?? index.php.bak
字號:
<?
include_once '../auth.php';
$CUR_DATE = date ('Y-m-d', time ());
$query = "SELECT count(*) from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and READ_FLAG='0' and (DELETE_FLAG='0' or DELETE_FLAG='2')";
$cursor= exequery($connection,$query);
$NEW_LETER_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$NEW_LETER_COUNT=$ROW[0];
if($NEW_LETER_COUNT==0){$ALL=1;
}
echo '
<html>
<head>
<title>內部郵件</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<font color=blue size=+2><b>';
echo $NEW_LETER_COUNT;
echo '封新郵件</b></font>
<br><br>
';
$query = "SELECT * from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID='$BOX_ID' and READ_FLAG='0' and TO_ID='$LOGIN_USER_ID' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') order by READ_FLAG,SEND_TIME desc";
$cursor = exequery ($connection, $query);
$EMAIL_COUNT = 0;
while ($ROW = mysql_fetch_array ($cursor))
{
++$EMAIL_COUNT;
if (20 < $EMAIL_COUNT)
{
break;
}
$EMAIL_ID = $ROW['EMAIL_ID'];
$FROM_ID = $ROW['FROM_ID'];
$SEND_TIME = $ROW['SEND_TIME'];
$IMPORTANT = $ROW['IMPORTANT'];
if (($IMPORTANT == '0' OR $IMPORTANT == ''))
{
$IMPORTANT_DESC = '';
}
else
{
if ($IMPORTANT == '1')
{
$IMPORTANT_DESC = '<font color=red>重要</font>';
}
else
{
if ($IMPORTANT == '2')
{
$IMPORTANT_DESC = '<font color=red>非常重要</font>';
}
}
}
$SUBJECT = $ROW['SUBJECT'];
$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 '
';
echo $EMAIL_COUNT;
echo '.';
echo $FROM_NAME;
echo '：';
echo $SUBJECT;
echo ' ';
echo $IMPORTANT_DESC;
echo '<br>
<i>';
echo $SEND_TIME;
echo '</i>
<a href="read.php?P=';
echo $P;
echo '&EMAIL_ID=';
echo $EMAIL_ID;
echo '"> 閱讀</a>
<hr>
';
}
if ($EMAIL_COUNT == 0)
{
echo '無新郵件';
}
echo '
<a href="./all.php?P=';
echo $P;
echo '">全部郵件</a>';
echo '
<a href="../main.php?P=';
echo $P;
echo '">返回</a>
'<br>;
$CUR_TIME=date("Y-m-d H:i:s",time());
echo $CUR_TIME;
echo '
</body>
</html>
';
?>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -