Advert Management

[Scott MacVicar]

This is a script to allow you to manage the adverts on your forums, you can have any sort of advert you can imagine there is no actual limit with this hack to what it can be, javascript, flash, image, text and images.

You add adverts to a category or a forum or the whole board. If the category has child forums they will inherit the adverts as well as their own adverts if they have any.
Adverts can have a set exposure such as 10,000 views and once it has reached that it will stop.

It fills a variable called $advert which you just place in any template, such as the header, you can also use variables and replacements within the adverts, such as $bbuserinfo[userid] for the persons userid in a link within an advert.

Updated June 9th at 19:44 GMT

Added date limits and options for unlimited exposures.
To upgrade from an older version, reapply code in global.php, upload ads.php and run this sql query to alter the ads table you made.

ALTER TABLE `ads` ADD `time` INT(10) DEFAULT '0' NOT NULL;

ALTER TABLE `ads` ADD `wholeforum` SMALLINT(1) DEFAULT '0' NOT NULL;
If you already run that query though are still experiencing problems with the time always being January 1st run

ALTER TABLE `ads` CHANGE `time` `time` INT(10) DEFAULT '0' NOT NULL

New features include showing the advert on the entire forum by using a radio button, some highlighting in the admin panel, italic name indicates the time period has ended and a bold name means the advert has met its quota for exposures.

You must chance RAND() to RAND(NOW()) if you have mysql 3.23.52 or above

Scott

[Scott MacVicar]

And before someone asks for a screenshot.

[Neopiper]

this is awesome :) what about exposure that have no limits?

[RDX1]

oh god, he comes hack of the month ;)

[Kumaro]

whats an advert? and then explain again what this does?

[Scott MacVicar]

Em its an advert

http://www.dictionary.com/search?q=advertisement

[snyx]

^^^ ROFL!
anyways... great man I was looking for this hack last night actually, I will post when I get her installed.

cheers PPN.
-myles

[Parker Clack]

PPN:

Great hack. Have your figured out a way to make it count the number of times it has been clicked on like a link?

I added a maketableheader2 with a colspan of 4 in the adminfunctions.php file as the default is only a colspan of 2.

Parker

[Scott MacVicar]

Oh the maketable problem hold on you don't need another function you just need to adjust the variables passed into the function.

Adjusting ads.php just now.

[Scott MacVicar]

If you wanted it to count the number times a link had been clicked on you have to start creating a file in which to hold the link information and that means you have to start doing more work and you wouldn't really be able to use the adverts for other media like javascript.

Ill have a think about it though.

[Parker Clack]

PPN:

Ok, I will see what you do. Thanks.

I added another row so that the actual banner would show up too.

Below the last </tr> I added

echo "<tr>";
echo "<td colspan='4' align='center'>$ads[advert]</td>";
echo "</tr>";

and I added the ability to reset the count on the advert to zero if you wanted by adding

// ###################### Start Reset #######################
if ($action=="reset") {

doformheader("ads","zero");
makehiddencode("adid",$adid);
maketableheader("Confirm reset");
makedescription("Are you sure you want to reset this advert");
doformfooter("Yes","",2,"No");

}

// ###################### Start Kill #######################
if ($HTTP_POST_VARS['action']=="zero") {

$ad = $DB_site->query("SELECT name FROM ads WHERE adid='$adid'");
$DB_site->query("UPDATE ads SET exposed=0 WHERE adid='$adid'");
echo "<p>Advert $ad[name] has been reset</p>";
$action="list";

}

and just link to reset.

Thanks again for a great hack. This is something that I thought should have been included with vBulletin from the start.

Parker

[scsa20]

Originally posted by PPN
Em its an advert

http://www.dictionary.com/search?q=advertisement

lol, dictionary.com, the only place where I go to for defantions :D

[Scott MacVicar]

Yep but that can cause problems showing the ad if it has alot of ads or if its javascript with \ in it as it would be stripped and could cause problems.
The reset thing i'll add to the release then.

[Scott MacVicar]

Uploads ads.php from the zip again to get the reset feature working on your board, you can use this to reset your ad hits to start exposures at 0 again.

[Velocd]

advert eh? you're the first person I have met abbreviate advertisements into advert, instead of plainly referring to it as an ad.

nonetheless, excellent hack :D

[Sparkz]

If that is the case, you need to get out more, Velocd :P

I think advert occurs pretty commonly...

[duke]

This is a great

sugestion
1. what if you want to have two different rotatons one at top and obe at bottom you would need to variable's is that a posability to add.

2. there should be a way to set the banner to unlimited exposers

3. rotate the ad in all or one forum to beable to choose two or three forums right now it is a little limited to all of one catagory or one forum

[Neo]

Would you post a pic of what it looks like from the users end?

[Parker Clack]

neo:

The upper right hand banner is what the enduser will see.

[Floris]

It works very nice :) I expected to find instructions for many files, but this was very quick and easy. Great hack!

One little tweak me and my users want, is to exclude the showthread and postreply pages. Or at least an option for the admin to also show on those pages, or not.

Another little tweak is the option to show certain banners for unlimited time.

[Jeremy W.]

So, does this do rotations if there are more then one ad for a certain forum?

[Parker Clack]

Jeremy:

Yes as long as you have them in the same forum they will show up together. You chose the forum(s) that you want the banner(s) to show up in. So you can have multiple banners for a single forum.

PPN:

I did notice though if you have more than one banner for a forum though it will create multiple of the banners. Say I put in banner1 and banner2 to show up in forum1. When I go back to the admin for the banners I will see three banner1s show up and 1 banner2. Now if I go back and delete the extra banner1s they will not show up again but when you first add them they are often times multiples.

Parker

[Scott MacVicar]

Will test it now, this shouldn't really happen as there is only one query. Does it appear 3 times when you add banner1 or does it only appear 3 times when you after you add banner2?

xiphoid: to exclude pages you have to start doing more checking, what files are you wanting to exclude? Tell me and i'll try and get the code done to do it.

[Floris]

showthread.php (maybe) We are still discussing this

but at least:
newthread.php
newreply.php
editpost.php
report.php
postings.php

[Scott MacVicar]

Not many files then ;)

You'll need to add this code below

eval("\$advert = trim(\"".str_replace("\'", "'", addslashes($advert['advert']))."\");");

if (substr($PHP_SELF,-strlen('newthread.php'))=='newthread.php' or substr($PHP_SELF,-strlen('newreply.php'))=='newreply.php' or substr($PHP_SELF,-strlen('editpost.php'))=='editpost.php' or substr($PHP_SELF,-strlen('report.php'))=='report.php' or substr($PHP_SELF,-strlen('postings.php'))=='postings.php') {
$advert='';
}

[Floris]

You the man :)
(and firefly ofcourse)

I will tweak it now :) (global.php I assume)

[update]
Yep, global.php and it works perfectly !!

[Sparkz]

I am pretty sure I am a man too.
/me checks between his legs...

Yup, definitely a man...

[Parker Clack]

PPN:

It happens after I add the second banner. The first one will get tripled.

I also noticed that the move function doesn't work with having the $advert array in global.php. Somehow it messes with postings.php and the move function thinks that you are trying to move it back to the same forumid. If I put the code in forumdisplay.php and showthread.php it works as I want it.

Would putting the check that you have written above resolve the issue with postings.php?

Thanks,
Parker

[Henry-RS]

Ok, I installed this without a problem, but there doesn't seem to be a feature that rotates the banners if you add two different ones to one specific forum, using the one "$advert" variable.

How can I make them rotate, by picking random banners that were assigned to that area?

[Parker Clack]

Henry:

If you put more than one banner for a forum the script will randomly pick the banner to display out of the ones that you have assigned to that forum area. From what I have experienced they are about one a one to one footing. Your mileage may vary.

Parker

[inetd]

Originally posted by duke
This is a great

sugestion
1. what if you want to have two different rotatons one at top and obe at bottom you would need to variable's is that a posability to add.

2. there should be a way to set the banner to unlimited exposers

3. rotate the ad in all or one forum to beable to choose two or three forums right now it is a little limited to all of one catagory or one forum Good suggestion!
And one od the best hack of course :) :) :D
PPN, please realize this suggestion. I need this too . ;)

[inetd]

Please add shows ad by time.
Example: 2 days
After 2 days ad not show.

Thanks for this!

[Kumaro]

oh, okay...great. looks like an excellent hack.

[Scott MacVicar]

Bah thats my bad, i set $forumid in the global code, i'll change that until then em thats broken :D

WIll update it in a bit.

Will do some of the suggestions, To pick multiple forums might cause a problem cause the query will be more complicated but i should be able to find something.

[Floris]

WIll update it in a bit.

It has been a bit,
and I just upgraded to 2.2.6 RC,
and re-installed your hack -redownloaded it too-

Works like I want to.

[Scott MacVicar]

Ive updated it now, sorted the forumid problem. Added unlimited exposures and the time limit.

The next problem is multiple banners and I've decided that allowing it for multiple forums would prove too dificult after some testing was done but I'll consult some people just to be sure.

[inetd]

I very waiting new version :)
PPN, good work :)
I will install new version after release :)

[Parker Clack]

PPN:

Looking good. I have it installed and is working just fine on my board. Your new coding resolved the issue with the move/copy/move thread with redirect issue I was having.

Thanks again,

Parker

[Parker Clack]

PPN:

I am not sure if this is a bug or not or just something not working right on my board but when I installed it before midnight the time limit function correctly identified the server date and worked great. Then I noticed that the banners stopped showing up after midnight and when I went to edit the file the stop date was listed as January 1 2001. If I reset this to today's date it would revert back to the January 1 2001.

Parker

[Scott MacVicar]

Getting it to 2001 is a good trick since there isn't any in the code ;)

You'll need to update all old ads with a time period, setting it today wont work as its based on 12am that day, so by the time you add it, its already happened.

[Stealthy]

PPN, excuse my naivety but this is the first time for me doing banners.

Question: When filling in the section 'Code to be shown as advert', what exactly does this mean? Could you show an example of one please?

Also, do I have to have the banners on my server? I would like to link the banners to the advertisers' servers. How can this be accomplished?

Thanks for your help and great hack!

[active]

help need please this is just the hack i need to can not seem to install it any one help me out please

[Scott MacVicar]

Stealthy, for the Code to be shown you can put in whatever you like and it will replace $advert in any of your code, it can be images, text or javascript. Its up to you it doesn't matter what you have.

I have
<a href="http://www.site.com"><img src="http://www.site.com/banners.gif" alt="Website" /></a>


active, do what the instructions say in the text file within the zip. Make the code changes and then upload ads.php then run the sql query at the top to create the table.

[Parker Clack]

PPN:

Sorry. I meant January 1, 2002. If I delete the ad and reenter it at say 2200 then at 0001 it gets reset back to January 1, 2002.

Sorry if I wasn't clear before.

Parker

[active]

sorry to be a pain but were do i run the sql?

[Stealthy]

Thanks PPN, I will give it a try.

Also, I am getting the same problem as Parker. When I save the advert, I save it as 30 June 2002 but when I go back in to modify, it is set to 1 January 2002. Maybe this is why I cannot get the banner to show up as it is expired??

[Scott MacVicar]

What version of php are you running Parker? Its now 01:21 and its running fine on my local board which is php 4.2.1. Also what mysql version are you running?

[Floris]

I had a problem, you meantioned to upgrade, I did, and problem disappeared, I could move threads again. But now I can't use this hack. The adverts won't show up.

[Floris]

Ah, I see now.
It does say 2002 in my hear, but resets the dates to jan 1st, 2002. If i change them, then goto 'edit' it still says '1 jan 2002'. So that is why they wont' show up.

[Scott MacVicar]

Ok i obviously have a date problem I cant find on linux i'll play with it tonight after work.

[Floris]

Take your time, it is really appriciated. I wish I was as smart as you guys, and do it myself :) I already looked. But ofcourse..

[Neopiper]

heheh for some reason i cant get the ads to view after upgrade, i reinstall the hack becoz of the problem moving thread , now move thread works but the banner didnt show at all

[Scott MacVicar]

change this wee bit in global.php

if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}

to

if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}

This will disable the time length function until i get it sorted.

[Neopiper]

thanks PPN :)

[Stealthy]

PPN, I did the edit and it still resets to 1 January 2002. I still cannot see the banners. Have you figured out what the problem could be?

[inetd]

PPN, when you release new version? :)

[Scott MacVicar]

Im having major problems working out what it is, its actually quite puzzling.

Stealthy if you update the code in global.php then time isn't taken into account. Have you set correct zones in the admin panel and the banner isn't all exposed. It can be 0 or a value.

[Stealthy]

PPN, I have tried "0", left it blank, and I have tried other values and still the same thing.

Does it matter where you place the $advert value? I have tried various places within my "header" template and it will not show up anywhere.

[dxb]

thanks alot for this hack PPN and I have one Q .... will this work with vb224 or I have to upgrade to 226 to get it running :)

[Parker Clack]

PPN:

Sorry. I've been working the "day" job. I am running PHP Version v4.1.2 and MySQL Version v3.23.43 on a Linux box.

What is really weird about all of this is that the date showed up correctly when I first created the banner. So it would have in the date line today's date and all would be fine. Then after 0001 came around on the next day the date would get reset to January 1st, 2002. If I deleted the banner and reinstalled it the date would still default to the January 1st, 2002 date. Now if I got out of the admin panel completely then reinstalled the banner the date would be fine until the next date came up and again the $advert would be wrong and the banners don't get displayed.

I know you are working on this and I see no reason why it isn't working either and getting reset instead of staying. I just commented out those lines of code referring to the date and all works as it should.

I am glad to see that others are having issues with this too instead of it being just me screwing something up again. :)

Parker

[GeorgeofCS]

great hack :) One question though is there a way to get it so that ads that are selected as any forum will run on pages like forum home, etc? It only appears to run on my site in the forums themselves and I'd like to make it so it would run pretty much throughout the site. :classic:

[active]

please help this looks like just the hack i need for my site but i can not get it to work im new to vbullititon any help would be very gratefull

[Tech_Koss]

Originally posted by active
sorry to be a pain but were do i run the sql?
run that in your "phpmyadmin"

if you dont know what the link is ask your host

[Scott MacVicar]

OK i cant get the time thing to work, time to pester chen and see if he can find a solution to why it is not updating.
I presume Parker that you dropped the ads table and re created it or altered the table to add the time column.

[Parker Clack]

PPN:

I just took out the time check and that column from the ads table.
Works just fine that way.

Parker

[Slynderdale]

i get a parse error with the ads.php and when i add the code to global.php

Parse error: parse error in /home/public_html/forum/admin/ads.php on line 246

[Scott MacVicar]

Upload the file in ASCII

[Slynderdale]

i did, they still didnt work :(

[Slynderdale]

works now, got my self a new ftp client

[Slynderdale]

hmm, i found a bug, i set the advert to show for one year but it doesnt show

[Scott MacVicar]

Sorted the problem, the best idea is to download the hack again, drop the ads table and then re-upload the ads.php file to admin, reapply code in global.php and recreate table. There has been many changes recently to all code concerned with this hack.

[Floris]

Wow, you solved it! Great, I will try to re-apply the hack again soon!! w000 h00000

[Scott MacVicar]

If you need to know it was something real real real real simple, wasnt even any php coding.

I had made the time column a small integer which isn't enough to accomodate a timestamp as its 10 characters long. But i added some more features any way.

[Floris]

Uninstalled the hack, then installed the latest .zip from the first post, and it seems to work just fine!


Oh,
what if I now want to exclude files? can I still apply that little code you provided or will that not work properly with this new version?

https://vborg.vbsupport.ru/showthread.php?postid=254950#post254950

[Scott MacVicar]

Yeah it'll still work, Im going to look into a way of adding an advert to seperate forums.

[Floris]

A nice challange maybe (or maybe I am trying to hard)

Showing banners on announcement pages. (or at least on all of them)

[Scott MacVicar]

Banners should be shown on announcement pages as they have a $forumid specified and this should invoke the code which loads banner code.

Presuming you have a banner set for the forum that your viewing the announcements for.

[Floris]

Ah great :)

Just added a few banners from MadOnion to my site and they look great in the footer :) Works perfectly, especially that little code to exclude some pages.

No, let's see how rich I will become !

[Stealthy]

Thanks PPN! Works great!

*installed*

[merit5]

Has there been a way figured out to have for instance.. 2 calls of the $advert tag and have it as two different banners or will it always call the same banner when calling multiple banners on the same page?

thanks for the update.. this hack is great..

[Scott MacVicar]

Will be looking into this as soon as I get back from vacation.

My rough idea is add a variable in the vBulletin options asking how many banners to load. $advert_1 and $advert_2 etc

[Slynderdale]

works great now, i made a couple changes though, greak hack

[Slynderdale]

made more changes :)

[Slynderdale]

heres the modify list screenshot

[X-Fan]

Is there any way to adapt this hack for button ads and icon ads?

[Andy R]

OK, I have run the MySQL command via PHPMyAdmin. In order to run the comman, I had to remove the apostrophy marks (').

Here is the result I got:Your SQL-query has been executed successfully

SQL-query :
CREATE TABLE ads (
adid smallint(5) NOT NULL auto_increment,
name varchar(25) NOT NULL default '',
forumid smallint(5) NOT NULL default 0,
wholeforum smallint(1) NOT NULL default 0,
exposed smallint(10) NOT NULL default 0,
exposures smallint(10) NOT NULL default 0,
time int(10) NOT NULL default 0,
advert text NOT NULL,
KEY adid (adid)
)


I have edited the /forums/admin/index.php file and all the admin features seem to be working. I can create ads and modify them.

When I ad the code to global.php and upload the modified file, I get a MySQL error:Database error in vBulletin 2.2.6:

Invalid SQL: SELECT * FROM ads WHERE wholeforum='1' AND time>=1024693619 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()
mysql error: You have an error in your SQL syntax near 'RAND()' at line 1

mysql error number: 1064

Date: Friday 21st of June 2002 03:06:59 PM
Script: http://www.airstreamforums.com/forums/forums/index.php?s=
Referer: http://www.airstreamforums.com/forums/online.php?s=


I have reverted back to the original gloabl.php for now.

Any clues on what I might be doing wrong?

Thanks,

Andy

[inetd]

PPN, when you release new version? :)

[Scott MacVicar]

organic-hosting what version of MySQL are you running?

inted i had to modify the forums.php and set in there how many times to invoke the banner code.

Slynderdale Ive stolen your who it should be shown to idea and Ive got the code written for that.

[ladyfyre]

Hey PPN, just wanted to let you know, i found a bug.

i have mine set to unlimited exposures...but the exposure count for all adverts only went to 32767 for Houston, Austin, and Dallas, and will not go any higher....so the counter has a bug somewhere....

[Scott MacVicar]

Its not a bug its the limit of mysql smallint.
Ill icq you the fix.

[ladyfyre]

ok....cool

[inetd]

PPN, sorry. I'm inEtd, but not intEd :)
And i don't understand you :(

[Jeremy W.]

I'll be installing this hack later on this week, letcha know how it goes :)

[inetd]

PPN, when you released new version? :)

[X-Fan]

The coolest thing would be to combine this with vbPortal's banner admin system and KarateKid's recent vB Banner Control hack to make for an absolute banner management system for vB!

Is that at all possible?!

[X-Fan]

PPN, would it be possible to include tracking of click-thrus and the click-thru percentage for each banner, please?

[WoodiE]

Right now I have my buttons and main logo centered. How do I make it so my main logo is aligned to the left and a banner aligned to the right with the buttons centered if possible?

I have included my header. Any help would be great!!!

Thanks

WoodiE

[EchoHype.com]

Sweet hack man!

[veedee]

I've just installed adcycle. This hack is great but AdCycle is better :)

[WoodiE]

whats better about it? I think Advert Management is great.

Do you have a link for AdCycle?

-WoodiE

[EchoHype.com]

Hey woodie

try

www.adcycle.com


hehe

[ochw]

is there any way of have the banners change from one to another/

[Night Owl]

Originally posted by ladyfyre
Hey PPN, just wanted to let you know, i found a bug.

i have mine set to unlimited exposures...but the exposure count for all adverts only went to 32767 for Houston, Austin, and Dallas, and will not go any higher....so the counter has a bug somewhere....

I am having this problem too. Can you send me the fix? Just PM me to let me know how you would like to send the info, if you don't mind.

Thanks!

[SpeedStreet]

Anyone who uses phpadsnew....This hack works great out of the box, provided you use the header.

Awesome hack! Saved the day!

[Kevin104]

Hey PPN,

I love this hack, it works great.

I only have one question though. I want to use this to put banner ads on my non-vB pages. How would I be able to do that?

Thanks for the great hack!

[DannyITR]

Woks great !

I would also like ot know if it's possible to ad the banner to the threads in that particular forum as well. What do you guys think?

[Buddha]

Originally posted by Slynderdale
works great now, i made a couple changes though, greak hack

i like these additions (all of the ones you've listed in the three replies).
any way you can post the addons so that we can apply them as well.
thanks.

[WoodiE]

Is there anyway to make the banner open a new window after its been clicked on?

-WoodiE

[bouncer18]

in the a href url

add a

target="blank"

[Rand M]

Installed on v2.2.8, very smooth.....
Thank you.

[alkatraz]

Great hack! But I'll wait for a clickthrough tracking system to be added =)

[Tigga]

I seem to be having some of the same problems as other people. If I add more than one ad, it will only display the newest one I added. I also noticed the problem with ads being created multiple times. It seemed to only do this whenever I refreshed the page right after adding one though. I'm sure I have the new version because I had never downloaded it before and it has the option to set a date for the ad to expire. Any idea's on what I did wrong?

Thanks,
Brian

[DannyITR]

Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

[Okiewan]

Originally posted by DannyITR
Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

Ditto :(

[DannyITR]

Guys, you must help us lost souls.

[Julio]

I installed and ran the queries.... worked OK, but whenever I set an ad and try to view it in the board I get the following error:

Parse error: parse error, unexpected T_STRING in c:\MYPATH\global.php on line 237

Fatal error: Call to undefined function: getpermissions() in c:\MYPATH\index.php on line 10

Any help?

[DannyITR]

help!

[Julio]

Nevermind... fixed it.

1) Anyone knows the code I should use to have some flash, or videos show up?

2) Why when I add an ad, it doesn't show start date? It only shows end date. How can I do that?

[Okiewan]

Same problem here. It was working fine alternating between banners and all of a sudden it only displays the newest one. I've even re-installed the hack. Help!

Pretty Please?

[DrkFusion]

At last, I have found the best use for this.

Thanks PPN!
-Arunan

[grahamvonbaron]

I have the 2.2.8 version and I have been able to install some hacks myself, however I could use some help with this Adv manager hack.

Actually, I am open for somebody to be my go to guy for overseaing maintenance/upgrades and new hacks, I will pay a nominal fee or trade for your services. thanks,

graham@rcnow.com

[SpeedStreet]

Like everyone else, I am seeing an issue after a certain time of running this hack. However, I have uncovered something that I find VERY strange...

The only advertisement that loads on my page now is the most current one in the database...when I go into PHPmyAdmin, all the rows EXCEPT the most recent one return ok values. The most recent ID, when I try to browse its data, returns zero values and appears as if I was making a query versus a view.

Does ANYBODY know what could be causing this issue? How can we fix this? This is a great hack, and I hate to see it go by the wayside just cuz of a simple error....

[Julio]

Yes. I would even pay to get this hack working! :tired:

[SpeedStreet]

I just posted a general distress call, hoping other PHP gurus would come in here and help this hack out.

This is one of the best hacks period...to see it languish like this is sad :(

[Okiewan]

Pretty wild it's just getting dropped like this. Dissapointing.

[Scott MacVicar]

Most of my hacks have been re-written for vB3 and I have other things to do. Though I will definately try and debug this hack on a fresh install tonight.

/me adds this to his todo list.

[Okiewan]

Great! Thank you.

[Scott MacVicar]

ok i can't figure out why ORDER BY RAND() refuses to be working, its actually quite wierd and it appears to be the source of the problem.

[SpeedStreet]

PPN,

Thank you for picking this back up!!! We will all wait patiently for you to fix it :)

If you need a tester, I am here for you!

[Julio]

PPN: Same here as for test site. In fact I wrote that I would be willing to pay to fix this hack, since my board most probably be sponsored and I definately NEED to use this hack.

You have no idea how reconfortable is to know most of your hacks are being coded for VB3. This greatly increases the chances for me to update sooner, but it will pass a while until I do some tests, etc before upgrading. It needs to be seamless.

As always... keep the good work.

[SpeedStreet]

PPN,

I tried adding a limit, just HOPING that would work, and that still didn't seem to fix the problem.

i.e.
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND() LIMIT 50");

I'm still thinking that the issue lies within the info of the table. My last entry is always garbled only in that table, no others...

[SpeedStreet]

Any luck?

[waherne]

PPN,

I was reviewing this thread and also the code for the hack.

I'm not a programmer but would this be a solution?!!!!

I think that the problem relates to the mysql query and the 'order by rand()' instruction.

Would this solution work?

1. Query the database but exclude the order by rand() referred to above.
2. Count the no of rows in the query result/array. Result ='x'.
3. Use a php function to pick a random value 'y' between 0 and x-1.
4. Select row 'y' from the query result/array and use this to display the advert.

What do you think?

Or is there anyone else out there that has the coding skill to implement and test this?

This is a great hack and only needs the last push to make it a super one!

Keep up the good work.

Willie

[SpeedStreet]

If someone can write it, I will test it :)

[SpeedStreet]

Right about now is when I start crying....Did PPN wander off again? ;)

[Visionray]

good thing I read the last few pages of this thread and realized this hack isn't working. Maybe the first post should be updated with that info so people don't go instalilng it to only find out it doesn't work.

[SpeedStreet]

I tried ORDER BY RAND(GETDATE())

That crapped out my system.

Then, I tried
RAND(datepart(ss,getdate())
Still nothing.

How about if generate a random number using PHP, convert it to an integer value (probably by
multiplying by 100 and lopping off the decimals) and use that as the
seed?

I don't know how to do this, but I clearly remember there being something on these forums about a vbrand() function.

[thakikka]

Hello,

nice hack! Sorry for my bad english, but I will try to explain the problem that occurs on my board..

I put the variable into the header template and it works on all pages, but if i go directly to a post, e.g. http://forum.ksgemeinde.de/showthread.php?postid=170230#post170230 the banner is not shown?

But if you go to the same thread directly, e.g. http://forum.ksgemeinde.de/showthread.php?threadid=19771 the banner is shown.

Do I have to insert anything anywhere to get it work in the header even if you directly go to the last post?

Thanks in advance,
thakikka

[quickstang22]

I'm posting another cry for the hack to be fixed. I really need a reliable ad system going. So far this one rocks but I need it to rotate banners.

[Scott MacVicar]

I'm going to have a go of re-writing this hack, maybe before christmas. Life is just a bit hectic at the moment.

The problem with this hack is basically the sql query that fetches the adverts, it doesn't seem to randomise it.

[SpeedStreet]

Would any of my proposed fixes work for this, PPN?

[waherne]

PPN,

I modified your hack and have now got it to randomise the adverts successfully. As I said before, I am not a programmer, so my code is probably inefficient in performing the task - when I post the code here, you and others can hopefully assist in that respect.

The only thing with my modification is that I have disabled the 'show on whole board' functionality. Basically, I didn't need it for my purpose.

I'm at work now and don't have access to my laptop. I will post my code to this thread over the next few days.

Once again, thanks for the hack.

Willie

[thakikka]

I guess I found the error I reported some posts before (banners not shown on directly linked posts).

If the script finds something like "&threadid=19938" then the banner gets displayed.

But if you directly link to a post, it contains "?postid=172199" and the banner does not get displayed.

Can someone fix this so banners get displayed on every page?

Thanks in advance,
Sebastian

[thewolf]

Hi PPN,

any news on the new version of this hack?

Also, will it work with the latest stable version of Vbulletin (2.2.9)?

Keep up the good work!

Thanks,
Marco.

[waherne]

Further to my post above, here are the changes I made to PPN's hack to make it randomise. As I said, let us all work together to make my code more efficient.

Willie

////////////////////START//////////////////////////
In global.php, FIND:

if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND

time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE wholeforum='1' AND time>=".time()." AND (exposed<=exposures OR

exposures=0) ORDER BY RAND()");
}

AND REPLACE IT WITH:

$DB_site;

$sql="SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()";

$advert1 = mysql_query($sql);
$advert2 = mysql_query($sql);

$adcounter=0;
while($countrow = mysql_fetch_row($advert1))
{
$adcounter++;
}
$act1=rand(0,$adcounter-1);
$adcounter3=0;
while($countrow3 = mysql_fetch_row($advert2))
{
if($adcounter3==$act1)
{
$DB_site->query("UPDATE ads SET exposed=exposed+1 WHERE adid='$countrow3[0]'");
eval("\$advert = trim(\"".str_replace("\'", "'", addslashes($countrow3[7]))."\");");
}
$adcounter3++;
}

///////////////END///////////////////

I just noticed that there is another block of code that should also be included in the Find It and Replace above, essentially it's the code immediately following that set out above and beginning with $DB_site->query("UPDATE ads SET exposed - one query only.

[SpeedStreet]

Now, let me understand you correctly. This code works, but it eliminates the "Show on all forums" functionality?

[waherne]

Correct.

Adverts on child forums will be pooled together with adverts on their parent forums (and their parents...) as before. One advert will then be picked from the pool. Therefore, insertion of an advert at the ultimate parent level could be one way of displaying it on the entire forum.

Test my code and see if it suits your needs.

Willie

[quickstang22]

Willie

I tried your fix but lost all my ads. Not one is showing up. I made sure they were not selected for show all fourms. Just had them in child forums

Matt

[themonarch]

Originally posted by Visionray
good thing I read the last few pages of this thread and realized this hack isn't working. Maybe the first post should be updated with that info so people don't go instalilng it to only find out it doesn't work.

mmm, good point VisionRay. I installed this hack and then when it didn't work, I came back in here to read the whole thread and found out it's not working right yet.

[ChurchMedia]

When I run this query:

CREATE TABLE `ads` (
`adid` smallint(5) NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`forumid` smallint(5) NOT NULL default '0',
`wholeforum` smallint(1) NOT NULL default '0',
`exposed` smallint(10) NOT NULL default '0',
`exposures` smallint(10) NOT NULL default '0',
`time` int(10) NOT NULL default '0',
`advert` text NOT NULL,
KEY `adid` (`adid`)
);

I get this error:

MySQL said:

You have an error in your SQL syntax near '\'\',
`forumid` smallint(5) NOT NULL default \'0\',
`wholeforum` smallint(' at line 3

Any ideas?

[SpeedStreet]

Where's PPN?

That code did not work for me waherne...

[SpeedStreet]

well then...

[Scott MacVicar]

change

RAND() in global.php to RAND(NOW())

I just found out that the format had changed on newer versions of MySQL.

[SpeedStreet]

PPN,

While this may help the problem, I am still only getting one banner ad to pull out of three records consistently:


Banner 1 [edit] [reset] [remove] 0 0 Leaders Forum No
Banner 2 [edit] [reset] [remove] 48 0 All forums Yes
Banner 3 [edit] [reset] [remove] 0 0 Leaders Forum No


I did change both RAND() arguements to RAND(NOW()). There must be something else amiss. Also, I have tried switching it so that only one banner appears in the All Forums and the other appear in a subforum, but the All Forum one still overrides the other two, if you understand what I am saying.

Let me know if I can help in any way!


SYSTEM INFO
Operating System Linux
Apache Version 1.3.27 (Unix)
Perl Version 5.006001
PHP Version 4.2.3
Mysql Version 3.23.54

[waherne]

I have just installed VB 2.29 and this hack with the amendments I suggested earlier. The ads rotated correctly as I expected.

Willie

[SpeedStreet]

hrmm....I wonder why I am having problems then...

[Merjawy]

better late than never

I haven't a clue what ver. my php/sql but who cares? the hack works for me .. I don't have any ads but I can put different announcement or special greetings in different forums.. INSTALL

thnx

[Brain Crusher]

i want a hack plugin for this should like

only ads for guests :)

or only ads in a special category

[Doc203]

Works great for me also, and I changed Global.php, but it still doesn't appear to be random. Any ideas?

[DannyITR]

change

RAND() in global.php to RAND(NOW())


I'm confused now. Is the hack fixed? Is that all it was? What about the fix proposed by waherne? PPN can you update us?

[DannyITR]

I changed it but it still only displays the most recent ad. I have 2.26 but I'll upgrade to 2.30 and see what happens.

[DannyITR]

Nope, doesn't rotate the banners.

Help!

[DannyITR]

I just did the modification suggested by waherne and I lost all my ads.

Waherne, the last part is not clear. Can you edit the origional post and inlcude whatever code needs to be replace with the first batch. Mabye that is the problem although I'm sure I did it right.

We still don't have a hack that can randomly rotate banners in the same forum.

Help!

[DannyITR]

help

[SpeedStreet]

Try PMming PPN....he seems to answer those.

[DannyITR]

no reply to my PM yet

[DannyITR]

help

[GoTTi]

yup, im having same problem where it doesnt rotate the banners.

I did the RAND(NOW()) thing, still nothing.

[SpeedStreet]

Hrmm, this really sucks :(

[DannyITR]

PPN?

[DannyITR]

up

[DannyITR]

It can't be that hard. Mabye someone else can help? v

[Imprezer]

Bump!

I cannot seem to find a good banner management and this is the one I like but I cannot get it to rotate the banners.

Please help us!

[DannyITR]

I was thinking about using phpadsnew and putting a zone in the head. I think it would work but the problem is you'd have the same for all forums. I've sold a non-rotation banner in one of my forums but from now on I want a rotation for the whole forum.

[Drowned]

Damnit :( I love this hack... isn't anybody willing fo fix this great hack? :(

[SpeedStreet]

<sniff>

The problem is, PPN has shown time and again on these sites that he is a great coder. I think right now he has alot on his plate.

He has also been working pretty hard on VB3....hopefully sometime soon he will pop in and fix our problems :D

[DannyITR]

any news?

[The Realist]

In the admin controlpanel were it says Code to be shown as advert........ What does it mean and what code you you put in there?

Is it a direct link to a gif, HTML has it does not say.

Regards,

Brian

[trafix]

i hate to spam :( but if you are having problems have a look at my Arrow Ads (link in sig)

[Jacko]

Excellent hack, works a treat on my 2.3.0 board :bandit:

* Jacko clicks install *

[Anjie]

Not only works, but rotates with java script, and this hack ROCKS! Exactly what I've been looking for for sooooooo long!! THANK YOU!!!!

[Super Ted]

Has anyone worked out how to include 2 different banners on a page?

[noppid]

04-19-03 at 09:59 PM trafix said this in Post #179 (https://vborg.vbsupport.ru/showthread.php?postid=384430#post384430)
i hate to spam :( but if you are having problems have a look at my Arrow Ads (link in sig)

I've gone to your site more then once looking for your hacks. I'm lost everytime.

Can you please explain why they can't be posted here for better support and availability?

EDIT: NM, this one works great.

[Anjie]

To ad more than one ad to a forum, use this code in the "Code to be shown as advert" box. Works like a charm. :D

<SCRIPT LANGUAGE="JavaScript">
var how_many_ads = 3;
var now = new Date()
var sec = now.getSeconds()
var ad = sec % how_many_ads;
ad +=1;
if (ad==1) {
txt="Ad Name";
url="http://youradsite.com";
alt="Alt Message";
banner="http://www.yoursite/banner.jpg";
width="460";
height="80";
}
if (ad==2) {
txt="Ad Name";
url="http://youradsite.com";
alt="Alt Message";
banner="http://www.yoursite/banner.jpg";
width="468";
height="60";
}
if (ad==3) {
txt="Ad Name";
url="http://youradsite.com";
alt="Alt Message";
banner="http://www.yoursite/banner.jpg";
width="468";
height="60";
}
document.write('<center>');
document.write('<a href=\"' + url + '\" target=\"_new\">');
document.write('<img src=\"' + banner + '\" width=')
document.write(width + ' height=' + height + ' ');
document.write('alt=\"' + alt + '\" border=0><br>');
document.write('<small>' + txt + '</small></a>');
document.write('</center>');
</SCRIPT><br>


If you have more ads, just change the number variable in line 2., copy and paste a new section and rename the if statement to ad==4 and so on. This works like a charm for me, I've got in running different sets of banners on 60 some odd forums. :) This hack is a master stroke.

The only thing I'd like to do is get the subs to work independently of the parent forum, other than that this hack is the best! :)

[Sidewindr]

I am having a similar problem ..

I have set up 5 banners and it appears to be stuck on the 4th and 5th banners....

Odd. .

I found I had to have RAND() not RAND(NOW()) as the latter did not seem to work when I put the following query inth mysql cmd line interface..

SELECT * FROM ads ORDER BY RAND(NOW());

Yielded the ad list in the same order EVERY time

SELECT * FROM ads ORDER BY RAND();

Yielded the ad list in a different order every time.

[Sidewindr]

I fixed the problem .. it is wierd .. I had to run the database query twice!! So instead of this portion of code in global.php

mysql Ver 11.18 Distrib 3.23.53, for sun-solaris2.9 (sparc)
PHP 4.3.1 (cli) (built: Mar 25 2003 16:03:01)


if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE wholeforum='1' AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}


I had to use


if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE wholeforum='1' AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
$advert=$DB_site->query_first("SELECT * FROM ads WHERE wholeforum='1' AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}



Also just a quick note .. it does not work very well with only 2 adverts. If you only have 2 adverts make 3 copies of each and the randomization will work alot better.

[94supratt]

<center><a href="http://www.dtpracing.com" target="_blank"><img src="http://www.tidewaterracing.com/pics/dtpcard1.jpg"" width="289" height="125"></center>

I have that as an ad in the "Code to be shown as advert" and now when I try to quote someone in a post I am unable to highlight using the left button on the mouse. Any ideas why.

[Sidewindr]

There appears to be a problem with the following portion of code in global.php


if (isset($postid)) {
// viewing post
$postid=verifyid('post',$postid,0);
if ($postid!=0) {
$advert_forumid=$postid['forumid'];
}
}


$advert_forumid appears to be incorrect. If post id is say 92355 and the post is in thread 23352 in forum 24. advert_forumid is set to 9 ... this is wrong and it should be 24.

I got around it for the time being by changing it to the following.


if (isset($postid) and isset($threadid)) {
// viewing post
$thread=verifyid("thread",$threadid,0,1);
$advert_forumid=$thread['forumid'];
}


This works and the advert_forumid is set to 24 for the above example.

I don't think this fix is correct though, is there a scenaro where postid is set but threadid is not ?

[gmarik]

MySQL 4.0.13 should work with vBulletin 2.3?

[Sidewindr]

What's the hack for this hack to allow the exposure count to go over 32767 exposures ?

[Moreliator]

This may be asking alot, but is there any way you could make an addon that would allow the Admin to specify certain banners based on a user's location? For example, I have some adverts who I can only display for US traffic, and for International traffic I woudl want a different banner displayed.

Thanks.

[gldtn]

Anyone got this to work with vB2.3.0? I installed it but the options to configure it in admin, it does not appear.

[Anjie]

yeah worked great on ours. :) 2.3.0

[mfacer]

awesome hack!! Love it to bits!!

works perfectly on 2.3.2

:-)

see example: http://www.yu-gi-oh-online.co.uk/forum/showthread.php?s=&threadid=67

[Super Ted]

Has anyone got this hack to work on a non-vb page?

[Super Ted]

^^^Bump^^^ I am sure others would like to know too!

[MuSuL]

So after reading all 196 posts to this, I have not seen or maybe I have over looked that post that talked about fixing the problem of the ad banners not rotating...Mine are not!...The first on the list is the only one that shows...

So here is the question, is there a way to make the banners rotate and have then rotate from one to the other every so many seconds?

Or does the hack only let one banner show until you refreash the screen, which I have done and nothing has changed...I would love to be able to use this hack, but if it does not work, why use it?

[TheLab]

So after reading all 196 posts to this, I have not seen or maybe I have over looked that post that talked about fixing the problem of the ad banners not rotating...Mine are not!...The first on the list is the only one that shows...

So here is the question, is there a way to make the banners rotate and have then rotate from one to the other every so many seconds?

Or does the hack only let one banner show until you refreash the screen, which I have done and nothing has changed...I would love to be able to use this hack, but if it does not work, why use it?


Same here, the banners are only rotating when you refresh the screen.
Also one more thing. Can yoy make it in any way to record the clicks? Thats what the advertisers want...to know how many clicks their banner had.

Thanx in advance

[d3nnis]

Scott, anyway to use this ad management to show those advertisers whats the current page views or stats?

[d3nnis]

Also one more thing. Can yoy make it in any way to record the clicks? Thats what the advertisers want...to know how many clicks their banner had.

Thanx in advance


thats what i want... since the advertisers needs to be convince...

[liquidblaze]

this hack doesnt seem to work for me.. at least the images dont get displayed - i edited all files and upped ads.php but whenever i set something in the adverts panel it doesnt get displayed. the strange thing though is that the visits get counted ...

[MrNase]

are you sure you used "<img src="....">" ???! You should include ALL html code and not just the url to the image :)


btw: working for me! Very cool work! Thanks!

[liquidblaze]

well i dont think of myself as the UEBER php/sql pro but i know quite a lot about html ;)

im using a full <img> tag incl. alt and all surrounded by a link - it doesnt work with or without link nor with or without alt :)

[MrNase]

adjust the time (last setting when adding a new one or updating a new one...) standard is 29th january 2003 and that is wrong... change it to ... ... 2004 or whatever :)

[liquidblaze]

all done .. date is set and all works - the countdown (how many exposures are left) works too, it just doesnt show the image - neither via hotlinking nor via a local (on the server itself) file.

any more hints for people who are no total morons?

i mean.. setting it up was no prob - using it neither, i just dont see the images...

[madhouse]

Liquidblaze , just a question but did you add $advert to you header template?

[liquidblaze]

ah yes someone is looking like the absolute noob now... :) thx for your help

[Spyke1]

is it possible to use this to manage banners on a site (outside vbulletin)?

[Big J]

Hey PPN, just wanted to let you know, i found a bug.

i have mine set to unlimited exposures...but the exposure count for all adverts only went to 32767 for Houston, Austin, and Dallas, and will not go any higher....so the counter has a bug somewhere....

I'm having the same issue. Could comeone please PM me the fix!! Thanks!

[madhouse]

Read my post here :https://vborg.vbsupport.ru/showpost.php?p=436245&postcount=206

If u are having the same issue....

[PAINTBALLM]

i'd like to see the option to output a statistics page for your sponsors/advertisers to view, so they know that they arent getting done dirty.

[d3nnis]

Its not a bug its the limit of mysql smallint.
Ill icq you the fix.


hi Scott can you post here?

[d3nnis]

found the solution... i alter ad table , exposed field to bigint(10)

[TheLab]

found the solution... i alter ad table , exposed field to bigint(10)


What does this change? And whats the exact query you run?

[d3nnis]

What does this change? And whats the exact query you run?


i used phpmyadmin, under ads table, field -> exposed, click on action -> change

[TheLab]

And what did you earn by doing that?

Edit: Forget it.. i found out what this does.. :nervous:

[d3nnis]

some info about mysql numeric types..

http://www.mysql.com/doc/en/Numeric_types.html

smallint can only goes up to 32767

so by changing to bigint, I can expect it to goes up to 9223372036854775807!

[PAINTBALLM]

Scott, I installed this hack, and what I did was modified the variables and installed it again so I could have a different banner system for both the top and bottom of my site. I changed all of the advert variables for the footer system to advert2, and changed all the ads to ads2, then the variable I put in the footer is $advert2 instead of $advert... It works nice..

Accept, one problem is confusing me, as I am not a PHP expert, and you are :P I think you can help me..

First, go here, and look at the footer, notice it works.. http://www.paintballmessage.com/forums

Now go here, and look at the footer, notice.. its not working... http://www.paintballmessage.com/forums/forumdisplay.php?s=&forumid=8

It seems to work on every page accept two, those two being the showthread.php and the forumdisplay.php...

Could you tell me how to fix this?

Thanks scott ;)

Justin

[d3nnis]

some info about mysql numeric types..

http://www.mysql.com/doc/en/Numeric_types.html

smallint can only goes up to 32767

so by changing to bigint, I can expect it to goes up to 9223372036854775807!


by the way, exposure max limit will also be 32767 since the datatype value is smallint.

if you wish to go beyond 32767, you have to change it to bigint as well.

[PAINTBALLM]

^^^Bump^^^ I am sure others would like to know too!


Ted what you could do is make a php file in your forum directory, and have it call the global and functions files.... And then put $advert in that, in a table with 0 border and 0 cell padding spanning 100% x 100% centered.. Make it transparent on the non vb page, and it would work like a dream ;) thats what I do

[PAINTBALLM]

i hope scott is on vacation or something, beacuse hes not responding :(

[Super Ted]

I want to try and maximise my ad space or whatever free space is available on the forum pages or my non vb homepage. However I don't want it looking a mess or too intrusive. I have seen boards that have a column down the left that contain ads, plus ones at the top of individual forums. I also need to be able to count page impressions for these ads. So multiple ads per page plus the ability to count ad impressions. Do any of you do this already? or have a site that has maximised its ads potential without making a mess of the forum.

[midnightz]

I have installed this before, But on my friends board, it wont go past the first advert and cycle, i have tested it for about 30 minutes? This is quite strange

anybody come accross this? I looked in admin settings and count won't change on variation after the first. It just wont join in the cycle?!? :(

[Dan Flynn]

This is a very very great hack.

Thank You :)

[lorden]

Some silly question it seems as though my whole hack has run flawlessly, i just don't know where to add $advert.

i tried doing some reading and tried adding it just as a test to newthread.php for example.

I keep getting line errors, i'll kepe looking hopefully someone can reply with the simple answer to this...

[Super Ted]

In the header or footer is your best bet.

[LadyBeth]

Two silly questions from a newbie...
1. will this work in 3.0 gamma
2. can it be set up to work on the main index/forums pag ein the upper right hand corner....

ok so it is three questions...
3. if yes, how?

Sorry to be so...new at this...

[SpeedStreet]

To my knowledge, it will not work with vB 3....though I *thought* there was some talk on vb.com about adding this in.

[Dez_U]

great hack.

Question, is there a plan to update it to run on vb 3 ?

thanks again

[BradM]

I personally would love to see it in v3 :D

[JustAskJulie]

Tried to run the first SQL query and got this

[JustAskJulie]

Tried to install the first SQL query and got this error:

Error

SQL-query :

CREATE TABLE `ads` (

`adid` smallint( 5 ) NOT NULL auto_increment,
`name` varchar( 25 ) NOT NULL default '',
`forumid` smallint( 5 ) NOT NULL default '0',
`wholeforum` smallint( 1 ) NOT NULL default '0',
`exposed` smallint( 10 ) NOT NULL default '0',
`exposures` smallint( 10 ) NOT NULL default '0',
`time` int( 10 ) NOT NULL default '0',
`advert` text NOT NULL ,
KEY `adid` ( `adid` )
)

MySQL said:


You have an error in your SQL syntax near '`ads` ( `adid` smallint(5) NOT NULL auto_increment, `name` varchar(25) NOT NULL ' at line 1

[Sidewindr]

I NEED this for VB3!!!! Desperatley.

[chet]

This is posted in VB3 but does it work in VB3, the title reads "Advert Management
For vBulletin 2.2.6"

Regards

Chet

Sorry about that, right forum wrong post, is it ready for vB3 at all

Chet

[White Knight]

Nope... Nothing for VB3 yet.. lots of people waiting for it though. One of the hacks I greatly missed when I was running 2.0

[Sidewindr]

I have ended up using phpAdsNew, seems to be VERY good :)

[White Knight]

I have ended up using phpAdsNew, seems to be VERY good :)

yeah it works if your just trying to do banners.

I was accually using this for the html addition into certian subbords.. I was able to add tables images just like "second menu"

[94supratt]

Is it possible to have multiple ads appear at the same time? I would like to have them side by side at the top of my forum.

[M.C.]

just join to everyone who waiting for vB 3x port!!! bump bump bump !!!

[jamiepryer@hotm]

hey, can someone post up a link to a forum this is working on please :)

[Dez_U]

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in :)

[Julie]

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in :)

With you on that bump! *bump*

[94supratt]

All of my ads have expired because the last date I can set an ad to expire is Dec 31, 2005. How do I resolve this?

[94supratt]

change this wee bit in global.php

if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND time>=".time()." AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}

to

if(isset($advert_forumid)) {
$foruminfo = getforuminfo($advert_forumid);
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',$foruminfo[parentlist],')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
} else {
$advert=$DB_site->query_first("SELECT * FROM ads WHERE LOCATE(CONCAT(',',forumid,','),',-1,')>0 AND (exposed<=exposures OR exposures=0) ORDER BY RAND()");
}

This will disable the time length function until i get it sorted.



I did this to disable the time length function in the mean time.

[bradg]

lets Bump it again in the hopes that someone is ready to releas this as a 3.5 plug in :)

I second that bump! I desperately need this for 3.5.3!!

[Andy R]

Yes, this would be excellent for 3.5!

[Marco van Herwaarden]

This is a 4 year old vB2 hack.

Nobody ever migrated it to vB3.0 i the last 2 years, so i doubt someone will do it for 3.5 now.

Probably enough alternatives.

[bradg]

I've looked around and can't find anything that does exactly what this one did. If you know of anything it would be a huge help to me as well as the several others who have replied with the same response as mine.