Forum Home Enhancements - 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

[vLkn]

Version History
1.1.0
+ Added automatic placement
+ Fixed avatar problem

1.2.0
+Fixed Database Error

1.3.0
+Added Select Table Location

1.4.0
+Fixed avatar problem(2)
+Added Collapse Table

News: Version 2.0 Coming Soon.

[nomoreturn]

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;

[New Joe]

Installed but when enter user name in acp its gave me deta error

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.

[erel34]

thanks

[Nadeemjp]

nice, installed

[vLkn]

Originally Posted by nomoreturn@hotm

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;

Write textbox USERID

[chrisdaman77]

Originally Posted by New Joe

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

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.

[nomoreturn]

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

[vLkn]

Originally Posted by nomoreturn@hotm

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