Gw8 Posted January 18, 2018 Share Posted January 18, 2018 getRanking = function() local rankCash = conn:query('SELECT TOP 3 * FROM teamSystem ORDER BY cash DESC') local resultCash = rankCash:poll(-1) or {} local rankReputation = conn:query('SELECT TOP 3 * FROM teamSystem ORDER BY reputation DESC') local resultReputation = rankReputation:poll(-1) or {} return resultCash,resultReputation end, [2018-01-18 11:39:10] WARNING: new\storage\sql_team.lua:148: poll failed; near "3": syntax error WTF ERROR dahsdjksaj alguem sabe outra sql que vá me da o mesmo resultado ou como acerta isso? Link to comment
Other Languages Moderators Lord Henry Posted January 18, 2018 Other Languages Moderators Share Posted January 18, 2018 (edited) Isso aí é MySQL. Prefira usar SQLite. ExecuteSQLQuery Edited January 18, 2018 by Lord Henry Link to comment
[M]ister Posted January 18, 2018 Share Posted January 18, 2018 Aparentemente sua query está errada, tente: SELECT * FROM teamSystem ORDER BY cash DESC LIMIT 3 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now