Very big string. - Printable Version

Very big 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: Very big string. (/showthread.php?tid=592470)

Very big string. - norton2 - 25.10.2015

SOLVED!

Re: Very big string. - Dusan01 - 25.10.2015

Lol dude, u dont need that big string...
For all Queryes use 1 string with length 2048

and that code split with 5-6 queryes, not all in one, here is example from my script:

PHP код:



mysql_format(MySQL, Query, sizeof(Query), "UPDATE `igraci_main` SET level = '%d', novac = '%d', skin = '%d', lider = '%d', clan = '%d', rank = '%d', droga = '%d', materijali = '%d' WHERE ime = '%s'",lvl, pare, skin, lider, clan, rank, droga, materijali, PlayerName(id));

    mysql_query(MySQL,Query);

and next update:

PHP код:



mysql_format(MySQL, Query, sizeof(Query), "UPDATE `igraci_main` SET spawn = '%d', posao = '%d', ajail = '%d', pjail = '%d', ticketi = '%d', vozacka = '%d', kanap = '%d', gps = '%d', askq = '%d' WHERE ime = '%s'", spawn, posao, ajail, pjail, ticket, vozacka, kanap, gps, askq, PlayerName(id));

    mysql_query(MySQL,Query);

Re: Very big string. - norton2 - 25.10.2015

Quote:

Originally Posted by Dusan01

Lol dude, u dont need that big string...
For all Queryes use 1 string with length 2048

and that code split with 5-6 queryes, not all in one, here is example from my script:

PHP код:



mysql_format(MySQL, Query, sizeof(Query), "UPDATE `igraci_main` SET level = '%d', novac = '%d', skin = '%d', lider = '%d', clan = '%d', rank = '%d', droga = '%d', materijali = '%d' WHERE ime = '%s'",lvl, pare, skin, lider, clan, rank, droga, materijali, PlayerName(id));

    mysql_query(MySQL,Query);

and next update:

PHP код:



mysql_format(MySQL, Query, sizeof(Query), "UPDATE `igraci_main` SET spawn = '%d', posao = '%d', ajail = '%d', pjail = '%d', ticketi = '%d', vozacka = '%d', kanap = '%d', gps = '%d', askq = '%d' WHERE ime = '%s'", spawn, posao, ajail, pjail, ticket, vozacka, kanap, gps, askq, PlayerName(id));

    mysql_query(MySQL,Query);

Thank you. +1.