/dports/chinese/phpbb3-tw/phpBB3/includes/ |
H A D | functions_admin.php | 527 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 D | functions_database_helper.php | 36 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 D | functions_privmsgs.php | 582 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 D | functions_user.php | 58 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 D | auth.php | 222 $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 D | functions_admin.php | 569 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 D | functions_database_helper.php | 40 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 D | functions_user.php | 69 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 D | functions_privmsgs.php | 627 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 D | functions_mcp.php | 149 '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 D | board.php | 214 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 D | email.php | 129 …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 D | remove_attachment_flash.php | 44 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 D | remove_outdated_media.php | 50 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 D | fulltext_native.php | 216 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 D | mcp_front.php | 49 '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 D | mcp_reports.php | 395 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 D | mcp_reports.php | 300 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 D | mcp_main.php | 251 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 D | fulltext_native.php | 341 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 D | content_visibility.php | 292 …$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 D | auth.php | 127 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 D | auth.php | 129 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 D | feed.php | 773 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 D | mcp.php | 387 '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);
|