FC counter  

  Home      Add Links      New Links      Popular Links      Top Rated      Most Popular Search      Search  
$sitename"; ?>Powered By - Links Caffe & web9000.com  

Search Again :      
* Note : Last word must contain at least 3 characters.
- Directory
"; $i = 1; while($row = mysql_fetch_array($rime)) { extract($row); $id = $row["lcat_id"]; $name = $row["lcat_name"]; $cat_icon = $row["cat_icon"]; if ($showicon=="1") { if($cat_icon==""){$cat_icon="icon.gif";}else{$cat_icon=$cat_icon;} $icon = " "; } $rime11 = mysql_query("SELECT COUNT(*) from links WHERE link_val LIKE 'yes' AND cat_id='$id'") or die(mysql_error()); $totalnum = mysql_result($rime11, 0, 0); $navigator = "" ; $rime1= mysql_query("SELECT * FROM category WHERE sub_cat='$id' LIMIT $nosub") or die(mysql_error()); while($row = mysql_fetch_array($rime1)) { extract($row); $ida = $row["lcat_id"]; $name1 = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $linnk = "$name1"; $navigator = $linnk ." ".$navigator; } echo "";} else echo ""; if (is_int($i / $nocat)) echo ""; $i++; } echo "
$icon$name "; If ($shownumlinks=="1"){echo " ($totalnum)";} If ($nosub >0){echo "
$navigator

"; showlinksfooter(); If ($counter=="1"){showcounter();} exit; } function showaddlink() { require( './paramlinks.inc.php'); ?> : How to add a link

: You Are Rated

: Error Rating Link

$sitename : Search Term


"; echo "
Thanks, your search has been completed, please stand by as we take you to the search results.
"; ?>
$sitename : MOST POPULAR SEARCHES


Keywords
"; $rime = mysql_query("SELECT DISTINCT(search_word), sum(count) as hepa FROM search WHERE search_word!=' ' GROUP BY search_word ORDER BY hepa DESC LIMIT 20") or die(mysql_error()); while($row = mysql_fetch_array($rime)) { extract($row); $search_word = $row["search_word"]; echo "$search_word ($hepa)  "; } echo "

Terms
"; $rime = mysql_query("SELECT DISTINCT(search_word), sum(count) as hepa FROM search_phrase GROUP BY search_word ORDER BY hepa DESC LIMIT 20") or die(mysql_error()); while($row = mysql_fetch_array($rime)) { extract($row); $search_word = $row["search_word"]; echo "$search_word ($hepa)  "; } showlinksfooter(); exit; } if ($action=="addlink") { $sitenames = "$sitename - Add Link"; include('header.inc.php'); showlinksheader(); dbConnect(); if (!ereg("^[0-9]+$", $lcat_id)) { showaddlink(); showlinksfooter(); exit; } $rime9 = mysql_query("SELECT * from category WHERE lcat_id='$lcat_id'") or die(mysql_error()); $num_cat = mysql_numrows($rime9); If (!$num_cat) { showaddlink(); showlinksfooter(); exit; } else dbConnect(); ?> Please fill in the following fields to add your Web site to
$sitename

We Do Not Accept Links That Contain ...

  • Adult material
  • Anonomous websites (your site must have your business name and contact info listed)
  • Personal webpages
  • Non-english websites

    "; $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$lcat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ."/" .$navigator; } ?> Category : Link Name : Link URL : Description : Keywords : Email address :
    • 6){ echo "$sitename : Add a Link

    "; echo "Link $link_url was added earlier.
    You do not need update link.

    "; $rime2 = mysql_query("SELECT *,(rating/rate) AS arate from links WHERE link_url LIKE '$link_url'") or die(mysql_error()); while($row = mysql_fetch_array($rime2)) { extract($row); echo " $link_name
    "; echo " $link_desc
    "; echo " | hits $hits vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT |
    "; } } else { $rime = mysql_query("SELECT lcat_name from category") or die(mysql_error()); if (($lcat_id) &&($link_name) && ($link_url) && ($link_desc) && ($link_keyword) && ($link_email)) { $link_name = strip_tags($link_name); $link_url = strip_tags($link_url); $link_desc = strip_tags($link_desc); $link_keyword= strip_tags($link_keyword); $link_email= strip_tags($link_email); $rime1 = "INSERT into links VALUES ('NULL','$lcat_id','$link_name','$link_url','$link_desc','$link_keyword','$link_email','no',NOW(),'','no','','$hits','$rate','$rating','$exp_date','$sponsorlogo')"; $rime=$rime; $result = mysql_query($rime1); echo "$sitename : Add a Link : Thank You

    "; echo "Your link $link_name is now awaiting validation by our webmaster.


    $sitename
    Links Manager    "; $rime4 = mysql_query("SELECT * from links WHERE link_val!='yes'") or die(mysql_error()); $result = mysql_numrows($rime4); if($result == $nolinksvalidate OR $result==2*$nolinksvalidate OR $result==3*$nolinksvalidate) { $header = "From: $webmaster\n"; $header .= "MIME-Version: 1.0\n"; $header .= "Content-Type: text/html; charset=iso-8859-1\n"; $message = "Dear webmaster,

    You have $result links to validate.
    Please go to Admin to validate links.

    Sincerely,
    Link Manager
    $sitename

    "; mail("$webmaster","Validate links in $sitename","$message","$header"); } } else { echo "$sitename : Add a Link

    "; echo "All fields are required. Please go back.

    "; } } showlinksfooter(); exit; } if ($action=="new") { $sitenames = "$sitename - New Links"; include('header.inc.php'); showlinksheader(); dbConnect(); if ($start) { settype($start, 'integer'); } else { $start = 0; } $climit = $nolinksnew + 0; if (!$newdays) { $newdays=$daysnew; } else { $newdays=$newdays; } $rime1 = mysql_query("SELECT COUNT(*) from links WHERE (to_days(NOW()) - to_days(links.date)) <= $newdays AND link_val = 'yes'") or die(mysql_error()) ; $totalnum = mysql_result($rime1, 0, 0); $rime=mysql_query("SELECT *,(rating/rate) AS arate FROM links WHERE (to_days(NOW()) - to_days(links.date)) <= $newdays AND link_val = 'yes' ORDER BY date DESC LIMIT $start, $climit"); echo "$sitename : New Links

    "; echo "Displaying links added in the last $newdays days. $totalnum links will be displayed.

    "; while($row = mysql_fetch_array($rime)) { extract($row); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ." / " .$navigator; } echo " $link_name
    "; echo " $link_desc
    "; If ($showlinknav=="1") { echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT | CATEGORY |
    "; } echo "
    "; } if (mysql_num_rows($rime) == $climit) { $next_url = $start + $nolinksnew; $next = 'Next -'.$nolinksnew.''; } else { $to = $start + mysql_num_rows($rime); } $back_url = $start - $nolinksnew; $prev = ($start) ? '  Previous-'.$nolinksnew.'' : ''; echo "$next $prev"; echo "
    Show links added in the last days.
    "; showlinksfooter(); exit; } if ($action=="popular") { $sitenames = "$sitename - Popular Links"; include('header.inc.php'); showlinksheader(); dbConnect(); if ($start) { settype($start, 'integer'); } else { $start = 0; } $climit = $nolinkspop + 0; $rime=mysql_query("SELECT *,(rating/rate) AS arate FROM links WHERE link_val = 'yes' AND hits >= '$noratepopular' ORDER BY hits DESC, date ASC LIMIT $start, $climit"); $numlinks = mysql_num_rows($rime); echo "$sitename : Popular Links

    "; echo "Displaying popular links. Links with $noratepopular hits will be display.

    "; while($row = mysql_fetch_array($rime)) { extract($row); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ." / " .$navigator; } echo " $link_name
    "; echo " $link_desc
    "; If ($showlinknav=="1") { echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT | CATEGORY |
    "; } echo "
    "; } if (mysql_num_rows($rime) == $climit) { $next_url = $start + $nolinkspop; $next = 'Next -'.$nolinkspop.''; } else { $to = $start + mysql_num_rows($rime); } $back_url = $start - $nolinkspop; $prev = ($start) ? 'Previous-'.$nolinkspop.'' : ''; echo "$prev  $next"; showlinksfooter(); exit; } if ($action=="editor") { $sitenames = "$sitename - Editor's Chose"; include('header.inc.php'); showlinksheader(); dbConnect(); if ($start) { settype($start, 'integer'); } else { $start = 0; } $climit = $nolinksedit + 0; $rime=mysql_query("SELECT *,(rating/rate) AS arate FROM links WHERE link_pop = 'pop' AND link_val = 'yes' ORDER BY link_name ASC LIMIT $start, $climit"); echo "$sitename : Editor's Choice

    "; echo "Displaying editor's choice links.

    "; while($row = mysql_fetch_array($rime)) { extract($row); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ." / " .$navigator; } echo " $link_name
    "; echo " $link_desc
    "; If ($showlinknav=="1") { echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT | CATEGORY |
    "; } echo "
    "; } if (mysql_num_rows($rime) == $climit) { $next_url = $start + $nolinksedit; $next = 'Next -'.$nolinksedit.''; } else { $to = $start + mysql_num_rows($rime); } $back_url = $start - $nolinksedit; $prev = ($start) ? 'Previous-'.$nolinksedit.'' : ''; echo "$prev  $next"; showlinksfooter(); exit; } if ($action=="top") { $sitenames = "$sitename - Top rated"; include('header.inc.php'); showlinksheader(); dbConnect(); $rime=mysql_query("SELECT *,(rating/rate) AS arate FROM links WHERE link_val = 'yes' AND rate>=$noratetop ORDER BY arate DESC, hits DESC LIMIT $nolinkstop"); echo "$sitename : Top rated

    "; echo "Displaying top rated links. A maximum of $nolinkstop links will be displayed.

    "; echo "
      "; while($row = mysql_fetch_array($rime)) { extract($row); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ." / " .$navigator; } echo "
    1. $link_name
      "; echo " $link_desc
      "; If ($showlinknav=="1") { echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT | CATEGORY |
      "; } echo "
      "; } echo "
    "; showlinksfooter(); exit; } if ($action=="searchform") { $sitenames = "$sitename - Search Form"; include('header.inc.php'); showlinksheader(); echo "$sitename : Search Links"; showsearchtable(); showlinksfooter(); exit; } if ($action=="rated") { $sitenames = "$sitename Rate It"; dbConnect(); $rime= mysql_query("SELECT link_id, hits, link_url FROM links WHERE link_id = '$link_id'") or die(mysql_error()); if (!ereg("^[0-9]+$", $link_id)) { showindex(); exit; } while ($row = mysql_fetch_array($rime)) { $hits = $row["hits"]; $link_id = $row["link_id"]; $link_url = $row["link_url"]; } $hits++; $rime2 = @mysql_query("UPDATE links SET hits = '$hits' WHERE link_id = '$link_id'"); echo ""; exit; } if ($action=="vote") { $sitenames = "Vote"; include('header.inc.php'); showlinksheader(); dbConnect(); ?> : Vote Link

    Please rate the link between five and ten.


    = 1) { showvote(); showlinksfooter(); exit; } else $rime1 = mysql_query("SELECT rate, rating, link_id, link_name, link_url FROM links WHERE link_id = '$link_id' AND link_val='yes'") or die(mysql_error()); $result1 = mysql_num_rows($rime1); if ($result1 == 0) { showrate(); showlinksfooter(); exit; } $rate++; $rating = $rating + $score; $result2 = @mysql_query("UPDATE links SET rate = '$rate', rating = '$rating' WHERE link_id = '$link_id'"); mysql_query ("INSERT INTO vote (date, host, linkID) VALUES (NOW(),'$client','$link_id')"); if ($rate > 0) { $arate = sprintf ("%.2f", ($rating / $rate)); } else { $arate = '0'; } ?> : Thank You

    • Thank You for Rating -
    • You have rated it .
    • Link has been voted times, and has an average of .




      Links Manager
    : Broken Link

    Thank you for reporting a broken Link.
    $link_name
    $link_desc
    "; echo "
    "; } ?>
    : Thank You
    Thank you for letting us know about the broken/dead link you found.


    $sitename
    Links Manager    "; $rime4 = mysql_query("SELECT * from links WHERE link_broken LIKE 'yes'") or die(mysql_error()); $result = mysql_numrows($rime4); if($result == $nolinksvalidate OR $result==2*$nolinksvalidate OR $result==3*$nolinksvalidate) { $header = "From: $webmaster\n"; $header .= "MIME-Version: 1.0\n"; $header .= "Content-Type: text/html; charset=iso-8859-1\n"; $message = "Dear webmaster,

    You have $result links reported as broken.
    Please go to Admin to validate links.

    Sincerely,
    Link Manager
    $sitename

    "; mail("$webmaster","Broken links in $sitename","$message","$header"); } } else { echo "
    You did not enter any data.
    "; } showlinksfooter(); exit; } if ($search) { $sitenames = "$sitename - Search Result for $search"; include('header.inc.php'); showlinksheader(); dbConnect(); $limit = 20; if (empty($page)) { $page = 1; } $offset = $limit * ($page - 1); $searchwords = split ( "[ ,]", $search ); $search = strtoupper($search); echo "$sitename : Search Links"; $first = true; foreach ( $searchwords as $word ) { if ( $first ) { $first = false; $like .= " WHERE "; } elseif ( $andor == "or" ) $like .= " OR "; else $like .= " AND "; $word = chop($word); $like .= "link_val = 'yes' AND (link_id LIKE '%$word%' OR link_name LIKE '%$word%' OR link_desc LIKE '%$word%' OR link_keyword LIKE '%$word%' OR link_url LIKE '%$word%' OR link_pop LIKE '%$word%')"; } $words = $word; if (strlen($words) < 3) { echo "

    WEB RESULTS for $search resulted in the following matches : $totalnum links

    "; showsearchtable(); showlinksfooter(); exit; } $rime1 = mysql_query("SELECT COUNT(*) from links $like") or die(mysql_error()); $totalnum = mysql_result($rime1, 0, 0); $numrows = mysql_result($rime1, 0, 0); if ($totalnum < 1) { echo "

    WEB RESULTS for $search resulted in the following matches : no links

    "; showsearchtable(); showlinksfooter(); exit; } else { echo "

    WEB RESULTS for $search resulted in the following matches : $totalnum links

    "; $rime = mysql_query ("SELECT *,(rating/rate) AS arate FROM links $like ORDER BY link_pop DESC, link_name ASC LIMIT $offset, $limit"); while($row = mysql_fetch_array($rime)) { extract($row); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat_id'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = $name ." / " .$navigator; } echo " $link_name
    "; echo " $link_desc
    "; If ($showlinknav=="1") { echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT | CATEGORY |
    "; } echo "
    "; } $search = strtolower($search); echo "
    Result Page : "; if ($page > 1) { $regpage = $page - 1; echo "first "; echo "prev "; } $numpages = intval($numrows / $limit); if ($numrows % $limit) { $numpages++; } $firstpage=max(1,$page-5); $lastpage=min($numpages,$firstpage+15); for($i=$firstpage; $i<=$lastpage; ++$i) { if($page != $i) { echo ""; } echo $i; if($page != $i) { echo " "; } echo " \n"; } if ($page < $numpages) { $refpage = $page + 1; echo "next "; echo "last

    \n"; } } ?>

    0 && $count>=2) { mysql_query ("UPDATE search_phrase SET count=count+1 WHERE search_word = '$search' AND date LIKE '$date1'"); } elseif($count>=2) { mysql_query ("INSERT INTO search_phrase (search_word, count, date) VALUES ('$search','1',NOW())"); } $search2=explode(" ",$search); for($i=0;$i0) { mysql_query ("UPDATE search SET count=count+1 WHERE search_word = '$searchs' AND date LIKE '$date1'"); } elseif(strlen($searchs)>3) { mysql_query ("INSERT INTO search (search_word, count, date) VALUES ('$searchs','1',NOW())"); } } } showlinksfooter(); exit; } if ($cat) { dbConnect(); $rime22 = mysql_query("SELECT * from category WHERE lcat_id='$cat'") or die(mysql_error()); $row = mysql_fetch_array($rime22); $name = $row["lcat_name"]; $sitenames = "$sitename - $name"; include('header.inc.php'); showlinksheader(); $limit = $nolinks; $offset = ($offset) ? $offset : 0; $query = "&cat=".urlencode($cat); dbConnect(); $rime1 = mysql_query("SELECT COUNT(*) from links WHERE link_val LIKE 'yes' AND cat_id LIKE '$cat'") or die(mysql_error()); $totalnum = mysql_result($rime1, 0, 0); $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$cat'") or die(mysql_error()); while($row = mysql_fetch_array($rime2)) { extract($row); $id = $row["lcat_id"]; $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $navigator = "" .$name ."" . "" ; while ($sub_cat > 0) { $rime2 = mysql_query("SELECT * from category WHERE lcat_id='$sub_cat'") or die(mysql_error()); $row = mysql_fetch_array($rime2); $id = $row["lcat_id"]; $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $linnk = "$name >"; $linnk1 = "$name"; $navigator = $linnk . " " .$navigator; } echo "Home > $navigator
    "; $hepa = "$cat_desc
    "; if($showdescription==1 && $cat_desc!==""){echo "$hepa";} $rime = mysql_query("SELECT * FROM category WHERE sub_cat='$lcat_id'") or die(mysql_error()); $numrows = mysql_num_rows($rime); if ($numrows != 'NULL') { echo ""; echo ""; $nocol=1; while ($i < $numrows) { $row = mysql_fetch_array($rime); $ida = $row["lcat_id"]; $name = $row["lcat_name"]; $sub_cat = $row["sub_cat"]; $cat_icon = $row["cat_icon"]; $rime7 = mysql_query("SELECT * FROM links WHERE cat_id='$ida'") or die(mysql_error()); $numrows7 = mysql_num_rows($rime7); if ($showicon=="1") { if($cat_icon==""){$cat_icon="icon.gif";}else{$cat_icon=$cat_icon;} $icon = " "; } $shownumber = "1"; If ($shownumber == $shownumlinks){$shownum = "($numrows7)";} $widthcol = 100/$nosubcat; if ($nocol==$nosubcat) { echo ""; echo ""; $i++; $nocol=1; } else { echo ""; $nocol++; $i++; } } echo "
    "; echo "$icon $name $shownum "; echo "
    "; echo "$icon $name $shownum"; echo "
    "; echo "
    "; } $rime1 = mysql_query("SELECT * from links WHERE link_pop LIKE 'pop' AND link_val LIKE 'yes' AND cat_id LIKE '$cat' ORDER BY link_name") or die(mysql_error()); $result = mysql_num_rows($rime1); if ($result>0 && $offset=='') { echo "$sponsortext

    "; while($row = mysql_fetch_array($rime1)) { extract($row); if ($rate > 0) { $arate = sprintf ("%.2f", ($rating / $rate)); } else { $arate = '0'; } if(!$sponsorlogo){$logo="";}else{$logo = "";} echo ""; } echo "
    $logo"; echo "$link_name
    "; echo "$link_desc
    "; echo "| hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT |

    "; } $totalnum = $totalnum - $result; echo "$totalnum links will be displayed in category $lcat_name

    "; } $rime = mysql_query("SELECT * from links WHERE link_val like 'yes' AND cat_id LIKE '$cat' AND link_pop!='pop' ORDER BY link_name ASC LIMIT $offset, $limit") or die(mysql_error()); while($row = mysql_fetch_array($rime)) { extract($row); if ($rate > 0) { $arate = sprintf ("%.2f", ($rating / $rate)); } else { $arate = '0'; } echo " $link_name
    "; echo " $link_desc
    "; echo " | hits $hits | vote $rate rating $arate | [Added: $date] DEAD LINK | RATE IT |

    "; } ShowNav($totalnum, $query, $offset, $limit); showlinksfooter(); exit; } function ShowNav($totalnum, $query, $offset, $limit) { global $PHP_SELF; if ($totalnum > $limit) { $pages = intval($totalnum/$limit); if ($totalnum%$limit) $pages++; if (($offset + $limit) > $totalnum) { $lastnum = $totalnum; } else { $lastnum = ($offset + $limit); } ?>
    Page
    "; } return; } echo "" ?>