Chequear el lugar especifico de un Mob:
SELECT * FROM t_npc_regen where a_npc_idx = 93;
Borrar NPC o Mob del NPC_Regen
DELETE FROM `t_npc_regen` WHERE `a_npc_idx` = '94' ;
Reemplazar un Mob del NPC Regen
UPDATE t_npc_regen SET a_npc_idx = "2090" WHERE a_npc_idx = "65";
Borrar el SP/GOLD/ITEM de los skills
UPDATE t_skillLevel SET a_learnSP = 0;
UPDATE t_skillLevel SET a_learnItemIndex1 = -1;
UPDATE t_skillLevel SET a_learnItemCount1 = 0;
Subir el Guild a level 50 o al que quieran
UPDATE t_guild SET a_level = 50;
UPDATE t_extend_guild SET a_guild_point = 2147483647;
UPDATE t_extend_guild SET a_guild_maxmember = 100;
Poner que todos los Mob's den 200k sp^^
UPDATE t_npc SET a_skill_point = "2111111111";
Para correjir cuando agregar un nuevo item y te sale: "Wrong Level" al usarlo.
UPDATE t_item SET a_level2 = 999;
Update t_item
UPDATE t_npc SET a_item_0 = '-1' WHERE a_item_0 = '140';
UPDATE t_npc SET a_item_1 = '-1' WHERE a_item_1 = '140';
UPDATE t_npc SET a_item_2 = '-1' WHERE a_item_2 = '140';
UPDATE t_npc SET a_item_3 = '-1' WHERE a_item_3 = '140';
UPDATE t_npc SET a_item_4 = '-1' WHERE a_item_4 = '140';
UPDATE t_npc SET a_item_5 = '-1' WHERE a_item_5 = '140';
UPDATE t_npc SET a_item_6 = '-1' WHERE a_item_6 = '140';
UPDATE t_npc SET a_item_7 = '-1' WHERE a_item_7 = '140';
UPDATE t_npc SET a_item_8 = '-1' WHERE a_item_8 = '140';
UPDATE t_npc SET a_item_9 = '-1' WHERE a_item_9 = '140';
UPDATE t_npc SET a_item_10 = '-1' WHERE a_item_10 = '140';
UPDATE t_npc SET a_item_11 = '-1' WHERE a_item_11 = '140';
UPDATE t_npc SET a_item_12 = '-1' WHERE a_item_12 = '140';
UPDATE t_npc SET a_item_13 = '-1' WHERE a_item_13 = '140';
UPDATE t_npc SET a_item_14 = '-1' WHERE a_item_14 = '140';
UPDATE t_npc SET a_item_15 = '-1' WHERE a_item_15 = '140';
UPDATE t_npc SET a_item_16 = '-1' WHERE a_item_16 = '140';
UPDATE t_npc SET a_item_17 = '-1' WHERE a_item_17 = '140';
UPDATE t_npc SET a_item_18 = '-1' WHERE a_item_18 = '140';
UPDATE t_npc SET a_item_19 = '-1' WHERE a_item_19 = '140';
Borrar todo el oro del servidor o poner una cantidad especifica a todos los jugadores
UPDATE t_inven00 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven00 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven00 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven00 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven00 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven01 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven01 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven01 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven01 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven01 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven02 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven02 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven02 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven02 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven02 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven03 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven03 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven03 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven03 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven03 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven04 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven04 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven04 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven04 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven04 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven05 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven05 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven05 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven05 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven05 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven06 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven06 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven06 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven06 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven06 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven07 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven07 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven07 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven07 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven07 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven08 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven08 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven08 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven08 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven08 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
UPDATE t_inven09 SET a_count0 = '0' + "100" WHERE a_item_idx0 = 19;
UPDATE t_inven09 SET a_count1 = '0' + "100" WHERE a_item_idx1 = 19;
UPDATE t_inven09 SET a_count2 = '0' + "100" WHERE a_item_idx2 = 19;
UPDATE t_inven09 SET a_count3 = '0' + "100" WHERE a_item_idx3 = 19;
UPDATE t_inven09 SET a_count4 = '0' + "100" WHERE a_item_idx4 = 19;
