[Question]Pre-leveled Characters

[[Dev]Cataclysm]

Originally Posted by viper4513

mhmms, thats the way i work with my SQL shiz, i'm a total newbie at it, with no past experience.. i go at it with a hammer and break everything in everyway i can until i get something to work :P

Thats how i learn xD

and for the button things, i wudnt think it would be a stored procedure but simply just edit the "look" of the button itself, probably look in the "interface" folder in your game files (extracted)

The buttons and graphics I know are a simple fix, but I was referring to modifying the procedure to fit each desired level on the modes (slots)

[[Admin]Snuggle]

I modified usp_Create_Char_R
What I did with it is made Normal mode turn into pre leveled 15 UM, Hard mode as pre leveled 30 UM, and Ultimate mode as pre leveled 60 UM.

Originally Posted by [Dev]Cataclysm

SET @CharName = LTRIM(RTRIM(@CharName))
SET @Level = 60
SET @StatPoint = 531
SET @SkillPoint = 300
SET @Ret = 0

You have part of that right so far except I'm not sure what the use of CharName or Ret would be for this kind of edit. So you might want to move those somewhere else into the SP and not with this part of the edit.

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

That's how I had part of mine set up. That would make the Normal mode select start as 15 UM. Yet you have to do more than this as well. You also have to take into account for the base stats that get increased per level too.
Like this:

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

That is incomplete as I think you should do most the work here. Yet that is how it is set up sorta.
I hope this helps and if you have any other questions about it just ask o.O
(credits go to Abrasive for helping me with this when I first looked into it)

Edit:

Originally Posted by [Dev]Cataclysm

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

Also remove that part with the SET @SkillPoint = 5 or else it will set all that skill points to 5 instead of what you want them to be. (I faced that issue for like five minutes before seeing that lol)

[viper4513]

very nice post there Snuggle, should help people work it out for themselves if thats what they aim to do.

And to be honest, you pretty much gave them all the work right there anyways :P

[[Admin]Snuggle]

Yuh I know lol but there was a lot of points he was missing *shrug*

[[Dev]Cataclysm]

Originally Posted by [Admin]Snuggle

I modified usp_Create_Char_R
What I did with it is made Normal mode turn into pre leveled 15 UM, Hard mode as pre leveled 30 UM, and Ultimate mode as pre leveled 60 UM.




You have part of that right so far except I'm not sure what the use of CharName or Ret would be for this kind of edit. So you might want to move those somewhere else into the SP and not with this part of the edit.

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

That's how I had part of mine set up. That would make the Normal mode select start as 15 UM. Yet you have to do more than this as well. You also have to take into account for the base stats that get increased per level too.
Like this:

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

That is incomplete as I think you should do most the work here. Yet that is how it is set up sorta.
I hope this helps and if you have any other questions about it just ask o.O
(credits go to Abrasive for helping me with this when I first looked into it)

Edit:



Also remove that part with the SET @SkillPoint = 5 or else it will set all that skill points to 5 instead of what you want them to be. (I faced that issue for like five minutes before seeing that lol)

Only thing I added really was the SET @Level = 60 SET @StatPoint = 531 & SET @SkillPoint = 300. The rest was already there. I also don't know what the Ret means, but then comes a question. Even though I have all characters set at level 60 now with their Skill and Stat points, would the base stats +1 per level per job be there? If it isn't then I would assume to kinda do what you did, with adding and setting the Job inside the query. (If that made sense)


But the rest of your partial queries make more then enough sense for me to complete it myself with making sure each Job has the correct stats.

[[Admin]Snuggle]

It's like setting the level of a toon with in game commands. It won't set a thing other than a level unless you add stats, skills, etc
So yes you need to add the base stats per level as well(that is why I added them o.o)

[[Dev]Cataclysm]

Ok cool enough said and def. gonna set that all up, thanks Snuggs :P

[[Admin]Snuggle]

no problem o.o

[[Dev]Cataclysm]

Btw, pieced the rest together in the query and all base job stats are set to where they should be :P

[[Admin]Snuggle]

Yuh that part is pretty easy lol
I even set up custom spawn points for the levels
Like 15 was in 1-15(different spots per faction of course)

[[Dev]Cataclysm]

Yeah I figured out where to change the spawn points for the main toons but adding additional spawn points...would that also be in the map.ini?

[[Admin]Snuggle]

I'm not sure about that. I only added the spawn points per faction in the SP. Haven't messed with the map.ini as of that. :/

[[Dev]Cataclysm]

Hmm well have to check that out then in the SP. See what I can figure out

[[Admin]Snuggle]

So I looked through the map.ini just now...lol was easy to find

HUGameStartMapPos = (1,577.98, 78.56, 1762.12)
ELGameStartMapPos = (1,1678.92, 38.92, 1776.91)
BAGameStartMapPos = (2,165.25, 118.50, 397.89)
DEGameStartMapPos = (2,1838.93, 129.33, 443.43)

Those are the spawn points for toons by default.
You can edit those easily but you can't edit it as of "I want pre leveled 15 here and pre leveled 30 here"
Only "I want humans here and elfs here"
So you are kinda limited with the map.ini compared to the SP.

[[Dev]Cataclysm]

Yeah that is where I first edited the spawn points, but I how I would write it out in the SP I am not too sure yet. But since I know where to place it all I will play around with some queries and see what happens.