[Adv] banners Hack

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

[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]

Originally Posted by 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...

PHP Code:

 $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:

PHP Code:

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]

Originally Posted by 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:

PHP Code:

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]

Originally Posted by Eagle Creek

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?