open All Channels
seplocked Market Discussions
blankseplocked EVE-Profit - new update 2011-September-3
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 [2] 3

Author Topic

H'rafir Smith
Posted - 2011.07.06 17:24:00 - [31]
 

Been using the site for a little bit now, but I'm seeing issues.

When I log in and try to open my wallet transactions, I get an error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rafir Smith', race='Caldari', bloodline='Civire', gender='Male' WHERE charid=909' at line 1"

If I refresh, it goes away. However, I'm not getting the right ISK values listed for my total cash etc.

Nomad Quento
Minmatar
Posted - 2011.07.06 20:14:00 - [32]
 

Originally by: H'rafir Smith
When I log in and try to open my wallet transactions, I get an error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rafir Smith', race='Caldari', bloodline='Civire', gender='Male' WHERE charid=909' at line 1"
Fixed. The special character ' is luckily rare in character names. When not handled correctly the database will not accept it but it is quite easy to fix :-)
Please try again and let me know of any problems - either here or with the "bugs" page on the site.

// Nomad Quento

H'rafir Smith
Posted - 2011.07.06 20:40:00 - [33]
 

Rad, its working now. :D

I submitted a bug and saw that fixed within 30 seconds, hah!

Badass man, badass.


Nomad Quento
Minmatar
Posted - 2011.07.08 12:06:00 - [34]
 

Regarding the statistics - as it is now, anyone that is visible to the public can see all the other character names in the statistics. This means that an account with for example 2 chars (where one is more or less a dummy char) then the dummy char can make itself visible for the public while the other remains hidden. As I see it this can be an exploit as this can be used to harvest "who are my competitors". For my own char this makes no difference as I am more or less inactive in trading but for others this may not be good.

I can see a couple of solutions to this:

1) If I want to see real char names in the statistics ALL my chars must be visible for anyone (this is easy to implement)

2) I can only see other char names if my visible char is in the top 10 in at least one category - in this way we know the char is active and a "real" trader

I can see that only two (besides me) have made a char visible, so I would like to know how this can be improved so at least this is not going to be an exploit - any suggestions? Or should there be no possibility to show any real char names?

// Nomad Quento

locJ
Posted - 2011.07.08 13:33:00 - [35]
 

Edited by: locJ on 08/07/2011 13:34:07
why does the choice whether a character is public or not influence what the owner of that character sees ?
Or perhaps I missunderstood you.

I mean If I want to be public, then it's my choice. Others should be able to see me but it shouldn't affect what I'm able to see. Why? Because the people who choose not be public should be repsected no matter what.

Nomad Quento
Minmatar
Posted - 2011.07.08 15:19:00 - [36]
 

Originally by: locJ
Edited by: locJ on 08/07/2011 13:34:07
why does the choice whether a character is public or not influence what the owner of that character sees ?
Or perhaps I missunderstood you.

I mean If I want to be public, then it's my choice. Others should be able to see me but it shouldn't affect what I'm able to see. Why? Because the people who choose not be public should be repsected no matter what.
Because I want people to contribute to get the statistics interesting. If everyone on the page were public but my char isn't, then I get an advantage that I still can see my placement in the statistics but I also can see all the public characters - that's not fair (hey, this is EVE - nothing is fair!)

But maybe you are right - maybe everyone should be able to see everyone public because they have at least chosen to be so?

// Nomad Quento

locJ
Posted - 2011.07.10 19:08:00 - [37]
 

Originally by: Nomad Quento
Originally by: locJ
Edited by: locJ on 08/07/2011 13:34:07
why does the choice whether a character is public or not influence what the owner of that character sees ?
Or perhaps I missunderstood you.

I mean If I want to be public, then it's my choice. Others should be able to see me but it shouldn't affect what I'm able to see. Why? Because the people who choose not be public should be repsected no matter what.
Because I want people to contribute to get the statistics interesting. If everyone on the page were public but my char isn't, then I get an advantage that I still can see my placement in the statistics but I also can see all the public characters - that's not fair (hey, this is EVE - nothing is fair!)

But maybe you are right - maybe everyone should be able to see everyone public because they have at least chosen to be so?

// Nomad Quento


I, for one, see it as a breach of trust.
Everyone has the choice of being public or not. If I say yes, I expect to be public therefor that everybody can see me. But, if I say no, I choose to NOT be public and I expect that nobody can see me.
It's like when some TV crew films me. If I tell them to not show my face on TV they are obliged to do so. When it comes to my face, they have to respect my choice, not the choice of the dude sitting next to me.

Nomad Quento
Minmatar
Posted - 2011.07.10 19:23:00 - [38]
 

Originally by: locJ
I, for one, see it as a breach of trust.
Everyone has the choice of being public or not. If I say yes, I expect to be public therefor that everybody can see me. But, if I say no, I choose to NOT be public and I expect that nobody can see me.
It's like when some TV crew films me. If I tell them to not show my face on TV they are obliged to do so. When it comes to my face, they have to respect my choice, not the choice of the dude sitting next to me.
Just to make absolutely sure everyone gets this right - this is not a matter of everyone being shown on the statistics but merely a matter if I (with my character on the page) have chosen to be shown on the statistics then if everyone else should be able to see my real character name or if that would require them to be shown on the statistics too.
No one will be shown on the statistics unless they choose to!

// Nomad Quento

Get Paid
Posted - 2011.07.13 10:06:00 - [39]
 

Just started using this site a few days ago. I love it! Its so simple and the info is easy to look at!

Nomad Quento
Minmatar
Posted - 2011.07.17 20:03:00 - [40]
 

I have been thinking of a new feature but I am not sure if it actually would be any good in the end, so please let me know and how this perhaps can be solved.

I would like to do an import from EVE Central on the specific items on a regional basis - meaning that I can see the buy and sell prices on that specific item. But... this is an import from EVE Central and I cannot constantly request data from there so I think of an one hour cache... just like the wallet transactions. This means that whatever data I get from EVE Central can be up to one hour old... and I don't know the status of the data - it could even be several hours/days older, depending if anyone has uploaded that specific market info.

The intention was to show if my market order is the leading in the market - either with the highest buy price or the lowest sell price, but if I can't trust the data I get from EVE Central I am not aware if this actually is that helpful anyhow? In high desity places like Jita this would almost surely not be helpgul but perhaps it would be good enough on the slower markets... maybe on non-trade hub places?

Let me know what you think - thanks,

// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.07.20 11:19:00 - [41]
 

Edited by: IceFyre S18 on 20/07/2011 22:08:02
Excellent tool and very easy to use.
Thank you Nomad.

Nomad Quento
Minmatar
Posted - 2011.07.20 13:35:00 - [42]
 

Originally by: IceFyre S18
Nomad can you make statistics public so I can show my E-Peen to everybody?
I have copied this from another thread as I think it is better to keep it here.

The statistics are currently only available to others which has made themself public in the statistics. This is done due to I want people to contribute making this statistic interesting with named characters.

But I love your statistics - very nicely done and keep up the good work (I urge everyone to try and beat IceFyre) ;-)

// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.07.20 21:57:00 - [43]
 

Edited by: IceFyre S18 on 20/07/2011 22:09:48

Thank you Nomad, I'm relatively new player, worked very hard to get to that level.
Too bad my logs are not older than last days, had a interesting turns this month.

About statistics, it's not public to all, need to create account to see them, so not much of a use for e-peen showing Very Happy

Edit: name change Herman->Nomad, I'm sorry my glasses dirty :)

Nomad Quento
Minmatar
Posted - 2011.07.20 23:23:00 - [44]
 

Originally by: IceFyre S18
Thank you Nomad, I'm relatively new player, worked very hard to get to that level.
Too bad my logs are not older than last days, had a interesting turns this month.

About statistics, it's not public to all, need to create account to see them, so not much of a use for e-peen showing Very Happy
I look forward to see WHEN you beat me in the Life-Time Profit... it will for sure not take you long to get there so I am quite impressed... also on your (from time to time) quite well-proportioned wallet. Wallet-wise you beat me times-3 and I am not even having that many orders in escrow... and I have had a couple of years to do it (geee).

The statistics are not currently openend for other than registered users but I will think about your suggestion... this could be a good showoff if one is doing well... and everyone loves a good ranking, ehh :-)

// Nomad Quento

Get Paid
Posted - 2011.07.21 08:55:00 - [45]
 

I have 2 characters linked together. One of the characters API's is showing Buying transactions on the website but not showing the selling transactions. Any thoughts?

The other character is working properly showing both buying and selling transactions.

Nomad Quento
Minmatar
Posted - 2011.07.21 11:48:00 - [46]
 

Originally by: Get Paid
I have 2 characters linked together. One of the characters API's is showing Buying transactions on the website but not showing the selling transactions. Any thoughts?
The other character is working properly showing both buying and selling transactions.
Fixed. This was another problem with all stations not being in the same table (player built outposts not in same table as NPC stations).

// Nomad Quento

Get Paid
Posted - 2011.07.21 15:53:00 - [47]
 

Beautiful! That was fast thanks!

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.07.25 09:35:00 - [48]
 

Shameless bump for an exceptional tool!

This one grants me precious time calculating my day/week/month profit.
And however you turn it, time is of greatest value.
Pure gold, ahem, isk.

Nomad Quento
Minmatar
Posted - 2011.07.31 09:38:00 - [49]
 

I have learned a lot of security issues on webpages the last few days and due to that I have increased the security on my page. Words like "parameterized queries" are no longer strange to me and that should make the world a little safer place to be if all websites used these techniques.

This is the banner on my webpage for the week:

Quote:
With a penetration test it was discovered that this site was vulnerable to SQL injections! :-( This means that it could have been possible for an attacker to gain access to your account and I therefore recommend that everyone change their full API key as soon as possible.

Note that I am not aware of this has actually been misused but better safe than sorry and change that key. Mitigation measures have been installed and I will setup more logging in the future - logging that will be available to you so you can check for yourself for suspicious activities on your account.

I am so sorry about this rather stupid mistake (this is elementary web programming day 1) but if it is worth anything at least I did come out clean with it so you can take your precaution.


// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.08.02 12:10:00 - [50]
 

Security, in general, is a good thing, never enough of it.
No need to take it too seriously there, what can be stolen, market logs? Item traded?

There is no uber secret trade item, nor special trade location that can be exploited if revealed, that's a story older players talk to kids and laugh all the way behind.
No easy win, all is just hard work.

Nomad Quento
Minmatar
Posted - 2011.08.02 16:31:00 - [51]
 

Originally by: IceFyre S18
Security, in general, is a good thing, never enough of it.
No need to take it too seriously there, what can be stolen, market logs? Item traded?

There is no uber secret trade item, nor special trade location that can be exploited if revealed, that's a story older players talk to kids and laugh all the way behind.
No easy win, all is just hard work.
With your full API key someone can get whatever info is available on the API - and that's quite a lot. I always use this page as a reference, http://games.chruker.dk/eve_online/test_eve_api.php. So it is not just the things on my page.

// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.08.03 13:29:00 - [52]
 

Ah, I see now, thank you.
Tho I don't give a **** about my logs or stupid game data, full api gives info about corp/assets/alliance things that touches other people; and they may not choose to share that info public.

(note: the same people put public on Facebook a: birth date, place, sex, sexual orientation, religion and political views, friends, mail and phone, all spiced with half-nude hundreds of pictures, affinities about music and things and some even alot more; but the uber secret item in Rens traded is soo much)
Very Happy

Nomad Quento
Minmatar
Posted - 2011.08.03 19:00:00 - [53]
 

With the last update (where the database tables were restructured) some fields were set to NULL where they should have been 0. This resulted in the profit not being displayed correctly but that has been fixed now.

The site currently has 71 active users with a total of 97 characters associated and I am real happy to see so many using it on a daily basis :-)

Happy profitting,

// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.08.08 16:48:00 - [54]
 

I want to start a bond/loan/whatever,
Nomad, can I use your site as a reference?

flakeys
The Great cornholio's
Paper Tiger Coalition
Posted - 2011.08.08 17:41:00 - [55]
 

SMall question probably mentioned somewhere but can't find it.I use only corporate orders , is there a way to view these as i did not find that option.

Nomad Quento
Minmatar
Posted - 2011.08.08 17:44:00 - [56]
 

Originally by: IceFyre S18
I want to start a bond/loan/whatever,
Nomad, can I use your site as a reference?

I really appreciate your asking first because I think I need to change the statistics visibility option so it has more options - one should be to show the statistics for the public (non-registered users). As this hasn't been done yet I hope you will at least mask/obscure the other visible users so only your character will be shown wherever you post it... well, mine can be shown too, I don't mind.

// Nomad Quento

IceFyre S18
Zulu Labs
Zulu People
Posted - 2011.08.08 17:56:00 - [57]
 

Thank you.
Anybody wants to check my numbers will have to register like everybody else according to rules on eve-profit.

Nomad Quento
Minmatar
Posted - 2011.08.08 18:18:00 - [58]
 

Originally by: flakeys
SMall question probably mentioned somewhere but can't find it.I use only corporate orders , is there a way to view these as i did not find that option.
EVE-Profit really isn't geared towards corporate business. The only indication that you have traded a corporate order is the "C" (corporate) instead of a "P" (personal). This also means that you can filter on it but that's about it - no corporate wallet divisions or other fancy stuff.

// Nomad Quento

Nomad Quento
Minmatar
Posted - 2011.08.08 18:33:00 - [59]
 

Originally by: IceFyre S18
Thank you.
Anybody wants to check my numbers will have to register like everybody else according to rules on eve-profit.

I can't see anything wrong in you posting a picture (with proper masking) showing your earnings. If they then want to doublecheck they can register an account or await until the public records gets available.

// Nomad Quento

Byteflux
Southern Cross Incorporated
Flying Dangerous
Posted - 2011.08.09 01:52:00 - [60]
 

Edited by: Byteflux on 09/08/2011 01:52:42
I'm already using eve-profit to track my profits and it works well for the most part, but as the above person mentioned corporate orders would be handy to display, though not important.

A lot of people trade out of their corporate wallets simply because it's easier to margin trade this way if you have multiple trade characters in separate hubs all buying and selling.

Thanks for great app, keep up the good work!


Pages: 1 [2] 3

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


 


The new forums are live

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

These forums are archived and read-only