All pastes #472756 Raw Edit

webtheatre - wixyvir

public php v1 · immutable
·published 2007-05-05 20:01 UTC
rendered paste body
	  while ($d = mysql_fetch_assoc($q)){$sql = "SELECT * FROM video WHERE enc = '1' AND id='".$d['videoid']."' LIMIT ".$debut.",".$fin;$query = mysql_query($sql) or die("Erreur w1.1.1 (<a href=\"http://kb.wtheatre.net/doku.php?id=erreur_1.1.1\"> ?</a>");	  $num = mysql_num_rows($query);	  if ($num ==0) print "<center>Aucune video.</center>";	  $id = 0;	  while($data = mysql_fetch_assoc($query)) {	  $id++;	  $s2 = "SELECT * FROM stats WHERE videoid='".$data['id']."'";	  $q2 = mysql_query($s2);	  while ($d2 = mysql_fetch_assoc($q2)){	  $vues = $d2['stats'];	  }	 	  	  if ($vues == '') $vues = '0';	  print '<div id="calque'.$id.'" style="width:120; height:110; overflow:hidden; border:solid 0px black; float:left;margin-left: 10px;"><a href="play.php?id='.$data['id'].'" style="border:solid 0px black;"><img src="img/'.$data['id'].'.jpg" onMouseOver="affiche(\'calque'.$id.'\',\'infos'.$id.'\')" width="70" onMouseOut="hidden(\'calque'.$id.'\',\'infos'.$id.'\')" style="border:solid 0px black;" title="'.htmlspecialchars($data['titre']).' : '.htmlspecialchars($data['descr']).'"></a><form name="formu" method="POST" action="delfavoris.php" Target="favoris"><input type="hidden" name="id" value="'.$data['id'].'"><input type="image" src="supprimer.png" OnClick="pop_it(formu);"></form></a><div>'.htmlspecialchars($data['titre']).', vue '.$vues.' fois.</div> <div id="infos'.$id.'" style="visibility:hidden;">'.htmlspecialchars($data['descr']).'</div></div>';	  if (($id == 5) || ($id == 10) || ($id == 15) ) print "<br>";	  }	  }