Some minor modifications i made.
Brought to you by:
geoffw22
Menu
▾
▴
I have added a link on the first page to see the next 10 kills, and previous 10 kills
Also, on the stats page, i made the "ships that go BOOM regularly" more user-friendly by using ships images.
You can see the result on http://eve.web-arena.net/killboard
It is not a major modification, but i think some cosmetic changes are always a good thing ;p
BTW i noticed that you don't have any parameters file -or admin- for things like the number of kills returned by SQL request. Might be a good thing to have one.
Last thing : I installed the 1.9.1 version on the 1.8.4 version a few minutes ago (using winmerge not to overwrite my mods), and i see an admin section... but nothing useable, as there is not index.php in it, and an error on updatecorps.php :
Warning: main(database.php): failed to open stream: No such file or directory in /home/www/duael/www/eve/killboard/admin/updatecorps.php on line 13
Really like what you've done with images under the statistics, might need to play around with that myself and see what I can come up with.
BTW i don't know how to send my modified files on SF.net
Here's the code :
<tr>
<th style="background-color:#C2341E;" colspan="2">Ships that go BOOM regularly</th>
</tr>
<tr>
<td colspan="2">
<table style="width:100%;">
<tr>
<td style="width:50%">
<table style="width:100%;">
<tr>
<?php
$sql = 'SELECT `Ship` . `ShipName` , `Kill` . `ShipID` , COUNT( `Kill` . `ShipID` ) as KILLEDSHIPS FROM `Ship` , `Kill` WHERE ( `Ship` . `ShipID` = `Kill` . `ShipID` ) AND ( `Kill` . `ShipID` != 127 ) GROUP BY `Kill` . `ShipID` ORDER BY KILLEDSHIPS DESC LIMIT 0,4';
$result = mysql_query($sql);
for ($i = 0; $i < mysql_num_rows($result); $i ++)
{
$ShipName = mysql_result($result,$i,"ShipName");
$ShipID = mysql_result($result,$i,"ShipID");
$KilledShips = mysql_result($result,$i,"killedShips");
if (($i % 2) == 0) { ?>
</tr><tr>
<?
}
?>
<td style="width:50%;">
<table class="tableborder" style="width:100%;">
<tr>
<td style="width:32px">
<a href="?mode=ship&id=<? echo $ShipID; ?>&kn=0">
<?php
echo ("<img src=\"images/$ShipID.png\" alt=\"ship\" style=\"vertical-align:middle\" border=\"0\">");
?>
</a>
</td>
<td style="width:100%">
<?php echo $ShipName." : ".$KilledShips." destroyed"; ?>
</td>
</tr>
</table>
</td>
<?
}
?>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
I also add the number of pods destroyed :
<td style="width:50%">
<table class="tableborder" style="width:100%;">
<tr>
<?php
$sql = "SELECT COUNT(*) AS Pods FROM `Kill` WHERE (`ShipID` = 127)";
$result = mysql_query($sql);
$podsLost = mysql_result($result,0,0);
?>
<td style="width:32px">
<a href="?mode=ship&id=127&kn=0">
<img src="images/127.png" alt="pod" style="vertical-align:middle" border="0">
</a>
</td>
<td style="width:100%">
<?php
echo ("<b>$podsLost</b> pods have been destroyed");
?>
</td>
</tr>
</table>
</td>
If we're showing off in here, here's my version of the KB :)
(sorry, I couldn't resist)
<a href="http://kills.jubacorp.com/">JubaCorp KB</a>
Added:
- Comments per kill
- ships images in stats
- display of the time per day on FP
- made all items linkable (see kill detail for example)
- Changed display of destroyed items (cargo and fitted)
- Added Assists and Finals per user in the stats
- Highlight of own corp kills/losses
- Completely changed theme
And that looks damn fine Ryushe.... want to make some changes to mine?
www.thecursednavy.com
Ryushe - That modification of yours is just pure magic. Any chance for the users to get our hands on it?
Duael: which part of the above adds the link for next and previous kills on front page?
Tallbloke, Zahan, and others:
I'd be willing to release this mod of course, but I'd rather wait for the 2.0 pre-release, as I want to have that one up and running instead of our current one pretty soon, while keeping my current look intact.
If you want to stick with your 1.x version for now tho, let me know, and I'll set up a more generic version of the one I have running atm. This means stripping some graphic stuff out, and cleaning up some parts tho ;)
Geoffrey, if you're interested, I'd be willing to have a look and see if I can create a nice default new template for the 2.0 version of the killboard. Might be nice, as tbh I really think the current default theme is a bit bland... Let me know, you can reach me at ryushe@jubacorp.com.
I agree, default theme sucks : ) as i've said 1000's of times, I want people to code their own front ends, my work is focused on the parser/database etc..
Yeah, Ryushe's design is 'The Bomb' man.
Everything you need is just there in front of your eyes.
Would you mind showing the code you used to make your corp show up on the front page. I'm not planning on moving to the 2.0 in the near future.
Ruhnau Emmanuel those modifications you made... could you tell me where to add that code please?
Try a search on the text in the code, you'll find.
"ships that go BOOM regularly"
in frontend.php
http://broil.hostweb.com.au
Modified one or two things including an admin section which allows me to delete posts if necessary, refresh kill points, attempt to update player portraits (i use the ones that the eve site generates)
Tonight I am going to add a link on top to include pod kills into the menu as well :)