source: branches/rel/html/admin/system/delete.php @ 12157

Revision 12157, 1.3 KB checked in by uehara, 17 years ago (diff)
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$oquery = new SC_Query();
11
12// ǧ¾Ú²ÄÈݤÎȽÄê
13$objSess = new SC_Session();
14sfIsSuccess($objSess);
15
16// member_id¤Î¥Á¥§¥Ã¥¯
17if(sfIsInt($_GET['id'])){
18    // ¥ì¥³¡¼¥É¤Îºï½ü
19    $conn->query("BEGIN");
20    fnRenumberRank($conn, $oquery, $_GET['id']);
21    fnDeleteRecord($conn, $_GET['id']);
22    $conn->query("COMMIT");
23} else {
24    // ¥¨¥é¡¼½èÍý
25    gfPrintLog("error id=".$_GET['id']);
26}
27
28// ¥Ú¡¼¥¸¤Îɽ¼¨
29$location = "Location: " . URL_SYSTEM_TOP . "?pageno=".$_GET['pageno'];
30header($location);
31
32// ¥é¥ó¥­¥ó¥°¤Î¿¶¤êľ¤·
33function fnRenumberRank($conn, $oquery, $id) {
34    $where = "member_id = $id";
35    // ¥é¥ó¥¯¤Î¼èÆÀ
36    $rank = $oquery->get("dtb_member", "rank", $where);
37    // ºï½ü¤·¤¿¥ì¥³¡¼¥É¤è¤ê¾å¤Î¥é¥ó¥­¥ó¥°¤ò²¼¤²¤ÆRANK¤Î¶õ¤­¤òËä¤á¤ë¡£
38    $sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND del_flg <> 1";
39    // UPDATE¤Î¼Â¹Ô
40    $ret = $conn->query($sqlup);
41    return $ret;
42}
43
44// ¥ì¥³¡¼¥É¤Îºï½ü(ºï½ü¥Õ¥é¥°¤òON¤Ë¤¹¤ë)
45function fnDeleteRecord($conn, $id) {
46    // ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
47    $sqlup = "UPDATE dtb_member SET rank = 0, del_flg = 1 WHERE member_id = $id";
48    // UPDATE¤Î¼Â¹Ô
49    $ret = $conn->query($sqlup);
50    return $ret;
51}
52?>
Note: See TracBrowser for help on using the repository browser.