Profile Enhancements - Advanced Userbars Hack v1.0

ADVANCED USERBARS HACK for vBulletin 3.6.x BY HASANN


What does it?: This hacks allows you to upload, add, manage userbars in cats with usergroup permissions. And show your selected userbars in Memberinfo/Userinfo Profile

Installation:

1. ->Install product_userbars.xml
2. ->Upload all files (userbar images, bitfield xml, cpnav xml)
3. ->CHMOD 777 ./images/userbars/
4. ->rebuild bitfields
5. ->set usergroup permissions : UserGroups > Userbar permissions > Can have a Userbar? > Yes and Save
6. ->Do file edits
7. ->Do template edits
8. ->Show your support click "Mark As Installed", nominate for MOTM, rate this modification, and/or donate.

____________________________
FILE EDITS (4 edits in 1 file)

____________________________
OPEN admincp/image.php


(1)
FIND :
-----------

PHP Code:

case 'smilie':
    $itemtype = 'smilie';
    $itemtypeplural = 'smilies';
    $catid = 3;
    break; 


----------
ADD BELOW:
----------

PHP Code:

case 'userbar':
    $itemtype = 'userbar';
    $itemtypeplural = 'userbars';
    $catid = 4;
    break; 


----------

(2)
FIND:
----------

PHP Code:

$tables = array('avatar' => $vbphrase['avatar'], 'icon' => $vbphrase['post_icon'], 'smilie' => $vbphrase['smilie']); 


---------
REPLACE WITH:
----------

PHP Code:

$tables = array('avatar' => $vbphrase['avatar'], 'icon' => $vbphrase['post_icon'], 'smilie' => $vbphrase['smilie'], 'userbar' => $vbphrase['userbar']); 


----------

(3)
FIND:
----------

PHP Code:

'avatarid' => TYPE_INT,
'iconid'   => TYPE_INT,
'smilieid' => TYPE_INT, 


----------
ADD BELOW:
----------

PHP Code:

'userbarid' => TYPE_INT, 


----------

(4)
FIND:
----------

PHP Code:

if ($vbulletin->GPC['avatarid'])
{
    $id = $vbulletin->GPC['avatarid'];
}
else if ($vbulletin->GPC['iconid'])
{
    $id = $vbulletin->GPC['iconid'];
}
else if ($vbulletin->GPC['smilieid'])
{
    $id = $vbulletin->GPC['smilieid'];
} 


----------
ADD BELOW:
----------

PHP Code:

else if ($vbulletin->GPC['userbarid'])
{
    $id = $vbulletin->GPC['userbarid'];
} 


----------

Save & Close





_________________________
Template Edits (2)
_________________________


OPEN MEMBERINFO TEMPLATE



FIND:
------------------------------------------------------------

			<if condition="$show['usernotes']">

------------------------------------------------------------


ADD ABOVE:
-----------------------------------------------------------

<if condition="$userinfo[userbar]">
<fieldset><legend>$userinfo[username]-s Userbar:</legend><table><tr><td>
<b>$userbar[title]</b>
<img src="$userbar[userbarpath]" border="0">
</td></tr>
</table></fieldset>
</if>

-----------------------------------------------------------
Save & Close






OPEN USERCP_SHELL TEMPLATE AND FIND:
----------------------------------------------------------

<if condition="$show['siglink']">
            <tr>
              <td class="$navclass[signature]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td>
            </tr>
          </if>

-----------------------------------------------------------



ADD BELOW:
-----------------------------------------------------------

<tr>
	<td class="alt2" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=selectuserbar">$vbphrase[select_userbar_picture]</a></td>
</tr>

------------------------------------------------------------
Save & Close

Also You Can Find Userbars From www.userbars.be
Enjoy & Don't forget to click install.

[DevinM]

Yeah thats what I am waiting for, ill have this hack shutoff till then.

[devilsmania]

agree, waiting the upgrade for postbit
thanks

[Reeve of shinra]

I really like this! I hope you can pull out a postbit update. Im going to use this one for now

[TechDawg]

I like this hack alot, and also would really like to see a postbit option.

However, the reason for my post is that I'm getting an odd Database error, that seems to be associated with this particular hack. I'm hoping you'll have some idea of what to do.

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT * FROM vb_userbar WHERE imagecategoryid !=(11,12,13) ORDER BY displayorder ASC;

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 '12,13) ORDER BY displayorder ASC' at line 1
Error Number : 1064

Date         : Saturday, May 5th 2007 @ 11:54:14 PM

Script       : http://www.iridethelines.com/forums/...=selectuserbar

Referrer     : http://www.iridethelines.com/forums/private.php

Any Insight would be greatly appreciated.

Thanks,

TechDawg

[DevinM]

Sadly this hack isnt supported and doesnt appear there will be any updates.

Hopefully someone picks it up.

[o0Hubba0o]

Originally Posted by DevinM

Sadly this hack isnt supported and doesnt appear there will be any updates.

Hopefully someone picks it up.

Yeah that's too bad, I'm looking into the codes but it's all still very foreign to me. But this might be a good one to start getting practice on, if I do happen to figure something out I'll get permission from the creator to post a new version.........but don't hold your breath lol. Chances are better of someone else figuring it out first heh.

[nickypoooo]

Marked Installed, Thank you.

I do have one big problem and hope that you can help me - I get this error message -

"Invalid Table Specified" when getting in to admincp --- Userbars I can not modify images or upload new one (userbars work fine in usr CP and i can add images)

Attachment 69532

Do you have an idea?

Thank you

[nickypoooo]

I got it fixed Thanks...

[Clanwebmaster]

is there any way to make it so it add's the user bar it adds it to there sig?

[nickypoooo]

Great plug-in.
I am having a very strange problem with it- works fine only for site admin but all other users get "database error"

Attachment 70524

I can not find how to fix my problem, please help.

Using Vb 3.6.8

Thank you