THE BUNGHOLE"; else echo "THE BUNGHOLE - Showing category: ",nopavla($showcat),""; ?>

27 February 2001: Bunghole now has a new owner. Kostas Batis, also owner of one of the most well designed webzines Hades Gates, came to bring life to Bunghole once again.

Be ready to find lots of changes in this metal search engine, like a bunghole e-mail, more sites (also all the old sites will be checked again), put the advertising back and much more...

For the last 6 months Bunghole has gone Open Source and its code is available under the GPL license from this site.

\n"; $query = mysql_query("SELECT id, title, description, category, date_added, hits, is_new, rating, votes FROM bunghole_links ORDER BY date_added DESC LIMIT 3"); $result = mysql_fetch_array($query); echo "Last database update: ", convert_date($result["date_added"]), "
\n"; /* $query2 = mysql_query("SELECT 1 FROM bunghole_newsletter WHERE status = 'ok';"); echo "Newsletter: ", mysql_num_rows($query2), " subscribers.\n"; */ echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; make_title("Last 3 links added"); do { echo "".ucfirst($result["title"]).""; echo " from ",$result["category"]," category.\n"; echo "
".$result["description"]."\n"; echo "
(Added: ".convert_date($result["date_added"]).", ".$result["hits"]." hits)\n"; echo "
Rating: ", $result["rating"]/100,"/10 from ".$result["votes"]." votes. [Rate It]\n"; echo "
 
"; } while(($result = mysql_fetch_array($query))); ?>   ",nopavla($showcat),"\n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; echo "\n"; echo "
\n"; echo "\n"; $query = mysql_query("SELECT 1 FROM bunghole_links WHERE category LIKE \"$showcat\";"); $totalnumber = mysql_num_rows($query); if($order == "title") $query = mysql_query("SELECT id, title, description, date_added, hits, is_new, rating, votes FROM bunghole_links WHERE category LIKE \"$showcat\" ORDER BY $order LIMIT $start, 11;"); else $query = mysql_query("SELECT id, title, description, date_added, hits, is_new, rating, votes FROM bunghole_links WHERE category LIKE \"$showcat\" ORDER BY $order DESC, votes DESC LIMIT $start, 11;"); $end = mysql_num_rows($query); if(!$end) echo "No results for category ",nopavla($showcat),".\n"; else { echo "Showing records ",$start+1," to "; if($end == 11) echo "".$start+$end-1; else echo "".$start+$end; echo " out of $totalnumber records. Viewing by ",nopavla($order),".
"; if($order != "title") echo "[View by title] "; if($order != "date_added") echo "[View by date] "; if($order != "hits") echo "[View by hits] "; if($order != "rating") echo "[View by rating] "; // Show records // We will only show 10 records, the eleventh is to see if more records exist echo "
    \n"; $count = 1; while($count <= $end) { $result = mysql_fetch_array($query); echo "
  • ".ucfirst($result["title"])."\n"; echo "
    ".$result["description"]."\n"; echo "
    (Added: ".convert_date($result["date_added"]).", ".$result["hits"]." hits)\n"; echo "
    Rating: ", $result["rating"]/100,"/10 from ".$result["votes"]." votes. [Rate It]\n"; echo "
     "; $count++; if($count == 11) break; } // Page menu $numofpages = $totalnumber / 10; settype($numofpages, "integer"); if(($totalnumber % 10)) $numofpages++; $curpage = $start/10; settype($numofpages, "integer"); // if(($start % 10)) $curpage++; $curpage++; if($numofpages > 1) { echo "

    $numofpages pages:\n"; for($count=1;$count<=$numofpages;$count++) { if($count == $curpage) echo " $count "; else echo " $count "; } // Previous - Next menu echo ".   "; if($start >= 10) echo "<< Previous"; if(($start >= 10) && ($end == 11)) echo " - "; if($end == 11) echo "Next >>\n"; } else echo "

    No more pages.\n"; echo "

    \n"; echo "\n"; echo "

    Search in this category:

    \n"; } mysql_close($db); ?>