| 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
|
| |
|
| Pages: [1] 2 3 :: one page |
| First page | Previous page | Next page | Last page |