https://wiki.projectskyfire.org/index.php?action=history&feed=atom&title=Guild_eventlog_SF Guild eventlog SF - Revision history 2026-05-03T21:34:25Z Revision history for this page on the wiki MediaWiki 1.45.3 https://wiki.projectskyfire.org/index.php?title=Guild_eventlog_SF&diff=475&oldid=prev Cheapgamer: Created page with "{| align="right" | __TOC__ |} Category: SkyFire Characters database tables {{Back-to:Characters}} <big>'''The `guild_eventlog` table'''</big> {{table-no-description}} ..." 2012-07-06T20:04:00Z <p>Created page with &quot;{| align=&quot;right&quot; | __TOC__ |} <a href="/index.php?title=Category:SkyFire_Characters_database_tables&amp;action=edit&amp;redlink=1" class="new" title="Category:SkyFire Characters database tables (page does not exist)">Category: SkyFire Characters database tables</a> {{Back-to:Characters}} &lt;big&gt;&#039;&#039;&#039;The `guild_eventlog` table&#039;&#039;&#039;&lt;/big&gt; {{table-no-description}} ...&quot;</p> <p><b>New page</b></p><div>{| align=&quot;right&quot;<br /> | __TOC__<br /> |}<br /> [[Category: SkyFire Characters database tables]]<br /> {{Back-to:Characters}}<br /> <br /> <br /> &lt;big&gt;&#039;&#039;&#039;The `guild_eventlog` table&#039;&#039;&#039;&lt;/big&gt;<br /> <br /> {{table-no-description}}<br /> <br /> <br /> &lt;big&gt;&#039;&#039;&#039;Structure&#039;&#039;&#039;&lt;/big&gt;<br /> {| border=&quot;1&quot;<br /> |&#039;&#039;&#039;Field&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Type&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Attributes&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Key&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Null&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Default&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Extra&#039;&#039;&#039;<br /> |&#039;&#039;&#039;Comment&#039;&#039;&#039;<br /> |-<br /> |[[#guildid|guildid]]<br /> |int(11)<br /> |signed<br /> |PRI<br /> |NO<br /> |NULL<br /> |<br /> |Guild Identificator<br /> |-<br /> |[[#LogGuid|LogGuid]]<br /> |int(11)<br /> |signed<br /> |PRI<br /> |NO<br /> |NULL<br /> |<br /> |Log record identificator - auxiliary column<br /> |-<br /> |[[#EventType|EventType]]<br /> |tinyint(1)<br /> |signed<br /> |<br /> |NO<br /> |NULL<br /> |<br /> |Event type<br /> |-<br /> |[[#PlayerGuid1|PlayerGuid1]]<br /> |int(11)<br /> |signed<br /> |<br /> |NO<br /> |NULL<br /> |<br /> |Player 1<br /> |-<br /> |[[#PlayerGuid2|PlayerGuid2]]<br /> |int(11)<br /> |signed<br /> |<br /> |NO<br /> |NULL<br /> |<br /> |Player 2<br /> |-<br /> |[[#NewRank|NewRank]]<br /> |tinyint(2)<br /> |signed<br /> |<br /> |NO<br /> |NULL<br /> |<br /> |New rank(in case promotion/demotion)<br /> |-<br /> |[[#TimeStamp|TimeStamp]]<br /> |bigint(20)<br /> |signed<br /> |<br /> |NO<br /> |NULL<br /> |<br /> |Event UNIX time<br /> |}<br /> <br /> <br /> &lt;big&gt;&#039;&#039;&#039;Description of the fields&#039;&#039;&#039;&lt;/big&gt;<br /> ====guildid====<br /> {{field-no-description|1}}<br /> ====LogGuid====<br /> {{field-no-description|2}}<br /> ====EventType====<br /> {{field-no-description|3}}<br /> ====PlayerGuid1====<br /> {{field-no-description|4}}<br /> ====PlayerGuid2====<br /> {{field-no-description|5}}<br /> ====NewRank====<br /> {{field-no-description|6}}<br /> ====TimeStamp====<br /> {{field-no-description|7}}</div> Cheapgamer