aboutsummaryrefslogtreecommitdiff
path: root/admin/rudi/includes
diff options
context:
space:
mode:
Diffstat (limited to 'admin/rudi/includes')
-rw-r--r--admin/rudi/includes/functions.awards.php38
-rw-r--r--admin/rudi/includes/functions.battles.php70
-rw-r--r--admin/rudi/includes/functions.members.php48
-rw-r--r--admin/rudi/includes/functions.units.php33
4 files changed, 166 insertions, 23 deletions
diff --git a/admin/rudi/includes/functions.awards.php b/admin/rudi/includes/functions.awards.php
index 439f0e1..0b4b1e2 100644
--- a/admin/rudi/includes/functions.awards.php
+++ b/admin/rudi/includes/functions.awards.php
@@ -1,20 +1,20 @@
-<?php
-
- function getAwardClasses(){
- global $db;
- $result = $db->Query("SELECT `name`, `class_id` FROM `rudi_award_classes`");
- return $db->Fetch($result);
- }
-
- function getAwardsByClass($class_id){
- global $db;
- $result = $db->Query("SELECT `award_id`, `name`, `image`, `description` FROM `rudi_awards` WHERE `class_id` = '$class_id' ORDER BY `name`");
- return $db->Fetch($result);
- }
-
- function getAward($award_id){
- global $db;
- $result = $db->Query("SELECT `award_id`, `name`, `image`, `description`, `class_id` FROM `rudi_awards` WHERE `award_id` = '$award_id' LIMIT 1");
- return $db->FetchRow($result);
- }
+<?php
+
+ function getAwardClasses(){
+ global $db;
+ $result = $db->Query("SELECT `name`, `class_id` FROM `rudi_award_classes`");
+ return $db->Fetch($result);
+ }
+
+ function getAwardsByClass($class_id){
+ global $db;
+ $result = $db->Query("SELECT `award_id`, `name`, `image`, `description` FROM `rudi_awards` WHERE `class_id` = '$class_id' ORDER BY `name`");
+ return $db->Fetch($result);
+ }
+
+ function getAward($award_id){
+ global $db;
+ $result = $db->Query("SELECT `award_id`, `name`, `image`, `description`, `class_id` FROM `rudi_awards` WHERE `award_id` = '$award_id' LIMIT 1");
+ return $db->FetchRow($result);
+ }
?> \ No newline at end of file
diff --git a/admin/rudi/includes/functions.battles.php b/admin/rudi/includes/functions.battles.php
new file mode 100644
index 0000000..2b878da
--- /dev/null
+++ b/admin/rudi/includes/functions.battles.php
@@ -0,0 +1,70 @@
+<?php
+
+ function getAllBattles(){
+ global $db;
+
+ $result = $db->Query("SELECT w.war_id,
+ w.title,
+ w.visit_unit_id,
+ w.home_score,
+ w.visit_score,
+ w.date,
+ w.status,
+ v.name
+ FROM rudi_war_stats AS w
+ LEFT OUTER JOIN rudi_war_units AS v
+ ON v.visitor_id = w.visit_unit_id
+ ORDER BY w.date");
+ $data = $db->Fetch($result);
+
+ return $data;
+ }
+
+ function getBattleInfo($war_id){
+ global $db;
+
+ $result = $db->Query("SELECT w.war_id,
+ w.title,
+ w.visit_unit_id,
+ w.home_score,
+ w.visit_score,
+ w.date,
+ w.status,
+ v.name
+ FROM rudi_war_stats AS w
+ LEFT OUTER JOIN rudi_war_units AS v
+ ON v.visitor_id = w.visit_unit_id
+ WHERE w.war_id = {$war_id}");
+ $data = $db->FetchRow($result);
+
+ return $data;
+ }
+
+ function getCombatSoldiers($war_id){
+ global $db;
+
+ $query = "SELECT m.member_id,
+ m.first_name,
+ m.last_name,
+ r.shortname,
+ r.longname,
+ w.record_id,
+
+ FROM rudi_combat_record AS w
+ JOIN rudi_unit_members AS m
+ ON m.member_id = w.member_id
+ JOIN rudi_ranks AS r
+ ON m.rank_id = r.rank_id
+ WHERE m.status_id < 4, w.war_id = {$war_id} OR w.war_id IS NULL
+ ORDER BY r.weight DESC , m.date_promotion ASC , m.date_enlisted ASC";
+
+ decho($query);
+ $result = $db->Query($query);
+ $data = $db->Fetch($result);
+
+
+
+ return $data;
+ }
+
+?> \ No newline at end of file
diff --git a/admin/rudi/includes/functions.members.php b/admin/rudi/includes/functions.members.php
index 6a4970e..86848dc 100644
--- a/admin/rudi/includes/functions.members.php
+++ b/admin/rudi/includes/functions.members.php
@@ -48,9 +48,17 @@
function GetRoles(){
global $db;
- $result = $db->Query("SELECT * FROM `rudi_roles`");
- $row = $db->Fetch($result);
- return $row;
+ $data = array();
+ $result = $db->Query("SELECT * FROM `rudi_role_classes` ORDER BY `weight` ASC");
+ $classes = $db->Fetch($result);
+
+ foreach($classes as $class){
+ $rclass_id = $class['rclass_id'];
+ $result2 = $db->Query("SELECT * FROM rudi_roles WHERE rclass_id = '$rclass_id' ORDER BY `weight` ASC");
+ $data[] = array("name" => $class['name'], "roles" => $db->Fetch($result2));
+ }
+
+ return $data;
}
function GetCountry(){
@@ -177,7 +185,7 @@
<td><?php echo date("M j Y", strtotime($record['date_added'])); ?></td>
<td><?php echo $record['record_note']; ?></td>
<td><a href="?op=rudi&show=members&award=<?php echo $member_id; ?>&edit=<?php echo $record['record_id']; ?>">Edit</a></td>
- <td><a href="?op=rudi&show=members&award=<?php echo $row['member_id']; ?>&delete=<?php echo $record['record_id']; ?>">Delete</a></td>
+ <td><a href="?op=rudi&show=members&award=<?php echo $member_id; ?>&delete=<?php echo $record['record_id']; ?>">Delete</a></td>
</tr>
<?php
}
@@ -224,6 +232,38 @@
}
+ function DeleteAwardRecord($record_id){
+ global $db;
+
+ $result = $db->Query("SELECT r.date_added, r.record_note, r.member_id, a.name FROM rudi_award_record AS r LEFT OUTER JOIN rudi_awards AS a ON a.award_id = r.award_id WHERE r.record_id = '$record_id' LIMIT 1");
+ $record = $db->FetchRow($result);
+ decho($record_id);
+ decho($record);
+ $form = new BayonetForm("", "POST");
+
+ if(isset($_POST['proceed']))
+ {
+ echo "Award '{$record['name']}', was deleted from that soldiers record.";
+ $db->Query("DELETE FROM `rudi_award_record` WHERE `record_id` = '$record_id' LIMIT 1");
+ PageRedirect(2, "?op=rudi&show=members&award={$record['member_id']}");
+ return;
+ }
+ if(isset($_POST['cancel']))
+ {
+ echo "User cancelled deletion of award: '{$record['name']}'";
+ PageRedirect(2, "?op=rudi&show=members&award={$award['member_id']}");
+ return;
+ }
+
+ OpenTable();
+?>
+ <th>Are you <u>SURE</u> you want to delete the award record: '<?php echo $record['name'];?>'? for this member?<br />All changes are final.</th>
+ <tr><th><button name="proceed">Yes</button>&nbsp;&nbsp;&nbsp;<button name="cancel">No</button></th></tr>
+<?php
+ CloseTable();
+ $form->__destruct();
+ }
+
function AddAwardRecord($member_id){
global $db;
diff --git a/admin/rudi/includes/functions.units.php b/admin/rudi/includes/functions.units.php
new file mode 100644
index 0000000..5005fa0
--- /dev/null
+++ b/admin/rudi/includes/functions.units.php
@@ -0,0 +1,33 @@
+<?php
+
+ function DisplayUnits(){
+ global $db;
+ $result = $db->Query("SELECT `unit_id`, `name` FROM `rudi_combat_units` WHERE `detachment` = 0 ");
+ $row = $db->Fetch($result);
+ foreach($row as $unit){
+ $unit_name = $unit['name'];
+ $unit_id = $unit['unit_id'];
+ echo '<img src="images/tree_branch.gif" />&nbsp;'.$unit_name.'<br />';
+ selectUnits($unit_id, 0, $member['cunit_id']);
+ }
+ }
+
+ function selectUnits($previous_unit, $indent, $members_unit){
+ global $db;
+
+ $indent++;
+ //$formatting = str_repeat("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;", $indent);
+ $formatting = str_repeat('<img src="images/tree_leaf.gif" />', $indent);
+
+ $result = $db->Query("SELECT `unit_id`, `name` FROM `rudi_combat_units` WHERE `detachment` = '$previous_unit'");
+ $row = $db->Fetch($result);
+ foreach($row as $unit){
+ $unit_id = $unit['unit_id'];
+ $unit_name = $unit['name'];
+ echo $formatting.'<img src="images/tree_branch.gif" />&nbsp;'.$unit_name.'<br />';
+
+ selectUnits($unit_id, $indent, $members_unit);
+ }
+ }
+
+?> \ No newline at end of file
generated by cgit (git 2.34.1) at 2025-04-28 20:28:31 -0400