AdColumns v1.0

AdColumns 1.0

Description
This hack will allow you to toggle between (or have both) right/left column sidebars on your forum allowing you to insert Advertisements, Banners or whatever else you desire.

Information
Sidebar HTML code by DARK_WIZARD, used with permission (re: https://vborg.vbsupport.ru/showthread.php?t=59781)

Tested on RC4, should work on RC1+

Version History
v1.0 - Initial Release

Planned Features
v2.0
- Image/Content control via ACP (actually, I have this done now.. I'm just finishing up testing)
- Increased Ad Locations toggles (top, bottom, etc..)


If you use this, please click

[joeychgo]

ACtually -- I figured out my problem

I had width set to 1000 sx instead of just 100%

One question while im here --- can the logo be set to 100% somehow?

[joeychgo]

After upgrading to gold - i tried to reinstall -- I got this after running the install script.....

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('adcolumn', '600', 1)

mysql error: Duplicate entry 'adcolumn' for key 1

mysql error number: 1062

Date: Saturday 20th of March 2004 01:26:22 AM

[magnus]

Originally Posted by joeychgo

After upgrading to gold - i tried to reinstall -- I got this after running the install script.....



Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('adcolumn', '600', 1)

mysql error: Duplicate entry 'adcolumn' for key 1

mysql error number: 1062

Date: Saturday 20th of March 2004 01:26:22 AM

You have no reason to re-run the installer. Upgrading to Gold didn't erase anything from the SQL DB. You need to perform the template and file edit mods again though.

[DaveLogic]

Originally Posted by magnus

You have no reason to re-run the installer. Upgrading to Gold didn't erase anything from the SQL DB. You need to perform the template and file edit mods again though.

Since upgrade to Gold all has stopped working..In AdminCP there is still Advertisment Colomn option under VB options but when you click on it it no longer brings up any options..i.e Left / Right check boxes. If I click on OK it just says "Nothing to do"

[joeychgo]

thats the same problem i have

[magnus]

It seems like vB3 Gold may have removed some things from the dB. Looks like I'm going to have to make a quick uninstaller, so you can re-run the installer and put all the settings back.

/sigh.. why Jelsoft, why?

[magnus]

Ok, run these following queries:
[SQL]DELETE FROM `phrase` WHERE `varname` = 'settinggroup_adcolumn' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adenable_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adenable_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adright_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleleft_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleleft_desc' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleright_title' LIMIT 1;
DELETE FROM `phrase` WHERE `varname` = 'setting_adtitleright_desc' LIMIT 1;

DELETE FROM `settinggroup` WHERE `grouptitle` = 'adcolumn' LIMIT 1;

DELETE FROM `setting` WHERE `varname` = 'adenable' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adleft' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adright' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adtitleleft' LIMIT 1;
DELETE FROM `setting` WHERE `varname` = 'adtitleright' LIMIT 1;[/SQL]

Then, go ahead and re-run the installer. It should work fine after that. Be sure to verify the file and template edits!

[heynurse]

I've also got the alignment issues in the show thread where the thread contents are not as wide as they should be (see screenie)

I've made the changes you suggested throughout this thread:

Let's try something, go to your AdminCP then Styles and Templates -> StyleVars. Look for the "Message Area Width (pixels)" and set it to "auto"

I've tried:

In SHOWTHREAD template, find:

<!-- / toolbar -->

<!-- end content table -->
$spacer_close
<!-- / end content table -->

and delete the $spacer_close text

I've tried commenting out

<!-- <div style="padding:0px 25px 0px 25px"> --> from spacer_open template.

Has anyone figured this problem out? Any help would be appreciated, I have also included the source of a page with the problem. Please let me know if you need anything else. Thanks

[magnus]

heynurse,

Here is your problem:

		<div class="page" style="width:95%; text-align:left">

That needs to be "width:100%". You can change it in your Stylevars in the AdminCP.

[jeoworks]

Will this work with the final version of vBulletin? The version after RC4?

Forgive me with terminology

vBulletin 3.0.0

Thanks.