EDK4.04 - Item name update script.

[Frazer]

Script with fix did it for me

Finally!

[Elder]

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

[H_D]

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]

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.

[Ullus Demos]

This script worked great for me. Thanks!

[Kiddow]

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]

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

This.

[squizz]

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

[zero2espect]

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]

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