> Home > Popular Links
"; $sql_rqst="SELECT * FROM links WHERE approved='yes' ORDER BY clicks DESC LIMIT 0,".$popular; } else if($list_type=="date_added") { echo "$new Newest Links
"; echo "> Home > Newest Links
"; $sql_rqst="SELECT * FROM links WHERE approved='yes' ORDER BY date_added,id ASC LIMIT 0,".$new; } else { $topic_result = MySQLQuery("SELECT * FROM links_cat WHERE id=$cat_id", $QueryError_Email,$QueryError_Browser); while($topic_row = mysql_fetch_array($topic_result)) { $id=$topic_row["id"]; $formcat_id=$topic_row["id"]; $sub_cat=$topic_row["sub_cat"]; $name=$topic_row["name"]; $dsc=$topic_row["dsc"]; } if($sub_cat != 0) { $topic2_result = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE id=$sub_cat", $QueryError_Email,$QueryError_Browser); while($topic2_row = mysql_fetch_array($topic2_result)) { $id2=$topic2_row["id"]; $sub_cat2=$topic2_row["sub_cat"]; $name2=$topic2_row["name"]; } $trail="$name2 > $name"; } else { $trail=$name; } echo "$name
"; echo "> Home > $trail
"; echo "$dsc
"; if(!isset($start)){$start = 0;} $sql_rqst="SELECT * FROM links WHERE cat_id=".$_GET["cat_id"]." AND approved='yes' ORDER BY ".$list_by." ".$list_order." LIMIT ".$start.",".$category; $page_result = MySQLQuery("SELECT * FROM links WHERE cat_id=$cat_id",$QueryError_Email,$QueryError_Browser); $previous_page=$start - $category; $next_page=$start + $category; $numrows=mysql_num_rows($page_result); if(($start > 0) || ($numrows > ($start + $category))){echo "";} if($start > 0){echo "[ < < Previous ]\n";} if($numrows > ($start + $category)){echo "[ Next > > ]\n";} if(($start > 0) || ($numrows > ($start + $category))){echo "
";} } $result = MySQLQuery($sql_rqst,$QueryError_Email,$QueryError_Browser); while($row = mysql_fetch_array($result)) { $id=$row["id"]; $name=$row["name"]; $clicks=$row["clicks"]; $approved=$row["approved"]; $url=$row["url"]; $dsc=$row["dsc"]; $date_added=$row["date_added"]; $year = substr($date_added, 0, 4); $month = substr($date_added, 5, 2); $day = substr($date_added, 8, 2); $date_added=date($display_format,mktime("00","00","00",$month,$day,$year)); $image=$row["image"]; $rating=$row["rating"]; $rates=$row["rates"]; if($image_enabled=="yes" && $image) { $image="
Added: | Total Clicks: | Rating: | Rate This Website | Notify of Dead Link
";} if($start > 0){echo "[ < < Previous ]\n";} if($numrows > ($start + $category)){echo "[ Next > > ]\n";} if(($start > 0) || ($numrows > ($start + $category))){echo "
";} } } else if($ax=="out") { $result = MySQLQuery("SELECT id,url,clicks FROM links WHERE id=".$_GET["id"],$QueryError_Email,$QueryError_Browser); while($row = mysql_fetch_array($result)) { $id=$row["id"]; $url=$row["url"]; $clicks=$row["clicks"]; $clicks=$clicks+1; $up_clicks = MySQLQuery("UPDATE links SET clicks='$clicks' WHERE id='$id'",$QueryError_Email,$QueryError_Browser); ob_end_clean(); header("Location: ".$url); } } else if($ax=="deadlink") { $result = MySQLQuery("SELECT id,name,url FROM links WHERE id=".$_GET["id"],$QueryError_Email,$QueryError_Browser); while($row = mysql_fetch_array($result)) { $id=$row["id"]; $url=$row["url"]; $name=$row["name"]; $clicks=$clicks+1; $message="$name\n$url\nis being reported as a dead link in the links directory at $site_title"; mail("$admin_mail","Dead Link Report from $site_title","$message","From: $admin_mail"); echo "Thank You
"; echo "> Home > Report Dead Link
"; echo "You have reported $name linked to $url as being a deal link in our directory.
"; echo "This message has been sent to the web site administrator, thank you for your help.
"; } } else if($ax=="addrate") { $id=$_GET["id"]; $cat_id=$_GET["cat_id"]; $new_rating=$_POST["rating"]; $result = MySQLQuery("SELECT id,rating,rates FROM links WHERE id=$id;",$QueryError_Email,$QueryError_Browser); while($row = mysql_fetch_array($result)) { $rating=$row["rating"]; $rating=$rating + $new_rating; $rates=$row["rates"]; $rates=$rates + 1; $up_clicks = MySQLQuery("UPDATE links SET rating='$rating',rates='$rates' WHERE id='$id'",$QueryError_Email,$QueryError_Browser); echo "Thanks for your input
\n"; echo "> Home > Rating
"; echo "Your rating has been added, thank you.
\n"; } if($list_type=="") { $sub_result = MySQLQuery("SELECT id,sub_cat FROM links_cat WHERE id=".$cat_id."",$QueryError_Email,$QueryError_Browser); while($sub_row = mysql_fetch_array($sub_result)) { $list_type=$_GET["l"]; if($list_type=="") { $id=$sub_row["id"]; $subcat=$sub_row["sub_cat"]; if($subcat==0){$subcat=$id;} echo "To return to the page you were at, click here.
\n"; } } } else { echo "To return to the page you were at, click here.
\n"; } } ////////////////// // Search Function ////////////////// else if ($ax=="search") { echo "Search Results
"; echo "> Home > Search Results
"; if(!isset($start)) { $start = 0; $search_for=$_POST["search_for"]; } else { $search_for=$_GET["search_for"]; } $result = MySQLQuery("SELECT * FROM links WHERE (name LIKE '%".$search_for."%' OR url LIKE '%".$search_for."%' OR dsc LIKE '%".$search_for."%') AND approved='yes' ORDER BY name ASC LIMIT $start,$search",$QueryError_Email,$QueryError_Browser); $page_result = MySQLQuery("SELECT * FROM links WHERE (name LIKE '%".$search_for."%' OR url LIKE '%".$search_for."%' OR dsc LIKE '%".$search_for."%') AND approved='yes' ORDER BY id DESC",$QueryError_Email,$QueryError_Browser); $previous_page=$start - $search; $next_page=$start + $search; $numrows=mysql_num_rows($page_result); echo "Total of $numrows Records Returned
"; if(($start > 0) || ($numrows > ($start + $search))){echo "";} if($start > 0){echo "[ < < Previous ]\n";} if($numrows > ($start + $search)){echo "[ Next > > ]\n";} if(($start > 0) || ($numrows > ($start + $search))){echo "
";} while($row = mysql_fetch_array($result)) { $id=$row["id"]; $name=$row["name"]; $clicks=$row["clicks"]; $approved=$row["approved"]; $url=$row["url"]; $dsc=$row["dsc"]; if ($approved=="yes") { if($clicks==""){$clicks="0";} echo "$name
[ $url | Total Clicks: $clicks | Notify of Dead Link ]
$dsc
";} if($start > 0){echo "[ < < Previous ]\n";} if($numrows > ($start + $search)){echo "[ Next > > ]\n";} if(($start > 0) || ($numrows > ($start + $search))){echo "
";} } /////////////////////////// // Add and Insert Functions /////////////////////////// else if($ax=="add") { $date_added=date($date_format); ?>Add a Link
> Home > Add a Link
All Fields are required for link submission
The Link Was Added"; echo "Home > Add a Link > Link Added
"; if($admin_approved=="no") { echo "Your link request has been sent to the site administrator for approval.
"; echo "An email has also been sent to you regarding your login information should you choose to edit your listing in the future.
"; } else { echo "Your link has been added to the directory.
"; echo "An email has also been sent to you regarding your login information should you choose to edit your listing in the future.
"; } } else { echo "Home > Add a Link > Error Adding Link
Error Adding Link
"; } } ////////////////////////////// // Login and Editing Functions ////////////////////////////// else if($ax=="login") { ?>Edit Your Listing
> Home > Edit Login
Edit a Link
> Home > ">Edit Login > Edit
No Records Found"; echo "No web site listing can be found with that URL, email address or password.
"; echo "Click here to get login info for all websites listed to your email address sent to you.
"; } } else if($ax=="update") { $result11=MySQLQuery("select * from links where url='".$_POST["url"]."' and email='".$_POST["email"]."' and password='".$_POST["password"]."'",$QueryError_Email,$QueryError_Browser); if(mysql_num_rows($result11)) { while($row=mysql_fetch_array($result11)) { $id=$row["id"]; $cat_id=$row["cat_id"]; $name=$row["name"]; $dsc=$row["dsc"]; $url=$row["url"]; $image=$row["image"]; $email=$row["email"]; $password=$row["password"]; $cat_id=$_POST["cat_id"]; $name=$_POST["name"]; $dsc=$_POST["dsc"]; $url=$_POST["url"]; $email=$_POST["email"]; $password=$_POST["password"]; $image=$_POST["image"]; $result=MySQLQuery("update links set cat_id='$cat_id', name='$name', dsc='$dsc', url='$url', email='$email', password='$password', image='$image' where id='$id'",$QueryError_Email,$QueryError_Browser); if ($result) { if ($email && $password) { mail($email, "Link modified at ".$site_title."", "Your link has been modified.\n\nThanks for keeping it up to date.", "From: ".$noreply_mail); } echo "The Link Was Updated
"; echo "Home > Edit Login > Edit > $name Updated
"; } else { echo "Error Updating Link
"; } } } } ////////////////////////////// // Password Reminder Functions ////////////////////////////// else if($ax=="remind") { ?>Get Your Login Information
This will email you the login information for all URL's that have been submitted by the requested email address
Email SentYour Login Information has been sent to $email.
"; } else { echo "No Records Found
Sorry, no records were found registered to $email.
"; } } ////////////////// // Main Front Page ////////////////// else { $result = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE sub_cat='0' ORDER BY name ASC", $QueryError_Email,$QueryError_Browser); $count=0; if(mysql_num_rows($result)) { echo "| \n";} else if($count < $front_cols && $count > 1){echo " | \n | \n";} else if($count==$front_cols){echo " | \n | \n";}
echo "$name ($link_count $link_text) \n"; $result2 = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE sub_cat='$id' ORDER BY name ASC", $QueryError_Email,$QueryError_Browser); if(mysql_num_rows($result2)) { echo "
\n | \n";}
else if($count < $front_cols && $count > 1){echo "\n"; } echo " |
No categories found
"; } } include('footer.php'); ob_end_flush(); ?>