<?php
class ServerClass {
var $server_conn;
function load_server_db($db) {
$this->server_conn = mysql_connect($db['host'], $db['user'], $db['pass'], "SET NAMES 'utf8'") or die ("Unable to connect!");
mysql_select_db('pugbot', $this->server_conn) or die ("Unable to select database! LANG");
$utf8 = mysql_query("SET NAMES UTF8");
return $this->server_conn;
}
public function load_servers() {
$query = mysql_query("SELECT * FROM `servers` WHERE `status`!='RCONFAIL'", $this->server_conn);
$server_a = array();
while ($server = mysql_fetch_array($query)) {
$server_a[] = $server;
}
return $server_a;
}
public function load_banner_server($server_addy, $server_port) {
$query = mysql_query("SELECT * FROM `servers` WHERE `host`='$server_addy' AND `port`='$server_port'", $this->server_conn);
$server = mysql_fetch_array($query);
$server_a = array();
$server_a['sv_id'] = $server['server_id'];
$server_a['name'] = $server['name'];
$server_a['slots'] = $server['slots'];
$server_a['players'] = $server['players'];
$server_a['map'] = $server['current_map'];
$sv_id = $server_a['sv_id'];
$query = mysql_query("SELECT * FROM `tracker_aliases` WHERE `server_id`='$sv_id'", $this->server_conn);
$server_a['num_a'] = mysql_num_rows($query);
return $server_a;
}
public function close_db() {
mysql_close($this->server_conn);
}
public function set_irc_colors($urt_string) {
$urt_string = str_replace("^0",'<font color="black">',$urt_string);
$urt_string = str_replace("^1",'<font color="red">',$urt_string);
$urt_string = str_replace("^2",'<font color="green">',$urt_string);
$urt_string = str_replace("^3",'<font color="yellow">',$urt_string);
$urt_string = str_replace("^4",'<font color="blue">',$urt_string);
$urt_string = str_replace("^5",'<font color="cyan">',$urt_string);
$urt_string = str_replace("^6",'<font color="magenta">',$urt_string);
$urt_string = str_replace("^7",'<font color="white">',$urt_string);
return $urt_string;
}
}
?>
