So what would I do to correct it?

Do the following SQL statement and i post the output here.
[sql]show create table customprofilepic;[/sql]

Attached.

Can somebody help me reverse the queries. To be honest, I've spent ages on this, installing all the fixes and I still get the same errors. :S

The initial queries are

Thanks, sorry to repost but it is quite urgent.

Hi Guys,
I am still struggling with this hack, but i'm making head way, my latest issue is the error that I am getting when i click on upload picture, below is the error message i receive:

Parse error: parse error, unexpected '{' in /home/naijawor/public_html/includes/functions_upload.php on line 448

can someone please tell me how to fix it, I am not good with this code

Marco, you are the man please help thanks man

i gave up on this hack...i've uninstall it...half of the pictures dont even show up....

Open the file and go to that line. Compare any changes you made to what the instructions say. You probably have a stray bracket that should have been part of the edit.

Okay, so it was working fine, despite the SQL mess up.

Something else happened and I had to start over. I followed the new install without a hitch and left out the default value in the one SQL statement.

Seemed great, I was happy. Wrong. Still bunches of little red x's.

Anything else I can try? I cleared the browser cache and even rebooted the server.

Thanks,

Oops sorry, i missed your reply. Still need help on this?
PS Better send me a PM, or i might miss your reply again.

Has anyone come up with a way of notifying the Admin when a member uploads a pic that needs to be approved?

Is there any way at all to uninstall this???

Ok, I've finally managed to sort it by using phpmyadmin and manually uninstalling each table entry.

Marco, did you get my PM?

Dennis

Anybody?

In admin cp under vb3 gallery "verify pictures" they are all X for some reason. I do have GD2 installed and working fine.

How do I correct this?

Most of us have that problem :(

Mine look like that in album.php as well.

How do I "Run the following queries from PhpMyAdmin"?

sorry, might be a stupid question, but I'm kinda new....THANKS!

when you select your database click on sql : )

I think the only thing wrong with this hack is that the thumb images are not generated. This seems to be due to some issue with the database.

If I read things correctly the thumbs are stored there.

Can't anybody have a look at this and get it fixed? It's a great hack, shame to let it die from something so simple.

Okay, I will PAY to have this hack repaired on my site.

PM me if interested.

Meh. The only use this hack is good for is for making sure your users arent breaking signature rules.

Huh?

Instead of having to rely on moderator/user input about signatures, you can view them all at the same time. That's what i meant.

This hack is for creating a page that shows thunbmails of users profile picture in a photo album format.

It has nothing to do with sigs.

It has both - a photo gallery and a user sig gallery. It has a dropdown that lets you change the view. :)

Yeah, but it's only there to look at them, not to control them.

Unless I seriously missed something.

I know that, but the user profile picture is broken (and going through this thread, you'll see that its broken for a lot of other people too).

Yes signature editing still has to be done thru admincp, but at least with the signature gallery part of this hack, you can quickly view everyone's sigs.

I haven't even looked at that part, I want the photos to work.

And I'm still willing to pay to get it fixed.

A note on the sig gallery feature:

vB doesn't have image checking (but there are hacks for size). It also doesn't control the number of images -- only the character count.

People also have a tendency to hotlink, which we do not allow.

I have sigs turned off for me on my board because many of our users get carried away with them and I don't want to have to scroll an entire screen just to get to the next post.

This allows me to scan sorted by the latest modify date looking for hotlinking and other issues. ;)

BTW -- this hack will not work on vB 3.5 as written. If you are planning to upgrade anytime soon, you may want to hold off and watch for a 3.5 version to be released.

:)

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?