open All Channels
seplocked EVE Technology Lab
blankseplocked Yapeal PHP API library (revision 1203 branches/keys/)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 12 13 14 15 [16] 17 18 19 20 ... : last (24)

Author Topic

Mahoosiv
Ardent Spirits
Ushra'Khan
Posted - 2010.02.14 15:15:00 - [451]
 

Edited by: Mahoosiv on 14/02/2010 15:47:01
Hi Again.

Now I am certain that this is numpty country, but reading through this forum I figured that the alpha download was a bit iffy - so I went to the svn version and checked out the trunk.

** Edited**
I have looked at the code and unless i am reading it wrong, the paths in setup.php are not the same as the paths in the install, i refer to the cache dir which in setup and common paths is set to be in the same dir as inc...

Do I have a completely messed up copy of this?


Please either shoot me or something cos I cant take the suspense!

Mahoo

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.14 22:49:00 - [452]
 

Mahoosiv - Actually right at this time the download version and the SVN are basically in sync and the download has advantage that it works correctly on new installs where the old one isn't being maintained anymore and I have no idea wither it works for them. I'm just working out some last minute issues before the branch I build the downloads from is merged into the trunk/ that you get from SVN. I've IDed a couple issues with MailMessages and StarbaseList APIs that I need to fix but once I've checked those fixes I will probably be doing the merge sometime this week. It would be very helpful for everyone to try the downloads and find any additional problems with it before then so they can be address.

I'm also looking for some help with updating the existing install info on the wiki etc. and writing some more guides from a new user point of view as I find it hard to write anything given that none of it is 'new' to me Wink Anyone interested in helping out please contact me through my G-Mail account. You'll need to have a G-Mail account yourself to be able to edit the Wiki etc.

AydenKain
Deep Core Mining Inc.
Posted - 2010.02.16 04:03:00 - [453]
 

So does anyone know how to associate ItemId and/or typeId to the actual Item name, assets for example?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.16 13:42:00 - [454]
 

To do that you'll need to static data dump. from it you'll need at least the invTypes tables for the itemID to name stuff. You'll also need one or more of the map* ones to do locations. You can find MySQL versions of them in the Sticky above.

Dirty Snipe
Posted - 2010.02.18 12:19:00 - [455]
 

I downloaded from the svn and uploaded to webhost.

Browsed to the following location to install yapeal.

http://www.eve-miners.co.uk/eveapi/yapeal/install/setup.php

and I get the following error

Fatal error: Nonexistent directory defined for log in /home2/evewarco/public_html/eveapi/yapeal/install/inc/mainfile.php on line 60

Pls Help.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.19 01:15:00 - [456]
 

Try creating either the log/ or cache/log/ directory that is missing. That an issue with the old installer/setup system and since it's being replace soon(tm) it's not being updated to some of the changes that have been made with directory structure. I recommend for anyone doing a new install to grab Yapeal from downloads from now on and use the new installer.

Dirty Snipe
Posted - 2010.02.19 09:05:00 - [457]
 

The problem with your installers is that I am uploading to a web host which I do not have shell access so your way of installing kinda buggers me up.

The old fashoned way of just uploading the files and running the setup.php to change config settings was a much better way of doing things.

Can this still not be an option on the downloads????

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.19 09:44:00 - [458]
 

Short answer is no. The bit longer answer is that a way to let you remotely instill over the web is planned but I'm not sure my idea will work yet. Another way of doing it is to install it on a local machine and once it's setup locally copy it over. Even the SQL files are available in the cache/ directory after install.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.19 10:41:00 - [459]
 

It's finally done the new install system has now replaced the old system in trunk/. I know some people liked the old system and this change will make it harder with some ISPs to install but there are ways to work around them. One of the reasons for the change is so several improvements could be made so there's more options where and how you can install Yapeal. I've also setup a new automated build system that should keep the downloads up to date with trunk/ as well.

revision 990

StinGer ShoGuN
Pragmatic Kernel
Posted - 2010.02.24 20:23:00 - [460]
 

Hi there !

I have just set up Yapeal to run some tests with it. I pull it through SVN on a LAMPP server. SVN says it's version 1000. However, when running yapeal.php, it displays a message stating it's version 898. Anyway, this is a small issue.

As there is no /install/setup.php, I set it up manually: created the user and DB and then, used the tables creation script. All good ! Then, I looked for a way to add a user, a character... with the /install/addTestCharacter.php and /install/addTestUser.php, but they were not working (error with ADOdb apparently). Hence, I added my character, corporation and user manually in the tables (active is set to 1). Then, run a yapeal.php, but nothing is done (or nearly): the only tables populated were serverServerStatus, utilCachedUntil and utilXmlCache. I have looked through the logs, but nothing appears (except errors or warns or else from when I was trying to understand how it was working).

So, what have I done wrong ? What else should I do to make it work ? I must admit, I'm not really willing to walk through the code (I am doing too much PHP elsewhere atm). Just tell me how I can make this tremendous library work !

Cheeers !

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.24 21:36:00 - [461]
 

Edited by: Dragonaire on 25/02/2010 00:03:37
Did you also make sure isActive is set on everything in utilSections and filled correctly? It's used as an overall admin level control on the APIs.

Quote:
However, when running yapeal.php, it displays a message stating it's version 898.
The installer changes that as part of the install process but now that I'm making ZIPs and TGZs available I should look at changing it during build process instead.

Quote:
Then, I looked for a way to add a user, a character... with the /install/addTestCharacter.php and /install/addTestUser.php, but they were not working (error with ADOdb apparently)
I thought I'd made them general enough to be used elsewhere but you might look at the class/util/*.php files as the scripts in install/ are most just a wrapper for them made to work in the install environment. I'd like to see what errors you were getting from them so if you wouldn't mind send them to me I'll take a look at them. Just send them to me at my project owner G-Mail address.
I made the class/util/*php classes to make it easier for me and everyone else working with the tables in util/. I try to make them easy to understand and useful for anyone integrating Yapeal into their applications.
Update: I've added a new wiki page that should help explain how to use these classes which you can find at http://code.google.com/p/yapeal/wiki/UsingClassUtilClasses

monkey miner
Posted - 2010.02.26 11:54:00 - [462]
 

Edited by: monkey miner on 26/02/2010 12:16:54
Thanks for an excellent tool! I'm having some issues similar to the above mentioned however..

I've installed yapeal on my Windows machine running xampp for the web services and I've got it running as far as it gets the data for sections: account, eve, map and server however I can't get it to fetch the char and corp data.. All the isActive fields are set to 1 and I can't figure out why it doesn't get those 2 only. Any ideas?

[EDIT]
Figured it out.. had to add all the different APIs I wanted to pull in the activeAPI field in utilregisteredcharacter and corporation now it works perfect :) Thanks again for an excellent tool

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.26 21:44:00 - [463]
 

Glad you figured it out and to help you and other application developers in the future I just finished write a new Wiki page that cover how the tables and settings are and aren't related which should make it clearer and easier to understand for most people compared to trying to follow the code and it's comments. I do still recommend looking at the code for a better understanding but the Wiki page should be a first step before that and you may find it's all you need to understand as an application developer about how they work together. You can find it at http://code.google.com/p/yapeal/wiki/UtilDatabaseTableDependences

Naja Ashei
Posted - 2010.02.27 01:30:00 - [464]
 

The linux installer doesn't appear to work. When it gets to the database section, I put in the db, user, and password, and it continually tells me that the user doesn't have permissions to use the database.

I've done everything I can think of here, including using the root user to try and get the installer to just move on. Any ideas?

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.27 03:44:00 - [465]
 

Check that you have at least version 5.0 of MySQL and that there is a information_schema database and the user you're try to use has at least select access to the SCHEMA_PRIVILEGES table. That user will also need create database privilege to create the DB. If you don't find any problems after that I'd try run these queries from either a MySQL command prompt or through phpMyAdmin and see what errors are being return that cause it to fail.

select `PRIVILEGE_TYPE` from `information_schema`.`SCHEMA_PRIVILEGES` where
`TABLE_SCHEMA`="MyNewYapealDatabase" and `GRANTEE`="'YapealUser'@'localhost'"

create database `MyNewYapealDatabase` collate = utf8_unicode_ci

BTW with MySQL usually the 'root' user isn't added to SCHEMA_PRIVILEGES so will always fail. Since the 'root' user always has all privileges even if named something else it's not listed since it would be pointless, at least that seems to be the thinking at MySQL Wink You should be able to still add record yourself and it will work.

Check everything above should let you find why it's failing.

Naja Ashei
Posted - 2010.02.27 08:21:00 - [466]
 

Originally by: Dragonaire
Check that you have at least version 5.0 of MySQL and that there is a information_schema database and the user you're try to use has at least select access to the SCHEMA_PRIVILEGES table. That user will also need create database privilege to create the DB. If you don't find any problems after that I'd try run these queries from either a MySQL command prompt or through phpMyAdmin and see what errors are being return that cause it to fail.


The issue appears to be that _ characters get escaped in the schema_privileges table, so your script passing the "foo_bar" database in doesn't match the "foo\_bar" in the table.

Also, as a general note, I've never encountered a webhost that lets you create databases without using their own tools, none of the users have create database permissions.

Ursulen Kein
Posted - 2010.02.27 11:54:00 - [467]
 

Hello,

I'm a director of a french corporation. I need your service Dragonia to use your tools for an adaptation for our website. We can pay you by ISK, or with real money, via paypal but it's important.

What's we need ?
- installing Out of Eve on our website, we don't know how to make it.
- Install on an other webpage, a tool to show the fuel staying in POS.

What we have.
- A website : http://chantiersspatiauxfrancais.domaines-laporte.com/news/news.php
- a place for an SQL installation
- we can give you ftp access for a part of the website.

What we offer to you ?
- an interesting price in ISK/ real money via paypal.

It's very hard to survey some pos, in space, always check time staying for BPO research ...

So, because for us, it's a game, we NEEED your service,

Thank your for your answer, don't hesitate, to contact me ingame.

Please help us.

Ursulen

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.02.28 00:19:00 - [468]
 

Naja Ashei - Ok that would explain the issue you were having. As I remember MySQL says using '_' is bad idea anyway in DB or table names but I will say I've done it too and then changed them because of all the problems they cause Wink You could escape it yourself and it would work right since the installer will pass it directly to MySQL.
Quote:
Also, as a general note, I've never encountered a webhost that lets you create databases without using their own tools, none of the users have create database permissions.
That one of the reasons Yapeal gives you an option to made it yourself with whatever tools they provide and then you tell it which one to use and it'll just add the tables to the existing DB. It even gives you option to add a table prefix to all it's tables so when you have a host that only lets you have one DB you don't have to worry about conflicts with any other existing tables from the rest of your applications.

I've always tried to make Yapeal work on as many hosting sites I can but I personal never have used a host but always ran it on local computers or one I had full control of. I wouldn't use a host that didn't give me SSH access and ability to make my own DBs but that is a personal thing. I will say with all the hosts now offering low cost VM hosting where they can give you that kind of access I really don't understand why anyone would go with traditional hosting even if it is cheaper as you're getting what your not paying for (bad service and in most cases outdated hackable sites).

Auguste Renoir
Posted - 2010.02.28 14:35:00 - [469]
 

And for me ? :) are you agree for me ?

Chris Libby
Gallente Heavy Industries
Trinova
Posted - 2010.03.01 16:09:00 - [470]
 

I've recently switch from a WAMP server to ubuntu and reinstalled the latest version of yapeal. I keep getting the following error when running the program for the first time:

PHP Fatal error: Call to private method YapealDBConnection::getOptionalColumns() from context 'Sections' in /home/chris/Yapeal/class/util/Sections.php on line 80

Any ideas? Thanks - Chris

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.03.01 18:40:00 - [471]
 

It's called developer forgetting about autobuilding and letting work in progress escape into trunk Embarassed Having to change how I do things a bit and still haven't got the hang of it sorry about that. I'll have a fixed for that and a few other bugs that have come to light probably later today.

I'm also looking at making a change to utilRegisteredUser to bring it more in line with the other utilRegistered* tables. Going to add activeAPI column for account section APIs. Currently that only the '/account/Characters.xml.aspx' API but if CCP decided to add any others it will become more useful in the future. The good thing about this change is it lets you now enable/disable that API without having to do the some for the user, chars, and, corps like now which should be a good thing.

Look for some more changes to make the new utility classes in class/util/ more useful for application developers as I'm changing Yapeal to use them and they mature. Any suggestions on them or other 'helper' type functions that would make your life as application developers easier I'd like to hear.

Naja Ashei
Posted - 2010.03.01 20:24:00 - [472]
 

Edited by: Naja Ashei on 01/03/2010 20:28:42
Originally by: Dragonaire
Naja Ashei - Ok that would explain the issue you were having. As I remember MySQL says using '_' is bad idea anyway in DB or table names but I will say I've done it too and then changed them because of all the problems they cause Wink You could escape it yourself and it would work right since the installer will pass it directly to MySQL.


I tried that when I discovered the issue, and it actually doesn't work either. The escape makes the permission test work, but then when it tries to fill the database with tables, no errors are reported, but no tables get created either. Note that this is the same thing I see if I just try to have it make a database using an _. No DB/etc end up created.

I finally ended up installing linux/etc on a spare box at home, installing the software, dumping the resulting database, editing the values to match what the hosting provider demands, then loaded the database on the remote end to make it work.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.03.01 21:15:00 - [473]
 

I'm glad to hear you found a work around but hopefully you'll only need it temporary.

Ok from what you're saying it looks like something about how I'm building queries in the installer scripts is different than in the rest Yapeal. I'll look into it some more and see if I can figure out why that happens. Probably some missing escaping in the installer scripts some where though I don't remember doing any escaping on the table prefixes in either.

Ursulen Kein
Posted - 2010.03.02 20:48:00 - [474]
 

Ok, well please answer me if you are agree to help me, i hope it's an honnest offer so, just say if it's ok or not.

Best R.

Orxa

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.03.02 22:10:00 - [475]
 

Sorry I didn't see you're post above seems it got missing while I was making my own post Smile
I have not a clue about Out of Eve as I've never more than glanced at it's main page.

I'd say you should use POS tracker for your POS stuff as it's been around for a while and works well.

For tracking your BPO research etc. I'm not really sure what to use for that but there's probably a few tools but all the ones I know of you can't install on your own site or are desktop tools.

As far as having someone do this stuff for you I'm not really the person for that since I've never worked with any of them. I know Yapeal which IMHO is a really nice API library and I'd be able to help you with it but what you're wanting is not something I do and you'll probably do better with your own thread find someone to help you then in this thread.

Cory Sopapilla
Minmatar
Kiroshi Group
Posted - 2010.03.05 00:36:00 - [476]
 

Edited by: Cory Sopapilla on 05/03/2010 02:08:34
Edited by: Cory Sopapilla on 05/03/2010 01:32:14
Edited by: Cory Sopapilla on 05/03/2010 01:03:21
Edited by: Cory Sopapilla on 05/03/2010 00:36:42
I've tried repeatedly to get it to put in my user API stuff in the test section of the new installer. It gets to the point where I get to choose 1 of the 3 characters and starts installing but ends up having errors when trying to insert the actual user data.

Do you have anything available on just manually filling in user information on the activeAPI field? I remember it being a bunch of space separated fields before I reformatted :(

Oh *edit* Fedora Core 12 64-bit
*edit2* exclamation points in the DB passwords need to be in quotes in the yapeal.ini file.
*edit3* Tried manually filling out utilRegisteredUser, utilRegisteredCorporation, utilRegisteredCharacter, utilAccountCharacters and set all the 'isActive' I could find to 1. No dice so far.
*edit4* I think I figured it out. I copy/pasted all the fields from utilSection char and corp to the respective activeAPI fields and it seems to be pulling.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.03.05 02:55:00 - [477]
 

Quote:
*edit2* exclamation points in the DB passwords need to be in quotes in the yapeal.ini file.
It should be quoting it and most of the others as well.

Have a look in cache/ for the cached *.sql files you should be able to run them manually. If it's failing before creating them then you can try creating the DB and tables by running install/createMySQLDatabase.php and install/createMySQLTables.php as needed from command-line. Once you have them you can try the addTest*.php files or just adding the info to the tables yourself. You'll find the list of APIs in the activeAPI column from utilSections table.

Hope that helps and I'll be looking into adding some more quoting for the command line parameters used in the installer to keep it from failing to start with.

Cory Sopapilla
Minmatar
Kiroshi Group
Posted - 2010.03.05 21:37:00 - [478]
 

Edited by: Cory Sopapilla on 05/03/2010 21:45:51
Edited by: Cory Sopapilla on 05/03/2010 21:37:50
Thanks for the reply. I think it's working but will need to make sure I got all of the tables during the install when I get home. I don't see anything for mapJumps, mapKills, Soverignty, etc and it's listed as working on the wiki. If they aren't just lemme know and I'll stop looking ;) Linkage

charResearch has nothing higher than 99.99 per day. I'll make sure that's not just something weird in the way it's being returned or a max value that needs to be increased later as well.

As always, thanks a ton for this utility. It's a major timesaver and very appreciated :)

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2010.03.06 00:08:00 - [479]
 

Originally by: Cory Sopapilla
I don't see anything for mapJumps, mapKills, Soverignty, etc and it's listed as working on the wiki.


They should be working, at least I know sov is. I'm guessing you have it turned off somewhere.

Dragonaire
Caldari
Corax.
PURgE Alliance
Posted - 2010.03.06 01:01:00 - [480]
 

Edited by: Dragonaire on 06/03/2010 01:18:04
Quote:
charResearch has nothing higher than 99.99 per day. I'll make sure that's not just something weird in the way it's being returned or a max value that needs to be increased later as well.
Column has been expanded so it can go up to 999.99 which should be enough Wink

Quoting in the installer has been changed which should help with non-alphanumeric passwords, etc.

revision 1015


Pages: first : previous : ... 12 13 14 15 [16] 17 18 19 20 ... : last (24)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only