02.02.2019, 19:39
[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
I don't get it. What seems to be the problem in that code..?
[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; }