Changeset 4608 for temp/trunk/html/admin/contents/index.php

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/contents/index.php (modified) (6 diffs)

temp/trunk/html/admin/contents/index.php

@@ -104 +104 @@
     //-- ºï½ü¤¹¤ë¿·Ãå¾ðÊó°Ê¹ß¤Îrank¤ò1¤Ä·«¤ê¾å¤²¤Æ¤ª¤¯
     $conn->query("BEGIN");
-    $sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE delete = 0 AND rank > ( SELECT rank FROM dtb_news WHERE delete = 0 AND news_id = ? )";
+    $sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE del_flg = 0 AND rank > ( SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? )";
     $conn->query( $sql, array( $_POST['news_id']  ) );
 
-    $sql = "UPDATE dtb_news SET rank = 0, delete = 1, update_date = NOW() WHERE news_id = ?";
+    $sql = "UPDATE dtb_news SET rank = 0, del_flg = 1, update_date = NOW() WHERE news_id = ?";
     $conn->query( $sql, array( $_POST['news_id'] ) );
     $conn->query("COMMIT");
@@ -138 +138 @@
 
 //---- Á´¥Ç¡¼¥¿¼èÆÀ
-$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE delete = '0' ORDER BY rank DESC";
+$sql = "SELECT *, EXTRACT(EPOCH FROM news_date) as news_date_unix FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
 $objPage->list_data = $conn->getAll($sql);
 $objPage->line_max = count($objPage->list_data);
-$sql = "SELECT MAX(rank) FROM dtb_news WHERE delete = '0'";     // rank¤ÎºÇÂçÃͤò¼èÆÀ
+$sql = "SELECT MAX(rank) FROM dtb_news WHERE del_flg = '0'";        // rank¤ÎºÇÂçÃͤò¼èÆÀ
 $objPage->max_rank = $conn->getOne($sql);
 
@@ -187 +187 @@
 
     //--¡¡»ØÄꤷ¤¿½ç°Ì¤Î¾¦Éʤ«¤é°ÜÆ°¤µ¤»¤ë¾¦ÉʤޤǤÎrank¤ò£±¤Ä¤º¤é¤¹
-    $sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND delete = 0";
+    $sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0";
     if( $position > $rank ) $conn->query( $sql, array( $rank + 1, $position ) );
     if( $position < $rank ) $conn->query( $sql, array( $position, $rank - 1 ) );
 
     //-- »ØÄꤷ¤¿½ç°Ì¤Ørank¤ò½ñ¤­´¹¤¨¤ë¡£
-    $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND delete = 0 ";
+    $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 ";
     $conn->query( $sql, array( $position, $keyId ) );
     $conn->query("COMMIT");
@@ -209 +209 @@
     // rank¤ÎºÇÂçÃͰʾå¤ÎÆþÎϤòµöÍƤ·¤Ê¤¤                                            
     if( ! $objErr->arrErr["position"] ) {                                
-        $sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE delete = 0";
+        $sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE del_flg = 0";
         $result = $conn->getOne($sql);
         if( $position > $result ) $objErr->arrErr["moveposition"] .= "¢¨ ÆþÎϤµ¤ì¤¿½ç°Ì¤Ï¡¢ÅÐÏ¿¿ô¤ÎºÇÂçÃͤòĶ¤¨¤Æ¤¤¤Þ¤¹¡£";
@@ -243 +243 @@
 
     $sql = "INSERT INTO dtb_news (news_date, news_title, creator_id, news_url, link_method, news_comment, rank)
-            VALUES ( ?,?,?,?,?,? , (SELECT MAX(rank) + 1 FROM dtb_news WHERE delete = '0'))";
+            VALUES ( ?,?,?,?,?,? , (SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'))";
     $arrRegist = array($registDate, $_POST["news_title"], $_SESSION['member_id'],  $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"]);
 
@@ -249 +249 @@
     
     // ºÇ½é¤Î1·ïÌܤÎÅÐÏ¿¤Ïrank¤ËNULL¤¬Æþ¤ë¤Î¤ÇÂкö
-    $sql = "UPDATE dtb_news SET rank = 1 WHERE delete = 0 AND rank IS NULL";
+    $sql = "UPDATE dtb_news SET rank = 1 WHERE del_flg = 0 AND rank IS NULL";
     $conn->query($sql);
 }