File: /home/asjudine/public_html/modules/Web_Links/index.php
<?php
if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
$pagetitle = "- "._WEBLINKS."";
require_once("mainfile.php");
require_once("modules/Web_Links/l_config.php");
function getparent($parentid,$title) {
global $prefix, $dbi;
$result = sql_query("select cid, title, parentid from $prefix"._links_categories." where cid=$parentid", $dbi);
list($cid, $ptitle, $pparentid) = sql_fetch_row($result, $dbi);
if ($ptitle!="") $title=$ptitle."/".$title;
if ($pparentid!=0) {
$title=getparent($pparentid,$title);
}
return $title;
}
function getparentlink($parentid,$title) {
global $prefix, $dbi;
$result=sql_query("select cid, title, parentid from $prefix"._links_categories." where cid=$parentid", $dbi);
list($cid, $ptitle, $pparentid) = sql_fetch_row($result, $dbi);
if ($ptitle!="") $title="<a href=modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid>$ptitle</a>/".$title;
if ($pparentid!=0) {
$title=getparentlink($pparentid,$title);
}
return $title;
}
function menu($mainlink) {
OpenTable();
echo "<br><center><a href=\"modules.php?name=Web_Links\"><img src=\"images/links/web.gif\" border=\"0\" alt=\"\"></a><br><br>";
echo "<form action=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query\" method=\"post\">"
."<font class=\"content\"><input type=\"text\" size=\"25\" name=\"query\"> <input type=\"submit\" value=\""._SEARCH."\"></font>"
."</form>";
echo "<font class=\"content\">[ ";
if ($mainlink>0) {
echo "<a href=\"modules.php?name=Web_Links\">"._LINKSMAIN."</a> | ";
}
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=AddLink\">"._ADDLINK."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=NewLinks\">"._NEW."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular\">"._POPULAR."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated\">"._TOPRATED."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=RandomLink\">"._RANDOM."</a> ]"
."</font></center>";
CloseTable();
}
function SearchForm() {
echo "<form action=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query\" method=\"post\">"
."<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">"
."<tr><td><font class=\"content\"><input type=\"text\" size=\"25\" name=\"query\"> <input type=\"submit\" value=\""._SEARCH."\"></td></tr>"
."</table>"
."</form>";
}
function linkinfomenu($lid, $ttitle) {
echo "<br><font class=\"content\">[ "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$ttitle\">"._LINKCOMMENTS."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$ttitle\">"._ADDITIONALDET."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkeditorial&lid=$lid&ttitle=$ttitle\">"._EDITORREVIEW."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=modifylinkrequest&lid=$lid\">"._MODIFY."</a>"
." | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=brokenlink&lid=$lid\">"._REPORTBROKEN."</a> ]</font>";
}
function index() {
global $prefix, $dbi;
include("header.php");
$mainlink = 0;
menu($mainlink);
echo "<br>";
OpenTable();
echo "<center><font class=\"title\"><b>"._LINKSMAINCAT."</b></font></center><br>";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$result = sql_query("select cid, title, cdescription from $prefix"._links_categories." where parentid=0 order by title", $dbi);
$count = 0;
while(list($cid, $title, $cdescription) = sql_fetch_row($result, $dbi)) {
echo "<td><font class=\"option\"><strong><big>·</big></strong> <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid\"><b>$title</b></a></font>";
categorynewlinkgraphic($cid);
if ($description) {
echo "<font class=\"content\">$cdescription</font><br>";
} else {
echo "<br>";
}
$result2 = sql_query("select cid, title from $prefix"._links_categories." where parentid=$cid order by title limit 0,3", $dbi);
$space = 0;
while(list($cid, $stitle) = sql_fetch_row($result2, $dbi)) {
if ($space>0) {
echo ", ";
}
echo "<font class=\"content\"><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid\">$stitle</a></font>";
$space++;
}
if ($count<1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count==2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
$result=sql_query("select * from $prefix"._links_links."", $dbi);
$numrows = sql_num_rows($result, $dbi);
$result=sql_query("select * from $prefix"._links_categories."", $dbi);
$catnum = sql_num_rows($result, $dbi);
echo "<br><br><center><font class=\"content\">"._THEREARE." <b>$numrows</b> "._LINKS." "._AND." <b>$catnum</b> "._CATEGORIES." "._INDB."</font></center>";
CloseTable();
include("footer.php");
}
function AddLink() {
global $prefix, $dbi, $user, $links_anonaddlinklock;
include("header.php");
$mainlink = 1;
menu(1);
echo "<br>";
OpenTable();
echo "<center><font class=\"title\"><b>"._ADDALINK."</b></font></center><br><br>";
if (is_user($user) || $links_anonaddlinklock == 1) {
echo "<b>"._INSTRUCTIONS.":</b><br>"
."<strong><big>·</big></strong> "._SUBMITONCE."<br>"
."<strong><big>·</big></strong> "._POSTPENDING."<br>"
."<strong><big>·</big></strong> "._USERANDIP."<br>"
."<form method=\"post\" action=\"modules.php?op=modload&name=Web_Links&file=index&l_op=Add\">"
.""._PAGETITLE.": <input type=\"text\" name=\"title\" size=\"50\" maxlength=\"100\"><br>"
.""._PAGEURL.": <input type=\"text\" name=\"url\" size=\"50\" maxlength=\"100\" value=\"http://\"><br>";
echo ""._CATEGORY.": <select name=\"cat\">";
$result2=sql_query("select cid, title, parentid from $prefix"._links_categories." order by parentid,title", $dbi);
while(list($cid2, $ctitle2, $parentid2) = sql_fetch_row($result2, $dbi)) {
if ($parentid2!=0) $ctitle2=getparent($parentid2,$ctitle2);
echo "<option value=\"$cid2\">$ctitle2</option>";
}
echo "</select><br><br>"
.""._LDESCRIPTION."<br><textarea name=\"description\" cols=\"60\" rows=\"5\"></textarea><br><br><br>"
.""._YOURNAME.": <input type=\"text\" name=\"auth_name\" size=\"30\" maxlength=\"60\"><br>"
.""._YOUREMAIL.": <input type=\"text\" name=\"email\" size=\"30\" maxlength=\"60\"><br><br>"
."<input type=\"hidden\" name=\"op\" value=\"Add\">"
."<input type=\"submit\" value=\""._ADDURL."\"> "._GOBACK."<br><br>"
."</form>";
}else {
echo "<center>"._LINKSNOTUSER1."<br>"
.""._LINKSNOTUSER2."<br><br>"
.""._LINKSNOTUSER3."<br>"
.""._LINKSNOTUSER4."<br>"
.""._LINKSNOTUSER5."<br>"
.""._LINKSNOTUSER6."<br>"
.""._LINKSNOTUSER7."<br><br>"
.""._LINKSNOTUSER8."";
}
CloseTable();
include("footer.php");
}
function Add($title, $url, $auth_name, $cat, $description, $email) {
global $prefix, $dbi, $user;
$result = sql_query("select url from $prefix"._links_links." where url='$url'", $dbi);
$numrows = sql_num_rows($result, $dbi);
if ($numrows>0) {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><b>"._LINKALREADYEXT."</b><br><br>"
.""._GOBACK."";
CloseTable();
include("footer.php");
} else {
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$submitter = $cookie[1];
}
// Check if Title exist
if ($title=="") {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><b>"._LINKNOTITLE."</b><br><br>"
.""._GOBACK."";
CloseTable();
include("footer.php");
}
// Check if URL exist
if ($url=="") {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><b>"._LINKNOURL."</b><br><br>"
.""._GOBACK."";
CloseTable();
include("footer.php");
}
// Check if Description exist
if ($description=="") {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><b>"._LINKNODESC."</b><br><br>"
.""._GOBACK."";
CloseTable();
include("footer.php");
}
$cat = explode("-", $cat);
if ($cat[1]=="") {
$cat[1] = 0;
}
$title = stripslashes(FixQuotes($title));
$url = stripslashes(FixQuotes($url));
$description = stripslashes(FixQuotes($description));
$auth_name = stripslashes(FixQuotes($auth_name));
$email = stripslashes(FixQuotes($email));
sql_query("insert into $prefix"._links_newlink." values (NULL, '$cat[0]', '$cat[1]', '$title', '$url', '$description', '$auth_name', '$email', '$submitter')", $dbi);
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><b>"._LINKRECEIVED."</b><br>";
if ($email != "") {
echo _EMAILWHENADD;
} else {
echo _CHECKFORIT;
}
CloseTable();
include("footer.php");
}
}
function NewLinks($newlinkshowdays) {
global $prefix, $dbi;
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><font class=\"option\"><b>"._NEWLINKS."</b></font></center><br>";
$counter = 0;
$allweeklinks = 0;
while ($counter <= 7-1){
$newlinkdayRaw = (time()-(86400 * $counter));
$newlinkday = date("d-M-Y", $newlinkdayRaw);
$newlinkView = date("F d, Y", $newlinkdayRaw);
$newlinkDB = Date("Y-m-d", $newlinkdayRaw);
$result = sql_query("select * FROM $prefix"._links_links." WHERE date LIKE '%$newlinkDB%'", $dbi);
$totallinks = sql_num_rows($result, $dbi);
$counter++;
$allweeklinks = $allweeklinks + $totallinks;
}
$counter = 0;
while ($counter <=30-1){
$newlinkdayRaw = (time()-(86400 * $counter));
$newlinkDB = Date("Y-m-d", $newlinkdayRaw);
$result = sql_query("select * FROM $prefix"._links_links." WHERE date LIKE '%$newlinkDB%'", $dbi);
$totallinks = sql_num_rows($result, $dbi);
$allmonthlinks = $allmonthlinks + $totallinks;
$counter++;
}
echo "<center><b>"._TOTALNEWLINKS.":</b> "._LASTWEEK." - $allweeklinks \ "._LAST30DAYS." - $allmonthlinks<br>"
.""._SHOW.": <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=NewLinks&newlinkshowdays=7\">"._1WEEK."</a> - <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=NewLinks&newlinkshowdays=14\">"._2WEEKS."</a> - <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=NewLinks&newlinkshowdays=30\">"._30DAYS."</a>"
."</center><br>";
/* List Last VARIABLE Days of Links */
if (!isset($newlinkshowdays)) {
$newlinkshowdays = 7;
}
echo "<br><center><b>"._TOTALFORLAST." $newlinkshowdays "._DAYS.":</b><br><br>";
$counter = 0;
$allweeklinks = 0;
while ($counter <= $newlinkshowdays-1) {
$newlinkdayRaw = (time()-(86400 * $counter));
$newlinkday = date("d-M-Y", $newlinkdayRaw);
$newlinkView = date("F d, Y", $newlinkdayRaw);
$newlinkDB = Date("Y-m-d", $newlinkdayRaw);
$result = sql_query("select * FROM $prefix"._links_links." WHERE date LIKE '%$newlinkDB%'", $dbi);
$totallinks = sql_num_rows($result, $dbi);
$counter++;
$allweeklinks = $allweeklinks + $totallinks;
echo "<strong><big>·</big></strong> <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=NewLinksDate&selectdate=$newlinkdayRaw\">$newlinkView</a> ($totallinks)<br>";
}
$counter = 0;
$allmonthlinks = 0;
echo "</center>";
CloseTable();
include("footer.php");
}
function NewLinksDate($selectdate) {
global $prefix, $dbi,$admin;
$admin = base64_decode($admin);
$admin = explode(":", $admin);
$aid = "$admin[0]";
$result3 = sql_query("select radminlink,radminsuper from $prefix"._authors." where aid='$aid'", $dbi);
list($radminlink,$radminsuper) = sql_fetch_array($result3, $dbi);
$dateDB = (date("d-M-Y", $selectdate));
$dateView = (date("F d, Y", $selectdate));
include("header.php");
menu(1);
echo "<br>";
OpenTable();
$newlinkDB = Date("Y-m-d", $selectdate);
$result = sql_query("select * FROM $prefix"._links_links." WHERE date LIKE '%$newlinkDB%'", $dbi);
$totallinks = sql_num_rows($result, $dbi);
echo "<font class=\"option\"><b>$dateView - $totallinks "._NEWLINKS."</b></font>"
."<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
$result=sql_query("select lid, cid, sid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where date LIKE '%$newlinkDB%' order by title ASC", $dbi);
while(list($lid, $cid, $sid, $title, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments)=sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title); $description = stripslashes($description);
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"new\">$title</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>"._DESCRIPTION.": $description<br>";
setlocale ("LC_TIME", "$locale");
/* INSERT code for *editor review* here */
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
echo ""._ADDEDON.": <b>$datetime</b> "._HITS.": $hits";
$transfertitle = str_replace (" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary!="0" || $linkratingsummary!="0.0") {
echo " "._RATING.": $linkratingsummary ($totalvotes $votestring)";
}
echo "<br>";
if ($radminsuper==1 || $radminlink==1) {
echo "<a href=\"admin.php?op=LinksModLink&lid=$lid\">"._EDIT."</a> | ";
}
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$transfertitle\">"._RATESITE."</a>";
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=brokenlink&lid=$lid\">"._REPORTBROKEN."</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$transfertitle\">"._DETAILS."</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$transfertitle\">"._SCOMMENTS." ($totalcomments)</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br>";
$result2=sql_query("select title from $prefix"._links_categories." where cid=$cid", $dbi);
list($ctitle) = sql_fetch_row($result2, $dbi);
$ctitle=getparent($cid,$ctitle);
echo ""._CATEGORY.": $ctitle";
echo "<br><br>";
}
echo "</font></td></tr></table>";
CloseTable();
include("footer.php");
}
function TopRated($ratenum, $ratetype) {
include("header.php");
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $admin;
menu(1);
echo "<br>";
OpenTable();
echo "<table border=\"0\" width=\"100%\"><tr><td align=\"center\">";
if ($ratenum != "" && $ratetype != "") {
$toplinks = $ratenum;
if ($ratetype == "percent") {
$toplinkspercentrigger = 1;
}
}
if ($toplinkspercentrigger == 1) {
$toplinkspercent = $toplinks;
$result=sql_query("select * from $prefix"._links_links." where linkratingsummary != 0", $dbi);
$totalratedlinks = sql_num_rows($result, $dbi);
$toplinks = $toplinks / 100;
$toplinks = $totalratedlinks * $toplinks;
$toplinks = round($toplinks);
}
if ($toplinkspercentrigger == 1) {
echo "<center><font class=\"option\"><b>"._BESTRATED." $toplinkspercent% ("._OF." $totalratedlinks "._TRATEDLINKS.")</b></font></center><br>";
} else {
echo "<center><font class=\"option\"><b>"._BESTRATED." $toplinks </b></font></center><br>";
}
echo "</td></tr>"
."<tr><td><center>"._NOTE." $linkvotemin "._TVOTESREQ."<br>"
.""._SHOWTOP.": [ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=10&ratetype=num\">10</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=25&ratetype=num\">25</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=50&ratetype=num\">50</a> | "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=1&ratetype=percent\">1%</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=5&ratetype=percent\">5%</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=TopRated&ratenum=10&ratetype=percent\">10%</a> ]</center><br><br></td></tr>";
$result=sql_query("select lid, cid, sid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where linkratingsummary != 0 and totalvotes >= $linkvotemin order by linkratingsummary DESC limit 0,$toplinks", $dbi);
echo "<tr><td>";
while(list($lid, $cid, $sid, $title, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments)=sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title);
$description = stripslashes($description);
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"new\">$title</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>";
echo ""._DESCRIPTION.": $description<br>";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
echo ""._ADDEDON.": $datetime "._HITS.": $hits";
$transfertitle = str_replace (" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary!="0" || $linkratingsummary!="0.0") {
echo " "._RATING.": <b> $linkratingsummary </b> ($totalvotes $votestring)";
}
echo "<br><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$transfertitle\">"._RATESITE."</a>";
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=brokenlink&lid=$lid\">"._REPORTBROKEN."</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$transfertitle\">"._DETAILS."</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$transfertitle\">"._SCOMMENTS." ($totalcomments)</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br>";
$result2=sql_query("select title from $prefix"._links_categories." where cid=$cid", $dbi);
list($ctitle) = sql_fetch_row($result2, $dbi);
$ctitle=getparent($cid,$ctitle);
echo ""._CATEGORY.": $ctitle";
echo "<br><br>";
echo "<br><br>";
}
echo "</font></td></tr></table>";
CloseTable();
include("footer.php");
}
function MostPopular($ratenum, $ratetype) {
global $prefix,$admin,$dbi;
$admin = base64_decode($admin);
$admin = explode(":", $admin);
$aid = "$admin[0]";
$result3 = sql_query("select radminlink,radminsuper from $prefix"._authors." where aid='$aid'", $dbi);
list($radminlink,$radminsuper) = sql_fetch_array($result3, $dbi);
include("header.php");
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $admin;
menu(1);
echo "<br>";
OpenTable();
echo "<table border=\"0\" width=\"100%\"><tr><td align=\"center\">";
if ($ratenum != "" && $ratetype != "") {
$mostpoplinks = $ratenum;
if ($ratetype == "percent") $mostpoplinkspercentrigger = 1;
}
if ($mostpoplinkspercentrigger == 1) {
$toplinkspercent = $mostpoplinks;
$result=sql_query("select * from $prefix"._links_links."", $dbi);
$totalmostpoplinks = sql_num_rows($result, $dbi);
$mostpoplinks = $mostpoplinks / 100;
$mostpoplinks = $totalmostpoplinks * $mostpoplinks;
$mostpoplinks = round($mostpoplinks);
}
if ($mostpoplinkspercentrigger == 1) {
echo "<center><font class=\"option\"><b>"._MOSTPOPULAR." $toplinkspercent% ("._OFALL." $totalmostpoplinks "._LINKS.")</b></font></center>";
} else {
echo "<center><font class=\"option\"><b>"._MOSTPOPULAR." $mostpoplinks</b></font></center>";
}
echo "<tr><td><center>"._SHOWTOP.": [ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=10&ratetype=num\">10</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=25&ratetype=num\">25</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=50&ratetype=num\">50</a> | "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=1&ratetype=percent\">1%</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=5&ratetype=percent\">5%</a> - "
."<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=MostPopular&ratenum=10&ratetype=percent\">10%</a> ]</center><br><br></td></tr>";
$result=sql_query("select lid, cid, sid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." order by hits DESC limit 0,$mostpoplinks", $dbi);
echo "<tr><td>";
while(list($lid, $cid, $sid, $title, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments)=sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title);
$description = stripslashes($description);
echo "<font class=\"content\"><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"new\">$title</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>";
echo ""._DESCRIPTION.": $description<br>";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
echo ""._ADDEDON.": $datetime "._HITS.": <b>$hits</b>";
$transfertitle = str_replace (" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary!="0" || $linkratingsummary!="0.0") {
echo " "._RATING.": $linkratingsummary ($totalvotes $votestring)";
}
echo "<br>";
if ($radminsuper==1 || $radminlink==1) {
echo "<a href=\"admin.php?op=LinksModLink&lid=$lid\">"._EDIT."</a> | ";
}
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$transfertitle\">"._RATESITE."</a>";
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=brokenlink&lid=$lid\">"._REPORTBROKEN."</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$transfertitle\">"._DETAILS."</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$transfertitle\">"._SCOMMENTS." ($totalcomments)</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br>";
$result2=sql_query("select title from $prefix"._links_categories." where cid=$cid", $dbi);
list($ctitle) = sql_fetch_row($result2, $dbi);
$ctitle=getparent($cid,$ctitle);
echo ""._CATEGORY.": $ctitle";
echo "<br><br>";
echo "<br><br></font>";
}
echo "</font></td></tr></table>";
CloseTable();
include("footer.php");
}
function RandomLink() {
global $prefix, $dbi;
$result = sql_query("select * from $prefix"._links_links."", $dbi);
$numrows = sql_num_rows($result, $dbi);
if ($numrows == 1) {
$random = 1;
} else {
srand((double)microtime()*1000000);
$random = rand(1,$numrows);
}
$result2 = sql_query("select url from $prefix"._links_links." where lid='$random'", $dbi);
list($url) = sql_fetch_row($result2, $dbi);
sql_query("update $prefix"._links_links." set hits=hits+1 where lid=$random", $dbi);
Header("Location: $url");
}
function viewlink($cid, $min, $orderby, $show) {
global $prefix, $dbi, $admin, $perpage;
$admin = base64_decode($admin);
$admin = explode(":", $admin);
$aid = "$admin[0]";
$result3 = sql_query("select radminlink,radminsuper from $prefix"._authors." where aid='$aid'", $dbi);
list($radminlink,$radminsuper) = sql_fetch_array($result3, $dbi);
include("header.php");
if (!isset($min)) $min=0;
if (!isset($max)) $max=$min+$perpage;
if(isset($orderby)) {
$orderby = convertorderbyin($orderby);
} else {
$orderby = "title ASC";
}
if ($show!="") {
$perpage = $show;
} else {
$show=$perpage;
}
menu(1);
echo "<br>";
OpenTable();
$result = sql_query("select title,parentid from $prefix"._links_categories." where cid=$cid", $dbi);
list($title,$parentid)=sql_fetch_row($result, $dbi);
$title=getparentlink($parentid,$title);
$title="<a href=modules.php?name=Web_Links>"._MAIN."</a>/$title";
echo "<center><font class=\"option\"><b>"._CATEGORY.": $title</b></font></center><br>";
echo "<table border=\"0\" cellspacing=\"10\" cellpadding=\"0\" align=\"center\"><tr>";
$result2 = sql_query("select cid, title, cdescription from $prefix"._links_categories." where parentid=$cid order by title", $dbi);
$count = 0;
while(list($cid2, $title2, $cdescription2) = sql_fetch_row($result2, $dbi)) {
echo "<td><font class=\"option\"><strong><big>·</big></strong> <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid2\"><b>$title2</b></a></font>";
categorynewlinkgraphic($cid2);
if ($description) {
echo "<font class=\"content\">$cdescription2</font><br>";
} else {
echo "<br>";
}
$result3 = sql_query("select cid, title from $prefix"._links_categories." where parentid=$cid2 order by title limit 0,3", $dbi);
$space = 0;
while(list($cid3, $title3) = sql_fetch_row($result3, $dbi)) {
if ($space>0) {
echo ", ";
}
echo "<font class=\"content\"><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid3\">$title3</a></font>";
$space++;
}
if ($count<1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count==2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
echo "<hr noshade size=\"1\">";
$orderbyTrans = convertorderbytrans($orderby);
echo "<center><font class=\"content\">"._SORTLINKSBY.": "
.""._TITLE." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=titleA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=titleD\">D</a>) "
.""._DATE." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=dateA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=dateD\">D</a>) "
.""._RATING." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=ratingA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=ratingD\">D</a>) "
.""._POPULARITY." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=hitsA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&orderby=hitsD\">D</a>)"
."<br><b>"._SITESSORTED.": $orderbyTrans</b></font></center><br><br>";
$result=sql_query("select lid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where cid=$cid order by $orderby limit $min,$perpage", $dbi);
$fullcountresult=sql_query("select lid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where cid=$cid", $dbi);
$totalselectedlinks = sql_num_rows($fullcountresult, $dbi);
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"10\" border=\"0\"><tr><td><font class=\"content\">";
$x=0;
while(list($lid, $title, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments)=sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title);
$description = stripslashes($description);
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"new\"><b>$title</b></a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
/* INSERT code for *editor review* here */
echo "<br>";
echo ""._DESCRIPTION.": $description<br>";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
echo ""._ADDEDON.": $datetime "._HITS.": $hits";
$transfertitle = str_replace (" ", "_", $title);
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary!="0" || $linkratingsummary!="0.0") {
echo " "._RATING.": $linkratingsummary ($totalvotes $votestring)";
}
echo "<br>";
if ($radminsuper==1 || $radminlink==1) {
echo "<a href=\"admin.php?op=LinksModLink&lid=$lid\">"._EDIT."</a> | ";
}
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$transfertitle\">"._RATESITE."</a>";
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=brokenlink&lid=$lid\">"._REPORTBROKEN."</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$transfertitle\">"._DETAILS."</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$transfertitle\">"._SCOMMENTS." ($totalcomments)</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br><br>";
$x++;
}
echo "</font>";
$orderby = convertorderbyout($orderby);
/* Calculates how many pages exist. Which page one should be on, etc... */
$linkpagesint = ($totalselectedlinks / $perpage);
$linkpageremainder = ($totalselectedlinks % $perpage);
if ($linkpageremainder != 0) {
$linkpages = ceil($linkpagesint);
if ($totalselectedlinks < $perpage) {
$linkpageremainder = 0;
}
} else {
$linkpages = $linkpagesint;
}
/* Page Numbering */
if ($linkpages!=1 && $linkpages!=0) {
echo "<br><br>";
echo ""._SELECTPAGE.": ";
$prev=$min-$perpage;
if ($prev>=0) {
echo " <b>[ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&min=$prev&orderby=$orderby&show=$show\">";
echo " << "._PREVIOUS."</a> ]</b> ";
}
$counter = 1;
$currentpage = ($max / $perpage);
while ($counter<=$linkpages ) {
$cpage = $counter;
$mintemp = ($perpage * $counter) - $perpage;
if ($counter == $currentpage) {
echo "<b>$counter</b> ";
} else {
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&min=$mintemp&orderby=$orderby&show=$show\">$counter</a> ";
}
$counter++;
}
$next=$min+$perpage;
if ($x>=$perpage) {
echo " <b>[ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid&min=$max&orderby=$orderby&show=$show\">";
echo " "._NEXT." >></a> ]</b> ";
}
}
echo "</td></tr></table>";
CloseTable();
include("footer.php");
}
function newlinkgraphic($datetime, $time) {
echo " ";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
$startdate = time();
$count = 0;
while ($count <= 7) {
$daysold = date("d-M-Y", $startdate);
if ("$daysold" == "$datetime") {
if ($count<=1) {
echo "<img src=\"images/links/newred.gif\" alt=\""._NEWTODAY."\">";
}
if ($count<=3 && $count>1) {
echo "<img src=\"images/links/newgreen.gif\" alt=\""._NEWLAST3DAYS."\">";
}
if ($count<=7 && $count>3) {
echo "<img src=\"images/links/newblue.gif\" alt=\""._NEWTHISWEEK."\">";
}
}
$count++;
$startdate = (time()-(86400 * $count));
}
}
function categorynewlinkgraphic($cat) {
global $prefix, $dbi;
$newresult = sql_query("select date from $prefix"._links_links." where cid=$cat order by date desc limit 1", $dbi);
list($time)=sql_fetch_row($newresult, $dbi);
echo " ";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
$startdate = time();
$count = 0;
while ($count <= 7) {
$daysold = date("d-M-Y", $startdate);
if ("$daysold" == "$datetime") {
if ($count<=1) {
echo "<img src=\"images/links/newred.gif\" alt=\""._CATNEWTODAY."\">";
}
if ($count<=3 && $count>1) {
echo "<img src=\"images/links/newgreen.gif\" alt=\""._CATLAST3DAYS."\">";
}
if ($count<=7 && $count>3) {
echo "<img src=\"images/links/newblue.gif\" alt=\""._CATTHISWEEK."\">";
}
}
$count++;
$startdate = (time()-(86400 * $count));
}
}
function popgraphic($hits) {
include("modules/Web_Links/l_config.php");
if ($hits>=$popular) {
echo " <img src=\"images/links/pop.gif\" alt=\""._POPULAR."\">";
}
}
function convertorderbyin($orderby) {
if ($orderby == "titleA") $orderby = "title ASC";
if ($orderby == "dateA") $orderby = "date ASC";
if ($orderby == "hitsA") $orderby = "hits ASC";
if ($orderby == "ratingA") $orderby = "linkratingsummary ASC";
if ($orderby == "titleD") $orderby = "title DESC";
if ($orderby == "dateD") $orderby = "date DESC";
if ($orderby == "hitsD") $orderby = "hits DESC";
if ($orderby == "ratingD") $orderby = "linkratingsummary DESC";
return $orderby;
}
function convertorderbytrans($orderby) {
if ($orderby == "hits ASC") $orderbyTrans = ""._POPULARITY1."";
if ($orderby == "hits DESC") $orderbyTrans = ""._POPULARITY2."";
if ($orderby == "title ASC") $orderbyTrans = ""._TITLEAZ."";
if ($orderby == "title DESC") $orderbyTrans = ""._TITLEZA."";
if ($orderby == "date ASC") $orderbyTrans = ""._DATE1."";
if ($orderby == "date DESC") $orderbyTrans = ""._DATE2."";
if ($orderby == "linkratingsummary ASC") $orderbyTrans = ""._RATING1."";
if ($orderby == "linkratingsummary DESC") $orderbyTrans = ""._RATING2."";
return $orderbyTrans;
}
function convertorderbyout($orderby) {
if ($orderby == "title ASC") $orderby = "titleA";
if ($orderby == "date ASC") $orderby = "dateA";
if ($orderby == "hits ASC") $orderby = "hitsA";
if ($orderby == "linkratingsummary ASC") $orderby = "ratingA";
if ($orderby == "title DESC") $orderby = "titleD";
if ($orderby == "date DESC") $orderby = "dateD";
if ($orderby == "hits DESC") $orderby = "hitsD";
if ($orderby == "linkratingsummary DESC") $orderby = "ratingD";
return $orderby;
}
function visit($lid) {
global $prefix, $dbi;
sql_query("update $prefix"._links_links." set hits=hits+1 where lid=$lid", $dbi);
$result = sql_query("select url from $prefix"._links_links." where lid=$lid", $dbi);
list($url) = sql_fetch_row($result, $dbi);
Header("Location: $url");
}
function search($query, $min, $orderby, $show) {
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $admin, $bgcolor2;
if (!isset($min)) $min=0;
if (!isset($max)) $max=$min+$linksresults;
if(isset($orderby)) {
$orderby = convertorderbyin($orderby);
} else {
$orderby = "title ASC";
}
if ($show!="") {
$linksresults = $show;
} else {
$show=$linksresults;
}
$query = stripslashes($query);
$result = sql_query("select lid, cid, sid, title, url, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where title LIKE '%$query%' OR description LIKE '%$query%' ORDER BY $orderby LIMIT $min,$linksresults", $dbi);
$fullcountresult=sql_query("select lid, title, description, date, hits, linkratingsummary, totalvotes, totalcomments from $prefix"._links_links." where title LIKE '%$query%' OR description LIKE '%$query%'", $dbi);
$totalselectedlinks = sql_num_rows($fullcountresult, $dbi);
$nrows = sql_num_rows($result, $dbi);
$x=0;
include("header.php");
menu(1);
echo "<br>";
OpenTable();
if ($query != "") {
if ($nrows>0) {
echo "<font class=\"option\">"._SEARCHRESULTS4.": <b>$query</b></font><br><br>"
."<table width=\"100%\" bgcolor=\"$bgcolor2\"><tr><td><font class=\"option\"><b>"._USUBCATEGORIES."</b></font></td></tr></table>";
$result2 = sql_query("select cid, title from $prefix"._links_categories." where title LIKE '%$query%' ORDER BY title DESC", $dbi);
while(list($cid, $stitle) = sql_fetch_row($result2, $dbi)) {
$res = sql_query("select * from $prefix"._links_links." where cid=$cid", $dbi);
$numrows = sql_num_rows($res, $dbi);
$result3 = sql_query("select cid,title,parentid from $prefix"._links_categories." where cid=$cid", $dbi);
list($cid3,$title3,$parentid3) = sql_fetch_row($result3, $dbi);
if ($parentid3>0) $title3 = getparent($parentid3,$title3);
$title3 = ereg_replace($query, "<b>$query</b>", $title3);
echo "<strong><big>·</big></strong> <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlink&cid=$cid\">$title3</a> ($numrows)<br>";
}
echo "<br><table width=\"100%\" bgcolor=\"$bgcolor2\"><tr><td><font class=\"option\"><b>"._LINKS."</b></font></td></tr></table>";
$orderbyTrans = convertorderbytrans($orderby);
echo "<br><font class=\"content\">"._SORTLINKSBY.": "
.""._TITLE." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=titleA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=titleD\">D</a>)"
.""._DATE." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=dateA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=dateD\">D</a>)"
.""._RATING." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=ratingA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=ratingD\">D</a>)"
.""._POPULARITY." (<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=hitsA\">A</a>\<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&orderby=hitsD\">D</a>)"
."<br>"._SITESSORTED.": $orderbyTrans<br><br>";
while(list($lid, $cid, $sid, $title, $url, $description, $time, $hits, $linkratingsummary, $totalvotes, $totalcomments) = sql_fetch_row($result, $dbi)) {
$linkratingsummary = number_format($linkratingsummary, $mainvotedecimal);
$title = stripslashes($title); $description = stripslashes($description);
$transfertitle = str_replace (" ", "_", $title);
$title = ereg_replace($query, "<b>$query</b>", $title);
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"new\">$title</a>";
newlinkgraphic($datetime, $time);
popgraphic($hits);
echo "<br>";
$description = ereg_replace($query, "<b>$query</b>", $description);
echo ""._DESCRIPTION.": $description<br>";
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(""._LINKSDATESTRING."", mktime($datetime[4],$datetime[5],$datetime[6],$datetime[2],$datetime[3],$datetime[1]));
$datetime = ucfirst($datetime);
echo ""._ADDEDON.": $datetime "._HITS.": $hits";
/* voting & comments stats */
if ($totalvotes == 1) {
$votestring = _VOTE;
} else {
$votestring = _VOTES;
}
if ($linkratingsummary!="0" || $linkratingsummary!="0.0") {
echo " "._RATING.": $linkratingsummary ($totalvotes $votestring)";
}
echo "<br><a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$transfertitle\">"._RATESITE."</a>";
if ($totalvotes != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkdetails&lid=$lid&ttitle=$transfertitle\">"._DETAILS."</a>";
}
if ($totalcomments != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkcomments&lid=$lid&ttitle=$transfertitle>"._SCOMMENTS." ($totalcomments)</a>";
}
detecteditorial($lid, $transfertitle);
echo "<br>";
$result3 = sql_query("select cid,title,parentid from $prefix"._links_categories." where cid=$cid", $dbi);
list($cid3,$title3,$parentid3) = sql_fetch_row($result3, $dbi);
if ($parentid3>0) $title3 = getparent($parentid3,$title3);
echo ""._CATEGORY.": $title3<br><br>";
$x++;
}
echo "</font>";
$orderby = convertorderbyout($orderby);
} else {
echo "<br><br><center><font class=\"option\"><b>"._NOMATCHES."</b></font><br><br>"._GOBACK."<br></center>";
}
/* Calculates how many pages exist. Which page one should be on, etc... */
$linkpagesint = ($totalselectedlinks / $linksresults);
$linkpageremainder = ($totalselectedlinks % $linksresults);
if ($linkpageremainder != 0) {
$linkpages = ceil($linkpagesint);
if ($totalselectedlinks < $linksresults) {
$linkpageremainder = 0;
}
} else {
$linkpages = $linkpagesint;
}
/* Page Numbering */
if ($linkpages!=1 && $linkpages!=0) {
echo "<br><br>"
.""._SELECTPAGE.": ";
$prev=$min-$linksresults;
if ($prev>=0) {
echo " <b>[ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&min=$prev&orderby=$orderby&show=$show\">"
." << "._PREVIOUS."</a> ]</b> ";
}
$counter = 1;
$currentpage = ($max / $linksresults);
while ($counter<=$linkpages ) {
$cpage = $counter;
$mintemp = ($perpage * $counter) - $linksresults;
if ($counter == $currentpage) {
echo "<b>$counter</b> ";
} else {
echo "<a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&min=$mintemp&orderby=$orderby&show=$show\">$counter</a> ";
}
$counter++;
}
$next=$min+$linksresults;
if ($x>=$perpage) {
echo " <b>[ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=search&query=$query&min=$max&orderby=$orderby&show=$show\">"
." "._NEXT." >></a> ]</b>";
}
}
echo "<br><br><center><font class=\"content\">"
.""._TRY2SEARCH." \"$query\" "._INOTHERSENGINES."<br>"
."<a target=\"_blank\" href=\"http://www.altavista.com/cgi-bin/query?pg=q&sc=on&hl=on&act=2006&par=0&q=$query&kl=XX&stype=stext\">Alta Vista</a> - "
."<a target=\"_blank\" href=\"http://www.hotbot.com/?MT=$query&DU=days&SW=web\">HotBot</a> - "
."<a target=\"_blank\" href=\"http://www.infoseek.com/Titles?qt=$query\">Infoseek</a> - "
."<a target=\"_blank\" href=\"http://www.dejanews.com/dnquery.xp?QRY=$query\">Deja News</a> - "
."<a target=\"_blank\" href=\"http://www.lycos.com/cgi-bin/pursuit?query=$query&maxhits=20\">Lycos</a> - "
."<a target=\"_blank\" href=\"http://search.yahoo.com/bin/search?p=$query\">Yahoo</a>"
."<br>"
."<a target=\"_blank\" href=\"http://es.linuxstart.com/cgi-bin/sqlsearch.cgi?pos=1&query=$query&language=&advanced=&urlonly=&withid=\">LinuxStart</a> - "
."<a target=\"_blank\" href=\"http://search.1stlinuxsearch.com/compass?scope=$query&ui=sr\">1stLinuxSearch</a> - "
."<a target=\"_blank\" href=\"http://www.google.com/search?q=$query\">Google</a> - "
."<a target=\"_blank\" href=\"http://www.linuxlinks.com/cgi-bin/search.cgi?query=$query&engine=Links\">LinuxLinks</a> - "
."<a target=\"_blank\" href=\"http://www.freshmeat.net/search.php?query=$query\">Freshmeat</a> - "
."<a target=\"_blank\" href=\"http://www.justlinux.com/bin/search.pl?key=$query\">JustLinux</a>"
."</font>";
} else {
echo "<center><font class=\"option\"><b>"._NOMATCHES."</b></font></center><br><br>";
}
CloseTable();
include("footer.php");
}
function viewlinkeditorial($lid, $ttitle) {
global $prefix, $dbi, $admin;
include("header.php");
include("modules/Web_Links/l_config.php");
menu(1);
$result=sql_query("SELECT adminid, editorialtimestamp, editorialtext, editorialtitle FROM $prefix"._links_editorials." WHERE linkid = $lid", $dbi);
$recordexist = sql_num_rows($result, $dbi);
$transfertitle = ereg_replace ("_", " ", $ttitle);
$displaytitle = $transfertitle;
echo "<br>";
OpenTable();
echo "<center><font class=\"option\"><b>"._LINKPROFILE.": $displaytitle</b></font><br>";
linkinfomenu($lid, $ttitle);
if ($recordexist != 0) {
while(list($adminid, $editorialtimestamp, $editorialtext, $editorialtitle)=sql_fetch_row($result, $dbi)) {
$editorialtitle = stripslashes($editorialtitle); $editorialtext = stripslashes($editorialtext);
ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $editorialtimestamp, $editorialtime);
$editorialtime = strftime("%F",mktime($editorialtime[4],$editorialtime[5],$editorialtime[6],$editorialtime[2],$editorialtime[3],$editorialtime[1]));
$date_array = explode("-", $editorialtime);
$timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
$formatted_date = date("F j, Y", $timestamp);
echo "<br><br>";
OpenTable2();
echo "<center><font class=\"option\"><b>'$editorialtitle'</b></font></center>"
."<center><font class=\"tiny\">"._EDITORIALBY." $adminid - $formatted_date</font></center><br><br>"
."$editorialtext";
CloseTable2();
}
} else {
echo "<br><br><center><font class=\"option\"><b>"._NOEDITORIAL."</b></font></center>";
}
echo "<br><br><center>";
linkfooter($lid,$ttitle);
echo "</center>";
CloseTable();
include("footer.php");
}
function detecteditorial($lid, $ttitle) {
global $prefix, $dbi;
$resulted2 = sql_query("select adminid from $prefix"._links_editorials." where linkid=$lid", $dbi);
$recordexist = sql_num_rows($resulted2, $dbi);
if ($recordexist != 0) {
echo " | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=viewlinkeditorial&lid=$lid&ttitle=$ttitle\">"._EDITORIAL."</a>";
}
}
function viewlinkcomments($lid, $ttitle) {
global $prefix, $dbi, $admin, $bgcolor2;
include("header.php");
include("modules/Web_Links/l_config.php");
menu(1);
echo "<br>";
$result=sql_query("SELECT ratinguser, rating, ratingcomments, ratingtimestamp FROM $prefix"._links_votedata." WHERE ratinglid = $lid AND ratingcomments != '' ORDER BY ratingtimestamp DESC", $dbi);
$totalcomments = sql_num_rows($result, $dbi);
$transfertitle = ereg_replace ("_", " ", $ttitle);
$displaytitle = $transfertitle;
OpenTable();
echo "<center><font class=\"option\"><b>"._LINKPROFILE.": $displaytitle</b></font><br><br>";
linkinfomenu($lid, $ttitle);
echo "<br><br><br>"._TOTALOF." $totalcomments "._COMMENTS."</font></center><br>"
."<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" width=\"450\">";
$x=0;
while(list($ratinguser, $rating, $ratingcomments, $ratingtimestamp)=sql_fetch_row($result, $dbi)) {
$ratingcomments = stripslashes($ratingcomments);
ereg ("([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})", $ratingtimestamp, $ratingtime);
$ratingtime = strftime("%F",mktime($ratingtime[4],$ratingtime[5],$ratingtime[6],$ratingtime[2],$ratingtime[3],$ratingtime[1]));
$date_array = explode("-", $ratingtime);
$timestamp = mktime(0, 0, 0, $date_array["1"], $date_array["2"], $date_array["0"]);
$formatted_date = date("F j, Y", $timestamp);
/* Individual user information */
$result2=sql_query("SELECT rating FROM $prefix"._links_votedata." WHERE ratinguser = '$ratinguser'", $dbi);
$usertotalcomments = sql_num_rows($result2, $dbi);
$useravgrating = 0;
while(list($rating2)=sql_fetch_row($result2, $dbi))
$useravgrating = $useravgrating + $rating2;
$useravgrating = $useravgrating / $usertotalcomments;
$useravgrating = number_format($useravgrating, 1);
echo "<tr><td bgcolor=\"$bgcolor2\">"
."<font class=\"content\"><b> "._USER.": </b><a href=\"$nukeurl/user.php?op=userinfo&uname=$ratinguser\">$ratinguser</a></font>"
."</td>"
."<td bgcolor=\"$bgcolor2\">"
."<font class=\"content\"><b>"._RATING.": </b>$rating</font>"
."</td>"
."<td bgcolor=\"$bgcolor2\" align=\"right\">"
."<font class=\"content\">$formatted_date</font>"
."</td>"
."</tr>"
."<tr>"
."<td valign=\"top\">"
."<font class=\"tiny\">"._USERAVGRATING.": $useravgrating</font>"
."</td>"
."<td valign=\"top\" colspan=\"2\">"
."<font class=\"tiny\">"._NUMRATINGS.": $usertotalcomments</font>"
."</td>"
."</tr>"
."<tr>"
."<td colspan=\"3\">"
."<font class=\"content\">";
if (is_admin($admin)) {
echo "<a href=\"admin.php?op=LinksModLink&lid=$lid\"><img src=\"images/links/editicon.gif\" border=\"0\" alt=\""._EDITTHISLINK."\"></a>";
}
echo " $ratingcomments</font>"
."<br><br><br></td></tr>";
$x++;
}
echo "</table><br><br><center>";
linkfooter($lid,$ttitle);
echo "</center>";
CloseTable();
include("footer.php");
}
function viewlinkdetails($lid, $ttitle) {
global $prefix, $dbi, $admin, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4;
include("header.php");
include("modules/Web_Links/l_config.php");
menu(1);
$voteresult = sql_query("select rating, ratinguser, ratingcomments FROM $prefix"._links_votedata." WHERE ratinglid = $lid", $dbi);
$totalvotesDB = sql_num_rows($voteresult, $dbi);
$anonvotes = 0;
$anonvoteval = 0;
$outsidevotes = 0;
$outsidevoteeval = 0;
$regvoteval = 0;
$topanon = 0;
$bottomanon = 11;
$topreg = 0;
$bottomreg = 11;
$topoutside = 0;
$bottomoutside = 11;
$avv = array(0,0,0,0,0,0,0,0,0,0,0);
$rvv = array(0,0,0,0,0,0,0,0,0,0,0);
$ovv = array(0,0,0,0,0,0,0,0,0,0,0);
$truecomments = $totalvotesDB;
while(list($ratingDB, $ratinguserDB, $ratingcommentsDB)=sql_fetch_row($voteresult, $dbi)) {
if ($ratingcommentsDB=="") $truecomments--;
if ($ratinguserDB==$anonymous) {
$anonvotes++;
$anonvoteval += $ratingDB;
}
if ($useoutsidevoting == 1) {
if ($ratinguserDB=='outside') {
$outsidevotes++;
$outsidevoteval += $ratingDB;
}
} else {
$outsidevotes = 0;
}
if ($ratinguserDB!=$anonymous && $ratinguserDB!="outside") {
$regvoteval += $ratingDB;
}
if ($ratinguserDB!=$anonymous && $ratinguserDB!="outside") {
if ($ratingDB > $topreg) $topreg = $ratingDB;
if ($ratingDB < $bottomreg) $bottomreg = $ratingDB;
for ($rcounter=1; $rcounter<11; $rcounter++) if ($ratingDB==$rcounter) $rvv[$rcounter]++;
}
if ($ratinguserDB==$anonymous) {
if ($ratingDB > $topanon) $topanon = $ratingDB;
if ($ratingDB < $bottomanon) $bottomanon = $ratingDB;
for ($rcounter=1; $rcounter<11; $rcounter++) if ($ratingDB==$rcounter) $avv[$rcounter]++;
}
if ($ratinguserDB=="outside") {
if ($ratingDB > $topoutside) $topoutside = $ratingDB;
if ($ratingDB < $bottomoutside) $bottomoutside = $ratingDB;
for ($rcounter=1; $rcounter<11; $rcounter++) if ($ratingDB==$rcounter) $ovv[$rcounter]++;
}
}
$regvotes = $totalvotesDB - $anonvotes - $outsidevotes;
if ($totalvotesDB == 0) {
$finalrating = 0;
} else if ($anonvotes == 0 && $regvotes == 0) {
/* Figure Outside Only Vote */
$finalrating = $outsidevoteval / $outsidevotes;
$finalrating = number_format($finalrating, $detailvotedecimal);
$avgOU = $outsidevoteval / $totalvotesDB;
$avgOU = number_format($avgOU, $detailvotedecimal);
} else if ($outsidevotes == 0 && $regvotes == 0) {
/* Figure Anon Only Vote */
$finalrating = $anonvoteval / $anonvotes;
$finalrating = number_format($finalrating, $detailvotedecimal);
$avgAU = $anonvoteval / $totalvotesDB;
$avgAU = number_format($avgAU, $detailvotedecimal);
} else if ($outsidevotes == 0 && $anonvotes == 0) {
/* Figure Reg Only Vote */
$finalrating = $regvoteval / $regvotes;
$finalrating = number_format($finalrating, $detailvotedecimal);
$avgRU = $regvoteval / $totalvotesDB;
$avgRU = number_format($avgRU, $detailvotedecimal);
} else if ($regvotes == 0 && $useoutsidevoting == 1 && $outsidevotes != 0 && $anonvotes != 0 ) {
/* Figure Reg and Anon Mix */
$avgAU = $anonvoteval / $anonvotes;
$avgOU = $outsidevoteval / $outsidevotes;
if ($anonweight > $outsideweight ) {
/* Anon is 'standard weight' */
$newimpact = $anonweight / $outsideweight;
$impactAU = $anonvotes;
$impactOU = $outsidevotes / $newimpact;
$finalrating = ((($avgOU * $impactOU) + ($avgAU * $impactAU)) / ($impactAU + $impactOU));
$finalrating = number_format($finalrating, $detailvotedecimal);
} else {
/* Outside is 'standard weight' */
$newimpact = $outsideweight / $anonweight;
$impactOU = $outsidevotes;
$impactAU = $anonvotes / $newimpact;
$finalrating = ((($avgOU * $impactOU) + ($avgAU * $impactAU)) / ($impactAU + $impactOU));
$finalrating = number_format($finalrating, $detailvotedecimal);
}
} else {
/* REG User vs. Anonymous vs. Outside User Weight Calutions */
$impact = $anonweight;
$outsideimpact = $outsideweight;
if ($regvotes == 0) {
$avgRU = 0;
} else {
$avgRU = $regvoteval / $regvotes;
}
if ($anonvotes == 0) {
$avgAU = 0;
} else {
$avgAU = $anonvoteval / $anonvotes;
}
if ($outsidevotes == 0 ) {
$avgOU = 0;
} else {
$avgOU = $outsidevoteval / $outsidevotes;
}
$impactRU = $regvotes;
$impactAU = $anonvotes / $impact;
$impactOU = $outsidevotes / $outsideimpact;
$finalrating = (($avgRU * $impactRU) + ($avgAU * $impactAU) + ($avgOU * $impactOU)) / ($impactRU + $impactAU + $impactOU);
$finalrating = number_format($finalrating, $detailvotedecimal);
}
if ($avgOU == 0 || $avgOU == "") {
$avgOU = "";
} else {
$avgOU = number_format($avgOU, $detailvotedecimal);
}
if ($avgRU == 0 || $avgRU == "") {
$avgRU = "";
} else {
$avgRU = number_format($avgRU, $detailvotedecimal);
}
if ($avgAU == 0 || $avgAU == "") {
$avgAU = "";
} else {
$avgAU = number_format($avgAU, $detailvotedecimal);
}
if ($topanon == 0) $topanon = "";
if ($bottomanon == 11) $bottomanon = "";
if ($topreg == 0) $topreg = "";
if ($bottomreg == 11) $bottomreg = "";
if ($topoutside == 0) $topoutside = "";
if ($bottomoutside == 11) $bottomoutside = "";
$totalchartheight = 70;
$chartunits = $totalchartheight / 10;
$avvper = array(0,0,0,0,0,0,0,0,0,0,0);
$rvvper = array(0,0,0,0,0,0,0,0,0,0,0);
$ovvper = array(0,0,0,0,0,0,0,0,0,0,0);
$avvpercent = array(0,0,0,0,0,0,0,0,0,0,0);
$rvvpercent = array(0,0,0,0,0,0,0,0,0,0,0);
$ovvpercent = array(0,0,0,0,0,0,0,0,0,0,0);
$avvchartheight = array(0,0,0,0,0,0,0,0,0,0,0);
$rvvchartheight = array(0,0,0,0,0,0,0,0,0,0,0);
$ovvchartheight = array(0,0,0,0,0,0,0,0,0,0,0);
$avvmultiplier = 0;
$rvvmultiplier = 0;
$ovvmultiplier = 0;
for ($rcounter=1; $rcounter<11; $rcounter++) {
if ($anonvotes != 0) $avvper[$rcounter] = $avv[$rcounter] / $anonvotes;
if ($regvotes != 0) $rvvper[$rcounter] = $rvv[$rcounter] / $regvotes;
if ($outsidevotes != 0) $ovvper[$rcounter] = $ovv[$rcounter] / $outsidevotes;
$avvpercent[$rcounter] = number_format($avvper[$rcounter] * 100, 1);
$rvvpercent[$rcounter] = number_format($rvvper[$rcounter] * 100, 1);
$ovvpercent[$rcounter] = number_format($ovvper[$rcounter] * 100, 1);
if ($avv[$rcounter] > $avvmultiplier) $avvmultiplier = $avv[$rcounter];
if ($rvv[$rcounter] > $rvvmultiplier) $rvvmultiplier = $rvv[$rcounter];
if ($ovv[$rcounter] > $ovvmultiplier) $ovvmultiplier = $ovv[$rcounter];
}
if ($avvmultiplier != 0) $avvmultiplier = 10 / $avvmultiplier;
if ($rvvmultiplier != 0) $rvvmultiplier = 10 / $rvvmultiplier;
if ($ovvmultiplier != 0) $ovvmultiplier = 10 / $ovvmultiplier;
for ($rcounter=1; $rcounter<11; $rcounter++) {
$avvchartheight[$rcounter] = ($avv[$rcounter] * $avvmultiplier) * $chartunits;
$rvvchartheight[$rcounter] = ($rvv[$rcounter] * $rvvmultiplier) * $chartunits;
$ovvchartheight[$rcounter] = ($ovv[$rcounter] * $ovvmultiplier) * $chartunits;
if ($avvchartheight[$rcounter]==0) $avvchartheight[$rcounter]=1;
if ($rvvchartheight[$rcounter]==0) $rvvchartheight[$rcounter]=1;
if ($ovvchartheight[$rcounter]==0) $ovvchartheight[$rcounter]=1;
}
$transfertitle = ereg_replace ("_", " ", $ttitle);
$displaytitle = $transfertitle;
echo "<br>";
OpenTable();
echo "<center><font class=\"option\"><b>"._LINKPROFILE.": $displaytitle</b></font><br><br>";
linkinfomenu($lid, $ttitle);
echo "<br><br>"._LINKRATINGDET."<br>"
.""._TOTALVOTES." $totalvotesDB<br>"
.""._OVERALLRATING.": $finalrating</center><br><br>"
."<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" width=\"455\">"
."<tr><td colspan=\"2\" bgcolor=\"$bgcolor2\">"
."<font class=\"content\"><b>"._REGISTEREDUSERS."</b></font>"
."</td></tr>"
."<tr>"
."<td bgcolor=\"$bgcolor1\">"
."<font class=\"content\">"._NUMBEROFRATINGS.": $regvotes</font>"
."</td>"
."<td rowspan=\"5\" width=\"200\">";
if ($regvotes==0) {
echo "<center><font class=\"content\">"._NOREGUSERSVOTES."</font></center>";
} else {
echo "<table border=\"1\" width=\"200\">"
."<tr>"
."<td valign=\"top\" align=\"center\" colspan=\"10\" bgcolor=\"$bgcolor2\"><font class=\"content\">"._BREAKDOWNBYVAL."</font></td>"
."</tr>"
."<tr>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[1] "._LVOTES." ($rvvpercent[1]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[1]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[2] "._LVOTES." ($rvvpercent[2]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[2]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[3] "._LVOTES." ($rvvpercent[3]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[3]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[4] "._LVOTES." ($rvvpercent[4]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[4]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[5] "._LVOTES." ($rvvpercent[5]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[5]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[6] "._LVOTES." ($rvvpercent[6]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[6]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[7] "._LVOTES." ($rvvpercent[7]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[7]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[8] "._LVOTES." ($rvvpercent[8]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[8]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[9] "._LVOTES." ($rvvpercent[9]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[9]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$rvv[10] "._LVOTES." ($rvvpercent[10]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$rvvchartheight[10]\"></td>"
."</tr>"
."<tr><td colspan=\"10\" bgcolor=\"$bgcolor2\">"
."<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"200\"><tr>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">1</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">2</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">3</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">4</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">5</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">6</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">7</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">8</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">9</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">10</font></td>"
."</tr></table>"
."</td></tr></table>";
}
echo "</td>"
."</tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LINKRATING.": $avgRU</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._HIGHRATING.": $topreg</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LOWRATING.": $bottomreg</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._NUMOFCOMMENTS.": $truecomments</font></td></tr>"
."<tr><td></td></tr>"
."<tr><td valign=\"top\" colspan=\"2\"><font class=\"tiny\"><br><br>"._WEIGHNOTE." $anonweight "._TO." 1.</font></td></tr>"
."<tr><td colspan=\"2\" bgcolor=\"$bgcolor2\"><font class=\"content\"><b>"._UNREGISTEREDUSERS."</b></font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._NUMBEROFRATINGS.": $anonvotes</font></td>"
."<td rowspan=\"5\" width=\"200\">";
if ($anonvotes==0) {
echo "<center><font class=\"content\">"._NOUNREGUSERSVOTES."</font></center>";
} else {
echo "<table border=\"1\" width=\"200\">"
."<tr>"
."<td valign=\"top\" align=\"center\" colspan=\"10\" bgcolor=\"$bgcolor2\"><font class=\"content\">"._BREAKDOWNBYVAL."</font></td>"
."</tr>"
."<tr>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[1] "._LVOTES." ($avvpercent[1]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[1]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[2] "._LVOTES." ($avvpercent[2]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[2]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[3] "._LVOTES." ($avvpercent[3]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[3]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[4] "._LVOTES." ($avvpercent[4]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[4]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[5] "._LVOTES." ($avvpercent[5]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[5]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[6] "._LVOTES." ($avvpercent[6]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[6]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[7] "._LVOTES." ($avvpercent[7]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[7]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[8] "._LVOTES." ($avvpercent[8]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[8]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[9] "._LVOTES." ($avvpercent[9]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[9]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$avv[10] "._LVOTES." ($avvpercent[10]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$avvchartheight[10]\"></td>"
."</tr>"
."<tr><td colspan=\"10\" bgcolor=\"$bgcolor2\">"
."<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"200\"><tr>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">1</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">2</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">3</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">4</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">5</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">6</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">7</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">8</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">9</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">10</font></td>"
."</tr></table>"
."</td></tr></table>";
}
echo "</td>"
."</tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LINKRATING.": $avgAU</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._HIGHRATING.": $topanon</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LOWRATING.": $bottomanon</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\"> </font></td></tr>";
if ($useoutsidevoting == 1) {
echo "<tr><td valign=top colspan=\"2\"><font class=\"tiny\"><br><br>"._WEIGHOUTNOTE." $outsideweight "._TO." 1.</font></td></tr>"
."<tr><td colspan=\"2\" bgcolor=\"$bgcolor2\"><font class=\"content\"><b>"._OUTSIDEVOTERS."</b></font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._NUMBEROFRATINGS.": $outsidevotes</font></td>"
."<td rowspan=\"5\" width=\"200\">";
if ($outsidevotes==0) {
echo "<center><font class=\"content\">"._NOOUTSIDEVOTES."</font></center>";
} else {
echo "<table border=\"1\" width=\"200\">"
."<tr>"
."<td valign=\"top\" align=\"center\" colspan=\"10\" bgcolor=\"$bgcolor2\"><font class=\"content\">"._BREAKDOWNBYVAL."</font></td>"
."</tr>"
."<tr>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[1] "._LVOTES." ($ovvpercent[1]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[1]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[2] "._LVOTES." ($ovvpercent[2]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[2]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[3] "._LVOTES." ($ovvpercent[3]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[3]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[4] "._LVOTES." ($ovvpercent[4]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[4]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[5] "._LVOTES." ($ovvpercent[5]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[5]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[6] "._LVOTES." ($ovvpercent[6]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[6]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[7] "._LVOTES." ($ovvpercent[7]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[7]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[8] "._LVOTES." ($ovvpercent[8]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[8]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[9] "._LVOTES." ($ovvpercent[9]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[9]\"></td>"
."<td bgcolor=\"$bgcolor1\" valign=\"bottom\"><img border=\"0\" alt=\"$ovv[10] "._LVOTES." ($ovvpercent[10]% "._LTOTALVOTES.")\" src=\"images/blackpixel.gif\" width=\"15\" height=\"$ovvchartheight[10]\"></td>"
."</tr>"
."<tr><td colspan=\"10\" bgcolor=\"$bgcolor2\">"
."<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"200\"><tr>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">1</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">2</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">3</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">4</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">5</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">6</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">7</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">8</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">9</font></td>"
."<td width=\"10%\" valign=\"bottom\" align=\"center\"><font class=\"content\">10</font></td>"
."</tr></table>"
."</td></tr></table>";
}
echo "</td>"
."</tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LINKRATING.": $avgOU</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\">"._HIGHRATING.": $topoutside</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor2\"><font class=\"content\">"._LOWRATING.": $bottomoutside</font></td></tr>"
."<tr><td bgcolor=\"$bgcolor1\"><font class=\"content\"> </font></td></tr>";
}
echo "</table><br><br><center>";
linkfooter($lid,$ttitle);
echo "</center>";
CloseTable();
include("footer.php");
}
function linkfooter($lid,$ttitle) {
echo "<font class=\"content\">[ <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=visit&lid=$lid\" target=\"_blank\">"._VISITTHISSITE."</a> | <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid&ttitle=$ttitle\">"._RATETHISSITE."</a> ]</font><br><br>";
linkfooterchild($lid);
}
function linkfooterchild($lid) {
include("modules/Web_Links/l_config.php");
if ($useoutsidevoting = 1) {
echo "<br><font class=\"content\">"._ISTHISYOURSITE." <a href=\"modules.php?op=modload&name=Web_Links&file=index&l_op=outsidelinksetup&lid=$lid\">"._ALLOWTORATE."</a></font>";
}
}
function outsidelinksetup($lid) {
include("header.php");
include("modules/Web_Links/l_config.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><font class=\"option\"><b>"._PROMOTEYOURSITE."</b></font></center><br><br>
"._PROMOTE01."<br><br>
<b>1) "._TEXTLINK."</b><br><br>
"._PROMOTE02."<br><br>
<center><a href=\"$nukeurl/modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid\">"._RATETHISSITE." @ $sitename</a></center><br><br>
<center>"._HTMLCODE1."</center><br>
<center><i><a href=\"$nukeurl/modules.php?op=modload&name=Web_Links&file=index&l_op=ratelink&lid=$lid\">"._RATETHISSITE."</a></i></center>
<br><br>
"._THENUMBER." \"$lid\" "._IDREFER."<br><br>
<b>2) "._BUTTONLINK."</b><br><br>
"._PROMOTE03."<br><br>
<center>
<form action=\"modules.php?name=Web_Links\" method=\"post\">\n
<input type=\"hidden\" name=\"lid\" value=\"$lid\">\n
<input type=\"hidden\" name=\"op\" value=\"ratelink\">\n
<input type=\"submit\" value=\""._RATEIT."\">\n
</form>\n
</center>
<center>"._HTMLCODE2."</center><br><br>
<table border=\"0\" align=\"center\"><tr><td align=\"left\"><i>
<form action=\"$nukeurl/modules.php?name=Web_Links\" method=\"post\"><br>\n
<input type=\"hidden\" name=\"lid\" value=\"$lid\"><br>\n
<input type=\"hidden\" name=\"op\" value=\"ratelink\"><br>\n
<input type=\"submit\" value=\""._RATEIT."\"><br>\n
</form>\n
</i></td></tr></table>
<br><br>
<b>3) "._REMOTEFORM."</b><br><br>
"._PROMOTE04."
<center>
<form method=\"post\" action=\"$nukeurl/modules.php?name=Web_Links\">
<table align=\"center\" border=\"0\" width=\"175\" cellspacing=\"0\" cellpadding=\"0\">
<tr><td align=\"center\"><b>"._VOTE4THISSITE."</b></a></td></tr>
<tr><td>
<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr><td valign=\"top\">
<select name=\"rating\">
<option selected>--</option>
<option>10</option>
<option>9</option>
<option>8</option>
<option>7</option>
<option>6</option>
<option>5</option>
<option>4</option>
<option>3</option>
<option>2</option>
<option>1</option>
</select>
</td><td valign=\"top\">
<input type=\"hidden\" name=\"ratinglid\" value=\"$lid\">
<input type=\"hidden\" name=\"ratinguser\" value=\"outside\">
<input type=\"hidden\" name=\"op value=\"addrating\">
<input type=\"submit\" value=\""._LINKVOTE."\">
</td></tr></table>
</td></tr></table></form>
<br>"._HTMLCODE3."<br><br></center>
<blockquote><i>
<form method=\"post\" action=\"$nukeurl/modules.php?name=Web_Links\"><br>
<table align=\"center\" border=\"0\" width=\"175\" cellspacing=\"0\" cellpadding=\"0\"><br>
<tr><td align=\"center\"><b>"._VOTE4THISSITE."</b></a></td></tr><br>
<tr><td><br>
<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><br>
<tr><td valign=\"top\"><br>
<select name=\"rating\"><br>
<option selected>--</option><br>
<option>10</option><br>
<option>9</option><br>
<option>8</option><br>
<option>7</option><br>
<option>6</option><br>
<option>5</option><br>
<option>4</option><br>
<option>3</option><br>
<option>2</option><br>
<option>1</option><br>
</select><br>
</td><td valign=\"top\"><br>
<input type=\"hidden\" name=\"ratinglid\" value=\"$lid\"><br>
<input type=\"hidden\" name=\"ratinguser\" value=\"outside\"><br>
<input type=\"hidden\" name=\"op\" value=\"addrating\"><br>
<input type=\"submit\" value=\""._LINKVOTE."\"><br>
</td></tr></table><br>
</td></tr></table><br>
</form><br>
</i></blockquote>
<br><br><center>
"._PROMOTE05."<br><br>
- $sitename "._STAFF."
<br><br></center>";
CloseTable();
include("footer.php");
}
function brokenlink($lid) {
include("header.php");
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $user;
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$ratinguser = $cookie[1];
} else {
$ratinguser = "$anonymous";
}
menu(1);
echo "<br>";
$result = sql_query("select cid, title, url, description from $prefix"._links_links." where lid=$lid", $dbi);
list($cid, $title, $url, $description) = sql_fetch_row($result, $dbi);
OpenTable();
echo "<center><font class=\"option\"><b>"._REPORTBROKEN."</b></font><br><br><br><font class=\"content\">";
echo "<form action=\"modules.php?name=Web_Links\" method=\"post\">";
echo "<input type=\"hidden\" name=\"lid\" value=\"$lid\">";
echo "<input type=\"hidden\" name=\"cid\" value=\"$cid\">";
echo "<input type=\"hidden\" name=\"title\" value=\"$title\">";
echo "<input type=\"hidden\" name=\"url\" value=\"$url\">";
echo "<input type=\"hidden\" name=\"description\" value=\"$description\">";
echo "<input type=\"hidden\" name=\"modifysubmitter\" value=\"$ratinguser\">";
echo ""._THANKSBROKEN."<br><br>";
echo "<input type=\"hidden\" name=\"l_op\" value=\"brokenlinkS\"><input type=\"submit\" value=\""._REPORTBROKEN."\"></center></form>";
CloseTable();
include("footer.php");
}
function brokenlinkS($lid,$cid, $title, $url, $description, $modifysubmitter) {
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $user;
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$ratinguser = $cookie[1];
} else {
$ratinguser = "$anonymous";
}
sql_query("insert into $prefix"._links_modrequest." values (NULL, $lid, $cid, 0, '$title', '$url', '$description', '$ratinguser', 1)", $dbi);
include("header.php");
//echo "insert into $prefix"._links_modrequest." values (NULL, $lid, $cid, 0, '$title', '$url', '$description', '$ratinguser', 1)";
menu(1);
echo "<br>";
OpenTable();
echo "<br><center>"._THANKSFORINFO."<br><br>"._LOOKTOREQUEST."</center><br>";
CloseTable();
include("footer.php");
}
function modifylinkrequest($lid) {
include("header.php");
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $user;
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$ratinguser = $cookie[1];
} else {
$ratinguser = "$anonymous";
}
menu(1);
echo "<br>";
OpenTable();
$blocknow = 0;
if ($blockunregmodify == 1 && $ratinguser=="$anonymous") {
echo "<br><br><center>"._ONLYREGUSERSMODIFY."</center>";
$blocknow = 1;
}
if ($blocknow != 1) {
$result = sql_query("select cid, sid, title, url, description from $prefix"._links_links." where lid=$lid", $dbi);
echo "<center><font class=\"option\"><b>"._REQUESTLINKMOD."</b></font><br><font class=\"content\">";
while(list($cid, $sid, $title, $url, $description) = sql_fetch_row($result, $dbi)) {
$title = stripslashes($title);
$description = stripslashes($description);
echo "<form action=\"modules.php?name=Web_Links\" method=\"post\">"
.""._LINKID.": <b>$lid</b></center><br><br><br>"
.""._LINKTITLE.":<br><input type=\"text\" name=\"title\" value=\"$title\" size=\"50\" maxlength=\"100\"><br><br>"
.""._URL.":<br><input type=\"text\" name=\"url\" value=\"$url\" size=\"50\" maxlength=\"100\"><br><br>"
.""._DESCRIPTION.": <br><textarea name=\"description\" cols=\"60\" rows=\"10\">$description</textarea><br><br>";
$result2=sql_query("select cid, title from $prefix"._links_categories." order by title", $dbi);
echo "<input type=\"hidden\" name=\"lid\" value=\"$lid\">"
."<input type=\"hidden\" name=\"modifysubmitter\" value=\"$ratinguser\">"
.""._CATEGORY.": <select name=\"cat\">";
$result2=sql_query("select cid, title, parentid from $prefix"._links_categories." order by title", $dbi);
while(list($cid2, $ctitle2, $parentid2) = sql_fetch_row($result2, $dbi)) {
if ($cid2==$cid) {
$sel = "selected";
} else {
$sel = "";
}
if ($parentid2!=0) $ctitle2=getparent($parentid2,$ctitle2);
echo "<option value=\"$cid2\" $sel>$ctitle2</option>";
}
echo "</select><br><br>"
."<input type=\"hidden\" name=\"op\" value=\"modifylinkrequestS\">"
."<input type=\"submit\" value=\""._SENDREQUEST."\"></form>";
}
}
CloseTable();
include("footer.php");
}
function modifylinkrequestS($lid, $cat, $title, $url, $description, $modifysubmitter) {
include("modules/Web_Links/l_config.php");
global $prefix, $dbi, $user;
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$ratinguser = $cookie[1];
} else {
$ratinguser = "$anonymous";
}
$blocknow = 0;
if ($blockunregmodify == 1 && $ratinguser=="$anonymous") {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><font class=\"content\">"._ONLYREGUSERSMODIFY."</font></center>";
$blocknow = 1;
CloseTable();
include("footer.php");
}
if ($blocknow != 1) {
$cat = explode("-", $cat);
if ($cat[1]=="") {
$cat[1] = 0;
}
$title = stripslashes(FixQuotes($title));
$url = stripslashes(FixQuotes($url));
$description = stripslashes(FixQuotes($description));
sql_query("insert into $prefix"._links_modrequest." values (NULL, $lid, $cat[0], $cat[1], '$title', '$url', '$description', '$ratinguser', 0)", $dbi);
include("header.php");
menu(1);
echo "<br>";
OpenTable();
echo "<center><font class=\"content\">"._THANKSFORINFO." "._LOOKTOREQUEST."</font></center>";
CloseTable();
include("footer.php");
}
}
function rateinfo($lid) {
global $prefix, $dbi;
sql_query("update $prefix"._links_links." set hits=hits+1 where lid=$lid", $dbi);
$result = sql_query("select url from $prefix"._links_links." where lid=$lid", $dbi);
list($url) = sql_fetch_row($result, $dbi);
Header("Location: $url");
}
function addrating($ratinglid, $ratinguser, $rating, $ratinghost_name, $ratingcomments) {
global $prefix, $dbi, $cookie, $user;
$passtest = "yes";
include("header.php");
include("modules/Web_Links/l_config.php");
completevoteheader();
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
cookiedecode($user);
$ratinguser = $cookie[1];
} else if ($ratinguser=="outside") {
$ratinguser = "outside";
} else {
$ratinguser = "$anonymous";
}
$results3 = sql_query("SELECT title FROM $prefix"._links_links." WHERE lid=$ratinglid", $dbi);
while(list($title)=sql_fetch_row($results3, $dbi))
$ttitle = $title;
$ip = getenv("REMOTE_HOST");
if (empty($ip)) {
$ip = getenv("REMOTE_ADDR");
}
/* Check if Rating is Null */
if ($rating=="--") {
$error = "nullerror";
completevote($error);
$passtest = "no";
}
/* Check if Link POSTER is voting (UNLESS Anonymous users allowed to post) */
if ($ratinguser != $anonymous && $ratinguser != "outside") {
$result=sql_query("select submitter from $prefix"._links_links." where lid=$ratinglid", $dbi);
while(list($ratinguserDB)=sql_fetch_row($result, $dbi)) {
if ($ratinguserDB==$ratinguser) {
$error = "postervote";
completevote($error);
$passtest = "no";
}
}
}
/* Check if REG user is trying to vote twice. */
if ($ratinguser!=$anonymous && $ratinguser != "outside") {
$result=sql_query("select ratinguser from $prefix"._links_votedata." where ratinglid=$ratinglid", $dbi);
while(list($ratinguserDB)=sql_fetch_row($result, $dbi)) {
if ($ratinguserDB==$ratinguser) {
$error = "regflood";
completevote($error);
$passtest = "no";
}
}
}
/* Check if ANONYMOUS user is trying to vote more than once per day. */
if ($ratinguser==$anonymous){
$yesterdaytimestamp = (time()-(86400 * $anonwaitdays));
$ytsDB = Date("Y-m-d H:i:s", $yesterdaytimestamp);
$result=sql_query("select * FROM $prefix"._links_votedata." WHERE ratinglid=$ratinglid AND ratinguser='$anonymous' AND ratinghostname = '$ip' AND TO_DAYS(NOW()) - TO_DAYS(ratingtimestamp) < $anonwaitdays", $dbi);
$anonvotecount = sql_num_rows($result, $dbi);
if ($anonvotecount >= 1) {
$error = "anonflood";
completevote($error);
$passtest = "no";
}
}
/* Check if OUTSIDE user is trying to vote more than once per day. */
if ($ratinguser=="outside"){
$yesterdaytimestamp = (time()-(86400 * $outsidewaitdays));
$ytsDB = Date("Y-m-d H:i:s", $yesterdaytimestamp);
$result=sql_query("select * FROM $prefix"._links_votedata." WHERE ratinglid=$ratinglid AND ratinguser='outside' AND ratinghostname = '$ip' AND TO_DAYS(NOW()) - TO_DAYS(ratingtimestamp) < $outsidewaitdays", $dbi);
$outsidevotecount = sql_num_rows($result, $dbi);
if ($outsidevotecount >= 1) {
$error = "outsideflood";
completevote($error);
$passtest = "no";
}
}
/* Passed Tests */
if ($passtest == "yes") {
$comment = stripslashes(FixQuotes($comment));
/* All is well. Add to Line Item Rate to DB. */
sql_query("INSERT into $prefix"._links_votedata." values (NULL,'$ratinglid', '$ratinguser', '$rating', '$ip', '$ratingcomments', now())", $dbi);
/* All is well. Calculate Score & Add to Summary (for quick retrieval & sorting) to DB. */
/* NOTE: If weight is modified, ALL links need to be refreshed with new weight. */
/* Running a SQL statement with your modded calc for ALL links will accomplish this. */
$voteresult = sql_query("select rating, ratinguser, ratingcomments FROM $prefix"._links_votedata." WHERE ratinglid = $ratinglid", $dbi);
$totalvotesDB = sql_num_rows($voteresult, $dbi);
include ("voteinclude.php");
sql_query("UPDATE $prefix"._links_links." SET linkratingsummary=$finalrating,totalvotes=$totalvotesDB,totalcomments=$truecomments WHERE lid = $ratinglid", $dbi);
$error = "none";
completevote($error);
}
completevotefooter($ratinglid, $ttitle, $ratinguser);
include("footer.php");
}
function completevoteheader(){
menu(1);
echo "<br>";
OpenTable();
}
function completevotefooter($lid, $ttitle, $ratinguser) {
global $prefix, $dbi;
include("modules/Web_Links/l_config.php");
$result=sql_query("select url FROM $prefix"._links_links." WHERE lid=$lid", $dbi);
list($url)=sql_fetch_row($result, $dbi);
echo "<font class=\"content\">"._THANKSTOTAKETIME." $sitename. "._LETSDECIDE."</font><br><br><br>";
if ($ratinguser=="outside") {
echo "<center><font class=\"content\">".WEAPPREACIATE." $sitename!<br><a href=\"$url\">"._RETURNTO." $ttitle</a></font><center><br><br>";
$result=sql_query("select title FROM $prefix"._links_links." where lid=$lid", $dbi);
list($title)=sql_fetch_row($result, $dbi);
$ttitle = ereg_replace (" ", "_", $title);
}
echo "<center>";
linkinfomenu($lid,$ttitle);
echo "</center>";
CloseTable();
}
function completevote($error) {
include("modules/Web_Links/l_config.php");
if ($error == "none") echo "<center><font class=\"content\"><b>"._COMPLETEVOTE1."</b></font></center>";
if ($error == "anonflood") echo "<center><font class=\"option\"><b>"._COMPLETEVOTE2."</b></font></center><br>";
if ($error == "regflood") echo "<center><font class=\"option\"><b>"._COMPLETEVOTE3."</b></font></center><br>";
if ($error == "postervote") echo "<center><font class=\"option\"><b>"._COMPLETEVOTE4."</b></font></center><br>";
if ($error == "nullerror") echo "<center><font class=\"option\"><b>"._COMPLETEVOTE5."</b></font></center><br>";
if ($error == "outsideflood") echo "<center><font class=\"option\"><b>"._COMPLETEVOTE6."</b></font></center><br>";
}
function ratelink($lid, $user, $ttitle) {
include("header.php");
menu(1);
echo "<br>";
OpenTable();
$transfertitle = ereg_replace ("_", " ", $ttitle);
$displaytitle = $transfertitle;
global $prefix, $dbi, $cookie, $datetime;
$ip = getenv("REMOTE_HOST");
if (empty($ip)) {
$ip = getenv("REMOTE_ADDR");
}
echo "<b>$displaytitle</b>"
."<ul><font class=\"content\">"
."<li>"._RATENOTE1.""
."<li>"._RATENOTE2.""
."<li>"._RATENOTE3.""
."<li>"._RATENOTE4.""
."<li>"._RATENOTE5."";
if(is_user($user)) {
$user2 = base64_decode($user);
$cookie = explode(":", $user2);
echo "<li>"._YOUAREREGGED.""
."<li>"._FEELFREE2ADD."";
cookiedecode($user);
$auth_name = $cookie[1];
} else {
echo "<li>"._YOUARENOTREGGED.""
."<li>"._IFYOUWEREREG."";
$auth_name = "$anonymous";
}
echo "</ul>"
."<form method=\"post\" action=\"modules.php?name=Web_Links\">"
."<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\" width=\"100%\">"
."<tr><td width=\"25\" nowrap></td>"
."<tr><td width=\"25\" nowrap></td><td width=\"550\">"
."<input type=\"hidden\" name=\"ratinglid\" value=\"$lid\">"
."<input type=\"hidden\" name=\"ratinguser\" value=\"$auth_name\">"
."<input type=\"hidden\" name=\"ratinghost_name\" value=\"$ip\">"
."<font class=content>"._RATETHISSITE.""
."<select name=\"rating\">"
."<option>--</option>"
."<option>10</option>"
."<option>9</option>"
."<option>8</option>"
."<option>7</option>"
."<option>6</option>"
."<option>5</option>"
."<option>4</option>"
."<option>3</option>"
."<option>2</option>"
."<option>1</option>"
."</select></font>"
."<font class=\"content\"><input type=\"submit\" value=\""._RATETHISSITE."\"></font>"
."<br><br>";
if(is_user($user)) {
echo "<b>"._SCOMMENTS.":</b><br><textarea wrap=\"virtual\" cols=\"50\" rows=\"10\" name=\"ratingcomments\"></textarea>"
."<br><br><br>"
."</font></td>";
} else {
echo"<input type=\"hidden\" name=\"ratingcomments\" value=\"\">";
}
echo "</tr></table></form>";
echo "<center>";
linkfooterchild($lid);
echo "</center>";
CloseTable();
include("footer.php");
}
if (isset($ratinglid) && isset ($ratinguser) && isset ($rating)) {
$ret = addrating($ratinglid, $ratinguser, $rating, $ratinghost_name, $ratingcomments);
}
switch($l_op) {
case "menu":
menu($mainlink);
break;
case "AddLink":
AddLink();
break;
case "NewLinks":
NewLinks($newlinkshowdays);
break;
case "NewLinksDate":
NewLinksDate($selectdate);
break;
case "TopRated":
TopRated($ratenum, $ratetype);
break;
case "MostPopular":
MostPopular($ratenum, $ratetype);
break;
case "RandomLink":
RandomLink();
break;
case "viewlink":
viewlink($cid, $min, $orderby, $show);
break;
case "brokenlink":
brokenlink($lid);
break;
case "modifylinkrequest":
modifylinkrequest($lid);
break;
case "modifylinkrequestS":
modifylinkrequestS($lid, $cat, $title, $url, $description, $modifysubmitter);
break;
case "brokenlinkS":
brokenlinkS($lid,$cid, $title, $url, $description, $modifysubmitter);
break;
case "visit":
visit($lid);
break;
case "Add":
Add($title, $url, $auth_name, $cat, $description, $email);
break;
case "search":
search($query, $min, $orderby, $show);
break;
case "rateinfo":
rateinfo($lid, $user, $title);
break;
case "ratelink":
ratelink($lid, $user, $ttitle);
break;
case "addrating":
addrating($ratinglid, $ratinguser, $rating, $ratinghost_name, $ratingcomments, $user);
break;
case "viewlinkcomments":
viewlinkcomments($lid, $ttitle);
break;
case "outsidelinksetup":
outsidelinksetup($lid);
break;
case "viewlinkeditorial":
viewlinkeditorial($lid, $ttitle);
break;
case "viewlinkdetails":
viewlinkdetails($lid, $ttitle);
break;
default:
index();
break;
}
?>