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!

Must read for ep3 server

Status
Not open for further replies.

PTG

Newbie Spellweaver
Joined
Jan 14, 2010
Messages
24
Reaction score
15
Re: [Solved] Question about ep3 config files

If you do find it, please up it. I'd like to take a look around it ;s
 
Experienced Elementalist
Joined
Nov 30, 2008
Messages
271
Reaction score
0
Re: [Solved] Question about ep3 config files

That DB was missing some EP 3 stuff and what was listed in there, was empty...
 
Banned
Banned
Joined
Sep 16, 2010
Messages
8
Reaction score
5
Re: [Solved] Question about ep3 config files

That DB was missing some EP 3 stuff and what was listed in there, was empty...

Because you have to import the .xls file which is floating around....

I can tell that DB is the base of the current ep3.3 setup. Ofcourse needed lots of updates, but it's the base.

It should do fine for a ep3.2 setup though.
 
Experienced Elementalist
Joined
Nov 30, 2008
Messages
271
Reaction score
0
Re: [Solved] Question about ep3 config files

Because you have to import the .xls file which is floating around....

I can tell that DB is the base of the current ep3.3 setup. Ofcourse needed lots of updates, but it's the base.

It should do fine for a ep3.2 setup though.

Maybe I did it wrong but importing .xls files gave many duplicate table entries that were still empty.
 
Banned
Banned
Joined
Sep 16, 2010
Messages
8
Reaction score
5
Re: [Solved] Question about ep3 config files

Maybe I did it wrong but importing .xls files gave many duplicate table entries that were still empty.

It doesn't matter if there are empty entries. The Localization\ti_%s.cfg takes care of all the names and descriptions.

:thumbup:
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

I think theres something wrong with servergroupinfo. If theres someone good at disassembly pls try to find wtf happens when preserver reads the servergroupinfo. I thought it used the "ServerGroup: %20s, Enable(%d) MGameServerID(%05d)" text to scanf it but somethings wrong, even if it runs. Notice that i use only 1 dollar ($) sign before SERVER_GROUP_INFOs in pre.cfg and double dollar sign ($$) in global.cfg cause otherwise it has an error (mgameserverid is somehow 0 oO). So i think that it doesnt read the second variable correctly (whereas it replaces the first one with "Pandea"). Hope theres someone interested...
 
Last edited:
Newbie Spellweaver
Joined
Jul 22, 2010
Messages
33
Reaction score
18
Re: [Solved] Question about ep3 config files

I think theres something wrong with servergroupinfo. If theres someone good at disassembly pls try to find wtf happens when preserver reads the servergroupinfo. I thought it used the "ServerGroup: %20s, Enable(%d) MGameServerID(%05d)" text to scanf it but somethings wrong, even if it runs. Notice that i use only 1 dollar ($) sign before SERVER_GROUP_INFOs in pre.cfg and double dollar sign ($$) in global.cfg cause otherwise it has an error (mgameserverid is somehow 0 oO). So i think that it doesnt read the second variable correctly (whereas it replaces the first one with "Pandea"). Hope theres someone interested...

"ServerGroup: %20s, Enable(%d) MGameServerID(%05d)" This setting is good for me, if I use 1 $ in global.cfg and 2 $-s in pre.cfg, server starts, but it has a DB error.
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

I gotta say a big thx to all those who upped ep3 stuff so ima tell you the answer. Check this thread :Read Carefully
Consider that if you gave it atum as db user (4 chars) it says it tried to log in with a J3 user (2 chars). 4 chars are turned into 2, straightforward.


One more thing: try editing the $$SERVER_GROUP_INFO1 = "A random string lol"
Itll work without error!! So as i said, somethings wrong... And this thing later will most probably cause an error.

Oh i found it. Check post #13 for correct ServerGroupInfo config (i hope it is). The string i mentioned was really misleading but while disassembling i noticed it looked for other stuff (like TRUE instead of Enable(1) and it first looked for the servergroupid and THEN for this "TRUE"). After all it wasnt of any practical use to have stuff like ServerGroup:, Enable(), MGameServerID() in the strings; its easier to just give the values. Anyway, atm im stuck with InitDbTable() error.
 
Last edited:
Newbie Spellweaver
Joined
Jul 22, 2010
Messages
33
Reaction score
18
Re: [Solved] Question about ep3 config files

I've wondered, how easy to get InitDBTable() working.

You MUST use EP3 database from Filterheadz release, and you must configure $DB_SERVER_IP to atum2_db_account. The PreServer calls atum_PROCEDURE_080827_0087 and that procedure is in atum2_db_account.

Attachment: Log file of working PreServer.
 

Attachments

You must be registered for see attachments list
Junior Spellweaver
Joined
Apr 5, 2006
Messages
113
Reaction score
75
Re: [Solved] Question about ep3 config files

I see some missing things in PreSystem there...
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

I've wondered, how easy to get InitDBTable() working.

You MUST use EP3 database from Filterheadz release, and you must configure $DB_SERVER_IP to atum2_db_account. The PreServer calls atum_PROCEDURE_080827_0087 and that procedure is in atum2_db_account.

Attachment: Log file of working PreServer.

Thx for pointing this out. It was as simple as changing this line:
$DB_SEVER_DATABASE_NAME atum2_db_1
To this:
$DB_SEVER_DATABASE_NAME atum2_db_account

*imagines myselef debugging obdc.dll trying to find out wtf goes wrong*

Indeed the error it returned me was that the proceedure didnt exist... :mellow:



Working log:
Code:
12-12 16:24:35|[Notify] elapsed time after turn on !!  0Day  6h:15m:33s 
12-12 16:24:35|Pre Server Start
12-12 16:24:35|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[  100] CommitSize[  151552] vectorSize[1] Address Range(0x7FF80000 ~ 0x7FFA5000)
12-12 16:24:35|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[  101] CommitSize[  155648] vectorSize[1] Address Range(0x7FF50000 ~ 0x7FF76000)
12-12 16:24:35|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[15001] CommitSize[23281664] vectorSize[1] Address Range(0x7E0B0000 ~ 0x7F6E4000)
12-12 16:24:35|	ServerGroup:               Pandea, Enable(1) MGameServerID(10061)
12-12 16:24:35|	ServerGroup:                    A, Enable(0) MGameServerID(10062)
12-12 16:24:35|	ServerGroup:                    B, Enable(0) MGameServerID(10063)
12-12 16:24:35|	ServerGroup:                    C, Enable(0) MGameServerID(10064)
12-12 16:24:35|	ServerGroup:                    D, Enable(0) MGameServerID(10065)
12-12 16:24:56|  [Notify] CPreGlobal::OnPacketNotifyOfSPToMPWinSoc# 10000 CWinSocket::WS_CONNECTED wParam(0) 
12-12 16:24:56|  [Notify] CPreGlobal::InitServerSocket# Starting... 
12-12 16:24:56|  [Notify] CPreIOCP::IOCPInit# 10000 
12-12 16:24:56|  [Notify] CPreIOCP::IOCPInit# 11000 updated version files !
12-12 16:24:56|  [Notify] CPreIOCP::IOCPInit# 12000 arranged version list !
12-12 16:24:56|  [Notify] CPreIOCP::IOCPInit# 13000 connected to db server !
12-12 16:24:56|  [Notify] CPreIOCP::IOCPInit# 14000 called CPreIOCP::InitDBTable# 
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5700, 0x1644)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5236, 0x1474)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4740, 0x1284)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2616, 0xA38)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4928, 0x1340)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4776, 0x12A8)
12-12 16:24:56|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5580, 0x15CC)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  6104, 0x17D8)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2368, 0x940)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(   280, 0x118)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3604, 0xE14)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5940, 0x1734)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5968, 0x1750)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  6044, 0x179C)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2524, 0x9DC)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4556, 0x11CC)
12-12 16:24:57|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2968, 0xB98)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  1152, 0x480)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3244, 0xCAC)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(   996, 0x3E4)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4180, 0x1054)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4652, 0x122C)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4140, 0x102C)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4412, 0x113C)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5468, 0x155C)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4416, 0x1140)
12-12 16:24:58|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4428, 0x114C)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3248, 0xCB0)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3856, 0xF10)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4472, 0x1178)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  1120, 0x460)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2200, 0x898)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2204, 0x89C)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4836, 0x12E4)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4732, 0x127C)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4768, 0x12A0)
12-12 16:24:59|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4696, 0x1258)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4788, 0x12B4)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5300, 0x14B4)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5564, 0x15BC)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5944, 0x1738)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5904, 0x1710)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4384, 0x1120)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4028, 0xFBC)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  1976, 0x7B8)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  2632, 0xA48)
12-12 16:25:00|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3588, 0xE04)
12-12 16:25:01|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  4132, 0x1024)
12-12 16:25:01|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  5676, 0x162C)
12-12 16:25:01|CAtumDBManager::AtumDBWorker_ DWWorkerThread, 	 ThreadID(  3608, 0xE18)
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 15000 CAtumPreDBManager::Init# !
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 16000 CPreTickManager::InitTickManager# !
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 17000 CAccountBlockManager::CAccountBlockManager# !
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 18000 CPreIOCP::LoadBlockedAccounts# !
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 19000 arranged ServerGroupList !
12-12 16:25:01|  [Notify] CPreIOCP::IOCPInit# 20000 end !
12-12 16:25:01|########################	Server IOCPInit		########################
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  4464, 0x1170)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  3792, 0xED0)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  4832, 0x12E0)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  5820, 0x16BC)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  3908, 0xF44)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  4844, 0x12EC)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  1456, 0x5B0)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  3436, 0xD6C)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  2756, 0xAC4)
12-12 16:25:01|CIOCP::Worker_ WorkerThread, 					 ThreadID(  5696, 0x1640)
12-12 16:25:01|CIOCP::Writer_ WriterThread, 					 ThreadID(  4240, 0x1090)
12-12 16:25:01|CIOCP::Writer_ WriterThread, 					 ThreadID(  4224, 0x1080)
12-12 16:25:01|  [Notify] CPreGlobal::InitServerSocket# Started 
12-12 16:25:01|CIOCP::Listen_ ListenerThread, 				 ThreadID(  4684, 0x124C)
12-12 16:32:22|  [Notify] CPreGlobal::EndServerSocket# 
12-12 16:32:22|CGlobalGameServer::EndServerSocket_1
12-12 16:32:22|########################	Server IOCPClean	########################

12-12 16:32:22|########################	Server IOCPClean	########################

12-12 16:32:22|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1508] TotalCommitedObjCnts(   100) CurrentObjCnts(   100)
12-12 16:32:22|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1528] TotalCommitedObjCnts(   101) CurrentObjCnts(   101)
12-12 16:32:22|[Notify] CVMem::FreeAllVMem_ TypeSize[ 1552] TotalCommitedObjCnts( 15001) CurrentObjCnts( 15001)
12-12 16:32:22|Pre Server End


12-12 16:32:22|CGlobalGameServer::EndServerSocket_1

This is my log and seems ok imo. Warzinger your servergoupinfo isnt ok, i told you. Check the updated post #13. :wink:

12-12 16:24:35| ServerGroup: Pandea, Enable(1) MGameServerID(10061)
12-12 16:24:35| ServerGroup: A, Enable(0) MGameServerID(10062)
12-12 16:24:35| ServerGroup: B, Enable(0) MGameServerID(10063)
12-12 16:24:35| ServerGroup: C, Enable(0) MGameServerID(10064)
12-12 16:24:35| ServerGroup: D, Enable(0) MGameServerID(10065)

Thats where the "ServerGroup: %20s, Enable(%d) MGameServerGroup(%05d)" is in the exe. In the %05d the 0 doesnt make sense if it was to read.
 
Last edited:
Newbie Spellweaver
Joined
Jul 22, 2010
Messages
33
Reaction score
18
Re: [Solved] Question about ep3 config files

Thank you PanKJ, I've made PreServer working.

I think, 1 $ is needed, when there is only 1 data in the variable, and 2 $-s are required if the variable contains more data.
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

Did you manage to run the rest of them? Theyre relatively easy considering what ive posted so far. Ill post all cfg files in a while. Also logserver under certain circumstances attempts to open a non-existing file. I made a fixed version of it but later noticed that as long as the cfg files are corrects it runs ok anyway.
 
Newbie Spellweaver
Joined
Dec 5, 2010
Messages
29
Reaction score
3
Re: [Solved] Question about ep3 config files

What did I wrong when I get LoadConfiguration Error ?
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

With PreServer_ep3? Check post #13 (it has been updated). If it still wont work post your log.
 
Last edited:
Newbie Spellweaver
Joined
Dec 5, 2010
Messages
29
Reaction score
3
Re: [Solved] Question about ep3 config files

Edit: OK, I'll test it!

---------- Post added at 10:16 PM ---------- Previous post was at 10:11 PM ----------

Nope, it doesn't work.....

Here's my log

Code:
12-13 22:15:31|[Notify] elapsed time after turn on !!  0Day  4h:57m: 2s 
12-13 22:15:31|Pre Server Start
12-13 22:15:31|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[  100] CommitSize[  151552] vectorSize[1] Address Range(0x7FF80000 ~ 0x7FFA5000)
12-13 22:15:31|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[  101] CommitSize[  155648] vectorSize[1] Address Range(0x7FF50000 ~ 0x7FF76000)
12-13 22:15:31|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[15001] CommitSize[23281664] vectorSize[1] Address Range(0x7E0B0000 ~ 0x7F6E4000)

P.S I go sleeping, in my time zone it's 22:49, and I have to get up very early.... so Good Night @ all ;)
 
Last edited:
Joined
Sep 7, 2010
Messages
431
Reaction score
263
Re: [Solved] Question about ep3 config files

lol for me it was 23:50... Anyway i got my server fully running and all i have to do is fixxing map, localization, (i suppose omi) etc. Ill up my preserver and my pre.cfg along with global.cfg. If it doesnt work then somethings wrong with your pc/os or something idk about.

One more tip: im, field and npc servers require ti_LuckyMachine.cfg to have valid entries. Otherwise you get config erros. (took me a day to figure this out - in the end i randomly found out that it got the error shortly after reading some localization files... :mellow: )
 

Attachments

You must be registered for see attachments list
Last edited:

PTG

Newbie Spellweaver
Joined
Jan 14, 2010
Messages
24
Reaction score
15
Re: [Solved] Question about ep3 config files

Great work PanKJ =D
 
Status
Not open for further replies.
Back
Top