Input line too long - Mysql
#8

Okay then, The code should look like that while using strcat..

PHP Code:
UpdatePlayerData(playerid)
{
if (
Player[playerid][IsLoggedIn] == false) return 0;

// if the client crashed, it's not possible to get the player's position in OnPlayerDisconnect callback
// so we will use the last saved position (in case of a player who registered and crashed/kicked, the position will be the default spawn point)

new query[700];
new 
strcatquery[700];
strcat(strcatquery"UPDATE `players` SET `sexe` = '%d', `ethnie` = '%d', `age` = '%d', `skin` = '%d', `level` = '%d', `adminlevel` = '%d', `banned` = '%d', `faction` = '%d', `cash` = '%d', `rankfaction` = '%d' WHERE `id` = '%d' LIMIT 1");

mysql_format(dbhandlequerysizeof querystrcatqueryPlayer[playerid][Sexe],Player[playerid][Ethnie],Player[playerid][Age],Player[playerid[Skin],Player[playerid[Level],Player[playerid[AdminLevel],Player[playerid[Banned],Player[playerid][Faction],Player[playerid][Cash],Player[playerid][RankFaction],);

//mysql_format(dbhandle, query, sizeof query, "UPDATE `players` SET `rankfaction` = %d WHERE `id` = %d LIMIT 1", Player[playerid][RankFaction], Player[playerid][ID]);
// mysql_tquery(dbhandle, query, false, "", "");
mysql_tquery(dbhandlequery);

return 
1;

idk if I fucked something up or no, try it..
Reply


Messages In This Thread
( FIXED ) Input line too long - Mysql - by Klayton - 04.09.2017, 10:19
Re: Input line too long - Mysql - by JasonRiggs - 04.09.2017, 10:27
Re: Input line too long - Mysql - by Klayton - 04.09.2017, 10:35
Re: Input line too long - Mysql - by JasonRiggs - 04.09.2017, 10:39
Re: Input line too long - Mysql - by Klayton - 04.09.2017, 10:40
Re: Input line too long - Mysql - by JasonRiggs - 04.09.2017, 10:44
Re: Input line too long - Mysql - by Klayton - 04.09.2017, 10:53
Re: Input line too long - Mysql - by JasonRiggs - 04.09.2017, 11:00
Re: Input line too long - Mysql - by 10MIN - 04.09.2017, 11:03
Re: Input line too long - Mysql - by Klayton - 04.09.2017, 11:13
Re: Input line too long - Mysql - by Klayton - 04.09.2017, 11:16

Forum Jump:


Users browsing this thread: 2 Guest(s)