Good night,
I have found a minor problem and I do not know how to solve it.
I want to send ingame items from the web, but when I send them I have problems with the ‘item_instance’ table. I have theese code:
SET @CHAR = {CHARACTER};
SET @IDNUM = (SELECT MAX(ID) FROM mail)+1;
INSERT INTO `mail` (`id`, `messageType`, `stationery`, `mailTemplateId`, `sender`, `receiver`, `subject`, `body`, `has_items`, `expire_time`, `deliver_time`, `money`, `cod`) VALUES (@IDNUM, 0, 61, 0, 14, @CHAR, 'Tienda de votos', 'Gracias por votar y utilizar nuestra tienda', 1, 0, 0, 0, 0);
SET @IDGUID = (SELECT MAX(guid) FROM item_instance)+1;
INSERT HIGH_PRIORITY INTO `item_instance` (`itemEntry`, `owner_guid`, `count`, `charges`, `enchantments`, `guid`, `durability`) VALUES
(ITEM, 14, 1, '1 0 0 0 0', '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', @IDGUID, 200);
INSERT INTO `mail_items` (`mail_id`, `item_guid`, `receiver`) VALUES (@IDNUM, @IDGUID, @CHAR);
The problem items do not correctly store in the table. I often change the value entered in itemEntry.
It does not always happen, and the value is random. Is there any solution for this?
Thank you
Sorry, i don’t speak english