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

[brianj]

Originally Posted by DeeperImage

I tried this, can someone make sure I have all the files there ? or is it missing something?

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;

Ok, just upgraded to 3.07 and lost the adcolumn (expected), I went in and ran the above to delete any other instance of it in my database, but the install is still failing and I still get the blank adcolumn template, with no options to change :tired: . any suggestions? Here is the error I am getting:

Database error in vBulletin 3.0.7:

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: Monday 04th of April 2005 05:22:34 PM
Script: http://www.xxxxxxxx.com/admincp/install_adcolumns.php
Referer: http://www.xxxxxxxx.com/admincp/install_adcolumns.php
Username: xxxxx
IP Address: xx.xx.xxx.xxx

[brianj]

nm, went with another option.

[epic1]

Has anyone integrated this with phpadsnew? I'd like to have the banners randomize in placement so the same sponsor isn't on the top at all times. I have my zone setup already, just not sure how to deliver all the banners in the zone with a linebreak and randomize. Thanks in advance if anyone can assist!

[Gary King]

I'd like integration w/phpAdsNew as well.

[Oleks]

Hi,
I’d like to upgrade my forum to vBulletin 3.0.7
As far as understand, I will loss the adcolumn after upgrading.

Can somebody suggest me how to avoid this?
I do not want to go once again through adcolumn installation.

Can I save some file(s) from old version of vBulletin and upload them to the updated vBulletin version to have my old adcolumn (and all content) up and running?

Any other suggestions are welcome.

Thank you.

[Gastongr]

Hi, nice hack!
i get this error when i click on aply database changes

Database error in vBulletin 3.0.1:

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: Wednesday 27th of April 2005 01:56:35 PM
Script: http://www.webmastershelp.com/adminc..._adcolumns.php
Referer: http://www.webmastershelp.com/adminc..._adcolumns.php
Username: Gastongr
IP Address: 24.232.184.185

Help please

[Gastongr]

wtf i already have this in my admincp https://vborg.vbsupport.ru/attachmen...chmentid=17230

Is this the only hack with that menu cause i don't remember me installing this.

[kobescoresagain]

How do you get the column to fit a certain size including the forums. I need mine to be 980 total, I have adcolumns set for 150. I can't change the size to 830 and it look right. Thanks

[n_wattam]

I'm looking for some help, i have installed this mod and works fine... cheers its a great mod.

However the 2 side colums are on the out side of the header, where instead i want the header and nav to stay at max width, and then the colums fallin under as the rest of the foums are.

[kobescoresagain]

you basically are having the same problem as me