Miscellaneous Hacks - vBSigHosting v1.0.1

vBSigHosting v1.0.0

====================
Author: Ken 'LiveWire' Iovino
Site: www.vbhacks.us
Version: 1.0.1
====================

Updates

• Fixed bug with profile pic showing avatar.
  If your using 1.0.0 please read upgrad_from_1.0.0.txt for the bug fixes

What this does
vBSigHosting is a free image hosting hack for remote hosting of signatures for your forums. This will allow members to upload there signature to your site and use it on your site. Each user gets one upload, with a file width, height, and size limit that you specified in the admin cp.

Features:

• Completely Admin CP controlled.
• Turn on/off for diffrent usergroups.
• File sizes, width, and height restrictions (pixels) via ACP.
• One user equals one signature image at a time.
• When user uploads new signature, old signature will erase.
• All images are stored in database.
• And more...

To do list...

• Time to install: 15-20 minutes
• Queries to run: 2
• File Mods: 5
  • /admincp/usergroup.php
  • /includes/init.php
  • /includes/functions_upload.php
  • /forum/profile.php
  • /forum/image.php
• Templates to edit: 1
• Templates to add: 1
• New Phrases: 14

Click It

Please read carefully and make all the necessary changes at stated. This is will work if installed properly. I've tested this hack on 3 diffrent vBulletin boards running version 3.0.0. PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN! If you like this hack, please be kind and click on the "Install" button, i will have some updated versions soon.

Help & Support
Before asking for support Please make sure you have done all necessary changes! If you still need support please post a reply.


Please post bugs and errors here. Hope you like, feedback welcomed.

[csrs]

csrs, what other hacks do you have installed at the moment?

The only other hack I have installed is the arcade mod.

[Logikos]

I'm not to sure then, i personaly would try to reinstall the hack, or at least take your time and go over every bit of code that you need to install from my install.html file. And make sure you save the usergroups. Go to the register usergroup and just set the settings and click save.

[Tru Smiles]

I tried installing this program, but couldn't get it working. So I uninstalled it, and everything was fine. Till I tried to edit a usergroup, and I got this error message:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Guest',
description = '',
usertitle = 'Guest',
opentag = '',
closetag = '',
passwordexpires = '0',
passwordhistory = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '50',
pmsendmax = '0',
forumpermissions = '4103',
pmpermissions = '0',
calendarpermissions = '0',
wolpermissions = '1',
adminpermissions = '0',
genericpermissions = '1',
genericoptions = '8',
journalpermissions = '0',
siguploaderpermissions = '0',
arcadepermissions = '0'
WHERE usergroupid=1
mysql error: Unknown column 'siguploaderpermissions' in 'field list'

mysql error number: 1054

^ Now, I have tried re-installing my forum without the hack ever touching it, but I still get that error. I'm posting it here because of the 'siguploader' thing that I uninstalled. Any idea what could be causing it, so I can go fix the problem? >_>

Thankie!

[Logikos]

You haven't fully uninstalled then, you need to unedit anything in the admincp/usergroup.php that i have had you add. Thats why i tell everyone to backup. Backup the files your going to edit, then install the hack, if the hack don't work, then upload the old files that you backed up and your finished.

Don't know why this isn't working for you, i've installed this hack countless amount of times on friends, and customers websites, and never once had a problem, and i've followed my own instructions.

[Sweet Evil]

In the users CP the upload link is not using my forums style.. and its ugly.. Where is this code so I can fix it? Thanks!

[Tru Smiles]

Originally Posted by Live Wire

You haven't fully uninstalled then, you need to unedit anything in the admincp/usergroup.php that i have had you add. Thats why i tell everyone to backup. Backup the files your going to edit, then install the hack, if the hack don't work, then upload the old files that you backed up and your finished.

Don't know why this isn't working for you, i've installed this hack countless amount of times on friends, and customers websites, and never once had a problem, and i've followed my own instructions.

Thats the thing, I ALWAYS make back ups, and even when uploading them again, I still get this strange My SQL error. I even reinstalled a fresh forum and wiped the database, yet I still got this error. It's mighty strange o_O

[Andrew]

Originally Posted by Tru Smiles

Thats the thing, I ALWAYS make back ups, and even when uploading them again, I still get this strange My SQL error. I even reinstalled a fresh forum and wiped the database, yet I still got this error. It's mighty strange o_O

If thats what you get after installing on a clean database then the database isn't really empty. If you look at what I bolded it still shows the column 'siguploaderpermissions' in the database. Might want to use phpMyAdmin and drop the tables manually to be sure they are completely gone.

[Logikos]

True.Rooster is almost correct. The reason why your getting that error is because you still have code in the usergroup.php file. When you try to save any usergroup, its trying to save the siguploader permissions cause there still code in the usergroup.php file. If you go into phpmyadmin, your not going to find that feild cause it don't exisit.

In usergroup.php Find and Remove:

PHP Code:

, 'siguploader' => 1 


Then Find and remove:

PHP Code:

'siguploadermaxwidth' => 500, 'siguploadermaxheight' => 125, 'siguploadermaxsize' => 25000 


Then find and remove:

PHP Code:

                print_table_header($vbphrase['signature_uploading_permissions']);
                print_yes_no_row($vbphrase['can_upload_signature'], 'usergroup[siguploader]', $ug_bitfield['siguploader']);
                print_input_row($vbphrase['upload_signature_max_width'], 'usergroup[siguploadermaxwidth]', $usergroup['siguploadermaxwidth']);
                print_input_row($vbphrase['upload_signature_max_height'], 'usergroup[siguploadermaxheight]', $usergroup['siguploadermaxheight']);
                print_input_row($vbphrase['upload_signature_max_filesize'] . '<br /><span class="smallfont">1KB = 1024 bytes</span>', 'usergroup[siguploadermaxsize]', $usergroup['siguploadermaxsize']);
                print_table_break(); 


Thats all the code that belongs in usergroup.php to make my hack work. So get rid of it all and it will be fine.

[Sweet Evil]

Originally Posted by Sweet Evil

In the users CP the upload link is not using my forums style.. and its ugly.. Where is this code so I can fix it? Thanks!

Well I changed

PHP Code:

<td class="$navclass[uploadsig]" 


to

PHP Code:

<td class="$navclass[signature]" 


and seems ok now, hopefully this does no effect anything else.

[indie]

Hi:
this looks great!
This thread is huge so please excuse my questions if redundant...

1) Can I pick a certain usergroup that can use this?
2) If i have IMG tags disabled for members in signatures, will it affect this mod? because I'd like to keep that setting off, so only usergroups with this mod can use images (banners)...
3) When is the update mentioned coming

thanks!