These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

zKillboard.com

First post
Author
Previous Topic Next Topic
Squizz Caphinator
The Wormhole Police
#181 - 2013-03-10 18:38:19 UTC
Gheent wrote:
Hello,

I love the new look and the design of zKillboard! I was just curious, is it possible to download the source and host my own? Thanks!


I swear no one takes the time to read through threads before asking questions...

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Karbowiak
Sacred Templars
Fraternity.
#182 - 2013-03-11 12:05:43 UTC
During the night the "last" of the manual mails was imported to zKB

And this is the end result (Taken from IRC)

(13:02:01) (ESCBot) Karbowiak: Unparsed kills: 0 / Total kills: 13,841,460 / Actual Kills: 13,359,614

Now all thats needed to be done, is move over the last of the manual mails, the api verified mails, and then go through the ones that failed - and the move is complete! Big smile

HOWEVER, this does not mean zKB will be launched, but it's closer, a lot closer! Blink
Sojurn Turnith
Indecent Explosions
#183 - 2013-03-14 23:39:01 UTC  |  Edited by: Sojurn Turnith
I've noticed that when I click on kills to examine them, and I try to go back to the previous page, pressing back reloads the kill page again. This started happening about two weeks ago or so. Is this working as intended?

Edit: It appears that this issue has something do to with the ads being disabled by Adblock Plus.
Karbowiak
Sacred Templars
Fraternity.
#184 - 2013-03-15 08:40:30 UTC
Sojurn Turnith wrote:
I've noticed that when I click on kills to examine them, and I try to go back to the previous page, pressing back reloads the kill page again. This started happening about two weeks ago or so. Is this working as intended?

Edit: It appears that this issue has something do to with the ads being disabled by Adblock Plus.


Just tested the page on a multitude of pages, both with ads blocked, and without ads blocked, and it seems to work just fine.

It was tested with latest dev version of Chrome with Adblock+
Sojurn Turnith
Indecent Explosions
#185 - 2013-03-15 13:58:20 UTC
Karbowiak wrote:


Just tested the page on a multitude of pages, both with ads blocked, and without ads blocked, and it seems to work just fine.

It was tested with latest dev version of Chrome with Adblock+


Thanks for looking into it. I updated to the latest dev version of Chrome and everything is working fine now. Sorry for thinking it was something wrong with the site! Great job and keep up the good work!
Karbowiak
Sacred Templars
Fraternity.
#186 - 2013-03-15 14:41:02 UTC
Sojurn Turnith wrote:
Karbowiak wrote:


Just tested the page on a multitude of pages, both with ads blocked, and without ads blocked, and it seems to work just fine.

It was tested with latest dev version of Chrome with Adblock+


Thanks for looking into it. I updated to the latest dev version of Chrome and everything is working fine now. Sorry for thinking it was something wrong with the site! Great job and keep up the good work!


No worries, it might aswell have been the site that was ******* up :D
Karbowiak
Sacred Templars
Fraternity.
#187 - 2013-03-19 14:32:43 UTC
A few updates.

Firstly we have added stomp support to zKB, including gotten a stomp server setup (thanks to PeterPowers Big smile)

What is stomp you might ask, well, basically it's a message queue, where we will publish API mails to, as we get them into zKB.
So anyone can listen in, and get mails as we get them.

This could be very cool for that one person who wants to make a live updating map, of kills happening in EVE Lol

You can probably think of more uses Blink

Also, we have altered the DB a bit, to be partitioned, so it's faster (might do move partitioning, we'll see) _AND_ we are almost done with moving over mails, woo..

Currently there are 15.8million mails.

And lastly, we have begun moving zKB's development over to github, it's still a private repo, but we will be letting more people into the development of it. And soon, it'll go opensource, so everyone can participate. Cool
Karbowiak
Sacred Templars
Fraternity.
#188 - 2013-03-19 23:46:32 UTC
Over the next day or two, there might be issues with zKB, mainly in regards to stuff not loading (scripts)

If you run into this issue, let us know - we have reworked quite a bit of the backend dependencies, and the paths.
And i'm pretty sure we've missed something somewhere Lol
Squizz Caphinator
The Wormhole Police
#189 - 2013-03-20 15:02:09 UTC
see, karbo even admits to breaking things! <3

(tho I'm good at it too)

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Karbowiak
Sacred Templars
Fraternity.
#190 - 2013-03-20 22:13:22 UTC
Seeing as zKB is rapidly taking shape, we have decided to start looking for more people to help us out.

What we are looking for are people who are fluent in english and has a humor.
What we'll give you in return is some great times with a close knit group of friends, who have all been working on EVE-KILL for years.
Plus you'll have the ability to work on the largest killboard in EVE. Plus whatever else we can have fun doing. Blink

Below are a bit more concise list of what you should be able to do, what we require from you and obv. where to contact us.

What you need to have..

  1. Good english (Written, not spoken)
  2. A sense of humor

What you should be able to do..

  1. PHP
  2. HTML
  3. Javascript

What we require from you..

  1. Being on IRC
  2. Not coding PHP worse than me (Karbowiak)

What you'll be working with..

  1. SlimFramework
  2. Twig
  3. Almost 17 million killmails, and some very beefy server hardware
  4. A bunch of crazy people Lol


If you're still interested, please contact us on IRC.
Contact:
Server: irc.coldfront.net
Channel: #esc

Mibbit: http://chat.mibbit.com/?channel=%23esc&server=irc.coldfront.net
NickyYo
modro
The Initiative.
#191 - 2013-03-21 11:37:15 UTC
I can donate some time alongside my personal projects, msg me if interested.

..
Karbowiak
Sacred Templars
Fraternity.
#192 - 2013-03-21 13:38:31 UTC
NickyYo wrote:
I can donate some time alongside my personal projects, msg me if interested.


It says: contact us Blink
Squizz Caphinator
The Wormhole Police
#193 - 2013-03-21 20:16:27 UTC  |  Edited by: Squizz Caphinator
This week if you've been trying to use zKillboard it's probably been slow, unresponsive, or just downright not responding to you. I'm sorry for that.

I've spent the past few days doing some major changes to our 2nd biggest table: 100m rows, 19 columns, 33 indexes, for a total of 50 gb in table size. These changes have reduced the footprint of the table by roughly 20% and allowed us to implement better indexes on the data. Unfortunately any major changes to the table took 18 hours at a time, so I'd start it in the morning and finish it the next morning (I do have to sleep!). Hopefully we are over this major table shakeup.

Over the next few weeks you should see a flurry of development from us which will have less impact on you. You'll be seeing more of a polished, final project as well. I'm really proud of us for getting as far as we have on this and I hope you all enjoy the new killboard with at least half the enjoyment I have had in creating it :)

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Karbowiak
Sacred Templars
Fraternity.
#194 - 2013-03-22 22:54:41 UTC
So for those of you who still havn't noticed, i have been toying with something many will like.

An EDK based theme Shocked

Some things are different tho, it is wider than the standard EDK theme, and it still uses bootstrap elements to keep as much of the template code the same between the two views.
BUT if all goes to plan, you can use your old banner and your old CSS from EDK.

Pretty cool huh?

If you want to view the EDK theme for zKB, make an account, go to site settings, and select EDK under Theme.
At the moment it's stuck using the cyborg theme from bootstrap, since it's what fits into EDK the best - but as i go, i'll sort a CSS editor, plus move over some of the standard EDK themes for everyone to enjoy.

That said, there are bugs, the ones i have identified is:
- tablet view is terrible
- mobile view is even worse
- the grey lines in the side dont extend all the way down
- stuff in bootstrap that is defined by spans, are a bit wonky in their placement.

If you notice anything really wtf, do reply here, or stop by IRC with it.

--
As for progress, we are going ahead pretty damn fast, git have slowed us a little bit down, but that has more to do with it constantly thinking we're morons and wants us to merge ****.
Or, maybe are morons, dunno Oops

As for programmers, we are still looking, so far two have showed up, one didn't pan out, the other just vanished after an hour Straight

Anywho, that is all! Lol
Karbowiak
Sacred Templars
Fraternity.
#195 - 2013-04-07 19:19:01 UTC
It's been a few days since we last updated this. So here is some more information!

Since last post, we have created a few new things, and fixed some bugs.

Latest added feature is a stats call to the API, by courtesy of Ricky Baby. you can see more info about this here: https://zkillboard.com/information/api/ (Scroll down to near the bottom)

There has also been a few improvements to the EDK theme, making it look better, still a lot that needs doing on that front, so. yeah.

The autocomplete search has been revamped, also by Ricky Baby, so now it will actually send you directly to the page you want, instead of sending you to a search page.

We are also working on bringing a BRDOC feature to zKB, but will most likely also provide an API call for it, so other sites can still implement BRDOC incase they want to (or if someone wants to use the data for something, like, a forum summary or something)

So, with all of this work happening, we are getting close. Real close to releasing the code to all of you who wants to toy with it and add to it (and hopefully contribute back!)
Poetic Stanziel
The Scope
Gallente Federation
#196 - 2013-04-08 07:28:15 UTC  |  Edited by: Poetic Stanziel
Karbowiak wrote:
Since last post, we have created a few new things, and fixed some bugs.
Any word concerning a fix of the orderDirection/asc problem? Which was causing queries to run for 9000+seconds? (Probably some sort of recursive loop it was unable to get out of until the inevitable stack overflow error.)

I'm currently snagging all the killmails back to Jan 01 2013 ... but once that is done (it will probably take another week or so), then resuming from my most recent KillMailID and working my way into the future, ensuring that I never miss a KM, requires that orderDirection/asc be functioning.

I realize you guys have lives and tonnes of daily work dealing with the killboards ... but when you can get around to it fixing that problem ... I would love you long time.
Squizz Caphinator
The Wormhole Police
#197 - 2013-04-08 13:43:32 UTC
Poetic, I know I told you I'd look at it last week but that was before I had a pretty big work project dumped on me. I do all of my zkb work in my free time and that was sorely lacking. I will def. try to look into that issue this week.

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
DingoGS
We are not bad. Just unlucky
#198 - 2013-04-08 23:27:46 UTC  |  Edited by: DingoGS
I have a API Request,

Could you add a option to show estimated ISK Value of the Kill? That could open up many interesting analysis to be pulled from the API :)

Also, it seems the endTime tag is broken, or I'm formatting the DateTime badly (But it works for startTime tho)

Something I really liked about the old API (Epic one) was the "Mask" attribute, which was really good to select the information you want.
Poetic Stanziel
The Scope
Gallente Federation
#199 - 2013-04-09 06:35:56 UTC
DingoGS wrote:
Could you add a option to show estimated ISK Value of the Kill? That could open up many interesting analysis to be pulled from the API :)
The old EVE Kill API had that information, but the new zKill does not ... which struck me as odd. I asked about it a few weeks ago, and the response was non-committal. I'm sure they have the information in the database, since their new stats API functions give ISK values for losses and kills.

For my own project, I could start accessing the EVE-Central database, getting the mod prices myself, and then constructing ISK values of items on the KM ... but zKill doing it for me would be a time-saver.
Poetic Stanziel
The Scope
Gallente Federation
#200 - 2013-04-09 06:36:33 UTC
Squizz Caphinator wrote:
Poetic, I know I told you I'd look at it last week but that was before I had a pretty big work project dumped on me. I do all of my zkb work in my free time and that was sorely lacking. I will def. try to look into that issue this week.
You done fixed it ... as you notified me in an eveMail. Thanks a bunch, dude!