| Pages: 1 [2] 3 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
evistin
   |
Posted - 2006.06.18 04:19:00 -
[31]
This Software is Great!! Thank you!!
But I would like 1 request. Not everyone has a large number of databases to play with. For your tables, could you please add an extension to them like say. "pos_user" for the tables. then you can allow me to install this in the same database as other php/mysql applications.
-------------------
Sig removed, please stay away from extremely cute and cuddly sigs, email [email protected] if you have any questions |
g0pher
|
Posted - 2006.06.18 13:56:00 -
[32]
Evistin has a nice point, make it postracker_ even to make it painfully obvious :D
very nice pos tracker. Kazoo Corp is very greatfull for this fantastic contribution.
|
Wringle
|
Posted - 2006.06.21 04:51:00 -
[33]
I am working on adding the silo feature. I will work on it at my liesure have to make isk in game so this takes back seat. The assumptions are that the silo will fill all the time.
I also working on the structures on and offline , the problem with that is you will have to update all your structures everytime you turn one on and off. I am not sure this is worth the effort. If people think so let me know and I will move forward.
The last piece that i have just finished and is in testing is the Pos fuel shopping list. I have added a field that asks how many days of fuel do you wish to have on hand per pos. It will calculate and display a list of materials you need to buy to bring supplies up to your on hand level. This I think can be made available to any corp memeber. This way they can help buy the pos fuel. It will be nice to be at a station and be able to buy the correct amount of fuel needed. Never have to guess again. 
|
Johnathan Roark
|
Posted - 2006.06.21 05:06:00 -
[34]
 Originally by: Wringle
I am working on adding the silo feature. I will work on it at my liesure have to make isk in game so this takes back seat. The assumptions are that the silo will fill all the time.
I also working on the structures on and offline , the problem with that is you will have to update all your structures everytime you turn one on and off. I am not sure this is worth the effort. If people think so let me know and I will move forward.
The last piece that i have just finished and is in testing is the Pos fuel shopping list. I have added a field that asks how many days of fuel do you wish to have on hand per pos. It will calculate and display a list of materials you need to buy to bring supplies up to your on hand level. This I think can be made available to any corp memeber. This way they can help buy the pos fuel. It will be nice to be at a station and be able to buy the correct amount of fuel needed. Never have to guess again.
with the silos, it depends if the silo is the source or output.
On structure, I know alot of corp leave sturtures anchored at there POS that they keep offline and dont use very often.
Alos, in regard to using ingame titles and such to configure access, Id rather set those myself. First, they may change. Second, I want to be aware of who has access.
Corporation Management Improvement |
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.07.24 10:35:00 -
[35]
Very nice tool, thanks for releasing it to the public.
I added 3 functionnalities to it.
- You can claim ownership on a pos
- Pos under 48h of fuel will be highlighted.
- I'm currently finishing the "toggle sovereignty" option.
Ps : since I didn't see any licence attached to the pos tracker, I won't release the modified source unless Randay wishes so.
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.07.24 15:15:00 -
[36]
Edited by: Esaam DeVries on 24/07/2006 15:16:12
You have a bug in the online function.
So I replaced
if ($isotope < $oxygen) {
$online = $isotope;
} else {
$online = $oxygen;
}
if ($online > $mechanical_parts) {
$online = $mechanical_parts;
} else if ($online > $coolant) {
$online = $coolant;
} else if ($online > $robotics) {
$online = $robotics;
} else if ($online > $uranium) {
$online = $uranium;
}
with
$fuel_array = array($isotope, $oxygen, $mechanical_parts, $coolant, $robotics, $uranium, $ozone, $heavy_water);
array_multisort($fuel_array);
$online = $fuel_array[0];
ps: I know you can shorten this in one line but I don't like to do it because after the whole thing looks like a PERL program :p
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Nina Mires
Sharks With Frickin' Laser Beams
|
Posted - 2006.07.25 09:56:00 -
[37]
Edited by: Nina Mires on 25/07/2006 09:56:14
Couple of problems with MySQL 5
You need to remove the default bit for both pos_static & sovereignty_static.
pos_size tinyint NOT NULL default '', = pos_size tinyint NOT NULL,
You also need to switch Strict mode off in my.ini else you won't be able to add any structures.
# Set the SQL mode to strict
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
HTH
Nina
---------
|
franny
The Core Collective
|
Posted - 2006.07.25 16:50:00 -
[38]
anyone recode it to work by alliance instead of corp?
(I know there are restrictions, but bulk shopping 4tw)
and I want the color'd timer code!
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.07.25 17:30:00 -
[39]
Originally by: franny
anyone recode it to work by alliance instead of corp?
(I know there are restrictions, but bulk shopping 4tw)
and I want the color'd timer code!
Originally by: franny
anyone recode it to work by alliance instead of corp?
(I know there are restrictions, but bulk shopping 4tw)
and I want the color'd timer code!
in track.php at line 18 you have the following code.
$sql = "SELECT * FROM pos_info WHERE corp = '" . $_SESSION['corp'] . "' ORDER BY status";
All you need to do is change it to
$sql = "SELECT * FROM pos_info WHERE alliance = '" . $_SESSION['alliance'] . "' ORDER BY status";
And then modify user-transaction.php and add at line 28 (before redirect('track.php');) :
$_SESSION['alliance'] = $row['alliance'];
I didn't try it tbh but it should work 
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
meh bleh
|
Posted - 2006.07.25 17:34:00 -
[40]
Essam any chance I could have a copy of the code that you have used for the highlight and also the timer colour?
My Logistics director would thank me for this tool!
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.07.25 17:58:00 -
[41]
Originally by: meh bleh
Essam any chance I could have a copy of the code that you have used for the highlight and also the timer colour?
My Logistics director would thank me for this tool!
As I already said, it would really help if Randay could allow me to release the modified source. I could do it now but since he stated he might want to make isk with it later, I don't want to ruin his business plan ;) Well it's more a matter of ethics, Randay remains the orignal code writer and I'd prefere to have his ok before releasing the source.
Lets hope he'll read this antytime soon ;)
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
franny
The Core Collective
|
Posted - 2006.07.26 02:06:00 -
[42]
Originally by: Esaam DeVries
Originally by: franny
anyone recode it to work by alliance instead of corp?
(I know there are restrictions, but bulk shopping 4tw)
and I want the color'd timer code!
in track.php at line 18 you have the following code.
$sql = "SELECT * FROM pos_info WHERE corp = '" . $_SESSION['corp'] . "' ORDER BY status";
All you need to do is change it to
$sql = "SELECT * FROM pos_info WHERE alliance = '" . $_SESSION['alliance'] . "' ORDER BY status";
$sql = "SELECT * FROM pos_info WHERE corp = '" . $_SESSION['alliance'] . "' ORDER BY status";
don't know why, but it failed with where alliance, but works with that
now I just need to figure out how to admin with just 1 id, instead of creating one 'admin' id for each corp in the alliance
|
Tammarr
|
Posted - 2006.07.26 02:13:00 -
[43]
I'am waiting for someone to start hosting this for a monthly 50m isk/corp fee ;)
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.07.26 02:25:00 -
[44]
Edited by: Esaam DeVries on 26/07/2006 02:30:36
Originally by: Tammarr
I'am waiting for someone to start hosting this for a monthly 50m isk/corp fee ;)
The code needs to be optimised and some tweaking is needed for the IGB. I made some tests with more than 35 poses and the eve client just freeze for 10s because he doesn't like large tables.
Then it would need some security audit cause right now, I saw about 4 SQL Injection vulnerabilities and I wasn't even looking for them. So my best advice would be, it's a great tool we have there, the work done on data handling is impressive and deserves a thumbs up but don't use an hosted one yet ;)
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
franny
The Core Collective
|
Posted - 2006.07.26 08:59:00 -
[45]
I found a structure missing
Tracking Arrays
didn't look that well for other missing items
|
Tammarr
|
Posted - 2006.07.26 13:22:00 -
[46]
I havent bothered looking at the code yet, whats the fun in not trying to make something yourself first? :)
Sadly all apps I write myself without a overhead plan tends to end in enormous nifty app that never gets completed because I always add more. I hate myself :(
Originally by: Esaam DeVries
Edited by: Esaam DeVries on 26/07/2006 02:30:36
Originally by: Tammarr
I'am waiting for someone to start hosting this for a monthly 50m isk/corp fee ;)
The code needs to be optimised and some tweaking is needed for the IGB. I made some tests with more than 35 poses and the eve client just freeze for 10s because he doesn't like large tables.
Then it would need some security audit cause right now, I saw about 4 SQL Injection vulnerabilities and I wasn't even looking for them. So my best advice would be, it's a great tool we have there, the work done on data handling is impressive and deserves a thumbs up but don't use an hosted one yet ;)
|
Ralle030583
Gallente
|
Posted - 2006.07.27 06:40:00 -
[47]
Originally by: franny
I found a structure missing
Tracking Arrays
didn't look that well for other missing items
you can add it easyly to the structures table and you can use it...
good that everything is in tables and can be changed...
btw I've found an dangerous bug:
if you go into the edit menue of a POS and leave it without changingy anything, the pos tracker save the time of this as last fuel update and the fuel calc is not right anymore... i also searching the bug but haven find it yet.
|
franny
The Core Collective
|
Posted - 2006.07.27 10:15:00 -
[48]
Originally by: Ralle030583
Originally by: franny
I found a structure missing
Tracking Arrays
didn't look that well for other missing items
you can add it easyly to the structures table and you can use it...
good that everything is in tables and can be changed...
btw I've found an dangerous bug:
if you go into the edit menue of a POS and leave it without changingy anything, the pos tracker save the time of this as last fuel update and the fuel calc is not right anymore... i also searching the bug but haven find it yet.
yep, I changed my install(because i'm only hacking the code for my alliance needs before feeding it to our web admin) and my temp install on my webspace
renamed the Small/Medium/Large Projectile Batterys, to xxx Artillery Batterys in mine too
this PHP/MySQL ain't to bad, considering a week ago I knew none whatsoever
|
Randay
Band of Builders Inc.
|
Posted - 2006.08.01 20:12:00 -
[49]
Originally by: Esaam DeVries
As I already said, it would really help if Randay could allow me to release the modified source. I could do it now but since he stated he might want to make isk with it later, I don't want to ruin his business plan ;) Well it's more a matter of ethics, Randay remains the orignal code writer and I'd prefere to have his ok before releasing the source.
Lets hope he'll read this antytime soon ;)
Wow people are actually using my pos thing! yay. I did originally want to try and sell it as a service, but it was impossible to get off the ground like that, so I released it as source because having people actually use it was more important then making money off of it!
That said I have no problem with you releasing any modified source, provided that its free and open to anyone! If you want you can just make a new thread, and I'll update this one with a link to it. I would work with you to update this thread but frankly as you already know I don't spend too much time on this atm.
Im sure your additions and anyone elses additions to the source is greatly appreciated by those who use this thing. Personally I think your additions are great and I'd like to thank you for taking the time to improve this tool. And thanks to everyone who uses it too.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
franny
The Core Collective
|
Posted - 2006.08.02 10:07:00 -
[50]
/me sits in a corner waiting quietly for the colored code and claim POS code
(10 seconds later)
/me gets bored and starts bouncing up and down looking for the code
patience isn't my strong point
|
Nina Mires
Sharks With Frickin' Laser Beams
|
Posted - 2006.08.02 11:13:00 -
[51]
Thanks for getting back to the post Randay.
I've made a couple of amendments to fit in with how i see it working for us. namely removing the .SESSION[CORP] from both the track, and admin pages so that you can view the pos's even if your not in the corp who owns said pos's.
There maybe a bug in the register.php as i don't think it likes frickin' in the corp title. So i had to manually add the user into the sql database.
Hitting enter on the page to login instead of clicking on the button also doesn't work it takes you to a blank screen instead of to track.php.
HTH.
Nina
---------
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.02 22:53:00 -
[52]
Edited by: Esaam DeVries on 02/08/2006 22:56:01
Originally by: Nina Mires
Thanks for getting back to the post Randay.
I've made a couple of amendments to fit in with how i see it working for us. namely removing the .SESSION[CORP] from both the track, and admin pages so that you can view the pos's even if your not in the corp who owns said pos's.
There maybe a bug in the register.php as i don't think it likes frickin' in the corp title. So i had to manually add the user into the sql database.
Hitting enter on the page to login instead of clicking on the button also doesn't work it takes you to a blank screen instead of to track.php.
HTH.
Nina
It's because of the '
What you need is add backslashes to special chars.
The enter bug is an IGB problem, sadly.
I will soon release the new code with out of game mail alerts and alliance support but I'd like to correct a few things before. ;)
And yeah, thank you randay for the hard work you put in this.
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
franny
The Core Collective
|
Posted - 2006.08.04 08:55:00 -
[53]
Esaam in your code for "Pos under 48h of fuel will be highlighted"
is that 1 color or 2?, it dawned on me, might be good to do 1 color(lets say yellow) for say 30-48hrs, and then another for 30hrs down
gives a higher priority to the lower fuel, if they are allowed to drop that low
|
Wipster
Shattered Star Confederation
|
Posted - 2006.08.04 14:59:00 -
[54]
Hey just found this lil program, looks to be very handy through I just installed it on my local webserver to test it and when I setup my name and access level and try to log in I get 'Notice: A session had already been started - ignoring session_start() in c:\program files\easyphp1-8\www\postracker\user-transaction.php on line 23' and when I refresh the page everything is okey........ bit strange, anyone elce have this orrrr just me?
Wip
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.04 20:39:00 -
[55]
Edited by: Esaam DeVries on 04/08/2006 20:43:50
Edited by: Esaam DeVries on 04/08/2006 20:41:47
Originally by: franny
Esaam in your code for "Pos under 48h of fuel will be highlighted"
is that 1 color or 2?, it dawned on me, might be good to do 1 color(lets say yellow) for say 30-48hrs, and then another for 30hrs down
gives a higher priority to the lower fuel, if they are allowed to drop that low
Atm it's four colors. one below 48 hours and one below 24.
Plus, you have 2 more colors (overided by the fuel level ones)
One for the poses you claimed
One for the pos you just modified (so it eases the edit then view for control).
The out of game mail works as following :
Under 48 hours, it mails the owner every 12 hours.
Under 24 hours, it mails all the pos managers in the corp.
(of course, you can change the levels ;))
I'm finishing a few heavy database modifications before releasing the new code.
I'm adding silo support and for this I need some more fields and it breaks the downward compatibility).
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Joe Momiac
|
Posted - 2006.08.04 22:35:00 -
[56]
sorry to say it..
i think it is to hard to install and get it working ..
i have never worked with mysql
i canŠt even get in to the install.php
so here is a sugestion..
sugestion do a much easier installation notes..
i have a linux server with apache..
installed the mysql server and webmin-mysql ..and now i have no clue
selling gtc sometimes |
franny
The Core Collective
|
Posted - 2006.08.05 05:59:00 -
[57]
Originally by: Esaam DeVries
Edited by: Esaam DeVries on 04/08/2006 20:43:50
Edited by: Esaam DeVries on 04/08/2006 20:41:47
Originally by: franny
Esaam in your code for "Pos under 48h of fuel will be highlighted"
is that 1 color or 2?, it dawned on me, might be good to do 1 color(lets say yellow) for say 30-48hrs, and then another for 30hrs down
gives a higher priority to the lower fuel, if they are allowed to drop that low
Atm it's four colors. one below 48 hours and one below 24.
Plus, you have 2 more colors (overided by the fuel level ones)
One for the poses you claimed
One for the pos you just modified (so it eases the edit then view for control).
The out of game mail works as following :
Under 48 hours, it mails the owner every 12 hours.
Under 24 hours, it mails all the pos managers in the corp.
(of course, you can change the levels ;))
I'm finishing a few heavy database modifications before releasing the new code.
I'm adding silo support and for this I need some more fields and it breaks the downward compatibility).
nice
|
Nina Mires
Sharks With Frickin' Laser Beams
|
Posted - 2006.08.05 11:53:00 -
[58]
Originally by: Esaam DeVries
Edited by: Esaam DeVries on 04/08/2006 20:43:50
Edited by: Esaam DeVries on 04/08/2006 20:41:47
Originally by: franny
Esaam in your code for "Pos under 48h of fuel will be highlighted"
is that 1 color or 2?, it dawned on me, might be good to do 1 color(lets say yellow) for say 30-48hrs, and then another for 30hrs down
gives a higher priority to the lower fuel, if they are allowed to drop that low
Atm it's four colors. one below 48 hours and one below 24.
Plus, you have 2 more colors (overided by the fuel level ones)
One for the poses you claimed
One for the pos you just modified (so it eases the edit then view for control).
The out of game mail works as following :
Under 48 hours, it mails the owner every 12 hours.
Under 24 hours, it mails all the pos managers in the corp.
(of course, you can change the levels ;))
I'm finishing a few heavy database modifications before releasing the new code.
I'm adding silo support and for this I need some more fields and it breaks the downward compatibility).
Sounds like you've been hard at it Esaam.
Silo support would be superb.
Let me know if you need anything testing.
Nina
---------
|
Malson Russo
|
Posted - 2006.08.05 15:32:00 -
[59]
I would also be interested in seeing your changes Esaam. I've got the original files installed and running but I've hit a few snags when it comes to actually managing the POS information. I look forward to your post.
|
franny
The Core Collective
|
Posted - 2006.08.05 18:57:00 -
[60]
Originally by: Joe Momiac
Edited by: Joe Momiac on 05/08/2006 09:52:43
sorry to say it..
i think it is to hard to install and get it working ..
i have never worked with mysql
i canŠt even get in to the install.php
so here is a sugestion..
sugestion do a much easier installation notes..
i have a linux server with apache..
installed the mysql server and webmin-mysql ..and now i have no clue
i think it step 4 the problem are in .. do i need to create a table... if yes.. what should i typ in the field to create table..
if you put in evry tiny info you have aboute howto setup this . thene more people will love you
you create the database, the install.php creates the tables
but with the major revamp thats coming, you might want to wait a bit
and the process in the 1st post is 99% of the work, if you have webspace(or a personal server) that supports it
|
| |
|
| Pages: 1 [2] 3 :: one page |
| First page | Previous page | Next page | Last page |