📄 delete_sms.php
字号:
<?php
include_once( "inc/auth.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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\r\n";
$query = "select SMS_ID,SMS.BODY_ID from SMS,SMS_BODY where SMS.BODY_ID=SMS_BODY.BODY_ID and DELETE_FLAG='1' and FROM_ID='".$LOGIN_USER_ID."'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SMS_ID = $ROW['SMS_ID'];
$BODY_ID = $ROW['BODY_ID'];
$query1 = "select count(*) from SMS where BODY_ID='".$BODY_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$GROUP_COUNT = $ROW[0];
}
$SMS_ID_STR .= $SMS_ID.",";
if ( $GROUP_COUNT <= 1 )
{
$BODY_ID_STR .= $BODY_ID.",";
}
}
$query = "delete from SMS where find_in_set(SMS_ID,'".$SMS_ID_STR."')";
exequery( $connection, $query );
$query = "delete from SMS_BODY where find_in_set(BODY_ID,'".$BODY_ID_STR."')";
exequery( $connection, $query );
header( "location: index.php?start=".$start );
echo "\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -