📄 delete.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_file.php" );
ob_end_clean( );
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from PROJ_BUG WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_NAME != "" )
{
delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
}
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from PROJ_FILE WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_NAME != "" )
{
delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
}
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from PROJ_FORUM WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_NAME != "" )
{
delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
}
$query = "select TASK_ID from PROJ_TASK WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$TASK_STR .= $ROW['TASK_ID'].",";
}
if ( $TASK_STR != "" )
{
$TASK_STR = substr( $TASK_STR, 0, -1 );
$query = "select ATTACHMENT_ID,ATTACHMENT_NAME from PROJ_TASK_LOG WHERE TASK_ID IN (".$TASK_STR.")";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
if ( $ATTACHMENT_NAME != "" )
{
delete_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME );
}
}
$query = "delete from PROJ_TASK_LOG WHERE TASK_ID IN (".$TASK_STR.")";
exequery( $connection, $query );
}
$query = "delete from PROJ_FILE WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_FILE_SORT WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_BUG WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_FORUM WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_TASK WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_COMMENT WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
$query = "delete from PROJ_PROJECT WHERE PROJ_ID IN (".$PROJ_ID_STR.")";
exequery( $connection, $query );
echo $PROJ_ID_STR;
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -