Thread: Bard Bot Bug
View Single Post
  #8  
Old 04-04-2017, 12:47 AM
Mistmaker's Avatar
Mistmaker
Sarnak
 
Join Date: Feb 2014
Posts: 77
Default

MariaDB [peq]> SELECT `name` FROM `npc_spells` WHERE `id` = '3008';
+----------+
| name |
+----------+
| Bard Bot |
+----------+
1 row in set (0.00 sec)

MariaDB [peq]> SELECT `id` FROM `npc_spells` WHERE `name` = 'Bard Bot';
+------+
| id |
+------+
| 3008 |
+------+
1 row in set (0.00 sec)

MariaDB [peq]> SELECT `spells_id` FROM `bot_data` WHERE `spells_id` < '3001' OR `spells_id` > '3016';
Empty set (0.00 sec)

MariaDB [peq]> SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` < '3001' OR `npc_spells_id` > '3016';
Empty set (0.00 sec)

MariaDB [peq]> SELECT `npc_spells_id` FROM `bot_spells_entries` WHERE `npc_spells_id` = '3008';
+---------------+
| npc_spells_id |
+---------------+
| 3008 |
| 3008 |
<...>
| 3008 |
| 3008 |
+---------------+
2508 rows in set (0.00 sec)

MariaDB [peq]>
__________________
~ Mr. Gold ~ Pillage and Plunder ~

Last edited by Uleat; 04-04-2017 at 12:46 PM.. Reason: truncated for thread readability
Reply With Quote