Template:Person: Difference between revisions

@@ Line 199: / Line 199: @@
 {{Privileged}}
-{{#get_db_data:
+{{#cargo_query:
- db=helix
+tables=EventAttendees,Events
- |from=ix_sessions
+|fields=Date,Events._pageName=Event,Role,Notes
- |order by=start_time DESC
+|where=Name="{{FULLPAGENAME}}"
- |data=start_time=FROM_UNIXTIME(start_time), end=FROM_UNIXTIME(end_time), map
+|format=table
- |where=character_id={{{ID}}}
+|order by=Date DESC
+|join on=Events._pageName=EventAttendees._pageName
 }}
-{|
-|-
-! Start Date
-! End Date
-! Map
-|-
-{{#for_external_table:|
-   {{!}} {{{start_time}}}
-   {{!}} {{{end|Ongoing}}}
-   {{!}} {{{map}}}
-   {{!}}-
-}}
-|}
 </div>
 [[Category:People]]</includeonly>

Revision as of 21:40, 9 December 2022