fenglin/bbs/set_life.php

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

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

        $uid = (isset($data["uid"]) ? intval($data["uid"]) : 0);
        $life = (isset($data["life"]) ? intval($data["life"]) : 0);

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

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

        // Validate input data
        if (!isset($_SESSION["BBS_uid"]) || $_SESSION["BBS_uid"] == 0)
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "没有登录";

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

        if (!(in_array($life, $BBS_life_immortal) || $life == 150))
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "非法生命值";

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

        if (!$_SESSION["BBS_priv"]->checklevel(P_ADMIN_M | P_ADMIN_S))
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "没有权限";

                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));
        }

        $sql = "SELECT life FROM user_list
                        INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID
                        WHERE user_list.UID = $uid AND user_list.enable";

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

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

        if($row = mysqli_fetch_array($rs))
        {
                if ($row["life"] == $life)
                {
                        $result_set["return"]["code"] = -1;
                        $result_set["return"]["message"] = "没有改变";
        
                        mysqli_close($db_conn);
                        exit(json_encode($result_set));
                }
        }
        else
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "用户不存在";

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

        $sql = "UPDATE user_pubinfo SET life = $life WHERE UID = $uid";

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

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

        $sql = "UPDATE user_online SET current_action = 'reload' WHERE UID = $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));
        }

        $sql = "INSERT INTO user_life_log(UID, set_UID, life, dt, ip)
                        VALUES($uid, " . $_SESSION["BBS_uid"] . ", $life, 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));
        }

        // 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	<?
2	sysadm	1.8	require_once "../lib/db_open.inc.php";
3	sysadm	1.4	require_once "./common_lib.inc.php";
4	sysadm	1.1	require_once "./session_init.inc.php";
5
6	sysadm	1.11	$data = json_decode(file_get_contents("php://input"), true);
7
8			$uid = (isset($data["uid"]) ? intval($data["uid"]) : 0);
9			$life = (isset($data["life"]) ? intval($data["life"]) : 0);
10	sysadm	1.1
11	sysadm	1.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			// Validate input data
22			if (!isset($_SESSION["BBS_uid"]) \|\| $_SESSION["BBS_uid"] == 0)
23			{
24			$result_set["return"]["code"] = -1;
25			$result_set["return"]["message"] = "没有登录";
26
27			mysqli_close($db_conn);
28			exit(json_encode($result_set));
29			}
30
31			if (!(in_array($life, $BBS_life_immortal) \|\| $life == 150))
32			{
33			$result_set["return"]["code"] = -1;
34			$result_set["return"]["message"] = "非法生命值";
35
36			mysqli_close($db_conn);
37			exit(json_encode($result_set));
38			}
39
40	sysadm	1.12	if (!$_SESSION["BBS_priv"]->checklevel(P_ADMIN_M \| P_ADMIN_S))
41	sysadm	1.11	{
42			$result_set["return"]["code"] = -1;
43			$result_set["return"]["message"] = "没有权限";
44
45			mysqli_close($db_conn);
46			exit(json_encode($result_set));
47			}
48
49			// Begin transaction
50			$rs = mysqli_query($db_conn, "SET autocommit=0");
51			if ($rs == false)
52			{
53			$result_set["return"]["code"] = -2;
54			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
55
56			mysqli_close($db_conn);
57			exit(json_encode($result_set));
58			}
59
60			$rs = mysqli_query($db_conn, "BEGIN");
61			if ($rs == false)
62			{
63			$result_set["return"]["code"] = -2;
64			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
65
66			mysqli_close($db_conn);
67			exit(json_encode($result_set));
68			}
69
70			$sql = "SELECT life FROM user_list
71			INNER JOIN user_pubinfo ON user_list.UID = user_pubinfo.UID
72			WHERE user_list.UID = $uid AND user_list.enable";
73
74			$rs = mysqli_query($db_conn, $sql);
75			if ($rs == false)
76			{
77			$result_set["return"]["code"] = -2;
78			$result_set["return"]["message"] = "Query user error: " . mysqli_error($db_conn);
79
80			mysqli_close($db_conn);
81			exit(json_encode($result_set));
82			}
83
84			if($row = mysqli_fetch_array($rs))
85			{
86			if ($row["life"] == $life)
87			{
88			$result_set["return"]["code"] = -1;
89			$result_set["return"]["message"] = "没有改变";
90
91			mysqli_close($db_conn);
92			exit(json_encode($result_set));
93			}
94			}
95			else
96			{
97			$result_set["return"]["code"] = -1;
98			$result_set["return"]["message"] = "用户不存在";
99
100			mysqli_close($db_conn);
101			exit(json_encode($result_set));
102			}
103			mysqli_free_result($rs);
104
105			$sql = "UPDATE user_pubinfo SET life = $life WHERE UID = $uid";
106
107			$rs = mysqli_query($db_conn, $sql);
108			if ($rs == false)
109			{
110			$result_set["return"]["code"] = -2;
111			$result_set["return"]["message"] = "Update user life error: " . mysqli_error($db_conn);
112
113			mysqli_close($db_conn);
114			exit(json_encode($result_set));
115			}
116
117			$sql = "UPDATE user_online SET current_action = 'reload' WHERE UID = $uid";
118
119			$rs = mysqli_query($db_conn, $sql);
120			if ($rs == false)
121			{
122			$result_set["return"]["code"] = -2;
123			$result_set["return"]["message"] = "Update user online error: " . mysqli_error($db_conn);
124
125			mysqli_close($db_conn);
126			exit(json_encode($result_set));
127			}
128
129			$sql = "INSERT INTO user_life_log(UID, set_UID, life, dt, ip)
130			VALUES($uid, " . $_SESSION["BBS_uid"] . ", $life, NOW(), '".
131			client_addr() . "')";
132
133			$rs = mysqli_query($db_conn, $sql);
134			if ($rs == false)
135			{
136			$result_set["return"]["code"] = -2;
137			$result_set["return"]["message"] = "Add log error: " . mysqli_error($db_conn);
138
139			mysqli_close($db_conn);
140			exit(json_encode($result_set));
141			}
142
143			// Commit transaction
144			$rs = mysqli_query($db_conn, "COMMIT");
145			if ($rs == false)
146			{
147			$result_set["return"]["code"] = -2;
148			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
149
150			mysqli_close($db_conn);
151			exit(json_encode($result_set));
152			}
153	sysadm	1.1
154	sysadm	1.11	mysqli_close($db_conn);
155			exit(json_encode($result_set));
156	sysadm	1.1	?>
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1