How to change initial stats and item for new char

[shadowunic]

Fist Open You'r Sql Management

Open Databases > SRO_VT_SHARD_INIT > Programmability > Stored Procedures > _AddNewChar



Now To Change Initial Stats Search The Lines

-- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼­ ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 150, 100, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 109,
GetDate(), 1, 1, 10000000, 0, 7500, 200,200, 1, 1, 1, 1)

This Is My AddNewChar

The Value 150 is = STR
The Value 100 is = INT
The Value 109 is = Inventory Space ( 109 is All Inventory Open)
The Value 10000000 is = Initial Gold
The Value 7500 is = Skill Points
The Value 200 is = HP
The Value 200 is = MP


Remember this is my initial values for new chars

Now Go To Change Itens For New Chars ^^


In Databases > SRO_VT_SHARD_INIT > Programmability > Stored Procedures > _AddNewChar Search The Line
This Is My Initial Itens

INSERT _CharNameList VALUES(@CharName, @NewCharID)

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_60EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_FLUTE_WHITE',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_RABBIT_SCROLL_SILK',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060517_MON_GENERATION_BOX',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E090930_SPEED_UP_SUPER_SCROLL',10,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',25,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',25,1

exec _ADD_ITEM_EXTERN @CharName, <<< Dont Change This

ITEM_MALL_RETURN_SCROLL_HIGH_SPEED = Item Name ( _RefObjCommon CodeName128 )

25 = Units

1 = Active



Exemple I Need 50 Gold Coin Initial

Im Create New Line For Values

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SD_TOKEN_04',50,1

Guide By: Shadow

[MentaL]

[omarc2040]

Greats work friend. :)