echo "<option>" . (date("Y") + 1) . "</option>\n ";
} else {
echo "<option>" . date("Y") . "</option>\n ";
echo "<option selected>" . (date("Y") + 1) . "</option>\n ";
}
?>
</select>
</td>
<td id="tdresp" class="title">Capogita</td>
<td id="resp">
<?php
include_once "lib/db_mysql.php";
$resp = new db_local();
$resp->query("SELECT * FROM anagrafiche WHERE (carica = 'C' OR carica = 'A') AND id >= 1 ORDER BY nome;");
echo "\t<select onchange=\"newass();\" size=\"1\" name=\"resp\">\n";
while ($resp->next_record()) {
if (intval($db->record['idresp']) == intval($resp->record['id'])) {
$s = "selected ";
}
echo "\t\t\t<option " . $s . "value=\"" . intval($resp->record['id']) . "\">" . $resp->record['nome'] . " " . $resp->record['cognome'] . "</option>\n";
$s = "";
}
?>
</select>
</td>
</tr>
<tr>
<td id="tdtipogita" class="title">Tipo di gita</td>
<td>
<select onchange="cambiaTipogita();" size="1" name="tipogita">
<?php
?>
</table>
<br>
<table width="90%" border=1 align="center" cellpadding="2">
<tr>
<td colspan="2" style="color:green" align="center">EVENTI</td>
</tr>
<tr>
<td class="data" width="13%">Data</td>
<td class="difficili">Titolo</td>
</tr>
<?php
unset($db);
include_once "lib/db_mysql.php";
$db = new db_local();
if ($_GET['limitev'] == '0') {
$db->query("SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM eventi WHERE DATE(dataeora) >= CURDATE() AND approvato = 1 ORDER BY dataeora;");
} else {
$db->query("SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM eventi WHERE DATE(dataeora) >= CURDATE() AND approvato = 1 ORDER BY dataeora LIMIT 0,10 ;");
}
while ($db->next_record()) {
echo "<tr>\n" . "\t<td class=\"data\">" . date("d/m/Y", $db->record['data']) . "</td>\n\t" . "\t<td class=\"difficili\"><a class=\"difficili\" href=\"index.php?evid=" . $db->record['id'] . "\">" . $db->record['titolo'] . "</a></td>\n\t" . "</tr>\n";
}
$db->close();
?>
</table>
</div>
<br>
<div align= "right"><a href="admin.php" target="_parent"><img alt="Amministrazione" src="img/lucchetto.jpg" width="50" height="50"></a></div>
<?php
makeTail();
$rowcolorlight = '#004070';
$rowcolor = $rowcolorlight;
$headercolor = $rowcolordark;
$cellpad = '"1"';
$cellspc = '"3"';
//template config
require_once "patTemplate.php";
$design = new patTemplate();
$design->setBasedir('./templates');
$design->readTemplatesFromFile('basic.xml');
$design->addVar("basic", "LANG_USERSONLINE", $lang['usersonline']);
$design->addVar("basic", "LANG_QUICKSEARCH", $lang['quicksearch']);
$design->addVar("basic", "LANG_EXTENDEDSEARCH", $lang['extendedsearch']);
$design->addVar("basic", "LANG_ARTISTBROWSE", $lang['artistbrowser']);
$design->addVar("basic", "LANG_ADDLYRICS", $lang['addlyrics']);
$design->addVar("basic", "LANG_PREFERENCES", $lang['preferences']);
$design->addVar("basic", "LANG_STAFF", $lang['staff']);
$design->addVar("basic", "LANG_STATISTICS", $lang['statistics']);
$db = new db_local();
$db_user = new db_local();
$db_user->query("SELECT id FROM catusers WHERE name = '{$_COOKIE['user']}' AND pass = '******'pass']}'");
if ($db_user->num_rows() == 0) {
$user_id = 0;
} else {
$db_user->next_record();
$user_id = $db_user->record['id'];
}
$db_user->close();
$username = isset($_COOKIE['user']) ? $_COOKIE['user'] : '******';
$design->addVar("basic", "USERNAME", $username);
unset($output);
function iscr_gita()
{
if (is_numeric($_GET['iscr'])) {
//$message = "Per iscriverti ad una gita devi effettuare il login, inserisci il tuo nome utente e la tua password.";
if (file_exists("db_mysql.php")) {
include_once "db_mysql.php";
} else {
include_once "lib/db_mysql.php";
}
$db = new db_local();
$db->query("SELECT UNIX_TIMESTAMP(dataeora) as data FROM gite WHERE id = " . $_GET['iscr'] . " LIMIT 1");
if ($db->next_record()) {
/*echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG class.php] iscr gita -- trovata gita</div>\n";
if (date("Y") == date("Y",$db->record['data']))
echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Stesso anno</div>\n";
if (date("n") == date("n",$db->record['data']))
echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Stesso mese</div>\n";
if ((date("j")-date("j",$db->record['data'])) <= 2)
echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Mancano meno di due giorni e precisamente".((date("j",$db->record['data']))-(date("j")))."</div>\n";*/
if (date("Y") == date("Y", $db->record['data']) && date("n") == date("n", $db->record['data']) && date("j", $db->record['data']) - date("j") <= 1) {
makeHead("Gestione Gite", "<meta http-equiv=\"refresh\" content=\"5;url=index.php?id=" . $_GET['iscr'] . "\">");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Le iscrizioni alla gita sono terminate. Contattare il capogita.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\">Fra 5 secondi sarete rimandati alla gita.</div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
}
if ($_POST['nonsocio'] == 1) {
//echo "nome=>".$_POST['nome']."< cognome=>".$_POST['cognome']."< tel=>".$_POST['tel1']."< email=>".$_POST['nome']."<";
if (!$_POST['nome'] || !$_POST['cognome'] || !$_POST['email'] || !$_POST['tel1']) {
//header("Location: admin.php?iscr=" . $_GET['iscr']);
makeHead("Gite");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Attenzione devi inserire tutti i campi marcati in rosso.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione della gita.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
if (get_magic_quotes_gpc() == 1) {
$nome = htmlentities($_POST['nome']);
$cognome = htmlentities($_POST['cognome']);
$via = htmlentities($_POST['via']);
$tel1 = htmlentities($_POST['tel1']);
$cell = htmlentities($_POST['cell']);
$comune = htmlentities($_POST['comune']);
$sesso = htmlentities($_POST['sesso']);
$cap = htmlentities($_POST['cap']);
$prov = htmlentities($_POST['prov']);
$giorno = htmlentities($_POST['giorno']);
$mese = htmlentities($_POST['mese']);
$anno = htmlentities($_POST['anno']);
$email = htmlentities($_POST['email']);
} else {
$nome = addslashes(htmlentities($_POST['nome']));
$cognome = addslashes(htmlentities($_POST['cognome']));
$via = addslashes(htmlentities($_POST['via']));
$tel1 = addslashes(htmlentities($_POST['tel1']));
$cell = addslashes(htmlentities($_POST['cell']));
$comune = addslashes(htmlentities($_POST['comune']));
$sesso = addslashes(htmlentities($_POST['sesso']));
$cap = addslashes(htmlentities($_POST['cap']));
$prov = addslashes(htmlentities($_POST['prov']));
$giorno = addslashes(htmlentities($_POST['giorno']));
$mese = addslashes(htmlentities($_POST['mese']));
$anno = addslashes(htmlentities($_POST['anno']));
$email = addslashes(htmlentities($_POST['email']));
}
$datanascita = date("Y-m-d G:i:00", mktime(0, 0, 0, intval($mese), intval($giorno), intval($anno)));
$db->query("SELECT * FROM anagrafiche WHERE LOWER(nome) LIKE '%" . strtolower($nome) . "%' AND LOWER(cognome) LIKE '%" . strtolower($cognome) . "%' LIMIT 1");
if ($db->next_record()) {
makeHead("Gite");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Attenzione c'è già una persona iscritta con i tuoi stessi dati. Le iscrizioni alle gite per i non soci sono possibili UNA sola volta. Se è la prima volta che ti iscrivi ad una gita, ti prego di contattare il capogita.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='index.php?id=" . $_GET['iscr'] . "'>Ritorna alla gita.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
if (!$db->query("INSERT INTO anagrafiche (nome,cognome,via,tel1,cell,citta,sesso,cap,prov,datanascita,carica) VALUES ('{$nome}','{$cognome}','{$via}','{$tel1}','{$cell}','{$citta}','{$sesso}','{$cap}','{$prov}','{$datanascita}','NS');")) {
makeHead("Errore");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE inserimento dati, ti prego di contattare il WebMaster segnalando questo errore.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
$db->query("SELECT id FROM anagrafiche WHERE nome = '" . $nome . "' AND cognome = '" . $cognome . "' LIMIT 1");
if (!$db->next_record()) {
makeHead("Errore");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE prima dell'inserimento iscrizione, ti prego di contattare il WebMaster segnalando questo errore.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
if (!$db->query("INSERT INTO iscrizioni (idgita,idassociato,idresp) VALUES (" . $_GET['iscr'] . "," . $db->record['id'] . "," . $db->record['id'] . ");")) {
makeHead("Errore");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE inserimento iscrizione, ti prego di contattare il WebMaster segnalando questo errore.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
makeHead("Complimenti");
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #0000FF\">COMPLIMENTI. Ti sei iscritto alla gita.</div>\n";
echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='index.php'>Ritorna alle gite.</a></div>\n";
$db->close();
unset($db);
makeTail();
exit;
}
makeHead("Iscrizione");
$db->close();
unset($db);
$message = "";
include "lib/check_login.php";
if (!isset($user)) {
return;
}
$user->iscrizione($_GET['iscr']);
} else {
echo "Errore iscr_gita, nessuna gita selezionata";
}
}
<?php
//echo "<br> act = $act <br>";
session_start();
$login = $_SESSION['login'];
$password = $_SESSION['password'];
if ($login == "") {
echo "Devi effettuare il login prima.";
echo "<br><center>[<a href='http://www.biciedintorni.it/application/admin.php'>Login</a>]</center>";
exit;
}
include_once "class.php";
include_once "db_mysql.php";
$db = new db_local();
$db->query("SELECT user,email FROM anagrafiche WHERE user = '******';");
if ($db->next_record()) {
//echo "--------------".$db->record['email']."<br>";
if ($_POST["password"] != "") {
if ($_POST["password"] == $_POST["password2"]) {
if (check($login, $_POST["password"])) {
if ($_POST["email"] != "") {
$strqry = "UPDATE anagrafiche SET passch = passch + 1, pw = '" . $_POST["password"] . "', pass = MD5('" . $_POST["password"] . "'),email = '" . trim($_POST["email"]) . "' WHERE user = '******' LIMIT 1;";
} else {
$strqry = "UPDATE anagrafiche SET passch = passch + 1, pw = '" . $_POST["password"] . "', pass = MD5('" . $_POST["password"] . "') WHERE user = '******' LIMIT 1;";
}
if ($db->query($strqry)) {
$_SESSION['password'] = md5($_POST["password"]);
if ($_GET['iscr']) {
$variabile = "?iscr=" . $_GET['iscr'];
}
$script = '' . "<script type=\"text/javascript\">\n" . "\t\t\tfunction ok()\n" . "\t\t\t{\n" . "\t\t\t\talert('Password modificata.');\n" . "\t\t\t\tlocation.replace('http://www.biciedintorni.it/application/admin.php" . $variabile . "');\n" . "\t\t\t}\n" . "\t\t</script>";
<?php
include_once "lib/db_mysql.php";
include_once "lib/class.php";
$dbanag2008 = new db_local();
$dbanag = new db_local();
$dbanag2008->query("SELECT * FROM anag2008");
$i = 0;
while ($dbanag2008->next_record()) {
$dbanag->query("SELECT * FROM anagrafiche WHERE TRIM(nome) LIKE \"%" . trim($dbanag2008->record['nome']) . "%\" AND TRIM(cognome) LIKE \"%" . trim($dbanag2008->record['cognome']) . "%\"");
echo "SELECT * FROM anagrafiche WHERE TRIM(nome) LIKE \"%" . trim($dbanag2008->record['nome']) . "%\" AND TRIM(cognome) LIKE \"%" . trim($dbanag2008->record['cognome']) . "%\"<br>";
echo "nrow: " . $dbanag->num_rows() . "<br>";
if ($dbanag->num_rows() == 1 && $dbanag->next_record()) {
$dbanag2008->query("SELECT id FROM anag2008 WHERE '" . trim($dbanag->record['nome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(nome)),'%\"') AND '" . trim($dbanag->record['cognome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(cognome)),'%\"')");
echo "SELECT id FROM anag2008 WHERE '" . trim($dbanag->record['nome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(nome)),'%\"') AND '" . trim($dbanag->record['cognome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(cognome)),'%\"')<br>";
echo "nrow: " . $dbanag2008->num_rows() . "<br>";
if ($dbanag2008->num_rows() == 1 && $dbanag2008->next_record()) {
$id = $dbanag2008->record['id'];
$dbanag2008->query("DELETE FROM anag2008 WHERE id = " . $id);
$dbanag2008->query("SELECT * FROM anag2008 AND id > " . $id);
$i++;
// "SELECT id FROM anag2008 WHERE 'ciccio' LIKE CONCAT(CONCAT('%',TRIM(nome)),'%') AND 'ciccio' LIKE CONCAT(CONCAT('%',TRIM(cognome)),'%')"
}
$id = 0;
}
}
echo "Eliminate: {$i} righe.";
<?php
require_once 'config.inc.php';
$db = new db_local();
if ($_REQUEST['id'] == "") {
$design->addVar("error", "ERROR", "id ist leer!");
//HELP ME!
$design->addVar("basic", "PAGECONTENT", $design->getParsedTemplate('error'));
$design->displayParsedTemplate('basic');
exit;
}
$db->query("SELECT comment FROM catusers WHERE id = {$_REQUEST['id']}");
$db->next_record();
$design->addVar("basic", "PAGECONTENT", $db->record['comment']);
$design->displayParsedTemplate('basic');
<!-- title>FIAB Torino Bici e Dintorni - gita - <?php
echo $db->record['titolo'];
?>
</title>-->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
</head>
<body>
<div class="container-fluid">
<?php
if ($db->next_record()) {
$ciscr = new db_local();
if ($ciscr->query("SELECT COUNT(*) AS niscr FROM iscrizioni WHERE idgita = '" . $db->record['id'] . "';", true)) {
if ($ciscr->next_record()) {
$niscri = $ciscr->record['niscr'];
} else {
echo "Errore vis_gita 'numero iscritti' iscr, query falsa.";
}
}
$ciscr->close();
unset($ciscr);
?>
<div id="tddata">Data: <?php
echo substr($db->record['dataeora'], 8, 2) . "/" . substr($db->record['dataeora'], 5, 2) . "/" . substr($db->record['dataeora'], 0, 4);
if ($niscri > 0) {
echo ", <a href=\"index.php?iscrid=" . $db->record['id'] . "\">Numero iscritti: {$niscri}</a>";
}
/*else
echo ", Nessun iscritto a questa gita.";*/
function listgruppi()
{
$db = new db_local();
/*$sqlqry = "select * from gruppimail inner join lnk_gruppi_soci on gruppimail.id = lnk_gruppi_soci.idgruppo";*/
$sqlqry = "select * from gruppimail";
if ($db->query($sqlqry)) {
?>
<br>
<table style="width:900px;" align="center" border="1">
<tbody>
<tr class="title">
<td align="center">Nome Gruppo</td>
<td align="center">Descrizione</td>
<td align="center">Modifica</td>
<td align="center">Elimina</td>
</tr>
<?php
$i = 0;
if ($db->num_rows() == 0) {
echo "<tr>\n\t<td colspan=\"4\">Nessun gruppo presente nel database</td>\n</tr>";
} else {
while ($db->next_record()) {
echo "<tr>";
echo "<td>" . $db->record['nome'] . " </td>\n\t\t\t\t\t\t";
echo "<td>" . $db->record['descrizione'] . " </td>\n\t\t\t\t\t\t";
echo "<td><a href=\"admin.php?fun=modgruppo&id=" . $db->record['id'] . "\">Modifica</a></td>\n\t\t\t\t\t\t";
echo "<td><a href=\"\" onclick=\"javascript: eliminagruppo(" . $db->record['id'] . "); return false; \">Elimina</a></td>\n\t\t\t\t\t\t";
echo "</tr>";
}
}
?>
</tbody>
</table>
<br>
<?php
}
}
title="Crea Un documento Doc con tutte le gite approvate.">[Scarica doc promemoria gite <?php
echo date("Y");
?>
]
</a>
</div>
<table>
<tbody>
<tr>
<th class="data">Data</th>
<th class="facili">Descrizione</th>
<th class="facili" align="center">Km</th>
<th class="medie">Difficoltà</th>
</tr>
<?php
while ($snipdb->next_record()) {
?>
<tr>
<td class="data"><?php
echo substr($snipdb->record['dataeora'], 8, 2) . "/" . substr($snipdb->record['dataeora'], 5, 2) . "/" . substr($snipdb->record['dataeora'], 0, 4);
?>
</td>
<td><span class="medie"><a
href="http://www.biciedintorni.it/application/index.php?id=<?php
echo $snipdb->record['id'];
?>
"><?php
echo $snipdb->record['titolo'];
?>
</a></span></td>
<td align="center"><?php
if ($database->next_record()) {
if (mail($database->record['email'], $_POST['oggetto'], $_POST['messaggio'], "From: " . $_POST['nome'] . " <" . $_POST['da'] . ">\r\n" . "Reply-To: " . $_POST['da'] . "\r\n" . "X-Mailer: Mailer/Bici&Dintorni")) {
echo "<div align=\"center\">Il messaggio è stato inviato correttamente.</div>";
} else {
echo "<div align=\"center\">Errore nell'invio del messaggio.(Segnalare il problema al webmaster (Error: mail false)</div>";
}
} else {
echo "<div align=\"center\">Errore nell'invio del messaggio.(Segnalare il problema al webmaster (Error: nessun utente a cui inviare il messaggio)</div>";
}
makeTail();
exit;
}
if (is_numeric($_GET['id'])) {
$database = new db_local();
$database->query("SELECT * FROM anagrafiche WHERE id = '" . $_GET['id'] . "' LIMIT 1;", true);
if (!$database->next_record()) {
echo "Errore sconosciuto";
makeTail();
return;
}
?>
<form action="mail.php" method="post" name="emailForm">
<table align="center">
<tr>
<td colspan="2">Manda una e-mail a questo contatto:<br><br></td>
</tr>
<tr>
<td>Il tuo nome:</td>
<td><input size="50" name="nome" value="<?php
echo $user->nome . " " . $user->cognome;
?>
function appgita($id)
{
if (is_numeric($id)) {
include_once "lib/db_mysql.php";
$db = new db_local();
if ($db->query("SELECT approvata FROM gite WHERE id = '" . $id . "' ;")) {
if ($db->next_record()) {
if ($db->record['approvata'] == '1') {
if ($db->query("UPDATE gite SET approvata = '0' WHERE id = '" . $id . "' ;")) {
return "Non approvata";
} else {
return "appgita (approvazione gita), query falsa.";
}
} else {
if ($db->query("UPDATE gite SET approvata = '1' WHERE id = '" . $id . "' ;")) {
return "Approvata";
} else {
return "appgita (approvazione gita), query falsa.";
}
}
} else {
return "appgita (approvazione gita), gita non esistente.";
}
} else {
return "appgita (approvazione gita), query select falsa.";
}
$db->close();
unset($db);
} else {
return "nessun id specificato.";
}
}
function listass()
{
$db = new db_local();
if ($this->matricola == 0) {
$sqlqry = "SELECT * FROM anagrafiche ORDER BY cognome;";
} else {
switch ($this->carica) {
case 'A':
case 'S':
$sqlqry = "SELECT * FROM anagrafiche ORDER BY cognome;";
//break;
}
}
if ($db->query($sqlqry)) {
?>
<table align="center" border="1">
<tbody>
<tr>
<td align="center" colspan="3">Lista associati.</td>
<td align="center" colspan="3"><a href="admin.php?fun=listaass" title="Lista di tutti gli associati">Lista di tutti gli associati</a></td>
</tr>
<tr>
<td align="center">Cognome</td>
<td align="center">Nome</td>
<td align="center">UserName</td>
<td align="center">Indirizzo</td>
<td align="center">Tel1</td>
<td align="center">Cell</td>
<td align="center">E-Mail</td>
<td align="center">Carica</td>
<td align="center">Tipo Socio</td>
</tr>
<?php
$i = 0;
if ($db->num_rows() == 0) {
echo "<tr>\n\t<td colspan=\"6\">Nessun associato presente nel database</td>\n</tr>";
} else {
while ($db->next_record()) {
echo "\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $db->record['cognome'] . "</td>\n\t\t\t\t\t\t";
//echo "<td><a target=\"_blank\" href=\"index.php?id=".$db->record['id']."\">".$db->record['titolo']."</a></td>\n ";
echo "<td>" . $db->record['nome'] . "</td>\n\t\t\t\t\t\t";
echo "<td>" . $db->record['user'] . "</td>\n\t\t\t\t\t\t";
echo "<td>" . $db->record['via'] . "</td>\n\t\t\t\t\t\t";
echo "<td>";
if ($db->record['difficolta'] == 'F') {
echo "Facile";
} elseif ($db->record['difficolta'] == 'M') {
echo "Media";
} elseif ($db->record['difficolta'] == 'U') {
echo "Facile per famiglie";
} else {
echo "Impegnativa";
}
echo "</td>\n\t\t\t\t\t\t";
echo "<td><a href=\"admin.php?fun=modgita&id=" . $db->record['id'] . "\">Modifica</a></td>\n\t\t\t\t\t\t";
if ($this->carica != 'A') {
echo "<td>Elimina</td>\n\t\t\t\t\t";
echo "<td>Approva</td>\n\t\t\t\t\t</tr>\n";
} else {
echo "<td><a href=\"\" onclick=\"javascript: elimina(" . $db->record['id'] . "); return false; \">Elimina</a></td>\n\t\t\t\t\t\t";
if ($db->record['approvata'] == '1') {
$str = 'Approvata';
} else {
$str = 'Non approvata';
}
echo "<td><a href=\"\" id=\"linkapp" . $i++ . "\" onclick=\"approva(" . $db->record['id'] . ",'linkapp" . ($i - 1) . "'); return false;\">" . $str . "</a></td>\n\t\t\t\t\t\t";
}
}
}
?>
</tbody>
</table>
<?php
}
$db->close();
unset($db);
}
