diff options
| author | jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6> | 2011-04-17 12:49:09 -0400 |
|---|---|---|
| committer | jhunkeler <jhunkeler@c5b2fb0a-d05d-0410-98c8-828840a80ff6> | 2011-04-17 12:49:09 -0400 |
| commit | fa8180ea3a41584943dd7464eb8c3cad769d8211 (patch) | |
| tree | 9d52ffcd157d29f322226b467d7fe70eaa502388 /admin/rudi/views/view.members.php | |
| parent | b3261cbea8c20989d2976a4816021438a668397d (diff) | |
| download | bayonetcms-fa8180ea3a41584943dd7464eb8c3cad769d8211.tar.gz | |
Jessus christ
git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2.1@491 c5b2fb0a-d05d-0410-98c8-828840a80ff6
Diffstat (limited to 'admin/rudi/views/view.members.php')
| -rw-r--r-- | admin/rudi/views/view.members.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/admin/rudi/views/view.members.php b/admin/rudi/views/view.members.php index 659ef2b..38929df 100644 --- a/admin/rudi/views/view.members.php +++ b/admin/rudi/views/view.members.php @@ -16,7 +16,7 @@ echo "<h3>Current Members</h3>"; echo "<table width=\"100%\" style=\"text-align:center;\">"; echo "<tr><th>Rank</th><th>Soldier</th><th>Main Info</th><th>Service Record</th><th>Medal Record</th></tr>"; - $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id != 4 AND rudi_unit_members.status_id != 5 ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); + $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id <= 3 ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); foreach($row as $member){ @@ -32,7 +32,7 @@ echo "<h3>Previous Members</h3>"; echo "<table width=\"100%\" style=\"text-align:center;\">"; echo "<tr><th>Rank</th><th>Soldier</th><th>Main Info</th><th>Service Record</th><th>Medal Record</th></tr>"; - $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id = 4 OR rudi_unit_members.status_id = 5 ORDER BY rudi_ranks.weight DESC, rudi_unit_members.date_promotion ASC, rudi_unit_members.date_enlisted ASC"); + $result = $db->Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id > 3 ORDER BY rudi_ranks.weight DESC, rudi_unit_members.date_promotion ASC, rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); foreach($row as $member){ |