cron_functions.php

<?php

/*

	ent-ghost
	Copyright [2011-2013] [Jack Lu]

	This file is part of the ent-ghost source code.

	ent-ghost is free software: you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation, either version 3 of the License, or
	(at your option) any later version.

	ent-ghost source code is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with ent-ghost source code. If not, see <http://www.gnu.org/licenses/>.

	ent-ghost is modified from GHost++ (http://ghostplusplus.googlecode.com/)
	GHost++ is Copyright [2008] [Trevor Hogan]

*/

# this file contains a list of cron functions that you may wish to use on your database
# you must provide each function with a mysqli database link from an external cron script
# note that this script ONLY DEFINES FUNCTIONS, and requires an external script to function

function escape($link, $str) {
	return $link->escape_string($str);
}

# updateBan will update your ban cache
# the ban cache is used so that host bots can quickly synchronize with the master ban list
#  without wasting bandwidth on bans that they already have
# 'ttr.cloud' indicates a contextless ban, meaning that it applies globally
#  non-blank contexts indicate bans pertaining to a specific game owner
function updateBan($link) {
	# fix context for odd bans
	$link->query("UPDATE bans SET context = 'ttr.cloud' WHERE context = '' OR context IS NULL");
	
	# add unrecorded bans to the ban history, but only 1000 at a time
	$result = $link->query("SELECT id, server, name, ip, date, gamename, admin, reason, expiredate, botid FROM bans WHERE id > ( SELECT IFNULL(MAX(banid), 0) FROM ban_history ) AND context = 'ttr.cloud' ORDER BY id LIMIT 1000");

	while($result && $row = $result->fetch_array()) {
		$id = escape($link, $row[0]);
		$server = escape($link, $row[1]);
		$name = escape($link, $row[2]);
		$ip = escape($link, $row[3]);
		$date = escape($link, $row[4]);
		$gamename = escape($link, $row[5]);
		$admin = escape($link, $row[6]);
		$reason = escape($link, $row[7]);
		$expiredate = escape($link, $row[8]);
		$botid = escape($link, $row[9]);
		
		# insert into history table
		$link->query("INSERT INTO ban_history ( banid, server, name, ip, date, gamename, admin, reason, expiredate ) VALUES ('$id', '$server', '$name', '$ip', '$date', '$gamename', '$admin', '$reason', '$expiredate')");
		
		# put banid in ban cache so that bots can update to it
		$link->query("INSERT INTO bancache (banid, datetime, status) VALUES ('$id', NOW(), 0)"); # 0 means new ban, 1 means del ban
	}

	# update cache to reflect deleted bans
	$result = $link->query("UPDATE bancache SET status = '1', datetime = NOW() WHERE status = '0' AND (SELECT COUNT(*) FROM bans WHERE bans.id = banid) = 0");
}

# this will update the gametrack table
# the table keeps track of total games played, stay percentage, and other data
function gameTrack($link, $next_player) {
	# track last bots that player used
	
	# create table if not already there
	$link->query("
CREATE TABLE IF NOT EXISTS `gametrack` (
  `name` varchar(15) DEFAULT NULL,
  `realm` varchar(100) DEFAULT NULL,
  `bots` varchar(40) DEFAULT NULL,
  `lastgames` varchar(100) DEFAULT NULL,
  `total_leftpercent` double DEFAULT NULL,
  `num_leftpercent` int(11) DEFAULT NULL,
  `num_games` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_active` datetime DEFAULT NULL,
  `playingtime` INT DEFAULT NULL,
  KEY `name` (`name`),
  KEY `realm` (`realm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	
	# get the next 5000 players
	$result = $link->query("SELECT gameplayers.botid, name, spoofedrealm, gameid, gameplayers.id, (`left`/duration), duration FROM gameplayers LEFT JOIN games ON games.id = gameid WHERE gameplayers.id >= '$next_player' ORDER BY gameplayers.id LIMIT 5000");

	while($result && $row = $result->fetch_array()) {
		$botid = intval($row[0]);
		$name = escape($link, $row[1]);
		$realm = escape($link, $row[2]);
		$gameid = escape($link, $row[3]);
		$leftpercent = escape($link, $row[5]);
		$duration = escape($link, $row[6]);
	
		# see if this player already has an entry, and retrieve if there is
		$checkResult = $link->query("SELECT bots, lastgames FROM gametrack WHERE name = '$name' AND realm = '$realm'");
		
		if($checkResult && $checkRow = $checkResult->fetch_array()) {
			# update bots and lastgames shifting-window arrays
			$bots = explode(',', $checkRow[0]);
			$lastgames = explode(',', $checkRow[1]);
		
			if(in_array($botid, $bots)) {
				$bots = array_diff($bots, array($botid));
			}
		
			$bots[] = $botid;
			$lastgames[] = $gameid;
		
			if(count($bots) > 10) {
				array_shift($bots);
			}
		
			if(count($lastgames) > 10) {
				array_shift($lastgames);
			}
		
			$botString = escape($link, implode(',', $bots));
			$lastString = escape($link, implode(',', $lastgames));
			$link->query("UPDATE gametrack SET bots = '$botString', lastgames = '$lastString', total_leftpercent = total_leftpercent + '$leftpercent', num_leftpercent = num_leftpercent + 1, num_games = num_games + 1, time_active = NOW(), playingtime = playingtime + '$duration' WHERE name = '$name' AND realm = '$realm'");
		} else {
			$botString = escape($link, $botid);
			$lastString = escape($link, $gameid);
			$link->query("INSERT INTO gametrack (name, realm, bots, lastgames, total_leftpercent, num_leftpercent, num_games, time_created, time_active, playingtime) VALUES ('$name', '$realm', '$botString', '$lastString', '$leftpercent', '1', '1', NOW(), NOW(), '$duration')");
		}
	
		$next_player = $row[4] + 1;
	}
	
	return $next_player;
}

?>