$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,