EDK 4.2.22.0 (Citadel 1.0)

EDK releases + Open discussion and chat about EDK.
User avatar
Salvoxia
Developer
Posts: 1515
Joined: Wed Feb 22, 2012 12:11

EDK 4.2.22.0 (Citadel 1.0)

Post by Salvoxia » Thu Apr 28, 2016 21:13

\o guys,

EDK 4.2.22.0 (2016-04-28)

This release updates your database to Citadel 1.0.

Since CCP changed the base URL for CREST access, this update incorporates this change as well, while still supporting posting of CREST links containing the old URL.
That way, you can grab a CREST link from a killboard that has not yet been updated and cross-post a kill to your own.

The mechanism that pulls new items from CREST has been refined.
If the killboard can't find an item in its own database, it tries to fetch it from CREST. As of the March update CREST also supplies all meta information for items, so EDK pulls it as well.


At this point I'd like to apologize for the lack of new features and pursual of some of your ideas and suggestions (daily stats, changing data types to allow partitioning, ...), my RL has been quite demanding lately, leaving me with little time and energy. Sorry for that!


Download:
Full Install Package 4.2.22.0: Download (please check MD5: 4CDEF790880E80BCBF51B899F3F4EC5B)
Update 4.2.21.0 - 4.2.22.0: Download (please check MD5: CFE3ABEED8FA93F481A95C0902F28500)


Database only:
Download the standalone database update for of EDK4.2+ here: Download (please check MD5: FC5A803264A91F2BDA7140F39FBFB8B2)



Release Notes:

List of new features
  • Updated EDK to 4.2.22.0 and CCP DB to Citadel 1.0.20160427
  • Allow posting of CREST links with legacy base URL
  • Changed CREST base URL to crest-tq.eveonline.com
Enhancements:
  • Fetch dogma info for unknown items

List of Bugfixes
  • Fixed typo in ACP setting name
  • Fix: Fetching item types via CREST

Installation Instructions:
Requirements
  • Webserver (e.g. Apache)
  • PHP 5.2+ (5.3.7+ recommended)
  • MySQL 5.0+
  • GD 2 or higher (default on most hosts)
  • PHP MySQLi extension (default on most hosts)
  • PHP XML extension (default on most hosts)
  • PHP openssl extension (default on most hosts, required for API use)
  • PHP Safe Mode off. (highly recommended)
New Installations
  • Upload the whole package to a webhost
  • Point your webbrowser to /install inside the EDK directory
  • Follow the instructions
  • Delete the install folder after installation
  • If no pilot images are displayed check that the server has write permission to the cache folder.
Manual upgrade
  • Backup the existing database and files
  • Remove or rename all files in the killboard folder other than [kbfolder]/kbconfig.php
  • Upload the new package to the killboard folder
  • Remove install folder
  • Move your mods back from the backup to the mods folder.


Update from 4.2.21.0:

Auto Updater
  • Backup the existing database and files
  • Enter the admin control panel
  • Select the option "Upgrade" from the menu on the right
  • If the code update to Version 4.2.21.0 doesn't show up in the list, select the link at the bottom saying "retrieve update description file now"
  • Click "Download"
  • Click "Apply"
  • Database update process starts, follow instructions
  • DONE \o/


Manual upgrade
  • Download the Update 4.2.21.0 - 4.2.22.0 (see above)
  • Backup the existing database and files
  • Upload the contents of the update package to your webhost
  • DONE


Known issues:


Regards,
Salvoxia

User avatar
Dism0
Active Author
Posts: 151
Joined: Fri Jul 06, 2012 01:42

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Dism0 » Thu Apr 28, 2016 23:54

thanks for the quick update. flawless upgrade.

Code: Select all

This is the EVE Development Network Killboard running version 4.2.22.0 (Citadel 1.0)

User avatar
Rounon Dax
Greenhorn
Posts: 21
Joined: Sat Jul 11, 2015 17:15

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Rounon Dax » Fri Apr 29, 2016 18:44

Some Itemgroups are missing their slots and need to be assigned.

Flex Shield Hardener
Flex Armor Hardener
Capital Sensor Array
Missile Launcher Rapid Torpedo

Maybe more, but that are the ones I found.

User avatar
Salvoxia
Developer
Posts: 1515
Joined: Wed Feb 22, 2012 12:11

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Salvoxia » Fri Apr 29, 2016 20:55

Hi,

are you referring to the kb3_item_types.itt_slot column? If so, this column is deprecated and no longer maintained, but it's left there for compatibility reasons with mods.
I checked with Flex Shield/Armor Hardeners and the Networked Sensor Arrays, Slot determination seems fine for these.


Best Regards,
Salvoxia

User avatar
Rounon Dax
Greenhorn
Posts: 21
Joined: Sat Jul 11, 2015 17:15

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Rounon Dax » Sat Apr 30, 2016 08:57

Yes, I am referring to those.

Ok, is they are deprecated, how to determine the slot of a module now? I am asking because I am using the killboard DB for our internal web based fitting tool and need to know what module has to go in what slot.

For now I am going with this to get the item details:

Code: Select all

$sql = 'SELECT
		`kb3_invtypes`.`typeID` AS `itemID`,
		`kb3_invtypes`.`groupID` AS `groupID`,
		`kb3_invtypes`.`typeName` AS `itemName`,
		`kb3_invtypes`.`description` AS `itemDescription`,

		`kb3_item_types`.`itt_slot` AS `slotID`,
		`kb3_item_types`.`itt_cat` AS `categoryID`,

		`kb3_item_locations`.`itl_flagName` AS `slotName`
	FROM `kb3_invtypes`, `kb3_item_types`, `kb3_item_locations`
	WHERE `typeName` = ?
	AND `kb3_item_types`.`itt_id` = `kb3_invtypes`.`groupID`
	AND `kb3_item_locations`.`itl_flagID` = `kb3_item_types`.`itt_slot`';
If there is another way to determine which slot a module goes in, please let me know.

User avatar
Salvoxia
Developer
Posts: 1515
Joined: Wed Feb 22, 2012 12:11

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Salvoxia » Sat Apr 30, 2016 10:04

Hi,

the great thing is that it's all in the SDE provided by CCP. The slot requirement for an item are set by a dogma effect.

This query

Code: Select all

SELECT
		it.typeID AS itemID,
		it.groupID AS groupID,
		it.typeName AS itemName,
		it.description AS itemDescription,
		itt.itt_cat AS categoryID,
		e.displayName AS slotName,
		e.effectId AS slotEffectID
	FROM kb3_invtypes it
    left join kb3_dgmtypeeffects te on te.typeID = it.typeID AND te.effectID IN (
        12, -- needs high slot
        13, -- needs med slot
        11, -- needs lot slow
        2663, -- needs rig slot
        3772, -- needs subsystem slot
        6306 -- needs service slot
    )
    inner join kb3_dgmeffects e on e.effectID = te.effectID
    inner join kb3_item_types itt on itt.itt_id = it.groupID
	WHERE it.typeName = 'Capital Flex Shield Hardener I'
	AND itt.itt_id = it.groupID
gives

Code: Select all

+--------+---------+--------------------------------+------------+--------------+--------------+
| itemID | groupID | itemName                       | categoryID | slotName     | slotEffectID |
+--------+---------+--------------------------------+------------+--------------+--------------+
|  41516 |    1700 | Capital Flex Shield Hardener I |          7 | Medium power |           13 |
+--------+---------+--------------------------------+------------+--------------+--------------+
(I left out the description in the result)

You can either hardcode the mapping of slotEffectIDs to a specific slot in kb3_item_locations (as done in EDK's class InventoryFlag::$EFFECT_ID_SLOT_MAPPING) or come up with a mapping in the SQL query itself if you cannot touch your application's code.

Hope that helps, if you have any further questions, go ahead! :)

Best Regards,
Salvoxia

User avatar
Rounon Dax
Greenhorn
Posts: 21
Joined: Sat Jul 11, 2015 17:15

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Rounon Dax » Sat Apr 30, 2016 10:10

GREAT! Thank you!

celagon
Greenhorn
Posts: 39
Joined: Mon Oct 07, 2013 01:50

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by celagon » Fri May 20, 2016 17:51

We have had 2 kills for Citadels now but they show up as 0 isk.
I have updated the value for everything but still it doesnt come up. Should it be like this or whats going on ?

When i go in to the killmail the loss price is there. But on the mainpage it says 0.

http://dab-eve.com/killboard/index.php/ ... ail/74287/

http://dab-eve.com/killboard/index.php/ ... ail/74256/

User avatar
Salvoxia
Developer
Posts: 1515
Joined: Wed Feb 22, 2012 12:11

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by Salvoxia » Sat May 21, 2016 11:02

Hi,

did you simply fetch the the value from CREST or did you manually edit the ship's value in the kill directly?
In any case, you need to do the latter or re-post the kill after updating the value.

Best Regards,
Salvoxia

celagon
Greenhorn
Posts: 39
Joined: Mon Oct 07, 2013 01:50

Re: EDK 4.2.22.0 (Citadel 1.0)

Post by celagon » Sat May 21, 2016 11:40

Thank you :)

Post Reply

Return to “General Killboard Chat”

Who is online

Users browsing this forum: No registered users and 8 guests