diff options
| author | Joseph Hunkeler <jhunkeler@gmail.com> | 2013-08-19 09:41:19 -0400 |
|---|---|---|
| committer | Joseph Hunkeler <jhunkeler@gmail.com> | 2013-08-19 09:41:19 -0400 |
| commit | c5eb569f5122d4140952bd5cc7ad4fdc5fbf8a23 (patch) | |
| tree | 37024ec14fde9fef92eef8e9f997f72731e5155d /admin/rudi/includes/functions.members.php | |
| parent | 41d7bde950d6166a6cc414a48d0fa57f3fd9a512 (diff) | |
| parent | 50f14f6bee7e1efaac5971579fc2e76c728ecad6 (diff) | |
| download | bayonetcms-c5eb569f5122d4140952bd5cc7ad4fdc5fbf8a23.tar.gz | |
Some more stuff
Diffstat (limited to 'admin/rudi/includes/functions.members.php')
| -rw-r--r-- | admin/rudi/includes/functions.members.php | 44 |
1 files changed, 42 insertions, 2 deletions
diff --git a/admin/rudi/includes/functions.members.php b/admin/rudi/includes/functions.members.php index 86848dc..4a93134 100644 --- a/admin/rudi/includes/functions.members.php +++ b/admin/rudi/includes/functions.members.php @@ -37,8 +37,13 @@ function GetMembersRoles($member_id){ global $db; $row = NULL; - $query = sprintf("SELECT r.role_id, r.name AS role_name FROM rudi_roles AS r LEFT OUTER JOIN rudi_roles_container AS rl USING(role_id) INNER JOIN rudi_unit_members AS rm USING(member_id) WHERE rm.member_id = %d AND r.name IS NOT NULL ORDER BY r.role_id ASC", - (int)$member_id); + $query = sprintf("SELECT r.role_id, r.name AS role_name + FROM rudi_roles AS r + LEFT OUTER JOIN rudi_roles_container AS rl USING(role_id) + INNER JOIN rudi_unit_members AS rm USING(member_id) + WHERE rm.member_id = %d + AND r.name IS NOT NULL + ORDER BY r.role_id ASC", (int)$member_id); $result = $db->Query($query); $row = $db->Fetch($result); @@ -299,4 +304,39 @@ CloseTable(); $form->__destruct(); } + + + + + function DeleteMember($member_id) + { + // FROM unit_members, service_record, award_record FOR member_id + global $db; + + $db->Query("DELETE FROM `rudi_unit_members`, + `rudi_service_record`, + `rudi_award_record`, + `rudi_combat_record`, + `rudi_drills_record` + USING `rudi_unit_members` + INNER JOIN `rudi_award_record` USING(member_id) + INNER JOIN `rudi_service_record` USING(member_id) + INNER JOIN `rudi_combat_record` USING(member_id) + INNER JOIN `rudi_drills_record` USING(member_id) + WHERE `member_id` = $member_id"); + decho("DELETE FROM `rudi_unit_members`, + `rudi_service_record`, + `rudi_award_record`, + `rudi_combat_record`, + `rudi_drills_record` + USING `rudi_unit_members` + INNER JOIN `rudi_award_record` USING(member_id) + INNER JOIN `rudi_service_record` USING(member_id) + INNER JOIN `rudi_combat_record` USING(member_id) + INNER JOIN `rudi_drills_record` USING(member_id) + WHERE `member_id` = $member_id"); + decho("Done."); + return; + } + ?>
\ No newline at end of file |