THIS SERVER IS NOT CURRENTLY OPERATIONAL AND IS IN DEVELOPMENT!!!!
Against my better judgement, I am here to provide you the current work being done at Redemption / xSanadu and other Development Crews as a unified force. The work is going smooth, but we still must sniff out changes that the new Game Server expects to be present in the databases.
First we'll start off with the important information:
Debug of Current Crash
Code:
==============================================================================
------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------
00 Thread name : IOCP 03
00 job info :
00 job id : 0
00 counter : 0
00 execute time : 0
01 Thread name : IOCP 02
01 job info :
01 job id : 0
01 counter : 0
01 execute time : 0
02 Thread name : IOCP 01
02 job info :
02 job id : 0
02 counter : 0
02 execute time : 0
03 Thread name : IOCP 00
03 job info :
03 job id : 0
03 counter : 0
03 execute time : 0
04 Thread name : Scheduler 00
04 job info : ItemCollector(0x40519510)
04 job id : 0
04 counter : 0
04 execute time : 64
05 Thread name : Scheduler 01
05 job info : _ServerStatusReport(0x40512050)
05 job id : 0
05 counter : 0
05 execute time : 64
06 Thread name : Scheduler 02
06 job info :
06 job id : 0
06 counter : 0
06 execute time : 0
07 Thread name : Scheduler 03
07 job info :
07 job id : 0
07 counter : 0
07 execute time : 0
------------------------------------------------------------------------------
Basic Information
------------------------------------------------------------------------------
Program Name : Arcadia
EXE : C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe
User : Administrator
Computer :
Program :
Exception : C0000094 (INT_DIVIDE_BY_ZERO)
Fault Address: 00000001401A6F74 01:001A5F74
Mem Usage : 1543824KB / 1500020KB
------------------------------------------------------------------------------
Allocation Count Info(by _MEM_USAGE_DEBUG)
------------------------------------------------------------------------------
Type: StructSummon Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: StructQuestManager Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: StructPlayer Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------
RAX=000030D457FEB3F0 RBX=000000005E79FA10 RCX=0000000000000000 RDX=0000000000000000
ESI=0000000000000000 EDI=0000000000000000 EBP=00000001401A6EE0
DS =002B ES=002B FS=0053 GS:002B
CS:RIP=0033:00000001401A6F74
SS:RSP=002B:000000005E79F8E0
Flags=00010246
------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00E3664E
app.cmdline : "C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe"
app.filesize : 5690368
app.filetime : 2012/03/09-14:59:36
db.c._password :
db.c.account : sa
db.c.name : Arcadia
db.c.server : 127.0.0.1
db.user._password :
db.user.account : sa
db.user.name : Telecaster
db.user.server : 127.0.0.1
db.user.thread_active : 0
db.user.thread_total : 0
db.user.work_active : 0
db.user.work_pending : 0
db.user.work_total : 1
engine.ar_time : 1106
engine.count_client : 0
engine.count_movable : 0
engine.count_static : 0
engine.lock : 0
engine.region_size : 180
engine.scheduler.0.instruction : 24
engine.scheduler.0.object : 1
engine.scheduler.1.instruction : 14
engine.scheduler.1.object : 1
engine.scheduler.2.instruction : 24
engine.scheduler.2.object : 0
engine.scheduler.3.instruction : 24
engine.scheduler.3.object : 0
engine.scheduler.destroy_cnt : 0
engine.scheduler.destroy_loop : 23
engine.scheduler.destroy_pend : 0
engine.use_region_debug : 0
engine.wait : 0
game.AdultServer : 0
game.AutoOpenOnly : 0
game.PKServer : 0
game.allowed_special_char :
game.ally_pcbang_bonus_rate : 0.100000
game.ally_pcbang_chaos_bonus_rate : 0.100000
game.apply_stamina_bonus_in_premium_pcbang : 0
game.auction_process_request_min_interval : 100
game.auction_search_request_min_interval : 300
game.bUseLockDelayLogging : 0
game.base_ethereal_durability_consumption_on_damage : 98
game.base_ethereal_durability_consumption_on_normal_attack : 31
game.base_ethereal_durability_consumption_on_skill_attack : 51
game.broadcast_event_item_pickup : 0
game.cash_item_dropable : 0
game.cash_usable_server : 0
game.chaos_drop_rate : 1.000000
game.check_storage_security_always : 1
game.disable_buy_booth : 0
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_pk_on : 0
game.exp_rate : 1.000000
game.farm_growth_summon_exp : 347264
game.farm_normal_summon_exp : 137700
game.force_unregister_account_on_kick_fail : 0
game.gold_drop_rate : 1.000000
game.ignore_random_damage : 0
game.item_count : 0
game.item_drop_rate : 1.000000
game.item_hold_time : 180000
game.limit_adv_chat_count : 1
game.limit_booth_openable_layer_to_zero : 0
game.limit_dungeon_enterable_level : 0
game.limit_field_logout : 0
game.limit_game_time : 0
game.local_flag : 1
game.log_required_item_list :
game.log_required_state_list :
game.logout_timer : 1000
game.map_height : 1000000
game.map_width : 700000
game.max_characters_per_account : 6
game.max_game_time_limited_age : 17
game.max_healthy_game_time : 1080000
game.max_layer : 256
game.max_level : 170
game.max_storage_item_count : 1000
game.max_tired_game_time : 1800000
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 0
game.mod : 0.000000
game.monster_drop_respawn : 0
game.monster_pathfinding : 0
game.monster_respawn_cnt : 0
game.monster_respawn_object_cnt : 0
game.monster_respawn_try_cnt : 0
game.monster_wandering : 1
game.no_collision_check : 0
game.no_skill_cooltime : 0
game.party_exp_rate : 1.000000
game.period_of_security_solution_check : 30000
game.play_point_accumulate_amount : 1
game.play_point_accumulate_term : 60
game.premium_pcbang_bonus_rate : 1.200000
game.premium_pcbang_chaos_bonus_drop_rate : 1.000000
game.premium_pcbang_chaos_bonus_rate : 0.100000
game.premium_pcbang_gold_bonus_drop_rate : 1.000000
game.premium_pcbang_item_bonus_drop_rate : 1.000000
game.premium_pcbang_play_point_bonus_rate : 2.000000
game.pvp_damage_rate_for_player : 0.050000
game.pvp_damage_rate_for_summon : 0.050000
game.restrict_banword_for_booth : 0
game.restrict_special_char : 1
game.security_solution_exceptional_ip :
game.security_solution_response_timeout : 3000
game.security_solution_type : 0
game.skip_loading_attribute : 0
game.speed_unit : 30
game.stamina_bonus_rate : 1.000000
game.super_save_bonus_rate : 2.000000
game.super_save_level_limit : 130
game.use_auto_jail : 1
game.use_auto_trap : 1
game.use_delete_security : 0
game.use_guild_donation_point : 0
game.use_login_logout_debug : 0
game.use_play_point : 0
game.use_security : 0
game.use_storage_security : 0
game.user_count : 0
io.connection : 0
io.recv_byte : 0
io.recv_count : 0
io.send_byte : 0
io.send_count : 0
io.use_message_statistics : 0
iocp.active : 0
iocp.dis_count : 0
iocp.instruction : 0
iocp.total : 4
log.chat.working : 0
log.connect_Main : 0
log.connect_Scheduler 01 : 0
log.server_name : CA Game Server
log.working : 1
memory.item_heap_size : 246272
memory.monster_heap_size : 299880
memory.player_heap_size : 22752
memory.summon_heap_size : 86560
process.id : 5412
process.load : 338
process.load_kernel : 94
process.load_user : 5
process.memory : 1544672
process.memory_peak : 1545580
process.paged_memory : 1500888
process.paged_memory_peak : 1500888
process.start : 2012/03/11-09:21:28
process.uptime : 11 Second
thread.db.0.proc : DB_OnStartUp
thread.scheduler.0.proc : ItemCollector
thread.scheduler.1.proc : _ServerStatusReport
------------------------------------------------------------------------------
Application-specific log
------------------------------------------------------------------------------
PlayerHeapSize : 22752 kb
MonsterHeapSize : 299880 kb
ItemHeapSize : 246272 kb
SummonHeapSize : 86560 kb
PetHeapSize : 8440 kb
SkillHeapSize : 51840 kb
QuestHeapSize : 5760 kb
DBHeapSize : 13218 kb
------------------------------------------------------------------------------
Call Stack (Short)
------------------------------------------------------------------------------
Address Frame Function SourceFile
00000001401A6F74 000000005E79F900 0001:001A5F74 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
00000001401A7D59 000000005E79FC00 0001:001A6D59 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
00000001401A8F77 000000005E79FD30 0001:001A7F77 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
0000000140037B77 000000005E79FEF0 0001:00036B77 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
00000001403827D7 000000005E79FF20 0001:003817D7 C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
00000001403828AF 000000005E79FF50 0001:003818AF C:\Users\Administrator\Documents\Redemption\CaptainHerlockServer-Arab.exe (e487)
000000007702652D 000000005E79FF80 BaseThreadInitThunk+D
000000007725C521 000000005E79FFD0 RtlUserThreadStart+21
------------------------------------------------------------------------------
Memory Dump
------------------------------------------------------------------------------
Code: 16 bytes starting at (RIP = 00000000401A6F74)
401A6F74: 48 F7 F9 B9 01 00 00 00 49 89 01 41 0F B6 40 40 H.......I..A..@@
Stack: 1024 bytes starting at (RSP = 000000005E79F8E0)
5E79F8E0: 28 AF E8 5D 00 00 00 00 00 00 00 00 00 00 00 00 (..]............
5E79F8F0: 78 2C A3 5D 00 00 00 00 00 00 00 00 00 00 00 00 x,.]............
5E79F900: 10 AF E8 5D 00 00 00 00 59 7D 1A 40 01 00 00 00 ...]....Y}.@....
5E79F910: 01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79F920: 00 00 00 00 00 00 00 00 10 AF E8 5D 00 00 00 00 ...........]....
5E79F930: 01 00 00 00 00 00 00 00 02 00 00 00 00 00 00 00 ................
5E79F940: 10 AF E8 5D 00 00 00 00 00 00 00 00 00 00 00 00 ...]............
5E79F950: 38 B0 E8 5D 00 00 00 00 F4 FB F6 02 00 00 00 00 8..]............
5E79F960: 0F 7E 3F 4B A3 FD 00 00 03 00 00 00 00 00 00 00 .~?K............
5E79F970: B0 76 C3 01 00 00 00 00 F0 EF 42 00 00 00 00 00 .v........B.....
5E79F980: F8 9C 3E 40 01 00 00 00 4C 3E 02 40 01 00 00 00 ..>@....L>.@....
5E79F990: B0 F9 79 5E 00 00 00 00 00 00 42 00 00 00 00 00 ..y^......B.....
5E79F9A0: 28 A2 E7 5D 00 00 00 00 20 F0 42 00 00 00 00 00 (..].... .B.....
5E79F9B0: 00 00 00 00 00 00 00 00 08 F8 20 00 00 00 00 00 .......... .....
5E79F9C0: 02 00 00 01 02 00 08 01 FE FF FF FF FF FF FF FF ................
5E79F9D0: 08 00 00 00 00 00 00 00 08 F8 20 00 00 00 00 00 .......... .....
5E79F9E0: 02 00 00 01 02 00 08 01 00 02 04 01 00 02 0C 01 ................
5E79F9F0: 09 00 42 00 00 00 00 00 28 A2 E7 5D 00 00 00 00 ..B.....(..]....
5E79FA00: 20 F0 42 00 00 00 00 00 0F 00 00 00 00 00 00 00 .B.............
5E79FA10: 28 F1 40 40 01 00 00 00 00 00 00 00 00 00 00 00 (.@@............
5E79FA20: 00 00 00 00 60 59 3F ED 38 59 BF B4 00 00 00 00 ....`Y?.8Y......
5E79FA30: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA40: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA60: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA70: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FA90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FAA0: 00 00 00 00 00 00 00 00 00 00 00 00 02 12 08 01 ................
5E79FAB0: 00 00 00 00 00 00 00 00 02 12 00 21 02 12 08 21 ...........!...!
5E79FAC0: 0A 10 00 01 0A 10 08 01 0A 12 00 01 0A 12 08 01 ................
5E79FAD0: C8 FB 79 5E 00 00 00 00 7A 9B 00 40 01 00 00 00 ..y^....z..@....
5E79FAE0: D0 FB 79 5E 00 00 00 00 09 00 00 00 00 00 00 00 ..y^............
5E79FAF0: 00 00 00 00 00 00 00 00 C0 F1 43 40 01 00 00 00 ..........C@....
5E79FB00: CA F1 43 40 01 00 00 00 AF 40 02 40 01 00 00 00 ..C@.....@.@....
5E79FB10: C8 FB 79 5E 00 00 00 00 F0 CC 4E 40 01 00 00 00 ..y^......N@....
5E79FB20: C0 F1 43 40 01 00 00 00 C8 FB 79 5E 00 00 00 00 [email protected]^....
5E79FB30: C0 81 42 00 00 00 00 00 6D 44 02 40 01 00 00 00 ..B.....mD.@....
5E79FB40: FF 68 3F 4B A3 FD 00 00 C8 FB 79 5E 00 00 00 00 .h?K......y^....
5E79FB50: E8 FB F6 02 00 00 00 00 F4 FB F6 02 00 00 00 00 ................
5E79FB60: 00 FD F6 02 00 00 00 00 20 FC 79 5E 00 00 00 00 ........ .y^....
5E79FB70: 03 00 00 00 00 00 00 00 00 FC F6 02 00 00 00 00 ................
5E79FB80: 50 A4 C4 01 00 00 00 00 2E F7 36 40 01 00 00 00 P.........6@....
5E79FB90: 01 00 00 00 00 1B 06 28 C8 FB 79 5E 00 00 00 00 .......(..y^....
5E79FBA0: 50 A4 C4 01 00 00 00 00 00 FC F6 02 00 00 00 00 P...............
5E79FBB0: 20 FC 79 5E 00 00 00 00 50 00 90 16 24 18 08 72 .y^....P...$..r
5E79FBC0: FE FF FF FF FF FF FF FF 00 A3 6C 5F 00 00 00 00 ..........l_....
5E79FBD0: 0F 7F 3F 4B A3 FD 00 00 72 00 00 00 00 00 00 00 ..?K....r.......
5E79FBE0: F4 FB F6 02 00 00 00 00 00 FD F6 02 00 00 00 00 ................
5E79FBF0: 00 00 00 00 00 00 00 00 03 00 00 00 00 00 00 00 ................
5E79FC00: 00 FC F6 02 00 00 00 00 77 8F 1A 40 01 00 00 00 ........w..@....
5E79FC10: 48 FC F6 02 00 00 00 00 48 FC F6 02 00 00 00 00 H.......H.......
5E79FC20: 00 00 00 00 00 00 00 00 00 01 01 01 01 01 01 81 ................
5E79FC30: 28 A2 E7 5D 00 00 00 00 00 00 00 00 00 00 00 00 (..]............
5E79FC40: 00 00 00 00 00 00 00 00 85 3D 69 FD FE 07 00 00 .........=i.....
5E79FC50: CC 00 00 00 00 00 00 00 D0 00 00 00 00 00 00 00 ................
5E79FC60: E0 5C 23 00 00 00 00 00 02 00 00 00 00 00 00 00 .\#.............
5E79FC70: FE FF FF FF FF FF FF FF FC 61 69 FD FE 07 00 00 .........ai.....
5E79FC80: 50 FD 79 5E 00 00 00 00 00 00 00 00 00 00 00 00 P.y^............
5E79FC90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
5E79FCA0: F8 FB F6 02 00 00 00 00 E8 FB F6 02 00 00 00 00 ................
5E79FCB0: F4 FB F6 02 00 00 00 00 00 FD F6 02 00 00 00 00 ................
5E79FCC0: E0 72 70 5F 00 00 00 00 03 00 00 00 00 00 00 00 .rp_............
5E79FCD0: 00 FC F6 02 00 00 00 00 7A 30 03 77 00 00 00 00 ........z0.w....
==============================================================================
You can download the full dump details:

Current SQL Trace
This is the current SQL trace from Startup of Game Server til Crash:
Code:
exec [Telecaster]..sp_procedure_params_rowset N'on_server_startup',1,NULL,NULL go declare @p1 int set @p1=NULL exec on_server_startup @p1 output select @p1 go declare @p1 int set @p1=1 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Item with (nolock) where sid < 0x3FFFFFFFFFFFFFFF' select @p1 go exec sp_unprepare 1 go declare @p1 int set @p1=2 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Skill with (nolock) where sid < 0x3FFFFFFF' select @p1 go exec sp_unprepare 2 go declare @p1 int set @p1=3 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Summon with (nolock)' select @p1 go exec sp_unprepare 3 go declare @p1 int set @p1=4 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Pet with (nolock)' select @p1 go exec sp_unprepare 4 go declare @p1 int set @p1=5 exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Farm with (nolock)' select @p1 go exec sp_unprepare 5 go declare @p1 int set @p1=6 exec sp_prepexec @p1 output,NULL,N'UPDATE Character SET name = ''@'' + name WHERE delete_time <= GETDATE() and name not like ''@%''' select @p1 go select * from StringResource go select * from StringLocalResource go exec sp_reset_connection go select * from EventAreaResource go SELECT * FROM dbo.MonsterSkillResource ORDER BY id, sub_id go SELECT * FROM dbo.ItemEffectResource ORDER BY id, ordinal_id go SELECT * FROM dbo.MonsterDropTableResource ORDER BY id, sub_id go SELECT * FROM AuctionCategoryResource ORDER BY category_id, sub_category_id go select * from SetItemEffectResource go select * from MonsterResource go exec sp_reset_connection go select * from SummonResource go exec sp_reset_connection go select * from CreatureLevelBonus go exec sp_reset_connection go select * from DropGroupResource go select * from DropGroupLocalResource go exec sp_reset_connection go select * from SummonDefaultNameResource go select * from SummonUniqueNameResource go
Game Server Startup Log:
This is as far as we've got the Game Server to load at this point:
*Any Load with a 1 or a 0 during load was a table reconfigured or added in by us.
Code:
2012-03-11 09:28:19 Network initialize... ok 2012-03-11 09:28:19 IOCP initialize... ok 2012-03-11 09:28:19 Starting IOCP thread pool... ok 2012-03-11 09:28:19 LUA initialize... ok 2012-03-11 09:28:19 Launching ARCADIA... ok 2012-03-11 09:28:19 Start loading... 2012-03-11 09:28:19 Loading max Item index... (1) ok [B]<-- ALREADY WORKED[/B] 2012-03-11 09:28:19 Loading Complete. 2012-03-11 09:28:20 Total 106738 String loaded... 2012-03-11 09:28:20 Total 119 String(local) info loaded... 2012-03-11 09:28:20 Total 38/38 AuctionCategoryResource loaded. 2012-03-11 09:28:20 Total 0 ItemEffect loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Monster skill/trigger info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Event Area info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:20 Total 0 Monster item drop info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:25 Total 6640 Monster info loaded... 2012-03-11 09:28:25 Total 138 Summon info loaded... 2012-03-11 09:28:25 Total 87 Summon Level Bonus info loaded... 2012-03-11 09:28:25 Total 4265 DropGroup info loaded... 2012-03-11 09:28:25 Total 0 DropGroup(local) info loaded... [B]<-- ADDED[/B] 2012-03-11 09:28:25 Total 119 Summon Default Name loaded... 2012-03-11 09:28:25 Total 1 Summon Unique Name loaded... [B]<-- This one already worked[/B]
You can get the current databases from:
Information Being Updated
You can get the gameserver from:

!!! WARNING !!!
This game server DOES NOT load from gameserver.eop (Any changes to connection info MUST BE HEX'D) The above gameserver is set to use 127.0.0.1 for all connections to the databases, it uses Arcadia and Telecaster as names and an SA with no password for the login.
-Disclaimer:
You all should know better than I, this is one of our last chances to become a community again, so lets keep the trolling, flaming out and the busting our asses in. Only a community makes marvelous things, individuals make great things. Which one do you want, Marvelous or Great?
-MENTION:
I have done all of the work on the databases with Microsoft SQL Server 2012 RC0, there is known issues when trying to restore database backup from 2012 with Microsoft SQL Server 2008 R2. I can only suggest that you use the Microsoft SQL Server 2012 RC0 available from Microsoft






