AdColumns v1.0

[magnus]

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 https://vborg.vbsupport.ru/ (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=62348)

[Akex]

It seems great :). Good job

[ryancooper]

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

Thansk!!

[magnus]

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.

[PixelFx]

nice :)

[ryancooper]

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.
Awesome!! Installing tonight! Thank You!

[joeychgo]

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?

[magnus]

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.

[joeychgo]

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

[magnus]

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

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.

:)

[joeychgo]

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

[gopherhockey]

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

[magnus]

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.

[joeychgo]

That would be fantastic!

[drumsy]

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

[magnus]

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.

[drumsy]

PMed...

[snyx]

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

[magnus]

PMed...

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

[magnus]

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

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

[gmarik]

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

[magnus]

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.

[riyatch]

very nice hack! thanks

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

[Ted S]

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.

[drumsy]

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?

[magnus]

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.

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)

[magnus]

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?

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.

[Ted S]

snip

[Ted S]

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!

[magnus]

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:

SELECT * FROM `settinggroup` WHERE grouptitle = "adcolumn"


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.

[Ted S]

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

[magnus]

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

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 (https://vborg.vbsupport.ru/showpost.php?p=484627&postcount=19) 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 (https://vborg.vbsupport.ru/showthread.php?t=59781&page=3&pp=15) for information, perhaps something may help.

You can also try contacting the poster of this thread (https://vborg.vbsupport.ru/showpost.php?p=463591&postcount=34). 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...


delete from setting where varname = 'adright';
delete from setting where varname = 'adleft';
delete from setting where varname = 'adtitleleft';
delete from setting where varname = 'adtitleright';


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


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

[magnus]

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]

Drumsy,

Someone else had your same problem with Dark_Wizard's sidebar hack. It must be something with your settings/html. Check this thread (https://vborg.vbsupport.ru/showthread.php?t=59781&page=3&pp=15) for information, perhaps something may help.

You can also try contacting the poster of this thread (https://vborg.vbsupport.ru/showpost.php?p=463591&postcount=34). 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.

[magnus]

Unfortunately that did not work and I do not know what other recourse to take.
If you could give me the source of the page in question, I could check out the HTML. I'm sure it's a simple <table> problem.

I'm betting you're using the default vB Style? (Layout, not colors..)

[adusei]

Hi,
first of all - thx to Magnus: I really appreciate the work you've done! Great hack!

Small problem:
Everything is working proper but - if I enable the RIGHT sidebar, it is only to be seen on all forumdisplay-pages, not on the index-page.
Of course it would be better not only to see the left sidebar (if enabled) on the first page of the board but the right (if enabled) too.

Any help out there?

Best regards and TIA -

adusei

[magnus]

Hi,
first of all - thx to Magnus: I really appreciate the work you've done! Great hack!

Small problem:
Everything is working proper but - if I enable the RIGHT sidebar, it is only to be seen on all forumdisplay-pages, not on the index-page.
Of course it would be better not only to see the left sidebar (if enabled) on the first page of the board but the right (if enabled) too.

Any help out there?

Best regards and TIA -

adusei
adusei, I'm confused. The AdColumns show up on every page that includes $header and $footer. It's impossible for them not to. Could you show screenshots or possibly give me a link to see for myself?

[magnus]

Drumsy,

Ok, I found the culprit. It's a slight glitch with the vB default style.

This line is what is causing the problem:

<div style="padding:0px 25px 0px 25px">


You need to remove, or replace that line with:

<!-- <div style="padding:0px 25px 0px 25px"> -->


Now, I just need to figure out what template that is located in. Check the following templates:

spacer_open
postbit
postbit_legacy

It should be in one of those. ;)

[drumsy]

Ok, so far I've found it in spacer_open only as:

<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

[drumsy]

This does change the layout, even before I enable the AdColumn. Namely, where I used to have some space between the right and left edges of my forums and the edge of the screen, it sits pretty much right on top of it now.

[drumsy]

Ok, I've enabled it, it works fine everywhere, but does it have to be right up on the edge of the screen? Check out www.honda-acura.net/forums as an example.

[adusei]

adusei, I'm confused. The AdColumns show up on every page that includes $header and $footer. It's impossible for them not to. Could you show screenshots or possibly give me a link to see for myself?

I'm sorry to say - but it is like I mentioned before: RIGHT sidebar is not to be seen (to be more precisely: it is to be seen BELOW the "What's up here"-column and on top of the time).
I tested it with Mozilla 1.6 and Opera 7 and IE6 - always the same problem.

A friend tested it with IE5 - and there it s working proper. Since I need the RIGHT sidebar I please need some help. What can be my mistake ?

TIA and best regards,

adusei

P.S.: I installed everything again - same problem LEFT sidebaris ok, RIGHT doesn't appear proper...

[magnus]

adeusi,

In a previous post you said it's working fine on FORUMHOME, but not on your INDEX page, correct? When I checked your site earlier, you have pretty heavily modified INDEX page. I'm sure you've got an open html tag somewhere that's screwing with it. Try running the site url through a HTML validator, it will help you track down the culprit.

If it's working on fORUMHOME fine, logic tells us it's got to be something specific to the INDEX page.

[magnus]

Ok, I've enabled it, it works fine everywhere, but does it have to be right up on the edge of the screen? Check out www.honda-acura.net/forums as an example.
What do you mean by 'right up on the edge of the screen'? I visited the link, and it looks great on my side?

[adusei]

@magnus

Yup - thx for the hint - it's been the forumhome template! Now everthing is working proper!
Thanks for the fine hack again!

Best regards,

adusei

[joeychgo]

Its strange, everything else is fine, but my calander is too wide... Im set to 1050 width and when I enable left column ads (via hack) the calander doesnt adjust.


www.lincolnvscadillac.com

[magnus]

Its strange, everything else is fine, but my calander is too wide... Im set to 1050 width and when I enable left column ads (via hack) the calander doesnt adjust.


www.lincolnvscadillac.com

Odd, but I don't even see a calendar on your FORUMHOME? It has to be a missing HTML tag in the calendar code. If you could enable it, so I could get a look I could probably find the missing tag.

[joeychgo]

Odd, but I don't even see a calendar on your FORUMHOME? It has to be a missing HTML tag in the calendar code. If you could enable it, so I could get a look I could probably find the missing tag.

Calendar is there-- I have the ads turned off though... here is a screenshot. Its taken on my 19" lcd monitor and you can see I have the scrollbar on the bottom

[magnus]

Oh, that problem has been addressed. See this thread (https://vborg.vbsupport.ru/showpost.php?p=484972&postcount=44). The changes you need to make are in the "spacer_open" template.

It's a glitch in the default vB style.

[joeychgo]

nope --- that thread doesnt help -- here is my spaceropen template -- what that thread calls for isnt there or in postbit or postbit_legacy

<!-- open content container -->
<if condition="$show['old_explorer']">
<table cellpadding="0" cellspacing="0" border="0" width="$stylevar[outertablewidth]" align="center"><tr><td class="page" style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">
<else />
<div align="center">
<div class="page" style="width:$stylevar[outerdivwidth]; text-align:$stylevar[left]">
<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">
</if>

[magnus]

Joey, do me a favor. Enable AdColumns, go to your Calendar. Click "View Source", and save the source to a file and give it to me. I can track down what's wrong much easier that way. :)

[joeychgo]

here you go.............its attached

Joey, do me a favor. Enable AdColumns, go to your Calendar. Click "View Source", and save the source to a file and give it to me. I can track down what's wrong much easier that way. :)

[magnus]

here you go.............its attached

Well, I found the problem:


<!-- open content container -->

<div align="center">
<div class="page" style="width:1000px; text-align:left">
<div style="padding:0px 25px 0px 25px">


You need to remove, or comment out:


<div style="padding:0px 25px 0px 25px">


I'm not sure which template this is located in, since you said it's not in spacer_open. Use the template search feature and see what it pulls up. :)

[joeychgo]

I did a template search, no dice----

this is spacer_open

<!-- open content container -->
<if condition="$show['old_explorer']">
<table cellpadding="0" cellspacing="0" border="0" width="$stylevar[outertablewidth]" align="center"><tr><td class="page" style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">
<else />
<div align="center">
<div class="page" style="width:$stylevar[outerdivwidth]; text-align:$stylevar[left]">
<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">
</if>

[magnus]

In spacer_open, comment out:


<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

[joeychgo]

what do you mean --- "comment out" ?

In spacer_open, comment out:


<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

[magnus]

what do you mean --- "comment out" ?

Either delete it, or place "<!--" and "-->" around it, for example:


<!-- <div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px"> -->

[joeychgo]

ok, I commented it out and, well that keeps it from running off the page --

But the forum automatically adjusts size to fit within the size allotted - the members list and calander do not. They stretch so as to be larger then the header. Not running off the page, but not quite right either. any thoughts?

[gc1]

Installed, works perfect on the forums and the vb advanced homepage

[magnus]

ok, I commented it out and, well that keeps it from running off the page --

But the forum automatically adjusts size to fit within the size allotted - the members list and calander do not. They stretch so as to be larger then the header. Not running off the page, but not quite right either. any thoughts?
Could you show me a screenshot, as well as provide the source one more? This is very odd.

[joeychgo]

HEre are some screenshots -- the first 2 are with both left and right turned on and you can see in the first one with forums its fine - but the second one, calander isnt.-- the third on is with only left on showing the same problem

what code do you want?

[magnus]

HEre are some screenshots -- the first 2 are with both left and right turned on and you can see in the first one with forums its fine - but the second one, calander isnt.-- the third on is with only left on showing the same problem


what code do you want?
I'll need two sources. First, your /index.php with both sides enabled. Then your /calendar.php with both sides enabled.

[joeychgo]

here you go. I included member list.php because the calander and memberlist are the ones screwed up. -

[magnus]

here you go. I included member list.php because the calander and memberlist are the ones screwed up. -
Hrm.. I didn't mean I needed your .PHP files. I need the source. I need you to access each of those files/pages in your browser, then View Source and save them to separate files so I can open them on my end and twiddle with the source.

Make sure you have both sidebars enabled when you save the source, as I'll need that code in their, too.

As for the index, I need your forum index. Not vBadvanced index. ;)

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

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]

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

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.

[rocket98]

I've tried various things to get the alignment working on this "NICE Addition"; however I was not able to get that down pat. I have visited some of the sites who have installed this code and each has the same problems noted in previous posts. I looked at the code from a page dump inside Golive and found all ending tags in the footer section Highlighted because each was out of alignment with the remaining code of the page.

Not sure how it can be done but it would be nice if your columns appeared below the Nav bar. That way the nav bar remains sized as intended and content falls below.

See enclosed pic for my suggestion.

Good hack, but it's turned off for now.

[DaveLogic]

Removed old version, tables etc and reinstalled but receive this error when trying to install..

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES(0, 'setting_adright_title', 'Advertisement "Right" Column Active', 5000)

mysql error: Duplicate entry 'setting_adright_title-0-5000' for key 2

mysql error number: 1062

[joeychgo]

i got the exact same thing jsut now!

ok he left out one query -

DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_title' LIMIT 1;

Add that to the list of queries above - and redo them all -- then run the installer ---


See mangus -- IM learning! IM LEARNING!!!!!!!!!! :nervous:

[DaveLogic]

i got the exact same thing jsut now!

ok he left out one query -

DELETE FROM `phrase` WHERE `varname` = 'setting_adleft_title' LIMIT 1;

Add that to the list of queries above - and redo them all -- then run the installer ---


See mangus -- IM learning! IM LEARNING!!!!!!!!!! :nervous:

Many thanks...

[joeychgo]

im amazed at myself for figuring it out LOL

[magnus]

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

Forgive me with terminology ;)

vBulletin 3.0.0

Thanks.
Yes, there should be no problem with vB 3.0.0 "Gold".

[magnus]

I've tried various things to get the alignment working on this "NICE Addition"; however I was not able to get that down pat. I have visited some of the sites who have installed this code and each has the same problems noted in previous posts. I looked at the code from a page dump inside Golive and found all ending tags in the footer section Highlighted because each was out of alignment with the remaining code of the page.

Not sure how it can be done but it would be nice if your columns appeared below the Nav bar. That way the nav bar remains sized as intended and content falls below.

See enclosed pic for my suggestion.

Good hack, but it's turned off for now.
That's the beauty of templates, you can put things wherever you want. Just change the HTML code and place it below $navbar and you're set.

[heynurse]

Magnus,

Unfortunately, this is still not taking care of my spacing problem, thanks for all your help trying to get this figured out. :ermm: I guess I'll keep watching this thread, if anyone figures it out, please let me know what it was to fix it.

Does anyone have this working with proper alignment on a different styles other than the default style?

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.

[pcalloway]

I'm trying to do the edit but I don't find anything like this in my global.php file:

#######################
eval('$header = "' . fetch_template('header') . '";');
#######################

I'm running vBulletin 3.0.0 Release Candidate 3

[magnus]

Magnus,

Unfortunately, this is still not taking care of my spacing problem, thanks for all your help trying to get this figured out. :ermm: I guess I'll keep watching this thread, if anyone figures it out, please let me know what it was to fix it.

Does anyone have this working with proper alignment on a different styles other than the default style?
I don't understand, if I take your showthread.txt output file, modify that line to read width:100%, it works fine. Are you positive you changed it correctly?

[magnus]

I'm trying to do the edit but I don't find anything like this in my global.php file:

#######################
eval('$header = "' . fetch_template('header') . '";');
#######################

I'm running vBulletin 3.0.0 Release Candidate 3
While I haven't personally tested this with RC3, I see no reason for you not to have that line.. after all, without it, you wouldn't have a header. Try searching for just:


$header = "' . fetch_template('header')

[joeychgo]

for what its worth mangus, i have the exact same problem. -- it only seems to be on the thread itself.........

[magnus]

for what its worth mangus, i have the exact same problem. -- it only seems to be on the thread itself.........
joeychgo, apply the same fix used to repair your FORUMHOME when you had this same problem.

[dlam2k]

I use VBB 3.0 Gold version with Xamira style, I don't know why the Ad column doesn't show ! Please help me

My link is http://69.93.39.242/~svbreme/forum/
(Sorry, I'm updating DNS)

[magnus]

I use VBB 3.0 Gold version with Xamira style, I don't know why the Ad column doesn't show ! Please help me

My link is http://69.93.39.242/~svbreme/forum/
(Sorry, I'm updating DNS)
I'm going to go ahead and just guess that you didn't install the templates. Verify they exist, and let me know.

[dlam2k]

I installed.
Please click to my link

[TheMusicMan]

I have vB 3.0 Gold and have installed this without any glitches at all. This is the first Mod/Hack I have tried to install using vB and I must say I am delighted with how easy it was to do.

I have also tested it using phpAdsNew to delivery banners within the new columns... all works just fine. I will be using it on my boards.

I have yet to launch my boards as I currently have a moderately busy phpBB2 forum that I am waiting to migrate across to vB3 - so I am only using them for my learning of vB3 and they really don't look good at all. However, if anyone wants to see, PM me and I will be happy to help.

John

[mantra]

This worked great for me, however, is there anyway you can have it appear only on the forum home page, instead of all pages ??

[Willnot]

Any ideas on how to insert an RSS feed into it?

thx

[magnus]

This worked great for me, however, is there anyway you can have it appear only on the forum home page, instead of all pages ??
Well, with the way it's setup. No. You would have to do a bit of editing.

[magnus]

Any ideas on how to insert an RSS feed into it?

thx
Sure. Go grab a copy of Carp RSS (http://www.geckotribe.com/rss/) and use that. You can assign the output in the PHP include templates, then call it in an AdColumn box. :)

[poliveira]

Although the columns space is visible, none of the content is?

I have not modified the templates, just the default LEFT RIGHT, if I copy out the template content and create a new page the content is visible. On the forums it is not??

Any ideas

[magnus]

Although the columns space is visible, none of the content is?

I have not modified the templates, just the default LEFT RIGHT, if I copy out the template content and create a new page the content is visible. On the forums it is not??

Any ideas
Err.. if you can see the box, you would have to be able to see the content. It's all included in the same template?! Perhaps the font color is set to transparent or equivalent to your background color? Try viewing the source.

[ConqSoft]

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.

Mine's 100% too, and I have the same display issues. :ermm:

[Cyn]

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?

I had a similar problem. In a Reply or post new thread window the smilies were misaligned - sort of pushed into the ad column area and those in that area not visible. I tried all of the suggestions and fixes offered by magnus and nothing worked.

Then, just as a thought, I set viewable smiles to 5 per row and that resolved it. :)

Just thought I'd share my fix for others who may have the problem.

Great hack!!

[joeychgo]

How do I lower the top of the column? I would like the ad column to start below the navbar..................

[magnus]

How do I lower the top of the column? I would like the ad column to start below the navbar..................
Use <br /> before the code.

[joeychgo]

Use <br /> before the code.



I ahve that at the top of the code already. I tried adding several more and while the ad column started lower, the navbar didnt go all the way across - it just left blank space.........


WHat im looking to do is have the navbar all the way across and have the ad column begin even with the block below -- here is what i have now....

[Rick Sample]

Any progress on version two? I'd be willing to be the first to betta test it for ya :)

In either version, will you be able to add links or pics easily or will it be kind of hard? Also, will the colum with be adjustable, and lastly can you add like a few titles. you know like car of the month, then under list the car of the month, the babe of the month, then sponsors.


let me know man, thanks


Edit* also, does anyone have any sample sites of what I'm talking about?

[Steve F]

WHat im looking to do is have the navbar all the way across and have the ad column begin even with the block below .

Yes that is something I would like to see too. Something to do with the header template? The adcolumn code inserted @ the end , maybe it should be included somewhere in between (tables) ?

[Steve F]

Ah sorry for my ignorance, it was discussed a few pages back......

I edited the FORUMHOME template rather than the header and placed the adcolumn code after $navbar.

[Oleks]

Hi,
I have a problem. I can see Right column and table, but can’t see left column.
Just a place for the left column, no table.

Advertisement Column(s), Left and right columns are “Active” though AdminCP > Advertisement Column(s).

Thank you.

[joeychgo]

Ok ---- Google is crabbin that registration pages can be seen with their ads. How do I condition ad colums to not be on such pages?

[Spencer F.]

Does this work for 3.0.1?

[DaveLogic]

I fear not....Just upgraded to 3.01 - totally screwed upmy forum display and the settings in AdminCP have vanished....

[Natch]

Those who are finding that an Upgrade causes settings or templates to disappear,, just make sure that you are NOT inserting your new templates/phrases/settings into the MASTER group - these are there to cascade down into the custom groups etc - and are set back to their defaults each upgrade ... (This rule is especially important if you run with debug on!)

Coders take note - never install any settings into the MASTERs ...

[camauonline1]

How to uninstall Adcolumns ?

[DaveLogic]

Those who are finding that an Upgrade causes settings or templates to disappear,, just make sure that you are NOT inserting your new templates/phrases/settings into the MASTER group - these are there to cascade down into the custom groups etc - and are set back to their defaults each upgrade ... (This rule is especially important if you run with debug on!)

Coders take note - never install any settings into the MASTERs ...

Is there a way to remedy this if this was the case (which I believe is sowith me)...

[lifesourcerec]

The templates are uncached. How do I fix that?

[lifesourcerec]

Actually, is there a way to uninstall it (even from mysql database)? I guess I could open the php file and replace INSERT with DELETE.

[glenvw]

I love this hack.

Can someone tell me how on the forumhome page only though, to get the "What's Going On?" and Forum Contains New Posts, Forum Contains No New Posts, Forum is Closed for Posting , and log out to be full width? It would help clean up my board....

[brahim]

i wanted to ask
is that what if you want two or 3 divided boxes instead of one long one that this hack gives

is it possible

[joeychgo]

Anyone know how to do this??????

Ok ---- Google is crabbin that registration pages can be seen with their ads. How do I condition ad colums to not be on such pages?

[ForYou]

Hello ,

I need to add the AddColum in Showtheard page , How can i do that ,

Regards

[adusei]

Hello ,

I need to add the AddColum in Showtheard page , How can i do that ,

Regards

It is working on showthread! Maybe you'll install it again.

+++++++++++++

One question:

How can I disable the right column on forumhome? I only want the right side to be seen on forumdisplay and showthread. Any ideas?

TIA + regards,

adusei

[Vb-Hispano]

in 3.0.1 no show column

no problem :nervous:

[Spencer F.]

I'd really love this hack to get converted to 3.0.1

[joeychgo]

Just as an FYI - anyone considering installing vBadvanced CMPS, there is a conflit of some type that puts the ad column on the vBadvanced CMPS page as well.

The easiest way to take care of this would probably be with an if condition.
Find the variable or code for the ad column in your footer template and add this before it:

<if condition="THIS_SCRIPT != 'adv_index'">

Then add this after it:

</if>

That should disable the ad column on your homepage.

[pcalloway]

Trying to run the installer, I'm getting:

Database error in vBulletin 3.0.0 Release Candidate 3:

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 17th of May 2004 04:45:55 PM
Script: http://www.authentic-campaigner.com/forum/admincp/install_adcolumns.php
Referer: http://www.authentic-campaigner.com/forum/admincp/install_adcolumns.php

[pcalloway]

Trying to run the installer, I'm getting:

Database error in vBulletin 3.0.0 Release Candidate 3:

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 17th of May 2004 04:45:55 PM
Script: http://www.authentic-campaigner.com/forum/admincp/install_adcolumns.php
Referer: http://www.authentic-campaigner.com/forum/admincp/install_adcolumns.php


Any support on this?

[proxyMX]

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
Can you only make this appear in certain forums?

[joeychgo]

Ok ---- Google is crabbin that registration pages can be seen with their ads. How do I condition ad colums to not be on such pages?



Anyone?????????????

[gc1]

First I want to say thanks, this is a great hack and I put 160 x 600 googleads in the left one and finally the forum pays for itself.

How can I put the latest poll in the other one.....

[Prince]

anyone get this to work on the FORUM HOME page only?

[RUF SS]

Hi guys!

Well, I have a problem. I installed it and all went very smooth so far. I activated it and I got the spaces on the right and left columns. However, it would not display anything!!!!

I am not very good at this I have to admit!

Can someone help? Can someone give me an html example?

Thanks!

[RUF SS]

Ok, all works!

Very nice! :)

[dutchbb]

doesnt work here error during installation:

Database error in vBulletin 3.0.0:

Invalid SQL:
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'settinggroup_adcolumn', 'Advertisement Column(s)', 5000)

mysql error: Duplicate entry 'settinggroup_adcolumn-0-5000' for key 2

mysql error number: 1062

[Vile]

Hack works great, thanks :)

With this, is it possible to add additional columns above or below the left & right?

TIA :)

[AviationForum]

Will the columns stay there throughout the forums, or only at forumhome?

[glenvw]

This is a great hack but I need to uninstall it for the time being.

How do I delete the 2 templates it added?

And I reversed the changes to global.php and the advertisement options still shows up in AdminCP..

[ADDForums]

Hoping that this works with 3.0.1. I've got it installed, however, it's not displaying anything. It does create the tables correctly, and I can turn it on and off. Can someone please provide guidance with this one?

[YabbaDabba]

Neat hack. It works on a vB 3.0.1 test install.

Wish List:
1 - Unique columns for each (sub)-forum
2 - Multiple content blocks per column
3 - Admin controls to manage above

Appears to be an abandoned hack at this point.
Oh well . . .

[DeeperImage]

I love this hack. I recently upgraded to vb3.0.3 and it is not working anymore. All the custom templates are there, all the code in header and footer are there. Also in global.php. What am I missing? someone help please. I went into vbulletin options under Admincp and the advertising columns is also there but it is blank. How do I fix this? Thanks.

[Smitty]

Neat hack. It works on a vB 3.0.1 test install.

Wish List:
1 - Unique columns for each (sub)-forum
2 - Multiple content blocks per column
3 - Admin controls to manage above

Appears to be an abandoned hack at this point.
Oh well . . .
So it sometimes goes... Nice hack - 2.0 sounded like it would really be nice.

[DeeperImage]

I love this hack. I recently upgraded to vb3.0.3 and it is not working anymore. All the custom templates are there, all the code in header and footer are there. Also in global.php. What am I missing? someone help please. I went into vbulletin options under Admincp and the advertising columns is also there but it is blank. How do I fix this? Thanks.

NE body have any suggestions??

[DeeperImage]

When I try to re-run the install script I get the following Error..Cmon someone help me out.

Database error in vBulletin 3.0.3:

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: Friday 09th of July 2004 04:42:53 PM
Script: ****/******/*****/*****/********/*******/******
Referer:
Username: ************
IP Address: ***.***.***.***


How can I remove the previous install in the db so that i can redo it?

[resellertalk]

What file do you use or should I say "Where" do you add your HTML for banners and other functions

[DeeperImage]

What file do you use or should I say "Where" do you add your HTML for banners and other functions

It creates two templates for you. Right and left adcolumn. You go in there and add all your code. Really easy.

[Smitty]

When I try to re-run the install script I get the following Error..Cmon someone help me out.

How can I remove the previous install in the db so that i can redo it?
I think you can just drop the extra tables with something like phpMyAdmin.

[DeeperImage]

I think you can just drop the extra tables with something like phpMyAdmin.

I'd be too afraid to mess something up. I went in there and see a couple of templates that have the adcolumn code in it. but don't know enough to know what remove or fix to make them work again.. :o

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

[resellertalk]

I have tried over and over to make changes to the template and my chnges never show... ANy suggestions... This is the default left column template..

<br />
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center">
<tr>
<td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" style="width:100%">
<tr align="center">
<td class="tcat"><span class="smallfont"><b>$vboptions[adtitleleft]</b></span></td>
</tr>
<tr>
<td class="alt1" align="center">LEFT</td>
TEST TEST TEST SHOW TEXT

</tr>
</table>
</td>
</tr>
</table>
<br />

[resellertalk]

I have also just tried regular HTML:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<p>this is a test</p>
<p>&nbsp;</p>
</body>
</html>

And still nothing shows up, what am I doing wrong

[DeeperImage]

Reseller I wish I could help. I am in dire need of help my self. I need to get this running asap, for I have several paying sponsors.. I just need to know how to completely remove it so that I can re run the install script.. That is all.

[DeeperImage]

I have also just tried regular HTML:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<p>this is a test</p>
<p>&nbsp;</p>
</body>
</html>


And still nothing shows up, what am I doing wrong
Stupid question, but did you save the settings under vbulletin options/ Adcolumn settings? So that it displays ? Make sure its turned on..

[DeeperImage]

I will paypal someone 5 dollars in they can help me fix this.. :devious:

[resellertalk]

Yes, I do have this on... :)

[DeeperImage]

Yes, I do have this on... :)
Hmmm. Wish I knew what I was doing so I could fix your issue and mine also.. Cmon people, someone out there have a hart... Help some brothas out.. :squareeyed:

[DeeperImage]

I'll paypal you $25 if you help me fix it.. cmon people.

[glenvw]

Not sure if anyone has played with the layout but my experience is whenever you add a left (or right) hand column to the forums board for ads, etc, the main board gets skewed in it's appearance. Especially if you have good descriptions of the individal forums. Things get skrunched and off kilter. Anyone come up with just the right adjustmenst so as not to lose info but make it look good?



If yes, can you post your site and how you did it?

I optimize for 800x600

[manguish]

By doing the following :

Set Main Table Width to 100% in stylevars
Set Message Area Width to auto in stylevars

Comment out :

<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

In spacer_open

And job should be a good un ;)

[glenvw]

By doing the following :

Set Main Table Width to 100% in stylevars
Set Message Area Width to auto in stylevars

Comment out :

<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

In spacer_open

And job should be a good un ;)

My message width says "540" Do I just type in "auto" ?

[glenvw]

By doing the following :

Set Main Table Width to 100% in stylevars
Set Message Area Width to auto in stylevars

Comment out :

<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

In spacer_open

And job should be a good un ;)

I forgot to add, the only real page that presents a problem is "forumhome".
Is this what your fix addresses?

[manguish]

My message width says "540" Do I just type in "auto" ?

Yup......

[manguish]

I forgot to add, the only real page that presents a problem is "forumhome".
Is this what your fix addresses?

I had problems with thread display - this should sort out any problems tho......

Try it - you can always change it back ;)

[CMachuca]

Thanks, very useful addon. Will install.

[glenvw]

I had this hack installed earlier but after upgrading to 3.03 it disappeared so I never messed with it.

Now I re-installed it and get this error:

Database error in vBulletin 3.0.3:

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

mysql error: Duplicate entry 'adcolumn' for key 1

mysql error number: 1062

Date: Tuesday 27th of July 2004 12:03:05 PM
Script: http://www.MYSITENAME.com/forums/admincp/install_adcolumns.php
Referer:
Username: My USer Name
IP Address: removed


==

Can you help me out please?

I went ahead and installed everything and i the Vbulletin Options, the option to turn the column ads on or off are missing

[CMachuca]

That's because your database already has that code inserted

[glenvw]

That's because your database already has that code inserted

Right but it apparently has made it so the install does not work.

Attached is an image. Notice I have no choices in the drop down menu.

[glenvw]

Can anyone help me?

[Cyn]

Same problem here that glenvw has. :(

[glenvw]

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 (https://vborg.vbsupport.ru/showpost.php?p=484627&postcount=19) 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.


Personally, I am NOT proficient.

I need someone to tell me how to uninstall this thing so I can try a re-install.

Somene please read the couple of previous posts and send HELP!

[YogiTW]

I would like to request a feature. Being able to specify ads and ad types on a per-forum basis.

[The Realist]

Done all the below and it still throws my forums out. If I use auto in the stylevars it throws my reply box out as well.

There has to be a fix for this?



By doing the following :

Set Main Table Width to 100% in stylevars
Set Message Area Width to auto in stylevars

Comment out :

<div style="padding:0px $stylevar[spacersize]px 0px $stylevar[spacersize]px">

In spacer_open

And job should be a good un ;)

[Dead End Society]

So if we are running a default theme that was just edited, we will have problems and have to make some changes?

[Gastongr]

How can i unistall this hack?
it works for me, but the menu is out of the main template table. (i'm not using the defaul template)

[RetroDreams]

Anyone running 3.0.3 that has this working? Maybe this should be asked first, then you'll know if it is compatible.

I know they changed quite a bit in 3.0.3, so that may be the issue rather then the code. You will most likely have to re-enter the date into the files in question (your db and templates should be fine).

[fiber1]

Works fine in 3.03

[dutchbb]

Just a tip:

To get the width right (same as other tables), you have to set cellspacing from 7 to "0" in the forumhome part. (2 times for each column)

And in forumhome template add this

<td>&nbsp;</td>

after this

<if condition="$vboptions[adenable]==1"> (2 times for each column)

It looks mutch better that way :)

[scottct1]

I have Google yelling at my because their ads are being showing on the registration and login pages.

I don't want to get removed from google, any ideas?

[pcalloway]

Installed this just as described and I get no ad columns anywhere. Doesn't look like I did anything.

Paul Calloway
www.authentic-campaigner.com

[kall]

I have Google yelling at my because their ads are being showing on the registration and login pages.

I don't want to get removed from google, any ideas?
Add:


<if condition="THIS_SCRIPT != 'register' AND THIS_SCRIPT != 'login'">


in both the header and footer code inserts. Add the </if> at the end of the inserts.

No more columns on those pages.

[kall]

Installed this just as described and I get no ad columns anywhere. Doesn't look like I did anything.

Paul Calloway
www.authentic-campaigner.com
Have you uploaded your changed global.php?

If so, the other first place to check is your Default Template. That is where the templates get installed to.

If that one is not set to your parent-most style, the child styles won't get the templates.

[dave6901_2000]

question i have this installed also with vbadvanced is there any way to stop it from showing on the main page as well as the forums index??

[italks]

hey does it works with vbulletin lastest version 3.0.3

[Super Ted]

Yes.

[Ganon]

For some reason I'm getting blank columns with no headers at all when I install this. I know I followed the instructions correctly. The install thing never did create the adcolumn_left and adcolumn_right templates for me, so is it possible that it never ran the database queries either?

[Super Ted]

I had the same problem.

Within the global.php where you added the 2 lines. Re-type them.

[Ganon]

Actually, I was stupid. I edited the global.php file just fine and just forgot to upload the modified file. It's fine now, but thanks.

[Neutral Singh]

Awesome Magnus !!! I am already your big fan ;)

[DoKoK]

Can you add more "boxes"

For example I want 3 of them on the left.

One for Sponsors, one for Google Ads, one for some random banners.

How would i go about addind 2 extra ones?

[etaslim]

For some reason I'm getting blank columns with no headers at all when I install this. I know I followed the instructions correctly. The install thing never did create the adcolumn_left and adcolumn_right templates for me, so is it possible that it never ran the database queries either?

Exactly the same problem here. I'm using VB 3.0.3 & did make sure that the global.php that I uploaded is the correct one. The option appears in the vBulletin Options but nothing showed up. Any help? Thanks in advance

[Super Ted]

Do what I said above and it will work!

[Justin XBLN]

Hey guys, I installed this mod and everything was working great until I went to my threads... the content was all pushed out to the sides and i'm not sure how to fix it.

Can anyone help me out? :)

Thanks,

Justin

[etaslim]

Do what I said above and it will work!

Thanks Super Ted. The columns do appear now. As for the templates, I found them in my other sytle. Appearently not all styles are updated.

[Justin XBLN]

Hey guys, I installed this mod and everything was working great until I went to my threads... the content was all pushed out to the sides and i'm not sure how to fix it.

Can anyone help me out? :)

Thanks,

Justin

I know it's only been a day, but I need help soon! :nervous:

Please reply back if you can help solve my problem.

Thanks

[seangworld]

hey, i just installed this and it was easy and looked nice.
only thing is i have vbadvanced installed as well and i don't need 5 columns on my homepage.

how do i make it so it only affects my forum and not my homepage too?

[nansy]

HI EVRY BODY

I TRY BUT What's Going On? members AND guests IN THE LEFT colums
but notwork can any body help me thank you

sory i can write well english !
i am from chaina :nervous:

[CostaRicaForums]

Sorry, but couldn't have it to work and had to uninstall it. :ermm:

I was having the same problem that Justin XBLN was.

I installed instead the Left Sidebar on all pages (https://vborg.vbsupport.ru/showthread.php?t=59781) mod. Doesn't have a control window, but serves the same function and seems simpler to me.

Anyway, this one is a good one for those that were able to put it to work.

Thank you for sharing it. :up:

[Claudia99]

Hi,

I've an vBulletin 3.0.3 and a gallery (PhotoPost). In my Forum-Homepage "Ad Columns" works fine - but in the gallery is the table not in the right place.

I use in PhotoPost the same stylesheets and templates like in vBulletin.

To better understandig my problem I've 2 screenshots. On the first is my forum, on the second my gallery - and there is the problem.

Has anyone a idea?

Greetings

Claudia

[inverted]

hey, i just installed this and it was easy and looked nice.
only thing is i have vbadvanced installed as well and i don't need 5 columns on my homepage.

how do i make it so it only affects my forum and not my homepage too?


i got this problem too. any advice on how to fix it?

also, i know it's been asked before, but i don't know how long ago it was addressed: when is v2.0 comign out? should we expect it soon? (my schedule is hectic as well, so i understand that things get stressful, sorry if i sound annoying by asking)

- inverted

[kristian]

Installed - nice, does what it said on the tin... :squareeyed:

Anyone know how I can make the columns only show on 'forumdisplay'?

[fpouk]

anyway of making the sidebar unviewable to some membergroups such as VIP Group?

[brianj]

Ok, got it all installed and the column shows up exactly where I need it...now where in the code do I stick my code for the banner exactly?

[brianj]

It creates two templates for you. Right and left adcolumn. You go in there and add all your code. Really easy.

When I expand anything under adcolmn and select...i get the basic control panel for it...no right or left templates

Ok...found the problem..had to do with me using the default vB design instead of my installed green...made the green default, then deleted default and re-installed adcolumn..works fine now. Thanks for all the help on this! :classic:

[Ledfish]

I installed this hack and everything went smoothly, except when I go into "options>>Advertisment Column" and select "yes" for left column and then save changes, I get nothing on my forum pages. The space is there, but nothing displays, not even the title entered under the options section. The right side works fine! I have rechecked everything and can't seem to find anything I did wrong when installing it. I'm not a PHP wiz, but I can follow directions carefully.

I'm using VB 3.0.3 and the default templates/styles that came with VB 3.0.3

Anybody able to help me figure out what the problem is ?

[yinyang]

How many queries does this add to the forum index page?

[arun]

Has anyone tried this with version 3.0.4? Let me know. Thanks.

[Atsuko]

Hello!
I have installed, and the forumhomepage, and forumdesplay work well,
but the threddesplay is not shown as I wanted to show it.
The width is not right width.

How can I change it?

Thank you.

[TORON]

hey, i just installed this and it was easy and looked nice.
only thing is i have vbadvanced installed as well and i don't need 5 columns on my homepage.

how do i make it so it only affects my forum and not my homepage too?

Did you ever figure this one out? I am also using Vbadbanced and with to install this hack but not if it will change that page.

[joeychgo]

Good question - I dot have this installed on my new forum because of this - it didnt affect my old forum for some reason -

[rex_b]

Ah sorry for my ignorance, it was discussed a few pages back......

I edited the FORUMHOME template rather than the header and placed the adcolumn code after $navbar.


THANK YOU!!!!!! THANKKKUUUUUUUUUUUUUUUUUUUUU!!!

[Richard Tafoya]

Does anyone have this working in 3.0.5?

[Glenn379]

How about 3.0.6? I can't find the

eval('$header = "' . fetch_template('header') . '";');

so I can't do any of these sidebar type deals which I want. :( help please.

[DavidL]

How about 3.0.6? I can't find the

eval('$header = "' . fetch_template('header') . '";');

so I can't do any of these sidebar type deals which I want. :( help please.
Same here.
* DavidL waits to click install
3.0.6 anybody?

[calvinnguyen]

How about 3.0.6? I can't find the

eval('$header = "' . fetch_template('header') . '";');

so I can't do any of these sidebar type deals which I want. :( help please.

are you sure you can't find it?

It is second line under:
// parse headinclude, header & footer

[Glenn379]

I'm gonna try it again *sigh*

[Enajizer]

Did you ever figure this one out? I am also using Vbadbanced and with to install this hack but not if it will change that page.

Here is how I did it, not too sure if it's the "correct" way or not, but it works for me. :nervous:

I added another "if" (colored in green) to the header template addon. So this is what the added section looks like on my header template....

<!-- BEGIN AdColumns -->
<if condition="THIS_SCRIPT == 'index'">
<if condition="$vboptions[adenable]==1">
<table width="$stylevar[tablewidth]" cellpadding="0" cellspacing="7" border="0">
<tr>
<if condition="$vboptions[adleft]==1">
<td style="width:150px" valign="top">$adcolumn_left</td>
</if>
<td valign="top">
<table width="$stylevar[tablewidth]" cellpadding="0" cellspacing="0" border="0">
<tr>
<td style="width:100%">
</if>
</if>
<!-- END AdColumns -->

Hope this may help others with vbadvanced....

And yes this does work on 3.06!

[Glenn379]

yeah it works. SOrry I got it the same night I said the last reply. The common mistake might be which file to edit; in the admin cp or root. That was my problem, even though its kind of a stupid problem to have had. O_O; Anyway, thanks.

[junkiesnetwork]

I can't get it working.. it all installs right, but doesn't show up anywhere on my forum..

[kewl1uk]

Clicks install.

But putting the side-bar on all pages tends to slow down the loading of some pages, especially showthread, so a good case for just including it on forumhome. I followed the instructions elsewhere in this thread to put the code intended for the header below $navbar and the code intended for the footer above $footer in the forumhome template. The sidebar could additionally be added to other pages in the same way by editing their respective templates. The bonus is that the navbar is full width.

[ThePimp]

I had a previous install of this hack, and had to upgrade vB to 3.07. The adcolumns aren't working now, and I was wondering how to "Uninstall" it so I can reinstall it clean?

EDIT: I only need to know how to unintsall it from the database.

[RichieBoy67]

This works great for me but can somebody please just tell me where exaclty I paste the google code??

I had it where I thought it went but it was out of align. When I added the <center> </center> the ads stopped working... I just need to know where in this code the template to put the code... this should be easy...

where do I paste it??

Thanks,

Great Hack by the way!!

[elastomaniac]

everything is working great except after i installed the Microstats hack i noticed this:

Page generated in 0.17158 seconds with 9 queries (2 queries for uncached templates)
Uncached templates: adcolumn_left (1)
Uncached templates: adcolumn_right (1)

Im guessing that uncached templates are a bad thing for performance. How would i go about getting the adcolumn templates to be cached like all the other templates? I wont be editing them anymore so they may aswell be cached?

[Super Ted]

I had a previous install of this hack, and had to upgrade vB to 3.07. The adcolumns aren't working now, and I was wondering how to "Uninstall" it so I can reinstall it clean?

EDIT: I only need to know how to unintsall it from the database.

Did you sort this?

I had to go through and remove all entries in the db from the old install and re-run.

[amity]

hi, trying to install and looked for all of the 'fetch' lines, but there is not one in my global.php with

eval('$header = "' . fetch_template('header') . '";');

could someone help with vBulletin 3.0.7 version?

Thanks so much!!

[amity]

oh god, i am a doofus. i was trying to edit admincp.

[kobescoresagain]

I was going ot do this. But in my global.php file I didn't have the very first thing that I had to change. I am running version 3.0.6 Would that be the reason? Thanks

[Marco van Herwaarden]

The line still exist in 3.0.7, didn't check 3.0.6 but it should be there.

Which global.php did you edit? in your root folder or in admincp, you should edit the one in the forum root.

[lasto]

on default skin of vb3.07 this installs fine.On my other skin it simply wont show - hav done the template edits and double checked they are there but it wont show at all.
Do notice it has pushed the board a bit to the left but thats about it - No box at all.

Also as reported before there is 2 uncached templates in this hack as well.

[brianj]

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/admincp/install_adcolumns.php
Referer: http://www.webmastershelp.com/admincp/install_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/attachment.php?attachmentid=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

[n_wattam]

think i may have fixed it

kiteforums.net

[n_wattam]

I've just finished modding my script now, to include TOP & BOTTOM ad locations. These can be changed just like the left and right ones.

Also tidyed up the layout to make it look nicer

http://www.kiteforums.net/index.php?

working example..

I have the top, bottom and left activated on mine

[[Stryder]]

]i can't get anything to show up inside the colum, i was trying to use this code:

<tr><td class="thead" colspan="2"><a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_stats')"><img id="collapseimg_forumhome_stats" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase></td></tr></tbody><tbody id="collapseobj_forumhome_stats" style="$vbcollapse[collapseobj_forumhome_stats]">
<tr><td class="alt2"><img src="$stylevar[imgdir_misc]/stats.gif" alt="<phrase 1="$vboptions[bbtitle]">$vbphrase[x_statistics]</phrase>" border="0" /></td><td class="alt1" width="100%"><div class="smallfont">
<div>$vbphrase[threads]: $totalthreads, $vbphrase[posts]: $totalposts, $vbphrase[members]: $numbermembers</div>
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
</div></td></tr></tbody><tr> <td class="thead"><b>Upcoming PPV Coverage</b></td> </tr> </tbody> <tbody> <tr> <td class="alt1" width="100%"> <div class="smallfont"> <div align="left"><strong>ECW ONE NIGHT STAND</font>:</strong> Remember, <a href="http://www.lndforums.com" target="_blank">www.lndforums.com</a> will be providing free, live coverage of this WWE Pay-Per-View event on June 12th.</div> </div> </td> </tr> </tbody> <tbody> <tr> <td class="thead"><b>Miscellaneous</b></td> </tr> </tbody> <tbody> <tr> <td class="alt1" width="100%"> <div class="smallfont"> <!----Set site as homepage script----------
By Ryan Gravener (ryangravener@hotmail.com)
Permission granted to Dynamicdrive.com
to include script in it's archive
For full source code, installation instructions,
100's more DHTML scripts, visit http://dynamicdrive.com
-------------------------------------------> <div align="left"> <div class="smallfont">
: <A STYLE="behavior: url(#default#homepage); cursor: hand" ONCLICK="this.style.behavior='url(#default#homepage)';this. setHomePage('http://www.lndforums.com');" href><b><U>Home Page</U></b></A> <br>
: <A HREF="javascript:window.external.AddFavorite('http://www.lndforums.com', 'LND Forums.com')"><b>Bookmark Us</b></A> <br>
: <A HREF="http://www.lndwrestling.com" target="_blank"><b>LND Wrestling</b></A> <br>
: <A HREF="http://www.lndforums.com" target="_blank"><b>LND Forums</b></A> <br>
: <A HREF="webmaster@lndforums.com"><b>Contact Us</b></A> </div> </div> </td> </tr> </tbody> <tbody> <tr> <td class="thead"> <b>Advertisement</b></td> </tr> </tbody> <tbody> <tr> <td class="alt1" width="100%"> <div class="smallfont"> <div align="center"><strong>Click The Ads To Make The Site Money></strong></a><br><br> <SCRIPT LANGUAGE="JavaScript"> <!--
now = new Date();
random = now.getTime();
site = "http://custom2.hurricanedigitalmedia.com";
target = "/site=weforums.com/area=bottom/generic=Sports/sitecategory=Sports";
document.write('<IFRAME SRC="' + site + '/hserver/acc_random=' + random + target + '"');
document.write(' NORESIZE SCROLLING=NO HSPACE=0 VSPACE=0 FRAMEBORDER=0 MARGINHEIGHT=0 MARGINWIDTH=0 WIDTH=160 HEIGHT=600 allowtransparency="true" background-color="transparent">');
document.write('<SCR');
document.write('IPT SRC="' + site + '/jnserver/acc_random=' + random + target + '">');
document.write('</SCR');
document.write('IPT>');
document.write('</IFRAME>');
//--> </SCRIPT> <NOSCRIPT> <A HREF="http://custom2.hurricanedigitalmedia.com/adclick/site=weforums.com/area=bottom/generic=Sports/sitecategory=Sports"> <IMG SRC="http://custom2.hurricanedigitalmedia.com/nserver/site=weforums.com/area=bottom/generic=Sports/sitecategory=Sports"> </A> </NOSCRIPT> </div> </td> </tr> </tbody> </table> </td> </tr> </table> <p align=center> <SCRIPT LANGUAGE="JavaScript"> <!--
now = new Date();
random = now.getTime();
site = "http://custom3.hurricanedigitalmedia.com";
target = "/site=weforums.com/area=middle/generic=Sports/sitecategory=Sports";
document.write('<IFRAME SRC="' + site + '/hserver/acc_random=' + random + target + '"');
document.write(' NORESIZE SCROLLING=NO HSPACE=0 VSPACE=0 FRAMEBORDER=0 MARGINHEIGHT=0 MARGINWIDTH=0 WIDTH=300 HEIGHT=250 allowtransparency="true" background-color="transparent">');
document.write('<SCR');
document.write('IPT SRC="' + site + '/jnserver/acc_random=' + random + target + '">');
document.write('</SCR');
document.write('IPT>');
document.write('</IFRAME>');

[xtreme-mobile]

is there any way i can make this hack work so it only displays the left ad coloum on the forum home and not in every thread etc

as its making my thread pages go all out size with browser screen

many thanks

dean

[n_wattam]

yeah thats what i origonaly did, for the same reason

[xtreme-mobile]

any one?

ive seen it done on another forum where the colum is only visible on the proper forum homepage, it does not display when you go into a thread etc

does anyone know how to do this?

[mobillica]

Hi Anyone know how to divide the ad column so you have more than one adcolumn down the left hand side?

[n_wattam]

you mean like mine :D

http://www.kiteforums.net

[kungen]

Looks great, can you share the modifications you done? would really like to get the same adcolumn layout as yours.

you mean like mine :D

http://www.kiteforums.net

[mattyk72]

Is there a solution for the uncached templates??