<?php
$bd_host = "mysql1303.hostexcellence.com:3306/";
$bd_usuario = "alvarom_folcast";
$bd_password = "berenjena";
$db_name = "alvarom_folcast";
$db = mysql_connect($bd_host, $bd_usuario, $bd_password);
mysql_select_db($db_name, $db);

//max number of tags
$MAX_NUMBER_OF_TAGS = 45;

	require_once("../folcast.com/freetag/freetag.class.php");

	$freetag_options = array (
		'debug' => FALSE,
		'db_user' => $bd_usuario,
		'db_pass' => $bd_password,
		'db_host' => $bd_host,
		'db_name' => $db_name,
		'table_prefix' => 'opml_'
		);

	$freetag = new freetag($freetag_options);

$micro = "`     `          ````` ..^..:::::;;;???????1111111++++;++??;;;;;::^^.....``` `  ` `  ` `
  ` `      ````````` ..^::::::;;???====llllllltllllll=lll====1++;;::......`````    `  `
   `       `````  .^^:.:;;;????==llzOOOrrwrvvrrrrvrrrrttttttOlz=??+;;;;;:.^...````      `
`          `....^^^:::;;;??1lllttrrzzuuuuuZZZZZZZZZZuuuuzuzvrwttl==???;;;::^....```` `
       ```  ..^^^^::;;?11=zltrrwuuuZXXyXyX0OC7777CCOXXWVVXXZZXwzwOOzz11??;;::^...```````
 ` ` ````...^^^^::;;;?1ltrrrwuuZyyXWWpfWUVv```` `` `+OXWbbpVyyZZXuzrrtl==?;;;::^^^..````
     ```...^^:::;;++=lzrvzXXZyXVffWHHHW0I!` `   ``` `?zXWqkbppfWyZZuuvrtl=???;;:^^^. ````
 `   ```.^^^:::;??=lltwzuZXWpbbbkqH@@HkZ:`` `  `````` +dW@gHHHHbWfWyZuuvrtl==?;;:::^...```
  `````.^^::;;;??lltOvwZyVWbqHggHHMHHMHZ! ```  `````` ?dH#M@H@ggHHbpVyZZuvrtl=??;;::^...```
`` ``..^^::;;??=lzrrwuXVppkHm@@HHHMNMMHk: ```` `````  ?dMMN#HHH@@HmkkpVyZuzvOOl=?;;::....```
````...^::;??==ltrwXXyWpkqmgHMH##NMMMMNk: ` ```   ``` ?dMMMMNN##HH@@mHbWWWuuXwtl=??;+:^^..```
```..^^^::;?=lttrwuyVpbqmg@HM#NNMMMMMMMRl  ````  `` ` ?dMMMMMMMNN#H@@gmqbfyyZuvrOl??;::^^.````
``..^^^.;;+1ltrvuXyVpbHg@MMMNNMMMMMMMMNRl `````` ```` +dMMMMMMMMMNHHH@HHkbWWWZurttl=?;::....```
``..^^::;?==ltruZyfpkqg@HH##NMMMMMMMMMMHI.............+dMMMMMMMMMM##HHMHqqkpVyuvrtl=?;;:^^^.```
`...^^:;;?=ltrzuZVpkqg@HH#NNMMMMMMMMMMMMNmmmmggggggmNNNMMMMMMMMMMMMNNN#MgmqbfyZzvrtl=?;::^^..``
`..^^::;?=ltrvuZVfbqg@@H#NMMMMMMMMH0MMMMMMMMMMMMMMMMMMMMMM8UHMMMMMMMNNNH@@mqbfyXzvrt=?;;:^^^.``
...^^:;;?=ltvuZVfbqg@@H#NMMMMMMMMH0:dMMM9Y777TTTT7777TWMMNr+wWMMMMMMMNNH@@@mkpVZuzrtl??;::^^..`
..^^::;?=ltrzuyfpkm@@H#NMMMMMMMMMN0:dMNHI.````` `````.jWMMI+wMMMMMMMMMNMMH@gqpfyZuvrl=?;;:^^^.`
..^^:;;?=ltvzuyfbqg@HHNMMMMMMMMMMNk:dMMMI````````````.jWMM$1wMMMMMMMMMMMNH@@mbpVZuzrl=?;;::^^..
..^^:;;?=trvuZypbqg@HHNMMMMMMMMMMNS:dMMNI.```````````.zMMMP1wMMMMMMMMMMM#H@@mkpVZuzrl=?;;::^^..
..^^:;;?ltrvzZyfbqg@HH#NMMMMMMMMMMS!dMMN0```  ``` ```.zWMMR=OMMMMMMMMMMMHH@@mkpVZZzvO=??;:^^^..
..^^::;?=ltrzuyfbqm@HH#MMMMMMMMMMM0!dMMM$.``` ``  `` `zWMMb=zWMMMMMMMMMN#H@@gkpVyZurO=??;::^^..
..^^:;;?=ltvzZyfbqg@@HNMMMMMMMMMMNk:dMMN0```.` ```   .jWMM$1wMMMMMMMMMM#HH@@gkpVZZzrt=?;;::^^..
..^^::;?=ltvzZyfpkg@HH#NMMMMMMMMMNR:dMMMR, ````    `.+WMM#cjXMMMMMMMMMM#HH@@mbpVyuzrt=??;::^^..
..^^::;?=ltrzXyVpkHg@HHNMMMMMMMMMMN:+WMMNmx..`... ..jdMMM8:jMMMMMMMMMMMMH@@gqHfyZuzrlz??;::^^..
..^^::;??=trruZyfbqg@@H#NMMMMMMMMMNs+?WMMMNmga&&+jggMMMMD++dMMMMMMMMMMMM@@@mkpyZuurtl??;::^^^..
`..^^::;?=ztrzuXypkqg@HH#NMMMMMMMMMNm++vMMMMMMMMMMMMMMB6++dMMMMMMMMNMNMH@@gkHfyXzvrt=?;;::^^...
`...^^:;;?=ltvuZyVpkHg@HH#NMMMMMMMMMNmmxzvTMMMMMMMMH9I+JdNMMMMMMMMMMNMHHHgqkpyZuvrtl=?;;:^^^..`
`...^^::;??ztrrXZWfbHg@@HH#MMMMMMMMMMMMNma+..``!`..J&QQNMMMMMMMMMMNNMM@@MHkbfyZzrtO=?+;::^^..``
```..^^::;?1zltvuZyfWHH@@HM#NMMMMMMMMMMMMMNHo.. ..dMMMMMMMMMMMMMMMHHH@@gqbpVyZuwtl=??;:::^..```
``...^^^::;??llrvXZyWWHHg@MM#NNMMMMMMMMMMMMMD!```?WMMMMMMMMMMMMN#H@HHMgHHHyXZurOl=??;::^^^..```
```...^^:::;+?=ztvuuXVWbqqgMMMM##NMMMMMMMMMM0.  .JWMMMMMMMMMMMN#H@@@@HHHWyZuXOOz=?;;:^^^^...```
````...^^^::;??1lOrzXZyfpbqqgHMMMHHHHMMMMMM9C`  `?UMMMMMMMMHHHMMMMHqHHVyZuuvOOl??;;:+^^^..````
 `````...^^:+;;+=llrwXXyyVWkqqHW0I?!!!!!!!!!````` `!!!!!!!!??wWHmHHpWWZZXzrtl=??;;::`^...```
```````...^^^:;;??==OOwXZZWWHpWXz``` ````````````` ````````.`+XWbpyyy0wrrttl=??;;::^^...```
    ````...^^^`+;;?==ltrvuuXUWXwz+. ` ..``   ``.```  .``..`..+wXfyZZZwttll=??;;::^^^..```
   ` ````...^^^^:++?+?zOtOrrrXzvOz+??J++JJ+&+++++++++&+J+++?+zwuZXXXwOll1+;;+++``^..`````
` `    ````...^^^::+;;??=llttrrzuuuZZZyyVVffppffpffffffVVyZZuuzvrrttl=1??;:::^^^...``````
    `` `````....^^^^::++?1?=llOtrrrXXXXXZZZXZZZZZZZZZuuuuuuwwwOOOlz=?+;;;:::^^...``````
`  `   ` ````.....^^`^::+;?;???==llttOOwwvvvvvvvvvvvrrrrtttllz=?1+++;;::^^^^....`````
  `    ` ```````.....^^^^:::+++???===1zllltOtttttttllll====1?++;;;:::`^^^.....`````    `";


$microFin = "";
$letras = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";


	$tTags = split(" ",$q);

	$tempA = array();
	foreach($tTags as $value){
		array_push($tempA,"$value");
	}
	$tTags = $tempA;

	$wherevalue = "";

	foreach($tTags as $value){
		$value = strtolower($value);
		$wherevalue .= " and (LOWER(origin) like '%" . $value . "%' or LOWER(url) like '%" . $value . "%' or LOWER(text) like '%" . $value . "%' or LOWER(xmlurl)  like '%" . $value . "%' or LOWER(tags)  like '%" . $value . "%' or LOWER(author)  like '%" . $value . "%' or LOWER(title) like '%" . $value . "%' or LOWER(description) like '%" . $value . "%' or LOWER(link) like '%" . $value . "%') ";
	}


	$sql="SELECT id,text,link,xmlurl,origin,url,tags,author,title,description,image FROM opml where status = 'S' " . $wherevalue . " order by date desc";
//	$sql="SELECT id,text,link FROM opml where status = 'S' order by date desc";

	$res=mysql_query($sql, $db);

	//podcast seleccionados para portada
	$numRows =  mysql_num_rows($res);
	$podUno = rand(1,$numRows);
	$podDos = rand(1,$numRows);
	while($podUno == $podDos){
		$podDos = rand(1,$numRows);
	}
	$podTres = rand(1,$numRows);
	while($podTres == $podUno || $podTres == $podDos){
		$podTres = rand(1,$numRows);
	}

	$podCuatro = rand(1,$numRows);
	while($podCuatro == $podUno || $podCuatro == $podDos || $podCuatro == $podTres){
		$podCuatro = rand(1,$numRows);
	}

	$podCinco = rand(1,$numRows);
	while($podCinco == $podUno || $podCinco == $podDos || $podCinco == $podTres || $podCinco == $podCuatro){
		$podCinco = rand(1,$numRows);
	}

	$podSeis = rand(1,$numRows);
	while($podSeis == $podUno || $podSeis == $podDos || $podSeis == $podTres || $podSeis == $podCuatro || $podSeis == $podCinco){
		$podSeis = rand(1,$numRows);
	}

	$podSiete = rand(1,$numRows);
	while($podSiete == $podUno || $podSiete == $podDos || $podSiete == $podTres || $podSiete == $podCuatro || $podSiete == $podCinco || $podSiete == $podSeis){
		$podSiete = rand(1,$numRows);
	}

	$podIndice = 0;
	$podPortadaTodo = array();
	$podPortadaTitulo = array();

	$lastPodcasts = array();
	$lastInicio = 0;
	$lastCuantos = 10;

	while($linea = mysql_fetch_object ($res)){

		$podIndice = $podIndice + 1;


		$continuar = true;

		while($continuar){


			$indice = rand(1,strlen($micro) - 1);

			$enlace = trim($linea->link);

			if($enlace == null || $enlace == ""){
				$enlace = $linea->xmlurl;
			}

			if(strpos($letras,$micro[$indice]) != FALSE && $micro[$indice-1] != ">"){
				$tit = $linea->id . "@@" .
					strtolower($linea->image) . "@@" .
					strtolower($linea->text) . "@@" .
					strtolower($linea->link) . "@@" .
					strtolower($linea->xmlurl) . "@@" .
					strtolower($linea->origin) . "@@" .
					strtolower($linea->url) . "@@" .
					strtolower($linea->tags) . "@@" .
					strtolower($linea->author) . "@@" .
					strtolower($linea->title) . "@@" .
					strtolower($linea->description) . " ";

				$tit = str_replace("\'","",$tit);
				$tit = str_replace("'","",$tit);
				$tit = str_replace("\"","",$tit);
				$tit = str_replace("Ñ","ñ",$tit);

				$tituloValido = str_replace("\'","",$linea->text);
				$tituloValido = str_replace("'","",$tituloValido);
				$tituloValido = str_replace("\"","",$tituloValido);

				if($podIndice == $podUno || $podIndice == $podDos || $podIndice == $podTres || $podIndice == $podCuatro || $podIndice == $podCinco || $podIndice == $podSeis || $podIndice == $podSiete){
					array_push($podPortadaTodo,$tit);
					array_push($podPortadaTitulo,strtolower($tituloValido));
				}

				$microFin = substr($micro,0,$indice) .
							"<a onmouseover=\"javascript:ver(event,this.name);\" onmouseout=\"javascript:irmicro(event);\" href=\"#\" onclick=\"javascript:detalles(event,this.name);\" class=\"enlace\" title=\"" . strtolower($linea->text) . "\"  id=\"" . strtolower($linea->text) . "\" name=\"" . $tit . "\">" .
							$micro[$indice] . "</a>" .
							substr($micro,$indice + 1);
				$micro = $microFin;


				if($lastInicio < $lastCuantos){
					array_push($lastPodcasts,strtolower($linea->text));
					$lastInicio = $lastInicio + 1;
				}


				$continuar = false;
			}
		}

	}


	mysql_free_result ($res);
?>

<html>
<head>
	<title>micro - directorio de podcasts</title>
	<meta name="title" content="micro - directorio de podcasts">
	<meta name="description" content="micro - directorio de podcasts basado en folcsonomías y ascii art. Podcasts para tus orejas">
	<meta name="keywords" content="podcast, folcsonomía,directorio, ascii, art">
	<link rel='stylesheet' type='text/css' href='styles/styles.css'>
	<script type="text/JavaScript" src="js/functions.js"></script>

<script>
<?php
	$vx = rand(0,9);
	$vy = rand(0,9);
?>
	function displayAddPodcast(){
		var formulario = "<div style=\"text-align:left;width:560px\"><form name=\"frmAddRSS\" method=\"post\" action=\"http://micro.folcast.com/addOpml.php\" style=\"padding:5 0 0 10\">";
		formulario += "<input type=\"Hidden\" name=\"vx\" value=\"<?php echo $vx;?>\">";
		formulario += "<input type=\"Hidden\" name=\"vy\" value=\"<?php echo $vy;?>\">";
		formulario += "<b>feed:</b> <input type=\"text\" name=\"xmlurl\" maxlength=\"255\" size=\"52\"><br />";
		formulario += "<b>etiquetas:</b>	<input type=\"text\" name=\"feedtags\" maxlength=\"500\" size=\"47\"> ";
		formulario += "<font style=\"font-size:11px\">separadas por espacios</font><br />";
		formulario += "<b>¿<?php echo $vx;?> + <?php echo $vy;?>?:</b> ";
		formulario += "<input type=\"text\" name=\"vxvy\" maxlength=\"2\" size=\"49\"> <font style=\"font-size:11px\">filtro anti-spam</font>";
		formulario += " <input class=\"boton\" type=\"Submit\" name=\"send\" value=\"enviar\">";
		formulario += "</form></div>";

		document.getElementById("caja3").innerHTML = formulario;

	}


	var portada = "<div class=\"titulo\" style=\"width:175px;margin: 0 0 2 0;\">AL AZAR</div>";
	<?php
		$ind = 0;

		$indImg = 0;
		$indText = 0;

		foreach($podPortadaTodo as $value){

					$indText = $indText + 1;
	?>
					portada += '<div id="cuadroPortada<?php echo $ind;?>" class="cuadroPortada"><a href="#" onclick="javascript:detalles(event,\'<?php echo nl2br($value);?>\');" title="<?php echo $podPortadaTitulo[$ind];?>" class="portada" onmouseover="javascript:cambiarId(\'cuadroPortada<?php echo $ind;?>\',\'cuadroPortadaOver\')" onmouseout="javascript:cambiarId(\'cuadroPortadaOver\',\'cuadroPortada<?php echo $ind;?>\')">';
					portada += '<?php echo $podPortadaTitulo[$ind];?></a></div>';
	<?php
				$ind = $ind + 1;

		}

	?>
		ultimos = new Array();
	<?php
		$contandoPodcast = 0;
		foreach($lastPodcasts as $value){
	?>
			ultimos[<?php echo $contandoPodcast;?>] = "<?php echo $value;?>";
	<?php
			$contandoPodcast = $contandoPodcast + 1;
		}
	?>
</script>
			<?
			$tags = $freetag->silly_list($MAX_NUMBER_OF_TAGS);

			$index = 0;

			$folcFile = "tags.js";

			$create = false;

			if(!file_exists($fileName)) {
				$create = true;
			} else if(date("Y-m-d",filemtime($folcFile)) < date("Y-m-d",time())) {
				$create = true;
			}


			if($create){
				$filepointer = fopen($folcFile, "w");
				fputs ($filepointer,"var t = new Array();\n");


				foreach( $tags as $key => $value ) {
					$upSize = $value / 5;
					if($upSize > 0.4){

						fputs ($filepointer,"t[" . $index . "] = new Array(2);\n");
						fputs ($filepointer,"t[" . $index . "][0] = '" . $key . "';\n");
						fputs ($filepointer,"t[" . $index . "][1] = " . $upSize . ";\n");

						$index = $index + 1;
					}
				}
				fclose ($filepointer);
			}


				echo "<script src=\"" . $site . $folcFile . "\" type=\"text/javascript\"></script><script>";
				echo "var etiquetas = '';";
				echo "for(i = 0; i < t.length;i++){";
				echo "var tamfuente = (t[i][1] + 11);";
				echo "if(tamfuente > 18){tamfuente = 18;}";
			?>
				etiquetas += "<a class='folcsonomy' href='#' onclick='javascript:buscar(event,\"" + t[i][0] + "\")' id='" + t[i][0] + "' title='" + t[i][0] + "' style='font-size:" + tamfuente + "'>" + t[i][0] + "</a> ";
			<?php
				echo "}</script>";
			?>
</head>
<body>
<div class="arriba">
	<div class="logo">
		<a href="http://micro.folcast.com"><img src="images/micro185.gif" border="0"></a><div id="caja1">
			<form name="frmSearch" method="post" action="http://micro.folcast.com/" style="margin:0 0 0 0;padding:8 0 0 0" class="todas">
				<strong>buscar: </strong>
				<input type="text" name="q" size="15" onchange="searchTag(event,document.frmSearch.q.value);" onkeyup="searchTag(event,document.frmSearch.q.value);"><br />
				<span><a href="http://micro.folcast.com/todos.php" target="_blank" class="todas">todas las fuentes en un micro</a></span>
			</form>
		</div>
	</div>
	<div class="arribaDcha">
		<div id="caja3">
			<?php
				if($_POST['insertMessage'] != null && $_POST['insertMessage'] != ""){
					echo "<br /><strong>" . $_POST['insertMessage'] . "</strong>";
				} else{
			?>
				<script>
					document.write(etiquetas);
				</script>
			<?php
				}
			?>
		</div>
		<div id="caja2">
			<div id="menu1"><a href="#" onclick="javascript:displayTags();" onmouseover="javascript:cambiarId('menu1','menu1p')" onmouseout="javascript:cambiarId('menu1p','menu1')" class="menu">etiquetas</a></div>
			<div class="vertical-separator">&nbsp;</div>
			<div id="menu2"><a href="#" onclick="javascript:displayAddPodcast();" onmouseover="javascript:cambiarId('menu2','menu2p')" onmouseout="javascript:cambiarId('menu2p','menu2')" class="menu">añadir podcast</a></div>
			<div class="vertical-separator">&nbsp;</div>
			<div id="menu3"><a href="#" onclick="javascript:lastPodcast(event,ultimos);" onmouseover="javascript:cambiarId('menu3','menu3p')" onmouseout="javascript:cambiarId('menu3p','menu3')" class="menu">últimos</a></div>
			<div class="vertical-separator">&nbsp;</div>
			<div id="menu4"><a href="#" onclick="javascript:displayInfo();" onmouseover="javascript:cambiarId('menu4','menu4p')" onmouseout="javascript:cambiarId('menu4p','menu4')" class="menu">¿micro?</a></div>
<!--
			<div class="vertical-separator">&nbsp;</div>
			<div id="cajaMenu">&nbsp;</div>
-->
		</div>
	</div>

</div>

<div class="main">
<div id="izda">
	<div id="descripcion">
		<script>document.write(portada);</script>
	</div>
</div>
<div id="microfono" class="microfono"><pre class="texto"><?php echo $micro;?></pre></div>
</div>

<div>
	<a href="http://www.listometro.net">Trivial</a> |
	<a href="http://www.nombresconsignificado.net">Nombres significado</a>
</div>

<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-223426-2";
urchinTracker();
</script>
</body>
</html>
<?mysql_close($db);?>