Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
[Release] query to rest your server's characters stat points [Release] query to rest your server's characters stat points
You last visited: Today at 00:34

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Release] query to rest your server's characters stat points

Discussion on [Release] query to rest your server's characters stat points within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1
 
ahmed4ever2u's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2009
Posts: 1,514
Received Thanks: 891
[Release] query to rest your server's characters stat points

hello there 2night while i was testing some stuff i wrote those line

update _Char set Strength = 10000000

and i forgot to put ( where bla bla blaaa. )
so it made all of the characters unbalanced !

so i wrote another one that will rest those stats
and i'm here to share it ( it works 100% )


PUT THE SERVER OFFLINE THEN EXECUTE IT OR THEY WILL STAY BUGGED !
Code:
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
ahmed4ever2u is offline  
Thanks
4 Users
Old 06/24/2012, 16:21   #2
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
The Black Market: 3/0/0
Join Date: May 2008
Posts: 16,390
Received Thanks: 6,507
#moved
please always post all kind of releases on Approval Sections
PortalDark is offline  
Thanks
2 Users
Old 08/10/2012, 22:31   #3
 
ahmed4ever2u's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2009
Posts: 1,514
Received Thanks: 891
Bumb ?
ahmed4ever2u is offline  
Old 08/10/2012, 22:44   #4
 
Shane¸'s Avatar
 
elite*gold: 100
The Black Market: 9/0/0
Join Date: May 2010
Posts: 1,948
Received Thanks: 1,635
dude why so complicated...
PHP Code:
update _Char 
             set (Intellect and Strength) = '20'
             IF CurLevel > 1  
             begin
                 set RemainStatPoint = (CurLevel * '3' - '3')
                 set (Intellect and Strength) = CurLevel + '20'
             end 
didn't check but it should work
edit: yours is a bit strange. statpoints at lvl2 = 3 and lvl3 = 9, lvl4 = 12? lol?
Shane¸ is offline  
Thanks
4 Users
Old 04/23/2013, 17:44   #5
 
InPanic Kev's Avatar
 
elite*gold: 80
The Black Market: 4/0/0
Join Date: Feb 2011
Posts: 766
Received Thanks: 249
dont use the first query
InPanic Kev is offline  
Old 04/23/2013, 20:22   #6
 
IceAmStiel's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
Why so complicated? xD

Code:
UPDATE dbo._Char SET Strength = 20 + (CurLevel - 1), Intellect = 20 + (CurLevel - 1), RemainStatPoint = (CurLevel - 1) * 3 WHERE CharID = 1;
IceAmStiel is offline  
Thanks
1 User
Old 04/23/2013, 22:24   #7
 
gigola123's Avatar
 
elite*gold: 0
The Black Market: 4/0/0
Join Date: Jun 2007
Posts: 722
Received Thanks: 390
Request-Sql-Sadomasochism.com Oh Yeah !
gigola123 is offline  
Reply

« Taiwan SRO Server files Fixed 100% by Nemo07 | [Release] Vigor Autopotion [Memory Based] »

Similar Threads Similar Threads
[Release] How to change stat points per level and working stat resets
04/08/2017 - Shaiya PServer Guides & Releases - 20 Replies
A tutorial on how to change Ultimate Mode stat points and make stat resets give the changed stats back Things you will need. ollydbg 2.0 - http://www.ollydbg.de/odbg200.zip ps_game.exe not to be confused with game.exe can be found in server folder SHAIYA_SERVER\SERVER\PSM_Client\Bin Make a back up of your ps_game.exe before you edit it just incase you make a mistake.
[Request] How Change Mode Stat Points and Skill Points?
05/09/2013 - Shaiya - 49 Replies
How do i change MODE Stat Points and Skill Points per level? Ex.: Ultimate Mode: 7 Stat Points - want to change it to 14 Stat Points 4 Skill Points - want to change it to 8 Skill Points Thanks for your attention.
How to fix stat points Str/Int ( + )
06/23/2012 - SRO Private Server - 7 Replies
Hello E*PVP! How to fix stat points the (+) one. Str/Int So players cant add points. Here is a pic http://img820.imageshack.us/img820/4668/sro201206 2017034358.jpg
[Small Release] Set players stat points command
07/14/2010 - CO2 PServer Guides & Releases - 5 Replies
Hey guys some people are having problems on their servers with stat points messing up. Here is a little code to add into chat.cs. These are 100% right went to the Official Conquer website and looked at all the stats "Masters" need. Goto chat.cs and search for /recall Under that void add this code. #region Set Player stats if (Cmd == "/setstats400") { if (GC.AuthInfo.Status...
skill points / stat points / 2 jobs
06/07/2007 - Kal Online - 5 Replies
hi, ich wollte mal fragen ob mir iener weiterhelfen kann ich weis nciht ob ihr hier bei sowas weiterhelft aber ich frag einfach mal :) also ich wollte einen npc in meinen server stellen der für 1kkk = 1k stat points verkauft und für 1kkk = 1k skill points verkauft und dann noch das man einfach job change drückt und den 2 job noch bekommt weis einer einen link o ich das herbekomme oder vll auch machen ^^ weil wie ich sehe gibts hier ein paar richtige pros wo das können ^^ naja hoffe ihr...



All times are GMT +1. The time now is 00:34.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.