';
$res = $db->sql_query('SELECT currency.* FROM `'.$prefix.'_donations_config` AS config LEFT JOIN `'.$prefix.'_donations_currency` AS currency ON config.`currency` = currency.`currency`');
list($currency, $currency_symbol) = $db->sql_fetchrow($res);
$res = $db->sql_query('SELECT `site_active`, `site_target` FROM `'.$prefix.'_donations_config`');
list($site_donations_active, $site_target) = $db->sql_fetchrow($res);
$res = $db->sql_query('SELECT `user_id`, `first_name`, `last_name`, `settle_amount`, `event_id`, `payment_date` FROM `'.$prefix.'_donations` UNION SELECT `user_id`, `first_name`, `last_name`, `settle_amount`, `event_id`, `payment_date` FROM `'.$prefix.'_donations_archive`');
$donators = array();
$stats['week'] = array('number'=>0, 'amount'=>0);
$stats['month'] = array('number'=>0, 'amount'=>0);
$stats['sixmonths'] = array('number'=>0, 'amount'=>0);
$stats['year'] = array('number'=>0, 'amount'=>0);
$stats['life'] = array('number'=>0, 'amount'=>0);
$site_amount = 0;
while ($row = $db->sql_fetchrow($res)){
if ($row['event_id']==0){
$site_amount += $row['settle_amount'];
}
if ($row['user_id']!=0){
if (isset($donators[$row['user_id']])){
$donators[$row['user_id']] += $row['settle_amount'];
}else{
$donators[$row['user_id']] = $row['settle_amount'];
}
}
$time = time();
$stats['life']['number'] += 1;
$stats['life']['amount'] += $row['settle_amount'];
if ($row['payment_date']>($time-31556926)){
$stats['year']['number'] += 1;
$stats['year']['amount'] += $row['settle_amount'];
if ($row['payment_date']>($time-15778463)){
$stats['sixmonths']['number'] += 1;
$stats['sixmonths']['amount'] += $row['settle_amount'];
if ($row['payment_date']>($time-2629743)){
$stats['month']['number'] += 1;
$stats['month']['amount'] += $row['settle_amount'];
if ($row['payment_date']>($time-604800)){
$stats['week']['number'] += 1;
$stats['week']['amount'] += $row['settle_amount'];
}
}
}
}
}
arsort($donators);
$i=1;
foreach($donators as $id=>$amount){
if ($i>5){
unset($donators[$id]);
}
$i++;
}
if (!empty($donators)){
$in = implode(',', array_keys($donators));
$res = $db->sql_query('SELECT `user_id`, `username` FROM `'.$prefix.'_users` WHERE `user_id` IN ('.$in.')');
$top5 = array();
while($row = $db->sql_fetchrow($res)){
$top5[$row['user_id']] = array('username'=>$row['username'], 'amount'=> $donators[$row['user_id']]);
}
}
echo '| '._DONATIONS_GLOBAL_STATS.' |
|---|
';
echo '| '._DONATIONS_LAST_WEEK.' | '.$stats['week']['number'].' | '.$currency_symbol.currency($stats['week']['amount']).' '.$currency.' | ';
echo '| '._DONATIONS_LAST_MONTH.' | '.$stats['month']['number'].' | '.$currency_symbol.currency($stats['month']['amount']).' '.$currency.' | ';
echo '| '._DONATIONS_LAST_SIX_MONTHS.' | '.$stats['sixmonths']['number'].' | '.$currency_symbol.currency($stats['sixmonths']['amount']).' '.$currency.' | ';
echo '| '._DONATIONS_LAST_YEAR.' | '.$stats['year']['number'].' | '.$currency_symbol.currency($stats['year']['amount']).' '.$currency.' | ';
echo '| '._DONATIONS_LIFETIME.' | '.$stats['life']['number'].' | '.$currency_symbol.currency($stats['life']['amount']).' '.$currency.' | ';
echo '
';
echo '| '._DONATIONS_TOP_FIVE_DONATORS.' |
|---|
';
foreach($donators as $key=>$val){
$user = $top5[$key];
echo '| '.UsernameColor($user['username']).' | '.$currency_symbol.currency($user['amount']).' '.$currency.' | ';
}
echo '
';
echo ' | ';
$res = $db->sql_query('SELECT `event_id`, COUNT(`id`) as c FROM `nuke_donations` GROUP BY `event_id`');
while ($row = $db->sql_fetchrow($res)){
$event_count[$row['event_id']] = $row['c'];
}
echo '';
echo '| '._DONATIONS_SITE.(($site_donations_active) ? '' : ' ('._DONATIONS_INACTIVE.')').' |
|---|
';
echo '| '._DONATIONS_DONATIONS.' | ';
echo ''.((isset($event_count[0])) ? $event_count[0] : 0).' | ';
echo '| '._DONATIONS_CURRENT_AMOUNT.' | ';
echo ''.$currency_symbol.currency($site_amount).' '.$currency.' | ';
if ($site_target>0){
$difference = $site_amount-$site_target;
echo '| '._DONATIONS_GOAL.' | ';
echo ''.$currency_symbol.currency($site_target).' '.$currency.' | ';
echo '| '.(($difference>0) ? _DONATIONS_ABOVE_GOAL : _DONATIONS_BELOW_GOAL).' | ';
echo ''.$currency_symbol.currency(abs($difference)).' '.$currency.' | ';
echo '| '._DONATIONS_PERCENT_COMPLETE.' | ';
echo ''.round($site_amount/$site_target*100).'% | ';
}
echo '
';
$res = $db->sql_query('SELECT `id`, `title`, `time_based`, `date_end`, `target`, `current`, `active` FROM `'.$prefix.'_donations_events`');
while ($row = $db->sql_fetchrow($res)){
echo '';
echo '| '.$row['title'].(($row['active']) ? '' : ' ('._DONATIONS_INACTIVE.')').' |
|---|
';
echo '| '._DONATIONS_DONATIONS.' | ';
echo ''.((isset($event_count[$row['id']])) ? $event_count[$row['id']] : 0).' | ';
echo '| '._DONATIONS_CURRENT_AMOUNT.' | ';
echo ''.$currency_symbol.currency($row['current']).' '.$currency.' | ';
if ($row['target']>0){
echo '| '._DONATIONS_GOAL.' | ';
echo ''.$currency_symbol.currency($row['target']).' '.$currency.' | ';
$difference = $row['current']-$row['target'];
echo '| '.(($difference>0) ? _DONATIONS_ABOVE_GOAL : _DONATIONS_BELOW_GOAL).' | ';
echo ''.$currency_symbol.currency(abs($difference)).' '.$currency.' | ';
echo '| '._DONATIONS_PERCENT_COMPLETE.' | ';
echo ''.round($row['current']/$row['target']*100).'% | ';
}
if ($row['time_based']==1){
echo '| '._DONATIONS_END_DATE.' | ';
echo ''.date('d/m/Y', $row['date_end']).' | ';
}
echo '
';
}
echo ' |