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.
 

Website Development

First post
Author
Previous Topic Next Topic
Puhkastu Niam
Hedion University
Amarr Empire
#1 - 2014-11-18 12:50:55 UTC
Hello spacefriends

Im sorry if this is not in the right place.( i thought it was the perfect one )

I´ve been trying to make a website-calculator for my corporation , but without any luck.

So i thought to myself ,, why not ask the community.

I need some instructions on how to import the datadump to phpmyadmin(remote server)

also need a price calculator that fetches jita price for any item. (copy/paste) function.

Anyone willing to help me out in that.
Or anyone i can hire to do that ?

Best Regards
P
Ortho Loess
Escalated.
OnlyFleets.
#2 - 2014-11-18 16:21:18 UTC
There are mysql conversions of the Static Data Export available here: https://www.fuzzwork.co.uk/dump/

I'd recommend taking a look at the new endpoints just added to CREST though (only on sisi for now, but the data is pretty much the same, and it should migrate to TQ fairly soon). If you get types info from CREST instead of SDE, you should never have to worry about reimporting the SDE for each patch :) (also, the SDE is a pain to work with...)

Eve Central has an API where you can get price data (not available from CREST of the XML API, although history is on CREST...)

What sort of tool are you making? If it only looks up prices, then I'd just use EVE Central, if you want to use it to work out the cost to build something, by looking up raw materials etc. then have a look around at the other tools that do this first.
Puhkastu Niam
Hedion University
Amarr Empire
#3 - 2014-11-18 23:45:59 UTC
Ortho Loess wrote:


What sort of tool are you making? If it only looks up prices, then I'd just use EVE Central, if you want to use it to work out the cost to build something, by looking up raw materials etc. then have a look around at the other tools that do this first.


Thanks for you reply.

I know about the data dump that steve has on fuzzwork...
And i have the code for this calculator... php and javascript script.
All i want is to make this work ...
Ive been reading alot on the web on how to set this up.. And im just out of ideas. Either im just dumb, or this is a bit difficult.
I can do css, html, change things in phpmyadmin, hell ,,, im just not able to get this api website going..

And I know about eve-praisal . but we want our own dedicated corporation calculator .. very simple copy/paste items from ingame to the website.. Should be very easy to make...... Infact . i already have the code .... and the static data dump..
I just need it to work..

Anyone willing to help. i´ll make it worth the trouble.
Thanks in advance

Best Regards
P
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-11-19 09:20:31 UTC
Is the stumbling block you're running into getting the price data?

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Puhkastu Niam
Hedion University
Amarr Empire
#5 - 2014-11-20 17:56:22 UTC
Yes master Steve :-)

I got the code from you in email.
And now im just trying to figure out how to put it all togeather and make it work.

Any chance you can help me with that ...
Im very new at this so..

Best Regards
P
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2014-11-20 18:26:36 UTC
Puhkastu Niam
Hedion University
Amarr Empire
#7 - 2014-11-20 19:12:32 UTC
Steve Ronuken wrote:
https://www.fuzzwork.co.uk/2013/05/06/using-the-eve-central-api-with-php/ may well be of interest to you Smile


Ok. I think i found the code I want to use :
Am I right ?

$typeids=array(34,35);
$url="http://api.eve-central.com/api/marketstat?regionlimit=10000002&typeid=".join('&typeid=',$typeids);
$pricexml=file_get_contents($url);
$xml=new SimpleXMLElement($pricexml);
foreach($typeids as $typeid)
{
    $item=$xml->xpath('/evec_api/marketstat/type[@id='.$typeid.']');
    $price= (float) $item[0]->sell->percentile;
    $price=round($price,2);
    echo $typeid." ".$price."\n";
}


But this will only get price for tritanium like your website says ...
What do I change to make it fetch any price for any item, so I can make that evaluator code work ?

Where do I put the code with-in your code ? like what file and where ?
And last question. Do I need a database for all this or is the php code enaugh ?

Thanks a bunch .
Best Regards
Tarik

p.s. i´ll donate some iskies , if you give me your ingame name :-)

Best Regards
P
Xinryu
NEXUS Financial
#8 - 2014-11-20 19:23:19 UTC 
$typeids=array(34,35);

You'll need to change that into an array of whichever typeIDs you'd like information for

[Lotteries] New Eden Grand --{ LIVE }--

https://nexusdev.net/negrand/
Puhkastu Niam
Hedion University
Amarr Empire
#9 - 2014-11-20 19:34:03 UTC
Xinryu wrote:
$typeids=array(34,35);

You'll need to change that into an array of whichever typeIDs you'd like information for

Thanks for the reply.

Its a copy/paste evaluator ... I should be able to copy/paste items from ingame to the website .. fetching Any item price thats available..

I know that 34,35 is tritanium, but what do I put there instead .. so the evaluator code that fuzzysteve made can fetch any price for any item , from copy/paste.. :-)

Again, thanks for the help

Best Regards
P
Puhkastu Niam
Hedion University
Amarr Empire
#10 - 2014-11-20 19:55:06 UTC
i cant beleve i have to put in all typeid´s and names into the code ?
Do I really ??
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#11 - 2014-11-20 20:15:32 UTC
What you need to do is convert names to typeids, and look those up.

The conversion of names to typeids is what https://github.com/fuzzysteve/eve-evaluator/blob/master/display.php does.

It all pulls from a database Smile

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Puhkastu Niam
Hedion University
Amarr Empire
#12 - 2014-11-20 20:30:24 UTC
Steve Ronuken wrote:
What you need to do is convert names to typeids, and look those up.

The conversion of names to typeids is what https://github.com/fuzzysteve/eve-evaluator/blob/master/display.php does.

It all pulls from a database Smile


Thanks
Just to clarify ..

Do I need to put ALL typeid´s into this part of the code :
$typeids=array(34,35);

and then put this code into display.php
and it will all work like a charm ??

I also noticed one thing ..
in your code , i saw a page called price.php.
But there was no price.php in the folder.
Do I take that part out of the code or leave it ?
Xinryu
NEXUS Financial
#13 - 2014-11-20 21:06:49 UTC
Puhkastu Niam wrote:
Steve Ronuken wrote:
What you need to do is convert names to typeids, and look those up.

The conversion of names to typeids is what https://github.com/fuzzysteve/eve-evaluator/blob/master/display.php does.

It all pulls from a database Smile


Thanks
Just to clarify ..

Do I need to put ALL typeid´s into this part of the code :
$typeids=array(34,35);

and then put this code into display.php
and it will all work like a charm ??

I also noticed one thing ..
in your code , i saw a page called price.php.
But there was no price.php in the folder.
Do I take that part out of the code or leave it ?

In that code, there's a loop that constructs an array of typeNames to typeIDs called $typeidlookup.
The following code should get those typeIDs into the $typeids variable:
$typeids = array();
foreach ($typeidlookup as $tid)
{
    $typeids[] = $tid;
}

[Lotteries] New Eden Grand --{ LIVE }--

https://nexusdev.net/negrand/
Ortho Loess
Escalated.
OnlyFleets.
#14 - 2014-11-20 22:43:15 UTC
Puhkastu Niam wrote:

p.s. i´ll donate some iskies , if you give me your ingame name :-)

Not fishing for iskies myself, since I've been of very limited help here, but I feel Steve and Xinryu are too altruistic to say:

eve forums only let you post with ingame char names, so if you want to give them isk, just send to the char with the same name they posted under :)