Badge's page fix for SnowFlat

qa-badge-page.php

function process_request($request)
{
	$qa_content=qa_content_prepare();

	$qa_content['title']=qa_lang('badges/badge_list_title');

	$badges = qa_get_badge_list();

	$totalawarded = 0;

	$html ='<em>'.qa_lang('badges/badge_list_pre').'</em><br />';
	$html .= '<table cellspacing="20">';

	$result = qa_db_read_all_assoc(
		qa_db_query_sub(
			'SELECT user_id,badge_slug  FROM ^userbadges'
		)
	);

	$count = array();

	foreach($result as $r) {
		if(qa_opt('badge_'.$r['badge_slug'].'_enabled') == '0') continue;
		if(isset($count[$r['badge_slug']][$r['user_id']])) $count[$r['badge_slug']][$r['user_id']]++;
		else $count[$r['badge_slug']][$r['user_id']] = 1;
		$totalawarded++;
		if(isset($count[$r['badge_slug']]['count'])) $count[$r['badge_slug']]['count']++;
		else $count[$r['badge_slug']]['count'] = 1;
	}


	foreach($badges as $slug => $info) {
		if(qa_opt('badge_'.$slug.'_enabled') == '0') continue;
		$badge_name = qa_badge_name($slug);
		if(!qa_opt('badge_'.$slug.'_name')) qa_opt('badge_'.$slug.'_name',$badge_name);
		$name = qa_opt('badge_'.$slug.'_name');
		$var = qa_opt('badge_'.$slug.'_var');
		$desc = qa_badge_desc_replace($slug,$var,false);
		$type = qa_get_badge_type($info['type']);
		$types = $type['slug'];
		$typen = $type['name'];
		$html.='<tr><td class="badge-entry"><div class="badge-entry-badge"><span class="badge-'.$types.'" title="'.$typen.'">'.$name.'</span>&nbsp;<span class="badge-entry-desc">'.$desc.'</span>'.(isset($count[$slug])?'&nbsp;<span title="'.$count[$slug]['count'].' '.qa_lang('badges/awarded').'" class="badge-count-link" onclick="jQuery(\'#badge-users-'.$slug.'\').slideToggle()">x'.$count[$slug]['count'].'</span>':'').'</div>';

		// source users

		if(qa_opt('badge_show_source_users') && isset($count[$slug])) {

			$users = array();

			require_once QA_INCLUDE_DIR.'qa-app-users.php';

			$html .='<div style="display:none" id="badge-users-'.$slug.'" class="badge-users">';
			foreach($count[$slug] as $uid => $ucount) {
				if($uid == 'count') continue;

				if (QA_FINAL_EXTERNAL_USERS) {
					$handles=qa_get_public_from_userids(array($uid));
					$handle=@$handles[$uid];
				}
				else {
					$useraccount=qa_db_select_with_pending(
						qa_db_user_account_selectspec($uid, true)
					);
					$handle=@$useraccount['handle'];
				}

				if(!$handle) continue;

				$users[] = '<a href="'.qa_path_html('user/'.$handle).'">'.$handle.($ucount>1?' x'.$ucount:'').'</a>';
			}
			$html .= implode(', ',$users).'</div>';
		}
		$html .= '</td></tr>';
	}


	$html.='<tr><td class="badge-entry"><span class="total-badges">'.count($badges).' '.qa_lang('badges/badges_total').'</span>'.($totalawarded > 0 ? ', <span class="total-badge-count">'.$totalawarded.' '.qa_lang('badges/awarded_total').'</span>':'').'</td></tr></table>';
	$qa_content['custom'] = $html;

	if(isset($qa_content['navigation']['main']['custom-2'])) $qa_content['navigation']['main']['custom-2']['selected'] = true;

	return $qa_content;
}