Home
last modified time | relevance | path

Searched refs:sql_in_set (Results 1 – 25 of 157) sorted by relevance

1234567

/dports/chinese/phpbb3-tw/phpBB3/includes/
H A Dfunctions_admin.php527 WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
542 WHERE " . $db->sql_in_set('topic_id', $topic_ids);
571 WHERE ' . $db->sql_in_set('post_id', $post_ids);
595 WHERE " . $db->sql_in_set('post_id', $post_ids);
600 WHERE " . $db->sql_in_set('post_msg_id', $post_ids);
679 WHERE " . $db->sql_in_set('topic_id', $topic_ids);
807 WHERE " . $db->sql_in_set('post_id', $post_ids);
958 WHERE ' . $db->sql_in_set($sql_id, $ids);
986 WHERE ' . $db->sql_in_set($sql_id, $ids);
1060 WHERE ' . $db->sql_in_set('post_id', $post_ids);
[all …]
H A Dfunctions_database_helper.php36 WHERE " . $db->sql_in_set($column, $from_values);
80 AND " . $db->sql_in_set('user_id', $different_user_ids);
96 WHERE " . $db->sql_in_set($column, $from_values);
121 WHERE " . $db->sql_in_set($column, $from_values);
171 AND " . $db->sql_in_set('user_id', $different_user_ids);
183 AND " . $db->sql_in_set('user_id', $same_user_ids);
201 WHERE " . $db->sql_in_set($column, $from_values);
H A Dfunctions_privmsgs.php582 AND " . $db->sql_in_set('msg_id', $important_ids);
678 AND " . $db->sql_in_set('msg_id', $msg_ary);
688 AND " . $db->sql_in_set('msg_id', $msg_ary);
791 AND " . $db->sql_in_set('msg_id', $move_msg_ids);
890 AND " . $db->sql_in_set('msg_id', $msg_ids);
1077 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1243 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1263 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1354 WHERE ' . $db->sql_in_set('user_id', $u);
1380 WHERE ' . $db->sql_in_set('group_id', $g);
[all …]
H A Dfunctions_user.php58 WHERE ' . $db->sql_in_set($sql_where, $sql_in);
395 WHERE ' . $db->sql_in_set('post_id', $report_posts);
579 WHERE ' . $db->sql_in_set('user_id', $user_id_ary);
1100 WHERE ' . $db->sql_in_set('ban_id', $unban_sql);
1106 WHERE ' . $db->sql_in_set('ban_id', $unban_sql);
1124 WHERE ' . $db->sql_in_set('ban_id', $unban_sql);
2885 WHERE ' . $db->sql_in_set('user_id', $user_id_ary);
2936 AND " . $db->sql_in_set('user_id', $user_id_ary);
2997 AND " . $db->sql_in_set('user_id', $user_ids);
3036 AND ' . $db->sql_in_set('user_id', $user_ids);
[all …]
H A Dauth.php222 $sql .= ' WHERE ' . $db->sql_in_set('forum_id', array_keys($this->acl), true);
528 $where_sql = ' WHERE ' . $db->sql_in_set('user_id', $user_id);
551 …lse) ? ((!is_array($ug_id)) ? "AND a.$sql_id = $ug_id" : 'AND ' . $db->sql_in_set("a.$sql_id", $ug…
552 …((!is_array($forum_id)) ? "AND a.forum_id = $forum_id" : 'AND ' . $db->sql_in_set('a.forum_id', $f…
580 …false) ? ((!is_array($user_id)) ? 'user_id = ' . (int) $user_id : $db->sql_in_set('user_id', array…
581 …ay($forum_id)) ? 'AND a.forum_id = ' . (int) $forum_id : 'AND ' . $db->sql_in_set('a.forum_id', ar…
696 …false) ? ((!is_array($user_id)) ? 'user_id = ' . (int) $user_id : $db->sql_in_set('user_id', array…
697 …ay($forum_id)) ? 'AND a.forum_id = ' . (int) $forum_id : 'AND ' . $db->sql_in_set('a.forum_id', ar…
748 …se) ? ((!is_array($group_id)) ? 'group_id = ' . (int) $group_id : $db->sql_in_set('group_id', arra…
749 …ay($forum_id)) ? 'AND a.forum_id = ' . (int) $forum_id : 'AND ' . $db->sql_in_set('a.forum_id', ar…
[all …]
/dports/www/phpbb3/phpBB3/includes/
H A Dfunctions_admin.php569 WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
605 WHERE " . $db->sql_in_set('topic_id', $topic_ids);
650 WHERE ' . $db->sql_in_set('post_id', $post_ids);
696 WHERE " . $db->sql_in_set('post_id', $post_ids);
701 WHERE " . $db->sql_in_set('post_msg_id', $post_ids);
838 WHERE " . $db->sql_in_set('topic_id', $topic_ids);
1045 WHERE " . $db->sql_in_set('post_id', $post_ids);
1267 WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
1530 WHERE ' . $db->sql_in_set('post_id', $post_ids);
1635 WHERE ' . $db->sql_in_set('post_id', $post_ids);
[all …]
H A Dfunctions_database_helper.php40 WHERE " . $db->sql_in_set($column, $from_values);
84 AND " . $db->sql_in_set('user_id', $different_user_ids);
100 WHERE " . $db->sql_in_set($column, $from_values);
125 WHERE " . $db->sql_in_set($column, $from_values);
175 AND " . $db->sql_in_set('user_id', $different_user_ids);
187 AND " . $db->sql_in_set('user_id', $same_user_ids);
205 WHERE " . $db->sql_in_set($column, $from_values);
H A Dfunctions_user.php69 WHERE ' . $db->sql_in_set($sql_where, $sql_in);
446 $user_id_sql = $db->sql_in_set('user_id', $user_ids);
655 WHERE ' . $db->sql_in_set('poster_id', $user_ids);
748 OR ' . $db->sql_in_set('zebra_id', $user_ids);
753 WHERE ' . $db->sql_in_set('ban_userid', $user_ids);
820 WHERE ' . $db->sql_in_set('user_id', $user_id_ary);
1381 WHERE ' . $db->sql_in_set('ban_id', $unban_sql);
1405 WHERE ' . $db->sql_in_set('ban_id', $unban_sql);
2968 AND " . $db->sql_in_set('user_id', $user_id_ary);
3050 AND " . $db->sql_in_set('user_id', $user_ids);
[all …]
H A Dfunctions_privmsgs.php627 AND " . $db->sql_in_set('msg_id', $important_ids);
723 AND " . $db->sql_in_set('msg_id', $msg_ary);
733 AND " . $db->sql_in_set('msg_id', $msg_ary);
837 AND " . $db->sql_in_set('msg_id', $move_msg_ids);
970 AND " . $db->sql_in_set('msg_id', $msg_ids);
1173 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1342 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1360 WHERE ' . $db->sql_in_set('msg_id', $delete_ids);
1454 WHERE ' . $db->sql_in_set('user_id', $u);
1480 WHERE ' . $db->sql_in_set('group_id', $g);
[all …]
H A Dfunctions_mcp.php149 'WHERE' => $db->sql_in_set('t.topic_id', $topic_ids)
225 'WHERE' => $db->sql_in_set('p.post_id', $post_ids) . '
322 WHERE " . $db->sql_in_set('f.forum_id', $forum_id);
366 'WHERE' => $db->sql_in_set('p.msg_id', $pm_ids) . '
443 …$where_sql " . $db->sql_in_set('p.forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_…
444 AND ' . $db->sql_in_set('p.post_visibility', $visibility_const) .'
463 …$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_fo…
464 AND ' . $db->sql_in_set('topic_visibility', $visibility_const);
493 …$where_sql .= ' ' . $db->sql_in_set('p.forum_id', get_forum_list(array('!f_read', '!m_report')), t…
530 …$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_fo…
[all …]
/dports/www/phpbb3/phpBB3/phpbb/notification/method/
H A Dboard.php214 AND ' . $this->db->sql_in_set('n.notification_id', array_keys($rowset), true) . '
321 …(is_array($notification_type_id) ? $this->db->sql_in_set('notification_type_id', $notification_typ…
322 …(($user_id !== false) ? ' AND ' . (is_array($user_id) ? $this->db->sql_in_set('user_id', $user_id)…
323 …(($item_id !== false) ? ' AND ' . (is_array($item_id) ? $this->db->sql_in_set('item_id', $item_id)…
338 …(is_array($notification_type_id) ? $this->db->sql_in_set('notification_type_id', $notification_typ…
339 …(($item_parent_id !== false) ? ' AND ' . (is_array($item_parent_id) ? $this->db->sql_in_set('item_…
340 …(($user_id !== false) ? ' AND ' . (is_array($user_id) ? $this->db->sql_in_set('user_id', $user_id)…
354 …AND ' . ((is_array($notification_id)) ? $this->db->sql_in_set('notification_id', $notification_id)…
365 …AND ' . (is_array($item_id) ? $this->db->sql_in_set('item_id', $item_id) : 'item_id = ' . (int) $i…
366 …(($parent_id !== false) ? ' AND ' . ((is_array($parent_id) ? $this->db->sql_in_set('item_parent_id…
[all …]
H A Demail.php129 …WHERE ' . ($notification_type_id !== false ? $this->db->sql_in_set('notification_type_id', $notifi…
130 ($user_id !== false ? ' AND ' . $this->db->sql_in_set('user_id', $user_id) : '') .
131 ($item_id !== false ? ' AND ' . $this->db->sql_in_set('item_id', $item_id) : '');
141 …WHERE ' . ($notification_type_id !== false ? $this->db->sql_in_set('notification_type_id', $notifi…
142 ($user_id !== false ? ' AND ' . $this->db->sql_in_set('user_id', $user_id) : '') .
143 …($item_parent_id !== false ? ' AND ' . $this->db->sql_in_set('item_parent_id', $item_parent_id, fa…
/dports/www/phpbb3/phpBB3/phpbb/db/migration/data/v330/
H A Dremove_attachment_flash.php44 WHERE ' . $this->db->sql_in_set('cat_id', $this->cat_id);
72 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
79 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
86 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
/dports/www/phpbb3/phpBB3/phpbb/db/migration/data/v320/
H A Dremove_outdated_media.php50 WHERE ' . $this->db->sql_in_set('cat_id', $this->cat_id);
78 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
85 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
92 WHERE ' . $this->db->sql_in_set('group_id', $group_ids);
/dports/chinese/phpbb3-tw/phpBB3/includes/search/
H A Dfulltext_native.php216 WHERE ' . $db->sql_in_set('word_text', $exact_words) . '
651 $sql_author = $db->sql_in_set('p.poster_id', $author_ary);
862 $sql_author = $db->sql_in_set('p.poster_id', $author_ary);
1235 WHERE ' . $db->sql_in_set('word_id', $sql_in) . '
1242 WHERE ' . $db->sql_in_set('word_id', $sql_in) . '
1260 WHERE ' . $db->sql_in_set('word_text', $word_ary);
1265 WHERE ' . $db->sql_in_set('word_text', $word_ary);
1292 WHERE ' . $db->sql_in_set('m.post_id', $post_ids) . '
1333 WHERE ' . $db->sql_in_set('post_id', $post_ids);
1382 WHERE ' . $db->sql_in_set('word_id', $sql_in);
[all …]
/dports/www/phpbb3/phpBB3/includes/mcp/
H A Dmcp_front.php49 'WHERE' => $db->sql_in_set('p.forum_id', $forum_list) . '
50 AND ' . $db->sql_in_set('p.post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE))
73 WHERE ' . $db->sql_in_set('forum_id', $forum_list);
84 WHERE ' . $db->sql_in_set('forum_id', $forum_list) . '
85 AND ' . $db->sql_in_set('post_visibility', array(ITEM_UNAPPROVED, ITEM_REAPPROVE)) . '
118 WHERE ' . $db->sql_in_set('p.post_id', $post_list) . '
176 AND ' . $db->sql_in_set('p.forum_id', $forum_list);
220 AND ' . $db->sql_in_set('p.forum_id', $forum_list),
H A Dmcp_reports.php395 WHERE ' . $db->sql_in_set('forum_id', $forum_list);
443 WHERE ' . $db->sql_in_set('p.forum_id', $forum_list) . "
489 WHERE ' . $db->sql_in_set('r.report_id', $report_ids) . '
631 WHERE ' . $db->sql_in_set('r.report_id', $report_id_list) . '
669 WHERE ' . $db->sql_in_set('topic_id', $close_report_topics) . '
671 AND ' . $db->sql_in_set('post_id', $close_report_posts, true);
691 WHERE ' . $db->sql_in_set('report_id', $report_id_list);
696 WHERE ' . $db->sql_in_set('report_id', $report_id_list);
706 WHERE ' . $db->sql_in_set('msg_id', $close_report_posts);
718 WHERE ' . $db->sql_in_set('post_id', $close_report_posts);
[all …]
/dports/chinese/phpbb3-tw/phpBB3/includes/mcp/
H A Dmcp_reports.php300 WHERE ' . $db->sql_in_set('forum_id', $forum_list);
349 WHERE ' . $db->sql_in_set('p.forum_id', $forum_list) . "
374 WHERE ' . $db->sql_in_set('r.report_id', $report_ids) . '
518 WHERE ' . $db->sql_in_set('r.report_id', $report_id_list) . '
556 WHERE ' . $db->sql_in_set('topic_id', $close_report_topics) . '
558 AND ' . $db->sql_in_set('post_id', $close_report_posts, true);
578 WHERE ' . $db->sql_in_set('report_id', $report_id_list);
583 WHERE ' . $db->sql_in_set('report_id', $report_id_list);
594 WHERE ' . $db->sql_in_set('msg_id', $close_report_posts);
606 WHERE ' . $db->sql_in_set('post_id', $close_report_posts);
[all …]
H A Dmcp_main.php251 WHERE ' . $db->sql_in_set($sql_id, $ids);
339 WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '
350 WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '
357 WHERE " . $db->sql_in_set('topic_id', $topic_ids) . '
364 WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);
399 WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '
419 WHERE " . $db->sql_in_set('topic_id', $topic_ids);
425 WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
431 WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);
483 WHERE ' . $db->sql_in_set('topic_id', $topic_ids) . '
[all …]
/dports/www/phpbb3/phpBB3/phpbb/search/
H A Dfulltext_native.php341 WHERE ' . $this->db->sql_in_set('word_text', $exact_words) . '
866 $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);
1110 $sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);
1553 WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '
1560 WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '
1578 WHERE ' . $this->db->sql_in_set('word_text', $word_ary);
1583 WHERE ' . $this->db->sql_in_set('word_text', $word_ary);
1608 WHERE ' . $this->db->sql_in_set('m.post_id', $post_ids) . '
1649 WHERE ' . $this->db->sql_in_set('post_id', $post_ids);
1696 WHERE ' . $this->db->sql_in_set('word_id', $sql_in);
[all …]
/dports/www/phpbb3/phpBB3/phpbb/
H A Dcontent_visibility.php292 …$where_sql .= '(' . $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums, false, true)…
295 AND ' . $this->db->sql_in_set($table_alias . 'forum_id', $forum_ids, false, true) . '))';
347 …$where_sqls[] = '(' . $this->db->sql_in_set($table_alias . 'forum_id', $exclude_forum_ids, true, t…
353 $where_sqls[] = $this->db->sql_in_set($table_alias . 'forum_id', $approve_forums);
387 $where_sql = $this->db->sql_in_set('post_id', array_map('intval', $post_id));
495 WHERE ' . $this->db->sql_in_set('post_id', $post_ids);
511 WHERE ' . $this->db->sql_in_set('user_id', $poster_ids) . '
517 WHERE ' . $this->db->sql_in_set('user_id', $poster_ids) . '
525 WHERE ' . $this->db->sql_in_set('user_id', $poster_ids);
625 AND ' . $this->db->sql_in_set('post_id', $post_id, true);
/dports/chinese/phpbb3-tw/phpBB3/includes/acp/
H A Dauth.php127 WHERE ' . $db->sql_in_set('user_id', $ug_id);
283 WHERE ' . $db->sql_in_set('user_id', array_keys($hold_ary)) . '
290 WHERE ' . $db->sql_in_set('group_id', array_keys($hold_ary)) . '
362 AND ' . $db->sql_in_set('r.role_id', array_keys($roles));
619 WHERE ' . $db->sql_in_set('forum_id', array_keys($hold_ary)) . '
644 WHERE ' . $db->sql_in_set('user_id', $auth_ary['users']) . '
663 WHERE ' . $db->sql_in_set('group_id', $auth_ary['groups']) . '
781 WHERE ' . $db->sql_in_set('auth_option', $update_options);
845 AND " . $db->sql_in_set('auth_option_id', $auth_option_ids);
867 AND " . $db->sql_in_set('auth_role_id', $role_ids);
[all …]
/dports/www/phpbb3/phpBB3/includes/acp/
H A Dauth.php129 WHERE ' . $db->sql_in_set('user_id', $ug_id);
293 WHERE ' . $db->sql_in_set('user_id', array_keys($hold_ary)) . '
300 WHERE ' . $db->sql_in_set('group_id', array_keys($hold_ary)) . '
372 AND ' . $db->sql_in_set('r.role_id', array_keys($roles));
647 WHERE ' . $db->sql_in_set('forum_id', array_keys($hold_ary)) . '
672 WHERE ' . $db->sql_in_set('user_id', $auth_ary['users']) . '
691 WHERE ' . $db->sql_in_set('group_id', $auth_ary['groups']) . '
809 WHERE ' . $db->sql_in_set('auth_option', $update_options);
873 AND " . $db->sql_in_set('auth_option_id', $auth_option_ids);
895 AND " . $db->sql_in_set('auth_role_id', $role_ids);
[all …]
/dports/chinese/phpbb3-tw/phpBB3/
H A Dfeed.php773 WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '
810 'WHERE' => $db->sql_in_set('p.topic_id', $topic_ids) . '
908 WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . '
1039 AND ' . $db->sql_in_set('forum_id', $in_fid_ary) . '
1155 AND ' . $db->sql_in_set('f.forum_id', $in_fid_ary),
1239 WHERE ' . $db->sql_in_set('forum_id', $in_fid_ary) . '
1272 AND ' . $db->sql_in_set('p.post_id', $post_ids),
1312 WHERE ' . $db->sql_in_set('forum_id', $in_fid_ary) . '
1345 AND ' . $db->sql_in_set('p.post_id', $post_ids),
1407 WHERE ' . $db->sql_in_set('forum_id', $in_fid_ary) . '
[all …]
H A Dmcp.php387 'WHERE' => $db->sql_in_set('t.topic_id', $topic_ids)
469 'WHERE' => $db->sql_in_set('p.post_id', $post_ids) . '
551 WHERE " . $db->sql_in_set('f.forum_id', $forum_id);
595 'WHERE' => $db->sql_in_set('p.msg_id', $pm_ids) . '
670 …$where_sql " . $db->sql_in_set('p.forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_…
688 …$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_fo…
718 …$where_sql .= ' ' . $db->sql_in_set('p.forum_id', get_forum_list(array('!f_read', '!m_report')), t…
755 …$where_sql " . $db->sql_in_set('forum_id', ($forum_id) ? array($forum_id) : array_intersect(get_fo…
854 WHERE " . $db->sql_in_set($sql_id, $ids);

1234567