Most visitors online was 11705 , on 26 Apr 2024
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!Thats what i was about to try...
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.
Maybe I did it wrong but importing .xls files gave many duplicate table entries that were still empty.
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...
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.
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
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-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)