Multuple Accounts\n";
echo "This script discovers users who have potentially created multiple accounts by checking for IP addresses where multiple accounts have been seen.
\n";
$result = $smcFunc['db_query'] ('', "SELECT DISTINCT (m.poster_ip) AS poster_ip FROM {db_prefix}messages AS m ORDER BY m.poster_ip ASC", '');
if (!$result) {
die("Query failed: " . $smcFunc['db_error'] ());
}
while ($res = $smcFunc['db_fetch_assoc']($result)) {
// Skip blank IP
if (!$res['poster_ip']) {
continue;
}
$count = 0;
$users = "";
$result2 = $smcFunc['db_query'] ('', "SELECT DISTINCT (m.poster_name) FROM {db_prefix}messages AS m WHERE m.poster_ip = {string:poster_ip} ORDER BY m.poster_name ASC", array (
'poster_ip' => $res['poster_ip']
));
if (!$result) {
die("Query failed: " . $smcFunc['db_error'] ());
}
while ($res2 = $smcFunc['db_fetch_assoc']($result2)) {
$count++;
$mname = $smcFunc['htmlspecialchars'] ($res2['poster_name']);
// echo "MName: $mname [".$res2['poster_name']."]
";
$result3 = $smcFunc['db_query'] ('', "SELECT m.`id_member` FROM {db_prefix}members AS m WHERE m.`member_name` = \"$mname\"", '');
$res3 = $smcFunc['db_fetch_assoc']($result3);
$smcFunc['db_free_result']($result3);
if ($res3['id_member']) {
$users .= "";
}
$users .= $res2['poster_name'];
if ($res3['id_member']) {
$users .= "";
}
$users .= "
\n";
}
$smcFunc['db_free_result']($result2);
if ($count > 1) {
if (!$res['poster_ip']) {
echo "No Listed IP Address";
}
echo "" . $res['poster_ip'] . " ($count users)
\n";
echo $users;
echo "
\n";
}
}
$smcFunc['db_free_result']($result);
if ($armyca) {
include "$include_dir/footer.php";
}
?>