| 319 | case 'violent_systems': |
| 320 | $html .= "<div class=block-header2>Most violent systems</div>"; |
| 321 | $html .= "<table width=\"99%\"><tr><td align=center valign=top>"; |
| 322 | |
| 323 | $html .= "<div class=block-header>This month</div>"; |
| 324 | $html .= "<table class=kb-table>"; |
| 325 | $html .= "<tr class=kb-table-header><td>#</td><td width=180>System</td><td width=40 align=center >Kills</td></tr>"; |
| 326 | |
| 327 | $sql = "select sys.sys_name, sys.sys_sec, sys.sys_id, count(distinct kll.kll_id) as kills |
| 328 | from kb3_systems sys, kb3_kills kll, kb3_inv_detail inv |
| 329 | where kll.kll_system_id = sys.sys_id |
| 330 | and inv.ind_kll_id = kll.kll_id"; |
| 331 | |
| 332 | if ($crp_id) |
| 333 | $sql .= " and inv.ind_crp_id in (".$crp_id.")"; |
| 334 | if (ALLIANCE_ID) |
| 335 | $sql .= " and inv.ind_all_id = ".ALLIANCE_ID; |
| 336 | |
| 337 | $sql .= " and date_format( kll.kll_timestamp, \"%c\" ) = ".date("m")." |
| 338 | and date_format( kll.kll_timestamp, \"%Y\" ) = ".date("Y")." |
| 339 | group by sys.sys_name |
| 340 | order by kills desc |
| 341 | limit 25"; |
| 342 | |
| 343 | $qry = new DBQuery(); |
| 344 | $qry->execute($sql); |
| 345 | $odd = false; |
| 346 | $counter = 1; |
| 347 | while ($row = $qry->getRow()) |
| 348 | { |
| 349 | if (!$odd) |
| 350 | { |
| 351 | $odd = true; |
| 352 | $rowclass = 'kb-table-row-odd'; |
| 353 | } |
| 354 | else |
| 355 | { |
| 356 | $odd = false; |
| 357 | $rowclass = 'kb-table-row-even'; |
| 358 | } |
| 359 | |
| 360 | $html .= "<tr class=".$rowclass."><td><b>".$counter.".</b></td><td class=kb-table-cell width=180><b><a href=\"?a=system_detail&sys_id=".$row['sys_id']."\">".$row['sys_name']."</a></b> (".roundsec($row['sys_sec']).")</td><td align=center>".$row['kills']."</td></tr>"; |
| 361 | $counter++; |
| 362 | } |
| 363 | |
| 364 | $html .= "</table>"; |
| 365 | |
| 366 | $html .= "</td><td align=center valign=top>"; |
| 367 | $html .= "<div class=block-header>All-Time</div>"; |
| 368 | $html .= "<table class=kb-table>"; |
| 369 | $html .= "<tr class=kb-table-header><td>#</td><td width=180>System</td><td width=40 align=center>Kills</td></tr>"; |
| 370 | |
| 371 | $sql = "select sys.sys_name, sys.sys_id, sys.sys_sec, count(distinct kll.kll_id) as kills |
| 372 | from kb3_systems sys, kb3_kills kll, kb3_inv_detail inv |
| 373 | where kll.kll_system_id = sys.sys_id |
| 374 | and inv.ind_kll_id = kll.kll_id"; |
| 375 | |
| 376 | if ($crp_id) |
| 377 | $sql .= " and inv.ind_crp_id in (".$crp_id.")"; |
| 378 | if ($all_id) |
| 379 | $sql .= " and inv.ind_all_id = ".$all_id; |
| 380 | |
| 381 | $sql .= " group by sys.sys_name |
| 382 | order by kills desc |
| 383 | limit 25"; |
| 384 | |
| 385 | $qry = new DBQuery(); |
| 386 | $qry->execute($sql); |
| 387 | $odd = false; |
| 388 | $counter = 1; |
| 389 | while ($row = $qry->getRow()) |
| 390 | { |
| 391 | if (!$odd) |
| 392 | { |
| 393 | $odd = true; |
| 394 | $rowclass = 'kb-table-row-odd'; |
| 395 | } |
| 396 | else |
| 397 | { |
| 398 | $odd = false; |
| 399 | $rowclass = 'kb-table-row-even'; |
| 400 | } |
| 401 | |
| 402 | $html .= "<tr class=".$rowclass."><td><b>".$counter.".</b></td><td class=kb-table-cell><b><a href=\"?a=system_detail&sys_id=".$row['sys_id']."\">".$row['sys_name']."</a></b> (".roundsec($row['sys_sec']).")</td><td align=center>".$row['kills']."</td></tr>"; |
| 403 | $counter++; |
| 404 | } |
| 405 | $html .= "</table>"; |
| 406 | $html .= "</td></tr></table>"; |
| 407 | break; |