Hi there!
Does anyone have the hotelview external_variables for the Hall of Fame feature? I can't find it :(
Printable View
Hi there!
Does anyone have the hotelview external_variables for the Hall of Fame feature? I can't find it :(
It's not in your variables. Go to your Database and look for "emulator_settings". Then look forQuote:
Originally Posted by Poiesz
' hotelview.halloffame.query '
The code you want for the value is this
You can change the users_currency.type = 5 to another number for whatever currency you want to show and change the LIMIT 8 to show more or less users!Quote:
SELECT users.id,username,look,amount AS hof_points FROM users INNER JOIN users_currency ON users.id=users_currency.user_id WHERE users_currency.type = 5 AND users.rank < 5 ORDER BY users_currency.amount DESC LIMIT 8
Then Restart Arcturus :)