sql - change mlvl all players to 0

[Scooty]

Hi,

im looking for sql query who will change magic level all players to 0.

I tried to do it alone but im to noob ;d


can someone help me?


@sorry for my english

 

[Aeven]

UPDATE `players` SET `maglevel` = 0

 

[Scooty]

thx but:

when i want to change all stats can i use something like that?

UPDATE `players` SET(`world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `comment`, `frags`) VALUES
(0, 1, 1, 8, 1, 185, 185, 4200, 132, 132, 132, 132, 128, 0, 0, 35, 35, 0, 100, 1, 1000, 1000, 7, '', 420, 1, 1291477540, 206316978, 1, 0, 0, 0, '', 1291477603, 0, 0, 151200000, 0, 100, 0, 0, 100, 100, 0, 0, 0, 0, 0, '', 1291473637, 1, '', 1, '', 0),

^query dont work