Miscellaneous Hacks - Sidebar Column

Description:
This MOD automatically create a sidebar column on the left or right in your forum.

Features:

• Show only Index or All Pages.
• Choose StyleID, which you want to use for the sidebar.
• User Infomation with Avatar
• Latest Threads
• Poll
• Advertisement
• Partner Links

Info:
Plugins: 3
Phrases: 57
Templates: 17
Settings: 20

Install:

1. Import Product via Manage Products
ACP >> Plugins & Products >> Manage Products >> [Add/Import Product]

Settings:
ACP >> vBulletin Options >> Sidebar Column Settings

History:
v3.8.001 : First Release
v3.8.002 : Add Option for StyleID

PS: Work fine with 3.7.x (Tested)

Thanks to:

• bmckinley
• Alisa Lindsay

Similar Mods:
Sidebar Lastest Threads
Sidebar Poll

[rtyagis]

Reserved for install.

[Lautaro]

I'm having this error:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT threadid, title, dateline, lastpost, visible, open, postusername, postuserid
FROM thread AS thread
WHERE NOT ISNULL(threadid) AND forumid IN () AND visible = '1' AND open!='10'
ORDER BY dateline DESC

LIMIT 0, 5;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND visible = '1' AND open!='10'
ORDER BY dateline DESC

' at line 3
Error Number : 1064
Request Date : Friday, June 5th 2009 @ 05:06:32 AM
Error Date : Friday, June 5th 2009 @ 05:06:32 AM
Script : XXXXXXXXXX
Referrer : XXXXXXX
IP Address : XXXXXXXXXXX
Username : XXXXXX
Classname : vB_Database
MySQL Version : 5.0.67-community

[ry215]

Originally Posted by Lautaro

I'm having this error:

WHERE NOT ISNULL(threadid) AND forumid IN () AND visible = '1' AND open!='10'

Enter forumids in options.

[faraz_9000]

hi
thnx for the great mod
all ok for me but prblm on index page as its showing sidebar at center at the right side as well as left.its not starting from top where navbar ends like on other pages.
please help

[Kottonmouth801]

:up: Kottonmouth801 Marks Installed...!! :up:

:up::up: Mod Of The Month :up::up:


A Mod to Remove the Navbar Login would be great to go along with this....! :up:

Does anyone know of a mod that does this?

[faraz_9000]

Originally Posted by Kottonmouth801

:up: Kottonmouth801 Marks Installed...!! :up:

:up::up: Mod Of The Month :up::up:


A Mod to Remove the Navbar Login would be great to go along with this....! :up:

Does anyone know of a mod that does this?

removing following will do,but make sure to take backup of navbar template in notepad or wordpad

Edit NAVBAR

<!-- login form -->
<form action="login.php?do=login" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, $show[nopasswordempty])">
<script type="text/javascript" src="clientscript/vbulletin_md5.js?v=$vboptions[simpleversion]"></script>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
<tr>
<td class="smallfont" style="white-space: nowrap;"><label for="navbar_username">$vbphrase[username]</label></td>
<td><input type="text" class="bginput" style="font-size: 11px" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
<td class="smallfont" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="103" id="cb_cookieuser_navbar" accesskey="c" />$vbphrase[remember_me]</label></td>
</tr>
<tr>
<td class="smallfont"><label for="navbar_password">$vbphrase[password]</label></td>
<td><input type="password" class="bginput" style="font-size: 11px" name="vb_login_password" id="navbar_password" size="10" tabindex="102" /></td>
<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="104" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
</tr>
</table>
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="securitytoken" value="$bbuserinfo[securitytoken]" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="vb_login_md5password" />
<input type="hidden" name="vb_login_md5password_utf" />
</form>
<!-- / login form -->

[Kottonmouth801]

:up: Thanks....! :up:

That worked Great...!!

[Scovic]

How would I make this mod so that users can collapse it, if required.

[shinng]

installed it and it worked great, but when i made a reply to a post and checked out the sidebar, all of a sudden now there's a horizontal scroll bar. users are now required to scroll horizontally to actually see the sidebar. How do I edit this so that everything fits on one page with no horizontal scroll bar at the bottom?

Edit: sidebar is currently installed, but disabled until I understand how to edit it so there is no horizontal scroll bar at the bottom.

[xplan2007]

Originally Posted by Baigo

Same is happening here, anyone knows how to fix this?

Baigo

Originally Posted by v12kid

go it working but it screws up the alignment of my forums and the chatbox

any idea what to fix?

i fixed it by

edit template>sc_right_top or sc_left_top

remove

width="100%"