Search Rebirth script

[NoLand]

Hay :)
English:
have 1 player Rebirth script for me ? o:

if so I would be very grateful

German:

hat einer ein Rebirth script für mich ? o:

wenn ja wäre ich sehr dankbar

[MentaL]

[Bakey]

How does it work? I can probably make it.

[NoLand]

when you are for example lvl 140 can you let the staff reset your lvl to 1 then you have 0 exp then you become 30 stat points as bonus (example) or any item

sry for my english not so good

thx bakey for your answer

[Bakey]

USE World00_Character

DECLARE @name varchar(50)
DECLARE @requiredLevel int
DECLARE @level int

SET @name = 'Char'
SET @requiredLevel = 140

IF NOT EXISTS(Select sID FROM tCharacter WHERE sID = @name) --Check character exsists
	BEGIN
		SELECT "result" ='character "' + @name + '" does not exist' --If not then return error
	END
ELSE
	BEGIN
		SELECT @level = nLevel from tCharacter where sID = @name	--Else get character level
		
		IF @level = @requiredLevel --If level is the required level then reset level, exp and give points
			BEGIN
				UPDATE tCharacter SET nLevel = 1, nExp = 0, nRedistributePoint = nRedistributePoint + 30 where sID = @name
			END
		ELSE
			BEGIN
				SELECT "result" = @name + ' is not level 140'	--Else return error
			END
	END

[NoLand]

Thx Bakey you're the best and nice man ever °-°

Can you script in php ? O:

[xWhiteCore]

Thx Bakey you're the best and nice man ever °-°

Can you script in php ? O:

German..
Geh bakey nicht am sack man...

English...
don't annoy bakey

[Flash1369]

-annoys bakey-

[NoLand]

German..
Geh bakey nicht am sack man...

English...
don't annoy bakey

ich habe nur gefragt ob er machen kann du pisser er kann ja auch nein sagen -.-
das würde mich nicht stören da er mir so schon geholfen hat !

[xWhiteCore]

Deutsch...
Du weißt das die mods auch deutsch können.. pass auf was du hier sagst.. wenn du den
falschen erwischt haste auf einmal einen hack Angriff am arsch

English...
You know that the mods can also German .. be careful what you say here .. If you are the
wrong you've caught on to even a hack attack ass

PS: wurde gemeldet.. (has been reported ..)

You must speak english.. !!!! or convert it also to english

[NoLand]

ist doch egal dein comi ist unnötig es ist help thema für fragen und hilfe und ich habe nur um hilfe gefragt !

du kommst mit scheiß comi !

[xWhiteCore]

Deutsch:
^^ mach nur weiter so.. lass noch paar beleidigungen springen...
wirst schon sehen was du davon hast. ^^

English:
^^ Do just keep it up .. let go yet few insults ...
ll see what you get out of it. ^^

-annoys bakey-

Thank you for improving me

[munozvo5]

the script is missing a few things
For starters the way rebirth works is it changes ur class to the next one
For example if you want 2 rebirths in your server ur players can not do level 60 and 100 jobchange.
You have to set up the 2 jobchange classes so that the stats continue at level 1

For example as a mage you would be able to reach level 140 (if thats the cap) as a wizmage
Once you reach level 140 the rebirth script must change the class of the person to the next one (Enchanter) and set the level to 1. You must change the class files so that the stats from wizmage continue on the enchanter class at level 1. Then do the same when the person moves on to the next rebirth at level 140 Enchanter. The stats from 140 enchanter must continue at level 1 warlock/wizard. You can not do rebirth from warlock to wizard (or wizard to warlock) because a wizard can not equip warlock items and vise versa.

YOU HAVE to edit the class files, its not just a simple script that adds stat points thru sql, it wont work correctly

[xWhiteCore]

@munozvo5

thank you for this note