Skip to content

Instantly share code, notes, and snippets.

@Spuds
Created April 6, 2013 16:15
Show Gist options
  • Save Spuds/5326635 to your computer and use it in GitHub Desktop.
Save Spuds/5326635 to your computer and use it in GitHub Desktop.
loadMemberData query
$request = $smcFunc['db_query']('', '
SELECT variable, value
FROM {db_prefix}themes
WHERE id_member' . (count($new_loaded_ids) == 1 ? ' = {int:loaded_ids}' : ' IN ({array_int:loaded_ids})'),
array(
'loaded_ids' => count($new_loaded_ids) == 1 ? $new_loaded_ids[0] : $new_loaded_ids,
)
);
while ($row = $smcFunc['db_fetch_assoc']($request))
$user_profile[$row['id_member']]['options'][$row['variable']] = $row['value'];
$smcFunc['db_free_result']($request);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment