26 lines
655 B
PHP
26 lines
655 B
PHP
<?php
|
|
|
|
|
|
|
|
/* $Id: admin_general.php 8 2009-01-11 06:02:53Z john $ */
|
|
|
|
|
|
|
|
$page = "admin_general";
|
|
|
|
include "admin_header.php";
|
|
|
|
$query=$database->database_query("SELECT *, COUNT(*) FROM se_groupmembers WHERE `groupmember_group_id`=1763 GROUP BY `groupmember_user_id` HAVING COUNT(*) > 1 ORDER BY `COUNT(*)` DESC");
|
|
|
|
while($row=$database->database_fetch_array($query))
|
|
{
|
|
$database->database_query("UPDATE se_groupmembers SET duplicate='1' WHERE groupmember_id='".$row["groupmember_id"]."'");
|
|
|
|
echo $row["groupmember_id"]."ssss<br />";
|
|
}
|
|
|
|
$database->database_query("DELETE FROM se_groupmembers WHERE `duplicate`='1'");
|
|
exit;
|
|
include "admin_footer.php";
|
|
|
|
?>
|