SA-MP Forums Archive
MySQL Plugin R5 - Multiline strings - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Plugin R5 - Multiline strings (/showthread.php?tid=261888)



MySQL Plugin R5 - Multiline strings - Blowfish - 15.06.2011

Hi,

I have some problems with getting multiline strings with G-sTyLeZzZ's MySQL.
The only thing it puts into my array is the first word second line of the string, which
seems to be really odd to me. The rest is kinda randomly put somewhere else.
So sometimes other variables are getting messed up.
Are there any limitations for the size of the string returned from the database or is
there a special function for fetching newline strings or am I just doing something
terribly wrong?

Here's an extract from my source code:
Код:
        format(QueryString, sizeof(QueryString), "SELECT `description` FROM `help_cmds` WHERE `cmd` = '%s' AND `category` = %d", Command, GetPVarInt(playerid, "help_lastcategory"));                                                                                                                                           
        mysql_query(QueryString);
        mysql_store_result();                                                                                                                                   
        if(mysql_retrieve_row())
                mysql_fetch_field_row(HugeString, "description");                                                                                               
        mysql_free_result();
And here are some more details about my setup:
Plugin version: r5 x86
OS: GNU/Linux
Distribution: Arch Linux
Kernel: 2.6.32-5-openvz-amd64
Architecture: i686
SAMP Server Version: 0.3c r2

Thanks,
Blowfish