|
You last visited: Today at 20:21
Advertisement
[Release]Instant leveling
Discussion on [Release]Instant leveling within the Shaiya PServer Development forum part of the Shaiya Private Server category.
09/12/2011, 16:23
|
#16
|
elite*gold: 0 
Join Date: Apr 2010
Posts: 148
Received Thanks: 171
|
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
|
#17
|
elite*gold: 0
Join Date: Jul 2009
Posts: 380
Received Thanks: 86
|
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
|
#18
|
elite*gold: 0
Join Date: Jul 2009
Posts: 408
Received Thanks: 180
|
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
|
#19
|
elite*gold: 0
Join Date: Aug 2011
Posts: 53
Received Thanks: 23
|
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
|
#20
|
elite*gold: 0
Join Date: Feb 2011
Posts: 214
Received Thanks: 205
|
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
|
#21
|
elite*gold: 0
Join Date: Sep 2011
Posts: 30
Received Thanks: 7
|
i too am getting the same error as Cata not sure whats causing it
|
|
|
|
|
10/01/2011, 16:23
|
#22
|
elite*gold: 0
Join Date: Aug 2011
Posts: 53
Received Thanks: 23
|
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
|
#23
|
elite*gold: 0
Join Date: Feb 2011
Posts: 214
Received Thanks: 205
|
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
|
#24
|
elite*gold: 0
Join Date: Aug 2011
Posts: 53
Received Thanks: 23
|
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
|
#25
|
elite*gold: 0
Join Date: Oct 2009
Posts: 942
Received Thanks: 1,066
|
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
|
#26
|
elite*gold: 0
Join Date: Aug 2011
Posts: 53
Received Thanks: 23
|
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
|
#27
|
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
|
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
|
#28
|
elite*gold: 0
Join Date: Apr 2010
Posts: 148
Received Thanks: 171
|
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
|
#29
|
elite*gold: 0
Join Date: Feb 2011
Posts: 214
Received Thanks: 205
|
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
|
#30
|
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
|
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 
|
|
|
|
Similar Threads
|
[Release] BYM Instant Ressources
08/20/2011 - Facebook - 0 Replies
1. scan 83 C4 10 F3 0F 7E 8D E0 FE FF FF
2. movq xmm1, -> movq xmm1,
3. change add esp,10 -> add esp,33
4. click on your Home button
5. wait for game to save
6. change add esp,33 -> add esp,50
7. speedhack 0.05
8. bank all until empty for a maximum of 3 times
9. change add esp,50 -> add esp,10
10. speedhack 1.00
|
[Release] Leveling NPC
07/13/2010 - CO2 PServer Guides & Releases - 9 Replies
Here's how it goes guys. I made a NPC for leveling 'till L200 (for 2,5kk CPs) and 'till L255 (for 25kk CPs). Here's what you are going to write in NPCDialog.cs:
#region UnknownMan
case 2739:
{
if (Control == 0)
{
GC.AddSend(Packets.NPCSay("Ima gonna level you, bloody bitch!- At least thank Fucky~"));
...
|
All times are GMT +2. The time now is 20:24.
|
|
![[Release]Instant leveling](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-development/release-instant-leveling_ltr.gif){kind=small}
![[Admin]Snuggle's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1811160_4.gif){kind=avatar}
![[ADMIN]Cryptic's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar3857950_1.gif){kind=avatar}
