/*if(mail("*****@*****.**", "Bici&Dintorni, WebCron.", "Ciao Antonino,\n". "è stato richiamato il file control.php.\n", "From: WebMaster Bici&Dintorni <*****@*****.**>\r\n". "Reply-To: webmaster@biciedintorni.it\r\n". "X-Mailer: Mailer/Bici&Dintorni")) echo "<div id=\"msg\" align=\"center\" style=\"color: #0000FF\">[control.php] -- Email di controllo inviata correttamente.</div>\n"; else echo "<div id=\"msg\" align=\"center\" style=\"color: #FF0000\">[control.php] -- Email di controllo non inviata.</div>\n"; */ $db->query($query); $db2 = new db_local(); while ($db->next_record()) { $testo = "Ciao " . $db->record['nome'] . ",\n\nIscritti online alla gita '" . $db->record['titolo'] . "'\n"; $query2 = "SELECT nome,cognome,cell,email,cauzione,carica,idassociato,iscrizioni.idresp FROM anagrafiche,iscrizioni WHERE anagrafiche.id = idassociato AND idgita = " . $db->record['id'] . " and iscrizioni.idresp <> concat(iscrizioni.idassociato,'-NS') ORDER BY cognome,nome"; $db2->query($query2); $testo .= "Associati iscritti: " . $db2->num_rows() . "\n\n"; while ($db2->next_record()) { $testo .= $db2->record['cognome'] . " " . $db2->record['nome'] . " _ Cell: " . $db2->record['cell'] . " _ Email: " . $db2->record['email']; if ($db2->record['cauzione'] != 'SI' && $db2->record['carica'] == 'AS') { $testo .= " ---> SENZA CAUZIONE\n"; } else { $testo .= "\n"; } } $query2 = "SELECT nome,cognome,via,cap,citta,prov,datanascita,tel1,tel2,cell,email FROM nonsoci,iscrizioni WHERE nonsoci.id = idassociato AND idgita = " . $db->record['id'] . " and iscrizioni.idresp = concat(iscrizioni.idassociato,'-NS') ORDER BY cognome,nome"; $db2->query($query2); $testo .= "\n\nNon associati iscritti: " . $db2->num_rows() . "\n\n"; while ($db2->next_record()) { $testo .= $db2->record['cognome'] . " " . $db2->record['nome'] . " Via:" . $db2->record['via'] . "; CAP:" . $db2->record['cap'] . "; Città:" . $db2->record['citta'] . "; "; $testo .= "Provincia:" . $db2->record['prov'] . "; Data di nascita:" . $db2->record['datanascita'] . "; Tel1:" . $db2->record['tel1'] . "; Tel2:" . $db2->record['tel2'] . "; Cell:" . $db2->record['cell'] . "; E-Mail: " . $db2->record['email']; $testo .= "\n\n";
<?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.";
$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);
while ($db->next_record()) { echo " <tr>"; echo " <td>" . $db->record['cognome'] . " " . $db->record['nome'] . "</td>"; echo " <td>" . ($db->record['cell'] ? $db->record['cell'] : $db->record['tel1']) . "</td>"; echo " <td>" . $db->record['email'] . "</td>"; echo " <td>" . $db->record['cauzione'] . "</td>"; echo " <td>" . $db->record['dataeora'] . "</td>"; echo " </tr>"; } echo "</table>\n"; $db2 = new db_local(); // echo "<div color='white'>SELECT iscrizioni.*,nonsoci.nome,nonsoci.cognome,nonsoci.via,nonsoci.tel1,nonsoci.cell,nonsoci.citta,nonsoci.sesso,nonsoci.cap,nonsoci.prov,nonsoci.datanascita FROM iscrizioni,nonsoci,gite WHERE iscrizioni.idassociato=nonsoci.id and iscrizioni.idresp = CONCAT(nonsoci.id,'-NS') AND gite.id = iscrizioni.idgita AND gite.id = '".$id."' AND(gite.idcreat = '".$this->matricola."' or gite.idresp = '".$this->matricola."' or ".$this->matricola." = 0 or '".$this->carica."' = 'A') ORDER BY nonsoci.cognome,nonsoci.nome;</div>"; if ($db2->query("SELECT iscrizioni.*,nonsoci.nome,nonsoci.cognome,nonsoci.via,nonsoci.tel1,nonsoci.cell,nonsoci.citta,nonsoci.sesso,nonsoci.cap,nonsoci.prov,nonsoci.datanascita FROM iscrizioni,nonsoci,gite WHERE iscrizioni.idassociato=nonsoci.id and iscrizioni.idresp = CONCAT(nonsoci.id,'-NS') AND gite.id = iscrizioni.idgita AND gite.id = '" . $id . "' AND(gite.idcreat = '" . $this->matricola . "' or gite.idresp = '" . $this->matricola . "' or " . $this->matricola . " = 0 or '" . $this->carica . "' = 'A') ORDER BY nonsoci.cognome,nonsoci.nome;")) { echo "<table border=\"1\" align=\"center\">"; echo " <tr>"; echo " <td colspan=\"11\" bgcolor=\"#CCFFCC\">Numero NON SOCI iscritti: " . $db2->num_rows() . "</td>"; echo " </tr>"; echo " <tr>"; echo " <td bgcolor=\"#CCFFCC\">Nomi</td>"; echo " <td bgcolor=\"#CCFFCC\">E-Mail</td>"; echo " <td bgcolor=\"#CCFFCC\">Telefono</td>"; echo " <td bgcolor=\"#CCFFCC\">Cellulare</td>"; echo " <td bgcolor=\"#CCFFCC\">Via</td>"; echo " <td bgcolor=\"#CCFFCC\">Città</td>"; echo " <td bgcolor=\"#CCFFCC\">Sesso</td>"; echo " <td bgcolor=\"#CCFFCC\">C.A.P.</td>"; echo " <td bgcolor=\"#CCFFCC\">Provincia</td>"; echo " <td bgcolor=\"#CCFFCC\">Data di nascita</td>"; echo " <td bgcolor=\"#CCFFCC\">NON SOCI</td>"; echo " </tr>"; while ($db2->next_record()) {
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 } }
<?php $db = new db_local(); if ($_GET["all"] == 1) { $db->query("SELECT dataeora,titolo,nome,cognome FROM gite,anagrafiche WHERE anagrafiche.id = gite.idresp ORDER BY dataeora DESC;"); } else { $db->query("SELECT dataeora,titolo,nome,cognome FROM gite,anagrafiche WHERE anagrafiche.id = gite.idresp AND YEAR(dataeora) >= " . date("Y") . " ORDER BY dataeora;"); } echo "<table class=\"funlistagite\" border=\"0\" align=\"center\">\n"; echo " <tr>\n"; echo " <td colspan=\"3\" class=\"title\"><a href='admin.php?fun=listagite&all=1'>Visualizza tutte le gite.</a></td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td colspan=\"3\" class=\"title\">Numero di gite: " . $db->num_rows() . "</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td class=\"title\">Data e ora</td>\n"; echo " <td class=\"title\">Titolo</td>\n"; echo " <td class=\"title\">Capo Gita</td>\n"; echo " </tr>\n"; while ($db->next_record()) { echo " <tr>\n"; echo " <td class=\"dati\"> " . substr($db->record['dataeora'], 8, 2) . "/" . substr($db->record['dataeora'], 5, 2) . "/" . substr($db->record['dataeora'], 0, 4) . " </td>\n"; echo " <td> " . $db->record['titolo'] . " </td>\n"; echo " <td> " . $db->record['nome'] . " " . $db->record['cognome'] . " </td>\n"; echo " </tr>\n"; } echo "</table>\n"; $db->close(); unset($db);
<?php $db = new db_local(); $db->query("SELECT gite.titolo,gite.dataeora as datagita, anagrafiche.nome,anagrafiche.cognome,iscrizioni.* FROM gite,iscrizioni,anagrafiche WHERE gite.id = idgita AND anagrafiche.id = idassociato AND (idassociato = '" . $this->matricola . "' OR iscrizioni.idresp = '" . $this->matricola . "') ORDER BY gite.dataeora DESC, iscrizioni.dataeora, iscrizioni.idresp;"); echo "<table style=\"\" border=\"1\" align=\"center\">\n"; echo " <tr>\n"; echo " <td colspan=\"5\" class=\"title\">Numero di iscrizioni: " . $db->num_rows() . "</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td class=\"title\">Data Gita</td>\n"; echo " <td class=\"title\">Titolo Gita</td>\n"; echo " <td colspan=\"2\" class=\"title\"> </td>\n"; echo " <td class=\"title\">Data Iscrizione</td>\n"; echo " </tr>\n"; while ($db->next_record()) { echo " <tr>\n"; echo " <td class=\"dati\"> " . substr($db->record['datagita'], 8, 2) . "/" . substr($db->record['datagita'], 5, 2) . "/" . substr($db->record['datagita'], 0, 4) . " </td>\n"; echo " <td><a title=\"" . $db->record['titolo'] . "\" href=\"index.php?id=" . $db->record['idgita'] . "\">" . $db->record['titolo'] . "</a></td>\n"; echo " <td><a href=\"\" onclick=\"eliminaisc(" . $db->record['id'] . "); return false; \">Cancella: </a></td>\n\t\t\t\t\t\t"; if (intval($db->record['idassociato']) != intval($this->matricola)) { echo " <td>" . $db->record['nome'] . " " . $db->record['cognome'] . "</td>\n"; } else { echo " <td><b>" . $db->record['nome'] . " " . $db->record['cognome'] . "</b></td>\n"; } echo " <td class=\"dati\"> " . substr($db->record['dataeora'], 8, 2) . "/" . substr($db->record['dataeora'], 5, 2) . "/" . substr($db->record['dataeora'], 0, 4) . " </td>\n"; echo " </tr>\n"; } echo "</table>\n"; $db->close(); unset($db);
function listgite() { $db = new db_local(); if ($this->matricola == 0) { $sqlqry = "SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM gite ORDER BY dataeora DESC;"; } else { switch ($this->carica) { case 'A': case 'S': $sqlqry = "SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM gite ORDER BY dataeora DESC;"; break; default: $sqlqry = "SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM gite WHERE idcreat = {$this->matricola} OR idresp = {$this->matricola} ORDER BY dataeora DESC;"; } } if ($db->query($sqlqry)) { ?> <table align="center" border="1"> <tbody> <tr> <td align="center" colspan="3">Lista gite<br>Attenzione, puoi vedere e modificare solo le gite da te create.</td> <td align="center" colspan="3"><a href="admin.php?fun=listagite" title="Lista di tutte le gite ordinate per data">Lista di tutte le gite inserite ordinate per data</a></td> </tr> <?php $i = 0; if ($db->num_rows() == 0) { echo "<tr>\n\t<td colspan=\"6\">Nessuna gita 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>" . date("d/m/Y", $db->record['data']) . "</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['titolo'] . "</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); }
<?php $db = new db_local(); $db->query("SELECT dataeora,titolo FROM eventi WHERE approvato = '1' ORDER BY dataeora DESC;"); echo "<table style=\"\" border=\"1\" align=\"center\">\n"; echo " <tr>\n"; echo " <td colspan=\"2\" class=\"title\">Numero di eventi: " . $db->num_rows() . "</td>\n"; echo " </tr>\n"; echo " <tr>\n"; echo " <td class=\"title\">Data e ora</td>\n"; echo " <td class=\"title\">Titolo</td>\n"; echo " </tr>\n"; while ($db->next_record()) { echo " <tr>\n"; echo " <td class=\"dati\"> " . substr($db->record['dataeora'], 8, 2) . "/" . substr($db->record['dataeora'], 5, 2) . "/" . substr($db->record['dataeora'], 0, 4) . " </td>\n"; echo " <td> " . $db->record['titolo'] . " </td>\n"; echo " </tr>\n"; } echo "</table>\n"; $db->close(); unset($db);
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); }