Add column in RanGame1 >Chainfo
Column name "ChaKill" bigint not null
then execute this on ranlog
then create your custom ranking php script which will count values in chakill column
Column name "ChaKill" bigint not null
then execute this on ranlog
- Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_LogAction_Insert]
@nChaNum int,
@nType int,
@nTargetNum int,
@nTargetType int,
@nExpPoint money,
@nBrightPoint int,
@nLifePoint int,
@nMoney money
AS
SET NOCOUNT ON
IF (@nType=2)
BEGIN
Update RanGame1.dbo.ChaInfo
Set ChaKill=ChaKill+1
Where ChaNum=@nChaNum
END
INSERT INTO LogAction (ChaNum, Type, TargetNum, TargetType, ExpPoint, BrightPoint, LifePoint, ActionMoney)
VALUES (@nChaNum, @nType, @nTargetNum, @nTargetType, @nExpPoint, @nBrightPoint, @nLifePoint, @nMoney)
SET NOCOUNT OFF
then create your custom ranking php script which will count values in chakill column