Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Banner Rotation, AdvertPro, and Links SQL

Quote Reply
Re: Banner Rotation, AdvertPro, and Links SQL In reply to
In Reply To:
Perhaps delegating the expiring of campaigns and ads to a cron job or as a daemon running in the background would solve many of the problems.
I would recommend adding a field called Active (Like what Monster.com does with its job and resume postings), then it would allow advertisers to expire or re-active advertisement campaigns. I am doing this with upgrading my Resume Postings (with the current version using DBMAN, I have the employers choose a number of days to run the ad and with resumes the default deletion period is 120 days, and then I run a script via Cron that checks the records by date added and remove date) feature I am working on. In the new upgraded feature, prospective employees and employers can activate or de-activate (expire) their resumes. I have learned a lot from my users who have complained that when their jobs/resumes are deleted, they have to re-enter their data. The employers re-open positions all the time and prospective employees like the flexibility of activating/de-activating since they do not have to spend more time re-enter data.

The main reason that I recommend an Active (ENUM ('Y','N')) field is that outright automatically deleting advertisements will raise frustrations of advertisers who would have to re-enter their information to re-active advertisment campaigns.

Another suggestion is tying the advertisement system with the Links table. I have done this for my banner exchange (although I am still working on the view bugs) that only Link Owners can add one banner per link they add and they cannot add a banner without first selecting a link they've added. When they select a link, then they are redirected to the Banner form where some of the fields, including Title are already filled in with the value from the associated record in the Links table. I have added a field for the LinkID that pulls the URL from the Links table, rather than re-printing the URL in the Banner table.

Regards,

Eliot Lee
Subject Author Views Date
Thread Banner Rotation, AdvertPro, and Links SQL pugdog 5475 Oct 26, 2000, 2:20 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5372 Oct 27, 2000, 5:08 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5365 Oct 27, 2000, 11:34 AM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5372 Oct 27, 2000, 6:55 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5359 Oct 27, 2000, 9:33 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5350 Oct 27, 2000, 10:07 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5351 Oct 27, 2000, 10:12 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
Stealth 5352 Oct 27, 2000, 10:22 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5361 Oct 27, 2000, 11:59 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
qango 5362 Oct 28, 2000, 6:59 AM
Post Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5275 Nov 1, 2000, 3:42 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5280 Nov 1, 2000, 4:29 PM
Thread Re: Banner Rotation, AdvertPro, and Links SQL
pugdog 5278 Nov 1, 2000, 9:57 PM
Post Re: Banner Rotation, AdvertPro, and Links SQL
Michael_Bray 5262 Nov 1, 2000, 10:50 PM