[Help Thread] Please post your questions here.

Page 299 of 586 « First 199249289297298 299 300301309349399 Last »
04/17/2015 18:47 bertie2008#4471
Quote:
Originally Posted by ismokedrow View Post
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 ThunderNikk#4472
Quote:
Originally Posted by mohamad512 View Post
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 View Post
Hi guys,

i just tried to setup 9.1 server on my laptop following [Only registered and activated users can see links. Click Here To Register...] guide (thanks for this).

My problem is, that when i try to launch GameServer it crashes without error.

GameLog.txt is empty.

My System

gameserver.opt

/log/*_2015...txt

Arcadia .... .txt

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 bertie2008#4473
Quote:
Originally Posted by Lawcry View Post
Hi guys,

i just tried to setup 9.1 server on my laptop following [Only registered and activated users can see links. Click Here To Register...] guide (thanks for this).

My problem is, that when i try to launch GameServer it crashes without error.

GameLog.txt is empty.

My System

gameserver.opt

/log/*_2015...txt

Arcadia .... .txt

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 ismokedrow#4474
Quote:
Originally Posted by bertie2008 View Post
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 Domesday Brock#4475
Quote:
Originally Posted by ismokedrow View Post
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.:D

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 View Post
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 ismokedrow#4476
Quote:
Originally Posted by Domesday Brock View Post
Assumed you would be to busy updating your server that's why I didn't contact you.:D

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 Domesday Brock#4477
Quote:
Originally Posted by ismokedrow View Post
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 mohamad512#4478
Quote:
Originally Posted by thndr View Post
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 tokesbowls#4479
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 Aurorauser#4480
Quote:
Originally Posted by TheOnlyOneRaskim View Post
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 :
[Only registered and activated users can see links. Click Here To Register...]


If my Creature has Equip:
[Only registered and activated users can see links. Click Here To Register...]

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 Saltaya#4481
He answered his own Question allready

Quote:
Originally Posted by TheOnlyOneRaskim View Post
Got it now.

The Telecaster stores different Informations with the gcode column.

If anybody else ran into this:


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 colonelx#4482
is there any way to get player guild name ??
04/18/2015 15:39 Aurorauser#4483
Sql viev player guild table and guild table and character table inner join function
04/18/2015 15:54 Modamer9#4484
Quote:
Originally Posted by TheOnlyOneRaskim View Post
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 TheOnlyOneRaskim#4485
Quote:
Originally Posted by Modamer9 View Post
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
[Only registered and activated users can see links. Click Here To Register...]


Quote:
Originally Posted by colonelx View Post
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
Page 299 of 586 « First 199249289297298 299 300301309349399 Last »