You can use sql trigger with quest for this.
Add for Chars table or whatever new columin some like this
Code:
USE [PS_GameData]
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.Chars ADD
Rank15 tinyint NOT NULL CONSTRAINT DF_Chars_Rank15 DEFAULT 0
GO
COMMIT
For trigger
if not exist (Select rank15 from Chars where CharID=CharID and rank15='1')
begin
If @
[Only registered and activated users can see links. Click Here To Register...]='15' and k1 = '1'
begin
Update Chars
Set Statpoint=Statpoint+'1',Rank15='1'
where CharID=@CharID
end
end
And if player wish reset stat ad another trigger for reset
Code:
If ActionType='112' and value2='100048'
Begin
update PS-GameData.dbo.chars
Set Rank15='0'
where CharID=@CharID
And after relog player can use bonus stat again
Im not test this but should work