вот переделанный под l2jteon 100% работает.
Код:
SET @NICK = 'ник';
SET @charId = (SELECT `obj_Id` FROM `characters` WHERE `char_name` = @NICK);
SET @objId = (SELECT MAX( object_id ) + 1 FROM items);
SET @itemId = 'ид вещи';
SET @name = 'название';
SET @count = 'количество';
INSERT INTO items ( owner_id, object_id, item_id, count, enchant_level, loc, loc_data, price_sell, price_buy, time_of_use, custom_type1, custom_type2, mana_left, donatorRentTime )
VALUES (@charId, @objId, @itemId, @count, 0, 'INVENTORY', '0', '0', '0', null, '0','0','-1','0' );