[31/01/2019 22:44:24] ** [MySQL] 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
[31/01/2019 22:44:24] [31/01/2019, 22:44] OnStorageAdd: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server
Код:
stock House_AddItem(houseid, item[], model, quantity = 1, slotid = -1)
{
if (houseid == -1 || !HouseData[houseid][houseExists])
return false;
new
itemid = House_GetItemID(houseid, item),
string[128];
if (itemid == -1)
{
itemid = House_GetFreeID(houseid);
if (itemid != -1)
{
if (slotid != -1)
itemid = slotid;
HouseStorage[houseid][itemid][hItemExists] = true;
HouseStorage[houseid][itemid][hItemModel] = model;
HouseStorage[houseid][itemid][hItemQuantity] = quantity;
strpack(HouseStorage[houseid][itemid][hItemName], item, 32 char);
format(string, sizeof(string), "INSERT INTO `housestorage` (`ID`, `itemName`, `itemModel`, `itemQuantity`) VALUES('%d', '%s', '%d', '%d')", HouseData[houseid][houseID], item, model, quantity);
mysql_tquery(g_iHandle, string, "OnStorageAdd", "dd", houseid, itemid);
return itemid;
}
return -1;
}
else
{
format(string, sizeof(string), "UPDATE `housestorage` SET `itemQuantity` = `itemQuantity` + %d WHERE `ID` = '%d' AND `itemID` = '%d'", quantity, HouseData[houseid][houseID], HouseStorage[houseid][itemid][hItemID]);
mysql_tquery(g_iHandle, string);
HouseStorage[houseid][itemid][hItemQuantity] += quantity;
}
return itemid;
}
I don't get it. What seems to be the problem in that code..?
Aight, will try. Thank you very much