| 144 | |
| 145 | break; |
| 146 | case "corp_kills_class": |
| 147 | $html .= "<div class=block-header2>Destroyed ships</div>"; |
| 148 | |
| 149 | // Get all ShipClasses |
| 150 | $sql = "select scl_id, scl_class from kb3_ship_classes |
| 151 | where scl_class not in ('Drone','Unknown') order by scl_class"; |
| 152 | |
| 153 | $qry = new DBQuery(); |
| 154 | $qry->execute($sql); |
| 155 | while ($row = $qry->getRow()) |
| 156 | { |
| 157 | $shipclass[] = new Shipclass($row['scl_id']); |
| 158 | } |
| 159 | $html .= "<table class=kb-subtable>"; |
| 160 | $html .= "<tr>"; |
| 161 | $newrow = true; |
| 162 | |
| 163 | foreach ($shipclass as $shp){ |
| 164 | if ($newrow){ |
| 165 | $html .= '</tr><tr>'; |
| 166 | } |
| 167 | $list = new TopCorpKillsList(); |
| 168 | $list->addInvolvedAlliance($alliance); |
| 169 | $list->addVictimShipClass($shp); |
| 170 | $table = new TopCorpTable($list, "Kills"); |
| 171 | $content = $table->generate(); |
| 172 | if ($content != '<table class=kb-table cellspacing=1><tr class=kb-table-header><td class=kb-table-cell align=center>#</td><td class=kb-table-cell align=center>Corporation</td><td class=kb-table-cell align=center width=60>Kills</td></tr></table>'){ |
| 173 | $html .= "<td valign=top width=440>"; |
| 174 | $html .= "<div class=block-header>".$shp->getName()."</div>"; |
| 175 | $html .= $content; |
| 176 | $html .= "</td>"; |
| 177 | $newrow = !$newrow; |
| 178 | } |
| 179 | |
| 180 | } |
| 181 | $html .= "</tr></table>"; |
| 182 | |
| 183 | break; |
| 184 | case "kills_class": |
| 185 | $html .= "<div class=block-header2>Destroyed ships</div>"; |
| 186 | |
| 187 | // Get all ShipClasses |
| 188 | $sql = "select scl_id, scl_class from kb3_ship_classes |
| 189 | where scl_class not in ('Drone','Unknown') order by scl_class"; |
| 190 | |
| 191 | $qry = new DBQuery(); |
| 192 | $qry->execute($sql); |
| 193 | while ($row = $qry->getRow()) |
| 194 | { |
| 195 | $shipclass[] = new Shipclass($row['scl_id']); |
| 196 | } |
| 197 | $html .= "<table class=kb-subtable>"; |
| 198 | $html .= "<tr>"; |
| 199 | $newrow = true; |
| 200 | |
| 201 | foreach ($shipclass as $shp){ |
| 202 | if ($newrow){ |
| 203 | $html .= '</tr><tr>'; |
| 204 | } |
| 205 | $list = new TopKillsList(); |
| 206 | $list->addInvolvedAlliance($alliance); |
| 207 | $list->addVictimShipClass($shp); |
| 208 | $table = new TopPilotTable($list, "Kills"); |
| 209 | $content = $table->generate(); |
| 210 | if ($content != '<table class=kb-table cellspacing=1><tr class=kb-table-header><td class=kb-table-cell align=center colspan=2>Pilot</td><td class=kb-table-cell align=center width=60>Kills</td></tr></table>'){ |
| 211 | $html .= "<td valign=top width=440>"; |
| 212 | $html .= "<div class=block-header>".$shp->getName()."</div>"; |
| 213 | $html .= $content; |
| 214 | $html .= "</td>"; |
| 215 | $newrow = !$newrow; |
| 216 | } |
| 217 | |
| 218 | } |
| 219 | $html .= "</tr></table>"; |
| 220 | |
| 221 | break; |
| 222 | case "corp_losses_class": |
| 223 | $html .= "<div class=block-header2>Lost ships</div>"; |
| 224 | |
| 225 | // Get all ShipClasses |
| 226 | $sql = "select scl_id, scl_class from kb3_ship_classes |
| 227 | where scl_class not in ('Drone','Unknown') order by scl_class"; |
| 228 | |
| 229 | $qry = new DBQuery(); |
| 230 | $qry->execute($sql); |
| 231 | while ($row = $qry->getRow()) |
| 232 | { |
| 233 | $shipclass[] = new Shipclass($row['scl_id']); |
| 234 | } |
| 235 | $html .= "<table class=kb-subtable>"; |
| 236 | $html .= "<tr>"; |
| 237 | $newrow = true; |
| 238 | |
| 239 | foreach ($shipclass as $shp){ |
| 240 | if ($newrow){ |
| 241 | $html .= '</tr><tr>'; |
| 242 | } |
| 243 | $list = new TopCorpLossesList(); |
| 244 | $list->addVictimAlliance($alliance); |
| 245 | $list->addVictimShipClass($shp); |
| 246 | $table = new TopCorpTable($list, "Losses"); |
| 247 | $content = $table->generate(); |
| 248 | if ($content != '<table class=kb-table cellspacing=1><tr class=kb-table-header><td class=kb-table-cell align=center>#</td><td class=kb-table-cell align=center>Corporation</td><td class=kb-table-cell align=center width=60>Losses</td></tr></table>'){ |
| 249 | $html .= "<td valign=top width=440>"; |
| 250 | $html .= "<div class=block-header>".$shp->getName()."</div>"; |
| 251 | $html .= $content; |
| 252 | $html .= "</td>"; |
| 253 | $newrow = !$newrow; |
| 254 | } |
| 255 | } |
| 256 | $html .= "</tr></table>"; |
| 257 | |
| 258 | break; |
| 259 | case "losses_class": |
| 260 | $html .= "<div class=block-header2>Lost ships</div>"; |
| 261 | |
| 262 | // Get all ShipClasses |
| 263 | $sql = "select scl_id, scl_class from kb3_ship_classes |
| 264 | where scl_class not in ('Drone','Unknown') order by scl_class"; |
| 265 | |
| 266 | $qry = new DBQuery(); |
| 267 | $qry->execute($sql); |
| 268 | while ($row = $qry->getRow()) |
| 269 | { |
| 270 | $shipclass[] = new Shipclass($row['scl_id']); |
| 271 | } |
| 272 | $html .= "<table class=kb-subtable>"; |
| 273 | $html .= "<tr>"; |
| 274 | $newrow = true; |
| 275 | |
| 276 | foreach ($shipclass as $shp){ |
| 277 | if ($newrow){ |
| 278 | $html .= '</tr><tr>'; |
| 279 | } |
| 280 | $list = new TopLossesList(); |
| 281 | $list->addVictimAlliance($alliance); |
| 282 | $list->addVictimShipClass($shp); |
| 283 | $table = new TopPilotTable($list, "Losses"); |
| 284 | $content = $table->generate(); |
| 285 | if ($content != '<table class=kb-table cellspacing=1><tr class=kb-table-header><td class=kb-table-cell align=center colspan=2>Pilot</td><td class=kb-table-cell align=center width=60>Losses</td></tr></table>'){ |
| 286 | $html .= "<td valign=top width=440>"; |
| 287 | $html .= "<div class=block-header>".$shp->getName()."</div>"; |
| 288 | $html .= $content; |
| 289 | $html .= "</td>"; |
| 290 | $newrow = !$newrow; |
| 291 | } |
| 292 | } |
| 293 | $html .= "</tr></table>"; |