Newbie Spellweaver
- Joined
- Dec 26, 2008
- Messages
- 74
- Reaction score
- 51
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
Sorry for sharing this someone is making money out of this
"wag nyo sakin ibenta dahil di nyo man lang alam ako ang gumawa"
Credits Iwarez and me
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
Sorry for sharing this someone is making money out of this
"wag nyo sakin ibenta dahil di nyo man lang alam ako ang gumawa"
Credits Iwarez and me
Last edited: