Auto apply skills at login

[player1up]

I've noticed that there are some p-servers that do the auto skill thing for conti's and such. I couldn't find the script to do it, so I modified the database stored procedure that reads the applied skills.

( usp_Read_Char_ApplySkills_R )

psudo code ( what the code does in laymans terms ):

1. Applies skills during toon login when the skills for the toon are read by the login procedure.
a. Checks to see if the skill is already applied.
b. if skill is applied, reset the timer to full term.
c. if skill is not applied, add it.
2. Returns the applied skills ( including ones we just added ) to the client


Comments at the begining of the section describe what is being added. If your skill table is different than mine,
you will need to adjust the skillid's to match what is in YOUR database table.

I've also included some stored procedures to read drops.
ShowGrade -- shows all items of a grade that you specify
Usage: exec ShowGrade 50
ShowDropsByMobName -- shows the grade, itemname, mobname,mobid, and droprate with a mob name that you specify
Usage: exec ShowDropsByMobName 'lumen' -- shows drops for mobname that is EXACTLY 'lumen'
or ShowDropsByMobName '%boar%' -- shows drops for mobname that has 'boar' anywhere in the mobname
or ShowDropsByMobName '******%' -- shows drops for mobname that starts with '******'
ShowDropsByGrade -- shows the grade, itemname, mobname,mobid, and droprate with an item name that you specify
Usage: similar to ShowDropsByMobName

In addition to being able to quickly search drops directly from the DB, the stored procs can be referenced from a website to provide a searchable drop list.

Happy gaming!
--player1up

[admin_lewis]

Can you build script only for new players what makes characters and get all of those 30 days without recharge time plz

[momocruz]

Originally Posted by admin_lewis

Can you build script only for new players what makes characters and get all of those 30 days without recharge time plz

Use change stat point per level for Hard Mode do like if was Ultimate and use script like this and all your toon are HM and no need Rez rune and when die get all HP MP SP

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 05/19/2012 18:11:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Hard MODE lvl 1
BEGIN
SET @Grow = 2
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- Hard Mode lvl 30
BEGIN
SET @Grow = 2
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Hard mode lvl 60
BEGIN
SET @Grow = 2
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 2 -- Hard mode lvl 90 or what you want
BEGIN
SET @Grow = 2
SET @Level = 90
SET @StatPoint = 810
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END

BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF

Just use Brain.EXE and Search Butom

[italo.sanchez]

Insert after SET @CharID = IDENT_CURRENT ('Chars')
on stored procedure usp_Create_Char_R

 Spoiler

INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,286,3,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,227,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,233,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,225,1,2592000)

[italo.sanchez]

usp_Read_Char_ApplySkills_R

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Read_Char_ApplySkills_R] Script Date: 02/25/2015 23:26:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Read_Char_ApplySkills_R]

@CharID int

AS

SET NOCOUNT ON

---Ress 30 Dias
if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=286 and skilllevel=3)
begin
update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=286
end
if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=286)
begin
insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime)
Values (@CharID, 286,3,2592000)
end


---Resist endurance 30 days
if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=225 and skilllevel=1)
begin
update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=225
end
if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=225)
begin
insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime)
Values (@CharID, 225,1,2592000)
end

---Red Phoenx amulet 30 days
if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=233 and skilllevel=1)
begin
update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=233
end
if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=233)
begin
insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime)
Values (@CharID, 233,1,2592000)
end

---Prevent Item Drop 30 days
if exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=227 and skilllevel=1)
begin
update charapplyskills set LeftResettime=2592000 where CharID=@charID and skillid=227
end
if not exists ( select skillID from charapplyskills with (nolock) where charID=@CHARID and skillid=227)
begin
insert into CharApplySkills (CharID, SkillID, SkillLevel,LeftResetTime)
Values (@CharID, 227,1,2592000)
end

SELECT SkillID,SkillLevel,LeftResetTime FROM CharApplySkills WHERE CharID=@CharID

SET NOCOUNT OFF

[admin_lewis]

Originally Posted by italo.sanchez

Insert after SET @CharID = IDENT_CURRENT ('Chars')
on stored procedure usp_Create_Char_R

 Spoiler

INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,286,3,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,227,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,233,1,2592000)
INSERT INTO dbo.CharApplySkills (CharID,SkillID,SkillLevel,LeftResetTime) VALUES (@CharID,225,1,2592000)

thanks much

[Cansas59]

how can i removed this?

[Mark.Teal1982]

Originally Posted by Cansas59

how can i removed this?

just go into the stored procedure usp_Create_Char_R in the database and remove the code that was posted above if you wanted to remove it

Originally Posted by momocruz

Use change stat point per level for Hard Mode do like if was Ultimate and use script like this and all your toon are HM and no need Rez rune and when die get all HP MP SP

 Spoiler

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R] Script Date: 05/19/2012 18:11:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R 스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,


/* 여기까지 인자값 주어져야 함 */

/* SP 내부 참조용 변수 */

@CharID int = 0,
@NameCnt tinyint = 0

AS

SET NOCOUNT ON

DECLARE @Ret int
IF @Grow = 0 -- Hard MODE lvl 1
BEGIN
SET @Grow = 2
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 28
END
ELSE IF @Job = 1
BEGIN
SET @rec = 26
END
ELSE IF @Job = 2
BEGIN
SET @dex = 33
END
ELSE IF @Job = 3
BEGIN
SET @luc = 27
END
ELSE IF @job = 4
BEGIN
SET @int = 29
END
ELSE IF @job = 5
BEGIN
SET @wis = 28
END

END

ELSE IF @Grow = 1 -- Hard Mode lvl 30
BEGIN
SET @Grow = 2
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 43
END
ELSE IF @Job = 1
BEGIN
SET @rec = 41
END
ELSE IF @Job = 2
BEGIN
SET @dex = 48
END
ELSE IF @Job = 3
BEGIN
SET @luc = 42
END
ELSE IF @job = 4
BEGIN
SET @int = 44
END
ELSE IF @job = 5
BEGIN
SET @wis = 43
END

END

ELSE IF @Grow = 2 -- Hard mode lvl 60
BEGIN
SET @Grow = 2
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END


END


ELSE IF @Grow = 2 -- Hard mode lvl 90 or what you want
BEGIN
SET @Grow = 2
SET @Level = 90
SET @StatPoint = 810
SET @SkillPoint = 9999
SET @money = 2000000

IF @Job = 0
BEGIN
SET @Str = 73
END
ELSE IF @Job = 1
BEGIN
SET @rec = 71
END
ELSE IF @Job = 2
BEGIN
SET @dex = 78
END
ELSE IF @Job = 3
BEGIN
SET @luc = 72
END
ELSE IF @job = 4
BEGIN
SET @int = 74
END
ELSE IF @job = 5
BEGIN
SET @wis = 73
END
END
SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
RETURN -2
END
ELSE
BEGIN
IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
BEGIN
RETURN -2
END

BEGIN TRANSACTION

INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, Sex, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)

VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @Sex, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)

IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END

SET @CharID = IDENT_CURRENT('Chars')
END

RETURN @CharID

SET NOCOUNT OFF

Just use Brain.EXE and Search Butom

the idea of that is good but comes with problems because you would have to also go in and edit all the gears, weapons, accessories, mounts and skills that only UMs can use and HMs don't have access to in turn I think it would be more work as to just writing a script for it