📄 copy_sort.php
字号:
<?php
function copy_sort( $SORT_PARENT, $SORT_PARENT_NEW, $USER_ID, $MANAGE_USER, $DOWN_USER, $NEW_USER )
{
global $connection;
global $LOGIN_USER_ID;
$query = "SELECT * from FILE_SORT where SORT_PARENT='".$SORT_PARENT."'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_ID = $ROW['SORT_ID'];
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_NO = $ROW['SORT_NO'];
$SORT_TYPE = $ROW['SORT_TYPE'];
$DEPT_ID = $ROW['DEPT_ID'];
$query = "insert into FILE_SORT(SORT_TYPE,DEPT_ID,SORT_NO,SORT_PARENT,SORT_NAME,USER_ID,MANAGE_USER,DOWN_USER,NEW_USER,SHARE_USER) values ('".$SORT_TYPE."','{$DEPT_ID}','{$SORT_NO}','{$SORT_PARENT_NEW}','{$SORT_NAME}','{$USER_ID}','{$MANAGE_USER}','{$DOWN_USER}','{$NEW_USER}','{$SHARE_USER}')";
exequery( $connection, $query );
$SORT_PARENT_NEW1 = mysql_insert_id( );
$query = "SELECT * from FILE_CONTENT where SORT_ID=".$SORT_ID;
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
$CONTENT_NO = $ROW['CONTENT_NO'];
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $ATTACHMENT_ID != "" && $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID = copy_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME, "", "file_folder", "file_folder" ).",";
}
$query = "insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values (".$SORT_PARENT_NEW1.",'{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}','{$ATTACHMENT_DESC}','{$USER_ID}','{$CONTENT_NO}')";
exequery( $connection, $query );
}
copy_sort( $SORT_ID, $SORT_PARENT_NEW1, $USER_ID, $MANAGE_USER, $DOWN_USER, $NEW_USER );
}
}
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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\" onload=\"\">\r\n";
if ( !stristr( $HTTP_REFERER, "/general/file_folder/index.php" ) )
{
exit( );
}
if ( $SORT == 0 )
{
$query = "SELECT * from FILE_CONTENT where find_in_set(CONTENT_ID,'".$FILE_STR."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
$USER_ID = $ROW['USER_ID'];
$CONTENT_NO = $ROW['CONTENT_NO'];
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $SORT_PARENT == 0 )
{
$USER_ID = $LOGIN_USER_ID;
}
if ( $ATTACHMENT_ID != "" && $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID = copy_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME, "", "file_folder", "file_folder" ).",";
}
$query = "insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values ('".$SORT_PARENT."','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}','{$ATTACHMENT_DESC}','{$USER_ID}','{$CONTENT_NO}')";
exequery( $connection, $query );
}
}
else if ( $SORT == 1 )
{
$query = "SELECT * from FILE_SORT where SORT_ID='".$SORT_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SORT_NAME = $ROW['SORT_NAME'];
$SORT_NO = $ROW['SORT_NO'];
$SORT_TYPE = $ROW['SORT_TYPE'];
$DEPT_ID = $ROW['DEPT_ID'];
$USER_ID_PARENT = $ROW['USER_ID'];
$MANAGE_USER_PARENT = $ROW['MANAGE_USER'];
$DOWN_USER_PARENT = $ROW['DOWN_USER'];
$NEW_USER_PARENT = $ROW['NEW_USER'];
if ( $SORT_PARENT == 0 )
{
$USER_ID_PARENT = $LOGIN_USER_ID;
$SORT_TYPE = 4;
}
else
{
$query = "SELECT * from FILE_SORT where SORT_ID='".$SORT_PARENT."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID_PARENT = $ROW['USER_ID'];
$MANAGE_USER_PARENT = $ROW['MANAGE_USER'];
$DOWN_USER_PARENT = $ROW['DOWN_USER'];
$NEW_USER_PARENT = $ROW['NEW_USER'];
}
}
$query = "insert into FILE_SORT(SORT_TYPE,DEPT_ID,SORT_NO,SORT_PARENT,SORT_NAME,USER_ID,MANAGE_USER,DOWN_USER,NEW_USER,SHARE_USER) values ('".$SORT_TYPE."','{$DEPT_ID}','{$SORT_NO}','{$SORT_PARENT}','{$SORT_NAME}','{$USER_ID_PARENT}','{$MANAGE_USER_PARENT}','{$DOWN_USER_PARENT}','{$NEW_USER_PARENT}','{$SHARE_USER}')";
exequery( $connection, $query );
$SORT_PARENT_NEW = mysql_insert_id( );
$query = "SELECT * from FILE_CONTENT where SORT_ID=".$SORT_ID;
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$ATTACHMENT_ID = $ROW['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $ROW['ATTACHMENT_NAME'];
$ATTACHMENT_DESC = $ROW['ATTACHMENT_DESC'];
$CONTENT_NO = $ROW['CONTENT_NO'];
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $SORT_PARENT == 0 )
{
$USER_ID = $LOGIN_USER_ID;
}
if ( $ATTACHMENT_ID != "" && $ATTACHMENT_NAME != "" )
{
$ATTACHMENT_ID = copy_attach( $ATTACHMENT_ID, $ATTACHMENT_NAME, "", "file_folder", "file_folder" ).",";
}
$query = "insert into FILE_CONTENT(SORT_ID,SUBJECT,CONTENT,SEND_TIME,ATTACHMENT_ID,ATTACHMENT_NAME,ATTACHMENT_DESC,USER_ID,CONTENT_NO) values (".$SORT_PARENT_NEW.",'{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$ATTACHMENT_ID}','{$ATTACHMENT_NAME}','{$ATTACHMENT_DESC}','{$USER_ID}','{$CONTENT_NO}')";
exequery( $connection, $query );
}
copy_sort( $SORT_ID, $SORT_PARENT_NEW, $USER_ID_PARENT, $MANAGE_USER_PARENT, $DOWN_USER_PARENT, $NEW_USER_PARENT );
}
}
echo "<script Language=\"JavaScript\">\r\n";
if ( $SORT == 1 )
{
echo " parent.file_tree.location.reload();\r\n";
}
echo " window.location=\"folder.php?SORT_ID=";
echo $SORT_ID;
echo "&FILE_SORT=";
echo $FILE_SORT;
echo "&PAGE_START=";
echo $PAGE_START;
echo "\";\r\n</script>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -