i apreciate this hack.

Any future move towards a backend? i mean, something like phpmyads, so publishers could see number of clicks of banners assigned to them? Just a tip.

Saw somebody posting this same question a page ago, but I'm also having this problem, and the answer there was to just create the table, nonsense ofcourse. Anyway, the problem:

Invalid SQL: SELECT displayads FROM usergroup WHERE usergroupid='2'
mysql error: Table 'jnfn.usergroup' doesn't exist

mysql error number: 1146

So there is still a prefix missing in the code. So in functions_bannerads.php change line 34 to:

Solved the errors for me.

Edit:

Noticed another one missing in the code which has to be added to profile.php

Find the following in profile.php
And replace this with:

ja, most of the prefix problems were found/fixed a couple of pages back! - but its good you found and fixed your code!

So is there ever going to be a fix for this error? Has anyone looked into it?

Forgive me for asking this, but there are an awful lot of posts here...is this working now? If I download and install, am I good to go?

Thanks!

Well, no. It works, but still has bugs that obviously aren't being fixed. So I'm clicking UNinstall.

the only bug is in admincp the link dont work and u can fix it by urself besides that 100% good 2 go

I love this hack, only problems im having is I want to be able to sell advertisement space for a certain period of time and time isnt included in this. Also I want to be able to display a random banner ad in one spot on refresh. Anyone done this yet?

any news? i would like to have the time option ;)

Can someone please explain this hack, or certain features at least. Is it like PHPadsnews?

This feature here to me, means that a user can log in his/her CP and see their stats. Am I wrong?

i am running 3.0.7 and i cannot get this to work.

ok so this morning, for testing purposes, i did a reinstall of vbulletin fresh on a clean new database. i figure i can test the mod out, so if it works then i can take it to my live site.

i went through the install instructions, verbatim, and not one hitch.

i go into admin cp, and the dhc banner system heading is there, but when i click on it, there are no links underneath it, just 3 little small blue boxes that are about 2 pixels high. the top little box does nothing, the bottom two do link to something, not sure what since i cant read anything.

That's ok, I can look in the code, and for whatever reason it did not make things work, but I see the link (example dhcbannerads.php?do=view) and I can make my own 3 links from there to view, add, and do settings so I'm ok with this bug.

So I deleted the default banner, and added a new banner. Everything seems to work so far up to this point. Now I just want to insert the banner into the header by adding the appropiate code. I just used the install instructions to copy and replace the code in the header template.

Keep in mind when I setup the banner, I selected ALL to make sure it was in all banner slots.

I load my forum and the banner is not there, dont know what is going on?????

update, i got it to work. for some reason, once the banner has been saved, u have to go back and manually choose the banner slot and the dimensions again, cause they dont save on the initial load.

and last update. i fixed the admincp issue, all you have to do is search in phrases for one of the banner phrases, i did banner_view and made no changes and saved it, it forced the phrases to rebuild themselves and now it all works perfect.

LOL! You fixed it yourself, by doing everything I was gonna tell you to do. Glad to see it.

thx very much worked perfectly, this was the only problem i was having

Hi I just installed no probs but I would like to display ad under my banner in the centre anyone help me out please?

Ok ummm I really need some help on this. Advertising is the only thing that keeps my site going and ever since I switched to vb I havnt been able to have a good advertisment.

I have followed every step of every page and I do not see or get the banners on my page.

I dont have any errors. I put in the phasing for admincp. I have vbadvanced but I dont care if its on that page. I downloaded it a few days ago. NO images show up ANYwhere.

Please help. My site is at your coding mercy.

No problems here....Works great...

*installed*

The first edit takes my site down. Do I need to close my site while I add this?
Will it work, once everything is complete?

----------------------------------------------------------------------
/global.php (1 Change)
----------------------------------------------------------------------
FIND

eval('$headinclude = "' . fetch_template('headinclude') . '";');
eval('$header = "' . fetch_template('header') . '";');
eval('$footer = "' . fetch_template('footer') . '";');

ADD ABOVE

// <DHC>
require_once('./includes/functions_bannerads.php');
$TotalSlots = get_banner_slots();
for ($x=1; $x < ($TotalSlots+1); $x++)
{
$banner_ad[$x] = print_random_banner($x);
}
// </DHC>
----------------------------------------------------------------------

You should always close down while modding. (and/or work on a local copy of the files, and upload them all at once).

I get the exact same problem when I try to do anything in the banner control panel I get this back

"Warning: Cannot modify header information - headers already sent by (output started at /bla/bla/public_html/forum/includes/adminfunctions.php:223) in /admin/dhcbannerads.php on line 313""

or line 323, etc, depending on what I try to do.

If I can fix it I will let you know, for now my whole site is bannerless :(

I just installed the latest version of this hack and I can't get two banners to rotate.

Any suggestions?

Hi all.

Everything works fine.
The banners works fine in the header.
But i still have one small problem.

Im running vBadvanced and wants to add a "banner module".
I need a php page to use as module.
I was hoping that adding a simple $banner_ad[1]; to a php file would do the trick.
But no luck.

So i guess i need a php page that can display the banners without all the other header code and stuff.

Any ideas how one of theese pages should look?

/DonLKSAB

My guess is that i need a php file that can display the banner standalone.
Is that possible to do?

/DonLKSAB

Hey yea I've tried installin this hack 3 times and my site once everything is said and done says I have an error on the forum and I have to blow everything away anyw reason why it would do this? Unless there is an underlying message I don't see that is happening

I am having the same issue I finally got the program to work but I can't get the banners to show up the home page and I think its because its lookin for the table params in the admin cp but since its on the root directory its not gonna be able to pull them. Anyone confirm this?

I have Vbulletin 3.0.7, I got all installation instructions but one, the part find Modify template 'USERCP_SHELL'. Can you please help me.

THanks

It's been 3 months since the coder so much as posted in this thread.

I doubt he's coming back.

This is such a shame, the 1.4 version is starting to look really good.
Hopefully the author has some free time soon to patch up what he has so far and address some known issues, and zip it up as a 1.5 :)

Save up the new features as a plugin for vb 3.5 so you can call it 2.0 - which also gives you (the author) some extra time to work on it.

Nice hack, feature rich enough for some sites I run and looking forward to version 1.5

If you read this please let us know if you have some time in the near future again to work on this! You've done a great job so far.

I don't think Adam has actually forgot about the mod, He is very busy at the moment in his full time job, I am sure v1.5 will be out soon.

Martin
(Adams Friend - DHChat.com)

yeah, this seems to be a good hack thanks..

bug - everytime i view my homepage, the number of views for the banner goes up by 12?

shit i'm still confused on how to get a banner under my nav bar in that blank space...

Sorry everyone for the long...long delay. As Martin said, I have been incredibly busy over the past few months and have had next to no free time for coding.

I will be working on the bug fixes stated so far and will be releasing a version 1.5 in the near future.

I also plan to be releasing a version 2.0 for VB 3.5.0.

Thank you for your patience everyone.

Regards,

Adam Prickett

thanks for it

Hey do we have a release date for this for version 3.5??? I have this hack installed and it works GREAT however I wanna upgrade to version 3.5 and I am guessing that this is not compatible with it yet?

can anyone help me here.. i get this when i try and and install the msql part

Is there an updated version of this for 3.5?

Anymore news on this?