need help fast!

03/30/2012 01:36 dragonxone#1
I Wanna Make Sure That Its Gonna Be 15 , 30 , 90 With Another Set To 1-90 But Need Help With This. as well as to have them all UM Toons :handsdown:
What I Have Atm Is


SET @Grow = 3
SET @Level = 15
SET @StatPoint = 135
SET @SkillPoint = 9999
SET @Map = 42

Correct Me If I'm Wrong If These Others Are Correct


SET @Grow = 3
SET @Level = 30
SET @StatPoint = 270
SET @SkillPoint = 9999
SET @Map = 42

And For Level 90


SET @Grow = 3
SET @Level = 90
SET @StatPoint = 810
SET @SkillPoint = 9999
SET @Map = 42

Just Wanna Make Sure This Is Right..

[Only registered and activated users can see links. Click Here To Register...]
03/30/2012 05:22 JohnHeatz#2
My only question would be why are you giving that many skill points? ;)

But it seems fine, hopefully you have changed the level cap on your game.exe though
03/30/2012 06:40 dirksen95#3
John, its PvP server so i think he wanna, that we can learn every skill there ^^ could be he don't find out, hot to change the needed skill points for each skill or just been to lazy to do this and edited the skill points^^
03/30/2012 18:12 dragonxone#4
Quote:
Originally Posted by JohnHeatz View Post
My only question would be why are you giving that many skill points? ;)

But it seems fine, hopefully you have changed the level cap on your game.exe though
yeah the level cap is already 90 :)

ok i tryed that but now i got this error i also tryied this and got the same error again
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 89
Must declare the scalar variable "@dex".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 93
Must declare the scalar variable "@luc".
Msg 137, Level 15, State 2, Line 95
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 97
Must declare the scalar variable "@int".
Msg 137, Level 15, State 2, Line 99
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 101
Must declare the scalar variable "@wis".
Msg 137, Level 15, State 2, Line 108
Must declare the scalar variable "@Grow".
Msg 137, Level 15, State 1, Line 110
Must declare the scalar variable "@Grow".
Msg 137, Level 15, State 1, Line 111
Must declare the scalar variable "@Level".
Msg 137, Level 15, State 1, Line 112
Must declare the scalar variable "@StatPoint".
Msg 137, Level 15, State 1, Line 113
Must declare the scalar variable "@SkillPoint".
Msg 137, Level 15, State 1, Line 114
Must declare the scalar variable "@money".
Msg 137, Level 15, State 2, Line 116
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 118
Must declare the scalar variable "@Str".
Msg 137, Level 15, State 2, Line 120
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 122
Must declare the scalar variable "@rec".
Msg 137, Level 15, State 2, Line 124
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 126
Must declare the scalar variable "@dex".
Msg 137, Level 15, State 2, Line 128
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 130
Must declare the scalar variable "@luc".
Msg 137, Level 15, State 2, Line 132
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 134
Must declare the scalar variable "@int".
Msg 137, Level 15, State 2, Line 136
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 138
Must declare the scalar variable "@wis".



and my new one i tried still had errors :/
IF @Grow = 0 -- Easy mode
BEGIN
SET @Grow = 3
SET @Level = 15
SET @StatPoint = 135
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 -- normal mode
BEGIN
SET @Grow = 3
SET @Level = 30
SET @StatPoint = 270
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
BEGIN
SET @Grow = 3
SET @Level = 90
SET @StatPoint = 630
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 = 3 -- Ultimate mode
BEGIN
SET @Grow = 3
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
04/02/2012 20:55 ·Tyler·#5
Quote:
Originally Posted by dragonxone View Post
yeah the level cap is already 90 :)

ok i tryed that but now i got this error i also tryied this and got the same error again
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 89
Must declare the scalar variable "@dex".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 93
Must declare the scalar variable "@luc".
Msg 137, Level 15, State 2, Line 95
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 97
Must declare the scalar variable "@int".
Msg 137, Level 15, State 2, Line 99
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 101
Must declare the scalar variable "@wis".
Msg 137, Level 15, State 2, Line 108
Must declare the scalar variable "@Grow".
Msg 137, Level 15, State 1, Line 110
Must declare the scalar variable "@Grow".
Msg 137, Level 15, State 1, Line 111
Must declare the scalar variable "@Level".
Msg 137, Level 15, State 1, Line 112
Must declare the scalar variable "@StatPoint".
Msg 137, Level 15, State 1, Line 113
Must declare the scalar variable "@SkillPoint".
Msg 137, Level 15, State 1, Line 114
Must declare the scalar variable "@money".
Msg 137, Level 15, State 2, Line 116
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 118
Must declare the scalar variable "@Str".
Msg 137, Level 15, State 2, Line 120
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 122
Must declare the scalar variable "@rec".
Msg 137, Level 15, State 2, Line 124
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 126
Must declare the scalar variable "@dex".
Msg 137, Level 15, State 2, Line 128
Must declare the scalar variable "@Job".
Msg 137, Level 15, State 1, Line 130
Must declare the scalar variable "@luc".
Msg 137, Level 15, State 2, Line 132
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 134
Must declare the scalar variable "@int".
Msg 137, Level 15, State 2, Line 136
Must declare the scalar variable "@job".
Msg 137, Level 15, State 1, Line 138
Must declare the scalar variable "@wis".
This is literally another repeat of [Only registered and activated users can see links. Click Here To Register...] People are too lazy.

Find your PS_GameData.dbo.usp_Create_Char_R and add that code, you can't just paste it into the new query window and expect fairies to do the work for you. Damn people. :rtfm:

Tyler