function connect_db()
{
# Attemt connect. Return success or fail. Catch exceptions.
// Create connection
//$conn = new mysqli(servername(), username(), password());
$servername = servername();
$username = username();
$password = password();
$dbname = dbname();
//IMPROVE. Perhaps add check to see if we are already connected. Php db ping probably.
try {
$conn = new PDO("mysql:host={$servername};dbname={$dbname}", $username, $password);
} catch (PDOException $e) {
echo $e->getMessage();
exit;
}
return $conn;
}
function server_update_points($server)
{
global $no_ranking_clusters;
mysql_select_db(dbname($server));
file_put('data/calc-stat.dat', 'Berechnung von Server $server ...');
ignore_user_abort(0);
$clusters = array();
// Alle Datensätze zurcksetzen,
// damit es bei herrenlosen PCs keine falschen Anzeigen gibt:
#db_query('UPDATE pcs SET owner_name=\'\', owner_points=0, owner_cluster=0, owner_cluster_code=\'\';');
$current = 0;
$u_result = db_query('SELECT * FROM users');
$total = mysql_num_rows($u_result);
while ($user = mysql_fetch_assoc($u_result)) {
$current++;
$upoints = 0;
if ($current % 100 == 0) {
file_put('data/calc-stat.dat', 'Berechnung von Server ' . $server . ' ... ' . $current . ' / ' . $total);
}
$pc_result = db_query('SELECT * FROM pcs WHERE owner=\'' . mysql_escape_string($user['id']) . '\';');
$pc_cnt = mysql_num_rows($pc_result);
while ($pc = mysql_fetch_assoc($pc_result)) {
processupgrades($pc);
$pcpoints = getpcpoints($pc, 'bydata');
db_query('UPDATE pcs SET points=\'' . mysql_escape_string($pcpoints) . '\' WHERE id=\'' . mysql_escape_string($pc['id']) . '\';');
$upoints += $pcpoints;
}
#reset($pcs);
#foreach($pcs As $pcid):
#$sql='UPDATE pcs SET owner_points=$upoints,owner_name=\''.mysql_escape_string($user['name']).'\' ';
#$cluster=getcluster($user['cluster']);
#if($cluster!==false) {
# $sql.=',owner_cluster='.mysql_escape_string($cluster['id']).', owner_cluster_code=\''.mysql_escape_string($cluster['code']).'\' ';
#}
#$sql.='WHERE id=\''.mysql_escape_string($pcid).'\'';
#db_query($sql);
#endforeach;
$c = $user['cluster'];
if ($c != '' && $c != 0) {
#$r=db_query('SELECT id FROM clusters WHERE id=\''.mysql_escape_string($c).'\' LIMIT 1');
#if(mysql_num_rows($r)>0) {
$clusters['c' . $c]['points'] += $upoints;
$clusters['c' . $c]['members'] += 1;
$clusters['c' . $c]['pcs'] += $pc_cnt;
#}
}
if (is_noranKINGuser($user['id']) == false && $user['id'] != 6249 && $user['id'] != 19061) {
$rank[$user['id'] . ';' . $user['name'] . ';' . $user['cluster']] = $upoints;
} else {
db_query('UPDATE users SET points=\'' . mysql_escape_string($upoints) . '\',rank=\'0\' WHERE id=\'' . mysql_escape_string($user['id']) . '\';');
}
}
#$pcinfo=gettableinfo('pcs',dbname($server));
#file_put('data/_server'.$server.'/pc-count.dat', $pcinfo['Rows']);
file_put('data/_server' . $server . '/user-count.dat', mysql_num_rows($u_result));
ignore_user_abort(0);
file_put('data/calc-stat.dat', 'Berechnung von Server ' . $server . ' ... Berechnung abgeschlossen: Schreiben in DB ...');
arsort($rank);
db_query('TRUNCATE TABLE rank_users');
# Tabelle leeren
#$platz=0;
while (list($dat, $points) = each($rank)) {
#$platz++;
$dat = explode(';', $dat);
$dat[2] = (int) $dat[2];
db_query('INSERT INTO rank_users VALUES(0, ' . mysql_escape_string($dat[0]) . ', \'' . mysql_escape_string($dat[1]) . '\', ' . mysql_escape_string($points) . ', ' . mysql_escape_string($dat[2]) . ');');
db_query('UPDATE users SET points=' . mysql_escape_string($points) . ', rank=' . mysql_insert_id() . ' WHERE id=' . mysql_escape_string($dat[0]) . ' LIMIT 1;');
}
#file_put('data/_server'.$server.'/rank-user-count.dat', count($rank));
db_query('TRUNCATE TABLE rank_clusters');
# Tabelle leeren
unset($b);
settype($b, 'array');
while (list($bez, $val) = each($clusters)) {
$b[$bez] = $clusters[$bez]['points'];
}
arsort($b);
unset($c);
settype($c, 'array');
while (list($bez, $val) = each($b)) {
$c[$bez]['points'] = $val;
$c[$bez]['pcs'] = $clusters[$bez]['pcs'];
$c[$bez]['members'] = $clusters[$bez]['members'];
}
while (list($bez, $dat) = each($c)) {
$bez = substr($bez, 1);
$av_p = round($dat['points'] / $dat['members'], 2);
$av_pcs = round($dat['pcs'] / $dat['members'], 2);
// SUCCESS RATE CALCULATION START
$cluster = getcluster($bez);
$total = $cluster['srate_total_cnt'];
$scnt = $cluster['srate_success_cnt'];
$ncnt = $cluster['srate_noticed_cnt'];
if ($total > 0) {
$psucceeded = $scnt * 100 / $total;
$pnoticed = $ncnt * 100 / $total;
// Erfolg ist gut und zählt 75%
// Bemerkt ist schlecht (deshalb 100-$pnoticed) und zählt 25%
$srate = $psucceeded * 0.75 + (100 - $pnoticed) * 0.25;
} else {
$srate = 0;
}
// SUCCESS RATE CALCULATION END
if ($bez != $no_ranking_clusters) {
db_query('INSERT INTO rank_clusters VALUES(0,\'' . mysql_escape_string($bez) . '\',\'' . mysql_escape_string($dat['members']) . '\',\'' . mysql_escape_string($dat['points']) . '\',\'' . mysql_escape_string($av_p) . '\',\'' . mysql_escape_string($dat['pcs']) . '\',\'' . mysql_escape_string($av_pcs) . '\',\'' . mysql_escape_string($srate) . '\');');
}
db_query('UPDATE clusters SET points=\'' . mysql_escape_string($dat['points']) . '\',rank=\'' . mysql_insert_id() . '\' WHERE id=\'' . mysql_escape_string($bez) . '\' LIMIT 1;');
}
file_put('data/calc-stat.dat', 'Gleich fertig!!!');
cleardir('data/_server' . $server . '/usrimgs');
}
function GetTableInfo($table, $db = '')
{
global $server;
if ($db == '') {
$db = dbname($server);
}
$sql = 'SHOW TABLE STATUS FROM ' . mysql_escape_string($db) . ' LIKE \'' . mysql_escape_string($table) . '\';';
#echo $sql;
$r = mysql_db_query($db, $sql);
#echo mysql_error();
return mysql_fetch_assoc($r);
}
exit;
}
$fstr = @file_get($sidfile);
if (trim($fstr) != '') {
list($server, $usrid, $pcid) = explode("\v", $fstr);
/* SID wechseln ist ja eigentlich nicht sinnvoll ...
if(time()-filemtime($sidfile) > 300) {
@unlink($sidfile);
$sid=create_sid();
db_query('UPDATE users SET sid=\''.mysql_escape_string($sid).'\' WHERE id='.mysql_escape_string($usrid).';');
write_session_data();
} */
} else {
badsession('Session-ID nicht vorhanden!');
}
mysql_select_db(dbname($server));
$DATADIR = 'data/_server' . $server;
$usr = @mysql_fetch_assoc(db_query('SELECT * FROM users WHERE id=\'' . mysql_escape_string($usrid) . '\' LIMIT 1'));
$ip = GetIP();
$ip = $ip['proxy'] == '' ? $ip['ip'] : $ip['ip'] . ' over ' . $ip['proxy'];
if ($usr['sid'] != $sid) {
badsession('Das ist nicht deine Session-ID');
} elseif ($usr['sid_ip'] != $ip && $usr['sid_ip'] != 'noip') {
/* falsche IP-Adresse */
setcookie('htnLoginData');
badsession('Deine IP ist nicht dieser Session-ID zugeordnet!<br />Benutz die \'erweitertes LogIn\'-Funktion auf der Startseite.');
}
/*if($usr['bigacc']!='yes' && (time()-1*60*60)>$usr['login_time'] ) {
$sid='';
@unlink($sidfile);
simple_message('Du warst jetzt eine Stunde eingeloggt. Um Platz für andere Spieler zu machen, wurdest du automatisch ausgeloggt.','warning');
