".translate("HOME").""; if ($mainlink>0) { echo " ".translate("Links Main").""; } echo " ".translate("Add URL")." ".translate("New Links")." ".translate("The Best")." ".translate("Random Link")."
"; } function SearchForm() { echo " Hip Links

"; } function index() { include("header.php3"); $mainlink = 0; menu($mainlink); echo "

"; SearchForm(); echo " "; $result=mysql_query("select cid, title from links_categories order by title"); $count = 0; while(list($cid, $title) = mysql_fetch_row($result)) { echo ""; } $count++; if ($count==2) { echo ""; $count = 0; } } $result=mysql_query("select * from links_links"); $numrows = mysql_num_rows($result); echo "
$title
"; $result2 = mysql_query("select sid, title from links_subcategories where cid=$cid order by title limit 0,3"); $space = 0; while(list($sid, $stitle) = mysql_fetch_row($result2)) { if ($space>0) { echo ", "; } echo "$stitle"; $space++; } if ($count<1) { echo "
    


".translate("There are")." $numrows ".translate("Links in our Database")."
"; include("footer.php3"); } function AddLink() { include("header.php3"); $mainlink = 1; menu($mainlink); echo "

Hip Links


".translate("Page Title: ")."
".translate("Page URL: ")."
"; $result=mysql_query("select cid, title from links_categories order by title"); echo "".translate("Category: ")."


".translate("Description: (255 characters max)")."



".translate("Your Name: ")."
".translate("Your Email: ")."



"; include("footer.php3"); } function Add($title, $url, $name, $cat, $description, $name, $email) { dbconnect(); $result = mysql_query("select url from links_links where url='$url'"); $numrows = mysql_num_rows($result); if ($numrows>0) { include("header.php3"); echo "

"; SearchForm(); echo ""; echo "".translate("ERROR: This URL is already listed in the Database!")."

"; echo "
"; include("footer.php3"); } else { // Check if Title exist if ($title=="") { include("header.php3"); echo "

"; SearchForm(); echo ""; echo "".translate("ERROR: You need to type a TITLE for your URL!")."

"; echo "
"; include("footer.php3"); } // Check if URL exist if ($url=="") { include("header.php3"); echo "

"; SearchForm(); echo ""; echo "".translate("ERROR: You need to type a URL for your URL!")."

"; echo "
"; include("footer.php3"); } // Check if Description exist if ($description=="") { include("header.php3"); echo "

"; SearchForm(); echo ""; echo "".translate("ERROR: You need to type a DESCRIPTION for your URL!")."

"; echo "
"; include("footer.php3"); } $cat = explode("-", $cat); if ($cat[1]=="") { $cat[1] = 0; } $title = stripslashes(FixQuotes($title)); $url = stripslashes(FixQuotes($url)); $description = stripslashes(FixQuotes($description)); $name = stripslashes(FixQuotes($name)); $email = stripslashes(FixQuotes($email)); dbconnect(); mysql_query("insert into links_newlink values (NULL, '$cat[0]', '$cat[1]', '$title', '$url', '$description', '$name', '$email')"); include("header.php3"); $mainlink = 1; menu($mainlink); echo "

"; SearchForm(); echo ""; echo "".translate("We received your Link submission. Thanks!")."
"; echo "".translate("You'll receive and E-mail when it's approved.")."

"; echo "
"; include("footer.php3"); } } function NewLinks() { global $admin; include("header.php3"); include("config.php3"); $mainlink = 1; menu($mainlink); echo "

"; SearchForm(); echo "
"; echo "".translate("Last")." $newlinks ".translate("Links Added to Database").""; echo "
"; $result=mysql_query("select lid, cid, sid, title, description, date, hits from links_links order by date DESC limit 0,$newlinks"); echo "
"; while(list($lid, $cid, $sid, $title, $description, $time, $hits)=mysql_fetch_row($result)) { if ($admin) { echo ".translate( $title 
"; } else { echo " $title 
"; } echo "".translate("Description: ")."$description
"; setlocale ("LC_TIME", "$locale"); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime); $datetime = strftime("".translate("linksdatestring")."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1])); $datetime = ucfirst($datetime); echo "".translate("Added on: ")."$datetime ".translate("Hits: ")."$hits
"; $result2=mysql_query("select title from links_categories where cid=$cid"); list($ctitle) = mysql_fetch_row($result2); echo "".translate("Category: ")."$ctitle"; $result3=mysql_query("select title from links_subcategories where sid=$sid"); while(list($stitle) = mysql_fetch_row($result3)) { echo " / $stitle"; } echo "

"; } echo "
"; echo "
"; include("footer.php3"); } function TheBest() { global $admin; include("header.php3"); include("config.php3"); $mainlink = 1; menu($mainlink); echo "

"; SearchForm(); echo "
"; echo "".translate("The")." $toplinks ".translate("Most Visited Links").""; echo "
"; $result=mysql_query("select lid, cid, sid, title, description, date, hits from links_links order by hits DESC limit 0,$toplinks"); echo "
"; while(list($lid, $cid, $sid, $title, $description, $time, $hits)=mysql_fetch_row($result)) { if ($hits>0) { if ($admin) { echo ".translate( $title 
"; } else { echo " $title 
"; } echo "".translate("Description: ")."$description
"; setlocale ("LC_TIME", "$locale"); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime); $datetime = strftime("".translate("linksdatestring")."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1])); $datetime = ucfirst($datetime); echo "".translate("Added on: ")."$datetime ".translate("Hits: ")."$hits
"; $result2=mysql_query("select title from links_categories where cid=$cid"); list($ctitle) = mysql_fetch_row($result2); echo "".translate("Category: ")."$ctitle"; $result3=mysql_query("select title from links_subcategories where sid=$sid"); while(list($stitle) = mysql_fetch_row($result3)) { echo " / $stitle"; } echo "

"; } } echo "
"; echo "
"; include("footer.php3"); } function RandomLink() { dbconnect(); $result = mysql_query("select * from links_links"); $numrows = mysql_num_rows($result); srand((double)microtime()*1000000); $random = rand(1,$numrows); $result2 = mysql_query("select url from links_links where lid='$random'"); list($url) = mysql_fetch_row($result2); Header("Location: $url"); } function viewlink($cid, $min) { global $admin; include("header.php3"); include("config.php3"); $mainlink = 1; if (!isset($min)) $min=0; if (!isset($max)) $max=$min+$perpage; menu($mainlink); echo "
"; echo "
"; echo "

"; SearchForm(); echo "
"; echo "".translate("SubCategories").""; echo "
"; $result=mysql_query("select sid, title from links_subcategories where cid=$cid"); while(list($sid, $title) = mysql_fetch_row($result)) { $result2 = mysql_query("select * from links_links where sid=$sid"); $numrows = Mysql_num_rows($result2); echo "  
  • $title ($numrows)"; } echo "

    "; echo "
    "; $result=mysql_query("select title from links_categories where cid=$cid"); list($title) = mysql_fetch_row($result); echo "".translate("Category: ")."$title"; echo "
    "; $result=mysql_query("select lid, title, description, date, hits from links_links where cid=$cid AND sid=0 limit $min,$perpage"); echo "
    "; $x=0; while(list($lid, $title, $description, $time, $hits)=mysql_fetch_row($result)) { if ($admin) { echo ".translate( $title"; } else { echo " $title"; } if ($hits>=$popular) { echo " .translate("; } echo "
    "; echo "".translate("Description: ")."$description
    "; setlocale ("LC_TIME", "$locale"); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime); $datetime = strftime("".translate("linksdatestring")."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1])); $datetime = ucfirst($datetime); echo "".translate("Added on: ")."$datetime ".translate("Hits: ")."$hits

    "; $x++; } echo "
    "; $prev=$min-$perpage; if ($prev>=0) { print ""; print "

    ".translate("Previous Page").""; } $next=$min+$perpage; if ($x>=$perpage) { print ""; print "

    ".translate("Next Page").""; } echo "
  • "; include("footer.php3"); } function viewslink($sid, $min) { global $admin; include("header.php3"); include("config.php3"); $mainlink = 1; menu($mainlink); if (!isset($min)) $min=0; if (!isset($max)) $max=$min+$perpage; echo "
    "; echo "
    "; echo "

    "; SearchForm(); echo "
    "; $result = mysql_query("select cid, title from links_subcategories where sid=$sid"); list($cid, $stitle) = mysql_fetch_row($result); $result2 = mysql_query("select cid, title from links_categories where cid=$cid"); list($cid, $title) = mysql_fetch_row($result2); echo "".translate("Main")." / $title / $stitle"; echo "
    "; $result=mysql_query("select lid, url, title, description, date, hits from links_links where sid=$sid limit $min,$perpage"); echo "
    "; $x=0; while(list($lid, $url, $title, $description, $time, $hits)=mysql_fetch_row($result)) { if ($admin) { echo ".translate( $title
    "; } else { echo " $title
    "; } echo "".translate("Description: ")."$description
    "; setlocale ("LC_TIME", "$locale"); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime); $datetime = strftime("".translate("linksdatestring")."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1])); $datetime = ucfirst($datetime); echo "".translate("Added on: ")."$datetime ".translate("Hits: ")."$hits

    "; $x++; } echo "
    "; $prev=$min-$perpage; if ($prev>=0) { print ""; print "

    ".translate("Previous Page").""; } $next=$min+$perpage; if ($x>=$perpage) { print ""; print "

    ".translate("Next Page").""; } echo "
    "; include("footer.php3"); } function visit($lid) { dbconnect(); mysql_query("update links_links set hits=hits+1 where lid=$lid"); $result = mysql_query("select url from links_links where lid=$lid"); list($url) = mysql_fetch_row($result); Header("Location: $url"); } function search($query, $min) { include("config.php3"); global $admin; if (!isset($min)) $min=0; if (!isset($max)) $max=$min+$linksresults; $query = stripslashes($query); dbconnect(); $result = mysql_query("select lid, cid, sid, title, url, description, date, hits from links_links where title LIKE '%$query%' OR description LIKE '%$query%' ORDER BY title DESC LIMIT $min,$linksresults"); $nrows = mysql_num_rows($result); $resultx = mysql_query("select * from links_subcategories where title LIKE '%$query%' ORDER BY title DESC"); $nrowsx = mysql_num_rows($resultx); $x=0; include("header.php3"); $mainlink = 0; menu($mainlink); echo "

    "; SearchForm(); if ($nrows>0 OR $nrowsx>0) { $result2 = mysql_query("select cid, sid, title from links_subcategories where title LIKE '%$query%' ORDER BY title DESC"); echo "".translate("Search Results for: ")."$query

    "; echo "
    ".translate("SubCategories")."
    "; while(list($cid, $sid, $stitle) = mysql_fetch_row($result2)) { $cate = mysql_query("select title from links_categories where cid=$cid"); list($ctitle) = mysql_fetch_row($cate); $res = mysql_query("select * from links_links where sid=$sid"); $numrows = mysql_num_rows($res); $ctitle = ereg_replace($query, "$query", $ctitle); $stitle = ereg_replace($query, "$query", $stitle); echo "
  • $ctitle / $stitle ($numrows)
    "; } echo "
    ".translate("Links")."
    "; while(list($lid, $cid, $sid, $title, $url, $description, $time, $hits) = mysql_fetch_row($result)) { $title = ereg_replace($query, "$query", $title); if ($admin) { echo ".translate( $title
    "; } else { echo " $title
    "; } $description = ereg_replace($query, "$query", $description); echo "".translate("Description: ")."$description
    "; setlocale ("LC_TIME", "$locale"); ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $time, $datetime); $datetime = strftime("".translate("linksdatestring")."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1])); $datetime = ucfirst($datetime); echo "".translate("Added on: ")."$datetime ".translate("Hits: ")."$hits
    "; $result3 = mysql_query("select title from links_categories where cid=$cid"); $result4 = mysql_query("select title from links_subcategories where sid=$sid"); list($ctitle) = mysql_fetch_row($result3); list($stitle) = mysql_fetch_row($result4); if ($stitle=="") { $slash = ""; } else { $slash = "/"; } echo "".translate("Category: ")."$ctitle $slash $stitle

    "; $x++; } } else { echo "
    ".translate("No matches found to your query")."


    "; } $prev=$min-$linksresults; if ($prev>=0) { print ""; print "

    ".translate("Previous Page").""; } $next=$min+$linksresults; $tmp = $linksresults-1; if ($x>=$tmp) { print ""; print "

    ".translate("Next Page").""; } echo "

    ".translate("Try to search")." \"$query\" ".translate("in others Search Engines")."
    Alta Vista - HotBot - Infoseek - Deja News - Lycos - Yahoo
    LinuxStart - 1stLinuxSearch - Google - LinuxLinks - Freshmeat - JustLinux
    "; echo "
  • \n"; echo "\n"; include("footer.php3"); } switch($op) { case "menu": menu($mainlink); break; case "AddLink": AddLink(); break; case "NewLinks": NewLinks(); break; case "TheBest": TheBest(); break; case "RandomLink": RandomLink(); break; case "viewlink": viewlink($cid, $min); break; case "viewslink": viewslink($sid, $min); break; case "visit": visit($lid); break; case "Add": Add($title, $url, $name, $cat, $description, $name, $email); break; case "search": search($query, $min); break; default: index(); break; } ?>