Duplicate Search

[jenigma]

Is there a mod for admin to search for duplicate i.p. addresses, and duplicate email addresses, to easily find out those who have multiple identities?

If not, I hope someone will make one soon.

[[Unknown]]

You can't have duplicate emails.

Here: (I wrote this a LONG time ago...)

Code Select Expand

<?phprequire 'Settings.php';require $sourcedir . '/Subs.php';require $sourcedir . '/Load.php';require $sourcedir . '/Errors.php';$dbcon = mysql_connect ($db_server, $db_user, $db_passwd);mysql_select_db ($db_name);LoadCookie();LoadUserSettings();$modSettings = array();$request = mysql_query("   SELECT variable, value   FROM {$db_prefix}settings   WHERE variable != 'agreement'") or database_error(__FILE__, __LINE__);while ($row = mysql_fetch_assoc($request))   $modSettings[$row['variable']] = $row['value'];$chklngfile = $chklngfile2 = $settings[23];if ($modSettings['userLanguage'] == 1){   if ($chklngfile == Null)      include_once($language);   else      include_once($chklngfile2);}else   include_once($language);Duplicates();function Duplicates(){   global $db_prefix, $scripturl, $color, $yytitle;      $yytitle = 'Duplicates';   template_header();   $q = mysql_query("      SELECT DISTINCT m.memberIP AS ip, m.memberName AS user, m.realName AS name      FROM {$db_prefix}members AS m, {$db_prefix}members AS m2      WHERE m.memberIP = m2.memberIP         AND m.ID_MEMBER != m2.ID_MEMBER      ORDER BY m.memberIP, m.memberName") or database_error(__FILE__, __LINE__);   $q2 = mysql_query("      SELECT posts, memberName AS name      FROM {$db_prefix}members");         $r2 = mysql_fetch_table($q2, 'name', 'posts');      $colors[0] = $color['windowbg'];   $colors[1] = $color['windowbg2'];   $i = 1;      if ($r = mysql_num_rows($q))   {      echo '         <table cellspacing="0" cellpadding="0" width="100%">';      while($r = mysql_fetch_assoc($q))      {         if ($r['ip'] != $lastip) $i = $i ^ 1;         $lastip = $r['ip'];         echo '            <tr bgcolor="' . $colors[$i] . '">               <td><a href="' . $scripturl . '?action=viewprofile&user=' . $r['user'] . '">' . $r['name'] . '</a> (' . $r['user'] . ') with ' . $r2[$r['user']] . ' posts.</td>               <td align="right"><a href="http://www.nic.com/cgi-bin/whois.cgi?query=' . $r['ip'] . '">' . $r['ip'] . '</td>            </tr>';      }      echo '         </table>';   }      footer();   obExit();}function mysql_fetch_table($query = '', $idname = '', $selname = '', $call = ''){   assert_options(ASSERT_ACTIVE, 1);   assert_options(ASSERT_WARNING, 1);   assert($query != '');   while($row = mysql_fetch_assoc($query))   {      if($selname == '')      {         if($idname == '') $rows[] = (($call == '') ? ($row) : ($call($row)));         else $rows[$row[$idname]] = (($call == '') ? ($row) : ($call($row)));      }      else      {         if($idname == '') $rows[] = (($call == '') ? ($row[$selname]) : ($call($row[$selname])));         else $rows[$row[$idname]] = (($call == '') ? ($row[$selname]) : ($call($row[$selname])));      }   }   return $rows;}?>

-[Unknown]

[jenigma]

Thanks Unknown.

Where do I add this code?

[[Unknown]]

It's a completely seperate file.... just save it as "duplicate.php" or something in your YaBB SE folder.

-[Unknown]

[jenigma]

Ah okay.

Beautiful. Thanks so much. I love that it shows how many posts each person has.