IPb v1.12.
$DB->query("
SELECT mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post,
m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.last_visit, m.last_activity, m.dst_in_use,
m.view_prefs, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )
WHERE m.id='$member_id'");
Nv table
$DB->query("
SELECT moder.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post,
m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.last_visit, m.last_activity, m.dst_in_use,
m.view_prefs, g.*
FROM ibf_members m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moder ON (moder.member_id=m.id OR moder.group_id=m.mgroup )
WHERE m.id='$member_id'");