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!

Creating Charecter

Newbie Spellweaver
Joined
Jun 25, 2008
Messages
31
Reaction score
0
I have a problem i can not create a charecter in the game. :scratch:
If someone can help me ?

Pls can someone tell me how can i insert a charecter direct in to the DB with the query.
 
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
Execute the stored procedure (in the account db) cabal_sp_newchar.
 
Upvote 0
Newbie Spellweaver
Joined
Jun 8, 2008
Messages
34
Reaction score
0
Rexzam: If you get syntax error then its something wrong with your linked server. Maybe you put wrong password and username?

If you have changed port like me then you need to remember to change the ports in both Client Network Utility and Server Network Utility
 
Upvote 0
The Dinosaur
Loyal Member
Joined
Jun 29, 2008
Messages
5,028
Reaction score
999
If the stored procedure isn't working but shows no errors you need to check the log files (/var/log/cabal) for clues as there is probably an error in there.
 
Upvote 0
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
34
Reaction score
0
Here my log`s . Hope Someone can help

CashDBAgent.log
PHP:
[Thu Jul 17 2008 01:18:05.459033 3086468800]: open log file  '/var/log/cabal/CashDBAgent.log'
[Thu Jul 17 2008 01:18:05.459315 3086468800]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:05.459350 3086468800]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:18:05.461846 3086468800]: Start CashDBAgent Server
[Thu Jul 17 2008 01:18:05.463902 3086468800]: UseEcryptText (Off)
[Thu Jul 17 2008 01:18:05.483377 3086465952]: CProcessLayer(0)::svc Start [3086465952]
[Thu Jul 17 2008 01:18:05.484257 3075976096]: CProcessLayer(0)::svc Start [3075976096]
[Thu Jul 17 2008 01:18:05.484398 3065486240]: CProcessLayer(0)::svc Start [3065486240]
[Thu Jul 17 2008 01:18:05.484845 3054996384]: CProcessLayer(0)::svc Start [3054996384]
[Thu Jul 17 2008 01:18:05.487352 3086468800]: try listening 38190 port
[Thu Jul 17 2008 01:18:05.487899 3044506528]: CProcessLayer(0)::svc Start [3044506528]
[Thu Jul 17 2008 01:18:05.488253 3034016672]: CProcessLayer(0)::svc Start [3034016672]
[Thu Jul 17 2008 01:18:05.488349 3023526816]: CProcessLayer(0)::svc Start [3023526816]
[Thu Jul 17 2008 01:18:05.488429 3013036960]: CProcessLayer(0)::svc Start [3013036960]
[Thu Jul 17 2008 01:18:05.488870 3002547104]: CProcessLayer(0)::svc Start [3002547104]
[Thu Jul 17 2008 01:18:05.488934 2992057248]: CProcessLayer(0)::svc Start [2992057248]
[Thu Jul 17 2008 01:52:51.872833 3086583488]: open log file  '/var/log/cabal/CashDBAgent.log'
[Thu Jul 17 2008 01:52:51.873312 3086583488]: LOG LEVEL: 3
[Thu Jul 17 2008 01:52:51.873345 3086583488]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:52:51.874685 3086583488]: Start CashDBAgent Server
[Thu Jul 17 2008 01:52:51.875847 3086583488]: UseEcryptText (Off)
[Thu Jul 17 2008 01:52:51.888437 3086580640]: CProcessLayer(0)::svc Start [3086580640]
[Thu Jul 17 2008 01:52:51.888779 3076090784]: CProcessLayer(0)::svc Start [3076090784]
[Thu Jul 17 2008 01:52:51.888881 3065600928]: CProcessLayer(0)::svc Start [3065600928]
[Thu Jul 17 2008 01:52:51.891817 3086583488]: try listening 38190 port

ChatNode_24.log

PHP:
[Thu Jul 17 2008 01:18:03.757699 3086141120]: open log file  '/var/log/cabal/ChatNode_24.log'
[Thu Jul 17 2008 01:18:03.757805 3086141120]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:03.758100 3086141120]: MemPoolUnitSizeClass(2): 24576Bytes
[Thu Jul 17 2008 01:18:03.760617 3086141120]: Start ChatNode_24 Server
[Thu Jul 17 2008 01:18:03.760873 3086141120]: main(): ChatServerId(250:24:1)
[Thu Jul 17 2008 01:18:03.761086 3086141120]: ReloadConfig(): ReloadConfig
[Thu Jul 17 2008 01:18:03.761114 3086141120]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:03.761150 3086141120]: SetSayChannelMgrLogSay(): LogSay: 0
[Thu Jul 17 2008 01:18:03.761175 3086141120]: ReloadConfig(): BroadCastOverServerNation: 0
[Thu Jul 17 2008 01:18:03.761200 3086141120]: ReloadConfig(): UseGuildCreateFee: 1
[Thu Jul 17 2008 01:18:03.761224 3086141120]: ReloadConfig(): CharLevelForGuildCreate: 40
[Thu Jul 17 2008 01:18:03.761248 3086141120]: ReloadConfig(): AllowGuildBoard: 0
[Thu Jul 17 2008 01:18:03.777790 3085867936]: CProcessLayer(0)::svc Start [3085867936]
[Thu Jul 17 2008 01:18:03.778183 3075378080]: CProcessLayer(0)::svc Start [3075378080]
[Thu Jul 17 2008 01:18:03.778669 3064888224]: CProcessLayer(0)::svc Start [3064888224]
[Thu Jul 17 2008 01:18:03.781271 3086141120]: try connect 192.168.1.5:38170, Sync
[Thu Jul 17 2008 01:18:03.785782 3086141120]: sock 5 ->LinkHandler Open
[Thu Jul 17 2008 01:18:03.786078 3086141120]: SendIPSConnect2Svr (250:24:01:00)
[Thu Jul 17 2008 01:18:03.786141 3086141120]: try connect 192.168.1.5:38181, Sync
[Thu Jul 17 2008 01:18:03.790135 3086141120]: sock 7 ->LinkHandler Open
[Thu Jul 17 2008 01:18:03.790179 3086141120]: SendIPSConnect2Svr (250:24:01:00)
[Thu Jul 17 2008 01:18:03.790231 3086141120]: try listening 38121 port
[Thu Jul 17 2008 01:18:03.793157 3054398368]: CProcessLayer(0)::svc Start [3054398368]
[Thu Jul 17 2008 01:18:03.793243 3043908512]: CProcessLayer(0)::svc Start [3043908512]
[Thu Jul 17 2008 01:18:03.793697 3033418656]: CProcessLayer(0)::svc Start [3033418656]
[Thu Jul 17 2008 01:18:03.794979 3022928800]: CProcessLayer(0)::svc Start [3022928800]
"ChatNode_24.log" 4940L, 403274C

DBAgent_24.log

PHP:
[Thu Jul 17 2008 02:58:31.121809 3086399168]: [##ERROR##] active fail
[Thu Jul 17 2008 02:58:31.121904 3054926752]: CProcessLayer(0)::svc Start [3054926752]
[Thu Jul 17 2008 02:58:31.121967 3044436896]: CProcessLayer(0)::svc Start [3044436896]
[Thu Jul 17 2008 02:58:31.122014 3044436896]: CProcessLayer(0)::svc Terminated [3044436896]
[Thu Jul 17 2008 02:58:31.122115 3086396320]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 02:58:31.122141 3086396320]: CProcessLayer(0)::svc Terminated [3086396320]
[Thu Jul 17 2008 02:58:31.122190 3075906464]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 02:58:31.122215 3075906464]: CProcessLayer(0)::svc Terminated [3075906464]
[Thu Jul 17 2008 02:58:31.122260 3065416608]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 02:58:31.122284 3065416608]: CProcessLayer(0)::svc Terminated [3065416608]
[Thu Jul 17 2008 02:58:31.122331 3054926752]: CProcessLayer(0)::svc Terminated [3054926752]
[Thu Jul 17 2008 02:58:31.392047 3085907648]: accept success 10(192.168.1.5:33039)
[Thu Jul 17 2008 02:58:31.392640 3085907648]: 2.open user 10 [98669B8] (192.168.1.5)
[Thu Jul 17 2008 02:58:31.394249 3085907648]: 2.close user 10 [98669B8] (192.168.1.5)
[Thu Jul 17 2008 03:56:56.024165 3085904800]: SIGTERM
3085907648: work_pending_i: Interrupted system call
[Thu Jul 17 2008 03:56:56.321923 3085904800]: CProcessLayer(0)::svc Terminated [3085904800]
[Thu Jul 17 2008 03:56:56.322659 3054435232]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 03:56:56.322907 3054435232]: CProcessLayer(0)::svc Terminated [3054435232]
[Thu Jul 17 2008 03:56:56.323021 3075414944]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 03:56:56.323049 3075414944]: CProcessLayer(0)::svc Terminated [3075414944]
[Thu Jul 17 2008 03:56:56.323560 3064925088]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 03:56:56.323586 3064925088]: CProcessLayer(0)::svc Terminated [3064925088]
[Thu Jul 17 2008 03:56:56.324910 3043945376]: [##ERROR##] getq fail (108)
[Thu Jul 17 2008 03:56:56.324938 3043945376]: CProcessLayer(0)::svc Terminated [3043945376]
[Thu Jul 17 2008 03:58:57.119703 3086350016]: open log file  '/var/log/cabal/DBAgent_24.log'
"DBAgent_24.log"

GlobalDBAgent.log

PHP:
[Thu Jul 17 2008 01:18:01.643087 3086452416]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Thu Jul 17 2008 01:18:01.643221 3086452416]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:01.643257 3086452416]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:18:01.647344 3086452416]: Start GlobalDBAgent Server
[Thu Jul 17 2008 01:18:01.649270 3086452416]: UseEcryptText (Off)
[Thu Jul 17 2008 01:18:01.657829 3086449568]: CProcessLayer(0)::svc Start [3086449568]
[Thu Jul 17 2008 01:18:01.658092 3075959712]: CProcessLayer(0)::svc Start [3075959712]
[Thu Jul 17 2008 01:18:01.658193 3065469856]: CProcessLayer(0)::svc Start [3065469856]
[Thu Jul 17 2008 01:18:01.658264 3054980000]: CProcessLayer(0)::svc Start [3054980000]
[Thu Jul 17 2008 01:18:01.659848 3086452416]: try listening 38180 port
[Thu Jul 17 2008 01:18:01.660756 3044490144]: CProcessLayer(0)::svc Start [3044490144]
[Thu Jul 17 2008 01:18:01.660872 3034000288]: CProcessLayer(0)::svc Start [3034000288]
[Thu Jul 17 2008 01:18:01.660955 3023510432]: CProcessLayer(0)::svc Start [3023510432]
[Thu Jul 17 2008 01:18:01.661177 3013020576]: CProcessLayer(0)::svc Start [3013020576]
[Thu Jul 17 2008 01:18:01.661251 3002530720]: CProcessLayer(0)::svc Start [3002530720]
[Thu Jul 17 2008 01:18:01.661319 2992040864]: CProcessLayer(0)::svc Start [2992040864]
[Thu Jul 17 2008 01:18:03.139940 3086452416]: accept success 8(192.168.1.5:32800)
[Thu Jul 17 2008 01:18:03.142317 3086452416]: 1.open user 8 [935FA88] (192.168.1.5)
[Thu Jul 17 2008 01:18:05.021648 3086452416]: accept success 10(192.168.1.5:32804)
[Thu Jul 17 2008 01:18:05.023864 3086452416]: 2.open user 10 [936E1C8] (192.168.1.5)
[Thu Jul 17 2008 01:52:49.971859 3086403264]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Thu Jul 17 2008 01:52:49.972091 3086403264]: LOG LEVEL: 3
[Thu Jul 17 2008 01:52:49.972127 3086403264]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:52:49.975012 3086403264]: Start GlobalDBAgent Server
[Thu Jul 17 2008 01:52:49.977023 3086403264]: UseEcryptText (Off)
"GlobalDBAgent.log" 4502L, 369949C

GlobalMgrSvr.log

PHP:
[Thu Jul 17 2008 01:18:03.015196 3086128832]: open log file  '/var/log/cabal/GlobalMgrSvr.log'
[Thu Jul 17 2008 01:18:03.016029 3086128832]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:03.016206 3086128832]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:18:03.018870 3086128832]: Start GlobalMgrSvr Server
[Thu Jul 17 2008 01:18:03.040898 3086128832]: LoadServerAndChannelType(1)
[Thu Jul 17 2008 01:18:03.056535 3086128832]: channelType[24][1]: 1
[Thu Jul 17 2008 01:18:03.057214 3086128832]: maxUserName[24][1]: 300
[Thu Jul 17 2008 01:18:03.135843 3086128832]: try connect 192.168.1.5:38180, Sync
[Thu Jul 17 2008 01:18:03.143860 3086128832]: sock 7 ->LinkHandler Open
[Thu Jul 17 2008 01:18:03.144233 3086128832]: SendIPSConnect2Svr (246:128:00:00)
[Thu Jul 17 2008 01:18:03.144285 3086128832]: try listening 38170 port
[Thu Jul 17 2008 01:18:03.146824 3085659040]: CProcessLayer(0)::svc Start [3085659040]
[Thu Jul 17 2008 01:18:03.783870 3086128832]: accept success 10(192.168.1.5:32801)
[Thu Jul 17 2008 01:18:03.784170 3086128832]: 1.open user 10 [8DB1E48] (192.168.1.5)
[Thu Jul 17 2008 01:18:05.015427 3086128832]: accept success 11(192.168.1.5:32803)
[Thu Jul 17 2008 01:18:05.016402 3086128832]: 2.open user 11 [8DB82B0] (192.168.1.5)
[Thu Jul 17 2008 01:18:10.012528 3085659040]: [##ERROR##] OnIPCNFYUserCnt0(): pUserDataCtx(bServerIdx:0, bGroupIdx:0), pIPSNFYUserCnt0(bServerIdx:128, bGroupIdx:1)
[Thu Jul 17 2008 01:18:10.012653 3085659040]: [##ERROR##] 'OnIPCNFYUserCnt0' fail (Proc/Global.cpp:21)
[Thu Jul 17 2008 01:18:10.012682 3085659040]: [##ERROR##] UsrMap Fail : MainCmd(52) Ret(15:0:21) Addr(192.168.1.5)
[Thu Jul 17 2008 01:18:12.012856 3086128832]: sock 11 ->handle_timeout
[Thu Jul 17 2008 01:18:12.013897 3086128832]: 2.close user -1 [8DB82B0] (192.168.1.5)
[Thu Jul 17 2008 01:18:17.016568 3086128832]: accept success 11(192.168.1.5:32806)
[Thu Jul 17 2008 01:18:17.017093 3086128832]: 2.open user 11 [8DB82B0] (192.168.1.5)
"GlobalMgrSvr.log" 4125L, 354343C

LoginSvr_01.log

PHP:
[Thu Jul 17 2008 01:18:04.547544 3086841536]: open log file  '/var/log/cabal/LoginSvr_01.log'
[Thu Jul 17 2008 01:18:04.547974 3086841536]: LOG LEVEL: 3
[Thu Jul 17 2008 01:18:04.548012 3086841536]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jul 17 2008 01:18:04.550997 3086841536]: Start LoginSvr_01 Server
[Thu Jul 17 2008 01:18:04.551886 3086841536]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Thu Jul 17 2008 01:18:04.551994 3086841536]: TestChannelGroupIdxStartPoint=50
[Thu Jul 17 2008 01:18:04.552044 3086841536]: affiliatedCorpIP=192.168.2.99;
[Thu Jul 17 2008 01:18:04.552071 3086841536]: AdminIP=121.170.135.;
[Thu Jul 17 2008 01:18:04.552101 3086841536]: client_version=1262
[Thu Jul 17 2008 01:18:04.552465 3086841536]: IgnoreClientVersion(0)
[Thu Jul 17 2008 01:18:04.552495 3086841536]: UseAntiOnlineGameAddictionSystem(1)
[Thu Jul 17 2008 01:18:04.552521 3086841536]: AdultAge(18)
[Thu Jul 17 2008 01:18:04.552544 3086841536]: DefaultAgeAdult(1)
[Thu Jul 17 2008 01:18:04.552575 3086841536]: UsePSS(0)
[Thu Jul 17 2008 01:18:04.552600 3086841536]: CachedPSS(0)
[Thu Jul 17 2008 01:18:04.552958 3086841536]: PssCacheDurationMin(1440)
[Thu Jul 17 2008 01:18:04.552982 3086841536]: CutIfPssUserNotFound(0)
[Thu Jul 17 2008 01:18:04.553006 3086841536]: PssLogLevel(0)
[Thu Jul 17 2008 01:18:04.553030 3086841536]: InstantPlayTimeClearIntervalMin(300)
[Thu Jul 17 2008 01:18:04.553053 3086841536]: IDC(1)
[Thu Jul 17 2008 01:18:04.553077 3086841536]: SharedPssPersonId(0)
[Thu Jul 17 2008 01:18:04.553611 3086841536]: NormalClientMagicKey(1168110)
[Thu Jul 17 2008 01:18:04.553637 3086841536]: UseImageAuth(0)
[Thu Jul 17 2008 01:18:04.553661 3086841536]: ImageAuthDataPath(./ImageAuth/)
[Thu Jul 17 2008 01:18:04.553684 3086841536]: ImageAuthMaxTryCount(5)
[Thu Jul 17 2008 01:18:04.553955 3086841536]: ImageAuthWaitTime(120000)

WorldSvr_24_01.log

PHP:
[Thu Jul 17 2008 17:51:02.090241 3086935744]: open log file  '/var/log/cabal/WorldSvr_24_01.log'
[Thu Jul 17 2008 17:51:02.090451 3086935744]: LOG LEVEL: 3
[Thu Jul 17 2008 17:51:02.090512 3086935744]: MemPoolUnitSizeClass(5): 16384Bytes
[Thu Jul 17 2008 17:51:02.091025 3086935744]: Start WorldSvr_24_01 Server
[Thu Jul 17 2008 17:51:02.091084 3086935744]: CheckSkillCoolTimeHack (On)
[Thu Jul 17 2008 17:51:02.091111 3086935744]: CheckShopHack (On)
[Thu Jul 17 2008 17:51:02.091136 3086935744]: CheckWarpHack (On)
[Thu Jul 17 2008 17:51:02.091160 3086935744]: CheckWareHouseHack (On)
[Thu Jul 17 2008 17:51:02.091192 3086935744]: UseCheckDistanceSkillHack (On)
[Thu Jul 17 2008 17:51:02.091218 3086935744]: MaxTimeHackingCount(2)
[Thu Jul 17 2008 17:51:02.091243 3086935744]: MaxDistanceHackingCount(2)
[Thu Jul 17 2008 17:51:02.091267 3086935744]: UseNonClientCheck (On)
[Thu Jul 17 2008 17:51:02.091291 3086935744]: NonClientDisAdvantageRate (90)
[Thu Jul 17 2008 17:51:02.091317 3086935744]: useDropDiscount (On)
[Thu Jul 17 2008 17:51:02.091341 3086935744]: UseBlessingBeadCheck (On)
[Thu Jul 17 2008 17:51:02.091366 3086935744]: AllowTradeChannel (Off)
[Thu Jul 17 2008 17:51:02.091390 3086935744]: UseCheckMissionIdx(On)
[Thu Jul 17 2008 17:51:02.091414 3086935744]: UseCheckDeadStatActive(On)
[Thu Jul 17 2008 17:51:02.091438 3086935744]: reload ActiveDeadStatCount(30)
[Thu Jul 17 2008 17:51:02.091462 3086935744]: UseHackcheckByTimeScope (On)
[Thu Jul 17 2008 17:51:02.091487 3086935744]: CheckSkillTimeHackScope(60000)
[Thu Jul 17 2008 17:51:02.091511 3086935744]: UseMobsChaseModify (On)
[Thu Jul 17 2008 17:51:02.091535 3086935744]: UseAlzDbHackCheck (On)
[Thu Jul 17 2008 17:51:02.091559 3086935744]: UseCutIfAlzDbHacked (On)
[Thu Jul 17 2008 17:51:02.091583 3086935744]: useCheckUserAttack (On)
[Thu Jul 17 2008 17:51:02.091612 3086935744]: UseHackUserDBSave (On)
 
Upvote 0
The Cat in the Hat
Legend
Joined
Oct 26, 2005
Messages
4,475
Reaction score
677
I should have watched my mouth and not said/talked poop to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.
 
Upvote 0
Newbie Spellweaver
Joined
Jul 14, 2008
Messages
34
Reaction score
0
restore it 4 times .. its not working

any database command for create char?
 
Upvote 0
Back
Top