EQEmulator Forums - Populate Goallist for all npc in zone (sql expression)

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Populate Goallist for all npc in zone (sql expression) (https://www.eqemulator.org/forums/showthread.php?t=39168)

Populate Goallist for all npc in zone (sql expression)

Hi,

I was trying to figure out this sql expression and figured someone else might find it useful in the future.

I am trying to create an expression where i can type in goallist say 997 and have it fill all mobs in a zone, say "kurn's tower".

The first and last lines work its the middle section of inserting 997 as the listid and then pulling the npc_type.id via the inner join.

Code:

INSERT INTO goallists(listid, entry)

VALUES (997, SELECT id

FROM npc_types 

INNER JOIN spawnentry ON npc_types.id = spawnentry.npcID AND spawnentry.spawngroupID = spawn2.spawngroupID)

WHERE spawn2.zone = 'kurn'

You must not have noticed, but I have had to move every one of your support posts into the Windows Servers support section of the forums. General Support is for players, not dev or server-owner issues unless they are client related.

If you read the descriptions for the forum sections, it should help to understand what should be posted where:

Support::General Support
Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Support::Windows Servers
Support forum for Windows EQEMu users.

This is for both you (to get answers from people reading the server support section) as well as for other members (to find relevant information when searching the forum sections). There are a ton of posts on these forums so it helps to keep it organized.

Quote:

Originally Posted by trevius (Post 236456)

Sorry I will post in Windows Server support when it comes to the server, I thought the general support was non OS specific was all.