claww Posted August 9, 2010 Share Posted August 9, 2010 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"; Quote Link to comment Share on other sites More sharing options...
Lomkevicius Posted August 9, 2010 Share Posted August 9, 2010 thanks. i go try :) Quote Link to comment Share on other sites More sharing options...
mindaugas Posted August 9, 2010 Share Posted August 9, 2010 nice idea of script, i i'll try Quote Link to comment Share on other sites More sharing options...
Onix Posted August 9, 2010 Share Posted August 9, 2010 awesome share and good work but you mistake put tag [share], anyway thanks for share . Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.