/*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);
}
