The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#11
|
|||
|
|||
![]()
thx Kier but I tried it on vb115 and work fine, but it is not what i want, I wanna to display usertitles not usergroups, sorry for bothering u but can u to modify it.
![]() |
#12
|
|||
|
|||
![]()
Replace Kier's SQL query with this:
SELECT user.usertitle, COUNT(userid) AS users FROM user GROUP BY user.usertitle Hope this helps. |
#13
|
|||
|
|||
![]()
Lol Pef,don't forget that Kier is the better php coder's of the World (for vbulletin
![]() |
#14
|
|||
|
|||
![]()
I have 4 users in my test board, and when I test it, it gived me a list without titles only numbers, and they was 3 numbers only, but I have 4 titles to those users, any help???
![]() |
#15
|
|||
|
|||
![]()
try the sql query if you have this.
|
#16
|
|||
|
|||
![]()
I didnt get ur meaning, sorry
|
#17
|
|||
|
|||
![]()
Do you know if you have phpmyAdmin access to your site? If you have, run the SELECT statement I posted and see if you get the result you wanted.
|
#18
|
|||
|
|||
![]()
I checked in phpmyadmin and it was very nie, I think there are some modification in the rest of kier code to display every thing correctly in the index page, any help.
|
#19
|
|||
|
|||
![]()
can u do it with new select statment?
|
#20
|
|||
|
|||
![]() PHP Code:
not 100% sure. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|