Pages: 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 .. 14 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 1 post(s) |
Natasha Russo
Caldari
|
Posted - 2008.01.11 23:14:00 -
[151]
I get the following error any time I try to use the Fuel Calculator:
Error retrieving from pos_static in function uptimecalc;Table 'posadmin2.pos2_pos_race_specific' doesn't exist
That table was not created when I installed the beta version of the tracker. Could you clarify what needs to be done to have a functional fuel calculator?
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.12 08:34:00 -
[152]
Originally by: Crotador
hash() function wasn't introduced until after 5.1.2 This should maybe check the version and adapt the code accordingly.
Im planning to look at adding some checks to the initial install page that will hopefully tell you if you'll have issues and what can be done to correct them.
Originally by: Crotador
My CEO would like his API key to be encrypted in the DB. Is this easily possible??
Yes, you would just need to add reversible encription, probably AES, functions to addapi.php, updatepos.php, and cron_updatepos.php. The only thing this would accomplish is making it so if someone got a copy of your database but did not get a copy of your code would not have the api key. There is nothing that can be done to keep the site admin from getting the key if he/she wants to. The site admin will have access to the encryption key. Thats why I have not taken the time to add this, as I see little value.
Originally by: Natasha Russo I get the following error any time I try to use the Fuel Calculator:
Error retrieving from pos_static in function uptimecalc;Table 'posadmin2.pos2_pos_race_specific' doesn't exist
That table was not created when I installed the beta version of the tracker. Could you clarify what needs to be done to have a functional fuel calculator?
Yea, i took that table out as it had very little in it and added it to the tower_static tables. I have already corrected it in the SVN. It still has a few miner calculation bugs that I need to work out. I'm hoping to have most of bugs i know about corrected sometime this weekend and release another package, which hopefully will be the final beta package.
Random possible ideas for future versions I have been experimenting with using templates to separate display code from actual app code. This would make it easier to customize the look. About anyone who knows HTML could do this. I am looking at how easy it will be to package this. Absolute paths work best, but finding what this is can be a pain on some host. I will release an a small test pack in a week or two with some basic templates requesting feedback on ease of installation, etc. Another issue I am also looking at, which may be related to wanting to separate display code from app code is access control. The current system isn't very clear and does not work well for everyone. If anyone has any ideas/suggestions on how to fix it and how it could be implemented, please let me know.
Corporation Management Improvement |
Natasha Russo
Caldari
|
Posted - 2008.01.12 16:13:00 -
[153]
Can you advise which files I would need to replace to fix this error? I don't want to have to download and reinstall the entire thing since I have already spent significant time going through all the files correcting spelling errors and the like. I would assume there are just a couple of replacement files that need to be loaded. Thanks!
|
Crotador
Minmatar The Older Gamers R0ADKILL
|
Posted - 2008.01.13 11:20:00 -
[154]
Edited by: Crotador on 13/01/2008 11:22:24 Suggestions:
Would like to see who last updated the info on a pos.
The fuel calculater should have an option to not include strontium.
For the access levels, I think just having a decriptive word for each level would help. It would also be nice to be able to set another person to level 4 so that they can approve other users.
Templates: Have you looked at Smarty?
|
Myrdyr
|
Posted - 2008.01.13 22:55:00 -
[155]
Edited by: Myrdyr on 13/01/2008 22:55:04 i copied the latest from SVN in the 2.1 branch and it appears improved but I still am unable to update amounts in my silos... has anyone gotten the silo tracking to work ?
oh, and the problem is, i can get the reactors + silos set up but i can't update the quantities...after i type in the amounts and hit update they refresh back to zero...
|
Verybadman
|
Posted - 2008.01.14 09:37:00 -
[156]
Originally by: Myrdyr Edited by: Myrdyr on 13/01/2008 22:55:04 i copied the latest from SVN in the 2.1 branch and it appears improved but I still am unable to update amounts in my silos... has anyone gotten the silo tracking to work ?
oh, and the problem is, i can get the reactors + silos set up but i can't update the quantities...after i type in the amounts and hit update they refresh back to zero...
Yes I have noticed the same problem too. Also I have found that the HW calculations are slightly off when compared to the consumption stated in the pos management screen. This not the case on every tower tho.
|
Blue Sassley
Caldari Momentum. The Reckoning.
|
Posted - 2008.01.14 20:14:00 -
[157]
Originally by: Myrdyr Edited by: Myrdyr on 13/01/2008 22:55:04 i copied the latest from SVN in the 2.1 branch and it appears improved but I still am unable to update amounts in my silos... has anyone gotten the silo tracking to work ?
oh, and the problem is, i can get the reactors + silos set up but i can't update the quantities...after i type in the amounts and hit update they refresh back to zero...
I have looked all over where are you getting the SVN from?
Thanks,
|
Myrdyr
|
Posted - 2008.01.14 20:24:00 -
[158]
it's a sourceforge project, they all have SVN. i don't have the URL but it's off the sourceforge project page someplace here's what i used from my .bash_history though: svn co https://pos-tracker2.svn.sourceforge.net/svnroot/pos-tracker2 pos-tracker2
|
Blue Sassley
Caldari Momentum. The Reckoning.
|
Posted - 2008.01.15 00:47:00 -
[159]
I seen to get this error when I install some of the systems:
INSERT INTO `pos2_evemoons` ( `moonID` , `moonName` , `systemID` , `systemName` , `regionID` , `regionName` )VALUES ('40002090', 'Mohas II - Moon 1', '30000042', 'Moh', '10000001', 'Derelik')Database creation failed on step 2050. Please create database manually from file. Error Text: Duplicate entry '40002090' for key 1
I'm using the SVN version.
Any ideas?
Blue
|
CHAOS100
Momentum. The Reckoning.
|
Posted - 2008.01.15 02:46:00 -
[160]
Your fuel calculation is incorrect with pos modules. I have 4 small railgun batteries, and the actual liquid ozone fuel timer is 3d 18h, the calculated timer on the site is 5d 6h. These are the error codes given at the top of the site:
Quote: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sassley.com/subdomains/pos/httpdocs/viewpos.php on line 175
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/sassley.com/subdomains/pos/httpdocs/viewpos.php on line 180
Warning: Division by zero in /home/httpd/vhosts/sassley.com/subdomains/pos/httpdocs/viewpos.php on line 251
--------------
|
|
Natasha Russo
Caldari
|
Posted - 2008.01.15 09:10:00 -
[161]
Edited by: Natasha Russo on 15/01/2008 09:11:08 Ok, I updated the fuel_calculator.php file to the most recent from the SVN. The calculator functions but it does have a behavior I would like to change. Is there a way to exclude Strontium from fuel calculations? Obviously, it's only used when a tower is in reinforced so it's not something that you will need to continuously add. When I try to calculate say 7 days of fuel, it's telling me I need 50k m3 of Strontium which is not necessary. So, can a check box or something be added to exclude stront? I don't remember the previous version working this way...
|
CHAOS100
Momentum. The Reckoning.
|
Posted - 2008.01.16 01:54:00 -
[162]
I am using the SVN version and the fuel calc is bugged with mods. --------------
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.16 04:28:00 -
[163]
Originally by: Natasha Russo Can you advise which files I would need to replace to fix this error? I don't want to have to download and reinstall the entire thing since I have already spent significant time going through all the files correcting spelling errors and the like. I would assume there are just a couple of replacement files that need to be loaded. Thanks!
Any chance you could tell me what these spelling errors are so I can get them correct. Your corrected files would do, Evemail me ingame on how to get them to me.
Originally by: Crotador
Suggestions: Would like to see who last updated the info on a pos.
Biggest issue with that would be how to treat those changed via api. I may add a log viewer at some point.
Originally by: Crotador
The fuel calculator should have an option to not include strontium.
I am assuming the trouble is the hauler part. I may add a second line excluding strontium.
Originally by: Crotador
For the access levels, I think just having a descriptive word for each level would help. It would also be nice to be able to set another person to level 4 so that they can approve other users.
I am looking at doing a bit more, but I'll probably add a description to the Admin pannel on what each level does. I have been considering changing it so the admin account is added at level 5, but I'll probably start getting request for an easy way to change other accounts to 5 then. Really the only thing 4 can do that 3 can't is change users to 3.
Originally by: Crotador
Templates: Have you looked at Smarty?
Yep, thats what I'm planning on using. Problem I ran into is it likes an absolute file path to the template directories and the class directory. I am afraid too many people will strugle with this.
Originally by: Blue Sassley I seen to get this error when I install some of the systems:
INSERT INTO `pos2_evemoons` ( `moonID` , `moonName` , `systemID` , `systemName` , `regionID` , `regionName` )VALUES ('40002090', 'Mohas II - Moon 1', '30000042', 'Moh', '10000001', 'Derelik')Database creation failed on step 2050. Please create database manually from file. Error Text: Duplicate entry '40002090' for key 1
You've attempted to install the same region twice into the moon database.
Originally by: CHAOS100 Your fuel calculation is incorrect with pos modules. I have 4 small railgun batteries, and the actual liquid ozone fuel timer is 3d 18h, the calculated timer on the site is 5d 6h. These are the error codes given at the top of the site:
When I test them, they are right on. I've updated the SVN so it now displays the max heavy water and liquid ozone a tower can use. So you'll see something like 22(29) where 29 would be what is displayed in the tower information. Some things to check for: Does your alliance have sovereignty in the system? Does the tracker have the Sovereignty Correct? Does the max usage match the tower info? Do you mods pg/cpu usage match whats listed in the tracker? Are your totals for pg/cpu the same? After updating from the SVN, if your still having problems, answer those questions along with what tower type you have an the sovereignty level and I'll see if that narrows it down.
Originally by: Myrdyr Edited by: Myrdyr on 13/01/2008 22:55:04 oh, and the problem is, i can get the reactors + silos set up but i can't update the quantities...after i type in the amounts and hit update they refresh back to zero...
Download the SVN version 110 or Change Line 449 to: $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `material_ammount` = \''.my_escape($_POST['material_amount']).'\' WHERE `'.TBL_PREFIX.'silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT 1;';
Corporation Management Improvement |
Crotador
Minmatar The Older Gamers R0ADKILL
|
Posted - 2008.01.16 13:06:00 -
[164]
Originally by: Johnathan Roark
Originally by: Crotador
My CEO would like his API key to be encrypted in the DB. Is this easily possible??
Yes, you would just need to add reversible encription, probably AES, functions to addapi.php, updatepos.php, and cron_updatepos.php. The only thing this would accomplish is making it so if someone got a copy of your database but did not get a copy of your code would not have the api key. There is nothing that can be done to keep the site admin from getting the key if he/she wants to. The site admin will have access to the encryption key. Thats why I have not taken the time to add this, as I see little value.
Thanks.
It was pointed out to me the main reason for doing this would be to prevent against a SQL injection type hack. Using malformed inputs to gain access to data in the DB. This can be done without ever having access to the code.
|
Myrdyr
|
Posted - 2008.01.16 17:59:00 -
[165]
Originally by: Johnathan Roark
Originally by: Blue Sassley I seen to get this error when I install some of the systems:
INSERT INTO `pos2_evemoons` ( `moonID` , `moonName` , `systemID` , `systemName` , `regionID` , `regionName` )VALUES ('40002090', 'Mohas II - Moon 1', '30000042', 'Moh', '10000001', 'Derelik')Database creation failed on step 2050. Please create database manually from file. Error Text: Duplicate entry '40002090' for key 1
You've attempted to install the same region twice into the moon database.
Actually it appears as if your SQL exports repeat themselves. I had this problem for Domain also, somewhere in the M's.
|
Blue Sassley
Caldari Momentum. The Reckoning.
|
Posted - 2008.01.17 00:45:00 -
[166]
Edited by: Blue Sassley on 17/01/2008 00:46:25
Originally by: Myrdyr
Originally by: Johnathan Roark
Originally by: Blue Sassley I seen to get this error when I install some of the systems:
INSERT INTO `pos2_evemoons` ( `moonID` , `moonName` , `systemID` , `systemName` , `regionID` , `regionName` )VALUES ('40002090', 'Mohas II - Moon 1', '30000042', 'Moh', '10000001', 'Derelik')Database creation failed on step 2050. Please create database manually from file. Error Text: Duplicate entry '40002090' for key 1
You've attempted to install the same region twice into the moon database.
Actually it appears as if your SQL exports repeat themselves. I had this problem for Domain also, somewhere in the M's.
How do I go about fixing this?
Thanks, Blue Sassley
PS the new password.php file seems to be crap... I replaced it with the old version to get it working again.
|
Brut4l
InQuest Industries
|
Posted - 2008.01.17 16:24:00 -
[167]
Hey, it all sounds like a really cool app, but I can't really get it to work properly
I've installed it, and it runs fine on my installation, and I can register and login without any problem at all.
But I can't get any POS information? How do I add towers? When I looked around I saw that there is a table where I can put the API key, but do I have to add users manually to that table, and fill in their API keys by hand.
Really grateful for some advices ! Thnx in advance ...
|
Vellup
|
Posted - 2008.01.18 23:43:00 -
[168]
Great system, very useful for managing a large number of POS.
Can we get a new release? From the sounds of this thread there have been quite a few updates.
|
Myrdyr
|
Posted - 2008.01.20 02:05:00 -
[169]
it's not ready for a new release quite yet, IMO. needs a lot of bugfixing, and a better db dump.
there's an error in the calculations that i've narrowed down to line 34 of viewpos.php
Quote: if ($pos_race == 1 || $pos_race == 2 || $pos_race == 3 || $pos_race == 4)
it makes every tower calculate as if it were an amarr tower...not sure what was intended here.
|
Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.20 07:43:00 -
[170]
Issue with the moon table and duplicates was caused by the fact that there are a few systems that are basically a shorter version of another. Mohas and Moh in Derelik are too good examples of this. The current version of the script I use to generate the moon tables uses a wild card to pull the moons out of evenames. I'm currently working on modifying this script to fix this.
Originally by: Myrdyr Edited by: Myrdyr on 20/01/2008 02:27:56 it's not ready for a new release quite yet, IMO. needs a lot of bugfixing, and a better db dump.
there's an error in the calculations that i've narrowed down to line 34 of viewpos.php
Quote: if ($pos_race == 1 || $pos_race == 2 || $pos_race == 3 || $pos_race == 4)
it makes every tower calculate as if it were an amarr tower...not sure what was intended here.
edit: also duplicated in editpos.php, line 39
The 2.0 version did not have any distinction between fuel requirements between the 4 main races. The few fields that did matter (cpu, pg, and isotope type) where stored in a different table, race_specific. You can safely remove those lines as long as you change refrences to $pos_race1 to $pos_race. That would explain why some where having issues with heavy water and liquid ozone calculations.
Corporation Management Improvement |
|
Aiden Rhen
|
Posted - 2008.01.20 09:11:00 -
[171]
I have read through this whole post and it looks like an incredible tool that I would love to try out. Do you have any sort of documentation on how to set this up, like a users guide or something? I have not used PHP before and it would be nice to have some guidance on the setup of the tool.
|
RattleHed
Phoenix Allianz
|
Posted - 2008.01.20 12:14:00 -
[172]
Quote:
hash() function wasn't introduced until after 5.1.2 This should maybe check the version and adapt the code accordingly.
fix:
// calculate the hash from a salt and a password function getPasswordHash( $salt, $password ) { return ( crypt( 'md5', $password ) ); }
|
perry2
|
Posted - 2008.01.20 12:18:00 -
[173]
I found an error in pos-transaction.php when i try to change direction of silo in input:
Old: case 'Input': //Case to direction of the silo if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { //Update material_id in silo.info with new ammount $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `status` = \'0\' WHERE `silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT 1;'; mysql_query($sql); redirect("editsilo.php?i=" . $_REQUEST['silo_id']); } else { redirect('failure.php'); } break;
New change:
case 'Input': //Case to direction of the silo if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { //Update material_id in silo.info with new ammount $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `status` = \'0\' WHERE `'.TBL_PREFIX.'silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT $ mysql_query($sql); redirect("editsilo.php?i=" . $_REQUEST['silo_id']); } else { redirect('failure.php'); } break;
|
perry2
|
Posted - 2008.01.20 13:14:00 -
[174]
Same error for update amount of silo:
Old: case 'Update Silo': //Case to modify amount of material in silo if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { //Update materia_amount in silo.info with new ammount $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `material_ammount` = \''.my_escape($_POST['material_amount']).'\' WHERE `silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT 1;';
New:
case 'Update Silo': //Case to modify amount of material in silo if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { //Update materia_amount in silo.info with new ammount $sql = 'UPDATE `'.TBL_PREFIX.'silo_info` SET `material_ammount` = \''.my_escape($_POST['material_amount']).'\' WHERE `'.TBL_PREFIX.'silo_info`.`silo_id` = '.my_escape($_POST['silo_id']).' LIMIT 1;';
|
Maker7
Sacred Templars DeStInY.
|
Posted - 2008.01.21 18:14:00 -
[175]
Hi, very useful tool and has made dealing with our poses just that much easier. I was just wondering if there was a way to make a silo so that it could be an input and an output. For example say the output of a simple reaction and then the contents of that silo are used as one of the inputs for a complex reaction. Maybe its something ive missed but thought I would just ask. Keep up the good work :D |
Kartock Maar
Harbingers of Sarrow
|
Posted - 2008.01.22 01:38:00 -
[176]
arse error: syntax error, unexpected ':' in /****/*****/public_html/postrac/install/config.php on line 10
What is the syntax that should be used on this line ..I assume it is the redirect line. Not a PHP expert by any stretch of the imagination. Thanks. for you help Your signature exceeds the maximum allowed dimensions of 400x120 pixels -Sahwoolo |
Riu Stuka
Caldari GeoCorp. Paxton Federation
|
Posted - 2008.01.22 10:35:00 -
[177]
I can't add my API key, i always get an "error 521" as return value. I've read some ppl had the same trouble before. But the suggested changes to addapi.php looks from an older version, cause mine looks different. -----------------------------------------------
|
perry2
|
Posted - 2008.01.22 10:58:00 -
[178]
Originally by: Kartock Maar Edited by: Kartock Maar on 22/01/2008 01:50:03 arse error: syntax error, unexpected ':' in /****/*****/public_html/postrac/install/config.php on line 10
What is the syntax that should be used on this line ..I assume it is the redirect line. Not a PHP expert by any stretch of the imagination. Thanks. for you help
Figured it out.
Can u post your config.php?
|
Viktor Rasmussen
Gallente Indra-Sveijk Korps Sev3rance
|
Posted - 2008.01.22 11:11:00 -
[179]
I don't know if you're aware of this, but my Gallente large POS is counted as an amarr large one
CPU: 6575 / 5500 PG: 3140000 / 5000000
which are the values for the amarr tower. I don't know where there values comes from - I definitely choosen Gallente CT. The tower itself is located in Amarr space - maybe this is related?
|
perry2
|
Posted - 2008.01.22 11:35:00 -
[180]
In the fuel calculator dont display isotopes that tower needs. It's due at line 175 of fuel_calculator.php.
This line needs an "s" $required_isotope = $row['isotope'];
This works $required_isotope = $row['isotopes'];
|
|
|
|
|
Pages: 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 .. 14 :: one page |
First page | Previous page | Next page | Last page |