I would really like the sig guardian hack to get that one last update the author promised so I can use it and turn on sig img's.

But I only wanted this for the album of profile photos.

I just got mine to work,

But its bringing up users avatars, not profile pics! wtf

The instructions for this hack assume certain things that could cause serious problems for inexperienced users.

First of all, no contingency is made for people using table prefixes.

Number two, in adding table data for phrases, it's assumed that no other phrases have been added and that this data can be added at phraseid 9231.

I only got this hack working after debugging several problems.

Please revise your instructions accordingly.

- Sid

Would really appreciate a 3.5 port. :)

How do you uninstall this?

I dropped "customprofilepic" and then now I get database error when viewing any member profile.

I tried to rerun the queries but I get this:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 ';
ALTER TABLE `customprofilepic` ADD reason varchar(100) not null' at line 1

how do I fix this?

You dropped the whole table? :eek:

That's a default vBulletin table, to which this hack merely added two columns. You should've dropped the columns not the table!

The solution is to create a new version of the table:
[sql]
CREATE TABLE IF NOT EXISTS customprofilepic (
userid int(10) unsigned NOT NULL default '0',
picture_id int(10) unsigned NOT NULL auto_increment,
filedata mediumblob NOT NULL,
thumbnaildata mediumtext NOT NULL,
dateline int(10) unsigned NOT NULL default '0',
filename varchar(100) NOT NULL default '',
comment varchar(255) NOT NULL default '',
visible smallint(6) NOT NULL default '1',
filesize int(10) unsigned NOT NULL default '0',
width smallint(5) unsigned NOT NULL default '0',
height smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (picture_id),
KEY userid (userid)
) TYPE=MyISAM AUTO_INCREMENT=1;
[/sql]

And don't drop tables without checking in future!!!

How do I completley uninstall this thing?

Anyone please help?