[share]Sql script

[claww]

this script  modify armors pdef from  B grade to s80   as to s84

 

i do that cause somebody  told me thats is booring to see all players in same armor  and its a good ideea to make pdef of all armors as to vesper

 

some armors have good stats but low pdef

 

now added sql script when i'm finish i will add and client side part...

 

UPDATE armor SET p_def="68" WHERE bodypart="gloves" and crystal_type="b";
UPDATE armor SET p_def="68" WHERE bodypart="feet" and crystal_type="b";
UPDATE armor SET p_def="101" WHERE bodypart="head" and crystal_type="b";

UPDATE armor SET p_def="68" WHERE bodypart="gloves" and crystal_type="a";
UPDATE armor SET p_def="68" WHERE bodypart="feet" and crystal_type="a";
UPDATE armor SET p_def="101" WHERE bodypart="head" and crystal_type="a";

UPDATE armor SET p_def="68" WHERE bodypart="gloves" and crystal_type="s";
UPDATE armor SET p_def="68" WHERE bodypart="feet" and crystal_type="s";
UPDATE armor SET p_def="101" WHERE bodypart="head" and crystal_type="s";


UPDATE armor SET p_def="68" WHERE bodypart="gloves" and crystal_type="s80";
UPDATE armor SET p_def="68" WHERE bodypart="feet" and crystal_type="s80";
UPDATE armor SET p_def="101" WHERE bodypart="head" and crystal_type="s80";


UPDATE armor SET p_def="250" WHERE bodypart="chest" and crystal_type="b" and armor_type="heavy";
UPDATE armor SET p_def="157" WHERE bodypart="legs" and crystal_type="b" and armor_type="heavy";
UPDATE armor SET p_def="401" WHERE bodypart="fullarmor" and crystal_type="b" and armor_type="heavy";

UPDATE armor SET p_def="250" WHERE bodypart="chest" and crystal_type="a" and armor_type="heavy";
UPDATE armor SET p_def="157" WHERE bodypart="legs" and crystal_type="a" and armor_type="heavy";
UPDATE armor SET p_def="401" WHERE bodypart="fullarmor" and crystal_type="a" and armor_type="heavy";

UPDATE armor SET p_def="187" WHERE bodypart="chest" and crystal_type="a" and armor_type="light";
UPDATE armor SET p_def="117" WHERE bodypart="legs" and crystal_type="a" and armor_type="light";
UPDATE armor SET p_def="300" WHERE bodypart="fullarmor" and crystal_type="a" and armor_type="light";

UPDATE armor SET p_def="125" WHERE bodypart="chest" and crystal_type="a" and armor_type="robe";
UPDATE armor SET p_def="78" WHERE bodypart="legs" and crystal_type="a" and armor_type="robe";
UPDATE armor SET p_def="200" WHERE bodypart="fullarmor" and crystal_type="a" and armor_type="robe";


UPDATE armor SET p_def="250" WHERE bodypart="chest" and crystal_type="s" and armor_type="heavy";
UPDATE armor SET p_def="157" WHERE bodypart="legs" and crystal_type="s" and armor_type="heavy";
UPDATE armor SET p_def="401" WHERE bodypart="fullarmor" and crystal_type="s" and armor_type="heavy";

UPDATE armor SET p_def="187" WHERE bodypart="chest" and crystal_type="s" and armor_type="light";
UPDATE armor SET p_def="117" WHERE bodypart="legs" and crystal_type="s" and armor_type="light";
UPDATE armor SET p_def="300" WHERE bodypart="fullarmor" and crystal_type="s" and armor_type="light";

UPDATE armor SET p_def="125" WHERE bodypart="chest" and crystal_type="s" and armor_type="robe";
UPDATE armor SET p_def="78" WHERE bodypart="legs" and crystal_type="s" and armor_type="robe";
UPDATE armor SET p_def="200" WHERE bodypart="fullarmor" and crystal_type="s" and armor_type="robe";


UPDATE armor SET p_def="250" WHERE bodypart="chest" and crystal_type="s80" and armor_type="heavy";
UPDATE armor SET p_def="157" WHERE bodypart="legs" and crystal_type="s80" and armor_type="heavy";
UPDATE armor SET p_def="401" WHERE bodypart="fullarmor" and crystal_type="s80" and armor_type="heavy";

UPDATE armor SET p_def="187" WHERE bodypart="chest" and crystal_type="s80" and armor_type="light";
UPDATE armor SET p_def="117" WHERE bodypart="legs" and crystal_type="s80" and armor_type="light";
UPDATE armor SET p_def="300" WHERE bodypart="fullarmor" and crystal_type="s80" and armor_type="light";

UPDATE armor SET p_def="125" WHERE bodypart="chest" and crystal_type="s80" and armor_type="robe";
UPDATE armor SET p_def="78" WHERE bodypart="legs" and crystal_type="s80" and armor_type="robe";
UPDATE armor SET p_def="200" WHERE bodypart="fullarmor" and crystal_type="s80" and armor_type="robe";

 

[Lomkevicius]

thanks. i go try :)

[mindaugas]

nice idea of script, i i'll try

[Onix]

awesome share and good work but you mistake put tag [share], anyway thanks for share .