zboard.php ÆÄÀÏÀÇ ¿ôºÎºÐÀÇ ¼Ò½º¸¦ ¾Æ·¡Ã³·³ ¼öÁ¤ÇÕ´Ï´Ù.
/***************************************************************************
* °øÅë ÆÄÀÏ include
**************************************************************************/
include "_head.php";
/***************************************************************************
* °Ô½ÃÆÇ ¼³Á¤ üũ
**************************************************************************/
$iid="aaa";//Àû¿ëÇÒ °Ô½ÃÆÇ¾ÆÀ̵𸦠ÀÔ·ÂÇϼ¼¿ä.
$ty=date("Y");
$tm=date("m");
$td=date("d");
$tw=date("w");//0,1,2,3,4,5,6-->ÀÏ,¿ù,È,¼ö,¸ñ,±Ý,Åä
$ti=mktime("0,0,0,$tm,$td,$ty");//¿À´Ã 0½Ã
$ti2=$ti-86400*7;//3ÀÏÀü 0½Ã, 3À» ´Ù¸¥ ¼ýÀÚ·Î ¹Ù²Ù¾î »ç¿ë°¡´É.
if(($id==$iid)($tw==6)){
$data=mysql_query("select * from $t_board"."_$id where reg_date<'$ti2' headnum>'-2000000000' ismember!=1", $connect);
while($data11=mysql_fetch_array($data)){
// ÆÄÀÏ»èÁ¦
@unlink("./".$data11[file_name1]);
@unlink("./".$data11[file_name2]);
}
//7ÀÏÀü °Ô½Ã¹° °¡Á®¿À±â(°ü¸®ÀÚ,°øÁö»çÇ× Á¦¿Ü)
$data=mysql_query("select * from $t_board"."_$id where reg_date<'$ti2' headnum>'-2000000000' ismember!=1", $connect);
while($data2=mysql_fetch_array($data)){
//°Ô½Ã¹° »èÁ¦
$query="delete from $t_board"."_$id where no='$data2[no]'";
mysql_query($query, $connect);
//ÄÚ¸àÆ®»èÁ¦
$query="delete from $t_comment"."_$id where parent='$data2[no]'";
mysql_query($query, $connect);
}
//Ä«Å×°í¸® Á¤¸®
$data=mysql_query("select * from $t_category"."_$id", $connect);
while($data3=mysql_fetch_array($data)){
if($data3[no])$temp=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id where category='$data3[no]'"));
$total2=$temp[0];
$temp3=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id"));
$total3=$temp3[0];
// °³¼ö ¾÷µ¥ÀÌÆ®
mysql_query("update $t_category"."_$id set num='$total2' where no='$data3[no]'") or Error(mysql_error());
mysql_query("update $t_division"."_$id set num='$total3' where no=1") or Error(mysql_error());
mysql_query("update $admin_table set total_article='$total3' where name='$id'") or Error(mysql_error());
}
}
// »ç¿ë±ÇÇÑ Ã¼Å© |
|