XoopsModules25x /
news
| @@ 224-233 (lines=10) @@ | ||
| 221 | $sql = 'SELECT s.*, t.* FROM ' . $db->prefix('news_stories') . ' s, ' . $db->prefix('news_topics') . ' t WHERE (s.published > 0 AND s.published <= ' . time() . ') AND (s.expired = 0 OR s.expired > ' . time() . ') AND (s.topicid=t.topic_id) '; |
|
| 222 | if (0 != $topic) { |
|
| 223 | if (!is_array($topic)) { |
|
| 224 | if ($checkRight) { |
|
| 225 | $topics = NewsUtility::getMyItemIds('news_view'); |
|
| 226 | if (!in_array($topic, $topics)) { |
|
| 227 | return null; |
|
| 228 | } else { |
|
| 229 | $sql .= ' AND s.topicid=' . (int)$topic . ' AND (s.ihome=1 OR s.ihome=0)'; |
|
| 230 | } |
|
| 231 | } else { |
|
| 232 | $sql .= ' AND s.topicid=' . (int)$topic . ' AND (s.ihome=1 OR s.ihome=0)'; |
|
| 233 | } |
|
| 234 | } else { |
|
| 235 | if ($checkRight) { |
|
| 236 | $topics = NewsUtility::getMyItemIds('news_view'); |
|
| @@ 1290-1299 (lines=10) @@ | ||
| 1287 | $sql = 'SELECT storyid FROM ' . $db->prefix('news_stories') . ' WHERE (published > 0 AND published <= ' . time() . ') AND (expired = 0 OR expired > ' . time() . ')'; |
|
| 1288 | if (0 != $topic) { |
|
| 1289 | if (!is_array($topic)) { |
|
| 1290 | if ($checkRight) { |
|
| 1291 | $topics = NewsUtility::getMyItemIds('news_view'); |
|
| 1292 | if (!in_array($topic, $topics)) { |
|
| 1293 | return null; |
|
| 1294 | } else { |
|
| 1295 | $sql .= ' AND topicid=' . (int)$topic . ' AND (ihome=1 OR ihome=0)'; |
|
| 1296 | } |
|
| 1297 | } else { |
|
| 1298 | $sql .= ' AND topicid=' . (int)$topic . ' AND (ihome=1 OR ihome=0)'; |
|
| 1299 | } |
|
| 1300 | } else { |
|
| 1301 | if (count($topic) > 0) { |
|
| 1302 | $sql .= ' AND topicid IN (' . implode(',', $topic) . ')'; |
|
