m (Protected "Template:Person" ([Edit=Allow only administrators] (indefinite))) |
mNo edit summary |
||
(24 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 199: | Line 211: | ||
{{Privileged}} | {{Privileged}} | ||
{| style="width:100%;" | |||
|- | |||
! Date | |||
! Event | |||
! Role | |||
! style="width:50%;" | Notes | |||
|- | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=EventAttendees,Events | tables=EventAttendees,Events | ||
|fields=Date,Events._pageName=Event,Role,Notes | |fields=Date,Events._pageName=Event,Role,Notes | ||
|where=Name="{{FULLPAGENAME}}" | |where=Name="{{FULLPAGENAME}}" | ||
|format= | |format=template | ||
|order by=Date DESC | |order by=Date DESC | ||
|join on=Events._pageName=EventAttendees._pageName | |join on=Events._pageName=EventAttendees._pageName | ||
|template=Person/Event | |||
|named args=yes | |||
}} | |||
|} | |||
</div> | |||
</div> | |||
=Activity= | |||
<div class="mw-collapsible"> | |||
{{OOC}} | |||
{{#get_db_data: | |||
db=helix | |||
|from=ix_sessions | |||
|order by=start_time DESC | |||
|data=start_time=FROM_UNIXTIME(start_time), end=FROM_UNIXTIME(end_time), map, messagesSent, messagesReceived, dmgReceived, dmgGiven, ffReceived, ffGiven | |||
|where=character_id={{{ID}}} | |||
}} | }} | ||
{| style="width:100%" | |||
|- | |||
! Start Date | |||
! End Date | |||
! Map | |||
! Messages (Recv/Sent) | |||
! Damage (Given/Taken) | |||
! Friendly Fire (Given/Taken) | |||
|- | |||
{{#for_external_table:| | |||
{{!}} {{{start_time}}} | |||
{{!}} {{{end|Ongoing}}} | |||
{{!}} {{{map}}} | |||
{{!}} {{{messagesReceived|0}}}/{{{messagesSent|0}}} | |||
{{!}} {{{dmgGiven|0}}}/{{{dmgTaken|0}}} | |||
{{!}} {{{ffReceived|0}|}}}/{{{ffGiven|0}}} | |||
{{!}}- | |||
}} | |||
|} | |||
</div> | </div> | ||
[[Category:People]]</includeonly> | [[Category:People]] | ||
{{#ifeq:{{{STATUS}}}|KIA|[[Category:KIA|}}</includeonly> |
Latest revision as of 20:29, 20 December 2022
This template defines the table "People". View table.
Categories:
No categories