📄 clone.php
字号:
<?php
include_once( "inc/auth.php" );
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
if ( $LOGIN_USER_PRIV != "1" )
{
$query = "SELECT * from VOTE_TITLE where PARENT_ID=0 and FROM_ID='".$LOGIN_USER_ID."'";
}
else
{
$query = "SELECT * from VOTE_TITLE where PARENT_ID=0";
}
$query .= " and find_in_set(VOTE_ID, '".$DELETE_STR."')";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$VOTE_ID = $ROW['VOTE_ID'];
$TO_ID = $ROW['TO_ID'];
$PRIV_ID = $ROW['PRIV_ID'];
$USER_ID = $ROW['USER_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$MAX_NUM = $ROW['MAX_NUM'];
$ANONYMITY = $ROW['ANONYMITY'];
$VIEW_PRIV = $ROW['VIEW_PRIV'];
$BEGIN_DATE = $ROW['BEGIN_DATE'];
$END_DATE = $ROW['END_DATE'];
$PUBLISH = $ROW['PUBLISH'];
$VOTE_NO = $ROW['VOTE_NO'];
$SUBJECT .= " - 复制";
$query = "insert into VOTE_TITLE(FROM_ID,PARENT_ID,TO_ID,PRIV_ID,USER_ID,SUBJECT,CONTENT,SEND_TIME,BEGIN_DATE,END_DATE,TYPE,MAX_NUM,ANONYMITY,VIEW_PRIV,PUBLISH,VOTE_NO) values ('".$LOGIN_USER_ID."','0','{$TO_ID}','{$PRIV_ID}','{$USER_ID}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$BEGIN_DATE}','{$END_DATE}','{$TYPE}',{$MAX_NUM},'{$ANONYMITY}','{$VIEW_PRIV}','{$PUBLISH}','{$VOTE_NO}')";
exequery( $connection, $query );
$VOTE_ID_NEW = mysql_insert_id( );
$query = "SELECT ITEM_NAME from VOTE_ITEM where VOTE_ID='".$VOTE_ID."'";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$ITEM_NAME = $ROW['ITEM_NAME'];
$query = "insert into VOTE_ITEM (VOTE_ID,ITEM_NAME) values ('".$VOTE_ID_NEW."','{$ITEM_NAME}')";
exequery( $connection, $query );
}
$query = "SELECT * from VOTE_TITLE where PARENT_ID='".$VOTE_ID."'";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$VOTE_ID_SUB = $ROW['VOTE_ID'];
$SUBJECT = $ROW['SUBJECT'];
$CONTENT = $ROW['CONTENT'];
$TYPE = $ROW['TYPE'];
$MAX_NUM = $ROW['MAX_NUM'];
$VOTE_NO = $ROW['VOTE_NO'];
$query = "insert into VOTE_TITLE(FROM_ID,PARENT_ID,SUBJECT,CONTENT,SEND_TIME,TYPE,MAX_NUM,VOTE_NO) values ('".$LOGIN_USER_ID."','{$VOTE_ID_NEW}','{$SUBJECT}','{$CONTENT}','{$SEND_TIME}','{$TYPE}',{$MAX_NUM},'{$VOTE_NO}')";
exequery( $connection, $query );
$VOTE_ID_SUB_NEW = mysql_insert_id( );
$query = "SELECT ITEM_NAME from VOTE_ITEM where VOTE_ID='".$VOTE_ID_SUB."'";
$cursor2 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor2 ) )
{
$ITEM_NAME = $ROW['ITEM_NAME'];
$query = "insert into VOTE_ITEM (VOTE_ID,ITEM_NAME) values ('".$VOTE_ID_SUB_NEW."','{$ITEM_NAME}')";
exequery( $connection, $query );
}
}
}
header( "location: index1.php?start=".$start );
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -