how to add hwanlevel to new chars?

01/19/2012 15:56 CrazyGirL_ZSZC#1

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

01/19/2012 16:11 Dr.Abdelfattah#2

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 .

01/19/2012 16:25 CrazyGirL_ZSZC#3

Quote:

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

01/20/2012 00:08 IceAmStiel#4

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

01/20/2012 12:43 CrazyGirL_ZSZC#5

Quote:

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 :)