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
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
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------
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|
------------------------------------------------------------------------------
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
------------------------------------------------------------------------------
x86 Registers
------------------------------------------------------------------------------
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.
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.
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?
@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.
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?
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 ?
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
[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""
![[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}
guide (thanks for this).
