The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
the two tables are "reputation" & "user".
I get the info from "reputation" but want to translate the userid in to a username via the user table. the script looks like this... PHP Code:
|
#2
|
||||
|
||||
![]()
This is not a nice way of doing it - firstly if this is for vB make use of the built in class.
mysql_query(); = $DB_site->query(); mysql_fetch_array(); = $DB_site->fetch_array(); And so on... Secondly use templates as it's a lot cleaner method Thirdly for your join ![]() PHP Code:
You may want to try and limit it too as if you have 100+ users as soon as they all have their reputations you're going to be pulling 100+ users at a time. |
#3
|
||||
|
||||
![]()
Try
PHP Code:
|
![]() |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|