EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Matching grid zoneID with zone names (https://www.eqemulator.org/forums/showthread.php?t=20896)

Angelox 06-28-2006 12:24 AM

Matching grid zoneID with zone names
 
Is it possible to match "zoneid" number in "grid" and "grid_entries" with the proper zone name? If so how would I do that?

Thanks

GeorgeS 06-28-2006 02:21 AM

SELECT id,type,type2,long_name FROM grid,zone WHERE (grid.zoneid=zone.zoneidnumber)


and then run this

SELECT gridid,number,x,y,z,heading,pause,long_name FROM grid_entries,zone WHERE (grid_entries.zoneid=zone.zoneidnumber)

GeorgeS


All times are GMT -4. The time now is 01:36 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.