PAH---Post Ad Hack

The Post admin hack is for those who need money for bandwith, or those who just don't mind advertising thought their site.

This hack adds posts randomly after someone replys. The posts are shown to the usergroups that are enabled to view them, in the forums that are set to show them.

This hack uses a bit of the organization of the tom bot hack, cause that is what inspried this idea, however the bot was totaly removed, and was replaced with a random ad genertor. The postbit used also was changed to make it dispaly clearly as an add rather than a post, however you can clone the postbit template to make it match.

If you use this hack, please leave the gama banner in the rotation. Its not required to use this hack, id just appriciate it since i did not create this hack for my use, but solely for anyone who would want to.

Also id like to see this in use on some of your sites so i know how i can improve it as well as other people see examples so if you post a url to your board with it installed, ill put a link in the first post.

ScreenShot:
Post Screen

File:
version 1.01

Updates:
From 1.0 to 1.01

Sites Using it:
waiting for urls to be submitted

[Dribbles]

Nice hack ... does this rotate the ads in any way or are they the one set banner once the ad is posted? thnx

[Dribbles]

oops, maybe I was vague ... I mean once a banner is posted, if someone presses refresh, will he always see the same banner or will it rotate per view?

PS - I added 3 banners to test out the rotation ... tried to delete them from the admin cp and it won't delete it. I see in the instructions it gives a way to delete all ads through phpmyadmin ... but I'd like to keep a couple of my current ones. Are there any easier ways to delete individual ads? Also, once an ad is deleted, will it still show up in the ads that are already posted? thnx

PPS - When I try to edit an ad:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE adholder SET name=Your Ad Here,script=<a href=\"http://www.yoursite.com\" target=\"_blank\"><img src=\"http://www.yoursite.net/images/ilads.gif\" border=0></a> WHERE id=2
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ad Here,script=<a href=\"http://www.yoursite.com\" target=\"_bl

mysql error number: 1064

Date: Sunday 25th of May 2003 11:15:13 PM

[zajako]

gah, ill look into that error dribbles

Also the adbot posts should not be showing, i will look into this when i get on my comp...

also dribbles when i fix these errors the posts will not change banners, it will be like a post with a banner in it with the special postbit.

[Dribbles]

very nice .. thnx a million man.

[David Bott]

Any word on this hack about the above issues? Thank you kindly, looks like something we just may use.

[Mntsnow]

I too wouild be interested in this one

[Zachery]

ill have zajako look into this when he gets back online

[zajako]

sorry guys i have been really really busy working on some of my softwares when im online. I have a new full time job doing concrete and am gone most of my days so when i am home i gotta get stuff that helps pay the bills done first.

If this gets fixed it would be nice, hence my forum would be perfect for the use of this hack.

[Okiewan]

PLEASE!!! PRETTY PLEASE!!!
Can you port this to RC3? Did I say Please?