Problem with Change Name Scroll

devdash · 01/17/2019, 16:58

this happens after change name Scroll, the name is diffrent in the Ranking and the player can't invite any play to he's academy, and he can't form a number academy too

i think i need to edit something in the _ChangeNameByID Producer

thanks in advance

putzeimer195 · 01/17/2019, 17:27

Restart your gameserver and then look, academy only updated at a fixed time

HECKT0R · 01/17/2019, 23:18

the player who gonna change his char name should not be in guild or Academy .
he should leave guild and academy first .

Leodoom · 01/17/2019, 23:19

Spoiler

Update Honor rank

Spoiler

#HB · 01/17/2019, 23:22

Quote:

Originally Posted by Leodoom

Spoiler

USE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK

Update Honor rank

Spoiler

USE SRO_VT_SHARD
exec _TRAINING_CAMP_UPDATEHONORRANK

Uhm, uhm. That's not what he's talking about buddy.

Leodoom · 01/17/2019, 23:39

I understood that he was speaking after the name changed

devdash · 01/18/2019, 23:54

i really appreciate all the answers,
i just need a thing that can be added to the change name scroll, for example
" update name @

-rank "

iam just trying to give example, cuz i can't restart the gameserver.exe everytime someone use the scroll

thanks in advance and apolgize for late replay...

#HB · 01/19/2019, 00:20

Quote:

Originally Posted by alydandy

iam just trying to give example, cuz i can't restart the gameserver.exe everytime someone use the scroll

Yeah, you can try to edit GS's memory.

devdash · 01/19/2019, 17:32

Quote:

Originally Posted by #HB

Yeah, you can try to edit GS's memory.

i don't think its possible for me, and i think u mess understood me
what i meant is
this producer [_RenameCharNameByID]
have lines like

insert _CharNameList values @

, @

d)

UPDATE _Char set CharName16 = @

where CharID = @

D

update _Friend set friendcharname = @

where friendcharid = @

d

update _GuildMember set charname = @

where charid = @

d

update _Memo set fromcharname = @

where fromcharname = @

name

update _TrainingCampMember set charname = @

where charid = @

d

why can't we just add update _honor ranking name

comon u have more experience than me

cuz its not cool that the player can't invite any player to he's academy till i restart the gameserver.exe not cool at all

thanks in advance

#HB · 01/19/2019, 19:19

Quote:

Originally Posted by alydandy

why can't we just add update _honor ranking name

_RenameCharNameByID already edits the name but the GS doesn't tell the client the value stored at the database, but the one stored at its memory.

Probably there's only 2 ways to do that:

Editing GS's memory.
Using a packet-filter that will receive that training camp name, checks if he has used character name changer scroll before, creates a new modified packet and sends it to the client. But you'll need to make a table for the players who had used the character name changer scroll and then delete its lines whenever you restart the GS, so I prefer editing GS's memory.

Beba Army · 06/03/2020, 03:21

So it fixes by restarting Gameserver?