Files
Testing/bwadmin/fixduplicates.php

26 lines
655 B
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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";
?>