| Pages: 1 2 3 4 5 6 7 8 :: [one page] |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Ray McCormack
hirr
   |
Posted - 2007.07.16 09:34:00 -
[1]
DEMO Available Now
DOWNLOAD Available Soon
This is the first public release of the (Sexy) Offline Wallet. Feedback, bug reports and feature suggestions are most welcome, and are what will drive the development of the Offline Wallet. Collaborators are more than welcome, and needed, to help develop it too.
Many thanks to Proton Power for the use of his API Key, without which this DEMO would not be available.
Further work is needed this week to ready the script for a Beta Release, so expect a download to be available by the weekend.
REQUIREMENTS PHP5, MySQL 4/5, GDLib 2
| Researched BS BPOs | BMBE ISK Loans | |
Ray McCormack
hirr
|
Posted - 2007.07.16 09:34:00 -
[2]
Edited by: Ray McCormack on 16/07/2007 09:37:39
BUGS and LIMITATIONS
This is a list of known bugs and limitations. The aim is to have nothing on this list.
- Corporation Update loops through confirmation display.
- CURL is only method of fetching API data.
- Graphs don't distinguish between Sell and Buy orders.
- There is no Home page.
| Researched BS BPOs | BMBE ISK Loans | |
Ray McCormack
hirr
|
Posted - 2007.07.16 09:35:00 -
[3]
FEATURE and DESIGN REQUESTS
| Researched BS BPOs | BMBE ISK Loans | |
Sunset Atrea
Minmatar
Sunset Asset Management
|
Posted - 2007.07.16 10:10:00 -
[4]
That's probably the best wallet / transaction manager i've seen so far. |
Skidmarks
|
Posted - 2007.07.16 16:08:00 -
[5]
Will you be incorporating sell/buy orders into this as well?
Just wondered if you are could, you make it so it can compare order stock levels with amounts sold, IE ive got 50 of item A and I sold 5 today so I have 45 left so no need to re-order the item.
All these tools coming out I feel like its christmas.
Nice looking tool 
|
Ray McCormack
hirr
|
Posted - 2007.07.16 16:47:00 -
[6]
 Originally by: Skidmarks
Will you be incorporating sell/buy orders into this as well?
Yes.
Originally by: Skidmarks
Just wondered if you are could, you make it so it can compare order stock levels with amounts sold, IE ive got 50 of item A and I sold 5 today so I have 45 left so no need to re-order the item.
Like a real-time order tracker? Or a stock tracker? Both are planned, although I'm delaying the former as I'm hoping CCP add it to the API. The latter would be an add-on that could be populated from your orders or manually updated.
| Researched BS BPOs | BMBE ISK Loans | |
Skidmarks
|
Posted - 2007.07.16 17:07:00 -
[7]
At the moment I am currently have to go through all my sell transactions and compare them to my sell orders in market/sell orders
I Am looking for a way so that I can just export my sales and then import my buy/sell orders and make it nice and easy to know if an item is running low on stock and need to buy more of it, if you get what I mean.
I have 900 sell orders and it takes me a while to go through them all compareing sales with stock level.
I usually do this once a week.
Hope that makes sense.
|
Motivated Prophet
Zerodot Schools
Power Corrupts Industry's
|
Posted - 2007.07.16 17:42:00 -
[8]
Originally by: Skidmarks
At the moment I am currently have to go through all my sell transactions and compare them to my sell orders in market/sell orders
I Am looking for a way so that I can just export my sales and then import my buy/sell orders and make it nice and easy to know if an item is running low on stock and need to buy more of it, if you get what I mean.
I have 900 sell orders and it takes me a while to go through them all compareing sales with stock level.
I usually do this once a week.
Hope that makes sense.
Perfectly.
That's the app I'm trying to build at the moment.
MP
--
Proud steward of 47 billion isk in public money, and counting. Ask me about mineral compression! |
Blazing Fire
Interstellar Operations Incorporated
|
Posted - 2007.07.17 14:08:00 -
[9]
Looks awesome.
I wonder what the price of this tool will be
Blazing Fire
CEO
Interstellar Operations Incorporated
Corp web site
Recruting
Services
[Service] Killboard hosting
[Service] Forum hosting
[Service] Web site hosting
[Service] Obelisk loaning
[Service] Alliance Creation
|
Erfnam
Time Cube Syndicate
|
Posted - 2007.07.17 17:15:00 -
[10]
Originally by: Blazing Fire
Looks awesome.
I wonder what the price of this tool will be
Open Source implies free.
-
Recruiting | Capital Ships Sales | Covetors Delivered - Bulk/Package/BYOM
|
Blazing Fire
Interstellar Operations Incorporated
|
Posted - 2007.07.17 21:19:00 -
[11]
Originally by: Erfnam
Originally by: Blazing Fire
Looks awesome.
I wonder what the price of this tool will be
Open Source implies free.
Yeah, I know, just missed that part when reading the OP.
My bad.
Blazing Fire
CEO
Interstellar Operations Incorporated
Corp web site
Recruting
Services
[Service] Killboard hosting
[Service] Forum hosting
[Service] Web site hosting
[Service] Obelisk loaning
[Service] Alliance Creation
|
Motivated Prophet
Zerodot Schools
Power Corrupts Industry's
|
Posted - 2007.07.17 21:36:00 -
[12]
Originally by: Erfnam
Originally by: Blazing Fire
Looks awesome.
I wonder what the price of this tool will be
Open Source implies free.
Not really, no.
But it often is.
MP
--
Proud steward of 47 billion isk in public money, and counting. Ask me about mineral compression! |
Havok Pierce
Gallente
Black Lance
oooh Shiny
|
Posted - 2007.07.17 22:59:00 -
[13]
Originally by: Erfnam
Originally by: Blazing Fire
Looks awesome.
I wonder what the price of this tool will be
Open Source implies free.
Open Source implies "Hey, here's the source code too."
GPL -- "Here's the source. If you make changes and redistribute, you MUST include the source yourself."
BSD -- "Here's the source, do whatever, just don't bug me when it breaks."
|
DeathGrip
Amarr
Dirty Deeds Corp.
Axiom Empire
|
Posted - 2007.07.18 07:50:00 -
[14]
Looks good so far. Glad I could be of some use ;)
|
Confuzer
PBA Corporation
The Volition Cult
|
Posted - 2007.07.19 08:30:00 -
[15]
The colors are very bad so it's hard to get an overview, the date column is unreadable, make it smaller...
And where is a statistics function? This is still only a log viewer... I suggest thinking off some neat features to analyse your sales.
-----------------
Destiny is not a matter of chance. It is a matter of choice. It's not a thing to be waited for - it is a thing to be achieved. |
Ray McCormack
hirr
|
Posted - 2007.07.19 08:59:00 -
[16]
Originally by: Confuzer
The colors are very bad so it's hard to get an overview, the date column is unreadable, make it smaller...
What browser and version are you using, what is your resolution? Can you take a screenshot and email it to me? [email protected] The colours are customisable.
Originally by: Confuzer
And where is a statistics function? This is still only a log viewer... I suggest thinking off some neat features to analyse your sales.
Click or search for an item, then click on Overview. This Overview will be integrated into the Home page when the Beta is released. Lots more statistics planned and in development.
| Researched BS BPOs | BMBE ISK Loans | |
Shadow Lightbringer
Daedal Anomaly
Zzz
|
Posted - 2007.07.19 09:12:00 -
[17]
Wow, this looks like an outstanding tool. Looking forward to when the download will be available.
|
Carniflex
Caldari
Fallout Research
Fallout Project
|
Posted - 2007.07.22 12:23:00 -
[18]
Seems interesting. Would defo try it out when it's available for download.
|
Cherybol
Caldari
Es and Whizz
Hedonistic Imperative
|
Posted - 2007.07.22 19:49:00 -
[19]
Bump for an amazing tool that I look forward to using.
|
Skidmarks
|
Posted - 2007.07.23 14:33:00 -
[20]
any ETA on this yet dude?
|
Ray McCormack
hirr
|
Posted - 2007.07.23 15:19:00 -
[21]
Thanks for the kind words and interest so far. I'm just setting up the version control and will make available some pre-release code and downloads either tonight or tomorrow.
| Thanatos BPO ME1 Auction | BMBE ISK Loans | |
Bedrox
Amarr
Lambda Lambda Lambda
|
Posted - 2007.07.24 17:43:00 -
[22]
Wow looks damn good cant wait to get home and try it!
|
Ray McCormack
hirr
|
Posted - 2007.07.24 23:00:00 -
[23]
I have updated the DEMO and made a pre-release Beta available for DOWNLOAD.
| Thanatos BPO ME1 Auction | BMBE ISK Loans | |
Prime Ori
|
Posted - 2007.07.25 08:44:00 -
[24]
Originally by: Ray McCormack
Originally by: Confuzer
The colors are very bad so it's hard to get an overview, the date column is unreadable, make it smaller...
What browser and version are you using, what is your resolution? Can you take a screenshot and email it to me? [email protected] The colours are customisable.
Originally by: Confuzer
And where is a statistics function? This is still only a log viewer... I suggest thinking off some neat features to analyse your sales.
Click or search for an item, then click on Overview. This Overview will be integrated into the Home page when the Beta is released. Lots more statistics planned and in development.
Where can I customize the colors then?
On the left, the dates are always 2 rows, I have a dual monitor at a very high resolution and it stays that way, you have fixed the column width. Even with images of it stays 2 lines.
The average, min and max overview isn't that helpfull imho... it just a small piece of info but not what I was thinking about.
I've started my own tool to reflect my ideas, no open source though 
|
Carniflex
Caldari
Fallout Research
Fallout Project
|
Posted - 2007.07.25 08:45:00 -
[25]
Any possibility of getting 'dumbuser' version where you can just clik at icon and it works  ? Did install php and mysql altho as I have never used neither then can't think out anything what to do next.
Just staring at that 'install.php' script. Can write stuff in fortran and python (if i really need to) but this one seems somewhat ... different. I need to compile that script somehow (under windows xp) ?
|
Ray McCormack
hirr
|
Posted - 2007.07.25 09:02:00 -
[26]
Originally by: Prime Ori
Where can I customize the colors then?
In the CSS file. One of the ideas is to add this as an interface where users can customise everything.
Originally by: Prime Ori
On the left, the dates are always 2 rows, I have a dual monitor at a very high resolution and it stays that way, you have fixed the column width. Even with images of it stays 2 lines.
It is on two rows because I put a <br /> in between the date and time. You can remove this by changing
'.$datetime[0].'<br />'.$datetime[1].' to '.$datetime[0].' '.$datetime[1].'.
This will need to be done in four different files.
Originally by: Prime Ori
The average, min and max overview isn't that helpfull imho... it just a small piece of info but not what I was thinking about.
There is more than an avg, min and max overview. There is a regional breakdown by item, there is a daily, weekly and monthly breakdown of expenditure and income. There will also be a breakdown of transactions over the above periods coming soon, as well as a stock and order tracker. If you let me know what you're thinking I can add it to the REQUESTS list, otherwise I have no idea what it is you're thinking about.
|
Ray McCormack
hirr
|
Posted - 2007.07.25 09:08:00 -
[27]
Originally by: Carniflex
Any possibility of getting 'dumbuser' version where you can just clik at icon and it works?
When there is a full release, yes. During Beta the installation procedure will be constantly worked on and fully integrated into the site.
Originally by: Carniflex
Just staring at that 'install.php' script.
If you've compiled PHP correctly (on WinXP this can be difficult, my suggestion would be to use WAMPServer) you should see the install.php script lists a few different .sql.gz files. You need to import these one by one, and then delete them. Once you've done that, delete the install directory (no real security risk, but better safe than sorry) and run index.php. If this doesn't help please grab me on irc.coldfront.net (#BIG) or ingame for a chat.
|
PenguinJim
|
Posted - 2007.07.25 12:34:00 -
[28]
hmmm did all the installs to my webserver.
However seem to be having an issue keeps saying Auth failure, in the apilog. Checked the API key, UserID and Character ID in the settings file and these were correct.
Any ideas? |
Ray McCormack
hirr
|
Posted - 2007.07.25 13:29:00 -
[29]
Originally by: PenguinJim
However seem to be having an issue keeps saying Auth failure, in the apilog. Checked the API key, UserID and Character ID in the settings file and these were correct.
Any ideas?
Are you using the full API key?
|
Confuzer
PBA Corporation
The Volition Cult
|
Posted - 2007.07.25 14:32:00 -
[30]
Aah I thought it was a GUI based layout change... Offcourse it's always possible in the code ^^
Good luck with yer tool... I'm going to make mine available to the alliance only at first I think 
-----------------
Destiny is not a matter of chance. It is a matter of choice. It's not a thing to be waited for - it is a thing to be achieved. |
PenguinJim
|
Posted - 2007.07.25 14:47:00 -
[31]
Originally by: Ray McCormack
Originally by: PenguinJim
However seem to be having an issue keeps saying Auth failure, in the apilog. Checked the API key, UserID and Character ID in the settings file and these were correct.
Any ideas?
Are you using the full API key?
Yup first thing i checked
|
Ray McCormack
hirr
|
Posted - 2007.07.25 14:54:00 -
[32]
Originally by: PenguinJim
Yup first thing i checked
If you have access to IRC jump on irc.coldfront.net and join #BIG. Otherwise email the URL of apierrorlog.html to [email protected].
|
Ray McCormack
hirr
|
Posted - 2007.07.26 19:06:00 -
[33]
There was a corrupt GZip file in install.zip. This has been fixed and both download locations have been updated. You will need to re-run install.php (only on dbst.sql.gz) to fix this mistake, and should now be able to store data correctly.
|
Thraxon
|
Posted - 2007.07.27 13:28:00 -
[34]
Edited by: Thraxon on 27/07/2007 13:31:57
Nice tool Ray. Real sexeeh
Would be good if you could set it up for multiple users though.
|
Perin Ashedge
Minmatar
Total Information Technology
|
Posted - 2007.07.29 06:34:00 -
[35]
That is indeed a sexy viewer you have made.
I am sure you're going to implement this in the future, but I think I may delve into it and attempt a hack at making it multiple user capable.
|
ThePanu
SouthStar Business Solutions Inc.
|
Posted - 2007.07.30 20:55:00 -
[36]
Bumb for very promising tool.
Rays effort is much appreciated.
|
Sunset Atrea
Minmatar
Sunset Asset Management
|
Posted - 2007.07.31 10:14:00 -
[37]
I'm going to instal this tonight. I have an excel-based one I keep at work, and it does the job, but i'd like something more substantial (and I need graphs!). |
Elisa Day
Koshaku
Interstellar Starbase Syndicate
|
Posted - 2007.07.31 10:41:00 -
[38]
I managed to install this and get it updating, but for some reason I only see things on the journal tab, on the transaction tab it claims I have no transactions, am I missing something?
|
Ray McCormack
hirr
|
Posted - 2007.07.31 21:51:00 -
[39]
Originally by: Elisa Day
I managed to install this and get it updating, but for some reason I only see things on the journal tab, on the transaction tab it claims I have no transactions, am I missing something?
You need to update the Journal and Transactions separately. So update your Transactions (from that tab) and then your Journal (from the Journal tab). Either that or run a cronjob on /cron/api.php and /cron/corpapi.php which will do both for you.
|
Ray McCormack
hirr
|
Posted - 2007.07.31 21:53:00 -
[40]
Originally by: Thraxon
Would be good if you could set it up for multiple users though.
I'll make it multi-user by the weekend. I don't know why I didn't do this from the start, it's something I need myself.
|
RiotRick
Black-Sun
|
Posted - 2007.08.01 07:20:00 -
[41]
An option to disable the "update wallet" buttons would be nice too. So you can set it up for more ppl in your and have a cronjob update the wallet, instead of having ppl updating it manually.
Anyway, it's a great tool, nice job.
|
Elisa Day
Koshaku
Interstellar Starbase Syndicate
|
Posted - 2007.08.01 08:34:00 -
[42]
Originally by: Ray McCormack
...run a cronjob on /cron/api.php and /cron/corpapi.php which will do both for you.
That's what I did to update the information in the first place. The "update this wallet" button does nothing for me on transactions (says 0 entries added). Updating journal works fine.
|
Ray McCormack
hirr
|
Posted - 2007.08.01 08:40:00 -
[43]
Originally by: Elisa Day
That's what I did to update the information in the first place. The "update this wallet" button does nothing for me on transactions (says 0 entries added). Updating journal works fine.
If you access the API directly for your transactions from the character sheet is the XML filled with transactions? Can you check /logs/apierrorlog.html and match any errors to the time you tried to update the transactions?
|
Elisa Day
Koshaku
Interstellar Starbase Syndicate
|
Posted - 2007.08.01 08:53:00 -
[44]
There are no errors in the log, and I can't test if I can download transactions right now because I just tried to update it through the wallet app, and it apparently does at least download the file.
Hm personal transactions says
# error 102: Expected beforeTransID = 381415074: wallet previously loaded.
while corp transactions says
# error 101: Wallet exhausted: retry after 2007-08-01 09:51:56.
|
Ray McCormack
hirr
|
Posted - 2007.08.01 09:11:00 -
[45]
Okay, those are expected errors, it means you are at least getting something from it. It's strange it updates the journal and not the transactions as it's the exact same procedure for both. Can you check in MySQL that there is a `wallet` and a `wcorp` table that have a structure?
|
Elisa Day
Koshaku
Interstellar Starbase Syndicate
|
Posted - 2007.08.01 09:16:00 -
[46]
Edited by: Elisa Day on 01/08/2007 09:21:23
Originally by: Ray McCormack
Can you check in MySQL that there is a `wallet` and a `wcorp` table that have a structure?
Ah, I guess that's the problem, I don't have these, but I do have journal and jcorp.
These tables exist in the dbst.sql file I used though so it's very odd that they didn't get created. I've added them now and hopefully it will work!
It would probably be proper to throw an error message when something like this happens.
|
Ray McCormack
hirr
|
Posted - 2007.08.01 09:27:00 -
[47]
Originally by: Elisa Day
It would probably be proper to throw an error message when something like this happens.
Yeah, I need to sort something out with the database wrapper. It's auto set to false, but it doesn't seem to throw up errors even when set to true. I'll play around with it some and see what I can come up with.
|
Thraxon
|
Posted - 2007.08.03 09:01:00 -
[48]
It would also be nice if we could see when the wallet you are viewing was last updated. Maybe next to the current time tab?
|
Carniflex
Caldari
Fallout Research
Fallout Project
|
Posted - 2007.08.06 06:13:00 -
[49]
How soon could we possibly expect 'dumbuser' version 
Seems rather nice app, I just have not got time yet to kick it around enough to get it actually working (granted I have not been trying hard for RL time issues). Somekind of 'beta' stage (does not need to be entirely stable or fully working) standalone version would be rather awesome.
|
xAsmod
Dark Blade Incorporated
Interstellar Alcohol Conglomerate
|
Posted - 2007.08.08 11:10:00 -
[50]
Originally by: Ray McCormack
Originally by: Thraxon
Would be good if you could set it up for multiple users though.
I'll make it multi-user by the weekend. I don't know why I didn't do this from the start, it's something I need myself.
Hi Ray,
How's this going? I'm looking forward to it :) It would mean I can run stuff properly, I've currently got two wallets setup both using the same DB. It's ok as it allows me to see sales/purchases across both chars.
If you need any help just shout!
|
Koron Eldoran
|
Posted - 2007.08.09 15:58:00 -
[51]
Every time I the data to update want come these error:
Fatal error: Call to undefined function curl_init() in C:\Programme\xampp\htdocs\wallet\functions.php on line 441
|
Ray McCormack
hirr
|
Posted - 2007.08.09 16:39:00 -
[52]
Originally by: Thraxon
It would also be nice if we could see when the wallet you are viewing was last updated. Maybe next to the current time tab?
Sure, but only in a later version when I store all settings in a database.
Originally by: Carniflex
How soon could we possibly expect 'dumbuser' version
I take it you mean a one-click install version? That'll be around only in a much later release. Functionality first. And I don't think it's too hard to setup and install.
Originally by: xAsmod
How's this going?
It's implemented in my current local build. I just need to code some interface filters for it. I've not released it on the SVN yet as it requires a database change, but I'll get an upgrade.zip out over the next few days.
Originally by: Koron Eldoran
Edit: Ok the bug was that the php_curl.dll was not active in php.ini.
Yup, PHP needs to be compiled with CURL. In a future release you won't require CURL, but for now you do.
Originally by: Koron Eldoran
Edit: Mh this Tool only for the Corpmainwallet not for the other Corpwallets?
Nope, it's for all the wallets. You just need to pick which division you want from the drop-down list.
|
Cpt Fina
Insult to Injury
|
Posted - 2007.08.10 02:31:00 -
[53]
I have no friggin idea how to install this 
Your signature exceeds the maximum allowed filesize of 24000 bytes -TheDagda ([email protected]) |
Ray McCormack
hirr
|
Posted - 2007.08.10 09:16:00 -
[54]
Originally by: Cpt Fina
I have no friggin idea how to install this
Install
|
Jennifer Christage
Token Industries
|
Posted - 2007.08.10 14:31:00 -
[55]
Cheers for the great app. Got a small problem where no records or shown and when I click the "update this wallet" I get a blank page back (the nav bar at the stop shows but no content). Any ideas? Thanks
|
Ray McCormack
hirr
|
Posted - 2007.08.10 15:48:00 -
[56]
Originally by: Jennifer Christage
Cheers for the great app. Got a small problem where no records or shown and when I click the "update this wallet" I get a blank page back (the nav bar at the stop shows but no content). Any ideas? Thanks
Have you installed all the database tables?
|
Jennifer Christage
Token Industries
|
Posted - 2007.08.10 21:18:00 -
[57]
Just been through them all again and imported them. I think it made 13 new tables in the database, but the same problem showing no data.
|
Hettere Lema
MAAK Industries
|
Posted - 2007.08.10 21:41:00 -
[58]
You need Php 5 compiled with CURL. with php4, i had a blank page too, upgrade php to php5 and it worked. |
Ray McCormack
hirr
|
Posted - 2007.08.10 21:55:00 -
[59]
Originally by: Jennifer Christage
Just been through them all again and imported them. I think it made 13 new tables in the database, but the same problem showing no data.
Another problem may be in update.php; change this line (which occurs four times) :
if ($xml->error) {
to this :
if (!empty($xml->error)) {
For some reason that makes a difference on a few compilations, not sure why yet.
|
Ray McCormack
hirr
|
Posted - 2007.08.10 22:01:00 -
[60]
Originally by: Hettere Lema
You need Php 5 compiled with CURL. with php4, i had a blank page too, upgrade php to php5 and it worked.
Correct, because of the Simple XML function as the CURL function. As it's a beta I'm just running with those for now, the full release will support both versions. For now coding is focused on functionality and sexuality (cough) rather than compatibility. Also, Javascript will be a requirement for the next release; and there's a UI direction change that will deviate from the 'browse' structure that is currently in place.
|
Jennifer Christage
Token Industries
|
Posted - 2007.08.10 23:56:00 -
[61]
Aha... I'm missing php5. Coulda sworn my host had installed it. Time to mail them.. Thanks for the help guys, much appreciated.
|
Koron Eldoran
|
Posted - 2007.08.11 18:02:00 -
[62]
Two Bugs:
1. ISK shifted from a Wallet on another Wallte we these at the total balance taken off.
2. On Overview -> Corperation. The "ISK out" and "ISK in" are the woth of the Personal Wallets.
|
matarkhan
ConHugeCo
|
Posted - 2007.08.12 07:02:00 -
[63]
Oh man, this is just what I've been looking for. I've gotten it up and running, and i LOVE the monthly overview, even though last month was pretty painful (I bought another toon).
If anyone is running into issues with curl on Ubuntu, the fix is to make sure all of the curl stuff is installed, just dropping in php5-curl doesn't do the trick for some reason. Just use this line:
Quote:
sudo apt-get install curl libcurl3 libcurl3-dev php5-curl
There are features I'd like to see, but I can't fully put them into words yet, and I'd like to see what else is on your own agenda first anyway.
Again, great work.
|
xAsmod
Dark Blade Incorporated
Interstellar Alcohol Conglomerate
|
Posted - 2007.08.12 23:25:00 -
[64]
Originally by: matarkhan
Oh, and also.... what is it using to draw the graph on the front page? It's failing on my install, so I must be missing something...
I believe it's libgd
|
ResearchBot 9
|
Posted - 2007.08.13 02:48:00 -
[65]
I noticed later that it's JPGraph.
It's lib-jpgraph in Ubuntu, but you do indeed need to install gd first, which again in Ubuntu is php5-gd.
|
Zolcan
Amarr
Sovereign Enterprises
|
Posted - 2007.08.13 03:22:00 -
[66]
This looks like a great tool Ray but I don't know anything about phpxyz-whatever. Is this something code-dummies like myself can make use of? Your directions don't look too bad but I want to make sure before I try it and blow something up.
Zolcan
SOVEREIGN WEBPAGE
|
Ricdic
Caldari
Corporate Research And Production Pty Ltd
Zzz
|
Posted - 2007.08.13 07:41:00 -
[67]
Originally by: Zolcan
This looks like a great tool Ray but I don't know anything about phpxyz-whatever. Is this something code-dummies like myself can make use of? Your directions don't look too bad but I want to make sure before I try it and blow something up.
Zolcan
Agreed, I might get La Vista to host this through www.eve-bank.net and possibly offer it to the public in some way (if it isn't hard to do, and not against your rules etc)
Need Empire Research Slots. Click here |
Ray McCormack
hirr
|
Posted - 2007.08.13 10:13:00 -
[68]
Originally by: Koron Eldoran
1. ISK shifted from a Wallet on another Wallte we these at the total balance taken off.
Sorry, I don't quite understand that.
Originally by: Koron Eldoran
2. On Overview -> Corperation. The "ISK out" and "ISK in" are the woth of the Personal Wallets.
Will fix that.
Originally by: Zolcan
This looks like a great tool Ray but I don't know anything about phpxyz-whatever. Is this something code-dummies like myself can make use of?
It's fairly easy to do, you just need to ensure you've followed the instructions correctly. You can even run it locally on WinXP by installing WAMPServer and then making sure you have php_curl and php_gd2 checked under PHP Settings (easily done with one click from the tasktray icon).
|
Koron Eldoran
|
Posted - 2007.08.13 11:23:00 -
[69]
Edited by: Koron Eldoran on 13/08/2007 11:28:20
Edited by: Koron Eldoran on 13/08/2007 11:24:04
Originally by: Ray McCormack
Originally by: Koron Eldoran
1. ISK shifted from a Wallet on another Wallte we these at the total balance taken off.
Sorry, I don't quite understand that.
Ok,
On Corpwallet one i have 5.000.000 ISK.
On Corpwallet two i have 0 IKS.
In the Balance-Graph on the Page Overview i have now 5.000.000 ISK
Now i switch the 5.000.000 form Corpwallet one to Corpwallet two.
In the Balance-Graph on the Page Overview i have now 0 ISK
|
Ray McCormack
hirr
|
Posted - 2007.08.13 11:37:00 -
[70]
Ah, okay, I getcha now. The corporate wallet graph is only for the master wallet at the moment. You'll be able to choose a specific one soon, as well as have a total balance graph.
|
Proton Power
Amarr
Power Corrupts Tech
Axiom Empire
|
Posted - 2007.08.13 11:38:00 -
[71]
If you need me to make a few corp transactions in differant wallets let me know. I normally don't use them but can if it would better help you test.
-----------------------------------------------
http://oldforums.eveonline.com/?a=topic&threadID=439797Cli |
ResearchBot 9
|
Posted - 2007.08.14 01:40:00 -
[72]
Aright, I gotta ask...
Proton Power, what kinda toon or BPO do you get for 15b? 
|
DeathGrip
Amarr
Dirty Deeds Corp.
Axiom Empire
|
Posted - 2007.08.14 02:14:00 -
[73]
Originally by: ResearchBot 9
Aright, I gotta ask...
Proton Power, what kinda toon or BPO do you get for 15b?
T1 Frigate BPO Set. Its at ME1000 though so I figure in like 100 years if I produce non stop I will get my isk back. SOmthing I can pass onto my son, and he can pass onto his son.
On a more serious note if your talking about the 15bil with Rome that was a small loan he gave me for a few months so I could keep some things moving.
|
Thraxon
Black-Sun-Inventions
|
Posted - 2007.08.14 11:42:00 -
[74]
Edited by: Thraxon on 14/08/2007 11:44:32
I think it would be extremely useful if you split the 'average', 'minimum', 'maximum' prices and volumes in items sold and bought.
For example in places where you filter on an item (in transactionss) and when click on overview when filtered. This will enable traders to get a much better insight on their margin for an item.
The filtered view can be switched from both / sell / buy, but the above mentioned prices/volumes don't change accordingluy.
|
Altaree
Red Frog Investments
|
Posted - 2007.08.14 12:55:00 -
[75]
Cool, the comments on the install script helped me get this installed. At least now I know what I need to have running before unzipping the archive.
|
Hattur
Gallente
Viktor Research Incoporated
New Eden Research
|
Posted - 2007.08.18 14:54:00 -
[76]
Congrats, amazing tool :)
---
Need Research Slots? Click here! |
Gwen Horach
Gallente
Satriales Pork Store
|
Posted - 2007.08.23 07:24:00 -
[77]
really nice tool.
any progress?
like a working multi account support or splitting on the overview page in buy and sell?
|
Shar Tegral
|
Posted - 2007.08.24 23:47:00 -
[78]
Excellent tool. Real easy to setup (including Wamp5). Easy to use as well. Just remember to space your updates a bit our you'll be pulling empty documents. (And feel foolish too)
It's A GIRL!!!!! |
Avalira
Caldari
Confederation of Independent Corporations
|
Posted - 2007.08.25 14:34:00 -
[79]
Really nice tool! Good job and thank you very much for sharing it with the rest of us .
I wanted to ask (not being a php pro myself), is there a way to keep the setup.php outside the webroot? In some php forums or websites (like phpBB2 or Nuke) you can put the config.php outside the webroot (ie, unaccessable from outside). If not, then how secure is it leaving my details like this in the setup file?
Thanks.
|
Rix Machur
Gallente
Trader's Academy
Daikoku Trade Syndicate
|
Posted - 2007.08.25 14:45:00 -
[80]
This wallet rocks. Good work!
Originally by: Avalira
I wanted to ask (not being a php pro myself), is there a way to keep the setup.php outside the webroot? In some php forums or websites (like phpBB2 or Nuke) you can put the config.php outside the webroot (ie, unaccessable from outside). If not, then how secure is it leaving my details like this in the setup file?
I had a look at the code when I downloaded it (I have some php experience) and from what I can see, the settings.php can go anywhere in the tree but you'd have to change the code. I've done this with the few php apps I've coded although (and I am very very far from being an expert) I think that the security of this has much more to do with the php setup, error logging and general account security than the location of the file. If you try to access settings.php from a browser, you won't see anything back.
You could setup your .htaccess to stop people from accessing the whole folder if you wanted.
Rix.
|
Skolima
|
Posted - 2007.08.29 18:05:00 -
[81]
Edited by: Skolima on 29/08/2007 18:05:48
Congratulations on your work. However, I am missing a bit of functionality :-) Namely, income per item statistics. I hacked a dirty patch that is attached to the feature request , but this is more and illustration of what would be useful.
Also, a comparison report, showing which items gave best income and which generated the hugest loss would be nice..
|
Ray McCormack
hirr
|
Posted - 2007.08.29 19:11:00 -
[82]
This is a screenshot from my local version. From what I can tell it gives you everything your mod does.
I still need to add support to differentiate between characters for the new multi-character environment. This needs to be a seamless integration, so I was thinking of just placing tabs along the top of the graph. I also want to add a mini-browser in the whitespace to the left of the graph so you can view the transactions that make up the data.
I will wait for CCP to issue a new data dump before releasing a new eveow version, which should be at the weekend.
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
Skolima
|
Posted - 2007.08.29 19:53:00 -
[83]
Brilliant! :-D
|
Thraxon
Black-Sun-Inventions
|
Posted - 2007.08.31 08:07:00 -
[84]
Originally by: Ray McCormack
This is a screenshot from my local version.
That's very promising. Look forward to it!
|
ResearchBot 9
|
Posted - 2007.09.06 18:24:00 -
[85]
Something occurred to me this morning....
Since you're tracking all of the sales data, including when/how many items are put on the market, then tracking when they're sold, it would be possible to keep an inventory list of what remains on the market unsold....
|
Femintaki
Gallente
Black Nova Corp
Band of Brothers
|
Posted - 2007.09.08 14:19:00 -
[86]
Downloaded this and installed WAMP - but not clever enough to get it all up and running. Do you have any "Really noddy" instructions for complete technophobes like me who know nothing about WAMP etc??
What I am looking for is astep by step, blow by blow set of instructions for setting it up :) Please ....
Quote:
Do or do not - there is no try!
|
Ray McCormack
hirr
|
Posted - 2007.09.08 16:32:00 -
[87]
Originally by: Femintaki
What I am looking for is astep by step, blow by blow set of instructions for setting it up
1) Install WAMP (for security reasons run in offline mode).
2) In your browser visit http://localhost/phpmyadmin/.
3) Create a new database table called wallet.
4) Left-click on the WAMP tray icon and browse to PHP settings, PHP extensions and make sure php_curl and php_gd2 are checked.
5) Unzip the archives to a sub-directory named wallet in your www folder (default is c:\wamp\www\).
6) Edit settings.php with your API and MySQL information. For WAMP your connection info would be : server = localhost; username = root; password = ; db = wallet.
7) In your browser visit http://localhost/wallet/install/install.php and import each file.
7.1) If you have trouble importing the files, use WinRar to uncompress the .gz files to the same directory. Then left-click on the WAMP tray icon and select MySQL, MySQL Console. In the new console window press enter to confirm a blank password, and then type "\r wallet" and then for each file type "\. c:\wamp\www\wallet\install\filename.sql". Type "exit" to close the console.
8) Once installed browse to http://localhost/wallet/ and visit each wallet to click on Update.
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
Avalira
Caldari
Confederation of Independent Corporations
|
Posted - 2007.09.08 22:48:00 -
[88]
Finally got it to work by installing it locally instead of on my webhost. Very nice software, can't wait for the new version!
Thanks
|
Draycar Hazaran
Uninvited Guests
|
Posted - 2007.09.09 03:28:00 -
[89]
Great tool! Ray was kind enough to aid me via IRC when I had trouble with the import process, and it worked immediately thereafter. I very much look forward to future builds!
|
Shar Tegral
|
Posted - 2007.09.09 05:16:00 -
[90]
If you are taking suggestions, not like you need the, for this fine piece of software:
- Updating Alternatives.
I.e. Single update button or possibly a timecheck function for an automated update on page load.
- Unlimited Record Return
For when you filter your summaries.
- Format Free Reports
For easy copy and paste into other mediums.
Thanks for this great software.
It's A GIRL!!!!! |
ResearchBot 9
|
Posted - 2007.09.09 15:21:00 -
[91]
Are we still waiting on CCP's new data dump for the new version?
|
Thraxon
Black-Sun-Inventions
|
Posted - 2007.09.10 08:20:00 -
[92]
Originally by: Shar Tegral
If you are taking suggestions, not like you need the, for this fine piece of software:
- Updating Alternatives.
I.e. Single update button or possibly a timecheck function for an automated update on page load.
You can setup cron jobs for this. Mine updates automatically every 1 1/2 hours.
Originally by: Shar Tegral
- Unlimited Record Return
Isn't this limited by the CCP data feed?
|
Shar Tegral
|
Posted - 2007.09.10 08:23:00 -
[93]
Originally by: Thraxon
You can setup cron jobs for this. Mine updates automatically every 1 1/2 hours.
Well I'm using the wamp installation to run "Sexy" locally so cron jobs isn't an available solution.
Originally by: Thraxon
Originally by: Shar Tegral
- Unlimited Record Return
Isn't this limited by the CCP data feed?
I meant for "Sexy" to create unlimited record returns for the data already stored.
It's A GIRL!!!!! |
Avalira
Caldari
Confederation of Independent Corporations
|
Posted - 2007.09.10 20:11:00 -
[94]
Originally by: Shar Tegral
Originally by: Thraxon
Originally by: Shar Tegral
- Unlimited Record Return
Isn't this limited by the CCP data feed?
I meant for "Sexy" to create unlimited record returns for the data already stored.
That would be awesome and allow us to keep on record more than 1000 entries.
|
Ray McCormack
hirr
|
Posted - 2007.09.10 20:26:00 -
[95]
Originally by: Avalira
Originally by: Shar Tegral
Originally by: Thraxon
Originally by: Shar Tegral
- Unlimited Record Return
Isn't this limited by the CCP data feed?
I meant for "Sexy" to create unlimited record returns for the data already stored.
That would be awesome and allow us to keep on record more than 1000 entries.
Can someone explain exactly what they mean by this? You can return as many entries as are stored since you started updating your wallet. Or do you mean display an unlimited amount of entries on a single page?
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
Avalira
Caldari
Confederation of Independent Corporations
|
Posted - 2007.09.11 03:08:00 -
[96]
We might have jumped the gun, but what we wanted is for previous records to stay, so that you can see the progression over a year or more. After using Sexy OW for a week now it does seem like this is the case. Am I correct in assuming that you keep old records of the API data?
|
Shar Tegral
|
Posted - 2007.09.11 04:27:00 -
[97]
Originally by: Ray McCormack
Or do you mean display an unlimited amount of entries on a single page?
That was all I was suggesting myself. Currently Sexy limits each page to 40 records no matter what filter is applied. Some of what I'm asking for is in part for ease of copy and pasting into excel instead of having to make an odbc connection to the actual database. (See also unformatted reports as well) I know how to do so but I suspect I'd have to give an even longer FAQ on that then you do on Sexy & Wamp. I'm just thinking of features that would be helpful in general but not requiring too much in the way of instruction to utilize. I don't know how anyone presumed that Sexy is not storing more than 1000 records. Sexy is doing a perfect job from everything that I'm seeing. I can only guess that someone assumed Sexy was limited in the same fashion that the api updates are limited. Guess that comes from people not understanding the entire process, for both things. Hope that clears that up.
It's A GIRL!!!!! |
Thraxon
Black-Sun-Inventions
|
Posted - 2007.09.11 08:52:00 -
[98]
Edited by: Thraxon on 11/09/2007 08:55:06
Originally by: Shar Tegral
Originally by: Thraxon
You can setup cron jobs for this. Mine updates automatically every 1 1/2 hours.
Well I'm using the wamp installation to run "Sexy" locally so cron jobs isn't an available solution.
In windows you have the 'at' command which basically does the same thing.
Originally by: Thraxon
Originally by: Shar Tegral
- Unlimited Record Return
Isn't this limited by the CCP data feed?
I meant for "Sexy" to create unlimited record returns for the data already stored.
You can do this by hand by putting the limit=1000 in the url for it to display 1000 records for example.
For example:
http://your_wallet_url/journal.php?limit=1000
or
http://your_wallet_url/transactions.php?limit=1000
|
Shar Tegral
|
Posted - 2007.09.11 09:28:00 -
[99]
Originally by: Thraxon
In windows you have the 'at' command which basically does the same thing. Or the winat frontend for it if you have the resource kit.
Thank you. Was very unfamiliar with this so I looked it up. (AT)
Originally by: Thraxon
http://your_wallet_url/journal.php?limit=1000
http://your_wallet_url/transactions.php?limit=1000
Aye, I've been doing just that myself I just thought it a nice feature to include.
It's A GIRL!!!!! |
Ray McCormack
hirr
|
Posted - 2007.09.11 09:40:00 -
[100]
Originally by: Shar Tegral
Originally by: Thraxon
In windows you have the 'at' command which basically does the same thing. Or the winat frontend for it if you have the resource kit.
Thank you. Was very unfamiliar with this so I looked it up. (AT)
Or just use the in-built Scheduled Tasks tool found in the Control Panel. Point it to c:\wamp\php\php.exe and then in advanced properties add the path to the cron update files after that.
Originally by: Shar Tegral
Originally by: Thraxon
http://your_wallet_url/journal.php?limit=1000
http://your_wallet_url/transactions.php?limit=1000
Aye, I've been doing just that myself I just thought it a nice feature to include.
If the purpose is just to be able to copy/paste a larger volume of entries I won't add it as standard as I'll be adding CSV exports instead. So for now just bear with the workaround you have.
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
Ray McCormack
hirr
|
Posted - 2007.09.11 09:44:00 -
[101]
Originally by: ResearchBot 9
Are we still waiting on CCP's new data dump for the new version?
Yer, today's patch may be changing things. I'll release separate updates though, seems the easiest way.
So if anyone is looking to test an upgrade please hop on ColdFront IRC and /query RayMcCormack.
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
shags
|
Posted - 2007.09.17 16:01:00 -
[102]
the demo for this looks great so i am really interested in it now. my question though is what features you are using that makes this php5? will it work with php4?
Ive kind of neglected my debian machine for the last year or so cause everything i use it for works fine. now the thought of typing "apt-get upgrade" scares the crap out of me.
|
Ray McCormack
hirr
|
Posted - 2007.09.17 16:12:00 -
[103]
Originally by: shags
the demo for this looks great so i am really interested in it now. my question though is what features you are using that makes this php5?
SimpleXML. Possibly some others too, but that is the crux.
Originally by: shags
will it work with php4?
Nope.
Originally by: shags
Ive kind of neglected my debian machine for the last year or so cause everything i use it for works fine. now the thought of typing "apt-get upgrade" scares the crap out of me.
Yer, can appreciate that. But I'm not coding a PHP4 version when everyone has switched over to PHP5. And PHP4 will stop being supported beginning of next year iirc. Although it's possible a simple function rewrite is all that's needed to make it work in PHP4.
Proud steward of more public ISK than Motivated Prophet. Ask me about Secured ISK Loans. |
Valator Uel
Caldari
Pax Minor Asylum
Confederation of Independent Corporations
|
Posted - 2007.09.28 19:50:00 -
[104]
Hello Ray McCormack,
First of all, thanks a million for doing this and doing it for free! It's a great tool and is really appreciated  .
I know you're going to release a new version soon, but there are a few suggestions I'd like to make:
1) Able to import your orders (after exporting them ingame). A new page shows you your orders but as those orders get sold/bought up the page updates itself. The idea is that you can export your orders whenever you put a new one up ingame and can then follow the progression via ingame. This is more for people who don't log on every day and can thus follow thier orders from a website and see when one of their orders is getting low.
2) A single update button (I currently have /cron/api.php as a shortcut).
3) The ability to filter out who buys lots of stuff from me. I often go through my orders to see who buys regularly and then try to contact them ingame and see if I can't get a contract with them. At the moment I have to manually go through all the orders but it would be nice to be able to filter eg "who bought more than 10000 bananas from me" or "who bought more than 10 times from me".
4) An indication of the next time we can update, or an indication of the last update date.
Cheers!
-----------------------------------------------------
|
Valator Uel
Caldari
Pax Minor Asylum
Confederation of Independent Corporations
|
Posted - 2007.10.08 20:46:00 -
[105]
I've been working on a skin but have run into trouble. In the pic below, you'll see some of the borders are still orange, but I can't for the love of me find them in the css file. Which ones are they?
skin test
A couple of bugs I found:
- When selecting the display amount or turning images on/off, it won't save the settings when pressing on the save button
- If you take another look at the screenshot above, you'll see that there is a bug with the distrubution of the days on the x-axis. For instance the first two dates are 2007-08-01 and 2007-08-22, 21 days apart. The last two are one day apart which messes up the whole graph. It's not a big issue, just helps visually see what's going on.
And yet another suggestion:
When looking at a specific item's overview, all the nu;bers are from buy and sell commands. Now unless I'm missing some special marketing/economics theory, I find it more usefull if they were all split from buy and sell orders. It allows me to see how my average buy/sell prices are progressing. Being able to compare them to previous weeks/months would be nice too.
I've also taken a look on your updated demo, it seems you removed the graph. Will it be back in future versions?
Thanks, hope to hear from you soon
-----------------------------------------------------
|
RaTTuS
BIG
Ka-Tet
|
Posted - 2007.10.09 06:03:00 -
[106]
Ray is away ATM -
well he may be round a bit but it will be sporodic
--
BIG Lottery, BIG Deal, InEve & RaTTuS Home
|
Phoebios
|
Posted - 2007.10.12 09:24:00 -
[107]
For someone like me this is hard to install.
But this is the best wallet analyzer i ever see
I hope you will continue to update this huge software !
Thanks a lot !
|
Shar Tegral
|
Posted - 2007.10.18 07:29:00 -
[108]
Is Ray back yet... I'm jonzing for a sexy update.
It's A GIRL!!!!! |
Leya Marcsson
|
Posted - 2007.10.28 01:22:00 -
[109]
Edited by: Leya Marcsson on 28/10/2007 01:25:21
If I try to update my wallet it says:
"200- Current security level not high enough."
Will it know eat my beloved cat, or even start a world war? Do I really need to brown-nose concord to make this work?
thx
|
Shar Tegral
|
Posted - 2007.10.28 01:27:00 -
[110]
Originally by: Leya Marcsson
If I try to update my wallet it says: "200- Current security level not high enough."
Without further details, I'd say there is two likely culprits. A: You are using the limited API key to try and update with or B: You may be trying to update a corp wallet and you don't have access.
It's A GIRL!!!!! |
tornpain
|
Posted - 2007.11.13 00:25:00 -
[111]
is anyone else having problems retrieving transactions besides the most recent 1000 for personal wallet? I can go back several thousand for corporate wallet (august)
|
Pizza Delivery
|
Posted - 2007.11.24 04:56:00 -
[112]
sexy!
free shameless bump
|
Prokonsul Piotrus
Minmatar
Astral Light of Nature
|
Posted - 2007.12.29 00:31:00 -
[113]
Dumb question, but do I need to have my own ftp server with MySQL server to use Sexy?
--
One day, we will return to the planets... please, CCP? :)
EVE-Wiki - share your knowledge in one place. |
Ray McCormack
hirr
|
Posted - 2007.12.29 08:48:00 -
[114]
Originally by: Prokonsul Piotrus
Dumb question, but do I need to have my own ftp server with MySQL server to use Sexy?
Below is a modified quote from the Wiki at EVEOW.
Quote:
There are many platforms and software options to get this running. An AMP (Apache, MySQL, PHP) server is probably your best bet. For people on WinXP use WAMPServer, for MAC there is also something called MAMP you can use (google it).
You need to have PHP compiled with curl and gdlib. Under WAMPServer these are enabled by clicking on the system tray icon and checking them under PHP Settings, PHP Extensions.
To create a database, visit phpMyAdmin (again by clicking the system tray icon) and create one (call it anything).
I can't really be expected to give further instructions on how to install PHP and MySQL beyond this, there are many online guides. Google it.
However, if you're trying to install this locally for yourself and are using WAMP or MAMP I will be more than willing to help. I am RayMcCormack? on irc.coldfront.net and usually sit in #eve-dev.
Good luck.
|
Daphne Eveningstar
|
Posted - 2007.12.29 18:56:00 -
[115]
When I create my database table in Wamp how many fields should it have?
|
Daphne Eveningstar
|
Posted - 2008.01.09 17:56:00 -
[116]
Bumping dis
I have this application working great for a single char. It's really cool.
How do I add another char to the db? I have 3 traders, not in a corp together. 2 do most of my buying and shipping, and the 3rd char sells. Would like to figure out how to look at the big picture.
Will dig into the docs again later and see if I can find any info.
|
Kala Denethir
Caldari
DenTech Industries
Final Retribution Alliance
|
Posted - 2008.01.10 08:33:00 -
[117]
Looks interesting, I might have a use for it.
|
Ray McCormack
hirr
|
Posted - 2008.01.10 19:02:00 -
[118]
Originally by: Daphne Eveningstar
How do I add another char to the db?
Upgrade to the latest unofficial release.
http://www.big-eve.com/upgrade19092007.zip
http://www.big-eve.com/install19092007.zip
http://www.big-eve.com/wallet19092007.zip
|
Ray McCormack
hirr
|
Posted - 2008.01.10 19:05:00 -
[119]
Originally by: tornpain
is anyone else having problems retrieving transactions besides the most recent 1000 for personal wallet? I can go back several thousand for corporate wallet (august)
The API itself limits you to 1000 transactions, or the transactions for the last week. SEXY will store these in a database for you, though, allowing you to browse back to when you first started using SEXY.
|
kickan mei
|
Posted - 2008.01.11 01:28:00 -
[120]
Installed this last night and man this is SEXY
Thanks alot :P
And for you guys n gals that need "Wallets" for more chars cant ya just create another install ?
ie. Wallet1: /www/wallet1/ Wallet2: /www/wallet2/
and 2 diff DBs Wallet1_DB, Wallet2_DB ? or Am i not remebering things correctly was a looong time since i worked with this kinda stuff If so disregard the last part ^^
|
Daphne Eveningstar
|
Posted - 2008.01.11 05:01:00 -
[121]
Edited by: Daphne Eveningstar on 11/01/2008 05:06:33
Edited by: Daphne Eveningstar on 11/01/2008 05:01:12
Winrar is giving me an "unexpected end of file" error on
http://www.big-eve.com/install19092007.zip
To upgrade an existing install (in windows) should I just stop Wamp and dump this folder onto the old one?
PS thanks for the update
Edit: Got it updated. Put upgrade.php and \upgrade into your wallet folder and point your browser at it. Seems to be working ok!
|
RaTTuS
BIG
Ka-Tet
|
Posted - 2008.01.11 15:59:00 -
[122]
BUG:
on the weekly view when it goes back to last year it says it is still 2008 ...
--
BIG Lottery, BIG Deal, InEve [Now Verified] & Recruiting
|
Lila Penney
|
Posted - 2008.01.18 15:00:00 -
[123]
When I install and then use svn to upgrade to the latest code, I get these errors:
2008-01-18 14:58:08: (mod_fastcgi.c.2570) FastCGI-stderr: PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 8
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 12
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 16
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 24
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 32
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 36
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 40
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 48
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 52
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 56
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 60
PHP Notice: Undefined index: typeID in /data/www/www.untaken.net/html/wallet/queries.php on line 64
PHP Notice: Use of undefined constant IMG_PNG - assumed 'IMG_PNG' in /data/www/www.untaken.net/html/wallet/graph/jpgraph_errhandler.inc.php on line 188
|
Trilori
Caldari
GearBox Fleet Svcs
|
Posted - 2008.01.18 20:21:00 -
[124]
how do I setup a cron job? Obviously this is needed to pull from the API data.
All the instructions say (at best, very flimsy) is to setup a daily cron on cron/cronapi.php and cron/croncorpapi.php but when I run these, the cron system gives me an error saying it doesn't exist.
|
Kaelor
Minmatar
Freelancing Corp
Confederation of Independent Corporations
|
Posted - 2008.01.21 08:23:00 -
[125]
Edited by: Kaelor on 21/01/2008 08:23:54
Wonder if you guys can help...
I have installed the wallet (on WAMP) and it appears to be fine however it wont record any wallet transactions, yet it provides me with the jopuirnal entries and graph of total. When I go to update it says updated with 0 records and the API log is showing an "OK" link.
Any ideas?
|
Treyish
Muff Divers
Gemini Federation
|
Posted - 2008.01.22 00:43:00 -
[126]
I'm confused as how to get this to work with MAMP on a mac. Has anyone been able to do this and could they post steps on how to get it to run on MAMP?
Thanks
|
Vested Interest
|
Posted - 2008.01.28 00:27:00 -
[127]
Bump
Could someone tell me how to set this up with 3 characters (not affiliated corps) transactions and wallet entries in the same view?
I want to see all the trades and entries from these 3 chars as though they were as single entity.
|
Ishikari
Gallente
Ishikari Industries
|
Posted - 2008.01.28 03:27:00 -
[128]
Originally by: Daphne Eveningstar
Edited by: Daphne Eveningstar on 11/01/2008 05:06:33
Edited by: Daphne Eveningstar on 11/01/2008 05:01:12
Winrar is giving me an "unexpected end of file" error on
http://www.big-eve.com/install19092007.zip
I tried a repair on this and it choked on isntall/stasta.sql.gz. The file is bad.
--------------------------
Ishikari Industries
Researchers of ship BPO's and BPC's
Visit our Shop Today! |
Daphne Eveningstar
|
Posted - 2008.01.28 04:12:00 -
[129]
I had installed a previous version and the upgrade.php went smoothly with that package for me.
|
Mephistocles
Red Frog Investments
Blue Sky Consortium
|
Posted - 2008.01.28 04:25:00 -
[130]
I haven't tried the upgrade myself, but I've helped a number of corpmates install the program and each one has had difficulty with the new build. I suggested they try the old build and the installation went in with no problems. This was both on Vista and XP platforms.
|
Salisuka
Caldari
Intex Mechanics
|
Posted - 2008.01.29 05:37:00 -
[131]
I keep getting this error :
Warning: simplexml_load_file() [function.simplexml-load-file]: /mydir/wallet/temp/c0cd8405b4eee5fca7736865680e0b80.xml:1: parser error : Document is empty in /mydir/wallet/update.php on line 51
The files are in the right location, I just removed the path to post on these boards. The permissions on the temp directory are 0777 as well.
|
T 2
Minmatar
Core Element
Blackguard Coalition
|
Posted - 2008.02.21 13:27:00 -
[132]
Excellent application! And a very needed one to effectively run a corporation!
If possible, update to the coding site would be appreciated! Also there are a few good suggestions on where to improve.
I'd love to have more Categories on the summarized main Journal view. F.ex. A new category for POS fuel, minerals, advanced moon minerals etc. Perhaps a system where user could create categories based on the item name or id that comes out of the API interface..
Good job, keep it up!
Best Regards,
T2
---
Core Element - a corporation for all timezones and players. http://www.core-e.org/ |
El'Evator
|
Posted - 2008.02.24 19:55:00 -
[133]
I installed the main files and then upgrade files. Now, when I try to look transactions I get an error:
Quote:
Warning: Invalid argument supplied for foreach() in /../content.php on line 87
In the mentioned line there is the following:
foreach ($type as $id => $type) {
$type[sell];
$type[buy];
|
Gorfob
Minmatar
GoonFleet
GoonSwarm
|
Posted - 2008.03.05 20:13:00 -
[134]
I am hoping this is still under development. A couple of things.
1. Brilliant app. The install went smoothly even for someone who has no experience with linux and purcahsed a server for the very reason of running this.
2. When you disable personal journal and wallet in the settings.php file personal information stil appears in the overview tab. I would love to see that knocked out as well if you choose not to display personal data.
|
Alz Shado
Ever Flow
|
Posted - 2008.03.05 21:16:00 -
[135]
Edited by: Alz Shado on 05/03/2008 21:24:55
I agree and fully endorse this product. It has real potential in it's current state, but there's still a few things that need touching up.
Features I'd love to see added or fixed
- multiple corp wallets
- recognizing the new grouped bounty system, with proper notation as to who earned the bounty and for killing what.
- remembering filters when going to next page in transactions
- calculating Isk In/Isk Out properly in the transactions log
- clicking on transaction ID showing the actual transaction
- updating the system list to avoid # SYSTEM being listed.
- Reporting features that allow sorting transactions by quantity sold, total, average, difference, etc.
- Adding [YEARLY] as a grouping option to go along daily, weekly and monthly.
- Corp transaction history going back farther than 2 months (bug? feature?)
Any news on it's progress would be awesome.
-------------------
"Kill a man one is a murderer; kill a million, a conqueror; kill them all, a God." -- Jean Rostand |
Narusegawa Naru
Gallente
The Phoenix Legionaires
|
Posted - 2008.03.08 20:08:00 -
[136]
Is this still in development? And does anyone have a snapshot of the latest SVN?
|
Ray McCormack
hirr
|
Posted - 2008.03.08 20:32:00 -
[137]
Originally by: Narusegawa Naru
Is this still in development? And does anyone have a snapshot of the latest SVN?
Yes, and only me.
|
Narusegawa Naru
Gallente
The Phoenix Legionaires
|
Posted - 2008.03.08 20:36:00 -
[138]
Cool, just installing it to my server now to try out. Looks really cool.
|
Ray McCormack
hirr
|
Posted - 2008.03.08 20:40:00 -
[139]
Originally by: Alz Shado
Features I'd love to see added or fixed
- multiple corp wallets
Possible now, just no filter for them, but easy to add if you're using the latest version.
- recognizing the new grouped bounty system, with proper notation as to who earned the bounty and for killing what.
Give me the codes and descriptions and it's done. If the API supplies it, I can do it.
- remembering filters when going to next page in transactions
This should happen now, if it doesn't please supply the ex-url (the part of the url less your domain) and I will look into it.
- calculating Isk In/Isk Out properly in the transactions log
Why doesn' it?
- clicking on transaction ID showing the actual transaction
What does it do now?
- updating the system list to avoid # SYSTEM being listed.
Just needs a new update of the official dump.
- Reporting features that allow sorting transactions by quantity sold, total, average, difference, etc.
Yes, definitely. With features that allow you to add logical filters such as >,<,=,>=,<=,<>,between,in,etc.
- Adding [YEARLY] as a grouping option to go along daily, weekly and monthly.
Heh, there's a major bug in the code that will show up in September. Hopefully I have it fixed before then. Will add this as a dynamic option.
- Corp transaction history going back farther than 2 months (bug? feature?)
You sure you have data entered for your corp that goes beyond that? I have corps using the wallet that have no problem with this.
|
Zizou
Caldari Provisions
|
Posted - 2008.03.18 17:20:00 -
[140]
Originally by: Ray McCormack
Upgrade to the latest unofficial release.
http://www.big-eve.com/upgrade19092007.zip
http://www.big-eve.com/install19092007.zip
http://www.big-eve.com/wallet19092007.zip
Any chance you could re-upload the install1909 one? I am having some problems with the upgrade version and the fresh install version of the file seems to still be corrupt.
|
Ray McCormack
hirr
Morsus Mihi
|
Posted - 2008.03.18 17:24:00 -
[141]
Originally by: Zizou
Any chance you could re-upload the install1909 one? I am having some problems with the upgrade version and the fresh install version of the file seems to still be corrupt.
Done.
|
Alz Shado
Ever Flow
|
Posted - 2008.03.25 17:55:00 -
[142]
- multiple corp wallets
Possible now, just no filter for them, but easy to add if you're using the latest version.
We're running 1.19.09, which I believe is the latest, but I don't have access to the server to modify the code myself.
- recognizing the new grouped bounty system, with proper notation as to who earned the bounty and for killing what.
Give me the codes and descriptions and it's done. If the API supplies it, I can do it.
I'll have to look and see if it's in the database dump. The codes are all in the format of "12835:6,16010:5,18027:1,12464:3,16209:1,18026:4" which I believe is the shiptype and the quantity.
- remembering filters when going to next page in transactions
This should happen now, if it doesn't please supply the ex-url (the part of the url less your domain) and I will look into it.
First page: ?type=Small+Armor+Repairer+I&typeID=&wallet=corp&action=transactions
Second page: ?offset=15&wallet=corp&action=transactions
It appears the "type" option isn't being carried over. If I enter it manually after the offset, it works.
- calculating Isk In/Isk Out properly in the transactions log
Why doesn' it?
When choosing "Transactions" it continues to calculate the entire Journal's in/out, including bounties, rewards, etc. What I'm expecting to happen is for the Isk In/Isk Out value to recalculate based on the transaction log (ie, Market transactions) only.
- clicking on transaction ID showing the actual transaction
What does it do now?
ex-url: index.php?action=transactions&transactionID=XXXXXXXX (removed)
Page loads as "No Transactions Found"
- updating the system list to avoid # SYSTEM being listed.
Just needs a new update of the official dump.
What I get in the transaction log currently: "Berceuse bought x #System from Alz Shado (TransactionID : xxxxxxxxx)"
- Reporting features that allow sorting transactions by quantity sold, total, average, difference, etc.
Yes, definitely. With features that allow you to add logical filters such as >,<,=,>=,<=,<>,between,in,etc.
Awesome^2.
- Adding [YEARLY] as a grouping option to go along daily, weekly and monthly.
Heh, there's a major bug in the code that will show up in September. Hopefully I have it fixed before then. Will add this as a dynamic option.
Good news: that's six months away. Bad news: that's ONLY six months away
- Corp transaction history going back farther than 2 months (bug? feature?)
You sure you have data entered for your corp that goes beyond that? I have corps using the wallet that have no problem with this.
I've been using the offline wallet since November, and as of today the corp records only go as far back as the beginning of February. Last month I could see January and December too. If I go into my personal log, I can see as far back as November of last year.
Thanks again for developing this remarkable tool. I'm looking forward to the next release!
////
---------===
[]=
---------===
\\\\ Rifter(RedBad)
"Kill a man one is a murderer; kill a million, a conqueror; kill them all, a God." -- Jean Rostand |
T 2
Core Element
Blackguard Coalition
|
Posted - 2008.03.26 13:55:00 -
[143]
Originally by: Ray McCormack
Originally by: Alz Shado
Features I'd love to see added or fixed
- calculating Isk In/Isk Out properly in the transactions log
Why doesn' it?
It actually bugs heavyly when there are transactions inside corps wallet from one division to another division. It does not calculate that correctly. It seems that sometimes it "notices" only the Withdrawal and not the input to another wallet division and vice versa. I think that a good way to solve it would be to take out all interwallet transactions from all calculations.
This is the reason its not currently calculating the weekly in's and out's properly for me :-/
Best Regards,
T2
|
Shinhan
Phoenix Knights
Dark Nebula Galactic Empire
|
Posted - 2008.03.26 23:10:00 -
[144]
I've been having some problems with the cron and logging.
So, this is what I changed the logerror function in the functions.php to:
function log_error($data)
{
$today = date("Y-m-d G:i");
$logfile = "apierrorlog.html";
$dir = $_SERVER['DOCUMENT_ROOT'].'/logs/';
$saveLocation= $dir . $logfile;
if (!$handle = fopen($saveLocation, "a"))
{ exit;
}
else
{
if(fwrite($handle,$today.' '.nl2br(print_r($data,true))."<br />\n")===FALSE)
{ exit;
}
fclose($handle);
}
}
Note the addition of DOCUMENT_ROOT (so cron can find the log location) and print_r (so this function can print arrays that cron is sending to it).
--
Selling apples, 1 signature each.
ѼѼѼѼѼѼѼ |
Luminality
|
Posted - 2008.03.29 13:40:00 -
[145]
hi,
can someone please tell me the syntax of the whole cron thingy?
how do i actually "run" the php-files?
this happens when i try to run them with php5:
nnn@nnn:~/httpdocs/wallet/cron> php5 api.php
PHP Notice: Undefined index: accountKey in /nnn/httpdocs/wallet/functions.php on line 501
PHP Notice: Undefined index: accountKey in /nnn/httpdocs/wallet/functions.php on line 501
this isnt it, is it?
|
Kaelor
|
Posted - 2008.03.29 14:28:00 -
[146]
Is there anyway to make the graphs track since the first time you used it?
Atm I only see the last 2 weeeks worth of data in the graph yet have used it for four months?
|
Franconian Eagle
|
Posted - 2008.03.30 13:08:00 -
[147]
Originally by: Luminality
nnn@nnn:~/httpdocs/wallet/cron> php5 api.php
PHP Notice: Undefined index: accountKey in /nnn/httpdocs/wallet/functions.php on line 501
PHP Notice: Undefined index: accountKey in /nnn/httpdocs/wallet/functions.php on line 501
Exactly the same is happening to me as well.
Furthermore I get these lines in apierrorlog.html:
Originally by: apierrorlog.html
2008-03-30 14:55 Array
2008-03-30 14:55 Array
2008-03-30 14:59 Array
2008-03-30 14:59 Array
Does this app work with php5 at all? Or what's happening here?
Btw, setting the debug=true in settings.php didn't actually print any additional debug messages.
Can someone shed some light on this?
|
Luminality
|
Posted - 2008.03.30 15:00:00 -
[148]
Originally by: Franconian Eagle
Does this app work with php5 at all? Or what's happening here?
php5 is a minimum requirement since php4 does not have the simplexml_load_file function which is used by this script.
fyi: i receive the Array message in the apierrorlog.html too
|
Freaky Eyes
|
Posted - 2008.04.07 07:02:00 -
[149]
Has anyone got version BETA 1.19.09.2007 working with crond?
It looks like the query is being build in journalapi.php and transactionsapi.php, but the query isn't being run.
|
Ray McCormack
hirr
Morsus Mihi
|
Posted - 2008.04.07 16:49:00 -
[150]
The cron is broken in that version. I will try to release a fix by the weekend.
|
GorfobInc
|
Posted - 2008.04.13 01:59:00 -
[151]
Edited by: GorfobInc on 13/04/2008 02:00:01
Unable to get corp data using the update function. All settings are correct. API, character etc. As it works for personal wallets.
Throws the wallet exhausted error every time for corp crap. Except I know its not exhausted because I can manually download it seconds after it tells me it is unable to get it. This is a 100% fresh install as well.
I have it working for personal wallets without fail. |
Athre
Minmatar
The HIgher Standard
|
Posted - 2008.04.13 02:52:00 -
[152]
Hey Ray,
Is there any way to lock Sexy wallet on a single corp section? Like say I want to only give data on Corp Wallet 5. Is something like that possible? |
Ray McCormack
hirr
|
Posted - 2008.04.13 07:44:00 -
[153]
Originally by: GorfobInc
This is a 100% fresh install as well.
I have it working for personal wallets without fail.
What version? If you don't mind, evemail me the link and I will have a look at it.
Originally by: Athre
Is there any way to lock Sexy wallet on a single corp section? Like say I want to only give data on Corp Wallet 5. Is something like that possible?
Edit your settings.php file.
Quote:
# Set the wallet divisions to access.
# Tip : Disable those you don't require or don't have access to.
# Default : $settings['divisions'] = array("1000","1001","1002","1003","1004","1005","1006");
# Options : an array from 1000 to 1006. Master is 1000, Division 7 is 1006.
$settings['divisions'] = array("1000","1001","1002","1003","1004","1005","1006");
Or do you mean you still want to capture the other wallets, but want the display to filter them out? If so, currently only on the Journal and Transactions Tabs, not the Overview Tab.
|
Myrdyr
|
Posted - 2008.04.14 20:26:00 -
[154]
re: http://oldforums.eveonline.com/?a=topic&threadID=646686&page=15#436
Is there a way to regenerate the XML data captured and parsed by "Sexy", to feed it into another application?
Please post constructively. ~Saint |
Ray McCormack
hirr
|
Posted - 2008.04.15 05:53:00 -
[155]
Originally by: Myrdyr
Is there a way to regenerate the XML data captured and parsed by "Sexy", to feed it into another application?
Not currently. I will release a standalone exporter/importer soon that will be needed for future upgrades. But this will be to CSV.
You can however turn off the deleting of XML files after they are parsed. In update.php find the lines (plural) :
Quote:
unlink($xmlfile);
and change it to Quote:
#unlink($xmlfile);
This will leave all the xml files in /temp, but be aware this is an open folder that anyone can access (granted they will need to guess the file name) so you will need to clear it out. And protecting it will break the parsing.
|
Athre
Minmatar
The HIgher Standard
|
Posted - 2008.04.15 07:01:00 -
[156]
Originally by: Ray McCormack
Originally by: Athre
Is there any way to lock Sexy wallet on a single corp section? Like say I want to only give data on Corp Wallet 5. Is something like that possible?
Edit your settings.php file.
Thank you
|
Otaci
|
Posted - 2008.04.17 15:36:00 -
[157]
Was having a lot of problems with IE, switched to Firefox and it seems to be working much better.
Just FYI, I don't personally have time to look into it, using Firefox instead is an easy fix.
Ota
|
Calgorac
The Arrow Project
Morsus Mihi
|
Posted - 2008.04.21 00:42:00 -
[158]
having the following warnings pop up...
[20-Apr-2008 20:16:31] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:16:31] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:16:31] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:16:31] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:16:31] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:17:33] PHP Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\sexy\overview.php on line 49
[20-Apr-2008 20:17:33] PHP Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\sexy\overview.php on line 49
[20-Apr-2008 20:17:33] PHP Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\sexy\overview.php on line 49
[20-Apr-2008 20:17:33] PHP Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\sexy\overview.php on line 49
[20-Apr-2008 20:17:33] PHP Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\sexy\overview.php on line 49
[20-Apr-2008 20:19:51] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\sexy\content.php on line 87
[20-Apr-2008 20:23:29] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\sexy\content.php on line 87
[20-Apr-2008 20:33:25] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\sexy\content.php on line 87
[20-Apr-2008 20:35:07] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\sexy\content.php on line 87
[20-Apr-2008 20:35:18] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:35:18] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:35:18] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:35:18] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
[20-Apr-2008 20:35:18] PHP Warning: mktime() expects parameter 5 to be long, string given in C:\wamp\www\sexy\overview.php on line 56
For Buy back option Contact "James Omerand" ingame.24 billion under Management |
Ray McCormack
hirr
|
Posted - 2008.04.21 05:57:00 -
[159]
Have you created and pointed to your MySQL db correctly?
|
Arkham Lerouge
|
Posted - 2008.04.22 11:08:00 -
[160]
Dear Ray,
it seems i'm having the same issue as the poster just above :
====================
Warning: mktime() expects parameter 6 to be long, string given in /srv/sexywallet/overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in /srv/sexywallet/overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in /srv/sexywallet/overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in /srv/sexywallet/overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in /srv/sexywallet/overview.php on line 52
====================
Is there a way to make sure the databases have been correctly created/imported/linked and stuff? I first thought i was having this because it was a fresh install, with no information updated or whatsoever, so i selected "personal", "weekly" and "update". It then displayed
Checking wallets for <my character ID>
And that was it, nothing more displayed.
Would that be a DB issue or an API issue... or anything else?
I did install php5-gd and php5-curl, and checked that there was a /etc/php5/conf.d/curl.ini and gd.ini (containing the lines "extension=curl.so" and "extension="gd.so").
I also created a database, a user, and granted all privileges on this db for this user.
I believe I provided the correct DB information (and correct api/key and stuff) in the settings.php file, but i'd love to know a way to validate that.
Thanks for this great piece of app ! |
Ray McCormack
hirr
|
Posted - 2008.04.22 11:14:00 -
[161]
It sounds like the db is empty and the update has failed. What browser are you using? Try running the update with Firefox and see what happens.
|
Arkham Lerouge
|
Posted - 2008.04.22 12:19:00 -
[162]
Edited by: Arkham Lerouge on 22/04/2008 12:21:53
well, i'm actually one of those superiorly intelligent, cute and handsome people that happen to use firefox (and firefox only) :D
Are they any DB that should be populated straight away, before the update? And how can I make sure the update is running correctly and there's no issue with the API or credentials?
(that was a free ad for firefox, get it here : http://download.mozilla.org/?product=firefox-2.0.0.14&os=win&lang=en-GB !)
|
Calgorac
The Arrow Project
Morsus Mihi
|
Posted - 2008.04.22 21:05:00 -
[163]
my corp wallet transactions show in the db
all tables are created
I use wamp with upto date php/mysql and curl gd
I get that error on the personal page and a couple others.
using the latest version on a fresh install
also havent used IE since mozilla was reliesed and currently use latest firefox |
No La
Federal Navy Academy
|
Posted - 2008.04.23 06:32:00 -
[164]
Any chance of adding a yearly tab to the app?
I tried to do it myself yesterday, but i gave up. Your code is very hard to read
Indentation ftw!
Ow, and comments would help a lot too...
Besides that, awesome job! Keep it up!
Can't live without it.
No La
|
Arkham Lerouge
Osiris Entreprises
|
Posted - 2008.04.23 10:03:00 -
[165]
Problem fixed for me ...
Everything was actually configured correctly, but I was using https on my host, and it seems this blocked the update somehow...
Setting apache back to normal http seems to have fixed the issue ;)
Thanks for this awesome tool!
|
Myrdyr
|
Posted - 2008.04.24 15:22:00 -
[166]
I just updated from the pre-release beta, and wow-awesome now. Drilldown capability and everything is very sweet.
Please post constructively. ~Saint |
Ray McCormack
hirr
|
Posted - 2008.04.24 16:09:00 -
[167]
Originally by: Arkham Lerouge
Could you tell if this is your code, or if you grabbed it from someplace, the tool to display debugging informations? It is AWESOME ! Does it come with the Zebra DB wrapper? ME WANT SOME!
Yes, it comes with Zebra. It is quite nice. But I am changing the database wrapper in the next release to ADODB and implementing a custom error and debug system.
Originally by: Calgorac
I get that error on the personal page and a couple others.
Catch me ingame or on RAWR IRC (or ColdFront) if you frequent it so we can work through the problem.
Originally by: No La
Any chance of adding a yearly tab to the app?
Sure, but in the next release it won't be necessary. I'm switching to date range filtering on most things with customisable presets.
Originally by: No La
Your code is very hard to read
Indentation ftw!
Ow, and comments would help a lot too...
Yer, sorry. In the current re-write I will try to structure things a bit better and comment a lot of the code.
Originally by: Arkham Lerouge
Problem fixed for me ...
I'm glad it's sorted.
Originally by: Myrdyr
Drilldown capability
Moar drill-down in next release!
We should be about a month away from that. I will post some screenshot teasers next weekend hopefully.
WHY DO I HAVE TO LOGIN A DOZEN TIMES TO POST ONE REPLY!?
|
Myrdyr
|
Posted - 2008.04.24 16:15:00 -
[168]
Originally by: Myrdyr
P.S. I saw the monthly-transactions-grow thing is fixed on the devel copy on big-eve.com, how can I grab a copy of that? :)
Nevermind -- it just took a very, very long time to load due to my # of items in the transactions :)
Please post constructively. ~Saint |
Chira Netanru
|
Posted - 2008.04.29 01:33:00 -
[169]
It looks like transfers from one division to another in the corporate wallet get counted as a debit?
There's no corresponding credit transaction for the debit from the master wallet for a trasnfer to a division.
I can't decide if this is a problem in CCP's transaction data or if it should be coded around...
|
Ray McCormack
hirr
|
Posted - 2008.04.29 08:18:00 -
[170]
Originally by: Chira Netanru
It looks like transfers from one division to another in the corporate wallet get counted as a debit?
There's no corresponding credit transaction for the debit from the master wallet for a trasnfer to a division.
I can't decide if this is a problem in CCP's transaction data or if it should be coded around...
Interesting. I shall investigate. I'd prefer not to have to create the corresponding credit transaction, from a brief glance it looks like there'll be a few issues on hitting the correct division and calculating the running balance.
Anyone able to check for definite if this is the case?
|
Ray McCormack
hirr
|
Posted - 2008.04.29 08:19:00 -
[171]
Originally by: Myrdyr
If it isn't too crazy intensive would it be possible to get a sum of all the subsection from Transactions?
Probably not, if I knew what you meant.
|
Crytan
NorCorp Enterprise
|
Posted - 2008.05.02 22:37:00 -
[172]
I tried installing this on my paid webhost, 'cause from the demo it looks awesome. However, when I have entered all the proper settings (as far as I understand) the install script states the following (I removed some info due to privacy):
Quote:
Database connection failed due to Access denied for user 'removed'@'localhost' (using password: NO)
Edit the database settings in /removed/install/install.php or contact your database provider
The username states seems to be the default user for the server, and not the one I entered in both the settings.php and install.php. All the files have been uploaded and the proper permissions have been given. Is there an obvious solution to this that I have overlooked? I have contacted my webhost, but would expect them not to help out if this seems to be an error on my part. Any help would be appreciated.
In advance, thank you for your time :-) |
Chira Netanru
|
Posted - 2008.05.05 14:17:00 -
[173]
Originally by: Ray McCormack
Anyone able to check for definite if this is the case?
What do you mean? Do you want to see a live example? Just transfer from a master wallet to a division.
|
Chira Netanru
|
Posted - 2008.05.13 17:25:00 -
[174]
I took a look and fixed the issue in my local database via:
delete FROM `jcorp` where ownerName1 = ownerName2 and refTypeID = 37
It's not trivial to create the appropriate credit transactions as I think you'll have to step through the journal and look for discrepancies in the balance -- more a case of a mistake on CCP's part that needs correcting, I think.
|
Chira Netanru
|
Posted - 2008.05.23 03:34:00 -
[175]
I went back and forth with a bughunter and turns out the problem is refid is not a primary key... the refid for the credit transaction is the same as the debit
ex:
Quote:
date,refID,refType,ownerName1,ownerName2,argName1,amount,balance,reason
2008-05-16 18:20:00,xxxxxxxx89,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,2000000.00,80000000.00,
2008-05-16 18:19:00,xxxxxxxx30,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,-1000000.00,78000000.00,
2008-05-16 18:18:00,xxxxxxxx65,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,-1000000.00,79000000.00,
<row date="2008-05-16 18:20:00" refID="xxxxxxxx89" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx" amount="2000000.00" balance="80000000.00" reason="" />
<row date="2008-05-16 18:19:00" refID="xxxxxxxx30" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx" amount="-1000000.00" balance="78000000.00" reason="" />
<row date="2008-05-16 18:18:00" refID="xxxxxxxx65" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx" amount="-1000000.00" balance="79000000.00" reason="" />
Division 7:
date,refID,refType,ownerName1,ownerName2,argName1,amount,balance,reason
2008-05-16 18:20:00,xxxxxxxx89,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,-2000000.00,0.00,
2008-05-16 18:19:00,xxxxxxxx30,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,1000000.00,2000000.00,
2008-05-16 18:18:00,xxxxxxxx65,Corporation Account Withdrawal,TestCorp,TestCorp,Inganam,1000000.00,1000000.00,
<row date="2008-05-16 18:20:00" refID="xxxxxxxx89" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx5" amount="-2000000.00" balance="0.00" reason="" />
<row date="2008-05-16 18:19:00" refID="xxxxxxxx30" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx5" amount="1000000.00" balance="2000000.00" reason="" />
<row date="2008-05-16 18:18:00" refID="xxxxxxxx65" refTypeID="37" ownerName1="TestCorp" ownerID1="xxxxxxxxx1" ownerName2="TestCorp" ownerID2="xxxxxxxxx1" argName1="Inganam" argID1="xxxxxxxxx5" amount="1000000.00" balance="1000000.00" reason="" />
|
Chira Netanru
|
Posted - 2008.06.04 17:44:00 -
[176]
There's a bug on the last day of the month (5/31/08 anyway) where monthly only shows may/may/march/march/january
|
Ray McCormack
hirr
|
Posted - 2008.06.05 16:12:00 -
[177]
Originally by: Chira Netanru
There's a bug on the last day of the month (5/31/08 anyway) where monthly only shows may/may/march/march/january
Strange. We're moving away from split overviews in the next version. Everything is just date ranges, which can be preset. So this isn't something that needs looking into now.
Also, thanks for the posts above. Will help a lot in creating a workaround for the issue.
|
Lep Erd
|
Posted - 2008.06.17 06:35:00 -
[178]
Originally by: Ray McCormack
Originally by: Chira Netanru
There's a bug on the last day of the month (5/31/08 anyway) where monthly only shows may/may/march/march/january
Strange. We're moving away from split overviews in the next version. Everything is just date ranges, which can be preset. So this isn't something that needs looking into now.
Also, thanks for the posts above. Will help a lot in creating a workaround for the issue.
I'm looking forward to this... Is there an ETA for the next release? Or when can we expect date ranges on the CVS?
Lastly, just a couple feature requests... 1) Can you add it so we can sort columns? 2) Can we filter by item type? (modules, ammo, ships, etc)
Thanks for the excellent work. Best wishs,
-l
|
Slanty McGarglefist
University of Caille
|
Posted - 2008.06.25 00:36:00 -
[179]
Edited by: Slanty McGarglefist on 25/06/2008 00:38:30
Originally by: Ray McCormack
Originally by: Femintaki
What I am looking for is astep by step, blow by blow set of instructions for setting it up
1) Install WAMP (for security reasons run in offline mode).
2) In your browser visit http://localhost/phpmyadmin/.
3) Create a new database table called wallet.
4) Left-click on the WAMP tray icon and browse to PHP settings, PHP extensions and make sure php_curl and php_gd2 are checked.
5) Unzip the archives to a sub-directory named wallet in your www folder (default is c:\wamp\www\).
6) Edit settings.php with your API and MySQL information. For WAMP your connection info would be : server = localhost; username = root; password = ; db = wallet.
7) In your browser visit http://localhost/wallet/install/install.php and import each file.
7.1) If you have trouble importing the files, use WinRar to uncompress the .gz files to the same directory. Then left-click on the WAMP tray icon and select MySQL, MySQL Console. In the new console window press enter to confirm a blank password, and then type "\r wallet" and then for each file type "\. c:\wamp\www\wallet\install\filename.sql". Type "exit" to close the console.
8) Once installed browse to http://localhost/wallet/ and visit each wallet to click on Update.
I get to Step 7 and I get the error; "Database connection failed due to Access denied for user 'root'@'localhost' (using password: YES)"
I know this is because the password is set to ";", so where do I input this password so I can get access? I know if I just delete the PW in the config file it'll work fine but you said to put in a PW so I did.
Also, it was recommended by the program to add a password to the MYSQL account on the phpMyAdmin page and once I did, it completely locked me out, not asking for a password/username input and forcing me to uninstall and reinstall the program. I'm having problems with passwords here, I haven't a clue where I input them so I can get access.
__________________________________________________
Originally by: CCP Wrangler
No
Doh! |
Mazzarins Demise
Profit Development and Research Association
|
Posted - 2008.06.25 12:43:00 -
[180]
Originally by: Slanty McGarglefist
I get to Step 7 and I get the error; "Database connection failed due to Access denied for user 'root'@'localhost' (using password: YES)"
I know this is because the password is set to ";", so where do I input this password so I can get access? I know if I just delete the PW in the config file it'll work fine but you said to put in a PW so I did.
Also, it was recommended by the program to add a password to the MYSQL account on the phpMyAdmin page and once I did, it completely locked me out, not asking for a password/username input and forcing me to uninstall and reinstall the program. I'm having problems with passwords here, I haven't a clue where I input them so I can get access.
Ironically, I'm stuck here as well.
|
Ray McCormack
hirr
|
Posted - 2008.06.25 14:41:00 -
[181]
Originally by: Slanty McGarglefist
I know if I just delete the PW in the config file it'll work fine but you said to put in a PW so I did.
Then why not just do that if it works?
Try $settings['password'] = '';
|
Slanty McGarglefist
University of Caille
|
Posted - 2008.06.25 14:46:00 -
[182]
Originally by: Ray McCormack
Originally by: Slanty McGarglefist
I know if I just delete the PW in the config file it'll work fine but you said to put in a PW so I did.
Then why not just do that if it works?
Try $settings['password'] = '';
Alright I'll just make that change to the config file then, thanks. Also, where do I type in this? - $settings['password'] = '';
In the same config file?
__________________________________________________
Originally by: CCP Wrangler
No
Doh! |
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.06.28 02:23:00 -
[183]
Any further progress? I know you're probably busy... but some of us are eagerly awaiting updates. :)
Cheers,
-l
|
Pechocha
|
Posted - 2008.07.15 05:26:00 -
[184]
Awesome piece of software.
Sadly not working for me.
This is what i got
Quote:
Warning: require(../settings.php) [function.require]: failed to open stream: No such file or directory in E:\wamp\www\wallet\install\install.php on line 2
Fatal error: require() [function.require]: Failed opening required '../settings.php' (include_path='.;C:\php5\pear') in E:\wamp\www\wallet\install\install.php on line 2
tried to search for settings.php and cant find it. Download the file a few times and nothing... cant see settings.php
|
WhitePhantom
Gallente
Edenists
|
Posted - 2008.07.15 08:05:00 -
[185]
Originally by: Pechocha
Awesome piece of software.
Sadly not working for me.
This is what i got
Quote:
Warning: require(../settings.php) [function.require]: failed to open stream: No such file or directory in E:\wamp\www\wallet\install\install.php on line 2
Fatal error: require() [function.require]: Failed opening required '../settings.php' (include_path='.;C:\php5\pear') in E:\wamp\www\wallet\install\install.php on line 2
tried to search for settings.php and cant find it. Download the file a few times and nothing... cant see settings.php
Sounds like your hosting setup doesn't have one of the required libs for this to work.
The settings.php most likely isn't even connected to this project.
|
Ray McCormack
hirr
|
Posted - 2008.07.15 08:56:00 -
[186]
You need to download wallet*.zip and unzip it to a folder. The install*.zip file needs to be unzipped to this folder as well, and should be a /install/ folder.
|
Pechocha
|
Posted - 2008.07.15 11:39:00 -
[187]
Thx a lot Ray... Its working perfect now.
|
Hac Ta'o
|
Posted - 2008.07.15 21:50:00 -
[188]
Originally by: Lep Erd
Originally by: Ray McCormack
Originally by: Chira Netanru
There's a bug on the last day of the month (5/31/08 anyway) where monthly only shows may/may/march/march/january
Strange. We're moving away from split overviews in the next version. Everything is just date ranges, which can be preset. So this isn't something that needs looking into now.
Also, thanks for the posts above. Will help a lot in creating a workaround for the issue.
I'm looking forward to this... Is there an ETA for the next release? Or when can we expect date ranges on the CVS?
Lastly, just a couple feature requests... 1) Can you add it so we can sort columns? 2) Can we filter by item type? (modules, ammo, ships, etc)
Thanks for the excellent work. Best wishes,
-l
Bump in the hope of more progress on this app.
-l
|
Traxman
|
Posted - 2008.07.17 19:43:00 -
[189]
Hi Ray.
Just installed it. 2 problems.
[18-Jul-2008 02:42:46] PHP Warning: mktime() expects parameter 6 to be long, string given in /home/x/y/wallet/overview.php on line 52
[18-Jul-2008 02:42:46] PHP Warning: mktime() expects parameter 6 to be long, string given in /home/x/y/wallet/overview.php on line 52
[Fri Jul 18 02:37:49 2008] [error] [client cc.bb.nn.66] File does not exist: /home/x/y/wallet/scripts/license.js
[Fri Jul 18 02:37:52 2008] [error] [client cc.bb.nn.66] File does not exist: /home/x/y/wallet/scripts/scriptaculous.js
I get java error in the client, i guess the function for rechecking status of the update
is in one of thoose 2 files.
I cant say much until i have seen what i can use it for ;)
|
Ray McCormack
hirr
|
Posted - 2008.07.17 20:22:00 -
[190]
The first two errors are because there is no data in your database. The javascript files are not required in any existing version.
|
Traxman
|
Posted - 2008.07.18 07:02:00 -
[191]
Edited by: Traxman on 18/07/2008 07:05:24
Hi Ray,
It's correct, the first errors are due to a problem where it seems not to check if the result set is empty ;)
The other 2 missing files, if you want i can prove it for you that it's included in the main page.
I'll mail you privatly later today with some ideas.
Update:
Show the page, view pagesource, and you can see it:
'<script src="scripts/scriptaculous.js?load=effects" type="text/javascript"></script>'
I might have another version ? I downloaded every file you got, followed the instructions and so far it seems be a problem with the import then.
|
Ray McCormack
hirr
|
Posted - 2008.07.18 12:44:00 -
[192]
I don't need proof, I wrote the thing. Those files may be requested but are not needed in any released version.
So besides that I still don't know what problem you are having. All you've told me is what you think is causing it, not what is actually wrong.
When you click on Update, what happens?
|
Salisuka
Caldari
98.4
|
Posted - 2008.07.18 16:18:00 -
[193]
Any date on a concrete release ray or should I just update from the svn?
|
Ray McCormack
hirr
|
Posted - 2008.07.18 16:29:00 -
[194]
I should take the SVN offline for now, it's out of date. SEXY will have a new release sometime soon, I'm busy finalising some of the framework and then just need to implement some standard reports.
Once the next release is done SEXY will shift to an early release subscription model. Hosting will be provided for paying subscribers who will receive updates first and custom reports as part of that deal. Third-party report writers will receive compensation for their submissions.
Updates will be made available freely to the public one or two months after initial release.
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.07.19 03:16:00 -
[195]
Originally by: Ray McCormack
I should take the SVN offline for now, it's out of date. SEXY will have a new release sometime soon, I'm busy finalising some of the framework and then just need to implement some standard reports.
Once the next release is done SEXY will shift to an early release subscription model. Hosting will be provided for paying subscribers who will receive updates first and custom reports as part of that deal. Third-party report writers will receive compensation for their submissions.
Updates will be made available freely to the public one or two months after initial release.
Looking forward to the new releases. Just out of curiosity, will the subscription be in isk or real world currency?
|
Ray McCormack
hirr
|
Posted - 2008.07.19 07:51:00 -
[196]
ISK.
|
LaVista Vista
|
Posted - 2008.07.19 08:06:00 -
[197]
Will we be able to buy the source for hosting on own server?
|
Ray McCormack
hirr
|
Posted - 2008.07.19 08:38:00 -
[198]
Yes, for a reduced subscription fee. It'll have to be based on trust, though.
|
Salisuka
Caldari
98.4
|
Posted - 2008.07.19 18:29:00 -
[199]
I'm not very well versed with licenses but couldn't you release the source with a restrictive license that says that one can only use it for personal use and profiting from it in terms of money and isk is not allowed? Maybe even allow only single user per license to avoid people claiming to be using it for corp etc.
Other than that I doubt that anyone will try to profit from the app because selling the same service as you would mean no more free version which will cause their business to tank.
|
Ray McCormack
hirr
|
Posted - 2008.07.19 19:06:00 -
[200]
I will be releasing it on something very similar to that license, in fact, the same license it is already released on. But, it will be two months after it is released to paying subscribers.
I still believe in open source and the open source model, but the implementation and future development of the application require my time. And between work, EVE and SEXY I need some balance. If I can balance the latter two then my life will become so much easier.
|
Gorfob
Minmatar
GoonFleet
GoonSwarm
|
Posted - 2008.07.20 23:54:00 -
[201]
When you say 'released to the public' does that mean we can still host a copy on our own server?
|
Ray McCormack
hirr
|
Posted - 2008.07.21 06:26:00 -
[202]
Sure.
|
Traxman
|
Posted - 2008.07.23 06:39:00 -
[203]
I havent got much time to check into the problems i have, but when pressing the update buttom results in just nothing.
I'll redo everything again and see where the problem can be.
Again, ill try contact you ingame with some other things.
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.08.06 04:40:00 -
[204]
it's been a couple of weeks so I figured I'd check in to see if there's any news or progress. This app is easily the offline tool I use the most... I'm almost obsessive with it.
I look forward to any updates.
Best wishes,
-l
|
Robacz
Essence Trade
Essence Enterprises
|
Posted - 2008.08.09 11:51:00 -
[205]
Originally by: Lep Erd
I look forward to any updates.
Me too. And my ISK.
|
Zizou
|
Posted - 2008.08.14 13:54:00 -
[206]
Just wondering if the current version is going to explode in september as you mentioned something about it having problems after a date in an earlier post Ray.
Will we now need to pay isk to replace the exploding version with a new non-volatile version?
|
Sugar Jugs
|
Posted - 2008.08.16 07:50:00 -
[207]
Edited by: Sugar Jugs on 16/08/2008 07:51:32
Edited by: Sugar Jugs on 16/08/2008 07:50:37
I am having some issues.
All of my corporation transactions that I am interested in analysing are through the master wallet (division 1000).
Since I installed the wallet, something in my calculations has not been right, in that my sales is reported lower than I know it actually is.
I did some playing around today, and it appears that almost 90% of my sales figues are coming through tagged incorrectly.
89% of my isk volume is being tagged with the division set to zero.....
Only 11% of my master wallet transactions are in the database with division 1000 set correctly.
The biggest issue is that on these "division 0" transactions the corporation member who actioned the sales order is a blank field.
-------------A sample transaction from wcorp reads (continues on 2nd set of lines):-------------------
transactionDateTime transactionID quantity typeName typeID price clientID clientName characterID
2008-07-06 08:24:00 681260712 2 Stasis Webifier I 526 20000.0 802965082 Sputnik D 361362480
CharacterName corpID stationID stationName transactionType division
0 60003760 Jita IV - Moon 4 - Caldari Navy Assembly Plant buy 0
------------------------------------------------------------------------------------------------------
Is this a problem with SEXY, the eve-api or something on my end? I really need to solve this problem.
Any thought would be appreciated.
Regards, Sugar Jugs
P.S. Hosted version for isk sounds excellent, especially with user submitted reports available to others (at uploaders discression ofc). :)
|
Ray McCormack
hirr
|
Posted - 2008.08.16 14:32:00 -
[208]
Originally by: Zizou
Will we now need to pay isk to replace the exploding version with a new non-volatile version?
No, you will just need to wait a while longer than you would if you paid for it. The date problem is limited to how long you've been pulling data. It's easily fixable by truncating data older than a year.
Originally by: Sugar Jugs
Is this a problem with SEXY, the eve-api or something on my end? I really need to solve this problem.
Any thought would be appreciated.
I noticed this too on one of my wallets. Not sure where it's coming from, haven't investigated it further.
|
Trigger64
Dark Knights of Deneb
Against ALL Authorities
|
Posted - 2008.09.13 05:07:00 -
[209]
Edited by: Trigger64 on 13/09/2008 05:06:55
I can't make it to even step one.
http://f1-f12.org/eve/images/sexyerror.png
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.09.29 07:09:00 -
[210]
Another bump to check on any progress on the next version...
|
Da Trader
|
Posted - 2008.10.05 09:37:00 -
[211]
Also a friendly bump. That's a great piece, which helps enormously when it works.
|
Mike'P
|
Posted - 2008.10.07 23:24:00 -
[212]
Edited by: Mike''P on 07/10/2008 23:25:26
Hi guys,
First off, to Ray, fantastic application, thanks for putting it out there!
[EDIT: just noticed the reference to the September explosion: I believe my patches below solve this - pressure off, Ray! ]
Second off, if any of you have been running it for over a year, you'll start to notice something a bit awry in your weekly and monthly figures - basically, the results from September last year will get mixed in with results for September this year if you're in the overview page looking at the 'month' or 'week' stats. A small bug has crept in.
It seems like Ray has sidestepped this in the next version with the date range approach to getting at that data, but in the meantime, to fix the issue with the current version, here's a little patchiness.
First port of call: functions.php. This is just about adding a $year argument to a few functions and including it into the SQL statement.
Locate the 'get_isk_week_in()' function, and modify it as below:-
function get_isk_week_in($wallet,$week,$year)
{
global $settings;
$query = "SELECT SUM(amount) AS amount FROM `".$settings[$wallet.'journaltable']."` WHERE `amount` > '0' AND WEEK(`date`,1) = ".$week." AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
return number_format($row['amount'], 2, '.', ',');
}
I'm sure you can see what I've done there - an extra argument $year, and change the $query to test the YEAR as well as the WEEK:-)
Now do the same mod for the other 'get_isk_week_xx' functions and the 'get_isk_month_xx' functions.
Second port of call: overview.php.
Line 231: add this
$year = date("Y",mktime(0, 0, 0, $rowdate['date'][1], $rowdate['date'][2][0]-($n*7), rowdate['date'][0]));
Line 233: change to this:
$query = "SELECT * FROM `".$settings[$_GET['wallet'].'journaltable']."` WHERE WEEK(`date`,1) = ".$week." AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
Line 313: add this:
$year = date("Y",mktime(0, 0, 0, $rowdate['date'][1]-$n, $rowdate['date'][2][0], $rowdate['date'][0]));
Line 314: change to this:
$query = "SELECT * FROM `".$settings[$_GET['wallet'].'journaltable']."` WHERE MONTHNAME(`date`) = '".$month."' AND YEAR(`date`) = ".$year." ORDER BY `date` DESC";
and then change any references to the 'get_isk_xxx_xxx' functions modified in functions.php so that they have the extra '$year' argument.
I can make proper unix diffs if anyone wants them.
Hope that helps!
|
Salisuka
Caldari
98.4
|
Posted - 2008.10.10 08:59:00 -
[213]
Ray, will you release SEXY II if I pledge my first born to you?
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.11.06 04:27:00 -
[214]
bumping in the vain hope that there's some updates on the horizon.
|
Lep Erd
Minmatar
Pator Tech School
|
Posted - 2008.12.18 04:06:00 -
[215]
Originally by: Lep Erd
bumping in the vain hope that there's some updates on the horizon.
this... again.
|
You What
The Grill UK
|
Posted - 2008.12.26 16:14:00 -
[216]
bump as well
looking forward to new release as [sexy] is just must-have for me
|
Argator
|
Posted - 2009.01.04 14:53:00 -
[217]
A Must Have !!
|
RaTTuS
BIG
Libertas Fidelitas
|
Posted - 2009.01.04 15:00:00 -
[218]
/me agrees
do it ray or I'll make the humper do something special for you
--
BIG Lottery, BIG Deal, InEve
|
Ray McCormack
hirr
|
Posted - 2009.01.04 15:10:00 -
[219]
Meh, when it's ready. I got sidetracked with SEXY.net Desktop Edition, but SEXY 0.2b will be out before you see that.
|
Argator
|
Posted - 2009.01.04 15:57:00 -
[220]
It's nice to hear that.
|
Forceflow
Gallente
Center for Advanced Studies
|
Posted - 2009.01.22 03:20:00 -
[221]
I followed all the steps but I ended up with this sort of error message on all the tabs:
Notice: Undefined offset: 2 in C:\wamp\www\wallet\overview.php on line 47
Notice: Undefined offset: 1 in C:\wamp\www\wallet\overview.php on line 52
Warning: mktime() expects parameter 6 to be long, string given in C:\wamp\www\wallet\overview.php on line 52
Notice: Undefined variable: thisYear in C:\wamp\www\wallet\functions.php on line 629
Notice: Undefined variable: thisIni in C:\wamp\www\wallet\functions.php on line 631
An suggestions on what i'm doing wrong? |
Saira Jin
|
Posted - 2009.01.22 04:08:00 -
[222]
The demo no worky! Looks like somebody forgot to renew their domain name registration.
|
Eventy One
Magellan Exploration and Survey
|
Posted - 2009.03.12 16:36:00 -
[223]
/bump
|
Hurricane Carter
0ccam's Razor
Nexus-Alliance
|
Posted - 2009.03.29 20:46:00 -
[224]
tried to get it working, throws a bunch of errors that I can't figure out :s
Notice: Undefined index: wallet in C:\wamp\www\eow\wallet19092007\header.php on line 41
Notice: Undefined index: wallet in C:\wamp\www\eow\wallet19092007\header.php on line 42
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 43
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 44
Notice: Undefined index: length in C:\wamp\www\eow\wallet19092007\header.php on line 45
and
Notice: Undefined index: actions in C:\wamp\www\eow\wallet19092007\update.php on line 39
Notice: Undefined index: actions in C:\wamp\www\eow\wallet19092007\update.php on line 56
running latest WAMP versionso honestly don't know whats up. DB's are input but.... mmm don't know what to do at this point
|
Ommand
|
Posted - 2009.05.24 00:39:00 -
[225]
Just posting this here at Ray's request:
I was having some problems getting [SEXY] fully functional, try as I might nothing was showing up in the transactions tab and all of the journal entries were missing information. I talked to Ray and he noticed there was a problem fetching specifically the corporate transaction log, as seen by the series of errors below:
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1000.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1001.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1002.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1003.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1004.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1005.
...updating corporate transactions for xxxx... ...A general error has occured, please try again later. for division 1006.
After much head scratching and bugging Ray I logged into "My Character" here on the eve-o site and attempted to receive said log through that interface, only to be confronted by the same error once again. Once I saw this I went and reset my api key and voila.. all was well again.
Apparently it's possible for one 'small' section of the API to be broken while the rest works flawlessly, who knew?
|
Arazmus Lionheart
|
Posted - 2009.07.13 14:55:00 -
[226]
Does this still work..
I have followed the steps perfectly, I have also looked through the php code (fairly adept at php) and yet I still get no data entered into the MySQL DB..
I get the following repeated indefinatly:
updating personal journal for 641814732... ...0 entries added successfully
i left it for 5 mins once and had over 500 lines of it.... The DB tables are correct and I have reinstalled and reinstalled.. Curl, GD and PHP are all set up correctly yet no joy.. any help?
|
| |
|
| Pages: 1 2 3 4 5 6 7 8 :: [one page] |