SA-MP Forums Archive
MySQL doesn't save a long string. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL doesn't save a long string. (/showthread.php?tid=664734)


MySQL doesn't save a long string. - Stefhan - 09.03.2019

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;
} 


Re: MySQL doesn't save a long string. - bgedition - 09.03.2019

That is just how phpMyAdmin works. Notice the three dots at the end of the field? This means the string was cut for displaying purposes (so it can be compact). If you double click the field you will enter editing mode for that field and will see the full string.

Re: MySQL doesn't save a long string. - Stefhan - 09.03.2019

Quote:
Originally Posted by bgedition
View Post
That is just how phpMyAdmin works. Notice the three dots at the end of the field? This means the string was cut for displaying purposes (so it can be compact). If you double click the field you will enter editing mode for that field and will see the full string.
If I double click it I just select the text, and if I try to search for the part of the string that comes after the dots, nothing is found. I also tried dragging the field to make it longer but it doesn't show the new text. I clicked edit at the top and it doesn't show anything either.

If I double click:



If I search for part of the string that comes after the dots:


Also notice I made the field longer by dragging it and additional text did not show.

As far as I'm aware, I'm not editing the column when I double click it, I just select it.

Please help

Re: MySQL doesn't save a long string. - Stefhan - 09.03.2019

Found settings which let me increase the size. If anyone else has this issue, this is how to solve it:

Go to options here:


Then increase size here:


Hope that helps others that get this issue!

Re: MySQL doesn't save a long string. - Banditul18 - 09.03.2019

You realize you cant type more than 128 characters in chat right?

https://san-andreas-multiplayer-samp...om/wiki/Limits

Re: MySQL doesn't save a long string. - Stefhan - 09.03.2019

Quote:
Originally Posted by Banditul18
View Post
You realize you cant type more than 128 characters in chat right?

https://san-andreas-multiplayer-samp...om/wiki/Limits
Yes, obviously.. But a player can type 128 characters when they press T. With their name added though, it cuts down, that's why you need a second line to continue the string.

Re: MySQL doesn't save a long string. - bgedition - 10.03.2019

Sorry about the double click thing. It only works when a table has a primary key.