| Commento lasciato da " . $row["Nome"] . " " . $row["Cognome"] . ", " . formatDateFromSQL($row["DataOra"], "dataestesa") . " alle ore " . formatDateFromSQL($row["DataOra"], "ora") . " |
| " . formatTXT($row["Testo"]) . " |
";
$addToAnyString .= "";
$addToAnyString .= "";*/
return $addToAnyString;
}
function getElencoCommenti($db, $limit)
{
$commenti = array();
$query = "SELECT c.* FROM vw_commenti c LIMIT " . $limit;
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
$i = 0;
if ($num_row > 0)
{
while($row = mysql_fetch_assoc($res))
{
array_push($commenti, $row);
if ($commenti[$i]["IDConcerto"] > 0)
{
$commenti[$i]["Titolo"] = getNomeArtistiConcerto($db, $commenti[$i]["IDConcerto"], 0) . " @ " . $commenti[$i]["NomeLuogo"];
}
$i++;
}
}
return $commenti;
}
function getPrimoPiano($db)
{
$primo = array();
$query = "SELECT p.Testo FROM primopiano p WHERE sysdate() BETWEEN p.DataDa AND p.DataA AND p.Attivo = 1 ORDER BY p.DataDa";
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
if ($num_row > 0)
{
while($row = mysql_fetch_assoc($res))
{
array_push($primo, $row);
}
}
return $primo;
}
function getConcertiInZona($db, &$concerti, $giorni)
{
if (count($concerti) == 0)
{
$concerti = array();
}
$query = "";
$query .= "SELECT z.ID, z.Nome, count(*) Numero FROM concerto c ";
$query .= "INNER JOIN realta r ON r.ID = c.IDLuogo ";
$query .= "INNER JOIN zona_provincia zp ON zp.IDProvincia = r.IDProvincia ";
$query .= "INNER JOIN zona z ON z.ID = zp.IDZona ";
$query .= "WHERE c.Attivo >= 1 AND Date(c.DataOra) >= Curdate() ";
if ($giorni > 0)
{
$query .= "AND Date(c.DataOra) < Curdate() + INTERVAL " . $giorni . " DAY ";
}
$query .= "GROUP BY z.ID ";
$query .= "HAVING count(*) >= 5 ";
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
if ($num_row > 0)
{
while($row = mysql_fetch_assoc($res))
{
array_push($concerti, $row);
}
}
}
function contaAccessi($db)
{
if (!isset($_SESSION["LiveUs_Accessi"]))
{
$query = "SELECT ID, Count, Mese FROM accessi_count ORDER By Mese DESC LIMIT 1";
$accessi = 1;
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
$mese = 0;
$id = 1;
if ($num_row > 0)
{
while($row = mysql_fetch_assoc($res))
{
$accessi = $row["Count"] + 1;
$mese = formatDateFromSQL($row["Mese"], "mese");
$id = $row["ID"];
}
}
$today = getdate();
$month = $today['mon'];
if ($month == $mese)
{
$query = "UPDATE accessi_count SET Count = " . $accessi . " WHERE ID = " . $id;
}
else
{
$oggi = $today['year'] . "-" . $today['mon'] . "-" . $today['mday'];
$query = "INSERT INTO accessi_count (Count, Mese) VALUES (1, '" . $oggi . "')";
}
$db->exec($query);
isToExecute($db);
$_SESSION["LiveUs_Accessi"] = $accessi;
}
}
function isToExecute($db)
{
$query = "SELECT ID, DataOra, Nome, Intervallo, Numero FROM accessi_todo WHERE Attivo = 1";
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
if ($num_row > 0)
{
while($row = mysql_fetch_assoc($res))
{
$oradbAnno = substr($row["DataOra"], 0, 4);
$oradbMese = substr($row["DataOra"], 5, 2);
$oradbGiorno = substr($row["DataOra"], 8, 2);
$oradbOra = substr($row["DataOra"], 11, 2);
$oradbMinuto = substr($row["DataOra"], 14, 2);
$oradbSecondo = substr($row["DataOra"], 17, 2);
switch($row["Intervallo"])
{
case "y":
$oradbAnno += $row["Numero"];
break;
case "m":
$oradbMese += $row["Numero"];
break;
case "d":
$oradbGiorno += $row["Numero"];
break;
case "h":
$oradbOra += $row["Numero"];
break;
case "i":
$oradbMinuto += $row["Numero"];
break;
case "s":
$oradbSecondo += $row["Numero"];
break;
}
$oradb = mktime($oradbOra, $oradbMinuto, $oradbSecondo, $oradbMese, $oradbGiorno, $oradbAnno);
$now = getdate();
$adesso = mktime($now['hours'], $now['minutes'], $now['seconds'], $now['mon'], $now['mday'], $now['year']);
if ($oradb < $adesso)
{
switch($row["Nome"])
{
case "PDF Concerti":
sendConcertiPDF($db, $row["ID"]);
break;
}
$query = "UPDATE accessi_todo SET DataOra = '" . strftime("%Y-%m-%d %H:%M:%S", $oradb) . "' WHERE ID = " . $row["ID"];
$db->exec($query);
}
}
}
}
function sendConcertiPDF($db, $id)
{
$query = "SELECT u.Nome, u.Email, ut.IDZona, z.Nome NomeZona FROM utente_todo ut INNER JOIN utente u ON ut.IDUtente = u.ID INNER JOIN zona z ON ut.IDZona = z.ID WHERE ut.IDToDo = " . $id . " AND ut.Attivo = 1 AND u.Attivo = 1";
$res = $db->getRecordset($query);
$num_row = mysql_num_rows($res);
if ($num_row > 0)
{
$titolo = "LiveUs.it -> Concerti";
while($row = mysql_fetch_assoc($res))
{
$to = $row["Email"];
$testo = "Ciao " . $row["Nome"] . ",