opentable("D1 Scores Rally"); ////NUR HIER ÄNDERN -> $timesst1 = mktime(00,00,10,08,01,2015); // Start Zeit - (FORMAT: HH,MM,SS,MM,DD,YYYY) $timeend2 = mktime(23,59,59,08,31,2015); // Ende Zeit - (FORMAT: HH,MM,SS,MM,DD,YYYY) ////NUR HIER ÄNDERN <- $srtime = time(); $dstart = date("d.m.Y H:i:s",$timesst1); $dend = date("d.m.Y H:i:s",$timeend2); echo "
Nuggets Rally - TOP 10
Errechnet vom: ".$dstart." bis: ".$dend."
"; if (($timesst1 <= $srtime) && ($timeend2 >= $srtime)) { echo "
Nuggets Rally läuft
"; } elseif ($timeend2 <= $srtime) { echo "
Nuggets Rally beendet
"; } elseif ($timesst1 >= $srtime) { echo "
Nuggets Rally noch nicht gestartet
"; } else { echo "
SYSTEM ERROR
"; } $scresult = dbquery("SELECT SUM(tra_score) AS sumscore, tra_user_id FROM ".DB_PREFIX."score_transfer WHERE tra_time >= '$timesst1' AND tra_time <= '$timeend2' AND tra_typ = 'P' GROUP BY tra_user_id ORDER BY sumscore DESC LIMIT 0,10"); if (dbrows($scresult)) { echo "
"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $i = 0; while ($sc = dbarray($scresult)) { $i++; $scusername = dbarray(dbquery("SELECT user_id, user_name FROM ".DB_USERS." WHERE user_id='".$sc['tra_user_id']."'")); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "
PlatzUsernameScores
".$i.".".trimlink($scusername['user_name'], 15)." ".$sc['sumscore']."
"; } else { echo "
Keine Ergebnisse zu dieser Errechnung vorhanden!
"; } echo "
© DeeoNe
"; closetable();