Hall of Fame in hotelview (Arcturus)

[Poiesz]

Hi there!

Does anyone have the hotelview external_variables for the Hall of Fame feature? I can't find it :(

[MentaL]

[Xylo]

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 for
' hotelview.halloffame.query '

The code you want for the value is this

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

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!

Then Restart Arcturus :)

[Aamiainen]

http://forum.ragezone.com/f335/tips-...turus-1144466/