[ecarabin]

Hi all, here's my first post.

Thanx for this hack. ^_^

I'm trying to install it on my board, and it seems to work. ( I installed the fixed version for 3.0.3 )
The queries were successfully executed, the first look at the album was ok ...

But I have some troubles

* In the Admincp, I just get red crosses for new picture profiles that have to be approved

* In the album, some of new pictures are ok, but some just show red crosses. I dont really understand.

* When I try type2 ( should show signatures ) I get this error

Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT user.userid, user.username, user.usergroupid,
		user.usertitle, usertextfield.signature, usertextfield.sigdateline, 
		avatar.avatarpath, user.avatarrevision, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, 
		customavatar.dateline AS avatardateline 
		FROM vb3_user 
		LEFT JOIN vb3_usertextfield AS usertextfield
		USING (userid) 
		LEFT JOIN vb3_avatar AS avatar 
		ON(avatar.avatarid = user.avatarid) 
		LEFT JOIN vb3_customavatar AS customavatar 
		ON(customavatar.userid = user.userid) 
		WHERE usertextfield.signature!='' 
		ORDER BY posts desc 
		LIMIT 0, 18
	
mysql error: Unknown table 'user' in field list

mysql error number: 1109

I don't understand, since the table vb3_user exists ?!

An idea please ? ^_^

( sorry if there are english mistakes, I'm french ).