Changeset 4753 for temp

Timestamp:

2006/09/14 20:34:15 (20 years ago)

Author:

kakinaka

Message:

blank

File:

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

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

@@ -104 +104 @@
 //----¡¡¥Ç¡¼¥¿ºï½ü
 if ( $_POST['mode'] == 'delete' && is_numeric($_POST["news_id"])) {
+    
+    // rank¤ò¼èÆÀ
+    $pre_rank = $conn->getone(" SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? ", array( $_POST['news_id']  ));
+    
 
     //-- ºï½ü¤¹¤ë¿·Ãå¾ðÊó°Ê¹ß¤Îrank¤ò1¤Ä·«¤ê¾å¤²¤Æ¤ª¤¯
     $conn->query("BEGIN");
-    $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 = rank - 1, update_date = NOW() WHERE del_flg = 0 AND rank > ?";
+    $conn->query( $sql, array( $pre_rank  ) );
 
     $sql = "UPDATE dtb_news SET rank = 0, del_flg = 1, update_date = NOW() WHERE news_id = ?";
@@ -259 +263 @@
 }
 
-//UPDATEʸ
 function lfNewsUpdate(){
     global $conn;
     global $registDate;
-    
+
     if ($_POST["link_method"] == "") {
         $_POST["link_method"] = 1;