[ic] Ads extenstion first version done

[Mike Heins]

Quoting Scott Andreas (joscan at comcast.net):
> On Tue, 2004-07-20 at 10:28, Mike Heins wrote:
> > As requested and funded by some of our kind Interchange users, I have
> > put up the ad serving extension to Interchange.
> > 
> >    http://www.perusion.com/contrib/ads-0.01.tar.gz
> > 
> > There is an INSTALL document and rudimentary documentation in README.
> > I have tested it fully on MySQL. It does not yet work on Postgres because
> > it relies on AUTO_INCREMENT fields -- this can be addressed if extra
> > time is found.
> > 
> > If you said you would contribute a half-hour, you are asked to follow this
> > link to pay by credit card:
> > 
> >     https://www.perusion.com/c/public/ord/checkout?mv_action=refresh&mv_order_item=misc-0001&mv_order_quantity=75
> > 
> >        or
> > 
> >     http://tinyurl.com/64kx2
> > 
> > Click twice to pay for one hour (if anyone said they would contribute that).
> > 
> > The more payment, the more time I will have to add features like:
> > 
> > 	-- Ad start/expiration dates
> > 	-- Expire by number of exposures
> > 	-- Expire by number of clicks
> > 	-- etc.
> > 
> > I expect to put this extension in the distribution for 5.4.
> 
> Thanks mike my users will surely appreciate a system for ad
> tracking...IMOP it was well worth the price...I hope that all
> contributore will pony up to their obligations. Also although my SQL of
> choice is PostgreSQL I hope that their is functionality coming soon..
> 

Turns out it works fine with Postgres if you just make the id
field in the ads log tables default to the next value in the sequence:

Database    ads_log     COLUMN_DEF      "id=int default nextval('ads_seq'::text)"
Database    ads_summary COLUMN_DEF      "id=int default nextval('ads_summary_seq'::text)"

Add those lines to the appropriate dbconf/pgsql/ads_*.pgsql files and
away it goes.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Software axiom: Lack of speed kills.