📄 clear.php
字号:
<?php
include_once( "inc/auth.php" );
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "SELECT VOTE_ID from VOTE_TITLE where PARENT_ID=0 and FROM_ID='".$LOGIN_USER_ID."'";
}
else
{
$query = "SELECT VOTE_ID from VOTE_TITLE where PARENT_ID=0";
}
$query .= " and find_in_set(VOTE_ID, '".$DELETE_STR."')";
$update_query = "update VOTE_TITLE set READERS='' where ".substr( $query, 37 );
exequery( $connection, $update_query );
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$VOTE_ID = $ROW['VOTE_ID'];
$query = "SELECT ITEM_ID from VOTE_ITEM where VOTE_ID='".$VOTE_ID."'";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$query = "delete from VOTE_DATA where ITEM_ID='".$ITEM_ID."'";
exequery( $connection, $query );
}
$query = "update VOTE_ITEM set VOTE_COUNT=0, VOTE_USER='' where VOTE_ID='".$VOTE_ID."'";
exequery( $connection, $query );
$query = "SELECT VOTE_ID from VOTE_TITLE where PARENT_ID='".$VOTE_ID."'";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$VOTE_ID_SUB = $ROW['VOTE_ID'];
$query = "SELECT ITEM_ID from VOTE_ITEM where VOTE_ID='".$VOTE_ID_SUB."'";
$cursor2 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$query = "delete from VOTE_DATA where ITEM_ID='".$ITEM_ID."'";
exequery( $connection, $query );
}
$query = "update VOTE_ITEM set VOTE_COUNT=0, VOTE_USER='' where VOTE_ID='".$VOTE_ID_SUB."'";
exequery( $connection, $query );
}
$query = "update VOTE_TITLE set READERS='' where PARENT_ID='".$VOTE_ID."'";
exequery( $connection, $query );
}
header( "location: index1.php?start=".$start );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -