Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Serene Python
52
|
Posted - 2016.06.10 06:48:51 -
[1] - Quote
Original Thread: https://forums.eveonline.com/default.aspx?g=posts&m=716570
Quote:What is EVE-Profit? It is a webpage showing your loss/profit on all your market orders (not station trades nor contracts). It does take broker fee and tax into consideration and it gives some statistics so you can follow your progress month by month or see your most profitable items. You can merge your characters which give you the possibility to have for example a buy-character in Jita and a sell-character in another region and see those two characters as one virtual character - calculating the profit for the virtual character. The webpage is very simple and clean and you can always delete all your information (no history kept).
So after ironing out most of the bugs, I feel more comfortable to bringing this over to Market Discussions where I'm sure it will be appreciated by many more!
First and foremost, I am a large advocate of open source initiatives so in the event I no longer wish to manage this, the source code will be available to all and database will be cleaned of user records. Due to all the issues I had originally setting this up, I have made several changes so this can easily be migrated to a new host.
If you are familiar with the original website you will feel at home with this. I plan on it looking the same with any features I add being subtle and not bothering you if you don't want to see them. One notable change I have added is being able to sort the listing under "Most-profitable Sell", just click the column you want to sort(does not work with period separator, yet).
If you can suggest a feature that can be implemented in a way that isn't going to ruin others experience with this, I'm more than happy to hear you out and look at putting it in.
If you find any bugs/issues feel free to eve-mail me and I'll look into it as soon as I can and keep you updated with what's going on.
Find it HERE You can see what the website looks like from this screenshot from original developer |
Serene Python
52
|
Posted - 2016.06.10 06:53:39 -
[2] - Quote
Reposted thread as I'm hoping to have updates released soon.
I've been in the works for a few months slowly working on migrating some core code that is deprecated now to the current functions, this has resulted in a lot of things breaking(currently transactions don't pull, woooo). The bitbucket page will have a full novel of changes I've made once I'm done.
Current news: I'm updating the server to try and address a security issue that has been long present that was pushed to the side thanks to firewall rules I will be looking for a new server host I'm going to set up a DNS in the next day or so so when the host change happens it'll be a smooth transition. I am also subbed again, thanks CCP for the SP injectors these keep me playing free so you can eve-mail me if you wish instead of email. |
Serene Python
52
|
Posted - 2016.06.12 07:09:42 -
[3] - Quote
We are up and running on an actual URL now! Website should display correctly if you are using the IP address or the actual website address.
Get your trade on here - http://eveprofit.ddns.net
Please try to migrate to this address as I may be changing hosts in the near future. Using the above website will ensure a migrate from hosts will be as painless as possible. If you notice any display issues please contact me. If you have no script you will need to enable it on ddns.net, I just spent an hour wondering why the website design looked different. I'm not very bright some days. |
Denisych
Malfunctioning Drones
0
|
Posted - 2016.06.12 15:02:00 -
[4] - Quote
thanks for doing this. I really enjoyed it the last few rounds you did. |
Tralminia
All Good CO2 Inc.
1
|
Posted - 2016.06.14 00:19:04 -
[5] - Quote
Heya,
I'm getting a " Duplicate entry '2147483647' for key 'PRIMARY' " error, in both old and new servers
Am I doing something wrong?.... |
Piter Presley
Presley Enterprises
16
|
Posted - 2016.06.14 07:27:06 -
[6] - Quote
I get the same error message when I try to update my transactions.
Duplicate entry '2147483647' for key 'PRIMARY'
Cheers, Piter |
Serene Python
52
|
Posted - 2016.06.15 21:29:15 -
[7] - Quote
Piter Presley wrote:I get the same error message when I try to update my transactions.
Duplicate entry '2147483647' for key 'PRIMARY'
Cheers, Piter
I was getting this as well, I'm not entirely certain what causes this cause even my local copy was giving the same error. The code on the website has remained the same however(haven't gotten around to syncing them).
Refreshing the page fixes it easily enough. When I have some time I'll look through the server error logs and see if anything specific is showing in there. |
Tralminia
All Good CO2 Inc.
1
|
Posted - 2016.06.15 23:33:56 -
[8] - Quote
Serene Python wrote:Piter Presley wrote:I get the same error message when I try to update my transactions.
Duplicate entry '2147483647' for key 'PRIMARY'
Cheers, Piter I was getting this as well, I'm not entirely certain what causes this cause even my local copy was giving the same error. The code on the website has remained the same however(haven't gotten around to syncing them). Refreshing the page fixes it easily enough. When I have some time I'll look through the server error logs and see if anything specific is showing in there.
I tried the refresh fix, but it only shows me buy orders. Sell orders not appearing...
|
Piter Presley
Presley Enterprises
16
|
Posted - 2016.06.16 05:26:15 -
[9] - Quote
Same with me. Only buy orders Show up. |
Serene Python
52
|
Posted - 2016.06.19 20:43:05 -
[10] - Quote
We've gone down!
I poked the security issue too hard and I think this caused the server to get automatically shutdown.
Waiting on the host to revive the rival project. |
|
Serene Python
53
|
Posted - 2016.06.24 06:15:02 -
[11] - Quote
We are back up!
Please try to switch to the http://eveprofit.ddns.net domain name as I plan on doing a server migration sometime in the next month. |
Serene Python
53
|
Posted - 2016.06.28 06:51:31 -
[12] - Quote
Notice has been added. I have also changed the date to allow for more time to migrate.
The old server transactions will not be migrated over as of July 16 and the server will be shutdown July 22. If there's still people using the old host July 16 onwards I will have a pop up notification at that point advising the domain has changed, I will not force a redirect as I do not like when websites do this to me so I won't put it on other people. |
Tralminia
All Good CO2 Inc.
1
|
Posted - 2016.06.30 21:21:47 -
[13] - Quote
I still get the same error in the new server.... :( |
Serene Python
53
|
Posted - 2016.07.05 20:11:10 -
[14] - Quote
Tralminia wrote:I still get the same error in the new server.... :(
I believe this is due to some form of API change that was done since i haven't made any changes(beyond file reference, which the API functions shouldn't be touching).
I will take a look at the sell order issue during my free time today, I have created an issue ticket on bitbucket for both of the annoying issues that are occurring.
The duplicate key issue is due to max integer value being reached while querying the station API information, I haven't looked into that just yet since a page refresh fixes it with no noticeable delay. |
Serene Python
53
|
Posted - 2016.07.24 16:02:20 -
[15] - Quote
Cat update - My cat threw up last night and I just seen him eating it. I'm pretty sure I have a dog in a cats body.
Sorry for the horrible delays, I've been really busy at work(grrrr hard worker/greed for overtime). As I've been poking in my spare time, this appears to be a database issue. The variables are stored in an integer column type, I believe changing everything to big integer will fix this, when I made a quick attempt to implement this it didn't work. My next attempt will be just implementing a dirty bypass that ignores the transactions.
What is happening is citadel stationIDs are higher than the maximum integer value which is why there were duplicate entry errors. I will try to wipe all my current modifications(it's Frankensteins monster currently) and get the bypass put in which should be a work around until I correct this.
Fingers crossed this theory isn't wrong like my previous ones, but having a logical explanation for the error now makes me confident this isn't wrong. |
Serene Python
53
|
Posted - 2016.07.25 06:24:47 -
[16] - Quote
I made the integer changes to the installation SQL file and managed to successfully pull my transactions and calculate(I think, I don't station trade anymore) profits. I have sell and buy orders showing now. If time permits in the next day or so I will attempt to implement this fix into the official database without breaking it, only one line of code needed to be changed regarding this. |
Piter Presley
Presley Enterprises
16
|
Posted - 2016.07.25 09:09:04 -
[17] - Quote
That are great news Serene! Thx for taking the time to look into this.
Cheers, Piter |
Serene Python
53
|
Posted - 2016.07.29 16:44:32 -
[18] - Quote
So I assumed the database export I downloaded would actually have been complete, shame on me! Have been short on time so I only ran the import command I went on with my day since I didn't have time to verify everything was successful.
I am downloading it again and will verify whether or not it exports successfully this time. |
Serene Python
53
|
Posted - 2016.07.30 15:46:21 -
[19] - Quote
I think the export file was too big, it cut off at user transactions but otherwise kept everything up to a certain point. I slept in this morning so I was unable to get to this before work(yay cold/gym fatigue).
I have no obligations tonight/tomorrow before/after work so I will have ample time to correct this. |
Serene Python
53
|
Posted - 2016.07.31 17:06:45 -
[20] - Quote
Server is back online, I will work on fixing the database tables in the next few days, latest by Thursday.
Once I'm done some stuff in EVE I'll work on what tables I need to modify and then make a script to update everything. |
|
Serene Python
53
|
Posted - 2016.08.02 20:22:55 -
[21] - Quote
If anyone receives the duplicate error, just eve-mail me what characters you have and I will manully correct your character(s) in the mean time until I correct all the tables. |
ISD Decoy
ISD Community Communications Liaisons
1672
|
Posted - 2016.08.02 21:59:08 -
[22] - Quote
Excessive replies removed at the request of the OP.
ISD Decoy
Captain
Community Communication Liaisons (CCLs)
Interstellar Services Department
|
Serene Python
53
|
Posted - 2016.08.07 18:23:29 -
[23] - Quote
I have corrected all user transaction tables to correctly take citadel station IDs now. |
Serene Python
53
|
Posted - 2016.09.30 21:37:23 -
[24] - Quote
I have had a few users bring to my attention merged characters are failing to create getting the error "Table 'trans_raw_' already exists"
I will look into this during my free time. Just setting up my laptop for development again(yay arch linux). |
Serene Python
53
|
Posted - 2016.11.11 07:14:05 -
[25] - Quote
Nice update to the source code.
I've corrected handling of citadels to be a bit better, still unsure if API provides citadel information yet but the workaround I implemented is a bit better now. This will prevent duplicate key for PRIMARY errors from coming up now.
Merged characters now work, this has been a pain point for several people I am so sorry for how long it's taken me to get around to correcting this, especially with how simple it was to fix.
For people newly installing, it will now actually work. Due to the mysql manager I use exporting table names as lowercase, this screwed up new installations using the sql file. This has now been corrected to have the needed casing. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |