Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Help !!

Junior Spellweaver
Joined
Feb 8, 2008
Messages
112
Reaction score
0
After i use this all new player can`t login ...
There are several different ways of giving mapcodes, stats, alz and other things but all require several individual edits. There is a much much easier way but i have not seen anybody share it yet so here you are.

Most people know you can make all new accounts premium my editing the cabal_tool_registeraccount stored procedure in the account database but in case you don't look for this line in the stored procedure...

Code:
values(@UserNum, [COLOR=Red]0[/COLOR], [COLOR=Blue]DATEADD(day, 100 , getdate())[/COLOR], 0)
The red number is the account type. 0 is a free account and 1 is charged (premium). The blue number is the expiry date (the dateadd function is adding 100 days to today's date). Simply change the 0 to 1 to make all new chars premium and change the 100 if you want them to have more than 100 days of prem.

Here are the prem types from SAUR0N's client synch patch:
Sarmalutza - Help !! - RaGEZONE Forums


I have squashed the columns up a bit to get it all in but the actual column titles (in left to right order) are:

[DurationSvc] = The row index. This always starts at 0 and increments by values of 1.
DurationSvcIdx = The premium ServiceIdx number
Type = Not completely sure. I *think* 0 means premium expires by expiry date and 1 uses the PayMinutes values and counts down the minutes until expiry.
Exp = Bonus EXP
SklExp = Bonus Skill EXP
Drop = Bonus droprate
Craft = Bonus craft EXP
CraftSuccess = Bonus craft success
Inventory = Extra inventory tab
Warehouse = Extra warehouse tab
Str = Bonus STR
Dex = Bonus DEX
Int = Bonus INT
Attk = Bonus Attack
MgAttk = Bonus Magic Attack
AR = Bonus Attack Rate
DR = Bonus Defense rate
Defense = Bonus DEF
MoveSpeed = Bonus move speed
SP = Bonus EXP
UseSP = Not sure
BombAlz = Bonus Alz bomb rate
Inventory2 = 2nd extra inventory tab
Warehouse2 = 2nd extra warehouse tab
dummy = Use of training dummies

So, from this you can tell that a DurationSvcIdx of 1 gives you an extra 25% to all exp and drop rates and 200% Alz bomb but no training dummies. DurationSvcIdx of 2 give you the same, but Skill EXP is at 50%, you get 2 extra inventory tabs, 1 extra warehouse tab and access to training dummies.

Now comes the interesting bit. Execute the following statement in the account database and then try making a new char, it should be level 150 with a full mithril set and lots of points to add.

Code:
update cabal_newflagdata_table set chardataidx=8, etcdataidx=8 where channel=25
All very interesting, but why does it do that? To find out you need to look at some other tables in the account database...

Sarmalutza - Help !! - RaGEZONE Forums


cabal_character_count_table is the first place to look. Find an existing userid on your server and check the server idx, don't assume the server idx will be 24 like your configs.

Sarmalutza - Help !! - RaGEZONE Forums


If i look through cabal_newflagdata_table i can see my channel number has a chardataidx and an etcdataidx of 8 (we just changed this to 8 from 10). These 2 values are important as it tells the server what set of new character stats/equips etc. to use when creating new chars.

Sarmalutza - Help !! - RaGEZONE Forums


This table (cabal_newchardata_table for those that can't read title bars) holds the default stats, alz, mapcodes and a whole bunch of other stuff that gets used for new chars. Inventory, equips, quest data and some other stuff can be found in cabal_newetcdata. We have just told the server to use set 8 which you can see are not noobie stats, it was using 10 before just below the area i hilighted which are the normal new char stats.

If you look through these tables you will see that there are several different configurations. You can even mix and match the 2 values to use combinations of newchardata and newetcdata. You can even modify the sets using the info in darkxl's sticky to suit your own server, or even have multiple sets to have different new char data for high and low rate servers.

Warning: Most of the higher sets here have the equips already equipped but your stats aren't actually high enough to wear them as all of your points are unassigned. This does cause errors in the server logs and i have not done much testing for problems if you don't assign your stats high enough for the equips, but if you raise the stats straight away it should be fine. Obviously the better way is to alter the stats in the cabal_newchardata_table to match the kit the chars will be wearing though ;)



I have this error`s just in GlobalDBAgent in rest all it`s ok

Code:
[Mon Dec 21 2009 14:47:36.709278 3060968336]: Database Connect success!
[Mon Dec 21 2009 14:47:37.487600 3060968336]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Mon Dec 21 2009 14:47:37.487694 3060968336]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Difference of two datetime columns caused overflow at runtime.
[Mon Dec 21 2009 14:47:37.487715 3060968336]: [##ERROR##] DB ERROR(CODE)     : 535
[Mon Dec 21 2009 14:47:37.487731 3060968336]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Mon Dec 21 2009 14:47:37.487749 3060968336]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Mon Dec 21 2009 14:47:37.487766 3060968336]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Mon Dec 21 2009 14:47:38.240553 3060968336]: Database Connect success!
[Mon Dec 21 2009 14:47:38.240647 3060968336]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Mon Dec 21 2009 14:47:38.240692 3060968336]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Mon Dec 21 2009 14:48:29.425053 3050478480]: Database Connect success!
[Mon Dec 21 2009 14:48:29.917684 3050478480]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Mon Dec 21 2009 14:48:29.917836 3050478480]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Difference of two datetime columns caused overflow at runtime.
[Mon Dec 21 2009 14:48:29.917859 3050478480]: [##ERROR##] DB ERROR(CODE)     : 535
[Mon Dec 21 2009 14:48:29.917878 3050478480]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Mon Dec 21 2009 14:48:29.917897 3050478480]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Mon Dec 21 2009 14:48:29.917916 3050478480]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Mon Dec 21 2009 14:48:30.660381 3050478480]: Database Connect success!
[Mon Dec 21 2009 14:48:30.660460 3050478480]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Mon Dec 21 2009 14:48:30.660488 3050478480]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Mon Dec 21 2009 14:49:20.858289 3060968336]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Mon Dec 21 2009 14:49:20.858415 3060968336]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Difference of two datetime columns caused overflow at runtime.
[Mon Dec 21 2009 14:49:20.858436 3060968336]: [##ERROR##] DB ERROR(CODE)     : 535
[Mon Dec 21 2009 14:49:20.858455 3060968336]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Mon Dec 21 2009 14:49:20.858473 3060968336]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Mon Dec 21 2009 14:49:20.858490 3060968336]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Mon Dec 21 2009 14:49:21.642441 3060968336]: Database Connect success!
[Mon Dec 21 2009 14:49:21.642547 3060968336]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Mon Dec 21 2009 14:49:21.642575 3060968336]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Mon Dec 21 2009 14:50:13.084637 3050478480]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Mon Dec 21 2009 14:50:13.084733 3050478480]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Difference of two datetime columns caused overflow at runtime.
[Mon Dec 21 2009 14:50:13.084753 3050478480]: [##ERROR##] DB ERROR(CODE)     : 535
[Mon Dec 21 2009 14:50:13.084769 3050478480]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Mon Dec 21 2009 14:50:13.084786 3050478480]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Mon Dec 21 2009 14:50:13.084802 3050478480]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Mon Dec 21 2009 14:50:13.904814 3050478480]: Database Connect success!
 
Junior Spellweaver
Joined
Oct 18, 2008
Messages
189
Reaction score
64
I usually get this error when editing the Day Add variable beyond 9999. Edit the SP and drop the value to 9999 (or anything below 10k) and restart.
 
Upvote 0
Back
Top