|
You last visited: Today at 09:22
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
04/17/2015, 18:47
|
#4471
|
elite*gold: 0 
Join Date: May 2010
Posts: 91
Received Thanks: 7
|
Thanks iSmoke
Quote:
Originally Posted by ismokedrow
If you all would provide an SQL Trace from SQL Profiler when this issue happens, it would be a LOT easier to figure out what parameters are causing the bad conversion.
|
this may be information overload but i see red writing so me thinks there must be some problem here as well
First:
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output, N'@P1 varchar(6),@P2 varchar(33)',N'SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = @P1 AND password = @P2;','tspIsKing','32a41055bbabaae02a457dac5e799ac 5'
select @p1
Next:
declare @p1 int
set @p1=1
exec sp_prepexec @ p1 output,N'@P1 smallint,@P2 int',N'UPDATE accounts SET last_login_server_idx = @P1 WHERE account_id = @P2;',1,1002
select @p1
next one is long
declare @p2 varchar(4096)
set @p2=' CLIENTVER=2|'
declare @p3 varchar(4096)
set @p3=' QS2=0,2,0|QS2=12,1,2679,11|QS2=13,1,2671,9|QS2=21, 3,690343|QS2=23,0,1152|QS2=36,1,31208,10|QS2=45,0, 1181|QS2=58,1,4001,1|QS2=60,1,31204,10|QS2=69,0,11 80|QS2=72,1,45660,17,16|QS2=73,1,45015,15,16|QS2=7 4,1,48208,15,16|QS2=84,1,50201,7|QS2=93,0,1179|QS2 =95,0,1193|CLIENTVER=2|'
declare @p4 varchar(4096)
set
@p4=' KMT=0,0,0,0,192|KMT=1,0,0,0,73|KMT=2,0,0,0,75|KMT= 3,0,0,0,67|KMT=4,0,0,0,89|KMT=5,0,0,0,69|KMT=6,0,0 ,0,82|KMT=7,0,0,0,70|KMT=8,0,0,0,71|KMT=9,0,0,0,80 |KMT=10,0,0,0,81|KMT=11,0,0,0,77|KMT=12,0,0,0,84|K MT=13,0,0,0,72|KMT=14,0,0,0,90|KMT=15,0,0,0,79|KMT =16,0,0,0,0|KMT=17,0,0,0,86|KMT=18,0,0,0,0|KMT=19, 0,0,1,115|KMT=20,0,0,1,70|KMT=21,0,0,1,72|KMT=22,0 ,0,1,219|KMT=23,0,0,1,221|KMT=24,0,0,1,80|KMT=25,0 ,0,0,9|KMT=26,0,0,0,32|KMT=27,0,0,0,49|KMT=28,0,0, 0,50|KMT=29,0,0,0,51|KMT=30,0,0,0,52|KMT=31,0,0,0, 53|KMT=32,0,0,0,54|KMT=33,0,0,0,55|KMT=34,0,0,0,56 |KMT=35,0,0,0,57|KMT=36,0,0,0,48|KMT=37,0,0,0,189| KMT=38,0,0,0,187|KMT=39,0,1,0,49|KMT=40,0,1,0,50|K MT=41,0,1,0,51|KMT=42,0,1,0,52|KMT=43,0,1,0,53|KMT =44,0,1,0,54|KMT=45,0,1,0,55|KMT=46,0,1,0,56|KMT=4 7,0,1,0,57|KMT=48,0,1,0,48|KMT=49,0,1,0,189|KMT=50 ,0,1,0,187|KMT=51,0,0,1,49|KMT=52,0,0,1,50|KMT=53, 0,0,1,51|KMT=54,0,0,1,52|KMT=55,0,0,1,53|KMT=56,0, 0,1,54|KMT=57,0,0,1,55|KMT=58,0,0,1,56|KMT=59,0,0, 1,57|KMT=60,0,0,1,48|KMT=61,0,0,1,189|KMT=62,0,0,1 ,187|KMT=63,1,0,0,49|KMT=64,1,0,0,50|KMT=65,1,0,0, 51|KMT=66,1,0,0,52|KMT=67,1,0,0,53|KMT=68,1,0,0,54 |KMT=69,1,0,0,55|KMT=70,1,0,0,56|KMT=71,1,0,0,57|K MT=72,1,0,0,48|KMT=73,1,0,0,189|KMT=74,1,0,0,220|K MT=75,0,0,0,0|KMT=76,0,0,0,0|KMT=77,0,0,0,0|KMT=78 ,0,0,0,0|KMT=79,0,0,0,0|KMT=80,0,0,0,0|KMT=81,0,0, 0,0|KMT=82,0,0,0,0|KMT=83,0,0,0,0|KMT=84,0,0,0,0|K MT=85,0,0,0,0|KMT=86,0,0,0,0|KMT=87,0,0,0,0|KMT=88 ,0,0,0,0|KMT=89,0,0,0,0|KMT=90,0,0,0,0|KMT=91,0,0, 0,0|KMT=92,0,0,0,0|KMT=93,0,0,0,0|KMT=94,0,0,0,0|K MT=95,0,0,0,0|KMT=96,0,0,0,0|KMT=97,0,0,0,0|KMT=98 ,0,0,0,0|KMT=99,0,0,0,0|KMT=100,0,0,0,0|KMT=101,0, 0,0,0|KMT=102,0,0,0,0|KMT=103,0,0,0,0|KMT=104,0,0, 0,0|KMT=105,0,0,0,0|KMT=106,0,0,0,0|KMT=107,0,0,0, 0|KMT=108,0,0,0,0|KMT=109,0,0,0,0|KMT=110,0,0,0,0| KMT=111,0,0,0,0|KMT=112,0,0,0,0|KMT=113,0,0,0,0|KM T=114,0,0,0,0|KMT=115,0,0,0,0|KMT=116,0,0,0,0|KMT= 117,0,0,0,0|KMT=118,0,0,0,0|KMT=119,0,0,0,0|KMT=12 0,0,0,0,0|KMT=121,0,0,0,0|KMT=122,0,0,0,0|KMT=123, 0,0,0,0|KMT=124,0,0,0,0|KMT=125,0,0,0,85|KMT=126,0 ,0,0,0|KMT=127,0,0,0,0|KMT=128,0,0,0,0|KMT=129,0,0 ,0,112|KMT=130,0,0,0,113|KMT=131,0,0,0,114|KMT=132 ,0,0,0,115|KMT=133,0,0,0,116|KMT=134,0,0,0,117|KMT =135,0,0,0,118|KMT=136,0,0,0,119|KMT=137,0,0,0,186 |KMT=138,0,0,0,78|KMT=139,0,0,0,87|KMT=140,0,0,0,8 3|KMT=141,0,0,0,65|KMT=142,0,0,0,68|ENTERCHATMODE= 1|CLIENTVER=2|'
declare @p5 varchar(4096)
set @p5=' CLIENTVER=2|'
exec dbo.smp_read_client_info 444219,@p2 output,@p3 output,@p4 output,@p5 output
select @p2, @p3, @p4, @p
And the last one
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444219,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
|
|
|
|
04/17/2015, 18:49
|
#4472
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,912
Received Thanks: 1,490
|
Quote:
Originally Posted by mohamad512
hey ...
I'm trying to run cash shop on my PC ..
*i'm using IIS8
but this error came out : Call to undefined function mssql_connect()
|
You have not identified the function mssql_connect() with your connection strings to connect to your database.
Quote:
Originally Posted by Lawcry
Hi guys,
i just tried to setup 9.1 server on my laptop following  guide (thanks for this).
My problem is, that when i try to launch GameServer it crashes without error.
GameLog.txt is empty.
My System
Windows 8.1 x64
Processor: i7-4700HQ
RAM 16GB
gameserver.opt
S:app.name:Xeon
T:auth.server_idx:1
S:auth.server_name:Xeon Rappelz
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:Patrick
S:db.c._password:*************
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:Sandy
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:8
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
/log/*_2015...txt
2015-04-17 18:04:15 Network initialize... ok
2015-04-17 18:04:15 IOCP initialize... ok
2015-04-17 18:04:15 Starting IOCP thread pool... ok
2015-04-17 18:04:15 LUA initialize... ok
2015-04-17 18:04:15 Launching ARCADIA... ok
2015-04-17 18:04:15 Start loading...
2015-04-17 18:04:15 Loading max Item index... (1) ok
2015-04-17 18:04:15 Loading Complete.
Arcadia .... .txt
================================================== ============================
------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------
00 Thread name : IOCP 00
00 job info :
00 job id : 0
00 counter : 0
00 execute time : 0
01 Thread name : IOCP 01
01 job info :
01 job id : 0
01 counter : 0
01 execute time : 0
02 Thread name : IOCP 02
02 job info :
02 job id : 0
02 counter : 0
02 execute time : 0
03 Thread name : IOCP 03
03 job info :
03 job id : 0
03 counter : 0
03 execute time : 0
04 Thread name : Scheduler 00
04 job info : ItemCollector(0xB8E3C1B0)
04 job id : 0
04 counter : 0
04 execute time : 992
05 Thread name : Scheduler 01
05 job info : _ServerStatusReport(0xB8E3ABE0)
05 job id : 0
05 counter : 0
05 execute time : 992
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 : R:\XeonRZ 9.1\Main Server\server_bin\Game_bin\CaptainHerlockServer.ex e
User : ryllez
Computer : LAWCRY
Program :
Exception : E06D7363 ()
Fault Address: 00007FF894898B9C 01:00007B9C
Mem Usage : 1971600KB / 1924252KB
------------------------------------------------------------------------------
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=0000000000000000 RBX=0000000002BAF2E0 RCX=0000000079E9AF80 RDX=0000000000000000
ESI=0000000080004005 EDI=00007FF7B8E1F978 EBP=0000000002BAF2B0
DS =002B ES=002B FS=0053 GS:002B
CS:RIP=0033:00007FF894898B9C
SS:RSP=002B:0000000002BAF170
Flags=00000206
------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00E1E978
app.cmdline : "R:\XeonRZ 9.1\Main Server\server_bin\Game_bin\CaptainHerlockServer.ex e"
app.filesize : 5393648
app.filetime : 2014/09/12-15:29:42
app.name : Xeon
auth.server_idx : 1
auth.server_name : Xeon Rappelz
console.allow_ip : 127.0.0.1
console.port : 44554
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 : 0
db.user.server : 127.0.0.1
db.user.thread : 4
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 : 1000
engine.count_client : 0
engine.count_movable : 0
engine.count_static : 0
engine.lock : 0
engine.region_size : 180
engine.scheduler.0.instruction : 3
engine.scheduler.0.object : 1
engine.scheduler.1.instruction : 3
engine.scheduler.1.object : 1
engine.scheduler.2.instruction : 3
engine.scheduler.2.object : 0
engine.scheduler.3.instruction : 3
engine.scheduler.3.object : 0
engine.scheduler.destroy_cnt : 0
engine.scheduler.destroy_loop : 3
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 : 0
game.PathFindingCount : 0
game.ProcessingMonsterCount : 0
game.ProcessingMonsterTime : 0
game.ProcessingPlayerCount : 0
game.ProcessingPlayerTime : 0
game.ProcessingSummonCount : 0
game.ProcessingSummonTime : 0
game.RandomMove : 0
game.ServiceServer : 0
game.TracingGamePerformance : 1
game.allowed_special_char :
game.ally_pcbang_bonus_rate : 0.300000
game.ally_pcbang_chaos_bonus_rate : 0.300000
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 : 300
game.bUseLockDelayLogging : 0
Can't figure it out... |
Telecaster tries to restore as Telecaster1 did you check that your database name and the name in gameserver.opt match?
|
|
|
|
|
04/17/2015, 19:07
|
#4473
|
elite*gold: 0
Join Date: May 2010
Posts: 91
Received Thanks: 7
|
this may help
Quote:
Originally Posted by Lawcry
Hi guys,
i just tried to setup 9.1 server on my laptop following guide (thanks for this).
My problem is, that when i try to launch GameServer it crashes without error.
GameLog.txt is empty.
My System
Windows 8.1 x64
Processor: i7-4700HQ
RAM 16GB
gameserver.opt
S:app.name:Xeon
T:auth.server_idx:1 for some reason i had to change this to N:auth.server_idx:1
S:auth.server_name:Xeon Rappelz
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:8
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
/log/*_2015...txt
2015-04-17 18:04:15 Network initialize... ok
2015-04-17 18:04:15 IOCP initialize... ok
2015-04-17 18:04:15 Starting IOCP thread pool... ok
2015-04-17 18:04:15 LUA initialize... ok
2015-04-17 18:04:15 Launching ARCADIA... ok
2015-04-17 18:04:15 Start loading...
2015-04-17 18:04:15 Loading max Item index... (1) ok
2015-04-17 18:04:15 Loading Complete.
Arcadia .... .txt
================================================== ============================
------------------------------------------------------------------------------
Thread Information
------------------------------------------------------------------------------
00 Thread name : IOCP 00
00 job info :
00 job id : 0
00 counter : 0
00 execute time : 0
01 Thread name : IOCP 01
01 job info :
01 job id : 0
01 counter : 0
01 execute time : 0
02 Thread name : IOCP 02
02 job info :
02 job id : 0
02 counter : 0
02 execute time : 0
03 Thread name : IOCP 03
03 job info :
03 job id : 0
03 counter : 0
03 execute time : 0
04 Thread name : Scheduler 00
04 job info : ItemCollector(0xB8E3C1B0)
04 job id : 0
04 counter : 0
04 execute time : 992
05 Thread name : Scheduler 01
05 job info : _ServerStatusReport(0xB8E3ABE0)
05 job id : 0
05 counter : 0
05 execute time : 992
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 : R:\XeonRZ 9.1\Main Server\server_bin\Game_bin\CaptainHerlockServer.ex e
User : ryllez
Computer : LAWCRY
Program :
Exception : E06D7363 ()
Fault Address: 00007FF894898B9C 01:00007B9C
Mem Usage : 1971600KB / 1924252KB
------------------------------------------------------------------------------
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=0000000000000000 RBX=0000000002BAF2E0 RCX=0000000079E9AF80 RDX=0000000000000000
ESI=0000000080004005 EDI=00007FF7B8E1F978 EBP=0000000002BAF2B0
DS =002B ES=002B FS=0053 GS:002B
CS:RIP=0033:00007FF894898B9C
SS:RSP=002B:0000000002BAF170
Flags=00000206
------------------------------------------------------------------------------
Environment dump
------------------------------------------------------------------------------
app.checksum : 00E1E978
app.cmdline : "R:\XeonRZ 9.1\Main Server\server_bin\Game_bin\CaptainHerlockServer.ex e"
app.filesize : 5393648
app.filetime : 2014/09/12-15:29:42
app.name : Xeon
auth.server_idx : 1
auth.server_name : Xeon Rappelz
console.allow_ip : 127.0.0.1
console.port : 44554
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 : 0
db.user.server : 127.0.0.1
db.user.thread : 4
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 : 1000
engine.count_client : 0
engine.count_movable : 0
engine.count_static : 0
engine.lock : 0
engine.region_size : 180
engine.scheduler.0.instruction : 3
engine.scheduler.0.object : 1
engine.scheduler.1.instruction : 3
engine.scheduler.1.object : 1
engine.scheduler.2.instruction : 3
engine.scheduler.2.object : 0
engine.scheduler.3.instruction : 3
engine.scheduler.3.object : 0
engine.scheduler.destroy_cnt : 0
engine.scheduler.destroy_loop : 3
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 : 0
game.PathFindingCount : 0
game.ProcessingMonsterCount : 0
game.ProcessingMonsterTime : 0
game.ProcessingPlayerCount : 0
game.ProcessingPlayerTime : 0
game.ProcessingSummonCount : 0
game.ProcessingSummonTime : 0
game.RandomMove : 0
game.ServiceServer : 0
game.TracingGamePerformance : 1
game.allowed_special_char :
game.ally_pcbang_bonus_rate : 0.300000
game.ally_pcbang_chaos_bonus_rate : 0.300000
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 : 300
game.bUseLockDelayLogging : 0
Can't figure it out... |
if you followed Drows tut your accs should be :sa as i marked in red
|
|
|
|
|
04/17/2015, 19:16
|
#4474
|
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,460
|
Quote:
Originally Posted by bertie2008
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444219,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
|
Issue this as a query into your SQL (targeting your telecaster) and paste me the screenie of results plz. I don't have anything in my paiditem table, so I can't reproduce at the moment.
|
|
|
|
|
04/17/2015, 19:17
|
#4475
|
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
|
MC Bug
Quote:
Originally Posted by ismokedrow
If you all would provide an SQL Trace from SQL Profiler when this issue happens, it would be a LOT easier to figure out what parameters are causing the bad conversion.
|
Assumed you would be to busy updating your server that's why I didn't contact you. 
I think this is what you requested
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444217,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
very similar to 2008's I see
Quote:
Originally Posted by ismokedrow
Issue this as a query into your SQL (targeting your telecaster) and paste me the screenie of results plz. I don't have anything in my paiditem table, so I can't reproduce at the moment.
|
Querie:
USE [telecaster]
GO
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444217,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
Result:
Msg 8115, Level 16, State 2, Procedure smp_check_purchased_item, Line 42
Arithmetic overflow error converting expression to data type int.
(1 row(s) affected)
|
|
|
|
|
04/17/2015, 19:45
|
#4476
|
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,460
|
Quote:
Originally Posted by Domesday Brock
Assumed you would be to busy updating your server that's why I didn't contact you.
I think this is what you requested
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444217,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
very similar to 2008's I see
Querie:
USE [telecaster]
GO
declare @p3 int
set @p3=0
declare @p4 int
set @p4=0
declare @p5 int
set @p5=0
declare @p6 int
set @p6=0
declare @p7 int
set @p7=0
exec dbo.smp_check_purchased_item 1002,444217,@p3 output,@p4 output,@p5 output,@p6 output,@p7 output
select @p3, @p4, @p5, @p6, @p7
Result:
Msg 8115, Level 16, State 2, Procedure smp_check_purchased_item, Line 42
Arithmetic overflow error converting expression to data type int.
(1 row(s) affected) |
Line 42 =
Code:
SET @OUT_STAMINA_REGEN_TIME = 0
@OUT_STAMINA_REGEN_TIME is an INT so setting it 0 would cause that. o.O Are you sure you captured your own execute via profiler or did you just copy the one I told bert about?
|
|
|
|
|
04/17/2015, 19:58
|
#4477
|
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
|
MC Bug
Quote:
Originally Posted by ismokedrow
Line 42 =
Code:
SET @OUT_STAMINA_REGEN_TIME = 0
@OUT_STAMINA_REGEN_TIME is an INT so setting it 0 would cause that. o.O Are you sure you captured your own execute via profiler or did you just copy the one I told bert about? |
Its my execute via profiler, I loged onto the wrong toon when i ran profiler though, with the problem MC toon this is the result:
Msg 8115, Level 16, State 2, Procedure smp_check_purchased_item, Line 43
Arithmetic overflow error converting expression to data type int.
|
|
|
|
|
04/17/2015, 22:46
|
#4478
|
elite*gold: 0
Join Date: Feb 2013
Posts: 119
Received Thanks: 13
|
Quote:
Originally Posted by thndr
You have not identified the function mssql_connect() with your connection strings to connect to your database.
Telecaster tries to restore as Telecaster1 did you check that your database name and the name in gameserver.opt match?
|
I have identified it , but the error still come out.
|
|
|
|
|
04/17/2015, 22:50
|
#4479
|
elite*gold: 0
Join Date: Nov 2009
Posts: 308
Received Thanks: 32
|
Hello,
So my 9.1 has been running with no issues, until i noticed today its not dropping E-Unique cards
Has anyone else had this issues, and if so how did you fix it. for them to drop proper?
Thank you for your time and help.
|
|
|
|
|
04/18/2015, 00:59
|
#4480
|
elite*gold: 0
Join Date: Feb 2014
Posts: 146
Received Thanks: 35
|
Quote:
Originally Posted by TheOnlyOneRaskim
Hi Guy's,
incredible that im asking E*pvp but im Stuck and maybe someone got the Fix for me.
Well im currently writing an application, wich gives me all user related infos.
But for some Reason i have an minor bug (maybe application itself but cant find any error code). Im using an SQL Query to get the inventory/Warehouse etc pp.
Now when it loads the Main Weapon and the Offhand, it loads my pet's armory (if equipped)
Example below:
Without Creature has Equip :
If my Creature has Equip:
If someone has the Right gcode for character equip, i would like to know it.
Thanks in Advance ^^ |
C# picturebox make codebehind and properties options sometime characters problem equepment_slot two rows look execute sql query ?
|
|
|
|
|
04/18/2015, 02:18
|
#4481
|
elite*gold: 20
Join Date: Sep 2010
Posts: 57
Received Thanks: 25
|
He answered his own Question allready
Quote:
Originally Posted by TheOnlyOneRaskim
Got it now.
The Telecaster stores different Informations with the gcode column.
If anybody else ran into this:
wear_info
Code:
public string[] item_set_parts =
{
"0:Mainhand","1:Offhand","2:armor","3:Helmet","4:gloves","5:boot","6:belt","7:cloak","8:necklace","9:1. Ring","10:2. Ring","11:earring",
"12:face deco","13:hair","14:Deco Mainhand","15:Deco Offhand","16:Deco armor","17:Deco Helmet","18:Deco glove","19:Deco boot","20:Deco cloak",
"21:Deco wings"
};
gcode
Code:
1 = pet
3 = character
For example you want to get the mainhand
Code:
use telecaster
select * from item where wear_type = 0 and gcode = 3
go
|
|
|
|
|
|
04/18/2015, 12:38
|
#4482
|
elite*gold: 0
Join Date: Aug 2014
Posts: 83
Received Thanks: 17
|
is there any way to get player guild name ??
|
|
|
|
|
04/18/2015, 15:39
|
#4483
|
elite*gold: 0
Join Date: Feb 2014
Posts: 146
Received Thanks: 35
|
Sql viev player guild table and guild table and character table inner join function
|
|
|
|
|
04/18/2015, 15:54
|
#4484
|
elite*gold: 0
Join Date: Aug 2011
Posts: 185
Received Thanks: 33
|
Quote:
Originally Posted by TheOnlyOneRaskim
Got it now.
For example you want to get the mainhand
Code:
use telecaster
select * from item where [B]wear_type[/B] = 0 and gcode = 3
go
|
wear_info not wear_type
|
|
|
|
|
04/18/2015, 17:16
|
#4485
|
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
|
Quote:
Originally Posted by Modamer9
wear_info not wear_type
|
Sorry, was just an quick and dirty writing from me :P
Btw if you want to correct me, than do it right.
The Wear info flags wich were written down from me, weren't correct.
It's like that:
gcode: 0 or 3 = player equip
So getting the Mainhand would be look like that:
Code:
declare @Name nvarchar(max)
set @Name = 'Raskim'
select s.value,i.enhance,i.level,i.cnt,i.wear_info,inv.icon_file_name,c.chaos,inv.socket,c.gold,c.arena_point
,c.huntaholic_point,i.flag,i.socket_0 as 'summon_char_id',i.gcode,
ISNULL((select value from arcadia.dbo.ItemResource join arcadia.dbo.stringresource on name_id = code where id = i.socket_0),'Leer') as 'socket_0',
ISNULL((select value from arcadia.dbo.ItemResource join arcadia.dbo.stringresource on name_id = code where id = i.socket_1),'Leer') as 'socket_1',
ISNULL((select value from arcadia.dbo.ItemResource join arcadia.dbo.stringresource on name_id = code where id = i.socket_2),'Leer') as 'socket_2',
ISNULL((select value from arcadia.dbo.ItemResource join arcadia.dbo.stringresource on name_id = code where id = i.socket_3),'Leer') as 'socket_3'
from telecaster.dbo.Item i join telecaster.dbo.Character c on i.owner_id = c.sid
join arcadia.dbo.StringResource s on (select name_id from arcadia.dbo.ItemResource where id = i.code) = s.code
join arcadia.dbo.ItemResource inv on i.code = inv.id
where c.name = @Name and i.wear_info in (0,1) and i.gcode in(0,3)
order by i.sid
Quote:
Originally Posted by colonelx
is there any way to get player guild name ??
------------------------------------------------
Code:
use telecaster
select c.name as 'Player Name',gu.name as 'Guild Name',g.permission from GuildMember g
join character c on g.player_id = c.sid
join Guild gu on g.guild_id = gu.sid
|
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 09:23.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
