Automatic Alias Name for JOB

[lepitismak]

Anyone can help me how i can set for when char enter in job, alias name go same name of char?

bump

[leo2111]

Edit the sro_client xD

[B1Q]

do it via a trigger.

on update

check if jobtype > 0

update NickName16 to CharName16

Trigger Example:

BEGIN
if((select top 1 JobType from Inserted) > 0)
BEGIN
Update _Char set NickName16 = (select CharName16 from _Char where CharID=(select top 1 CharID from Inserted)) where CharID=(select top 1 CharID from Inserted)
END
END

didn't test it. but it should work

[lepitismak]

Originally Posted by B1QB0SS :3

do it via a trigger.

on update

check if jobtype > 0

update NickName16 to CharName16

Trigger Example:

BEGIN
if((select top 1 JobType from Inserted) > 0)
BEGIN
Update _Char set NickName16 = (select CharName16 from _Char where CharID=(select top 1 CharID from Inserted)) where CharID=(select top 1 CharID from Inserted)
END
END

didn't test it. but it should work

Would this be inserted in the addnewchar procedure?

["Abner"]

Hello @,


An easier way to do this is to replace the following code in _AddNewChar:

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

With this code:

    INSERT INTO _Char (RefObjID, CharName16, NickName16, 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, **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)

ps: replace every "**" with @, idk why epvp changes it to a [mention] -_-


best,




Abner

[B1Q]

Originally Posted by "Abner"

Hello @,


An easier way to do this is to replace the following code in _AddNewChar:

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

With this code:

    INSERT INTO _Char (RefObjID, CharName16, NickName16, 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, **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)

ps: replace every "**" with @, idk why epvp changes it to a [mention] -_-


best,




Abner

didn't think about it. that should work too

[lepitismak]

Originally Posted by "Abner"

Hello @,


An easier way to do this is to replace the following code in _AddNewChar:

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

With this code:

    INSERT INTO _Char (RefObjID, CharName16, NickName16, 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, **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)

ps: replace every "**" with @, idk why epvp changes it to a [mention] -_-


best,




Abner

i need a way for block any changes if player try to change alias name.
can help me with that?

[B1Q]

create a trigger on _CharTriJob

after update

Rollback Transaction :3

EDIT:

that was a ******* joke don't do it

[lepitismak]

Originally Posted by B1QB0SS :3

create a trigger on _CharTriJob

after update

Rollback Transaction :3

great thx i will try it