fenglin/bbs/user_service_friend.php

<?php
        require_once "../lib/db_open.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);
        $set = (isset($data["set"]) && $data["set"] == "1" ? 1 : 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 ($uid == $_SESSION["BBS_uid"])
        {
                $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 UID FROM user_list WHERE UID = $uid AND 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(mysqli_num_rows($rs) == 0)
        {
                $result_set["return"]["code"] = -1;
                $result_set["return"]["message"] = "用户不存在";

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

        $sql = "SELECT ID FROM friend_list WHERE UID = " .
                        $_SESSION["BBS_uid"] . " AND fUID = $uid FOR UPDATE";

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

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

        if ($row = mysqli_fetch_array($rs))
        {
                if ($set == 0)
                {
                        $sql = "DELETE FROM friend_list WHERE ID = " . $row["ID"];

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

                                mysqli_close($db_conn);
                                exit(json_encode($result_set));
                        }
                }
                else // $set == 1
                {
                        $result_set["return"]["code"] = 1;
                        $result_set["return"]["message"] = "已添加";

                        mysqli_close($db_conn);
                        exit(json_encode($result_set));
                }
        }
        else
        {
                if ($set == 1)
                {
                        $sql = "INSERT INTO friend_list(UID, fUID) VALUES(".
                                        $_SESSION["BBS_uid"].", $uid)";

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

                                mysqli_close($db_conn);
                                exit(json_encode($result_set));
                        }
                }
                else // $set == 0
                {
                        $result_set["return"]["code"] = 1;
                        $result_set["return"]["message"] = "已删除";

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

        // 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			$data = json_decode(file_get_contents("php://input"), true);
6
7			$uid = (isset($data["uid"]) ? intval($data["uid"]) : 0);
8			$set = (isset($data["set"]) && $data["set"] == "1" ? 1 : 0);
9
10			$result_set = array(
11			"return" => array(
12			"code" => 0,
13			"message" => "",
14			"errorFields" => array(),
15			)
16			);
17
18			header("Content-Type:application/json; charset=utf-8");
19
20			// Validate input data
21			if (!isset($_SESSION["BBS_uid"]) \|\| $_SESSION["BBS_uid"] == 0)
22			{
23			$result_set["return"]["code"] = -1;
24			$result_set["return"]["message"] = "没有登录";
25
26			mysqli_close($db_conn);
27			exit(json_encode($result_set));
28			}
29
30			if ($uid == $_SESSION["BBS_uid"])
31			{
32			$result_set["return"]["code"] = -1;
33			$result_set["return"]["message"] = "不能对自己操作";
34
35			mysqli_close($db_conn);
36			exit(json_encode($result_set));
37			}
38
39			// Begin transaction
40			$rs = mysqli_query($db_conn, "SET autocommit=0");
41			if ($rs == false)
42			{
43			$result_set["return"]["code"] = -2;
44			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
45
46			mysqli_close($db_conn);
47			exit(json_encode($result_set));
48			}
49	sysadm	1.2
50	sysadm	1.1	$rs = mysqli_query($db_conn, "BEGIN");
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			$sql = "SELECT UID FROM user_list WHERE UID = $uid AND enable";
61
62			$rs = mysqli_query($db_conn, $sql);
63			if ($rs == false)
64			{
65			$result_set["return"]["code"] = -2;
66			$result_set["return"]["message"] = "Query user error: " . mysqli_error($db_conn);
67
68			mysqli_close($db_conn);
69			exit(json_encode($result_set));
70			}
71
72			if(mysqli_num_rows($rs) == 0)
73			{
74			$result_set["return"]["code"] = -1;
75			$result_set["return"]["message"] = "用户不存在";
76
77			mysqli_close($db_conn);
78			exit(json_encode($result_set));
79			}
80			mysqli_free_result($rs);
81
82			$sql = "SELECT ID FROM friend_list WHERE UID = " .
83			$_SESSION["BBS_uid"] . " AND fUID = $uid FOR UPDATE";
84
85			$rs = mysqli_query($db_conn, $sql);
86			if ($rs == false)
87			{
88			$result_set["return"]["code"] = -2;
89			$result_set["return"]["message"] = "Query friend error: " . mysqli_error($db_conn);
90
91			mysqli_close($db_conn);
92			exit(json_encode($result_set));
93			}
94
95			if ($row = mysqli_fetch_array($rs))
96			{
97			if ($set == 0)
98			{
99			$sql = "DELETE FROM friend_list WHERE ID = " . $row["ID"];
100
101			$ret = mysqli_query($db_conn, $sql);
102			if ($ret == false)
103			{
104			$result_set["return"]["code"] = -2;
105			$result_set["return"]["message"] = "Delete friend error: " . mysqli_error($db_conn);
106	sysadm	1.2
107	sysadm	1.1	mysqli_close($db_conn);
108			exit(json_encode($result_set));
109			}
110			}
111			else // $set == 1
112			{
113			$result_set["return"]["code"] = 1;
114			$result_set["return"]["message"] = "已添加";
115	sysadm	1.2
116	sysadm	1.1	mysqli_close($db_conn);
117			exit(json_encode($result_set));
118			}
119			}
120			else
121			{
122			if ($set == 1)
123			{
124			$sql = "INSERT INTO friend_list(UID, fUID) VALUES(".
125			$_SESSION["BBS_uid"].", $uid)";
126
127			$ret = mysqli_query($db_conn, $sql);
128			if ($ret == false)
129			{
130			$result_set["return"]["code"] = -2;
131			$result_set["return"]["message"] = "Add friend error: " . mysqli_error($db_conn);
132	sysadm	1.2
133	sysadm	1.1	mysqli_close($db_conn);
134			exit(json_encode($result_set));
135			}
136			}
137			else // $set == 0
138			{
139			$result_set["return"]["code"] = 1;
140			$result_set["return"]["message"] = "已删除";
141	sysadm	1.2
142	sysadm	1.1	mysqli_close($db_conn);
143			exit(json_encode($result_set));
144			}
145			}
146			mysqli_free_result($rs);
147
148			// Commit transaction
149			$rs = mysqli_query($db_conn, "COMMIT");
150			if ($rs == false)
151			{
152			$result_set["return"]["code"] = -2;
153			$result_set["return"]["message"] = "Mysqli error: " . mysqli_error($db_conn);
154
155			mysqli_close($db_conn);
156			exit(json_encode($result_set));
157			}
158
159			mysqli_close($db_conn);
160			exit(json_encode($result_set));
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1