| Pages: [1] 2 3 4 5 6 7 8 9 :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 2 post(s) |
Azazel Mordred
Minmatar
Cloak of Shadows
   |
Posted - 2008.11.24 20:44:00 -
[1]
Hi
For the original post, see this thread. Unfortunately it's well older than 90 days, or I'd have just updated that. I do apologise for duplication.
Just wanted to drop a quick note that Out of Eve (http://www.outofeve.com/) 1.1 has been released, with full Quantum Rise support, including certificates on your character page.
One of the main updates in this release is increased API key security, so if you're hosting your own OOE instance, and your database is compromised, unless an attacker gains full access to your web server and invests some time and effort in working it all out, your API keys should remain safe. The outofeve.com instance is also secured using the same method, should you choose to sign up there.
Other updates include breakdown of financial losses on the kills/deaths log, certificate and attribute/implant support on the character page, ships now show their full fittings in proper Eve fitting layout, rather than just a list, and your journal transactions are available via an Atom feed, which you can plug into Google Reader, FeedReader, or any RSS/feed reader of your choice, so you'll always be able to keep track of your financial activity.
Feel free to either register at OutofEve.com (full API key required - see original post) and check it out, or download it and securely host your own site.
I believe there are issues with the assets list and Outposts, however since I do not own any myself, nor know anyone with any, I'm a bit in the dark in this area. Feel free to download the source (available on the Out of Eve about page) and either help out by contributing some code, or pointing me in the right direction.
Thanks
|
|
CCP Explorer
|
Posted - 2008.11.24 20:57:00 -
[2]
Edited by: CCP Explorer on 24/11/2008 20:57:09
I would love to see this site, websites and tools that use the EVE API are always interesting, but:
 Quote:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in /var/www/outofeve.com/includes/database.php:15 Stack trace: #0 /var/www/outofeve.com/includes/database.php(15): PDO->__construct('mysql:host=loca...', 'root', 'loaded') #1 /var/www/outofeve.com/includes/database.php(10): DBManager->Connect(Array) #2 /var/www/outofeve.com/includes/site.php(20): DBManager->DBManager(Array) #3 /var/www/outofeve.com/index.php(8): Site->Site() #4 {main} thrown in /var/www/outofeve.com/includes/database.php on line 15
Erlendur S. Thorsteinsson
Software Director
EVE Online, CCP Games |
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.24 20:59:00 -
[3]
Apologies, caught me doing some quick DB changes :). It's all back up now.
|
|
CCP Explorer
|
Posted - 2008.11.24 21:02:00 -
[4]
Much better now 
Erlendur S. Thorsteinsson
Software Director
EVE Online, CCP Games |
|
Faife
Noctiscion
|
Posted - 2008.11.24 21:50:00 -
[5]
what's my chances of getting an eve-mon clone on there?
there's no mac port you see, and i broke my parallels.
--
i am a humble and inefficient ammo to dps converter |
Maglorre
|
Posted - 2008.11.25 04:50:00 -
[6]
Very nice work.
I've got lots of assets all over the place including outposts and yes, it seems a little broken. Maybe don't auto-load the assets, allow the user to enter a search term first!
If I can fend off the wife agro for a while tonight I might try installing the source and see if I can fix it. I once started writing an eve asset manager using Adobe Air and ExtJS (but gave up when the heavyduck eve asset manager was released) and recall I had to mess around a bit to get the outpost stuff to work properly.
Part of the problem with outposts is that they can change hands and then the name changes
Also, a POS report would be awesome. If you are interested I can provide some XML output from the API that gives the POS details.
The other thing that would be nice is a report on the corp assets, wallets and manufacture/research jobs.
Cheers
|
Nikita Alterana
Gallente
The Antikythera Mechanism
|
Posted - 2008.11.25 05:35:00 -
[7]
very nice
__________________________________________________
I was Amarr before they were the FOTM and I'll be Amarr after it!
I'm also training Minmatar Capitals!
And I eat Lions! |
Mal Plox
The xDEATHx Squadron
Legion of xXDEATHXx
|
Posted - 2008.11.25 05:58:00 -
[8]
nice site!
but using 'root' to access your web database? :)
---
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.25 06:44:00 -
[9]
Indeed! It was a my bad, which I was correcting while breaking at the same time  .
Thanks for the feedback so far.
Faife: EveMon is a pretty awesome application, one I have no intention of even trying to replicate  . I believe they've been making progress with getting EveMon to run under Mono on Linux. I'm not sure if it does, but if Mono run on OSX, perhaps you could investigate that avenue.
On, after typing all that, I see this may in fact help you: http://gtkevemon.battleclinic.com/ - I'm sure you can get GTK applications to run on OSX?
Maglorre: If you could perhaps evemail me some example data (feel free to hide or change whatever sensitive data it might contain), as well as some kind of explanation of how it's expected to be presented, I'd be very grateful.
As for corporation support, I'm afraid I'll be maintaining OOE in a purely single-user fashion for the foreseeable future. Again, corporation management is not something I'm overly familiar with, and the biggest barrier for me is unfortunately the time required to write it all  .
However anyone should be able to develop a couple of plugins for this, and, should they wish to do so, contribute those additions to the main OOE package for future releases. If anyone wants to do this, please drop me an evemail.
|
Lady Aja
Caldari
Ore Mongers
Black Hand.
|
Posted - 2008.11.25 07:17:00 -
[10]
Edited by: Lady Aja on 25/11/2008 07:19:58
for me this is REALLY nice...
I dont have to login to my account and check on something that is bugging me to hell. its all there.
maybe an addition for kill mail support for public display would be superb.
|
|
|
|
Chribba
Otherworld Enterprises
Otherworld Empire
|
Posted - 2008.11.25 07:45:00 -
[11]
Sweet, hope this one works better than the previous (as I couldn't install that at all). Giving it the lookxies.
Secure 3rd party service ■ Veldspar |
|
Maglorre
|
Posted - 2008.11.25 14:49:00 -
[12]
OK,
Got a few things to report.
I set it up under Zend Core on a Windows box (normally use Unix/Linux at work but just don't have one at home right now). Had to do a bit of fiddling with path and directory separators in the config files to make it all happy. For example
Quote:
ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'libs' . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'eve');
Basically, make use of DIRECTORY_SEPARATOR and PATH_SEPARATOR constants in the config.php and site.php instead of / and : and it all works fine (sort of).
Registration didn't work as the SQL to insert a new user attempts to insert an empty string into the active_time field. Didn't actually fix this problem, just inserted the user detail manually for now.
Regarding the Assets in Outposts. You may need to load the list of Outposts via the API from http://api.eve-online.com/eve/ConquerableStationList.xml.aspx . Also, there is something about locations that start with the digits 66 and 67 (I think it has something to do with corp offices but my memory is a bit hazy on this). The code from my original work went something like this...
Quote:
if (locationID.substr(0, 2) == '66')
{
locationID = locationID - 6000001;
}
else if (locationID.substr(0, 2) == '67')
{
locationID = locationID - 6000000;
}
Also, it's possible to have assets in space. In this case the locationID is a solarsystemID, not a stationID. For example I have a Velator rookie ship floating in Gulfonodi
Quote:
<row itemID="1240652248" locationID="30002384" typeID="606" quantity="1" flag="0" singleton="1">
<rowset name="contents" key="itemID" columns="itemID,typeID,quantity,flag,singleton">
<row itemID="1240652235" typeID="3651" quantity="1" flag="28" singleton="1" />
<row itemID="1240652241" typeID="3640" quantity="1" flag="27" singleton="1" />
</rowset>
</row>
I haven't traced through all the code to see if you are handling that yet but I didn't notice anything like that being done.
Anyway, that's it for now, time for bed
Cheers
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.26 05:17:00 -
[13]
Thanks for all the feedback.
That path issue is rather odd, I've been using exactly this format for include_path setting on Linux and Windows, under IIS and Apache, and it's never given me problems. Your suggestion is the correct way of doing it though, so I'll factor that into the next update.
Also not sure why you had an issue inserting an empty date on signup, but I'll get that sorted as soon as possible. What MySQL version are you using?
Finally thanks for the great insights into how assets and their locations work, I have a much better understanding of how this all works now.
Looks like a new version is going to have to come out pretty soon .
|
Dragonaire
Caldari
Corax.
|
Posted - 2008.11.26 06:57:00 -
[14]
$sql='case
when o.stationID between 66000000 and 66015131
then (select s.stationName from dbo.staStations as s where s.stationID=o.stationID-6000001)
when o.stationID between 66015132 and 67999999
then (select c.stationName from ConquerableStationList as c where c.stationID=o.stationID-6000000)
else (select m.itemName from dbo.mapDenormalize as m where m.itemID=o.stationID)
end as location from marketorders as o';
Just in case you'd rather do it with SQL I thought I'd post what I came up with to do it.
--
Finds camping stations from the inside much easier.
Been known to write some PHP code for API from time to time too. |
Maglorre
|
Posted - 2008.11.26 12:00:00 -
[15]
Originally by: Azazel Mordred
That path issue is rather odd, I've been using exactly this format for include_path setting on Linux and Windows, under IIS and Apache, and it's never given me problems. Your suggestion is the correct way of doing it though, so I'll factor that into the next update.
I had the same thought when I was fiddling around getting it to work. In hindsight I think it was the directory separator more than the path one that fixed it.
Originally by: Azazel Mordred
Also not sure why you had an issue inserting an empty date on signup, but I'll get that sorted as soon as possible. What MySQL version are you using?
Quote:
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(32) NOT NULL,
`password` varchar(64) NOT NULL,
`email` varchar(32) NOT NULL,
`timezone` varchar(128) NOT NULL default 'GMT',
`theme` varchar(64) NOT NULL,
`proxy` varchar(256) NOT NULL,
`level` tinyint(4) NOT NULL,
`account_id` int(11) NOT NULL,
`activetime` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`password`)
);
That's from your install-db.sql. It is a not null field with no default value
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.26 16:57:00 -
[16]
Oh bugger, I scripted it wrong 
|
Tourim
|
Posted - 2008.11.27 14:32:00 -
[17]
Okay... my understanding of mysql and php is rather limited. I installed ooe on my macbook. At the beginning it went fine but as I tried to login, after registration, I got a blank page. Since I'm a total php-n00b I fooled a bit around with some text outputs in the functions and found that it crashes during the loadPlugins function after the line $newPlug....
I'm running:
Apache 2.0.59
MySQL 5.0.41
PHP 5.2.3
curl 7.16.2
mcrypt 2.5.8
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2008.11.27 16:26:00 -
[18]
Originally by: Azazel Mordred
Apologies, caught me doing some quick DB changes :). It's all back up now.
Sooory mate, isn't it just said that you're using 'root' user to access database? What you're using as brain replacement if that's true?
--
Thanks CCP for cu |
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2008.11.27 16:31:00 -
[19]
Originally by: Maglorre
OK,
Got a few things to report.
I set it up under Zend Core on a Windows box (normally use Unix/Linux at work but just don't have one at home right now). Had to do a bit of fiddling with path and directory separators in the config files to make it all happy. For example
Quote:
ini_set('include_path', ini_get('include_path') . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'libs' . PATH_SEPARATOR . dirname(__FILE__) . DIRECTORY_SEPARATOR . 'eve');
Basically, make use of DIRECTORY_SEPARATOR and PATH_SEPARATOR constants in the config.php and site.php instead of / and : and it all works fine (sort of).
Real bugger is PATH_SEPARATOR.
Windows handle "/" as directory separator just fine. Since DOS 3.30 at least.
--
Thanks CCP for cu |
Key Nas
|
Posted - 2008.11.28 11:31:00 -
[20]
First of all a very nice utility. Has almost all that you would wish to use, it is over the web and I am sure there is the base to enhance it with more functionality.
I used it and thought to report the following issues:
- Mining Utility misses mining equipment(i.e strip miner II) and mining products (i.e. ice ores)
- Profitability Tool has memory issues. Couldn't get it to work with the characters that have a lot of BPOs. Might want to look into such issues...
- Some redirects get you to wrong url. For example I use a url patter or domainname:port and when I select another account I am redirected to simple domainname rather than domainname:port. Surely I can add it by hand, but is annoying :)
These for now and I will surely come back to you with more feedback, remarks. Thank you for a great tool!
|
|
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.30 11:44:00 -
[21]
Originally by: Tonto Auri
Originally by: Azazel Mordred
Apologies, caught me doing some quick DB changes :). It's all back up now.
Sooory mate, isn't it just said that you're using 'root' user to access database? What you're using as brain replacement if that's true?
Luckily anyone with half a brain replacement knows that a) you never allow logins from any host but localhost (unless you require a specific user to have remote access) and b) you do not allow connections to your database server at all from the outside world.
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.11.30 18:47:00 -
[22]
Just released update 1.2, incorporating a bunch of fixes and updates based on feedback received so far.
I've also done a clean install of the site along with a fresh install of Apache2/PHP5/MySQL5 on my Ubuntu system to ensure everything works as expected, and it does seem to work out-the-box, with zero Apache or PHP configuration modifications.
Thanks for all the feedback.
|
Grim
Amarr
Fallen Angel's
Blade.
|
Posted - 2008.11.30 18:55:00 -
[23]
Edited by: Grim on 30/11/2008 18:56:52
EDIT - Wrong Post, I tis retared.
--
Death By Titan :( |
Nuran DeSiad
Gallente
Fleet of the Damned
Dark Trinity Alliance
|
Posted - 2008.12.01 15:34:00 -
[24]
Hey,
I've followed the instructions in the install.txt, but when trying to enter the site, I get the following error:
Fatal error: Class 'PDO' not found in /var/www/test.somecorpurl.net/htdocs/ooe/outofeve/includes/database.php on line 15
I'm not a php/sql guru, so any hints or tips are appreciated.
|
Azazel Mordred
Minmatar
Cloak of Shadows
|
Posted - 2008.12.01 16:21:00 -
[25]
Do you know what PHP version you are using? If you're using at least PHP 5.1, the PDO stuff should be enabled by default - make sure you have a MySQL extension enabled/installed as well. If you're using a PHP 5 version less than PHP 5.1, unfortunately you may need to enable PDO support manually.
To see your current PHP configuration and enabled modules, create a new .php file somewhere in your htdocs/www directory with the following content:
<?php
phpinfo();
?>
|
Nuran DeSiad
Gallente
Fleet of the Damned
Dark Trinity Alliance
|
Posted - 2008.12.01 18:33:00 -
[26]
Hi,
php version is 5.2.6, but PDO is disabled. Since it is not my system, I have to ask the administrator to enable PDO support.
Thanks for pointing this out !
cheers,
Nuran
|
Tourim
|
Posted - 2008.12.01 21:06:00 -
[27]
Edited by: Tourim on 01/12/2008 21:06:31
Hi!
After a bit of work I got ooe to run. The mistake, as aspected, has been on my site. So... now I got a nice overview of this really great app and have some features I would love to request.
- It would be great to have the prizes of every item in the asset view. Those prizes could be cached once or twice a week. Amybe even for the region the item is in (and jita).
- A reprocess calculator would be nice
- Some nice visual presentation of the data would be cool. Maybe that will help u (http://www.liquidx.net/plotkit/) If u want some help with the javascript stuff maybe I can help u out a bit.
thx again.
TouriM
|
Nuran DeSiad
Gallente
Fleet of the Damned
Dark Trinity Alliance
|
Posted - 2008.12.02 10:50:00 -
[28]
OK, PDO is enabled, and now the site is working too ! Great.
Now, this outoefeve site is part of our corporation website, which runs on Joomla.
Is it possible to link the login of Outofeve to the Joomla login ??
cheers,
Andy
|
Ben Thomas
Caldari
Legion of Ascension
|
Posted - 2008.12.02 22:57:00 -
[29]
Edited by: Ben Thomas on 02/12/2008 23:01:38
Azazel - awesome app, thanks! - Spent an hour or so today fixing some of the bugs/problems etc. I noticed.
Changelog:
Quote:
Bugs Fixed:
Changing password via preferences now works, it did not previously.
Added missing level 0 skill image to all templates.
Added 0 to roman numerals function, so correct level is given for level 0 skills.
Cosmetic Changes:
Typo "Availabe Items" changed to "Available Items" under Market Prices.
Paid From changed to Paid By under Journal.
Remain. changed to Remaining under Market Orders.
Optional Downloads:
Created Blueprint Pack - As all blueprints were missing from the graphics pack.
Bugfixes Only - ooe-fixes.tar.bz2
Instructions: After extracting outofeve-1.2qr, extract this in the outofeve main folder using: tar --overwrite -xjf ooe-fixes.tar.bz2
Blueprint Images - ooe-blueprints.tar.bz2
Instructions: After extracting outofeve-1.2qr, extract this in the eveimages folder using: tar -xjf ooe-blueprints.tar.bz2
It is important to follow the instructions, as the files have the directory structure etc. already set up and will overwrite the required files automatically where necessary.
Both downloads are here.
Hope this helps.
---
Founder, CEO - Legion of Ascension |
buyenne
Steel Daggers
Sev3rance
|
Posted - 2008.12.03 01:40:00 -
[30]
Hi,
gratz to that nice software. I like it a lot. Managed to install it and make it run. Solved most of the problems I had. Having only one problem left (maybe its related to the late/early) time. I get once I have set up a new char with Full API this message many many times in the background:
Warning: Division by zero in /homepages/xxxxxxx/outofeve/includes/functions.php on line 146
Does it have something to do with ooekeypass?
If yes, I have no clue what I missed there.
Thanks a lot and fly safe
--
|
|
|
|
|
| |
|
| Pages: [1] 2 3 4 5 6 7 8 9 :: one page |
| First page | Previous page | Next page | Last page |