Here you can find a ranking of the hardest working spot guides on surfcampseurope.com!
$value) {
$result = db_query("SELECT count(nid) FROM node WHERE type = 'spot' AND status = 1 AND uid = %d", $value['uid']);
$anzahl = db_fetch_array($result);
$row = array($value['name'], $anzahl['count(nid)']);
if($anzahl['count(nid)'] > 0) $rows[] = $row;
}
foreach ($rows as $key => $row) {
$anzahl[$key] = $row[1];
$name[$key] = $row[0];
}
unset($anzahl['count(nid)']);
$anzahl_low = array_map('strtolower', $anzahl);
$name_low = array_map('strtolower', $name);
array_multisort($anzahl_low, SORT_NUMERIC, SORT_DESC, $name_low, SORT_ASC, SORT_STRING, $rows);
$z = 0;
foreach ($rows as $key => $row) {
$user = user_load(array("name" => $row[0]));
$g = 40 - $z;
if($g " . theme_username($user) . "", l($row[1], "myspots/".$user->uid, array("style" => "font-size:" . $g . "px")) );
}
print theme('table', $header, $f_rows);
?>
