MQL запрос

[M1SHA 136]

подскажите sql запрос для добавления итема персонажу 

[l2vote 8]

подскажите sql запрос для добавления итема персонажу 

INSERT* FROM items WHERE item_id=(id итема) AND owner_id=(id чара)    -  попробуйте так

[M1SHA 136]

INSERT* FROM items WHERE item_id=(id итема) AND owner_id=(id чара)    -  попробуйте так

 

[Err] 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 'mysql> INSERT* FROM items WHERE item_id=4037 AND owner_id=268521906

    ->' at line 1

[Err] mysql> INSERT* FROM items WHERE item_id=4037 AND owner_id=268521906

    ->

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[l2vote 8]

 

[Err] 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 'mysql> INSERT* FROM items WHERE item_id=4037 AND owner_id=268521906

    ->' at line 1

[Err] mysql> INSERT* FROM items WHERE item_id=4037 AND owner_id=268521906

    ->

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

INSERT* звездочку уберите

[CalypsoToolz 451]

INSERT INTO `items_table` (`item_id`, `count`, `owner_id`) VALUES ('4037', '10', '268553686');

items_table изменить на свою таблицу, ну и названия поменять, в items не вставлять, ибо нужен obj_id итема, а при случайном значении можно получить различные ошибки. Вставлять в таблицу, которая используется для временного хранения итемов, например награда с топов/донат

[M1SHA 136]

INSERT INTO `items_table` (`item_id`, `count`, `owner_id`) VALUES ('4037', '10', '268553686');

items_table изменить на свою таблицу, ну и названия поменять, в items не вставлять, ибо нужен obj_id итема, а при случайном значении можно получить различные ошибки. Вставлять в таблицу, которая используется для временного хранения итемов, например награда с топов/донат

 

вот такие таблицы есть 

[Detect 618]

ты структуру таблиц выведи, названий мало.

в навакате выбираешь базу данных, жмешь F6  и пишешь:

desc `items`;

[M1SHA 136]

mysql> desc `items`;

+----------------------+-------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

| Field                | Type                                                                                                                          | Null | Key | Default | Extra |

+----------------------+-------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

| object_id            | int(11)                                                                                                                       | NO   | PRI | 0       |       |

| owner_id             | int(11)                                                                                                                       | NO   | MUL | NULL    |       |

| item_id              | smallint(5) unsigned                                                                                                          | NO   | MUL | 0       |       |

| visual_item_id       | smallint(5) unsigned                                                                                                          | NO   |     | 0       |       |

| name                 | varchar(100)                                                                                                                  | YES  |     | NULL    |       |

| count                | bigint(20) unsigned                                                                                                           | NO   |     | 0       |       |

| enchant_level        | smallint(5) unsigned                                                                                                          | NO   |     | 0       |       |

| visual_enchant_level | smallint(6)                                                                                                                   | NO   |     | -1      |       |

| class                | enum('CONSUMABLE','MISC','EQUIPMENT','MATHERIALS','OTHER','PIECES','RECIPIES','SPELLBOOKS')                                   | NO   | MUL | OTHER   |       |

| loc                  | enum('CLANWH','CWH_BACK','FREIGHT','INVENTORY','LEASE','PAPERDOLL','VOID','WAREHOUSE','MONSTER','SELL','PET','PET_PAPERDOLL') | NO   | MUL | NULL    |       |

| loc_data             | int(11)                                                                                                                       | YES  |     | NULL    |       |

| custom_type1         | smallint(5) unsigned                                                                                                          | NO   |     | 0       |       |

| custom_type2         | smallint(5) unsigned                                                                                                          | NO   |     | 0       |       |

| shadow_life_time     | int(11)                                                                                                                       | NO   |     | 0       |       |

| flags                | int(11)                                                                                                                       | NO   |     | 0       |       |

| energy               | int(10) unsigned                                                                                                              | NO   |     | 0       |       |

| temporal             | enum('false','true')                                                                                                          | NO   |     | false   |       |

+----------------------+-------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+

17 rows in set

 

mysql>

[Demoncool 1110]

INSERT INTO `items` VALUES ("object_id", "owner_id", "item_id", "visual_item_id", "name", "count", "enchant_level", "visual_enchant_level", "class", "loc", "loc_data", "custom_type1 ", "custom_type2", "shadow_life_time", "flags ", " energy", "temporal");

Изменено 12 июня, 2016 пользователем Demoncool

[Evolution 243]

INSERT* FROM items WHERE item_id=(id итема) AND owner_id=(id чара)    -  попробуйте так

что это такое,