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.
 

Ganker tracker (PHP based web app)

Author
Sergio Team
The Scope
Gallente Federation
#1 - 2016-01-01 20:55:15 UTC  |  Edited by: Sergio Team
Hi there o/
I always wanted to do a public app for EVE (Since as web developer I like to create things Big smile ), and well, I have done a ganker tracker (only for mining barges, exhumers and orca on highsec) , I know that there was already one done but for me it was a bit hard to find the last kills for example in a region or it didn't show the ganker corp/alliance (only when using the game browser).

So, basically for when I'm mining I always like to search if there is any activity near my place, and maybe start moving or just stop mining.

In the past 3 days, I found a way to have the kills from the zkillboard API (to get the losses), and later to check if this one is made by a war or not, i used the crest API. So once this have as 0 the warID, my app add it's like a gank (I cannot still look how if the victim has turned to suspect or not, or he agressed a suspect, because some gankers doesn't have a loss from concord on zkillboard). I do this process every 2 minutes, with a php script.

This the url to the web app: http://tracker.eveminingsquad.com/index.php

It is already finished, it searches for all (corps, alliances, characters, systems, constellations and regions). Also, I'll set up more calls to the API (statistics)

I made the design of the app like in this style, because of suggestions talking with other spanish people, if you don't like the design, just tell how I could improve it, because I'm not a web designer, I tried to show the ganks in a different way (it shows like it was a zkillboard kill on the main table), but I couldn't do another design, since I'm not good drawing user interfaces, and I don't know to display in another way, since I want to show how many ganked, and their corp/alliance.

I would really like to get suggestions, or your opinion of how do you see it, to improve the app, I'm still working on the public API for other developers that want to use the data that my app have.
This app, is hosted on where I have my blog about industry and some pvp thing (spanish blog), so for that you'll see why the app is translated for 2 languages right now (english and spanish). If you would like to have it on another language, just send me a message.

This tool have a public API which can be used to get data from the gank tracker.
You can check the information about the API here: http://tracker.eveminingsquad.com/index.php?vista=api
I still need to add the statistics to the API (the statistics which I show on the solar systems page, constellation, region or character profiles, corps and alliance).

Right now you can get from the API the next thing:
- Last gank (cached)
- Dangerous gankers
- Dangerous systems (systems that have a lot of ganks)
- list of ganks

If someone needs a extra language, just mail me, and I'll send you the translation file ;)
Amely Miles
Second Exile
#2 - 2016-01-02 20:49:23 UTC
I had a idea like this some time ago heres my idea (probably a easier way to do it but i am not a coder)... stand alone program connected to a website. the website crawls thru something like Zkill for deaths of any kind of mining ship in the last hour. the program on your PC would have your local system and would keep a eye on zkill thru the website for the surrounding 5 systems if someone in a mining ship dies in those 5 systems you hear a noticeable Ding if someone on that kill comes in to system thru a Overlay on your PC you would hear a Alarm go off (possibly connect it to a Map with red flashes for kills)

As I slipped my finger slowly inside her hole, I could immediately feel it getting wetter and wetter.

I took my finger back out and within seconds she was going down on me.

"I really need a new boat," I thought to myself.

Sergio Team
The Scope
Gallente Federation
#3 - 2016-01-02 22:01:07 UTC
Amely Miles wrote:
I had a idea like this some time ago heres my idea (probably a easier way to do it but i am not a coder)... stand alone program connected to a website. the website crawls thru something like Zkill for deaths of any kind of mining ship in the last hour. the program on your PC would have your local system and would keep a eye on zkill thru the website for the surrounding 5 systems if someone in a mining ship dies in those 5 systems you hear a noticeable Ding if someone on that kill comes in to system thru a Overlay on your PC you would hear a Alarm go off (possibly connect it to a Map with red flashes for kills)


Well, I can set up some desktop notifications with sounds, and save for example the locations that someone would like and store it up in a cookie, if you like in this way I can try to do it.

But first, I'm trying to fix why the website doesn't seem to update with the lastest kills, since sometimes it takes 1h or 30min, just to display the last kill, and later finish the auto-update.

But ty for your suggestion, I'll try to as soon as possible.
Amely Miles
Second Exile
#4 - 2016-01-02 22:17:49 UTC
Because of times for pulling from Zkill or any other site crest or what ever magic you use i also suggest having a shared system from your users ...for instance zkill says nearest to me was 60mins ago but hypothetically zkill only lets you pull every 70 minutes then you have a gap but if you share resources from each of the people that use the program/site then it can fill in that gap making it a more precise program/website ....the best way i think of it would be kinda like what evecentral did to pull prices for marketing it used players to export cvs and then import using a tool that always ran to the website

As I slipped my finger slowly inside her hole, I could immediately feel it getting wetter and wetter.

I took my finger back out and within seconds she was going down on me.

"I really need a new boat," I thought to myself.

Sergio Team
The Scope
Gallente Federation
#5 - 2016-01-02 22:44:08 UTC
Amely Miles wrote:
Because of times for pulling from Zkill or any other site crest or what ever magic you use i also suggest having a shared system from your users ...for instance zkill says nearest to me was 60mins ago but hypothetically zkill only lets you pull every 70 minutes then you have a gap but if you share resources from each of the people that use the program/site then it can fill in that gap making it a more precise program/website ....the best way i think of it would be kinda like what evecentral did to pull prices for marketing it used players to export cvs and then import using a tool that always ran to the website


Ok, then I could do for example allow the users POST the public url of the killmail or with the API. Well, I'll do tomorrow first the way to post the killmail url, and later finish the auto-update (so the user doesn't need to refresh

Ty for saying that, because I didn't know about the cached request from zkillboard.
Amely Miles
Second Exile
#6 - 2016-01-02 23:02:31 UTC
well i dont know if they have a cache timer or not but most websites in eve do...have you been on there IRC channel on Coldfront or emailed Squizz?

squizzc@gmail.com
#esc

or other devs thru
#eve-dev also on coldfront

As I slipped my finger slowly inside her hole, I could immediately feel it getting wetter and wetter.

I took my finger back out and within seconds she was going down on me.

"I really need a new boat," I thought to myself.

Sergio Team
The Scope
Gallente Federation
#7 - 2016-01-13 18:37:51 UTC
Amely Miles wrote:
well i dont know if they have a cache timer or not but most websites in eve do...have you been on there IRC channel on Coldfront or emailed Squizz?

squizzc@gmail.com
#esc

or other devs thru
#eve-dev also on coldfront



I finally contacted with him, and well now I have the kills sync (I still do the requests every 2 minutes), now I'm working on finish the statistics page for locations (region/constellation/solar system), next will be the statistics for gankers/corps and alliance.

And finally some global, and after this I'll finish the search input that I have added to the toolbar.

And thanks for the help.
1upnate
Forward Secrecy
#8 - 2016-01-13 22:31:39 UTC
I'd be interested in discussing the options about jabber/xmpp integration for this. For example, users can connect to the broadcasting service, set their location, and be alerted to indy/gank kills within a certain range.

shoot me a message in game if you'd be interested in discussing this. I really like what you've got so far.
Sergio Team
The Scope
Gallente Federation
#9 - 2016-01-18 19:14:25 UTC  |  Edited by: Sergio Team
I have updated today the website with more things:
- I enabled the search tool (only for regions, constellations and systems)
- I have finally finished the region, constellations and systems page

I have also, did a limit of kills that I'm showing on the main page, I'll do later the pagination since right now I'm only showing the last 15 ganks.

I still have to finish the page for the user statistics, and about the xmpp, I'm working on it (the only is I don't know how to connect as anonymous to the xmpp service xd).

EDIT: I finished the way to add the notificacion to the jabber, but i still don't know how to connect as anonymous xd.
Sergio Team
The Scope
Gallente Federation
#10 - 2016-02-15 15:54:28 UTC  |  Edited by: Sergio Team
I bump the thread just to announce, that I enabled more things to the public API of my web app.

On the call to lastganks I added 2 new parameters if someone wants to search the ganks on for example january of 2016. (you'll need the 2 parameters and this will replace the days= parameter).

And I also added the statistics call to retrieve the total ganks on a solar system, constellation or region, or the ganks done by a capsuleer, corporation or Alliance.


Examples:

- Ganks done on Verge vendor on January 2016
http://tracker.eveminingsquad.com/?modulo=api&call=statistics&statisticType=region&regionID=10000068&year=2016&month=1

- Ganks done on Domain region on February 2016 until now
http://tracker.eveminingsquad.com/?modulo=api&call=statistics&statisticType=region&regionID=10000043&year=2016&month=2

- Ganks done by CODE. on January 2016.
http://tracker.eveminingsquad.com/?modulo=api&call=statistics&statisticType=alliance&allianceID=99002775&year=2016&month=1

If anyone have a suggestion just say.



Edit: Today 19th february I updated the web app with a suggestion, about display too the killmails of the ganker freighters, jump freighters.
I'll also include a way to filter by ship category on the search or when checking the information on a statistics page.