ȸ¿ø°¡ÀԡžÆÀ̵ð/ºñ¹øã±â
ȨÀ¸·Î

ÀÏÁ¤½Ã°£ ÀÌ Áö³­ °Ô½Ã¹° Á¤¸®Çϱâ
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¿¡ Ãß°¡Çصµ µÈ´Ù.
ÃßõÃßõ : 566 Ãßõ ¸ñ·Ï
¹øÈ£ Á¦¸ñ
2,885
input ÀÔ·Â ÇÊµå ¾ÕµÚ °ø¹é ½Ç½Ã°£ Á¦°Å
2,884
Placeholder Æ÷Ä¿½º½Ã °¨Ãß±â
2,883
MySQL Áߺ¹µÈ µ¥ÀÌÅ͸¦ »èÁ¦
2,882
MySQL Áߺ¹ µ¥ÀÌÅÍ È®ÀÎ
2,881
sessionStorage.getItem ¿Í sessionStorage.setItem
2,880
Á¦ÀÌÄõ¸® ·£´ýÀ¸·Î ¹è°æ»ö º¯°æ
2,879
preg match¿¡ °üÇÑ Á¤±Ô½Ä
2,878
Stream an audio file with MediaPlayer ¿Àµð¿À ÆÄÀÏ ½ºÆ®¸®¹Ö Çϱâ
2,877
Audio Streaming PHP Code
2,876
PHP $ SERVER ȯ°æ º¯¼ö Á¤¸®
2,875
Vimeo (ºñ¸Þ¿À) API ¸¦ »ç¿ëÇÏ¿© Ç÷¹À̾î ÄÁÆ®·ÑÇϱâ
2,874
iframe »ç¿ë½Ã ÇÏ´Ü¿¡ ¹ß»ýÇÏ´Â °ø¹é Á¦°Å¹æ¹ý
2,873
¾ÆÀÌÇÁ·¹ÀÓ(iframe) Àüüȭ¸é °¡´ÉÇÏ°Ô Çϱâ
2,872
ºÎÆ®½ºÆ®·¦(bootstrapk)¿¡¼­ »ç¿ëÇÏ´Â class¸í Á¤¸®
2,871
ºÎÆ®½ºÆ®·¦ CSS
2,870
Å©·Ò¿¡¼­ ¸¶Áø Á¶Àý
2,869
PHP ÇöÀç ÆäÀÌÁöÀÇ µµ¸ÞÀθíÀ̳ª urlµîÀÇ Á¤º¸ ¾Ë¾Æ¿À±â
2,868
PHP preg match all()
2,867
PHP ·Î À¥ÆäÀÌÁö ±Ü¾î¿À±â ¸ðµç ¹æ¹ý ÃÑÁ¤¸®!
2,866
[PHP] ¿ø°ÝÁö ÆÄÀÏ ÁÖ¼Ò ³ëÃâ ¾ÈÇÏ°í curl·Î ´Ù¿î·Îµå ¹Þ±â
2,865
PHP ÇÔ¼ö Á¤¸®
2,864
¾ÆÀÌÇÁ·¹ÀÓ(iframe) ºñÀ² À¯ÁöÇϸ鼭 Å©±â Á¶ÀýÇÏ´Â ¹æ¹ý
2,863
PHP ¹è¿­¿¡¼­ ¹«ÀÛÀ§·Î Çϳª »Ì¾ÆÁÖ´Â array rand() ÇÔ¼ö
2,862
PHP Á¤±Ô½Ä Á¤¸®
2,861
PHP Á¤±Ô½ÄÀ» È°¿ëÇÑ ÅÂ±× ¹× ƯÁ¤ ¹®ÀÚ¿­ Á¦°Å ¹× ÃßÃâ ¹æ¹ý
2,860
php Å©·Ñ¸µ ¶Ç´Â ÆÄ½Ì ÇÔ¼ö, Á¤±Ô½Ä ¸ðÀ½
2,859
Á¦ÀÌÄõ¸® ±âº» ¸í·É¾î
2,858
À¥ÆäÀÌÁö °¡·Î ¸ðµå¼¼·Î ¸ðµå ÀνÄÇϱâ
2,857
¸ð¹ÙÀÏ À¥ È­¸é °­Á¦ ȸÀü(°¡·Î¸ðµå °íÁ¤)
2,856
[HTML5]¿¡¼­ frameset ´ëü ¹æ¹ý°ú iframe ¼Ó¼º
¸ñ·Ï
¹ÂÁ÷Æ®·ÎÆ® ºÎ»ê±¤¿ª½Ã ºÎ»êÁø±¸ °¡¾ßµ¿ ¤Ó °³ÀÎÁ¤º¸Ãë±Þ¹æħ
Copyright ¨Ï musictrot All rights reserved.