fenglin/bbs/user_section_favor.inc.php

<?php
if (!isset($_BBS_S_FAVOR_CLASS_INIT_))
{
        $_BBS_S_FAVOR_CLASS_INIT_=1;

        class section_favorite
        {
                var $s_list;
                var $s_count;

                function __construct($uid = 0, $db_conn = NULL)
                {
                        $this->load_s_favor($uid, $db_conn);
                }

                function load_s_favor($uid, $db_conn)
                {
                        $this->s_list = array();

                        if ($uid == 0)
                        {
                                return 0;
                        }

                        if ($db_conn == NULL)
                        {
                                return -1;
                        }

                        $rs = mysqli_query($db_conn, "SELECT SID FROM section_favorite WHERE UID = $uid");
                        if ($rs == false)
                        {
                                return -2;
                        }
                        while ($row = mysqli_fetch_array($rs))
                        {
                                array_push($this->s_list, $row["SID"]);
                        }
                        mysqli_free_result($rs);

                        return 0;
                }

                function save_s_favor($uid, $db_conn)
                {
                        if ($db_conn == NULL)
                        {
                                return -1;
                        }

                        if (mysqli_query($db_conn, "DELETE FROM section_favorite WHERE UID = $uid") == false)
                        {
                                return -2;
                        }

                        foreach ($this->s_list as $sid)
                        {
                                if (mysqli_query($db_conn, "INSERT INTO section_favorite(UID, SID) VALUES($uid, $sid)") == false)
                                {
                                        return -3;
                                }
                        }

                        return 0;
                }

                function is_in($sid)
                {
                        return in_array($sid, $this->s_list);
                }
        }
}
1	sysadm	1.1	<?php
2			if (!isset($_BBS_S_FAVOR_CLASS_INIT_))
3			{
4			$_BBS_S_FAVOR_CLASS_INIT_=1;
5
6			class section_favorite
7			{
8			var $s_list;
9			var $s_count;
10
11			function __construct($uid = 0, $db_conn = NULL)
12			{
13			$this->load_s_favor($uid, $db_conn);
14			}
15
16			function load_s_favor($uid, $db_conn)
17			{
18			$this->s_list = array();
19
20			if ($uid == 0)
21			{
22			return 0;
23			}
24
25			if ($db_conn == NULL)
26			{
27			return -1;
28			}
29
30			$rs = mysqli_query($db_conn, "SELECT SID FROM section_favorite WHERE UID = $uid");
31			if ($rs == false)
32			{
33			return -2;
34			}
35			while ($row = mysqli_fetch_array($rs))
36			{
37			array_push($this->s_list, $row["SID"]);
38			}
39			mysqli_free_result($rs);
40	sysadm	1.2
41	sysadm	1.1	return 0;
42			}
43	sysadm	1.2
44	sysadm	1.1	function save_s_favor($uid, $db_conn)
45			{
46			if ($db_conn == NULL)
47			{
48			return -1;
49			}
50
51			if (mysqli_query($db_conn, "DELETE FROM section_favorite WHERE UID = $uid") == false)
52			{
53			return -2;
54			}
55	sysadm	1.2
56	sysadm	1.1	foreach ($this->s_list as $sid)
57			{
58			if (mysqli_query($db_conn, "INSERT INTO section_favorite(UID, SID) VALUES($uid, $sid)") == false)
59			{
60			return -3;
61			}
62			}
63
64			return 0;
65			}
66	sysadm	1.2
67	sysadm	1.1	function is_in($sid)
68			{
69			return in_array($sid, $this->s_list);
70			}
71			}
72			}
webmaster@leafok.com	ViewVC Help
Powered by ViewVC 1.3.0-beta1