Mysteryskill store procedure

[DrOr-CoOl]

guys, can somone show me how the trigers should look like..
ive already try but it dont work

[MentaL]

[GallantS]

what do you mean?

[DrOr-CoOl]

I mean when you get the mystery skill at 81 it should lvl up automaticly each level you reach, but it doesnt.
so i was thinking about making it with sql store procedure.
i made one but it doesnt work

USE [kal_db]
GO
/****** Object:  StoredProcedure [dbo].[MysteryAutoLevel]    Script Date: 15/10/2015 23:13:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[MysteryAutoLevel]

@PLevel int,
@slvl tinyint,
 @Skill tinyint

AS

SET @slvl = (SELECT [Level] FROM Skill WHERE [Level] = @slvl)
SET @PLevel = (SELECT [Level] FROM [Player] WHERE [PID] = @PLevel)
SET @Skill = (SELECT [Index] FROM [Skill] WHERE [Index] = @PLevel)

IF (@PLevel = 82) And ( @Skill =86) And ( @slvl =1)
begin
--do a special thing, like make bound
UPDATE [Skill] SET [Level] = 2 
end

thats one for eva mystery skill for level 82

[GallantS]

Ahhh , mystery skills at shinra dll has only one grade and ungradeable

[DrOr-CoOl]

yea thats why i trying to make it with sql

[GallantS]

I dont think that will work

[TranX1337]

Right that wont work

[DrOr-CoOl]

ok guys thanks..
got any way to make the mystery skills auto leveling?

[lafreak]

Hook CPlayer::LevelUp

[DrOr-CoOl]

Hook CPlayer::LevelUp

yea thats what my coder started to do now after i gave up the store procedure

[Kallyanna]

I've been working hard on this but if you're REALLY into this .. then .. the hook @lafreak was talking about is this...

static int(__thiscall *Levelup) (void *PlayerPtr) = (int(__thiscall *Levelup) (void *PlayerPtr))0x0045CC00;