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.
 

Api to database app???

Author
epsilonion
CLOVEN SKY
#1 - 2011-10-08 22:31:53 UTC
I have looked at yapeal and that would be great if i had shell access, is there anything like yapeal that will allow me to setup from a webhost without shell access?

I had been pratting about with yeapeal then found that you need shell access from the old eve forum...

basically i want to pull all the corp api info and bang it in a mysql database as a primary conser.

any ideas please???


regards


epsi

[u]Boom you went BOOM!![/u]

Callean Drevus
Perkone
Caldari State
#2 - 2011-10-08 23:07:53 UTC
Yapeal will work without shell access if you can set up a cronjob from your web hosts interface (most allow this). If you do not know what a cronjob is, google is your friend.

Yapeal will also work if you put it in your web root directory and simply call yapeal.php I believe, though I'm not completely sure. Anyway, you can probably remove the checks that prevent you from doing so.

Developer/Creator of EVE Marketeer

epsilonion
CLOVEN SKY
#3 - 2011-10-08 23:25:35 UTC
I put yapeal in a directory of its own, tried running the create tables php file but got errors 403 error for some reason. .. :D

I filled in the .ini file but cannot populate the database with tables.

I found that there is not much in the way of documentation not even where to put api keys...

regards



epsi

[u]Boom you went BOOM!![/u]

epsilonion
CLOVEN SKY
#4 - 2011-10-08 23:34:32 UTC
epsilonion wrote:
I put yapeal in a directory of its own, tried running the create tables php file but got errors 403 error for some reason. .. :D

I filled in the .ini file but cannot populate the database with tables.

I found that there is not much in the way of documentation not even where to put api keys...

regards



epsi



I changed the permissions to exercutable now i et the following:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@xxxxxxxxxxxx.org.uk and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

[u]Boom you went BOOM!![/u]

Johnathan Roark
Quantum Industries
#5 - 2011-10-09 04:48:40 UTC
the only way to do this would be to install it locally using, then taking the sql files it caches and run those manually.

EVEVERIFY - A recruiting API Verification and Audit Tool

Also try out Yapeal for your php api needs

Dragonaire
Here there be Dragons
#6 - 2011-10-09 04:50:30 UTC
Try setting Yapeal up on your local machine and than copy stuff over to server is the easiest way around many of the problems you've been having. I've gone in depth on several ways to over come the problems you're having on the old thread plus in a few closed issues on the web site.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.

epsilonion
CLOVEN SKY
#7 - 2011-10-09 10:22:37 UTC
Aaahh, Sod it I will look at doinging my self (says grabbing the php for dummies book).. :D

just thought there would be an easier way to do these things.. :D once the info is in a database then its the hard part done (for me anyways).. :D


ty for your input guys


Epsi

[u]Boom you went BOOM!![/u]