Fanky Posted July 5, 2010 Posted July 5, 2010 before post check the dates :p but thnx for it,cauze its very usefull and i try to find something like this. thnx ya! Quote
makabru2000 Posted July 6, 2010 Posted July 6, 2010 Thankyou. Simple yet very useful. Good Job, badriniki Quote
EdenEternal Posted July 10, 2010 Posted July 10, 2010 2x more(Str,Int,Dex,Wit,Men,Con) UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40'); UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22'); UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36'); UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21'); UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23'); UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27'); UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39'); UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43'); UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27'); UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36'); UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25'); UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32'); UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24'); UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47'); UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31'); UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45'); UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43'); UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21'); UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41'); UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23'); UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37'); UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25'); UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44'); UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18'); UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31'); UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20'); UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26'); UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40'); UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37'); UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27'); UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42'); UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39'); UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25'); UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40'); UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43'); UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21'); UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30'); UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11'); UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11'); UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20'); UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14'); UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23'); UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12'); UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19'); UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15'); UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10'); UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30'); UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21'); UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35'); UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24'); UPDATE `char_templates` SET `dex`='68' WHERE (SELECT ClassId) AND (dex = '34'); UPDATE `char_templates` SET `dex`='46' WHERE (SELECT ClassId) AND (dex = '23'); UPDATE `char_templates` SET `dex`='52' WHERE (SELECT ClassId) AND (dex = '26'); UPDATE `char_templates` SET `dex`='58' WHERE (SELECT ClassId) AND (dex = '29'); Quote
badriniki Posted November 26, 2010 Author Posted November 26, 2010 thanks all, i'm happy to help you a little :) Quote
HellRanger Posted November 26, 2010 Posted November 26, 2010 WOW!! Is awesome share. Thank you!! Quote
ImmortalKiller Posted November 26, 2010 Posted November 26, 2010 Thanks for share mate.Is usefull for all newbies. Quote
josecarlosfl18 Posted January 5, 2011 Posted January 5, 2011 A lot of those script are so HandY!!! Thnks for this great share bro.. I hope doesn't die and get sticky... Keep sharing and updating ^.^! Quote
badriniki Posted January 5, 2011 Author Posted January 5, 2011 Thanks, add more scripts here, if you have more ! Quote
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.
Note: Your post will require moderator approval before it will be visible.