[Adv] banners Hack

[Creative Suite]

what it does ?

This hack allows the administrators to add banners in forumhome or forums or threads ! [ can choose any , or all ]

INSTALLATION

This Hack is tested and working on vb 3.0.4 but should work on ALL 3.x.x versions as well.
Please read the installation-English.txt file in the package CAREFULLY for installation instructions

SUPPORT

well I honestly cannot promise you to solve all-hack problems but I will try to do my best answering your questions and solving the problems I could solve , I also welcome all suggestion .

enjoy : )
Creative Suite
www.Montadiat.com

[Montadiat.com]

Thank You Creative Suite ,

great work ,

best wishes :)

[lasto]

here is neat that - can for certain forums make a banner saying PAYPAL me NOW :)

cheers m8 will test it 2morrow

[lanc3lot]

If its working ok with 3.0.3, i will test it tommorow...is a most wanted hack i think, i havent found anything like that till now

Is there a limit in the banners? i mean can we upload 5-10 banners, and to be shown after each refresh?

[Creative Suite]

lasto

thanks 4 replying , we are waiting for your test and it's results ;)

lanc3lot

If its working ok with 3.0.3, i will test it tommorow

yeah , its working ok with 3.0.3 :)

Is there a limit in the banners

you can add unlimited banners :)

can we upload 5-10 banners, and to be shown after each refresh?

yeah , you can do that by using installtion-english.txt which i attached it in this post :)

[Creative Suite]

there are an little comment :) , in the installtion-english.txt i had sayed

11- in FORUMHOME & SHOWTHREAD & FORUMDISPLAY templates
## find
##-------------
$header
##--------------
## in Above put - [ or any place that you want the banner shown on it ]
##--------------
<br><center>$shir</center><br>
##--------------
##

i mean in below , please keep sure that you edit the templates :), if you are using the hack

best wishes ;)

[8MM]

Nice first hack i installed !


:)

[we_scooter]

ياحبي لك ... توي امس كاتب طلب ابي الهاك هذا ..

انت شي ...

شكرا عزيزي
thanx thats awsome

[Creative Suite]

8MM

Thanks 4 replying & 4 clicking install :p

we_scooter

حياك الله يالغالي والحمدلله ان أفدناك ولو بشي قليل ;)

لاتنسى الضغط على انستول

welcome any time dear :)

[lasto]

works fine testing local to me

cheers m8 just need to find some decent banners now :)

[NuclioN]

Parse error: parse error, unexpected $ in /forums/index.php on line 721

[BarKeep]

you may have missed a } at the end of something.

[NuclioN]

you may have missed a } at the end of something.

Yes that's it, tnx :)

[Creative Suite]

NuclioN

you may have missed a } at this code

$doquery = $DB_site->query("select * from " . TABLE_PREFIX . "adv where main ='1' order by 'id' desc");
while($row=$DB_site->fetch_array($doquery)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}

& make sure that you put the code in above of

eval('print_output("' . fetch_template('FORUMHOME') . '");');

BarKeep

thanks 4 helping :)

best wishes ;)

[NuclioN]

This is a nice addon creative :) Is it possible to add code so that the logo is replaced with the adv image in forumdisplay and showthread? In this case the header image/logo will stay present in forumhome but is variable as adv image. Now the adv image is placed under or above the header image.

[Creative Suite]

NuclioN

i think it's possible to do that , becouse we need to change the logo vars in header template :paranoid: & that mean we should edit all files.

best wishes :up:

[SVTOA]

This seems an awful lot like this hack:
https://vborg.vbsupport.ru/showthread.php?p=591135#post591135

Am I missing the difference here?

[lanc3lot]

Ok installed...i have noticed some bugs(or i see them as bugs:))

So here we are:

a) It seems, for a very strange reason, that the whole banner system, doesnt work for Netscape users !!!

U can go to my page : www.gamers.gr/board and see that if u go through IE u can see the banner, but if u go through Netscape u dont see it !!!

Also the same thing occurs in Firefox users !!!

Can we find any solution on that?

b) Also, i noticed that every time i go to the admin page to edit the banner, the drop down menu which says: "On Forumhome" and its yes or no, its on default to nothing and not in the option u put the last time.

c) How can u put more than one forum to be displayed the banner system? I added in the forum home, and in one more, but i cant find the solution to add it in more...For example i put the forum id 6, and the 7, 8, 9 but only showed in 6. Then i tryed put it with ; between them..but nothing again:(

Also, can we add that in other pages as well? For example in the arcade page, or in the Faq, Articles page:)

d) Is there any way, we can have simple stats in the admin page for that? for example how many ppl clicked in the banner, how many times has been shown, etc

e) Can we put a code or something above the banner, which says: "This is an advertisment" or "This site is sponsored by" ? U can see an example to sites like Gamespot.com :)

Thanks again for the hack:)

[jamesk]

This seems an awful lot like this hack:
https://vborg.vbsupport.ru/showthread.php?p=591135#post591135

Am I missing the difference here?
I'm wondering the same.

[d7me4ever]

Hello

hi Creative Suite

Nice work

thanx

[Creative Suite]

SVTOA & jamesk

there are big difference , this hack https://vborg.vbsupport.ru/showthread.php?p=591135#post591135

allows the administrators to add banners in forum sections & there threads only , & the banners which show in threads is as the banners which show in the section , & you can not add banners to the forum home

but in our hack here , we can add banner to the forumhome "only"
we can add banners to the forum sections only "without it threads"
we can add banners to the thread only "without the section that we add the thread to it"

or we can add the banners in the forumhome , forum section / s and thread /s in 'one' adding step.

that's all :)

lanc3lot

hoolla , alot of comments :p

It seems, for a very strange reason, that the whole banner system, doesnt work for Netscape users !!!

U can go to my page : www.gamers.gr/board and see that if u go through IE u can see the banner, but if u go through Netscape u dont see it !!!

Also the same thing occurs in Firefox users !!!

Can we find any solution on that?

well , honestly i don't know what's the problem with Netscape or fire fox , i hope that any one of coders who is using netscap or fire fox give us the solution !

b) Also, i noticed that every time i go to the admin page to edit the banner, the drop down menu which says: "On Forumhome" and its yes or no, its on default to nothing and not in the option u put the last time.

now i fix it , just upload adv-admincp.php file which i attached it in this post to the "admincp" folder :) and overwrite it with the oldest one

c) How can u put more than one forum to be displayed the banner system? I added in the forum home, and in one more, but i cant find the solution to add it in more...For example i put the forum id 6, and the 7, 8, 9 but only showed in 6. Then i tryed put it with ; between them..but nothing again

Also, can we add that in other pages as well? For example in the arcade page, or in the Faq, Articles page

d) Is there any way, we can have simple stats in the admin page for that? for example how many ppl clicked in the banner, how many times has been shown, etc

well , i shall add this options in new upgrade of this hack , soon

e) Can we put a code or something above the banner, which says: "This is an advertisment" or "This site is sponsored by" ? U can see an example to sites like Gamespot.com

yeah , you can do that by edit the templates which we put the $shir var in it & putting your code above or below the $shir var :)

i hope that i had answered all your questions

best wishes :up:

[Creative Suite]

d7me4ever

u r welcome dear ;)

تحياتنا لكم ;)
my regards

[NuclioN]

The banner is not showing in showtread. How to let it do that? :)

[Creative Suite]

NuclioN

in SHOWTHREAD template

Find
#############
$header
#############
in below put this code
#############
<br><center>$shir</center><br>
#############

& make sure that you had edited the showthread.php file

best wishes

[NuclioN]

hm..i've done that :(

[Creative Suite]

NuclioN

are you sure that you had put the correct thread id in the input area ?

[NuclioN]

O i thought it whas showing in all threads in that subforum, sorry :) Can this be done?

[Creative Suite]

NuclioN

i shall add this option in new upgrade of this hack , soon :)

[lanc3lot]

So we wait for the new version:) hope it will be soon:)

Also if someone knows why this cant be seen in Firefox or Netscape users, please enlight us:)

[bigcurt]

Yeah Id like to be enlightened also lol

[apfparadise]

OK, I have installed the banner, but a small problem :

I have a border around the forum and the part where the banner is goes out of the borders which makes it look awkward. Here is a link to the index page:

My Index (http://72.9.227.2/~aquatic/forum/index.php?)

How can I make it so that it fits within the borders like the rest of the forum?

Thanks, great hack. BTW, I agree if you gave us STATs on the banner use that would be amazing. IF I am to have sponsors, they will need those stats.

[NuclioN]

Please make it so it can display swf flash banners

[erratic assasin]

installed on 3.0.5 and all is well many thanks for a fantastic hack

[jamesk]

question, I do not understand why you use this as step 2:

-> create new template "in styles wich you want the banners be shown on it"

How do i go about this? I don't understand the statement really.

[Creative Suite]

apfparadise

what about putting the $shir var below the $navbar var ? :)

NuclioN

i shall try to do that :)

erratic assasin

thanks 4 replying & clicking install :p

jamesk

just go to the style managar -> in the drop-down box select "add new template" , thats all :)


best wishes

[memobug]

I'm having a hard time telling from the screenshots what this hack does because I can't read it. Is it intended for banner ads? Are banners imported or selected for display on all forums, or certain forums, or what? I am looking for something to display forum-specific banners so people can better tell what portion of the site they are in.

Regards,

Matt

[Creative Suite]

memobug

just read this reply please :)

https://vborg.vbsupport.ru/showpost.php?p=591363&postcount=21

[Elfo King]

I have a problem.....i have installed all ok,but can i try to Add a ban into admincp i enter into login loop....this is the step when i try to Add,Edit or Delete a ban....
Click
login
"Thank you for logging in"
login
....and loop & loop

Any solution ?
have a bug into admincp/adv-admincp.php ? (i have just uploaded the new file u have attacched...)
Thx in advice

[Creative Suite]

Elfo King

use this one :)

[Elfo King]

sob...not work...i loop into login to admincp :(
i have php 4.3.10..syntax are different?

[Creative Suite]

Elfo King

please use this one , should be working :)


if you still loop , require it by using this link in your browser

the link:
http://www.[your_domain].com/[your_forum_folder]/[your_admincp_folder]/adv-admincp.php

but you must know that there are no security login now :)

regards

[Elfo King]

idem....not work the new file.
if i try to access directly to file /forum/admincp/adv-admincp.php i go to select "Add" "Edit" "Delete" page, but when i click....sdong...looping.
Another solution?

[Creative Suite]

just upload the file to your forum folder

but you must know that there are no security login now :)

regards

[Elfo King]

uploaded and deleted line 21 and 564.
the direct link to forum root start and work.
But is not possibile to rebuild the link or other, to use the hack into admincp ?

[Creative Suite]

Elfo King

it's working with me into admincp , but i don't know what's your problem with looping :(

best wishes

[lanc3lot]

Hope the update, will release soon:)

[memobug]

memobug

just read this reply please :)

https://vborg.vbsupport.ru/showpost.php?p=591363&postcount=21
Thanks, I did read that reply and I think I understand it. I am still confused as to whether the banners selected can be specific to a form (as a title banner) or the hack requires that the same banners be applied to all pages where banners are used.

I think some screenshots in English would be a big help, unless the hack is intended for certain language sets, I don't know, but it would go a long way toward making it more widely understood here on vb.org.

Thanks & reagards,

Matt

Regards,

Matt

[apfparadise]

apfparadise
what about putting the $shir var below the $navbar var ? :)


Thanks, man. IT works very well now. Inside the border, and it pulled my navbar up from the forum, an added bonus, it now belongs to the header. Great.

Now as for future versions, here are some very important things to have:
1. Stats - how each banner is doing, very important for sites that need to track that data to charge per-click customers

2. Ability to choose from a series of boxes, one for each major forum and formhome to display or not display. The system now is ackward. btw, I cant remember, what I have to put in order to do it on every forum, let's say the forums are ##s 1,2, and 3. Do I put commas between them in the box, or what?

Thanks for your help, great stuff.
Ed

[Creative Suite]

memobug

if i understood you , i can answer that it's don't requires that the same banners be applied to all pages where banners are used.


apfparadise

u'r welcome ,

& all what you want been added in the upgraded version :)

[Creative Suite]

it's the upgraded version ;)

new Features


can put more than one forum to be displayed the banner in it ex : *1*,*56*,*48*...
can put more than one thread to be displayed the banner in it ex : *1*,*56*,*48*...
can add the banner in other pages which been defined ex : *index*,*faq*,*usercp*...
simple stats in the hack option to know how many clicks & how many times did the banner show to the users & visitors


enjoy :)
Creative Suite

[lanc3lot]

Creative u are a charm:D

And i see we are supporting the same teams:P Hope i find u in Milanmania :P

Going to install it now:)

Ps

Anyone found any way this could work on Firefox or Netscape users?

[Creative Suite]

lanc3lot

lool :p , thanks 4 your nice words dear :)

comment *: if you want the random show , just use the attachment file in this post ;)

[apfparadise]

Thanks, CS, upgraded w/out problems and it looks great. Outstanding. Let me think about it, I may have some more ideas for you. On my old phpbb forum, I had a system that was VERY GOOD for this, had a lot of options, so this one is on its way!!!

BTW, I agree w/the other guy that for US (english-speaking) users you may want to get a screenshot w/an english language banner. IF you want, I can put up a generic Ad banner and send you a few screenshots on forumhome, and forums/threads if you 'd like. Email me at grhome@socal.rr.com.
Ed

[MajorFm.com]

Can the banners be set so they expire after a period of time or even better...

Can the advertiser sign up, upload their banner, pay for the time requested, and it simply sits in admincp waiting a simple accept link (banner approval)

The admin clicks the link and the banner is added for the time paid for...

[erratic assasin]

Elfo King

it's working with me into admincp , but i don't know what's your problem with looping :(

best wishes

Yeah I just upgraded and have the same problem with logging in it just loops any ideas? I have tried the file you provided but still looping even when I try to acsses from adv-admincp.php

every thing working fine before upgrade and I have checked my install twice over...

[Coriolan]

Ok, I instaled it and test with an image .bmp
I instruct to display in forum id *1*
I successfully created the adv. but the image didnt displayed at all :ermm:
Hints?

[Creative Suite]

apfparadise

i uploaded a new screenshots for the english users :) , & i'm waiting for your new suggestions ;)

MajorFm.com

i shall try to add this options

erratic assasin

i had upgraded my forum in same steps & it's working with me , please check your cookies system in your pc :)

Coriolan

i had tried to display an .bmp image extention , & it's gone to be shown successfully :)

please make sure that you had put "http://" before "www" , ;)

regards

[Coriolan]

Problem solved now. Very good job and thank you for your hack.

[lanc3lot]

:) CS any possible add in that, flash banners support
?:)

Thnx in advance:)

[Creative Suite]

Coriolan

u'r welcome ;)

[Creative Suite]

lanc3lot

i think it's unpossible , becouse if you want add flash banners , that's mean you wouldn't add an image banners

regards

[lanc3lot]

Hmm, didnt understand quite the answer:)

[Creative Suite]

lanc3lot

i mean that you have one choice only , flash banner or image banner :)

if you want to use the flash choice replace the cone in the adv_creativesuite tamplate with this one

<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" >
<param name="movie" value="$row[url]">
<param name="quality" value="High">
<embed src="$row[url]" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="$row[name]"></object>

regards

[lanc3lot]

Thanks for this:)

Can u also tell me...in your hack, u say: "if we want to add the banner to the faq page we need to edit 'faq' template and put this code '<br><center></center><br>' in place that you want banner display on it"

Where do i have to put that code? I want to have the banner code, as regular banner at the top, under my forum head logo

I have to do that also for my index page?(i assume its forumhome?)

Thanks also for the flash code, i will use it soon:)

Ps

I noticed, that if u put 2 banners, to be displayed in the same pages(u can see it here! (http://www.gamers.gr/board/forumdisplay.php?f=6)) it add 2 banners! Is there any way, i can make each banner, to "appears" after a refresh?

Sorry for the lots of questions mate:)

[erratic assasin]

Ok I have sorted the problem of looped login in admincp just upload the php file to you /forum/ directory and then run the file www.yoursite.com/forum/fix_login.php
thats it all done. .
And im not taking any credit for the php file just letting you know it fix's problem :banana:

[Creative Suite]

lanc3lot

Can u also tell me...in your hack, u say: "if we want to add the banner to the faq page we need to edit 'faq' template and put this code '<br><center></center><br>' in place that you want banner display on it"

Where do i have to put that code? I want to have the banner code, as regular banner at the top, under my forum head logo

just put this code :

<br><center>$shir</center><br>

below this one:

$header


I have to do that also for my index page?(i assume its forumhome?)

yeah , you need to do that :)

comment * : if you want to use it in the index(forumhome) you must type *index* :)

I noticed, that if u put 2 banners, to be displayed in the same pages(u can see it here!) it add 2 banners! Is there any way, i can make each banner, to "appears" after a refresh?

just use this file :)

https://vborg.vbsupport.ru/attachment.php?attachmentid=22879

& u'r welcome any time :)

erratic assasin

thanks for helping ;)

regards

[kall]

Isn't this more of a "Misc Hack"?

Not a 'major addition' really...

[lanc3lot]

Isn't this more of a "Misc Hack"?

Not a 'major addition' really...


Why is that?

I dont see many hacks like that in the forums, there just another one as i see it, but with less feautures like this one:)

[we_scooter]

so now this is updated version and u solved all the problems stated above???

I am waiting ur confirmation on this then I will download it , thanks mate.....:)
we_scooter..

[Creative Suite]

we_scooter

all the problem been solved in the updated version :)

[J-TEK]

Is there any uninstall script for this hack, just out of curiosity.

[yinyang]

sounds like a good hack and it'd be perfect for my forum if one additional option could be enabled.

would it be possible to make the ads show for some usergroups and not others? for example, a site with a regular membership would have those "pesky" ads. but for premium (paid) members, those ads would disappear.

would this be difficult?

[apfparadise]

oh, yeah, I would love that, also. I love the hack, installed and upgraded but this would be awesome. ANother upgrade? should be easy, a simple <if> thing, but I dont know how to.

I run it as a Contributor Program solicitation, so it would be awesome if the people who have contributed (donated) would not have to keep seeing it.

[Creative Suite]

J-TEK

just upload the attachment file to your admincp folder , & then run it using your browser , & don't forget to remove the code from the global.php file :)

yinyang & apfparadise

if you had installed the hack , do that

in the global.php file

find :

$R = THIS_SCRIPT;

if($R != 'forumdisplay' AND $R != 'showthread' AND $R != 'login' ){

$queryxs = $DB_site->query("select * from adv where script LIKE '%*$R*%' order by RAND() limit 1");
$rowx = $DB_site->num_rows($queryxs);

while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');

}
$update = $DB_site->query("UPDATE adv SET views = views+1 where script LIKE '%*$R*%' ");
}

if($R == "forumdisplay"){
$foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by RAND() limit 1");

while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');

}
$update = $DB_site->query("UPDATE adv SET views = views+1 where forumid LIKE '%*$foruminfo[forumid]*%' ");
}


if($R == "showthread"){
$threadinfo = verify_id('thread',$_REQUEST['threadid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where threadid LIKE '%*$threadinfo[threadid]*%' order by RAND() limit 1");

while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');

}
$update = $DB_site->query("UPDATE adv SET views = views+1 where threadid LIKE '%*$threadinfo[threadid]*%' ");
}

replace it with :

global $bbuserinfo;
$R = THIS_SCRIPT;

if($R != 'forumdisplay' AND $R != 'showthread' AND $R != 'login' ){

$queryxs = $DB_site->query("select * from adv where script LIKE '%*$R*%' order by 'id' desc ");
$rowx = $DB_site->num_rows($queryxs);
if($bbuserinfo[usergroupid]==??){
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');

}
$update = $DB_site->query("UPDATE adv SET views = views+1 where script LIKE '%*$R*%' ");
}
else{
$do = "nothing";
}}

if($R == "forumdisplay"){
$foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc ");
if($bbuserinfo[usergroupid]==??){
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE adv SET views = views+1 where forumid LIKE '%*$foruminfo[forumid]*%' ");
}
else{
$do = "nothing";
}}


if($R == "showthread"){
$threadinfo = verify_id('thread',$_REQUEST['threadid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where threadid LIKE '%*$threadinfo[threadid]*%' order by 'id' desc ");
if($bbuserinfo[usergroupid]==6){
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');

}
$update = $DB_site->query("UPDATE adv SET views = views+1 where threadid LIKE '%*$threadinfo[threadid]*%' ");
}
else{
$do = "nothing";
}}

with changing the "??" marks to the group id in this code
:

$bbuserinfo[usergroupid]==??

if you want to add more than one group replace this code "for 3 time"

$bbuserinfo[usergroupid]==6

with :

$bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==??

with changing the "??" marks to the groups id :)

that's all

best wishes ;)

[lanc3lot]

lol:) he is awesome:D

Nice speed mate:D

[apfparadise]

CS, will this work if I need to do that to 12 Groups? Dont ask why :)

[MajorFm.com]

MajorFm.com

i shall try to add this options



I look forward to it... Thank u for keepin this hack updated with your support and updates... its appreciated.

[PuntoPower]

does this support swf (flash) banners??

[we_scooter]

Got every thing as being instructed in the upgrade guid , but stil the banner ads not showing ..!!

:surprised:

here are my settings for the banner and still nt showing , I did all the equired steps..

[J-TEK]

J-TEK

just upload the attachment file to your admincp folder , & then run it using your browser , & don't forget to remove the code from the global.php file

What attachment file? The installer?

[yinyang]

here's a noob question... does this work with google ads?

[Elfo King]

Ok I have sorted the problem of looped login in admincp just upload the php file to you /forum/ directory and then run the file www.yoursite.com/forum/fix_login.php
thats it all done. .
And im not taking any credit for the php file just letting you know it fix's problem :banana:

I have fixed...very , very very THX at all for HAck and support !!! :up:

[apfparadise]

ok, tell me why this is not working on my server.

I created a new secondary group, contributors, and put all contributors in that group as a sec. group. then in Forumhome, where your code is below the $navbar, I changed it to this code below, what is wrong with it why is it not showing (23 is the code for the Contributors user group):


<if condition="!is_member_of($bbuserinfo, 23)">
<center>$shir</center><br></if>

[Creative Suite]

lanc3lot

:)

apfparadise

CS, will this work if I need to do that to 12 Groups? Dont ask why

yes it's ,

replace

$bbuserinfo[usergroupid]==??

with :

$bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==?? OR $bbuserinfo[usergroupid]==??

with changing the "??" marks to the groups id

& if you want use that! :

<if condition="$bbuserinfo[usergroupid]==??">
<center>$shir</center><br>
</if>

with changing the "??" marks to the group id :)

PuntoPower

nope :)

we_scooter

replace ' " ' mark with ' * ' : ex : *1* or *index* :)

J-TEK

this one :) > https://vborg.vbsupport.ru/attachment.php?attachmentid=22919

yinyang

what did mean with "google ads" ? :)

best wishes :up:

[absoluthum]

After uploading the global.php the function "Mark forums read" doesn´t work.

Has any other this problem?

[apfparadise]

well what I was trying to do is show it to the members who are NOT part of the usergroups, so if the member was, it would NOT show the banner, Like an ad banner to NOT be shown to the contributing members.

What is the correct code for that then?

[apfparadise]

also, how do I put a line of text under the banner that says: Remove this ad by becoming a Contributor

This way if the above question is answered, I can have a banner that goes away as soon as the member donates and is added to the Contributor group.

[Creative Suite]

apfparadise

<if condition="$bbuserinfo[userid]==0">
<center>$shir<br><b>Remove this ad by becoming a Contributor</b></center><br>
</if>

with this code , the banners will be not display to the users , "only for the visitors"

[apfparadise]

No, I want it to display to all the users, including members, except for ONE USERGROUP, number 23, for example.

I thougth this below was the way to do it (from another example on another site):

<if condition="!is_member_of($bbuserinfo, 23)">
<center>$shir</center><br></if>

[Creative Suite]

apfparadise

i hadn't test your code , but this one should be work as you want it :)

<if condition="$bbuserinfo[usergroupid]!=23">
<center>$shir<br><b>Remove this ad by becoming a Contributor</b></center><br>
</if>

[apfparadise]

No, it still shows. What I did was make every member who contributes go into a group called Contributor (secondary group), then I put your code in, instead of the regular $shir code, and it still shows for both contributors and non-contributors

http://aquatic-photography.com

You can log in as username: test password: test, a member of : Registered Users as a Primary, and Contributors as a secondary.

[apfparadise]

nvm, I fixed it, it did work with the original code I showed you, but not the one you did:

<if condition="!is_member_of($bbuserinfo, 23)">
<center>$shir</center><br></if>

This one tells to show anyone who iS NOT the member of group 23. That is exactly what I needed. It totally works now.

[Elfo King]

I need to insert adv into all forum created, i supponse to insert *forumdisplay*(or "forumdisplay.php) into The box "Script name"...but i dont view.
The solution ? :-P
Thx ;)

[Elfo King]

UP !
I can set to view the ban into all forum ?
i dont want to set 150 forum id's manually....

thx

[Elfo King]

RE-UP
Pls i need a fast solution.....:(

[Bolas]

If you need an help by programmer you can ask here: https://vborg.vbsupport.ru/forumdisplay.php?f=30

Maybe someone has resolved it in his vb experiment ;)

[futureye]

Nice Hack...
i will install it in Forum Sites i got.

thanks again Creative Suite
and we shell met in ++++++

C U

[Creative Suite]

Elfo King

the hack don't support that :)

futureye

thanks 4 replying

[TunerNetwork]

This looks like a great hack, I got it all installed, and I think it's working properly, but I cant get the banners to show. Can someone please help me out, I really need this for my board. tunernetwork.com

Thank you, either pm me on here or email me: zazza_ceo@TunerNetwork.com
or TN ZAZZA CEO on AIM

[Rastus]

I get this error:

Database error in vBulletin 3.0.6:

Invalid SQL: select * from adv where main ='1' order by RAND() limit 1
mysql error: Unknown column 'main' in 'where clause'

mysql error number: 1054

[Raitsa]

Sort of same lookin prob here as Rastus above:

Database error in vBulletin 3.0.1:

Invalid SQL: select * from adv where script LIKE '%*index*%' order by 'id' desc
mysql error: Table 'vbulletin**namecensoredbyRaitsa**.adv' doesn't exist

mysql error number: 1146

[iSpanish]

Nice hack

Good job Creative Suite

i will install it soon.

Marboosh

[duhaas88]

I installed the above and I get the error when trying to go to the forum index page. any suggestions?? I'm using 3.0.6

thanks

[Eagle Creek]

This is a nice addon creative :) Is it possible to add code so that the logo is replaced with the adv image in forumdisplay and showthread? In this case the header image/logo will stay present in forumhome but is variable as adv image. Now the adv image is placed under or above the header image.
Does it work on 3.0.6?

Seems nice to me

[Eagle Creek]

I would like to install this in my forum, so I have completed all steps but # 2 where you have to create a template and name it, then include the code. I'm a complete newbie to this.(I bought vbulletin last night)version 3.0.6

Can someone point me to where I can find out this information ragarding how to create the template? I have looked over the manual and haven't found a solution.

Thanks

Go to ACP
Go te styles templates
Select your style, choose "add template"

Does this do the trick for you?

[duhaas88]

Go to ACP
Go te styles templates
Select your style, choose "add template"

Does this do the trick for you?

I got the template done, but now I can't get the banner to show up in the forum. What could I be forgetting? Here is a screen shot of my ads "add Ads"

Thanks for the help:)

[Fallonme]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in adv.php on line 34
No banner had been detected

[TunerNetwork]

I need help with getting this hack to work, pm me if you can help

[agrajeda]

I added this hack and it really looks good from what I see on other sites. This may be a dumb question, but I dont understand the:

Forum /s id ( Forumdisplay,
Thread /s id ( Showthread
Script name

So I did *2* *1* and then index

so I figured it would show an add on the second forum and first thread but it does not show on my site.

can someone please help me. I reall would like to use this hack on my site.

[lifesourcerec]

Just installed this hack and now whenever a user clicks "Mark Forums Read", this comes up:


No Forum specified. If you followed a valid link, please notify the webmaster


IT's the code that you add to global.php. Once I add it, "Mark Forum Read" doesn't work. When I remove it, it works. Anyone else has this problem?

[b00k]

So I installed the hack according to the .txt file to a Tee, but the adv-admincp.php doesn't showup in the adminCP...

any ideas?

if i load the adv-admincp.php file directly in the browser it works..

[lifesourcerec]

Anyone figured out how to fix the "Mark Forums Read" problem?

[KanyeWest]

i need help i followed directions of the banner hack but it wont work where in admin cp do i find it i installed but it i dont see it anywhere :mad: help me :mad:

[lifesourcerec]

i need help i followed directions of the banner hack but it wont work where in admin cp do i find it i installed but it i dont see it anywhere :mad: help me :mad:

Double check step #3 which goes in admincp/index.php

[kall]

i need help i followed directions of the banner hack but it wont work where in admin cp do i find it i installed but it i dont see it anywhere :mad: help me :mad:
I'd advise against helping this guy with anything.

He likes to release other people's hacks on pirate sites.

[Barakat]

مشكور حبيبي والله هاك حلو ويعطيك العافيه ويجعله ربي في ميزان حسناتك
thanks for this nice hack

[TunerNetwork]

hack works great, finally figured it out. One questiong, any way to have it so the banners will rotate?

[agrajeda]

Will no one help me?

[iSpanish]

nice hack Creative Suite....

Marboosh Clicks Install*

- Thanks Bro

[Crank]

Ok I have sorted the problem of looped login in admincp just upload the php file to you /forum/ directory and then run the file www.yoursite.com/forum/fix_login.php
thats it all done. .
And im not taking any credit for the php file just letting you know it fix's problem :banana:


thank you very much for the fix it is greatly appreciated.

[lifesourcerec]

For everyone using this hack, see if "Mark Forums Read" still works.

[|Jordan|]

For everyone using this hack, see if "Mark Forums Read" still works.

Doesn't work for me either :rolleyes:

Also, i cant get the banner to display on other pages. I added the code to faq template and it works there, but in other templates it doesnt.

[The Realist]

The mark forums read dont work for me as well, it says No Forum specified. If you followed a valid link, please notify the webmaster

Also when I click any link in the adv hack option dropdown menu it keeps asking me for my username and password but does not let me in?

Anyone?

[The Realist]

Solved the admin loop problem, thanks erratic assasin.

Now the global.php code problem to get working.

Ok I have sorted the problem of looped login in admincp just upload the php file to you /forum/ directory and then run the file www.yoursite.com/forum/fix_login.php
thats it all done. .
And im not taking any credit for the php file just letting you know it fix's problem :banana:

[One-Team]

Thanks Creative Suite
INSTALL :laugh:
ومرة ثانية مشكور جداً على الهاك

[deathemperor]

Ok I have sorted the problem of looped login in admincp just upload the php file to you /forum/ directory and then run the file www.yoursite.com/forum/fix_login.php
thats it all done. .
And im not taking any credit for the php file just letting you know it fix's problem :banana:
I do not recommend this fix, highly not !

this file will change your setting automatically, 3 settings: cookiedomain, cookiepath and timeoutcontrolpanel

timeoutcontrolpanel is set to 0 means you will never be logged out automatically, this is a security risk. Vb has this in vb3.0.0 but later they add a session timeout so that you will be kicked out after a specific idle time.

The only good fix for this is to change the adv-admincp.php?s=add to something else, because as default VB uses s for session value.

just my 2 cent

[Eagle Creek]

Is it full vb3.0.7 compatible?

[Flow Fusion]

Database error in vBulletin 3.0.7:

Invalid SQL: select * from adv where main ='1' order by 'id' desc
mysql error: Unknown column 'main' in 'where clause'

mysql error number: 1054

Date: Saturday 05th of March 2005 12:05:00 PM
Script: http://giftedsouls.com/gs/index.php

[amphicar770]

Having same problem as some others in that images are not showing. The stats say ads are being presented, I just do not see them.
Screen capture attached of my config.

Thanks.

[Eric HRF]

Having same problem as some others in that images are not showing. The stats say ads are being presented, I just do not see them.
Screen capture attached of my config.

Thanks.

Ditto, same problem...

[madkidz]

Anyone fixed this problem for vb 3.0.7

[BluSmurf]

anyone got this working on 3.0.7? would love to add this hack to my site :)

[Eagle Creek]

Is it full vb3.0.7 compatible?

????

[Lionel]

That hack is creating some kind of conflict with vbookie. Once I removed the below at the end of global.php, vbookie worked again...


$R = THIS_SCRIPT;
if($R != 'forumdisplay' AND $R != 'showthread' AND $R != 'login' ){
$queryxs = $DB_site->query("select * from adv where script LIKE '%*$R*%' order by 'id' desc");
$rowx = $DB_site->num_rows($queryxs);
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE adv SET views = views+1 where script LIKE '%*$R*%' ");
}
if($R == "forumdisplay"){
$foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE adv SET views = views+1 where forumid LIKE '%*$foruminfo[forumid]*%' ");
}

if($R == "showthread"){
$threadinfo = verify_id('thread',$_REQUEST['threadid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where threadid LIKE '%*$threadinfo[threadid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE adv SET views = views+1 where threadid LIKE '%*$threadinfo[threadid]*%' ");
}

[outlaw621]

Here is a temporary fix to be able to use the "Mark All Forums Read" button.

In the code for the global.php you need to comment out one line as shown below:

if($R == "forumdisplay"){
// $foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}Do this at your own risk as I have no clue if it is going to break any other functions of this hack. I have completed the above and everything seems to be working. For some reason that particular line is causing the problem. If the author of the hack could look everything over and come up with a better solution that would be great.

[Eagle Creek]

Here is a temporary fix to be able to use the "Mark All Forums Read" button.

In the code for the global.php you need to comment out one line as shown below:

if($R == "forumdisplay"){
// $foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}Do this at your own risk as I have no clue if it is going to break any other functions of this hack. I have completed the above and everything seems to be working. For some reason that particular line is causing the problem. If the author of the hack could look everything over and come up with a better solution that would be great.

For what problem is this a fix?

[outlaw621]

For what problem is this a fix?
For the users who can no longer use the "Mark Forums Read" button or links.

[amoree]

السلام عليك?

شكرا على هل الهاك بس عندي مشكلة مني عارف شنو اسوي فيها وهي

انا قبل فترة سويت انستول للفايل وما ظبط وياي مرة وبعدين لاحظت انك سويت فيرجنت جديد فحبيت اسوي ابقريد قلت يمكن يظبط وياي طبعا ما ظبط واول ما سويت ابقريد للفايل حق الابقريد اعطاني ايرر انة في دبلكيت للتيبل ياريت تقلي شنو اسوي وهذا اهوة الايرور
ADV Hack - Upgrading : By Creative Suite

Duplicate column name 'NOCL'

[djjeffa]

Database error in vBulletin 3.0.5:

Invalid SQL: select * from adv where script LIKE '%*adv_index*%' order by 'id' desc
mysql error: Table 'djjeffa_djjeffaVB.adv' doesn't exist

mysql error number: 1146

Date: Saturday 19th of March 2005 07:26:59 PM
Script: http://www.djjeffa.com/vb/home.php
Referer:
Username: djjeffa



my prefix is _vb anyone have any advice?

[xtreme-mobile]

ive installed the hack but now i cant log in to my cp panel it says logging in then just goes back to the log in bit again

any ideas?

[djjeffa]

ok with the help of outlaw i got a lil futher with this it now works and shows the image but when tou click it it takes me to http://www.djjeffa.com/vb/adv.php?ID=3 when it should be going to http://www.dec.org.uk

any ideals guys?

[SunShina]

Here is a temporary fix to be able to use the "Mark All Forums Read" button.

In the code for the global.php you need to comment out one line as shown below:

if($R == "forumdisplay"){
// $foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}Do this at your own risk as I have no clue if it is going to break any other functions of this hack. I have completed the above and everything seems to be working. For some reason that particular line is causing the problem. If the author of the hack could look everything over and come up with a better solution that would be great.
this hack is really conf and i dont no how can i add banner .. :)

[XrayHead]

Anyone sorted this....?

[cgjackson2001]

Hi,

I have a banner space in the forum header here http://www.dzineforum.com, would i be able just to put the banner in there with this hack

[amphicar770]

Has anyone been able to get this to work on 3.0.7

A great hack but I wonder if it has been abandoned. :-(

[Eagle Creek]

Is it full vb3.0.7 compatible?

:banana:

[AllenMead]

I got the mysql error too

I'm using:

php 4.3.4
MySql 3.23.58

Database error in vBulletin 3.0.5:

Invalid SQL: select * from adv where script LIKE '%*index*%' order by 'id' desc
mysql error: Table 'astra-mk2_com_-_forum.adv' doesn't exist

mysql error number: 1146

Date: Thursday 24th of March 2005 10:34:13 AM
Script: http://www.astra-mk2.com/forum/index.php?
Referer: http://www.astra-mk2.com/forum/admincp/index.php?do=head
Username: Allen Mead
IP Address: ***********

[AllenMead]

I've had to revert the changes made to the glogal.php and index.php files as I can't afford to have a live site screwed.

[Eagle Creek]

I've had to revert the changes made to the glogal.php and index.php files as I can't afford to have a live site screwed.
Does it work on 3.0.7 or does everone has problems??!!

[Julio]

Creative:

I have VB 3.0.7 I have installed the hack, and when I click "add adv" it prompts me for the Username & Password. It goes in a loop. I beleive the same issue as Coriolan?

What can I do?

[Creative Suite]

hi 2 all

i had tested it on 3.0.7 and it's worked as well :)

regards

[Creative Suite]

note * : there is will be new upgrade soon :)

best wishes

[Osiris2k]

any way of putting google ads in? (javascript)

[AllenMead]

Is there an option to have this professionally installed?

[Julio]

Yeap... I would pay as well.

[djjeffa]

ok with the help of outlaw i got a lil futher with this it now works and shows the image but when tou click it it takes me to http://www.djjeffa.com/vb/adv.php?ID=3 when it should be going to http://www.dec.org.uk

any ideals guys?
umm bump?

[XrayHead]

Hi There

I want to remove this hack because of the admin loop thing.
Can you please tell me what tables I have to remove in my database and also what templates in my admincp. Thanks...

Xrayhead

[pcoskat]

Are 3.0.7 users still having problems with this?

[XrayHead]

Any updates on this please!!

Thank you.

[Highlander65]

A questions was raised about this hack doing banner rotation. Can the banners rotate?

[The Realist]

Removed.

My fault :)

[The Realist]

The instructions for this hack are terrible, can anyone make heads or tails of this:

for example :

if we want to display it in the forumhome we need to put 'index' , for faq 'faq' , & we can display it in more than one page , you should add the page name between two '*' , ex : *index*, *faq*,*usercp* , & you must add this code into the templates wich we will add the banner to their pages , ex : if we want to add the banner to the faq page we need to edit 'faq' template and put this code '<br><center></center><br>' in place that you want banner display on it

comment *: we dont need to use this option for 'forumdisplay' or 'showthread' becouse we have another options

comment * :if want to display it in the addtional hack page you need to define the hack page before

Because I cant.

Can someone PLEASE explain whats need to place a banner in the home page, within threads and posts etc.

Im lost.

[The Realist]

This hack is the worse hack I've seen yet.

Where in the instructions does it say to edit the showthread file never mind adding <br><center>$shir</center><br> to the showthread template.

Wish I never started this :mad:

NuclioN

in SHOWTHREAD template

Find
#############
$header
#############
in below put this code
#############
<br><center>$shir</center><br>
#############

& make sure that you had edited the showthread.php file

best wishes

[The Realist]

Forget it.

Removed it, worse hack I've ever seen and should be removed from VBorg.

[geovadim]

This hack also can show ads on the right side of the forum?

[pitt2424]

Can i make the banners look like this with this particular hack?

and will this hack work with 3.0.6?

[AlexUK]

I am getting this 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 'index' , for faq 'faq' , & we can display it in more than one

[AlexUK]

Ok fixed now.

[TouchStone]

nice mod i have the german version.;)

thx

[XrayHead]

Hi There

I want to remove this hack because of the admin loop thing.
Can you please tell me what tables I have to remove in my database and also what templates in my admincp. Thanks...


Xrayhead


Is there any support for this hack at all????

[Nero1977]

Creative Suite:

good hack, but I have just one q.

How can I add html code to some forum id, instead of image and url?

I need more custom design for each forum id :)

Thank you!

-Alex

[Creative Suite]

thanx 4 all one ..

i will answer all the questions in next time..:)

regards

[Almotmaiz.Net]

nice work ,,

[LuBi]

added 2 queries, and slowed page load a full .02 seconds :disappointed:

it's exactly what i was looking for but slowed things down to much, and is difficult to get up and running as I did not get it to display an add but was working. thanks anyhow.

[madkidz]

Is there an easy way to have the banner show in all forum without typing 1,2,3,4,5,6,7, etc. For people with large forums it becomes tedious to do for each. Also is there a way to set it so the you see the banner after every 6 posts for instant?

[Underlab]

I installed this hack, and everything went smooth and it seems to work, but I still dont see any Ads anywhere - When i go to the forums that the ads are supposed to be in, the stats claim to have seen them, however. No Images were ever actually shown. PLEASE HELP ME!!!!

[MajorFm.com]

You might be using the norton toolbar with adblocker... it takes out banner adverts...

[Underlab]

Noooooo. That is not the problem. I checked on 2 other computers one of which does not have norton, and i also made sure that those things were disabled. And it has never prevented me from seeing ads on other sites.

[Borimikan]

ok i installed the hack, and add the code to the showthread template,, and i have this error shown in the attached image!

ANY HELP!"""""!!

[Underlab]

This hack sucks, and now it just wastes space in the scripts and database tables. I cant get any support for it on here. I recently upgraded to vbulletin 3.07 and a few hacks stopped working.

[SlipNslide281]

Is there anyway somone can post an exact example of how to get the banner to show under the forumhome top center right under the header.

[mayzan]

Same thing happened to me... I get loop too when I try to log in... Creative Suite.. can you help me please? I use Vbulletin 3.07. I also tried "fix_login.php" which was posted by someone in this forum.... but still failed.

Any way, many thanks! :)

[erratic assasin]

ok why am I getting this ?

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 'index' , for faq 'faq' , & we can display it in more than one page , you should' at line 1

any one?

[Marco van Herwaarden]

Please post the full error mesage.

[erratic assasin]

Thats it nothing else?

or can someone tell me how to remove this hack?

[Marco van Herwaarden]

That is NOT the full error message.

[erratic assasin]

Its ok I have cleared up that problem! just need to know how to uninstall?

[SlipNslide281]

installed and I see it in the admincp but can't figure out how t get it to show on my forumhome under the header.

[ArabSQuad]

Thank You Creative Suite ,

great work ,

best wishes

[dimitris]

ok, thnks. Its work at 3.0.8

but you have a mistake at adv.php at 43 line
must be this:
print "<META HTTP-EQUIV=Refresh CONTENT='0; URL=$rox[url]'> ";

and not this:
print "<META HTTP-EQUIV=Refresh CONTENT='0; URL=$rox[url];/'> ";

hope to help

[bhr]

is it working with 3.0.7 ?

[Lizard306]

Hi there,

I went through the instillation procedures. Completed the steps as suggested. Am having a problem finding my adds. Also followed the instillation procedures provided in [installation-English-1.txt] file.

Also placed a sample add with the image [Adv Img Url] to an image file on my own webserver. But cant find any ad content.

Can anyone pls help. Can provide screen-shots of the same.

Kindly help,

Regards

Sougandh Pavithran

:disappointed:

[blackdream1971]

i want to be able to put my banners up through the admin cp, is there a hack for vb version 3.0.6 that looks like the banner placement in the link below?

http://www.beyondmass.com/forums

[Hanif]

Any updates on 3.5 Gold??? Anyone got it working yet???

Ta,

Hanif

[harpez]

Yeah, thats what I need to know!

[Bieddos]

Yeah, thats what I need to know!

me too

[nymyth]

HI, I cant seem to see the banner on my forum home.

Forumdisplay = *1*
Thread id = blank
Script name = index

It doesnt show anything on my forumhome....what am i doing wrong?

Peace

[ams3521]

I'm on 3.07 too and i cannot see any banners though the number of times shown increases when i view the page.

Any ideas?

[city-love]

الله يعطيك العافيه وياريت ترقيه لنا لنسخه الاخيره
3.5.0

اكون شاكر لك

thank you but we need for v3.5.0

[acorndomains.co]

الله يعطيك العافيه وياريت ترقيه لنا لنسخه الاخيره
3.5.0

اكون شاكر لك

thank you but we need for v3.5.0

Yes does it work on 3.5.0??

[Pain86]

i get this when i try and add a banner

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 'index' , for faq 'faq' , & we can display it in more than one page , you should' at line 1

help!?!?

[mayhemmike]

i get this when i try and add a banner

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 'index' , for faq 'faq' , & we can display it in more than one page , you should' at line 1

help!?!?
oops!

[jamiepryer@hotm]

Database error in vBulletin 3.0.6:

Invalid SQL: select * from adv where main ='1' order by 'id' desc
mysql error: Unknown column 'main' in 'where clause'

mysql error number: 1054

Date: Tuesday 13th of December 2005 10:37:57 PM
Script: http://www.sussexcarz.com/forum/upload/
Referer:
Username: Jamie@SMCC
IP Address: 80.3.64.11

get the following error
please help :)

[Icehawk002]

Everything appears OK but when the final changes are made to global.php as in


5- in [your forum folder]/global.php
## find
##-------------
/*================================================= =====================*\
|| ################################################## ##################
|| # Downloaded: 01:34, Sun Jan 2nd 2005
|| # CVS: $RCSfile: global.php,v $ - $Revision: 1.256.2.4 $
|| ################################################## ##################
\*================================================ ======================*/
##--------------
## in Above put
##--------------


$R = THIS_SCRIPT;

if($R != 'forumdisplay' AND $R != 'showthread' AND $R != 'login' ){

$queryxs = $DB_site->query("select * from adv where script LIKE '%*$R*%' order by 'id' desc");
$rowx = $DB_site->num_rows($queryxs); etc etc

Then an error is produced Invalid SQL: select * from adv

If anyone prepared to assist please PM me

[Icehawk002]

Actual error is


Database error in vBulletin 3.0.7:

Invalid SQL: select * from adv where script LIKE '%*online*%' order by 'id' desc
mysql error: Table 'icecastle.adv' doesn't exist

mysql error number: 1146

[Paul M]

From memory, you use table prefixes on your site, change the relevant line of code to this ;

$queryxs = $DB_site->query("select * from " . TABLE_PREFIX . "adv where script LIKE '%*$R*%' order by 'id' desc");

[Icehawk002]

Thanks Paul I tried that but no luck :o

[Paul M]

Thanks Paul I tried that but no luck :oI'm not surprised - looking at the whole block of code, there are about six instances where the table prefix is missing, not good.

Replace the whole section for global.php with this ;


// Fixed for table prefixes by Paul M.
$R = THIS_SCRIPT;

if ($R != 'forumdisplay' AND $R != 'showthread' AND $R != 'login' )
{
$queryxs = $DB_site->query("select * from " . TABLE_PREFIX . "adv where script LIKE '%*$R*%' order by 'id' desc");
$rowx = $DB_site->num_rows($queryxs);
while($row = $DB_site->fetch_array($queryxs)){
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE " . TABLE_PREFIX . "adv SET views = views+1 where script LIKE '%*$R*%' ");
}

if ($R == "forumdisplay")
{
$foruminfo = verify_id('forum', $_REQUEST['forumid'], 1, 1);
$queryxs = $DB_site->query("select * from " . TABLE_PREFIX . "adv where forumid LIKE '%*$foruminfo[forumid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs))
{
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE " . TABLE_PREFIX . "adv SET views = views+1 where forumid LIKE '%*$foruminfo[forumid]*%' ");
}


if ($R == "showthread")
{
$threadinfo = verify_id('thread',$_REQUEST['threadid'], 1, 1);
$queryxs = $DB_site->query("select * from " . TABLE_PREFIX . "adv where threadid LIKE '%*$threadinfo[threadid]*%' order by 'id' desc");
while($row = $DB_site->fetch_array($queryxs))
{
eval('$shir .= "' . fetch_template('adv_creativeSuite') . '";');
}
$update = $DB_site->query("UPDATE " . TABLE_PREFIX . "adv SET views = views+1 where threadid LIKE '%*$threadinfo[threadid]*%' ");
}

[Icehawk002]

Thanks Paul, great work it's working well installed should I say now. Just got to work it out now LOL

So in addition to the above fix
Banner only visible to non members - fixed
Admin looping - fixed
Mark Forums Read - fixed
Banner not showing - fixed
Now just need a little help with the CURRENT error


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /........../....../adv.php on line 34
No banner had been detected

?

[Icehawk002]

bump...

[Mokster]

is this avail for 3.5?

[Jamer]

How do you place the banner in the top right hand corner?

[IvyKeepMommy]

When I try and do the first step of installation, I get this error Warning: mysql_connect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /admincp/adv-install.php on line 88