opentable("D1 Scores Rally");

 

////NUR HIER ÄNDERN ->

$timest1 = mktime(13,11,0,8,1,2015);// Start Zeit - (FORMAT: H,M,S,m,d,YYYY)

$timeend2 = mktime(23,59,59,8,31,2015); // Ende Zeit - (FORMAT: H,M,S,m,dd,YYYY)

////NUR HIER ÄNDERN <-

 

 

$srtime = time();

$dstart = date("d.m.Y H:i:s",$timest1);

$dend = date("d.m.Y H:i:s",$timeend2);

 

echo "<center> <big><b>Nuggets Rally - TOP 10</b></big> <br> <small>Errechnet vom: ".$dstart." bis: ".$dend."</small></center>";

 

if (($timest1 <= $srtime) && ($timeend2 >= $srtime)) {

echo "<div style='color:lime;font-weight:bold;text-align:center;font-size: 12px;'><center><table style='border-color: #00FF00; border-width: 1px; border-style: dashed; background-color: #005500; margin-bottom:5px;' width='50%' align='center'><tr><td align='center'>Nuggets Rally l&auml;uft</td></tr></table></center></div>";

} elseif ($timeend2 <= $srtime) {

echo "<div style='color:red;font-weight:bold;text-align:center;font-size: 12px;'><center><table style='border-color: #ff0000; border-width: 1px; border-style: dashed; background-color: #550000; margin-bottom:5px;' width='50%' align='center'><tr><td align='center'>Nuggets Rally beendet</td></tr></table></center></div>";

} elseif ($timest1 >= $srtime) {

echo "<div style='color:red;font-weight:bold;text-align:center;font-size: 12px;'><center><table style='border-color: #ff0000; border-width: 1px; border-style: dashed; background-color: #550000; margin-bottom:5px;' width='50%' align='center'><tr><td align='center'>Nuggets Rally noch nicht gestartet</td></tr></table></center></div>";

} else {

echo "<div style='color:red;font-weight:bold;text-align:center;font-size: 12px;'><center><table style='border-color: #ff0000; border-width: 1px; border-style: dashed; background-color: #550000; margin-bottom:5px;' width='50%' align='center'><tr><td align='center'>SYSTEM ERROR</td></tr></table></center></div>";

}

 

$scresult = dbquery("SELECT SUM(tra_score) AS sumscore, tra_user_id FROM ".DB_PREFIX."score_transfer WHERE tra_time >= '$timest1' AND tra_time  <= '$timeend2' AND tra_typ = 'P' GROUP BY tra_user_id ORDER BY sumscore DESC LIMIT 0,10");

    if (dbrows($scresult)) {

 

    echo "<center><table  align='center' width='30%'>";

        echo "<tr>\n";

        echo "<td class='tbl2' style='white-space:nowrap'  width='5%'>Platz</td>\n";

        echo "<td class='tbl2' style='white-space:nowrap'  width='80%'>Username</td>\n";

        echo "<td align='center' class='tbl2'>Scores</td>\n";

        echo "</tr>\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 "<tr>\n";

        echo "<td align='center' class='tbl1'>".$i.".</td>\n";

        echo "<td class='tbl1' style='white-space:nowrap'><a href='".BASEDIR."profile.php?lookup=".$sc['tra_user_id']."' >".trimlink($scusername['user_name'], 15)." </a></td>\n";

        echo "<td align='center' class='tbl1'>".$sc['sumscore']."</td>\n";

        echo "</tr>\n";

}

    echo "</table></center>";

} else {

echo "<center><b>Keine Ergebnisse zu dieser Errechnung vorhanden!</b></center>";

}

echo "<div align='right'><a href='http://www.deeone.de' target='_blank' title='D1 Scores Rally 0.1.0 &copy; 2014 DeeoNe'><small>&copy; DeeoNe</small></a></div>";

closetable();