open All Channels
seplocked EVE Technology Lab
blankseplocked Out of Eve 1.6-AP - Character and Corporation info web app
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5 6 7 8 9

Author Topic

Azazel Mordred
Minmatar
Cloak of Shadows
Posted - 2008.11.24 20:44:00 - [1]
 

Edited by: Azazel Mordred on 06/07/2009 17:43:38
Hi

For the original post, see this thread. For a brief overview of all features, some screenshots, and source downloads, see the about page.

Presenting Out of Eve 1.6-AP, brought up to Apocrypha-spec, along with a number of fixes and additions. The Out of Eve website and source have been updated to version 1.6-AP.

What's changed in 1.6?

  • Many PHP errors/notices cleaned up.

  • API errors are reported clearer, and without making the page in the background unusable.

  • Production Profitability plugin shows corp blueprints.

  • API key encryption can be disabled if you're having trouble setting it up, and are perhaps running a secure private OOE website.

  • Added new precache.php script, which can be triggered periodically from a cron or other mechanism:
    Precaching loads all API data for an account's currently selected character, allowing smoother page loads.
    Each account can have the option enabled or disabled (default).
    Precaching can also be disabled site-wide via config file.

  • Updated all icon displays to prefer type graphics rather than icons (T3 ship graphic fix).

  • Completed industry jobs and market orders are hidden by default.



What's changed in 1.5?

  • Fixed problems with new user registration.

  • Better automatic display of the corporation menu when characters are not directors.

  • Additionally, under Account settings (not user preferences), there are options to force the various corporation menu options to show up if you're not a director, or some other factor is preventing them from being shown.

  • User preference to show small menu icons.

  • Various tweaks to display of the character sheet.

  • Improved display of some elements on the corporation sheet when character is not a director.

  • Substitute "?" icon is shown for items which do not have graphics of their own.

  • Assets -> Ships display should now display ships from within other containers.

  • All views show a message along the lines of "No data available", rather than having a blank page.

  • Open Market Orders show percentage complete.

  • Production profitability tool allows filtering of blueprints by type.

  • Deaths by NPCs try to show rat type in place of pilot name if possible.



Upgrade note (upgrades from version 1.5): You will need to run the "update-db-1.5-1.6.sql" script on this database to add a new field to the accounts table.

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

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 Very Happy

Faife
Dreddit
Test Alliance Please Ignore
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.

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 Very Happy

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
Kumiho's Smile
Posted - 2008.11.25 05:35:00 - [7]
 

very nice

Mal Plox
Gallente
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]
 

Edited by: Azazel Mordred on 25/11/2008 06:49:23
Indeed! It was a my bad, which I was correcting while breaking at the same time Razz.

Thanks for the feedback so far.

Faife: EveMon is a pretty awesome application, one I have no intention of even trying to replicate Smile. 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: Not loading up the initial assets list for large lists of assets is a great idea. I think I also need to extend the search to find system names.

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 Sad.

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
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.

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 Very Happy

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 Smile.

Dragonaire
Caldari
Corax.
PURgE Alliance
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. Smile

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 Very Happy

Azazel Mordred
Minmatar
Cloak of Shadows
Posted - 2008.11.26 16:57:00 - [16]
 

Oh bugger, I scripted it wrong EmbarassedEmbarassedEmbarassedEmbarassedEmbarassed

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?

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.

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:

  1. Mining Utility misses mining equipment(i.e strip miner II) and mining products (i.e. ice ores)

  2. 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...

  3. 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
Posted - 2008.11.30 18:55:00 - [23]
 

Edited by: Grim on 30/11/2008 18:56:52
EDIT - Wrong Post, I tis retared.

Nuran DeSiad
Gallente
Plain Trash
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,EmbarassedEmbarassed 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
Plain Trash
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
Plain Trash
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
SCORN.
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.

buyenne
Gallente
Steel Daggers
Gentlemen's Agreement
Posted - 2008.12.03 01:40:00 - [30]
 

Edited by: buyenne on 04/12/2008 00:26:13
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

Edit: looks like I ve made a wrong path to the ooekeypass in the config.php file. Works all fine now.



Pages: [1] 2 3 4 5 6 7 8 9

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


 


The new forums are live

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

These forums are archived and read-only