mNo edit summary Tag: Reverted |
mNo edit summary |
||
| (21 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude> | |||
{{#cargo_declare:_table=People|ID=Number|Name=String|Image=File|Rank=String|Homeworld=Page|Division=String|Sex=String|Location=Page}} | |||
</noinclude> | |||
<includeonly>{{#if:{{{ID}}}|{{#get_db_data: | <includeonly>{{#if:{{{ID}}}|{{#get_db_data: | ||
db=helix | db=helix | ||
|from=wiki_characters | |from=wiki_characters | ||
|order by=last_join_time DESC | |order by=last_join_time DESC | ||
|data=name=name, faction=faction, rank=rank, last_join=last_join,description=description | |data=name=name, faction=faction, rank=rank, last_join=last_join,description=description,steamid=steamid | ||
|limit=1 | |limit=1 | ||
|where=id={{{ID}}} | |where=id={{{ID}}} | ||
}}}} | }}}} | ||
{{#cargo_store:_table=People | |||
|ID={{{ID|}}} | |||
|Name={{{NAME}}} | |||
|Image={{{IMAGE|}}} | |||
|Rank={{Rank|{{#external_value:rank}}}} | |||
|Homeworld={{{HOMEWORLD}}} | |||
|Sex={{{SEX}}} | |||
|Location={{{LOCATION}}} | |||
}} | |||
<div class="buttonPane" style="float:right; width:50%; background-color:#334; padding:1em; text-align:center;"> | <div class="buttonPane" style="float:right; width:50%; background-color:#334; padding:1em; text-align:center;"> | ||
<b>Quick Actions</b> | <b>Quick Actions</b> | ||
| Line 38: | Line 50: | ||
|- | |- | ||
! colspan="1" |NAME(S) | ! colspan="1" |NAME(S) | ||
| colspan="5" |{{{NAME|{{#external_value:name}}}}} | | colspan="5" |{{{NAME|{{#external_value:name}}}}} ([http://steamcommunity.com/profiles/{{#external_value:steamid}} Steam Profile]) | ||
|- | |- | ||
! SEX | ! SEX | ||
| Line 81: | Line 93: | ||
| {{{ENLISTMENT_DATE}}} | | {{{ENLISTMENT_DATE}}} | ||
! LAST ACTIVE | ! LAST ACTIVE | ||
| {{{LAST_ACTIVE|{{#external_value:last_join}}}}} | | {{Date|{{{LAST_ACTIVE|{{#external_value:last_join}}}}}}} | ||
! STATUS | ! STATUS | ||
| {{{STATUS}}} | | {{{STATUS}}} | ||
| Line 198: | Line 210: | ||
<div class="mw-collapsible"> | <div class="mw-collapsible"> | ||
{{Privileged}} | {{Privileged}} | ||
{| style="width:100%;" | |||
|- | |||
! Date | |||
! Event | |||
! Role | |||
! style="width:50%;" | Notes | |||
|- | |||
{{#cargo_query: | |||
tables=EventAttendees,Events | |||
|fields=Date,Events._pageName=Event,Role,Notes | |||
|where=Name="{{FULLPAGENAME}}" | |||
|format=template | |||
|order by=Date DESC | |||
|join on=Events._pageName=EventAttendees._pageName | |||
|template=Person/Event | |||
|named args=yes | |||
}} | |||
|} | |||
</div> | |||
</div> | |||
=Activity= | |||
<div class="mw-collapsible"> | |||
{{OOC}} | |||
{{#get_db_data: | {{#get_db_data: | ||
| Line 203: | Line 242: | ||
|from=ix_sessions | |from=ix_sessions | ||
|order by=start_time DESC | |order by=start_time DESC | ||
|data=start_time=FROM_UNIXTIME(start_time), end=FROM_UNIXTIME(end_time), map | |data=start_time=FROM_UNIXTIME(start_time), end=FROM_UNIXTIME(end_time), map, messagesSent, messagesReceived, dmgReceived, dmgGiven, ffReceived, ffGiven | ||
|where=character_id={{{ID}}} | |where=character_id={{{ID}}} | ||
}} | }} | ||
{| | {| style="width:100%" | ||
|- | |- | ||
! Start Date | ! Start Date | ||
! End Date | ! End Date | ||
! Map | ! Map | ||
! Messages (Recv/Sent) | |||
! Damage (Given/Taken) | |||
! Friendly Fire (Given/Taken) | |||
|- | |- | ||
{{#for_external_table:| | {{#for_external_table:| | ||
{{!}} {{{start_time}}} | {{!}} {{{start_time}}} | ||
{{!}} {{{end}}} | {{!}} {{{end|Ongoing}}} | ||
{{!}} {{{map}}} | {{!}} {{{map}}} | ||
{{!}} {{{messagesReceived|0}}}/{{{messagesSent|0}}} | |||
{{!}} {{{dmgGiven|0}}}/{{{dmgTaken|0}}} | |||
{{!}} {{{ffReceived|0}|}}}/{{{ffGiven|0}}} | |||
{{!}}- | {{!}}- | ||
}} | }} | ||
|} | |} | ||
</div> | |||
[[Category:People]] | |||
{{#ifeq:{{{STATUS}}}|KIA|[[Category:KIA|}}</includeonly> | |||
[[Category: | |||
Latest revision as of 20:29, 20 December 2022
This template defines the table "People". View table.
Categories:
No categories
