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

Page 1 of 2

04/10/2013 18:51 QQers19#1

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

Spoiler

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

04/10/2013 19:19 DarkHost#2

Can i see your usp_Read_User_CashPoint_UsersMaster?

04/10/2013 19:25 QQers19#3

I dont have it. :(

04/12/2013 19:43 killer2p#4

well thats what your missing

04/14/2013 10:25 QQers19#5

Can u give me that proc?

04/14/2013 12:26 Призрак урана#6

Please download the files from the folder "C: \ ShaiyaServer \ SERVER \ PSM_Client \ Bin" maybe I can help you

04/14/2013 13:04 Призрак урана#7

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

04/14/2013 16:00 QQers19#8

Ok thanks Now AP work
Items in inventory after relog still disappear

04/17/2013 14:01 QQers19#9

Bump
How do I fix that does not disappear from the inventory?

04/17/2013 16:27 Призрак урана#10

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.

04/17/2013 17:52 QQers19#11

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

04/20/2013 03:19 killer2p#12

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

04/20/2013 18:15 QQers19#13

Still disappear
News logs

Spoiler

04/22/2013 05:32 killer2p#14

240803841010196230000000000000000000000.000000 search that in your database possibly it is a number out of range

04/22/2013 16:06 QQers19#15

Can i ask-where i must search this?

Page 1 of 2