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

[Ted S]

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

[magnus]

Originally Posted by Ted S

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

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

[drumsy]

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

[Ted S]

Originally Posted by magnus

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

What query/data do you want?


Structure for settings table is:


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

[magnus]

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.

[Ted S]

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

[magnus]

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:

In SHOWTHREAD template, find:

<!-- / toolbar -->

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

and delete the $spacer_close text

[Ted S]

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).

[magnus]

Originally Posted by Ted S

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

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

[drumsy]

Originally Posted by magnus

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:

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