SQL: Missing Grounds Tome in npc_list.sql

[altalus]

Hello all

I do not currently have access to retail to get the information for the grounds tome and quite a few are missing from the npc_list.sql file. I would need someone to add them to the SQL file:

Code: Select all

SQL to get the list from your database:
========================================================
SELECT zone.zoneid, zone.name,  COUNT(npc.name) AS nbrOfBooks
FROM zone_settings zone
LEFT JOIN npc_list npc
ON zone.zoneid = npc.zoneid
WHERE npc.name LIKE '%grounds%'
GROUP BY zone.zoneid
ORDER BY zone.name ASC

Results from my DB:
========================================================

name							zoneid	name			Books		Wiki	Comment
-----------------------------------	--------	---------------	------	----	--------------------------------------------------------
Bostaunieux_Oubliette				167		Grounds_Tome	3		3
Crawlers_Nest					197		Grounds_Tome	2		2
Dangruf_Wadi					191		Grounds_Tome	2		2
Den_of_Rancor					160		Grounds_Tome	2		?	They do not list any but there is obviously some :)
FeiYin							204		Grounds_Tome	2		2
Garlaige_Citadel					200		Grounds_Tome	3		3
Gusgen_Mines					196		Grounds_Tome	3		3
Gustav_Tunnel					212		Grounds_Tome	4		3	Too many books in the database ??
Ifrits_Cauldron					205		Grounds_Tome	8		5	Too many books in the database ??
Inner_Horutoto_Ruins				192		Grounds_Tome	3		3
King_Ranperres_Tomb				190		Grounds_Tome	4		3 	Too many books in the database ??
Korroloka_Tunnel					173		Grounds_Tome	4		4
Kuftal_Tunnel					174		Grounds_Tome	4		2	Too many books in the database ??
Labyrinth_of_Onzozo				213		Grounds_Tome	3		3
Lower_Delkfutts_Tower				184		Grounds_Tome	3		1	Too many books in the database ??
Maze_of_Shakhrami				198		Grounds_Tome	4		4
Middle_Delkfutts_Tower				157		Grounds_Tome	4		4
Ordelles_Caves					193		Grounds_Tome	2		2
Outer_Horutoto_Ruins				194		Grounds_Tome	4		2	Two books seems to be missing in the DB.
Quicksand_Caves					208		Grounds_Tome	2		5	Three books seems to be missing in the DB.
Ranguemont_Pass					166		Grounds_Tome	3		3
Sea_Serpent_Grotto				176		Grounds_Tome	0		3	All three books are missing in the DB.
Temple_of_Uggalepih				159		Grounds_Tome	4		4
The_Boyahda_Tree				153		Grounds_Tome	4		4	Wiki shows ??? in the list but we seems to have 4/4 :)
The_Eldieme_Necropolis				195		Grounds_Tome	4		3	One book seems missing in the DB.
The_Shrine_of_RuAvitau			178		Grounds_Tome	5		5
Toraimarai_Canal					169		Grounds_Tome	4		4
Upper_Delkfutts_Tower				158		Grounds_Tome	3		2	Too many books in the DB ??
VeLugannon_Palace				177		Grounds_Tome	7		10	Three books seems missing in the DB.
Zeruhn_Mines					172		Grounds_Tome	1		1

So, if someone could double check those that seems to be in problem I would appreciate it

[gedads]

Really sorry far late reply, i'll check areas where we don't match wiki minimum tomes.
For the other where we are exceeding the number indicated, it's more a lack of info from ffxiclopedia or other sites (like planar rifts there are not always all listed on websites) the best solution is to check polutils to see how much of those really are in the area.