ÀÏÁ¤½Ã°£ ÀÌ Áö³ °Ô½Ã¹° Á¤¸®Çϱâ |
|
|
|
12³â Àü
|
1. ¾Æ·¡¿Í °°ÀÌ ÆÄÀÏÀ» ¸¸µé¾î phpÆÄÀÏ·Î ÀúÀåÇÑ´Ù.
#!/usr/local/php/bin/php
<?
$dbhost="È£½ºÆ®À̸§";
$dbuser="µðºñ¾ÆÀ̵ð";
$dbpass="µðºñÆнº";
$dbname="µðºñÀ̸§";
//DB connect
$connect=mysql_connect($dbhost,$dbuser,$dbpass) or die("<script>alert(' DB CONNECT ERROR ');</script>");
mysql_select_db($dbname,$connect);
//½ÇÇàÀ» À§ÇÑ Å×À̺í¸í Á¤ÀÇ..
$Clear_board=array(
"essay" => true,
//"art" => true,
//"theme" => true,
//"plant" => true,
//"jujea" => true,
//"member" => true,
);
$admin_query=mysql_query("select * from zetyx_admin_table order by no desc",$connect);
$dbtotal=mysql_num_rows($admin_query);
$nowy=date("Y",time());
$nowm=date("m",time());
$nowd=date("d",time());
//2´ÞÀÌ Áö³ °Ô½Ã¹°Àº »èÁ¦ÇÑ´Ù.
$bbbfmonthdate=mktime(0,0,0,$nowm -1,1,$nowy);
for($i=1;$i<=$dbtotal;$i++){
$adminRow=mysql_fetch_array($admin_query);
if($Clear_board[$adminRow[name]] == true){
$boardtable="zetyx_board_".$adminRow[name];
$commenttable="zetyx_board_comment_".$adminRow[name];
$boardname=$adminRow[name];
$bQuery=mysql_query("select * from $boardtable where reg_date < $bbbfmonthdate and depth=0 order by no desc",$connect);
if(mysql_num_rows($bQuery)>0){
$bTotal=mysql_num_rows($bQuery);
for($k=1;$k<=$bTotal;$k++){
$bRow=mysql_fetch_array($bQuery);
### ´ä±Û Áö¿ì±â..
$reQuery=mysql_query("select * from $boardtable where father=$bRow[no]",$connect);
if(mysql_num_rows($reQuery)>0){
$retotal=mysql_num_rows($reQuery);
for($j=1;$j<=$retotal;$j++){
$reRow=mysql_fetch_array($reQuery);
// ÆÄÀÏÁö¿ì±â..
if($reRow[file_name1] and file_exists("/home/ID/public_html/zboard/$reRow[file_name1]")){
unlink("/home/ID/public_html/zboard/$reRow[file_name1]");
}
if($reRow[file_name2] and file_exists("/home/ID/public_html/zboard/$reRow[file_name2]")){
unlink("/home/ID/public_html/zboard/$reRow[file_name2]");
}
if($reRow[s_file_name1] and file_exists("/home/ID/public_html/zboard/$reRow[s_file_name1]")){
unlink("/home/ID/public_html/zboard/$reRow[s_file_name1]");
}
if($reRow[s_file_name2] and file_exists("/home/ID/public_html/zboard/$reRow[s_file_name2]")){
unlink("/home/ID/public_html/zboard/$reRow[s_file_name2]");
}
} //for
} //if
### ¿ø¹® ÆÄÀÏ Áö¿ì±â..
if($bRow[file_name1] and file_exists("/home/ID/public_html/zboard/$bRow[file_name1]")){
unlink("/home/ID/public_html/zboard/$bRow[file_name1]");
}
if($bRow[file_name2] and file_exists("/home/ID/public_html/zboard/$bRow[file_name2]")){
unlink("/home/ID/public_html/zboard/$bRow[file_name2]");
}
if($bRow[s_file_name1] and file_exists("/home/ID/public_html/zboard/$bRow[s_file_name1]")){
unlink("/home/ID/public_html/zboard/$bRow[s_file_name1]");
}
if($bRow[s_file_name2] and file_exists("/home/ID/public_html/zboard/$bRow[s_file_name2]")){
unlink("/home/ID/public_html/zboard/$bRow[s_file_name2]");
}
// µðºñÁö¿ì±â
mysql_query("Delete from $boardtable where no=$bRow[no]",$connect);
mysql_query("Delete from $boardtable where father=$bRow[no]",$connect);
mysql_query("Delete from $commenttable where parent=$bRow[no]",$connect);
} //for
} //if
$nquery=mysql_query("select * from $boardtable",$connect);
$nTotal=mysql_num_rows($nquery);
mysql_query("update zetyx_admin_table set total_article=$nTotal where name='$adminRow[name]'",$connect);
} //if
} //for
mysql_close($connect);
?>
2. À§ ÆÄÀÏÀÇ ÀúÀåÀÌ ³¡³µÀ¸¸é ÀÚµ¿À¸·Î ½ÇÇàµÉ ¼ö ÀÖµµ·Ï
#!/bin/bash
/À§/ÆÄÀÏ/°æ·Î/ÆÄÀϸí
°°ÀÌ ÇÏ¿© /etc/cron.monthly/ ¿¡ È®ÀåÀÚ¾ø´Â ÆÄÀϸí(¿¹ : ZboardClear )À¸·Î ÀúÀåÇÏ°í
#chmod 700 /etc/cron.monthly/ZboardClear ¸í·ÉÀ¸·Î ·çÆ®¸¸ÀÌ ½ÇÇàÇÒ ¼ö ÀÖ´Â ±ÇÇÑÀ» ÁØ´Ù.
¶Ç´Â crontab¿¡ Ãß°¡Çصµ µÈ´Ù.
|
|
̵̧ : 571 |
̵̧
¸ñ·Ï
|
|