Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .. 24 :: [one page] |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Dragonaire
Caldari Corax.
 |
Posted - 2008.10.22 17:56:00 -
[1]
Hi all I've started a new SourceForge project for people to look at. It's based on some code I've been developing for a while and I decided to release it under GNU LPGL 3.0 in hopes others would find it useful.
http://sourceforge.net/projects/yapeal/ -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.10.22 18:00:00 -
[2]
Reserved for future posts -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.10.25 23:14:00 -
[3]
New version 0.1.0 available sorry for the broken one had up before. Not that this one might not have bugs but it should at least try to run ;) Also added MySQL files to build Database to db-tools directory. |

Rehtom Lamina
Coalition of Nations Free Trade Zone.
 |
Posted - 2008.10.27 14:46:00 -
[4]
will download and have a play tonight.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.10.29 00:11:00 -
[5]
Ok been doing a lot of bug hunting and seem to have eve and corp API stuff working but still working on the char part. Needed to make a couple changes to the membertracking table so you'll need to drop and re-create it for everything to work. I'm not doing a release at this point so if you want the most current code need to get it from the subversion.
svn co https://yapeal.svn.sourceforge.net/svnroot/yapeal/trunk/ -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.02 20:59:00 -
[6]
I've moved the project over to google code so it's easier for me to manage along with another project I'm working on now. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.18 00:56:00 -
[7]
Ok after over 200 revisions according to subversion I think I've killed all the previous bugs that made it unusable. It's got a lot of fixes to database code since I've changed over to using ADOdb (included) instead of MDB2. Yapeal is now fully PEAR free so it should be much easier to install and use. |

Rehtom Lamina
ECM Space Patrol
 |
Posted - 2008.11.19 10:49:00 -
[8]
Good work  ------ Sig -------
Selling unique, one off web design, Link |

oUTSKIRTs
 |
Posted - 2008.11.20 15:47:00 -
[9]
This is really cool, almost everything seems to be working now, the things that doesn't work right now, did work at some point during the revisions, so i'm excited to see how this project will turn out. Right now my cron job is doing exactly what it is supposed to (exept for at the moment 4 tables not being updated due to missing indexes or upper/lowercase issues that i noticed you're hard at work on fixing). Tables not updating is: fuel, starbasedetail, IndustryJobs and MarketOrders
I haven't checked this latest revision 228 out, yet, waiting for cache timer (so tired of that). Thank you for this, it is really really usefull to get rid of the xml problems and get right to work on a database instead. Awesome!
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.21 02:36:00 -
[10]
Thanks I'm killing bugs as fast as I find them but going to need some help from someone with some of the ones you talked about because the alt I'm using doesn't own any POS so that might make it hard testing 
My original code that I extracted Yapeal from had all the eve/ and corp/ stuff I used working but with breaking it out into separate project, changing DB structure, and switching DB libraries many things ended up broken 
I decided to work on the char/ stuff first this time since I'd never got around to making it all work before since my other project was mostly corp stuff and usually once it's working for one it's easy to move changes into the other code. That only leaves the few things that's unique to each to fix if they are still broken.
I'm up to revision 249 at this time so look for some more changes to be pushed back into trunk when I'm sure they're work. I'm trying to leave trunk as the more stable branch now that it's starting to work and I don't feel like I'm losing ground like before with it 
Also a trick I use during debugging is to have the XML caching on and then delete the records in the CachedUntil table for main script 'eve-api-pull' and which even one I'm test like 'MarketOrder' then see if it works or doesn't It's absolute need when working with AssetList and that 23 hour timer As long as it has a good cache file it doesn't try grabbing one from API and you can cheat on that to for testing by just changing the time in XML. Saves me a lot of 101 errors from API during testing and the server from some of the worse of my typos  |
|

oUTSKIRTs
 |
Posted - 2008.11.21 12:40:00 -
[11]
It's looking good, nice work!
I am doing some tests here and there, and I like the cache feature a lot, i was trying to get the whole deal to connect through an api-proxy - so that other people still have their eve-mon when i pull the data to this db, but it seems to fail horribly right away. It is probably the proxy stuff not doing it just right. Not really important at this point.
A few more things I have noticed, that I forgot to mention:
There is a table in Yapeal.sql called 'logo' - but the program is calling it as 'corplogo' when trying to access it. It works fine by just renaming the table in the sql.
The starbasedetails (and i think 'fuel' too) table is actually gone from yapeal.sql None of them get any data imported any longer, it has been gone for a while, i think i still have the revision that was infact pulling these two tables allright a while back.. Somewhere.. :)
In the marketorders table, there is a field called "range", very nasty name for a database field - this is also the name of a mysql function, making it fail unless in backtics or maybe calling the field something else might be better... Some say they have tables called range without noticing the problem, really I think it would be better to call it something else. I can see how that might become slightly impractical to say the least, but looking at your code im pretty amazed, you know your stuff and im sure you'll think of something lol
Other than that -- my database is alive, it's 
Really close, keep it up .. 
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.21 17:50:00 -
[12]
Glad you like it and thanks for the catch on the logo table but it was the PHP that was wrong. All the tables and fields are directly named from the fields in the API so when there's a difference on something look at Eve-Dev or in the XML for what it should be. So in the case of 'logo' it's now logo everywhere like it was meant to be.
As to the 'range' field yes it sucks and there's a couple others but that what CCP used so that what I use and I just have to make sure I use the back-ticks or let ADOdb take care of any quoting for stuff like that.
I drop the other POS stuff for now because I felt it needed done differently and didn't have time to mess with it right now and no way to test it but I think I'll have some friends from another project to help me out with that now.
My naming for all the main tables should be in CamelCase just like the API calls are and the "sub" tables as I call them follow the XML which seems to be camelCase. The fields are also in camelCase so far anyway so that's what I'm using. For all the backend administration tables they should follow the same naming as well and as I am getting around to it I'm converting all the naming of class, functions, methods, and variables to follow PEAR conventions with a few mods here and there. Example with the function named 'getAPIinfo' I should uppercase the second 'I' and had the 'pi' lowercase but just didn't look right to me and didn't want to re-name it either 
Hope this has been helpful on see where some of the changes I'm make are coming from when not smashing bugs as I find them 
I've never tested it with any of the proxies out there but did make it so that any that act just like the API should work fine after all what we get from CCP is all through a proxy already on their end. Even if other proxies only follow the API naming and return XML and normal HTTP errors it should work but it would probably lose some of the special caching extras I've built in to work with the main API. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

oUTSKIRTs
 |
Posted - 2008.11.21 18:15:00 -
[13]
This is probably not the way to fix this, but..
Quote:
function makeMultiUpsert(array $data, array $params, $table, $dsn) { // Need this so we can do quoting. $con = connect($dsn); $needsQuote = array('C', 'X', 'D', 'T'); // Build query sections $insert = 'insert into ' . $table . ' (`'; $insert.= implode('`,`', array_keys($params)) . '`)';
... a little further down ...
// Loop thru and build update section. $updates = array(); foreach($params as $k => $v) { $updates[] = "`" . $k . "`" . '=values(' . "`" . $k . "`" . ')'; };
Function taken from the common_db file.
I just punched in some backticks around the fields, and well.. it worked.. I think it shouldn't break anything else :) The table is updated, and it looks kinda ok to me.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.21 21:47:00 -
[14]
Never had any problem in that function with 'range' etc because MySQL is smart enough to know that you can't have it inside the insert (range) ... values() ... in duplicate key update range=values('range') statement that it's building and adding extra back-ticks might break it. What I need to do is change to using a prepare, execute instead but I haven't yet because I figured I'd run into trouble some where along the line between my code , ADOdb, and MySQL because of the on duplicate key update part. I didn't figure out a way to make it work with MDB2 but I should take another look at it now with ADOdb and see if it could work. It should be a bit faster to, although that doesn't seem to be much of a problem once I started using transactions for the larger updates of WalletJournal, etc. I've seen an up to 10x speed up since using the transactions. It has to do with DB not have to do as much locking it seems. There was even measurable differences down to 10 records level which is what others have posted on-line so that why you'll see I check for number of records in multipleUpsert() and use transactions for the larger ones now. |

oUTSKIRTs
 |
Posted - 2008.11.22 00:11:00 -
[15]
Just checked out rev. 266 and it looks like it is doing the range thing correctly
Real good job
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.22 01:16:00 -
[16]
Ok transfered all the fixes from char/ to corp/ and everything seems to be working. Can't test StarbaseList at this time so it's only one I really has any questions about. Did a complete drop and re-create on DB and everything works so it seems the code and SQL are in sync now finally. Still might have a few bugs but I've began to test it in crontab off and on now that it seem to be stable enough. It's not like I've ever had it caused problems just wouldn't always run right and filling up it's logs much faster then I could use while fixing problems  -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

oUTSKIRTs
 |
Posted - 2008.11.22 13:09:00 -
[17]
StarbaseList is updating correctly, you also got the certificates right first time around. Man I totally like this stuff :)
Could you use my cache files to test with?
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.23 01:28:00 -
[18]
Yep certificates was an easy one to do and for now I'm going to keep try to fill in some of the missing sub-tables before I really try adding more to it. I've had it run now with crontab for over 12 hours and it's never glitch even though API did once or twice on me Been trying it on another hosted site with someone else's info and had a few problems but think it's something not configured right on site and we'll have to wait a couple days until owner is back in town to make some changes. Thanks for the offer on the cache files we'll see how it goes and if I decide to get the POS stuff wrote back in (it's commented out right now) I might contact you about them if friend doesn't get back where I can use him as guinea pig first   -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.23 19:55:00 -
[19]
Ok did some looking around on prepare/execute in ADOdb and found that because mysql does things a little different they only emulate using prepare with it. Since that basically what I'm doing already I might as well use my code as their's While I was looking up stuff on prepare/execute in the MySQL manual I also decided to take another look at the stuff on insert and update about the quoting and decide even though I was right that it worked without problems as is, you were right oUTSKIRTs that the field names should be quoted with the back-ticks to insure no future problems so I've added them now in the latest versions. Glad you said something that made me take another look at it. Have them in there should help cut off some possible mystery bugs if MySQL purser changes or they add something to API in the future that could break it. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

oUTSKIRTs
 |
Posted - 2008.11.24 16:48:00 -
[20]
Thanks for continuing the work on this!
Just following up, the back-tick thing worked ok and look nice and solid too. However some of the changes from rev 274 and up must've somehow cracked the whole deal out, I'll leave my cron running hourly tho, incase it's another temp eve-api oddity, which i doubt actually, I think there is a little something somewhere...
What happens is this: Nothing - pretty much absolutely nothing that I can see
I cleared the cacheduntill table, but it doesn't even update/create the 'eve-api-pull' record, no logs created even with trace on and trace level above 0, trace set to 'all'. It'll just exit, after a short pause - like a second or so - it does SOMETHING that's for sure, and it doesn't exit with any error - no output at all. Rather odd.
The ./cache/* dirs are all writeable. I'll take a look later, will also 'restart' from the svn source with a fresh database and basically crawl the script a bit to see what's up incase you have no idea what this could be and that there could be something that didn't sync correctly (i *might* have a few local changes, but I'm almost 100% sure i have rolled all changes back each time before a sync)
I'm a little too busy the next few days to really go too much into it, but i'll be watching the svn closely :)
|
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.24 20:32:00 -
[21]
Yeah sorry about that broke it for a couple there but 280-281 works again I just committed what I was working on to test it and had to fix it only took a few minutes but seems you grabbed it while still broken Usually when I break stuff like that you'll start getting error and warning logs in cache/log/ as long is you have them turned on in ini which are on by default. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

oUTSKIRTs
 |
Posted - 2008.11.24 22:39:00 -
[22]
A fresh svn got it back up and running just now 
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.11.29 20:09:00 -
[23]
Just in case you hadn't noticed Yapeal doesn't have anything implemented to deal with the generation change that has happened with the wallet journal transaction Id. You can read more about the problem in this thread:
Journal API RefID change
I'd kind of forgot about them doing this so hadn't done anything to work around the problem (really was hoping CCP would just move to a bigint) but since they don't seem to plan on do that I'll be looking at a way to work around their bug Since I'm already using bigint for all ID type fields in the database it shouldn't be hard to work something out but main problem will be dealing with php5's lack of an native bigint. I'll update here as I decided on how to deal with it. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Grim
Amarr Fallen Angel's Blade.
 |
Posted - 2008.11.30 05:10:00 -
[24]
Very nice, major props. Coding an assets pricer and viewer. It is very interesting because I am getting 3 databases to work together as one, one from eve central, the mysql item dump, and the ui. So, I have to say it is quite a challenge.
- Grim -- Death By Titan :( |

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.02 23:44:00 -
[25]
Added a new incomplete RegisteredCharacterManagement class and some helper files. Plan on having a couple more for Corporation, and User plus maybe ones to manage groups/ collections of the above. Thought I'd get some feedback on wither someone out there thinks they might be useful and maybe be willing to do some of the testing for me when I finish it up  
Still working on the WalletJournal generations stuff hope to have something to test in a couple days on that. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

ThyShiva
 |
Posted - 2008.12.16 23:19:00 -
[26]
Hi, I downloaded the Yapeal code on the 1st Dec so will still have to look at you newest release.
Out the box and after configuring the yapeal.ini file, the alliancelist, conquerablestationlist, errorlist, reftypes and serverstatus tables were populated.
At first I only populated the registereduser table with my Eve details but my char data did not download. Only after reading the code did I realise that registeredcharacter table must have data in it too. There seems to be a step missing because the avg user will not have the information you need to populate registeredcharacter table.
I see youÆre looking for a tester, put my name on that list as your project lends itself nicely to my current distraction.
-Shiva
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.17 16:52:00 -
[27]
Hi glad to hear someone else finds it useful 
The basic information need for the RegisteredCharacter table can be found with a call to /account/Characters which only needs the info from RegisteredUser to get. Setting up and 'registering' characters, corporations, or users is a frontend application function so that why I really haven't added anything in Yapeal for doing it. I have been playing around with some ideas for managing those tables which you can check out in RegisteredAccountManagement.class.php and RegisteredCharacterManagement.class.php. They are untested and just some ideas I've have on how to do it. I've done a little more work on some of the ideas in a branch but it's tied in with some other changes I've been looking at making and I'm not ready show it to others until I've worked on it some more.
For something that's more of a application framework you should look at another project I'm working on with some others at EMPA. It mostly in the planning/outline stage without any real code but it was a large part of the driving force behind the changes to the design of Yapeal. -- Finds camping stations from the inside much easier. Been known to write some PHP code for API from time to time too. |

Tanja Torture
 |
Posted - 2008.12.18 13:49:00 -
[28]
Hi Dragonaire
I've setup yapeal on my server. I use one database only (I only filled the first DNS and left the rest commented). After I inserted an entry for RegistredUser and RegistredCharacter. When I run the eve-api-pull.php through "php5 eve-api-pull.php", I get the following message:
Quote:
[2008-12-18 13:40:45.651] Tired of waiting! Getting eve-api-pull for 0 [2008-12-18 13:40:45.658] Tired of waiting! Getting CharacterSheet for 91xxxxx
But the charactersheet and all others tables except "ChachedUntil" stay empty. What I'm doing wrong? I use revision 312.
greets Tanja
|

ThyShiva
 |
Posted - 2008.12.18 17:33:00 -
[29]
Tanja û have a look in the Yapeal_warning.log file in the \cache\log directory for any clues, also have a look inside the directory \cache\char for any xml files û they often have a clue to the error too.
Dragonaire û Thanks for the help and new classes û IÆll play with them over the next few days. IÆm looking into asset management as part on my project and I have noticed that you are storing the station location of the asset but not storing what container/ship the asset is in. You will need to store the container/ship ID the asset is in, either in a new field or by replacing locationID with the itemID of the container/ship. I would think a new field is the best way forward.
-Shiva
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.19 00:28:00 -
[30]
Tanja Torture - Make sure you set `isActive`=1 but from the error messages you give it seems you have. The 'Tired of waiting ...' can mean one of two things either you never tried get that API before so there's nothing in cachedUntil to compare with or it's now more than ~5 minutes pass when cachedUntil says that API expired. It's just a notice really that I setup to help keep track when the API is acting up and let you know it's doing something and follow ThyShiva advise if that still doesn't seem to let you figure it out try turning on some of the trace stuff and look in cache/log/Yapeal_trace.log and see if you can find where it's getting to. I'll need that information to help narrow it down more.
ThyShiva - You'll want to learn about 'nested sets' and how you use the `lft` and `rgt` fields to find what is inside what. Basic idea is if item is inside of something else the child's lft > parent's lft and child's rgt < parent's rgt. You can find more information about it in HierarchicalData which is from another project I'm working on with some other people.
If you or others are interested in help with that project you'd be more than welcome as we've seemed to have stalled a bit after the planning stage We basically want to make a GPL'd modular API application framework that will bring all our varies other API projects together into one and then expand out from there. Like to see all the people working on API applications not be reinventing the wheel so much and get out something we can all use and contribute to so it can become truly useful for everyone. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Tanja Torture
 |
Posted - 2008.12.19 06:00:00 -
[31]
Thx for your fast response. I've changed now the trace settings to trace_all. And yes the isActive field is set to 1. Now I get the following:
Quote:
[2008-12-19 05:43:34.747] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.754] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.755] Tired of waiting! Getting eve-api-pull for 0 [2008-12-19 05:43:34.756] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.756] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.757] CHAR: Connect before section in eve-api-pull.php [2008-12-19 05:43:34.757] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.757] CHAR: Before GetAll $charList in eve-api-pull.php [2008-12-19 05:43:34.758] CHAR: Before require pulls_char.inc [2008-12-19 05:43:34.761] DATABASE: Before connect for mysqlt://webX:[email protected]/eve_dbo?new in common_db.in [2008-12-19 05:43:34.762] Tired of waiting! Getting CharacterSheet for 9XXXXXXX
The chache directory only contains the Yapeal_notice.log which contains the messages from my last post. I have no clue if it is something with the database. But the chachedUntil field gets filled. So it can't be that wrong, I think... but I've never used AdoDB before... I can also send you the configuration files etc. via E-Mail if that helps. Would be nice if I can get it to work. I just love the idea of yapeal.
greets Tanja
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.19 07:38:00 -
[32]
You're the second one to have problems in that area on Yapeal so I've added some more tracing code to revision 313 to try to narrow it down a little bit more if you could grab it and we'll see if that help me figure out why. I've never had any problem with that part of the code on my test server so it's really got me puzzled what's going on. For the other guy we just copied over my code from my test server and it started work but by that time he'd also changed host so wasn't totally certain what had cause the problem before.
I'm also going to do some checking and see if it's something where I change it on my test server that didn't get back into the subversion some how. If we can't figure it out after you try new version we'll get together with E-mail and I'll take a look at your config too -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Tanja Torture
 |
Posted - 2008.12.19 08:12:00 -
[33]
Well plz tell me which options and debugging lvl's should be enabled to help you. I've checked out the newsest version, but I can't see a diffrence in the messages.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.19 08:44:00 -
[34]
Looks like you have the ones I need on already but trace_section=YAPEAL_TRACE_CHAR|YAPEAL_TRACE_DATABASE are the only ones I should need to track it down more. If that doesn't seem to add any more output try adding |YAPEAL_TRACE_REQUEST.
I'm sure you've notice but just in case you missed it Yapeal never clears the log files it just keeps added to end so you have to always scroll down to see latest run or delete them so they start fresh.
We might also try getting together in-game or on IM if we don't figure it out soon and report back to thread what we figure out the problem. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Tanja Torture
 |
Posted - 2008.12.19 09:24:00 -
[35]
Well I added those options, no success. I wrote you an email with my configuration and stuff.
greets!
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.19 23:12:00 -
[36]
Ok a little update for everyone make sure curl is install on your server and phpinfo() shows something about curl because it has to be added as ext to php as well. That usually means other package has to be installed on linux system or have curl compiled into php I'll be adding some addition check to Yapeal soon also so you get error messages if it not setup right. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ryel Theon
Epiphyte Mining and Exploration Combined Planetary Union
 |
Posted - 2008.12.20 00:32:00 -
[37]
There's a bug in the table structure of MarketOrders. An API pull attempts to insert with a column named accountKey. However the table structure as defined in the .sql file in the distribution does not create MarketOrders with that column.
Adding it with the same definition found in other tables containing accountKey allows the API pull to properly populate MarketOrders.
This was with an svn checkout from today.
Thanks for the work on this. I'm only just starting to play with it but it looks good so far.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.20 02:04:00 -
[38]
Edited by: Dragonaire on 20/12/2008 02:04:36 Thanks for the bug report but the SQL was right was bad copy&paste on my part in pulls-corp.inc that needed fixed. Market orders don't have accountKeys just ownerIDs. I've updated subversion with fix. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ryel Theon
Epiphyte Mining and Exploration Combined Planetary Union
 |
Posted - 2008.12.20 18:12:00 -
[39]
Thanks for the update. I've got another bug. I'm at svn rev 318 and running an api pull results in:
Missing file: /home/cpueve/public_html/yapeal/ADOdb/drivers/adodb-mysqlt.inc.php
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.20 20:11:00 -
[40]
Sorry about that forgot to post that you'll need to update your yapeal.ini file I change to using the mysqli driver for ADOdb and I noted it in svn commit but forgot to do so here. You'll need to change the line that reads driver="mysqlt://" to driver="mysqli://" and you'll be good. Should have been using it to start with since it's for the newer MySQL DBs not sure why I got started with the other one but thought I should change. Also means only need one file for driver instead of 2 which is always nicer You can also look in the sample ini which has the new line now too. I'm thinking about adding some kind of version info for ini file that it will check for so Yapeal can issue a warning if it's incompatible with your current one instead of just failing or that you can at least check manual for which is current and what the changes are. I don't change it very often but be nicer to have something in place. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.21 00:21:00 -
[41]
Ryel Theon - You were right to add it. There is a accountKey field for MarketOrders. I've now corrected pulls-corp.inc, pulls-char.inc, and the SQL file and added it to them all. I shouldn't try reading the forum and making changes to code when I'm half asleep I sometimes try short cutting and not double check myself against the XML files or Eve-Dev like I should So sorry everyone and reason it hadn't been caught much soon was the alt I'd been using to test with didn't have any market orders so I'd never notice it didn't work right I've now made a couple orders with that character so in the future maybe I'll notice when I break something like that The only API I wouldn't be able to test now will be StarbaseList and if I get around to adding it back StarbaseDetails.
I've push out the change to subversion revision 319 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Juloshko
Caldari Aberration Of Perdition
 |
Posted - 2008.12.22 10:59:00 -
[42]
I just cant figure this out, the readme is....non existent and i dont have a clue after over 14 hours of trying
please can you help me
server windows xp with Wamp server 2.0c MySql 5.1.3
(and wtf is a cronjob?)
|

Eldstrom
 |
Posted - 2008.12.22 12:51:00 -
[43]
Schedule task would be the windows equivalent to a cronjob.
Eld
|

Juloshko
Caldari Aberration Of Perdition
 |
Posted - 2008.12.22 14:49:00 -
[44]
Originally by: Eldstrom Schedule task would be the windows equivalent to a cronjob.
Eld
but what am i scheduling? is it one of the php files (never done anything like cronjob before)
|

Eldstrom
 |
Posted - 2008.12.22 15:21:00 -
[45]
Originally by: Juloshko
Originally by: Eldstrom Schedule task would be the windows equivalent to a cronjob.
Eld
but what am i scheduling? is it one of the php files (never done anything like cronjob before)
Sorry Juloshko I am unfamiliar with the workings of this particular API library. I would assume it would be one or more of the .php files.
Eld.
|

Ryel Theon
Epiphyte Mining and Exploration Combined Planetary Union
 |
Posted - 2008.12.22 17:24:00 -
[46]
Originally by: Juloshko
but what am i scheduling? is it one of the php files (never done anything like cronjob before)
These are the steps I used to get started. I doubt this constitutes documentation of any type. 
- Create a database in MySQL for your tables. Call it something like yapeal
- You'll want to run the Yapeal.sql file in that database to create all of the tables
- Copy the sample config in config/ to config/yapeal.ini and update it with the values appropriate for your system (database location, username, password)
- Create a row in yapeal.RegisteredUser containing your userid/api key info
- Create rows in yapeal.RegisteredCharacter and yapeal.RegisteredCorporation appropriate for your char/corp info and set isActive to 1 in those rows
- Run backend/eve-api-pull.php and it should populate all of those tables with the info associated with your user/corp as set above. Set it to run periodically to automatically keep your data up to date.
- Now write your favorite web applications to interact with those tables
Hope that helps.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.22 18:01:00 -
[47]
Ryel Theon's instructions is a good summary of how to get started and yes the documentation is lacking still for how to use it. You will find the start of a user guide in the Docs directory but it is very lacking at this point and somewhat outdated.
I've only tested Yapeal on Linux myself but I did try to design it so it could be adapted for use in Windows. If someone does adapt it for a Windows system I'd like to hear about it and any changes in the code that might be needed to make it easier.
I'll try to put up some kind of summary or whatever of some of the key files in Yapeal on the wiki if I get a chance that might make it a bit easier to understand. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.23 06:17:00 -
[48]
Hi everyone been working on Yapeal some more in a branch to update some stuff and thought I'd post about some of the highlights or at least what I remember doing anyway 
- Added a new class for tracing and changed code to use it. The tracing code was starting to get overwhelming and had some limitations that I'm trying to overcome.
- Added new required setting in yapeal.ini needed by new tracing code. There is now another variable named trace_output that needs to be set to "file", "database", or "both". Sending the tracing information to the database isn't active yet but is being looked at for the future.
- Removed the old unused setting in yapeal.ini for use_exception since all the code had already been updated to no longer use it. It was left over from time when code used both errors and exception in areas. Code now only uses exceptions so this setting is no longer needed.
- Changed location and how the CachedUntil table is updated. In some error conditions when the database wasn't update the cachedUntil time still would be, now the cachedUntil time is set slightly in to the future and only set to cachedUntil time from XML if we actual update the related table(s). This should also let Yapeal recover quicker from temporary error conditions by API server.
- Moved the function getAPIinfo() used to get data from API into it's own file inc/common_api.inc instead of having it in the inc/common_db.inc file.
- Fixed some typos in trace and error messages and probably made some new ones
Also did varies other small changes here and there to code formatting etc.
Soon as I finish posting this message I move my changes into trunk and push it out for you to get. Don't forget to update your yapeal.ini file with new settings as missing the added one will stop it from running.
revision 355 is up with the new changes enjoy. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ramov Tinoga
Tinoga Enterprises
 |
Posted - 2008.12.23 11:43:00 -
[49]
Edited by: Ramov Tinoga on 23/12/2008 11:43:20
Originally by: Dragonaire
- Moved the function getAPIinfo() used to get data from API into it's own file inc/common_api.inc instead of having it in the inc/common_db.inc file.
revision 355 is up with the new changes enjoy.
Could you please submit the new inc/common_api.inc so we can use it too? 
Thank you very much for Yapeal. I look forward to do crazy stuff with it.  -----
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.23 15:16:00 -
[50]
Sorry I copied over that file here but forgot to add it to the subversion for trunk revision 357 should be complete with inc/common_api.inc -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.24 00:46:00 -
[51]
Hi again someone that's been testing Yapeal for their application has found an error with the IndustryJobs table. Seems that the `installedItemLicensedProductionRunsRemaining` field is set to -1 at times but I'd made it an unsigned bigint which doesn't work so well I'm putting out an updated yapeal.sql file for everyone. Here's also the SQL to change your active tables so you shouldn't have to dump and reload your data but I would recommend doing a backup just in case anyway 
ALTER TABLE `industryjobs` CHANGE `installedItemLicensedProductionRunsRemaining` `installedItemLicensedProductionRunsRemaining` BIGINT( 20 ) NOT NULL
Thanks to ThyShiva for finding this and sending me the fix with the alter table included.
revision 358 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Juloshko
Caldari Aberration Of Perdition
 |
Posted - 2008.12.27 03:33:00 -
[52]
Finaly got it running
now just gotta make a cool looking page for it (when i learn php)
|

Iskandara Cho
 |
Posted - 2008.12.27 17:20:00 -
[53]
Hi,
I would like to use yapeal to pull the personal information for my 3 alts as well as for my corporation, but I am having more than a little difficulty figuring out what I need to modify or not in the .ini file. Then there is the question of where I find the information needed for the registered characters and corporations.
A little help?
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.27 19:12:00 -
[54]
There are a couple ways to get the data you need but the easiest is to go to eve-online
- Then go to Eve Insider > My Character and sign in as needed
- Click on the character you want information for
- Click link to get XML data and from there you can get your characterID and corporationID
- Go back to character info page and scroll down to the API section and click the link there
- Read the info on the page about API keys then click button to get full API Key and either copy & paste it to a text file to save it or just write down your userID and API Key
- Now you'll need to add the information you've collect to the RegisteredUser and RegisteredCharacter tables like Ryel Theon wrote up in post 46 of this thread or you can find wrote up in the Yapeal wiki pages
Hope that enough to get you started. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Iskandara Cho
 |
Posted - 2008.12.28 14:38:00 -
[55]
Hi, Thanks, that did help.
I've gone through your sample.ini file and come up with two separate documents:
An Example yapeal.ini for a single database and a first pass at Documentation for the yapeal.ini file.
If you could take a look at them and see if I've made any mistakes I'd be grateful.
I also ended up with a few questions:
What is the behaviour of conflicting settings between the database and the database-xxx "active" fields?
What is the database named in any dbname field used for if the active field is set to FALSE? ie is it necessary to have a db name in the default section if the db-xxx sections have named db's?
Should each of the sub-db's have the same structure as the main db (as defined by the sql file provided)?
Does the username:password pairing need to be the same across all databases? Though there is a field in each db-xxx section they all share the same name "writer". If there is a pairing in the default Db section and a different pairing in a database-xxx section, which takes precedent?
Is the required section [DEBUGGING] really called [TRACING]?
Thanks!
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.28 23:51:00 -
[56]
Glad it helped. I tried going to the files you linked and I get '404 Sorry, the stargate denies you access.' errors so think you need to check the links.
Now on to you're questions.
The [database] section sets the defaults for all the [database-xxx] sections. So if you have something set in both of them the [database-xxx] setting will over ride what's in the [database] section. If you set all required settings in each active [database-xxx] section then you don't have to set any of the ones in [database] at all but it is easier to use just it if you're only using a single DB. In the original application that Yapeal developed from I use a separate DB for each API group (char, corp, eve, etc) and I've so far kept that ability to allow for more versatility by anyone using it.
If you decide to use multiple DBs say to have separate character and corporation DBs then you would have to duplicate the overlapping tables like MarketOrders, WalletJournals, etc. for each DB.
Each DB can have their own user/password pair if you want. You could probably even have all tables from the same API groups (char, corp, etc) have different user/password pair if you wanted in a single DB because of the way they are used. Each [database-xxx] section has several constants set from the yapeal.ini settings which are then used throughout Yapeal to access each 'DB' even though in most cases they are all set to the same values when using a single DB. Using a single user/password pair and one DB for all the tables is by far the easiest way to use Yapeal but if you need the more complex setup with multiple DBs and/or users it was build to allow for that. I will say though that the single DB with multiple users hasn't been tested by me but I see no reason why it shouldn't work.
There is both a tracing and debugging section for now I have looked at combining them but they do have different purposes even though they often overlap when you are actually trying to debug something. I use the tracing sometimes to track the program flow where the debugging code and error messages are either missing or not as helpful as they could be. A good example of when this has happened was with a couple users that had no error messages but Yapeal still wouldn't download their API information. What it turned out to be was they had cURL installed but not the php extension you need so php can use it and php didn't throw any kind of error messages that we could find because it had been build with cURL in an extension module and it just wasn't loaded. I thought it would have give us some kind of error message when I called the cURL function but instead it just quietly failed 
Okay I think I've covered all your questions and hopefully you can fix those links and I'll have a look at what you've done and thanks for the interest in trying to help document Yapeal for everyone. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Mintoko
Gallente Nova Remnants
 |
Posted - 2008.12.29 06:27:00 -
[57]
This is absolutely wonderful. I finally got it to work, but have a request...
I want to be able to add a prefix to the table names so that I can place them into my current database and still keep them together instead of having them spread throughout the list. I'm looking at the possibility of doing this myself, but will probably still be fiddling with it a lot longer than it would take you. :)
Perhaps, a default yap_ or something manually configurable.
|

Iskandara Cho
 |
Posted - 2008.12.29 08:22:00 -
[58]
Edited by: Iskandara Cho on 29/12/2008 08:26:37
Thanks for the answers Dragonaire.
docs and sample ini files in a zip
It seems eve files didn't think they were appropriate content, so I've tried it as a zip. Let me know if there are still problems and I'll find another host.
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.29 19:24:00 -
[59]
Seems Eve-files still doesn't like something it's still got the same error 
An error on line 102 of backend/eve-api-pull.php which is the try { line would suggest to me that you've got a bad file some how probably through an unintentional edit while looking at one of them. I've put out a new revision 363 which you might try getting and overwrite the existing files see if that clears it up. Yapeal's been running without error on my test server for the last several versions so that's the most likely cause. I've done it myself a few times while looking around at stuff before If you can when opening a file in your editor just to look at it try opening it read-only. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.29 19:55:00 -
[60]
Mintoko - I've been looking at adding some kind of prefix to all the table names because some of the API re-use the same names in the rowsets but with different columns (fields) An example would be 'skills' in both the CharacterSheet and SkillTree. To add any kind of prefix though will require editing most the SQL queries in Yapeal since most places the table names are hard coded into the SQL Probably a bit of lack of foresight on my part but something that often gets overlooked when try to get something working.
I'm working on some changes to Yapeal that should make adding more APIs in the future easier and as part of that I plan on adding some kind of prefixing system so it's less of a problem. I'm not sure when I'll release these changes since it's very much in an early stage of development and I haven't even got any running code yet so best I can say now is it's on the list of things I plan to do 
If you decide you can't wait and go ahead on your own and make something hopefully you'll share it back with us and maybe I'll be able to add it into Yapeal for everyone else that might have the same need. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Iskandara Cho
 |
Posted - 2008.12.29 21:35:00 -
[61]
Edited by: Iskandara Cho on 29/12/2008 21:54:37 If these don't work I will resort to carrier pigeon...
First pass at documentation
Sample single db .ini
I pulled the latest files from subversion, reuploaded them, and again tried running the script from the command line with the same result.
The line in question (line 101 of the current file) reads:
$cachetypes = array('tableName' => 'C', 'ownerID' => 'I', 'cachedUntil' => 'T');
is it possible that something in my .ini file is causing this error?
For that matter, I am not sure I am calling the script properly.. what should my command line read for proper execution?
Thanks!
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.29 22:59:00 -
[62]
Ok I now can see the files and I'm looking through them as I'm typing here.
You can use the lines from my crontab examples in the CrontabSetup wiki page by just not having the '*'s in front of it. So /path/to/yapeal/backend/eve-api-pull.php should work on most systems. What I like to do is cd /path/to/yapeal/ then run it with backend/eve-api-pull.php as that also let's me do things like dir cache/log/, vim -R cache/log/Yapeal_error.log, vim config/yapeal.ini, etc which makes my life easier during debugging.
So far the files look good though might want to check them with spell check. I also noticed you are setting the [DATABASE-UTIL] section to use another DB in your single DB sample which isn't a true single DB setup. After I've looked through them a bit more I'll probably add them to the subversion somewhere and make any changes to them I think of so you can take a look and see what you think. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.29 23:38:00 -
[63]
Ok I added the yepeal_ini_docs.txt to trunk in config directory for now. Have a look and see what you think.
I missed where you asked if a bad ini file could cause errors and it could but most of them should be caught as it is read by inc/common_backend.inc -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Mintoko
Gallente Nova Remnants
 |
Posted - 2008.12.30 01:46:00 -
[64]
Originally by: Dragonaire Mintoko - I've been looking at adding some kind of prefix to all the table names because some of the API re-use the same names in the rowsets but with different columns (fields) An example would be 'skills' in both the CharacterSheet and SkillTree. To add any kind of prefix though will require editing most the SQL queries in Yapeal since most places the table names are hard coded into the SQL Probably a bit of lack of foresight on my part but something that often gets overlooked when try to get something working.
I'm working on some changes to Yapeal that should make adding more APIs in the future easier and as part of that I plan on adding some kind of prefixing system so it's less of a problem. I'm not sure when I'll release these changes since it's very much in an early stage of development and I haven't even got any running code yet so best I can say now is it's on the list of things I plan to do 
If you decide you can't wait and go ahead on your own and make something hopefully you'll share it back with us and maybe I'll be able to add it into Yapeal for everyone else that might have the same need.
I certainly will....I almost had it completely working, but made a change that crapped up the whole thing. I made two fresh attempts and think that I may be successful on the third attempt. I'll let you know.
|

Iskandara Cho
 |
Posted - 2008.12.30 07:21:00 -
[65]
Glad you found the docs useful.
I've pulled the backend file again, checked the ini file thrice, and I'm still getting the error about an unexpected { on line 101...
|

Fishweasel
Imperium Technologies
 |
Posted - 2008.12.30 13:52:00 -
[66]
I was hoping to get a look at this, however i cant find any files on the yapeal pages, am i missing something ?
Fishweasel
|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.30 16:08:00 -
[67]
Fishweasel - To download the code you need a Subversion client program which there's a link to a list of them on the Source tab. I use TortoiseSVN for Windows myself as I like the way it integrate with Windows Explorer but there are several others to chose from. I just use the normal svn commands with Linux and sometime on Windows too when it's easier then TortoiseSVN.
If you just want to have a look at the code on-line you can click on the Browse link in the upper left corner and have a look around.
At some point I may start releasing Yapeal as zip or tar.bz archives but it's changing sometimes several times a day (360+ revisions in last 2 months) that it's not worth the extra effort right now when getting started with Subversion isn't that hard even for someone that hasn't seen it before. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.30 16:58:00 -
[68]
Iskandara Cho - Either still have an unintentional edit somewhere or a file got delete somehow. At that point Yapeal have only ran the stuff in inc/common_backend.inc and a few require_once on some of the error/exception code from there and I've double check all of them both in my editor and by running it on my test server over night and I'm not seeing any errors You might try backing up your config/yapeal.ini file and delete everything where you have it installed and try re-installing the whole thing again. If that doesn't fix it it'll have to be something in your yapeal.ini and we'll have to figure out how you managed to get that error from a bad config file and see what can be done to catch it before it can do that. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Iskandara Cho
 |
Posted - 2008.12.31 11:58:00 -
[69]
No joy 
I've completely deleted the installation on my web server, updated from SVN, deleted the databases, ans started from scratch.
1) Uploaded files to server 2) edited ini file to new db info 3) ran script (php eve-api-pull.php) 4) Get an unexpected { on line 101 error

|

Dragonaire
Caldari Corax.
 |
Posted - 2008.12.31 15:36:00 -
[70]
Very strange because I just did same thing and have no problems  I'll sent you an e-mail via eve-mail and have you send me you're config file and I'll see if there's something there that I see and maybe try to get with you in eve or on IM too. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Ragga daPhunk
Order Of Lyon
 |
Posted - 2009.01.04 17:13:00 -
[71]
greetings!
just discovered your project and i really like it.. but it doesn't work for me :( the only thing that gets updated in the database is the "CachedUntil" table but nothing else. i enabled all logging and tracing but it doesn't come up with an error.
trace.log says: [2009-01-04 17:06:13.530] API: Before connect for eve-api-pull in eve-api-pull.php DATABASE: Before connect for mysqli://eveapi:[email protected]/eveapi?new in common_db.inc API: Before dontWait DATABASE: Before connect for mysqli://eveapi:[email protected]/eveapi?new in common_db.inc
notice.log says: [2009-01-04 17:06:22.042] Tired of waiting! Getting eve-api-pull for 0 [2009-01-04 17:06:22.048] Tired of waiting! Getting CharacterSheet for 8xxxxx
database connection seems ok since the cacheduntil table gets updated and stuff.. when it fetches the api it takes some seconds.. so somethings is done.. but what? i enabled caching of the xml files - but the cache folders are empty. curl support is compiled in btw.
|

PoshaX
 |
Posted - 2009.01.04 23:34:00 -
[72]
I haven't been able to figure out why, but I continue to get this exception right after it says it is updating the character information.
[2009-01-04 23:25:55.289] Uncaught exception in eve-api-pull.php [2009-01-04 23:25:55.289] EXCEPTION: Code: 1 Message: Missing required fields (balance, bloodLine, characterID, cloneName, cloneSkillPoints, corporationID, corporationName, gender, name, race) found while making upsert for CharacterSheet File: /apps/eve/yapeal/inc/common_db.inc Line: 272 Backtrace: #0 /apps/eve/yapeal/inc/common_db.inc(430): makeMultiUpsert(Array, Array, 'CharacterSheet', 'mysqli://root:w...') #1 /apps/eve/yapeal/inc/pulls_char.inc(106): upsert(Array, Array, 'CharacterSheet', 'mysqli://root:w...') #2 /apps/eve/yapeal/backend/eve-api-pull.php(158): require('/apps/eve/yapea...') #3 {main} --- END TRACE ---
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.05 00:25:00 -
[73]
Okay here's some tips on figuring out problems with Yapeal. First have a look at GettingStarted on the Yapeal wiki then check out the new TroubleShooting page I just made. It also might be useful to look at the other wiki pages while you're there. Hopefully after going through the wiki you'll be able to find the problem and it'll be something you can fix yourself, if not then you should have the information and log files to make my life and yours a bit easier while we try to figure out what's going wrong 
revision 398 now out. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.05 00:50:00 -
[74]
I made a couple small changes to config/yapeal.ini so anyone using Yapeal should check out the example file.
For anyone having problems with Yapeal please make sure you're using the latest version and go through the pages I link in the post above hopefully by doing that you'll be able to find the problem yourself and not have to wait on me to check the forums.
Ragga daPhunk - Not sure what you're problem is if you'll try out troubleshooting page from wiki it should help you track it down if not I'll need you're log files with trace_level=2 you'll find the instructions about this in wiki.
PoshaX - Make sure to double check your configuration and the required stuff in all the RegisteredXxx tables I think there's something missing there. If after check those things you're still getting an exception I'll need the trace_level=2 log files from you too and try to figure out what's going on. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Iskandara Cho
 |
Posted - 2009.01.05 02:20:00 -
[75]
Still no joy. I've contacted my server provider to see if they can shed any light on the problem. I'll keep you posted.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.05 02:48:00 -
[76]
Edited by: Dragonaire on 05/01/2009 02:50:37 Might also try sending me your logs Iskandara Cho. I never saw any from you after you made contact with me via E-mail etc. If you have any that is  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Iskandara Cho
 |
Posted - 2009.01.05 09:21:00 -
[77]
Nope, no logs, it never gets to the point of actually executing anything.
I've heard back from support, and they said there is nothing they can do with 3rd party scripts. Not unusual I guess, but still kinda frustrating. I've sent you an email with the url to the phpinfo for my server.
Thanks for the help.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.06 18:50:00 -
[78]
Okay been working with Iskandara Cho on her problem and found something that might be useful for anyone else that having problem getting Yapeal running to check.
Assuming a Linux system from a command-line try:
php --version
If the output reads:
PHP 4.X.X blah blah blah OR PHP 5.1.X OR anything else
Except:
PHP 5.2.X blah blah blah
where X is a number that's the reason it's not working for you. Some of you may have looked at the output from phpinfo as a webpage and seen that it says PHP 5.2.X but the Command-Line Interface version of PHP that Yapeal uses is a different file and on some hosting sites you end up with the php4 CLI and php5 for webpages  In Iskandara Cho's case on DreamHost that was what was happening 
If you are hosted at DreamHost and you know Linux command-line a little try their instructions Advanced_PHP_configuration to fix the problem by following the ones for php5. You don't need the stuff for FastCGI for Yapeal but you might for the other stuff you're doing on your site I can't help you decide on that part Yapeal should work with or without.
The other way to fix it is to make a small change to backend/eve-api-pull.php file but you will have to do this every time you upgrade Yapeal.
For DreamHost change the very first line of backend/eve-api-pull/php from:
#!/usr/bin/php
To:
#!/usr/local/php5/bin/php
I'm going to add a page to the Yapeal wiki where I can add links and/or instructions for others but until then if you have this problem on another hosting service and figure out how to fix it please post it here and I'll add it to the wiki when I get page setup. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.07 08:40:00 -
[79]
New revision 421 out it should fix bug where Yapeal wouldn't run if trace=FALSE in [Tracing] section of config/yapeal.ini 
Yapeal project home http://code.google.com/p/yapeal/ -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.07 19:13:00 -
[80]
Ok decided to get some more input from people using Yapeal or other interested parties on things they'd like to see changed or added to it.
Here's a list of things people have already told me about:
- Some kind of install/setup script
- Some thing to help with managing the RegisteredUser/RegisteredCharacter/RegisteredCorporation stuff
- Better documentation
Anything else? Also what other APIs would people like to see added to it next? I'd like to get a little input on this and then I might even try making/adding some kind of development roadmap on wiki so people have something else to complain about on the forums when I don't always follow it 
I've already got one person that offered to take a stab at making an install script while I keep working on other stuff but I sure he wouldn't mind some help with it. For that matter if anyone out there has a programming itch and you know PHP or want to learn it I'd be happy to have the help that how Yapeal got started for me. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.08 20:17:00 -
[81]
Hi all been working with PoshaX? about the missing required fields problem in CharacterSheet and seem to have tracked it down to a bug in old versions of php5 on some Linux systems. In this case happens to be Debian Etch.
-- Rant On -- Etch was released on December 18th, 2008 but bug was fixed in PHP Version 5.2.1 back in 8-Feb-2007 but apparently nearly 2 years isn't enough lead time for them to include it or a couple months isn't enough time to release upgrade to even Version 5.2.6 which came out in 1-May-2008 which fixed several security problems etc For those interested the newest release is 5.2.8 which fix a bug that slipped into 5.2.7 or if you're a little more daring they have PHP 5.3 out which backports some stuff from PHP6 as I understand it. I've already had an official update to 5.2.8 available for my old OpenSuSE 10.3 for a while now  -- Rant Off --
Anyone using version 5.2.1 or newer of PHP shouldn't see the problem since that's when they fixed the bug. I've got a work around for the problem ready to be tested as soon as I get a chance to get back with PoshaX that I'll release if it works. BTW there's is a similar problem with CorporationSheet that my work around should fix also  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.09 01:25:00 -
[82]
Hi all me again been doing some cleanup up and move stuff around in Yapeal to streamline it a bit and make it easier for people to use. Some of the things I changed:
- Moved the Docs directory out of the project directories in trunk and all the branches and put them into their own top level directory. I never seem to have any time to update them so no need confusing people with having outdated information being included. Also makes Yapeal a little faster to download and easier to integrate for people that don't want or need to include them with their projects.
- Added new admin top level directory. I'm looking at maybe having a download/installer setup for people that don't or can't use subversion and I need to have a place outside trunk or the branches to keep the config files for it plus a few other misc stuff that isn't needed to use Yapeal but I need while working on it. So you might notice a few more things migrating over there as I run across them.
- Finally I found some nice little graphics again that someone made for me to use with Yapeal a while back and I decided might be nice for me to include them for people to use in their own projects etc. If you want to include one of them on your website with link back to Yapeal's website that would be great but only do it if you feel like it. I'm happy if you just let me know with post on forum or an E-mail that you like it and are using it.
That's it for this post I think fly safe. |

ThyShiva
 |
Posted - 2009.01.09 20:09:00 -
[83]
Hello,
I have not posted in a while as I have been intergrating Yapeal with my project. I would like to second Mintoko's request for a table prefix as many of us have database limits or just like to group tables within databases.
Keep up the good Dragonaire.
Shiva. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.10 12:36:00 -
[84]
Hi Dragonaire I have been using another API function for retrieving all my corp info and character info.
After have installed this script for testing purpos, I can now allready say that it will make my site mutch faster since it don't need to pulle the XML files each time a page need to be showen and putting it in a database just make it faster and mutch easyer to sort the the content. :)
I will start to implement this into my website now.
One thing I was wondering about. Once you updating an assetlist, will this script delete those info that have been used or sold or related to that ??
Kind Regards Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.10 18:15:00 -
[85]
Hi Satis Iqulenax glad you like Yapeal.
Quote: Once you updating an assetlist, will this script delete those info that have been used or sold or related to that ??
No it doesn't try to make any changes to the AssetList or any of the other API data really for that matter. I don't see that being part of the job it's trying to do. Yapeal tries to just take what it gets from the Eve API and put it into the DB in what I hope is a sensible way. To do that and be usable by multiple characters and corporations it does add a few extra columns like ownerID, accountKey, etc to the tables but I never take stuff away I leave that up to you as the application developers to decide what you want to do.
Just a couple things to think about if you try to update the AssetList yourself is that the itemIDs aren't constant in many cases. For example if you split a stack of ammo to use, sell, or just move part of a stack the old itemID is dropped and Eve makes 2 new IDs for the new stacks. The same thing happens if you repackage/assemble something it gets a new itemID. There are other times when it can change also I believe but I think you can see the problems with trying to update stuff as things change. Add to that that the next time Yapeal does get data from the API any of your change to Yapeal's AssetList table will be wiped and update with the data from the API. Hope that helps you if you try to do it yourself.
Also for anyone else looking at Yapeal as a way to have a full archive of all of the Eve API data keep in mind that things like ServerStatus, AssetList, etc are thrown away and replaced in effect. I did this because I felt having it act a snapshot of the in game data was what most people would be interested in and what the APIs were made to allow. I am looking at adding an ability to directly cache the XML into the DB as received and may add an ability to have it archive that data but it would be done as a single large text column not as processed data with multiple columns. I'm also looking at having all the log files optionally/additionally put into the DB but have to be careful not to get into infinite loops doing that Note that by their nature the WalletJournals and WalletTransactions are an archive and the IndustryJobs and MarketOrders form a history of old records because they are updated with the API data until it stops sending each record. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.10 20:36:00 -
[86]
Originally by: Dragonaire Hi Satis Iqulenax glad you like Yapeal.
Quote: Once you updating an assetlist, will this script delete those info that have been used or sold or related to that ??
No it doesn't try to make any changes to the AssetList or any of the other API data really for that matter. I don't see that being part of the job it's trying to do. Yapeal tries to just take what it gets from the Eve API and put it into the DB in what I hope is a sensible way. To do that and be usable by multiple characters and corporations it does add a few extra columns like ownerID, accountKey, etc to the tables but I never take stuff away I leave that up to you as the application developers to decide what you want to do.
So what you are saying is: If you have an Strip Miner in your posession and Yapeal is catching it and addind that on to the database, then if you sell the strip miner so it's not in your possession anymore, Yapeal just ignor this and let that item stay in the database ??
If it does that, you will constantly adding items to the database and never clean up those items that an user don't have in hes/hers posession anymore and can still be showen on the webpage forever. This will allso overfloat the DB with data it does not need.
Look at it in my way. If I as a webdeveloper need to check those tables for expired items I would need to do somthing simular as you do. Catch the XML and check to see if this item is stille there. that will only make you need to get the XML file 2 times. one to add old new data as Yapeal and then one to delete the old data. since Yapeal don't do this at the same time.
One solution that I can think of is when the backend is doing it's work, then for each character or corp, it should delete all the data from that character or corp and then insert the new data. that should not take anylonger that the methode you are doing now.
Hope you understand what I'm saying. I'm just a littel confused by this data dump 
Kind Regards Satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.10 22:15:00 -
[87]
Quote: Also for anyone else looking at Yapeal as a way to have a full archive of all of the Eve API data keep in mind that things like ServerStatus, AssetList, etc are thrown away and replaced in effect. I did this because I felt having it act a snapshot of the in game data was what most people would be interested in and what the APIs were made to allow.
You need to read the full post. But the way I worded it could be misunderstood so I'll try to rephrase it to be more clear. For all the APIs under eve, and server, they will have all their records truncated and then replaced by the new data pulled from the API. In tables like AssetList all records on a per ownerID basis well be deleted and replaced with the new data from API. For tables like WalletJournal, WalletTransactions, etc because of their nature they will just be added to. In MarketOrders and IndustryJobs they will be update by the new data until it stops changing then they do the same as WalletJournal, etc and keep a record of the last update received. This let's you look up old records if you want something that you can't do in game. Here an example for a market order. You make a sell order for some ammo as people buy it from you the record is update with the amount left to sell in volRemaining. Now the API may return a record where orderState=2 meaning it has either expired or someone bought it all up before it ran out. You'll have to check if volRemaining=0 to tell if it was bought out. We will continue to receive it in more updates from the API for a while because of how the API cache works but since our order doesn't change anymore it's basically ignored at this point. just like updates to unchanging records for WalletJournal would be. The record for your order will stay around until you decide to delete it.
Hopeful this makes it more clear to you how Yapeal does things. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ramov Tinoga
Tinoga Enterprises
 |
Posted - 2009.01.11 00:00:00 -
[88]
Originally by: Ragga daPhunk the only thing that gets updated in the database is the "CachedUntil" table but nothing else.
When I run the script manually once a day, everything is updated quite fine.
When its run by cron every five minutes (*/5), I noticed that only the CachedUntil table is updated, but none of the other tables. My server is running at GMT+1, so the times in the table and the local time are at different time zones. Could this cause the problem? |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.11 00:22:00 -
[89]
Originally by: Dragonaire You need to read the full post. But the way I worded it could be misunderstood so I'll try to rephrase it to be more clear. For all the APIs under eve, and server, they will have all their records truncated and then replaced by the new data pulled from the API. In tables like AssetList all records on a per ownerID basis well be deleted and replaced with the new data from API. For tables like WalletJournal, WalletTransactions, etc because of their nature they will just be added to. In MarketOrders and IndustryJobs they will be update by the new data until it stops changing then they do the same as WalletJournal, etc and keep a record of the last update received. This let's you look up old records if you want something that you can't do in game. Here an example for a market order. You make a sell order for some ammo as people buy it from you the record is update with the amount left to sell in volRemaining. Now the API may return a record where orderState=2 meaning it has either expired or someone bought it all up before it ran out. You'll have to check if volRemaining=0 to tell if it was bought out. We will continue to receive it in more updates from the API for a while because of how the API cache works but since our order doesn't change anymore it's basically ignored at this point. just like updates to unchanging records for WalletJournal would be. The record for your order will stay around until you decide to delete it.
Hopeful this makes it more clear to you how Yapeal does things.
Yes it did. I allso did read the full post of yours and I did misunderstand it 
But now that this is cleared I feal happy since it's working as I was hoping it would 
New Question: From: http://games.chruker.dk/eve_online/test_eve_api.php there is an list of all the API data you can collect. Are you planing to implement all of them ??
Kind Regards Satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.11 01:07:00 -
[90]
Glad to hear I was clearer on my second try. 
At some point I would like to see Yapeal do all the APIs and I plan on making some changes to how the code works so it's easier then it is now to add more APIs. I'm hoping to get it easy enough that I'm not the only one that can seems to understand it well enough to add more 
BTW I like what Chruker has done on his site and sometimes use it but I find the tables at http://wiki.eve-id.net/APIv2_Page_Index more useful for what I do. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.11 01:31:00 -
[91]
Edited by: Satis Iqulenax on 12/01/2009 03:23:14 Edited by: Satis Iqulenax on 11/01/2009 18:24:06 Edited by: Satis Iqulenax on 11/01/2009 18:22:59 Edited by: Satis Iqulenax on 11/01/2009 18:21:42
Originally by: Dragonaire Glad to hear I was clearer on my second try. 
At some point I would like to see Yapeal do all the APIs and I plan on making some changes to how the code works so it's easier then it is now to add more APIs. I'm hoping to get it easy enough that I'm not the only one that can seems to understand it well enough to add more 
Thanks for the answer 
I might take a more direct look into your coding style and if I can get the system in your coding (They are more advanced than I'm used to) I might be giving a helping hand and help you write some of the API functions you have not worken on yet.
I think I found a place where you have been writing about what have been done so far but can't remember where that one is ...... need to search more 
Well it's time for me to say good night. it's 2.30 in the morning where I live, and realy need some sleep since I have been fitling with my DB the whole day, implementing the EVE DB Dump to pull out usefull information to my site ^^
Night Night and happy coding 
//Satis |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.12 03:24:00 -
[92]
I found a bug that I think is a critical one: The bug have been mentioned 1 or more times in this forum, but I have naroed it further down. If try updating the tables with eve-api-pull.php less than 24 houers it will not update all the tables. I can narow it down to say that if you have an Cronjob running each 1 min or by manualy updating it each minut it checks the `CachedUntil` if there is some XML that need to be updated. If there is one or more of them that do not need to be updated, it will still Update the `CachedUntil` on those but it changes the date to be updated about 2-5 min later. But if you runs a cronjob each 1 min it will never update since it allways setup the `CachedUntil` for 2-5 min later and when it's runned each time it will not update the tables anymore but only move the update time 2-5 min later. if there was a table that needed to be updated in22 hours it would just change it so it would be updated in 2-5 min again, but still it will not update it, since the `CachedUntil` is set to 2-5 min later.
i think the solution to this is a simple function that tells the eve-api-pull.php that it should not update `CachedUntil` tables that was not expired and don't need to be updated with a 2-5 min delay.
Hope this makes sence 
//Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.12 05:12:00 -
[93]
Seems I got code from a broken branch merged into trunk there. Sorry about that everyone I'll push out my other branch that I know doesn't have at least a critical error like that one but I was still in testing. Guess most of you are use to being my beta testers by now Just not the alpha testers I'm in the process of changing how I work on the varies stages of code development and seem to be having a few hiccups getting the process organized and working, I also broke my main coding machine and I just this weekend got something that should be workable going again.
Ok some quick notes about the new version I'll be pushing out everyone will need to backup your config/yapeal.ini file to another location. I would do a complete wipe and re-install as many of the files have changed names and some of them have change location. I also split and added several files for the error and exception code. You'll want to copy over the included yapeal.ini-example as I've been making several changes that aren't fully backwards compatible with the old one. The new one should be a bit easier to use as many of the comments have been updated also so shouldn't have any problems with it. I've made lots of changes to the error and exception code in this version that should make finding problems much easier in the future with more useful (at least to me) logging. Most people should be able to just copy over from your backup your database and user/password info into the [Database] section like before and activate the same [Database-xxx] sections as before and it should work.
Fix out as revision 437
And a big thanks out to Satis Iqulenax for catching this  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ragga daPhunk
Order Of Lyon
 |
Posted - 2009.01.12 14:03:00 -
[94]
greetings!
i have it another go - just updated to rev. 440. when i try running the script i get: Fatal error: Call to undefined function simplexml_load_string() in inc/common_api.inc on line 183
prior to this it just did nothing when executed except updating the CachedUntil table. (i'm truncating the table each time for testing) the tracing never says anything about pulling XMLs (maybe it doesn't have debug output?) and the cache folders remain empty. the logs only tell about database access - nothing else. so hard to tell what is being done and what not. am i required to have certain options in php.ini? atm url open and include is allowed (this is how i retrieved XMLs) i'm running 5.2.8-pl1 with compiled in curl support. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.12 15:40:00 -
[95]
Ragga daPhunk - That error message is saying the simplexml extension is missing which is normally on in a default install. Just to double check that that is the problem try this at a command prompt:
php -r 'if (!extension_loaded("simplexml")) print "Not loaded!\n";'
If you get a 'Not loaded!" message you need to find out why someone changed from the default of including SimpleXML with php5 it is possible that another package needs to be loaded with some distros on Linux.
Good news is it seems the new error code and settings is doing more and gave me a clue now to your problem I'm also adding a check for the simplexml ext which should make it more clear like it does with mysql and curl that they are required. |

Ragga daPhunk
Order Of Lyon
 |
Posted - 2009.01.12 16:35:00 -
[96]
aaah :) simplexml support..
i'm using quite a minimalistic distro, which i very like. but this time it didn't work out that well :) i'm just rebuilding php with simplexml support - i hope there isn't anything else? :D
** 6 mins later ** it works ! :D |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.12 19:55:00 -
[97]
Edited by: Satis Iqulenax on 12/01/2009 20:04:14
Originally by: Dragonaire And a big thanks out to Satis Iqulenax for catching this 
Glad to be of help 
Now since you have updated it, I have rebuilded the Yapeal from the revision 445 it works like a charm  Now that I look in my tables in phpmyadmin I can see that there have been added a new table caled "test" That one holds the same info as the RegisteredUser table.
May i ask what the reaon is for the test table and will it update so it holds the same info in the RegisteredUser if you update RegisteredUser with a new API Key or add a new User to RegisteredUser ??
EDIT: Oh I forgot to ask if you can make a rar file with all the files for each new revision ?? I can't use the bin file since I'm running Vista and I have to manualy download each file from the SVN.
//Satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.12 21:31:00 -
[98]
I just looked at the install/Yapeal.sql file and there's no 'test' table in it If you were looking at the Yapeal.mwb by chance it was put there in the past only so I could keep track of it and is now a bit outdated since I'm made some manual edits to the Yapeal.sql file since I used workbench. Since I have another place to move it to now I'll be dropping it from trunk just to head off any confusion it might be causing others.
As for downloading Yapeal file by file that's the painful way to do it you should install a SVN client program of some type that's really the way it's made to be used. The one I like the best on any Windows platform is available here http://tortoisesvn.tigris.org/ It adds commands to the right click menu in Windows explorer that makes getting a complete update from the subversion take only a couple clicks. It comes with some nice help files to get you started. I use it everyday on my Windows XP machine while developing Yapeal. I'm current looking for something as easy to use in Linux because so far nothing works as well or as easy that I've tried. I usual can do it faster and easier from command prompt so if anyone has some thing that works as good for a GUI let me know.
The bin file is from some software I'm testing and plan on using in the future when the develop cycle slows down a little and I've learn how to use it When I decide to do that the software will make a Windows exe installer as well as some other versions. There's some things I need to work out also with Yapeal before I can start using the new software but one of the first things I'd really need to have is some kind of install/configure script which someone has offered to help work on as well as update/create some actual documentation for Yapeal which is badly needs if you haven't noticed 
While I'm at it I'd like to thank all of you for the feed back both good and bad and the bug reports as I'm limited on what I can test with my characters and the time I have to use for testing and sometimes coding. Since the start of November when I move project over to Google I've been averaging better then 100 commits to subversion per month Needless to say a few bugs slip past me from time to time  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Buzz AU
 |
Posted - 2009.01.13 22:33:00 -
[99]
Hi Dragonaire,
I have tried downloading this, but have been unsuccessful. I cant find a way of extracting the .bin file, and using Tourtise to connect to SVN asks me to authenticate.
How dows someone use this? |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.13 22:39:00 -
[100]
Dragonaire I have an question to the AssetList table.
I notised that there it a rowname caled: "lft" and "rgt"
When I looked in the XML AssetList they was not mentioned in there. Has that somthing to do with the Child of a container or the fitting on a ship ??
If so... can you give a little explanation on how those numbers are working together.
Kind Regards Satis
|
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.13 22:58:00 -
[101]
Originally by: Buzz AU Hi Dragonaire,
I have tried downloading this, but have been unsuccessful. I cant find a way of extracting the .bin file, and using Tourtise to connect to SVN asks me to authenticate.
How dows someone use this?
First of, the http://yapeal.googlecode.com/svn/trunk is Read Only, so I think you have used a wrong command to get the content. I think you might try to upload to the SVN and not downloading it.
I made a step by step tutorial for you to try out :)
Tutorial for TourtiseSVN
- Create a folder where Yapeal should be placed.
- Right click on the folder and chose: SVN Checkout
- In the Url you input: http://yapeal.googlecode.com/svn/trunk
- Now press the OK button and it should get the latest version of Yapeal.
- Now each time you wan't to update to the latest version just right click the folder and chose: SVN Update and it will automatic update to the latest one.
Hope this helps :)
Kind Regards Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.13 23:33:00 -
[102]
Think the problem he had was he tried to use the project member instructions which Google decided to list first instead of reading down to the non-member ones. Project members need to have read/write on the subversion but for just downloading Yapeal and getting updates to it the second instructions give you that. Or just follow the instructions Satis was nice enough to post above if you're using TortoiseSVN 
Thanks Satis Iqulenax for the nice simple instructions you posted.
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Mintoko
Gallente Nova Remnants
 |
Posted - 2009.01.14 02:33:00 -
[103]
I was going to do some whining that the api wasn't being pulled when setup as a cron job, but decided to try changing the permissions on the file before posting.
eve-api-pull.php had permissions set at 644, but would not work under cron until it was changed to 755. Of course, it may work with 744, but has not been checked.
The only other problem I had noticed the last couple days is that the server status was not updating, but is now working for some unknown reason. If the file permissions were responsible for this, I would think other api items would be affected, but none were noticed. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.14 06:49:00 -
[104]
If you grab the files with a subversion client on Linux it should set the permissions right but if you grab the ALPHA test download I had up it probably didn't I noticed a lot of people were grabbing it so for now I've turned off the download section again. I had it there just for my own testing but like anything found on the Internet that makes it fair game once people see it Anyone that is trying to use the download version should grab the newest version from the subversion because the one in the file had some major bugs as it turned out.
I'm current working on finishing some things that I didn't have ready yet when I had to push out the latest version to fix the very broken one I'd got out there before. Mostly some added stuff for troubleshooting and changes to error handling code. Once I'm done with that hope to start on some change to make adding new APIs easier and probably at same time be adding in some changes to add the table name prefixing that people have asked for.
Been think about asking people to start using the Issues tab on the project home to start making feature requests so people can 'star'/vote for the ones they'd like to see done first. Would be ok to report bugs there too but I think most of us prefer the forums here so not planning on pushing for that any time soon. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.14 17:07:00 -
[105]
Dragonaire did you read this ??
Originally by: Satis Iqulenax Dragonaire I have an question to the AssetList table.
I notised that there it a rowname caled: "lft" and "rgt"
When I looked in the XML AssetList they was not mentioned in there. Has that somthing to do with the Child of a container or the fitting on a ship ??
If so... can you give a little explanation on how those numbers are working together.
Kind Regards Satis
Waiting for an answer 
Kind Regards Satis
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.01.14 17:37:00 -
[106]
Originally by: Satis Iqulenax Dragonaire did you read this ??
Originally by: Satis Iqulenax Dragonaire I have an question to the AssetList table.
I notised that there it a rowname caled: "lft" and "rgt"
When I looked in the XML AssetList they was not mentioned in there. Has that somthing to do with the Child of a container or the fitting on a ship ??
If so... can you give a little explanation on how those numbers are working together.
Kind Regards Satis
Waiting for an answer 
Kind Regards Satis
Its to persevere the tree format using the "nested set" module. MYSQL Tree Treversal |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.14 18:02:00 -
[107]
Sorry I did miss you asking that. Here a pages with some links I found interesting when deciding how to implement it. Johnathan Roark there actually developed the test code I adapted to Yapeal to replaced what I had been using before which was extremely slow. The library I was using before took up to 20 minutes to add 2000 records where now it's done in a few seconds  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.14 19:12:00 -
[108]
Edited by: Satis Iqulenax on 14/01/2009 19:15:05
Originally by: Dragonaire Edited by: Dragonaire on 14/01/2009 18:11:23 Sorry I did miss you asking that. Here a pages with some links I found interesting when deciding how to implement it. Johnathan Roark there actually developed the test code I adapted to Yapeal to replaced what I had been using before which was extremely slow. The library I was using before took up to 20 minutes to add 2000 records where now it's done in a few seconds 
Also might want to look back around post 30 on this thread where someone else was asking about them and I made a few comments to help get them started.
Cool. I'll look into this :) BTW: I was lacy not have searched in this post for this 
anyway, if there is somthing I can help you with, please tell :)
EDIT:
Originally by: Johnathan Roark Its to persevere the tree format using the "nested set" module. MYSQL Tree Treversal
Thanks to you too allmost missed your post 
//Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 07:36:00 -
[109]
Okay I've pushed out a new version with all the changes to the error and exception code I had planned for now. Last bit to add was a tool to help me help people having problems getting it to run. Instead of having to make a bunch of changes in to the config/yapeal.ini you can just added "-d" to eve-api-pull.php when you run it and it puts all the logs etc into one neat (or not so neat) log file. It will also include your setting from the yapeal.ini (username/password blanked) and a full trace log (if it makes it that far) in there too Here's a simple example of how to run it assuming your in the base directory where you installed Yapeal:
backend/eve-api-pull.php -d'../cache/log/debug.log'
After it finishes or dies with an error you should find a file named debug.log in the cache/log/ directory. It will be a large mostly boring text file that you can look through if you want If after going through all the troubleshooting from the wiki you still can't figure out what the problem is you can sent the log to me and I'll take a look but do try to figure it out yourself first. WARNING don't try using this from crontab etc it's made to be used only with a manual run for debugging and troubleshooting.
In other changes you might notice are some small changes to yapeal.ini mostly that I've now added version info to it. In the future they will become important but for now if you have a running system you can ignore them and don't have to upgrade it again or can simply cut and paste them in to yours if you want.
At revision 454.
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Ragga daPhunk
Order Of Lyon
 |
Posted - 2009.01.15 11:54:00 -
[110]
greetings!
i started to work with yapeal a bit and thought of some things that would be nice to add/change.
- some sort of verification for api keys. when there is an authentication problem the script stops. it would be great if the script just sets the "isActive" var to "0" for the char with the auth problem. this way it wouldn't prevent yapeal from working when someone enters wrong data or the account is inactive (unpaid subscription or something).
- xml data : - Character List (on account) - Kill Log (Killmails) - Standings
these changes/additions would be really great :)
|
|

Buzz AU
 |
Posted - 2009.01.15 12:48:00 -
[111]
Edited by: Buzz AU on 15/01/2009 12:48:40 Looks like I closed chrome before I posted my last message:
Thanks for the instructions on Tortoise, it worked well!!
Are there new instructions on how to get this up and running?
The ones on the main google code site, dont really answer much.
Where do I enter the details for my database? Where do I enter my API information? I checked the yapeal.ini but dont see anything related to the above the the SQL db, and also cant find where I activate which API info I want to pull.
If there is a post on this, please can you point me to it.
Thanks
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.15 16:26:00 -
[112]
Originally by: Buzz AU Edited by: Buzz AU on 15/01/2009 12:48:40 Looks like I closed chrome before I posted my last message:
Thanks for the instructions on Tortoise, it worked well!!
Are there new instructions on how to get this up and running?
The ones on the main google code site, dont really answer much.
Where do I enter the details for my database? Where do I enter my API information? I checked the yapeal.ini but dont see anything related to the above the the SQL db, and also cant find where I activate which API info I want to pull.
If there is a post on this, please can you point me to it.
Thanks
Well in the: Getting Started on googlecode there is a description on how and where to indput the API Key's. But you need to make a script to get the character ID from inside eve to pulle out the character ID. you need the character ID and a corp ID if you wan't to setup corp pull allso.
In the : Key Files on googlecode there is a list of the files that would interest you in the setup.
I have planed to make a Install.php file that Dragoniere can deside if he would use in hes build for a easy setup for the Yapeal. it will be a file that need to be runned inside eve onlige IGB (Ingame Browser) since it easyer to get the character ID, Corp ID and more that way.
That install file will allso create the yapeal.ini that is needed for the database.
I could make a long post on how to setup yapeal to rune on your site but rather not since I am planing on making this install.php file for all to use.
Kind regards Satis.
PS. in the wait time, try to read the wiki one more time and see if you can figure out how to setup Yapeal :)
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 17:39:00 -
[113]
Ragga daPhunk - First thanks for giving Yapeal a try.
Quote: some sort of verification for api keys.
Yapeal is a library not an application you need to verify the API keys before you put them into the database for it to use. What I may do is add a helper script you can use to verify and also sometime in the future plan to finish off the management classes I had start developing for the RegisteredUser etc that you'll find laying around in the class/ directory.
Quote: when there is an authentication problem the script stops.
It shouldn't stop working it should just skip over any APIs that it can't get because of authentication problems like it skip over them with any other API error. For example if you have 3 characters active in Yapeal and the 2nd one has a bad apikey it should still get the data for both 1 and 3. If it isn't doing that then that is a bug and it needs fix.
I've now starting on a change to Yapeal that will change how I handle the API data which when it is done should make adding new APIs easier. Also after looking closer at the new trace logs I'm going to make some changes to how it makes and drops connections with the database server. As it is now even when it's just idling waiting for an API to need servicing it makes and drops 3 or more connections per API per character, corporation, etc. which could be much less if the code was smarter about how it does things. There's some other areas that need similar attention I believe but they are less of an issue for now. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 18:19:00 -
[114]
First I'd like to thank Satis Iqulenax for offering to help with some of the document fixes and additions she's working on. I'd also like to thank her for taking on making some kind of installer to make it easier for people to try out Yapeal.
I'm also planning on move the backend/eve-api-pull.php into the base directory and renaming it to yapeal.php or something similar that should make more sense to people. I'll make a wrapper at the old location so it shouldn't break anyone's stuff they already have setup but plan on change over to using the new location fairly quickly after I do this. That part of Yapeal directory structure is left over from when I split it away from another project I worked on for my corporation at the time and want it to easily be integrated back into it but I have now changed Yapeal to much to be usable with the original project and I've stopped develop on the other project for now. I may make some other changes but they shouldn't make any difference to how you use Yapeal like this change will so just a little heads up on that. I'll be sure to let everyone know when I make the change which should be Soon(tm)  |

blkmajik
ZiTek Deepspace Explorations
 |
Posted - 2009.01.15 19:06:00 -
[115]
Great job guys! I've been testing with this recently and it really does the trick. As for developing applications around the database... I'm not that far yet ;)
One shortcoming I've noticed is the lack of support for the Factional Warfare API calls. Is this in the pipeline for the near future? If so, is there an estimated ETA? If it's not, I'll need some more time to get comfortable with the project coding style, but I could contribute some if that would be welcomed. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 19:33:00 -
[116]
Plan is to support all the APIs when done at some point but have no time frames on when. I plan on re-doing all the currently supported APIs and make sure they still work before adding any new ones myself. If you interested in adding APIs and seeing how it's done now the easiest one to start with would be the ServerStatus one in inc/pulls_server.inc followed by the inc/pulls_eve.inc then work up to the character and corporation ones.
For those programmers interested in how I'm planning to change Yapeal might want to take a look at the IFecthApiTable.php, ILoadApiTable.php, and IStoreApiTable.php files in class/ directory. Still probably will make some changes to them but you should get some idea where I'm going. Just to throw around a few programming buzz words think Singleton, Factory Patterns, and maybe even a Reflection based plug-in system and an autoloader for classes. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.15 19:37:00 -
[117]
Originally by: Dragonaire First I'd like to thank Satis Iqulenax for offering to help with some of the document fixes and additions she's working on. I'd also like to thank her for taking on making some kind of installer to make it easier for people to try out Yapeal.
OH Thanks again 
Dragonaire I have some small matters I like to disguss with you. Is there another way to contact you beside this forum or Ingame ??
Kind regards Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 20:42:00 -
[118]
Best way would be through my E-mail either from the project files or the one at Google. I'm also usually on Gchat. I use an alt's name for them just look at the Yapeal project owner to figure it out. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.15 21:47:00 -
[119]
Originally by: Dragonaire Edited by: Dragonaire on 15/01/2009 20:48:03 Best way would be through my E-mail either from the project files or the one at Google. I'm also usually on Gchat. I use an alt's name for them just look at the Yapeal project owner to figure it out. Using eve-mail is a slow way to get hold of me. I'm usually only on to skip skills for my characters once in a while instead of playing Eve I spend most of my free time working on Yapeal 
Hehe okay :) is Gchat somthing you pay for, because I can only find one on the net that cost alot. did find an webbased Gchats but I'm not sure if that's the right one, since when I logged in, the place was empty.
well never mind that.
I might just send you an email. 
//satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.15 22:40:00 -
[120]
Looks good so far.
All you need to use Gchat is the free Gmail account. I use Pidgin to view it because I keep my web browser busy doing other things like posting on the forums and have chats from other places I need to use so something that understand several IM services was the way to go for me but the browser based one works as well and doesn't require any setup. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
|

Iskandara Cho
 |
Posted - 2009.01.16 22:11:00 -
[121]
Edited by: Iskandara Cho on 16/01/2009 22:11:06 Well, I guess I'll just toss my work thus far. Ah well. Still, its nice to know we'll have an installer soon.
Also check Google Talk not gchat, they are different things. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.16 23:39:00 -
[122]
I'll take the blame on this one when you both said something about installer I wasn't paying as much attention as I should have been and realize it was two different people not just two different characters and the some person Since one seems to be aiming at IGB and other normal browsers it's not really bad to have two people working at it. I'll let you guys decide if you want to combine your work or keep do parallel development and then I'll cherry pick from both after you have both finished. Let me know what you guys decided or maybe we can all get together somehow and talk it over.
A little point of interest on the number of connections Yapeal was making to the database server and how the new code I'm working on effects it. In testing I've getting an ~8 to 1 decrease in the number of new connections with more then one corporation using it that number should go higher because of more reuse of connections with balances, journals, and transactions etc. This should make anyone on a shared hosting happier since lots of DB connections can really lag you out if the DB server is overloaded. After a couple more tweaks (I seemed to be low on my quota of bugs today need to make a few more for myself ) and some more testing I should get this out later day. |

Iskandara Cho
 |
Posted - 2009.01.17 00:21:00 -
[123]
Since IGB pages work out of game as well, there is no reaon to duplicate the work. I'll just take the hit and look forward to the install script being done.
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.17 01:33:00 -
[124]
Oh I didn't know that some one was making an installer as well
Well can say that the one I'm doing right now is in first priority based on the IGB and you can not load it offgame since there is checkers that cheks if you are insite eve and if not, tells them that the installer can only be reached from the ingame.
However, I have planed to implement the outgame suport as well but I just want the IGB to work first.
Why I'm doing the IGB first is that it's the fastest and easyest way to get the character ID and name as well as the Corp ID and name. With a trustet site request you can get those variables without having to fitling around the api and cache the character and charactersheet XML to pull those information out.
Anyway, the progress with the installer is allmost done since alle the check for compability on the webhost have been done as well as folders and file write premission. the only part is missing is the fun part where I create the database and the yapeal.ini file. A beta will be done within 24 hours I think.
Just keep in mind that the outgame browser is planed, but first when the IGB part is done since the outgame browser takes a little more time to implement. I'm a little rusty on the API part so I need to refresh that, for the outgame support 
Dragonaire I have removed the Debugging function as you mentioned in the email. I has as well removed the Database-server part since it will be implementet as a standard activ=TRUE as well with the Util DB.
1 question thou. all the comments that are in the yapeal.ini-example would you like to have those implemented as well or is it okay with an raw ini file without the descriptions ?
Kind regards Satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.17 02:28:00 -
[125]
Really sorry for the mix up on this 
Satis Iqulenax think you could drop the commits and just have one at the top referring them to the example file and maybe the wiki pages instead that should cover it but if anyone else has an idea about this speak up. Make sure to include the new fields for version etc that I added I'll need that for some updating stuff I'm thinking about as well as when people ask for help and send me their logs.
Ok Iskandara Cho guess this will leave you more time to work on the docs we also talked about instead which is something that needs done just as badly as the installer did 
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.17 08:36:00 -
[126]
OK new version is out with the improved DB connection code. I'm see 9:1 decreases in number of new connections vs the old code I knew it would be an improvement but didn't expect that much really. I might be able to tweak it a bit more but not to worried about it now for some reason I'll move on to the other things I've had planned to make adding new APIs easier I think for now.
current version 464 Get it while it's hot! |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.18 14:58:00 -
[127]
A little update on the Yapeal Installer.
I might just skip the IGB installer and just have the normal browser installer, since I found a smart way to get the characterlist in JavaScript so gettimg the info on a character just depends on what PAI setup you make.
I'll make this so if you try to open this site in the IGB it will just give you a link that will pop out of EVE and open the Yapeal Installer in a normal browser. Thai way I don't have to make my script 2 times, one with javascript support and one without since IGB does not support JavaScript.
Status:
- the grafical UI is done
- The requirement test is done
- The basic cofiguration input site is done. There will be more advanced setups like chosing different databases to each setup groups
- Working on database creation right now.
I think that's that for now.
//Satis |

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.18 19:30:00 -
[128]
Satis Iqulenax - Sound good looking forward to having a go with it when you have it finished.
On other news some of you may have noticed I've had lots of problems getting out working versions of Yapeal lately. Part of is some software I was try working in unexpected ways when merging branches back into the trunk but mostly it was because of how I was working and testing the code. The way I was doing it tended to mix things like the config file from one branch or the trunk with the code from the other etc. Needless to say that just doesn't work well. So after someone got on me the other day about it I started making some changes to how I've setup my testing that should help prevent that from happening.
Another problem I have is because I only have 3 of my characters and one small alt corp to test with I just can't test the code like it needs to be. To try to solve the lack of ability on my part to test stuff I'd like to ask for some of you to help out as alpha/beta testers for me so the code can be more fully tested before I bring it back into the trunk. One thing I need from anyone that wants to help out as a tester is you most have an hour or two every one or two days when you can try stuff and either report back what happened or you can be on Google's IM with me when you are testing so I can ask questions and have you try stuff. I'll try to put up some more info on the wiki or somewhere about it but for now if you're interested in giving me a hand with this sent me an E-mail to either the e-mail in the code or my alt's E-mail dragonrun1 over at Gmail |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.24 20:07:00 -
[129]
Okay people.
After working together Dragonaire I have made an Basic Yapeal Installer.
It out now together with an version of yapeal that should be stabel.
the installer is working with both JavaScript enabled and disabled but the one with most install steps will be the one with no JS active.
This will make it easyer for people to setup Yapeal and will be able to run it without having problem with manual setup.
In the future there will be a more advanced installer that will be able to handle setup of multi databases as well as setup table prefixes so you don't mis tables together. There will allso be the option to input a password from the installer after Yapeal have been setup so you can edit your setup without having to remove the yapeal.ini config file.
To download yapeal in the most easy way is to grab it from the SVN.
For you who don't know how to do that, here is a little tutorial on doing so in windows.
- Download Tortoisesvn
- Install Tortoisesvn
- Create a folder where Yapeal should be placed.
- Right click on the folder and chose: SVN Checkout
- In the Url you input: http://yapeal.googlecode.com/svn/trunk
- Now press the OK button and it should get the latest version of Yapeal.
- Now each time you want to update to the latest version just right click the folder and chose: SVN Update and it will automatic update to the latest one.
I think that's all.
Kind Regards Satis Iqulenax Yapeal Member
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.24 21:34:00 -
[130]
Thanks Satis Iqulenax for all the hard work on the installer know it took a while longer to finish it then we expected but it works well. Everybody that's been having any problems understanding how to setup Yapeal should be very thankful now to you for this 
Now on to other news while not helping Satis Iqulenax with the installer now and then I've been working on a branch where I've making some changes that should make everyone happy when I'm done. I've been working on the code so that adding new API will be much easier to give you an example of how much easier within a couple hours of get the first API convert I decided to add a few new ones just to test it and I ended up with several from the map working and also convert the ones I had before in eve over and working. So in the time it would normally take to do one I did 7 and have another mostly done while adding another section (area) for maps that Yapeal didn't do before. This is something I'd been want to get to for over two months now but other things have had priority.
I'm also starting to add and test the table prefixing code as part of the change over in code while I'm at it which brings up another change I have been thinking of making. I thought I'd get some input from the people using Yapeal before making this change since it might cause some problems. The change is to no longer support having each API section in a different DB. To better understand what I'm talking about go over to the main Eve-Dev API page. The sections I talk about are like where you see Account, Character, Corporation, etc. As it is now in Yapeal each one of those can be in different databases with different user/password and other settings. This does let there be some nice flexibly but also makes for a more complex configuration to maintain and use. By dropping this ability to use multiple database it would greatly simplify the yapeal.ini and along with some other changes I'm looking at could get it down to maybe less then six settings while adding a bunch of per character and per corporation settings for which API you actual want. So for example now if you enable a character in RegisteredCharacter and Yapeal had stuff to get the SkillInTraining API it would interfere with your EveMon With some changes including dropping the multiple table stuff that is I believe not used by anyone it'll greatly simplify add per character/corporation settings on APIs so the APIs for things like SkillInTraining, Killlog can be added to Yapeal but turned off so they don't interfere with EveMon and Killboards you might want to use.
Okay I'll stop there for now before this gets any longer and see what everyone thinks of making the changes. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Sondrou Xi'Tral
Gallente CBE Handwerks Stargate Experiment 626
 |
Posted - 2009.01.25 07:58:00 -
[131]
Ok, I just used the installer (very nice btw), and everything seemed to install fine. However when I point my browser to backend/eve-api-pull.php I get the following message:
Notice: Yapeal version 464 (beta) 2009-01-17 03:16:35 in /home/u5/methos237/626/html/api/inc/common_backend.inc on line 55 Fatal error: Call to undefined function spl_object_hash() in /home/u5/methos237/626/html/api/class/YapealApiException.class.php on line 75
|

Buzz AU
 |
Posted - 2009.01.25 11:44:00 -
[132]
Notes regarding the Installer:
Quote: Welcome to Yapeal Installer. This installer will setup Yapeal EVE API Library to be runned on your site. The setup will check if your web host has the requirements to support this library.
It should be "run on your site", not "runned on your site"
On the "success page"
Quote: The setup is done. You can now run the backend/eve-api-pull.php to cache all the data
Maybe make the "backend/eve-api-pull.php" a link?
Just comments. It is fantastic and a LOT easier. Great job
|

Buzz AU
 |
Posted - 2009.01.25 11:50:00 -
[133]
I get the below when trying to pull the data, I have set the permissions on the file and folder to "777", but still get the same.
Quote: Forbidden
You don't have permission to access /Yapeal/backend/eve-api-pull.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/2.2.10 (Unix) mod_ssl/2.2.10 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.mysite.com Port 80
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.25 14:41:00 -
[134]
First off the reason there is a .htaccess in backend/ is YAPEAL IS NOT A WEB APPLICATION It is a library you use to make a web application with but YOU ONLY RUN YAPEAL FROM A COMMAND CONSOLE, OR CLI as it is know in PHP. The ONLY part of Yapeal that is made to be used as a web page is the installer. Everything else in it is made to be used from the CLI. |

Buzz AU
 |
Posted - 2009.01.25 18:25:00 -
[135]
Is that to say, we shouldn't run it using a normal cron job? |

Johnathan Roark
Caldari Borgholio's Collective Prime Orbital Systems
 |
Posted - 2009.01.25 18:29:00 -
[136]
Originally by: Buzz AU Is that to say, we shouldn't run it using a normal cron job?
That would be running it from a CLI, so yes |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.25 19:34:00 -
[137]
Originally by: Buzz AU Is that to say, we shouldn't run it using a normal cron job?
Yes you can run it as a cronjob and it is ment to be runned as a cronjob or on windows server a schedul task.
What Dragonair men't is that you should not run eve-api-pull.php from a webbrowser. That's why there was put an .htaccess file in that directory :)
//Satis
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.25 22:35:00 -
[138]
Okay I guess I'm making to many assumptions here that people understand some things that apparently they don't so I try to clear some of them up for everyone.
- CLI or Command Line Interface is a generic term that the designers of PHP use to describe any console type interface i.e. NOT windowed or web. On most Unix systems this is normal sh, on Linux it's Bash or one of several others if the user changes it. With Windows systems you have cmd.exe which you can usually access through the classic start menu by Start > Run and typing in cmd and clicking OK.
If you use anything like SSH to get to your hosted web server you are also run a CLI, usually Bash, with the input and output in effect redirected to your local machine over an encrypted connection.
- Cron or also know as crontabs is a system available on most Unix/Linux to run CLI programs/scripts for a user at different starting times and intervals. Generally only the interval part is used where it can be anywhere from 1 minute to hours, days or clear out to years in the future.
- Schtasks provides the same basic functionality as crontab does for Unix/Linux systems.
- Yapeal short for Yet Another Php Eve Api Library is a CLI PHP5 script that gets information from the Eve XML API and puts it into a MySQL database. A web based installer has also been made for it to help people get started with it but the main script is only made to be run from a CLI or as a crontab job.
Hope this is useful to people and helps make some things clearer.
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.25 22:41:00 -
[139]
Edited by: Satis Iqulenax on 25/01/2009 22:41:40 Okay I have just made 3 guids in the Yapeal Wiki.
- Setup a webserver on windows using Wampserver
- Install Yapeal on your windows webserver
- Guide to setup task scheduler for Yapeal in windows (Like cronjob)
Hope they will be of some use for those who want to testout Yapeal on there own Windows PC
//Satis |

Buzz AU
 |
Posted - 2009.01.25 22:47:00 -
[140]
In that case, change the final step in the installer, to not say "now you can go to /backend/.." |
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.25 22:51:00 -
[141]
Yeah the installer is in a raw Alpha/Beta state but we thought it was useful enough it was worth getting it out for people to use as we polish it and do a newer version with some more features. |

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.01.26 18:51:00 -
[142]
Originally by: Buzz AU In that case, change the final step in the installer, to not say "now you can go to /backend/.."
Both the welcome page and the end page should now be updated and can be updated from the trunk now :)
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.01.28 23:22:00 -
[143]
Just ran across a web page that anyone try out Yapeal on Windows and having problems with PHP might want to take a look at. http://www.corephp.co.uk/archives/36-A-Guide-to-using-PHP-5-Extensions-on-Windows.html |

Cryten Jones
Gallente Eldritch Storm The Matari Consortium
 |
Posted - 2009.02.05 17:18:00 -
[144]
Hi,
Nice work here! Just learning how all the dump tables work and this API is making my life easier * 1000 to get my head around it all!
Could anyone tell me what the lft and rgt column in the assets table are? I can't see them anywhere on the api documentation!
Also, how does yapeal deal with the Item X is inside Item Y? The xml provides a 'contents' value but as far as I can see yapeal just sets assets locationID to the same as their containers..is this right?
Thanks
-CJ
Originally by: Nogap toosmall
and your understanding of probability is on par with a radish.
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.02.06 02:00:00 -
[145]
Originally by: Cryten Jones Could anyone tell me what the lft and rgt column in the assets table are? I can't see them anywhere on the api documentation!
Also, how does yapeal deal with the Item X is inside Item Y? The xml provides a 'contents' value but as far as I can see yapeal just sets assets locationID to the same as their containers..is this right?
Thanks
-CJ
Hi CJ.
the 2 question you made is actually related to each other. the lft and rgt is hierarchical data and is a more advanced method to get what's inside a container or what a ship is fitted with or what is in a station.
to find out more about this, read in the Yapeal wiki in this section: hierarchical data Read and use the links in there and your question will be answered :)
Kind Regards Satis Iqulenaz Member of Yapeal Project: Installer/Setup |

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.06 05:46:00 -
[146]
Something that might give you and others a better understand of some of the power that nested sets gives you here some examples. Finding all your assets in the -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Satis Iqulenax
Amarr Hybris Pride
 |
Posted - 2009.02.06 14:12:00 -
[147]
Originally by: Dragonaire Something that might give everybody a better understand of some of the power that nested sets gives you here's some examples.
I just took the opportunity to take your small guide Dragonaire and paste it in the wiki on Yapeal Wiki.
The link is here: Small and simple nested sets guide
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.10 20:51:00 -
[148]
Hi all it's been a couple weeks since I've really posted about any changes or updates on Yapeal so I thought I'd let people know what's been going on. I've been in the process of doing a much needed re-factoring on all the code that will make it much easier to maintain and add to. Many of the ideas for the changes I've been kicking around for a couple months but was put on hold until I had more of the bugs fixed and what I considered the base set of APIs working. The old code though it worked had several problems with it that made it difficult to add new APIs especially by anyone other than me and sometimes when adding new APIs it would break others. It also had some limitations that made adding some requested features difficult or near imposable without changing a lot of code. I've also been learning a lot about how many site hosting locations setup stuff for their customers and where things I had done with Yapeal made it hard for many people to setup and use it. Given all the above I decided to 'crawl into a hole' so to speak and do a near complete re-write of much of the code.
Okay on to what this will mean for anyone using Yapeal which is all that most of you are interested in anyway Here's a broad outline of some of the changes/additions to expect.
- Table name prefixes. Many people are only allowed a single database at their hosting site so they need to have their applications and Yapeal tables all play nice together. I was also running into some issues with APIs using duplicate names on some rowsets which adding table name prefixes would also help solve.
- Ability to use multiple database to store all of Yapeal's varies tables has been dropped. This allowed for many of the other changes to be done much easier and was believed to be a largely unused feature. With the addition of user settable table prefix name the need for this is believed to be largely mote now so it was removed.
- There will be some changes to the database tables. All the table names have been changed to add a two part prefix the first part is user configurable and second part set internally by Yapeal.
- Some new tables have been add for additional APIs or old APIs that have been expanded on to make them more complete.
- Each API is now implemented as it's own class which solves many of the problems of changes to one API effecting others. This has also made adding more APIs easier and should make it easy for other programmers to understand how to add an API. That should mean not always having to wait on me to get around to adding new ones. This doesn't mean I won't be continuing to add APIs just that maybe I won't have to do all of them myself.
At least that is my hope anyway.
- Some bugs and mis-features fixed. Probably added a few new ones but I've been do much more testing on this code then some of the code I've released in the past.
- The yapeal.ini has had a major overhaul and been streamlined. Dropping multiple database table support was one of the main things helping with this but there were many other factors that made this possible.
Ok that should get you an idea what's coming. I hope to be finished with the conversions/updates and have finished all the testing I can do this week and be able to release everything into trunk for people to try out. I'll try to have a more detailed change list available when I release the code and probably have some instructions on what you'll need to do if you're upgrade from the current version of Yapeal. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.19 00:36:00 -
[149]
Hi all so it took a little more than a week but someone else decided to have an extend downtime on me but I've now merged all the changes into trunk for people to try. All current users be sure to read the updating.txt file in the root directory it has some important instructions on migrating your data from the old database tables into the new ones as well as some other information you'll need.
Please report any bugs you find. I've tested this revision more that many in the past but some bugs may have got through since I have limited resources to test some things with the characters available to me.
The currently supported API list on the wiki has also been updated for anyone interested.
revision: 572 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Ramov Tinoga
Tinoga Enterprises
 |
Posted - 2009.02.23 11:48:00 -
[150]
Dragionaire, thank you very much for the new framework! 
To give you a heads up: I'm working on the implementation for the Standings API (character and corp).
I haven't seen an API that has a structure similar to the Char Standings API (two groups with several rowsets). From my first analysis and following the approach used in CorporationSheet, it would need 5 new tables for char and corp each.
- [char|corp]StandingsToCharacters
- [char|corp]StandingsToCorporations
- [char|corp]StandingsToAlliances
- [char|corp]StandingsFromAgent
- [char|corp]StandingsFromNPCCorporations
- [char|corp]StandingsFromFactions
But I think I'll merge them together so that a total of 4 tables (charStandingsTo, charStandingsFrom, corpStandingsTo, corpStandingsTo) with 5 fields (one of them an enum field for the rowset name) will do.
What do you think?
-----
|
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.23 20:08:00 -
[151]
My general principal is to make each rowset a new table or anything that acts like a rowset ie attributeEnhancers and attributes in CharacterSheet became their own tables even though they aren't exactly a perfect match. I've also been naming the tables by the name attribute given to the rowset but here that's a problem as you have StandingsTo and StandingsFrom with rowsets having the same names (corp, alliance, etc) :P
Quote: (one of them an enum field for the rowset name)
I don't think a enum is way to go as I've generally tried to keep the tables free of any MySQL only data types so if someone wanted to port them to another DB backend that ADOdb supports it would be easier. It's better to use a plain text field and have a list of values that is enforced in the PHP instead. I did that with MarketOrders for the buy/sell field as an example. Where I have used MySQL specific SQL I've also tried to isolate it into a function so it only has to be changed one place to make porting easier should someone want to do so.
Ok after looking at the both APIs some more the way I'd do the character one is to have the 5 tables named charStandingsToCharacters, charStandingsToCorporations, ..., charStandingsFromFactions. This does end up with 5 tables but it stay more in line with how the other tables have been done I think. The corporation ones look somewhat more complex at first but you can basically use the same system with them. corpCorporationStandingsToCharacters, ..., corpCorporationStandingsFromAgent, ...,corpAllianceStandingsToCorporations, ...
Doing it this way does result in a large number of small tables with long table names but will make getting data back out in applications easier I believe.
You've managed I believe to have picked one of the harder APIs to tackle first :)
Having said all that if you feel like trying it the other way with the change from enum to a char column and post it so we can take a look at what you're thinking. Maybe we'll get some input from others and see what they think would be easier and make more sense when trying to use it. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Ramov Tinoga
Tinoga Enterprises
 |
Posted - 2009.02.24 08:31:00 -
[152]
Originally by: Dragonaire Ok after looking at the both APIs some more the way I'd do the character one is to have the 5 tables named charStandingsToCharacters, charStandingsToCorporations, ..., [..]
Doing it this way does result in a large number of small tables with long table names but will make getting data back out in applications easier I believe.
When you're ok with 12 more tables, then I'm ok too. It's much easier to maintain in the code when there's just a multiupsert for each rowset without having to tackle the different cases. I had second thoughts because each half of the 12 tables has identical structure (fromID, fromName, standings / toID, toName, standings).
Quote: You've managed I believe to have picked one of the harder APIs to tackle first :)
Now that you mention it.. It's the one I'm missing most at the moment, so I started with that, "charStandingsFromNPCCorporations" to be particular. 
-----
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.24 17:25:00 -
[153]
If you're interested and have a Gmail account (it's free) I can add you on to the project if you'd like. Just contact me via either the E-mail from the code or my Gmail one which you can figure out from the project. If you decided you want to do that please include you Eve character name some where in the title so don't I delete it with the spam 
Anyone else that's interested in developing one of the other APIs is also welcome to email about joining the project. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.26 18:44:00 -
[154]
Hi again thought I'd let everyone know we now have a new Russian translation for the installer that someone did for us. Like to thank John for getting that for us.
While I talking about translations for it I'd like to see a few more so if any of you are interested in helping us out with them please contact either me or Satis Iqulenax about doing so.
revision 602 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Caelon Bissau
 |
Posted - 2009.02.27 06:50:00 -
[155]
This seems like a simple problem but I can't find any reason for it to behave this way.
New install and I've set yapeal.php in a cron job but the only output I get is that it thinks I'm running it in a web browser and sends me that error message instead.
Any thoughts?
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.27 08:33:00 -
[156]
You're probably on a Debian or hosted site using Debian or something similar that has the CGI version of first in your path. Most better hosting will have a wiki or other resource to help you with what you need to do. If you can't figure it out on your own on a hosted site contact support and get some help. If you have console access you can also look around usually and find the CLI version of php somewhere.
Once you know the location for the CLI version of PHP you just need to use the alternate crontab instructions from wiki.
http://code.google.com/p/yapeal/wiki/CrontabSetup -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.27 08:37:00 -
[157]
You're probably on a Debian or hosted site using Debian or something similar that has the CGI version of first in your path. Most better hosting will have a wiki or other resource to help you with what you need to do. If you can't figure it out on your own on a hosted site contact support and get some help. If you have console access you can also look around usually and find the CLI version of php somewhere.
Once you know the location for the CLI version of PHP you just need to use the alternate crontab instructions from wiki.
http://code.google.com/p/yapeal/wiki/CrontabSetup -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.27 08:39:00 -
[158]
You're probably on a Debian or hosted site using Debian or something similar that has the CGI version of first in your path. Most better hosting will have a wiki or other resource to help you with what you need to do. If you can't figure it out on your own on a hosted site contact support and get some help. If you have console access you can also look around usually and find the CLI version of php somewhere.
Once you know the location for the CLI version of PHP you just need to use the alternate crontab instructions from wiki.
http://code.google.com/p/yapeal/wiki/CrontabSetup -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.27 08:42:00 -
[159]
You're probably on a Debian or hosted site using Debian or something similar that has the CGI version of first in your path. Most better hosting will have a wiki or other resource to help you with what you need to do. If you can't figure it out on your own on a hosted site contact support and get some help. If you have console access you can also look around usually and find the CLI version of php somewhere.
Once you know the location for the CLI version of PHP you just need to use the alternate crontab instructions from wiki.
http://code.google.com/p/yapeal/wiki/CrontabSetup -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.02.27 08:46:00 -
[160]
You're probably on a Debian or hosted site using Debian or something similar that has the CGI version of first in your path. Most better hosting will have a wiki or other resource to help you with what you need to do. If you can't figure it out on your own on a hosted site contact support and get some help. If you have console access you can also look around usually and find the CLI version of php somewhere.
Once you know the location for the CLI version of PHP you just need to use the alternate crontab instructions from wiki.
http://code.google.com/p/yapeal/wiki/CrontabSetup -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Phobos v2
Big Bangs Emporium Langers R'Us
 |
Posted - 2009.03.02 22:18:00 -
[161]
I was wondering if anyone could point me in a direction here. I've installed Yapeal, setup the tables and corrected the ini file. When I run the cron job for eve-api-pull.php i just get this in response..
X-Powered-By: PHP/5.2.8 Content-type: text/html
It does populate the tables or any logs.... Not sure what i have done wrong.. |

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.02 23:55:00 -
[162]
First thanks for trying Yapeal. That you're getting anything that looks like headers talking about html suggests your not using the CLI version of PHP or it's mis-configured. Also you should be running yapeal.php not backend/eve-api.pull.php as that's change but the documentation hasn't caught up yet. Here's a few question/ideas of things that might help in figuring out the problem:
Where are you see that output because you shouldn't every get that kind of output from Yapeal.
It would be helpful to know what OS (Linux I assume since you said crontab) you're run it on etc
If you look at the cache/log/ directory the log files there might help you figure out what the problem is or help me know what's going on anyway 
Did you try running it manually from the command-line before trying it as a crontab because you'll get to see more what's going on when you do that usually.
Have you tried changing 'log_level' in config/yapeal.ini to E_ALL like suggested in the example for testing?
Have you tried changing all the settings to the suggested ones for testing from the example they should give you a lot more information about what's going on both on the command-line and in the log files.
Last thing that I probably don't have to say but better safe than sorry Have you checked you have the latest from the subversion? Current revision is 620 something at this time. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Phobos v2
Big Bangs Emporium Langers R'Us
 |
Posted - 2009.03.03 08:33:00 -
[163]
Edited by: Phobos v2 on 03/03/2009 08:33:20 Thanks for your quick response, I have a feeling it might be that I haven't got CLI php. I certainly have debug on full and don't get anything from it in the logs. And now i've moved to pointing the cron job at yapeal.php i'm getting the message that i'm running it as a web page (i'm getting these by outputting the results to a file as I don't have cli access to my server).
Thanks :) I'll come back once i've worked through what you've suggested :D |

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.03 14:28:00 -
[164]
Okay just something to add since you're on a hosted site without command-line access Have a look at my post in 156 sound like a similar problem and you'll probably end up having to do something like that. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Phobos v2
Big Bangs Emporium Langers R'Us
 |
Posted - 2009.03.03 18:26:00 -
[165]
Working now, php path in as per one of the recommendations on your cronjobs pages :)
THanks dragonaire :D
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.04 06:36:00 -
[166]
Good to hear and since you said something about them and reminded me, I've now gone through the Linux pages and updated them to be in line with newest revisions of Yapeal. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.05 23:27:00 -
[167]
Hi again I'm like to announce a new improved Yapeal for you all to try out. I'll give a quick list of changes here.
- Fixed bug with charWalletTransactions. This may require you to alter a table, details below.
- Added standings API for characters and corporations. Thanks to Ramov Tinoga for making it and writing such nice clean code made it easy to test and add with only minor additions.
- APIs to pull can be selected on a per char/corp basis ie if you only want to get CharacterSheet and AccountBalance for a character or only AssetList and MarketOrders for a corp now you can.
- Updated configurer thanks to Satis Iqulenax. It now includes an update section for those of you upgrading a recent version.
- Configurer now let's you select which APIs you wish to get. Needed to work with change above.
- The usual minor tweaks and improvements etc that I never seem to run out of

Here's the SQL you'll need to run to fix the charWalletTransactions table.
Quote: ALTER TABLE `charWalletTransactions` DROP COLUMN `characterID`; ALTER TABLE `charWalletTransactions` DROP COLUMN `characterName`;
You'll still need the latest revision of Yapeal to have it work right but these changes can be made either before or after updating as needed.
As always bug reports or a thank you are welcome.
We are currently working on a couple more APIs and Satis Iqulenax has started working on an addition to the configurer so you can use it to upgrade Yapeal using a single button more information on these changes as the code is closer to being done.
revision 656 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Goonda
Minmatar DOMINATIO
 |
Posted - 2009.03.07 14:06:00 -
[168]
It took me a while to set this thing up. Like a few others here, I dont have command line access on my server. Now that I have it running, it is great.
I am planning to create a Drupal plugin with features similar to Out of Eve, and this seems like the perfect API library to base it off of.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.07 20:51:00 -
[169]
Glad you like it and good luck with the application. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Goonda
Minmatar DOMINATIO
 |
Posted - 2009.03.10 19:37:00 -
[170]
I'm really loving this thing. It is very powerful and is making my site development a lot easier. Which is a must, considering that I am teaching myself PHP, SQL, and the EVE-API as I go.
Also, about the code you are working on to auto-populate the utilRegisteredCharacter and utilRegisteredCorporation tables. I actually prefer the current situation with complete application-side control of those tables. It allows better flexibility, even if it does take a little more code in the application.
I have one suggestion regarding the corp tables. Currently the ownerID fields within the corp tables is only the corporationID, but does not include any character related information. Would it be possible to add another "ownerID" field with character identifiers?
Maybe call it ownerIDchar, and have it contain a space delimited list of the characterID for each character (registered in utilRegisteredCorporation) that can get that info from the API.
|
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.10 23:42:00 -
[171]
Hi glad to hear it's helping you out developing your application.
I've limited the utilRegisteredCorporation to using only one characterID because it made Yapeal much easier to program plus I believe easier to use since you only need to associate one character with the corporation to use it.
Quote: I have one suggestion regarding the corp tables. Currently the ownerID fields within the corp tables is only the corporationID, but does not include any character related information. Would it be possible to add another "ownerID" field with character identifiers?
If it did that I'd also have to make it part of the primary key which would mean we'd end up have multiple copies of say corpCorporationSheet or corpAssetList which isn't a good thing. Which is the correct one? How do we handle the extra record when a director leaves the corp for example? Plus it just not good database practice to do so to better understand why look up database normalization.
Quote: Maybe call it ownerIDchar, and have it contain a space delimited list of the characterID for each character (registered in utilRegisteredCorporation) that can get that info from the API.
This is also related to the above as to why not to add a column for this but to help you out developing the list for your needs I'll show you how to get this information from the existing APIs. First some background information you should know. The CEO of a corporation has full access to all the corp APIs using their full APIkey. Also any Directors in the corp has full access. Some of the APIs also let you have access by just being a member of the corp or by having some role in the corp like accountant, etc. There are a couple ways to look up if a character has the needed roles in a corporation. One is to use the charCorporationRoles* tables but requires that the char is registered and active. The other way to do it is to use the corpMemberTracking table which is much easier and only requires the corp API to be active. Using it does make for a bit of a chicken and egg problem when setting stuff up but that something that you'll have to solve as an application developer I will give you a hint on finding the corp members with director access though. You'll need to do something like this:
Quote: SELECT `characterID`,`name` from corpMemberTracking WHERE (`roles` & 1) = 1;
Hopefully that helps you understand the reasoning and ways you can get the information you need. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Goonda
Minmatar DOMINATIO
 |
Posted - 2009.03.11 00:17:00 -
[172]
Thanks for the lesson on database structure. I always like learning new things, and its tough trying to figure everything out from scratch.
Originally by: Dragonaire Some of the APIs also let you have access by just being a member of the corp or by having some role in the corp like accountant, etc. There are a couple ways to look up if a character has the needed roles in a corporation.
This is the part that I'm having trouble figuring out. I understand CEOs and Directors having full acccess, but it is the partial access for regular members and other roles that I'm trying to figure out. I suppose the issue is more of an API question than anything.
I can't seem to make any sense of the 'roles' column within the corpMemberTracking table. Which is outputting values like '575900001641700992' and '9223372036854775807'. The charCorporationRoles* tables would probably serve this same purpose. In either case, the issue then becomes figuring out which roles allow access to which corp info. Another pair of general API questions.
If I could find some resource that had the above info, I could figure it all out.
My feature request above was all about trying to work around this entire issue.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.11 06:58:00 -
[173]
The first link in the sticky above is best resource http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1006676 You'll also find a few more links on the main page there to places like Chucker's that covers some of the same stuff in different ways and also stuff that Eve-Dev doesn't. There's also an example class for dealing with roles that I put out for people to use and abuse in the API Building blocks section near the bottom you should find useful. Basically the roles are in a 64bit long bit map so you need to mask it to find out which ones are set. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sondrou Xi'Tral
Gallente Terror Solutions Stargate Experiment 626
 |
Posted - 2009.03.13 23:19:00 -
[174]
I've been playing around with this quite a bit over the past few days since this seems to be almost exactly what I am looking for when it comes to pulling API data for my alliance website. There are some questions I have, but first I want to post a fix I have come up with that may solve some problems you may have if setting this up on a site with shaed hosting.
Concerning the crontab setup, my hosting company has set the server's CLI php.ini to read only, and the only way to get the CLI to read your custom php.ini is by adding some information to the cronjob. I was getting errors stating that mysqli was not installed when I ran the cronjob, but the CGI (phpinfo()) showed that I had it enabled (as did the check in the setup.php file). However when I went to my CLI and typed php --info, I saw that I was not only using PHP4, but some of the required extensions were missing from my CLI. The fix for this is three parts.
1) Contact your hosting company and find out what the path to PHP5 is. For instance, I have two paths for PHP, one for PHP4 (usr/local/bin/php) and one for PHP5 (usr/local/bin/php5). If this is the case MAKE SURE YOU USE THE PHP5 PATH.
2) Create a php.ini file and place it somewhere on your webserver that is not able to be browsed to, i.e. if you have something like ftpname -> html -> mysite.com, place it in the ftpname folder. A standard php.ini that you can edit to your needs can be found here. All you have to do is remove the ";" from the front of the extensions you want to use.
3) Modify your cronjob to point to the new php.ini in the following format: /path/to/php5 -c /path/to/php.ini /path/to/yapeal.php -c path/to/yapeal.ini
This got me up and running on my shared host (aplus.net), and hopefully it can help some of you out as well.
Since this post is already long enough, I'll make another post with my questions :)
|

Sondrou Xi'Tral
Gallente Terror Solutions Stargate Experiment 626
 |
Posted - 2009.03.13 23:29:00 -
[175]
Ok, now for my questions:
I am running an alliance website, and each member that registers to the site provides either their limited or full api key upon registering, so I can check to ensure they are a member of the alliance. I am planning on adding other feature with the API keys, but with over 200 registered members, it will be tedious as hell if I have to run the setup.php to add each one of them.
Currently my registration asks for the API User ID, the API Key, and whether it is Limited or Full, and saves this to a database table combining the info with their website ID. What I need to know is, is there a way that I can have Yapeal look to this table (in the same database as the Yapeal tables) for the API information without breaking anything. Also, is there a way to make it so that I only have to supply the API User ID and the API Key, and Yapeal can run a job to collect the Character ID's of all the character's associated with that account, as well as those Character's Corp ID's?
If I can't make Yapeal look to my current API table and pick the API info from there, I can always do a cron import of the data once every few days, but I would really need to be able to have Yapeal take the API User ID and API Key from the utilRegisteredUser table and populate the utilRegisteredCharacter and utilRegisteredCorporation tables with all the Character ID's and Corporate ID's.
Any tips would be very appreciated!
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.13 23:44:00 -
[176]
Thanks for sharing you tips for things to look for and the workarounds. Only thing I'd add to your post is that in 3) if you used /path/to/php5 -c /path/to/php.ini -f /path/to/yapeal.php -c /path/to/yapeal.ini it might be better though the '-f' is supposedly optional.
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Goonda
Minmatar DOMINATIO
 |
Posted - 2009.03.15 02:17:00 -
[177]
What do you think about the idea of adding foreign keys (for delete cascade) to each of the char* and corp* tables (and possibly the accountCharacters table)?
It would sure make deleting characters, corps, and accounts a lot easier.
|

Tenshi Ryu
 |
Posted - 2009.03.15 07:09:00 -
[178]
Edited by: Tenshi Ryu on 15/03/2009 07:12:53
Originally by: Dragonaire
NEW HOME http://code.google.com/p/yapeal/
Can someone please tell me where the heck on the above website I can download this? I been over it from top to bottom .... NOTHING!!!!
pleeeeeeasse help ... I really wanna try this.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.15 07:44:00 -
[179]
Had the tables done that way before in the API application I made that Yapeal developed from and I ended up taking them out because trying to get it all working was a nightmare. Also some people don't want their skill list to disappear when they delete their CharacterSheet for example. Also how to you handle corpMemberTracking when someone leaves one corp for another and they are both in the same DB? Much better for that logic to be in the application code where each developer can decide how they want to handle it. I've tried not to build in any interdependences between API tables as any that are added might interfere with someone's application they are making with it. There were several things that got designed into Yapeal as it was because how I had used things in my other programming that I've been slowly trying to remove so as to make Yapeal more useful for more applications. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Gorfob
Minmatar GoonFleet GoonSwarm
 |
Posted - 2009.03.15 10:10:00 -
[180]
Originally by: Tenshi Ryu Edited by: Tenshi Ryu on 15/03/2009 07:12:53
Originally by: Dragonaire
NEW HOME http://code.google.com/p/yapeal/
Can someone please tell me where the heck on the above website I can download this? I been over it from top to bottom .... NOTHING!!!!
pleeeeeeasse help ... I really wanna try this.
This man makes a point. UNless we are supposed to grab the source from the source viewer on the website there is no link to download it.
|
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.15 14:45:00 -
[181]
From the first post.
Quote: Available through subversion at new home.
I also now edited my first post to add some additional information and links that might be helpful.
So to put it simple there aren't any 'downloads' at this time and may not ever be you need to use a subversion client to get Yapeal. You can find out more about subversion and what you need to do to get it at http://code.google.com/p/yapeal/source/checkout there's also some instructions for installing Yapeal on Windows in the wiki. http://code.google.com/p/yapeal/wiki/InsYapWinSer
This has also been asked/wrote about a couple times already in this thread as I remember so there's probably some more info back a couple pages if you look.
Just some notes for people that are on hosted server and don't have command-line access or no subversion access from it, you can get Yapeal on any computer and then upload it with ftp, etc just like you would any other web page or script. The preferred place to have Yapeal installed would be outside of any directory accessible by the web server but that isn't always possible I know and does make using the configurer very hard If you use a local test server (You should be you know) you can even copy it's configuration to your live server so you don't even need to run the configurer on the remote server which should make it easier to instill it somewhere else for added security. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Marty Thompson
 |
Posted - 2009.03.16 00:41:00 -
[182]
Hey, just wanted to say thanks for the cool tool. I finally have it up and running on my computer and I'm working on creating useful output for myself.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.17 22:50:00 -
[183]
Just thought I'd let everyone know I've added a page to the Eve online Wiki about Yapeal you can view it at http://wiki.eveonline.com/wiki/Yapeal
No new information in it since I basically took the wiki page from Eve-dev and dropped it into page but thought I'd let people know about it.
In other news I'm working on some issues that have come up while working on a new API and some errors that have been reported to me by some others as well. I expect to have some fixes ready in a few days. Satis Iqulenax has also been work on some issues with the configurer that have been reported and hopes to have them fixed within a couple days also. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Wraas Mlnir
Arctic Flying Penguins A.X.I.S
 |
Posted - 2009.03.18 00:02:00 -
[184]
Edited by: Wraas Mlnir on 18/03/2009 00:04:57 I did scan through to see if it had already been mentioned (apologies if this is a dupe, its been a long day).
Your Yapeal.sql file has a typo. The section that creates the TABLE utilConfig is referred to as utilconfig a couple of lines below causing the sqlscript to throw an error when it is run.
A quick search in vi for utilconfig will highlight only one instance and if you need a line count its on line: 742 meh |

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.18 00:54:00 -
[185]
Your the first to report it but I had spotted that when I was doing something else with the SQL files. It'll be in one of the upcoming fixes. Thanks for the report.
For those interested or needing the fix before I merge it with the trunk change line 742 of install/Yapeal.sql to read:
INSERT INTO `utilConfig` VALUES('version', '$Revision: 621 $') ON DUPLICATE KEY UPDATE `Value`=VALUES(`Value`);
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.03.18 23:21:00 -
[186]
Ok Now that they've changed it to something easier to work with I've added the Skill Queue API to Yapeal.
I've also release some minor fixes the some of the SQL files, etc.
The backend/ directory with the old eve_api_pull.php file has been dropped also. It was replaced by the Yapeal.php a while ago but I left the old file in for a while to let people have time to switch over but I've decided it been long enough for everybody to make the switch 
Revision 690 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Wraas Mlnir
Arctic Flying Penguins A.X.I.S
 |
Posted - 2009.03.19 23:01:00 -
[187]
Is there any chance I can see an example of the three records I need to insert as part of the initial setup as per the Getting Started guide.
I think I am either missing something, or putting in too much into the utilRegistered* tables.
thanks
-Farting on exiting elevators since 2003 |

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.03.20 00:52:00 -
[188]
Actual the instructions were missing a step that is needed now to have it work. I've added the step about activeAPI that was probably causing you the problem along with some addition notes that should be helpful. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Wraas Mlnir
Arctic Flying Penguins A.X.I.S
 |
Posted - 2009.03.20 13:01:00 -
[189]
That did the trick, thanks for the update.
I have a question about how data is persisted in the database. With large datasets like journals, the API only allows you to go back a fixed amount (either time or number of records if I am not mistaken).
My question is does Yapeal accumulate the data, or does it write over the last dataset with the new data?
-Farting on exiting elevators since 2003 |

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.03.20 14:44:00 -
[190]
Most APIs are deleted/truncated and then inserted but the Industry Jobs, Market Orders, Wallet Journal, and Wallet Transactions are not. They will keep the last values from the last update received from the API for each record and there for have a history that continues to grow. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.03.21 19:48:00 -
[191]
Hi everyone it's me again I've just finished killing some bugs in the latest API to be added to Yapeal. With some help from Johnathan Roark on it Yapeal now has Kill Log (Kill mails). You can now get them for both characters and corporations.
Also in this revision Satis Iqulenax and I have been trying to fix all the problems that have crept into the SQL lately for both the main files and the ones used by the configurer. We're looking at making some changes to decrease the number of SQL files that need to be updated and kept in sync which should help some of the problems we are having now.
There was a small bug in the Skill Queue that I also fixed in this revision.
Work is still continuing on the problems with Wallet Journal and Wallet Transactions not walking back through API correctly but has been held up by a need to rewrite much of the code that Yapeal uses to connect to the API servers so has been slow going since it ends up effecting all the APIs to a degree and I'm trying not to break everything all at once for a change 
Revision 702 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

General Ordogg
 |
Posted - 2009.03.26 04:49:00 -
[192]
Dragonaire, Your php to Mysql is awesome. Thank you for making this available to us all.
I have a question for anyone as I'm not a PHP programmer.
If someone could basicly rip out most of the code for the PHP files for the setup to change it to a free form user addtition to the database that would be awesome. it should be pretty simple for someone with some programming experiance. I just basiclly want to use the wizard or a new page to have a user enter their API and then tag all characetors for that API to get put into the database table utilregisteredcharacter.
I'm willing to pay isk for this.
|

Wraas Mlnir
Arctic Flying Penguins A.X.I.S
 |
Posted - 2009.04.03 11:13:00 -
[193]
I'm working on just that at the moment General.
Its not being rushed at the moment, as I am still sorting out some crap with my host, but then I am moving on to some tool development, mostly its database admin, and some basic reports from the database to begin with, but the first step HAS to be user administration as its a ball ache doing it manually...
-Farting on exiting elevators since 2003 |

Selene D'Celeste
Caldari The D'Celeste Trading Company
 |
Posted - 2009.04.19 18:22:00 -
[194]
Following the steps here: http://code.google.com/p/yapeal/wiki/InsYapWinSer
I get to "setup.php?install=step3" of the Yapeal setup and the apache server crashes.
Problem signature: Problem Event Name:APPCRASH Application Name:httpd.exe Application Version:2.2.11.0 Application Timestamp:493f5d44 Fault Module Name:php5ts.dll Fault Module Version:5.2.9.9
I can't find any more information on what could be configured wrong to cause this. Ideas?
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.04.20 15:53:00 -
[195]
Originally by: Selene D'Celeste Following the steps here: http://code.google.com/p/yapeal/wiki/InsYapWinSer
I get to "setup.php?install=step3" of the Yapeal setup and the apache server crashes.
Problem signature: Problem Event Name:APPCRASH Application Name:httpd.exe Application Version:2.2.11.0 Application Timestamp:493f5d44 Fault Module Name:php5ts.dll Fault Module Version:5.2.9.9
I can't find any more information on what could be configured wrong to cause this. Ideas?
In the cache/log folder where you have installed yapeal, you should have a setup log. with the date and time from where you started to use the setup.php.
Please check where it stops.
Kind Regards Satis install dev ---- Yapeal Developer Member Yapeal Setup Creater |

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.04.20 19:10:00 -
[196]
Okay NM my last post.
We have just released our new release. There is nothing new in the API of Yapeal but the setup it totally rewritten.
It's the 2. generation of the yapeal setup and right now, there is no manual install, so you have to use the setup.php from the install folder.
The character selection is not needed anymore and will not be shown in the first time setup, but first after yapeal is setup and running from your web host. The reason for this is that the character select and api registration is ONLY meant to be used as a test to test yapeal. When implementing into your system, do not use the test character section.
Another new thing that is added is that the setup now works together with yapeal error handler and there is now 3 new files in cache/log folder where all the new error/warning/notice logs will be added if there is one in the setup and it will be easier for us to find the error if you get one.
The backwards compatibility only goes back to last release so if you are using an older version than the last one, then you will need to start with a clean install.
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Ticnala
 |
Posted - 2009.05.01 05:19:00 -
[197]
I was trying to use the setup.php today after grabbing the 755 revision. The page loads up blank in my browse and when I went to check on the code in funciton.php I noticed there were some for loops missing foreach ( from the beginning. Dropping back to 754 will display the first page but I had to drop to 752 for it to pass the file write test. In 753+ there was a log error saying that the YAPEAL_LOG_LEVEL varible was undefined. 752 doesn't have that problem though and has been working so far.
I'm running PHP 5.2.8, Apache 2.2.11, and mySQL 5.1.32 revision# 2761.
Thanks again for the awesome work :D
|

Coryigon
Minmatar Research Unlimited
 |
Posted - 2009.05.01 17:16:00 -
[198]
When accessing setup.php I get this
Parse error: syntax error, unexpected T_AS in /home/repoindu/public_html/Yapeal/install/inc/function.php on line 77
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.05.02 05:27:00 -
[199]
Okay after having a look over in the code (and fixed some tiny bugs Dragonaire made :P) I found some small bugs that should be fixed now.
Try grab it from the trunk again and see if you still get the same errors
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.02 06:43:00 -
[200]
Hi guys I've fixed a few more things. The class/api/*AssetList.php files for char/corp have been updated to use the new lvl column. charSkillQueue should now update correctly also.
Revision 758 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Coryigon
Minmatar Research Unlimited
 |
Posted - 2009.05.02 12:53:00 -
[201]
Working good now thanks.
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.02 19:48:00 -
[202]
Some more fixes.
- Fixed errors caused by merging a project member's killboard version of the *KillLog xml definitions from one of his other projects instead of one without the extra columns
- Fixed minor missed edit to corpAssetList that caused warning messages when running yapeal.php
Revision 759 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

powers sellers
 |
Posted - 2009.05.03 10:15:00 -
[203]
i tried to use yapeal. All is ok but when i create cron i have this :
Quote: nullPHP Warning: mime_magic: type regexBEGIN[[:space:]]*[{]application/x-awk invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\inputtext/x-tex invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\sectiontext/x-tex invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\setlengthtext/x-tex invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\documentstyletext/x-tex invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\chaptertext/x-tex invalid in Unknown on line 0 PHP Warning: mime_magic: type search/400\\documentclasstext/x-tex invalid in Unknown on line 0 X-Powered-By: PHP/4.4.8_pre20070816-pl1-gentoo Content-type: text/html <br /> <b>Parse error</b>: syntax error, unexpected '{' in <b>/home/nthr/www/yap/yapeal.php</b> on line <b>101</b><br />
is it me or the code wich make problem ?
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.03 13:12:00 -
[204]
Quote: X-Powered-By: PHP/4.4.8_pre20070816-pl1-gentoo
Your trying to run it with PHP4 instead of PHP5 which won't work. Yapeal requires at least version 5.2.1. I'm also guessing from some of the rest of the message that you're trying to run it with the CGI version of PHP and not the CLI.
Just as a guess you're at a hosted site and you're using their so called 'cron' setup and not using the crontab command directly through a remote login like SSH to try setting it up which seems to cause all kind of problems for people. There is some help on the Yapeal website including some pointers in one of the issues on how to work around that. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Meissa Anunthiel
Redshift Industrial
 |
Posted - 2009.05.08 09:37:00 -
[205]
Hi Dragonaire,
Your early comments refer to a yapeal.sql file that doesn't exist [anymore?].
Followed your InsYapWinserver documentation to install, everything is fine, works flawlessly until you reach the "Character Select and API Pull Select".
There's no such thing. :-)
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.05.08 10:51:00 -
[206]
Originally by: Meissa Anunthiel Hi Dragonaire,
Your early comments refer to a yapeal.sql file that doesn't exist [anymore?].
Followed your InsYapWinserver documentation to install, everything is fine, works flawlessly until you reach the "Character Select and API Pull Select".
There's no such thing. :-)
Okay first of :P InsYapWinserver documentation is something I wrote and sorry for not updating it to the new version of yapeal that we have released. I'll go fix that now. The character select have been removed from the first time setup, since it's not really needed in a website where yapeal is implemented in. However if you are still just trying Yapeal out, then just run the setup.php again and then there is 3 menu now, where you can change database info, change Yapeal api handler and test character witch is the one you were looking fore ;)
about the yapeal.sql file, then if you have read one of my previous posts, then we have removed all sql files and manual setup is not possible now, Dragonaire might make a CLI installer, but that's that. We have changed from sql files over to use a axmls schema xml file to create the tables, since it's easier for us to maintain.
I'm guessing you found that info in a old dock :)
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Bonechewer
 |
Posted - 2009.05.09 00:53:00 -
[207]
Hey guys...
Ive got a bit of a problem with the SVN ive downloaded. The password field is not provided during the setup. So when i get to http://192.168.1.56/yapeal/install/setup.php?funk=configini ... no matter what i try, it doesnt work.
Any ideas ?
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.05.09 01:23:00 -
[208]
Originally by: Bonechewer Hey guys...
Ive got a bit of a problem with the SVN ive downloaded. The password field is not provided during the setup. So when i get to http://192.168.1.56/yapeal/install/setup.php?funk=configini ... no matter what i try, it doesnt work.
Any ideas ?
It should be on the yapeal.ini Setup page in the bottom. it's the page right after the tables have been created. Else check the cache/log folder and see if the setup_error.log, setup_notice.log or setup_warning.log have some info in it, since we need some more info on it.
Kind Regards Satis
---- Yapeal Developer Member Yapeal Setup Creater |

Matrix Lady
 |
Posted - 2009.05.13 10:10:00 -
[209]
i want to try the yapeal but where is the download links? i try on google but nothing any can help me with this? thank you
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.13 14:07:00 -
[210]
You have to use subversion to get it there's some instructions earlier in this thread and also in the wiki that should help you with getting it.
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Matrix Lady
 |
Posted - 2009.05.14 01:56:00 -
[211]
done code downloaded and now i make my install thx  One more question because i am noob on this and i can find other information.. i want my user to register on my site (this done)
It is possible with yapeal when my user is register and put the api key, this key save it on database for future use from user? is that easy? and if how can do it?
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.14 02:19:00 -
[212]
Glad to hear you've got it now.
Quote: It is possible with yapeal when my user is register and put the api key, this key save it on database for future use from user?
Any users, chars, corps that you add to the util.RegisteredUser, ...char, ...corp tables and is active Yapeal will get their info once you have the crontab setup but since Yapeal is made as a library for other developers to integrate into their own applications we haven't include anything to do that directly except for a single test user that you can do during setup for your own testing to make sure it's installed correctly.
You should be able to find some more info from some of the other posts in this thread and comments in the issues and on the wiki that should help you more with Yapeal. You can also look at the code which is generally will commented IMHO anyway . You might also look through the stuff in the docs directory by browsing in the source code tab. I will say that much of it is meant more for a programmer then for an end user since Yapeal isn't an application but a library 
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Matrix Lady
 |
Posted - 2009.05.14 20:48:00 -
[213]
Edited by: Matrix Lady on 14/05/2009 20:49:04 know THAT BECOME embarrassing to ask but I am a new to all this I want to make a small start to use this api library and i now my next question is stupid but I do not know where to begin.. so any help with this start on me i would appreciate it very much Let's say I have a .html page Blank and i need to see what characters i have in my account,so i have the id and api key after? Let's say I have one 2 textboxs one for id and one for api key, what code i need to pull out the data from yapeal and show in my blank web page after that explain i now where i start thank you.
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.05.14 21:54:00 -
[214]
Originally by: Matrix Lady Edited by: Matrix Lady on 14/05/2009 20:49:04 know THAT BECOME embarrassing to ask but I am a new to all this I want to make a small start to use this api library and i now my next question is stupid but I do not know where to begin.. so any help with this start on me i would appreciate it very much Let's say I have a .html page Blank and i need to see what characters i have in my account,so i have the id and api key after? Let's say I have one 2 textboxs one for id and one for api key, what code i need to pull out the data from yapeal and show in my blank web page after that explain i now where i start thank you.
Well you need to add some php code to get it to work. the first page you make the form and on the other page you use php codes to insert the data to the database in utilRegisteredUsers, utilRegisteredCharacter and utilRegisteredCorporations.
You might want to look at my code I use for the test character section. goto install/inc/config in your yapeal dir and then have a look at configapi.php, char_select.php and goapi.php this files holds the code I used to create a test character and it should be easy to convert them over for your own needs :)
Hops this helps.
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Matrix Lady
 |
Posted - 2009.05.16 23:26:00 -
[215]
i have a small problem i try everything but nothing.. i make install on my mac zend studio and zend server all is ok with this i make install yapeal all ok until login screen.. when i put my pass or no pass or everything i try say login fail. php.ini is ok i take like this errors
/usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 52 [17-May-2009 02:20:43] PHP Notice: Undefined index: password in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 39 [17-May-2009 02:20:43] PHP Notice: Undefined index: yapealsetup in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 40 [17-May-2009 02:20:43] PHP Notice: Undefined index: password in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 52 any help on this thx..
|

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.05.17 14:04:00 -
[216]
Originally by: Matrix Lady i have a small problem i try everything but nothing.. i make install on my mac zend studio and zend server all is ok with this i make install yapeal all ok until login screen.. when i put my pass or no pass or everything i try say login fail. php.ini is ok i take like this errors
/usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 52 [17-May-2009 02:20:43] PHP Notice: Undefined index: password in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 39 [17-May-2009 02:20:43] PHP Notice: Undefined index: yapealsetup in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 40 [17-May-2009 02:20:43] PHP Notice: Undefined index: password in /usr/local/zend/apache2/htdocs/testdb/install/inc/config/login.php on line 52 any help on this thx..
okay first off. I have fixed those notifications that you got. so new release in the trunk.
Second be sure that you have cookie turned on or else it wont work. another thing to check is in the database. go into utilConfig and see if there is a row with Name: password if it has that, check if it's empty. the password field may not be empty at all, not even if you have added a blank password, since it still convert the blank password into a hash string.
Another thing dragonaire and I talked about, might be that you are running it on a mac + on a zend studio since we don't know if that can run it properly, but we might be wrong about that.
Try it out and please give us a hint if it's working.
Kind Regards Satis ---- Yapeal Developer Member Yapeal Setup Creater |

Asimina
 |
Posted - 2009.05.19 00:38:00 -
[217]
i am matrix from up post:) so i try that yoi say on up post and i have the same results.. this time i try it on windows with zend server.. i make the installation all is green and ok on install when i go on login screen i take again the same error. i check the UtilConfig you say and i take this results from there and i hope help you.. i dont find any row with password inside.. the 2 Rows i find is Name and Value
utilconfig Table comments: InnoDB free: 11264 kB
Field Type Null Default Comments Name varchar(90) No Value varchar(255) Yes NULL
Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 8 Name
Space usage: Type Usage Data 16,384 B Index 0 B Total 16,384 B Row Statistics: Statements Value Format Compact Rows 8 Row length ° 2,048 Row size ° 2,048 B Creation May 19, 2009 at 03:26 AM
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.19 02:45:00 -
[218]
My suggestion is try it with PHP 5.2.x or better and only with the extensions it needs to run. I'd also suggest looking through the install and troubleshooting info in the Yapeal wiki and see if that doesn't help you figure out where it's going wrong better. If that doesn't seems to help with your problem we'll probably need you to send us some some of your log files so we can figure out better where the problem is. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Grandolfer
JotunHeim Hird Mostly Harmless
 |
Posted - 2009.05.22 08:28:00 -
[219]
I see that you need the api key(s) and userid from EVE for this.. I have this, but in another db. Is it possible to make YAPEAL fetch that data from another db/table instead of yapeal.utilRegisteredUser and yapeal.utilRegisteredCharacter Gr34tB4ll$ |

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.22 11:15:00 -
[220]
Grandolfer The DB name can be anything you want so you can install Yapeal so it just adds it's tables to your existing DB if you want. If you look in the inc/common_db.php file you'll find the main functions that are used to do the queries to the DB. To use different tables in the DB for the userID, ApiKey etc you would have to modified the queries there and it should work The only problem would be when we put out new versions of Yapeal you would have to modify them again. A better way might be to make a view in MySQL to map your exist table so it overlays (renames) the table/columns that it wants but to tell the true I'm not sure if/how well that might work as I've never tried something like that and I am not a DB guru so don't know if that would work or not Maybe someone else will have some ideas about this also and share them with us. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.05.28 13:14:00 -
[221]
Hi everyone just thought I'd update everyone on some stuff we've been working on. Finally after many requests and a long time coming I've added the Starbase Detail API. This makes what I consider the 'core' APIs complete now. 
This means that any other APIs that get added by me will probably only get added if I find I need it for any of the other projects I'm working on that use Yapeal. I'll still be adding and improving Yapeal as I get time or I get inspired to work on something but doing so will take a backseat to other things for now. As always I will continue to fix any bugs that get found or reported. Hopefully other people will decide to write and share some of the missing APIs with the project as I would like to see Yapeal have all the APIs implemented and be truly complete.
Since I've said something about working on other projects I'll tell you all about an old project that has come back to life that in part was why I made Yapeal to start with. It's called EMPA and is now currently it a very early alpha state of development by part of the development team of Yapeal plus a couple others. We're now working on the core framework which we should have to a usable state in the near future but everyone is welcome to download it and try it out but be warned it's in a rough state and subject to regular major changes and probably more than a few bugs I'd like to thank Satis Iqulenax and the others who have took up the project and really got it going again. I will probably also be working on some other small projects related both to Yapeal and EMPA but none of them are complete enough to talk about yet.
revision 786 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

DrefsabZN
Caldari Butterfly Effect Corp.
 |
Posted - 2009.05.28 13:27:00 -
[222]
Thanks for the update Dragonaire, I've been playing with EMPA the other day (was looking for something similar to out of eve seeing that doesnt seam to be an active project any more). I definatly like where this is going and just wanted to say thanks for all the hard work.
|

Dirty Snipe
 |
Posted - 2009.06.04 07:53:00 -
[223]
I just tried to follow the migrate instructions as I am already using another version of yapeal.
3. Use the install/Yapeal.sql
I cannot see this file. I also checked the svn and it also is not located in install/
I cant find it anywhere.
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.06.04 14:47:00 -
[224]
To Dirty Snipe and others that have tried to use the upgrade instructions in Updating.txt I'd like to apologize for the confusion they have been causing. Those instructions were for some changes we made back sometime in the revision 400-500 range and does not work for more current revisions. As often seems to happen during development the documentation doesn't also get updated when it should. As you noticed we have removed all the SQL files from Yapeal now that we've switch it to using the newer AXMLS system to do database updates in a semi-automatic way. To help people determine which revisions need to do what and what resources they (i.e. addition older files needed etc.) we'll try to put together something on the wiki to help out in the next couple days. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

lillitheve
Lupus Draconis
 |
Posted - 2009.06.05 02:14:00 -
[225]
Ok, maybe I am missing something, or maybe I've read too many of the posts in this thread. I looked through the two files, configapi and goapi and not sure what I need to put in there or where...second, and it might be related, if you enter something in the test char section, does the test char data not get put into the DB? Lupus Draconis Home |

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.06.05 04:52:00 -
[226]
lillitheve try just installing/copying Yapeal to your web server and browse to the url for install/setup.php once you've done that you'll want to try running yapeal.php from a command line so that Yapeal populates the database tables with the data APIs you have set active during setup. Once that seems to work right you'll need to create a crontab/scheduled task to run it every minute. For more details refer to the wiki pages from the project's home. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

lillitheve
Lupus Draconis
 |
Posted - 2009.06.05 13:08:00 -
[227]
ok, well been trying that, the setup went beautifully, as far as I can tell, have lots of tables, but no data in them. I am using godaddy hosting for my webserver.. It appears that the php5 is being run through the cgi not a true command line, so the cron job outputs this:
Quote:
/web/cgi-bin/php5: Symbol `client_errors' has different size in shared object, consider re-linking Content-type: text/html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http:www.w3.org/TR/xhtml1" xml:lang="en" lang="en"> <head> <title>Yapeal is not a web application</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> </head> <body> <h1 style="font-size: xx-large;color: #ff1010;">USER ERROR USER ERROR USER ERROR</h1> <p> If you are seeing this you have tried to run Yapeal as a web page which is incorrect. Yapeal is made to <b>ONLY</b> ran from the command line. See the <a href="http://code.google.com/p/yapeal/w/list">Yapeal Wiki</a> for more information on using it. </p> </body> </html>
trying to run it through ssh on putty gives me this:
Quote: <b>Parse error</b>: syntax error, unexpected '{' in <b>/home/content/g/w/y/gwyndion/html/yapeal.php</b> on line <b>101</b><br />
any ideas on how to get it to work?
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.06.05 13:54:00 -
[228]
Have a look at this article http://help.godaddy.com/article/1083 and look around at some more of their help about the path you may need to use to run the PHP5 CLI since it looks like they are like most hosting places and have the PHP4 version in your path by default instead of 5 Also look at the old issues at Yapeal's web site as there was some pointers there for how someone worked around a similar problem at another hosting. |

lillitheve
Lupus Draconis
 |
Posted - 2009.06.05 22:03:00 -
[229]
well, after plugging away at it, I never did get it to work on their hosting. Tis unfortunate, as it would be a good foundation for what I wanted to do. Hopefully, there will be a way that you can get it as a web access, instead of an application in the future, in the mean time, I will just quietly follow the progress to see where it goes. Thanks for trying dragon Lupus Draconis Home |

Satis Iqulenax
Amarr Free Imperial Vikings
 |
Posted - 2009.06.06 03:39:00 -
[230]
Originally by: lillitheve ok, well been trying that, the setup went beautifully, as far as I can tell, have lots of tables, but no data in them. I am using godaddy hosting for my webserver.. It appears that the php5 is being run through the cgi not a true command line, so the cron job outputs this:
Quote:
/web/cgi-bin/php5: Symbol `client_errors' has different size in shared object, consider re-linking Content-type: text/html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http:www.w3.org/TR/xhtml1" xml:lang="en" lang="en"> <head> <title>Yapeal is not a web application</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> </head> <body> <h1 style="font-size: xx-large;color: #ff1010;">USER ERROR USER ERROR USER ERROR</h1> <p> If you are seeing this you have tried to run Yapeal as a web page which is incorrect. Yapeal is made to <b>ONLY</b> ran from the command line. See the <a href="http://code.google.com/p/yapeal/w/list">Yapeal Wiki</a> for more information on using it. </p> </body> </html>
There is a way to use yapeal with that conjob you have, but you will need to disable that error test. This how you do it: open yapeal.php in a text editor and goto around line 85. there you will see an function triggered with the name: notAWebPage(); just add 2 / in front of it to disable that check, like this: //notAWebPage(); Now you can run it in a web browser as well.
I uses this hack on yapeal in the project EMPA that Dragonrun, stephen12, wengole and I are doing right now. I had to make that hack, since my web host also don't have a real CLI cronjob.
Hope this helps ;)
|
|

lillitheve
Lupus Draconis
 |
Posted - 2009.06.06 15:38:00 -
[231]
yes! that worked...now using the hack from another api puller to give id's friendly names, and then to design a php document to list things in a table, I'll have the corp asset items plugged into my smf forum in no time (no time being figurative for a very long time, but a step in the right direction) Lupus Draconis Home |

Cory Sopapilla
Minmatar
 |
Posted - 2009.06.11 18:59:00 -
[232]
Very nice tool. Thanks for sharing it.
The docs could definitely use an update though ;) I just kinda hacked it together after figuring out I needed to run the setup.php script thru a browser, did the "test character" thing and found it actually populated something in the DB after trying to find the config file to enter users/API keys, and finally realized it had put my limited API key in the full API field. After that it was all working.
So, 2 questions: 1) It didn't seem to work with just my limited key. Does it really need the full access key? It also kept saying I didn't have the proper role to pull some of the data (I'm CEO so that's not right). 2) Any plans on adding eve-central market pulls? Currently I pull the entire daily dump and spend about 20 hrs deleting duplicate orderIDs in a script. I'd love to be able to just pull the pieces I want and shove it in the DB ;)
Thanks!
|

Dragonaire
Caldari Corax. Sex Drugs And Rock'N'Roll
 |
Posted - 2009.06.12 06:21:00 -
[233]
Quote: It didn't seem to work with just my limited key. Does it really need the full access key? It also kept saying I didn't have the proper role to pull some of the data (I'm CEO so that's not right).
Many of the APIs do require the full APIkey so Yapeal just assumes that what you gave it. As you've noticed it doesn't really matter if you are CEO or not some things just need the full key to work.
At some point we might add Eve-Central data as well but I'm busy with new job right now and the rest of the team and I are working on EMPA which uses Yapeal for it's backend API stuff. That doesn't leave much time to add new stuff right now 
I am still try to get around to updating the docs so they are more current but not sure when I'll get that done. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Nick Partridge
 |
Posted - 2009.06.16 19:48:00 -
[234]
Just wondered, I had a problem on my server and had to reinstall yapeal.
However now I keep getting the error Failed map.xml file was not found or a bad XML file
I have tried to svn download, copy and paste the file etc, but it continues with same error.
Any ideas ?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.06.16 21:12:00 -
[235]
Originally by: Nick Partridge Just wondered, I had a problem on my server and had to reinstall yapeal.
However now I keep getting the error Failed map.xml file was not found or a bad XML file
I have tried to svn download, copy and paste the file etc, but it continues with same error.
Any ideas ?
look in the install/ folder and see if you have a map.xml file
Vuk Lau for CSM 3.0 |

Nick Partridge
 |
Posted - 2009.06.16 21:18:00 -
[236]
Yup it is there. I tried to replace it witha fresh download. I opened the file deleted contents and filled it with the online file in yapeals downloads.
Tried restoring an old version on the PC.
All still have same error. :-(
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.06.16 22:41:00 -
[237]
Edited by: Johnathan Roark on 16/06/2009 22:42:22
Originally by: Nick Partridge Yup it is there. I tried to replace it witha fresh download. I opened the file deleted contents and filled it with the online file in yapeals downloads.
Tried restoring an old version on the PC.
All still have same error. :-(
Make sure your actually has permission to read it, normally www-data group or something like that and chmod g+r,u+rwx map.xml |

Nick Partridge
 |
Posted - 2009.06.17 09:46:00 -
[238]
Hiya, thanks for your reply. I have tracked down the problem. I still had Map tables in the DB. Unlike the other tables for some reason the install script wont run unless you remove the tables and it can install them from scratch.
Now I am trying to resolve a new issue, which has been a cause of the svn and the weird server changes that have occured.
Quote: Notice: Yapeal version 779 (beta) 2009-05-21 15:16:39 in /home/nickph/yapeal2/inc/common_backend.php on line 54
This ones new :-)
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.06.17 15:31:00 -
[239]
Hi looks like you solved your problem but thought I'd comment on the part about deleting the tables so the installer would re-create them. You shouldn't need to do that if you use the update part of the installer as it was made just for that. Only case where it will have problems is if you have a very old version of the tables that it doesn't understand in which case you might have to delete them so it can rebuild them correctly. |

Nick Partridge
 |
Posted - 2009.06.25 10:21:00 -
[240]
Edited by: Nick Partridge on 25/06/2009 10:22:34 Yeah you most liely right, I was stuck by vertue of the fact all the tables were corrupted that Yapeal uses so nothing worked at all :-)
|
|

Cory Sopapilla
Minmatar
 |
Posted - 2009.06.25 15:07:00 -
[241]
Ok so I was building a sandbox server for API tool development and ran into the map.xml issue myself. If you put the CCP dump into a DB then add yapeal to the same DB, mapJumps is a duplicate table. So even from a fresh install, the 2 can't coexist unless you delete/rename mapJumps from CCP. It makes me worry about the next CCP data dump upgrade though. I'm going to end up losing mapJumps for yapeal most likely since I'll probably forget by then.
Any chance of looking into that and possibly renaming the yapeal mapJumps next build if this is confirmed? |

Dragonaire
Caldari Corax.
 |
Posted - 2009.06.25 15:37:00 -
[242]
No need to rename it that why we added the prefix stuff to Yapeal so if this became a problem there was already a fix in place When you run the instiller just make sure you use the prefix option when setting up the tables so for example all of them look like MyDB.YapealaccountCharacters etc. |

Cory Sopapilla
Minmatar
 |
Posted - 2009.06.25 18:58:00 -
[243]
Cool. As always, thanks for the quick response.
|

Barrington Farquharsen
Simtech Industrial Inc.
 |
Posted - 2009.07.11 12:39:00 -
[244]
I'm trying to pull CorporationSheet data for corps entered into the utilRegisteredCorporation table.
How would I go about editing your code to allow for the entry of an activeAPI (corpCorporationSheet) and a corporationID into this table so that it would update corpCorporationSheet accordingly?
Ideally, I'm not wanting to be limited to a single corp in this table (by restrictions such as characterID cannot be NULL and needing API keys for a character to be entered too). I would like to enter multiple corpIDs and pull the CorporationSheet for each one to be entered into the corpCorporationSheet table automatically.
I'm sure this would be possible within your code structure but just can't figure it out myself.
Great API library though 
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.07.11 14:01:00 -
[245]
Barrington Farquharsen - What you'll need to do is add another row to the utilRegisteredCorporation table with a minimum of the isActive, corporationID, characterID, and activeAPI set with the information on the corp. ActiveAPI is a space separated list of the APIs you want it to get for that corp. You'll need a row in utilRegisteredCharacter that correlates with the characterID column. You'll also need to add a row in utilRegisteredUser that correlates to the userID in utilRegisteredCharacter and has the fullApiKey filled. You don't have to set isActive=1 except if you also want to get API data for the character. The characterID you have in utilRegisteredCorporation needs to have CEO or director level access in the corp for it to work correctly. That is because of requirements setup by CCP to access most of the corp APIs.
Hopefully the above get you started down the right track. Yapeal was design to support multiple users, chars, and corps as that was a requirement for it in EMPA and also for it to be more generally useful for other developers. The installer only let's you add one of each as it is only meant to be used for initial testing for people to try out Yapeal before developing their own applications with it. Look for some useful util classes to show up in EMPA to make managing the utilRegistered* tables easier in the near future as more of what is being worked on in the branches get merged back into the trunk on it. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Barrington Farquharsen
Simtech Industrial Inc.
 |
Posted - 2009.07.11 14:33:00 -
[246]
I follow that the 3 tables need to be populated to do what you say, but ideally I would only like the utilRegisteredCorporation table to be populated.
As far as I am aware, the CorporationSheet can be accessed without an API key -- it only requires a corpID. This is what I would like to do. Ideally all I would do is populate the utilRegisteredCorporation and the cron job populates the corpCorporationSheet table.
Sadly I'm not interested in Corp or Character specific information, only CorporationSheets, hence the need for something where a characterID or API key is not required.
Would this be possible within Yapeal?
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.07.13 17:43:00 -
[247]
Can people get 'public' info about a corporation without being part of the corp? Yes
Could Yapeal be modified to not require you to have corp member info to access the API? Yes.
Do we plain on doing so? No, but it is open source so if someone wanted to branch it and do so they're welcome to do so and they would probably even get a few points from me on things that would need to be changed.
Something that might work but I haven't testing is to point the characterID at your character info for the other corps and see if it'll let you still pull the info from the API. The only thing you might run into is Yapeal may error out because of any missing stuff in the API info returned since you aren't a member in the corp and don't have access. Also depending on how the API works when Yapeal passes your UserID and API key it may give you an error about not being a member of the corp. You would just have to try it with all the logging turned on and see what happens but it might actually work  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.07.16 15:18:00 -
[248]
Hi everyone been working on some stuff in EMPA and that's shown me a few areas where I could be improved in Yapeal as well. Decided to bring over the class autoloader first as it's one of the easiest and required little in the way of changes. It's something I had thought about doing before but never got around to so when the need for one in EMPA came up I wrote it and decided I should port it back into Yapeal too.
In the process of adding the class autoloader I also made a couple small changes to the installer so it'll now cache the SQL it uses to build the tables. You can find the files in cache/. Some of you might find them interesting or even useful when move stuff between development and hosting servers. The ones it'll save if there's an error might also be useful during debugging for you and us 
Look for some more changes/improvements to show up as my work schedule and development on EMPA allows.
revision 803 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Cory Sopapilla
Minmatar
 |
Posted - 2009.07.16 15:59:00 -
[249]
Awesome. Thanks for the update. I'll check it out tonight.
Anything in the autoloader classes that would help in user registration of API info to populate the tables? I'm working on my own but don't want to reinvent the wheel if it's already done.
Thanks
|

Dragonaire
Caldari Corax.
 |
Posted - 2009.07.16 17:04:00 -
[250]
No this let's me get rid of most of the require_once statements that were scattered throughout the code. You can read more about what it effects here. I do have planned some changes that will effect some of the utilRegistered* tables and the ini file but not sure when they will be done. There will also be a few changes that shouldn't be visible to anyone using Yapeal but should improve it in several ways much like this change which doesn't really show up in anyway to the outside developers. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Al Coholick
 |
Posted - 2009.07.21 12:52:00 -
[251]
Is anyone working on integrating Eve Central data into Yapeal? If not, I'd like to give it a go.
|

Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
 |
Posted - 2009.07.21 18:02:00 -
[252]
I just added a table to my eve_db and pull the daily csv file in. I was going to work with the API pulls but that is WAY down on my list.
|

Al Coholick
 |
Posted - 2009.07.21 20:13:00 -
[253]
I was actually thinking about using the Mail-push feature. It should be fairly easy to set up a dedicated google email account (or whatever email you choose) and suck the posted mails in from there. Perfect for a cron task.
Also perhaps include an import function for the existing CSV data files.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.07.22 13:24:00 -
[254]
Hi there has been some talk about adding Eve-Central and/or other pricing data but the latest person to talk to me about it is very busy with a couple other projects at this time so not sure if/when he would get any code done. I had some code in the original project that Yapeal grow out of that worked with the CSV feed. You could try the e-mail approach as well if you think you really need minute by minute updated data but the extra overhead and complications getting and decoding the e-mail would probably outweigh the benefits if you don't need that.
If either or both of you would be interested in work on this let me know via my G-mail account from the project and I can add you to the project if you're interested in working on it in a branch. I could also dig up my old code for you to have a look at too. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Al Coholick
 |
Posted - 2009.07.27 13:29:00 -
[255]
Well, I finally got around to working on the Eve Central data this weekend, and it's 95% finished. After looking at the size of the dump files, I decided that the email approach probably wasn't a good idea. I didn't realize just how much data was recorded by Eve Central.
Which brings me to the problem I've come across. There is just SO much data. Over 4 million records just for the first 12 days of January.
I've not really used or studied the data yet, so I'm not sure if there are rows I should be updating (instead of inserting a new row). I see some duplicated rows, probably because multiple people submitted the same data. I'm thinking I should make OrderID an exclusive key, and update any duplicates.
Should I throw away data older than X days?
Any advice?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.07.27 18:09:00 -
[256]
OrderID does recycle every so often so might think of using it and the date/time of the order but you will still end up with dups. In my old code I used the daily CSV and sorted and got rid of any dups in it as I went then when I upserted it to the DB I let MySQL take care of dups between the dailies. How ever you do it make sure you use the one with the latest date/time or you can end up outdated data. Out of all the orders in each CSV I'd say probably 33% were dups with the main trade centers running closer to 75-90% dups at times.
In my old code I had it deleting any record older than a year and really anything older than 3 months is ancient history with Eve but just in case someone want to do some market trend stuff a year might be useful.
Hope that helps. Like I said if you are interested in having a look at my old code let me know it was really rough but did seem to work well. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Al Coholick
 |
Posted - 2009.07.27 18:22:00 -
[257]
Edited by: Al Coholick on 27/07/2009 18:24:11 Here's what I decided to do.
There is a new INI variable called "days_back", and this is used to determine how many days of data to process. Any dump files older than this will be ignored.
Also, duplicate rows (by OrderID) will be updated rather than inserted as a new row.
A preliminary version is ready. Since I don't have SVN write access, here is a direct download.
http://www.greygames.com/yapeal_with_EveCentral.zip
The install process is untested, but the SQL statement to create the new databases required are in the comments of eve_central.php.
There is a new section in Yapeal.ini for the Eve Central specific variables. Be sure to change the values to fit your system.
------------------------------------------- ; Section for Eve Central settings. (required if Eve Central updates are enabled) [EveCentral]
; Only go back X days. Ignore any dump files older than this. days_back=10
; A writable (by crontab) directory for processing EVE Central downloads temp_dir="/home/USERDIR/tmpFiles"
; Name of the****cutable used to unpack Eve Central's "gz" files ; Include the full path if necessary. unpack_util="gunzip" -------------------------------------------
There is a variable in eve_central.php named $maxProcessFiles which specifies how many dump files to process per cron run. Be careful if you increase this value from its default of 1. It takes about 3 minutes per dump file (on my web server, including the file download), and if the the cron job doesn't finish before its next scheduled run, errors will occur. When doing the initial download and import of the data, you may want to increase the frequency of the cron task (10 minutes?), and leave $maxProcessFiles at 1.
One major thing still missing the the cacheUntil feature. So please ensure your cron task doesn't run too often after the initial downloads, to prevent hammering Eve Central.
P.S. Dragonaire, please check your evemail.
EDIT: Oops, I must have been typing this when you replied, Dragonaire. Thanks for the tip about OrderID recycling. I'll have to do something about that.
|

Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
 |
Posted - 2009.07.27 18:28:00 -
[258]
Edited by: Cory Sopapilla on 27/07/2009 18:33:18 Al, you're in our public channel so gimme a shout ;) I've done alot of the work already and we have a corp project going for an API frontend for yapeal. I have all of the csv stuff working already so maybe we could compare notes.
Basically, I grab the entire daily dump and put in a temp table but only allow the newest by date for each orderID per regionID (there are items in jita reported hundreds of times per day). Then I generate a list of unique itemIDs per regionID and delete all matches (1 at a time) and replace with the new orderIDs for that itemID in the regionID. There's lots of other stuff like deleting any that expired, etc.
What I want to do ultimately (on top of this) is pull the xml for mineral prices from the eve-central API so I can get hourly prices on those as well as an option in the front end to request new prices on other things if they have recently sent a new dump to eve-central.
|

Phaedriel
 |
Posted - 2009.07.31 16:10:00 -
[259]
Hi Dragonaire,
I just set Yapeal up on my server after a little messing around with Cron tasks (getting paths etc). I'm now getting an error returned to me. Seems like the database tables are in lowercase and the reference to them in the code are in uppercase.
Is this something you've come across before? Can you see any issues with me just renaming the database tables to how they are referred?
E.g.
yapeal.utilCachedUntil is inthe database as yapeal.utilcacheduntil
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.07.31 17:11:00 -
[260]
Would probably cause you issue when trying to use the installer to update. The normal setting for MySQL is mixed case so I'd look at it's settings on your server myself to see if I couldn't fix that. I do know on Windows they seem to use a forced lower setting but it doesn't seem to cause any problems since MySQL just silent converts everything for you so the mixed case doesn't matter. I may look into adding settings to the DB connections in ADOdb to set for mixed case but you're the first one to have noticed it outside of one of the developers using Windows and I don't think it cause him any problems but let me know if it is and I'll look into it some more. The reason for the mixed case is the match the API as closely as possible and CCP does use mixed case in a very specific way in their naming. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Phaedriel
 |
Posted - 2009.07.31 21:30:00 -
[261]
Okay, I manually changed the names. As you say, I think it's a windows issue. I installed it on my local server and pretty much just copied it to my live server and exported/imported the SQL (yea, bad habit but it works most of the time!).
Just wanting to confirm the the message I'm getting means that all is okay (if so I'll disable the message).
Notice: Yapeal version 803 (beta) 2009-07-16 15:31:27 in (path)/httpdocs/Yapeal/inc/common_backend.php on line 54
(I editted (path) for security reasons but it's the path to the file.
If this is all good then I have to move onto Phase 2 of my application (not for public release, designed with myself and close friends in mind, just a useful tool)
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.07.31 23:05:00 -
[262]
Originally by: Phaedriel Okay, I manually changed the names. As you say, I think it's a windows issue. I installed it on my local server and pretty much just copied it to my live server and exported/imported the SQL (yea, bad habit but it works most of the time!).
Just wanting to confirm the the message I'm getting means that all is okay (if so I'll disable the message).
Notice: Yapeal version 803 (beta) 2009-07-16 15:31:27 in (path)/httpdocs/Yapeal/inc/common_backend.php on line 54
(I editted (path) for security reasons but it's the path to the file.
If this is all good then I have to move onto Phase 2 of my application (not for public release, designed with myself and close friends in mind, just a useful tool)
Thats normal
Quantum Industries is recruiting! |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.01 05:26:00 -
[263]
Yeah once you're sure it working the notice messages can usually be turned off without any problems do leave on the warnings and errors though as they can be helpful when something goes wrong. You'll also want to make sure you didn't turn on the tracing which is off by default
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.03 17:30:00 -
[264]
Ok just ran across something again and decided to add it into Yapeal. You can now view the syntax highlighted source code of any of the PHP files in a web browser. For example: http://localhost/path/to/yapeal/yapeal.php?viewSource=1 will return the highlighted source code for yapeal.php
This is mostly for show but thought I'd add it anyway Developers or someone trying to learn PHP might find it useful. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Aedrine
 |
Posted - 2009.08.17 14:39:00 -
[265]
Hello,
Is it possible to disable the sql part of this API? I just want to manipulate the XML.
Thanks :)
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.17 14:41:00 -
[266]
Aedrine if you just want the raw XML to start with why are you trying to use a library when you can just grab the XML directly from API if that's what you want  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
 |
Posted - 2009.08.17 17:05:00 -
[267]
Edited by: Cory Sopapilla on 17/08/2009 17:08:03 Edited by: Cory Sopapilla on 17/08/2009 17:07:13 Aedrine,
http://wiki.eve-id.net/APIv2_Page_Index is where you want to start. Each of the listed API calls is in the format following:
http://api.eve-online.com/account/Characters.xml.aspx?userID=1234567&apiKey=ABC123
Just start with http://api.eve-online.com and end it with the desired URI example column and fill in the ?name= input arguments. The one above would give the raw xml listing of your 3 characters if you use your own userid and apiKey as an example.
Note the cache short/long/etc timers to see how often you can pull. Don't hit longs every 5 minutes or you may end up being blocked ;)
|

autoland2
 |
Posted - 2009.08.20 15:28:00 -
[268]
Hi,
Stupid question, and yes they do exist :-)
Can I modify yapeal to run from mysql instad of mysqli ?
I tracked down the 2 files in teh installtaion that refence the DB Driver type, but will it work.
The new server we have meets all requirements except the mysqli driver.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.20 18:13:00 -
[269]
If your server doesn't have mysqli I think you'll find there are also other things missing as it's a normal part of the standard build as defined by the PHP org that everyone seems to ignore but as to you're question since Yapeal uses transactions for some things (most of the API table updates) which the mysql drive doesn't support you'll run into trouble. There are reasons that I've set the requirements to what they are and they really aren't that hard to meet given a relatively new and correctly configured server. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Nick Partridge
 |
Posted - 2009.08.20 19:36:00 -
[270]
Ok fair enough. Trying to get answers out of our server host, who support all the features of the system (Yapeal) except that, and there telling us they dont use it and we cant have it :-( what a pain.
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.21 04:38:00 -
[271]
Don't know if it'll help you much with them but point them to this:
Quote: Note: If you are using MySQL versions 4.1.3 or later it is strongly recommended that you use the mysqli extension instead.
from the docs for PHP 5 which you can find here and might also point out that mysql ext is in maintenance only mode now which is shown in the table at the bottom of that page and next step is to drop support for it. Hope that extra information can help you to get them to move out of the dark ages  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.23 02:47:00 -
[272]
I'm a bit confused...
I got Yapeal installed, and the databases have updated... But now what? I'm very new to the EVE API, but I was hoping to create a kind of character sheet on my local home server to get acquainted with it and then move on to a bigger community project.
Yapeal is a library of classes in OOP, correct? Which files should I include to pull the information that I need? I guess it's better to explain what I'm looking to do.
For example, I would like to register my character. I would put the userid and API key in two text fields, hit submit, and a new page should display asking which characters I would like to use. I select one, type in the password I would like to use to log into that character, hit submit, and then be taken to a page that displays some basic character information.
Basically, how would I incorporate Yapeal into a web application? I'm not asking anyone to make the application for me, rather to point me in the right direction on which file(s) have functions that can be included and used to pull different types of information. The problem I'm having with Yapeal is that it seems to only run from a terminal; thus, when I complete step one of the registration process (id and key) how would I exchange this information with Yapeal?
Sorry if this post is hard to understand. It's late and I always have trouble explaining things. 
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.23 04:49:00 -
[273]
Think the problem is you don't understand what Yapeal does for you and how it works. I'll quote from the main page:
Quote: Here's an extend explanation of what Yapeal does since it a little different then the other PHP API libraries people are using.
It not only grabs the data from the API for you but also saves the data into a MySQL database as well. It was made to be ran from a crontab job and works in the background to 'Auto-magically' as I call it, keep the database updated so all you have to do is work with the database tables not the API and XML. It was made to be set and forget once configured.
So basically it's grabbing the XML data from the Eve API and storing it into database tables for you and you get to write the application that takes the data from the tables and shows it to the web browser in some interesting way 
No part of Yapeal works with the IGB as other than the installer/test configurer nothing shows a webpage. There is a little code in all the PHP files now to show their source code in a web browser when passed ?viewSource=1 as part of their URL but that's so people can look at the files with source code highlighting not as any kind of normal operation.
Hopefully that makes things clearer for you. You might also take a look though the wiki as it has some additional information you will probably find useful. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.23 05:19:00 -
[274]
Edited by: Sable Blitzmann on 23/08/2009 05:22:07 The wiki and docs are few and far between, but I kinda understand now how Yapeal works. It it run on a schedule, and when it is, it updates everything in the database to their current true values, correct?
Great, that's awesome. However, I'm still having a little bit of trouble understanding how to initially create a user. I know you can manually add them to the database, but I would have thought there'd be an easier way to add the account to the database, and from that pull the characters, and from that register a character. I'm still trying to wrap my head around that part of the process. =)
Also, the IGB thing - I thought there was an installer version being released for the IGB, but I read through the topic more carefully and figured out that this is no longer the case.
Questions: What is a good time to schedule Yapeal? Once an hour? Once every 10 minutes? Every minute? And how fast is the updating if I use this in a community site where there's the potential of thousands of users being registered and updated? Will this put a heavy heavy load on my or CCP's server? Also, since you're not pulling data directly from CCP every time you access a characters info, but instead pull it from a local database, how accurate will that be (I'm sure that's depenant on how often I run the cron, yes?)?
I think this project is awesome by the way. Keep up the good work 
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.23 07:31:00 -
[275]
Yapeal is made to be ran every minute in a crontab and keeps track of the cachedUntil times itself so it plays nice with the API servers. The data in the database will be update as often as the API allows with a tiny bit of randomness to help disperse bursts of calls to the APIs. As to if the API servers can handle thousands of accounts grabbing all that data that's a better question asked of CCP than of me.
You put your info into the utilRegistered* tables for any characters and/or corporations you want data for. We are currently working on some changes that should make managing available APIs etc in applications easier as all the settings will be in the DB instead of a mix of the DB and the ini file. The installer is last part that needs updated before it's released in the trunk so people can try it. The main programmer for the installer was busy in RL plus his MySQL server had crashed on him and needed re-installed Hope to have new version out this weekend or this next week at latest.
Also look for future version to add a way to call APIs in an 'on demand' basis in addition to the current crontab system. Using that should scale much better for larger web applications while causing less loading of the API servers. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.23 07:55:00 -
[276]
Originally by: Dragonaire Yapeal is made to be ran every minute in a crontab and keeps track of the cachedUntil times itself so it plays nice with the API servers. The data in the database will be update as often as the API allows with a tiny bit of randomness to help disperse bursts of calls to the APIs. As to if the API servers can handle thousands of accounts grabbing all that data that's a better question asked of CCP than of me.
Well, the reason I ask about the server load is because of this: Lets say Yapeal runs every minute. Lets also assume Yapeal is running as a back-end to a web application that serves thousands of EVE's players. Within any given moment, those thousands of EVE players have changing values in their wallet and whatnot. It would seem that to keep the Yapeal database up to date it would have to update thousands of records (maybe more? ) per minute. Now that sounds like a lot to me, but with computers, who knows. Maybe it's nothing. 
Originally by: Dragonaire You put your info into the utilRegistered* tables for any characters and/or corporations you want data for. We are currently working on some changes that should make managing available APIs etc in applications easier as all the settings will be in the DB instead of a mix of the DB and the ini file. The installer is last part that needs updated before it's released in the trunk so people can try it. The main programmer for the installer was busy in RL plus his MySQL server had crashed on him and needed re-installed Hope to have new version out this weekend or this next week at latest.
Thanks for the info; looking forward to testing out the new install.
Originally by: Dragonaire Also look for future version to add a way to call APIs in an 'on demand' basis in addition to the current crontab system. Using that should scale much better for larger web applications while causing less loading of the API servers.
I think everyone would appreciate this. I've looked through the code and it seems like it wouldn't be too difficult to modify bits and pieces here and there so that you can easily include a lot of these classes right into webpage's and applications. For example, and from what I can tell, you already have the classes to call for API info from either fresh from the server or the database using YapealApiRequests(). Any ETA on when something like that would be available?
I really look forward to studying and breaking down this code. You've done a very good job with this cool project. It's been a while since I've been active in coding, and I think I'm gonna start my reintroduction with this 
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.23 15:01:00 -
[277]
If you look through the revision history of Yapeal you'll see where it's gone from a completely procedural library to a nearly completely class based one over time as it has been refined. The changes that I'm currently working on will move it farther in that direction and will add some new or at least better refined options for proxy support and other things. All the changes are coming about because of some need that the development team has thought of, has come up during development in EMPA or one of our other projects, or been brought to our attention by someone using it. Some of the things that are being added to Yapeal now or are looking at adding are things that we said no to in the past. There have been many reasons for saying no to stuff in the past the main ones being:
- The state and design of the code at that time just didn't support it
- The main developer (me) didn't have time to do it
- The problem wasn't explained well or more often mis-understood by the developers
- Developer knowledge and backgrounds.
On that last point in my own case this was only my second PHP project though I've programmed in many other mostly procedural languages on projects before. For some of the other developers this was their first project ever in anything or at least in PHP. We have also had developers with more experience helping along the way too.
Time frame for the 'on demand' code is unknown at this time but is being developed by us for a designer of another project with a large community of Eve users (Thousands of users) as part of a re-coding project on their site. It'll be some time after the current changes we're working on as some of them are needed to make it work. So figure on any where from a week to a month or more depending how that project goes and when we get these current changes done. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.23 16:02:00 -
[278]
Thank you for your helpful and thoughtful responses. =D
Can't wait to see what the devs come up with.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.25 19:30:00 -
[279]
I have another question relating to SVN...
I'm new to SVN, so i don't really know the mechanics. If I were to add my own notes to the source files, and then I updated to the latest revision using `svn up`, would I lose all my edits? Or will ASVN know to ignore my additions and just add yours?
|

Cadeyrn Gwrtheyrn
 |
Posted - 2009.08.26 00:16:00 -
[280]
Originally by: Sable Blitzmann I have another question relating to SVN...
I'm new to SVN, so i don't really know the mechanics. If I were to add my own notes to the source files, and then I updated to the latest revision using `svn up`, would I lose all my edits? Or will ASVN know to ignore my additions and just add yours?
It will try to merge the files, but don't count on it always working
|
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.26 00:49:00 -
[281]
lol, I thought that's what might happen. Thanks! 
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.28 04:49:00 -
[282]
Edited by: Sable Blitzmann on 28/08/2009 04:51:44 I'm still playing around with it. I finally got cURL working on my server so I've been testing a lot of things out. Question: the corp stuff only works if you are the CEO of said corp, correct? Because I put in my characters info AND my corps info into the appropriate util* tables, yet when I go to run yapeal.php, it returns errors.
I assume then that I must be CEO of that corp or have some sort of role (of which I do not have...), thus making the corp API's useless to regular corp members...
Do the character APIs export the characters role in his or her corp so that I can use that to narrow down what options are available for that character? For example, if a regular corp member without roles registered on the site, I do not want to insert anything into the utilRegisteredCorp table. If the corp accountant registers, I only want to enter into the `activeapi` column the API's that character can access.
Also, how does yapeal handle character deletions and role removals? If a character was removed from a role, will yapeal update the database to reflect this?
So many question, I know, but I'm very intrigued with this project.
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.08.28 06:35:00 -
[283]
Originally by: Sable Blitzmann Edited by: Sable Blitzmann on 28/08/2009 04:51:44 I'm still playing around with it. I finally got cURL working on my server so I've been testing a lot of things out. Question: the corp stuff only works if you are the CEO of said corp, correct? Because I put in my characters info AND my corps info into the appropriate util* tables, yet when I go to run yapeal.php, it returns errors.
I assume then that I must be CEO of that corp or have some sort of role (of which I do not have...), thus making the corp API's useless to regular corp members...
Most of the corp APIs need the character to be either CEO or director. I think the only exception is corpMemberTracking which would just have missing data. I'm not positive how yapeal will treat the missing fields.
Originally by: Sable Blitzmann
Do the character APIs export the characters role in his or her corp so that I can use that to narrow down what options are available for that character? For example, if a regular corp member without roles registered on the site, I do not want to insert anything into the utilRegisteredCorp table. If the corp accountant registers, I only want to enter into the `activeapi` column the API's that character can access.
I am rather sure that is data only a director or ceo can get from the corpMemberTracking api. The easiest way would be to try an pull an api that only a director can get and see if it returns an error, 209 Character must be a Director or CEO.
Originally by: Sable Blitzmann
Also, how does yapeal handle character deletions and role removals? If a character was removed from a role, will yapeal update the database to reflect this?
Roles being changed should get updated. I am not sure what it would do for a character deletion.
Quantum Industries is recruiting! |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.28 06:38:00 -
[284]
Some corp APIs can be access with some of the other roles but basically you do need to use the CEO's or a director's full API key to access stuff and the best info for that is to look at info from eve-dev wiki and/or stuff at Chucker's site which are in the sticky above.
As it is now the roles aren't being updated correctly but that will be fixed when I do the next merge from the current branch I've been working on. There will also have some what more intelligent handling of some of the API errors so it can auto deactivate users, chars, corps, and their APIs. I'm hoping to merge the new stuff into trunk on Friday or at latest this weekend. When I do I'll try to post a good list of all the changes that have been made and bugs fixed.
Yes the roles are in the character sheet so you can see what roles and titles they may have in their corps. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

M4g3ll4n
Circle of Shadows Novus Ordo Mundi
 |
Posted - 2009.08.28 07:51:00 -
[285]
Hi,
I have a short question regarding adding of corporation API keys. I would like to add the key of a director of a second corporation. How do I do this?
Just alter the yp_utilRegisteredCorporation table?
Thx in advance, Mag
P.S.: Ypeal is a genious tool, as base for development of own API based applications. Circle of Shadows - Recruiting now www.eve-cos.info |

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.28 08:30:00 -
[286]
Thanks for all the great work Dragon.
I do see one corp API that any corp member can access: `corpCorporationSheet` This just gets basic (and from what I can tell, public) details about the corp. So there is a reason to add a corp to the untiRegisteredCorps, even if that character doesn't have any roles. =)
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.28 18:14:00 -
[287]
OK here the short version of the changes in Yapeal.
- All the Eve API classes have had some code clean done to them
- New abstract classes have been made and are used by the the Eve API classes
- The inc/pull*.php files have been replaced by new class/Section*.php files
- Much of the code dealing with API sections in yapeal.php have been moved into the section files where it belongs now
- Required memory footprint for Yapeal have been reduced by breaking up the larger API upserts into 1000 record pieces instead of one huge upsert.
- Most error and tracing log messages have been updated and should be shorter and more useful
- Yapeal should now use less connections to the MySQL database server by re-using existing connections
- Yapeal now uses SPL Iterators directly in many of the new/updated classes and functions/methods where it didn't before
- New utilSections table was added to database and some new fields were added to the utilRegistered* tables to support the new proxy config stuff
- config/yapeal.ini has been change with many of the settings having been move into new utilSections table to make managing them in an application easier
- Now each char/corp can have their own proxy setting as will as each API section can have it's own default that will be overridden by the individual char/corp one
- Yapeal is now more proactive when it come to dealing with Eve API errors by deactivating users, characters, corporations, or individual APIs of them as needed and logs an error message when doing so
- Yapeal now 'soft' limits how long it will run to approx. 5 minutes
- Many other change that I've forgot
Everyone should make a backup of their DB before updating to this revision of Yapeal, then make another one just to make sure 
Anyone run a revision of Yapeal before about revision 800 will probably have some problems upgrading because of all the change to both the code and DB.
Everyone needs to run install/setup.php from a webbrowser and it should update the DB and config/yapeal.ini for you.
I will try to document the changes more on the weekend. For anyone that is really interested in understanding the code have a look at https://yapeal.googlecode.com/svn/docs/Developer Guide/phpDocs/ where you'll find two version of Yapeal in HTML format.
revision 857 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sable Blitzmann
Minmatar Eve University
 |
Posted - 2009.08.28 19:42:00 -
[288]
Edited by: Sable Blitzmann on 28/08/2009 19:43:04 EDIT: nvm.
Awesome stuff, btw
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.30 18:17:00 -
[289]
Ok here's a list of some bugs that were fixed:
- Sub-tables of CharacterSheet like rolesAt* and titles were not clearing old data. Now the old data is delete before adding new ones so no one just accumulates roles

- Same type of fix was done on several other APIs that had same problem as above with accumulating stuff
- Time out error exceptions, etc. from cURL were not being handled at all in the API files. They are now catching these exceptions correctly
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Teavan
First CityWide Change Bank New Eden Retail Federation
 |
Posted - 2009.08.31 14:17:00 -
[290]
Is it typical to get "Expected before ref/trans ID = 0: wallet not previously loaded." issues when executing yapeal.php with a cron job? It successfully pulled the info on the first execution, and the time difference is not long enough, but I figured yapeal wouldn't try to pull something it knew should be cachedUntil.
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.31 15:41:00 -
[291]
Even if you obey the cachedUntil time sometimes you get that error it's a pain in the A$$ that the Eve API servers sometimes get behind on their accounting for which ones you've got already (I've added all kind of delays, etc to try minimize the number of errors) but sometimes you'll still get a few You'll also get some of those errors if you stop and restart the MySQL server as the utilCachedUntil is stored in memory and is cleared every time you restart it. So to directly answer you question yes it normal to get a few of those from time to time but it should only do it once in a while usually when the API servers are under heavy load or having other issues. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Teavan
First CityWide Change Bank New Eden Retail Federation
 |
Posted - 2009.08.31 16:01:00 -
[292]
Thank Dragonaire ... nice piece of software, very much helped to jump start my latest project.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.08.31 16:34:00 -
[293]
Just was going through my logs this morning and noticed some errors with the new exception code functions Everyone should grab revision 867 BTW Teavan it could have been related to the extra error messages you were seeing as it was effecting updating the utiCachedUntil table. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.01 06:01:00 -
[294]
How can something work without any errors for a week then after merging it into trunk it starts throwing all kind of errors and exceptions Anyway give revision 870 it has the fixes. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.01 16:38:00 -
[295]
Think I've finally fixed a long standing bug with KillLog, WalletJournal, and WalletTransactions walking code where it would throw mostly errors instead of working right. As goes with most errors of this type the fix was simple and easy to do once found 
revision 873 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Teavan
First CityWide Change Bank New Eden Retail Federation
 |
Posted - 2009.09.02 18:38:00 -
[296]
Ok, a few things:
1.) I know I uploaded revision 870, yet when it runs it says 862. Forget to update something?
2.) I can't say for sure it is yapeal, but after an hour or so I can't seem to run yapeal manually, it never finishes. When running it with a crontab every 10 minutes, the entire system would get locked up within 24 hours. Any ideas on what to check? I checked the yapeal_error.log file and it is blank.
3.) Has work already begun on a Corp_MemberSecurity interface? I'd like access to the roles for my project and I can handle writing the file for yapeal if it is necessary, but I don't want to waste my time if its already in the works.
I apologize if any of this has been answered before.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.03 16:12:00 -
[297]
I haven't been changing yapeal.php that's why the revision number doesn't change. That's cause by way svn works I'll have to remember to make minor change to it so it'll update too once in a while As to the locking up problem I don't know why you're having problem as I've been running it even minute in crontab for several days without any problems. I would suggest you setup your crontab correctly by having it run every minute. * * * * * /path/to/yapeal/yapeal.php By not letting it run every minute you're keeping it from doing part of it's job correctly which is pulling the APIs by the cachedUntil times and also it tries to even out server load over time with some randomness which also won't work as well with running it only every 10 minutes.
To get more error logging to see what's going on try these settings in config/yapeal.ini: cache_xml=TRUE log_level=E_ALL|E_STRICT trace_active=TRUE trace_level=2 trace_sections=YAPEAL_TRACE_ALL
That should give you a LOT more logging that may point to where the problem is.
As far as I know no one is work on MemberSercurity if you want to work on it send an E-Mail to the project manager's G-Mail with your G-Mail account and I'll add you to project and we'll setup a branch where you can work on it in the svn. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.04 15:22:00 -
[298]
An issue has been reported with the MemberTracking API in issue 20 only storing the last corp member for each corporation. Thanks for the error report Matthew. You can read about the fix in the issue.
I've also corrected an error that was leaving all the Eve API error XML files in the main cache/ instead of cache/{section}/.
Revision 880 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Garo Hertee
 |
Posted - 2009.09.05 17:00:00 -
[299]
What a fantastically useful library. Thanks Dragonaire. Having set it up and got it running, I hit issue 20. I came on here to report it only to find it had already been fixed. Very nice.
|

Elnar Khad
Minmatar Deathadder Coalition
 |
Posted - 2009.09.06 16:38:00 -
[300]
Let me say, thank you to everyone who has worked on this project. It is very well thought out and will be very useful. I'm coming up against a wall during setup of the scripts. I have followed the windows version of the setup and most things seem to be working. It is correctly pulling down server, map and alliance information, and pulling the characters out of my accounts correctly. The only things that are not getting put into the database are the items that I put into the "ActiveAPI" fields in the utilregisteredcharacter and utilregisteredcorporation tables. Per the instructions, it should be "char" or "corp" and then the name of the api, so I'm putting in items like: Quote: charAccountBalance charAssetList charCharacterSheet charIndustryJobs charKillLog charMarketOrders charSkillInTraining charSkillQueue charStandings charWalletJournal charWalletTransactions corpAccountBalance corpAssetList corpCorporationSheet corpDivisions corpWalletDivisions corpLogo corpIndustryJobs corpKillLog corpAttackers corpItems corpVictim corpMarketOrders corpMemberTracking corpStandings corpStarbaseDetail corpCombatSettings corpFuel corpGeneralSettings corpStarbaseList corpWalletJournal corpWalletTransactions
I am not seeing any errors in the logs, and the yapeal/cache/char and corp folders are not getting xml documents.
I've been staring at this for days and I don't see what I'm doing wrong. Any ideas? Thanks, Elnar
|
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.09.06 17:45:00 -
[301]
Originally by: Elnar Khad Let me say, thank you to everyone who has worked on this project. It is very well thought out and will be very useful. I'm coming up against a wall during setup of the scripts. I have followed the windows version of the setup and most things seem to be working. It is correctly pulling down server, map and alliance information, and pulling the characters out of my accounts correctly. The only things that are not getting put into the database are the items that I put into the "ActiveAPI" fields in the utilregisteredcharacter and utilregisteredcorporation tables. Per the instructions, it should be "char" or "corp" and then the name of the api, so I'm putting in items like: Quote: charAccountBalance charAssetList charCharacterSheet charIndustryJobs charKillLog charMarketOrders charSkillInTraining charSkillQueue charStandings charWalletJournal charWalletTransactions corpAccountBalance corpAssetList corpCorporationSheet corpDivisions corpWalletDivisions corpLogo corpIndustryJobs corpKillLog corpAttackers corpItems corpVictim corpMarketOrders corpMemberTracking corpStandings corpStarbaseDetail corpCombatSettings corpFuel corpGeneralSettings corpStarbaseList corpWalletJournal corpWalletTransactions
I am not seeing any errors in the logs, and the yapeal/cache/char and corp folders are not getting xml documents.
I've been staring at this for days and I don't see what I'm doing wrong. Any ideas? Thanks, Elnar
It looks like your mixing the character and corporation apis. Corporation apis need to be in utilRegisteredCorporation and character apis need to be in utilRegisteredCharacter
Quantum Industries is recruiting! |

Elnar Khad
Minmatar Deathadder Coalition
 |
Posted - 2009.09.06 17:58:00 -
[302]
Sorry I wasn't clear when I made that post. I do have them split appropriately. I just copy/pasted both sets into the forum for review. Am I putting the wrong capitalization/spelling in there? Like I said, I know the api's are pulling appropriate information since I'm getting the character lists in accountcharacters and I did get an error message the other day when I let one of the accounts lapse and had to reactivate it. I'm stumped. Thanks again for the help.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.06 19:03:00 -
[303]
The problem is the docs haven't caught up the the code it seems, sorry about that. Try putting the API names in without adding "char" or "corp" to them that was a change that was made when updating to use utilSections table etc. that just was done a couple weeks ago. I'll look through the docs again and try to get them updated as it seems I missed that. Maybe a little while as I was just up until 5am re-doing Linux on my development machine after making mistake of trying the bleeding edge version of my desktop and still trying to get everything setup right again . -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Elnar Khad
Minmatar Deathadder Coalition
 |
Posted - 2009.09.06 20:08:00 -
[304]
It was the "Getting Started" guide on http://code.google.com/p/yapeal/wiki/GettingStarted
I'll try it out and see if that gets it. Thanks for the quick replies! Elnar
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.06 20:40:00 -
[305]
Guess you missed this: Deprecated - Use web installer
I've updated it to: WARNING Deprecated - Use web installer
but I did update the part about adding APIs to reflect the setting for ActiveAPI also while I was at it. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Pricecheckinaisle Amarr
 |
Posted - 2009.09.08 13:24:00 -
[306]
I did miss that, although even using the web installer, a person would still need to put their API information and the items in the "ActiveAPI" field by hand. Unless there is a different web installer I don't know about. 
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.08 18:09:00 -
[307]
In install/setup.php it does have a test character section to it after the basic config but it only does one char and corp. It wasn't made as a full application just something to help people try it out before building their own app around it 
We are working on adding some wrapper classes around the utilRegistered* table to make it a bit easier for anyone using it to work with them. They are in alpha testing now and should be done within a couple weeks. Also just started on some per char/corp on-demand style API classes that should be useful for apps that don't want, need, or can't use crontab for some reason. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Elnar Khad
Minmatar Deathadder Coalition
 |
Posted - 2009.09.08 18:12:00 -
[308]
My web host apparently did not install the CLI version for PHP (only the CGI) I'm paid up through the year, so I don't want to switch hosts yet. Any idea if I can get this working? Thanks, Elnar
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.08 18:19:00 -
[309]
I know some people have had some luck using Yapeal with CGI instead but it's not something I've done. From what I understand of it you may be able to just use it directly but not sure. Have a look in the issues and wiki for some pointers that might help. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
 |
Posted - 2009.09.14 15:15:00 -
[310]
My table serverServerStatus still shows the last known good API pull rather than a status of the API being offline. Is this something addressed in a newer version I don't have? |
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.14 16:49:00 -
[311]
When they take the API servers off line like that there's no way to get a new status so it doesn't update it again until a new one is available. If you want to know if it's stale also look at the date/time and if it's more then say 15 minutes old it's probably not being updated. Once again this is something to be handled in the application being developed it's not Yapeal's place to be deciding if it should return something other than what the API servers tell it as that would be beyond it's function which is to only return the most complete and current data as possible in a useful format for you to use.
Quote: In computer science, a library is a collection of subroutines or classes used to develop software. Libraries contain code and data that provide services to independent programs.
from Wikipedia
You are the programmer for the 'independent program' that uses it but Yapeal isn't the program it just makes it easier to write one IMHO anyway  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Cory Sopapilla
Minmatar Kiroshi Group Exiliar Syndicate
 |
Posted - 2009.09.15 15:57:00 -
[312]
I know. Was just checking to see if you had put any timeouts to grab an error value or something in newer versions before I wrote it myself ;)
Thanks for the feedback though.
|

Scribbly
 |
Posted - 2009.09.17 02:13:00 -
[313]
Hi guys,
This looks very promising and I hope I can get it to work correctly as have loads of ideas for it. I have been able to get it to pull data from the API as I now have assets, transactions etc. However it does not seem to be updating my characters account balance. I do see the following message
[2009-09-17 01:15:04.070] NOTICE: Message: Upserting 1 records for charAccountBalance File: /xxx/yapeal/class/YapealDBConnection.php Line: 240
and should I be concerned about the following message?
[2009-09-17 01:15:10.686] NOTICE: Message: Peak memory used:2621440 File: /xxx/yapeal.php Line: 200
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.17 05:30:00 -
[314]
The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.
Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.09.17 09:45:00 -
[315]
Originally by: Dragonaire The peak memory use is nothing to worry about that is just there as it says as a notice. If you ever see one larger than about 12 MB do let me know as I've been trying to reduce that and in my testing it's not going over about 12 MB now.
Do you see a record in the charAccountBalance table? If not then there might be a problem. First make sure you've activated that API both in the utilSections->char->activeAPI setting and in the utilRegisteredCharacter. You might also try deleting the record and see if it reappears if it does it's being updated but the API isn't changing which is an issue for CCP to solve 
I would also check the utilCachedUntil table to see if it has an entry for charAccountBalance.
Quantum Industries is recruiting! |

Scribbly
 |
Posted - 2009.09.18 02:53:00 -
[316]
ok I have it working!!! This is the coolest thing since sliced bread!
Whats the chances of finding/getting a table with all the eve items in it? Will let me match up transactions, assets etc
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.18 04:37:00 -
[317]
For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.19 17:38:00 -
[318]
Ok someone has found an error in the charMarketOrders and corpMarketOrders tables that is cause duplicate records to be created. You can read more about it at http://code.google.com/p/yapeal/issues/detail?id=21 and find the fix at http://code.google.com/p/yapeal/wiki/Issue21fix
I'll be releasing an update in a couple days for Yapeal but because of the nature of the error the above instructions MUST be used first or running install/setup.php again will either fail or end up deleting all you data which could be a bad thing on a production application with real data you'd like to keep. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Scribbly
 |
Posted - 2009.09.21 01:31:00 -
[319]
Originally by: Dragonaire For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.
Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.09.21 05:23:00 -
[320]
Originally by: Scribbly
Originally by: Dragonaire For that check out the stickys about the static data dump which you can get in MySQL format and look at the invTypes table.
Do you know if any of these dump table names would clash with Yapeal? Would like to know so I can import it all into the same database to keep the complexities of the queries down
nope, and you can set table prefixes for yapeal tables
Quantum Industries is recruiting! |
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.21 16:13:00 -
[321]
Ok I've deployed the fix for issue 21 to trunk all existing users please make sure to look at http://code.google.com/p/yapeal/wiki/Issue21fix before updating as this revision could cause you problems like lost of data. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

ChriztaneE
 |
Posted - 2009.09.27 10:06:00 -
[322]
Edited by: ChriztaneE on 27/09/2009 10:11:52 Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..
Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?
|

ChriztaneE
 |
Posted - 2009.09.27 10:39:00 -
[323]
Originally by: ChriztaneE Edited by: ChriztaneE on 27/09/2009 10:11:52 Hi. I have a problem with Yapeal, when everything is installed and the setup is finished. Going to the CONFIG menu it keeps asking to update the database, and everytime I UPDATE it takes me to the config menu, but it only sends me back to the update menu again, when hitting any buttons..
Also hitting the command prompt xxx\php5.3.0\php.exe -f xxx\yapeal.ph gives an error in common_backend.php on line 62 <- maybe these problems is connected?
Found out it has to do with the date in yapeal.ini.. Tried to change this from $Date:: 2009-08-28 19:31:54 #$ to Date .. Then cmd says im missing all elements in yapeal.ini (Cahce, Databse and Loggin)
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.09.27 19:47:00 -
[324]
Sound like you maybe try to use an yapeal.ini file from before the latest changes to it's format. I would suggest backing it up and then deleting it and try running setup again and see if it doesn't work better for you. The installer should have been able to update it for you but not sure how well that was tested.
On a related note look for Yapeal to be moving to a totally new and different installation and configuration system soon(tm). It will have a multi-platform GUI and CLI installer instead of the current drop into web directory and configure system. The current system will be kept in place for now but long term it will need to either be rewritten or just dropped if it is determined that it isn't needed anymore. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Zebullon
Gallente Pulsar Inc. Tau Ceti Federation
 |
Posted - 2009.10.03 12:16:00 -
[325]
I have the same problem as ChriztaneE and I can't resolve it... The problem is certainly with the date or the release version...
The error message when I run the yapeal.php: Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62
In my yapeal.ini file, I have this data : date="$Date:: 2009-09-02 17:59:29 #$" version="$Revision: 849 $"
If I change the date and version whith the data in error message, it's the same think. When I delete yapeal.ini and run setup.php, it's again the false data...
I think it's OK for the data base (70 tables created), and I've filled the table correctly...
could you help me ?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.10.03 12:48:00 -
[326]
Originally by: Zebullon I have the same problem as ChriztaneE and I can't resolve it... The problem is certainly with the date or the release version...
The error message when I run the yapeal.php: Notice: Yapeal version 898 (beta) 2009-09-21 18:06:41 in xxx\inc\common_backend.php on line 62
It always throws that notice, if there are no other problems and your getting data into the database, do not worry about it. Its just to let you know it has ran.
Quantum Industries is recruiting! |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.03 19:13:00 -
[327]
Notice: Talks about something that someone may find interest to look at
Warning: Something probably went wrong but the program could continue to run. Can mean an bug in the program or just some bad input and output (GIGO)
Error: Something went wrong and the program stopped running. Usually a bug in the program that needs fixed. Can be cause by either logic error or getting unexpected data that wasn't taken into consideration by programmer in program which probably needs to be fixed also.
Exception: Similar to a warning and usually used to handle something that might cause an error if it hadn't been caught by the programmer and handled in some way.
Uncaught exception: This is a exception that happens when the programmer some how missed handling an exception but was smart enough to add something to let him know he missed it.
From the above the only ones that normally need to be worried about are warnings, errors, and uncaught exception and be reported as they will need to be fixed or at least figured out why they have happened. Notices and exception are mostly use to help figure out where something want wrong or right, or just so you know something is really happening  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Zebullon
Gallente Pulsar Inc. Tau Ceti Federation
 |
Posted - 2009.10.04 06:59:00 -
[328]
OK, thanks form the explication. My configuration should be OK because the file TranquilityapiseverServerStatus.xml is correctly downloaded... But I have any other file... (I have any notice for the other files in logs)
I have certainly misinformed the rows in Database, but I don't now why... In the table utilregistereduser : I have filled the full and limited api and userid correctly, and isActive=1. In the table utilregisteredcorporation : I've only filled AccountBalance in activeAPI for the test, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ? In the table utilregisteredcharacter : I've only filled WalletJournal in activeAPI for the test, corporationName, name, userID, characterID and corporationID are filled and isActive=1. Do I filled the field proxy ? with "http://api.eve-online.com/%2$s/%1$s.xml.aspx" ? In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.04 16:58:00 -
[329]
The proxy can be left blank except if you want/need to use one. The default is to use the normal API servers if not set.
Quote: In the table utilconfig : fields charAPIs and corpAPIs are null... is it normal ?
If you didn't run the config/install that would be normal and that table isn't use by anything but it and can be ignored.
Do make sure in the utilSections table you've add the APIs to activeAPI that you want to get for each section as they act as an admin override to what utilRegisteredCharacter/Corporation are allowed to do and of course isActive needs to be set in it too.  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

ChillingEchos
 |
Posted - 2009.10.04 17:53:00 -
[330]
Was wondering if anyone happened to have the solution to working around the killLogs flag field being set to zero except when its drones or cargo bay?
Found in : /char/KillLog.xml.aspx
Results : <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="3520" flag="0" qtyDropped="3" qtyDestroyed="1" /> <row typeID="12076" flag="0" qtyDropped="0" qtyDestroyed="1"> <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="12259" flag="0" qtyDropped="0" qtyDestroyed="1" /> <row typeID="1236" flag="0" qtyDropped="2" qtyDestroyed="1" /> <row typeID="2032" flag="0" qtyDropped="1" qtyDestroyed="1" /> </rowset>
Notice how all the flags are 0. in the more broad list there are only flag number 87 and 5 of which are drones and cargo bay items.
Not sure if I have a glitch somewhere or maybe everyone else has found the work around? Or, perhaps like most of my related troubles it is something literally staring me in the face and I just dont see it.
While I'm at it. The yapeal sql for kill data uses the 'lft' 'lvl' 'rgt' fields to show the items. I may need to see if anyone can help me understand the intended use. I really cant help but to think that I may be having a glitch in my Yapeal install cause there are no "apparent" order to the results a couple will be ok and right in terms of how they were fitted on the ship then viola, gets scattered all over the place.
I could use a bail me out our if anyone got a minute and knows what I am doin wrong and can maybe help me figure out what to do with the flags ( god knows having to manually install slots of each item would be awful )
Any help appreciated, and on BIG round of applause to yapeal crew, brilliant work!
Cheers
|
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.10.04 20:41:00 -
[331]
Originally by: ChillingEchos Was wondering if anyone happened to have the solution to working around the killLogs flag field being set to zero except when its drones or cargo bay?
Found in : /char/KillLog.xml.aspx
Results : <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="3520" flag="0" qtyDropped="3" qtyDestroyed="1" /> <row typeID="12076" flag="0" qtyDropped="0" qtyDestroyed="1"> <rowset name="items" columns="typeID,flag,qtyDropped,qtyDestroyed"> <row typeID="12259" flag="0" qtyDropped="0" qtyDestroyed="1" /> <row typeID="1236" flag="0" qtyDropped="2" qtyDestroyed="1" /> <row typeID="2032" flag="0" qtyDropped="1" qtyDestroyed="1" /> </rowset>
Notice how all the flags are 0. in the more broad list there are only flag number 87 and 5 of which are drones and cargo bay items.
Check to see if its coming from the API this way. You can turn on file caching and look at it in the cache folders.
Originally by: ChillingEchos
While I'm at it. The yapeal sql for kill data uses the 'lft' 'lvl' 'rgt' fields to show the items. I may need to see if anyone can help me understand the intended use. I really cant help but to think that I may be having a glitch in my Yapeal install cause there are no "apparent" order to the results a couple will be ok and right in terms of how they were fitted on the ship then viola, gets scattered all over the place.
Look in the yapeal wiki about Hierarchical Data. The examples are for assets, but it applies to the killLog items as well.
Quantum Industries is recruiting! |

ChillingEchos
 |
Posted - 2009.10.04 21:33:00 -
[332]
Ty for the info on hierarchy data, may take me a bit to still wrap my head around that (been one of those weeks)as I still fail to grasp the idea. no worries there...
as for the cache, yes, I already looked into that and yes the data is cached that way. the rowsets show in previous example came from the sources found on eve-dev, I found it kinda interesting that their examples showed the exact same results as do mine. |

ChillingEchos
 |
Posted - 2009.10.04 21:43:00 -
[333]
mk, maybe spoke too soon. I figured out the 'lft' 'rgt' ordering kew, thats kinda neat. |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.05 00:22:00 -
[334]
Just like with assets the order of the items and locations isn't sorted come from the servers. It's common to have assets say in corp hangers at a station be in the order item, item, item, container, item, container, ... From want I've seen the killlog seems to do the same thing. The only constant is if something is inside something else it will always be inside it's parent container but even between 2 different pulls the order of the containers and/or the things inside them can change. Welcome to the world of most DB systems where if you don't add any 'order by' clause you get it in some random order that even the DB designers couldn't tell you how it decided Since we don't have anyway to pass an 'order by' to the API server and CCP didn't include any in their queries it was decided that Yapeal would 'pass the buck' on this too and let the developer using it decided how to handle the order after the data is in the local DB At some point I might re-visit that part of the code and see about re-ordering at least the container vs the stacks of stuff. Probably it would end up like: container, container, ..., item, item, ... but doing that is a very low priory for now and unlikely to be done for a long time if ever. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

ChillingEchos
 |
Posted - 2009.10.05 22:40:00 -
[335]
Mk, no problems there, thank for you responce.
So any idea where things might be going out of place as far as the flags?
Cheers |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.06 05:18:00 -
[336]
Yapeal just stores them as it gets them. The flags are the locations where stuff was from which you can check what each means in the table here. http://wiki.eve-id.net/API_Inventory_Flags -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Scribbly
 |
Posted - 2009.10.15 03:06:00 -
[337]
Edited by: Scribbly on 15/10/2009 03:16:04 Hi guys
I have been trying to reset up yapeal and have been having some difficulties.. I redownloaded by svncheckout and when browsing to setup.php I get the following error...Any ideas?
Fatal error: Call to undefined function elog() in /xxxsecret/install/setup.php on line 90
Has elog.php been removed?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.15 07:06:00 -
[338]
Seems you've found some kind of bug that causing an uncaught exception and elog isn't being included soon enough to log it which cause another error Try adding these lines to install/setup.php right after line 48 and see if at least it'll log the actual error that you're having so we can properly fix it so that exception gets caught.
/* * Require elog file */ require_once('..' . DS . 'inc' . DS . 'elog.php');
Once we have a better idea what's the root cause of error I'll add fix to trunk for everyone.
-- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Ariacus
 |
Posted - 2009.10.15 07:22:00 -
[339]
Was keen to try this out but getting the same error. On my setup, it appears line 56 in common_paths.php has "$dir = realpath($incDir . '..');" $incDir doesn't have a trailing separator, so changing it to this seems to work (so far...) "$dir = realpath($incDir . DS . '..');" I'll post a note on the Google Code site if setup seems to work 
Originally by: Scribbly Edited by: Scribbly on 15/10/2009 03:23:52 Edited by: Scribbly on 15/10/2009 03:16:04 Hi guys
I have been trying to reset up yapeal and have been having some difficulties.. I redownloaded by svncheckout and when browsing to setup.php I get the following error...Any ideas?
Fatal error: Call to undefined function elog() in /xxxsecret/install/setup.php on line 90
Has elog.php been removed? or common_paths.php changed so much that elog.php is no longer loading? Please help...I destroyed my old copy when install it :(
 |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.15 16:00:00 -
[340]
Thanks Ariacus for finding the bug seems when I committed that last one the changes I was making didn't all get saved to disk before I did it I was trying to make sure I had a good 'off site' backup of my work before going on a trip in case something happened to the laptop I've been using as main development machine. As usual when doing those things in a hurry something got missed 
revision 904 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Scribbly
 |
Posted - 2009.10.16 01:01:00 -
[341]
Guys.... Thanks for fixing that :)
I would like to make a donation of some kind? iskies ok? This app is just soo good, hope you guys continue to work on it. I imagine the API will only expand with the improvements CCP will be making with ingame mails, calendars, Dust 514 integration etc
|

Nick Partridge
 |
Posted - 2009.10.16 11:43:00 -
[342]
Hi Dragonaire.
A Quick question if I may. Is there a way to get yapeal to autocheck during the API update cycles and update the details in utilRegsitered tables.
For instance a character changes corporation etc. ?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.16 16:37:00 -
[343]
Quote: Is there a way to get yapeal to autocheck during the API update cycles and update the details in utilRegsitered tables.
It does do some changes now. Example if a eve account isn't paid up and the APIs aren't available it does deactivate the user, chars, corp for that one so you don't get loads of API errors from the servers, etc. As to having it update them with corp changes etc. there are several problems with that ie how do you handle when they change corps and in the old corp they were a director and use in RegisteredCorporation but in the new one they aren't or in their new corp some other char is set to do it should their information over write the existing? Depending on the application the answer can be different and that just one example. That why I've left those types of things out of Yapeal as it needs to be decided at the app developer level what to do and not in the library. I only very recently changed it to change isActive based on API errors because I'd changed the code in a way that it wasn't really possible to handle it any other way any longer. For some more example of why not to make how Yapeal of even your app to depend on the API for that type of stuff just look at the several thread in the forums here where people were using the APIs to add and remove people from their corp/alliance forums and when the API was down for patches etc everyone was dropped from their forums include in some cases the admin user One reason I took a path that used isActive was I didn't want a bug or any type of logic error on mine or someone else's part to be able to screw those tables up because they are so important to how everything works. It's one thing to use the API information to say prompt an admin that they should update the information and even offer to do it for them but to do so without their knowledge is asking for problems IMHO  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Nick Partridge
 |
Posted - 2009.10.17 10:54:00 -
[344]
Yeah fair point.
I can write a back end checker to run as a cron job for it and just disable the inputs.
Just thought i would check i wasnt missing an intended function :-)
Damn its good. I just need to integrate that chaps additional eve central bits and its completed for me :-)
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.10.27 18:32:00 -
[345]
Hi all, Thought I'd let everyone have a look at something I've been working on. I've been working at a replacement for the current install system used by Yapeal.The current system was largely the work of Satis Iqulenax and has been a great help in making Yapeal easier to install and setup which I have no doubt helped to make it more popular. Satis has done a great job with it and has been one of the best programmers I've worked with and has done a good job keeping up with the very demanding work load in Yapeal and not just on the installer but help on many other things with Yapeal. Unfortunately Satis has had to move on to some other Eve related projects for his corporation and others.
That leaves me with the task of keeping the installer up to date and change it as Yapeal changes that Satis use to do. In getting up to speed on the code it reminded me of several things I'd always want in the installer but we'd never got around to doing. One thing that had always bothered me is it was web base but Yapeal is really a library that is meant to be run from a CLI. Nothing in it required a web server except the installer and there was no install/configure help if you did install it on a computer without a webserver. So after think on that and some other issues with it I decided to go a different way and switch to a commercial installer that provides free licenses to open source projects. It's called Bitrock InstallBuilder and I release a early ALPHA test installer examples in the download section of Yapeal's website for people to try. I need to cut this post short as I'm running late for work but I would like some feed back on what people think of it so far. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.10.31 18:38:00 -
[346]
thanks for the package...elegant.
just went through a successful svn install.
i can download char data for multiple accounts
but i cannot download corp data.
none of the yapeal logs show any errors (only 'date_default_timezone_set() function' missing)
the eve API access log does not show any attempt to get corp data.
utilRegisteredCorporation has a record with the proper charid ie priveleges, it is set active.
what am i missing? can someone point me in the right direction?
thanx
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.01 06:22:00 -
[347]
Make sure you're running at least PHP version 5.2.1 or later and that the date extension is installed. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.11.01 07:28:00 -
[348]
thanx for the response.
topic: no corp data download
phpinfo(): PHP Version 5.3.1RC3-dev
phpinfo() - Date Default timezone Europe/Berlin (i've used the timezone function in some of my own coding so it seems to be installed)
yapeal db: activeapi field in corp record: AccountBalance AssetList MarketOrders WalletJournal WalletTransactions
where do i go from here?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
 |
Posted - 2009.11.01 08:47:00 -
[349]
Originally by: KtoJest thanx for the response.
topic: no corp data download
phpinfo(): PHP Version 5.3.1RC3-dev
phpinfo() - Date Default timezone Europe/Berlin (i've used the timezone function in some of my own coding so it seems to be installed)
yapeal db: activeapi field in corp record: AccountBalance AssetList MarketOrders WalletJournal WalletTransactions
where do i go from here?
Is the associated character in the database? also try setting it to active and see if it pulls your corp data? Also check the UtilSections table.
Quantum Industries is recruiting! |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.01 08:49:00 -
[350]
Look at activeAPI, isActive in utilSections as it will override utilRegisteredCorporation. Make sure you increase the logging also as it might give more information about what's going wrong. Just to let you know Yapeal hasn't been tested with PHP 5.3.x at all so it could have something to do with that as well. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.11.01 09:30:00 -
[351]
thanks to the 2 of you.
Quote: Look at activeAPI, isActive in utilSections as it will override utilRegisteredCorporation.
this was not set to 1.
the best-
|

Nevangalar
 |
Posted - 2009.11.03 13:50:00 -
[352]
Hi there, first of all great AP!
Now i need a bit help.
After installing i got this error: Warning: PHP Startup: Unable to load dynamic library '/opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_xsl.dll' - /opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/php_xsl.dll: cannot open shared object file: No such file or directory in Unknown on line 0
On a centos 5.2 linux server i need some .dll 's ?! Erm..
Someone got an idea?
/Nev
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.03 15:09:00 -
[353]
My guess is you some how ended up with a php.ini file made for PHP on Windows onto your Linux server. Try changing any lines that look like extension=php_xsl.dll to extension=php_xsl.so and see if it works. This is more a problem with your PHP setup then having to do with Yapeal and might be better to get help on a Centos forum for it. BTW Yapeal doesn't use XSL so could just comment out that line but you'll probably still have some other problems if your php.ini file isn't right. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Liam Fremen
Insurgent New Eden Tribe Systematic-Chaos
 |
Posted - 2009.11.05 08:21:00 -
[354]
Hello m8
My corporation is using this tool from precisely 1 year, even if we never followed the updates correctly we have a lot of data for developing our internal softwares.
Now i have a big problem, i have moved all my stuff on a new webserver, sadly it runs plesk 9.2 and php 5.2.0, yapeal say that 5.2.1 is required... since i have spoke with the web server provider and they refused to update the php since it's "linked" to the plesk installation and sadly, i must keep plesk running smoothly, there is any way to make yapeal work on php 5.2.0?
Thanks
-- Systematic-Chaos, Executor |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.05 18:08:00 -
[355]
Glad to hear you've found Yapeal useful.
It's been a while since I looked at why I set 5.2.1 as minimum but I believe it was because there's a bug in SimpleXML that was cause problems with any version before that. Since all the API parsing is done with SimpleXML it would make it hard to work around. It is possible that changes I've made to Yapeal since then have made the problems I was having go away but I think it was something that couldn't really be worked around or I would have done so at the time of course.
There is another way for you or anyone else to work around problems like this with your hosting sites CHOOSING to put your site at risk by staying with older versions that have know bugs and security issues. If you have the HD space you can install your own copy of PHP. This can work with Yapeal because it's really a console application and you can just use a full path to PHP in the crontab. I.E. something like
* * * * * /path/to/private/php /path/to/yapeal/yapeal.php If you decide to go that route make sure the version of PHP you get is made for your host's distro version or is statically linked so it can run anywhere. One place you can find statically linked versions of a full LAMP (Linux Apache MySql PHP) stack or WAMP (same for Windows) is at http://bitnami.org/ which is made just for these types of problems to help you work around them. There are other similar packages out there but I found this one because it uses the same BitRock InstallBuilder that I'm now planning on using as Yapeal's installer once I'm finished learning to use it.
Hope this gives you some ideas how to go forward from here. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Liam Fremen
Insurgent New Eden Tribe Systematic-Chaos
 |
Posted - 2009.11.06 14:15:00 -
[356]
Edited by: Liam Fremen on 06/11/2009 14:22:18
Originally by: Dragonaire Glad to hear you've found Yapeal useful.
It's been a while since I looked at why I set 5.2.1 as minimum but I believe it was because there's a bug in SimpleXML that was cause problems with any version before that. Since all the API parsing is done with SimpleXML it would make it hard to work around. It is possible that changes I've made to Yapeal since then have made the problems I was having go away but I think it was something that couldn't really be worked around or I would have done so at the time of course.
There is another way for you or anyone else to work around problems like this with your hosting sites CHOOSING to put your site at risk by staying with older versions that have know bugs and security issues. If you have the HD space you can install your own copy of PHP. This can work with Yapeal because it's really a console application and you can just use a full path to PHP in the crontab. I.E. something like
* * * * * /path/to/private/php /path/to/yapeal/yapeal.php If you decide to go that route make sure the version of PHP you get is made for your host's distro version or is statically linked so it can run anywhere. One place you can find statically linked versions of a full LAMP (Linux Apache MySql PHP) stack or WAMP (same for Windows) is at http://bitnami.org/ which is made just for these types of problems to help you work around them. There are other similar packages out there but I found this one because it uses the same BitRock InstallBuilder that I'm now planning on using as Yapeal's installer once I'm finished learning to use it.
Hope this gives you some ideas how to go forward from here.
I'm very sad about this issue since i'm loosing data even right now being 1-2 days that yapeal is not updating stuff... :(
Considering the actual situation, we could install ONLY a new debian version of php, under a different account, and just running yapeal over it... i don't like at all this situation.. i would prefer a different approach, considering i have a windows server 2008 machine with mysql installed could be a viable option to use your "windows" version and run it under the windows machine? actually the software that we use for corp management is written in asp.net, and i used to take data from the linux machine on the same net.
Can you give me some suggestions on how make yapeal work on my windows machine? i have windows server 2008 and IIS7 with php 5.2.11 installed (but not yet configured).
PS: do you have any other contact for speaking with you? i need to ask you some questions.. thanks
-- Systematic-Chaos, Executor |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.06 19:21:00 -
[357]
Best way to contact me direct for stuff you don't want to have in the thread would be through G-mail to the Yapeal project owner's account and we can get together via G-talk etc from there.
To run Yapeal on Windows I would suggest you install the stack from http://bitnami.org/ which has Apache, MySQL, and PHP and I've done some test on and seems to work. The other option is the setup as outlined on the Yapeal wiki as it's also been tested and work though some of the instructions maybe a little out of date.
Yapeal may work with what you have already with IIS7 but it is an un-test setup. Remember the only part of it that needs a webserver at this point in Yapeal is the old installer and you can do everything it does manual instead if need be.
Updating from a year old version of Yapeal to the current version I'm sure can be done but is not going to be easy depending on which tables you are using etc. There has been several updates to the DB table structures etc which will have to be worked out but can be done by anyone that is good with MySQL DB design. My first suggestion would be to backup your current DB and then back it up a couple more times some where else just in case then put together the SQL needed to move the data from the old DB into a new one with the current table setup. I can help provide some pointers on that part but it probably would be best if you have someone else to help you with that as my time is somewhat limited right now.
BTW stay with using the trunk from svn as the other download versions are "ALPHA" and not ready to be used in a production server really as it doesn't fully install and setup Yapeal and was only put out for people to make comments on what they thought of it etc. I'm still working on it and hope to finish something that can be use soon(tm) but I've been limit on time to work on it and want to make sure it's as bug free as can be before I try have people switch over to it as an option. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.15 02:21:00 -
[358]
Hi everyone, After doing an upgrade from OpenSuSE 11.1 to the new OpenSuSE 11.2 I started noticing some new messages in the logs about time zones not being set etc. Don't know if it just related to something in PHP5.3 which I'm now running or (more likely really) that there's been a small change in the default php.ini file they use but it has highlighted something I was not explicitly setting either for PHP or in MySQL connection that probably should be. I've now setting both to use UTC/GMT which should take care of any issues it might have been causing.
In other news the new installer is coming along nicely if a bit slower then I had planned. I've been adding checks that we never did/thought of before in the old installer but instead were making assumptions about. I'm trying to keep the simplicity from the old while adding a lot more options for those that want/need the extra control which isn't an easy task I'll try to have something that could be called an early beta out in the next few weeks as RL allows.
revision 919 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.11.15 09:36:00 -
[359]
i think this is a php 'thing'. i remember getting some time zone messages from Yapeal.
how to u like the 'dolphin' ? ;) i liked it so much that i switched to gnome. lol
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.15 19:53:00 -
[360]
I've been using openSuSE from when they were still just SuSE (version 5.x) and have learned to adapt as it changes. I've always preferred KDE but do use some apps from Gnome too. One reason I've always liked openSuSE is I don't have to choose to only use one or the other like some other popular distros make you do. Dolphin works good once you understand it and tweak it to your liking. I have to do the same with Windows etc to as the common defaults are just stupid IMHO. I've always liked this little commentary about OSes and using them  http://www.zyra.org.uk/os-air.htm
I will say that 11.2 is much improved over 11.1 was and other than having to download the driver for my video card before my desktop worked correctly the install was very easy. I was able to have everything mostly tweaked to my liking and able to get back to doing useful stuff within only a few hours where often it can take me a couple days with Windows  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.11.16 20:56:00 -
[361]
you've got a headstart on me. started with mandrake and then joined suse in v8.0. had always used kde until opensuse v11.1. i think it was kde v4+ that broke my sound so i went gnome and retro to suse v11.0. maybe it's time to look at 11.2
http://www.zyra.org.uk/os-air.htm - great analysis :)
by the way, i've referenced Yapeal on a small eve blog, recently started. seems to be getting some hits. :)
http://evegamer.ch/caveat-emptor/sandbox under the 'eveAPI Trader Project -RollYourOwn' post.
the best-
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.17 05:22:00 -
[362]
First, thanks for the kind words and that's an interesting looking Blog you've got started there I've BM it and will try to keep up with it.  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.19 19:21:00 -
[363]
New 'alpha' installer versions of Yapeal are available for testing in downloads. DON'T use any of these for production servers yet but do need feedback from anyone that tries them. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.20 19:00:00 -
[364]
... Continued
- If you choose 'Advanced' before you'll now have several more pages where you can change other settings that can be found in yapeal.ini which like the last page will default to either your current config/yapeal.ini or the ones from config/yapeal-example.ini
- Now it is ready to actually unpack everything and put stuff where you told it to which will take only a minute or so. If the database doesn't exist it will also be created for you.
- The last page gives you an option to view the very outdated README file and your instill should be done and you can start testing/using it.
I'll try to get a more complete walk through done on the wiki or hopefully someone will offer to make one for me If you're interested please contact me.
Also please report any bugs/problems you have so I can look into them. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.27 10:13:00 -
[365]
I thought I'd let everyone know I've been working on a new branch for Dominion and I've added the new APIs for char and map sections already but will wait to release it until after I had a chance to do a little testing before merging it into trunk/. I should be done with it within a couple days after the API servers come back up from the Dominion release. I'm going to wait until the final release notes to see if I need to change any of my caching code to deal with the new ideas they are talking about use with some of them. I don't think it will really effect Yapeal much because of how it works but time will tell. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
 |
Posted - 2009.11.29 11:41:00 -
[366]
I would like to make a suggestion.. nothing big or feature wise just something to hopefully make it work better.
In yapeal.php
To determine if it is a browser or the command line running the script you are currently doing
if (PHP_SAPI == 'cli')
Now this might always return the same thing depending on how the server is setup. So I recommend you change it to: if ($_SERVER['SHELL'] != NULL) From what I have see this will return something like "/bin/sh" if it is the command line and browsers will return null.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.11.30 01:35:00 -
[367]
Where it's using that it has to be the CLI SAPI and doesn't make sense to check any other way. Only times that's used is when running CLI and passing in params to it otherwise it only pays attention to it when deciding if it should also output log messages to the terminal or not. I believe with your way it would run into problems under Windows since $_SERVER['SHELL'] isn't set there outside of when using CGI in web server. The method I use is what is recommend by the people that wrote PHP. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
 |
Posted - 2009.12.01 18:24:00 -
[368]
There are other variables that it would output any ways if you don't want me to suggest things for compatibility then I wont. Just saying that some servers will return the same thing whether it is run by the CLI or via a browser.
I looked it up on the PHP website to: http://www.php.net/manual/en/function.php-sapi-name.php#89858
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.01 18:27:00 -
[369]
Ok I've had a chance to try my Dominion branch and seems to work after a couple minor fixes so I've merged it into trunk. You'll probably have to add the new API names into your utilRegisteredCharacter tables manually as I'm not updating the old installer for them since I'm hoping to have it replaced soon(tm). Same goes for new SovereigntyStatus table in map section. It should add/update all the tables right but let me know if it doesn't.
revision 935 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Redick
Minmatar Nex Exercitus IT Alliance
 |
Posted - 2009.12.02 00:34:00 -
[370]
Is there a list of "new API's" supported by this version of Yapeal that we can manually add? I can't seem to sort out which are new and which are old. Respectfully,
Re****
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.02 05:29:00 -
[371]
You can look at this DevBlog for more info on the new APIs but I've also update the wiki page for Yapeal with the new ones that have been added. Of course there's also info on them at http://wiki.eve-id.net/APIv2_Page_Index as usual. Basically they added 4 new ones and changed 2 others and one of the updates didn't effect Yapeal at all because somehow that field was already missing in the StarbaseDetail API and had never been caught by anyone. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Rottw Adleweh
 |
Posted - 2009.12.02 09:57:00 -
[372]
What is the easiest way to update yapeal?
To install it on my server I used an export of the SVN as I can't use any of the installers on my Unix box. I used the setup.php in the installer directory to get the database sorted out, but how can I now get the new API tables in the current database and if I again export the svn can I just copy it over the existing dir?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.02 17:27:00 -
[373]
Just do a svn up then svn export --force over the old copy should work fine as that's how I usually do it during development also To get the new tables into the DB you should be able to just run install/setup.php again and it'll update/add the tables for you. If for some reason it doesn't seem to work let me know and I'll look into it.
Quote: ... I can't use any of the installers on my Unix box.
Just wondering why you couldn't? In this case no one should be using them as they aren't updated yet for Dominion and are really in a ALPHA state anyway but I should have that fixed soon as well. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Rottw Adleweh
 |
Posted - 2009.12.02 21:10:00 -
[374]
Originally by: Dragonaire
Quote: ... I can't use any of the installers on my Unix box.
Just wondering why you couldn't?
Because FreeBSD doesn't run linux binaries out of the box. I can install linux compat, but don't want to install things I don't really need.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.03 05:47:00 -
[375]
Ah Ok that make sense then. BTW if you would like I can have it build for that as well I think but didn't have anyway to test it on so didn't do so. Also didn't know anyone was running it on BSD either Good to know it works on it as well though not surprised since both are very similar in most ways that count. If you'd like to give it a try send me a E-mail to my G-Mail account that you can get from the project and I'll send a build to to try. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Rottw Adleweh
 |
Posted - 2009.12.03 07:24:00 -
[376]
Nah, no need for the installer, works like this pretty well.
Something I came across during initial installation thought:
step 1: navigate to <yapeal-host>/install/setup.php step 2: set initial database credentials step 3: setup does creating all the tables and stuff and says its done step 4: go back to <yapeal-host>/install/setup.php to check other things/update database ----- At this point you get a login screen, but the password has never been set.
I expected that the password thus was set to admin or so. But it turned out to not been set at all, so it is impossible to log on.
At first I simply disabled the line in the phpcode that checked the password and substituted it with a line that is aways true. That let me get through the setupscreen where you can set the password. For some reason it didn't work either, but it showed me that I had to set the password in the database, but the field doesn't initially exist. So it took a while to figure out where to set the pw and how to make sure I can login, because that wasn't possible until manually added a record called: [password][md5(passwd)] in the utilConfig table.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.03 09:19:00 -
[377]
Yeah I've ran into that as well. It seems to be using a blank password or something even if you don't set one. I've thought about trying to fix it but since I'm changing away from using setup.php etc and going to be doing most, if not all of that, in the new installer I've not bothered trying to find it. I'll have something else to use for those that still install Yapeal from svn in the future but it will be different and designed for an application developer to use during testing and to learn what they need to do to manage accounts in their own apps. I do not plan to have it be web based since Yapeal itself isn't directly. I'll probably design something for the command line that using some PHP classes that should be easy to integrate with a web application as well. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Labrena
 |
Posted - 2009.12.03 21:08:00 -
[378]
I just tried updating to the 935 from a previous release.
It did not add the new mail/notifications tables.
How do I add the new tables and grab the data?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.04 15:54:00 -
[379]
Are you still having problems? Both are working for me. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Labrena
 |
Posted - 2009.12.04 18:23:00 -
[380]
Edited by: Labrena on 04/12/2009 18:24:15 Yes, I checked this morning.
They are the only 2 that stopped pulling data. Last entry for them was before the server went down for the patch on Dec 1st. All of the others are updating.
I removed them, re-added them to active and still nothing.
I did a new install for another character/corp, and that one is working correctly.
But the mail one will still not pull the corp WalletJournal or WalletTransactions.
Also, I could not get the setup to add the 4 new tables for the new API's. I just copied them from the other table I setup through.
|
|

Seraphina Oriana
The White Rabbits The Gurlstas Associates
 |
Posted - 2009.12.04 22:30:00 -
[381]
Okay, I've just installed the latest version from the svn - I've got it installed, and I can see all of the database being successfully made, and it's now going to setup.php and telling me there's a database update, I click update, it says à.
Progress Database: Connecting TolocalhostConnected Database: Update Tables Fromutil.xml fileDone Database: Update Tables Fromaccount.xml fileDone Database: Update Tables Fromchar.xml fileDone Database: Update Tables Fromcorp.xml fileDone Database: Update Tables Fromeve.xml fileDone Database: Update Tables Frommap.xml fileDone Database: Update Tables Fromserver.xml fileDone Database: Updateyap_utilSections -> accountDone Database: Updateyap_utilSections -> charDone Database: Updateyap_utilSections -> corpDone Database: Updateyap_utilSections -> eveDone Database: Updateyap_utilSections -> mapDone Database: Updateyap_utilConfigDone Update File:yapeal.iniDone Database update is done.
And then when I click go to database settings, it tells me there's an update and the process loops.
Any suggestions? DEADLY NIGHTSHADE - http://www.clan-oriana.com |

Verchan Stoneheart
First Flying Wing Inc Primary.
 |
Posted - 2009.12.05 03:39:00 -
[382]
Originally by: Labrena Edited by: Labrena on 04/12/2009 18:24:15 They are the only 2 that stopped pulling data. Last entry for them was before the server went down for the patch on Dec 1st. All of the others are updating.
I removed them, re-added them to active and still nothing.
Ditto
|

Sraelon d'Phist
 |
Posted - 2009.12.05 05:01:00 -
[383]
Installed the latest (937) and I can't find a setup.php anywhere under the installation directory.
Also, even with a system-wide install under /opt, it's installing config directories under my home dir and so when I run yapeal, it can't find it's config file.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.05 06:04:00 -
[384]
Sraelon d'Phist - You're trying the new Alpha grade installer which doesn't use/have a setup.php. It hasn't progressed to the point of doing everything the regular Yapeal does during install. You need to add you character/corp info by hand to the tables etc. As to the problem it's having not finding yapeal.ini that's a bug and I'll have a fix out for it this weekend as it can also effect a svn install. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.05 06:59:00 -
[385]
Seraphina Oriana - You only need to run the update when you download a new version. It's not check anything or able to get any updates. That's only used when you install a new version over the old to let it update the old tables. The new installer will have that but the old doesn't. You don't have to keep updating it as it will just keep remaking the same tables. Just add your test char/corp and finish the install. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sraelon d'Phist
 |
Posted - 2009.12.05 07:23:00 -
[386]
Thanks for the answer :) How can I get 935, or whatever version is operational? I don't see older versions on google code and svn is latest as well.
Thanks )
|

Sraelon d'Phist
 |
Posted - 2009.12.05 07:31:00 -
[387]
I looked at the SVN checkout and it DOES have setup.php....
So are there two versions of 937?
Also, when trying to use setup.php for the SVN version of 937, it's asking for a password, but this isn't set anywhere?
I can't login. Is there a place that has ALL the info needed to get this running?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.05 07:38:00 -
[388]
For those of you having problems with some of the tables not working it may be something I've just noticed. For some reason Yapeal seems to be using up to 10x more memory then normal at times. To see if that's causing your issue try upping the memory PHP allows and see if it works for you then. I'm looking into what's cause the memory increase and hope to have it fixed soon once I figure out the cause. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Sraelon d'Phist
 |
Posted - 2009.12.05 07:53:00 -
[389]
Yes, I'm a moron.
Thank you for not pointing that out :) It's installed and running.
|

Labrena
 |
Posted - 2009.12.05 17:49:00 -
[390]
Originally by: Verchan Stoneheart
Originally by: Labrena Edited by: Labrena on 04/12/2009 18:24:15 They are the only 2 that stopped pulling data. Last entry for them was before the server went down for the patch on Dec 1st. All of the others are updating.
I removed them, re-added them to active and still nothing.
Ditto
I found the cause of this.
I was using a directors API key. Switched to the CEO's API key and it worked. Seems CCP goofed something with the API roles.
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.05 17:54:00 -
[391]
Got a fix to the svn for the excessive memory use that was causing problems. Those of you having issues give it a try and let me know if it fixes stuff for you. Also included the fix for the hard coded path to config/yapeal.ini that was causing issues if you move config/ somewhere other than the default.
revision 939 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Rottw Adleweh
 |
Posted - 2009.12.06 19:56:00 -
[392]
I haven't updated to the above version yet, but after the dominion update I also had problems that api wasn't pulling things. With that update I used the setup.php to update the tables. I just found that in the utilSections table the values for all but the ServerStatus was set to 0.
I don't know if it was because of the update or because the api was down during deployment of Dominion. But setting the values back to 1 fixed the problems I had.
|

Seraphina Oriana
The White Rabbits The Gurlstas Associates
 |
Posted - 2009.12.06 23:18:00 -
[393]
Originally by: Dragonaire Seraphina Oriana - You only need to run the update when you download a new version. It's not check anything or able to get any updates. That's only used when you install a new version over the old to let it update the old tables. The new installer will have that but the old doesn't. You don't have to keep updating it as it will just keep remaking the same tables. Just add your test char/corp and finish the install.
I can't even get to that - as soon as I log in I get there's an update, when I click update, it says done and show the three buttons at the top. No matter which one I click I get a new update and the process starts again. DEADLY NIGHTSHADE - http://www.clan-oriana.com |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.07 01:16:00 -
[394]
Quote: I don't know if it was because of the update or because the api was down during deployment of Dominion. But setting the values back to 1 fixed the problems I had.
update.php will reset those because it over write your setting from the install/*.xml files. I'll look at changing that as it isn't very nice that it does that 
Seraphina Oriana - Are you trying to use the Alpha installer version from downloads? They are all broken right now as I've been busy working on some other things and haven't done a new build of them and uploaded them yet.
Quote: So are there two versions of 937?
Yes and No Since I'm using a branch for the new installer I'm working on so there can be differences between the version from downloads and the one you get from the SVN trunk. Just to make it clear for a production server and most developers you should still be using the SVN trunk for now. If you want to help me debug/test the new installer and make suggestions on how to improve it then give it a try and let me know how it works otherwise use the SVN for now.
I'm trying to decide how I want to do the test char/corp part right now and maybe have it be an outside program/library that isn't just useful with the installer but I've been hitting some walls doing what I would like to do. I'm thinking about starting with something just for the installer for now and maybe switch to something else in the future. It keeps seeming to grow bigger every time I look at what I was thinking about doing and seems to keep go father down the slippery slope to being part of an application and not just something to be used during testing for developers. I'll try to make up my mind on some of the things I've been looking at today and once that's done progress should increase on the new installer again and will have a version that lets you add the test char/corp as well and at that point the push to Beta version shouldn't take long. Once it's at that point it will become the default installer for trunk and the current setup system will be retired. Once that is done I'll probably start suggesting everyone use downloads instead of SVN. The SVN will of course always be available but for most people the version from downloads and the updater that comes with that version will because the preferred way to get Yapeal.
Hope that help clears up any confusion there might have been and gives everyone some idea where things are going with the project. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
 |
Posted - 2009.12.07 11:26:00 -
[395]
I just noticed that the server status table isn't updating when the server is down, it just stays as it was right before the server went down. Shouldn't it change serveropen to 0?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.07 17:12:00 -
[396]
For those of you that never read sticky threads they have turned off the /map/SovereigntyStatus.xml.aspx API as they thought it gave away to much intel. Have a look at the Removal of /map/SovereigntyStatus.xml.aspx API thread about it. You'll need to remove SovereigntyStatus from activeAPI for map in utilSections table to keep from get a lot of errors reported in log/yapeal_error.log. I'm going to probably hold off for a couple days before I release an updated revision of Yapeal in case they decide to bring it back but in a changed form like has already been suggested on the thread above.
Morgenholt Blue - Yapeal takes a simple approach to stuff. It grab the information from the APIs and puts it into the tables. If it can't get it do to say a connection error, the API is down, etc it leaves it alone. I've tried to never make assumptions that I know better that the XML what is true. If you want Yapeal to report the ServerStatus correctly during DT etc then report it as a bug to CCP (which it is IMHO BTW). You can always look at the cachedUntil time from utilCachedUntil on any API to determine how 'fresh' something is and act accordingly in your application. You could even update the ServerStatus table yourself based on the assumptions you wish to make and when Yapeal starts receiving data again it will simply update it with what it has. Just make sure your application plays nice by looking before changing any of the tables and uses SQL transactions. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
 |
Posted - 2009.12.07 17:52:00 -
[397]
The reason I told you was because the API was up. According to tools such as EVEMon I could connect to the EVE API fine and it reported off-line.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.08 08:27:00 -
[398]
I could be wrong but last time I knew EveMon was still polling the server directly instead of using the API but they could have changed by now. I'll take a look into it some more because after looking at the XML I see they seem to be setting <serverOpen>True</serverOpen> instead of 0/1 so that could be causing some issues with it not being understand somewhere along the chain and always returning 1 in the table. I may have to convert it to logical 0/1 or may just change table so it's a text field and let everyone else decide how to handle it  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.08 17:36:00 -
[399]
Ok I've update Yapeal with some API changes 
- Map Sovereignty Status is now deactivated

- In Server Server Status the serverOpen field has been change to text instead of boolean so now everyone gets to handle it themselves and not Yapeal trying to decide how to interpret it

- Tried to update the old installer to let people select the new character APIs. Should work but didn't have chance to test it

revision 940 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
 |
Posted - 2009.12.08 20:53:00 -
[400]
server.xml file was not found or a bad XML file
The file is there and works on 939.
|
|

Seraphina Oriana
The White Rabbits The Gurlstas Associates
 |
Posted - 2009.12.09 03:16:00 -
[401]
Quote: Seraphina Oriana - Are you trying to use the Alpha installer version from downloads? They are all broken right now as I've been busy working on some other things and haven't done a new build of them and uploaded them yet.
No, I'm using the latest SVN. DEADLY NIGHTSHADE - http://www.clan-oriana.com |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.09 06:45:00 -
[402]
Sorry about that didn't get the <UNSIGNED/> out of the server.xml file when switching from integer to char. You can either delete it yourself at line 45 or download new revision where I fixed it.
Revision 941 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.09 06:51:00 -
[403]
Seraphina Oriana - Try clearing the directory where you're instilling Yapeal and download the latest revision. I'm guessing but think something is bad with the one you got. Also if this wasn't an upgrade you might try deleting and remaking the DB and see if that helps. Might look to see what's in your cache/log/setup_*.log files as well for clues why it's not working for you. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Zuzaxx
 |
Posted - 2009.12.09 16:20:00 -
[404]
hi
im trying to get yapeal up and running and having some problems
i ran the web-setup and everything seamed to go fine, i connected via ssh and ran php ./yapeal.php which spat out a bunch of text, basically complaining that i'd not put my full api key (sadly i foolishly cleared the log so can't reproduce the error)
whenever i rerun the script (i've tried it with the full api, it makes no difference) it now spits out the version number / compile date and "public_html/yapeal/inc/common_backend.php on line 64"
Quote: // Log Yapeal version information. $mess = 'Yapeal version ' . YAPEAL_VERSION . ' (' . YAPEAL_STABILITY . ') '; $mess .= YAPEAL_DATE; trigger_error($mess, E_USER_NOTICE);
(line 60-64)
i've no idea what i've done thatÆs making it get stuck here, any help would be much appreciated
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.09 17:18:00 -
[405]
Quote: whenever i rerun the script (i've tried it with the full api, it makes no difference) it now spits out the version number / compile date and "public_html/yapeal/inc/common_backend.php on line 64"
That's normal it's just a NOTICE message so you know it did something Look in your database and see if you have some data there. I talk about all of that in post 327. Remember also that all the APIs have cache times so when there's nothing to do Yapeal just logs a few notice lines in the log and ends.
Now that you have the full apikey added you may need to look at the utilRegisteredCharacter/Corporation tables and add back in the APIs that may have got deactivated to activeAPI. You can copy&paste them from utilSections table. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.10 18:28:00 -
[406]
Thanks to matthiasvill for reporting issue 23 about corpStarbaseDetails. I'd missed changing something and it was causing that table not to update correctly and some other problems. There's a fix in the latest revision.
revision 943 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Strombizzle
 |
Posted - 2009.12.11 18:21:00 -
[407]
I have Yapeal running under my Godaddy hosting account. It's shared hosting so I have to make due with what I have.
I set up the cronjob and here is the response I got:
/web/cgi-bin/php5: Symbol `client_errors' has different size in shared object, consider re-linking Content-type: text/html
#!/usr/bin/php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http:www.w3.org/TR/xhtml1" xml:lang="en" lang="en"> <head> <title>Yapeal is not a web application</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> </head> <body> <h1 style="font-size: xx-large;color: #ff1010;">USER ERROR USER ERROR USER ERROR</h1> <p> If you are seeing this you have tried to run Yapeal as a web page which is incorrect. Yapeal is made to <b>ONLY</b> ran from the command line. See the <a href="http://eve-search.com/externalLink.asp?l=http%3A%2F%2Fcode%2Egoogle%2Ecom%2Fp%2Fyapeal%2Fw%2Flist">Yapeal Wiki</a> for more information on using it. </p> </body> </html>
It seems to be giving me a php library error along with the message saying that I'm running the file from the web browser.
Has anyone encountered this before? Any easy fix in the config or is this something I'm going to need to take up with godaddy?
Thanks!
|

Johnathan Roark
Caldari Quantum Industries Prime Orbital Systems
 |
Posted - 2009.12.12 07:57:00 -
[408]
Originally by: Strombizzle I have Yapeal running under my Godaddy hosting account. It's shared hosting so I have to make due with what I have.
I set up the cronjob and here is the response I got:
/web/cgi-bin/php5: Symbol `client_errors' has different size in shared object, consider re-linking Content-type: text/html
#!/usr/bin/php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http:www.w3.org/TR/xhtml1" xml:lang="en" lang="en"> <head> <title>Yapeal is not a web application</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> </head> <body> <h1 style="font-size: xx-large;color: #ff1010;">USER ERROR USER ERROR USER ERROR</h1> <p> If you are seeing this you have tried to run Yapeal as a web page which is incorrect. Yapeal is made to <b>ONLY</b> ran from the command line. See the <a href="http://eve-search.com/externalLink.asp?l=http%3A%2F%2Fcode%2Egoogle%2Ecom%2Fp%2Fyapeal%2Fw%2Flist">Yapeal Wiki</a> for more information on using it. </p> </body> </html>
It seems to be giving me a php library error along with the message saying that I'm running the file from the web browser.
Has anyone encountered this before? Any easy fix in the config or is this something I'm going to need to take up with godaddy?
Thanks!
First one I have no clue, maybe something to ask your host about? The other, if you still have the issue check the Wiki page and read through Issue 6. They may have information that you may find useful.
Quantum Industries is recruiting! |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.12 10:15:00 -
[409]
You can also try commenting out line 85 in yapeal.php and see if it works for you using cgi. I haven't tried it but it might work. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Strombizzle
 |
Posted - 2009.12.13 15:27:00 -
[410]
Ok, thanks for the info. I'll play with it a little and see what input my host has to offer.
|
|

Feng Schui
Minmatar Sebiestor tribe
 |
Posted - 2009.12.14 08:59:00 -
[411]
using the latest release of wamp, can't install this version and last version.. keeps telling me that curl isn't installed (but I've confirmed that the extension is loaded).

Project:Gank
Pilgrim Guide
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.14 12:08:00 -
[412]
Make sure when you confirm Curl is load that you do so for the CLI version and not just the CGI as they do have different INI files and can have different extension loaded. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Strombizzle
 |
Posted - 2009.12.15 01:16:00 -
[413]
Edited by: Strombizzle on 15/12/2009 01:16:26 After giving up on my godaddy hosting, I was able to install it on a local linux server and everything works great. Fantastic tool. Kudos to Dragonaire and contributors.
I could however use a point in the right direction as I just finished importing the static data dump for Dominion, but I can't find the static skill list in either the Yapeal imported data or the data dump. I must be missing something as I can't figure out where to get the skill list (other than importing it myself, which I'd like to avoid).
Thanks guys. |

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2009.12.17 10:04:00 -
[414]
hi- question: corpMarketOrders; field: orderState
what do the digits mean? in an earlier post you defined '2' what are '3', '0' defined as?
or where do i look?
thanx
Caveat Emptor |

Rottw Adleweh
 |
Posted - 2009.12.17 12:19:00 -
[415]
Check this page: http://wiki.eve-id.net/APIv2_Corp_MarketOrders_XML
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.20 19:31:00 -
[416]
Strombizzle - Sorry that you didn't get an answer sooner to your question but seems the forums eat my first answer from a few days ago Yapeal doesn't implement all of the skill APIs yet but info on them is also I believe available in the data dump and I'd direct you to the stickys above for more info on how to get what you need.
Fixed the install/*.xml files so during Yapeal updates isActive isn't changed back to the defaults which should make updating less of a hassle. The original reason for it doing that was have Yapeal a more testing mode until application developers could see if anything was broken in an incremental way but now that the code is much more stable this shouldn't be needed anymore.
In other news after taking a short break from Yapeal to play a new game (AVATAR - The Game) I've now added API section activation and setting of activeAPI to the installer for the utilSections DB table. The last remain thing to be added is the test user/char/corp stuff which should make it feature complete when compared to the old installer. I'd like to hear some feedback (good or bad) from anyone trying it out on their test servers.
Revision 948 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.21 14:28:00 -
[417]
Yapeal has past the one year mark. The project moved over to Google Code after a very brief appearance as a project on Sourceforge. Here's some stuff I found interesting that I thought I'd share.
- Average commits per month: 63 (Better then 2 per day
)
- Number of committers: 2 (Actual number of people contributing code is much higher but only have had a couple people that ever did new releases on the trunk)
- Lines of code: 19534 (trunk only)
- Comment lines: 10151 (trunk only)
- Estimated 4 person years for a team of programmers to reproduce effort
- Estimated cost to reproduce if programmers where paid $55,000/year: $244,392 USD

- Actual amount ever received: $0
- ISK received: 0
- Hours spent working on: More than I've have for my job

- Enjoyment from making something useful: Unmeasurable

Thanks to everyone that has helped make Yapeal what it is today and I look forward to continuing to work with all of you and many new people in the future as Yapeal continues to grow and change. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
Gallente House CHOAM SwineFlu.
 |
Posted - 2009.12.22 04:53:00 -
[418]
Quick question, does Yapeal support multiple characters? I tried 2 but then it stopped working.. will look up for any errors in a bit.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.22 08:45:00 -
[419]
It is made to work with multiple users, characters and corporations. The idea behind it is to work with large numbers of each but the exact number it can handle has never really been tested but by it's nature Yapeal is mostly limited by your Internet connections and the DB transactions rate of the server(s) you run it on. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Morgenholt Blue
Gallente House CHOAM SwineFlu.
 |
Posted - 2009.12.22 09:59:00 -
[420]
I don't see how do you distinguish between the different characters?
I see some things but not all have ownerID which I guess is supposed to be used for this?
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.22 18:36:00 -
[421]
All char APIs do have a ownerID=charID and corp ones ownerID=corpID.The rest of the table are either admin tables for Yapeal (util) or general tables that don't have an owner really like the eve, map, server ones. The one from account is of course keyed to userID. Hope that helps if you need help with a particular table let us know and someone can give you an example I'm sure. You might also look back through the thread here as there is a lot of information on how things work in Yapeal in many of the posts as well plus in the wiki. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Lonestar Leo
 |
Posted - 2009.12.23 11:20:00 -
[422]
Hi,
I just tried your your library and it looks promising .)
The installer didn't work: ./Yapeal-948-linux-x64-installer.bin Error: Error running /usr/local/include/php -f "/tmp/Yapeal/install/testForPHPVersion.php" : /bin/sh: /usr/local/include/php: Permission denied Press [Enter] to continue :
I used the svn version then and that worked... only the mail api produces an sql error on inserting into the charMailMessages table.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.23 17:50:00 -
[423]
Try the latest SVN revision 949 for the problems with charMailMessages as it has a couple fixes. As to your problem with installer version it looks like you didn't point it at a CLI version of PHP but either a CGI version (though it should work now too) or just the directory where it could be found and not the actual program. I probably need to make the instructions clearer that it needs to be set to the actual program and not just path to it. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Lonestar Leo
 |
Posted - 2009.12.24 08:51:00 -
[424]
it is still in the latest svn... the query was:
insert into `yapealcharMailMessages` (`messageID`,`ownerID`,`read`,`senderID`,`sentDate`,`title`,`toCharacterIDs`,`toCorpOrAllianceID`,`toListIDs`) values (290720362,544714069,1,1001474112,'2009-12-18 07:33:00','Aw: Aw: xxx','544714069',,''), on duplicate key update `messageID`=values(`messageID`),`ownerID`=values(`ownerID`),`read`=values(`read`),`senderID`=values(`senderID`),`sentDate`=values(`sentDate`),`title`=values(`title`),`toCharacterIDs`=values(`toCharacterIDs`),`toCorpOrAllianceID`=values(`toCorpOrAllianceID`),`toListIDs`=values(`toListIDs`)
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2009.12.24 14:09:00 -
[425]
Make sure you run install/setup.php again at least also as there is a DB update that is needed to fix it as well as the update to the code. Have a look at http://code.google.com/p/yapeal/issues/detail?id=25 for more information. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.03 13:42:00 -
[426]
In trunk/: Implemented suggestion by gilgamoth from Issue 22 to set cachedUntil time to +6 hours on API error 902 and also 901. This should greatly reduce the amount of error spam when the API server is down which seems to have become all to common IMHO. Update handling of fullAPIKey and limitedAPIKey from utilRegisteredUser during API fetching. Now will use either with fullAPIKey having priority. Small change to the utilRegisteredUser table and some updates to the class/Section* files' SQL so they can use either key. Make sure at least one of the keys is set or expect some nasty error messages 
Alpha from Downloads: For those of you having problem during install with the DB tables not being added etc. Try selecting 'Advanced' install option and it should work. Seems one or more bugs have come up in 'Legacy' option since I've been working mostly on 'Advanced' option during development. I'll be looking in what needs fixed soon(tm) For those trying out Linux versions on some distros you may have notice it aborts with an error message before it even seems to get started This is caused by a error during initiation while trying to auto detect path to PHP and it's version. I have someone testing a fix for that now and plan to release updated version later today.
Been making some progress on options to add test user/char/corp to utilRegistered* tables which is last feature I planned to add. Once that is done a general bug hunt and cleanup is planned which should lead to moving all the changes to trunk/ and the retirement of the old install system.
revision 953 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Qoi
New Eden Warriors
 |
Posted - 2010.01.03 15:16:00 -
[427]
I'm using php 5.3 and yapeal revision 953. The corp AssetList contains 23633 Entries. When updating corpAssetList, i get this warnings:
WARNING: Message: SimpleXMLElement::addAttribute(): Attribute already exists File: /home/niklas/yapeal/class/api/corpAssetList.php Line: 186
WARNING: Message: SimpleXMLElement::addAttribute(): Attribute already exists File: /home/niklas/yapeal/class/api/corpAssetList.php Line: 170
In total I get 302607 Warnings per yapeal run and yapeal takes 2.6 Gigabytes of Memory. The AssetList in the database seems to be okay.
The callstack for the first warning is: editAssets(&$obj); editAssets(&$obj, 0, 2, 0); editAssets(&$obj, 0, 2, 0); editAssets(&$obj, 0, 32, 1); editAssets(&$obj, 0, 33, 1); editAssets(&$obj, &$obj, NULL, 2);
With the last call leading to the warning - i don't think the second argument should be an object at all? (It's an simplexml object)
|

Scribbly
 |
Posted - 2010.01.03 22:42:00 -
[428]
Hi there
This is the best thing since sliced bread! One problem I am having is when inserting into charMailMessages, perhaps there is an extra ' in the mail message which is messing things up? I will investigate more
One question...What is the method for upgrading to a newer version? At the moment I am deleting everything and reinstalling although this is becoming a bit of a pain as I am loosing all my history?
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.03 23:19:00 -
[429]
Qoi - Please try the new revision and see if it helps with some of your warning messages. If it doesn't clear them up please contact me through my G-Mail account which you can find by looking at the project owner for Yapeal and I'll have you give me some more details and try some things.
Scribbly - Usually you can just install the new version right over the top of the old without any problems. If you're using the SVN version you probably need to run install/setup.php at least to let it update any change in the DB tables which BTW you don't have to clear like you've been doing as it can update them with the data in them. The new installer is also made to update the DB tables with data in them though there are some bugs right now that would probably make you have to use the 'Advanced' option.
revision 954 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.04 05:40:00 -
[430]
New version of the 'Alpha' installer out which should have fixed the errors with Map section and the problem with auto-detecting PHP under Linux. 'Legacy' should work correctly now as well as 'Advanced'.
revision 955 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Ramov Tinoga
Tinoga Enterprises
 |
Posted - 2010.01.06 11:15:00 -
[431]
Originally by: Dragonaire New version of the 'Alpha' installer out which should have fixed the errors with Map section and the problem with auto-detecting PHP under Linux. 'Legacy' should work correctly now as well as 'Advanced'.
revision 955
I've installed the Yapeal-955-linux-x64-installer.bin (Advanced Setup) on my openSUSE 11.0_x64 and it worked fine once I gave the yapeal database user all rights on the yapeal database. 
I was a bit reluctant to update my old yapeal version manually, so the installer is really helpful and takes care of everything. -----
|

M4g3ll4n
Circle of Shadows Black Swan.
 |
Posted - 2010.01.08 13:36:00 -
[432]
Hi, at the moment I am running "Yapeal Revision: 940" on webspace (no dedicated server or vserver, etc).
How is the best way (or are the steps) to update Yapeal to the actual Revision?
Thanks in advance. Mag
P.S.: Awesome tool!
Circle of Shadows - Recruiting now www.eve-cos.info |

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.08 15:40:00 -
[433]
How you upgrade Yapeal depends if you're using SVN or trying out the new installer version. With SVN you can use the normal 'svn up' to do it or 'svn export --force' if you use an export to keep from having .svn/ directories in web accessible locations on your server. For a somewhat more detail set of instructions that were written for Windows you can have a look at the Wiki
With new installer you should find install/autoupdate-* file that you can run that works much like the installer and will check for newer versions and give you option to update to the newest revision. If you don't see autoupdate-* then you can also just grab the latest download and run it and it'll overwritten the existing install as well and then you should have the autoupdate-* to use in the future.
In general updating Yapeal is mostly a matter of overwriting outdated files with new ones, adding any new ones, deleting unused ones, and then sometimes making updates to the database tables and ini file, all of which you can do manually but using svn and install/setup.php or the new installer are much easier and far less error prone of course  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.09 09:01:00 -
[434]
Ok a week later then expected but I've finished adding all the test user/character/corporation stuff to the new installer. It's ready to be used a bit more now. It's still not full production ready but if you make some good backups of your data it would be useful to give it a try. There have been a few changes to the util tables like adding CorporationName to the utilRegisteredCorporation table. Some things that the installer does that the old one didn't is it will add all your characters and their corps to the utilRegisteredCharacter/Corporation tables but only make the ones you select active. For more information about changes that were made look through the commit notes as well.
revision 959 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.15 09:05:00 -
[435]
Ok did some clean up and bug fixing on the new installer. I've also enabled option for it to check for new updates on install so it can do the job of the autoupdater as well so you can always make sure you have to latest version 
revision 961 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Qoi
New Eden Warriors
 |
Posted - 2010.01.16 08:02:00 -
[436]
Edited by: Qoi on 16/01/2010 08:03:12 I was able to succesfully reproduce my problems on several systems (linux x64) with several php 5.3.X versions including HEAD and latest stable
http://bugs.php.net/bug.php?id=50670
I optimized the code (it uses 70% less memory for CorpAssetList now with php 5.2.X) but still I get very high memory usage under php 5.3, i guess there is something terribly broken :/
To make that clear: it's php that is broken if you ask me, not your code 
|

Xaroth Brook
Minmatar BIG Libertas Fidelitas
 |
Posted - 2010.01.19 11:31:00 -
[437]
Dragonaire,
First of all, nice work so far, it was some getting used to due to not having that much information about it, but I got most of it working.
One bit I didn't get working was this:
If you have multiple characters belonging to the same corp, you can still only enter 1 item -per corp- in the utilRegisteredCorporation table.. as such, once there's already somebody in that list with limited view rights (say, normal member), you'll have to manually confirm that the character you are trying to add for that corp has more access than the one already in place, then replace the entry.
how when you then remove that second character, adding the first could be possible with some logic, but then the system would again, try to load API sections it shouldn't be loading.
a small proposed change for this:
allow multiple character-corp entries (and linked as such, primary key on characterID or so), that each have their own activeAPI list.
then, per corp check the list of characters (so you know which api key to use), and check which activeAPI they have set, start with the character that has the most (after verifying it works, obviously), if another character has access to a sheet that hasn't already been processed, use that character to retrieve the information
as such you would end up with a relation like this:
character - access Char1 - A B C D E Char2 - A B C D E F G H Char3 - A C D E F G H I J K L
The system should then use Char3's key to retrieve A (not B as it doesn't have it) C-L .. after loading it should notice that B hasn't been loaded, and that Char2 (seeing it has the most lists available) has that.. 1+1=3, use Char2's access to Load B, and yer done.
that way, if any of the characters gets removed at a later point, the system will remain functional (albeit less data being processed).. also, a new character added to the list with all access will be checked first to verify it's access, after which proper access will be used to pick up the remainder.
It was like a baby, it landed on my lap and was helpless and totally defenseless. Then I shot it and bragged about it on a killboard.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.21 08:57:00 -
[438]
Quote: it was some getting used to due to not having that much information about it
Yeah I know but I do try to document the code fairly well to help out. You can even do a SVN checkout of some auto built webpages for it from here. It's mostly made for Yapeal developers to use but there's stuff in that can be of use to everyone.
Quote: If you have multiple characters belonging to the same corp, you can still only enter 1 item -per corp- in the utilRegisteredCorporation table.. as such, once there's already somebody in that list with limited view rights (say, normal member), you'll have to manually confirm that the character you are trying to add for that corp has more access than the one already in place, then replace the entry.
The 'best' way to find the character to use is look at their roles in the corp from the character sheet API tables and select one that has 'Director' role and insert them into utilRegisteredCorporation. If none of the available characters have that role use the one that has to most roles that cover the API access you want. That's something best done/decided in the application code not Yapeal IMHO.
Quote: allow multiple character-corp entries (and linked as such, primary key on characterID or so), that each have their own activeAPI list.
The problem you run into trying to having more than one entry in utilRegisteredCorporation for a corp is you could end up trying to pull the same API more than once and the 'second' one to do so will always receive an error from the servers and cause un-needed increase in server load plus risk chance of having you IP banned from API from not obeying the cache timer  -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Trader Hek
Contingency.
 |
Posted - 2010.01.22 16:50:00 -
[439]
I checked out the latest from svn and tried to install. I recieved a failure on importing char.xml during install. I had to edit /install/char.xml
LINE 634 From : <field name="`remainderPoints`" type="F" size="52"> To: <field name="`remainderPoints`" type="F" size="5.2">
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.22 21:27:00 -
[440]
Yeah sorry about that ended up committing something to trunk instead being in a branch to test it You'll probably find that WalletJournal for characters fails also I'm going to revert the changes to it and just have the new Research API added until I work out my bugs with the Journal. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.24 23:41:00 -
[441]
Ok sorry took this long but had a couple other things going on in RL that kept me from getting the corrected update for Dominion 1.1 patch out. The new charReseach API should be working now and charWalletJournal updated with new tax columns. As always let me know if something isn't working 
I should have updates merged into installer downloads later or by tomorrow at latest.
revision 968 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.01.31 05:10:00 -
[442]
Minor update to let Yapeal be run with CGI instead of CLI which should make it a little easier to use with some web hosts. Limited testing but worked for me To use it from CGI you may need to change the first line in yapeal.php to read #!/usr/bin/php-cgi -Cq on Linux/BSD. The path maybe different on your system but that one should work for most people. I'll merge trunk into branch I use for installer version after a little feed back from people using it with CGI then release update for them as well. If you want to try it out you can copy the updated yapeal.php, /inc/common_backend.php, and /class/YapealAutoLoad.php from trunk/ and see how it goes.
For anyone that's been having problems running Yapeal from php 5.3 or latter you may need to change your php.ini file to allow 64MB memory as PHP now does proper accounting for memory use by it's extensions so you now have to deal with how much memory things like MySQLi and SimpleXML are truly using. So far in testing 55MB was highest I've seen reported but 64MB would be a nice round computer number to use 
revision 970 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

KtoJest
Minmatar Silkroad Partners
 |
Posted - 2010.01.31 11:12:00 -
[443]
hi- just got into 'nested sets'. thanx for the examples.  Caveat Emptor -a trader's blog |

Roomsy
 |
Posted - 2010.02.01 21:00:00 -
[444]
Hi
I think i'm being a complete numpty here but what is the password that your asked for at the end of the /install/setup.php web based setup? The DB password doesn't work and I can't seem to find a default password anywhere.
I did the setup by using the latest svn 971, created a new db and user with full permissions. The database is populated but I can't log in.
|

Roomsy
 |
Posted - 2010.02.01 22:13:00 -
[445]
Originally by: Roomsy Hi
I think i'm being a complete numpty here but what is the password that your asked for at the end of the /install/setup.php web based setup? The DB password doesn't work and I can't seem to find a default password anywhere.
I did the setup by using the latest svn 971, created a new db and user with full permissions. The database is populated but I can't log in.
ok, seems I.E 8 jumps the page where you set the password.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.02.02 22:22:00 -
[446]
Ok finally got around to making a change to how Yapeal figures out the required and optional column types for ADOdb during table inserts. This change should have no effect on application developers but should make updating and adding new APIs easier in the future. Before the developer was required to put together the list manually for each table when adding a new API now ADOdb can figure it out for itself from the DB table This change has already highlight one minor bug in the StarbaseDetails tables that was missed with sovereign changes.
I have a few days off and plan on looking into high memory use that has shown up with switch to PHP 5.3. I've tracked it down to the allianceList API but could also effect some of the other large APIs as well. I'll be trying out some different coding in a branch to see what I can do to reduce usage.
I probably won't be updating the downloads with what I've been working on until after I finish one or two more of these type of changes but once they are in trunk/ I'm merge them out to that branch again and release update for them. I had a report of the autoupdater not working right and need to look into what changes I can do to make it work smoother before continue with work to merge that branch back into trunk/ as well.
trunk revision 973, download revision 969 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.02.07 10:49:00 -
[447]
Ok added feature to Yapeal that I've wanted to do for a long time and just never seemed to get around to. You can now have XML cache to the database instead of or in addition to files in cache directories To enable the new caching you'll need to update config/yapeal.ini in the [Cache] section by changing cache_output="file" to either "both" or "database" depend on if you want to use database caching in addition to files or instead of. The XML cached in the database if valid and not expired has priority over the files during fetch so keep that in mind if you decide to use both and wonder why changes in the cache files during testing don't seem have any effect 
trunk revision 981, download revision 969 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.02.14 04:50:00 -
[448]
Ok I've finally finished what I can do for now on reducing memory usage in Yapeal and seem to have cut it in half at least for now from over 50MB down to 21MB or so in my testing. Farther cuts will have to wait until I can do some in-depth code profiling and tracing. That brings me to something else I've done. All the old tracing stuff have been removed to make way for an improved system that will probably be based on Xdebug instead. The time frame for adding the new code to do that is unknown at this time as changing over to the new install system and totally removing the old one is next planned thing to got finished. I have ideas for several things I'd like to add to or change with new installer but which of those get done before merge is still not decided yet but most will probably be put on hold until after merge.
revision 986 -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
|

Dragonaire
Caldari Corax. New Eden Retail Federation
 |
Posted - 2010.02.14 10:26:00 -
[449]
I've updated the downloads to latest merge from trunk/
trunk revision 986, download revision 987 -- Finds campi |