#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 '' at line 4
habe diesen error wenn ich dies in meiner db speichern will
CREATE TABLE IF NOT EXISTS `frakskins`(
`skinid` varchar(30) NOT NULL,
`skinnr` varchar(64) NOT NULL,
`frakid` int(5) NOT NULL,
im script der code
stock mysql_SetFrakSkin(FrakID,SkinNr,SkinID)
{
new Get[128];
format(query, 128, "SELECT skinid FROM frakskins WHERE frakid = '%d' AND skinnr = '%d'", FrakID, SkinNr);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get,"|");
if(mysql_num_rows()) {
format(query, sizeof(query), "UPDATE frakskins SET skinid = '%d' WHERE frakid = '%d' AND skinnr = '%d'", SkinID, FrakID, SkinNr);
} else {
format(query, sizeof(query), "INSERT INTO frakskins (frakid,skinnr,skinid) VALUES ('%d', '%d', '%d')", FrakID, SkinNr, SkinID);
}
mysql_query(query);
return true;
}
stock mysql_GetFrakSkin(FrakID,SkinNr)
{
new Get[128];
format(query, 128, "SELECT skinid FROM frakskins WHERE frakid = '%d' AND skinnr = '%d'", FrakID, SkinNr);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get,"|");
return strval(Get);
}