[HOW-TO] Setup 9.1

[brkhnsvr94]

Umm.. Actually the problem is button for equipment. When I press it with my wings or unless them, result is same. Freezing..Its a general problem with my server. There is a issue with my db but what..? So I want to record a video about my problem to explain it detailed. Maybe opt files demaged or configured incorrect. So I want to share them with you.
Here is youtube link:

GameServer.opt

 Spoiler

S:app.name:Burakhan
T:auth.server_idx:1
S:auth.server_name:RappelzCore
S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:sa
S:db.c._password:
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:sa
S:db.user._password:
N:io.port:15574
S:io.auth.ip:127.0.0.1

S:io.ip_address:127.0.0.1

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:16384
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url|

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

auth.opt

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_ mask

#include config in common.opt
%include:common.opt

common.opt

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
auth.db.salt:2011
#You can make auth.dbo.Accounts.[password] by visiting:
# (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:0.0.0.0
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

[ThunderNikk]

I think the issue is with your client because I am using the same database files and an .opt file would only cause freezes if you have set it to log.

I do not have the equipment issue which is why I think it is client mismatch.

[brkhnsvr94]

I tried this 9.1 client also. But problem is still exist. I think, as you mentioned the problem is client and db mismatch. Because the arcadia db is backuping some files after I pushed the equipt button. There was a text file in the game_bin like this:

 Spoiler

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

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

00 Thread name : IOCP 02
00 job info :
00 job id : 0
00 counter : 0
00 execute time : 0
01 Thread name : IOCP 03
01 job info : 5
01 job id : 0
01 counter : 0
01 execute time : 14067
02 Thread name : IOCP 00
02 job info : 5
02 job id : 0
02 counter : 0
02 execute time : 28445
03 Thread name : IOCP 01
03 job info : 7
03 job id : 0
03 counter : 0
03 execute time : 14436
04 Thread name : Scheduler 00
04 job info : StructMonster(0x2DEFE920)
04 job id : 0
04 counter : 0
04 execute time : 28445
05 Thread name : Scheduler 01
05 job info : StructMonster(0x27A86138)
05 job id : 0
05 counter : 0
05 execute time : 28445
06 Thread name : Scheduler 02
06 job info : StructMonster(0x2DF17FC8)
06 job id : 0
06 counter : 0
06 execute time : 28445
07 Thread name : Scheduler 03
07 job info : StructRoamer(0x8006D340)
07 job id : 0
07 counter : 0
07 execute time : 28445


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

Program Name : Arcadia
EXE : C:\Users\Burakhan\Desktop\server_bin\Game_bin\Capt ainHerlockServer.exe
User : Burakhan
Computer : BURAKHAN

Program :
Exception : C000000D (Bir hizmet veya işleve geçersiz bir parametre geçildi.
)
Fault Address: 00007FF61D18A30C 01:0036930C
Mem Usage : 2531120KB / 2487904KB

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

Type: StructSummon Allocated: [Current: 0]/[Peek Concurrent: 1]/[Total: 1]
Type: StructQuestManager Allocated: [Current: 1]/[Peek Concurrent: 1]/[Total: 2]
Type: StructPlayer Allocated: [Current: 1]/[Peek Concurrent: 1]/[Total: 2]
Type: AutoAuctionInfo Allocated: [Current: 46]/[Peek Concurrent: 46]/[Total: 46]
Type: StructItem Allocated: [Current: 52]/[Peek Concurrent: 52]/[Total: 52]
Type: AuctionInfo Allocated: [Current: 46]/[Peek Concurrent: 46]/[Total: 46]
Type: StructFieldProp Allocated: [Current: 59600]/[Peek Concurrent: 59600]/[Total: 59600]
Type: StructNPC Allocated: [Current: 7142]/[Peek Concurrent: 7142]/[Total: 7142]
Type: StructSkill Allocated: [Current: 18692]/[Peek Concurrent: 18692]/[Total: 18692]
Type: StructTitleCondition Allocated: [Current: 1]/[Peek Concurrent: 1]/[Total: 1]


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

RAX=000071BC8CE88E7E RBX=00000000C000000D RCX=000000007A64A2F0 RDX=0000000000000064
ESI=000000007A64F2A0 EDI=000000BF7CD945B3 EBP=000000007A64F450
DS =002B ES=002B FS=0053 GS:002B
CS:RIP=0033:00007FF61D12552B
SS:RSP=002B:000000007A64A220
Flags=00000206


------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
CodePage : 1256
app.checksum : 00E1E978
app.cmdline : "C:\Users\Burakhan\Desktop\server_bin\Game_bin\Cap tainHerlockServer.exe"
app.filesize : 5393648
app.filetime : 2014/09/12-15:29:42
app.name : Core Rappelz
auth.connect : complete
auth.server_idx : 1
auth.server_name : Burakhan Server
console.allow_ip : 127.0.0.1
console.port : 65528
db.c.name : Arcadia
db.c.server : 127.0.0.1
db.trace : 1
db.trace_refresh_period : 0
db.user.exec_query : 0
db.user.name : Telecaster
db.user.remain_query : 1
db.user.server : 127.0.0.1
db.user.thread : 4
db.user.thread_active : 1
db.user.thread_total : 1
db.user.work_active : 1
db.user.work_pending : 0
db.user.work_total : 7
engine.ar_time : 28445
engine.count_client : 1
engine.count_movable : 45014
engine.count_static : 59600
engine.lock : 0
engine.region_size : 180
engine.scheduler.0.instruction : 1323
engine.scheduler.0.object : 182
engine.scheduler.1.instruction : 1322
engine.scheduler.1.object : 182
engine.scheduler.2.instruction : 1322
engine.scheduler.2.object : 182
engine.scheduler.3.instruction : 1316
engine.scheduler.3.object : 182
engine.scheduler.destroy_cnt : 2
engine.scheduler.destroy_loop : 1325
engine.scheduler.destroy_pend : 0
engine.use_region_debug : 0
engine.wait : 0
game.AdultServer : 0
game.AutoOpenOnly : 0
game.FindDuplicatePos : 0
game.FirstLineCount : 0
game.GamePerformanceLogingInterval : 10000
game.LineCount : 0
game.PKPenaltyLevel : 10
game.PKServer : 1
game.PathFindingCount : 0
game.ProcessingMonsterCount : 9197
game.ProcessingMonsterTime : 144
game.ProcessingPlayerCount : 11
game.ProcessingPlayerTime : 0
game.ProcessingSummonCount : 0
game.ProcessingSummonTime : 0
game.RandomMove : 0
game.ServiceServer : 1
game.TracingGamePerformance : 1
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_damag e : 98
game.base_ethereal_durability_consumption_on_norma l_attack : 31
game.base_ethereal_durability_consumption_on_skill _attack : 51
game.battle_arena_reconnect_wait_duration : 18000
game.broadcast_event_item_pickup : 0
game.cash_item_dropable : 0
game.cash_usable_server : 1
game.chaos_drop_rate : 1.000000
game.check_storage_security_always : 1
game.disable_booth : 0
game.disable_buy_booth : 0
game.disable_dungeon_raid_siege : 0
game.disable_huntaholic : 0
game.disable_pk_on : 0
game.disable_trade : 0
game.enhance_fail_type : 2
game.exp_rate : 42.000000
game.farm_growth_summon_exp : 37087982
game.farm_normal_summon_exp : 145763
game.forbidden_script :
game.forbidden_script_init : 0
game.force_unregister_account_on_kick_fail : 0
game.gold_drop_rate : 50.000000
game.guild_icon_base_url :
game.helpdesk_url :
game.ignore_random_damage : 0
game.item_count : 52
game.item_drop_rate : 20.000000
game.item_hold_time : 2500
game.item_loading : complete
game.limit_adv_chat_count : 1
game.limit_booth_openable_layer_to_zero : 0
game.limit_field_logout : 0
game.limit_game_time : 0
game.loading : complete
game.local_flag : 8192
game.log_monster_pathfinding : 1
game.log_required_item_list :
game.log_required_state_list :
game.log_scheduling_status : 1
game.log_vulcanus_dungeon : 0
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 : 180
game.max_storage_item_count : 1000
game.max_tired_game_time : 1800000
game.min_booth_startable_level : 0
game.min_global_chat_usable_level : 80
game.mod : 0.000000
game.monster_collision_line : 1
game.monster_drop_respawn : 0
game.monster_pathfinding : 1
game.monster_respawn_cnt : 35959
game.monster_respawn_object_cnt : 33328
game.monster_respawn_try_cnt : 33328
game.monster_wandering : 1
game.newbiehelp_asura_url :
game.newbiehelp_deva_url :
game.newbiehelp_gaia_url :
game.no_collision_check : 0
game.no_skill_cooltime : 0
game.party_exp_rate_0 : 1.000000
game.party_exp_rate_1 : 1.000000
game.party_exp_rate_2 : 1.000000
game.party_exp_rate_3 : 1.000000
game.party_exp_rate_4 : 1.000000
game.party_exp_rate_5 : 1.000000
game.party_exp_rate_6 : 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.server_screenshot_url :
game.server_version : 9.1.0.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_max_limit_0 : 130
game.super_save_level_max_limit_1 : 140
game.super_save_level_max_limit_2 : 150
game.super_save_level_max_limit_3 : 160
game.super_save_level_max_limit_4 : 160
game.super_save_level_max_limit_5 : 170
game.super_save_level_max_limit_6 : 180
game.super_save_level_min_limit_0 : 1
game.super_save_level_min_limit_1 : 121
game.super_save_level_min_limit_2 : 131
game.super_save_level_min_limit_3 : 141
game.super_save_level_min_limit_4 : 121
game.super_save_level_min_limit_5 : 151
game.super_save_level_min_limit_6 : 171
game.term_for_time_based_event_db : 60
game.term_for_time_based_event_script : 120
game.tile_size : 42.000000
game.update.version : 24
game.url_list : guild.url|
game.use_account_authority_db : 0
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.use_time_based_event_db : 0
game.use_time_based_event_script : 1
game.user_count : 1
io.auth.ip : 127.0.0.1
io.connection : 3
io.ip_address : 127.0.0.1
io.port : 4514
io.recv_byte : 1317
io.recv_count : 50
io.send_byte : 15173
io.send_count : 223
io.upload.ip : 127.0.0.1
io.upload.port : 4616
io.use_message_statistics : 0
iocp.active : 1
iocp.bufsize : 8192
iocp.dis_count : 3
iocp.instruction : 206
iocp.max_realloc_size : 0
iocp.recv_count : 31
iocp.recv_rest_bytes : 0
iocp.recv_traffic : 1326
iocp.send_count : 167
iocp.send_rest_bytes : 0
iocp.send_traffic : 15173
iocp.total : 4
log.chat.ip : 127.0.0.1
log.chat.working : 1
log.ip : 127.0.0.1
log.server_name : Core Rappelz
log.working : 0
memory.item_heap_size : 422656
memory.monster_heap_size : 350168
memory.player_heap_size : 25344
memory.summon_heap_size : 95200
process.id : 2956
process.load : 1
process.load_kernel : 100
process.load_user : 0
process.memory : 1455000
process.memory_peak : 1455000
process.paged_memory : 2487876
process.paged_memory_peak : 2487884
process.start : 2017/01/17-23:51:57
process.uptime : 4 Minute 44 Second
thread.db.0.proc : DB_Login
thread.db.1.proc : DB_GetCommercialStorageInfo
thread.db.2.proc : DB_UpdateCharacterHideEquipFlag
thread.db.3.proc : DB_CharacterList
thread.iocp.0.proc : 5
thread.iocp.1.proc : 7
thread.iocp.3.proc : 5
thread.scheduler.0.proc : StructMonster
thread.scheduler.1.proc : StructMonster
thread.scheduler.2.proc : StructRoamer
thread.scheduler.3.proc : StructMonster
upload.connect : failed


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

Server Version : v9.1.0.0
PlayerHeapSize : 25344 kb
MonsterHeapSize : 350168 kb
ItemHeapSize : 422656 kb
SummonHeapSize : 95200 kb
PetHeapSize : 9336 kb
SkillHeapSize : 53760 kb
QuestHeapSize : 5760 kb
TitleHeapSize : 1440 kb
TitleConditionHeapSize: 1440 kb
ProcHeapSize : 2400 kb
DBHeapSize : 12914 kb



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

Address Frame Function SourceFile
00007FF61D12552B 000000007A64A7D0 ?InvokeUnhandledException@XExceptionHandler@XSEH@@ SAXK_N@Z+2B
00007FF61D18A30C 000000007A64A850 __remainder_piby2+1E444
00007FF61D1600E0 000000007A64A880 _CallSettingFrame+20
00007FF61D15B50F 000000007A64A940 __CxxCallCatchBlock+EB
00007FFACD4F2A63 000000007A64F440 RtlCaptureContext+3C3
00007FF61D0B8816 000000007A64F620 ?onProcess@DBProc@GameDBManager@@UEAA_NH@Z+156
00007FF61CE271FF 000000007A64F7B0 ?_threadFunc@XBossWorker@@CAIPEAX@Z+14F
00007FF61D14994F 000000007A64F7E0 _endthreadex+3B
00007FF61D1499E3 000000007A64F810 _endthreadex+CF
00007FFACCAF13D2 000000007A64F840 BaseThreadInitThunk+22
00007FFACD4754E4 000000007A64F890 RtlUserThreadStart+34




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

Code: 16 bytes starting at (RIP = 000000001D12552B)
1D12552B: 48 8D 4C 24 30 33 D2 41 B8 98 00 00 00 E8 73 9D H.L$03ÒA¸....ès.

Stack: 1024 bytes starting at (RSP = 000000007A64A220)
7A64A220: 00 00 84 02 00 00 00 00 0D 00 00 C0 00 00 00 00 ..„........À....
7A64A230: A0 F2 64 7A 00 00 00 00 25 00 00 00 00 00 00 00 *òdz....%.......
7A64A240: 50 A2 64 7A 00 00 00 00 F0 A2 64 7A 00 00 00 00 P¢dz....ğ¢dz....
7A64A250: 0D 00 00 C0 00 00 00 00 00 00 00 00 00 00 00 00 ...À............
7A64A260: 0C A3 18 1D F6 7F 00 00 00 00 00 00 00 00 00 00 .£..ö...........
7A64A270: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A280: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A290: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2A0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2B0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2C0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A2F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A300: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A310: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A320: 0F 00 10 00 A0 1F 00 00 33 00 2B 00 2B 00 53 00 ....*...3.+.+.S.
7A64A330: 2B 00 2B 00 06 02 00 00 9E 00 00 00 00 00 00 00 +.+.............
7A64A340: EF 00 00 00 00 00 00 00 A0 F2 64 7A 00 00 00 00 ï.......*òdz....
7A64A350: 14 0E 04 80 00 00 00 00 04 00 00 00 00 00 00 00 ................
7A64A360: 88 A9 0D 7F 00 00 00 00 7E 8E E8 8C BC 71 00 00 .©......~.茼q..
7A64A370: F0 A2 64 7A 00 00 00 00 64 00 00 00 00 00 00 00 ğ¢dz....d.......
7A64A380: 0D 00 00 C0 00 00 00 00 20 A2 64 7A 00 00 00 00 ...À.... ¢dz....
7A64A390: 50 F4 64 7A 00 00 00 00 A0 F2 64 7A 00 00 00 00 Pôdz....*òdz....
7A64A3A0: B3 45 D9 7C BF 00 00 00 00 24 ED 00 00 00 00 00 ³EÙ|¿....$í.....
7A64A3B0: 00 80 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A3C0: 08 01 00 00 00 00 00 00 14 0E 04 80 00 00 00 00 ................
7A64A3D0: B0 78 1C 1D F6 7F 00 00 00 A9 64 7A 00 00 00 00 °x..ö....©dz....
7A64A3E0: 70 A2 18 1D F6 7F 00 00 2B 55 12 1D F6 7F 00 00 p¢..ö...+U..ö...
7A64A3F0: 7F 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A400: 00 00 00 00 00 00 00 00 A0 1F 00 00 FF FF 00 00 ........*...ÿÿ..
7A64A410: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A420: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A430: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A440: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A450: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A460: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A470: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A480: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A490: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4A0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4B0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4C0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4D0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4E0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A4F0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A500: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A510: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A520: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A530: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A540: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A550: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A560: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A570: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A580: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
7A64A590: 65 61 64 3A 32 2C 20 48 52 45 53 55 4C 54 3A 38 ead:2, HRESULT:8
7A64A5A0: 30 30 34 30 45 31 34 2C 20 47 55 49 44 3A 30 43 0040E14, GUID:0C
7A64A5B0: 37 33 33 41 36 33 2D 32 41 31 43 2D 31 31 43 45 733A63-2A1C-11CE
7A64A5C0: 2D 41 44 45 35 2D 30 30 41 41 30 30 34 34 37 37 -ADE5-00AA004477
7A64A5D0: 33 44 29 20 3A 20 44 42 5F 55 70 64 61 74 65 43 3D) : DB_UpdateC
7A64A5E0: 68 61 72 61 63 74 65 72 48 69 64 65 45 71 75 69 haracterHideEqui
7A64A5F0: 70 46 6C 61 67 28 64 62 6F 2E 73 6D 70 5F 75 70 pFlag(dbo.smp_up
7A64A600: 64 61 74 65 5F 63 68 61 72 61 63 74 65 72 5F 68 date_character_h
7A64A610: 69 64 65 5F 65 71 75 69 70 5F 66 6C 61 67 00 00 ide_equip_flag..


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

Can you please share with me your db files?

[ThunderNikk]

I have the same DB files. I have already told you this about 3 times.

Everyone has the same 9.1 files.

That's why I think it is your client. You go ahead and keep trying to find different 9.1 files though.

[brkhnsvr94]

I've tried 4 different 9.1 clients .. Every client gave me the same print. So there must be some missing columns or rows in my db I think. Cause the print of my issue is giving me this kind of warnings on text file: DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag.. If its possible can you share with me your client? I want to try this way..

[ThunderNikk]

My client...

[brkhnsvr94]

Here is my problem with sql ... not with client.

 Spoiler

2017/01/18 03:55:20 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateCharacterHideEquipFlag(dbo.smp_update_cha racter_hide_equip_flag) : Must declare the scalar variable "@iN_SID".

EDIT: Tried 5 different 9.1 clients.

[ThunderNikk]

Have you tried it after you have equipped deco items.

In you video you have nothing to show or hide yet.

I tried stripping my character of deco items and using the button and mine still works, I am just not understanding how you have an issue with the smp and I don't with the same exact server files.

The following is my smp though if it helps...

USE [Telecaster]
GO

/****** Object:  StoredProcedure [dbo].[smp_update_character_hide_equip_flag]    Script Date: 1/17/2017 9:52:09 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- start of smp_update_character_hide_equip_flag
CREATE PROCEDURE [dbo].[smp_update_character_hide_equip_flag]
@IN_SID					INT,
@IN_HIDE_EQUIP_FLAG		INT
AS
SET NOCOUNT ON

UPDATE dbo.Character SET hide_equip_flag = @IN_HIDE_EQUIP_FLAG WHERE sid = @iN_SID

-- end of smp_update_character_hide_equip_flag

GO

You do have an sid column in your telecaster character table don't you?

[brkhnsvr94]

Yes I've tried 2 options. With deco items and without deco items. Both of them has given same result. I tried this query but not worked: Must declare the scalar variable "@iN_SID".
And also I have sid column in my table. There is no reason to not work.. But problem is still exist. Maybe I need to try another Telecaster backup. I'll search for this.. Can you back up your Telecaster db for me?

Note: I'm afraid and ashamed to want something from you.. Because you had a lot of work with me.. So you don't have to help me ..

EDIT: Problem is not telecaster db .. god .. what the hell is this problem???...

Here is my character table script:

 Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 18.1.2017 14:30:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Character](
[sid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](max) NULL,
[account] [varchar](60) NOT NULL,
[account_id] [int] NOT NULL,
[party_id] [int] NOT NULL,
[slot] [int] NOT NULL,
[permission] [int] NOT NULL,
[x] [int] NOT NULL,
[y] [int] NOT NULL,
[z] [int] NOT NULL,
[layer] [int] NOT NULL,
[race] [int] NOT NULL,
[sex] [int] NOT NULL,
[lv] [int] NOT NULL,
[max_reached_level] [int] NOT NULL,
[exp] [bigint] NOT NULL,
[last_decreased_exp] [bigint] NOT NULL,
[hp] [int] NOT NULL,
[mp] [int] NOT NULL,
[stamina] [int] NOT NULL,
[havoc] [int] NOT NULL,
[job] [int] NOT NULL,
[job_depth] [tinyint] NOT NULL,
[jlv] [int] NOT NULL,
[jp] [bigint] NOT NULL,
[total_jp] [bigint] NULL,
[talent_point] [int] NOT NULL,
[job_0] [int] NULL,
[job_1] [int] NULL,
[job_2] [int] NULL,
[jlv_0] [int] NULL,
[jlv_1] [int] NULL,
[jlv_2] [int] NULL,
[immoral_point] [decimal](18, 4) NOT NULL,
[cha] [int] NOT NULL,
[pkc] [int] NOT NULL,
[dkc] [int] NOT NULL,
[huntaholic_point] [int] NOT NULL,
[huntaholic_enter_count] [int] NOT NULL,
[ethereal_stone_durability] [int] NOT NULL,
[gold] [bigint] NOT NULL,
[chaos] [int] NOT NULL,
[skin_color] [int] NOT NULL,
[model_00] [int] NOT NULL,
[model_01] [int] NOT NULL,
[model_02] [int] NOT NULL,
[model_03] [int] NOT NULL,
[model_04] [int] NOT NULL,
[hair_color_index] [int] NOT NULL,
[hair_color_rgb] [int] NOT NULL,
[hide_equip_flag] [int] NOT NULL,
[texture_id] [int] NOT NULL,
[belt_00] [bigint] NOT NULL,
[belt_01] [bigint] NOT NULL,
[belt_02] [bigint] NOT NULL,
[belt_03] [bigint] NOT NULL,
[belt_04] [bigint] NOT NULL,
[belt_05] [bigint] NOT NULL,
[summon_0] [int] NOT NULL,
[summon_1] [int] NOT NULL,
[summon_2] [int] NOT NULL,
[summon_3] [int] NOT NULL,
[summon_4] [int] NOT NULL,
[summon_5] [int] NOT NULL,
[main_summon] [int] NOT NULL,
[sub_summon] [int] NOT NULL,
[remain_summon_time] [int] NOT NULL,
[pet] [int] NOT NULL,
[main_title] [int] NOT NULL,
[sub_title_0] [int] NOT NULL,
[sub_title_1] [int] NOT NULL,
[sub_title_2] [int] NOT NULL,
[sub_title_3] [int] NOT NULL,
[sub_title_4] [int] NOT NULL,
[remain_title_time] [int] NOT NULL,
[arena_point] [int] NOT NULL,
[arena_block_time] [datetime] NOT NULL,
[arena_penalty_count] [int] NOT NULL,
[arena_penalty_dec_time] [datetime] NOT NULL,
[arena_mvp_count] [int] NOT NULL,
[arena_record_0_0] [int] NOT NULL,
[arena_record_0_1] [int] NOT NULL,
[arena_record_1_0] [int] NOT NULL,
[arena_record_1_1] [int] NOT NULL,
[arena_record_2_0] [int] NOT NULL,
[arena_record_2_1] [int] NOT NULL,
[alias] [nvarchar](61) NOT NULL,
[create_time] [datetime] NOT NULL,
[delete_time] [datetime] NULL,
[login_time] [datetime] NOT NULL,
[login_count] [int] NOT NULL,
[logout_time] [datetime] NOT NULL,
[play_time] [int] NOT NULL,
[chat_block_time] [int] NOT NULL,
[adv_chat_count] [int] NOT NULL,
[name_changed] [int] NOT NULL,
[auto_used] [int] NOT NULL,
[pkmode] [tinyint] NOT NULL,
[otp_value] [int] NULL,
[otp_date] [datetime] NULL,
[flag_list] [varchar](1000) NOT NULL,
CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY CLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_last_decreased_exp] DEFAULT ((0)) FOR [last_decreased_exp]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_dkc] DEFAULT ((0)) FOR [dkc]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_main_summon] DEFAULT ((0)) FOR [main_summon]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_sub_summon] DEFAULT ((0)) FOR [sub_summon]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_remain_summon_time] DEFAULT ((0)) FOR [remain_summon_time]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF__Character_chat_block_time] DEFAULT ((0)) FOR [chat_block_time]
GO

[Azbeen]

Hello, when I start my "CaptainHerlockServer" he told me this :

"2017-01-18 21:30:22 Network initialize... ok

2017-01-18 21:30:22 IOCP initialize... ok

2017-01-18 21:30:22 Starting IOCP thread pool... ok

2017-01-18 21:30:22 LUA initialize... ok

2017-01-18 21:30:22 Launching ARCADIA... ok

2017-01-18 21:30:22 Start loading...


2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Spécification de permission non valide


2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516"

I have 0 error on my "RappelzServerAuth"

Do you have an idea please ?

[shiuyh2]

Originally Posted by Azbeen

Hello, when I start my "CaptainHerlockServer" he told me this :

"2017-01-18 21:30:22 Network initialize... ok

2017-01-18 21:30:22 IOCP initialize... ok

2017-01-18 21:30:22 Starting IOCP thread pool... ok

2017-01-18 21:30:22 LUA initialize... ok

2017-01-18 21:30:22 Launching ARCADIA... ok

2017-01-18 21:30:22 Start loading...


2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Spécification de permission non valide


2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516

2017-01-18 21:32:35 cannot connect log server: ip: 127.0.0.1, port: 4516"

I have 0 error on my "RappelzServerAuth"

Do you have an idea please ?

I'm having the same issue, read through all of the pages and tried all i could think of with no luck.

[SilentWisdom]

Originally Posted by shiuyh2

I'm having the same issue, read through all of the pages and tried all i could think of with no luck.

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Spécification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

[shiuyh2]

Originally Posted by SilentWisdom

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Spécification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

So i got up and went from the start again, the only issue I seem to be having now is with my CaptainHerlockServer. It will load all the way up to:

"Network initialize... ok
IOCP initialize... ok
Starting IOCP thread pool... ok
LUA initialize... ok
Launching ARCADIA... ok
Loading max item index... (1) ok"

At this point I get an error that "Game Server has stopped working" and the program closes.

This is my 1st server setup and any help would be appreciated!

[Azbeen]

Originally Posted by SilentWisdom

2017-01-18 21:30:22 ERROR: GAME DB INIT ERROR : Spécification de permission non valide

I don't speak french and I can still see your problem.

The login you specified for your Telecaster/Arcadia does not have permission to read.

Hey, hmm my Telecaster / Arcadia have the permissions for read.. So.. Do you have an other idea ?

[ThunderNikk]

You either did not set up user permissions correctly in the database, or you defined your users incorrectly in the .opt files.

If it is not your database then maybe it is your .opt file.