Messenger List via pid instead of name

[iFreakTime~.~ 47]

Hello everyone, tell me a hint how to modify the player.messenger_list to work via pid instead of player names, because some players changes their names and friends list is gone.

[Braxy 589]

You dont have to change it to PID. You can simply update the messenger_list by changing the last name with the new one both on account and companion rows.

Edited February 29, 2020 by Braxy

[iFreakTime~.~ 47]

And if i change my name directly from navicat? I think is better using pid instead of name

[PACI 911]

Why would you do that to begin with?

[VegaS™ 9934]

On 2/29/2020 at 12:56 PM, iFreakTime~.~ said:

And if i change my name directly from navicat? I think is better using pid instead of name

There's no reason to use pids instead of names, for doing that you've to re-code the whole structure of the system.

Ymir did when you change your name to delete all fields from table that match with the old name (account or companion).

So in this case, instead of deleting the whole list you can simply update it.

• Srcs/Server/game/src/questlua_pc.cpp

 

This is the hidden content, please

• Sign In
• or
• Sign Up

Or:

		std::auto_ptr<SQLMsg> pUpdate(DBManager::instance().DirectQuery(
			"UPDATE messenger_list SET "
			"account = CASE WHEN account = '%s' THEN '%s' ELSE account END, "
			"companion = CASE WHEN companion = '%s' THEN '%s' ELSE companion END", 
				ch->GetName(), szName, ch->GetName(), szName);

 

Edited August 22, 2020 by VegaS™