<?php
$db = mysql_connect("localhost","abuguet","CambiamE!!");
mysql_select_db("abuguet");
mysql_set_charset('utf8',$db); 
?>
<!DOCTYPE html>
<html>
<head>
	<title>Generador de Episodios de la Rosa de Guadalupe</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<style type="text/css">
		*{margin: 0; padding: 0;}
		body{
			background-image: url(bluebg.png);
			font-size: .625em;
			font-family: "Trebuchet MS", sans-serif;
		}
		#wrapper{
			width:460px;
			margin: 0 auto;
		}
		#header{
			display: block;
			background-image: url(proximoepisodio.png);
			height: 147px;
		}
		
		#header span{ display: none; }
		
		#episodio{
			border-radius: 5px;
			border: 1px solid #757d83;
			box-shadow: 0 2px 0 #bdd7e6;
			font-size: 1.8em;
			color: #000;
			background-image: url(whitebg.png);
		}
		
		#episodio p{
			margin: 10px;
		}
		
		#refresh{
			font-size: 1.4em;
			color: #6a8294;
			text-shadow: 0 1px 0 #c0d7e5;
			text-align: center;
			margin-top: 10px;
		}
	</style>
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-20018878-2']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
</head>
<body>
	<div id="wrapper">
		<a href="/" id="header"><span>En el proximo episodio de la rosa de guadalupe</span></a>
		<div id="episodio"><p>
		<?php
			$nombre = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'nombre' order by rand() limit 1"))or die(mysql_error());
			$causa = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'causa' order by rand() limit 1"));
			$tema = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'tema' order by rand() limit 1"));
			$efecto = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'efecto' order by rand() limit 1"));
			$familiar = mysql_fetch_row(mysql_query("SELECT * FROM `rosa_de_guadalupe` WHERE `tipo` = 'familiar' order by rand() limit 1"));
			printf("<strong>%s</strong> Hizo <strong>%s</strong> porque su <strong>%s</strong> <strong>%s</strong>. La tratan de matar, se da cuenta que <strong>%s</strong> es <strong>%s</strong>, y la virgencita le ayuda a sobresalir.", $nombre[1], $tema[1], $familiar[1], $causa[1], $tema[1], $efecto[1]);
		?>			
		</p></div>
		<div id="refresh">Refresca para más</a>
	</div>
</body>
</html>