26 Nov
2006
26 Nov
'06
12:22 p.m.
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"].
"(a)".$config->default_domain."%'"t_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"]."(a)".$config->default_domain."%'"ig->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> </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"> </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.