DB Rubicon 1.0.8

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

DB Rubicon 1.0.8

Post by Salvoxia » Sun Nov 17, 2013 10:16

Hi guys,

just wanted to let you know that I have put together a database update for EDK based on the Rubicon 1.0.4-93577 SDE. This is the latest SDE release from CCP. This update includes the name changes to orbital bombardement ammunition introduced in Rubicon 1.0.8. The changes listed below are compared to to Odyssey 1.1 release.

New ships:
  • 33470 Stratios Cruiser
  • 33553 Stratios Emergency Responder Cruiser
  • 33468 Astero Frigate
  • 33513 Leopard Shuttle
  • 33477 Small Mobile Siphon Unit Structure
  • 33478 Medium Mobile Siphon Unit Structure
  • 33479 Large Mobile Siphon Unit Structure
  • 33474 Mobile Depot Structure
  • 33522 'Yurt' Mobile Depot Structure
  • 33520 'Wetu' Mobile Depot Structure
  • 33476 Mobile Cynosural Inhibitor Structure
  • 33475 Mobile Tractor unit Structure
[/size]

Other changes:
  • fixed Bastion Module I Blueprint name
  • changed font size in item description headlines to 2
  • renamed the "POS Modules" ship class to "Structure", now includes the new deployables
  • renamed planetary bombardement ammunition according to stealth changes in Rubicon 1.0.8
[/size]

Hotfix for Rubicon 1.0.8: (use if you downloaded the DB before 2013-12-17 15:48 GMT)

Code: Select all

-- rename Tactical EMP S to Orbital EMP S
UPDATE kb3_invtypes SET typeName = 'Orbital EMP S' WHERE typeID = 32801;

-- rename Tactical Laser S to Orbital Laser S
UPDATE kb3_invtypes SET typeName = 'Orbital Laser S' WHERE typeID = 32799;

-- rename Tactical Hybrid S to Orbital Hybrid S
UPDATE kb3_invtypes SET typeName = 'Orbital Hybrid S' WHERE typeID = 32803;
Download:
http://code.google.com/p/evedev-kb/down ... p&can=2&q=
(updated 2013-12-17 15:48 GMT)

DB Update Guide for PHPMyAdmin and SSH:
http://www.evekb.org/forum/viewtopic.ph ... 071#p42071

If you encounter any errors, please post here with as much information as you can provide.

Regards,
Salvoxia
Last edited by Salvoxia on Thu Dec 19, 2013 00:51, edited 15 times in total.

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

Re: DB Rubicon 1.0

Post by Salvoxia » Tue Nov 19, 2013 08:50

Hi guys,

the DB update has now been in productive use for nearly two days, without errors.
So I'm confident it will work alright with Rubicon released, you can now download the update in the OP.
Create a backup of your current DB and update as usual.

Regards,
Salvoxia

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

Re: DB Rubicon 1.0

Post by Salvoxia » Tue Nov 19, 2013 15:11

Hi guys,

there are two issues with the current update, a bigger one and a smaller one:
1) Z-Coordinates for systems and regions are inverted, so the maps on the killboard show an inverted version of the universe/region/constellation (Deklein is in the SE for example)
2) I changed the name for the Bastion Mode Blueprint from "Bastion Mode I Blueprint" to "Bastion Module I Blueprint" because I assumed it to be a mistake in the SDE and didn't exepct it to hit TQ with that name. But it did.

I'll fix these two isses later today. So if you have the time and don't want to update twice, don't download the current version.

I'll post again when the update is done.


Regards,
Salvoxia

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

Re: DB Rubicon 1.0

Post by Salvoxia » Tue Nov 19, 2013 17:28

Hi,

I updated the database linked in the OP (see the "updated.." hint).
I fixed the inverted system/region coordinates, reverted the name for the "Bastion Mode I Blueprint" and added the Stratios Emergency Responder as another ship.

If you run into any other oddities/errors please post here. Thanks


Salvoxia

Eek
Someday Author
Posts: 73
Joined: Fri Dec 17, 2010 00:20

Re: DB Rubicon 1.0

Post by Eek » Tue Nov 19, 2013 22:09

Nice work!

Before i apply this update, i have a small question:

Lately i've noticed that i have been unable to post kills with remote armor, shield or energy transfers as the names of these modules have changed. I have fixed this one by one manually in the database, but im not sure i've got them all.

Is there a update before this one i missed?

Thx for all the work your putting into this Salvoxia!

- Eek
http://www.demonic-retribution.com/?a=home

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

Re: DB Rubicon 1.0

Post by Salvoxia » Tue Nov 19, 2013 22:27

Hi,

the last update before this one was the DB for Odyssey 1.1 (see http://www.evekb.org/forum/viewtopic.php?f=503&t=21615 ).

However, the Rubicon Update is based completely on the official Rubicon SDE, the entire invTypes table has been re-converted. So you all the names should be up to date.
As a test I tried posting this mail from your killboard to my killboard running the Rubicon SDE: http://www.demonic-retribution.com/?a=k ... l_id=32927
Worked flawlessly: http://kb.bunkerhub.de/?a=kill_detail&kll_id=283004

Regards,
Salvoxia

Eek
Someday Author
Posts: 73
Joined: Fri Dec 17, 2010 00:20

Re: DB Rubicon 1.0

Post by Eek » Tue Nov 19, 2013 23:34

Okay, nice.. Ive just deployed that Odyssey 1.1 patch before i did the Rubicon one as i found out that the Iterons still had their old names. Must have missed that DB update.

Again, thanks for all the work.

User avatar
Eowarebin
Greenhorn
Posts: 30
Joined: Thu Oct 03, 2013 00:13

Re: DB Rubicon 1.0

Post by Eowarebin » Tue Nov 19, 2013 23:43

Thank you for this update!!

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

Re: DB Rubicon 1.0

Post by Dism0 » Wed Nov 20, 2013 00:44

thanks for quick update!

underwoodr
Apprentice
Posts: 60
Joined: Sat Jan 31, 2009 03:23

Re: DB Rubicon 1.0

Post by underwoodr » Thu Nov 21, 2013 00:10

Thanks for this, great work

Post Reply

Return to “General Killboard Chat”

Who is online

Users browsing this forum: No registered users and 7 guests