nemo20122
08-10-2012, 04:36 PM
use SRO_VT_SHARD
update _Char set Intellect = '20', Strength = '20', RemainStatPoint ='0' where CurLevel = 1
update _Char set Intellect = '21', Strength = '21', RemainStatPoint ='3' where CurLevel = 2
update _Char set Intellect = '22', Strength = '22', RemainStatPoint ='9' where CurLevel = 3
update _Char set Intellect = '23', Strength = '23', RemainStatPoint ='12' where CurLevel = 4
update _Char set Intellect = '24', Strength = '24', RemainStatPoint ='15' where CurLevel = 5
update _Char set Intellect = '25', Strength = '25', RemainStatPoint ='18' where CurLevel = 6
update _Char set Intellect = '26', Strength = '26', RemainStatPoint ='21' where CurLevel = 7
update _Char set Intellect = '27', Strength = '27', RemainStatPoint ='24' where CurLevel = 8
update _Char set Intellect = '28', Strength = '28', RemainStatPoint ='27' where CurLevel = 9
update _Char set Intellect = '29', Strength = '29', RemainStatPoint ='30' where CurLevel = 10
update _Char set Intellect = '30', Strength = '30', RemainStatPoint ='33' where CurLevel = 11
update _Char set Intellect = '31', Strength = '31', RemainStatPoint ='37' where CurLevel = 12
update _Char set Intellect = '32', Strength = '32', RemainStatPoint ='40' where CurLevel = 13
update _Char set Intellect = '33', Strength = '33', RemainStatPoint ='43' where CurLevel = 14
update _Char set Intellect = '34', Strength = '34', RemainStatPoint ='46' where CurLevel = 15
update _Char set Intellect = '35', Strength = '35', RemainStatPoint ='49' where CurLevel = 16
update _Char set Intellect = '36', Strength = '36', RemainStatPoint ='52' where CurLevel = 17
update _Char set Intellect = '37', Strength = '37', RemainStatPoint ='55' where CurLevel = 18
update _Char set Intellect = '38', Strength = '38', RemainStatPoint ='58' where CurLevel = 19
update _Char set Intellect = '39', Strength = '39', RemainStatPoint ='61' where CurLevel = 20
update _Char set Intellect = '40', Strength = '40', RemainStatPoint ='64' where CurLevel = 21
update _Char set Intellect = '41', Strength = '41', RemainStatPoint ='67' where CurLevel = 22
update _Char set Intellect = '42', Strength = '42', RemainStatPoint ='70' where CurLevel = 23
update _Char set Intellect = '43', Strength = '43', RemainStatPoint ='73' where CurLevel = 24
update _Char set Intellect = '44', Strength = '44', RemainStatPoint ='76' where CurLevel = 25
update _Char set Intellect = '45', Strength = '45', RemainStatPoint ='79' where CurLevel = 26
update _Char set Intellect = '46', Strength = '46', RemainStatPoint ='82' where CurLevel = 27
update _Char set Intellect = '47', Strength = '47', RemainStatPoint ='85' where CurLevel = 28
update _Char set Intellect = '48', Strength = '48', RemainStatPoint ='88' where CurLevel = 29
update _Char set Intellect = '49', Strength = '49', RemainStatPoint ='91' where CurLevel = 30
update _Char set Intellect = '50', Strength = '50', RemainStatPoint ='94' where CurLevel = 31
update _Char set Intellect = '51', Strength = '51', RemainStatPoint ='97' where CurLevel = 32
update _Char set Intellect = '52', Strength = '52', RemainStatPoint ='100' where CurLevel = 33
update _Char set Intellect = '53', Strength = '53', RemainStatPoint ='103' where CurLevel = 34
update _Char set Intellect = '54', Strength = '54', RemainStatPoint ='106' where CurLevel = 35
update _Char set Intellect = '55', Strength = '55', RemainStatPoint ='109' where CurLevel = 36
update _Char set Intellect = '56', Strength = '56', RemainStatPoint ='112' where CurLevel = 37
update _Char set Intellect = '57', Strength = '57', RemainStatPoint ='115' where CurLevel = 38
update _Char set Intellect = '58', Strength = '58', RemainStatPoint ='118' where CurLevel = 39
update _Char set Intellect = '59', Strength = '59', RemainStatPoint ='121' where CurLevel = 40
update _Char set Intellect = '60', Strength = '60', RemainStatPoint ='124' where CurLevel = 41
update _Char set Intellect = '61', Strength = '61', RemainStatPoint ='127' where CurLevel = 42
update _Char set Intellect = '62', Strength = '62', RemainStatPoint ='130' where CurLevel = 43
update _Char set Intellect = '63', Strength = '63', RemainStatPoint ='133' where CurLevel = 44
update _Char set Intellect = '64', Strength = '64', RemainStatPoint ='136' where CurLevel = 45
update _Char set Intellect = '65', Strength = '65', RemainStatPoint ='139' where CurLevel = 46
update _Char set Intellect = '66', Strength = '66', RemainStatPoint ='142' where CurLevel = 47
update _Char set Intellect = '67', Strength = '67', RemainStatPoint ='145' where CurLevel = 48
update _Char set Intellect = '68', Strength = '68', RemainStatPoint ='148' where CurLevel = 49
update _Char set Intellect = '69', Strength = '69', RemainStatPoint ='151' where CurLevel = 50
update _Char set Intellect = '70', Strength = '70', RemainStatPoint ='154' where CurLevel = 51
update _Char set Intellect = '71', Strength = '71', RemainStatPoint ='157' where CurLevel = 52
update _Char set Intellect = '72', Strength = '72', RemainStatPoint ='160' where CurLevel = 53
update _Char set Intellect = '73', Strength = '73', RemainStatPoint ='163' where CurLevel = 54
update _Char set Intellect = '74', Strength = '74', RemainStatPoint ='166' where CurLevel = 55
update _Char set Intellect = '75', Strength = '75', RemainStatPoint ='169' where CurLevel = 56
update _Char set Intellect = '76', Strength = '76', RemainStatPoint ='172' where CurLevel = 57
update _Char set Intellect = '77', Strength = '77', RemainStatPoint ='175' where CurLevel = 58
update _Char set Intellect = '78', Strength = '78', RemainStatPoint ='178' where CurLevel = 59
update _Char set Intellect = '79', Strength = '79', RemainStatPoint ='181' where CurLevel = 60
update _Char set Intellect = '80', Strength = '80', RemainStatPoint ='184' where CurLevel = 61
update _Char set Intellect = '81', Strength = '81', RemainStatPoint ='187' where CurLevel = 62
update _Char set Intellect = '82', Strength = '82', RemainStatPoint ='190' where CurLevel = 63
update _Char set Intellect = '83', Strength = '83', RemainStatPoint ='193' where CurLevel = 64
update _Char set Intellect = '84', Strength = '84', RemainStatPoint ='196' where CurLevel = 65
update _Char set Intellect = '85', Strength = '85', RemainStatPoint ='199' where CurLevel = 66
update _Char set Intellect = '86', Strength = '86', RemainStatPoint ='202' where CurLevel = 67
update _Char set Intellect = '87', Strength = '87', RemainStatPoint ='205' where CurLevel = 68
update _Char set Intellect = '88', Strength = '88', RemainStatPoint ='208' where CurLevel = 69
update _Char set Intellect = '89', Strength = '89', RemainStatPoint ='211' where CurLevel = 70
update _Char set Intellect = '90', Strength = '90', RemainStatPoint ='214' where CurLevel = 71
update _Char set Intellect = '91', Strength = '91', RemainStatPoint ='217' where CurLevel = 72
update _Char set Intellect = '92', Strength = '92', RemainStatPoint ='220' where CurLevel = 73
update _Char set Intellect = '93', Strength = '93', RemainStatPoint ='223' where CurLevel = 74
update _Char set Intellect = '94', Strength = '94', RemainStatPoint ='226' where CurLevel = 75
update _Char set Intellect = '95', Strength = '95', RemainStatPoint ='229' where CurLevel = 76
update _Char set Intellect = '96', Strength = '96', RemainStatPoint ='232' where CurLevel = 77
update _Char set Intellect = '97', Strength = '97', RemainStatPoint ='235' where CurLevel = 78
update _Char set Intellect = '98', Strength = '98', RemainStatPoint ='238' where CurLevel = 79
update _Char set Intellect = '99', Strength = '99', RemainStatPoint ='241' where CurLevel = 80
update _Char set Intellect = '100', Strength = '100', RemainStatPoint ='244' where CurLevel = 81
update _Char set Intellect = '101', Strength = '101', RemainStatPoint ='247' where CurLevel = 82
update _Char set Intellect = '102', Strength = '102', RemainStatPoint ='250' where CurLevel = 83
update _Char set Intellect = '103', Strength = '103', RemainStatPoint ='253' where CurLevel = 84
update _Char set Intellect = '104', Strength = '104', RemainStatPoint ='256' where CurLevel = 85
update _Char set Intellect = '105', Strength = '105', RemainStatPoint ='259' where CurLevel = 86
update _Char set Intellect = '106', Strength = '106', RemainStatPoint ='262' where CurLevel = 87
update _Char set Intellect = '107', Strength = '107', RemainStatPoint ='265' where CurLevel = 88
update _Char set Intellect = '108', Strength = '108', RemainStatPoint ='268' where CurLevel = 89
update _Char set Intellect = '109', Strength = '109', RemainStatPoint ='271' where CurLevel = 90
update _Char set Intellect = '110', Strength = '110', RemainStatPoint ='274' where CurLevel = 91
update _Char set Intellect = '111', Strength = '111', RemainStatPoint ='277' where CurLevel = 92
update _Char set Intellect = '112', Strength = '112', RemainStatPoint ='280' where CurLevel = 93
update _Char set Intellect = '113', Strength = '113', RemainStatPoint ='283' where CurLevel = 94
update _Char set Intellect = '114', Strength = '114', RemainStatPoint ='286' where CurLevel = 95
update _Char set Intellect = '115', Strength = '115', RemainStatPoint ='289' where CurLevel = 96
update _Char set Intellect = '116', Strength = '116', RemainStatPoint ='292' where CurLevel = 97
update _Char set Intellect = '117', Strength = '117', RemainStatPoint ='295' where CurLevel = 98
update _Char set Intellect = '118', Strength = '118', RemainStatPoint ='298' where CurLevel = 99
update _Char set Intellect = '119', Strength = '119', RemainStatPoint ='301' where CurLevel = 100
update _Char set Intellect = '120', Strength = '120', RemainStatPoint ='304' where CurLevel = 101
update _Char set Intellect = '121', Strength = '121', RemainStatPoint ='307' where CurLevel = 102
update _Char set Intellect = '122', Strength = '122', RemainStatPoint ='310' where CurLevel = 103
update _Char set Intellect = '123', Strength = '123', RemainStatPoint ='313' where CurLevel = 104
update _Char set Intellect = '124', Strength = '124', RemainStatPoint ='316' where CurLevel = 105
update _Char set Intellect = '125', Strength = '125', RemainStatPoint ='319' where CurLevel = 106
update _Char set Intellect = '126', Strength = '126', RemainStatPoint ='322' where CurLevel = 107
update _Char set Intellect = '127', Strength = '127', RemainStatPoint ='325' where CurLevel = 108
update _Char set Intellect = '128', Strength = '128', RemainStatPoint ='328' where CurLevel = 109
update _Char set Intellect = '129', Strength = '129', RemainStatPoint ='331' where CurLevel = 110
هو دوية بحل المشكلة بس انا مثلا لفل 10 ولفلت 12 بيفضل الموضوع زى مكان مش بيعلى ولا تحت ولا فوق فى ال hp mp