[Serusers] message_store.php problem

Meidiana Ten gotcha_em at yahoo.com
Sun Nov 26 10:22:23 CET 2006 

Hi,
I've solve the problem of DNS so now my serweb can send IM successfully through SERWeb. But when I need to see the IM from message store tab on SERWeb, it shows nothing (only blank page on the tab).

Below is my message_store.php:


<?

/*

 * $Id: message_store.php,v 1.3 2003/10/13 19:56:43 kozlik Exp $

 */

 

require "prepend.php";

require "/var/www/phplib/oohforms.inc";

 

put_headers();

 

page_open (array("sess" => "phplib_Session",

                                "auth" => "phplib_Auth"));

 

class Cinst_mess{

        var $mid, $src_addr, $time, $body;

        function Cinst_mess($mid, $src_addr, $time, $body){

               $this->mid=$mid;

               $this->src_addr=$src_addr;

               $this->time=$time;

               $this->body=$body;

        }

}

 

class Cvoice_mess{

        var $mid, $src_addr, $time, $subject, $file;

        function Cvoice_mess($mid, $src_addr, $time, $subject, $file){

               $this->mid=$mid;

               $this->src_addr=$src_addr;

               $this->time=$time;

               $this->subject=$subject;

               $this->file=$file;

        }

}

 

do{

        $db = connect_to_db();

        if (!$db){ $errors[]="can't connect to sql server"; break;}

 

        if (isset($dele_im)){

               $q="select from ".$config->table_message_silo." where mid=$dele_im and r_uri like 'sip:".$auth->auth["uname"]."@".$config->default_domain."%'";

               $res=mySQL_query($q);

               if (!$res) {$errors[]="error in SQL query, line: ".__LINE__;}

 

               Header("Location: ".$sess->url("message_store.php?kvrk=".uniqID("")));

               page_close();

               exit;

        }

 

        if (isset($dele_vm)){

               $q="select file from ".$config->table_voice_silo." where mid=".$dele_vm." and r_uri like 'sip:".$auth->auth["uname"]."@".$config->default_domain."%'";

               $res=mySQL_query($q);

               if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; break;}

               if (!MySQL_num_rows($res)) {$errors[]="Message not found or you haven't access to message"; break;}

               $row=MySQL_Fetch_Object($res);

 

               @unlink($config->voice_silo_dir.$row->file);

 

               $q="delete from ".$config->table_voice_silo." where mid=$dele_vm";

               $res=mySQL_query($q);

               if (!$res) {$errors[]="error in SQL query, line: ".__LINE__;}

 

               Header("Location: ".$sess->url("message_store.php?kvrk=".uniqID("")));

               page_close();

               exit;

        }

}while(false);

 

do{

//      if ($db){

        if ($config->show_message_silo) {

               $q="select mid, src_addr, inc_time, body from ".

                       $config->table_message_silo.

                       " where r_uri like 'sip:".$auth->auth["uname"].

                       "@".$config->default_domain."%'";

               $im_res=mySQL_query($q);

               if (!$im_res) {$errors[]="error in SQL query, line: ".__LINE__; break;}

 

               while ($row=MySQL_Fetch_Object($im_res)){

                       $im_arr[]=new Cinst_mess($row->mid, $row->src_addr,

                               $row->inc_time, $row->body);

               }

 

               if ($config->show_voice_silo) {

                       $q="select mid, src_addr, inc_time, subject, file from ".

                               $config->table_voice_silo." where r_uri like 'sip:".

                               $auth->auth["uname"]."@".$config->default_domain."%'";

                       $vm_res=mySQL_query($q);

                       if (!$vm_res) {

                               $errors[]="error in SQL query, line: ".__LINE__;

                               break;

                       }

                       while ($row=MySQL_Fetch_Object($vm_res)){

                               $vm_arr[]=new Cvoice_mess($row->mid, $row->src_addr,

                                      $row->inc_time, $row->subject, $row->file);

                       }

               }

               set_timezone($errors);

        }

 

}while (false);

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title><?echo $config->title;?></title>

<?print_html_head();?>

 

        <style type="text/css">

        <!--

        .msgtitle{

               color: black;

               font-family: Verdana, Arial, Helvetica, sans-serif;

               font-size: 13px;

               font-style: normal;

               font-weight: bold ;

        }

        .msgtitle:visited{

               color: black;

        }

        .msgtitle:active{

               color: black;

        }

        .msgtitle:hover{

               color: black;

        }

        -->

        </style>

</head>

<?

        print_html_body_begin(7, true, true, get_user_name($errors));

        echo "<br>";

        print_errors($errors);                    // Display error

        print_message($message);

?>

 

 

<table border="0" cellspacing="0" cellpadding="0" align="center">

<tr><td class="title" width="502">Instant messages store:</td></tr>

</table><br>

 

<?if (isset($im_arr)){?>

<table border="0" cellspacing="0" cellpadding="0" align="center">

<?foreach($im_arr as $row){

        if (date('Y-m-d',$row->time)==date('Y-m-d')) $time="today ".date('H:i',$row->time);

        else $time=date('Y-m-d H:i',$row->time)

?>

<tr><td>

        <table border="0" cellspacing="0" cellpadding="2" bgcolor="#C1D773">

        <tr><td>

               <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">

               <tr bgcolor="#B1C9DC" valign="top">

               <td width="245" class="msgtitle"><?echo $row->src_addr;?></td>

               <td align="right" width="135" class="msgtitle"><?echo $time;?></td>

               <td align="center" width="60" class="msgtitle"><a href="<?$sess->purl("send_im.php?kvrk=".uniqid("")."&sip_addr=".rawURLEncode($row->src_addr));?>" class="msgtitle">reply</a></td>

               <td align="center" width="60" class="msgtitle"><a href="<?$sess->purl("message_store.php?kvrk=".uniqid("")."&dele_im=".rawURLEncode($row->mid));?>" class="msgtitle">delete</a></td>

               </tr>

 

               <tr>

               <td colspan="4" width="500"><?echo $row->body;?></td>

               </tr>

               </table>

        </td></tr>

        </table>

</td></tr>

<tr><td>&nbsp;</td></tr>

<?}?>

</table>

 

<?}else{?>

<div align="center">No stored instant messages</div>

<br>

<?}?>

 

<?if ($default->show_voice_silo) {?>

 

<table border="0" cellspacing="0" cellpadding="0" align="center">

<tr><td class="title" width="502">Voicemail messages store:</td></tr>

</table><br>

 

<?if (isset($vm_arr)){?>

<table border="0" cellpadding="2" cellspacing="0" bgcolor="#C1D773" align="center">

<tr><td>

        <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" align="center">

        <tr>

        <td class="titleT" width="139">calling subscriber</td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

        <td class="titleT" width="160">subject</td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

        <td class="titleT" width="135">time</td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

        <td class="titleT" width="60">&nbsp;</td>

        </tr>

        <tr><td colspan="7" height="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td></tr>

        <?foreach($vm_arr as $row){

               if (date('Y-m-d',$row->time)==date('Y-m-d')) $time="today ".date('H:i',$row->time);

               else $time=date('Y-m-d H:i',$row->time)

        ?>

        <tr valign="top">

        <td align="left" class="f12" width="139"><a href="<?$sess->purl("send_im.php?kvrk=".uniqid("")."&sip_addr=".rawURLEncode($row->src_addr));?>"><?echo htmlspecialchars($row->src_addr);?></a></td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

 

        <td align="left" class="f12" width="160"><a href="<?$sess->purl("ms_get_v_msg.php?kvrk=".uniqid("")."&mid=".rawURLEncode($row->mid));?>"><?echo $row->subject;?></a></td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

        <td align="center" class="f12" width="135"><?echo $time;?></td>

        <td width="2" bgcolor="#C1D773"><img src="<?echo $config->img_src_path;?>title/green_pixel.gif" width="2" height="2"></td>

        <td align="center" class="f12" width="60"><a href="<?$sess->purl("message_store.php?kvrk=".uniqid("")."&dele_vm=".rawURLEncode($row->mid));?>" class="msgtitle">delete</a></td>

        </tr>

        <?}?>

        </table>

</td></tr>

</table>

 

<?}else{?>

<div align="center">No stored voicemail messages</div>

<?}?>

<?}?>

 

<br>

<?print_html_body_end();?>

</html>

<?page_close();?>
  

Please tell me what's the problem.
 Thanx
 
 Regards,
 
 Meidiana
  
 
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20061126/2d5a38a0/attachment.htm>

More information about the sr-users mailing list