<?php |
/****************************** |
* GetDKP Plus |
* |
* © Corgan @ Server Antonidas PvE German -> www.seniorenraid.de |
* ------------------ |
* dkp_list.php |
* |
* Version 2.0 |
* 06/25/06 |
* Support English / German -> http://www.seniorenraid.de/forum/forumdisplay.php?f=13 |
* |
* modified: Sonath |
* for use with SDKP |
* version 0.4 |
* 3/20/09 |
* |
******************************/ |
|
############# you dont have to change anything below !!!! ###################################### |
|
echo "local _G = _G |
"; |
echo "local DEEP = _G.DEEP |
"; |
echo "DEEP.timedownload = ".time()." |
"; |
echo "DEEP.Players = {"; |
define('EQDKP_INC', true); |
$eqdkp_root_path = './'; |
include_once($eqdkp_root_path . 'common.php'); |
|
$replacement_table = array( |
"Ã " => "\\195\\160", |
"è" => "\\195\\168", |
"ì" => "\\195\\172", |
"ò" => "\\195\\178", |
"ù" => "\\195\\185", |
"á" => "\\195\\161", |
"é" => "\\195\\169", |
"Ã" => "\\195\\173", |
"ó" => "\\195\\179", |
"ú" => "\\195\\186", |
"â" => "\\195\\162", |
"ê" => "\\195\\170", |
"î" => "\\195\\174", |
"ô" => "\\195\\180", |
"û" => "\\195\\187", |
"ã" => "\\195\\163", |
"ë" => "\\195\\171", |
"ï" => "\\195\\175", |
"õ" => "\\195\\181", |
"ü" => "\\195\\188", |
"ä" => "\\195\\164", |
"ñ" => "\\195\\177", |
"ö" => "\\195\\182", |
"æ" => "\\195\\166", |
"ø" => "\\195\\184", |
"ç" => "\\195\\167", |
"Å" => "\\197\\147", |
"Ã" => "\\195\\132", |
"Ã" => "\\195\\150", |
"Ã" => "\\195\\156", |
"Ã" => "\\195\\159" |
); |
|
// Get DKP without spitting out the whole page |
|
$sql = ("SELECT m.member_id, m.member_name, c.class_name, r.rank_name, |
m.member_earned + m.member_adjustment as player_earned, |
m.member_spent as player_spent |
FROM " . MEMBERS_TABLE . " m, " . CLASS_TABLE . " c, " . MEMBER_RANKS_TABLE . " r |
WHERE m.member_class_id = c.class_id |
AND m.member_rank_id = r.rank_id |
GROUP BY m.member_name |
ORDER BY member_name ASC"); |
|
if (!($res = mysql_query($sql))) { |
print $sql; |
message_die("Could not download member DKP information", "", __FILE__, __LINE__, $sql); |
} |
$i = 1; |
while ($row = $db->fetch_record($res)) { |
$member_name = iconv("cp1251","UTF-8",$row['member_name']); |
$class_name = iconv("cp1251","UTF-8",$row['class_name']); |
$rank_name = $row['rank_name']; |
$member_id = $row['member_id']; |
|
|
$raids_30 = raid_count(mktime(0, 0, 0, date('m'), date('d')-30, date('Y')), time(), $row['member_name']); |
#$raids_60 = raid_count(mktime(0, 0, 0, date('m'), date('d')-60, date('Y')), time(), $row['member_name']); |
#$raids_90 = raid_count(mktime(0, 0, 0, date('m'), date('d')-90, date('Y')), time(), $row['member_name']); |
|
// empty DKP "pool" |
# printf("\"\" \"%s\" \"%s\" \"%s\" \"%f\" \"%f\" \"%f\" \"%f\" \"%f\"\n", |
# $member_name, |
# $class_name, |
# $rank_name, |
# $raids_30, |
# $raids_60, |
# $raids_90, |
# $row['player_earned'], |
# $row['player_spent']); |
$a = $row['player_earned'] ; |
$b = $row['player_spent'] ; |
#$c = |
$dkp = $a - $b; |
|
echo "[$i] = {"; |
echo "[\"name\"] = \"$member_name\","; |
echo "[\"class\"] = \"$class_name\","; |
echo "[\"dkp\"] = $dkp,"; |
echo "[\"atnd\"] = $raids_30,"; |
echo "},"; |
$i++; |
} |
|
function raid_count($start_date, $end_date, $member_name) { |
global $db; |
|
$raid_count = $db->query_first("SELECT count(*) FROM " . |
RAIDS_TABLE . |
" WHERE (raid_date BETWEEN " . |
$start_date . |
" AND " . |
$end_date . ")"); |
|
$sql = ("SELECT count(*) FROM " . |
RAIDS_TABLE . " r, " . RAID_ATTENDEES_TABLE . " ra " . |
"WHERE (ra.raid_id = r.raid_id) " . |
"AND (ra.member_name='" . $member_name . "') " . |
"AND (r.raid_date BETWEEN " . $start_date . " AND " . $end_date . ")"); |
|
$individual_raid_count = $db->query_first($sql); |
$percent_of_raids = ( $raid_count > 0 ) ? round(($individual_raid_count / $raid_count) * 100) : 0; |
$raid_count_stats = array( |
'percent' => $percent_of_raids, |
'total_count' => $raid_count, |
'indiv_count' => $individual_raid_count); |
|
return $raid_count_stats['percent']; // Only thing needed ATM |
} |
|
$db->free_result($res); |
|
echo "}"; |
?> |