[ShishaPipeUK]

Jon, i used your duplicate account script, great work, thank you for this.

I have a small problem, when i use this on 4.0.18 it works great but then when i go to the users, with this script still open in a new window, i have to re log into admin.

I get:
Main page :: Warning

Access denied !
You are not allowed to access that resource!

Error ID: 37

I presume you wrote this to show in a new window so you can go to the users in admin and delete the duplicate accounts.

So is there a way where i dont have to re log in as an admin.

Code is below you supplied, i posted it because you offer it free as well, hope you dont mind.

I of cause edited my shopcart/skin1/admin/menu_admin.tpl and yes i put in a _blank command to show in a new window, code below.

Duplicate Users

I have the duplicate_accounts.php in my shopcart/admin directory

<?php
#
# WebsiteCM.com - Free Script
# This script will list duplicate accounts
#

require "./auth.php";
require $xcart_dir."/include/security.php";

echo "

<font face=arial size=3>Duplicate Accounts by First and Last Name</font></p>";

$duplicates = func_query("select login,firstname,lastname,email,count(*) as duplicate from xcart_customers WHERE usertype='C' GROUP BY lastname,firstname ORDER BY duplicate DESC");
echo "<table border=0 cellpadding=3 cellspacing=2>";
echo "<tr>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>First Name</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Last Name</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Accounts</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Login Names</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Emails</font></td>";
echo "</tr>";

$bgcolor = "";

if (!empty($duplicates)) {
	foreach ($duplicates as $key=>$value) {
		if ($value[duplicate] > 1) {
			if ($bgcolor == "") { $bgcolor = "#EEEEEE"; }
			else { $bgcolor = ""; }
			$logins = func_query("select login from xcart_customers WHERE firstname='$value[firstname]' AND lastname = '$value[lastname]'");
			$login_names = "";
			foreach ($logins as $login) {
				$login_names .= $login[login] . "
";
			}
			$emails = func_query("select email from xcart_customers WHERE firstname='$value[firstname]' AND lastname = '$value[lastname]'");
			$email_addys = "";
			foreach ($emails as $email) {
				$email_addys .= $email[email] . "
";
			}
			echo "<tr>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[firstname] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[lastname] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[duplicate] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $login_names . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $email_addys . "</font></td>";
			echo "</tr>";
		}
	}
} else {
	echo "<tr><td><font face=arial size=2>There are no duplicate accounts to list.</font></td></tr>";
}
echo "</table>";

echo "

<font face=arial size=3>Duplicate Accounts by Email Address</font></p>";

$duplicates = func_query("select login,firstname,lastname,email,count(*) as duplicate from xcart_customers WHERE usertype='C' GROUP BY email ORDER BY duplicate DESC");
echo "<table border=0 cellpadding=3 cellspacing=2>";
echo "<tr>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>First Name</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Last Name</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Accounts</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Login Names</font></td>";
echo "<td bgcolor=#000000><font face=arial size=2 color=#FFFFF>Email</font></td>";
echo "</tr>";

$bgcolor = "";

if (!empty($duplicates)) {
	foreach ($duplicates as $key=>$value) {
		if ($value[duplicate] > 1) {
			if ($bgcolor == "") { $bgcolor = "#EEEEEE"; }
			else { $bgcolor = ""; }
			$logins = func_query("select login from xcart_customers WHERE email = '$value[email]'");
			$login_names = "";
			foreach ($logins as $login) {
				$login_names .= $login[login] . "
";
			}
			echo "<tr>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[firstname] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[lastname] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[duplicate] . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $login_names . "</font></td>";
			echo "<td valign=top bgcolor=" . $bgcolor . "><font face=arial size=2>" . $value[email] . "</font></td>";
			echo "</tr>";
		}
	}
} else {
	echo "<tr><td><font face=arial size=2>There are no duplicate accounts to list.</font></td></tr>";
}
echo "</table>";
?>