📄 show_messages.php
字号:
<?
include "logincheck.php";
include_once "myconnect.php";
include_once "date_time_format.php";
$msg1="";
$to_delete="";
$items_removed=0;
if ( count($_POST)<>0 )
{
/////////////////////////// A REQUEST TO DELETE SOME CONTACTS ///////////////
if(isset($_REQUEST["cnt"]))
$cnt=$_REQUEST["cnt"];
if(isset($_REQUEST["cnt2"]))
$cnt=$_REQUEST["cnt2"];
for($i=1;$i<=$cnt;$i++)
{
if ( isset($_REQUEST["checkbox" . $i]) ) //Is the checkbox ticked
{
if ($to_delete!="") { $to_delete.="," ; } //To insert comma??
$to_delete.= $_REQUEST["checkbox" . $i]; //Add another item to delete
$items_removed++;
}
} //End For
if ($to_delete=="")
{
$msg1=" Unable to remove inquiries. ";
}
else
{
$sql0=mysql_query("select * from sbbleads_messages where sb_id IN (" . $to_delete .")");
while($rs_t0=mysql_fetch_array($sql0))
{
if($rs_t0["sb_fid"]==$_SESSION["sbbleads_userid"])
{
$del_str=" update sbbleads_messages set sb_f_del='yes' where sb_id=".$rs_t0["sb_id"];
}
if($rs_t0["sb_tid"]==$_SESSION["sbbleads_userid"])
{
$del_str=" update sbbleads_messages set sb_t_del='yes' where sb_id=".$rs_t0["sb_id"];
}
if($rs_t0["sb_tid"]==$rs_t0["sb_fid"])
{
$del_str=" update sbbleads_messages set sb_t_del='yes', sb_f_del='yes' where sb_id=".$rs_t0["sb_id"];
}
mysql_query($del_str);
}
$del_str=" Delete from sbbleads_messages where sb_f_del='yes' && sb_t_del='yes'";
mysql_query($del_str);
$msg1= ($items_removed > 1)?$items_removed . " Inquiries have been removed":$items_removed . " Inquiry has been removed";
}
header("Location:"." msg_confirm_mem.php?errmsg=".urlencode($msg1));
die();
/////////////////////////////CONTACTS HAVE BEEN REMOVED /////////////////////
}
function main()
{
$null_char[0]=mysql_fetch_array(mysql_query("select sb_null_char from sbbleads_config"));
$rs0_query=mysql_query("Select * from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_fid=sbbleads_members.sb_id and sb_f_del='No' and sb_msg_read='No' and sb_fid =" .$_SESSION["sbbleads_userid"]);
$rs0=mysql_num_rows($rs0_query);
$outgoing_new_count=$rs0;
$rs0_query=mysql_query("Select * from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_fid=sbbleads_members.sb_id and sb_f_del='No' and sb_fid =" .$_SESSION["sbbleads_userid"]);
$rs0=mysql_num_rows($rs0_query);
$outgoing_count=$rs0;
$rs0_query=mysql_query("Select * from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_tid=sbbleads_members.sb_id and sb_t_del='No' and sb_msg_read='No' and sb_tid =" .$_SESSION["sbbleads_userid"]);
$rs0=mysql_num_rows($rs0_query);
$incoming_new_count=$rs0;
$rs0_query=mysql_query("Select * from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_tid=sbbleads_members.sb_id and sb_t_del='No' and sb_tid =" .$_SESSION["sbbleads_userid"]);
$rs0=mysql_num_rows($rs0_query);
$incoming_count=$rs0;
$rs0_query=mysql_query("Select *,UNIX_TIMESTAMP(sb_onstamp) as t from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_tid=sbbleads_members.sb_id and sb_t_del='No' and sb_tid =" .$_SESSION["sbbleads_userid"] . " order by sbbleads_messages.sb_id desc ");
?>
<script language="JavaScript">
//<!--
function select_all()
{
for (var i=0;i<document.form2.elements.length;i++)
{
var e =document. form2.elements[i];
if ((e.name != 'check_all') && (e.type=='checkbox'))
{
e.checked = document.form2.check_all.checked;
}
}
}
function select_all2()
{
for (var i=0;i<document.form3.elements.length;i++)
{
var e =document. form3.elements[i];
if ((e.name != 'check_all') && (e.type=='checkbox'))
{
e.checked = document.form3.check_all.checked;
}
}
}
//-->
</script>
<script language="javascript">
//<!--
function formValidate(form) {
if(form.add_desc.value == "") {
alert('Please enter description.');
return false;
}
return true;
}
//-->
</script>
<table width="100%" border="0" cellpadding="0" cellspacing="0" dwcopytype="CopyTableRow">
<tr>
<td valign="top" > <div align="center"><font class='red'> </font> </div>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
<tr >
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0" class="innertablestyle">
<tr>
<td height="25" class="titlestyle"> Incoming Inquiries</td>
</tr>
<tr>
<td><font class='normal'>Total - <strong><font class='red'><?php echo $incoming_count; ?></font></strong>
New - <strong><font class='red'><?php echo $incoming_new_count; ?></font></strong>
</font></td>
</tr>
<tr>
<td valign="top"> <p><font class='normal'>To remove an inquiry
just click the check box and click the remove button
below.</font></p></td>
</tr>
<tr>
<td valign="top"><form name="form2" method="post" action="show_messages.php">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr class="subtitle">
<td width="10" align="right"> <input type="checkbox" name="check_all" value="yes" onClick="select_all();"></td>
<td height="25"><b><font class='normal'>Subject</font></b></td>
<td><b><font class='normal'>From User</font></b></td>
<td><b><font class='normal'>Date Received</font></b></td>
<td><b><font class='normal'>Status</font></b></td>
</tr>
<?
$cnt=0;
while ($rs0=mysql_fetch_array($rs0_query))
{
$from_mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rs0["sb_fid"]));
if ($rs0["sb_msg_read"]=="No")
{
$status="<b><font class=\"red\" >New</font>";
}
else
{
$status="Read";
}
$cnt++;
?>
<tr>
<td width="10" align="right" > <div align="right"><font class='normal'>
<input name="checkbox<?php echo $cnt;?>" type="checkbox" id="checkbox<?php echo $cnt;?>" value="<?php echo $rs0["sb_id"];?>">
</font></div></td>
<td valign="top" ><a href="read_msg.php?id=<?php echo $rs0["sb_fid"]; ?>&mid=<?php echo $rs0["sb_id"]; ?>" >
<?
if (strlen ($rs0["sb_subject"])>50)
{
echo substr($rs0["sb_subject"], 0, strrpos( substr($rs0["sb_subject"], 0, 50),' ' )) . "..";
}
else
{
echo $rs0["sb_subject"];
}
?>
</a></td>
<td valign="top" ><font class='normal'>
<?php
if($from_mem)
{
echo $from_mem["sb_username"];
}
else
{
echo $null_char[0];
}?>
</font></td>
<td valign="top" ><font class='normal'><?php echo sb_date($rs0["t"]);?></font></td>
<td valign="top" ><font class='normal'><?php echo $status;?></font></td>
</tr>
<?
}
?>
<tr>
<td colspan="5"> <input type="hidden" name="cnt" value="<?php echo $cnt; ?>">
<input type="submit" name="Submit" value="Remove">
</td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td align="center" height="25"> </td>
</tr>
<tr>
<td>
<?php
$rs0_query=mysql_query("Select *,UNIX_TIMESTAMP(sb_onstamp) as t from sbbleads_members,sbbleads_messages where sbbleads_messages.sb_fid=sbbleads_members.sb_id and sb_f_del='No' and sb_fid =" .$_SESSION["sbbleads_userid"] . " order by sbbleads_messages.sb_id desc ");
?>
</td>
</tr>
<tr>
<td valign="top"> <div align="center">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
<tr >
<td valign="top"> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0" class="innertablestyle">
<tr>
<td height="25" class="titlestyle"> Outgoing Inquiries</td>
</tr>
<tr>
<td><font class='normal'>Total - <strong><font class='red'><?php echo $outgoing_count; ?></font></strong>
Not Read - <strong><font class='red'><?php echo $outgoing_new_count; ?></font></strong>
</font></td>
</tr>
<tr>
<td valign="top"><font class='normal'>To remove an inquiry
just click the check box and click the remove button
below.</font></td>
</tr>
<tr>
<td valign="top"> <form action="show_messages.php" method="post" name="form3" id="form3">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr class="subtitle">
<td width="10" align="right"><input name="check_all" type="checkbox" id="check_all" onClick="select_all2();" value="yes">
</td>
<td height="25"><b><font class='normal'>Subject</font></b></td>
<td><b><font class='normal'>To User</font></b></td>
<td><b><font class='normal'>Date Sent</font></b></td>
<td><b><font class='normal'>Status</font></b></td>
</tr>
<?
$cnt=0;
while ($rs0=mysql_fetch_array($rs0_query))
{
$to_mem=mysql_fetch_array(mysql_query("select * from sbbleads_members where sb_id=".$rs0["sb_tid"]));
if ($rs0["sb_msg_read"]=="No")
{
$status="<b><font class=\"red\" >Not Read</font>";
}
else
{
$status="Read";
}
$cnt++;
?>
<tr>
<td width="10" align="right" > <div align="right"><font class='normal'>
<input name="checkbox<?php echo $cnt;?>" type="checkbox" id="checkbox<?php echo $cnt;?>" value="<?php echo $rs0["sb_id"];?>">
</font></div></td>
<td valign="top" ><a href="read_msg_out.php?id=<?php echo $rs0["sb_fid"]; ?>&mid=<?php echo $rs0["sb_id"]; ?>" >
<?
if (strlen ($rs0["sb_subject"])>50)
{
echo substr($rs0["sb_subject"], 0, strrpos( substr($rs0["sb_subject"], 0, 50),' ' )) . "..";
}
else
{
echo $rs0["sb_subject"];
}
?>
</a></td>
<td valign="top" ><font class='normal'>
<?php
if($to_mem)
{
echo $to_mem["sb_username"];
}
else
{
echo $null_char[0];
}?>
</font></td>
<td valign="top" ><font class='normal'><?php echo sb_date($rs0["t"]);?></font></td>
<td valign="top" ><font class='normal'><?php echo $status;?></font></td>
</tr>
<?
}
?>
<tr>
<td colspan="5"> <input type="hidden" name="cnt2" value="<?php echo $cnt; ?>">
<input type="submit" name="Submit2" value="Remove">
</td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
</table>
<?
}// end main
include "template1.php";
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -