name_short); $display_cat = GetDisplayCategory($row->category) . ' ' . L_DOWNLOAD; $content .= "category.zoozle.$domain_ending/download.php?n=$name_short_url\" title=\"$row->name_short $display_cat\">$row->name_short
"; } return $content; } function GetRecentSearches($exclude_keyword = '') { global $page_lang; global $recent_searches_limit; global $domain_ending; $query = "SELECT category, keyword FROM latest_searches_$page_lang "; if ($exclude_keyword != '') $query .= "WHERE keyword != '$exclude_keyword' "; $query .= "ORDER BY time DESC LIMIT $recent_searches_limit"; $result = mysql_query($query); $content = ''; while ($row = mysql_fetch_object($result)) { $keyword_url = urlencode($row->keyword); $display_cat = GetDisplayCategory($row->category) . ' ' . L_DOWNLOAD; $content .= "category.zoozle.$domain_ending/suche.php?q=$keyword_url\" title=\"$row->keyword $display_cat\">$row->keyword
"; } return $content; } function GetDirectoryLetters($cached) { global $subdomain; global $page_lang; if ($cached) return file_get_contents("./cache/letters_$subdomain"."_$page_lang.html"); global $domain_ending; $display_cat = GetDisplayCategory($subdomain); $numbers = '0123456789'; $alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'; $alphabet_lower = 'abcdefghijklmnopqrstuvwxyz'; // faster than strtolower $content = ''; for ($i = 0; $i < strlen($numbers); $i++) { if (EntriesExist($numbers[$i])) $content .= " $numbers[$i]"; else $content .= "  "; } $content .= "
\r\n"; for ($i = 0; $i < strlen($alphabet); $i++) { $first_lower = $alphabet_lower[$i]; $first_upper = $alphabet[$i]; for ($u = 0; $u < strlen($alphabet); $u++) { if (EntriesExist($first_upper.$alphabet[$u])) $content .= " $first_upper$alphabet[$u]"; else $content .= " __"; } $content .= "
\r\n"; } $content = substr($content, 1); return $content; } function GetNews($category) { global $page_lang; global $domain_ending; $query = "SELECT name, name_short FROM names_$category"."_$page_lang ORDER BY entrydate DESC LIMIT " . NEWS_ENTRY_LIMIT; $result = mysql_query($query); $content = ''; while ($row = mysql_fetch_object($result)) { $link = urlencode(strtolower($row->name_short)); $content .= " name\">$row->name
\r\n"; } return $content; } ?>