Auto apply skills at login

04/19/2012 19:51 player1up#1

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 'Bloody%' -- shows drops for mobname that starts with 'Bloody'
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

02/25/2015 10:14 admin_lewis#2

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

02/25/2015 12:40 momocruz#3

Quote:

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

Just use Brain.EXE and Search Butom

02/25/2015 19:07 italo.sanchez#4

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

Spoiler

02/27/2015 15:15 italo.sanchez#5

usp_Read_Char_ApplySkills_R

Spoiler

03/01/2015 11:49 admin_lewis#6

Quote:

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

04/25/2015 14:51 Cansas59#7

how can i removed this?

05/11/2015 06:42 Mark.Teal1982#8

Quote:

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

Quote:

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