PS_GameLog.dbo.usp.Insert_Action_Log_E
select and copy under the following code:
IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END
And Execute the following procedures.
Credits to nubness
select and copy under the following code:
IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END
PHP Code:
ELSE IF @ActionType = 103 -- pvp kill
BEGIN
INSERT INTO Kill_Log VALUES (@UserID, @UserUID, @CharID, @CharName, @Value1, @Text1, @MapID, @PosX, @PosY, @PosZ, @ActionTime)
END
ELSE IF @ActionType = 104 -- pvp death
BEGIN
INSERT INTO Death_Log VALUES (@UserID, @UserUID, @CharID, @CharName, @Value1, @Text1, @MapID, @PosX, @PosY, @PosZ, @ActionTime)
DECLARE @K1 INT = (SELECT COUNT(*) FROM Kill_Log WHERE CharID = @CharID)
DECLARE @K2 INT = (SELECT COUNT(*) FROM Death_Log WHERE CharID = @CharID)
IF (@K2 > 50 AND @K1 * 50 < @K2)
-- if the character died more than 10 times and their kills multiplied by 10 are less than their deaths
BEGIN
-- banning the feeder
UPDATE PS_UserData.dbo.Users_Master
SET Status = -5
WHERE UserUID = @UserUID
-- banning the killer
-- uncomment those lines if you want the killer to get banned (not recommended)
--UPDATE PS_UserData.dbo.Users_Master
--SET Status = -5
--WHERE UserUID = (SELECT TOP 1 UserUID FROM PS_GameData.dbo.Chars WHERE CharID = @Value1)
END
END
PHP Code:
USE [PS_GameLog]
GO
/****** Object: Table [dbo].[Death_Log] Script Date: 6/13/2015 11:26:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Death_Log](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](18) NOT NULL,
[UserUID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[CharName] [nvarchar](50) NOT NULL,
[KillerCharID] [int] NOT NULL,
[KillerCharName] [nvarchar](50) NOT NULL,
[MapID] [tinyint] NOT NULL,
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[ActionTime] [datetime] NOT NULL,
CONSTRAINT [PK_Death_Log] PRIMARY KEY CLUSTERED
(
[RowID] 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
PHP Code:
USE [PS_GameLog]
GO
/****** Object: Table [dbo].[Kill_Log] Script Date: 6/13/2015 11:28:13 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Kill_Log](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[UserID] [varchar](20) NOT NULL,
[UserUID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[CharName] [nvarchar](50) NOT NULL,
[DeadCharID] [int] NOT NULL,
[DeadCharName] [nvarchar](50) NOT NULL,
[MapID] [tinyint] NOT NULL,
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[ActionTime] [datetime] NOT NULL,
CONSTRAINT [PK_Kill_Log] PRIMARY KEY CLUSTERED
(
[RowID] 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
