DP/AP to NPC Problem

01/26/2019 23:28 [GameAdvisor]Finn#1

Hi Epvp! i hope anyone can help me on my problem about ap to npc problem!
because my ap to npc got delay send when the server got active pvp's like event pvp!
i use procedure method last time and its work but when pvp is active like i said .. its not effect when we sale the ap to npc and ap will send few hours!
i try trigger method too and same.. its work but got delay too.. anyone can help me? how to fix this? thank you in advance!..

This is my ActionLog

Spoiler

01/27/2019 11:39 [ADM]Beno�#2

Try this Click Item to get DP !

[Only registered and activated users can see links. Click Here To Register...]

Spoiler

Credits : [Dev]Hoax

01/27/2019 13:22 [GameAdvisor]Finn#3

Quote:

Originally Posted by [ADM]Beno�

Try this Click Item to get DP !

[Only registered and activated users can see links. Click Here To Register...]

Spoiler

USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 28.12.2013 02:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008-6-7 18:32:40 ******/
/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008/3/15 ?? 05:16:53 ******/

CREATE Proc [dbo].[usp_Insert_Action_Log_E]

@UserID varchar(18), @[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime datetime,
@ActionType tinyint, @[Only registered and activated users can see links. Click Here To Register...] bigint = null, @[Only registered and activated users can see links. Click Here To Register...] int = null, @[Only registered and activated users can see links. Click Here To Register...]3 int = null, @[Only registered and activated users can see links. Click Here To Register...]4 bigint = null, @[Only registered and activated users can see links. Click Here To Register...]5 int = null, @[Only registered and activated users can see links. Click Here To Register...]6 int = null, @[Only registered and activated users can see links. Click Here To Register...]7 int = null, @[Only registered and activated users can see links. Click Here To Register...]8 int = null, @[Only registered and activated users can see links. Click Here To Register...]9 int = null, @[Only registered and activated users can see links. Click Here To Register...]0 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '', @[Only registered and activated users can see links. Click Here To Register...] varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS

/*
usp_Insert_Action_Log_E_v2.sql RELEASE: 2011-07-14

Scripted by [Dev]HoaX
Made for: ShaiyaAlliance / Shaiya-Reloaded / Shaiya-SyFy / Elitepvpers
*/

DECLARE
@AT int, @ItemID int
SET @ItemID = @[Only registered and activated users can see links. Click Here To Register...]

-- ActionType: 114 = Get AP by Selling Item to NPC
-- ActionType: 112 = Get AP by using it
SET @AT = 112

-- -----------------------------------------
IF ( @ActionType = @AT )
BEGIN

-- 25 AP Card

IF (@ItemID = 25219)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 25)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

-- 100 AP Card

IF (@ItemID = 25042)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 100)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

-- 1000 AP Card

IF (@ItemID = 44129)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 1000)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

End
-- -----------------------------------------

SET @[Only registered and activated users can see links. Click Here To Register...] = 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, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @[Only registered and activated users can see links. Click Here To Register...]ID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, @[Only registered and activated users can see links. Click Here To Register...] bigint, @[Only registered and activated users can see links. Click Here To Register...] int, @[Only registered and activated users can see links. Click Here To Register...]3 int, @[Only registered and activated users can see links. Click Here To Register...]4 bigint, @[Only registered and activated users can see links. Click Here To Register...]5 int, @[Only registered and activated users can see links. Click Here To Register...]6 int, @[Only registered and activated users can see links. Click Here To Register...]7 int, @[Only registered and activated users can see links. Click Here To Register...]8 int, @[Only registered and activated users can see links. Click Here To Register...]9 int, @[Only registered and activated users can see links. Click Here To Register...]0 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4

Credits : [Dev]Hoax

that i use now but dp to npc method.. and i got delay dp on my account when pvp event is active.. i don't know why..

01/27/2019 13:51 [ADM]Acid#4

Might be that your actionlog just overloads and the database can't respond so fast by that.. I wonder whats your CPU workload in % while this problem appears?
Maybe just try to make a backup when the problem appears, and clean the logs then to ease your SQL, and see if the problem solves by that. (Anyway, just a guess of mine)

01/27/2019 16:16 [DEV]Elessar#5

You can try using a trigger!

Spoiler

01/27/2019 16:50 {Skrillex}#6

As Acid already told: your ActionLog is overloaded.
The best way to do is makeing with Assembly.

01/27/2019 23:03 Munat#7

you can try to somthing like nubness used to his admin panel most action type are not Records

Quote:

For having a more functional log system, and decreasing log processing time, I have changed the PS_GameLog database, by spreading the information in multiple tables and not recording the so called junk logs, which are useless. From now on, your logs will only contain useful information.

[Only registered and activated users can see links. Click Here To Register...]

01/28/2019 03:21 [GameAdvisor]Finn#8

Quote:

Originally Posted by [ADM]Beno™

Try this Click Item to get DP !

[Only registered and activated users can see links. Click Here To Register...]

Spoiler

USE [PS_GameLog]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_Action_Log_E] Script Date: 28.12.2013 02:15:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008-6-7 18:32:40 ******/
/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E Script Date: 2008/3/15 ?? 05:16:53 ******/

CREATE Proc [dbo].[usp_Insert_Action_Log_E]

@UserID varchar(18), @[Only registered and activated users can see links. Click Here To Register...]ID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime datetime,
@ActionType tinyint, @[Only registered and activated users can see links. Click Here To Register...] bigint = null, @[Only registered and activated users can see links. Click Here To Register...] int = null, @[Only registered and activated users can see links. Click Here To Register...]3 int = null, @[Only registered and activated users can see links. Click Here To Register...]4 bigint = null, @[Only registered and activated users can see links. Click Here To Register...]5 int = null, @[Only registered and activated users can see links. Click Here To Register...]6 int = null, @[Only registered and activated users can see links. Click Here To Register...]7 int = null, @[Only registered and activated users can see links. Click Here To Register...]8 int = null, @[Only registered and activated users can see links. Click Here To Register...]9 int = null, @[Only registered and activated users can see links. Click Here To Register...]0 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '', @[Only registered and activated users can see links. Click Here To Register...] varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS

/*
usp_Insert_Action_Log_E_v2.sql RELEASE: 2011-07-14

Scripted by [Dev]HoaX
Made for: ShaiyaAlliance / Shaiya-Reloaded / Shaiya-SyFy / Elitepvpers
*/

DECLARE
@AT int, @ItemID int
SET @ItemID = @[Only registered and activated users can see links. Click Here To Register...]

-- ActionType: 114 = Get AP by Selling Item to NPC
-- ActionType: 112 = Get AP by using it
SET @AT = 112

-- -----------------------------------------
IF ( @ActionType = @AT )
BEGIN

-- 25 AP Card

IF (@ItemID = 25219)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 25)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

-- 100 AP Card

IF (@ItemID = 25042)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 100)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

-- 1000 AP Card

IF (@ItemID = 44129)
BEGIN

UPDATE PS_UserData.dbo.Users_Master
SET Point = (Point + @[Only registered and activated users can see links. Click Here To Register...]4 * 1000)
WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

END

End
-- -----------------------------------------

SET @[Only registered and activated users can see links. Click Here To Register...] = 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, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql,
N'@UserID varchar(18), @[Only registered and activated users can see links. Click Here To Register...]ID int, @CharID int, @CharName varchar(50),
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, @[Only registered and activated users can see links. Click Here To Register...] bigint, @[Only registered and activated users can see links. Click Here To Register...] int, @[Only registered and activated users can see links. Click Here To Register...]3 int, @[Only registered and activated users can see links. Click Here To Register...]4 bigint, @[Only registered and activated users can see links. Click Here To Register...]5 int, @[Only registered and activated users can see links. Click Here To Register...]6 int, @[Only registered and activated users can see links. Click Here To Register...]7 int, @[Only registered and activated users can see links. Click Here To Register...]8 int, @[Only registered and activated users can see links. Click Here To Register...]9 int, @[Only registered and activated users can see links. Click Here To Register...]0 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @[Only registered and activated users can see links. Click Here To Register...]ID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...], @[Only registered and activated users can see links. Click Here To Register...]3, @[Only registered and activated users can see links. Click Here To Register...]4, @[Only registered and activated users can see links. Click Here To Register...]5, @[Only registered and activated users can see links. Click Here To Register...]6, @[Only registered and activated users can see links. Click Here To Register...]7, @[Only registered and activated users can see links. Click Here To Register...]8, @[Only registered and activated users can see links. Click Here To Register...]9, @[Only registered and activated users can see links. Click Here To Register...]0, @Text1, @Text2, @Text3, @Text4

Credits : [Dev]Hoax

Quote:

Originally Posted by Munat

you can try to somthing like nubness used to his admin panel most action type are not Records [Only registered and activated users can see links. Click Here To Register...]

Thanks its not delay now but actionlog not recording..