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.
12Next page
 

Wordpress Killboard Widget
Author
Previous Topic Next Topic
Zaine Maltis
Innsmouth Enterprises
#1 - 2011-12-06 14:26:00 UTC  |  Edited by: Zaine Maltis
Run a Wordpress Blog to tell the world about your exploits? Use EDK killboard or www.eve-kill.net to track your kills? Well, now you can combine the two!

The Eve Killboard Plugin pulls your latest kills from either EDK or eve-kill and displays them on a customisable widget you can put anywhere on your blog.

More information:
The plugins dedicated page
Wordpress Plugins directory

Screenshot

Download the latest version:
http://downloads.wordpress.org/plugin/eve-killboard.1.2.zip

Join the In Game Mailing list:
Eve Killboard Wordpress Plugin

Link to original thread:
https://forums.eveonline.com/default.aspx?g=posts&t=6404&find=unread

Link to Old Forums Thread:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1113160

Innsmouth Enterprises
Zaine Maltis
Innsmouth Enterprises
#2 - 2011-12-06 14:26:51 UTC
I've had a bug flagged with the plugin being incompatible with the latest version of EDK. I'll be taking a look this week and pushing a fix.

Will bump when this is done.

Thanks for using! Big smile

Innsmouth Enterprises
Zaine Maltis
Innsmouth Enterprises
#3 - 2011-12-08 14:10:29 UTC
Got a test version available if anyone wants to give it a go before I commit it to the Wordpress SVN.

http://www.innsmouthenterprises.com/wp-content/plugins/eve-killboard.zip

Innsmouth Enterprises
Negativestatus
Caldari Provisions
Caldari State
#4 - 2011-12-09 07:08:23 UTC
Any plans for a joomla version of this?
Zaine Maltis
Innsmouth Enterprises
#5 - 2011-12-09 08:18:51 UTC
Never used Joomla, so wasn't on the cards. I could look at it though for the right price Pirate

Innsmouth Enterprises
Zaine Maltis
Innsmouth Enterprises
#6 - 2011-12-09 09:42:38 UTC
Grendel Warchild
Pator Tech School
Minmatar Republic
#7 - 2011-12-11 12:29:43 UTC
updated and still not working for me.
www.eve-1.com

-GW
Karbowiak
State War Academy
Caldari State
#8 - 2011-12-12 07:51:21 UTC
Instead of having the user input a custom feed for EVE-KILL, you should take a look at our API:
https://forums.eveonline.com/default.aspx?g=posts&find=unread&t=18842

If its missing functionality that you need, just lemme know, and i'll add another API :)
Zaine Maltis
Innsmouth Enterprises
#9 - 2011-12-12 13:29:14 UTC
Grendel Warchild wrote:
updated and still not working for me.
www.eve-1.com

-GW


Ouch. Just to confirm, you are running version 1.2? Do you have access to your kb db? Can you tell me what you get when you run this:

'SELECT cfg_value FROM `kb3_config` WHERE cfg_key = 'upd_dbVersion' LIMIT 1'

on your killboard DB? That's how I'm trying to determine the version of your killboard DB.

Innsmouth Enterprises
Zaine Maltis
Innsmouth Enterprises
#10 - 2011-12-12 13:35:00 UTC
Karbowiak wrote:
Instead of having the user input a custom feed for EVE-KILL, you should take a look at our API:
https://forums.eveonline.com/default.aspx?g=posts&find=unread&t=18842

If its missing functionality that you need, just lemme know, and i'll add another API :)


I'll take a look at that. Might be easier for the user.

Innsmouth Enterprises
Grendel Warchild
Pator Tech School
Minmatar Republic
#11 - 2011-12-15 19:41:53 UTC

mysql> +-----------+
-> | cfg_value |
-> +-----------+
-> | 1.1.2 |
-> +-----------+
-> 1 row in set (0.02 sec)
Zaine Maltis
Innsmouth Enterprises
#12 - 2011-12-16 08:25:06 UTC
That seems to be the DB version for the older version of EDK, unless I'm misunderstanding.

Can you re-enable the plugin and pop me the error messages on this thread please? Also dump me the structure of the kb3_kills table on here as well.

Innsmouth Enterprises
Grendel Warchild
Pator Tech School
Minmatar Republic
#13 - 2011-12-16 15:47:57 UTC
Query failed: Unknown column 'shp.shp_name' in 'field list'
test

Warning: Invalid argument supplied for foreach() in /home/one_percent/www/eve-1.com/blog/wp-content/plugins/eve-killboard/eve-killboard.php on line 391
Zaine Maltis
Innsmouth Enterprises
#14 - 2011-12-16 18:34:13 UTC
and can you "DESCRIBE kb3_kills "

Innsmouth Enterprises
Grendel Warchild
Pator Tech School
Minmatar Republic
#15 - 2011-12-16 19:06:45 UTC
mysql> DESCRIBE kb3_kills;
+-----------------+----------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------+------+-----+---------------------+----------------+
| kll_id | int(11) | NO | PRI | NULL | auto_increment |
| kll_timestamp | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| kll_victim_id | int(6) | NO | MUL | 0 | |
| kll_all_id | int(3) | NO | MUL | 0 | |
| kll_crp_id | int(6) | NO | MUL | 0 | |
| kll_ship_id | int(3) | NO | MUL | 0 | |
| kll_system_id | int(4) | NO | MUL | 0 | |
| kll_fb_plt_id | int(3) | YES | MUL | NULL | |
| kll_points | int(11) | NO | | 0 | |
| kll_dmgtaken | int(11) | NO | | 0 | |
| kll_external_id | int(3) | YES | UNI | NULL | |
| kll_isk_loss | float | NO | | 0 | |
+-----------------+----------+------+-----+---------------------+----------------+
Zaine Maltis
Innsmouth Enterprises
#16 - 2011-12-16 21:15:24 UTC
Can you DESCRIBE kb3_ships?

Innsmouth Enterprises
Grendel Warchild
Pator Tech School
Minmatar Republic
#17 - 2011-12-17 00:50:50 UTC
DESCRIBE kb3_ships;
+-----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+----------------+
| shp_id | int(11) | NO | PRI | NULL | auto_increment |
| shp_class | int(11) | NO | MUL | 18 | |
+-----------+---------+------+-----+---------+----------------+
Zaine Maltis
Innsmouth Enterprises
#18 - 2011-12-17 08:26:47 UTC
Weird.

You have a version 2 ships table, but the dbconfig number doesn't look like what I'm expecting. I'm asking the EDKs if they can work out why.

In the meantime, have a custom file:

http://plugins.svn.wordpress.org/eve-killboard/branches/1.2-GrendelWarchild/eve-killboard.php

Download it and overwrite the original one in wp-content/plugins/eve-killboard/

Innsmouth Enterprises
Karbowiak
State War Academy
Caldari State
#19 - 2011-12-17 17:02:07 UTC
Zaine Maltis wrote:
Karbowiak wrote:
Instead of having the user input a custom feed for EVE-KILL, you should take a look at our API:
https://forums.eveonline.com/default.aspx?g=posts&find=unread&t=18842

If its missing functionality that you need, just lemme know, and i'll add another API :)


I'll take a look at that. Might be easier for the user.


In about a day or two i'll release a new API, from which you can request everything you want, so forget implementing the current api.
Just keep an eye on the API thread i linked to :)
Zaine Maltis
Innsmouth Enterprises
#20 - 2011-12-17 17:04:42 UTC
Karbowiak wrote:

In about a day or two i'll release a new API, from which you can request everything you want, so forget implementing the current api.
Just keep an eye on the API thread i linked to :)


Awesome sauce. Would be really easy if the player can just put their name, corp or alliance in and just suck kills out :D

Innsmouth Enterprises
12Next page