EDK4.04 - Item name update script.

Help and support in getting the EVE-Dev Killboard to run on your site.
squizz
Greenhorn
Posts: 11
Joined: Wed Dec 30, 2009 22:57

EDK4.04 - Item name update script.

Post by squizz » Thu Mar 15, 2012 17:53

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.

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

Re: EDK4.04 - Item name update script.

Post by Salvoxia » Thu Mar 15, 2012 18:10

Hi,

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


Regards,
Salvoxia

netripper
Noob
Posts: 2
Joined: Thu Jan 26, 2012 10:58

Re: EDK4.04 - Item name update script.

Post by netripper » Thu Mar 15, 2012 18:22

Thanks for sharing :)

Setebrus
Noob
Posts: 9
Joined: Tue Mar 15, 2011 19:00

Re: EDK4.04 - Item name update script.

Post by Setebrus » Thu Mar 15, 2012 19:09

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
Greenhorn
Posts: 11
Joined: Wed Dec 30, 2009 22:57

Re: EDK4.04 - Item name update script.

Post by squizz » Thu Mar 15, 2012 20:04

Setebrus wrote: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
Noob
Posts: 5
Joined: Thu Aug 07, 2008 18:47

Re: EDK4.04 - Item name update script.

Post by Malatha » Thu Mar 15, 2012 20:59

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
Apprentice
Posts: 64
Joined: Wed Dec 07, 2011 15:25

Re: EDK4.04 - Item name update script.

Post by MrWhitei » Thu Mar 15, 2012 21:35

Malatha wrote: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
Noob
Posts: 2
Joined: Thu Jan 26, 2012 10:58

Re: EDK4.04 - Item name update script.

Post by netripper » Thu Mar 15, 2012 23:19

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
Noob
Posts: 1
Joined: Fri Mar 16, 2012 01:32

Re: EDK4.04 - Item name update script.

Post by Irori Neri » Fri Mar 16, 2012 01:34

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
Greenhorn
Posts: 11
Joined: Wed Dec 30, 2009 22:57

Re: EDK4.04 - Item name update script.

Post by squizz » Fri Mar 16, 2012 16:05

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 :)

Post Reply

Return to “Support”

Who is online

Users browsing this forum: No registered users and 13 guests