Register for your free account! | Forgot your password?

You last visited: Today at 12:02

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



need help fast!

Discussion on need help fast! within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2011
Posts: 33
Received Thanks: 11
need help fast!

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
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..

dragonxone is offline  
Old 03/30/2012, 05:22   #2
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,977
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
JohnHeatz is offline  
Thanks
1 User
Old 03/30/2012, 06:40   #3
 
elite*gold: 70
Join Date: Feb 2009
Posts: 502
Received Thanks: 88
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^^
dirksen95 is offline  
Old 03/30/2012, 18:12   #4
 
elite*gold: 0
Join Date: Apr 2011
Posts: 33
Received Thanks: 11
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
dragonxone is offline  
Old 04/02/2012, 20:55   #5
 
elite*gold: 0
Join Date: Apr 2010
Posts: 148
Received Thanks: 171
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 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.

Tyler
·Tyler· is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
FAST!FAST!FAST! Biete 25€ PSC Suche e*Gold | gebe first | FAST!FAST!FAST!
10/02/2011 - elite*gold Trading - 1 Replies
^regelt. Sofortkauf 1200e*Gold | offline erworben. Sonst bitte vorschläge per pn oder im Thread. Es wird nicht via treasure gehandelt, von wegen log. Bei trusted leuten gebe ich first. Alles wird gefilmt, versteht sich. rgrds



All times are GMT +2. The time now is 12:02.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.