<?php
/**
 * Template Name: DKP page
 *
 * Custom display of DKP database
 *
 * @package WordPress
 * @subpackage Twenty_Twelve
 * @since Twenty Twelve 1.0
 */

get_header(); ?>

    <div id="primary" class="site-content">
        <div id="content" role="main">
<?php
if(is_user_logged_in()) {
    $username = "fgt";
    $password = "fgt";
    $database = "fgt";
    $link     = mysql_connect(localhost, $username, $password);
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    @mysql_select_db($database) or die( "Unable to select database");
    $data = array();
    $earned = array();
    $spent = array();

    if (array_key_exists("dkpname", $_GET)) {
        $query = "select * from dkp where name='". $_GET['dkpname'] . "' order by ts desc;";
        $results = mysql_query($query);
        $size = mysql_numrows($results);
        print("<h1>DKP Breakdown for " . $_GET['dkpname'] . "</h1>\n");
        print("<br>\n");
        print("<table class=dkpbreakdown border=1>\n");
        print("<thead>\n");
        print("<tr><td>Date</td><td>Change</td><td>Reason</td></tr>\n");
        print("</thead>\n");
        print("<tbody>\n");
        $accum = 0;
        for ($i = 0; $i < $size; $i++) {
            $delta  = mysql_result($results, $i, "delta");
            $ts     = mysql_result($results, $i, "ts");
            $reason = mysql_result($results, $i, "reason");
            $accum += $delta;
            printf("<tr><td>%s</td><td class=change>%s</td><td>%s</td></tr>\n", $ts, $delta, $reason);
        }
        print("</tbody>\n");
        printf("<tfoot><tr><td>Total</td><td class=change>%d</td></tr></tfoot>\n", $accum);
        print("</table>\n");
        print("<br>\n");
        print("<a href=?>Return to previous page</a>\n");
    } else {
        $attendance = array();
        $query = "select * from dkp where ts > curdate() - interval 2 week and delta > 0";
        $results = mysql_query($query);
        $size = mysql_numrows($results);
        $max = 0;
        for ($i = 0; $i < $size; $i++) {
            $name = mysql_result($results, $i, "name");
            $delta = mysql_result($results, $i, "delta");
            if (array_key_exists($name, $attendance)) {
                $attendance[$name] += intval($delta);
            } else {
                $attendance[$name] = $delta;
            }
            if ($attendance[$name] > $max) {
                $max = $attendance[$name];
            }
        }
        $moattendance = array();
        $query = "select * from dkp where ts > curdate() - interval 1 month and delta > 0";
        $results = mysql_query($query);
        $size = mysql_numrows($results);
        $momax = 0;
        for ($i = 0; $i < $size; $i++) {
            $name = mysql_result($results, $i, "name");
            $delta = mysql_result($results, $i, "delta");
            if (array_key_exists($name, $moattendance)) {
                $moattendance[$name] += intval($delta);
            } else {
                $moattendance[$name] = $delta;
            }
            if ($moattendance[$name] > $momax) {
                $momax = $moattendance[$name];
            }
        }

        $query = "select * from dkp";
        $results = mysql_query($query);

        $size = mysql_numrows($results);
        for ($i = 0; $i < $size; $i++) {
            $name   = mysql_result($results, $i, "name");
            $delta  = mysql_result($results, $i, "delta");
            if (array_key_exists($name, $data)) {
                $data[$name] += intval($delta);
                if (intval($delta) > 0) {
                    $earned[$name] += intval($delta);
                } else {
                    $spent[$name] += intval($delta);
                }
            } else {
                $data[$name] = intval($delta);
                if (intval($delta) > 0) {
                    $earned[$name] = intval($delta);
                    $spent[$name] = 0;
                } else {
                    $earned[$name] = 0;
                    $spent[$name] = intval($delta);
                }
            }
        }
        print("<table class=sortable>\n");
        print("    <thead>\n");
        print("        <tr><td>Name</td><td class='dkp'>DKP</td><td>Earned</td><td>Spent</td><td>2 week attendance</td><td>1 month attendance</td></tr>\n");
        print("    </thead>\n");
        print("    <tbody>\n");
        ksort($data);
        foreach ($data as $key => $value) {
            if (array_key_exists($key, $attendance)) {
                $curattendance = intval($attendance[$key] / $max * 100);
            } else {
                $curattendance = 0;
            }
            if (array_key_exists($key, $moattendance)) {
                $curmoattendance = intval($moattendance[$key] / $momax * 100);
            } else {
                $curmoattendance = 0;
            }
            printf("        <tr><td><a href=?dkpname=%s>%s</a></td><td class=total>%s</td><td class=total>%s</td><td class=total>%s</td><td class=total>%s</td><td class=total>%s</td></tr>\n", $key, $key, $value,$earned[$key], abs($spent[$key]), $curattendance, $curmoattendance);
        }
        print("    </tbody>\n");
        print("</table>\n");
    }
} else {
    wp_die('Sorry, you must first <a href="/forum">log in</a> to view this page.');
}
?>

        </div><!-- #content -->
    </div><!-- #primary -->

<?php get_footer(); ?>