\r\n";
echo " | \r\n";
$htmlcounter=0;
if ($searchstring && $searchstring!="") // perform search only if a string was entered.
{
$connid = mysql_connect ('localhost' , 'rastrono' , 'sinhosejar');
mysql_select_db ("rastrono_numbers");
$query = "aname = '$searchstring' AND fullname REGEXP '\/[0-9]*)'";
$query = "SELECT firstname, lastname, aname, fullname, htmlpage FROM cardtable WHERE ".$query;
$result = mysql_query("$query") or die(mysql_error());
echo "Astroland's Numbered Cards for ".str_replace("Ñ","ñ",rtrim(ltrim($titlename)))." | | ";
while ($row = mysql_fetch_assoc($result)) {
$htmlpage = $row['htmlpage'];
$fullname = rtrim($row['fullname']);
$fullname = str_replace("\\","",$fullname);
$fullname = str_replace(" ^","",$fullname);
$fullname = preg_replace ("/\[[^\].]*\]/","",$fullname);
$aname = $row['aname'];
$i++;
$result2 = mysql_query("SELECT numbercards, aname, firstname, lastname FROM Numbertable WHERE aname = '$aname' ") or die(mysql_error());
$row2 = mysql_fetch_assoc($result2);
$firstname=$row2['firstname'];
$lastname=$row2['lastname'];
$firstletter = array();
$firstnamearray = array();
$firstname =strtolower($firstname);
if (strpos($firstname,"/") != false)
{$slashpos=strpos($firstname,"/")+1;
$slashflag=1;}
else {$slashflag=0;}
$firstnamearray = preg_split("/[\s\/]/ ",$firstname);
$firstname="";
for ($n=0;$n";
if ($i < 10) {echo " ";} elseif ($i<100) {echo " ";}
if ($i%2 ==1) {$backgroundstyle="style=\"background-color:beige\" ";} else {$backgroundstyle="";}
echo $i.". | ";
if ($htmlpage !="") {
$image = str_replace("html","jpg",$htmlpage);
if (file_exists($image)) {$fh = fopen($image, 'r');
list($width, $height) = getimagesize($image);
$htmlpage = str_replace("\\","",$htmlpage);
if ($width > 499 || $height > 499) {$pageopener="zoomBoxScroll";} else {$pageopener="zoomBox";}
if ($pageopener=="zoomBoxScroll") {
$htmlpagewindowwidth=$width+200;
$htmlpagewindowheight=$height+45;} else {
$htmlpagewindowwidth=$width+100;
$htmlpagewindowheight=$height+195;}
if ($width== 131 || $width == 130 || $width == 132) {$htmlpagewindowwidth=260;}
if ($width== 135 || $width == 136 || $width == 134) {$htmlpagewindowwidth=200;}
if ($height== 150 || $height == 149 || $height == 151) {$htmlpagewindowheight=385;}
if ($height== 210 || $height == 211 || $height == 209) {$htmlpagewindowheight=390;}
if ($width== 205 || $width == 204 || $width == 206) {$htmlpagewindowwidth=335;}
if ($width== 250 || $width == 249 || $width == 251 || $width == 252) {$htmlpagewindowwidth=380;}
if ($height== 312 || $width == 313 || $width == 311) {$htmlpagewindowwidth=500;}
if ($height > 348 && $height < 355) {$htmlpagewindowheight=545;}
if (($width== 350 || $width == 349 || $width == 351 ) && $pageopener != "zoomBoxScroll")
{$htmlpagewindowwidth=450;}
if ($height== 250 || $height == 249 || $height == 251) {$htmlpagewindowheight=475;}
if ($width== 148 && $height == 272) {$htmlpagewindowwidth=300;
$htmlpagewindowheight=470;}
if ($width== 253 && $height == 313) {$htmlpagewindowwidth=400;
$htmlpagewindowheight=470;}
if ($width > 499 || $height > 499) {$pageopener="zoomBoxScroll";} else {$pageopener="zoomBox";}
fclose($fh);}
if ($width == 0) {$htmlpagewindowwidth=380;
$pageopener="zoomBox";}
if ($height== 0) {$htmlpagewindowheight=545;}
}
$nbspvar =" ";
if (strlen($fullname) > 80) { $offset = 0; // initial offset is 0
$spaceCounter = 0;
// Check the rest of the string for spaces
while($offset = strpos($fullname," ",$offset + 1)){
if ($offset > 40 && $offset < 64 && strpos($fullname,"#")!=$offset - 1)
{$breakpoint = $offset;}
}
if ($row['htmlpage'] != "") {
$twolinehrefmarker="Y";
$fullname=substr_replace($fullname," ".$nbspvar.$nbspvar.$nbspvar,$breakpoint,0);} else {
$twolinehrefmarker="N";
$fullname=substr_replace($fullname," ".$nbspvar.$nbspvar.$nbspvar,$breakpoint,0);}}
if (strpos($fullname,"(") != false) {
$parenthesecheckers = substr($fullname,strpos($fullname,"(")+1,1);
if ($parenthesecheckers !="" && preg_match("/[p123456789]/",$parenthesecheckers)) {
$suffix = substr($fullname,strpos($fullname,"("));
$fullname = substr($fullname,0,strpos($fullname,"("));}
else {$suffix="";} }
else {$suffix="";}
$firstname=str_replace("/ ","/",$firstname);
if (strpos($lastname,"Mc")==1 ) {
$mcpos=strpos($lastname,"Mc");
$lettertoupper = substr($lastname,$mcpos+2,1);
$lastname = substr_replace($lastname,strtoupper($lettertoupper),$mcpos+2,1);}
if (strpos($lastname,"(")==1 ) {
$parenthpos=strpos($lastname,"(");
$lettertoupper = substr($lastname,$parenthpos+1,1);
$lastname = substr_replace($lastname,strtoupper($lettertoupper),$parenthpos+1,1);}
if (strpos($lastname,"'")==2 ) {$apospos=strpos($lastname,"'");
$lettertoupper = substr($lastname,$apospos+1,1);
$lastname = substr_replace($lastname,strtoupper($lettertoupper),$apospos+1,1);}
$lastname = str_replace("?n","án;",$lastname);
$lastname = str_replace("?","ñ",$lastname);
$lastname = str_replace("Ño","ño",$lastname);
$lastname = str_replace("Non-astros","Non-Astros",$lastname);
if (substr($fullname,0,9) !="1977 TCMA" && substr($fullname,0,9) !="1978 TCMA") {
if (substr($fullname,5,6) !="Choice") {
$fullname = preg_replace("/# 0(?=[1-9])/", "# ", $fullname);} else
{
$fullname = preg_replace("/# 000(?=[1-9])/", "# 0", $fullname);
$fullname = preg_replace("/# 00(?=[1-9])/", "# ", $fullname);
}
$fullname = preg_replace("/# 000(?=[1-9])/", "# ", $fullname);
$fullname = preg_replace("/# 00(?=[1-9])/", "# ", $fullname);
}
$fullname = preg_replace("/ - 000(?=[1-9])/", "- ", $fullname);
$fullname = preg_replace("/ - 00(?=[1-9])/", "- ", $fullname);
$fullname = preg_replace("/ - 0(?=[1-9])/", "- ", $fullname);
$fullname = preg_replace("/P000(?=[1-9])/", "P", $fullname); $fullname = preg_replace("/P00(?=[1-9])/", "P", $fullname);
$fullname = preg_replace("/P0(?=[1-9])/", "P", $fullname);
$fullname = preg_replace("/C000(?=[1-9])/", "C", $fullname); $fullname = preg_replace("/C00(?=[1-9])/", "C", $fullname);
$fullname = preg_replace("/C0(?=[1-9])/", "C", $fullname);
$fullname = preg_replace("/UH000(?=[1-9])/", "UH", $fullname); $fullname = preg_replace("/UH00(?=[1-9])/", "UH", $fullname);
$fullname = preg_replace("/UH0(?=[1-9])/", "UH", $fullname);
$fullname = preg_replace("/US-000(?=[1-9])/", "US-", $fullname); $fullname = preg_replace("/US-00(?=[1-9])/", "US-", $fullname);
$fullname = preg_replace("/US-0(?=[1-9])/", "US-", $fullname);
$fullname = preg_replace("/T000(?=[1-9])/", "T", $fullname); $fullname = preg_replace("/T00(?=[1-9])/", "T", $fullname);
$fullname = preg_replace("/T0(?=[1-9])/", "T", $fullname);
$fullname = preg_replace("/10000/", "10,000", $fullname);
$fullname = preg_replace("/Topps Chrome Red Xfractor/", "Topps Chrome (Red) Xfractor", $fullname);
$fullname = preg_replace("/Topps Chrome Update Red Xfractor/", "Topps Chrome Update (Red) Xfractor", $fullname);
$fullname = preg_replace("/2004 Topps Chrome White Refractor/", "2004 Topps Chrome (White) Refractor", $fullname); $fullname = preg_replace("/2005 Topps Chrome White Refractor/", "2005 Topps Chrome (White) Refractor", $fullname);
if (strpos($fullname,"First 2,000 Printed") != false)
{$fullname = str_replace("First 2,000 Printed","",$fullname);
$first2000flag=1;}
if (strpos($fullname,"one of 2000") != false)
{$fullname = str_replace("one of 2000","",$fullname);
$oneof2000flag=1;}
if (strpos($fullname,"one of 500") != false)
{$fullname = str_replace("one of 500","",$fullname);
$oneof500flag=1;}
if (strpos($fullname,"Rated Rookie") != false)
{$fullname = str_replace("Rated Rookie","",$fullname);
$ratedrookieflag=1;}
if ($htmlpage !="") {$htmlcounter++;
$hrefstring="";} else {$hrefstring="";}
echo $hrefstring;
if ($twolinehrefmarker=="Y") {
$hrefplusspaces=$nbspvar.$nbspvar.$nbspvar.$hrefstring;
$fullname = str_replace($nbspvar.$nbspvar.$nbspvar,$hrefplusspaces,$fullname);
echo $fullname."";}
else {echo $fullname."";}
if ($first2000flag==1) {echo "1st 2,000 Printed"; $first2000flag=0;}
if ($oneof2000flag==1) {echo "one of 2000"; $oneof2000flag=0;}
if ($oneof500flag==1) {echo "one of 500"; $oneof500flag=0;}
if ($ratedrookieflag==1) {echo "Rated Rookie"; $ratedrookieflag=0;}
echo $suffix." | \r\n"; }
if ($i=="") {$i=0;
echo "Sorry, but feel free to try again! | "; }} else {
$i=0;
echo "Please enter a search.";} if ($i ==1) {$cardtense="Card";} else {$cardtense = "Cards";}
echo " |
| ".$i." Different ".$cardtense;
if ($i>0) {echo " And ".$htmlcounter." with ";
if ($htmlcounter==1) {echo "a link";} else {echo "links";}
if ($htmlcounter==1) {echo " to a scan";} else {echo " to scans";}}
echo " | ";
if ($searchstring) {mysql_close ($connid);}
echo "
";
|
|