Request how i can add HWAN To All server

10/31/2011 19:40 JENZO#1
My Request is how i can add HWAN Lv 5 or 6 or 7 To all charcter in my server Like pvp server whene u Make New Acc And Creat New chracter u get Lv 110 with Lv 110 Zerk like chef General for ch or Count For EU ... i need a stored procedure for it so i need automatically set to 6 everytime a new character is created..

i hpe Guys u Understand me


any help
12/13/2011 16:37 IceAmStiel#2
Aw just found this thread by chance ;D

If it's still needed:

SRO_VT_SHARD -> _AddNewChar (Stored Procedure) -> Modify

Change the following line:

Quote:
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, HwanLevel)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1, 6)

-> every char is automatically Duke/General Lord after the creation