MOD: Update all values from eve-central

[Blake]

its built into 3.2 as standard, its the item valus thing in the admin menu

[SnakeTheBest]

but you have to fetch each item hell manually that will take centuries =)

[Blake]

that'll learn learn me not tot double check the menu name before posting replys, its "Value Fetch" not what i had said before

[Oleg]

Faction prices at http://prices.c0rporation.com/faction.xml seems to be not working (it redirects to https://admin.c0rporation.com/faction.xml with invalid sertificate, and even if sertificate warning is ignored, there is net::ERR_SSL_PROTOCOL_ERROR error).

Is there any alternative way of updating faction prices?

[mastergamer]

Sorry about that, I typo'd the server's IP in one of the Apache configs which broke all the virtualhosts. As the admin domain is the first one it tried to serve everything from that. It's fixed now.

[1nv3r7]

hello all I need a little help,

My problem is that all my faction prices are wrong, now i've had a look through this thread and found some useful information,

Under the Value Fetch page I have copied the link which I found in this thread for faction prices http://prices.c0rporation.com/faction.xml

Now when I click the fetch button with this url in the text box I get the following error

WARNING [512] SQL error (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE price = VALUES(price)' at line 1
Error on line 402 in file /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/common/includes/class.dbcachedquery.php
PHP 5.2.13 (Linux), EDK 3.1.8 (Incursion)
File: /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/common/includes/class.dbcachedquery.php, line: 402, function: trigger_error
File: /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/common/includes/class.valuefetcher.php, line: 89, class: DBCachedQuery, function: execute
File: /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/common/admin/admin_value_fetch.php, line: 42, class: valueFetcher, function: fetch_values
File: /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/common/index.php, line: 310, function: include
File: /data/www/vhosts/extreme-freedom.eu/httpdocs/kb/index.php, line: 21, function: include

but it also says that it's updated 316 ships and 0 items...

currently on Board Configuration (Current version: 3.1.8 (Incursion) Build Dev 1169)

Please could someone assist me with this, or at least point me in the right direction.

Thanks

[Plain213]

same error as above

[SPEC1AL1ST]

cant download via svn

[Plain213]

this mod gonna be available any time soon?

[TechCat]

this mod gonna be available any time soon?

I think no, but I find some files

common/includes/eve_central_sync.php


./common/admin/admin_value_editor.php:10:require_once('common/includes/eve_central_sync.php');
./themes/default/templates/value_editor.tpl:27: {if $eve_central_exists eq "1"}<td><a href='{$kb_host}/?a=admin_value_editor&itm_id={$results[opt].id}&d=eve_central&item_type={$type}'>Sync to EVE Central</a></td>{/if}

Here http://trac.eve-id.net/browser/dev/mods/value_fetch