3) $defaultorder=0; if (($o<0 && $o>3) || !isset($o)) $o=$defaultorder; function ShowParts($cid) { GLOBAL $cat,$TMPL,$db; $r=mysql_query("SELECT name,cid,count FROM ".$db["prefix"]."cat WHERE parent='$cid' ORDER BY name") or die(mysql_error()); $num=0; $cnt=mysql_num_rows($r); if ($cnt==0) return; print $TMPL["partstop"]; for ($i=0;$i<$cnt;$i++) { $num++; if ($num==1) print $TMPL["partsdelimtop"]; $template=$TMPL["partsbit"]; $template=str_replace("%CTITLE",mysql_result($r,$i,0),$template); $template=str_replace("%CID",mysql_result($r,$i,1),$template); $template=str_replace("%CCOUNT",mysql_result($r,$i,2),$template); print $template; if ($num==$cat["rows"]) {print $TMPL["partsdelimbottom"];$num=0;} } print $TMPL["partsbottom"]; } function ShowCat($cid,$best=0) { GLOBAL $start,$pp,$o,$sid,$LANG,$TMPL,$db; if ($best==1) $bestsql="AND moder_vote=10"; else $bestsql="AND moder_vote!=10"; if ($o==0) $order="ORDER BY gin DESC,gout DESC"; if ($o==1) $order="ORDER BY title"; if ($o==2) $order="ORDER BY moder_vote DESC, gout DESC"; if ($o==3) $order="ORDER BY insert_date DESC"; if ($cid!=0) $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid $order LIMIT $start,$pp;"; else $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql $order LIMIT $start,$pp;"; $r=mysql_query($Q) or die(mysql_error()); $cnt=mysql_num_rows($r); if ($cnt==0 && $best!=1) print $LANG["linksnotfound"]; while ($ar=mysql_fetch_array($r)) { $admin=""; if (isset($sid)) { $admin.=" [".$LANG["edit"]."]"; $admin.="[".$LANG["delete"]."] ["; for ($j=1;$j<11;$j++) { if ($j==$ar["moder_vote"]) $admin.="".$j." "; else $admin.="".$j." "; } $admin.="]"; } $template=($best==1)?$TMPL["bestlinksbit"]:$TMPL["linksbit"]; $template=str_replace("%ID",$ar["lid"],$template); $template=str_replace("%TITLE",$ar["title"],$template); $template=str_replace("%GIN",$ar["gin"],$template); $template=str_replace("%GOUT",$ar["gout"],$template); $template=str_replace("%MODERVOTE",$ar["moder_vote"],$template); $template=str_replace("%DESC",$ar["description"],$template); $template=str_replace("%URL",$ar["url"],$template); $template=str_replace("%BEST","",$template); $template=str_replace("%BROKENTEXT",$LANG["broken"],$template); $template=str_replace("%RESFIELD1",$ar["resfield1"],$template); $template=str_replace("%RESFIELD2",$ar["resfield2"],$template); $template=str_replace("%RESFIELD3",$ar["resfield3"],$template); $template=str_replace("%ADMINIFACE",$admin,$template); print $template; } if ($best!=1) { if ($cid!=0) return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid;"),0,0)); else return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql;"),0,0)); } } $c=intval($c); $start=intval($start); $pp=100; $cid=$c;$l=""; do { $r=mysql_query("SELECT parent,name,cid FROM ".$db["prefix"]."cat WHERE cid='$cid';") or die(mysql_error()); if (mysql_num_rows($r)==1) { $id=mysql_result($r,0,2); $title=mysql_result($r,0,1); if ($cid==$c) $l=mysql_result($r,0,1).$l; else $l="".$title." » ".$l; $cid=mysql_result($r,0,0); } else $cid=0; } while ($cid!=0); $r=mysql_query("SELECT name FROM ".$db["prefix"]."cat WHERE cid='$c';") or die(mysql_error()); if (mysql_num_rows($r)!=0) $title=mysql_result($r,0,0)." / ".$CATNAME; else $title=$CATNAME; include "_top.php"; $template=$TMPL["bmenu"]; $template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template); $template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template); $template=str_replace("%MAINTEXT",$LANG["main"],$template); print $template; $template=$TMPL["brokenscript"]; $template=str_replace("%YESTEXT",$LANG["yes"],$template); $template=str_replace("%NOTEXT",$LANG["no"],$template); $template=str_replace("%BROKENSURETEXT",$LANG["brokensure"],$template); print $template; $sform=$TMPL["searchform"]; $sform=str_replace("%SEARCHTEXT",$LANG["search"],$sform); $sform=str_replace("%QUERYTEXT",$q,$sform); print $sform; $template=$TMPL["catname"]; $template=str_replace("%MAINTEXT",$CATNAME,$template); $template=str_replace("%OTHERTEXT",$l,$template); print $template; ShowParts($c); if (intval($c)==0 && $cat["shownew"]==1) { if ($o==0) $sortbypop="".$LANG["popuarity"].""; else $sortbypop="".$LANG["popuarity"].""; if ($o==1) $sortbytitle="".$LANG["title"].""; else $sortbytitle="".$LANG["title"].""; if ($o==2) $sortbymoder="".$LANG["modervote"].""; else $sortbymoder="".$LANG["modervote"].""; if ($o==3) $sortbyin="".$LANG["sortbyin"].""; else $sortbyin="".$LANG["sortbyin"].""; $template=$TMPL["sortby"]; $template=str_replace("%SORTBYPOP",$sortbypop,$template); $template=str_replace("%SORTBYTITLE",$sortbytitle,$template); $template=str_replace("%SORTBYMODER",$sortbymoder,$template); $template=str_replace("%SORTBYIN",$sortbyin,$template); $template=str_replace("%SORTBYTEXT",$LANG["sortby"],$template); print $template; $newlinkstop=$TMPL["newlinkstop"]; $newlinkstop=str_replace("%NEWLINKSTEXT",$LANG["newlinks"],$newlinkstop); print $newlinkstop; $r=mysql_query("SELECT lid,title,description,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 ORDER by lid DESC LIMIT ".$cat["shownewcount"].";"); while ($ar=mysql_fetch_array($r)) { if (strlen($ar["description"])>75) $ar["description75"]=substr($ar["description"],0,75)."..."; else $ar["description75"]=$ar["description"]; $template=$TMPL["newlinkstbit"]; $template=str_replace("%ID",$ar["lid"],$template); $template=str_replace("%TITLE",$ar["title"],$template); $template=str_replace("%GIN",$ar["gin"],$template); $template=str_replace("%GOUT",$ar["gout"],$template); $template=str_replace("%MODERVOTE",$ar["moder_vote"],$template); $template=str_replace("%DESC75",$ar["description75"],$template); $template=str_replace("%DESC",$ar["description"],$template); $template=str_replace("%URL",$ar["url"],$template); $template=str_replace("%RESFIELD1",$ar["resfield1"],$template); $template=str_replace("%RESFIELD2",$ar["resfield2"],$template); $template=str_replace("%RESFIELD3",$ar["resfield3"],$template); print $template; } print $TMPL["newlinkstbottom"]; } if ($cat["linksatmain"]==1 || $c!=0) { print $TMPL["linkstop"]; ShowCat($c,1); print str_replace("%NUM",(1+$start),$TMPL["linksmiddle"]); $total=ShowCat($c); print $TMPL["linksbottom"]; print "

".$LANG["linkcount"].": $total

"; } if ($total>$pp) { print "
"; if ($start!=0) print "<< | "; else print "<< | "; $sstart=$start-60; if ($sstart<0) $sstart=0; $send=$start+60;if ($send>$total) $send=$total; for ($i=$sstart;$i<$send;$i+=$pp) { if ($start==$i) print "".($i+1).""; else print "".($i+1).""; print " | "; } if ($start==$i-$pp) print ">>"; else print ">>"; print "
"; } $template=$TMPL["bmenu"]; $template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template); $template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template); $template=str_replace("%MAINTEXT",$LANG["main"],$template); print $template; print $COPY; include "_bottom.php"; ?>