<?php

define('EQDKP_INC', true);
$eqdkp_root_path = './';
include_once($eqdkp_root_path . 'common.php');
$sql = 'SELECT
    ra.member_name, c.class_name as member_class,
    (m.member_earned + m.member_adjustment - m.member_spent) as current_dkp
 FROM
    '.RAIDS_TABLE.' r, '.RAID_ATTENDEES_TABLE.' ra, '.MEMBERS_TABLE.' m, ' .CLASS_TABLE.' c
 WHERE
    (ra.raid_id = r.raid_id)
 AND (m.member_name = ra.member_name)
 AND (m.member_class_id = c.class_id)
 GROUP BY
    ra.member_name
 ORDER BY
    member_name ASC';
if ( !($result = $db->query($sql)) ) {
message_die('Could not connect: ' . mysql_error());
}
define(TAB, "\t");
define(CRLF, "\r\n");

$output = 'gdkp = {'."\r\n";
$output .=  TAB.'["players"] = {'.CRLF;
$format =
	TAB.TAB.'["%s"] = {'.CRLF.
	TAB.TAB.TAB.'["dkp"] = %s,'.CRLF.
	TAB.TAB.TAB.'["class"] = "%s",'.CRLF.
	TAB.TAB.'},'.CRLF;

$lut = array(
"à" => "\\195\\160",
"á" => "\\195\\161",
"â" => "\\195\\162",
"ã" => "\\195\\163",
"ä" => "\\195\\164",
"æ" => "\\195\\166",
"ç" => "\\195\\167",
"è" => "\\195\\168",
"é" => "\\195\\169",
"ê" => "\\195\\170",
"ë" => "\\195\\171",
"ì" => "\\195\\172",
"í" => "\\195\\173",
"î" => "\\195\\174",
"ï" => "\\195\\175",
"ñ" => "\\195\\177",
"ò" => "\\195\\178",
"ó" => "\\195\\179",
"ô" => "\\195\\180",
"õ" => "\\195\\181",
"ö" => "\\195\\182",
"ø" => "\\195\\184",
"ù" => "\\195\\185",
"ú" => "\\195\\186",
"û" => "\\195\\187",
"ü" => "\\195\\188") ;

while ($row = $db->fetch_record($result)) {
    $output .= sprintf($format,
        strtr($row['member_name'],$lut),
        $row['current_dkp'],
        $row['member_class']
    );
}

$output = substr($output, 0, strlen($output)-3);
echo $output.CRLF.TAB.'}'.CRLF.'}'.CRLF;

$db->free_result($result);
?>