sastgroup forum

omarinux · 2008-02-15 12:56:17

Ciao a tutti.
Volevo chiedere se anche a voi succede questa cosa strana.

Apro dei TT scrivendo in maniera "normale", andando a capo, come da esempio:

Stamattina stranamente, ho trovato le key del DNS diverse.
[root@uffici root]# cat /etc/rndc.key key "rndckey" { algorithm hmac md5; secret "gnYgammdAYJN6TPHsuekqgEQ7xASBd8nADzn8zphCRVStT12NtfTspjwVJOn"; };

Poi quando vado a vedere i TT mi esce una cosa del genere:

Stamattina stranamente, ho trovato le key del DNS diverse. [root@uffici root]# cat /etc/rndc.key key "rndckey" { algorithm hmac-md5; secret "gnYgammdAYJN6TPHsuekqgEQ7xASBd8nADzn8zphCRVStT12NtfTspjwVJOn"; };

Tutto scritto su una riga, e se creo anche delle "liste" in questo modo:

- lista 1
- lista 2
- lista 3

La vedo così:

- lista 1 - lista 2 - lista 3

Succede anche a voi?

sandrostracuzzi · 2008-02-15 15:28:01

a me nn capita

omarinux · 2008-02-15 16:29:51

Scusa sandro ma posso postarti un file php che server per visualizzare i TT? Non riesco a capire come mai mi capita questa cosa...

Non dovrebbero esserci problemi su server apache + php 5 + mysql. Distro FC5

Omar

sandrostracuzzi · 2008-02-15 20:01:48

postalo

omarinux · 2008-02-18 09:15:11

Ecco il vedi_ticket.php all'interno della directory admin:

Codice:

 <?
include("../config.php");
$obj=new sast1com();
$temput=$_SESSION['temput'];
$temppass=$_SESSION['temppass'];
$tipo=$_SESSION['tipo'];
$isadmin=$_SESSION['isadmin'];

$tempid=$_SESSION['tempid'];
$tempgp=$_SESSION['tempgp'];

$faqi=$_SESSION['faqi'];
$faqm=$_SESSION['faqm'];
$faqv=$_SESSION['faqv'];
$avvisii=$_SESSION['avvisii'];
$avvisim=$_SESSION['avvisim'];
$avvisiv=$_SESSION['avvisiv'];
$downloadsi=$_SESSION['downloadsi'];
$downloadsm=$_SESSION['downloadsm'];
$downloadsv=$_SESSION['downloadsv'];
$utentii=$_SESSION['utentii'];
$utentim=$_SESSION['utentim'];
$utentiv=$_SESSION['utentiv'];
$comunicazioniv=$_SESSION['comunicazioniv'];

?>

<?
if(strlen($temput)>0 && strlen($temppass)>0 && $tipo==1){
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head>
<meta http-equiv="content-type" content="text/html;charset=ISO-8859-1">
<title>Cms admin</title>
<link href="images/smenustyles.css" rel="stylesheet">
 <script type="text/javascript" src="menuor.js"></script>
</head>

<body>
<div id="page">
<div class="row">
        <img src="images/phptroubleticket.jpg" alt="logo">
</div>

<div id="bar1">
<div id="menuTop">
<ul class="ul">
<li  id="but1"><a href="pannello.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="Welcome"><span>Home</span></a></li>
<li class="sel" id="but2"><a href="sel_ticket.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="categorie"><span>Ticket</span></a></li>
<li id="but3"><a href="sel_faq.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="menu"><span>Faq</span></a></li>
<li id="but4"><a href="sel_avvisi.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="pagine"><span>Avvisi</span></a></li>
<li id="but7"><a href="sel_downloads.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="ordini"><span>Downloads</span></a></li>
<li id="but5"><a href="sel_utenti.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="Immagini"><span>Utenti</span></a></li>
<li id="but5"><a href="sel_operatori.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="Operatorii"><span>Operatori</span></a></li>
<li id="but8"> <a href="sel_configurazione.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" ><span>Configurazione</span></a></li>
<li id="but9">  <a href="newsletter.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" ><span>Comunicazioni</span></a></li>
<li id="but12"><a href="logout.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" title="logout"><span>Esci</span></a></li>
</ul></div>
</div>

<div id="spazio" style="padding:7px;font-size:14px;">
 <?if($isadmin==1){?>
<a href="ins_ticket_cat.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0">Inserisci categorie</a> ||
<a href="sel_ticket_cat.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0">Vedi categorie</a> ||  <?}?>
<a href="sel_ticket.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0">Vedi ticket</a> ||
<a href="cerca_ticket.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0">Cerca ticket</a>

</div>


<?
$obj->connessione();
$result = mysql_query ("update ticket set letto='1' where id='$id'");

?>


          <div align="center">

                <div class="row">
                 <p>

<?
$id=$_GET['id'];
$idcat=$_GET['idcat'];
?>


<?
$obj->connessione();
$result = mysql_query("select * from configurazione where id=1");
while($array=mysql_fetch_array($result)){
$titolosito=$array[nome];
$emailsito=$array[email];
}
?>

<?
$obj->connessione();
if($_POST['op']=="ins"){
//cattura i dati dal modulo
$idx =$_POST['idx'];
$data =$_POST['data_risposta'];
$risposta =$_POST['risposta'];
$risposta =rteSafe($risposta);
$operatore =$_POST['operatore'];
$email =$_POST['email'];
//li inserisce nella tabella
$result = mysql_query ("insert into ticket_risp (id_t,utente,messaggio,data) values('$idx','$operatore','$risposta','$data')");
if($result)echo"modif corretto";
else echo"modif fallito";

//mail risp



        $testo="";
        $testo.="$risposta\n";
        $testo.="\n";
        $testo.="$utente\n";
        $testo.="$nomesito";
        $testo.="Dettagli Ticket\n";
        $testo.="===================\n";
        $testo.="Ticket ID: $idx\n";

        $oggettox="Ticket [# $idx]: risposta";

        //uno
        $extra_hdr_str = "From: $titolosito <$emailsito>";
        $formsent = mail($email,$oggettox,$testo,$extra_hdr_str);
        if($formsent)echo"K";
        else echo"N";


echo"<script language=javascript>";
//echo"alert('From: $titolosito <$emailsito>');";
echo"document.location.href='vedi_ticket.php?id=$idx&idcat=$idcat'";
echo"</script>";
}
?>

<?
$obj->connessione();
$result = mysql_query("select * from nomicampiextra where idcat=$idcat");

while($array=mysql_fetch_array($result)){
$nome1=$array[nome1];
$nome2=$array[nome2];
$nome3=$array[nome3];
$nome4=$array[nome4];
$nome5=$array[nome5];
$nome6=$array[nome6];
$nome7=$array[nome7];
$nome8=$array[nome8];
$nome9=$array[nome9];
}
?>

<fieldset><input type="hidden" name="phpMyAdmin" value="v7zjFK9AGEqnRjVcycE5l%2CkeVK0" /><legend>Ticket</legend>
<?
$obj->connessione();
if(strlen($id)>0)$result = mysql_query("select * from ticket where id='$id'");
else if(strlen($idx)>0)$result = mysql_query("select * from ticket where id='$idx'");
else $result = mysql_query("select * from ticket where id='$id'");

while($array=mysql_fetch_array($result)){
$id= $array[id];
echo "<b>ticket id</b> :".$array[id]."<br>";
echo "<b>priorita</b>:".$array[priorita]."<br>";
echo "<b>cat</b> :".catid($array[t_cat])."<br>";

if(strlen($array[nome1])>0){echo "<b>$nome1</b>:".$array[nome1]."<br>";}
if(strlen($array[nome2])>0){echo "<b>$nome2</b>:".$array[nome2]."<br>";}
if(strlen($array[nome3])>0){echo "<b>$nome3</b>:".$array[nome3]."<br>";}
if(strlen($array[nome4])>0){echo "<b>$nome4</b>:".$array[nome4]."<br>";}
if(strlen($array[nome5])>0){echo "<b>$nome5</b>:".$array[nome5]."<br>";}
if(strlen($array[nome6])>0){echo "<b>$nome6</b>:".$array[nome6]."<br>";}
if(strlen($array[nome7])>0){echo "<b>$nome7</b>:".$array[nome7]."<br>";}
if(strlen($array[nome8])>0){echo "<b>$nome8</b>:".$array[nome8]."<br>";}
if(strlen($array[nome9])>0){echo "<b>$nome9</b>:".$array[nome9]."<br>";}

echo "&nbsp;&nbsp;&nbsp;<b><font color=#00ccff>oggetto</b>:".$array[oggetto]."</font><br>";
echo "&nbsp;&nbsp;&nbsp;<b><font color=#00ccff>messaggio</b>:".$array[messaggio]."</font><br>";
echo "&nbsp;&nbsp;&nbsp;<b><font color=#00ccff>data_invio</b>:".$array[data_invio]."</font><br>";
echo "<b>utente</b>:".$array[utente]."<br>";
echo infoutente($array[utente]);
$email=$array[utente];
}
?>
</fieldset>
<br>

<?
$obj->connessione();
$result = mysql_query("select * from ticket_risp where id_t=$id");

while($array=mysql_fetch_array($result)){
//$id= $array[id];
echo "<fieldset><input type="hidden" name="phpMyAdmin" value="v7zjFK9AGEqnRjVcycE5l%2CkeVK0" /><legend>Risposta</legend>";
echo "<b>messaggio</b>:".$array[messaggio]."<br>";
echo "<b>data</b>:".$array[data]."<br>";
echo "<b>utente</b>:".$array[utente]."<br>";
echo "</fieldset><br>";
}
?>


<br>
<fieldset><input type="hidden" name="phpMyAdmin" value="v7zjFK9AGEqnRjVcycE5l%2CkeVK0" /><legend>Risposta</legend>
<form action="vedi_ticket.php?idcat=<?echo $idcat;?>" method="post">
<input type="hidden" value="<?echo $id;?>" name="idx">
<input type="hidden" value="ins" name="op">
<input type="hidden" value="<? echo $email;?>" name="email">
<textarea rows=6 cols=80 wrap="off" name="risposta"></textarea>
<br>
<?$today = date("j F Y, g:i a");?>
data risposta <input type="text" name="data_risposta" value="<?echo $today;?>">
<input type="hidden" value="<?echo $tempid;?>" name="operatore">

<!--<select size="1" name="operatore">
<?
$obj->connessione();
$result = mysql_query("select * from utenti where tipo=1");
while($array=mysql_fetch_array($result)){
echo "<option value=\"$array[id]\">$array[nome] - $array[email]</option>";
}
?>
</select>  -->

<br>
<input type="submit" value="Rispondi">
</form>
</fieldset>


<?
}
else{
echo"<script language=javascript>";
echo"document.location.href='errore.php'";
echo"</script>";
}
?>              </p>
                </div>
                <div class="row">&nbsp;</div>
                <div class="row"><?include("footer.php");?></div>

        </div>
</div>

</body></html>

<?

function catid($id){
$obj=new sast1com();
  $obj->connessione();
  $dati=mysql_query("select nome from ticket_cat where id=$id");
      while($array=mysql_fetch_array($dati)){
          return $array[nome];
      }
}

function infoutente($id){
$obj=new sast1com();
  $obj->connessione();
  $dati=mysql_query("select * from utenti where email='$id'");
      while($array=mysql_fetch_array($dati)){
          return $array[cognome]." ".$array[nome];
      }
}
?>


<?php
function rteSafe($strText) {
        //returns safe code for preloading in the RTE
        $tmpString = $strText;

        //convert all types of single quotes
        $tmpString = str_replace(chr(145), chr(39), $tmpString);
        $tmpString = str_replace(chr(146), chr(39), $tmpString);
        $tmpString = str_replace("'", "'", $tmpString);

        //convert all types of double quotes
        $tmpString = str_replace(chr(147), chr(34), $tmpString);
        $tmpString = str_replace(chr(148), chr(34), $tmpString);
//        $tmpString = str_replace("\"", "\"", $tmpString);

        //replace carriage returns & line feeds
        $tmpString = str_replace(chr(10), " ", $tmpString);
        $tmpString = str_replace(chr(13), " ", $tmpString);

        return $tmpString;
}
?>

Ecco il apri_ticket all'interno della directory radice:

Codice:

<?
include("config.php");

$temput= $_SESSION['temput'];
$temppass= $_SESSION['temppass'];

//parametri
$obj=new sast1com();
$obj->connessione();
$result = mysql_query("select * from configurazione");
while($array=mysql_fetch_array($result)){
$titolosito=$array[nome];
$logosito=$array[logo];
}

$id_cat=$_GET['id_cat'];
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<title><?echo $titolosito;?>apri ticket</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><!-- default stylesheet -->
<link rel="stylesheet" type="text/css" media="all" href="css.css" />
</head>

<body ><center>
<table width="830" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td>
    <table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="52%" align="left"><a href="index.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0"><img src="files/<?echo $logosito;?>" border="0"></a></td>
        <td width="48%" align="right" valign="bottom"><span class="smalltext"><font color="#666666"><?$today = date("j F Y, g:i a");echo $today;?>&nbsp;</font></span> </td>
      </tr>
    </table>
    </td>
</tr>
</table>

<table width="830" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td>
    <table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="2" bgcolor="#3894E5"><img src="images/space.gif" width="1" height="2"></td>
      </tr>
      <tr>
        <td height="6" bgcolor="#83BFF5"><img src="images/space.gif" width="1" height="6"></td>
      </tr>
      <tr>
        <td height="5" bgcolor="#C3E3FF"><img src="images/space.gif" width="1" height="5"></td>
      </tr>
    </table>
    </td>
</tr>
</table>

<table width="830" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td><table width="100%"  border="0" cellspacing="0" cellpadding="2">
      <tr>
        <td align="left" valign="top" class="smalltext"><b><font color="#707070"><a href="index.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="navlink">Centro di Supporto <?echo $titolosito;?></a></font>» ticket</b>
         <?if(strlen($temput)>0 && strlen($temppass)>0){?>
         - Benvenuto <?echo $temput;?> - <a href="logout.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0"><strong>Esci</strong></a>
         <?}else{?>
         - (<a href="accedi.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0"><b>Accedi</b></a> oppure <a href="registrati.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0"><b>Registrati</b></a>)</td>
         <?}?>
      </tr>
          <tr>
        <td height="5" bgcolor="#FFFFFF"><img src="images/space.gif" width="1" height="3"></td>
      </tr>
    </table></td>
</tr>
</table>

<table width="830" border="0" cellspacing="0" cellpadding="0">
 <tr>
                        <td>
Se non trovi la soluzione del tuo problema nel nostro <strong><a href="knowledgebase.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0">knowledgebase</a></strong>, puoi inviare una richiesta di assistenza al nostro Team di Supporto..</td>
                      </tr>
</table>
<br>
<table width="830" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td colspan="2"><div class="qbtitle">Selezionare il servizio per il quale si chiede assistenza</div></td>
                      </tr>
                      <tr>
                        <td colspan="2">
                          <?
                          if(strlen($temput)>0){
$obj->connessione();
$result = mysql_query("select * from ticket_cat order by id desc");
while($array=mysql_fetch_array($result)){
echo"<div class=\"navitem\" onMouseOver=\"javascript:this.className='navitemhover';\" onMouseOut=\"javascript:this.className='navitem';\"><img src=\"images/icon_folderyellow.gif\" border=0>&nbsp;<a href=\"apri_ticket2.php?id_cat=$array[id]&id_gp=$array[idgp]\"&phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0>$array[nome]</a></div>";
}
}else
{
echo"<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" width=\"100%\">";
        echo"<tr class=\"errorbox\">";
        echo"<td width=\"16\" align=\"left\" valign=\"middle\"><img src=\"images/icon_error.gif\" border=\"0\" />";
        echo"</td>";
        echo"<td align=\"left\">";
        echo"<span class=\"smalltext\">Utente NON autenticato</span>";
        echo"</td>";
        echo"</tr>";
        echo"</table>";
}
?>
                        </td>
                      </tr>
</table>
<br>

<table width="830" border="0" cellspacing="0" cellpadding="0">
  <tr bgcolor="#707070"><td height="24"><a href="index.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Home</a> | <a href="controlla_ticket.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Controlla Tickets</a> | <a href="apri_ticket.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Apri un Nuovo Ticket</a> | <a href="knowledgebase.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Knowledgebase</a> | <a href="avvisi.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Avvisi</a> | <a href="downloads.php?phpMyAdmin=v7zjFK9AGEqnRjVcycE5l%2CkeVK0" id="footerlink">Downloads</a></td>
</table>
</center>
</body>
</html>

<?
function totale($idcat){
$obj=new sast1com();
$obj->connessione();
$result = mysql_query("select * from downloads where d_cat=$idcat");
$tot=mysql_num_rows($result);
return $tot;
}

function nome($idcat){
$obj=new sast1com();
$obj->connessione();
$result = mysql_query("select * from downloads_cat where id=$idcat");
if(strlen($idcat)>0){
while($array=mysql_fetch_array($result)){
$nome=$array[nome];
}
return $nome;
}
}
?>

Come al solito grazie mille Sandro

Omar

sastgroup forum

#1 2008-02-15 12:56:17

formattazione apertura TT

#2 2008-02-15 15:28:01

Re: formattazione apertura TT

#3 2008-02-15 16:29:51

Re: formattazione apertura TT

#4 2008-02-15 20:01:48

Re: formattazione apertura TT

#5 2008-02-18 09:15:11

Re: formattazione apertura TT

Codice:

Codice:

Footer forum