source: temp/trunk/html/admin/system/delete.php @ 1328

<?php
require_once("../require.php");

$conn = new SC_DbConn();
$oquery = new SC_Query();

// ǧ¾Ú²ÄÈݤÎȽÄê
$objSess = new SC_Session();
sfIsSuccess($objSess);

// member_id¤Î¥Á¥§¥Ã¥¯
if(sfIsInt($_GET['id'])){
    // ¥ì¥³¡¼¥É¤Îºï½ü
    $conn->query("BEGIN");
    fnRenumberRank($conn, $oquery, $_GET['id']);
    fnDeleteRecord($conn, $_GET['id']);
    $conn->query("COMMIT");
} else {
    // ¥¨¥é¡¼½èÍý
    gfPrintLog("error id=".$_GET['id']);
}

// ¥Ú¡¼¥¸¤Îɽ¼¨
$location = "Location: " . URL_SYSTEM_TOP . "?pageno=".$_GET['pageno'];
header($location);

// ¥é¥ó¥­¥ó¥°¤Î¿¶¤êľ¤·
function fnRenumberRank($conn, $oquery, $id) {
    $where = "member_id = $id";
    // ¥é¥ó¥¯¤Î¼èÆÀ
    $rank = $oquery->get("dtb_member", "rank", $where);
    // ºï½ü¤·¤¿¥ì¥³¡¼¥É¤è¤ê¾å¤Î¥é¥ó¥­¥ó¥°¤ò²¼¤²¤ÆRANK¤Î¶õ¤­¤òËä¤á¤ë¡£
    $sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND delete <> 1";
    // UPDATE¤Î¼Â¹Ô
    $ret = $conn->query($sqlup);
    return $ret;
}

// ¥ì¥³¡¼¥É¤Îºï½ü(ºï½ü¥Õ¥é¥°¤òON¤Ë¤¹¤ë)
function fnDeleteRecord($conn, $id) {
    // ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
    $sqlup = "UPDATE dtb_member SET rank = 0, delete = 1 WHERE member_id = $id";
    // UPDATE¤Î¼Â¹Ô
    $ret = $conn->query($sqlup);
    return $ret;
}
?>