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