[HELP] how do it

[erisP]

addEventHandler("onResourceStart", resourceRoot, function()
	dbQuery(toptime, db, "SELECT name, time FROM general ORDER BY time DESC LIMIT 20")
	dbQuery(topkill, db, "SELECT name, kills FROM general ORDER BY kills DESC LIMIT 20")
	dbQuery(topdrift, db, "SELECT name, drift FROM general ORDER BY drift DESC LIMIT 20")
	dbQuery(toprecord, db, "SELECT name, record FROM general ORDER BY record DESC LIMIT 20")
	dbQuery(toplvl, db2, "SELECT name, lvl FROM general2 ORDER BY lvl DESC LIMIT 20")
	dbQuery(topeff, db2, "SELECT name, eff FROM general2 ORDER BY eff DESC LIMIT 20")
end)

setTimer(function()
	dbQuery(toptime, db, "SELECT name, time FROM general ORDER BY time DESC LIMIT 20")
	dbQuery(topkill, db, "SELECT name, kills FROM general ORDER BY kills DESC LIMIT 20")
	dbQuery(topdrift, db, "SELECT name, drift FROM general ORDER BY drift DESC LIMIT 20")
	dbQuery(toprecord, db, "SELECT name, record FROM general ORDER BY record DESC LIMIT 20")
	dbQuery(toplvl, db2, "SELECT name, lvl FROM general2 ORDER BY lvl DESC LIMIT 20")
	dbQuery(topeff, db2, "SELECT name, eff FROM general2 ORDER BY eff DESC LIMIT 20")
end,600*1000,0)

 

I m trying to sort it Will I have any problems if I use it this way? or how can I do it better?

[IIYAMA]

18 hours ago, erisP said:

I m trying to sort it Will I have any problems if I use it this way? or how can I do it better?

This is fine.

 

You could transform it in 1 query. But that basically means that you will have to split them up later with Lua.

SELECT 
	name, 
	'time' AS type, 
	time, 
	NULL AS kills 
FROM general ORDER BY time DESC LIMIT 20

UNION ALL

SELECT 
	name, 
	'kills' AS type, 
	NULL AS time, 
	kills 
FROM general ORDER BY kills DESC LIMIT 20