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) |
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. |
|
|
|
|
Pages: 1 2 3 [4] 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 .. 24 :: one page |
First page | Previous page | Next page | Last page |