fenglin/bbs/user_service_suicide.php

<?php
        require_once "../lib/db_open.inc.php";
        require_once "./session_init.inc.php";

        force_login();

        $data = json_decode(file_get_contents("php://input"), true);

        $confirm = (isset($data["confirm"]) && $data["confirm"] == "1");

        $result_set = array(
                "return" => array(
                        "code" => 0,
                        "message" => "",
                        "errorFields" => array(),
                )
        );

        header("Content-Type:application/json; charset=utf-8");

        if (!$confirm)
        {
                $result_set["return"]["code"] = -1;
                array_push($result_set["return"]["errorFields"], array(
                        "id" => "confirm",
                        "errMsg" => "需要勾选确认",
                ));

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        if (!$_SESSION["BBS_priv"]->checkpriv(0, S_POST) ||
                $_SESSION["BBS_priv"]->checklevel(P_ADMIN_M | P_ADMIN_S | P_MAN_M | P_MAN_S))
        {
                $result_set["return"]["code"] = -1;
                array_push($result_set["return"]["errorFields"], array(
                        "id" => "confirm",
                        "errMsg" => "没有权限",
                ));

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        if ($_SESSION["BBS_login_tm"] < time() - 60) // login earlier than 1 minute
        {
                $result_set["return"]["code"] = -1;
                array_push($result_set["return"]["errorFields"], array(
                        "id" => "confirm",
                        "errMsg" => "需要再次登录验证",
                ));

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        // Begin transaction
        $rs = mysqli_query($db_conn, "SET autocommit=0");
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }
        
        $rs = mysqli_query($db_conn, "BEGIN");
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        // Commit suicide
        $sql = "UPDATE user_pubinfo SET life = 60 WHERE UID = " . $_SESSION["BBS_uid"];

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Update user_pubinfo error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $sql = "INSERT INTO user_life_log(UID, set_UID, life, dt, ip)
                        VALUES(" . $_SESSION["BBS_uid"] . ", " . $_SESSION["BBS_uid"] . ", 60, NOW(), '".
                        client_addr() . "')";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Add log error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $sql = "INSERT INTO ban_user_list(SID, UID, day, ban_uid, ban_dt, ban_ip, unban_dt, reason)
                        VALUES(-1, " . $_SESSION["BBS_uid"] . ", 365, " . $_SESSION["BBS_uid"] .
                        ", NOW(), '" . client_addr() . "', ADDDATE(NOW(), INTERVAL 1 YEAR), '关闭账户')";

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Insert ban error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $sql = "UPDATE user_list SET p_login = 0 WHERE UID = " . $_SESSION["BBS_uid"];

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Update user privilege error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        $sql = "UPDATE user_online SET current_action = 'exit' WHERE UID = " . $_SESSION["BBS_uid"];

        $rs = mysqli_query($db_conn, $sql);
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Update user online error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        // Commit transaction
        $rs = mysqli_query($db_conn, "COMMIT");
        if ($rs == false)
        {
                $result_set["return"]["code"] = -2;
                $result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);

                mysqli_close($db_conn);
                exit(json_encode($result_set));
        }

        mysqli_close($db_conn);
        exit(json_encode($result_set));
?>
1	sysadm	1.1	<?php
2			require_once "../lib/db_open.inc.php";
3			require_once "./session_init.inc.php";
4
5			force_login();
6
7			$data = json_decode(file_get_contents("php://input"), true);
8
9			$confirm = (isset($data["confirm"]) && $data["confirm"] == "1");
10
11			$result_set = array(
12			"return" => array(
13			"code" => 0,
14			"message" => "",
15			"errorFields" => array(),
16			)
17			);
18
19			header("Content-Type:application/json; charset=utf-8");
20
21			if (!$confirm)
22			{
23			$result_set["return"]["code"] = -1;
24			array_push($result_set["return"]["errorFields"], array(
25			"id" => "confirm",
26			"errMsg" => "需要勾选确认",
27			));
28
29			mysqli_close($db_conn);
30			exit(json_encode($result_set));
31			}
32
33			if (!$_SESSION["BBS_priv"]->checkpriv(0, S_POST) \|\|
34			$_SESSION["BBS_priv"]->checklevel(P_ADMIN_M \| P_ADMIN_S \| P_MAN_M \| P_MAN_S))
35			{
36			$result_set["return"]["code"] = -1;
37			array_push($result_set["return"]["errorFields"], array(
38			"id" => "confirm",
39			"errMsg" => "没有权限",
40			));
41
42			mysqli_close($db_conn);
43			exit(json_encode($result_set));
44			}
45
46			if ($_SESSION["BBS_login_tm"] < time() - 60) // login earlier than 1 minute
47			{
48			$result_set["return"]["code"] = -1;
49			array_push($result_set["return"]["errorFields"], array(
50			"id" => "confirm",
51			"errMsg" => "需要再次登录验证",
52			));
53
54			mysqli_close($db_conn);
55			exit(json_encode($result_set));
56			}
57
58			// Begin transaction
59			$rs = mysqli_query($db_conn, "SET autocommit=0");
60			if ($rs == false)
61			{
62			$result_set["return"]["code"] = -2;
63			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
64
65			mysqli_close($db_conn);
66			exit(json_encode($result_set));
67			}
68
69			$rs = mysqli_query($db_conn, "BEGIN");
70			if ($rs == false)
71			{
72			$result_set["return"]["code"] = -2;
73			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
74
75			mysqli_close($db_conn);
76			exit(json_encode($result_set));
77			}
78
79			// Commit suicide
80			$sql = "UPDATE user_pubinfo SET life = 60 WHERE UID = " . $_SESSION["BBS_uid"];
81
82			$rs = mysqli_query($db_conn, $sql);
83			if ($rs == false)
84			{
85			$result_set["return"]["code"] = -2;
86			$result_set["return"]["message"] = "Update user_pubinfo error: " . mysqli_error($db_conn);
87
88			mysqli_close($db_conn);
89			exit(json_encode($result_set));
90			}
91
92			$sql = "INSERT INTO user_life_log(UID, set_UID, life, dt, ip)
93			VALUES(" . $_SESSION["BBS_uid"] . ", " . $_SESSION["BBS_uid"] . ", 60, NOW(), '".
94			client_addr() . "')";
95
96			$rs = mysqli_query($db_conn, $sql);
97			if ($rs == false)
98			{
99			$result_set["return"]["code"] = -2;
100			$result_set["return"]["message"] = "Add log error: " . mysqli_error($db_conn);
101
102			mysqli_close($db_conn);
103			exit(json_encode($result_set));
104			}
105
106			$sql = "INSERT INTO ban_user_list(SID, UID, day, ban_uid, ban_dt, ban_ip, unban_dt, reason)
107			VALUES(-1, " . $_SESSION["BBS_uid"] . ", 365, " . $_SESSION["BBS_uid"] .
108			", NOW(), '" . client_addr() . "', ADDDATE(NOW(), INTERVAL 1 YEAR), '关闭账户')";
109
110			$rs = mysqli_query($db_conn, $sql);
111			if ($rs == false)
112			{
113			$result_set["return"]["code"] = -2;
114			$result_set["return"]["message"] = "Insert ban error: " . mysqli_error($db_conn);
115
116			mysqli_close($db_conn);
117			exit(json_encode($result_set));
118			}
119
120			$sql = "UPDATE user_list SET p_login = 0 WHERE UID = " . $_SESSION["BBS_uid"];
121
122			$rs = mysqli_query($db_conn, $sql);
123			if ($rs == false)
124			{
125			$result_set["return"]["code"] = -2;
126			$result_set["return"]["message"] = "Update user privilege error: " . mysqli_error($db_conn);
127
128			mysqli_close($db_conn);
129			exit(json_encode($result_set));
130			}
131
132			$sql = "UPDATE user_online SET current_action = 'exit' WHERE UID = " . $_SESSION["BBS_uid"];
133
134			$rs = mysqli_query($db_conn, $sql);
135			if ($rs == false)
136			{
137			$result_set["return"]["code"] = -2;
138			$result_set["return"]["message"] = "Update user online error: " . mysqli_error($db_conn);
139
140			mysqli_close($db_conn);
141			exit(json_encode($result_set));
142			}
143
144			// Commit transaction
145			$rs = mysqli_query($db_conn, "COMMIT");
146			if ($rs == false)
147			{
148			$result_set["return"]["code"] = -2;
149			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
150
151			mysqli_close($db_conn);
152			exit(json_encode($result_set));
153			}
154
155			mysqli_close($db_conn);
156			exit(json_encode($result_set));
157			?>
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1