AdColumns v1.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 https://vborg.vbsupport.ru/

It seems great :). Good job

Just curious, when do you plan to have V2 out? Just wondering if I should wait?

Thansk!!

It could be out tonight, or it could be out next month. Who knows? Unfortunately, my work schedule is erratic at best.. so I can't promise. One thing I can promise though, is I will include upgrade instructions. Most of the upgrade will be automated, so it will be relatively painless.

As it sits, the installation for V1 takes about 2 minutes (if you take a break in between, lol). There's only 1 file edit, and 2 template edits. Neither of which require you to "replace" anything, so removal is a snap if needed.

nice :)

Awesome!! Installing tonight! Thank You!

INstalled -- worked easily! Thanks.

One question -- how do I put anything in this column? I know I have to edit the template, but IM guessing I have to learn html?

Yes. As with all templates, it's HTML based. However, with v2.0 I plan to help minimize the HTML knowledge needed to an extent.

Ok -- not to nag, but when is 2.0 coming?

:)

Yep I saw that before --- :) Guess I should stop nagging so you can get it done? LOL

I miss the adverts management hack that 2.x had. You could have different sponsors for different forums. If this develops into that, i'll install...

I have a real need to have different ads on different forums....

Hrm.. I might be able to accomodate that.

That would be fantastic!

Small problem...

Database error in vBulletin 3.0.0 Release Candidate 4:

Invalid SQL:
INSERT INTO setting VALUES('adenable', 'adcolumn', '1', '1', 'yesno', 10, 0, 1)

mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Simple. You have a hack installed that modified your 'setting' table. Simply modify the installer to include the extra field(s).

If that's something you don't think you can do, check your 'settings' table in phpMyAdmin and send me a PM with the field names and I will modify it for you.

PMed...

oh wow, this hack makes my life about a hundred times easier as we rotate new party banners almost monthly.

is there any sort of click tracking? or does this just open up two side columns with their own template?

great job, its definatly on my site :)

Follow the instructions I sent you via PM, then run this modified .php installer.

I'm glad you like it! As for click tracking, no, not at the moment at least. ;)

Nice. Are there any text block that I can use and turn off or only a (1) template to fill?

I'm not sure I completely understand the question. Yes, you can 'turn off' (disable) blocks. You don't have to have both, you can have either the right or left active if you wish as well as both. Each block is driven by it's own template, so if you use both blocks, then you'll need to fill both templates.

very nice hack! thanks

click tracking and the ability to have different ads in different forums would be great.

The installer worked just fine with no errors but when I try to load Advertisement Column(s) in the settings area it shows no options and nothing to change?

If I try to manually import the settigns to mysql it shows that the records are already in the database as well.

I've still got problems with this, but it's alignment problems now. If I set this up, I've put some PhpAdsNew code in there, and when I go into a forum, it displays fine, but when I open up a thread, it squishes the individual posts a little thinner than normal. I've even removed the code and left the template blank like it was originally and it still does it. Any ideas?

If you select the "Advertisement Column(s)" selection from the dropdown in the AdminCP, you see nothing at all? Do you see text? What? If possible, could you take a screenshot? This is very odd. Also, could you give me a list (in order) of the fields in the 'settings' table? Perhaps yours was modified as well.

Oh, and are you installing this on RC4? (It should work in all versions, but I'm just curious)

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" (yes, just type "auto" into the box [w/o the quotes]).

Let me know if that fixes it. It's not a problem with the hack, it's a tables problem. A few people reported this in Dark_Wizard's hack, too.

Also, make sure you're using the latest IE (if, of course, you're using IE).

LMK.

edit: If you could provide me with a link to view this, I may be able to trace the HTML.

snip

Attached is the screen shots from the admin settings area. I am using rc4 with minimal hacks (I can't think of anything done to settings lately). The settings varname list is in my previous response. Thanks!

Err.. I need the fields list, not the varnames. For example, my fields are "varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile".

From the looks of the screenshot, it's as if the settinggroup is missing.

Run:
[SQL]
SELECT * FROM `settinggroup` WHERE grouptitle = "adcolumn"
[/SQL]

Make sure that returns the adcolumn settinggroup. It's possible your 'displayorder' field isn't set to AUTO INCREMENT. Verify the 'displayorder' field isn't empty for 'adcolumn'. If it is, assign it the next available ID.

+------------+--------------+----------+
| grouptitle | displayorder | volatile |
+------------+--------------+----------+
| adcolumn | 600 | 1 |
+------------+--------------+----------+

Hmm.. so it's not that. How about the field list for the 'settings' table?

The auto setting did not fix the problem. I've attached it below:

What query/data do you want?


Structure for settings table is:


+----------+----------+------------+--------------+------------+--------------+----------+----------+
| varname | value | optioncode | displayorder | grouptitle | defaultvalue | advanced | volatile |
+----------+----------+------------+--------------+------------+--------------+----------+----------+

Ted S,

Ok, I think I know what the problem is. Since you seem to be quite proficient in SQL, perform an uninstall -- of everything SQL related. Then, re-run the attached installer in this thread. That should fix it.

Be sure to let me know if it worked. If it does, I'm going to update the main zip file to include this installer instead.

I'm on my way out but when I return I'll run it and let you know. Thanks!

Drumsy,

Someone else had your same problem with Dark_Wizard's sidebar hack. It must be something with your settings/html. Check this thread for information, perhaps something may help.

You can also try contacting the poster of this thread. He has your exact same problem, perhaps he's fixed it by now and can share how. If you do, I would greatly appreciate you returning to let us know how it was fixed in case others run into this problem.

In the meantime, if you could activate the AdColumn the exact way you have it in your attached screen shot, do a "View Source" and send me it in a .txt file so I can look it over, I would appreciate it. I may be able to track it down from here.

*EDIT: Someone posted this a possible fix, give it a try:

mysql> delete from setting where varname = 'adenable';
Query OK, 1 row affected (0.02 sec)

mysql> delete from setting where varname = 'adleftadleft';
Query OK, 0 rows affected (0.00 sec)
I couldn't wait...

[sql]
delete from setting where varname = 'adright';
delete from setting where varname = 'adleft';
delete from setting where varname = 'adtitleleft';
delete from setting where varname = 'adtitleright';
[/sql]

[sql]INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adenable', 'adcolumn', '1', '1', 'yesno', 10, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adleft', 'adcolumn', '1', '1', 'yesno', 20, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adright', 'adcolumn', '0', '0', 'yesno', 30, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adtitleleft', 'adcolumn', 'Left Column', 'Left Column', '', 40, 0, 1);
INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES('adtitleright', 'adcolumn', 'Right Column', 'Right Column', '', 50, 0, 1);
[/sql]

Results: it all works (so yea, the new installer file did the trick).

Excellent, thanks Ted. I'm updating the .zip as we speak. ;)

Unfortunately that did not work and I do not know what other recourse to take.