| Pages: 1 2 3 :: [one page] |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Randay
   |
Posted - 2006.06.05 02:03:00 -
[1]
Sorry it took so long, been busy, new job.
The old thread
Disclaimer: I take no responsibility for what may come from modified versions of my creation. I make no obligation to support the software, Ill try my best to help, hopefully noone has any problems.
Download the source
Installation:
1. unzip
2. edit config.php.changeme
3. rename config.php.changeme to config.php
4. create a database
5. browse install.php
6. register yourself
7. use php myadmin or something to change your access
8. send me some isk 
enjoy
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Randay
|
Posted - 2006.06.06 00:40:00 -
[2]
lots of reads, anybody using this/planning on?
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Elieza
|
Posted - 2006.06.06 04:28:00 -
[3]
1) Installer had issues, due to "default ''" on numeric types. MySQL 5 doesn't like this at all. I removed all defaults from your CREATE TABLE statements and it worked.
2) You still have a redirect to your servers's IP, which appears (to the startled person who gets redirected there) that you're stealing passwords. Upon closer inspection it seems that's not the case, but it very well could have been.
3) Having to manually edit the database to set access is a little clunky, most folks won't know how to do that sort of thing.
Once I got the above sorted out, it worked. I'm not entirely sure if this utility will be useful or not, my corporation wanted to evaluate it, so I set it up locally for them to look at. It's a good start, if nothing else!
|
Randay
|
Posted - 2006.06.06 04:58:00 -
[4]
Edited by: Randay on 06/06/2006 05:02:04
ah cool. originally i didnt plan on releasing the code. guess i missed that redirect. its fixed now and i will edit first post to reflect that. as you can see there is a lot of (now) useless debug code, feel free to clean that up too 
also about manually editting the database, you are welcome to make a little page to set superuser :P. as for the install.php, i will leave it like that but im sure people can figure it out after reading your post.
thanks for the input. i think i am just happy that someone will finally make use of my first php project. a pity i couldnt host it like i wanted because of that whole pos paranoia thing.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Lufio II
|
Posted - 2006.06.06 16:24:00 -
[5]
I'm about to install it, just following the hints of the poster a little bit above and already have one suggestion:
It might be useful to be able to set some prefix for the tables in the config.php... as especially a table "user" is quite common in all sorts of applications, most of them uses prefixes already, so it's not *that* bad. Just makes it easier if one runs more than one app in the same DB.
|
Randay
|
Posted - 2006.06.06 17:07:00 -
[6]
 Originally by: Lufio II
I'm about to install it, just following the hints of the poster a little bit above and already have one suggestion:
It might be useful to be able to set some prefix for the tables in the config.php... as especially a table "user" is quite common in all sorts of applications, most of them uses prefixes already, so it's not *that* bad. Just makes it easier if one runs more than one app in the same DB.
good idea, but i dont think ill have time to make those changes. i recommend just using a seperate database.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Lufio II
|
Posted - 2006.06.06 17:27:00 -
[7]
hehe, okthen I will add it :) I have to do a lot of bugfixing anyway since I got a sort of paranoid server setup PHP-Wise and currently it's not really working at all.
Hint: don't use short tags ( <? ) as that's not working on some more restricive setups, luckily there's not much in your code to change for that (to <?php in every case). Same goes for HTTP_SERVER_VARS, altho that might be an issue with PHP5, I think that in later PHP4 versions you could disable those global variables as well (there are other, less security relevant ways)... I'll get into that and send you the new version (if you want) :)
|
Alain Josviar
|
Posted - 2006.06.06 17:27:00 -
[8]
Not to knock your work at all and this is just a general musing rhetorical question, but WTF do people underestimate the utility of a pencil, paper and if needed calculator in this day and age.
/shakes head and walks away mumbling under his breath.
|
Randay
|
Posted - 2006.06.06 18:46:00 -
[9]
Originally by: Lufio II
hehe, okthen I will add it :) I have to do a lot of bugfixing anyway since I got a sort of paranoid server setup PHP-Wise and currently it's not really working at all.
Hint: don't use short tags ( <? ) as that's not working on some more restricive setups, luckily there's not much in your code to change for that (to <?php in every case). Same goes for HTTP_SERVER_VARS, altho that might be an issue with PHP5, I think that in later PHP4 versions you could disable those global variables as well (there are other, less security relevant ways)... I'll get into that and send you the new version (if you want) :)
Sure, I would love a copy. What exactly is wrong with using HTTP_SERVER_VARS? Is there another way of calling those vars? As for the short tags that is something to remember for next time I guess.  I am working on another project, hopefully itll be a bit more public-friendly. Thanks for the input.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Randay
|
Posted - 2006.06.06 18:53:00 -
[10]
Originally by: Alain Josviar
Not to knock your work at all and this is just a general musing rhetorical question, but WTF do people underestimate the utility of a pencil, paper and if needed calculator in this day and age.
/shakes head and walks away mumbling under his breath.
It was designed with a corp-wide tool in mind. You couldn't very well share your paper, pencil, and calculator over the internet now could you? Well, actually you could but it would be a lot more work depending on how many people in your corp help to manage your POSes. If its any consolation, I did use a pen and notebook to help design and code it, even a calculator, though it was a handy dandy scientific calculator that ran on cosmic light and chemical reactions, not the good old abacus. Also the pen was retractable, and it had gel-ink, wasnt one of those good pens where the ink and the pen is seperate and then you gotta dip it into the ink and hold it the right way to get the right thickness. Also the notebook was bound together with metal wires, and it had a perforrated edge so you could rip out a page and still have a straight edge on it.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Lufio II
|
Posted - 2006.06.06 20:30:00 -
[11]
Ok, I seem to have squished out the issues I had by now... it seems to be up and runnig, fixed an issue with the Sovereignity-Checkbox as well (involves the stupid IGB sending "on" and "off" as value instead of 0 or 1...
I sent you an (rather long) EVE-Mail with a few more infos Randay 
|
SGXiphias
|
Posted - 2006.06.07 02:54:00 -
[12]
im definantly interested in using this, i got the PHP stuff working, just dont know anything about SQL. Anyone able to help? i created the DB and created the user table, but from there im clueless.
|
Lufio II
|
Posted - 2006.06.07 10:40:00 -
[13]
the install.php file should create all the tables you need. Once installed, you need to register your user and then look it up in the user-table. There you set the accesslevel to 3. (either use a graphical tool like phpmyadmin or build the UPDATE-Statement yourself, it's not that hard:
UPDATE user SET access = 3 WHERE name = 'Lufio II';
Replace the Lufio II with the charactername you used for registering.)
|
Randay
|
Posted - 2006.06.08 02:26:00 -
[14]
There may or may not be an issue with sovereignty correctly being passed to the DB, due to a change in the way that IGB gives values for a checkbox.
Also might be a new and improved version going up, and maybe an even more detailed setup walkthrough.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Lygos
|
Posted - 2006.06.08 03:04:00 -
[15]
Originally by: Alain Josviar
Not to knock your work at all and this is just a general musing rhetorical question, but WTF do people underestimate the utility of a pencil, paper and if needed calculator in this day and age.
/shakes head and walks away mumbling under his breath.
More users. No access licenses. Runs on ye olde 200MHz server. Semi-static information that other team members can update. Kills trees faster, unless you're one of them weirdos with a solar powered webserver.
In truth, you don't need this kind of software if you have only one terminal or office to worry about.
|
Therem Harth
|
Posted - 2006.06.08 23:22:00 -
[16]
Randay, sovereignity should be an editable setting, because it's a thing that can change over time and you need to account for it.
|
Randay
|
Posted - 2006.06.09 00:21:00 -
[17]
it is. its a little checkbox that you check and then the consumables per hour changes accordingly. unless i dont understand what you are talking about, in which case: huh?
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Randay
|
Posted - 2006.06.09 04:56:00 -
[18]
small update to correct an issue that popped up when correcting that older issue with sovereignty and the igb and ogb and stuff
current version 1.01
http://www.gee-gee.org/eve/postracker-1.01.rar
Thread updated as well.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Therem Harth
|
Posted - 2006.06.09 05:30:00 -
[19]
Originally by: Randay
it is. its a little checkbox that you check and then the consumables per hour changes accordingly. unless i dont understand what you are talking about, in which case: huh?
it is editable only when adding a new POS. So here I am, setting up a POS in a system; I go to this fantabulous piece of software in IGB and add a POS and fill in stuff and all is well. I truthfully leave sov checkbox unchecked. However, in 5 days or so my POS generates sov claim; of course I want it to be reflected in the calculations by the fantabulous software - but alas! when I click "edit", I can only change fuel amounts but not sov status. The only way to account for the newly acquired sovereignity is to delete a pos listing and create it anew, which is, let's say, not exactly convenient, especially if you have a few structures in it to select from all the listboxes again.
Is this clearer? I mean, I want to be able to toggle sov status in the "edit" page, not only during adding a pos.
|
Randay
|
Posted - 2006.06.09 07:11:00 -
[20]
Oh, guess thats something I forgot about or just never realized. I didnt get much testing because I dunno... people didnt want to touch the beta phase for fear of me giving away thier pos info or something. some day it might get added in. you are welcome to do it yourself though. As it is I have very little time to fix that, sorry. It shouldnt be too hard for someone to fix though.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Lufio II
|
Posted - 2006.06.09 10:42:00 -
[21]
Originally by: Therem Harth
Originally by: Randay
it is. its a little checkbox that you check and then the consumables per hour changes accordingly. unless i dont understand what you are talking about, in which case: huh?
it is editable only when adding a new POS. So here I am, setting up a POS in a system; I go to this fantabulous piece of software in IGB and add a POS and fill in stuff and all is well. I truthfully leave sov checkbox unchecked. However, in 5 days or so my POS generates sov claim; of course I want it to be reflected in the calculations by the fantabulous software - but alas! when I click "edit", I can only change fuel amounts but not sov status. The only way to account for the newly acquired sovereignity is to delete a pos listing and create it anew, which is, let's say, not exactly convenient, especially if you have a few structures in it to select from all the listboxes again.
Is this clearer? I mean, I want to be able to toggle sov status in the "edit" page, not only during adding a pos.
It's on my list to add as well already. Another thing I will add probably during this weekend (if Randay doesn't do it that is) is adding a checkbox for outpost coverage, as that affects fuel usage even further if I'm not mistaken (I think it was another 25%).
|
Johnathan Roark
|
Posted - 2006.06.12 20:10:00 -
[22]
Ive installed this. Its great, i think we'll give it alot of use.
Here are a few issues I found:
Not all of our sturtures are always online.
on tower status, it displays the time of enriched uranium only even if thats not the first to run out
As far as outpost making a diffrence on fuel, i wish, but nope :( Atm, its right on.
Corporation Management Improvement |
Utoxin
|
Posted - 2006.06.14 16:37:00 -
[23]
Randay, this your first major PHP project?
If so, not bad. I just installed the site last night, and fiddled with it. It has some glitches, but they're minor.
However, I'm probably going to do a massive overhaul on the permissions aspect, making it use corp roles to manange view/edit/admin permissions.
Also, I'll be adding names for towers, and possibly more precise locations, for those corps who have multiple POS's in one system.
If you want a copy of my changes when I'm done, contact me here or shoot me an EVE mail.
|
Randay
|
Posted - 2006.06.15 03:18:00 -
[24]
Originally by: Utoxin
Randay, this your first major PHP project?
If so, not bad. I just installed the site last night, and fiddled with it. It has some glitches, but they're minor.
However, I'm probably going to do a massive overhaul on the permissions aspect, making it use corp roles to manange view/edit/admin permissions.
Also, I'll be adding names for towers, and possibly more precise locations, for those corps who have multiple POS's in one system.
If you want a copy of my changes when I'm done, contact me here or shoot me an EVE mail.
yes, my first. I wanted to work on it more, but public support was iffy at best due to the rampant nature of spying in eve. Plus I got a new job, less time for personal hobbies, and Im not about to cut out gaming :P. As for using corp roles, thats a good idea. I think I didnt include that initially because I didnt want to think of a way to parse that whole corp role value, but I saw that eve script thing, nifty. Also I wanted the site to be accessable by out of game browsers, which would have posed a problem if they had the corp role removed and then just didnt use the igb. But now that I think about it it probably wont be used much out of game anyway.
Good luck on your modifications. If you want to share with others let me know and we can get a version to me and ill put it up for download and update the thread.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Audrea
|
Posted - 2006.06.17 06:50:00 -
[25]
Edited by: Audrea on 17/06/2006 06:50:21
I am glad you finally decided to open it to the public, way to go! :)
I will pass the thread link to our php guy to set it up :)
Have you though of opening a working space on the open source developing sites/forums?
Will allow those with php experience to help you improve the tool even further, without having several people work on same section of the code.
And also allow intergration into one code, instead of looking for the modified version of xxx 
Thanks for the tool! :)
------------------
If you are tired of fleet combat lag, post HERE
All posts are my personal opinions. |
Bunny Blue
|
Posted - 2006.06.17 19:31:00 -
[26]
Hey I got everything running great but when I add a POS to the DB this is the error I get:
Error retrieving from pos_structures in function uptimecalc;You have an error in your SQL syntax near 'ON ps.type_id = ss.id WHERE ps.pos_id = '1'' at line 1
Can anyone help?
Thanks,
Bunny Blue
|
Futile Zombie
|
Posted - 2006.06.17 20:45:00 -
[27]
Same problem as me. The MySQL version is older than the OP i think. It doesnt like the JOIN command. Use a differnt join style such as:
SELECT * FROM pos_structures ps, structure_static ss WHERE ps.type_id = ss.id
Works fine for me afterwards.
Great tool btw. |
Bunny Blue
|
Posted - 2006.06.17 20:55:00 -
[28]
Can you tell me what files I would need to change and give me a before and after of a line change.
Thanks again,
Bunny Blue
|
Futile Zombie
|
Posted - 2006.06.17 21:20:00 -
[29]
Sent you an eve-mail. |
Bunny Blue
|
Posted - 2006.06.18 00:56:00 -
[30]
WOW works perfectly!
Thanks for the help m8
Bunny Blue
|
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
|
Joe Momiac
Caldari
Demon Womb
|
Posted - 2006.08.05 22:19:00 -
[61]
oki i got the mysql database working and the install.php..
but getting
error creating pos_static; invalide default value for `pos_size`
selling gtc sometimes |
Aeaea
XanoTech
|
Posted - 2006.08.05 23:00:00 -
[62]
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).
<3
Tried out the current code so far, it's nice, but not feature rich to justify use for me.
|
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.06 10:00:00 -
[63]
Originally by: Aeaea
Tried out the current code so far, it's nice, but not feature rich to justify use for me.
Depends on your needs tbh, i know looking after 1 pos is a pain but with more pos's comes more headache, your bound to miss refueling.
Some other thoughts would be an option to show how much fuel is in the corporate hanger array.
Then an option to show how much is needed to refuel a certain pos for 4 weeks say at current usage.
Or an option to say, i need these 3 pos's in the same location all refueled to a date in time, how much stuff do i need and mail it to me.
I'm assuming the silo option takes into account the reaction you are doing?
Anyone else any ideas?
Nina
---------
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.06 19:26:00 -
[64]
Edited by: Esaam DeVries on 06/08/2006 19:33:08
Edited by: Esaam DeVries on 06/08/2006 19:27:57
Originally by: Nina Mires
Or an option to say, i need these 3 pos's in the same location all refueled to a date in time, how much stuff do i need and mail it to me.
A bit like that ?
The "place an order for some fuel is already hardcoded into the database, need to finish it"
I'm starting the silo part but the new tracker will be released without it as soon as I finished to modify the tables and field types so you won't need to change the whole database scheme again...
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.06 20:52:00 -
[65]
Yep you've got it exactly what i had in mind.
Nina
---------
|
Johnathan Roark
Caldari
Quantum Industries
Prime Orbital Systems
|
Posted - 2006.08.07 20:04:00 -
[66]
I defently looking foward to this update, will make our POS operations go alot more smothly.
Corporation Management Improvement |
Nina Mires
Sharks With Frickin' Laser Beams
Mercenary Coalition
|
Posted - 2006.08.09 20:50:00 -
[67]
/me waits for SVN access.
Nina
---------
|
Esaam DeVries
Infinite Improbability Inc
Dusk and Dawn
|
Posted - 2006.08.09 21:01:00 -
[68]
Originally by: Nina Mires
/me waits for SVN access.
Nina
I might go svn after the 1st release.
I finished adding support for logistic projects. Ie : you assign poses to project and then you can get a fuel quotation for the whole project ;) I'm struggling a bit with silo / production support cause I don't want to get to the point where it would be more efficient to break everything and restart from scratch cause I know myself, I will break everything and then stop cause it will bore me
Soon (tm).
--
TRUST Shop : from T2 to Captital ship(yard)s. Shop smart, shop T-shop. |
Malson Russo
|
Posted - 2006.08.10 21:26:00 -
[69]
The demo works very well for me. I'll keep twiddling my thumbs until you release your updated files <whistles>
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.14 18:28:00 -
[70]
Edited by: Utoxin on 14/08/2006 18:32:09
Would you be interested in patches to handle charters and the display of optimal fuel level needs?
Screenshot of my features: http://krin.kydance.net/gallery/d/30-1/optimal_fuel.png
It calculates optimum by taking the current strontium levels, rounding it down so that there isn't any surplus that isn't needed to keep the current number of cycles, and then calculating the m3 needed for one full cycle of fuel. then it figures out how many full cycles can fit in the non-strontium used m3, and uses that number to calculate the units of each fuel type.
|
Utoxin
Caldari
Kydance Radiant Industries
|
Posted - 2006.08.14 18:40:00 -
[71]
Originally by: Esaam DeVries
The enter bug is an IGB problem, sadly.
eve-bay.biz handles enter properly on login, though I haven't been able to figure out how. As far as I can tell, they're not doing anything special. Maybe someone else can figure out their secret?
|
Tacaro Drigo
|
Posted - 2006.08.18 15:54:00 -
[72]
It looks good..
How can i get it, since the link doesn't work.
|
Bronko Buzman
|
Posted - 2006.08.18 16:32:00 -
[73]
is this software elsewhere aviable ? the download fails.
thanks
|
Randay
0utbreak
|
Posted - 2006.08.18 22:47:00 -
[74]
try again.
-------------------------------------------
Apparently the Swedish language is against the rules of the forums. |
Tacaro Drigo
|
Posted - 2006.08.21 18:21:00 -
[75]
I Cant' login in IGB, it seems like the Session Vars get lost after the login phase, when it goes to the tracker.php, the session vars regarding to the user are null, and then gives the error:
You do not have access, ask your CEO for access!
If your access has been set, please relog back in to the website!
I can register players, the login is the only problem.
When i use IE it all works fine.
Just added Structures for the stocking of fuel. Needs improvement though.
|
franny
Phoenix Knights
|
Posted - 2006.08.21 20:54:00 -
[76]
Originally by: Tacaro Drigo
I Cant' login in IGB, it seems like the Session Vars get lost after the login phase, when it goes to the tracker.php, the session vars regarding to the user are null, and then gives the error:
You do not have access, ask your CEO for access!
If your access has been set, please relog back in to the website!
I can register players, the login is the only problem.
When i use IE it all works fine.
Just added Structures for the stocking of fuel. Needs improvement though.
are you hitting enter?, or clicking the login button?, the enter in igb is a known issue
once session access has to be set, log out, then back in and it usually works
the dev release is nicer, and has more features, but you'd have to find it
|
EveJoker
|
Posted - 2006.08.22 06:52:00 -
[77]
Just a little problem I hope someone can help with, when I login I get this message:
Could not get pos_info; 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 'bu Kau Beh'Hude' ORDER BY status' at line 1
My guess is that the DB dosent like the ' in our name. Is there an easy solution for this?
|
Space Hog
NEW DAWN CO
Fuzzy Nut Attack Squirrels
|
Posted - 2006.12.13 02:22:00 -
[78]
Can someone release a working version for me. I am getting a error on the install on 'pos_size'
Thanks,
Caution
Visit Nuts |
franny
Phoenix Knights
|
Posted - 2006.12.13 05:35:00 -
[79]
Edited by: franny on 13/12/2006 05:37:26
Originally by: Space Hog
Can someone release a working version for me. I am getting a error on the install on 'pos_size'
on this release, or the developers release(which has a lot of bug fixes)?
for the developers release check sourceforge here
i'll see if I can dig up it's thread too, nevermind the thread is linked in the 1st page
CEO - PKKP
Recruitment |
Ammath
The 5 Amigo's LLC.
NxT LeveL
|
Posted - 2007.02.13 05:19:00 -
[80]
anything going on with this?
Ammath
Director
The 5 Amigos LLC
|
Stitchedscars
|
Posted - 2007.06.26 09:12:00 -
[81]
I have worked with mysql and websites before. Im having problems with the install. I changed the names, added the data, and uploaded the files. When i go to XXX/install.php i get a blank white screen. I did a test and put the wrong database info and get a white screen with can not connect to data base. Anyone got any clue.
The onlything i can figure is i might have a bad file and i have tried redownloading and re installing with no success. So any help would be nice. If i have to i might try to create all fields and data by hand but that takes alot of work. Please let me know if you or anyone can help.
Stitched
|
Gilgamoth
Imperium Technologies
Firmus Ixion
|
Posted - 2007.06.26 11:40:00 -
[82]
Edited by: Gilgamoth on 26/06/2007 11:41:37
This version is old (see the OP date of June 06). It's been updated by Esaam here although he has stated the he can't develop it any more, however I hope to update it in the near future.
Regards,
Gil
Future Falcon EVE Tools - Project Leader.
|
franny
Phoenix Knights
Dark Nebula Galactic Empire
|
Posted - 2007.06.26 11:48:00 -
[83]
Originally by: Stitchedscars
I have worked with mysql and websites before. Im having problems with the install. I changed the names, added the data, and uploaded the files. When i go to XXX/install.php i get a blank white screen. I did a test and put the wrong database info and get a white screen with can not connect to data base. Anyone got any clue.
The onlything i can figure is i might have a bad file and i have tried redownloading and re installing with no success. So any help would be nice. If i have to i might try to create all fields and data by hand but that takes alot of work. Please let me know if you or anyone can help.
Stitched
there is a working version on sourceforge
i'm supposed to be updating it for current POS structures... and some other tweaks, but i've been running in circles with work over the last 2-3 weeks
|
MrRx7
Amarr
Cutting Edge Incorporated
RAZOR Alliance
|
Posted - 2007.07.10 17:46:00 -
[84]
I posted an update for the new rev2 stuff, no faction however. its as simple as running a sql script.
I am however working on a several new features for the pos-tracker ( outpost tracking :D ) as well as all the faction modules. Should be done with the coding on Friday and have it uploaded and such.
|
Pakalolo
Tha Shiznit
|
Posted - 2007.07.11 00:42:00 -
[85]
hey this is great! Thank you!
|
Xiaodown
Dragons Of Redemption
Triumvirate.
|
Posted - 2007.09.29 05:27:00 -
[86]
Having just installed this for personal use, I ask: Would you like me to write an install script for use in Linux environments?
For example, with the application of 'sed', you could easily replace the lines that need to be replaced in both config.php and redirect.php; as well as imho, it's far easier to do:
mysql -u mysqluser -p postracker-db < create_database.sql
This could be automated, and with a good README file, you could make this quite a bit easier =).
~Xiao
--
Listen to BoB Radio!
I DJ sometimes!
|
CaldFighter
|
Posted - 2007.09.29 11:59:00 -
[87]
check out this for the latest version being worked on.
|
| |
|
| Pages: 1 2 3 :: [one page] |