how to add hwanlevel to new chars?

[CrazyGirL_ZSZC]

just want to knwo how can i add the hwanlevel like ( Baron ) to new chars

[Dr.Abdelfattah]

use this query

PHP Code:

UPDATE dbo._Char SET Hwan=0 WHERE Hwan LIKE '0' 


change

PHP Code:

Hwan=0 


To the number of Hwan u need like 1 or 2 like general baronet and soo .
i forgot the last Column in _Char table which for hwan but i think the column named hwan like what i write , just check it's name if u found another name just change both Hwan in the query to that name ,
Something else any new people will create new char u need to make this query again for them .

[CrazyGirL_ZSZC]

Originally Posted by Dr.Abdelfattah

use this query

PHP Code:

UPDATE dbo._Char SET Hwan=0 WHERE Hwan LIKE '0' 


change

PHP Code:

Hwan=0 


To the number of Hwan u need like 1 or 2 like general baronet and soo .
i forgot the last Column in _Char table which for hwan but i think the column named hwan like what i write , just check it's name if u found another name just change both Hwan in the query to that name ,
Something else any new people will create new char u need to make this query again for them .

i know how to make it manualy

but i want to know how to make it automatic !

cause too many chars creating every day , and so boring to make it manual

[IceAmStiel]

for Senior General/Baron..

SRO_VT_SHARD -> Stored Procedure "_AddNewChar" -> Modify, change the lines as stated below..

PHP Code:

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, 20000, 200,200, 1, 1, 1, 1, 3) 


As you can see I simply added "HwanLevel" under INSERT INTO and assigned the value "3" under VALUES to it

[CrazyGirL_ZSZC]

Originally Posted by IceAmStiel

for Senior General/Baron..

SRO_VT_SHARD -> Stored Procedure "_AddNewChar" -> Modify, change the lines as stated below..

PHP Code:

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, 20000, 200,200, 1, 1, 1, 1, 3) 


As you can see I simply added "HwanLevel" under INSERT INTO and assigned the value "3" under VALUES to it

thank you