Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
Ep 6 Problem Help Deleting rune Ep 6 Problem Help Deleting rune
You last visited: Today at 20:21

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

Advertisement


Advertise with us!

Ep 6 Problem Help Deleting rune

Discussion on Ep 6 Problem Help Deleting rune within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
Unhappy Ep 6 Problem Help Deleting rune

Hello friends, we want to build shaiya server.
We tried to establish Episode 6 alone failed to result.
We need friends to Us to Help About It
Our website is okay.
Exit and re-entered the game in-game by pressing problem rune
When the rune seems to have been deleted.
Skil at the same time
looking for friends to help us
would like to thank


skype=bulutumyuksel
yukolo is offline  
Old 11/26/2012, 20:16   #2
 
JohnHeatz's Avatar
 
elite*gold: 150
The Black Market: 20/0/0
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
You might want to explain further, because I can't understand what your problem is
JohnHeatz is offline  
Thanks
1 User
Old 12/02/2012, 19:08   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
I'm sorry for my english is bad
I am from Turkey
I do not understand much english
I can write so sloppy translations
my problem
pressing entered the game rune
alone will be deleted from the game when you go back to the rune
I think the database does not work
Turkish friends who could not be helpful in this regard

(selamun aleyküm hocam mecbur buraya yazdım çünkü dil problemimiz var kusura bakmayın şimdi biz ep 6 server kurduk yalnız oyuna girdiğimizde rünü ve siklleri basıyoruz oyuna girip çıktığımızda rün ve skiller geri siliniyor tam 2,5 aydır bu problemin çözümünü bulamadık databaseyemi kaydetmiyor acaba problem nedir bir yardımcı olabilirmisiniz)

Skype=bulutumyuksel
yukolo is offline  
Old 12/02/2012, 19:11   #4
 
nephren's Avatar
 
elite*gold: 92
The Black Market: 3/0/0
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
Did you mean Rollback ?

please post logs: PSM_Client/bin/logs
nephren is offline  
Thanks
1 User
Old 12/02/2012, 19:25   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
now that we have established ep 6 server to play alone when we entered the rune and the rune and skills that cyclin pressing back in the game and deleting the database does not record the full 2.5 months, I wonder what the problem could not find a solution to this problem Can you help

soon be installing okay, thank you
yukolo is offline  
Old 12/02/2012, 19:35   #6
 
nephren's Avatar
 
elite*gold: 92
The Black Market: 3/0/0
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
Well, I guess you mean Rollback.
But without Logs we cannot help.
Please share your Serverlogs with us: PSM_Client/Bin/Logs post it here, it contains error-messages.
nephren is offline  
Old 12/02/2012, 19:56   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
Quote:
Originally Posted by peripher View Post
Well, I guess you mean Rollback.
But without Logs we cannot help.
Please share your Serverlogs with us: PSM_Client/Bin/Logs post it here, it contains error-messages.
DBAGENT

2012-12-02 20:33:29 PS_DBAGENT__system log start (DBAgent01)

Module list:

D:\ShaiyaServer\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2012-12-02 20:33:36 ### Connect[3688] : Game[?][0x0073F7C0], Addr=127.0.0.1, DBJobEnd=1

2012-12-02 20:33:36 ### Connect[3688] : Game[?][0x0073F918], Addr=127.0.0.1, DBJobEnd=2

2012-12-02 20:33:36 ### DB_SYSTEM_CONNECT[3736] :Game[1][0x0073F7C0], Name=Game01, Addr=127.0.0.1

2012-12-02 20:33:36 Error Packet : 0x209, CConnection::PacketSystemConnect

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}





PSGAME


2012-12-02 20:33:31 PS_GAME__system log start (Game01) [KR]

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/sorp1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/croco1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/croco2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Troll1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Spink1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/GoldenPig

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Sorp3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Sorp2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Deinos

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Parridalis

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Alcarian

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Belizabeth

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/Kirhiross

2012-12-02 20:33:31 Loaded Behavior In Factory : data/ai/CrypticOne

2012-12-02 20:33:32 RandomOption Error : ItemID=24070, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24111, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24112, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24118, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24119, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24125, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24126, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24154, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24240, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24249, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24250, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24251, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24252, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24253, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=24254, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39070, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39111, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39112, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39118, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39119, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39125, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39126, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39154, byServer=2, Wis=0

2012-12-02 20:33:32 RandomOption Error : ItemID=39240, byServer=2, Wis=0

2012-12-02 20:33:36 connect mgr 740

2012-12-02 20:33:36 connect dbagent 748

2012-12-02 20:33:36 connect dbagent2 760

2012-12-02 20:33:36 connect gamelog 792

2012-12-02 20:33:37 Market End -----------------------

2012-12-02 20:33:38 Load Shaiya.SData 0

2012-12-02 20:34:02 <Console input> /nprotectoff

2012-12-02 20:34:02 <Console output> cmd NProtect off ok

2012-12-02 20:37:05 discon client: (104, 64) T=000:02:00:000, RC=36,RCS=0, RB=324,RBS=2, SC=231,SCS=1, SB=4251,SBS=33




PS GAMELOG


2012-12-02 20:33:29 PS_GAMELOG__system log start (GameLog01)

Module list:

D:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52

2012-12-02 20:33:36 connect game

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,107, 0,83886080,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL , '0.0.0.0','money=184549376, bank=117444096, cash=167774720','level=0,skp=3328,stp=32512','s=0, d=257,i=0,w=0,r=0,l=0'

2012-12-02 20:36:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '10419551905839035000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:36:31 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,1232609113,'š|1T', 0,0,29545, 69768364807739612000000.000000,1041955190583903500 0000000000000000.000000,-0.000000, '2012-12-02 20:36:31',180, 103,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'çxIš G',NULL,NULL,NULL

2012-12-02 20:36:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:36:42 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7082,-568516798,10820, 0.000000,0.000000,2864.330322, '2012-12-00 00:06:07' ,111, 69540876599088,512,0,NULL,NULL,NULL,NULL,NULL,NULL ,NULL,'',NULL,'7,0,0,0,0,208 (Option','2000-00-15 25:38:18'

2012-12-02 20:36:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:36:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,262151578,'', 7082,-568516798,11332, 0.000000,0.000000,2864.330322, '2012-12-00 00:06:07' ,112, 69540876599088,-1706461184,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,'xIšç E','use_item','30,1,3,0,0,0 (Option:,Ìx»PF)-2002-12-00 00:00:00','bag=23,slot=104'

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL, 'money=184549376, bank=117444096, cash=167774720','level=0,skp=3328,stp=256','s=0,d= 0,i=0,w=0,r=0,l=0'

2012-12-02 20:37:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
yukolo is offline  
Old 12/02/2012, 20:10   #8
 
nephren's Avatar
 
elite*gold: 92
The Black Market: 3/0/0
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
Quote:
Originally Posted by yukolo View Post
DBAGENT


PS GAMELOG

2012-12-02 20:35:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '237959233063284080000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)

2012-12-02 20:35:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,0,'', 7086,-568516798,60484, -237959233063284080000000000000000000000.000000,0.0 00000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Enter',NULL,NULL,NULL

2012-12-02 20:37:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'gmlight',1,-48471899,'0', 7082,-568516798,17732, 0.000000,0.000000,0.000000, '2001-04-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'Leave',NULL,NULL,NULL
Your database/Stored Procedure have a lot of Errors.
That is the Point - i suggest to install a new: PS_GameDefs and PS_GameData.
You can backup characters with Export/import
but at this time the best thing is to attach a new
PS_GameDefs/Data. You can fix it of course, just download other Serverfiles and take a look at stored procedures.

The number '237959233063284080000000000000000000000.000000' is out of the range which means it cannot be stored please check your Chars/CharItems there is something wrong or cannot cooperate with current files/database

Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2012-12-02 20:37:05 ::SaveCharacter 2 artist ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(2,286,3,2591980)}

SkillID is not decleard - > @Skillid smallint

Take a look at here - this will help you a bit (should fix Skills):

Stored Procedure > PS_GameData -> Save_Char_Apply_Skill_E2:
Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 12/02/2012 20:17:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime)

IF(@@ERROR = 0)
BEGIN
    RETURN 1
END
ELSE
BEGIN
    RETURN -1
END

SET NOCOUNT OFF
nephren is offline  
Thanks
4 Users
Old 12/02/2012, 21:47   #9
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Sep 2011
Posts: 61
Received Thanks: 4
Thank you very much for your interest
I'll try, thank you very, very much
yukolo is offline  
Reply

« Questions about pvp rewarding and speed enchant | Update Help - Paying $200 »

Similar Threads Similar Threads
[2 Questions] Deleting EU - Deleting Skills
06/26/2015 - SRO Private Server - 4 Replies
How can i disable creating eu chars WITHOUT disabling cosntaniple area on BR files ? I need to make the max level cap 80(i think i need help about it either i need to make required exp point to level up to 81, 9999999999 but from where ?) but first i need to delete 80 - 100 level skills on media pk2; from where and how ? Thanks
WTS: NA LoL Acct, 56 Champs, 5 Rune pages. Top Elo 1572, many rune sets.
07/04/2012 - League of Legends Trading - 0 Replies
I am wanting to sell one of my LvL 30 accts that I dont play much anymore besides when I goof off with friends. It currently has 56 champs, 5 rune pages, a few skins. Top elo of 1572, Current elo of 1312. I've spent a bit of money on it. It currently has 175RP and 3602 IP. The summoner name is 2Good2BeTru. Im looking for no less then $50 US Dollars made through PayPal. The account is in good standing with 0 bans/warnings. I will not release the information to the account until the payment...
Selling lvl 30 NA account, 36 champs, 4 rune pages, 4 T3 rune sets, and skins!
03/02/2012 - League of Legends Trading - 1 Replies
this account has all the things you could want in any league of legends account, skins, champions, runes, rune pages! i have personally also spent over $120 on riot points for this account some of the benefits include: 36 champions: akali alistar amumu annie ashe casseopeia
EU WEST ACCOUNT - 53 SKINS - 11 Rune Page with Rune Set - NOT OWNED 11 CHAMP
01/30/2012 - League of Legends Trading - 8 Replies
Hello Elitepvpers ;) I'm selling League of Legends Europe-West Account with Rare Skins,Many Skins,Champions,Runes... I have 53 Skins include Rare-Limited Skins. I don't have only 11 Champions. I have 5, Tier 3 Mark Sets.6 Seals Tier 3 Sets,6 Glyphs Tier 3 Sets,7 Quintessince Sets. Everysets have 9 runes. 9x5 + 9x6 + 9x6 + 9x7 Runes with 11 Rune Pages.
MLE Rune Hack Problem
05/04/2009 - Grand Chase - 9 Replies
I've been doing these steps for many-many times. Actually, I got it working on my first try. But, I forgot to save it in my MLE now, I tried a hundred times to make it work again. Actually I spend 500 aging cores already for the runes. But, I didn't get it working. What seems the problem? :confused:



All times are GMT +1. The time now is 20:22.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.