Ripeto che probabilmente sono limitata mentalemnet io per certe cose,
ma non riesco proprio a capire quello che scrivi, non riesco a interpretarlo:
"dove la chiami e come, tra l'altro se la stai usando "
questo è il codice di tutta la pagina
Codice PHP:
<?phpsession_start();include("config.php");include("connect.php"); $azione = (isset($_GET['azione']));$id = (isset($_GET['id']));$data_corrente = date("d-m-Y");
if ($azione == "edit_note") {mysqli_query($db,"UPDATE admin SET note = '".$_POST['note']."' ")or die(mysqli_error());$esito = "<div class=\"notification success\"> <span class=\"strong\">OK!</span> <b>Appunto modificato</b></div>";}function cronAttivo() {$cron = mysqli_query($db,"SELECT * FROM cronjob");while ($row_cron = mysqli_fetch_array( $cron )) {if($row_cron['cron'] != 0 && $row_cron['template'] != 0) {return 1;}else {return 0;}}}
function nomeCron() {$db = mysqli_connect();$cronj = mysqli_query($db,"SELECT * FROM cronjob");while ($row_cronj = mysqli_fetch_array('$db,$cronj')) {$cronN = mysqli_query($db,"SELECT * FROM cron WHERE id_cron = '".$row_cronj['cron']."' ");while ($row_cronN = mysqli_fetch_array($cronN)) {return $row_cronN['nome_query'];}}}
function nomeTelmplate() {$cronj = mysqli_query($db,"SELECT * FROM cronjob");while($row_cronj = mysqli_fetch_array( $cronj )) {$templ = mysqli_query($db,"SELECT id_template, nome_template FROM template WHERE id_template = '".$row_cronj['template']."' ");while ($row_templ = mysqli_fetch_array( $templ )) {return $row_templ['nome_template'];}}}function nDestinatari($nome) {$quer = mysqli_query($db,"SELECT count(id_query), nome_query FROM query WHERE nome_query = '$nome' ");while ($row_quer = mysqli_fetch_array( $quer )) {return $row_quer['count(id_query)'];}}function daInviare($nome) {$quer = mysqli_query($db,"SELECT count(id_query), nome_query, send FROM query WHERE nome_query = '$nome' AND send = '0' ");while ($row_quer = mysqli_fetch_array( $quer )) {return $row_quer['count(id_query)'];}}?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="content-type" content="text/html; charset=utf-8" /><link type="text/css" rel="stylesheet" media="all" href="css/base.css" /><link type="text/css" rel="stylesheet" media="all" href="css/jquery-ui.css" /><link type="text/css" rel="stylesheet" media="all" href="css/grid.css" /><link type="text/css" rel="stylesheet" media="all" href="css/visualize.css" /><title>Pannello di controllo EmailSend</title><script type="text/javascript" src="js/jquery.min.js"></script><script type="text/javascript" src="js/jquery-ui.min.js"></script><script type="text/javascript" src="js/excanvas.js"></script><script type="text/javascript" src="js/visualize.jQuery.js"></script><script type="text/javascript" src="js/functions.js"></script></head><body><?php include("inc/header.php"); ?><div id="page-wrapper"> <div class="page"> <div id="page-content"> <div id="page-header"> <h1>Pannello</h1> </div> <div class="container_12"> <div class="grid_8"> <div class="box-header" style="text-align:center;">Statistiche aperture</div> <div class="box table"> <table cellspacing="0"> <thead> <tr> <td style="text-align:center;">Nome</td> <td style="text-align:center;">Oggetto</td> <td style="text-align:center;">Mittente</td> <td style="text-align:center;">Aperte N° (circa)</td> </tr> </thead> <tbody><?php$user = mysqli_query($db,"SELECT nome_template, oggetto, sender, click FROM template");while($row = mysqli_fetch_array($user)) {?><tr><td style="text-align:center;font-weight:bold;"><?php echo $row['nome_template']; ?></td><td style="text-align:center;font-weight:bold;"><?php echo $row['oggetto']; ?></td><td style="text-align:center;font-weight:bold;"><?php echo $row['sender']; ?></td><td style="text-align:center;font-weight:bold;"><?php echo $row['click']; ?></td></tr><?php } ?> </tbody> </table> </div> </div> <div class="grid_4"> <div class="box-header" style="text-align:center;">Stato invio</div> <div class="box"><ul style="font-weight:bold;"><li>Cron attivo: <strong><?php echo nomeCron(); ?></strong></li><li>Template: <strong><?php echo nomeTelmplate(); ?></strong></li><li>N° destinatari: <strong><?php echo nDestinatari(nomeCron()); ?></strong></li><li>E-Mail da inviare N°: <strong><?php echo daInviare(nomeCron()); ?></strong></li><?phpif(cronAttivo() == 1) { echo "<p style=\"text-align:center;\"><b>... INVIO IN CORSO ...</b><br><img src=\"img/inviando.gif\" height=\"80px\"</p>"; echo "<li><a href=\"send.php?action=stop\"><b>FERMA INVIO</b></a></li>";}?></ul> </div> </div> <br class="cl" /> <div class="grid_12"> <div class="box-header" style="text-align:center;">Note e appunti</div> <div class="box"><?phpif ($azione == 'edit_note') {echo "$esito";}$admin = mysqli_query($db,"SELECT id_admin, note FROM admin");while ($row = mysqli_fetch_array( $admin )) {?><form method="post" action="home.php?azione=edit_note&id=<?php echo $row['id_admin']; ?>"><div class="row"><textarea name="note" rows="4" style="width:97%" id="note"><?php echo $row['note']; ?></textarea></div> <div class="row"> <input type="submit" value="Modifica" class="button" /> </div> </form> <?php } ?> </div> </div> <br class="cl" style="margin:1px auto;"> </div> </div> </div></div></div></body></html>