Changeset 171

Timestamp:

01/07/07 04:56:49 (14 years ago)

Author:

Mitchman

Message:

"Most violent systems" on corp/alliance detail screen will now correctly show for the selected corp/alliance (Reported by ralle030583). The known_members mod has been fixed to correctly handle this too.

Location:

dev

Files:

• common/corp_detail.php (modified) (4 diffs)
• mods/known_members/corp_detail.php (modified) (3 diffs)

dev/common/corp_detail.php

@@ -15 +15 @@
     exit;
 }
+$all_id = $_GET['all_id'];
 $corp = new Corporation($crp_id);
 $alliance = $corp->getAlliance();
@@ -322 +323 @@
                     and inv.ind_kll_id = kll.kll_id";
 
-        if (CORP_ID)
-            $sql .= " and inv.ind_crp_id in (".CORP_ID.")";
-        if (ALLIANCE_ID)
-            $sql .= " and inv.ind_all_id = ".ALLIANCE_ID;
+        if ($crp_id)
+            $sql .= " and inv.ind_crp_id in (".$crp_id.")";
+        if ($all_id)
+            $sql .= " and inv.ind_all_id = ".$all_id;
 
         $sql .= "   and date_format( kll.kll_timestamp, \"%c\" ) = ".date("m")."
@@ -366 +367 @@
                     and inv.ind_kll_id = kll.kll_id";
 
-        if (CORP_ID)
-            $sql .= " and inv.ind_crp_id in (".CORP_ID.")";
-        if (ALLIANCE_ID)
-            $sql .= " and inv.ind_all_id = ".ALLIANCE_ID;
+        if ($crp_id)
+            $sql .= " and inv.ind_crp_id in (".$crp_id.")";
+        if ($all_id)
+            $sql .= " and inv.ind_all_id = ".$all_id;
 
         $sql .= " group by sys.sys_name
@@ -397 +398 @@
         $html .= "</table>";
         $html .= "</td></tr></table>";
-    break;
+        break;
 }
 

dev/mods/known_members/corp_detail.php

@@ -12 +12 @@
 
 
-$corp = new Corporation(intval($_GET['crp_id']));
+if (!$crp_id = intval($_GET['crp_id']))
+{
+    echo 'no valid corp id specified<br/>';
+    exit;
+}
+$all_id = $_GET['all_id'];
+$corp = new Corporation($crp_id);
 $alliance = $corp->getAlliance();
 
@@ -311 +317 @@
         break;
                 
+    case 'violent_systems':
+        $html .= "<div class=block-header2>Most violent systems</div>";
+        $html .= "<table width=\"99%\"><tr><td align=center valign=top>";
+
+        $html .= "<div class=block-header>This month</div>";
+        $html .= "<table class=kb-table>";
+        $html .= "<tr class=kb-table-header><td>#</td><td width=180>System</td><td width=40 align=center >Kills</td></tr>";
+
+        $sql = "select sys.sys_name, sys.sys_sec, sys.sys_id, count(distinct kll.kll_id) as kills
+                    from kb3_systems sys, kb3_kills kll, kb3_inv_detail inv
+                    where kll.kll_system_id = sys.sys_id
+                    and inv.ind_kll_id = kll.kll_id";
+
+        if ($crp_id)
+            $sql .= " and inv.ind_crp_id in (".$crp_id.")";
+        if (ALLIANCE_ID)
+            $sql .= " and inv.ind_all_id = ".ALLIANCE_ID;
+
+        $sql .= "   and date_format( kll.kll_timestamp, \"%c\" ) = ".date("m")."
+                    and date_format( kll.kll_timestamp, \"%Y\" ) = ".date("Y")."
+                    group by sys.sys_name
+                    order by kills desc
+                    limit 25";
+
+        $qry = new DBQuery();
+        $qry->execute($sql);
+        $odd = false;
+        $counter = 1;
+        while ($row = $qry->getRow())
+        {
+            if (!$odd)
+            {
+                $odd = true;
+                $rowclass = 'kb-table-row-odd';
+            }
+            else
+            {
+                $odd = false;
+                $rowclass = 'kb-table-row-even';
+            }
+
+            $html .= "<tr class=".$rowclass."><td><b>".$counter.".</b></td><td class=kb-table-cell width=180><b><a href=\"?a=system_detail&amp;sys_id=".$row['sys_id']."\">".$row['sys_name']."</a></b> (".roundsec($row['sys_sec']).")</td><td align=center>".$row['kills']."</td></tr>";
+            $counter++;
+        }
+
+        $html .= "</table>";
+
+        $html .= "</td><td align=center valign=top>";
+        $html .= "<div class=block-header>All-Time</div>";
+        $html .= "<table class=kb-table>";
+        $html .= "<tr class=kb-table-header><td>#</td><td width=180>System</td><td width=40 align=center>Kills</td></tr>";
+
+        $sql = "select sys.sys_name, sys.sys_id, sys.sys_sec, count(distinct kll.kll_id) as kills
+                    from kb3_systems sys, kb3_kills kll, kb3_inv_detail inv
+                    where kll.kll_system_id = sys.sys_id
+                    and inv.ind_kll_id = kll.kll_id";
+
+        if ($crp_id)
+            $sql .= " and inv.ind_crp_id in (".$crp_id.")";
+        if ($all_id)
+            $sql .= " and inv.ind_all_id = ".$all_id;
+
+        $sql .= " group by sys.sys_name
+                    order by kills desc
+                    limit 25";
+
+        $qry = new DBQuery();
+        $qry->execute($sql);
+        $odd = false;
+        $counter = 1;
+        while ($row = $qry->getRow())
+        {
+            if (!$odd)
+            {
+                $odd = true;
+                $rowclass = 'kb-table-row-odd';
+            }
+            else
+            {
+                $odd = false;
+                $rowclass = 'kb-table-row-even';
+            }
+
+            $html .= "<tr class=".$rowclass."><td><b>".$counter.".</b></td><td class=kb-table-cell><b><a href=\"?a=system_detail&amp;sys_id=".$row['sys_id']."\">".$row['sys_name']."</a></b> (".roundsec($row['sys_sec']).")</td><td align=center>".$row['kills']."</td></tr>";
+            $counter++;
+        }
+        $html .= "</table>";
+        $html .= "</td></tr></table>";
+            break;
                 
    case "known_members":
@@ -452 +547 @@
 $menubox->addOption("caption","Global statistics");
 $menubox->addOption("link","Ships & weapons", "?a=corp_detail&crp_id=" . $corp->getID() . "&view=ships_weapons");
+$menubox->addOption("link","Most violent systems", "?a=corp_detail&crp_id=" . $corp->getID() . "&view=violent_systems");
 $menubox->addOption("link","Known Members", "?a=corp_detail&crp_id=" . $corp->getID() . "&view=known_members");
 $page->addContext($menubox->generate());