| 1 | <?php |
|---|
| 2 | /* |
|---|
| 3 | * Copyright ¢í 2000-2006 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 | ?> |
|---|
