- Joined
- Jun 14, 2008
- Messages
- 15
- Reaction score
- 0
hi guys,im really new to this RAN server. i made mine by following the instructions on this forum...but my biggest problem is, when my players relog, they get the same remaining stats, even if they already pumped it up...now, my server is a bit imbalanced due the overpumped stats of my players caused by this bug...pls help me...here is the script that i used:
USE [RanGame1]
GO
/****** Object: Trigger [dbo].[NewChar_Level] Script Date: 06/26/2008 18:15:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================== ====
-- Author: IaNz
-- Create date: --,--,--
-- Description: Starting Character Level,Skill and Stat Points
-- Dex,Pow,Int,Vit,Stm and Money
-- Note : If you have existing trigger replace CREATE TRIGGER
-- to ALTER TRIGGER
-- ================================================== ====
CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN
Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaSkillPoint=1000
From Inserted
Where Inserted.ChaSkillPoint = 1000 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaStRemain=10000
From Inserted
Where Inserted.ChaStRemain = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaMoney=100000000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
END
USE [RanGame1]
GO
/****** Object: Trigger [dbo].[NewChar_Level] Script Date: 06/26/2008 18:15:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ================================================== ====
-- Author: IaNz
-- Create date: --,--,--
-- Description: Starting Character Level,Skill and Stat Points
-- Dex,Pow,Int,Vit,Stm and Money
-- Note : If you have existing trigger replace CREATE TRIGGER
-- to ALTER TRIGGER
-- ================================================== ====
CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN
Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaSkillPoint=1000
From Inserted
Where Inserted.ChaSkillPoint = 1000 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaStRemain=10000
From Inserted
Where Inserted.ChaStRemain = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Update [ChaInfo] set [ChaInfo].ChaMoney=100000000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
END

