[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 [email protected]

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 [email protected]

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

[nomoreturn]

I dont think so that you need screen shot because there is only two option on /off and the 2nd one for the id anyway here is the screen shots

[vLkn]

Is User Id 29 available?

[nomoreturn]

yes user id 29 is available. every thing working good but when we put id or username got error

[HappyFeet]

I installed and it works except for avatar. Checked all styles and it's the same.

I like this mod, I enjoy giving credit to active users.

Is it possible to add a section to say why this person is the user of the month?

screen shot included...

[vLkn]

Plase wait version 1.1.0