Automatic Alias Name for JOB

02/09/2017 00:38 lepitismak#1

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

bump

02/10/2017 01:43 leo2111#2

Edit the sro_client xD

02/10/2017 09:35 B1Q#3

do it via a trigger.

on update

check if jobtype > 0

update NickName16 to CharName16

Trigger Example:

Code:

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

02/10/2017 11:42 lepitismak#4

Quote:
Originally Posted by B1QB0SS :3
do it via a trigger.

on update

check if jobtype > 0

update NickName16 to CharName16

Trigger Example:
Code:
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?

02/10/2017 14:12 "Abner"#5

Hello @[Only registered and activated users can see links. Click Here To Register...],

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

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

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

02/10/2017 21:15 B1Q#6

Quote:

Originally Posted by "Abner"

Hello @[Only registered and activated users can see links. Click Here To Register...],

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

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

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

02/11/2017 04:21 lepitismak#7

Quote:

Originally Posted by "Abner"

Hello @[Only registered and activated users can see links. Click Here To Register...],

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

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

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?

02/11/2017 06:34 B1Q#8

create a trigger on _CharTriJob

after update

Rollback Transaction :3

EDIT:

that was a fucking joke don't do it :D

02/11/2017 14:11 lepitismak#9

Quote:

Originally Posted by B1QB0SS :3

create a trigger on _CharTriJob

after update

Rollback Transaction :3

great thx i will try it :D