[Release]Instant leveling

Page 2 of 3

09/12/2011 16:23 �Tyler�#16

Quote:

Originally Posted by [Admin]Snuggle

It might be because I set all the exp to 0 except for 15 and 30 o.O
Well are you guys who are having the logs fill up...are you letting people level on the server still? If so that is probably why or maybe you are still doing /exp2xenable <exp amount> ?

Yes that would be, since the starting experience is 0 and your experience at level 15 is 0, there is no change needed, I just left mine at default. I guess it would be easy to go either way on this situation.

Tyler

09/26/2011 09:10 Big_#17

i noticed after setn all 4 Mode butons it starts meeen wif stuff also u wil notice that if u only set EM NP HM butons to auto level and set maps and locations u carnt make lvl 1 toons spawn at there normal places i tryed to set EM NM HM for instant lvling and UM for a level up thing but when u make the lvl 1 toons they spawn in randome places in map 1 and not the usual places and if u set places for all 3 butons it messes wif the EM setting duno if every1 getn this bug but yeah kinda made me scratch my head its a grate idea tho

09/26/2011 10:25 viper4513#18

All 4 buttons worked fine for me, EM, NM, HM being my instant levels in custom set places and UM being the lv1 start in normal position.
Make sure you set the map co-ordinates properly for the levels you did. Use WHERE & IF clauses aswell to make things easier for yourself.

10/01/2011 08:58 [Dev]Cataclysm#19

Ok so I tried piecing most of this together, and even played around with it a bit to find the problem, but I am not sure if I am doing this entirely correctly. It just gives me an error:

*Note I am trying to do all levels 15/30/60 in specified maps etc. so the Query is fairly large lol**

Msg 102, Level 15, State 1, Procedure usp_Create_Char_R, Line 237
Incorrect syntax near 'OFF'.

Does that error mean that the last line (where the SET NOCOUNT OFF) message is, mean i need to put something else there or??

10/01/2011 12:51 Xx.LaMin.xX#20

you need alil bit more brain.exe :P anyways here is mine if you want just copy and past and change it. Since snuggle ddint show how to put it together. Have fun with changing and good luck:

Code:

[COLOR="Red"]IF @Grow = 1 -- Normal mode
BEGIN
	SET @Grow = 3
	SET @Level = 15
    SET @StatPoint = 126
    SET @SkillPoint = 75
    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
END
            ELSE IF @Grow = 2 -- Hard Mode
            BEGIN
            SET @Grow = 3
            SET @Level = 30
            SET @StatPoint = 261
            SET @SkillPoint = 150
            SET @Map = 30
IF @Family IN(0,1)
	BEGIN
	 -- set light coords and map
		SET @PosX = 307
		SET @PosY = 2
		SET @PosZ = 314
	END
	ELSE IF @Family IN(2,3)
	BEGIN
	 -- set fury coords and map
		SET @PosX = 813
		SET @PosY = 31
		SET @PosZ = 752
	END[/COLOR]

About the erro you got, it hink you missed some ''end(s)''

10/01/2011 15:09 [Admin]Jet#21

i too am getting the same error as Cata not sure whats causing it

10/01/2011 16:23 [Dev]Cataclysm#22

I kinda added the Jobs in as well so that they had their proper base stat points so in example:

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

IF @Family IN(0,1)
BEGIN
-- set light coords and map
SET @PosX = 165
SET @PosY = 21
SET @PosZ = 150
END
ELSE IF @Family IN(2,3)
BEGIN
-- set fury coords and map
SET @PosX = 761
SET @PosY = 2
SET @PosZ = 865
END

IF @Job = 0
BEGIN
SET @Str = 30
END
ELSE IF @Job = 1
BEGIN
SET @rec = 30
END
ELSE IF @Job = 2
BEGIN
SET @dex = 30
END
ELSE IF @Job = 3
BEGIN
SET @luc = 30
END
ELSE IF @Job = 4
BEGIN
SET @int = 30
END
ELSE IF @Job = 5
BEGIN
SET @wis = 30
END

I then did that for the HM and the UM set up a bit different, but I will try rearranging it some more to see if it works :P I

Brain.exe can be sometimes slow at 4am lol

10/01/2011 16:26 Xx.LaMin.xX#23

I dont think this will work, becouse when you create a char it will only effect the first query This one

Quote:

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

You have to write all of them together to make it work for each mode. im not sure but that is my guess like 90%.

10/01/2011 16:31 [Dev]Cataclysm#24

Ah ok so then they might conflict, so best idea would be to scrap the "Job" portion and place a stat reset in their inventory when making a new character?

10/01/2011 16:38 [Admin]Snuggle#25

I didn't piece it all together on purpose :/

Code:

IF @Grow = 1 -- normal mode
BEGIN
	SET @Grow = 3
	SET @Level = 15
	SET @StatPoint = 126
	SET @SkillPoint = 70
	SET @Map = 18
	
	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
	
	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
END

That's my part that I have in for 15. So if you have issues look at that o.O
It's the same thing for 30 and 60 except for the different stats and start location.

Quote:

Originally Posted by [Dev]Cataclysm

Ah ok so then they might conflict, so best idea would be to scrap the "Job" portion and place a stat reset in their inventory when making a new character?

You can do that if you want but it is not needed if this is done right o.o

10/01/2011 16:44 [Dev]Cataclysm#26

Ok well I think I know where the main part of my problem is then. The UM portion has an entire different setup, it doesn't have the Map location as I have changed that part in the Map.ini and not included it in the query, as I had first initially set the query only to accomdate all new characters on UM to be set intstantly to 60 and placed inside the Bootleggery.

I will erase that portion and use the same setup as the 15/30 parts.

10/18/2011 01:34 [ADMIN]Cryptic#27

Hmmm I been playing with this.

I put the code below, but no matter what mode I choose the character starts at lvl 70 lol what did I put in wrong?

PHP Code:


			
 SET @CharName = LTRIM(RTRIM(@CharName))
SET @Ret = 0



IF @Grow = 0 -- Easy mode
BEGIN
    SET @Grow = 3
    SET @Level = 15
    SET @StatPoint = 126
    SET @SkillPoint = 70
    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

IF @Grow = 1 -- normal mode
BEGIN
    SET @Grow = 3
    SET @Level = 30
    SET @StatPoint = 261
    SET @SkillPoint = 150
    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

IF @Grow = 2 -- Hard mode
BEGIN
    SET @Grow = 3
    SET @Level = 60
    SET @StatPoint = 531
    SET @SkillPoint = 300
    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


IF @Grow = 3 -- Ultimate mode
BEGIN
    SET @Grow = 3
    SET @Level = 70
    SET @StatPoint = 621
    SET @SkillPoint = 350
    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

10/18/2011 02:10 �Tyler�#28

Quote:

Originally Posted by [ADMIN]Cryptic

Hmmm I been playing with this.

I put the code below, but no matter what mode I choose the character starts at lvl 70 lol what did I put in wrong?

PHP Code:

SET @CharName = LTRIM(RTRIM(@CharName)) SET @Ret = 0 IF @Grow = 0 -- Easy mode BEGIN SET @Grow = 3 SET @Level = 15 IF @Grow = 1 -- normal mode BEGIN SET @Grow = 3 SET @Level = 30 IF @Grow = 2 -- Hard mode BEGIN SET @Grow = 3 SET @Level = 60 IF @Grow = 3 -- Ultimate mode BEGIN SET @Grow = 3 SET @Level = 70

If this is what you have in your script, then this isn't your problem.

Edit: Check if you are making @Edit=3 somewhere above all this.
Post your entire stored procedure.
Tyler

10/18/2011 09:12 Xx.LaMin.xX#29

Cryptic, try to run this and test if this works. I added some Else If

(MAKE SURE THAT YOU MAKE YOURS BACKUP!)

Quote:

IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 126
SET @SkillPoint = 70
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 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 261
SET @SkillPoint = 150
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
BEGIN
SET @Grow = 3
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 300
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 = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
SET @Level = 70
SET @StatPoint = 621
SET @SkillPoint = 350
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

I said before for somehow it take only the last mode >.< when you do seperate . You need to stick together xD.. idk why but that is the only way to make it work

10/18/2011 15:32 [ADMIN]Cryptic#30

sorry forgot to write hehe yeah I did that yesterday. I figured it out myself that I needed else if instead of just if. Cos everyone is UM and the script says that UM should be lvl 70 and etc. So yeah that worked wonders. thanks alot anyway :)

Page 2 of 3