Viewing file:  indexb.php (7.21 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<head>
<BASE TARGET='ventana'>
</head>
<?
$conn=mysql_connect("localhost","placasci_pba","pba");
mysql_select_db("placasci_papyre",$conn);
//make class file require
require('xpMenu.class.php');
//construct the class
$xpmenu = new xpMenu();
//add category and options on menu
//use the format:
//addMenu("short_name")
//addCategory("short_name", "name", "image", "menu")
//addOption("short_name", "name", "image", "link", "category", "menu")
//remember: short_name can be anything without spaces or specials chars
$querytotal=" SELECT count( * ) as total FROM placasci_papyre.libros WHERE 1 ";
$restotal=mysql_query($querytotal,$conn);
$rowtotal=mysql_fetch_array($restotal);
$counter=0;
$xpmenu->addMenu("menu".$counter;
$xpmenu->addCategory("Ver TODOS los libros", "Total <font color='red'><b>".$rowtotal['total']." libros</b></font> ", "icons/network.gif", "menu".$counter);
$xpmenu->addOption("Ver TODOS los libros","Ver TODOS los libros", "icons/folder_open.gif", "../frames/listagenero.php","Ver TODOS los libros", "menu".$counter);
$counter++;
$querytotal="select count(distinct(autor)) as autores from placasci_papyre.libros where 1" ;
$restotal=mysql_query($querytotal,$conn);
$rowtotal=mysql_fetch_array($restotal);
$xpmenu->addMenu("menu".$counter);
$xpmenu->addCategory("Ver TODOS los autores", "Total <font color='red'><b>".$rowtotal['autores']." Autores</b></font> ", "icons/network.gif", "menu".$counter);
$xpmenu->addOption("Ver TODOS los autores","Ver TODOS los autores", "icons/folder_open.gif", "../frames/listaautores.php","Ver TODOS los autores", "menu".$counter);
$counter++;
$querygenero="select distinct(genero) from placasci_papyre.tipo";
$resgenero=mysql_query($querygenero,$conn);
while($rowgenero=mysql_fetch_array($resgenero)){
$xpmenu->addMenu("menu".$counter);
$squery="SELECT count( * ) as contador FROM placasci_papyre.libros WHERE genero = '{$rowgenero['genero']}'";
$num=mysql_fetch_array($res=mysql_query("SELECT count( * ) as contador FROM placasci_papyre.libros WHERE genero = '{$rowgenero['genero']}'",$conn));
$xpmenu->addCategory($rowgenero['genero'], $rowgenero['genero']." <font color='red'><b>".$num['contador']." libros</b></font> ", "icons/network.gif", "menu".$counter);
$querysubgenero="select subgenero from placasci_papyre.tipo where genero='".$rowgenero['genero']."' order by subgenero asc";
$ressubgenero=mysql_query($querysubgenero,$conn);
echo mysql_error();
while ($rowsubgenero=mysql_fetch_array($ressubgenero)){
$num=mysql_fetch_array($res=mysql_query("SELECT count( * ) as contador FROM placasci_papyre.libros WHERE genero = '{$rowgenero['genero']}' and subgenero='{$rowsubgenero['subgenero']}'",$conn));
$xpmenu->addOption($rowsubgenero['subgenero'], $rowsubgenero['subgenero']." <font color='red'><b>".$num['contador']." libros</b></font> ", "icons/folder_open.gif", "../frames/listagenero.php?genero={$rowgenero['genero']}&subgenero={$rowsubgenero['subgenero']}",$rowgenero['genero'], "menu".$counter);
}
$counter++ ;
}
$xpmenu->addMenu("menu".$counter);
$xpmenu->addCategory("misc", "Subir libro/miscelanea", "icons/network.gif", "menu".$counter);
$xpmenu->addOption("subir", "subir libro para convertir", "icons/news.gif", "../frames/AJAX/provincias_ajax/default.php", "misc", "menu".$counter);
$xpmenu->addOption("pendientes", "Ver Pendientes", "icons/news.gif", "../frames/pendientes.php", "misc", "menu".$counter);
$xpmenu->addOption("subir2", "compartir libro en FB2", "icons/news.gif", "../frames/AJAX/provincias_ajax/default.php?libro=fb2", "misc", "menu".$counter);
$counter++;
$xpmenu->addMenu("menu".$counter);
$xpmenu->addCategory("search", "BUSQUEDA Libros/Autores", "icons/search.gif", "menu".$counter);
$xpmenu->addOption("buscar", "busqueda", "icons/search.gif", "../frames/formulbusca.php", "search", "menu".$counter);
$counter++;
$xpmenu->addMenu("menu".$counter);
$xpmenu->addCategory("dime algo!", "dime algo!", "icons/note20x20.gif", "menu".$counter);
$xpmenu->addOption("dejame un comentario", "dejame un comentario", "icons/note20x20.gif", "../frames/comentarios.php", "dime algo!", "menu".$counter);
$counter++;
mysql_close ($conn);
?>
<html>
<head>
<?
//javascript for the menu
echo $xpmenu->javaScript();
//css for menu
echo $xpmenu->style();
?>
</head>
<body bgcolor='#FFFFFF' marginheight='0' marginwidth='0' topmargin='0' leftmargin='0'>
<table border='1' cellspacing='1' cellpadding='0' width='100%' height=30 bgcolor='#f1f1ed'>
<tr>
<?
for ($f=0;$f<$counter;$f++){
echo "<td valign='top'> ";
//show menu (put this where you want to show the XP Menu)
echo $xpmenu->mountMenu("menu".$f);
echo "</td></tr><tr>";
}
?>
</tr>
<tr><td>
<?//<p><a href="http://feeds2.feedburner.com/Papyrecocc"><img src="http://feeds2.feedburner.com/~fc/Papyrecocc?bg=99CCFF&fg=444444&anim=1" height="26" width="88" style="border:0" alt="" /></a></p>
?>
<a href="http://placasci.exofire.net/frames/rss.php?option=com_rss&feed=RSS2.0&no_html=1">
<img src="http://web.cocido-maragato.com/images/M_images/rss20.gif" alt="RSS 2.0" align="middle" name="RSS20" border="0" /></a></tr><tr><td>
<?
/*
*/
// contador de visitas
$visitas = 0;
$fp = fopen("visitantes.txt","r"); //no olvidar crear al archivo visitantes.txt y poner el path correcto
$visitas = fread($fp,100);
$visitas++;
fclose($fp);
$fp = fopen("visitantes.txt","w+") ;
fwrite($fp, $visitas);
fclose($fp);
echo ' Contador:<font color="red"> '.$visitas.' </font> visitas distintas<br>';
?>
<? //este el el contador de visita del usuario por cookie ?>
<SCRIPT LANGUAGE="JavaScript">
var caution = false
function setCookie(name, value, expires, path, domain, secure) {
var curCookie = name + "=" + escape(value) +
((expires) ? "; expires=" + expires.toGMTString() : "") +
((path) ? "; path=" + path : "") +
((domain) ? "; domain=" + domain : "") +
((secure) ? "; secure" : "")
if (!caution || (name + "=" + escape(value)).length <= 4000)
document.cookie = curCookie
else
if (confirm("La cookie no puede pesar mas de 4kb!"))
document.cookie = curCookie
}
function getCookie(name) {
var prefix = name + "="
var cookieStartIndex = document.cookie.indexOf(prefix)
if (cookieStartIndex == -1)
return null
var cookieEndIndex = document.cookie.indexOf(";", cookieStartIndex + prefix.length)
if (cookieEndIndex == -1)
cookieEndIndex = document.cookie.length
return unescape(document.cookie.substring(cookieStartIndex + prefix.length, cookieEndIndex))
}
function deleteCookie(name, path, domain) {
if (getCookie(name)) {
document.cookie = name + "=" +
((path) ? "; path=" + path : "") +
((domain) ? "; domain=" + domain : "") +
"; expires=Thu, 01-Jan-70 00:00:01 GMT"
}
}
function fixDate(date) {
var base = new Date(0)
var skew = base.getTime()
if (skew > 0)
date.setTime(date.getTime() - skew)
}
var now = new Date()
fixDate(now)
now.setTime(now.getTime() + 365 * 24 * 60 * 60 * 1000)
var visits = getCookie("counter")
if (!visits)
visits = 1
else
visits = parseInt(visits) + 1
setCookie("counter", visits, now)
document.write("Esta es tu visita numero: <font color='red'>" + visits+"</font>")
</script>
</table>
</body>
</html>
|