The Most Important Querry

[Janebug]

UPDATE t_quest SET a_prize_data0 = a_prize_data0*1 WHERE a_prize_index0 = 0 and a_prize_type0 = 2 ;

UPDATE t_quest SET a_prize_data1 = a_prize_data1*1 WHERE a_prize_index1 = 0 and a_prize_type1 = 2 ;

UPDATE t_quest SET a_prize_data2 = a_prize_data2*1 WHERE a_prize_index2 = 0 and a_prize_type2 = 2 ;

 

 

-- This Code let manage you the Quest Experience Replace 1 with the -- number of Exp Rate that you would to have (thanks for code filix_93 )

 

-- NPCS that have 0 Value run once even if it gives value to shop npcs atleast all mobs will have Value --

UPDATE t_npc SET a_str = (a_level - 1) WHERE a_str = 0; 

UPDATE t_npc SET a_dex = (a_level - 1) WHERE a_dex = 0;

UPDATE t_npc SET a_int = (a_level - 1) WHERE a_int = 0; 

UPDATE t_npc SET a_con = (a_level - 1) WHERE a_con = 0; 

UPDATE t_npc SET a_hit = (a_level * 7) WHERE a_hit = 0;

UPDATE t_npc SET a_attack = (a_level * 3) WHERE a_attack = 0;

UPDATE t_npc SET a_attacklevel = (a_level - 1) WHERE a_attacklevel = 0

UPDATE t_npc SET a_defenselevel = (a_level - 45) WHERE a_defenselevel = 0; 

UPDATE t_npc SET a_defense = (a_level - 45) WHERE a_defense = 0;

UPDATE t_npc SET a_dodge = (a_level - 45) WHERE a_dodge = 0;  

UPDATE t_npc SET a_resist = (a_level * 5) WHERE a_resist = 0;

UPDATE t_npc SET a_magic = (a_level * 35) WHERE a_magic = 0;

UPDATE t_npc SET a_prize = (a_level * 170) WHERE a_prize = 0;

UPDATE t_npc SET a_sight = (a_level / 13) WHERE a_sight = 0;

UPDATE t_npc SET a_exp = (a_level * 30) WHERE a_exp = 0;

UPDATE t_npc SET a_skill_point = (a_level * 23.62) WHERE a_skill_point = 0;

by: jane

 

most of these takes the Level of the npc Subtract, adds, divides or multiplies by a Value to give it something to start..