User Of The Month
 

What Does It?
This hack will show user of the mont on forumhome

Install:

1. Go vBulletin Admin Controlpanel
2. Plugin System -> Manage Products -> [Add/Import Product] -> Select
3. 'product-vum.xml' then İmport.

Please Click INSTALL and Leave a Reply

Installed but when enter user name in acp its gave me deta error
Database error in vBulletin 3.8.4:

Invalid SQL:
Select user.username as nick, customavatar.dateline as avatar From vb_user
Left Join vb_customavatar
ON user.userid= customavatar.userid
Where user.userid = Test;

Do you mean 'user id' or did you really add the 'user name'?
You need to add the 'user id'

Anyway, the av of the user didn't show up when I installed it.

thanks

nice, installed

Write textbox USERID

I noticed this as well. It displays my avatar. I have made a temporary fix for the time being but would need to adjust every month. Nice just the same. Will hopefully see a fix.

Here what i try with
Database error in vBulletin 3.8.4:

Invalid SQL:
Select user.username as nick, customavatar.dateline as avatar From vb_user
Left Join vb_customavatar
ON user.userid= customavatar.userid
Where user.userid = test;
===================================
Database error in vBulletin 3.8.4:

Invalid SQL:
Select user.username as nick, customavatar.dateline as avatar From vb_user
Left Join vb_customavatar
ON user.userid= customavatar.userid
Where user.userid = 29;
====================================
Database error in vBulletin 3.8.4:

Invalid SQL:
Select user.username as nick, customavatar.dateline as avatar From vb_user
Left Join vb_customavatar
ON user.userid= customavatar.userid
Where user.userid = id29;


and still got same error

Please Add AdminCP ScreenShot