[19:29:41] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \' PlayerInfo[playerid][Kill], PlayerInfo[playerid][Death], PlayerInfo[playerid][s\' at line 1
..... slot3`=\'%d\',`slot4`=\'%d\',`slot5`=\'%d\',`slot6`=\'%d\',`ammo1`=\'%d\',`ammo2`=\'%d\',`ammo3`=\'%d\',`ammo4`=\'%d\',`ammo5`=\'%d\',`ammo6`=\'%d\',`hudcolor`=\'%s\',`ip`=\'%s\' WHERE `username`=\'%s\', PlayerInfo[playerid][Kill], PlayerInfo[playerid][Death], PlayerInfo[playerid][score], PlayerInfo[playerid][Money], PlayerInfo[playerid][sex],PlayerInfo[playerid][Age].........
while(mysql_fetch_row_format(query,\"|\")) { mysql_fetch_field_row(savingstring, \"kills\"); PlayerInfo[playerid][Kill] = strval(savingstring); mysql_fetch_field_row(savingstring, \"deaths\"); PlayerInfo[playerid][Death] = strval(savingstring); mysql_fetch_field_row(savingstring, \"score\"); PlayerInfo[playerid][score] = strval(savingstring); mysql_fetch_field_row(savingstring, \"money\"); PlayerInfo[playerid][Money] = strval(savingstring); mysql_fetch_field_row(savingstring, \"sex\"); PlayerInfo[playerid][sex] = strval(savingstring);...........
[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'0\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'1\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'2\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'3\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'4\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'5\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'6\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'7\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'8\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'9\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'10\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'11\')...............
Sziasztok!Kb. fél órája nézem már és nem tudok rájönni mit írtam el [19:29:41] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \' PlayerInfo[playerid][Kill], PlayerInfo[playerid][Death], PlayerInfo[playerid][s\' at line 1 ..... slot3`=\'%d\',`slot4`=\'%d\',`slot5`=\'%d\',`slot6`=\'%d\',`ammo1`=\'%d\',`ammo2`=\'%d\',`ammo3`=\'%d\',`ammo4`=\'%d\',`ammo5`=\'%d\',`ammo6`=\'%d\',`hudcolor`=\'%s\',`ip`=\'%s\' WHERE `username`=\'%s\', PlayerInfo[playerid][Kill], PlayerInfo[playerid][Death], PlayerInfo[playerid][score], PlayerInfo[playerid][Money], PlayerInfo[playerid][sex],PlayerInfo[playerid][Age]......... A másik pedig:A betöltés így van megoldva: while(mysql_fetch_row_format(query,\"|\")) { mysql_fetch_field_row(savingstring, \"kills\"); PlayerInfo[playerid][Kill] = strval(savingstring); mysql_fetch_field_row(savingstring, \"deaths\"); PlayerInfo[playerid][Death] = strval(savingstring); mysql_fetch_field_row(savingstring, \"score\"); PlayerInfo[playerid][score] = strval(savingstring); mysql_fetch_field_row(savingstring, \"money\"); PlayerInfo[playerid][Money] = strval(savingstring); mysql_fetch_field_row(savingstring, \"sex\"); PlayerInfo[playerid][sex] = strval(savingstring);........... És ilyen warningokat ír: [19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'0\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'1\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'2\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'3\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'4\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'5\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'6\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'7\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'8\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'9\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'10\')[19:29:36] [WARNING] CMySQLResult::GetRowData - invalid row (\'1\') or field index (\'11\')...............
WHERE `username`=\'%s\', PlayerInfo[playerid][Kill]
WHERE `username`=\'%s\'\", PlayerInfo[playerid][Kill]