Banner Sharing

[Hooker]

I'm trying to write a banner sharing script that works on a PHPBB forum, i don't have access to the actual forum source so it needs to totaly be external.

 

Right now i have it so people get code similar to this:

[url="www.mysite.com/refer.php?usr=1234"][img=www.mysite.com/banner.php?usr=1234][url]

And i'm trying to track the click throughs, ie. how many clicks a particular banner has and who from so at the moment i'm doing this - In the image generation (banner.php searches a db table for a random image and shows it) it grabs the user id and assigns the image its showing to the user (in "ActiveBanner") so the table looks like this:

UID | Name | Points | ActiveBanner

Then when someone clicks through it adds 1 point to the user and removes 1 point from the user that the banner is coming from before redirecting the clicker to the right page.

 

I just wonderd if there was any better way to track the click throughs or if anyone can suggest any improvements.

 

Thanks in advance