Need some Mysql help please!

[MxSoft]

Hi i need to erase all quest storages from players form world id=0, move all that players to world id=2 and give them to all of them 10 premium points and 90 vipdays
vipdays is in accounts
Please help

 

[Cykotitan]

DELETE FROM `player_storage` WHERE `player_id` IN (SELECT `id` FROM `players` WHERE `world_id` = 0);

UPDATE `players` SET `world_id` = 2 WHERE `world_id` = 0;

UPDATE `accounts` SET `premium_points` = `premium_points` + 10, `vipdays` = `vipdays` + 90 WHERE `id` IN (SELECT `account_id` FROM `players` WHERE `world_id` = 2 GROUP BY `account_id`);

 

[GM Soul Monger]

UPDATE `accounts` SET `premium_points` = `premium_points` + 10, `vipdays` = `vipdays` + 90 WHERE `id` IN (SELECT `account_id` FROM `players` WHERE `world_id` = 0 GROUP BY `account_id`);
DELETE FROM `player_storage` WHERE `player_id` IN (SELECT `id` FROM `players` WHERE `world_id` = 0);
 
UPDATE `players` SET `world_id` = 2 WHERE `world_id` = 0;

Primero dias VIP y Prem points a los del world_id=0 no?, ya despues todo lo que puso cyko

Y para serte honesto 90 dias es Muchisimo, si bien perdimos muchos items pero no lo equivalente a 90 dias, 1 mes hubiese estado mas que bien =)