source: branches/comu/html/admin/system/rank.php @ 11730

Revision 11730, 2.1 KB checked in by nanasess, 17 years ago (diff)

r11729 の変更を取消

Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9$conn = new SC_DbConn();
10
11// ǧ¾Ú²ÄÈݤÎȽÄê
12$objSess = new SC_Session();
13sfIsSuccess($objSess);
14
15// ¥é¥ó¥­¥ó¥°¤ÎÊѹ¹
16if($_GET['move'] == 'up') {
17    // ÀµÅö¤Ê¿ôÃͤǤ¢¤Ã¤¿¾ì¹ç
18    if(sfIsInt($_GET['id'])){
19        lfRunkUp($conn, $_GET['id']);
20    } else {
21        // ¥¨¥é¡¼½èÍý
22        gfPrintLog("error id=".$_GET['id']);
23    }
24} else if($_GET['move'] == 'down') {
25    if(sfIsInt($_GET['id'])){
26        lfRunkDown($conn, $_GET['id']);
27    }  else {
28        // ¥¨¥é¡¼½èÍý
29        gfPrintLog("error id=".$_GET['id']);
30    }
31}
32
33// ¥Ú¡¼¥¸¤Îɽ¼¨
34$location = "Location: " . URL_SYSTEM_TOP . "?pageno=".$_GET['pageno'];
35header($location);
36
37// ¥é¥ó¥­¥ó¥°¤ò¾å¤²¤ë¡£
38function lfRunkUp($conn, $id) {
39    // ¼«¿È¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£
40    $rank = $conn->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
41    // ¥é¥ó¥¯¤ÎºÇÂçÃͤò¼èÆÀ¤¹¤ë¡£
42    $maxno = $conn->getOne("SELECT max(rank) FROM dtb_member");
43    // ¥é¥ó¥¯¤¬ºÇÂçÃͤè¤ê¤â¾®¤µ¤¤¾ì¹ç¤Ë¼Â¹Ô¤¹¤ë¡£
44    if($rank < $maxno) {
45        // ¥é¥ó¥¯¤¬¤Ò¤È¤Ä¾å¤ÎID¤ò¼èÆÀ¤¹¤ë¡£
46        $sqlse = "SELECT member_id FROM dtb_member WHERE rank = ?";
47        $up_id = $conn->getOne($sqlse, $rank + 1);
48        // ¥é¥ó¥¯Æþ¤ìÂؤ¨¤Î¼Â¹Ô
49        $conn->query("BEGIN");
50        $sqlup = "UPDATE dtb_member SET rank = ? WHERE member_id = ?";
51        $conn->query($sqlup, array($rank + 1, $id));
52        $conn->query($sqlup, array($rank, $up_id));
53        $conn->query("COMMIT");
54    }
55}
56
57// ¥é¥ó¥­¥ó¥°¤ò²¼¤²¤ë¡£
58function lfRunkDown($conn, $id) {
59    // ¼«¿È¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£
60    $rank = $conn->getOne("SELECT rank FROM dtb_member WHERE member_id = ".$id);
61    // ¥é¥ó¥¯¤ÎºÇ¾®Ãͤò¼èÆÀ¤¹¤ë¡£
62    $minno = $conn->getOne("SELECT min(rank) FROM dtb_member");
63    // ¥é¥ó¥¯¤¬ºÇÂçÃͤè¤ê¤âÂ礭¤¤¾ì¹ç¤Ë¼Â¹Ô¤¹¤ë¡£
64    if($rank > $minno) {
65        // ¥é¥ó¥¯¤¬¤Ò¤È¤Ä²¼¤ÎID¤ò¼èÆÀ¤¹¤ë¡£
66        $sqlse = "SELECT member_id FROM dtb_member WHERE rank = ?";
67        $down_id = $conn->getOne($sqlse, $rank - 1);
68        // ¥é¥ó¥¯Æþ¤ìÂؤ¨¤Î¼Â¹Ô
69        $conn->query("BEGIN");
70        $sqlup = "UPDATE dtb_member SET rank = ? WHERE member_id = ?";
71        $conn->query($sqlup, array($rank - 1, $id));
72        $conn->query($sqlup, array($rank, $down_id));
73        $conn->query("COMMIT");
74    }
75}   
76?>
Note: See TracBrowser for help on using the repository browser.