|
You last visited: Today at 17:12
Advertisement
Warehouse error
Discussion on Warehouse error within the Shaiya Private Server forum part of the Shaiya category.
06/17/2013, 03:54
|
#1
|
elite*gold: 0
Join Date: Sep 2010
Posts: 17
Received Thanks: 1
|
Warehouse error
Hi, i know, iknow, the are others threads about this and i should have to look for them in the search bar....
i've already done that but anything i tried worked...
i resume my problem in 3 photos...
the same happens when i use a reset skills, i haven't tried with reset stats and sumons but if the game crashes with reset skills i supose, it will be the same...
if anyone could give me an answer, (a detailed answer pliz  i'm kind of slow to learn xP ) i'd be a happier person n_n
anybody? D:
|
|
|
06/18/2013, 19:58
|
#2
|
elite*gold: 0
Join Date: Sep 2010
Posts: 17
Received Thanks: 1
|
somebody help me please
|
|
|
06/18/2013, 20:27
|
#3
|
elite*gold: 0
Join Date: Feb 2013
Posts: 36
Received Thanks: 1
|
Use search ...
I do not remember which is why this error, and you did not show logs, fix it, sort of.
USE PS_GameLog;
GO
drop procedure [dbo].[usp_Insert_Action_Log_E]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E ******/
CREATE Proc usp_Insert_Action_Log_E
@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTimeZ varchar(50),
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1
AS
DECLARE @ActionTime as datetime
SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120)
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)
IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END
IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END
SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType,
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'
EXEC sp_executesql @Sql,
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint,
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int,
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType,
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
|
|
06/19/2013, 17:36
|
#4
|
elite*gold: 0
Join Date: Sep 2010
Posts: 17
Received Thanks: 1
|
here are my logs
|
|
|
08/21/2013, 11:19
|
#5
|
elite*gold: 0
Join Date: Mar 2012
Posts: 12
Received Thanks: 2
|
I have the same problem :/
|
|
|
08/23/2013, 04:58
|
#6
|
elite*gold: 0
Join Date: Nov 2011
Posts: 4
Received Thanks: 0
|
install ur sql in english
|
|
|
08/23/2013, 08:31
|
#7
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,456
|
I'd re-install the whole server and re-attach the databases, sometimes it fixes problems like this one. Take my advice, use the Omega files.
|
|
|
 |
Similar Threads
|
Warehouse
06/30/2011 - Rappelz - 2 Replies
Has there been a way to fix the warehouse yet? I have read through several threads but havent seen anything yet.
|
[Problem] Error with warehouse
09/18/2010 - CO2 Private Server - 20 Replies
Can anyone explain why i have this error please :confused:
http://kevin.tofriends.com/error.jpg
Line 679 in Packets.cs
byte Packet = new byte;
Line 87 in Warehouse.cs
GC.AddSend(Packets.SendWarehouse(GC.MyChar, (ushort)NPC));
|
Warehouse.
01/11/2010 - Conquer Online 2 - 3 Replies
I was wondering if they still have a warehouse crack so we could open the warehouse without the password. I forgot my warehouse password and obviously i dont have a valid email for the wh..So can someone help me out here?
|
Warehouse pw
08/16/2009 - Conquer Online 2 - 20 Replies
Is there an way the bypass orsomething warehouse pw there whas tread but i cant find it anymore .. plz help me!
|
Warehouse Pw
09/01/2006 - Conquer Online 2 - 1 Replies
is there anyway to hack a warehouse password. is there any program
|
All times are GMT +1. The time now is 17:12.
|
|