EDK4.04 - Item name update script.

[squizz]

As taken from https://forums.eveonline.com/default.as ... post946237

You can find the script here:
http://fondl.zzeve.com/cron/item_update.phps (with pretty html markup)
http://fondl.zzeve.com/cron/item_update.txt (raw)

Directions:
1) Save the file as item_update.php in your killboard's cron folder. (copy/paste unless you like html markup)
2) From the command line cd into your killboard's cron folder and execute

php5 item_update.php

3) Watch it update item names

If you use CPanel or some other crappy web interface, you're on your own [:twisted]

Disclaimer: This works for me on a couple killboards I manage. I've used the same script, slightly modified, to update item names on Eve-Kill. This script DOES NOT add missing items, it only makes sure your database's item names match CCP's item names. Use at your own risk.

[Salvoxia]

Hi,

thanks for sharing this script!
Pulling the names via the api is an interesting idea, hadn't thought of that..


Regards,
Salvoxia

[netripper]

Thanks for sharing

[Setebrus]

Im getting this error while updating. What could cause that? Please respond if you have any info how to fix this.

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php:71 Stack trace: #0 /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php(71): SimpleXMLElement->__construct('') #1 {main} thrown in /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php on line 71

Thanks in advance

Setebrus

[squizz]

Im getting this error while updating. What could cause that? Please respond if you have any info how to fix this.

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php:71 Stack trace: #0 /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php(71): SimpleXMLElement->__construct('') #1 {main} thrown in /customers/lordsnapp.com/lordsnapp.com/httpd.www/killboard/all/cron/item_update.php on line 71

Thanks in advance

Setebrus

CCP's API server isn't returning anything valid. Blame CCP.

[Malatha]

You can update SQL manually using the following info.

Download:
http://fusion.massiveweb.net/crucible1.5.edk.zip

On Linux:
1. Unzip the file.
$unzip crucible1.5.edk.zip
2. Backup the DB.
$mysqldump -u 'db_user' -p 'db_name' > 'db_name.sql'
3. Import the data.
$cat ./crucible1.5.edk.sql/*.sql | mysql -u 'db_user' -p 'db_name'

On Windows:
Good Luck!

[MrWhitei]

You can update SQL manually using the following info.

Download:
http://fusion.massiveweb.net/crucible1.5.edk.zip

On Linux:
1. Unzip the file.
$unzip crucible1.5.edk.zip
2. Backup the DB.
$mysqldump -u 'db_user' -p 'db_name' > 'db_name.sql'
3. Import the data.
$cat ./crucible1.5.edk.sql/*.sql | mysql -u 'db_user' -p 'db_name'

On Windows:
Good Luck!

if this is directly from the datadump some modules are named the old way. and Trauma missiles are named as Scourge.

Gonna check out this script. seems like a cool idea

Cheers squizz

EDIT:

seems the EVSCO api proxy is down so i changed it to the CCP server api.eveonline.com and its working great.

[netripper]

Here's the .sql that basically does the same thing (but only for those that still have the 1.1 crucible db):
http://dl.dropbox.com/u/3500888/Eve/upd ... 214832.sql

The OPs script will always work. This .sql is a one time thing which you can do on top of the "EDK Database - Crucible 1.1 Rev 1.0 by FriedRoadKill".

Note that it only updates the names, allowing you to import new killmails. Stats can be wrong in case attributes were updated by this update. Hopefully someone is working on a full update and will release it in the near future.

[Irori Neri]

The OP's script is *almost* correct. It will appear to work, but won't be quite functional due to a small syntax error.

The following line:

Code: Select all

$qry->execute("update kb3_invtypes set typeName = '$name' where typeID = '$typeID'");

should be replaced with:

Code: Select all

$qry->execute("update kb3_invtypes set typeName = '$name' where typeID = '$id'");

Unless I misunderstand things. Which I don't think I do. Running the updated script fixed, including retroactively, all my killboard db troubles.

[squizz]

doh

this is what I get for mucking around with the script last night, thanks for pointing out the problem!

Also, I'm glad it helped you fix your db problems