Free Automatic Template Split Tester + Page Generator

Status
Not open for further replies.


This worked for me after the original code didn't...

Code: 
[SIZE=2]
CREATE TABLE `slimstat_dt` (
`dt_start` int(10) unsigned NOT NULL default '0',
`dt_end` int(10) unsigned NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`visits` int(10) unsigned NOT NULL default '0',
`uniques` int(10) unsigned NOT NULL default '0'

)
[/SIZE]

Code: 
[SIZE=2]
CREATE TABLE `slimstat` (
`id` int(11) unsigned NOT NULL auto_increment,
`remote_ip` varchar(15) NOT NULL default '',
`remote_addr` varchar(255) NOT NULL default '',
`country` varchar(50) NOT NULL default '',
`language` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`template` varchar(255) NOT NULL,
`referer` varchar(255) NOT NULL default '',
`searchterms` varchar(255) NOT NULL default '',
`resource` varchar(255) NOT NULL default '',
`user_agent` varchar(255) NOT NULL default '',
`platform` varchar(50) NOT NULL default '',
`browser` varchar(50) NOT NULL default '',
`version` varchar(15) NOT NULL default '',
`visit` int(10) unsigned NOT NULL default '0',
`dt` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY `referer_idx` (`referer`),
KEY `user_agent_idx` (`user_agent`),
KEY `version_idx` (`version`),
KEY `remote_ip_remote_addr_idx` (`remote_ip`,`remote_addr`),
KEY `resource_total_uniques_idx` (`resource`,`id`,`visit`,`remote_ip`),
KEY `searchterms_total_uniques_idx` (`searchterms`,`id`,`visit`,`remote_ip`),
KEY `domain_total_uniques_idx` (`domain`,`id`,`visit`,`remote_ip`),
KEY `platform_total_uniques_idx` (`platform`,`id`,`visit`,`remote_ip`),
KEY `browser_version_total_uniques_idx` (`browser`,`version`,`id`,`visit`,`remote_ip`),
KEY `country_total_uniques_idx` (`country`,`id`,`visit`,`remote_ip`),
KEY `language_total_uniques_idx` (`language`,`id`,`visit`,`remote_ip`),
KEY `dt_total_uniques_idx` (`dt`,`id`,`visit`,`remote_ip`),
KEY `visit_total_uniques_idx` (`visit`,`id`,`remote_ip`) )
[/SIZE]

Code: 
[SIZE=2]
CREATE TABLE `ad_clicks` (
`id` int(20) NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
`from` varchar(255) NOT NULL,
`unit` varchar(20) NOT NULL,
`browser` varchar(255) NOT NULL,
`adunitsize` varchar(100) NOT NULL,
`template` varchar(255) NOT NULL,
`adtype` varchar(255) NOT NULL,
`time` timestamp NOT NULL,
PRIMARY KEY (`id`),
KEY `from` (`from`) )
[/SIZE]

Run those SQl commands, they should work!
 
Hey lerchmo,

Thx for the amazing script. Everything works perfect except for adsense. No matter which pages I create adsense will use the domain name to target the ads and they remain the same no matter which keywords I use to create the page with. Any quick fix for this?
 
Hmmm. This may be a dumb question but is there anyway to check to see if everything is working?

Or a checklist I can go through?
 
Also, maybe I'm missing something but can I change the adsense channels per page?
 
lerchmo said:
havent added that.. it shouldnt be that hard to do though..
Click to expand...


Is it possible to have a mod-rewrite that can do the following:

User types: fart.com/ fart-alot/ fart_alot.php

meanwhile it goes to the virtual directory we have created. I notice relevant ads appear instantly when using the filename in the url. Ive been trying to use mod-rewite to change it but cant get it quite right.

FIGURED IT OUT:

change the last RewriteRule rule to:

RewriteRule ^(.*)/(.*).php site.php?site=$1 [QSA,L]

Even though the $2 variable is thrown out you can see the difference in the ad relevance when sending the browser the filename.

In generate.php the echo at the bottom can be changed to:
echo "<a href='$url/$name/$name.php'>$name</a>";
 
Great script, but for some reason it works only with 2 templates for me. There's no error message of any kind and it will work perfectly with 2 templates but not ever load template3.php. I even copied the html from template1.php which works into template3.php but it still doesn't work for more than 2. Any ideas?
Thanks
 
You need to edit the code where it says template1,template2 and add a third in the rotation. Need to know a little php to get this done. Remove the bot.php and cookie.txt file as well.
 
I get the scrapping stuff and making auto-gen websites but isn't it just FULL of duplicate content?

and the only way i see it ranking for anything is if you put it on a site that's already got trust unless you intend on having no organic traffic at all. imho.
 
Ummmm yeah, ppc arbitrage isnt really about organically ranking......

Anyway, how the fuck did I miss this, im going to have to find the time to give it a run...

Thanks Lerch!!
 
Your scripts kick ass lerchmo!

I just had one question:

Is there anyway I could just return a 404 error if someone tries to load a page that I haven't put into the MySQL/Generated yet?

Everything else I seem to have mostly customized now though
 
kensav said:
I get the scrapping stuff and making auto-gen websites but isn't it just FULL of duplicate content?

and the only way i see it ranking for anything is if you put it on a site that's already got trust unless you intend on having no organic traffic at all. imho.
Click to expand...
very insightful
 
lerchmo said:
very insightful
Click to expand...

Am I detecting some sarcasm here? I only pointed it out cause some n00bs might download that and think they can throw it up for some website and think they'll do well. :eek:

Im actually installing it and seeing how it works now.
 
andyem said:
You need to edit the code where it says template1,template2 and add a third in the rotation. Need to know a little php to get this done. Remove the bot.php and cookie.txt file as well.
Click to expand...

can someone explain this part? just remove them instead of fix them to handle multiple templates? when you say edit code to put in 3rd template, do we need to fix the split code to do like 3 way compares?
 
i get this errors on the top of my generated page...anybody any suggestions ?
Really could use some help

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/learnmag/public_html/best-info/rotator/slimstat/rotator_stats.php on line 75

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/learnmag/public_html/best-info/rotator/slimstat/rotator_stats.php on line 89
 
Status
Not open for further replies.
Top Bottom