Pages: 1 2 3 [4] 5 6 7 8 9 10 11 .. 11 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Tiberius Zol
28
|
Posted - 2014.08.20 14:51:00 -
[91] - Quote
forget the wiki.. look into the install.md and after it in the config.md... the yapeal.php is in the bin directory |
SCORPl0
Foundation Cutting-Edge Mordus Angels
1
|
Posted - 2014.08.20 18:35:00 -
[92] - Quote
Tiberius Zol wrote:forget the wiki.. look into the install.md and after it in the config.md... the yapeal.php is in the bin directory
All this two files completed already. Install and config done, database populated.
I just need a start point on how uses api functions and how I can play with it.
There's nothing that introduce the use of the api if the wiki became for old versions.
I'm not a php dev at the origin, but a developer anyway.
Thanks for any information. |
Tiberius Zol
28
|
Posted - 2014.08.20 19:43:00 -
[93] - Quote
ah ok.. if you have the DB stuff ready, you should fill the API data directly to the DB (prefix_utilRegisteredKey) and don't forget the right API mask (it doesn't work without it here).
after it just run the bin/yapeal.php from commandline... tadaaa.. you should see several data for the api in your tables.. then just let it be run every minute via your crontab.. that should be all.. after it you can use all your data in the database for whatever you need it. |
SCORPl0
Foundation Cutting-Edge Mordus Angels
1
|
Posted - 2014.08.20 20:55:00 -
[94] - Quote
Tiberius Zol wrote:ah ok.. if you have the DB stuff ready, you should fill the API data directly to the DB (prefix_utilRegisteredKey) and don't forget the right API mask (it doesn't work without it here).
after it just run the bin/yapeal.php from commandline... tadaaa.. you should see several data for the api in your tables.. then just let it be run every minute via your crontab.. that should be all.. after it you can use all your data in the database for whatever you need it.
I'll try this.
The data imported depends of the api access masks selected on EvE Create Api Page ?
Thanks for help. |
Tiberius Zol
28
|
Posted - 2014.08.20 21:00:00 -
[95] - Quote
yes.. and which of the apis are implemented in yapeal yet (some apis missing and will be added later, like assets) |
SCORPl0
Foundation Cutting-Edge Mordus Angels
1
|
Posted - 2014.08.20 21:10:00 -
[96] - Quote
SCORPl0 wrote:Tiberius Zol wrote:ah ok.. if you have the DB stuff ready, you should fill the API data directly to the DB (prefix_utilRegisteredKey) and don't forget the right API mask (it doesn't work without it here).
after it just run the bin/yapeal.php from commandline... tadaaa.. you should see several data for the api in your tables.. then just let it be run every minute via your crontab.. that should be all.. after it you can use all your data in the database for whatever you need it. I'll try this. The data imported depends of the api access masks selected on EvE Create Api Page ? Thanks for help.
Looks like yes, some corp data inserted using yapeal.php.
Now it's all about php code to build my function using database data.
Thanks again ! |
SCORPl0
Foundation Cutting-Edge Mordus Angels
1
|
Posted - 2014.08.20 21:13:00 -
[97] - Quote
Tiberius Zol wrote:yes.. and which of the apis are implemented in yapeal yet (some apis missing and will be added later, like assets)
I just need CorpWalletJournal to track user donations and display it on a php sorted page. |
Tiberius Zol
28
|
Posted - 2014.08.20 21:18:00 -
[98] - Quote
shouldn't be that hard.. fetch all from the table where refTypeID=10 (should be player donation) |
Dragonaire
Here there be Dragons
58
|
Posted - 2014.08.20 22:31:00 -
[99] - Quote
Just thought I say I've updated the crontab Setup page in the wiki if you need some more help with that. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Dragonaire
Here there be Dragons
59
|
Posted - 2014.08.25 18:36:00 -
[100] - Quote
Hi all I just pushed something I've been working on for last couple weeks. I finished up the database updater system. You can try it out by running
'php bin\yc D:U'
It should be able to update any databases that have been manually updated to at least have the blueprint API tables. Note just like with install you may need additional privileges above what the normal Yapeal user needs. Something that's different with the update compared to the install is it uses MYSQL procedure so make sure the user you run it as can create, delete, and use them. Also as always make sure you have a current backup of your database before using it.
Just a little bit about how the updates work. The command starts out by grabbing your settings from config/yapeal.yaml. You can tell it to use a different config file you if you want or override any of the settings using command line options. The command then checks the current version of the database in the utilDatabaseVersion table if it exists and compares that to the sql files in bin/sql/updates/ directory. It will apply any of the sql files that have a version (name) greater then the current database version. They are applied in order and the utilDatabaseVersion table is updated. On the first run you will get a warning message about 'Could NOT get database version ...' which you can ignore as the table should be added for you automatically so you don't see the message again. I decided to use a date-timestamp for the versions vs something else like plain numbers which you might have seen during development. All but the first one are based on when I did commits to git with database updates but in the future they'll be based on when I do create the update sql on my development machine since I wouldn't have commit dates before doing the actual commits like I did this time.
Anyway hope this new tool makes it easier for everybody when updating Yapeal. As always you can ask any questions you have here and if you find a bug make sure to create the issue on GitHub.
Thank you for using Yapeal. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
|
Tiberius Zol
30
|
Posted - 2014.08.25 18:58:00 -
[101] - Quote
quick feedback:
first:
Quote: warning Could NOT get database version using default 197001010001 /warning Could NOT access update directory /htdocs/eve/yapealneu/bin/bin/sql/updates/
seems to be the same problem as on the beginning (double /bin). |
Tiberius Zol
30
|
Posted - 2014.08.25 19:00:00 -
[102] - Quote
After delete the /bin in DatabaseUpdater.php i get this:
Quote: /htdocs/eve/yapealneu/bin/sql/updates/201408131139.sql ..................CALL "db478456446"."AddOrModifyColumn"('db478456446', 'yp2_corpWalletTransactions', 'characterName', 'CHAR(50) NOT NULL') Sql failed in /htdocs/eve/yapealneu/bin/sql/updates/201408131139.sql on statement 18 with (01000) SQLSTATE[01000]: Warning: 1265 Data truncated for column 'characterName' at row 1
|
Tiberius Zol
30
|
Posted - 2014.08.25 19:09:00 -
[103] - Quote
ok after setting the table column manually there was no more error. |
Dragonaire
Here there be Dragons
59
|
Posted - 2014.08.25 19:41:00 -
[104] - Quote
Tiberius Zol - So are you seeing character names longer than 50 characters? Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
30
|
Posted - 2014.08.25 19:50:00 -
[105] - Quote
Nope, but characterName column is empty now.. and characterID column is NULL everywhere. |
Tiberius Zol
30
|
Posted - 2014.08.26 12:25:00 -
[106] - Quote
just for your information: i set the isActive flag for the Blueprint APis to 1 and it pulls stuff and write it to the table... BUT i have several (maybe all?) Corp BPs in the charBlueprint table |
Tiberius Zol
30
|
Posted - 2014.08.26 14:50:00 -
[107] - Quote
About the corpWalletTransaction stuff.
I truncated the table. after it i run yapeal again and found this on the yapeal.log:
[2014-08-26 16:44:49] yapeal.WARNING: Failed to upsert data from Eve API corp/WalletTransactions for 98067338 on account 1000 {"exception":"[object] (PDOException: SQLSTATE[HY000]: General error: 1364 Field 'characterName' doesn't have a default value at /htdocs/eve/yapealneu/lib/Database/EveApiToolsTrait.php:107)"} []
after set the characterName to NULL again the table get filled again.. but with characterID and characterName both NULL |
Dragonaire
Here there be Dragons
59
|
Posted - 2014.08.26 17:57:00 -
[108] - Quote
Tiberius Zol wrote:just for your information: i set the isActive flag for the Blueprint APis to 1 and it pulls stuff and write it to the table... BUT i have several (maybe all?) Corp BPs in the charBlueprint table Edit: yes.. all BPs, char and corp related are in the charBlueprints table. corpBlueprints table is empty. Edit2: found the error and fixed it manually: lib/Database/Corp/Blueprints.php Quote: $this->attributePreserveData( $xml, $columnDefaults, 'charBlueprints' );
must be Quote: $this->attributePreserveData( $xml, $columnDefaults, 'corpBlueprints' );
https://github.com/Dragonrun1/yapeal/issues/37 Fixed. Sorry thought I'd made change before I pushed.
Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Dragonaire
Here there be Dragons
59
|
Posted - 2014.08.26 22:02:00 -
[109] - Quote
Tiberius Zol wrote:About the corpWalletTransaction stuff.
I truncated the table. after it i run yapeal again and found this on the yapeal.log:
[2014-08-26 16:44:49] yapeal.WARNING: Failed to upsert data from Eve API corp/WalletTransactions for 98067338 on account 1000 {"exception":"[object] (PDOException: SQLSTATE[HY000]: General error: 1364 Field 'characterName' doesn't have a default value at /htdocs/eve/yapealneu/lib/Database/EveApiToolsTrait.php:107)"} []
after set the characterName to NULL again the table get filled again.. but with characterID and characterName both NULL https://github.com/Dragonrun1/yapeal/issues/38 Fixed. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tiberius Zol
30
|
Posted - 2014.08.27 06:47:00 -
[110] - Quote
Good Job. Thanks for fixing. :-) |
|
Legedric Striker
Blue Republic RvB - BLUE Republic
46
|
Posted - 2014.08.27 11:22:00 -
[111] - Quote
Any hint on what I am doing wrong when my yapeal.log get's several GB big in size although I left the bufferSize at 25 in the yapeal.yaml config file? Join R-v-B-- The MOST active PVP community in EVE!
EVE-Skillplan.net - Plan your skill training online using a PC, tablet or smartphone! |
Dragonaire
Here there be Dragons
60
|
Posted - 2014.08.27 16:00:00 -
[112] - Quote
Legedric Striker- You might want to read how the bufferSize works in the FingersCrossedHandler.
https://github.com/Seldaek/monolog#wrappers--special-handlers
It doesn't really limit the log overall size only how many lines it goes back in it's internal held log from when something triggers it. Fixing your other issue should keep it from writing anything to you logs which probably will help keep them from growing like they have been.
The CorporationRolesAt* tables in the database are set to only allow for ASCII characters since they are fixed by CCP but titles are done by players so it should allow all normal UTF-8 characters. It was an oversight on my part about the difference and I'll try to push out an update that should fix it for you today or tomorrow. If you want to try it now just change the charCorporationTitles table charset from ASCII to utf8 with utf8_unicode_ci collate and you should see the warnings go away.
On another note some of you might have noticed Yapeal does NOT seem to be remembering which updates it has done so reapplies them all when you run 'yc D:U'. There's really nothing wrong with this other than it can be slower and it really shouldn't be repeating something it already did. I think it has to do with a last minute change I made to updating the utilDatabaseVersion table but still tracking it down so look for a fix for this as well in the next day or two.
There also a bit of a issue with the corp/MemberTracking stuff which I seem to have a working fix for. I expect to push out sometime later today to fix it. I may wait and do all the fixes together or break them up into several so just keep watching for them.
As always thank you for using Yapeal, Dragonaire. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Legedric Striker
Blue Republic RvB - BLUE Republic
46
|
Posted - 2014.08.27 16:37:00 -
[113] - Quote
Thanks, I changed the table collation to utf8_unicode_ci but the exception is still being thrown and so the title gets rejected. Join R-v-B-- The MOST active PVP community in EVE!
EVE-Skillplan.net - Plan your skill training online using a PC, tablet or smartphone! |
Dragonaire
Here there be Dragons
60
|
Posted - 2014.08.28 15:29:00 -
[114] - Quote
Try changing it directly on the titleName column because changing it just on the table after the table is created doesn't always update existing columns Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Legedric Striker
Blue Republic RvB - BLUE Republic
47
|
Posted - 2014.08.28 16:31:00 -
[115] - Quote
Thanks, that worked! I should have come up with that by myself Join R-v-B-- The MOST active PVP community in EVE!
EVE-Skillplan.net - Plan your skill training online using a PC, tablet or smartphone! |
Dragonaire
Here there be Dragons
60
|
Posted - 2014.08.28 21:03:00 -
[116] - Quote
Okay think I've resolved all the issues I talking about in https://forums.eveonline.com/default.aspx?g=posts&m=4958262#post4958262 above. Also found another couple things and fixed them in the tables hopefully before anyone had run into them without realizing. Updating is now working as intended so applying the updates should be more streamlined going forward.
Hopefully with these fixes there will be less issues coming up and I can start spend more of my time on adding some of the missing APIs again but I think its important that the current APIs be as bug free as possible so keep the reports coming.
Resolved issues in last two days:
#37 corp/Blueprints using wrong table #38 corp/WalletTransactions not setting defaults for characterID and characterName #39 XSD for eve/CharacterInfo does NOT understand new corporationName field. #40 charCorporationTitles table allows only ASCII character titles #41 IndustryJobs tables installerName columns to short #42 yc Database:Update unnecessarily reapplies updates
Thanks for using Yapeal, Dragonaire.
Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tesla Ming Chent-Shi
The Traders Blacksoul Tribal Nation
5
|
Posted - 2014.08.28 22:33:00 -
[117] - Quote
Would it be useful to make a wordpress plugin fully utilizing this library? If so, let me know and I'll design one. |
Dragonaire
Here there be Dragons
60
|
Posted - 2014.08.28 22:53:00 -
[118] - Quote
Tesla Ming Chent-Shi - There's probably some people that would really find that useful. Like with any project that uses Yapeal I'd be more than happy to help you figure out any missing details on how it works etc. I really don't know much about WP but I'm wondering how you'd handle the background automatic updating feature Yapeal uses or if you'd more be doing it as a one shot on a per page basis? I probably would have some other questions about it but I'll wait and let's see how much interest people have in the idea and what they might like to see etc. Finds camping stations from the inside much easier. Designer of Yapeal-á for the Eve API. Check out the Yapeal PHP API Library thread for more information. |
Tesla Ming Chent-Shi
The Traders Blacksoul Tribal Nation
5
|
Posted - 2014.08.28 23:13:00 -
[119] - Quote
I'm developing a wordpress project that will need your library, so like you say depending on response I'll be happy to do it.
It could easily support every major feature out of the box...really all we're attempting to do is hook basic functionality into wordpress and give it some good markup.
Feel free to message me if you feel there is potential and we can collaborate. |
Tiberius Zol
30
|
Posted - 2014.08.31 15:27:00 -
[120] - Quote
Guys... I try to import some of the old tabledata in the new tables. Some stuff is easy, like wallettables, but industryJobs seems to be a bit harder, because very different tablecolumns. Does anyone tried to convert the old data to the new table? I need the right mapping for it. Maybe some of you guys can help me here. |
|
|
|
|
Pages: 1 2 3 [4] 5 6 7 8 9 10 11 .. 11 :: one page |
First page | Previous page | Next page | Last page |