\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 = "High = '$searchstring' AND trim(fullname) != '^' ORDER by fullname";
$query = "SELECT High, firstname, lastname, aname, fullname, htmlpage FROM cardtable WHERE ".$query;
$result = mysql_query("$query") or die(mysql_error());
echo "Astroland's Cards Worth ".$titlename." Beckett High | | ";
while ($row = mysql_fetch_assoc($result)) {
$htmlpage = $row['htmlpage'];
$fullname = rtrim($row['fullname']);
$low = $row['High'];
$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' AND trim(aname) != ''") or die(mysql_error());
$row2 = mysql_fetch_assoc($result2);
$firstname=$row2['firstname'];
$lastname=$row2['lastname'];
$aname=$row2['aname'];
$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;}
}
$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("/US000(?=[1-9])/", "UH", $fullname);
$fullname = preg_replace("/US00(?=[1-9])/", "UH", $fullname);
$fullname = preg_replace("/US0(?=[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 (strpos($firstname,"ulti") != 0) {$firstname="";}
if (strpos($firstname,"ple And Q") != 0) {$firstname="";}
if ($firstname == "Team Photo") {$firstname="";}
if (strpos($firstname,"Dual/Triple") != 0) {$firstname="";}
//if ($firstname == "Rookie Dual/Triple Player") {$firstname="";}
if ($firstname == "Team Leader") {$firstname="";}
if ($firstname == "Coaches") {$firstname="";}
if ($firstname == "Major League Logo") {$firstname="";}
echo $fullname." ".$firstname." ".$lastname."\r\n";
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 "You can reference links to the info on this page by going to the Beckett High Breakdown here";
$crappedout="Y";
}
if ($i ==1) {$cardtense="Card";} else {$cardtense = "Cards";}
if ($crappedout !="Y") {echo " |
| ".$i." Different ".$cardtense;
$worth = $i*$queryvariable;
if ($worth==0) {echo " Worth, according to Beckett, alas, zero.";} else {
echo " Worth $".number_format($worth,2);}}
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 "
";
|
|