Files
Testing/bwadmin/fixduplicates.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

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";
?>