[Help Thread] Please post your questions here.

[The War Z]

help shop billing

2017/10/30 16:38:28 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:30 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:03 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:04 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:16 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:24 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:25 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.

server is online don't crash, gamelog create.

[ThunderNikk]

Check the status of your billing database specifically.

I have had databases go into a stasis or busy state trying to auto recover itself where it can not be accessed.

Try taking the billing database offline and then back online and see what happens.

If all else fails try restoring your billing database again.

[The War Z]

my server is 7.2 revolution arab files don't gamelog.txt is empty help

================================================== ============================

------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------

00 Thread name : IOCP 03
00 job info : 20
00 job id : 0
00 counter : 0
00 execute time : 1824810
01 Thread name : IOCP 02
01 job info : 5
01 job id : 0
01 counter : 0
01 execute time : 1824817
02 Thread name : IOCP 00
02 job info : 20
02 job id : 0
02 counter : 0
02 execute time : 1824819
03 Thread name : IOCP 01
03 job info : 503
03 job id : 0
03 counter : 0
03 execute time : 1824821
04 Thread name : Scheduler 00
04 job info : StructSummon(0x49701590)
04 job id : 0
04 counter : 0
04 execute time : 1824820
05 Thread name : Scheduler 01
05 job info : PlayerDeleter(0x403FDD10)
05 job id : 0
05 counter : 0
05 execute time : 1824598
06 Thread name : Scheduler 02
06 job info : StructMonster(0x22183B90)
06 job id : 0
06 counter : 0
06 execute time : 1824830
07 Thread name : Scheduler 03
07 job info : StructNPC(0x58DCE130)
07 job id : 0
07 counter : 0
07 execute time : 1824830


------------------------------------------------------------------------------
Basic Information
------------------------------------------------------------------------------

Program Name : Arcadia
EXE : C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe
User : Administrator
Computer : WIN-QNDM3VR27CH

Program :
Exception : C000000D (An invalid parameter was passed to a service or function.
)
Fault Address: 0000000140084B33 01:00083B33
Mem Usage : 1893700KB / 1844688KB

------------------------------------------------------------------------------
Allocation Count Info(by _MEM_USAGE_DEBUG)
------------------------------------------------------------------------------

Type: StructSummon Allocated: [Current: 73]/[Peek Concurrent: 73]/[Total: 318]
Type: StructQuestManager Allocated: [Current: 39]/[Peek Concurrent: 39]/[Total: 195]
Type: StructPlayer Allocated: [Current: 39]/[Peek Concurrent: 39]/[Total: 195]
Type: AutoAuctionInfo Allocated: [Current: 1]/[Peek Concurrent: 1]/[Total: 1]
Type: GuildInfo Allocated: [Current: 7]/[Peek Concurrent: 7]/[Total: 7]
Type: StructItem Allocated: [Current: 11032]/[Peek Concurrent: 11050]/[Total: 140377]
Type: AuctionInfo Allocated: [Current: 9]/[Peek Concurrent: 10]/[Total: 9]
Type: ItemKeepingInfo Allocated: [Current: 0]/[Peek Concurrent: 7]/[Total: 7]
Type: PartyInfo Allocated: [Current: 20]/[Peek Concurrent: 23]/[Total: 35]
Type: StructNPC Allocated: [Current: 4417]/[Peek Concurrent: 4417]/[Total: 4417]
Type: StructSkill Allocated: [Current: 23642]/[Peek Concurrent: 23654]/[Total: 50066]
Type: ArRegion Allocated: [Current: 88648]/[Peek Concurrent: 88648]/[Total: 88648]
Type: StructFieldProp Allocated: [Current: 49904]/[Peek Concurrent: 49910]/[Total: 49966]
Type: StructPet Allocated: [Current: 30]/[Peek Concurrent: 30]/[Total: 149]
Type: StructQuest Allocated: [Current: 37]/[Peek Concurrent: 38]/[Total: 4341]
Type: StructSkillProp Allocated: [Current: 0]/[Peek Concurrent: 2]/[Total: 71]


------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------

RAX=00000001403D8E40 RBX=000000007168A801 RCX=0000000050BDF390 RDX=00000001402F1201
ESI=00000000001BD756 EDI=00000000C000000D EBP=0000000000000000
DS =002B ES=002B FS=0053 GS:002B
CS:RIP=0033:00000001400215C7
SS:RSP=002B:0000000050BDF2C0
Flags=00000206


------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 0142699B
app.cmdline : CaptainHerlockServer.exe
app.filesize : 4668928
app.filetime : 2016/05/25-05:54:02
app.name : game001
auth.connect : complete
auth.server_idx : 1
auth.server_name : myserverip
blank.io.port : 4910
console._password : myserverpwd
console.allow_ip : 127.0.0.1
console.ip : myserverip
console.port : 4902
db.auth.use_webauth : 0
db.c._password : myserverpwd
db.c.account : sa
db.c.name : Arcadia
db.c.server : myserverip
db.game.ip : myserverip
db.user._password : myserverpwd
db.user.account : sa
db.user.name : Telecaster
db.user.server : myserverip
db.user.thread_active : 4
db.user.thread_total : 4
db.user.work_active : 4
db.user.work_pending : 1536
db.user.work_total : 340324
engine.ar_time : 1825162
engine.count_client : 32
engine.count_movable : 37986
engine.count_static : 50259
engine.lock : 1
engine.region_size : 180
engine.scheduler.0.instruction : 182204
engine.scheduler.0.object : 1851
engine.scheduler.1.instruction : 182166
engine.scheduler.1.object : 1903
engine.scheduler.2.instruction : 182197
engine.scheduler.2.object : 1871
engine.scheduler.3.instruction : 182163
engine.scheduler.3.object : 1901
engine.scheduler.destroy_cnt : 10614
engine.scheduler.destroy_loop : 182231
engine.scheduler.destroy_pend : 5
engine.use_region_debug : 0
engine.wait : 3
error_chat : 1
game.AdultServer : 0
game.AutoOpenOnly : 0
game.PKServer : 0
game.UseGameGuard : 0
game.UseHackShield : 0
game.allowed_special_char : 1
game.ally_pcbang_bonus_rate : 0.750000
game.ally_pcbang_chaos_bonus_rate : 0.750000
game.apply_stamina_bonus_in_premium_pcb : 0
game.apply_stamina_bonus_in_premium_pcbang : 0
game.auction_process_request_min_interval : 100
game.auction_search_request_min_interval : 100
game.bUseLockDelayLogging : 0
game.base_ethereal_durability_consumption_on_damag e : 20
game.base_ethereal_durability_consumption_on_norma l_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 : 1
game.chaos_drop_rate : 5.000000
game.check_storage_security_always : 0
game.console.port : 4902
game.disable_buy_booth : 0
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_pk_on : 0
game.enhance_fail_type : 2
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 : 4.000000
game.guild_icon_base_url :
game.helpdesk_url :
game.huntaholic_timer : 1
game.ignore_random_damage : 0
game.iocp.active : 1
game.is_maintenance : 0
game.item_count : 11032
game.item_drop_rate : 20.000000
game.item_hold_time : 9464
game.item_loading : complete
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.loading : complete
game.local_flag : 16384
game.log_required_item_list :
game.log_required_state_list :
game.logout_timer : 1
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 : 119
game.max_storage_item_count : 800
game.max_tired_game_time : 1800000
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 20
game.mod : 0.000000
game.monster_drop_respawn : 0
game.monster_pathfinding : 1
game.monster_respawn_cnt : 38037
game.monster_respawn_object_cnt : 28820
game.monster_respawn_try_cnt : 146184
game.monster_wandering : 0
game.no_collision_check : 0
game.no_skill_cooltime : 0
game.party_drop_rate : 25
game.party_exp_rate : 2.000000
game.period_of_security_solution_check : 30000
game.play_point_accumulate_amount : 10
game.play_point_accumulate_term : 6000
game.premium_pcbang_bonus_rate : 2.000000
game.premium_pcbang_chaos_bonus_drop_rate : 2.000000
game.premium_pcbang_chaos_bonus_rate : 2.000000
game.premium_pcbang_gold_bonus_drop_rate : 2.000000
game.premium_pcbang_item_bonus_drop_rate : 2.000000
game.premium_pcbang_play_point_bonus_rate : 2.500000
game.pvp_damage_rate_for_player : 0.200000
game.pvp_damage_rate_for_summon : 0.130000
game.resource : Resource
game.restrict_banword_for_booth : 0
game.restrict_special_char : 1
game.script.1096.time : 1824077
game.script.1096.trigger : open_market( 'Gaia_itemUP_suppert' )
game.script.3360.time : 1819952
game.script.3360.trigger : ChipExchange_lak_to_RP()
game.script.3400.time : 1823358
game.script.3400.trigger : quest_info( 1109, 90101208 )
game.script.4620.time : 1820992
game.script.4620.trigger : RunTeleport( 500 , 6625 , 6980 )
game.security_solution_exceptional_ip :
game.security_solution_response_timeout : 3000
game.security_solution_type : 0
game.server_screenshot_url :
game.skip_loading_attribute : 1
game.speed_unit : 30
game.stamina_bonus_rate : 1.000000
game.super_save_bonus_rate : 2.000000
game.super_save_level_limit : 130
game.tile_size : 42.000000
game.url_list : guild.url|
game.use_auto_jail : 0
game.use_auto_trap : 0
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 : 39
io.auth.ip : myserverip
io.connection : 37
io.ip_address : myserverip
io.max_connection : 5000
io.port : 4914
io.recv_byte : 51454276
io.recv_count : 2428651
io.send_byte : 422250446
io.send_count : 7868931
io.upload.ip : myserverip
io.upload.port : 4617
io.use_message_statistics : 0
iocp.1096.script : quest_start_2027()
iocp.3360.script : quest_start_2026_start()
iocp.3400.script : quest_start_2003()
iocp.4620.script : quest_start_2027()
iocp.active : 4
iocp.bufsize : 8192
iocp.dis_count : 108
iocp.instruction : 7308065
iocp.total : 4
log.chat.working : 0
log.server_name : game001
log.working : 0
memory.item_heap_size : 239616
memory.monster_heap_size : 244440
memory.player_heap_size : 19344
memory.summon_heap_size : 70880
process.id : 4060
process.load : 1
process.load_kernel : 0
process.load_user : 100
process.memory : 1893700
process.memory_peak : 1896832
process.paged_memory : 1844688
process.paged_memory_peak : 1845456
process.start : 2017/10/31-08:02:24
process.uptime : 5 Hour 4 Minute 17 Second
set_user_limit : 100
thread.db.0.proc : DB_UpdateItem
thread.db.1.proc : DB_UpdateItem
thread.db.2.proc : DB_UpdateItem
thread.db.3.proc : DB_UpdateItem
thread.iocp.0.proc : 20
thread.iocp.1.proc : 503
thread.iocp.2.proc : 20
thread.iocp.3.proc : 20
thread.scheduler.0.proc : StructPlayer
thread.scheduler.1.proc : PlayerDeleter
thread.scheduler.2.proc : StructNPC
thread.scheduler.3.proc : StructNPC
upload.connect : complete
upload.server_name : uploadserver1


------------------------------------------------------------------------------
Application-specific log
------------------------------------------------------------------------------

PlayerHeapSize : 19344 kb
MonsterHeapSize : 244440 kb
ItemHeapSize : 239616 kb
SummonHeapSize : 70880 kb
PetHeapSize : 6864 kb
SkillHeapSize : 46080 kb
QuestHeapSize : 5760 kb
DBHeapSize : 50671 kb


------------------------------------------------------------------------------
Call Stack (Short)
------------------------------------------------------------------------------

Address Frame Function SourceFile
00000001400215C7 0000000050BDF860 0001:000205C7 C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe (e487)
0000000140084B33 0000000050BDF9C0 0001:00083B33 C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe (e487)
000000014000D22F 0000000050BDFEF0 0001:0000C22F C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe (e487)
0000000140292C87 0000000050BDFF20 0001:00291C87 C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe (e487)
0000000140292D5F 0000000050BDFF50 0001:00291D5F C:\Users\Administrator\Desktop\serverfiles\Captain HerlockServer.exe (e487)
0000000076CB59BD 0000000050BDFF80 BaseThreadInitThunk+D
0000000076EEA2E1 0000000050BDFFD0 RtlUserThreadStart+21




------------------------------------------------------------------------------
Memory Dump
------------------------------------------------------------------------------

Code: 16 bytes starting at (RIP = 00000000400215C7)
400215C7: 48 8D 4C 24 30 33 D2 41 B8 98 00 00 00 E8 17 06 H.L$03.A........

Stack: 1024 bytes starting at (RSP = 0000000050BDF2C0)
50BDF2C0: E0 F2 BD 50 00 00 00 00 06 00 00 00 00 00 00 00 ...P............
50BDF2D0: 00 00 00 00 00 00 00 00 01 00 00 00 00 00 00 00 ................
50BDF2E0: F0 F2 BD 50 00 00 00 00 90 F3 BD 50 00 00 00 00 ...P.......P....
50BDF2F0: 0D 00 00 C0 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF300: 33 4B 08 40 01 00 00 00 00 00 00 00 00 00 00 00 3K.@............
50BDF310: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF320: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF330: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF340: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF350: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF360: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF370: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF380: 00 00 00 00 00 00 00 00 50 9B 8E 53 00 00 00 00 ........P..S....
50BDF390: B2 F8 BD 50 00 00 00 00 6B C2 01 40 01 00 00 00 ...P....k..@....
50BDF3A0: E0 F3 BD 50 00 00 00 00 01 00 00 00 00 00 00 00 ...P............
50BDF3B0: B2 F8 BD 50 00 00 00 00 80 9B 8E 53 00 00 00 00 ...P.......S....
50BDF3C0: 0F 00 10 00 B5 1F 00 00 33 00 2B 00 2B 00 53 00 ........3.+.+.S.
50BDF3D0: 2B 00 2B 00 06 02 00 00 E0 F3 BD 50 00 00 00 00 +.+........P....
50BDF3E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF3F0: A8 F6 BD 50 00 00 00 00 00 00 30 40 01 00 00 00 ...P......0@....
50BDF400: 29 00 00 00 00 00 00 00 40 8E 3D 40 01 00 00 00 ).......@.=@....
50BDF410: 90 F3 BD 50 00 00 00 00 01 12 2F 40 01 00 00 00 ...P....../@....
50BDF420: 01 A8 68 71 00 00 00 00 C0 F2 BD 50 00 00 00 00 ..hq.......P....
50BDF430: 00 00 00 00 00 00 00 00 56 D7 1B 00 00 00 00 00 ........V.......
50BDF440: 0D 00 00 C0 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF450: 00 00 00 00 00 00 00 00 00 00 00 40 01 00 00 00 ...........@....
50BDF460: B0 E2 2F 40 01 00 00 00 B0 DA 3C 40 01 00 00 00 ../@......<@....
50BDF470: 70 5D D9 01 00 00 00 00 90 5D D9 01 00 00 00 00 p].......]......
50BDF480: A0 19 3C 1C 00 00 00 00 C7 15 02 40 01 00 00 00 ..<........@....
50BDF490: 7F 02 20 04 00 00 00 00 10 9E 29 40 00 00 00 00 .. .......)@....
50BDF4A0: 08 EC BD 50 00 00 00 00 B5 1F 00 00 FF FF 00 00 ...P............
50BDF4B0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF4C0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF4D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF4E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF4F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF500: 00 00 00 00 00 00 00 80 FF 3F 00 00 00 00 00 00 .........?......
50BDF510: 00 00 00 00 00 00 00 E1 08 40 00 00 00 00 00 00 .........@......
50BDF520: 00 00 00 00 00 00 00 E1 08 40 00 00 00 00 00 00 .........@......
50BDF530: 10 76 8E 53 00 00 00 00 E0 9B 8E 53 00 00 00 00 .v.S.......S....
50BDF540: 00 00 34 43 00 00 00 00 00 00 00 00 00 00 00 00 ..4C............
50BDF550: 00 00 34 43 00 00 00 00 00 00 00 00 00 00 00 00 ..4C............
50BDF560: FA 00 B2 43 00 00 00 00 00 00 00 00 00 00 00 00 ...C............
50BDF570: CA 94 93 A7 91 0E E9 3D 00 00 00 00 00 00 00 00 .......=........
50BDF580: 00 00 34 43 5F 51 7A 47 00 00 00 00 3F 56 D5 3E ..4C_QzG....?V.>
50BDF590: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5A0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5B0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5C0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF5F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF600: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF610: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF620: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
50BDF630: 50 59 DC 01 00 00 00 00 3D A4 00 40 01 00 00 00 PY......=..@....
50BDF640: 06 00 00 00 00 00 00 00 FE B0 01 40 01 00 00 00 ...........@....
50BDF650: 08 81 B1 3D 58 52 00 00 50 59 DC 01 00 00 00 00 ...=XR..PY......
50BDF660: 50 F3 E4 01 00 00 00 00 F0 CC E4 01 00 00 00 00 P...............
50BDF670: A6 F8 BD 50 00 00 00 00 6B C2 01 40 01 00 00 00 ...P....k..@....
50BDF680: C0 F6 BD 50 00 00 00 00 06 00 00 00 00 00 00 00 ...P............
50BDF690: A6 F8 BD 50 00 00 00 00 50 59 DC 01 00 00 00 00 ...P....PY......
50BDF6A0: E0 7C E4 01 00 00 00 00 50 F3 E4 01 00 00 00 00 .|......P.......
50BDF6B0: 50 59 DC 01 00 00 00 00 C0 F6 BD 50 00 00 00 00 PY.........P....


================================================== ============================

[thefear511]

Originally Posted by The War Z

my server is 7.2 revolution arab files don't gamelog.txt is empty help

did you make any edits in arcadia? does it crash before running luas or from the start?

[Exterminator-[Fury]]

We need more information.

1: Show us your gameserver.opt crash error create printscreen when gameserver crashes.
2: Try to search in the (log) folder for gameserver.txt.
3: Maybe you have the gamelog.txt in the (game_bin) folder.

Originally Posted by The War Z

my server is 7.2 revolution arab files don't gamelog.txt is empty help

[The War Z]

Arcadia not edit, gamelog.txt empty in folder
help

[Exterminator-[Fury]]

Please explain in your own language.... Arab/Turkish/German/Russian?
Post picture/photo

Originally Posted by The War Z

Arcadia not edit, gamelog.txt empty in folder
help

[The War Z]

I am from turkish picture/photo deleted

[Ghost Informatics]

Originally Posted by The War Z

my server is 7.2 revolution arab files don't gamelog.txt is empty help

send me the crash dump file with the captainherlock.pdb and i will find the problem.

*upload it and send the url here ..

[PetTrainer]

Hi guys,

i have the Regiscript from iSmokeDrow..
there is a SQL Query for the old Auth database...
Can anyone help me to convert this Query for 9.4 Auth ?

Old Query:

 Spoiler

INSERT INTO Accounts (login_name,password,block,withdraw_remain_time,ag e,auth_ok,pcbang,last_login_server_idx,event_code, result, email)VALUES(@User @,0,0 @,1,1,1,0,1 @)");

[The War Z]

Originally Posted by Ghost Informatics

send me the crash dump file with the captainherlock.pdb and i will find the problem.

*upload it and send the url here ..

thanks fixed: harddisk sata crash. change to ssd disk
datastore bugs

new problem, //regenerate id count
delete boss spawn clear? delete regenerate code?

[ThunderNikk]

Originally Posted by PetTrainer

Hi guys,

i have the Regiscript from iSmokeDrow..
there is a SQL Query for the old Auth database...
Can anyone help me to convert this Query for 9.4 Auth ?

Try this...

INSERT INTO Account (account, password, email, password2, block, IP_user, last_login_server_idx, Admin, point, datePassword, pk_, creationDate_, updateDate_, creatorId_, updatorId_, portId_, type_, accessDate_, age) VALUES (@user, @pass, @email, @pass, 0, null, 1, 1, 0, null, 1, null, null, null, null, null, com.elixir.billing.impl.ImmAccount, null, @age)");

You can add and age column to the end of your account table or you can remove it from this script but ismoke's old register script will ask for the user input but not have a use for it if it is not there.

[PetTrainer]

Originally Posted by ThunderNikk

Try this...

INSERT INTO Account (account, password, email, password2, block, IP_user, last_login_server_idx, Admin, point, datePassword, pk_, creationDate_, updateDate_, creatorId_, updatorId_, portId_, type_, accessDate_, age) VALUES (@user, @pass, @email, @pass, 0, null, 1, 1, 0, null, 1, null, null, null, null, null, com.elixir.billing.impl.ImmAccount, null, @age)");

You can add and age column to the end of your account table or you can remove it from this script but ismoke's old register script will ask for the user input but not have a use for it if it is not there.

Don't work...


Can anyone make a Registerpage for 9.4 Auth Database ?....

[ThunderNikk]

Could you explain what does not work and maybe I can fix it for you.

I use the same register page I just use the same auth db I have been using since 7.4

Is there an error message that I can correct?

[PetTrainer]

Originally Posted by ThunderNikk

Could you explain what does not work and maybe I can fix it for you.

I use the same register page I just use the same auth db I have been using since 7.4

Is there an error message that I can correct?

I have insert your Query, but i delete the ,age entry... when i will register a acc i become this error:

 Spoiler

The multi-part identifier 'com.elixir.billing.impl.ImmAccount' could not be bound.

when i change the "com.elixir.billing.impl.ImmAccount" to "1" i will become this error:

 Spoiler

The value NULL can not be inserted into the IP_user column, Auth94.dbo.Account table. The column does not allow NULL values. Error with INSERT. The statement has ended.

when i change the IP_user entry from "NULL" to "127.0.0.1" i will become this error:

 Spoiler

Wrong syntax near '.0'.

when i change the IP_user entry from "127.0.0.1" to "1" i will become this error:

 Spoiler

Operand type collision: int is incompatible with text

#translated from german to english with google translator