Adding items to a merchant

[vindr3d]

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.9-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use peq
Database changed
MariaDB [peq]> SELECT * FROM `merchantlist` WHERE `merchantid` = '189528';
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
| merchantid | slot | item | faction_required | level_required | alt_currency_c
ost | classes_required | probability |
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
| 189528 | 2 | 8495 | -100 | 0 |
0 | 65535 | 100 |
| 189528 | 3 | 8496 | -100 | 0 |
0 | 65535 | 100 |
| 189528 | 4 | 20542 | -100 | 0 |
0 | 65535 | 100 |
+------------+------+-------+------------------+----------------+---------------
----+------------------+-------------+
3 rows in set (0.00 sec)

MariaDB [peq]>


MariaDB [peq]> SELECT * FROM `npc_types` WHERE `merchant_id` = '189528';
Empty set (0.10 sec)

MariaDB [peq]>



The second query I guess is the problem?




EDIT: I just found the problem. In npc_types table, the merchant ID was different than what I had set it to for the actual ID in the merchantlist table. I changed it to 189528 and then loaded the server. The 3 epics I set the NPC to sell showed up.

Thank you for the help cause without your posts, I wouldn't of even looked at it this much farther.

THANK YOU THANK YOU!!