[ TUT ] How to change the items when making character.

[rodanio14]

Well sorry for my english im not that good in english:P im 14 but uumm here we go:) this tut is for people that wanna change the items that u have at the beginning when u make a character and choose a class
Open mssql then open database expand GunzDB expand programmibility expand stored procedures search for spInsertchar then right click on it then modify then search for the line its kinda long


INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @MeleeItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @MeleeCIID =@@IDENTITY
/* Primary */
SET @PrimaryItemID =CASE @Costume
WHEN 0 THEN 5001
WHEN 1 THEN 5002
WHEN 2 THEN 4005
WHEN 3 THEN 4001
WHEN 4 THEN 4002
WHEN 5 THEN 4006
END
INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @PrimaryItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @PrimaryCIID =@@IDENTITY
/* Secondary */
IF @Costume = 0 OR @Costume = 2 BEGIN
SET @SecondaryItemID =
CASE @Costume
WHEN 0 THEN 4001
WHEN 1 THEN 0
WHEN 2 THEN 5001
WHEN 3 THEN 4006
WHEN 4 THEN 0
WHEN 5 THEN 4006
END
IF @SecondaryItemID <> 0 BEGIN
INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @SecondaryItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @SecondaryCIID =@@IDENTITY
END
END
SET @Custom1ItemID =CASE @Costume
WHEN 0 THEN 30301
WHEN 1 THEN 30301
WHEN 2 THEN 30401
WHEN 3 THEN 30401
WHEN 4 THEN 30401
WHEN 5 THEN 30101
END
/* Custom1 */
INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @Custom1ItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @Custom1CIID =@@IDENTITY
/* Custom2 */
IF @Costume = 4 OR @Costume = 5
BEGIN
SET @Custom2ItemID =
CASE @Costume
WHEN 0 THEN 0
WHEN 1 THEN 0
WHEN 2 THEN 0
WHEN 3 THEN 0
WHEN 4 THEN 30001
WHEN 5 THEN 30001
END
IF @Custom2ItemID <> 0
BEGIN
INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @Custom2ItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @Custom2CIID =@@IDENTITY
END
END

IF @Sex = 0 /* 남자일 경우 */
BEGIN
/* Chest */
SET @ChestItemID =
CASE @Costume
WHEN 0 THEN 21001
WHEN 1 THEN 21001
WHEN 2 THEN 21001
WHEN 3 THEN 21001
WHEN 4 THEN 21001
WHEN 5 THEN 21001
END

INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @ChestItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @ChestCIID =@@IDENTITY
/* Legs */
SET @LegsItemID =
CASE @Costume
WHEN 0 THEN 23001
WHEN 1 THEN 23001
WHEN 2 THEN 23001
WHEN 3 THEN 23001
WHEN 4 THEN 23001
WHEN 5 THEN 23001
END

INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @LegsItemID)
IF 0 <>@@ERRORBEGINROLLBACKTRAN
RETURN(-1)
END
SET @LegsCIID =@@IDENTITY
END
ELSE
BEGIN/* 여자일 경우 */
/* Chest */
SET @ChestItemID =
CASE @Costume
WHEN 0 THEN 21501
WHEN 1 THEN 21501
WHEN 2 THEN 21501
WHEN 3 THEN 21501
WHEN 4 THEN 21501
WHEN 5 THEN 21501
END

INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @ChestItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @ChestCIID =@@IDENTITY
/* Legs */
SET @LegsItemID =
CASE @Costume
WHEN 0 THEN 23501
WHEN 1 THEN 23501
WHEN 2 THEN 23501
WHEN 3 THEN 23501
WHEN 4 THEN 23501
WHEN 5 THEN 23501
END

INSERTINTO CharacterItem (CID, ItemID)Values(@CharIdent, @LegsItemID)
IF 0 <>@@ERRORBEGIN
ROLLBACKTRAN
RETURN(-1)
END
SET @LegsCIID =@@IDENTITY
END

then u see someting like this

SET @ChestItemID =
CASE @Costume
WHEN 0 THEN 21501
WHEN 1 THEN 21501
WHEN 2 THEN 21501
WHEN 3 THEN 21501
WHEN 4 THEN 21501
WHEN 5 THEN 21501
END
it says @ChestItemID = that means that that are the chest items then u can choose the item u want as chest tiem when u choose the class u have well after THEN it says 21501 that means the item id u can find it at strings ur zitem if u want ur own edited item ur ur other items then u gotta put the item id there 0 is class 1 is class 2 etc then u just gotta put the item id u want at class 0 and then if u wanna put at legs u gotta scrol little up and then u will see someting whit Leg but u'll get it its kinda easy sorry for my english i hope a gm ur admin could translate it to better english but i hope u guys get it but its helpfull =DD

[MentaL]

[willianmorvan]

Okay... thankx

[ron1233]

thanks!

[Kingston]

use the code box. and nice tutorial

[thebestkiller]

Nice tut.
Usefull!

[kochon]

good!

thank you