All pastes #409535 Raw Edit

Unnamed

public text v1 · immutable
#409535 ·published 2007-03-25 19:39 UTC
rendered paste body
<?php
$xml = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">';
echo $xml;
?>
<html lang="fr">
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
<meta http-equiv="content-language" content="fr">
<meta name="robots" content="index,follow">
<meta name="keywords" content="psp, iso, listing, full, playstation portable, playstation, sony, jeu">
<meta name="description" content="Sanaell ISO Listing PSP">
<meta name="author" content="Sanaell">
<meta name="copyright" content="Copyright © 2001-2008">
<SCRIPT LANGUAGE="JavaScript" type="text/javascript" SRC="BoxOver.js"></SCRIPT>
<style type="text/css">
.row2{ 
	background: #EAEAFF;
}
.row3{
	background: #DADAFF;
}
.rowon{ 
	background: #EFDEDE;
}
a, span.email {
	background-color: transparent;
	text-decoration: none;
	font-weight: bold; 
	color: #453434;
	font-family: Verdana, Arial, Geneva, sans-serif;
	font-size: 8pt;
}
.LoadingBox {
	font-size:1.5em;
	font-family: Tahoma, Sans-Serif;
	border: 1px solid #c3d6ee;
	padding: 3em;
}
.LoadingBox IMG {
		vertical-align:middle;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
function loadImages() {
if (document.getElementById) {  // DOM3 = IE5, NS6
document.getElementById('hidepage').style.visibility = 'hidden';
}
else {
if (document.layers) {  // Netscape 4
document.hidepage.visibility = 'hidden';
}
else {  // IE 4
document.all.hidepage.style.visibility = 'hidden';
      }
   }
if (document.getElementsByTagName) {
	var spans = document.getElementsByTagName('span')
	for (var i = 0; i < spans.length; ++i) {
		if (spans[i].className == 'email') {
			var c = spans[i].firstChild.nodeValue.split('()').join('@');
			var anchorText = document.createTextNode(c);
			var anchor = document.createElement('a');
			anchor.href = 'mailto:' + c;
			anchor.appendChild(anchorText);
			spans[i].replaceChild(anchor, spans[i].firstChild);
		}
	}
}   
}

</script>
<script type="text/javascript" src="tabber.js"></script>
</head>
<body bgcolor ="#F5F9FD" OnLoad="loadImages()">
<div id="hidepage" style="position: absolute; left:5px; top:5px; background-color: #F5F9FD; layer-background-color: #F5F9FD; height: 100%; width: 100%;"> 
<table width=100% ><tr><td>
        <div class="LoadingBox">
            <img alt="" src="http://gfx2.mail.live.com/mail/11.00/beta/i_animated_loading_32_2.gif" />
            Chargement en cours...
        </div>
</td></tr></table></div> 
<?
if (isset($HTTP_GET_VARS)){while(list($name, $value) = each($HTTP_GET_VARS)){$$name = $value;}}
if (!isset($x)) $x = 'all';
if (!isset($s)) $s = '0';
if (!isset($alpha)) $alpha ='';
if (!isset($beta)) $beta ='';
if (!isset($covers)) $covers ='';
if ($alpha) { $beta = ''; }
if ($beta) { $alpha = ''; }

$str_idcode = array (	"CPCS"	=> "JAPON",
						"TCPS"	=> "JAPON",
						"UCJB"	=> "SAMPLER DISCS",
						"UCJM"	=> "DEMOS JAPON",
						"UCKM"	=> "DEMOS COREE",
						"UCAS"	=> "ASIE",
						"UCED"	=> "DEMOS EUROPE",
						"UCES"	=> "EUROPE",
						"UCET"	=> "BETAS EUROPE",
						"UCJS"	=> "JAPON",
						"UCKS"	=> "COREE",
						"UCUS"	=> "USA",
						"ULAS"	=> "ASIE",
						"ULES"	=> "EUROPE",
						"ULJM"	=> "JAPON",
						"ULJS"	=> "JAPON",
						"ULKS"	=> "COREE",
						"ULUS"	=> "USA",
						"ULUX"	=> "BETAS USA");
require ('_cnx.php');
$link = mysql_connect ($host,$user,$pass) or die ('Erreur : '.mysql_error() );
mysql_select_db($bdd) or die ('Erreur :'.mysql_error());
$c1 = "#323296";
$c2 = "#EAEAFF";
$c3 = "#DADAFF";
$c4 = "#EFDEDE";
// requête SQL qui compte le nombre total d'enregistrements dans la table et qui
//récupère tous les enregistrements
if ($x == "all") { $select = "SELECT titre,region,langue,editeur,genre,firmware,idcode,taille,umdver,save,rating FROM listing_iso ORDER BY idcode ASC"; }
else { $select = "SELECT titre,region,langue,editeur,firmware,idcode,genre,taille,umdver,save,rating FROM listing_iso where region=\"$x\" ORDER BY idcode ASC"; }
$result = mysql_query($select,$link) or die ('Erreur : '.mysql_error() );
$total = mysql_num_rows($result);
$a = 1;
$idumd2 = $html = '';
$nb_images = $nb_reg = $nb_reg_img = 0;
// si on a récupéré un résultat on l'affiche.
if($total) {
  // début du tableau
	while($row = mysql_fetch_array($result)) {
				$pathx = '/mnt/115/free.fr/2/9/sanaell2002/psp-tutos/img/';
				$pathr ='http://sanaell2002.free.fr/psp-tutos/img/';
				$pathroot = 'http://sanaell2002.free.fr/flags/';
				$pathrate = 'http://sanaell2002.free.fr/rate/';
				$langues = explode("/",$row['langue']);
				$ratings = explode("/",$row['rating']);
				$langue = $rate = $tiny_rate = $file = '';
				$file = $row['idcode'].".jpg";
				if ($row['rating']) { 
				$x = 0;
					While ($ratings[$x]) {
						$rate .= '<img src='.$pathrate.strtolower($ratings[$x]).'.gif alt='.$ratings[$x].'>';
						$tiny_rate .= '<img height=32 width=32 src='.$pathrate.strtolower($ratings[$x]).'.gif>';
						$x++;
					}
				}
				else { $rate = $tiny_rate = 'N/A'; }
				$x = 0;
				While ($langues[$x]) {
					$langue .= '<img style=\'vertical-align:middle\' src=\''.$pathroot.$langues[$x].'.png\' alt=\''.$langues[$x].'\' width=\'18\' height=\'12\'>';
					$x++;
					$langue .= (($x % 6)?"&nbsp;":"<br>");
				}
				if ($alpha) {
					if ($alpha == $row['idcode']) {
						if (!file_exists($pathx.$file)) { 
							$image = '<img src=\''.$pathr.'nocover.jpg\' alt=\'nocover.jpg\' width=\'100\' height=\'172\'>';
						}	
						else { 
							$image = '<img src=\''.$pathr.$file.'\' alt=\''.$row['idcode'].'\' width=\'100\' height=\'172\'>';
						}
						$html .= '<table cellspacing="0" style="background-color: #EEEEEE; border: 1px #999999 solid; border-collapse: collapse;" width="100%">';
						$html .= '<tr>';
						$html .= '<td align="center" style="background-color: #D7D7D7"><font face="Verdana" size="1"><b>Cover</b></font></td>';
						$html .= '<td  colspan="1" style="background-color: #D7D7D7"><font face="Verdana" size="1"><b>Informations</b></font></td>';
						$html .= '<td align="center" width=128 style="background-color: #D7D7D7"><font face="Verdana" size="1"><b>Rating</b></font></td></tr>';
						$html .= '<tr>';
						$html .= '<td style="background-color: #EEEEEE; border: 1px #999999 solid;" width="100">'.$image.'</td>';
						$html .= '<td style="background-color: #EEEEEE; border: 1px #999999 solid; border-collapse: collapse;">';
						$html .= '<table cellspacing="0" width="100%">';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Titre</b>:</td><td valign=bottom align="left">'.$row['titre'].'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Editeur</b>:</td><td valign=bottom align="left">'.(($row['editeur'])?ucwords(strtolower($row['editeur'])):'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Genre</b>:</td><td valign=bottom align="left">'.(($row['genre'])?ucwords(strtolower($row['genre'])):'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Region</b>:</td><td valign=bottom align="left"><img src='.$pathroot.strtolower($row['region']).'.png></td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Langue(s)</b>:</td><td valign=bottom align="left">'.(($langue)?$langue:'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Taille ISO</b>:</td><td valign=bottom align="left">'.(($row['taille'])?number_format( $row['taille'], 0, '', ' ').'MB':'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>IDCode</b>:</td><td valign=bottom align="left">'.$row['idcode'].'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Version PSP</b>:</td><td valign=bottom align="left">'.(($row['firmware'])?$row['firmware']:'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Taille Sauvegarde</b>:</td><td valign=bottom align="left">'.(($row['save'])?number_format( $row['save'], 0, '', ' ').'KB':'N/A').'</td></tr>';
						$html .= '<tr><td valign=bottom align="right" width="140"><b>Version UMD</b>:</td><td valign=bottom align="left">'.(($row['umdver'])?$row['umdver']:'N/A').'</td></tr>';
						$html .= '</table></td>';
						$html .= '<td style="background-color: #EEEEEE; border: 1px #999999 solid;" width="128">'.$rate.'</td>';
						$html .= '</tr></table>';
					}
				}
				else if ($beta) {
						$bulle = 0;	
						if (!file_exists($pathx.$file)) { 
							$image = '<img src=\''.$pathr.'nocover.jpg\' alt=\'nocover.jpg\' width=\'100\' height=\'172\'>'; 
						}	
						else { 
							$image = '<img src=\''.$pathr.$file.'\' alt=\''.$row['idcode'].'\' width=\'100\' height=\'172\'>';
							$nb_images ++;
							$nb_reg_img ++;
							$bulle = 1;			
						}
						if (!$bulle) {
							$html .= $row['idcode']."&nbsp;".$row['titre'].'<br>';
						}
				}
				else if ($covers == "cso") {
						$bulle = 0;	
						if (!file_exists($pathx.$file)) { 
							$image = '<img src=\''.$pathr.'nocover.jpg\' alt=\'nocover.jpg\' width=\'100\' height=\'172\'>'; 
						}	
						else { 
							$image = '<img src=\''.$pathr.$file.'\' alt=\''.$row['idcode'].'\' width=\'100\' height=\'172\'>';
							$nb_images ++;
							$bulle = 1;			
						}
						if ($bulle) {
							$html .= $row['idcode']."&nbsp;".$row['titre'].'<br>';
							
						}
				}
				else {
				$idumd1 = explode("-",$row['idcode']);
				$nb_reg_tot = $nb_reg - $nb_reg_img;
				if ($idumd2 != $idumd1[0]) { 
					$a = 1 ;
					if ($nb_reg != 0 ) {
						$html .= '<td width="10%" bgcolor='.$c1.'><b><font color="white"></b></td>';
						$html .= '<td align=right width="50%" bgcolor='.$c1.'><b><font color="white">'.(($nb_reg > 1)?$nb_reg." jeux":$nb_reg." jeu").' / '.$nb_reg_img.(($nb_reg_img > 1)?" images":" image").'</b></td>';
						$html .= "</table></div><br><p>\n";
					}
					$nb_reg = $nb_reg_img = 0;
				}
				$nb_reg ++;
				if ($a == 1) {
				    $html .= '<div class="tabbertab" title="'.$str_idcode[$idumd1[0]].'">';
					$html .= '<table width="60%" bgcolor="#FFFFFF">'."\n";
					$html .= '<tr>';
					$html .= '<td width="10%" bgcolor='.$c1.'><b><font color="white">'.$str_idcode[$idumd1[0]].'</b></td>';
					$html .= '<td width="50%" bgcolor='.$c1.'><b><font color="white">Titres & Infos</b></td>';        
					$html .= '</tr>'."\n";
				}
				$bulle = 0;	
				if (!file_exists($pathx.$file)) { 
					$image = '<img src=\''.$pathr.'nocover.jpg\' alt=\'nocover.jpg\' width=\'100\' height=\'172\'>'; 
				}	
				else { 
					$image = '<img src=\''.$pathr.$file.'\' alt=\''.$row['idcode'].'\' width=\'100\' height=\'172\'>';
					$nb_images ++;
					$nb_reg_img ++;
					$bulle = 1;			
				}
				$html .= '<tr>';
				$html .= '<td bgcolor='.(($a % 2)?$c2:$c3).'>'.$row['idcode'].'</span></td>';
				$html .= '<td class='.(($a % 2)?"row2":"row3").' onmouseover="this.className = \'rowon\'" onmouseout="this.className = \''.(($a % 2)?"row2":"row3").'\'"';
				$html .= 'title="header=[<center></center>] body=[';
				$html .= '<Table height=190 bgcolor='.$c4.'><tr>';
				$html .= '<td valign=top bgcolor='.$c4.' width=100>'.$image.'</td>';
				$html .= '<td valign=top bgcolor='.$c4.' width=100%>';
				$html .= '<table width=250 bgcolor='.$c4.'>';
				$html .= '<tr><td valign=top height=32><font size=1><b>Region</b>:</td><td><div align=right><font size=1><img src='.$pathroot.strtolower($row['region']).'.png></td></tr>';
				$html .= '<tr><td valign=top height=32><font size=1><b>Genre</b></td><td><div align=right><font size=1>'.(($row['genre'])?ucwords(strtolower($row['genre'])):'N/A').'</div></td></tr>';
				$html .= '<tr><td valign=top height=48><font size=1><b>Langues</b></td><td><div align=right><font size=1>'.(($langue)?$langue:'N/A').'</div></td></tr>';
				$html .= '<tr><td valign=top height=32><font size=1><b>Rating</b></td><td><div align=right><font size=1>'.$tiny_rate.'</div></td></tr>';
				$html .= '<tr><td valign=top><font size=1><b>Firmware</b></td><td><div align=right><font size=1>'.(($row['firmware'])?$row['firmware']:'N/A').'</div></td></tr>';
				$html .= '<tr><td valign=top><font size=1><b>Editeur</b></td><td><div align=right><font size=1>'.(($row['editeur'])?ucwords(strtolower($row['editeur'])):'N/A').'</div></td></tr>';
				//$html .= '<tr><td valign=top><font size=1><b>Version UMD</b></td><td><div align=right><font size=1>'.(($row['umdver'])?$row['umdver']:'N/A').'</td></tr>';
				$html .= '<tr><td valign=top><font size=1><b>Taille Save</b></td><td><div align=right><font size=1>'.(($row['save'])?number_format( $row['save'], 0, '', ' ').'Ko':'N/A').'</td></tr>';
				//$html .= '<tr><td valign=top><font size=1><b>Taille ISO</b></td><td><div align=right><font size=1>'.(($row['taille'])?number_format( $row['taille'], 0, '', ' ').'Mo':'N/A').'</td></tr>';
				$html .= '</table>';
				$html .= '</td>';
				$html .= '</tr></table>';
				$html .= ']">'.'<a href="http://sanaell2002.free.fr/listing.php?s=1&alpha='.$row['idcode'].'">'.(($bulle == 1)?'<font color=darkpink><b>':'').$row['titre'].'</font></a></b></td>';
				$html .= '</tr>'."\n";
				$a++;
				$y++;
				$idumd2 = $idumd1[0];
				}
			}
	if (!$alpha) { }
}
else $html .= 'Pas d\'enregistrements dans cette table...';

//on construit tout le code HTML
  if (!$alpha) {
	echo '<font color="black"><i>Il y a '.$total.' jeux avec '.$nb_images.' images<br>Contact: <a><span class="email">sanaell2002()free.fr</span></a><br>';
	echo $html;
		$html = '<td width="10%" bgcolor='.$c1.'><b><font color="white"></b></td>';
		$html .= '<td align=right width="50%" bgcolor='.$c1.'><b><font color="white">'.(($nb_reg > 1)?$nb_reg." jeux":$nb_reg." jeu").' / '.$nb_reg_img.(($nb_reg_img > 1)?" images":" image").'</b></td>';
		$html .= '</table>'."\n";
echo $html;
	}
  else {
    echo '<div class="tabber">';
	echo $html;
	echo '</div>';
	echo '<font color="black"><i>Contact: <a><span class="email">sanaell2002()free.fr</span></a>'.(($s == 1)?'<a href="javascript:history.go(-1)"><br>Retour</a>':'');
  }
  // on libère le résultat
mysql_free_result($result);

?>
</body>
</html>