<?

$alpha = $_GET['alpha'];
$page = $_GET['page'];
$cat = $_GET['cat'];

$page = intval($_GET["resultpage"]);

if (get_magic_quotes_gpc()) { $alpha = stripslashes($alpha); }
$alpha = mysql_real_escape_string($alpha);

if (get_magic_quotes_gpc()) { $cat = stripslashes($cat); }
$cat = mysql_real_escape_string($cat);

if (get_magic_quotes_gpc()) { $page = stripslashes($page); }
$page = mysql_real_escape_string($page);

$alpha = strtolower($alpha);
$cat = strtolower($cat);

$alpha = strtolower($alpha);
$alpha2 = strtoupper($alpha);

$healthy = array("_");
$yummy  = array(" ");

$catz = $cat = strtolower($cat);
$cat = str_replace($healthy, $yummy, $cat);
$cat2 = ucwords($cat); 


if ($alpha && $cat) {

function remove_accent($str) 
{ 
  $a = array('ß', ' ', '&#39', '&', 'À', 'Á', 'Â', 'Ã', 'Ä', 'Å', 'Æ', 'Ç', 'È', 'É', 'Ê', 'Ë', 'Ì', 'Í', 'Î', 'Ï', 'Ð', 'Ñ', 'Ò', 'Ó', 'Ô', 'Õ', 'Ö', 'Ø', 'Ù', 'Ú', 'Û', 'Ü', 'Ý', 'ß', 'à', 'á', 'â', 'ã', 'ä', 'å', 'æ', 'ç', 'è', 'é', 'ê', 'ë', 'ì', 'í', 'î', 'ï', 'ñ', 'ò', 'ó', 'ô', 'õ', 'ö', 'ø', 'ù', 'ú', 'û', 'ü', 'ý', 'ÿ', '&#256;', '&#257;', '&#258;', '&#259;', '&#260;', '&#261;', '&#262;', '&#263;', '&#264;', '&#265;', '&#266;', '&#267;', '&#268;', '&#269;', '&#270;', '&#271;', '&#272;', '&#273;', '&#274;', '&#275;', '&#276;', '&#277;', '&#278;', '&#279;', '&#280;', '&#281;', '&#282;', '&#283;', '&#284;', '&#285;', '&#286;', '&#287;', '&#288;', '&#289;', '&#290;', '&#291;', '&#292;', '&#293;', '&#294;', '&#295;', '&#296;', '&#297;', '&#298;', '&#299;', '&#300;', '&#301;', '&#302;', '&#303;', '&#304;', '&#305;', '&#306;', '&#307;', '&#308;', '&#309;', '&#310;', '&#311;', '&#313;', '&#314;', '&#315;', '&#316;', '&#317;', '&#318;', '&#319;', '&#320;', '&#321;', '&#322;', '&#323;', '&#324;', '&#325;', '&#326;', '&#327;', '&#328;', '&#329;', '&#332;', '&#333;', '&#334;', '&#335;', '&#336;', '&#337;', 'Œ', 'œ', '&#340;', '&#341;', '&#342;', '&#343;', '&#344;', '&#345;', '&#346;', '&#347;', '&#348;', '&#349;', '&#350;', '&#351;', 'Š', 'š', '&#354;', '&#355;', '&#356;', '&#357;', '&#358;', '&#359;', '&#360;', '&#361;', '&#362;', '&#363;', '&#364;', '&#365;', '&#366;', '&#367;', '&#368;', '&#369;', '&#370;', '&#371;', '&#372;', '&#373;', '&#374;', '&#375;', 'Ÿ', '&#377;', '&#378;', '&#379;', '&#380;', 'Ž', 'ž', '&#383;', 'ƒ', '&#416;', '&#417;', '&#431;', '&#432;', '&#461;', '&#462;', '&#463;', '&#464;', '&#465;', '&#466;', '&#467;', '&#468;', '&#469;', '&#470;', '&#471;', '&#472;', '&#473;', '&#474;', '&#475;', '&#476;', '&#506;', '&#507;', '&#508;', '&#509;', '&#510;', '&#511;'); 
  $b = array('ss', '_', '\'', '&amp', 'A', 'A', 'A', 'A', 'A', 'A', 'AE', 'C', 'E', 'E', 'E', 'E', 'I', 'I', 'I', 'I', 'D', 'N', 'O', 'O', 'O', 'O', 'O', 'O', 'U', 'U', 'U', 'U', 'Y', 's', 'a', 'a', 'a', 'a', 'a', 'a', 'ae', 'c', 'e', 'e', 'e', 'e', 'i', 'i', 'i', 'i', 'n', 'o', 'o', 'o', 'o', 'o', 'o', 'u', 'u', 'u', 'u', 'y', 'y', 'A', 'a', 'A', 'a', 'A', 'a', 'C', 'c', 'C', 'c', 'C', 'c', 'C', 'c', 'D', 'd', 'D', 'd', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'E', 'e', 'G', 'g', 'G', 'g', 'G', 'g', 'G', 'g', 'H', 'h', 'H', 'h', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'I', 'i', 'IJ', 'ij', 'J', 'j', 'K', 'k', 'L', 'l', 'L', 'l', 'L', 'l', 'L', 'l', 'l', 'l', 'N', 'n', 'N', 'n', 'N', 'n', 'n', 'O', 'o', 'O', 'o', 'O', 'o', 'OE', 'oe', 'R', 'r', 'R', 'r', 'R', 'r', 'S', 's', 'S', 's', 'S', 's', 'S', 's', 'T', 't', 'T', 't', 'T', 't', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'W', 'w', 'Y', 'y', 'Y', 'Z', 'z', 'Z', 'z', 'Z', 'z', 's', 'f', 'O', 'o', 'U', 'u', 'A', 'a', 'I', 'i', 'O', 'o', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'U', 'u', 'A', 'a', 'AE', 'ae', 'O', 'o'); 
  $result = str_replace($a, $b, $str); 
  return $result;
}  
  
///////
  
function search($str, $gender) {

$result = array();
  
include 'japanese.php';
  
$k = count($english);
$str = strtolower($str);
$pieces = explode("/", $str);
$l = count($pieces);
  
  
for ($m = 0; $m < $l; $m++) {
 
$type = trim($pieces[$m]);  

for ($i = 0; $i <= $k+1; $i++) {
  
$word = strtolower($english[$i]);
  
if ($type == $word) { 
  
if ($gender<>"2") { $result[] = $japanese_m[$i]; } else {
  
if ($japanese_f[$i]<>"") { $result[] = $japanese_f[$i]; } else { $result[] = $japanese_m[$i]; } } 
  
  
} } } 
  
$sp="";

$l = count($result);
  
  
if ($result[0]<>"") {
  
for ($n = 0; $n <= $l-2; $n++) { $sp = $sp."".$result[$n]." / "; }  

$sp = $sp."".$result[$l-1];


return $sp; } else { return ""; }
  
}
  
///////
  

switch($cat) 
       { 

       case "actor";
          $cat3="Actor";
          $cat4="&#26144;&#30011;&#20467;&#20778;";
          break;
       case "actress": 
          $cat3="Actress"; 
          $cat4="&#22899;&#20778;";
          break; 
       case "director": 
          $cat3="Director"; 
          $cat4="&#26144;&#30011;&#30435;&#30563;";
          break; 
       case "singer": 
          $cat3="Singer";
          $cat4="&#27468;&#25163;"; 
          break; 
       case "music group": 
          $cat3="Music Group"; 
          $cat4="&#38899;&#27005;&#12464;&#12523;&#12540;&#12503;"; 
          break; 
       case "tennis player": 
          $cat3="Tennis Player"; 
          $cat4="&#12486;&#12491;&#12473;&#36984;&#25163;"; 
          break; 
       case "tv presenter": 
          $cat3="TV Presenter"; 
          $cat4="&#12486;&#12524;&#12499;&#21496;&#20250;&#32773;"; 
          break; 
       case "model": 
          $cat3="Model"; 
          $cat4="&#12514;&#12487;&#12523;"; 
          break; 
       case "author": 
          $cat3="Author"; 
          $cat4="&#33879;&#32773;"; 
          break;
       case "wrestler": 
          $cat3="Wrestler"; 
          $cat4="&#12503;&#12525;&#12524;&#12473;&#12521;&#12540;"; 
          break; 
       case "tv series": 
          $cat3="TV Series"; 
          $cat4="&#12486;&#12524;&#12499;&#12471;&#12522;&#12540;&#12474;"; 
          break; 
       case "nba": 
          $cat3="nba team"; 
          $cat4="NBA&#12481;&#12540;&#12512;"; 
          break; 
       case "nfl": 
          $cat3="nfl team"; 
          $cat4="NFL&#12481;&#12540;&#12512;"; 
          break; 
       case "mlb": 
          $cat3="mlb team"; 
          $cat4="MLB&#12481;&#12540;&#12512;"; 
          break;
       case "baseball player": 
          $cat3="Baseball Player"; 
          $cat4="&#37326;&#29699;&#36984;&#25163;"; 
          break; 
       case "mlb player": 
          $cat3="MLB Player"; 
          $cat4="&#12503;&#12525;&#37326;&#29699;&#36984;&#25163;"; 
          break;
       case "nba player": 
          $cat3="NBA Player"; 
          $cat4="&#12496;&#12473;&#12465;&#12483;&#12488;&#12508;&#12540;&#12523;&#36984;&#25163;"; 
          break;          
       case "nhl player": 
          $cat3="NHL Player"; 
          $cat4="&#12503;&#12525;&#12450;&#12452;&#12473;&#12507;&#12483;&#12465;&#12540;&#36984;&#25163;"; 
          break;    
       case "soccer team": 
          $cat3="Soccer Team"; 
          $cat4="&#12503;&#12525;&#12469;&#12483;&#12459;&#12540;&#12463;&#12521;&#12502;"; 
          break;
       case "driver": 
          $cat3="Driver"; 
          $cat4="&#12489;&#12521;&#12452;&#12496;"; 
          break; 
          default;
       case "football": 
          $cat3="NFL Player"; 
          $cat4="&#12450;&#12513;&#12522;&#12459;&#12531;&#12501;&#12483;&#12488;&#12508;&#12540;&#12523;&#12503;&#12524;&#12452;&#12516;&#12540;"; 
          break; 
          default;
          $cat3="&#26144;&#30011;&#20467;&#20778;"; 
          $cat4="&#26144;&#30011;&#20467;&#20778;"; 
          break;

       }

require_once ($_SERVER['DOCUMENT_ROOT'] . '/pagination.php');

if ($alpha && $cat) {

$rpp = 28;
$adjacents = 50;


if($page<=0) $page = 1;

$link_id = mysql_connect('localhost','fanmail2k8','o0wgilzcb1oema57') or die(mysql_error());
mysql_select_db('ntup002_address', $link_id);
$sql = "select * from table7 where lastname like '$alpha%' and type like '%$cat3%' order by lastname, firstname";
$result = mysql_query($sql, $link_id);


$tcount = mysql_num_rows($result);
$tpages = ($tcount) ? ceil($tcount/$rpp) : 1; // total pages, last page number

$count = 0;
$i = ($page-1)*$rpp;

if ($result) {

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="ja" xml:lang="ja">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Language" content="ja">

<meta name="description" content="<? echo $cat4;?>&#12398;&#20303;&#25152;&#12290;">
<meta name="keywords" content="<? echo $cat4;?>, &#20303;&#25152;, &#22899;&#20778;, &#22899;&#20778;, &#20467;&#20778;, &#27468;&#25163;, &#38899;&#27005;&#12464;&#12523;&#12540;&#12503;, &#30435;&#30563;, &#12514;&#12487;&#12523;, &#20467;&#20778; &#21517;&#37969;, &#12513;&#12540;&#12523;&#12450;&#12489;&#12524;&#12473; &#21462;&#24471;, &#26377;&#21517;&#20154;, &#12473;&#12509;&#12540;&#12484;&#36984;&#25163;, &#28023;&#22806;, &#12469;&#12452;&#12531;, &#12501;&#12449;&#12531;&#12288;&#12513;&#12540;&#12523;, &#12495;&#12522;&#12454;&#12483;&#12489;, &#28023;&#22806; &#20467;&#20778;, &#23451;&#20808;, &#30475;&#26495;, &#30452;&#31558;, &#20303;&#25152; &#26908;&#32034;, &#12501;&#12449;&#12531;&#12524;&#12479;&#12540; &#12398; &#26360;&#12365;&#26041;, &#12501;&#12449;&#12531;&#12524;&#12479;&#12540;, &#12501;&#12449;&#12531;&#12524;&#12479;&#12540; &#12398; &#36820;&#20107;">
<meta name="robots" content="all">
<title><? echo $cat4; ?>&#12398;&#20303;&#25152; - FanMail.biz &#9733;</title>
<link rel="stylesheet" type="text/css" href="http://jp.fanmail.biz/style2.css" />
</head>
<body>
<div id="frame">
<table style="width:980px; background-color:#FFF;" align="center" border="0">

<tr>
<td align="center">
  
<table style="height:15px; padding-bottom:11px; background-color:#FFF; width:850px" align="center" border="0">
<tr>
<td style="text-align:left; width:410px">
  
<a href="http://www.fanmail.biz/mboard/">&#12501;&#12457;&#12540;&#12521;&#12512;</a> | <a href="http://www.fanmail.biz/mboard/viewforum.php?f=2">&#12501;&#12449;&#12531;&#12524;&#12479;&#12540; &#12398; &#36820;&#20107;</a>
 
</td>
  
<td style="text-align:center">
  
<form action="http://www.fanmail.biz/search/" accept-charset="utf-8"/><input name="q" type="text" style="color:#000000; height:19px; padding-left:5px;" placeholder="Fanmail.biz &#26908;&#32034;..." size="39" /><input type="submit" style="color:#000000;" name="sa" value="&#26908;&#32034;" /><input name="lang" type="hidden" value="jp"><br /></form>

</td>
</tr>
</table>
  

<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 728x90, created 8/6/08 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:728px;height:90px"
     data-ad-client="ca-pub-4547783287984317"
     data-ad-slot="7021268674"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
<br>
  

<table style="width:850px; padding-top:10px; padding-bottom:10px; background-color:#FFF; line-height: 1.5;" align="center">
<tr>
<td width="142"><a href="/"><img src="/images/fanmail_small_logo.gif" alt="Fanmail.biz" align="absmiddle" /></a></td>
<td>
<left>
<a href="/actor/a/1.html">&#26144;&#30011;&#20467;&#20778;</a> | <a href="/actress/a/1.html">&#22899;&#20778;</a> | <a href="/director/a/1.html">&#26144;&#30011;&#30435;&#30563;</a> | <a href="/singer/a/1.html">&#27468;&#25163;</a> | <a href="/music_group/a/1.html">&#38899;&#27005;&#12464;&#12523;&#12540;&#12503;</a> | <a href="/tennis_player/a/1.html">&#12486;&#12491;&#12473;&#36984;&#25163;</a> | <a href="/soccer_team/a/1.html">&#12503;&#12525;&#12469;&#12483;&#12459;&#12540;&#12463;&#12521;&#12502;</a> | <a href="/a/1.html">&#12450;&#12523;&#12501;&#12449;&#12505;&#12483;&#12488;&#38918;&#12395;</a>
<br /><a href="/baseball_player/a/1.html">&#37326;&#29699;&#36984;&#25163;</a> | <a href="/wrestler/a/1.html">&#12524;&#12473;&#12522;&#12531;&#12464;&#36984;&#25163;/a> | <a href="/author/a/1.html">&#33879;&#32773;</a> | <a href="/tv_presenter/a/1.html">&#12486;&#12524;&#12499;&#21496;&#20250;&#32773;</a> | <a href="/football/a/1.html">&#12450;&#12513;&#12522;&#12459;&#12531;&#12501;&#12483;&#12488;&#12508;&#12540;&#12523;&#12503;&#12524;&#12452;&#12516;&#12540;</a> | <a href="/mlb/a/1.html">MLB</a> | <a href="/nba/a/1.html">NBA</a> | <a href="/nfl/a/1.html">NFL</a>
</left>
</td>
</tr>
<tr>
<td></td>
</tr>
</table>  
  
<hr style="border: 0; border-top: 1px solid #CCC; border-bottom: 1px solid #fff;">
  

<table style="width: 850px;" align="center">
<tr>
  
<td width="90" align="center" style="text-align: right; vertical-align: top;>">

  
<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- Fanmail_sub2 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:120px;height:600px"
     data-ad-client="ca-pub-4547783287984317"
     data-ad-slot="5893546449"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script>
  
</td>
  
  
<td style="padding: 15px 10px 0px 10px; vertical-align: top; line-height: 1.5;">
  
<br />
<b>Notice</b>:  Undefined variable: alpha2 in <b>/var/www/vhosts/jp/category.php</b> on line <b>304</b><br />
<br />
<b>Notice</b>:  Undefined variable: cat4 in <b>/var/www/vhosts/jp/category.php</b> on line <b>304</b><br />
<b> - </b>
  
<br /><br /><a href="http://jp.fanmail.biz/<? echo $catz;?>/a/1.html">A</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/b/1.html">B</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/c/1.html">C</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/d/1.html">D</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/e/1.html">E</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/f/1.html">F</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/g/1.html">G</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/h/1.html">H</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/i/1.html">I</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/j/1.html">J</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/k/1.html">K</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/l/1.html">L</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/m/1.html">M</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/n/1.html">N</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/o/1.html">O</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/p/1.html">P</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/q/1.html">Q</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/r/1.html">R</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/s/1.html">S</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/t/1.html">T</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/u/1.html">U</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/v/1.html">V</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/w/1.html">W</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/x/1.html">X</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/y/1.html">Y</a> | <a href="http://jp.fanmail.biz/<? echo $catz;?>/z/1.html">Z</a><br /><br />
 

<br />
<b>Notice</b>:  Undefined variable: count in <b>/var/www/vhosts/jp/category.php</b> on line <b>313</b><br />
<br />
<b>Notice</b>:  Undefined variable: rpp in <b>/var/www/vhosts/jp/category.php</b> on line <b>313</b><br />
   
  
</td>
  
  
<td style="text-align: left; vertical-align: top; line-height: 1.5; max-width: 240px; overflow-wrap: break-word;" width="240">
  
<br /><div style="margin-top:-5px">&#12501;&#12451;&#12540;&#12489;&#12496;&#12483;&#12463; (5&#20998;&#27598;&#12395;&#26356;&#26032;&#12375;&#12383;):</div><br />
  
<? include("10b.php")?>
  
<br />
  
<div id="picture"><a href="http://jp.fanmail.biz/1001.html"><img border="0" src="http://jp.fanmail.biz/images/<? echo $num ?>.jpg" width="240" height="300" title="<? echo $alt ?>" alt="<? echo $alt ?>"></a></div>

<br /><br /><form action="http://www.fanmail.biz/search/" accept-charset="utf-8"/><input name="q" type="text" style="color:#000000; height:19px; padding-left:5px;" placeholder="Fanmail.biz &#26908;&#32034;...." size="21" /><input type="submit" style="color:#000000;" name="sa" value="&#26908;&#32034;" /><input name="lang" type="hidden" value="jp"><br /></form><br />
  
  
<p style="text-align: left";>&#24613;&#19978;&#26119;&#12527;&#12540;&#12489;:</p><div id="queries" style="text-align: left; width: 240px; text-transform: capitalize; line-height: 1.5;">
<? include 'http://www.fanmail.biz/cse.php'; ?>
</div>
  
 
</td>
</tr>


</table>

  
<table style="width:850px" align="center">
<tr>
<td><br/>
<br />
<b>Fatal error</b>:  Uncaught Error: Call to undefined function paginate_three() in /var/www/vhosts/jp/category.php:566
Stack trace:
#0 {main}
  thrown in <b>/var/www/vhosts/jp/category.php</b> on line <b>566</b><br />