1 | <?php |
---|
2 | /* |
---|
3 | * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. |
---|
4 | * |
---|
5 | * http://www.lockon.co.jp/ |
---|
6 | */ |
---|
7 | require_once("../require.php"); |
---|
8 | |
---|
9 | $conn = new SC_DbConn(); |
---|
10 | |
---|
11 | // ǧ¾Ú²ÄÈݤÎȽÄê |
---|
12 | $objSess = new SC_Session(); |
---|
13 | sfIsSuccess($objSess); |
---|
14 | |
---|
15 | // ¥é¥ó¥¥ó¥°¤ÎÊѹ¹ |
---|
16 | if($_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']; |
---|
35 | header($location); |
---|
36 | |
---|
37 | // ¥é¥ó¥¥ó¥°¤ò¾å¤²¤ë¡£ |
---|
38 | function 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 | // ¥é¥ó¥¥ó¥°¤ò²¼¤²¤ë¡£ |
---|
58 | function 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 | ?> |
---|