@@ 49-108 (lines=60) @@ | ||
46 | * @param $followers |
|
47 | * @return array|bool |
|
48 | */ |
|
49 | public function Updates($last, $uid, $followers) |
|
50 | { |
|
51 | global $xoopsUser, $xoopsDB, $moduleConfig; |
|
52 | $hm = smallworld_GetModuleOption('msgtoshow'); |
|
53 | $set = smallworld_checkPrivateOrPublic(); |
|
54 | $followers = is_array($followers) ? $followers : [$followers]; |
|
55 | $followers = array_unique(Smallworld_array_flatten($followers, 0)); |
|
56 | ||
57 | $i = 0; |
|
58 | if (0 == $last) { |
|
59 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"; |
|
60 | } elseif ($last > 0) { |
|
61 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "' AND M.msg_id < '" . $last . "'"; |
|
62 | } elseif ('a' === $last) { |
|
63 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"; |
|
64 | } |
|
65 | ||
66 | if (is_array($followers)) { |
|
67 | foreach ($followers as $k => $v) { |
|
68 | if ($last > 0) { |
|
69 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "' and M.msg_id < '" . $last . "'"; |
|
70 | } elseif (0 == $last) { |
|
71 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "'"; |
|
72 | } elseif ('a' === $last) { |
|
73 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "'"; |
|
74 | } |
|
75 | ++$i; |
|
76 | } |
|
77 | } |
|
78 | if (!is_array($followers)) { |
|
79 | $followers = $uid; |
|
80 | if ($last > 0) { |
|
81 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "' and M.msg_id < '" . $last . "'"; |
|
82 | } elseif (0 == $last) { |
|
83 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "'"; |
|
84 | } elseif ('a' === $last) { |
|
85 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "'"; |
|
86 | } |
|
87 | } |
|
88 | ||
89 | if ($last > 0) { |
|
90 | $query .= ' order by created DESC LIMIT ' . $hm; |
|
91 | } elseif ('a' === $last) { |
|
92 | $query .= ' order by M.msg_id DESC LIMIT ' . $hm; |
|
93 | } else { |
|
94 | $query .= ' order by created DESC LIMIT ' . $hm; |
|
95 | } |
|
96 | $result = $xoopsDB->queryF($query); |
|
97 | $count = $xoopsDB->getRowsNum($result); |
|
98 | if (0 == $count) { |
|
99 | return false; |
|
100 | } else { |
|
101 | while ($row = $xoopsDB->fetchArray($result)) { |
|
102 | $data[] = $row; |
|
103 | } |
|
104 | if (!empty($data)) { |
|
105 | return $data; |
|
106 | } |
|
107 | } |
|
108 | } |
|
109 | ||
110 | /** |
|
111 | * @Get comments based on msg id |
@@ 53-113 (lines=61) @@ | ||
50 | * @param $followers |
|
51 | * @return array|bool |
|
52 | */ |
|
53 | public function Updates($last, $uid, $followers) |
|
54 | { |
|
55 | global $xoopsUser, $xoopsDB, $moduleConfig; |
|
56 | $query = ''; |
|
57 | $hm = smallworld_GetModuleOption('msgtoshow'); |
|
58 | $set = smallworld_checkPrivateOrPublic(); |
|
59 | $followers = is_array($followers) ? $followers : [$followers]; |
|
60 | $followers = array_unique(Smallworld_array_flatten($followers, 0)); |
|
61 | ||
62 | $i = 0; |
|
63 | if (0 == $last) { |
|
64 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"; |
|
65 | } elseif ($last > 0) { |
|
66 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "' AND M.msg_id < '" . $last . "'"; |
|
67 | } elseif ('a' === $last) { |
|
68 | $query = 'SELECT M.msg_id, M.uid_fk, M.priv, M.message, M.created, U.username FROM ' . $xoopsDB->prefix('smallworld_messages') . ' M, ' . $xoopsDB->prefix('smallworld_user') . " U WHERE M.uid_fk=U.userid AND M.uid_fk='" . $uid . "'"; |
|
69 | } |
|
70 | ||
71 | if (is_array($followers)) { |
|
72 | foreach ($followers as $k => $v) { |
|
73 | if ($last > 0) { |
|
74 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "' and M.msg_id < '" . $last . "'"; |
|
75 | } elseif (0 == $last) { |
|
76 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "'"; |
|
77 | } elseif ('a' === $last) { |
|
78 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $v . "'"; |
|
79 | } |
|
80 | ++$i; |
|
81 | } |
|
82 | } |
|
83 | if (!is_array($followers)) { |
|
84 | $followers = $uid; |
|
85 | if ($last > 0) { |
|
86 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "' and M.msg_id < '" . $last . "'"; |
|
87 | } elseif (0 == $last) { |
|
88 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "'"; |
|
89 | } elseif ('a' === $last) { |
|
90 | $query .= " OR M.uid_fk=U.userid and M.uid_fk= '" . $followers . "'"; |
|
91 | } |
|
92 | } |
|
93 | ||
94 | if ($last > 0) { |
|
95 | $query .= ' order by created DESC LIMIT ' . $hm; |
|
96 | } elseif ('a' === $last) { |
|
97 | $query .= ' order by M.msg_id DESC LIMIT ' . $hm; |
|
98 | } else { |
|
99 | $query .= ' order by created DESC LIMIT ' . $hm; |
|
100 | } |
|
101 | $result = $xoopsDB->queryF($query); |
|
102 | $count = $xoopsDB->getRowsNum($result); |
|
103 | if (0 == $count) { |
|
104 | return false; |
|
105 | } else { |
|
106 | while ($row = $xoopsDB->fetchArray($result)) { |
|
107 | $data[] = $row; |
|
108 | } |
|
109 | if (!empty($data)) { |
|
110 | return $data; |
|
111 | } |
|
112 | } |
|
113 | } |
|
114 | ||
115 | /** |
|
116 | * @Get comments based on msg id |