EDK4.04 - Item name update script.

Help and support in getting the EVE-Dev Killboard to run on your site.
Frazer
Noob
Posts: 7
Joined: Thu Mar 15, 2012 20:56

Re: EDK4.04 - Item name update script.

Post by Frazer » Fri Mar 16, 2012 17:11

Script with fix did it for me :)

Finally!

Elder
Noob
Posts: 1
Joined: Wed Feb 01, 2012 16:27

Re: EDK4.04 - Item name update script.

Post by Elder » Sat Mar 17, 2012 07:23

squizz's script worked like a charm for me, thanks man awesome job

H_D
Noob
Posts: 8
Joined: Mon Jul 11, 2011 11:25

Re: EDK4.04 - Item name update script.

Post by H_D » Sat Mar 17, 2012 18:35

Just dropping in to say thanks for the work on that; nice and easy to stay up-to-date with ccps mod changes. Good work OP.

waltari
Noob
Posts: 1
Joined: Sun Mar 18, 2012 16:19

Re: EDK4.04 - Item name update script.

Post by waltari » Sun Mar 18, 2012 17:56

used this script the dbase updated indeed but getting this
Database error: MySQL server has gone away
SQL: select * from kb3_corps where crp_id = 1
ERROR [256] SQL error (MySQL server has gone away
Error on line 46 in file /home/httpd/sk33tfl33t.com/kb/common/includes/class.dbnormalquery.php
PHP 5.2.6-1+lenny9 (Linux), EDK 4.0.4 (Crucible)
File: /home/httpd/sk33tfl33t.com/kb/common/includes/class.dbnormalquery.php, line: 46, function: trigger_error
File: /home/httpd/sk33tfl33t.com/kb/common/includes/class.corporation.php, line: 164, class: DBNormalQuery, function: execute
File: /home/httpd/sk33tfl33t.com/kb/common/includes/class.entity.php, line: 41, class: Corporation, function: execQuery
File: /home/httpd/sk33tfl33t.com/kb/common/index.php, line: 258, class: Entity, function: getName
File: /home/httpd/sk33tfl33t.com/kb/index.php, line: 27, function: include
when trying to access anything in admin section and/or posting killmail.
I did sql restore to state before using this script and all is fine again.
Looks to me like either some query or entire database timing out for some reason.

User avatar
Ullus Demos
Noob
Posts: 1
Joined: Sun Feb 13, 2011 19:15

Re: EDK4.04 - Item name update script.

Post by Ullus Demos » Sun Mar 18, 2012 19:10

This script worked great for me. Thanks!

Kiddow
Greenhorn
Posts: 14
Joined: Sun Oct 19, 2008 13:36

Re: EDK4.04 - Item name update script.

Post by Kiddow » Mon Mar 19, 2012 11:54

i dont have commandline access to my webserver. how do i use the script ? just upload the .php script from squizz to /cron and call it in the browser ?

or

the sql database archive from malatha. can i just upload the archive via pypmyadmin ?


my database is crucible 1.2.1

[edit]
another question. about the EDK update function. could this update just be distributed via this option ? would make the whole process more user-friendly. i guess that is what this feature was all about.

Xucphra
Greenhorn
Posts: 11
Joined: Mon Jul 04, 2011 13:02

Re: EDK4.04 - Item name update script.

Post by Xucphra » Mon Mar 19, 2012 19:02

Kiddow wrote:just upload the .php script from squizz to /cron and call it in the browser ?
This.

squizz
Greenhorn
Posts: 11
Joined: Wed Dec 30, 2009 22:57

Re: EDK4.04 - Item name update script.

Post by squizz » Wed Mar 21, 2012 23:23

Script updated to not rename the typeID's that are coming back from the API with a blank name.

zero2espect
Greenhorn
Posts: 14
Joined: Sat Apr 09, 2011 14:55

Re: EDK4.04 - Item name update script.

Post by zero2espect » Fri Mar 23, 2012 02:49

sorry. as a complete noob to webservers and stuff. i have cron access but not command line access.

i upload this file to the cron folder.

now what? when i type in <killboard>/cron/item_update.php i just get the wall of text code....?

i have tried setting up a cron job with the command line:

wget -q --delete-after http://<killboard>/cron/item_update.php

but it doesnt seem to do anything....(yet)?

triethylene
Noob
Posts: 7
Joined: Thu Dec 29, 2011 18:44

Re: EDK4.04 - Item name update script.

Post by triethylene » Sat Mar 24, 2012 15:43

You probably need to specify an interpreter, usually /usr/bin/php5?

/usr/bin/php5 <killboard>/cron/item_update.php

If that don't work you can probably also make the file executable so that you don't have to specify the interpreter.
chmod +x <killboard>/cron/item_update.php

Post Reply

Return to “Support”

Who is online

Users browsing this forum: No registered users and 8 guests