Wysłany: 2017-06-25, 16:52
Amebek
Wiek: 34 Na forum: 3533 dni Posty: 12
Witam, mam pewien problem z zapisem do bazy danych. M?j kod z wylogowywania wygl?da tak:
Kod: stock Wylogowanie(playerid)
{
new query[256];
GetPlayerHealth(playerid, PlayerCache[playerid][pHealth]);
GetPlayerArmour(playerid, PlayerCache[playerid][pArmor]);
GetPlayerPos(playerid, PlayerCache[playerid][pPosX], PlayerCache[playerid][pPosY], PlayerCache[playerid][pPosZ]);
PlayerCache[playerid][pVirtualWord] = GetPlayerVirtualWorld(playerid);
PlayerCache[playerid][pInterior] = GetPlayerInterior(playerid);
format(query, sizeof(query), "UPDATE members SET cash = '%d', score = '%d', health = '%f', armor = '%f', posX = '%f', posY = '%f', posZ = '%f', Frakcja = '%d', rank = '%d', StalaRanga = '%d', IP = '%s', Wanted = '%d', Interior = '%d', VW = '%d' WHERE uid = '%d'",
GetPlayerMoney(playerid),
GetPlayerScore(playerid),
PlayerCache[playerid][pHealth],
PlayerCache[playerid][pArmor],
PlayerCache[playerid][pPosX],
PlayerCache[playerid][pPosY],
PlayerCache[playerid][pPosZ],
PlayerCache[playerid][pFrakcja],
PlayerCache[playerid][pRank],
PlayerCache[playerid][pStalaRanga],
PlayerCache[playerid][pIP],
PlayerCache[playerid][pWanted],
PlayerCache[playerid][pInterior],
PlayerCache[playerid][pVirtualWord],
PlayerCache[playerid][pUID] );
mysql_query(query);
return 1;
}
i wyskakuje w konsoli to:
Kod:
[02:04] [MySQL] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1.
O co chodzi?
Wysłany: 2017-06-26, 12:48
Virex_PL
Głos rozsądku
Wiek: 26 Na forum: 4187 dni Posty: 170
Nick w MP: Virex_PL
Piwa : 31
Zwieksz tablice do przyk?adowo 500.
Spr?buj te zapytanie:
"UPDATE `members` SET `cash` = '%d', `score` = '%d', `health` = '%f', `armor` = '%f', `posX` = '%f', `posY` = '%f', `posZ` = '%f', `Frakcja` = '%d', `rank` = '%d', `StalaRanga` = '%d', `IP` = '%s', `Wanted` = '%d', `Interior` = '%d', `VW` = '%d' WHERE `uid` = '%d'"
Tagi: wylogowywanie(mysql)
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: