From 0077cb99704fe863cf731fc5cab792af2ede96c2 Mon Sep 17 00:00:00 2001
From: Joseph Hunkeler <jhunkeler@gmail.com>
Date: Sun, 17 Apr 2011 20:13:07 -0400
Subject: Backporting retarded amount of changes outside of version control

---
 admin/rudi/includes/functions.battles.php | 70 +++++++++++++++++++++++++++++++
 1 file changed, 70 insertions(+)
 create mode 100644 admin/rudi/includes/functions.battles.php

(limited to 'admin/rudi/includes/functions.battles.php')

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
-- 
cgit