📄 index.php
字号:
<?php
include_once( "../auth.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title>内部短信</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n<body>\r\n<font color=blue size=+2><b>未确认短信</b></font> \r\n<a href=\"edit.php?P=";
echo $P;
echo "\">写新短信</a>\r\n<br><br>\r\n\r\n";
$CUR_TIME = date( "Y-m-d H:i:s", time( ) );
$query = "SELECT * from SMS where TO_ID='".$LOGIN_USER_ID."' and SEND_TIME<='{$CUR_TIME}' and REMIND_FLAG=1 order by SEND_TIME desc";
$cursor = exequery( $connection, $query );
$SMS_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$SMS_COUNT;
if ( 20 < $SMS_COUNT )
{
break;
}
$SMS_ID = $ROW['SMS_ID'];
$SMS_ID_STR .= $SMS_ID.",";
$FROM_ID = $ROW['FROM_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$REMIND_FLAG = $ROW['REMIND_FLAG'];
$SMS_TYPE = $ROW['SMS_TYPE'];
$CONTENT = $ROW['CONTENT'];
$CONTENT = str_replace( "<", "<", $CONTENT );
$CONTENT = str_replace( ">", ">", $CONTENT );
$CONTENT = stripslashes( $CONTENT );
$query1 = "SELECT * from USER where USER_ID='".$FROM_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$FROM_NAME = $ROW['USER_NAME'];
}
else
{
$FROM_NAME = $FROM_ID;
}
echo "\r\n";
echo $SMS_COUNT;
echo ".";
echo $FROM_NAME;
echo "：";
echo $CONTENT;
echo "<br>\r\n<i>";
echo $SEND_TIME;
echo "</i>\r\n<a href=\"edit.php?P=";
echo $P;
echo "&TO_NAME=";
echo $FROM_NAME;
echo "\"> 回复</a> \r\n<a href=\"delete.php?P=";
echo $P;
echo "&SMS_ID=";
echo $SMS_ID;
echo "\"> 删除</a>\r\n<hr>\r\n";
}
if ( $SMS_COUNT == 0 )
{
echo "无新短信";
}
echo "\r\n<a href=\"../main.php?P=";
echo $P;
echo "\">返回</a>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -