Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Shaiya › Shaiya Private Server
Bad or missing proc or what?-Shop Problem -.-' Bad or missing proc or what?-Shop Problem -.-'
You last visited: Today at 19:07

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

Advertisement


Advertise with us!

Bad or missing proc or what?-Shop Problem -.-'

Discussion on Bad or missing proc or what?-Shop Problem -.-' within the Shaiya Private Server forum part of the Shaiya category.

Reply
Page 1 of 2 1 2
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Bad or missing proc or what?-Shop Problem -.-'

Please help me with item mall.
I cant buy nothing in my shop , buceuse after relog items is gone. And with more items like 1 have DC QQ


MSDTC is run and auto

Code:
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
	EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
	exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
	exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'
END

exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
	exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
	exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'
END
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';


IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
	exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
	exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'
END
exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';
Code:
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
This is not help
QQers19 is offline  
Old   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Aug 2011
Posts: 34
Received Thanks: 9
Can i see your usp_Read_User_CashPoint_UsersMaster?
DarkHost is offline  
Old   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
I dont have it.
QQers19 is offline  
Old   #4
 
killer2p's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2010
Posts: 417
Received Thanks: 159
well thats what your missing
killer2p is offline  
Old   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Can u give me that proc?
QQers19 is offline  
Old   #6
 
elite*gold: 100
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 99
Received Thanks: 220
Please download the files from the folder "C: \ ShaiyaServer \ SERVER \ PSM_Client \ Bin" maybe I can help you
Призрак урана is offline  
Old   #7
 
elite*gold: 100
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 99
Received Thanks: 220
usp_Read_User_CashPoint_UsersMaster

Code:
USE PS_GameData;
GO
set ANSI_NULLS ON
GO
set QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[usp_Read_User_CashPoint_UsersMaster]  
@CashPoint 	int OUTPUT,
@UserUID 	int


AS

SET NOCOUNT ON

SET @CashPoint = 0

SELECT @CashPoint=ISNULL(Point,0) FROM PS_UserData.dbo.Users_Master WHERE UserUID=@UserUID 
IF @CashPoint < 0
BEGIN
	UPDATE PS_UserData.dbo.Users_Master SET Point=0 WHERE UserUID=@UserUID
	SET @CashPoint = 0
END

SET NOCOUNT OFF
Призрак урана is offline  
Thanks
1 User
Old   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Ok thanks Now AP work
Items in inventory after relog still disappear
QQers19 is offline  
Old   #9
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Bump
How do I fix that does not disappear from the inventory?
QQers19 is offline  
Old   #10
 
elite*gold: 100
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 99
Received Thanks: 220
You have an error
Code:
2013-04-10 17:32:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server][COLOR="Red"]Error converting data type int to tinyint.[/COLOR], SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)

2013-04-10 17:32:01 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '2',2,859308110,'ķe$', 60576,1130123583,322, 0.000000,-36894614047325946000.000000,0.000000, '2019-08-00 00:06:07' ,121, 7953753054428622177,1394632039, 0,0,0, NULL,0,NULL,NULL,NULL,'tone',NULL,'0,108,50,84,0,2 55 (Option','2026-00-00 00:00:07'
Error converting data type int to tinyint.
Призрак урана is offline  
Old   #11
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
And how fix it?
This proc not help me:
Code:
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
QQers19 is offline  
Old   #12
 
killer2p's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2010
Posts: 417
Received Thanks: 159
try this
Code:
USE [PS_GameDefs]
GO

/****** Object:  Table [dbo].[ProductList]    Script Date: 04/18/2013 09:18:28 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ProductList]') AND type in (N'U'))
DROP TABLE [dbo].[ProductList]
GO

USE [PS_GameDefs]
GO

/****** Object:  Table [dbo].[ProductList]    Script Date: 04/18/2013 09:18:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ProductList](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[ProductName] [varchar](50) NOT NULL,
	[ProductCode] [varchar](20) NOT NULL,
	[BuyCost] [int] NOT NULL,
	[ItemID1] [int] NOT NULL,
	[ItemCount1] [tinyint] NOT NULL,
	[ItemID2] [int] NULL,
	[ItemCount2] [tinyint] NULL,
	[ItemID3] [int] NULL,
	[ItemCount3] [tinyint] NULL,
	[ItemID4] [int] NULL,
	[ItemCount4] [tinyint] NULL,
	[ItemID5] [int] NULL,
	[ItemCount5] [tinyint] NULL,
	[ItemID6] [int] NULL,
	[ItemCount6] [tinyint] NULL,
	[ItemID7] [int] NULL,
	[ItemCount7] [tinyint] NULL,
	[ItemID8] [int] NULL,
	[ItemCount8] [tinyint] NULL,
	[ItemID9] [int] NULL,
	[ItemCount9] [tinyint] NULL,
	[ItemID10] [int] NULL,
	[ItemCount10] [tinyint] NULL,
	[ItemID11] [int] NULL,
	[ItemCount11] [tinyint] NULL,
	[ItemID12] [int] NULL,
	[ItemCount12] [tinyint] NULL,
	[ItemID13] [int] NULL,
	[ItemCount13] [tinyint] NULL,
	[ItemID14] [int] NULL,
	[ItemCount14] [tinyint] NULL,
	[ItemID15] [int] NULL,
	[ItemCount15] [tinyint] NULL,
	[ItemID16] [int] NULL,
	[ItemCount16] [tinyint] NULL,
	[ItemID17] [int] NULL,
	[ItemCount17] [tinyint] NULL,
	[ItemID18] [int] NULL,
	[ItemCount18] [tinyint] NULL,
	[ItemID19] [int] NULL,
	[ItemCount19] [tinyint] NULL,
	[ItemID20] [int] NULL,
	[ItemCount20] [tinyint] NULL,
	[ItemID21] [int] NULL,
	[ItemCount21] [tinyint] NULL,
	[ItemID22] [int] NULL,
	[ItemCount22] [tinyint] NULL,
	[ItemID23] [int] NULL,
	[ItemCount23] [tinyint] NULL,
	[ItemID24] [int] NULL,
	[ItemCount24] [tinyint] NULL,
 CONSTRAINT [PK_ProductList] PRIMARY KEY CLUSTERED 
(
	[ProductCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
killer2p is offline  
Thanks
1 User
Old   #13
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Still disappear
News logs
QQers19 is offline  
Old   #14
 
killer2p's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2010
Posts: 417
Received Thanks: 159
240803841010196230000000000000000000000.000000 search that in your database possibly it is a number out of range
killer2p is offline  
Old   #15
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
Can i ask-where i must search this?
QQers19 is offline  
Reply
Page 1 of 2 1 2

« [Shaiya] MobsItems Mobs SQL Management Studio | Shaiya game language issue !!! »

Similar Threads Similar Threads
[INFO]About missing msvcr100.dll / msvcp100.dll and other missing dll files
08/22/2017 - S4 League Hacks, Bots, Cheats & Exploits - 106 Replies
English Maybe if you wanna start a hack from Elitepvpers you will get this Error: or a similar message This dll files are for programs written in C/C++ with Visual Studio To fix this problem you need to download the Microsoft Visual C++ 2010 Redistributable Package (x86) from here: Download Microsoft Visual C++ 2010 Redistributable Package (x86) from Official Microsoft Download Center If you have a 64-Bit System you also need the Microsoft Visual C++ 2010 Redistributable Package...
Map Missing / Problem
03/25/2011 - Counter-Strike - 10 Replies
Hallo, ich habe Css neu installiert und alles funkte dann hab ich es updatet und dann hat der ja nur wieder die standartmaps wie dedust2 und csitaly usw.... so jetzt joine ich einem server mit der map z.b. poolparty ... aim.... oder sonstiges
Missing new costumes seller in new costume Shop, 1.9?
07/11/2010 - Aion Private Server - 0 Replies
Sooooooooooooooo, the npc isn't there. Is it somewhere else? Or is it not in there at all?



All times are GMT +2. The time now is 19:08.

elitepvpers - play less, get more - Top

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

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