View Single Post
  #9  
Old 05-19-2021, 03:49 PM
Barm McLir Barm McLir is offline
Kobold

Barm McLir's Avatar

Join Date: Mar 2016
Posts: 140
Default

Quote:
Originally Posted by BlackBellamy [You must be logged in to view images. Log in or Register.]
If the issue was caused by a mob, I suspect that the other entries would display until they got to that mob then they would be blank or malformed. Unless the first mob pulled in was the problem...
I'd guess that the PHP code for the Wiki page contains an initial SQL call to get the list of NPCs;

Code:
SELECT name FROM npc_table WHERE zone CONTAINS "Permafrost";
To get a list of NPCs. Then the list of names is looped through and for each do an SQL call like;
Code:
SELECT race, class, level, location, known_loot, description FROM npc_table WHERE name = name LIMIT 1;
This is the one that is failing but the name still prints because it came from the first SQL call.