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.

[xug]

Originally Posted by ChuanSE

Your signature script sucks? it displays info we know ^^
kiddo

You're One Smart Kid

But your right, it sucks, time to place a new one since this one is more than a year old.

[xug]

Originally Posted by Live Wire

No, if members want my free hack and my support for a feature that i spent my time on. they can go to my site there selfs. They know where it is and they know how to get it. Clicking on the uninstall button won't hurt my feelings as this thread is pending to me moved to the can.

Live Wire.

My statement was nothing personal (in fact I think your hacks are great), I'm just tired of all these sites that have hacks that let us sign up and a month later they are gone, we have seen enough of that already in the past.

[Logikos]

vBSigHosting is back and has been updated with a small bug fix. New .Zip added and .txt file for upgrade instructions from 1.0.0 to 1.0.1

Next update will be to view the users sigs. The ammount of space it's using in the database, save files a .gif image, and watermark images for images outside of your site.

[InsaneContender]

I get this error message:

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	title = 'Administrators',
	description = '',
	usertitle = 'Administrator',
	opentag = '<i><b>',
	closetag = '</b></i>',
	passwordexpires = '0',
	passwordhistory = '0',
	siguploader = '1',
	siguploadermaxwidth = '500',
	siguploadermaxheight = '150',
	siguploadermaxsize = '524288000',
	arcademinposts = '0',
	arcademintime = '0',
	attachlimit = '0',
	avatarmaxwidth = '100',
	avatarmaxheight = '100',
	avatarmaxsize = '50000',
	profilepicmaxwidth = '100',
	profilepicmaxheight = '100',
	profilepicmaxsize = '65535',
	pmquota = '100',
	pmsendmax = '5',
	forumpermissions = '393215',
	pmpermissions = '3',
	calendarpermissions = '31',
	wolpermissions = '31',
	adminpermissions = '3',
	genericpermissions = '3145663',
	genericoptions = '23',
	arcadepermissions = '31',
	articlepermissions = '4095'
WHERE usergroupid=6
mysql error: Unknown column 'siguploader' in 'field list'

mysql error number: 1054

Date: Monday 04th of October 2004 02:16:55 PM
Script: http://www.communityforums.net/forum.../usergroup.php
Referer:

I followed directions perfectly as well...

[Logikos]

You forgot to run the SQL queries as instructed.

These are the ones you need to run:

[sql]
create table customsiguploader
( userid int unsigned not null default 0
, siguploaderdata mediumtext not null
, dateline int unsigned not null default 0
, filename varchar(100) not null default ''
, visible smallint not null default 1
, filesize int unsigned not null default 0
, primary key (userid)
)
[/sql]

And

[sql]
ALTER TABLE usergroup ADD (
siguploadermaxwidth SMALLINT UNSIGNED NOT NULL DEFAULT '0',
siguploadermaxheight SMALLINT UNSIGNED NOT NULL DEFAULT '0',
siguploadermaxsize INT UNSIGNED NOT NULL DEFAULT '0',
siguploaderpermissions INT(10) UNSIGNED NOT NULL DEFAULT '0'
)
[/sql]

[Blam Forumz]

Installed

[Erwin]

Are you able to make it so that the files are not in the database but in the filesystem?

[Logikos]

Originally Posted by Erwin

Are you able to make it so that the files are not in the database but in the filesystem?

I'm trying to figure out an easy way to do that, but the way i was trying still kept the image in the database. I was just going to use $_SERVER['REQUEST_URI'] to get the full request URI including the userid Then in .htaccess you make the no-extention file sigs be a php file:

<Files sigs>
ForceType application/x-httpd-php
</Files>

And everyone sigs will point to, www.yoursite.com/forums/sigs/1

1 being the userid.

I you can figure out how we can do it to upload to a specific directory that would be great, cause i know you have a huge site, and you need to access the database as less as possilbly.

[Deimos]

I think it's a great hack, keep up the good work Livewire.

[Gemma]

Great Hack *clicks install*