anyone have query to add gold to storage by charid ?
Printable View
anyone have query to add gold to storage by charid ?
Nvm .
go do SRO_VT_SHARD > Progamability > Stored Procedures > _AddNewUser > 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, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, xxxxxxxxxxxxxxxxxxxx, 0, 0, 200,200, 1, 1, 1, 1)
xxxxxxxxxxxxxxxxxxxx is value of gold to insert on new char