| @@ 1298-1311 (lines=14) @@ | ||
| 1295 | $smcFunc['db_free_result']($request); |
|
| 1296 | } |
|
| 1297 | ||
| 1298 | if (!empty($new_loaded_ids) && $set !== 'minimal') |
|
| 1299 | { |
|
| 1300 | $request = $smcFunc['db_query']('', ' |
|
| 1301 | SELECT id_member, variable, value |
|
| 1302 | FROM {db_prefix}themes |
|
| 1303 | WHERE id_member IN ({array_int:loaded_ids})', |
|
| 1304 | array( |
|
| 1305 | 'loaded_ids' => $new_loaded_ids, |
|
| 1306 | ) |
|
| 1307 | ); |
|
| 1308 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 1309 | $user_profile[$row['id_member']]['options'][$row['variable']] = $row['value']; |
|
| 1310 | $smcFunc['db_free_result']($request); |
|
| 1311 | } |
|
| 1312 | ||
| 1313 | $additional_mods = array(); |
|
| 1314 | ||
| @@ 2576-2597 (lines=22) @@ | ||
| 2573 | if (!empty($to_label) && $context['folder'] == 'inbox') |
|
| 2574 | { |
|
| 2575 | // Are we dealing with conversation view? If so, get all the messages in each conversation |
|
| 2576 | if ($context['display_mode'] == 2) |
|
| 2577 | { |
|
| 2578 | $get_pms = $smcFunc['db_query']('', ' |
|
| 2579 | SELECT pm.id_pm_head, pm.id_pm |
|
| 2580 | FROM {db_prefix}personal_messages AS pm |
|
| 2581 | INNER JOIN {db_prefix}pm_recipients AS pmr ON (pmr.id_pm = pm.id_pm) |
|
| 2582 | WHERE pm.id_pm_head IN ({array_int:head_pms}) |
|
| 2583 | AND pm.id_pm NOT IN ({array_int:head_pms}) |
|
| 2584 | AND pmr.id_member = {int:current_member}', |
|
| 2585 | array( |
|
| 2586 | 'head_pms' => array_keys($to_label), |
|
| 2587 | 'current_member' => $user_info['id'], |
|
| 2588 | ) |
|
| 2589 | ); |
|
| 2590 | ||
| 2591 | while ($other_pms = $smcFunc['db_fetch_assoc']($get_pms)) |
|
| 2592 | { |
|
| 2593 | $to_label[$other_pms['id_pm']] = $to_label[$other_pms['id_pm_head']]; |
|
| 2594 | } |
|
| 2595 | ||
| 2596 | $smcFunc['db_free_result']($get_pms); |
|
| 2597 | } |
|
| 2598 | ||
| 2599 | // Get information about each message... |
|
| 2600 | $request = $smcFunc['db_query']('', ' |
|
| @@ 3711-3724 (lines=14) @@ | ||
| 3708 | if ($criteria['t'] == 'mid' && !empty($criteria['v'])) |
|
| 3709 | $members[(int) $criteria['v']] = $k; |
|
| 3710 | ||
| 3711 | if (!empty($members)) |
|
| 3712 | { |
|
| 3713 | $request = $smcFunc['db_query']('', ' |
|
| 3714 | SELECT id_member, member_name |
|
| 3715 | FROM {db_prefix}members |
|
| 3716 | WHERE id_member IN ({array_int:member_list})', |
|
| 3717 | array( |
|
| 3718 | 'member_list' => array_keys($members), |
|
| 3719 | ) |
|
| 3720 | ); |
|
| 3721 | while ($row = $smcFunc['db_fetch_assoc']($request)) |
|
| 3722 | $context['rule']['criteria'][$members[$row['id_member']]]['v'] = $row['member_name']; |
|
| 3723 | $smcFunc['db_free_result']($request); |
|
| 3724 | } |
|
| 3725 | } |
|
| 3726 | else |
|
| 3727 | $context['rule'] = array( |
|