Pages: 1 [2] 3 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Mscivy
|
Posted - 2011.04.20 16:15:00 -
[31]
Hey,
great app, works like a charm ... and saves me from trying to webdesign around a hacked previous version I used myself :)
Some things though:
1) the page should refresh when changing selection dates on onblur (or w/e the event is called - losing focus. haven't used jQuery in quite a while) or perhaps when the value is changed
2) it would be great if datapoints on the graph were clickable -> changing the selection dates accordingly onclick, to get the hourly breakdown. No idea if it's possible with the plotting library you're using.
3) info in the 'total value' column in the widget breaking down data by rat type is invalid. total_value != bounty * amount_killed - this becomes an issue when more than 1 person gets the bounty for a particular rat kill. wasn't able to find any decent workaround for that.
4) it would be great to add the notable rats widget to each of the subpages - i.e. breakdown by user, system etc.
5) authorizations - it would be nice to store them in the db + add self registration through IGB (=> verify corp). that i can do myself though ;)
M.
|
Mikk36
Caldari
|
Posted - 2011.04.20 16:51:00 -
[32]
Edited by: Mikk36 on 20/04/2011 16:51:48
Originally by: Mscivy 1) the page should refresh when changing selection dates on onblur (or w/e the event is called - losing focus. haven't used jQuery in quite a while) or perhaps when the value is changed
Currently it refreshes the page when a new value is selected from the popup calendar (the onSelect event). Originally by: Mscivy 2) it would be great if datapoints on the graph were clickable -> changing the selection dates accordingly onclick, to get the hourly breakdown. No idea if it's possible with the plotting library you're using.
Just looked at the flot documentation and it seems to have that capability. Originally by: Mscivy 3) info in the 'total value' column in the widget breaking down data by rat type is invalid. total_value != bounty * amount_killed - this becomes an issue when more than 1 person gets the bounty for a particular rat kill. wasn't able to find any decent workaround for that.
Yup, I have given that thing that thought too, but as there is no better way (not possible to make sure if the rats were killed by the persons in the same fleet and grid or seperately) I just made it assume that they were killed seperately. Default sorting is set on the handler side. Originally by: Mscivy 4) it would be great to add the notable rats widget to each of the subpages - i.e. breakdown by user, system etc.
Good idea, doesn't seem to be hard to implement, just look up how other queries have those things implemented.
|
No07
|
Posted - 2011.04.24 09:17:00 -
[33]
Edited by: No07 on 24/04/2011 09:19:45
Originally by: Mscivy 3) info in the 'total value' column in the widget breaking down data by rat type is invalid. total_value != bounty * amount_killed - this becomes an issue when more than 1 person gets the bounty for a particular rat kill. wasn't able to find any decent workaround for that.
Originally by: Mikk36 Yup, I have given that thing that thought too, but as there is no better way (not possible to make sure if the rats were killed by the persons in the same fleet and grid or seperately) I just made it assume that they were killed seperately. Default sorting is set on the handler side.
Is this the reason why I get quadruple values?
What happens is this, corp has a mission event. Lets say 4 people run missions together in a fleet, the corp tax is set to 100%. After the event, 100 million isk in total was generated in bounties, but all 4 people is reported to have made 100 million.
Also, the corp is still reported to have made only the normal tax income, not the 100%.
There is nothing to do about this?
|
Mikk36
Caldari
|
Posted - 2011.04.24 21:57:00 -
[34]
Originally by: No07 Is this the reason why I get quadruple values?
What happens is this, corp has a mission event. Lets say 4 people run missions together in a fleet, the corp tax is set to 100%. After the event, 100 million isk in total was generated in bounties, but all 4 people is reported to have made 100 million.
Also, the corp is still reported to have made only the normal tax income, not the 100%.
There is nothing to do about this?
You'll get quadruple values only for the rats table. Other places are not affected by this. Be aware though that corporation sheet api has 8-hour cache timer, so that corp tax change could be delayed for up to 8 hours.
|
Takeshi Ryuu
Black Octopus Blind Octopus
|
Posted - 2011.05.02 09:12:00 -
[35]
Is it possbile to use this application for multiple corporations at once (all corpoprations in alliance, for example)?
I see that there is only a single userid/apikey/charid tuple, but may be there are some known hacks for multiple userid/apikey/charid?
|
Mikk36
Caldari
|
Posted - 2011.05.03 12:16:00 -
[36]
Originally by: Takeshi Ryuu Is it possbile to use this application for multiple corporations at once (all corpoprations in alliance, for example)?
I see that there is only a single userid/apikey/charid tuple, but may be there are some known hacks for multiple userid/apikey/charid?
I have given it some thought, will propably have to implement it. The basic layout is this: Create an additional column in the journal for the corporation identifier (either corpID or identifier in the configuration, for example, an array key of the specific api data pair (I'd prefer that myself, can also set that key to be corpID)). That is needed to properly check the latest refID in the journal table against the refID in the XML. Put the API parsing into a cycle so that all api pairs get used and modify the saving part to include the corp identifier.
I've also put up the code on Google Code: http://code.google.com/p/eve-online-carebear-statistics/
|
Nutbolt
Avalon Project Shadow Rock Alliance
|
Posted - 2011.05.04 09:36:00 -
[37]
The install instructions could be more detailed, or a readme, i.e. took me a while to cotton on that I have to upload the static.sql files :p
It is looking pretty sweet, only issue is that when it says total isk what does it mean? Isk that is collected by taxes, or total isk made by the members?
|
Mikk36
Caldari
|
Posted - 2011.05.05 08:45:00 -
[38]
Originally by: Nutbolt Edited by: Nutbolt on 04/05/2011 11:49:04 The install instructions could be more detailed, or a readme, i.e. took me a while to cotton on that I have to upload the static.sql files :p
It is looking pretty sweet, only issue is that when it says total isk what does it mean? Isk that is collected by taxes, or total isk made by the members?
EDIT: So after it has pulled more info, I am guessing its total they have made, is that then including tax or not? and is there any way there can be a tax section, i.e. how much tax each member has paid, and how much tax has been paid in total? I don't care so much if its hidden or not, just would be useful for directors to know how much isk is coming in from tax, and also allow each member to see how much tax they are paying.
It's the amount before taxation. If your corp tax is stable (ie, same percentage all the time), you can multiply the amount shown with the tax. For example, corp tax is 15%, page shows a member having earned 120m. 120m * 0.15 = 18m. Member gained 120m at first, but paid 18m to corp, and net income is in that case 102m.
|
Nutbolt
Avalon Project Shadow Rock Alliance
|
Posted - 2011.05.05 14:42:00 -
[39]
Originally by: Mikk36 It's the amount before taxation. If your corp tax is stable (ie, same percentage all the time), you can multiply the amount shown with the tax. For example, corp tax is 15%, page shows a member having earned 120m. 120m * 0.15 = 18m. Member gained 120m at first, but paid 18m to corp, and net income is in that case 102m.
Ah ok then, cool thanks.
How easy would it be to implement a row on the members pages (so if you click a player and get their stats page type thing) which displays the tax paid? And also maybe next to the total isk (to the right of the date) it state the total tax paid? I have had a quick look at the code but never even looked at java before lol so don't even know where to start.
|
No07
|
Posted - 2011.05.06 06:45:00 -
[40]
Is there a debug I can switch on?
I don't get any new data when I run the cron job. From april 29th and onward i have zero data in the table. No changes done and cron reports no error.
|
|
netbotix
|
Posted - 2011.05.11 22:48:00 -
[41]
Is there a way to get old values? ie from a week ago? It seems that it only grabs for the last few hours (I assume from chron) or is this a limitation on the api fetch
Great app
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.13 15:51:00 -
[42]
excuse me if i sound stupid but what is needed to be changed in the cinfiguration.php
a bit of a idiot with such things sadly
|
Mikk36
Caldari
|
Posted - 2011.05.13 20:37:00 -
[43]
Originally by: netbotix Is there a way to get old values? ie from a week ago? It seems that it only grabs for the last few hours (I assume from chron) or is this a limitation on the api fetch
Great app
On the first fetch it tries to grab as much data as the API provides. If you only get a few hours worth of data, that's what the API provided. Seems oddly low amount though. At the time I developed this, I got generally around 2 days worth of data, around 220 entries, but it seemed to be fixed some two weeks ago or so, when it was properly upped to 2560 entries. Originally by: Psyrelle excuse me if i sound stupid but what is needed to be changed in the cinfiguration.php
a bit of a idiot with such things sadly
At a minimum, you should change the following: public $Auth = array( 'username' => 'password' ); // These are the logins for the page. You can add multiple entries here, just seperate them by commas. // For example: 'user1' => 'pass1', 'user2' => 'pass2'
public $Dsn = 'mysql://username:password@host/database'; // This is the database connection setting, consisting of four parts: the username, password, server address and the database name.
public $UserID = '123'; // This is the userID of the character that has appropriate rights to the corporation wallet
public $ApiKey = 'asd'; // This is the apiKey of the character that has appropriate rights to the corporation wallet
public $CharacterID = '123'; // This is the characterID of the character that has appropriate rights to the corporation wallet
The rest of the settings are trivial, the defaults should work for you.
|
nesdaq
|
Posted - 2011.05.13 23:57:00 -
[44]
Originally by: Mikk36
Originally by: Nutbolt Edited by: Nutbolt on 04/05/2011 11:49:04 [....]
It's the amount before taxation. If your corp tax is stable (ie, same percentage all the time), you can multiply the amount shown with the tax. For example, corp tax is 15%, page shows a member having earned 120m. 120m * 0.15 = 18m. Member gained 120m at first, but paid 18m to corp, and net income is in that case 102m.
plz add this future and include manual entry and default (=current corp tax)
and able to add: * Link main chars with alts so they show up as a single entry and not more. * Able to click on a date/hour(quick select between dates/hours) witch will give u a page with info on those day(s)/hour(s) you've selected (instead entering these manualy) * Colors!! to split other corps/users in graph or so :) * Add formating dd/mm/yy mm/dd/yy and . vs , on the thousands/decimal (not a big prio :) ) bug: * change date is not auto applying when entering the date manual instead using the the calendar
|
Karina Hoeeg
|
Posted - 2011.05.14 05:19:00 -
[45]
Originally by: Mikk36
Originally by: netbotix Is there a way to get old values? ie from a week ago? It seems that it only grabs for the last few hours (I assume from chron) or is this a limitation on the api fetch
Great app
On the first fetch it tries to grab as much data as the API provides. If you only get a few hours worth of data, that's what the API provided. Seems oddly low amount though. At the time I developed this, I got generally around 2 days worth of data, around 220 entries, but it seemed to be fixed some two weeks ago or so, when it was properly upped to 2560 entries. Originally by: Psyrelle excuse me if i sound stupid but what is needed to be changed in the cinfiguration.php
a bit of a idiot with such things sadly
At a minimum, you should change the following: public $Auth = array( 'username' => 'password' ); // These are the logins for the page. You can add multiple entries here, just seperate them by commas. // For example: 'user1' => 'pass1', 'user2' => 'pass2'
public $Dsn = 'mysql://username:password@host/database'; // This is the database connection setting, consisting of four parts: the username, password, server address and the database name.
public $UserID = '123'; // This is the userID of the character that has appropriate rights to the corporation wallet
public $ApiKey = 'asd'; // This is the apiKey of the character that has appropriate rights to the corporation wallet
public $CharacterID = '123'; // This is the characterID of the character that has appropriate rights to the corporation wallet
The rest of the settings are trivial, the defaults should work for you.
Sorry. keep getting a error when trying to log in.
how should I write the things in the config.
this is how I wrote it: public $Auth = array( 'saphyron' => '123456' );
public $Dsn = 'mysql://saphyron_caerbear:826066@saphyron/saphyron_caerbear2';
and what is charID. is that the excat name of of the char or what is it?
p.s. im psyrelle
|
Mikk36
Caldari
|
Posted - 2011.05.14 11:50:00 -
[46]
Originally by: Karina Hoeeg Sorry. keep getting a error when trying to log in.
how should I write the things in the config.
this is how I wrote it: public $Auth = array( 'saphyron' => '123456' );
public $Dsn = 'mysql://saphyron_caerbear:826066@saphyron/saphyron_caerbear2';
and what is charID. is that the excat name of of the char or what is it?
p.s. im psyrelle
Can you log in with the default Auth values? Your charID is what it sounds like: the ID of your character, not name. You can find it from your image here in the forum for exameple. Look up it's image name. The DSN setting looks odd, have you just scrambled it to look odd?
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.14 23:05:00 -
[47]
sent you a ingame mail
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.15 20:49:00 -
[48]
Originally by: Mikk36
Originally by: Karina Hoeeg Sorry. keep getting a error when trying to log in.
how should I write the things in the config.
this is how I wrote it: public $Auth = array( 'saphyron' => '123456' );
public $Dsn = 'mysql://saphyron_caerbear:826066@saphyron/saphyron_caerbear2';
and what is charID. is that the excat name of of the char or what is it?
p.s. im psyrelle
Can you log in with the default Auth values? Your charID is what it sounds like: the ID of your character, not name. You can find it from your image here in the forum for exameple. Look up it's image name. The DSN setting looks odd, have you just scrambled it to look odd?
got it too work now i wrote the database wrongly and the charid.
after that i could log in.
now im just waiting for it to get info about corp and its members.
do you know how long that takes?
|
NoNah
|
Posted - 2011.05.15 21:38:00 -
[49]
Originally by: Psyrelle
Originally by: Mikk36
Originally by: Karina Hoeeg Sorry. keep getting a error when trying to log in.
how should I write the things in the config.
this is how I wrote it: public $Auth = array( 'saphyron' => '123456' );
public $Dsn = 'mysql://saphyron_caerbear:826066@saphyron/saphyron_caerbear2';
and what is charID. is that the excat name of of the char or what is it?
p.s. im psyrelle
Can you log in with the default Auth values? Your charID is what it sounds like: the ID of your character, not name. You can find it from your image here in the forum for exameple. Look up it's image name. The DSN setting looks odd, have you just scrambled it to look odd?
got it too work now i wrote the database wrongly and the charid.
after that i could log in.
now im just waiting for it to get info about corp and its members.
do you know how long that takes?[/quote
Depends on when you set your cron to cycle, worst case you can update it manually, which might be an easier way of catching errors aswell.
It should be mentioned that you need to import one of the static .sqls aswell, not just the carebear.sql. I havn't looked at the differences between 1 and 2. Parrots, commence!
Postcount: 185021
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.16 15:29:00 -
[50]
Originally by: NoNah
Originally by: Psyrelle
Originally by: Mikk36
Originally by: Karina Hoeeg Sorry. keep getting a error when trying to log in.
how should I write the things in the config.
this is how I wrote it: public $Auth = array( 'saphyron' => '123456' );
public $Dsn = 'mysql://saphyron_caerbear:826066@saphyron/saphyron_caerbear2';
and what is charID. is that the excat name of of the char or what is it?
p.s. im psyrelle
Can you log in with the default Auth values? Your charID is what it sounds like: the ID of your character, not name. You can find it from your image here in the forum for exameple. Look up it's image name. The DSN setting looks odd, have you just scrambled it to look odd?
got it too work now i wrote the database wrongly and the charid.
after that i could log in.
now im just waiting for it to get info about corp and its members.
do you know how long that takes?[/quote
Depends on when you set your cron to cycle, worst case you can update it manually, which might be an easier way of catching errors aswell.
It should be mentioned that you need to import one of the static .sqls aswell, not just the carebear.sql. I havn't looked at the differences between 1 and 2.
okay did not know that.
and how to manuelly update the file and how to i set the update interval?
|
|
Mikk36
Caldari
|
Posted - 2011.05.18 10:20:00 -
[51]
NoNah, both static files are needed, the data is just split up to make the files a bit smaller.
Originally by: Psyrelle and how to manuelly update the file and how to i set the update interval?
You can manually open the cron.php file in your browser. To automatically call it, you have to find your hosting provider's panel and find the cron tab from there. For further instructions, contact your hosting provider.
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.19 09:48:00 -
[52]
Originally by: Mikk36 NoNah, both static files are needed, the data is just split up to make the files a bit smaller.
Originally by: Psyrelle and how to manuelly update the file and how to i set the update interval?
You can manually open the cron.php file in your browser. To automatically call it, you have to find your hosting provider's panel and find the cron tab from there. For further instructions, contact your hosting provider.
I am getting this error when I open cron.php
<br /> <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br /> Connection failed
I think I might have wrote something wrong in the configuration.php but I am a idiot to this kind of things.
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.19 10:42:00 -
[53]
Originally by: Psyrelle I am getting this error when I open cron.php
<br /> <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br /> Connection failed
I think I might have wrote something wrong in the configuration.php but I am a idiot to this kind of things.
Did you read the message? It's rather clear. You didn't supplied correct address of your MySQL server. -- Thanks CCP for cu |
Nutbolt
Avalon Project Shadow Rock Alliance
|
Posted - 2011.05.19 11:20:00 -
[54]
Originally by: Psyrelle
Originally by: Mikk36 NoNah, both static files are needed, the data is just split up to make the files a bit smaller.
Originally by: Psyrelle and how to manuelly update the file and how to i set the update interval?
You can manually open the cron.php file in your browser. To automatically call it, you have to find your hosting provider's panel and find the cron tab from there. For further instructions, contact your hosting provider.
I am getting this error when I open cron.php
<br /> <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br /> Connection failed
I think I might have wrote something wrong in the configuration.php but I am a idiot to this kind of things.
Some more detailed install instructions wouldn't go amiss for those of us who havn't a clue about sql etc... however as the previous post states, the error message states that its your server host that is wrong. In the config file where you type in the database details your host is more than likely something like 'localhost'. But this depends on the server setup etc.....
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.19 22:23:00 -
[55]
Edited by: Psyrelle on 19/05/2011 22:24:02
Originally by: Tonto Auri
Originally by: Psyrelle I am getting this error when I open cron.php
<br /> <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br /> Connection failed
I think I might have wrote something wrong in the configuration.php but I am a idiot to this kind of things.
Did you read the message? It's rather clear. You didn't supplied correct address of your MySQL server.
like i wrote severel times im a total idiot setting up databases. since it aint the right one can you then help me how i should write it.
this is how i wrote it: public $Dsn = 'mysql://saphyron_caerbea:826066@saphyron/caerbear2';
database is named saphyron_caerbear2 (please look past the spelling mistake. i know i did it but too lasy to fix it) username is saphyron_caerbea password is 826066
i simple can't get it too work and i don't understand that certain part
EDIT: im using hosting24.com as a provider if that helps
|
Nutbolt
Avalon Project Shadow Rock Alliance
|
Posted - 2011.05.19 23:39:00 -
[56]
Originally by: Psyrelle like i wrote severel times im a total idiot setting up databases. since it aint the right one can you then help me how i should write it.
this is how i wrote it: public $Dsn = 'mysql://saphyron_caerbea:826066@saphyron/caerbear2';
database is named saphyron_caerbear2 (please look past the spelling mistake. i know i did it but too lasy to fix it) username is saphyron_caerbea password is 826066
i simple can't get it too work and i don't understand that certain part
EDIT: im using hosting24.com as a provider if that helps
These are obviously not my correct details but this is essentially my setup for the database line of code:
public $Dsn = 'mysql://nutbolt_cb:password@localhost/nutbolt_cbdb';
Where nutbolt_cb is the username setup for the database. This more than likely will include the account name you use at hosting24, ie my account name is nutbolt and i created a database user cb, the database username is acutally nutbolt_cb.
password is the database password...
localhost is the database host, this is more than likely the same for you, if it still does not work and the error mentions the database host file a support ticket with hosting24 asking for the name of the database host.
nutbolt_cbdb is the name of the database you created for this. In the same way for the username you may need to add your account name to the front of it if it is not already there.
I hope this helps,
Nutbolt |
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.20 01:32:00 -
[57]
Originally by: Nutbolt
Originally by: Psyrelle like i wrote severel times im a total idiot setting up databases. since it aint the right one can you then help me how i should write it.
this is how i wrote it: public $Dsn = 'mysql://saphyron_caerbea:826066@saphyron/caerbear2';
database is named saphyron_caerbear2 (please look past the spelling mistake. i know i did it but too lasy to fix it) username is saphyron_caerbea password is 826066
i simple can't get it too work and i don't understand that certain part
EDIT: im using hosting24.com as a provider if that helps
These are obviously not my correct details but this is essentially my setup for the database line of code:
public $Dsn = 'mysql://nutbolt_cb:password@localhost/nutbolt_cbdb';
Where nutbolt_cb is the username setup for the database. This more than likely will include the account name you use at hosting24, ie my account name is nutbolt and i created a database user cb, the database username is acutally nutbolt_cb.
password is the database password...
localhost is the database host, this is more than likely the same for you, if it still does not work and the error mentions the database host file a support ticket with hosting24 asking for the name of the database host.
nutbolt_cbdb is the name of the database you created for this. In the same way for the username you may need to add your account name to the front of it if it is not already there.
I hope this helps,
Nutbolt
it makes alot more sense.
but i still get this error
<br /> <b>Warning</b>: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'saphyron' (1) in <b>/home/saphyron/public_html/test_carebear/adodb5/drivers/adodb-mysql.inc.php</b> on line <b>365</b><br /> Connection failed
what could be the problem then
everything is default except ive changed the public dns api userid public userid and added the databases all 3 of ehm
|
Tonto Auri
Vhero' Multipurpose Corp
|
Posted - 2011.05.20 03:21:00 -
[58]
Originally by: Psyrelle like i wrote severel times im a total idiot setting up databases. since it aint the right one can you then help me how i should write it.
Then hire someone to set it up for you. It's not like there's a Big Blue Button "Make It All Work". You have to actually set up a database server, a web server, and all the other things that need to run the application.
P.S. One-time system configuration (Apache+PHP+MySQL on windows or Linux(preferred), by your choice) and short educational round over it: 1Bil. -- Thanks CCP for cu |
Nutbolt
Avalon Project Shadow Rock Alliance
|
Posted - 2011.05.20 12:47:00 -
[59]
The error still indicates that it is your database host, like I previously mentioned, try changing it to 'localhost'. if that doesn't work ask your hosting24 what it is.
|
Psyrelle
Caldari Saphyron Industrial Division OmniTech Initiative
|
Posted - 2011.05.20 13:13:00 -
[60]
Originally by: Nutbolt The error still indicates that it is your database host, like I previously mentioned, try changing it to 'localhost'. if that doesn't work ask your hosting24 what it is.
i have changed it to localhost
and i got a reply from my provider that it is localhost. but it still dosent work. which is kind of strange.
|
|
|
|
|
Pages: 1 [2] 3 :: one page |
First page | Previous page | Next page | Last page |