$image_params = array(
'w' => 100,
'contribution' => true,
);
$name = $campaign->title;
$photo_file = 'sites/all/themes/dw_campaigns_walking/images/no-image.gif';
$temp_filename = $campaign->field_dw_campaign_image[0]['filepath'];
if(file_exists($temp_filename)) {
$photo_file = $temp_filename;
}
$photo = _dw_campaigns_thumb($photo_file, $image_params);
$amount = dw_campaigns_convert_to_usd($campaign->field_dw_currency['0']['value'], $totals[$nid]);
$raw_amount = $totals[$nid];
$location = $campaign->field_dw_campaign_location[0]['value'];
$fundraisers = $pcp_counts[$nid];
$url = '/dw/walking/location/' . $nid;
db_query("insert into {leader_as_$num_per_page} (name, photo, position, amount, raw_amount, location, fundraisers, url, campaign_id) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $name, $photo, $position, $amount, $raw_amount, $location, $fundraisers, $url, $campaign->nid);
}
$sql_count = "select count(*) from leader_as_$num_per_page";
//$result = db_query("select * from donations_as " . tablesort_sql($headers));
$result = pager_query("select * from leader_as_$num_per_page " . tablesort_sql($headers), $num_per_page, 0, $sql_count);
$rows = array();
)
";
db_query($query);
$position = 0;
$rows = array();
$campaigns = array();
if(count($leaders) > 0) {
$sorted_leaders = array();
foreach($leaders as $leader) {
if(!isset($campaigns[$leader['campaign_id']])) {
$campaigns[$leader['campaign_id']] = node_load($leader['campaign_id']);
}
$our_campaign = $campaigns[$leader['campaign_id']];
$amount = dw_campaigns_convert_to_usd($our_campaign->field_dw_currency['0']['value'], $leader['total']);
$leader['amount'] = $amount;
$sorted_leaders[] = $leader;
}
usort($sorted_leaders, "sort_leaders");
foreach($sorted_leaders as $leader) {
$campaign_id = $leader['campaign_id'];
$position++;
$image_match = '';
$image_params = array(
'w' => 100,
'contribution' => true,
