rendered paste body<?php/** ------------------------------------------------------------------------ * Project : Reciprocal Link Directory * Author : Shaun Walker * Email : shaun@shaun-walker.com * Project site : www.shaun-walker.com * ------------------------------------------------------------------------- * * File Name: func.inc.php */function link_goto($show_url,$cat_name){ $cat_id = mysql_result(mysql_query("SELECT * from cats where name='$cat_name'"),0,'catID'); $catlink="SELECT * from links where cat='$cat_id' and validated='1' order by name ASC"; $catlink2=mysql_query($catlink) or die("Unable to grab main catergories"); if(mysql_num_rows($catlink2) == '0') { print "Sorry there are no links"; } else { while($catlink3=mysql_fetch_array($catlink2)) { if($show_url == '1') { print "<A target='_new' href='$catlink3[url]'>$catlink3[name] - $catlink3[url]</a><br />\n"; } else { print "<A target='_new' href='../../out.php?go=$catlink3[linkID]'>$catlink3[name] - $catlink3[url]</a><br />\n"; } print "$catlink3[info]<p>"; } }}function sublink_goto($cat,$show_url,$subcat,$cat_name){ $cat_id = mysql_result(mysql_query("SELECT * from cats where name='$subcat'"),0,'catID'); $catlink="SELECT * from links where cat='$cat_id' and validated='1' order by name ASC"; $catlink2=mysql_query($catlink) or die("Unable to grab main catergories"); if(mysql_num_rows($catlink2) == '0') { print "Sorry there are no links"; } else { while($catlink3=mysql_fetch_array($catlink2)) { if($show_url == '1') { print "<A target='_new' href='$catlink3[url]'>$catlink3[name] - $catlink3[url]</a><br />\n"; } else { print "<A target='_new' href='../../out.php?go=$catlink3[linkID]'>$catlink3[name] - $catlink3[url]</a><br />\n"; } print "$catlink3[info]<p>"; } }}function cats($cat_col,$mod_rewrite){ $maincats="SELECT * from cats where subcat=0 order by name ASC"; $maincats2=mysql_query($maincats) or die("Unable to grab main catergories"); $add=0; while($maincats3=mysql_fetch_array($maincats2)) { if($mod_rewrite == '1') { $cat = "<A href='CAT/$maincats3[name]/' title='$maincats3[name]'>$maincats3[name]</a> <br />\n"; } else { $cat = "<A href='$_SERVER[PHP_SELF]?cat=$maincats3[name]' title='$maincats3[name]'>$maincats3[name]</a> <br />\n"; } if($add%$cat_col==0) { print "<tr height='30'><td>$cat</td>\n"; } else if($add%$cat_col==1) { print "<td>$cat</td>\n"; } else { print "<td>$cat</td></tr>\n"; } $add++; }}function sub_cats($cat_col,$mod_rewrite,$cat_name,$site_url){ $cat_id = mysql_result(mysql_query("SELECT * from cats where name='$cat_name'"),0,'catID'); $subcats="SELECT * from cats where subcat='$cat_id' order by name ASC"; $subcats2=mysql_query($subcats); $add=0; while($subcats3=mysql_fetch_array($subcats2)) { if($subcats3[catID] <= '1'){} //make sure there is subcats before starting, stops it coming up with '(, )' else { if($mod_rewrite == '1') //check for mod_rewrite, if not use ?cat=132&subcat=24 { $subcat = "<A href='../../SUB/".$cat_name."_".$subcats3[name]."/' title='$subcats3[name]'>$subcats3[name]</a><br /> \n";// - $num_links } else { $subcat = "<A href='$_SERVER[PHP_SELF]?cat=$cat_name&subcat=$subcats3[name]' title='$subcats3[name]'>$subcats3[name]</a><br />\n"; } $subcat .= "$subcats3[info]<p>\n"; if($add%$cat_col==0) { print "<tr><td>$subcat</td>\n"; } else if($add%$cat_col==1) { print "<td>$subcat</td>\n"; } else { print "<td>$subcat</td></tr>\n"; } $add++; } }}?>