PHP insertEventsの例

コード例 #1

ファイル: playerhistory.php プロジェクト: PitbullOL/insurgency-hlstatsx

}
insertEvents('Connects', "\r\n\t\tSELECT\r\n\t\t\t'Connect',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I connected to the server'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('Disconnects', "\r\n\t\tSELECT\r\n\t\t\t'Disconnect',\r\n\t\t\t<table>.eventTime,\r\n\t\t\t'I left the game',\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('Entries', "\r\n\t\tSELECT\r\n\t\t\t'Entry',\r\n\t\t\t<table>.eventTime,\r\n\t\t\t'I entered the game',\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('Frags', "\r\n\t\tSELECT\r\n\t\t\t'Kill',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I killed %A%{$surl}?mode=playerinfo&player=', victimId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%', ' with ', weapon),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.victimId\r\n\t\tWHERE\r\n\t\t\t<table>.killerId = {$player}\r\n\t\t\tAND <table>.headshot = 0\r\n\t");
insertEvents('Frags', "\r\n\t\tSELECT\r\n\t\t\t'Kill',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I killed %A%{$surl}?mode=playerinfo&player=', victimId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%', ' with a headshot from ', weapon),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.victimId\r\n\t\tWHERE\r\n\t\t\t<table>.killerId = {$player}\r\n\t\t\tAND <table>.headshot = 1\r\n\t");
insertEvents('Frags', "\r\n\t\tSELECT\r\n\t\t\t'Death',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('%A%{$surl}?mode=playerinfo&player=', killerId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%', ' killed me with ', weapon),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.killerId\r\n\t\tWHERE\r\n\t\t\t<table>.victimId = {$player}\r\n\t");
insertEvents('Teamkills', "\r\n\t\tSELECT\r\n\t\t\t'Team Kill',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I killed teammate %A%{$surl}?mode=playerinfo&player=', victimId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%', ' with ', weapon),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.victimId\r\n\t\tWHERE\r\n\t\t\t<table>.killerId = {$player}\r\n\t");
insertEvents('Teamkills', "\r\n\t\tSELECT\r\n\t\t\t'Friendly Fire',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('My teammate %A%{$surl}?mode=playerinfo&player=', killerId, '%', IFNULL(hlstats_Players.lastName, 'Unknown'), '%/A%', ' killed me with ', weapon),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.killerId\r\n\t\tWHERE\r\n\t\t\t<table>.victimId = {$player}\r\n\t");
insertEvents('ChangeRole', "\r\n\t\tSELECT\r\n\t\t\t'Role',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I changed role to ', role),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('ChangeName', "\r\n\t\tSELECT\r\n\t\t\t'Name',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I changed my name from \"', oldName, '\" to \"', newName, '\"'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('PlayerActions', "\r\n\t\tSELECT\r\n\t\t\t'Action',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I received a points bonus of ', bonus, ' for triggering \"', IFNULL(hlstats_Actions.description,'Unknown'), '\"'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Actions\r\n\t\tON\r\n\t\t\thlstats_Actions.id = <table>.actionId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t\tAND\r\n\t\t\thlstats_Actions.game = '{$game}'\r\n\t");
insertEvents('PlayerPlayerActions', "\r\n\t\tSELECT\r\n\t\t\t'Action',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I received a points bonus of ', bonus, ' for triggering \"', IFNULL(hlstats_Actions.description,'Unknown'), '\" against %A%{$surl}?mode=playerinfo&player=', victimId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Actions\r\n\t\tON\r\n\t\t\thlstats_Actions.id = <table>.actionId\r\n\t\tLEFT JOIN hlstats_Players ON\r\n\t\t\thlstats_Players.playerId = <table>.victimId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t\tAND\r\n\t\t\thlstats_Actions.game = '{$game}'\r\n\t");
insertEvents('PlayerPlayerActions', "\r\n\t\tSELECT\r\n\t\t\t'Action',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('%A%{$surl}?mode=playerinfo&player=', <table>.playerId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A% triggered \"', IFNULL(hlstats_Actions.description,'Unknown'), '\" against me'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Actions\r\n\t\tON\r\n\t\t\thlstats_Actions.id = <table>.actionId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Players\r\n\t\tON\r\n\t\t\thlstats_Players.playerId = <table>.playerId\r\n\t\tWHERE\r\n\t\t\t<table>.victimId = {$player}\r\n\t\tAND\r\n\t\t\thlstats_Actions.game = '{$game}'\r\n\t");
insertEvents('Suicides', "\r\n\t\tSELECT\r\n\t\t\t'Suicide',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('I committed suicide with \"', weapon, '\"'),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t");
insertEvents('ChangeTeam', "\r\n\t\tSELECT\r\n\t\t\t'Team',\r\n\t\t\t<table>.eventTime,\r\n\t\t\tIF(hlstats_Teams.name IS NULL, CONCAT('I joined team \"', team, '\"'), CONCAT('I joined team \"', team, '\" (', hlstats_Teams.name, ')')),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Servers\r\n\t\tON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t\tLEFT JOIN\r\n\t\t\thlstats_Teams\r\n\t\tON\r\n\t\t\thlstats_Teams.code = <table>.team\r\n\t\tWHERE\r\n\t\t\t<table>.playerId = {$player}\r\n\t\tAND\r\n\t\t\thlstats_Teams.game = '{$game}'\r\n\t");
$result = $db->query("\r\n\t\tSELECT\r\n\t\t\thlstats_EventHistory.eventTime,\r\n\t\t\thlstats_EventHistory.eventType,\r\n\t\t\thlstats_EventHistory.eventDesc,\r\n\t\t\thlstats_EventHistory.serverName,\r\n\t\t\thlstats_EventHistory.map\r\n\t\tFROM\r\n\t\t\thlstats_EventHistory\r\n\t\tORDER BY\r\n\t\t\t{$table->sort} {$table->sortorder},\r\n\t\t\t{$table->sort2} {$table->sortorder}\r\n\t\tLIMIT\r\n\t\t\t{$table->startitem},\r\n\t\t\t{$table->numperpage}\r\n\t");
$resultCount = $db->query("\r\n\t\tSELECT\r\n\t\t\tCOUNT(*)\r\n\t\tFROM\r\n\t\t\thlstats_EventHistory\r\n\t");
list($numitems) = $db->fetch_row($resultCount);
?>

<div class="block">
<?php 
printSectionTitle('Player Event History (Last ' . $g_options['DeleteDays'] . ' Days)');
if ($numitems > 0) {
    $table->draw($result, $numitems, 95);
}
?>
<br /><br />
	<div class="subblock">
		<div style="float:right;">

コード例 #2

ファイル: tools_adminevents.php プロジェクト: PitbullOL/insurgency-hlstatsx

echo $g_options["DeleteDays"];
?>
 Days)<p>

<?php 
$table = new Table(array(new TableColumn("eventTime", "Date", "width=20"), new TableColumn("eventType", "Type", "width=10&align=center"), new TableColumn("eventDesc", "Description", "width=40&sort=no&append=.&embedlink=yes"), new TableColumn("serverName", "Server", "width=20"), new TableColumn("map", "Map", "width=10")), "eventTime", "eventTime", "eventType", false, 50, "page", "sort", "sortorder");
$db->query("DROP TABLE IF EXISTS hlstats_AdminEventHistory");
$db->query("\r\n\t\tCREATE TEMPORARY TABLE hlstats_AdminEventHistory\r\n\t\t(\r\n\t\t\teventType VARCHAR(64) NOT NULL,\r\n\t\t\teventTime DATETIME NOT NULL,\r\n\t\t\teventDesc VARCHAR(255) NOT NULL,\r\n\t\t\tserverName VARCHAR(255) NOT NULL,\r\n\t\t\tmap VARCHAR(64) NOT NULL\r\n\t\t) DEFAULT CHARSET=utf8\r\n\t");
function insertEvents($table, $select)
{
    global $db;
    $select = str_replace("<table>", "hlstats_Events_{$table}", $select);
    $db->query("\r\n\t\t\tINSERT INTO\r\n\t\t\t\thlstats_AdminEventHistory\r\n\t\t\t\t(\r\n\t\t\t\t\teventType,\r\n\t\t\t\t\teventTime,\r\n\t\t\t\t\teventDesc,\r\n\t\t\t\t\tserverName,\r\n\t\t\t\t\tmap\r\n\t\t\t\t)\r\n\t\t\t{$select}\r\n\t\t");
}
insertEvents("Rcon", "\r\n\t\tSELECT\r\n\t\t\tCONCAT(<table>.type, ' Rcon'),\r\n\t\t\t<table>.eventTime,\r\n\t\t\tCONCAT('\"', command, '\"\nFrom: %A%" . $g_options['scripturl'] . "?mode=search&q=', remoteIp, '&st=ip&game=%', remoteIp, '%/A%', IF(password<>'',CONCAT(', password: \"', password, '\"'),'')),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN hlstats_Servers ON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t");
insertEvents("Admin", "\r\n\t\tSELECT\r\n\t\t\t<table>.type,\r\n\t\t\t<table>.eventTime,\r\n\t\t\tIF(playerName != '',\r\n\t\t\t\tCONCAT('\"', playerName, '\": ', message),\r\n\t\t\t\tmessage\r\n\t\t\t),\r\n\t\t\tIFNULL(hlstats_Servers.name, 'Unknown'),\r\n\t\t\t<table>.map\r\n\t\tFROM\r\n\t\t\t<table>\r\n\t\tLEFT JOIN hlstats_Servers ON\r\n\t\t\thlstats_Servers.serverId = <table>.serverId\r\n\t");
if (isset($_GET['type']) && $_GET['type'] != '') {
    $where = "WHERE eventType='" . $db->escape($_GET['type']) . "'";
} else {
    $where = "";
}
$result = $db->query("\r\n\t\tSELECT\r\n\t\t\teventTime,\r\n\t\t\teventType,\r\n\t\t\teventDesc,\r\n\t\t\tserverName,\r\n\t\t\tmap\r\n\t\tFROM\r\n\t\t\thlstats_AdminEventHistory\r\n\t\t{$where}\r\n\t\tORDER BY\r\n\t\t\t{$table->sort} {$table->sortorder},\r\n\t\t\t{$table->sort2} {$table->sortorder}\r\n\t\tLIMIT\r\n\t\t\t{$table->startitem},{$table->numperpage}\r\n\t");
$resultCount = $db->query("\r\n\t\tSELECT\r\n\t\t\tCOUNT(*)\r\n\t\tFROM\r\n\t\t\thlstats_AdminEventHistory\r\n\t\t{$where}\r\n\t");
list($numitems) = $db->fetch_row($resultCount);
?>
<form method="get" action="<?php 
echo $g_options["scripturl"];
?>
">
<input type="hidden" name="mode" value="admin" />
<input type="hidden" name="task" value="<?php