Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 18:37

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #4471
 
elite*gold: 0
Join Date: Aug 2014
Posts: 82
Received Thanks: 12
hi , is there any way to get player guild name ??



colonelx is offline  
Old   #4472
 
elite*gold: 0
Join Date: May 2010
Posts: 74
Received Thanks: 6
Thanks iSmoke

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


bertie2008 is offline  
Old   #4473
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 961
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 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?
ThunderNikk is offline  
Old   #4474
 
elite*gold: 0
Join Date: May 2010
Posts: 74
Received Thanks: 6
this may help

Quote:
Originally Posted by Lawcry View Post
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

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


bertie2008 is offline  
Old   #4475
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
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.
ismokedrow is offline  
Old   #4476
 
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
MC Bug

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.

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)
Domesday Brock is offline  
Old   #4477
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
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.

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?
ismokedrow is offline  
Old   #4478
 
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
MC Bug

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.
Domesday Brock is offline  
Old   #4479
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
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.
mohamad512 is offline  
Old   #4480
 
elite*gold: 0
Join Date: Nov 2009
Posts: 303
Received Thanks: 30
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.
tokesbowls is offline  
Old   #4481
 
elite*gold: 0
Join Date: Feb 2014
Posts: 146
Received Thanks: 34
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 :
You must register and activate your account in order to view images.


If my Creature has Equip:
You must register and activate your account in order to view images.

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 ?
Aurorauser is offline  
Old   #4482
 
elite*gold: 20
Join Date: Sep 2010
Posts: 57
Received Thanks: 25
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
Saltaya is offline  
Thanks
1 User
Old   #4483
 
elite*gold: 0
Join Date: Aug 2014
Posts: 82
Received Thanks: 12
is there any way to get player guild name ??
colonelx is offline  
Old   #4484
 
elite*gold: 0
Join Date: Feb 2014
Posts: 146
Received Thanks: 34
Sql viev player guild table and guild table and character table inner join function
Aurorauser is offline  
Old   #4485
 
elite*gold: 0
Join Date: Aug 2011
Posts: 170
Received Thanks: 32
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


Modamer9 is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
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...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 18:37.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.