[Release]Instant leveling

1. First you need to go into the stored procedure usp_Create_Char_R.
   (This is located in PS_GameData for those that do not know)
   
2. Now that you have that open find this line:
   
   Code:

   SET @SkillPoint = 5

3. Remove that first before doing anything else.
   (If this is kept it will mess with the edits. At least for me it did)
   
   Where to add these edits you ask? After these lines:
   
   Code:

   @CharID int = 0,
   @NameCnt tinyint = 0
   
   AS
   
   SET NOCOUNT ON
   
   DECLARE @Ret int

4. Now that we have all that out of the way it's time to start working on the instant leveling:
   
   Code:

   IF @Grow = 1 -- normal mode
   BEGIN
   	SET @Grow = 3
   	SET @Level = 15
   	SET @StatPoint = 126
   	SET @SkillPoint = 70

5. Now this is pretty simple to set up here. You can choose what Grow or level you want. Make sure you set the stat and skill points correctly at whatever level you put in. (If someone applies a reset they will get unedited points)
   
6. You also need to set the base stat points per level:
   (I added this part directly under the above part)
   
   Code:

   IF @Job = 0
   	BEGIN
   		SET @Str = 28
   	END
   	ELSE IF @Job = 1
   	BEGIN
   		SET @rec = 26
   	END

7. This is set up to go with the level above. You will have to do the math on the points they get if you wish to increase/decrease the starting level.

IF @Grow = 1 -- normal mode
BEGIN
	SET @Grow = 3
	SET @Level = 15
	SET @StatPoint = 126
	SET @SkillPoint = 70
	SET @Map = 18

IF @Family IN(0,1)
	BEGIN
	 -- set light coords and map
		SET @PosX = 208
		SET @PosY = 20
		SET @PosZ = 177
	END
	ELSE IF @Family IN(2,3)
	BEGIN
	 -- set fury coords and map
		SET @PosX = 766
		SET @PosY = 3
		SET @PosZ = 825
	END

Quote:

Just one suggestion Snuggle. Can you add SET @Exp = <Level Exp Ammount>

Quote:

IF @Grow = 1 -- normal mode BEGIN SET @Grow = 3 SET @Level = 15 SET @StatPoint = 126 SET @SkillPoint = 70 SET @Exp = 100 (ex. my expdefs have 100 exp on lv15)

Quote:

Originally Posted by [Admin]Snuggle Make sure you always use a test server before applying something to a live server.

Quote:

Originally Posted by viper4513 Also.. on another slightly different note, would you know where to find the "mode" descriptions atall? i havnt had a look around for them yet, i'm guessing they wuld be in the client files somewhere. Would just be nice to have those saying the right things too :)

Quote:

Originally Posted by Xx.LaMin.xX I understand that but they can read what i said on here. I know that everybody dont have same expdefs. Using that @Exp will fix ''error exp min usern=LaMin,charn=LaMin, level=15,exp=0,exppv=100'' See the exp=0 its becouse when you create char , it dont add exp to exp colum. So you need to add 100 exp to @exp = 100. Becouse there is the current exp showing. exppv=100 All you need to do is add the exp from your own exp defs should look like this: If you add that, the exp error wont show up anymore.

Quote:

Originally Posted by ·Tyler· I believe it's in the system-uni.txt file. That file has lots of goods to edit. :) I could be wrong though, I am writing this off memory instead of looking like I should.