Originally Posted by badji
SRO_VT_SHARD>Programmability>stored Procedures> AddNewChar (modify) =
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, 129, 129, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 60,
GetDate(), 110, 110, 1000000000, 327, 9999999, 11168,11168, 1, 1, 1, 1)
this for start lvl sp gold etc
items on bottom page
example :
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLU S',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GLOBAL_CHATTING',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,7
IF ANYONE KNOWS HOW TO ADD FB ITEMS OR WEAPONS WITH GOOD STATS RIGHT AWAY AFTER CREATE CHAR PM or post it here
ty
|