[Help] Query Reset all player from server

[Critico]

this query is correct?

db.executeQuery("UPDATE players SET maglevel = 1 WHERE id NOT IN (SELECT players FROM maglevel WHERE player_id NOT IN (SELECT id FROM players));")

or

db.executeQuery("UPDATE players SET maglevel = 1 WHERE player_id NOT IN (SELECT id FROM players);")

?

and this:

for x = 1,6 do
db.executeQuery("UPDATE `player_skills` SET `value` = 10 WHERE player_id NOT IN (SELECT id FROM players) and `skillid` = x ;") 
end

OR

for x = 1,6 do
db.executeQuery("UPDATE `player_skills` SET `value` = 10 WHERE id NOT IN (SELECT players FROM player_skills WHERE player_id NOT IN (SELECT id FROM players)) and `skillid` = x ;") 
end

Thanks

 

[Critico]

Bump

 

[Scarlet Ayleid]

first:
if you just want to make the ML 1 of every player on the server, then:

[LEFT][COLOR=#333333]db.executeQuery("UPDATE players SET maglevel = 1, manaspent = 0")[/COLOR][/LEFT]

second:
make every player on the server get all skills = 10, then:

db.executeQuery("UPDATE player_skills SET value = 10, count = 0")