clear.php

通达OA官方提供的30源代码,感觉很实在

<?
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");
?>