Updating Group 30

"; // Start transaction $conn->begin_transaction(); try { // Step 1: Update group name in InviteEventGroups echo "

Step 1: Updating group name from 'LadiesPink' to 'LadiesFriendlies'...

"; $updateGroupStmt = $conn->prepare("UPDATE InviteEventGroups SET eventGroupName = ? WHERE groupNumber = 30"); $newGroupName = "LadiesFriendlies"; $updateGroupStmt->bind_param("s", $newGroupName); if ($updateGroupStmt->execute()) { $affectedRows = $updateGroupStmt->affected_rows; echo "

✅ Successfully updated group name to 'LadiesFriendlies' (affected rows: $affectedRows)

"; } else { throw new Exception("Failed to update group name: " . $conn->error); } $updateGroupStmt->close(); // Step 2: Find admin user by memberId echo "

Step 2: Finding admin user (memberId: 999930)...

"; $adminMemberId = "999930"; $findAdminStmt = $conn->prepare("SELECT id, name FROM Users WHERE memberId = ?"); $findAdminStmt->bind_param("s", $adminMemberId); $findAdminStmt->execute(); $adminResult = $findAdminStmt->get_result(); if ($adminResult->num_rows == 0) { throw new Exception("Admin user with memberId 999930 not found. Please create admin user first."); } $adminRow = $adminResult->fetch_assoc(); $adminUserId = $adminRow['id']; $currentAdminName = $adminRow['name']; echo "

ℹ️ Found admin user (ID: $adminUserId, Current Name: " . htmlspecialchars($currentAdminName) . ")

"; $findAdminStmt->close(); // Step 3: Update admin user name echo "

Step 3: Updating admin user name to 'Admin LadiesFriendlies'...

"; $newAdminName = "Admin LadiesFriendlies"; $updateAdminStmt = $conn->prepare("UPDATE Users SET name = ? WHERE id = ?"); $updateAdminStmt->bind_param("si", $newAdminName, $adminUserId); if ($updateAdminStmt->execute()) { $affectedRows = $updateAdminStmt->affected_rows; echo "

✅ Successfully updated admin user name to 'Admin LadiesFriendlies' (affected rows: $affectedRows)

"; } else { throw new Exception("Failed to update admin user name: " . $conn->error); } $updateAdminStmt->close(); // Step 4: Check current users in the group echo "

Step 4: Checking current users in group 30...

"; $checkUsersStmt = $conn->prepare("SELECT id FROM InviteGroupUsers WHERE groupNo = 30"); $checkUsersStmt->execute(); $result = $checkUsersStmt->get_result(); $userIds = []; while ($row = $result->fetch_assoc()) { $userIds[] = $row['id']; } $checkUsersStmt->close(); $totalUsers = count($userIds); echo "

ℹ️ Found $totalUsers users in group 30

"; // Step 5: Delete all users except admin echo "

Step 5: Removing users except admin (ID: $adminUserId)...

"; $deleteStmt = $conn->prepare("DELETE FROM InviteGroupUsers WHERE groupNo = 30 AND id != ?"); $deleteStmt->bind_param("i", $adminUserId); if ($deleteStmt->execute()) { $deletedRows = $deleteStmt->affected_rows; echo "

✅ Successfully removed $deletedRows users from group 30

"; // Verify admin is still in the group $verifyStmt = $conn->prepare("SELECT COUNT(*) as count FROM InviteGroupUsers WHERE groupNo = 30 AND id = ?"); $verifyStmt->bind_param("i", $adminUserId); $verifyStmt->execute(); $verifyResult = $verifyStmt->get_result(); $verifyRow = $verifyResult->fetch_assoc(); $verifyStmt->close(); if ($verifyRow['count'] > 0) { echo "

✅ Verified: Admin (ID: $adminUserId) is still in group 30

"; } else { // If admin is not in group, add them echo "

ℹ️ Admin not found in group 30, adding admin to group...

"; $addAdminStmt = $conn->prepare("INSERT INTO InviteGroupUsers (id, groupNo) VALUES (?, 30)"); $addAdminStmt->bind_param("i", $adminUserId); if ($addAdminStmt->execute()) { echo "

✅ Admin added to group 30

"; } else { throw new Exception("Failed to add admin to group: " . $conn->error); } $addAdminStmt->close(); } } else { throw new Exception("Failed to delete users: " . $conn->error); } $deleteStmt->close(); // Commit transaction $conn->commit(); echo "
"; echo "

✅ All updates completed successfully!

"; echo "

Summary:

"; echo ""; } catch (Exception $e) { // Rollback transaction on error $conn->rollback(); echo "

❌ Error: " . htmlspecialchars($e->getMessage()) . "

"; echo "

Transaction rolled back. No changes were made.

"; } // Show final state echo "
"; echo "

Final State Verification

"; // Check group name $finalGroupStmt = $conn->prepare("SELECT eventGroupName FROM InviteEventGroups WHERE groupNumber = 30"); $finalGroupStmt->execute(); $finalGroupResult = $finalGroupStmt->get_result(); if ($finalGroupRow = $finalGroupResult->fetch_assoc()) { echo "

Group name: " . htmlspecialchars($finalGroupRow['eventGroupName']) . "

"; } $finalGroupStmt->close(); // Check admin user name $finalAdminStmt = $conn->prepare("SELECT id, name, memberId FROM Users WHERE memberId = '999930'"); $finalAdminStmt->execute(); $finalAdminResult = $finalAdminStmt->get_result(); if ($finalAdminRow = $finalAdminResult->fetch_assoc()) { echo "

Admin user: " . htmlspecialchars($finalAdminRow['name']) . " (ID: " . $finalAdminRow['id'] . ", memberId: " . $finalAdminRow['memberId'] . ")

"; } $finalAdminStmt->close(); // Check remaining users $finalUsersStmt = $conn->prepare("SELECT id FROM InviteGroupUsers WHERE groupNo = 30 ORDER BY id"); $finalUsersStmt->execute(); $finalUsersResult = $finalUsersStmt->get_result(); $remainingUsers = []; while ($row = $finalUsersResult->fetch_assoc()) { $remainingUsers[] = $row['id']; } $finalUsersStmt->close(); echo "

Remaining users in group 30: " . count($remainingUsers) . "

"; if (count($remainingUsers) > 0) { echo ""; } $conn->close(); echo ""; ?>