Hall of Fame Settings.

[lStickerz]

How can i change this Query SELECT users.look, users.username, users.id, users_settings.hof_points FROM users_settings INNER JOIN users ON users_settings.user_id = users.id WHERE hof_points > 0 ORDER BY hof_points DESC, users.id ASC LIMIT 10');

To a query that make hall of fame base on currency type.. and if rank 2 above don't show the user on the hotelview

i have try alot of different ways...

[Fable]

Where did you find hall of fame view?

[lStickerz]

Emulator_settings table * Also on users_settings theres a table called hof_points you could use to give users points for them could appear on the hotelview

[kek]

Set POINTS_TYPE_HERE to your points

You can remove the AND users.rank < 5

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 = POINTS_TYPE_HERE AND users.rank < 5 ORDER BY users_currency.amount DESC LIMIT 10

[lStickerz]

didn't work. did u try it on your hotel or something?

[lStickerz]

nvm i forgot to put the points type. Thanks tho

[lStickerz]

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 = POINTS_TYPE_HERE AND users.rank < 5 ORDER BY users_currency.amount DESC LIMIT 10 < How To put it base on currency

[Wesley]

Removing version: 1.5.0 (automated comment)