[eluser]skunkbad[/eluser]
[quote author="Johan André" date="1249959267"]
By the way, if your host only lets you have 10 connections you should switch.
Good luck![/quote]
Hi Johan,
Thanks for your response. I was wrong. I checked and it is 30 MySQL connections. I don't know if that is much better, or how many other hosts allow, but I'm sure it is sufficient for my immediate needs.
So... when people click on your ads, you are obviously redirecting them, or you wouldn't be able to track clicks and other data, correct? Most of the ads that I currently use are from Commission Junction, and also from Google Adsense. They do provide their own click counts, but I always wonder if they are correct or not. With CJ, some advertisers do or do not allow redirects, so this could limit if an ad could be tracked.
Having ads on a site is an interesting task. I always try to think about a customer's needs. If it is just me I can edit the code, but a customer needs a GUI/user console of some sort. How do you handle this?
So far I have this sql:
Code:
-- Ad Management
CREATE TABLE `ads` (
`ad_id` int(10) unsigned NOT NULL,
`user_id` varchar(12) NOT NULL,
`clicks` int(10) NULL,
`ad_url` varchar(255) NULL,
`ad_image` varchar(255) NULL,
`ad_html` varchar(255) NULL,
`start_date` int(10) NOT NULL,
`end_date` int(10) NOT NULL,
`ad_class` char(1) NOT NULL,
`ad_rating` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`ad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `ad_classes` (
`ad_class` char(1) NOT NULL,
`width` smallint(4) unsigned NOT NULL,
`height` smallint(4) unsigned NOT NULL,
PRIMARY KEY (`ad_class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;