AAC myacc few spaces

[Tibia Idle]

I have a problem with myacc. when I create a character and put a lot of spaces, the website does not remove them. the created character looks good on the website. it has a lot of spaces in the game. how to fix it?

 

[Sizaro]

Looks like a feature to me

 

[lursky]

function sanitzePlayerName($name) {
    return preg_replace('/\s+/', ' ', trim($name));
}

$name = "Jon    Jons";
$sanitizedName = sanitzePlayerName($name);  // "Jon Jons"

 

[Tibia Idle]

function sanitzePlayerName($name) {
    return preg_replace('/\s+/', ' ', trim($name));
}

$name = "Jon    Jons";
$sanitizedName = sanitzePlayerName($name);  // "Jon Jons"

on the page it automatically removes spaces. however, I want to fix a bug in the game

 

[Sizaro]

Go into your database probably using phpMyAdmin and find table players, find the player you wanna change and change their name.

 

[Tibia Idle]

Go into your database probably using phpMyAdmin and find table players, find the player you wanna change and change their name.

Post automatically merged: Jan 16, 2024

function sanitzePlayerName($name) {
    return preg_replace('/\s+/', ' ', trim($name));
}

$name = "Jon    Jons";
$sanitizedName = sanitzePlayerName($name);  // "Jon Jons"

In which page file should I add it? I can't find the account php file

 

[lursky]

@Tubeshop Speaking of exiting entries in DB you could sanitize that with use of REGEXP_REPLACE(name, '\\s+', ' ', 1, 0) but if there are some names that'd lead to UNIQUE constraint violation you'd need to handle that too. For example like that (It's ugly but should work):

WITH normalizedMap AS (
    SELECT
        REGEXP_REPLACE(name, '\\s+', ' ', 1, 0) AS normalized_name,
        COUNT(*) OVER (PARTITION BY REGEXP_REPLACE(name, '\\s+', ' ', 1, 0)) AS cnt,
        id AS player_id
    FROM players
)
UPDATE players p
INNER JOIN normalizedMap n ON n.player_id = p.id
SET p.name = n.normalized_name
WHERE n.cnt = 1;

Speaking of the previous code snippet it's just a proposal code you could use while saving players to DB (find a save player method in your AAC or some method that validates/sanitizes player name and put the code there)

UPDATE:
From what I see MyAAC already has some validators for that purpouse:

myaac/system/libs/validator.php at a88103a95622bcf20db64a0b25d9592f2dca21bf · slawkens/myaac

Automatic Account Creator (AAC) for Open Tibia Servers written in PHP - slawkens/myaac

github.com

 

[Tibia Idle]

@Tubeshop Speaking of exiting entries in DB you could sanitize that with use of REGEXP_REPLACE(name, '\\s+', ' ', 1, 0) but if there are some names that'd lead to UNIQUE constraint violation you'd need to handle that too. For example like that (It's ugly but should work):

WITH normalizedMap AS (
    SELECT
        REGEXP_REPLACE(name, '\\s+', ' ', 1, 0) AS normalized_name,
        COUNT(*) OVER (PARTITION BY REGEXP_REPLACE(name, '\\s+', ' ', 1, 0)) AS cnt,
        id AS player_id
    FROM players
)
UPDATE players p
INNER JOIN normalizedMap n ON n.player_id = p.id
SET p.name = n.normalized_name
WHERE n.cnt = 1;

Speaking of the previous code snippet it's just a proposal code you could use while saving players to DB (find a save player method in your AAC or some method that validates/sanitizes player name and put the code there)

UPDATE:
From what I see MyAAC already has some validators for that purpouse:

myaac/system/libs/validator.php at a88103a95622bcf20db64a0b25d9592f2dca21bf · slawkens/myaac

Automatic Account Creator (AAC) for Open Tibia Servers written in PHP - slawkens/myaac

github.com

thanks for help

 

[slaw]

It is allowed for admin to create char with spaces and also some other rules are skipped.

Are you sure you are not logged on admin account while creating character?

 

[Tibia Idle]

Yes, I was logged in to the admin account. usually the account cannot do this. Thank you for your answer