[Stefhan]

So I try to log player chat at OnPlayerText and temporarily upped all the values to 500, yet it still doesn't save the large string, only a part of it.

Anyone knows why? See code and screenshot below.

MySQL:


Table:


In-Game:

PHP Code:

public OnPlayerText(playerid, text[])
{
    if(!gamemodeLoaded)
    {
        SCM(playerid, COLOR_ERROR, "Please wait until the gamemode finishes loading.");
        SCM(playerid, COLOR_SERVER, "Your request was not processed.");
        return 0;
    }
    if(!LoggedIn[playerid] || Spawned[playerid] == 0)
    {
        SCM(playerid, COLOR_ERROR, "You are not logged in or have not spawned yet.");
        SCM(playerid, COLOR_SERVER, "You must login and spawn first before your request can be processed.");
        return 0;
    }
    new str[500];
    if(AdminDuty[playerid] == 1)
    {
        format(str, sizeof(str), "(( %s %s(%i): %s ))",ReturnAdminLevel(playerid), ReturnICName(playerid), playerid, text);
        ProxDetector(20.0, playerid, str, COLOR_ORANGE);
    }
    else if(DevDuty[playerid] == 1)
    {
        format(str, sizeof(str), "(( %s %s(%i): %s ))",ReturnDevLevel(playerid), ReturnICName(playerid), playerid, text);
        ProxDetector(20.0, playerid, str, COLOR_DEV);
    }
    else
    {
        format(str, sizeof(str), "%s says: %s", ReturnICName(playerid), text);
        ProxDetectorColor(20.0, playerid, str, COLOR_GRAD1, COLOR_GRAD2, COLOR_GRAD3, COLOR_GRAD4, COLOR_GRAD5);
        SetPlayerChatBubble(playerid, str, COLOR_CHAT, 30, 5000);
    }
    new query[500];
    mysql_format(g_SQL, query, sizeof(query), "INSERT INTO logs_chat(acc_dbid, acc_name, playerid, time, text) VALUES('%i', '%e', '%i', UTC_TIMESTAMP(), '%e')", PlayerInfo[playerid][pDBID], ReturnName(playerid), playerid, text);
    mysql_tquery(g_SQL, query);
    return 0;
}