My little mod to this hack just allows rotation. KarateKid is the true master behind this hack though.

i put it on forumhome, forumdisplay, and viewthread. i did the whole banner hack, then the rotation hack...still nothing.

hm, I'll have a look on your rotation addon, maybe then I can help you in your problem

regards.

Hmmm, yes this hack would be absolutely excellent if it had the ability to rotate the ads on a timed basis, or even a refresh for that matter. :)

yes I can imagine, but that was not my intention. What I want is a hack which counts views and clicks and thats what this hack does currently. :)

Anyway to get this to support FLASH banners?

All my banners are .swf, but Id like to use your tracking system.

Thanks,
/DJ

hm, in this case you have to modify my hack a little bit, so that it doesn't place the <img> Tag but the right tag for your flash banners. Just have a look on my code.

If it doesn't work you could format your flash to gif, or? :)

Best Regards.

Which code are you referring to, exactly?

Thanks for the help,
/DJ

hm,

you have to change many things, at first the tags you place in forumhome, because they aren't <img> tags anymore.

Hello,

I followed the installationinstructions.txt file to the T and when I attempted to create the mysql tables, this is the error message I received.

SQL-query : [Edit]

CREATE TABLE banner (
id int(11) NOT NULL auto_increment,
url_to_banner varchar(255) NOT NULL default \'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NOT NULL default \'0\',
width int(11) NOT NULL default \'0\',
banner_text varchar(255) NOT NULL default \'0\',
guestclicks int(11) NOT NULL default \'0\',
userclicks int(11) NOT NULL default \'0\',
views int(11) NOT NULL default \'0\',
reportuserid int(11) NOT NULL default \'0\',
PRIMARY KEY (id)
) TYPE=MyISAM;

MySQL said:

You have an error in your SQL syntax near '\'\',
redirector_url varchar(255) NOT NULL default \'\',
height int(11) NO' at line 3

I also attempted to create the second table and this is what I got.....

CREATE TABLE userclicks (
userid int(11) NOT NULL default '0',
bannerid int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
PRIMARY KEY (userid,bannerid)
) TYPE=MyISAM;

I'm just copying and pasting them over. I tried several times, so I'm sure I'm not typing anything incorrectly. Can someone give me any ideas what could be wrong here?

Thanks!
-Gabriel