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.
 

EDK4.04 - Item name update script.
Author
Previous Topic Next Topic
Squizz Caphinator
The Wormhole Police
#1 - 2012-03-15 15:45:33 UTC  |  Edited by: Squizz Caphinator
Cross posted here: http://eve-id.net/forum/viewtopic.php?f=504&t=18689
(the above link is being mangled by the forums, copy/paste into your browser to view)

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
Quote:
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.

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Axari
#2 - 2012-03-16 17:04:23 UTC
Confirming that this appears to have worked for me! (EDK 4.04)

I just dropped it in the cron directory and accessed it via the web at /cron/item_update.php

Curious, there are random items in the list that do not have a name. Should that be considered normal?

Examples:
6495/19676 15533
6496/19676 15534
6497/19676 15545
6498/19676 15547
6499/19676 15551
6500/19676 15559
6501/19676 15565
6502/19676 15566


Awesome work Squizz (as usual) -- Many thanks!
Packet Loss
Republic University
Minmatar Republic
#3 - 2012-03-18 12:33:30 UTC
Awesome sauce!! Thank you Squizz for your contribution to the community!!

The script worked seamlessly on my EDK Crucible 4.0.4 board.

I assume the empty item names are for items that have been removed at one time or other. The requirement to maintain the item id is obvious in that removal may break old mails. I've updated my version of the script to only update items that have a valid name to avoid clobbering legacy items.
Squizz Caphinator
The Wormhole Police
#4 - 2012-03-18 19:28:16 UTC
Yea, I've seen some discussion on these items that were removed and it appears a good majority of them will be coming back too.

Glad I could help you guys out :)

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Squizz Caphinator
The Wormhole Police
#5 - 2012-03-21 21:23:13 UTC
Script updated to not rename the typeID's that are coming back from the API with a blank name.

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Reileen Kawahara
Bio-Tech Research
#6 - 2012-03-30 23:15:31 UTC
Do you have a script to convert back seeing as CCP changed stuff again
Squizz Caphinator
The Wormhole Police
#7 - 2012-03-31 03:35:03 UTC
Reileen Kawahara wrote:
Do you have a script to convert back seeing as CCP changed stuff again


The same script will work.

Various projects I enjoy putting my free time into:

https://zkillboard.com | https://evewho.com
Philderbeast
Native Freshfood
Minmatar Republic
#8 - 2012-03-31 04:08:28 UTC
will this affect old kill mails with the old names?