function getTagCloudByName($amount) { global $database, $db; if (!$db->query("SELECT t.name, count(r.tag) as tagUsed FROM {$database['prefix']}TagRelations r ON ( r.type = 'feed' ) LEFT JOIN {$database['prefix']}Tags t ON t.id = r.tag GROUP BY r.tag")) return false; if ($db->numRows() == 0) return false; $tagPool = array(); while ($data = $db->fetchArray()) { array_push($tagPool, array("name"=>$data['name'], "frequency"=>$data['tagUsed'], "cc"=>((ord($data['name']) < 128) ? 2 : 1))); } $db->free(); $tagPool = func::array_columnsort('cc', SORT_ASC, SORT_NUMERIC, 'name', SORT_ASC, SORT_STRING, $tagPool); return array_slice($tagPool, 0, $amount); }