The Reserve: Difference between revisions

Revision as of 05:29, 10 July 2025

Image	Item	Quantity	Take
	fuel	10	Yes

No results

No results

Error: the string ";" cannot be used within #cargo_query.

@@ Line 31: / Line 31: @@
 }}
-<noinclude>{{Documentation|Query to list NPC-rooms and their NPCs on a Location page}}</noinclude>
+<noinclude>{{Documentation|List all NPC-rooms on a Location page, with their NPCs}}</noinclude>
 {{#cargo_query:
-  tables = NpcRooms, RoomNpcs
+  tables = NpcRooms
-  join_on = NpcRooms.Codename = RoomNpcs.JobCodename
+  where  = Location = "{{FULLPAGENAME}}"
-  where = NpcRooms.Location = "loc_the_reserve"
   fields =
-    NpcRooms.Name        = Room,
+    Name         = Room,
-    NpcRooms.WaitTime    = WaitTime,
+    WaitTime,
-    NpcRooms.RespawnTime = RespawnTime,
+    RespawnTime
-   RoomNpcs.Codename    = NPC,
+  format   = template
-   RoomNpcs.Level       = Level
+  template =
-  format = csv
+  * '''{{{Room}}}''' (wait: {{{WaitTime}}} s; respawn: {{{RespawnTime}}} s):
-  |-
- Room || WaitTime || RespawnTime || NPC || Level
- |-
- {{{#each:Row|
-  * '''{{{Room}}}''' (wait: {{{WaitTime}}} s, respawn: {{{RespawnTime}}} s):
     {{#cargo_query:
-    tables = RoomNpcs
+     tables = RoomNpcs
-    where = JobCodename = "{{{Room|encode=uri}}}"
+     where  = JobCodename = "{{{Room|encode=uri}}}"
-    fields = Codename = NPC, Level
+     fields = Codename, Level
-    format = ul
+     format = ul
     }}
-}}}
+}}
-}}
 <!-- ZC_CP_Autogen_End -->