[ic] Ads extenstion first version done
mike at perusion.com
Thu Jul 22 00:44:38 EDT 2004
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.
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.
More information about the interchange-users