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
its still not showingGo to your Database and look for "emulator_settings". Then look for
' 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!Code: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
Did you clear your cache?its still not showing
Post automatically merged:
why isnt it showing up