Оптимизация запроса mysql (вопрос)

RaySamp · 12 Июл 2021

У меня две таблицы Account и Character. В Account у меня хранятся данные аккаунта, а в Character статистика.
Мне нужно на определённом этапе выгрузить данные ячейки "Skin" из таблицы "Character".

Я это делаю так:

C++:

    if(strcmp(Account[playerid][aAc_1],"None",true))
    {
        mysql_format(MySQL, string_p[playerid], MAX_STRING, "SELECT * FROM `character` WHERE `Name` = '%s'",Account[playerid][aAc_1]);
        mysql_tquery(MySQL, string_p[playerid], "Load_Skin1", "d", playerid), string_p[playerid][0] = 0;
    }
    if(strcmp(Account[playerid][aAc_2],"None",true))
    {
        mysql_format(MySQL, string_p[playerid], MAX_STRING, "SELECT * FROM `character` WHERE `Name` = '%s'",Account[playerid][aAc_2]);
        mysql_tquery(MySQL, string_p[playerid], "Load_Skin2", "d", playerid), string_p[playerid][0] = 0;
    }
    if(strcmp(Account[playerid][aAc_3],"None",true))
    {
        mysql_format(MySQL, string_p[playerid], MAX_STRING, "SELECT * FROM `character` WHERE `Name` = '%s'",Account[playerid][aAc_3]);
        mysql_tquery(MySQL, string_p[playerid], "Load_Skin3", "d", playerid), string_p[playerid][0] = 0;
    }
    if(strcmp(Account[playerid][aAc_4],"None",true))
    {
        mysql_format(MySQL, string_p[playerid], MAX_STRING, "SELECT * FROM `character` WHERE `Name` = '%s'",Account[playerid][aAc_4]);
        mysql_tquery(MySQL, string_p[playerid], "Load_Skin4", "d", playerid), string_p[playerid][0] = 0;
    }


publics Load_Skin1(playerid)
{
    Account[playerid][aSkin_1] = cache_get_field_content_int(0,"Skin");
    PlayerTextDrawSetPreviewModel(playerid, LobbySkin[0][playerid], Account[playerid][aSkin_1]);
    PlayerTextDrawShow(playerid, LobbySkin[playerid][0]);
    return true;
}
publics Load_Skin2(playerid)
{
    Account[playerid][aSkin_2] = cache_get_field_content_int(0,"Skin");
    PlayerTextDrawSetPreviewModel(playerid, LobbySkin[playerid][1], Account[playerid][aSkin_2]);
    PlayerTextDrawShow(playerid, LobbySkin[playerid][1]);
    return true;
}
publics Load_Skin3(playerid)
{
    Account[playerid][aSkin_3] = cache_get_field_content_int(0,"Skin");
    PlayerTextDrawSetPreviewModel(playerid, LobbySkin[playerid][2], Account[playerid][aSkin_3]);
     PlayerTextDrawShow(playerid, LobbySkin[playerid][2]);
    return true;
}
publics Load_Skin4(playerid)
{
    Account[playerid][aSkin_4] = cache_get_field_content_int(0,"Skin");
    PlayerTextDrawSetPreviewModel(playerid, LobbySkin[playerid][3], Account[playerid][aSkin_4]);
    PlayerTextDrawShow(playerid, LobbySkin[playerid][3]);
    return true;
}

Всё работает, но у меня вопрос. Можно-ли сделать это как-то проще и короче?
MySQL plugin R39-2
Буду признателен за помощь.

Оптимизация запроса mysql (вопрос)

RaySamp

Умник