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) |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 03:52:00 -
[1]
Although we have fixed most of the bugs, I am sure people will find more. Also note, because of the increased size of the database, some may have issues installing it on some host. We look foward to see where the community takes this. We hope everyone enjoys this.
New Features: AutoSov¬ - Automatically adjusting fuel usages based on daily updated sovereignty information Moon Mining, Reaction Tracking, and Silo Tracking. Outpost Fuel Tracking - Allows you to track your pos system wide usages by defining which towers are filled from which outpost. Re-fueling calculator - You specify the time, it tells you how much fuel you need. and how many hauls it will take. Absolute Location of Towers to the moon. Faction towers and modules. Bug fixes and additions.
Requirements:
PHP 5 and MYSQL is required.
Download:
POS-Tracker 2.0.92
Installation:
Step 1. Download here and unpackage the files.
Step 2. Edit Config.php define('SQL_HOST','hostname'); #replace hostname with your database host name. This is usually localhost define('SQL_USER','username'); #Database username define('SQL_PASS','password'); # Database password define('SQL_DB','database'); # Database to use (e.g. pos_tracker) define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/'); #Path to your postracker
There are other optional settings found in config.php
Step 3. Edit header.php, mail.php, and postrackercron.sh
Step 4. Upload the tracker files.
Step 5. Browse to www.yourserver.com/postrackerpath/install.php If your server has trouble with this step, bigdump.php (you will have to edit with your database information).
Step 6. Remove install.php, install2.php create_database.sql, and bigdump.php
Step 7. Create a cronjob pointed to postrackercron.sh and have it run at least every 24 hours for the AutoSov¬, Mail Alert, and Alliance-Update. AutoSov¬ and Alliance Update will warn every 7 days if not updated.
Other Resources: [Pos Tracker] Developer Release 0.1 POS-Tracker 2.0 Beta Test
Corporation Management Improvement |

Mr Krosis
The humble Crew Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 06:52:00 -
[2]

Downloading now..
I really liked some of the features that were on the public beta site. Will be nice to take a look at it.
-- Mr Krosis The greatest obstacle to discovery is not ignorance; it is the illusion of knowledge. |

Klepto Narg
Ascent of Ages Dark Matter Coalition
|
Posted - 2007.10.13 14:11:00 -
[3]
editoutpost.php
Line 67 Was: echo "<tr><td><a href=\"showinfo:17887\">Oxygen Isotopes</a></td><td>$outpost_oxisotope</td><td><input type=\"text\" name=\"outpost_oxisotope\" ' size=10></td></tr>";
Removed errant ' to get: echo "<tr><td><a href=\"showinfo:17887\">Oxygen Isotopes</a></td><td>$outpost_oxisotope</td><td><input type=\"text\" name=\"outpost_oxisotope\" size=10></td></tr>";
config.php
Added towards middle of file:
$absolocation = 1;
igbaddpos4.php
Line 64 typo
Was: $sql = "SELECT * FROM eveNames WHERE itemName LIKE '" . my_escape($systemName) . $echo . "'";
Changed to: $sql = "SELECT * FROM `evenames` WHERE itemName LIKE '" . my_escape($systemName) . $echo . "'";
All is up and running now and working well! Thanks to everyone who has participated on this project! Cheers!
|

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.10.13 14:27:00 -
[4]
much better now  PKKP recruitment |

Kivva
|
Posted - 2007.10.13 15:46:00 -
[5]
Getting ye ole: Fatal error: Allowed memory size of xxxxxx bytes exhausted (tried to allocate 132 bytes) in
Interestingly enough addition of an allocation seems to halt the installer script. Any thoughts anyone?
(I'm not a programmer or even a half decent coder, so please be gentle :P)
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 18:43:00 -
[6]
I have added all the fixes to the package. Also, the structure_static table dump had duplicate structures. I have provided a rar file with just the pages that have changed and the sql dump just for the structures. Also, pos_structures and reactor_info did not get cleared from the database dump.
Corporation Management Improvement |

Kivva
|
Posted - 2007.10.13 18:51:00 -
[7]
Now that its up and running, I've noticed a discrepancy in calculated uptime for faction towers between viewing with the IGB and an external browser. Out of game, the uptime is incorrectly calculated to be 2 hours less than actual (in my case).
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.13 19:05:00 -
[8]
Originally by: Kivva Edited by: Kivva on 13/10/2007 19:02:01 Now that its up and running, I've noticed a discrepancy in calculated uptime for faction towers between viewing with the IGB and an external browser. Out of game, the uptime is incorrectly calculated to be 2 hours less than actual (in my case).
Also, I'm unable to assign a parent outpost to an existing tower from the IGB.
Which page? Tower size? Tower Race/faction? I'm not seeing it.
Corporation Management Improvement |

Kivva
|
Posted - 2007.10.13 19:16:00 -
[9]
Edited by: Kivva on 13/10/2007 19:20:34 I think the time bugmay be due to the scripts assuming hostile sov without the charid from the IGB, as I'm viewing with the 'admin' account. Suppose there isn't a very easy way to rectify that though, short of having a toggle for the admin account.
|

CaldFighter
|
Posted - 2007.10.13 23:06:00 -
[10]
liquid ozone in the outpost view doesn't seem to be calculating properly either.
also, slight annoyance, where it doesn't include the numbers in the outpost fields when you edit it so if you just change one field you have to add them all in otherwise it treats it as being empty.
hmmm, think you shouldn't have mentioned we might find more 
*me goes to hide*
|

Daevien Steiner
ZipZoom Kaboom Ethereal Dawn
|
Posted - 2007.10.13 23:12:00 -
[11]
Found a bug in mail.php on line 38
$email=$row['email'];
should be
$email=$row2['email'];
Without this, the mail notification will always fail as it's trying to mail to a blank variable.
|

Beccara
|
Posted - 2007.10.14 00:03:00 -
[12]
Well it seems that the silo side of things is a bit sick, there was some old reactors and silos in that DB dump i cleared out but online time of silo's seems to be disabled for some reason
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.14 00:18:00 -
[13]
Originally by: Kivva Edited by: Kivva on 13/10/2007 20:13:25 I think the time bug may be due to the scripts assuming hostile sov without the charid from the IGB, as I'm viewing with the 'admin' account. Suppose there isn't a very easy way to rectify that though, short of having a toggle for the admin account.
Only thing I can think of that would cause this is if you added the tower with the admin account. Does the tower display that the sov is hostile or friendly in one browser?
Originally by: CaldFighter liquid ozone in the outpost view doesn't seem to be calculating properly either.
also, slight annoyance, where it doesn't include the numbers in the outpost fields when you edit it so if you just change one field you have to add them all in otherwise it treats it as being empty.
hmmm, think you shouldn't have mentioned we might find more 
*me goes to hide*
Im guessing the liquid ozone isn't calculating correctly on the main track page? It should be correct on view outpost page?
Originally by: Daevien Steiner Found a bug in mail.php on line 38
$email=$row['email'];
should be
$email=$row2['email'];
Without this, the mail notification will always fail as it's trying to mail to a blank variable.
Thats actually one of the few pages we did not touch, so I am guessing you found a bug from the version this is based off of.
Corporation Management Improvement |

CaldFighter
|
Posted - 2007.10.14 01:31:00 -
[14]
Originally by: Johnathan Roark Im guessing the liquid ozone isn't calculating correctly on the main track page? It should be correct on view outpost page?
Track -> View (outpost) shows us 20 Liquid Ozone in the 'Required' column but heavy water is 500 which i'm assuming is total for pos's per hour.
Our pos's definaly use more lo than heavy water :)
Originally by: Beccara Well it seems that the silo side of things is a bit sick, there was some old reactors and silos in that DB dump i cleared out but online time of silo's seems to be disabled for some reason
Johnathan Roark posted above regarding pos stuff already in the db which wasn't cleared out but it's been fixed now.
But silo's have a quirky bug in there, seems when you add them via add structures they don't seem to be getting linked to the POS in the db and so have had to manually update the pos_id field in both silo_info and reactor_info.
once done though you can change things about as normal.
|

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.10.14 04:42:00 -
[15]
view outpost, i'm getting .... POS's Currently being Tracked: Type: Serpentis Control Tower___System: Type: Serpentis Control Tower___System:
system is blank, now I know where my POS's are, but I think thats an error
that and the giant omgwtf every moon list in addpos step 4 seem to be my main 2 bugs sofar, but my testing was piecemeal today and tonights a busy night so not sure what i'll get done PKKP recruitment |

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.10.14 04:58:00 -
[16]
anyone try the semi standard setup yet?
silo\ ----reactor->silo->silo silo/
if so, does it track them properly too?, or does it say they are both filling? PKKP recruitment |

Shime
|
Posted - 2007.10.14 05:28:00 -
[17]
Hello,
First, great job !!
just a question : in the user panel what is "Highly Trusted" ??
admin and user are set to 'no'. What happened if yes ?
|

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.10.14 05:38:00 -
[18]
Originally by: Shime Hello,
First, great job !!
just a question : in the user panel what is "Highly Trusted" ??
admin and user are set to 'no'. What happened if yes ?
hint, make POS Classified they become secret, only people with that flag can see them
i'd like an option for the admin id to set that to yes/no in the id's, but meh
PKKP recruitment |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.14 17:53:00 -
[19]
Originally by: CaldFighter
Track -> View (outpost) shows us 20 Liquid Ozone in the 'Required' column but heavy water is 500 which i'm assuming is total for pos's per hour.
Our pos's definaly use more lo than heavy water :)
I'll do some testing on that soon to see if I can figure out what is up.
Originally by: CaldFighter But silo's have a quirky bug in there, seems when you add them via add structures they don't seem to be getting linked to the POS in the db and so have had to manually update the pos_id field in both silo_info and reactor_info.
once done though you can change things about as normal.
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
Originally by: franny view outpost, i'm getting .... POS's Currently being Tracked: Type: Serpentis Control Tower___System: Type: Serpentis Control Tower___System:
system is blank, now I know where my POS's are, but I think thats an error
that and the giant omgwtf every moon list in addpos step 4 seem to be my main 2 bugs sofar, but my testing was piecemeal today and tonights a busy night so not sure what i'll get done
Are your pos being assigned to systems properly? Does it have a systemID in the pos_info table?
Originally by: franny Edited by: franny on 14/10/2007 07:57:19 Edited by: franny on 14/10/2007 07:56:29 anyone try the semi standard setup yet?
silo\ ----reactor->silo->silo silo/
if so, does it track them properly too?, or does it say they are both filling?
ok, I set up to test it with this imaginary setup, set up about 3hrs ago Moon Harvester(not listed in the display)
, it is feeding both at the same time
Will it do that ingame? I think that may be a little to complex to try and do in this tracker.
Corporation Management Improvement |

CaldFighter
|
Posted - 2007.10.14 18:43:00 -
[20]
Originally by: Johnathan Roark
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
pos_id is 0 in the db, once it's changed to the correct pos it works fine though so must be when there added.
and yep, cleared out all the structures. I'd already put in the pos's, silo's, etc before i realised so was easier to remove them, clear the db and start again so can link each structure to the right pos.
Once it's added though everything is working great and huge thanks for all the work gone into it. 
|

Beccara
|
Posted - 2007.10.15 04:21:00 -
[21]
So whats the deal with POS silo uptimes? i'm not seeing them anywhere, i dont see it on the POS view page and i can only update the silo levels from the edit page.
Would be nice to have that back.
Also for silo's when you change the connect for the silo it shows all MHA's that are in the system, it should really be limited to the MHA's on the same POS
|

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.15 06:25:00 -
[22]
well got the DB working. Looking through my ISP to see if I can get the cron stuff going. I cut up the Create SQL DB file. evenames table I cut in half. grouped up the other 4 or so a file and all went fine with my service provider.
Good work on this thing! Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

Gorfob
|
Posted - 2007.10.15 06:40:00 -
[23]
I take it you want us to use the SourceForge bug tracker and feature requests pages?
-dbp |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.15 07:32:00 -
[24]
Originally by: CaldFighter
Originally by: Johnathan Roark
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
pos_id is 0 in the db, once it's changed to the correct pos it works fine though so must be when there added.
and yep, cleared out all the structures. I'd already put in the pos's, silo's, etc before i realised so was easier to remove them, clear the db and start again so can link each structure to the right pos.
Once it's added though everything is working great and huge thanks for all the work gone into it. 
ok it's late so forgive me. How did you fix this one?
Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.15 07:58:00 -
[25]
found a discrepancy in the reactions table. Fermionic is 200 not 15 output. I'm sorry I'm very tired and will check the whole thing tomorrow hehe I edited my silo and reactor pos Ids. Hehe still very good job here! Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.15 08:12:00 -
[26]
OK going to sleep now but this one thing was bugging me hehe bugging and I have a question
silo1 --> reactor -- > silo 2
is silo 1 input or output for direction is silo 2 input or output for direction
as for the bugging thing. int he reaction table material 21 is made from 2 and 3 not 2 and 5 :) Like I said I'll go through them tomorrow to see what I found. But now I can sleep Thanks again guys
Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2007.10.15 08:22:00 -
[27]
Originally by: Johnathan Roark
Edited by: franny on 14/10/2007 07:56:29 anyone try the semi standard setup yet?
silo\ ----reactor->silo->silo silo/
if so, does it track them properly too?, or does it say they are both filling?
ok, I set up to test it with this imaginary setup, set up about 3hrs ago Moon Harvester(not listed in the display)
, it is feeding both at the same time
Will it do that ingame? I think that may be a little to complex to try and do in this tracker.
works ingame, I have 2 POS's set that way, adv reaction otherwise I am emptying it every 3days or so PKKP recruitment |

CaldFighter
|
Posted - 2007.10.15 15:49:00 -
[28]
Originally by: Salia Deluri OK going to sleep now but this one thing was bugging me hehe bugging and I have a question
silo1 --> reactor -- > silo 2
is silo 1 input or output for direction is silo 2 input or output for direction
input/output relates to the reactor/harvester direction, so silo 1 would be:
silo1 (Input) --> reactor -- > silo 2 (Output)
if you update the silo amount with 0 after it's done it should then show the currect uptime 
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.15 16:20:00 -
[29]
Originally by: CaldFighter
Originally by: Johnathan Roark
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
pos_id is 0 in the db, once it's changed to the correct pos it works fine though so must be when there added.
and yep, cleared out all the structures. I'd already put in the pos's, silo's, etc before i realised so was easier to remove them, clear the db and start again so can link each structure to the right pos.
Once it's added though everything is working great and huge thanks for all the work gone into it. 
In pos-transaction.php, after line 328 add the following line: (integer) $pos_id=$_POST['pos_id'];
This is probably what is causing most of the Silo problems. Some php installs are more picky about correct syntax then others, which is a good thing.
Originally by: Salia Deluri OK going to sleep now but this one thing was bugging me hehe bugging and I have a question
silo1 --> reactor -- > silo 2
is silo 1 input or output for direction is silo 2 input or output for direction
Silo 1 would be an input, Silo 2 would be an output
Originally by: Salia Deluri
as for the bugging thing. int he reaction table material 21 is made from 2 and 3 not 2 and 5 :) Like I said I'll go through them tomorrow to see what I found. But now I can sleep Thanks again guys
Thanks, those tables where not fun to make and I'm not surprised by any errors in them. Just get me the entry number (first collum in the table) and I'll try to correct them.
Originally by: franny
works ingame, I have 2 POS's set that way, adv reaction otherwise I am emptying it every 3days or so
That wont be an easy fix.
Originally by: Gorfob I take it you want us to use the SourceForge bug tracker and feature requests pages?
Just post them in this thread for now.
Corporation Management Improvement |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.15 23:48:00 -
[30]
Originally by: Johnathan Roark
Originally by: CaldFighter
Originally by: Johnathan Roark
Its adding the silos and reactors but not addding the pos_id? what value is giving the pos_id? Have you cleared out those duplicates in the structure_static table?
pos_id is 0 in the db, once it's changed to the correct pos it works fine though so must be when there added.
and yep, cleared out all the structures. I'd already put in the pos's, silo's, etc before i realised so was easier to remove them, clear the db and start again so can link each structure to the right pos.
Once it's added though everything is working great and huge thanks for all the work gone into it. 
In pos-transaction.php, after line 328 add the following line: (integer) $pos_id=$_POST['pos_id'];
This is probably what is causing most of the Silo problems. Some php installs are more picky about correct syntax then others, which is a good thing.
Originally by: Salia Deluri OK going to sleep now but this one thing was bugging me hehe bugging and I have a question
silo1 --> reactor -- > silo 2
is silo 1 input or output for direction is silo 2 input or output for direction
Silo 1 would be an input, Silo 2 would be an output
Originally by: Salia Deluri
as for the bugging thing. int he reaction table material 21 is made from 2 and 3 not 2 and 5 :) Like I said I'll go through them tomorrow to see what I found. But now I can sleep Thanks again guys
Thanks, those tables where not fun to make and I'm not surprised by any errors in them. Just get me the entry number (first collum in the table) and I'll try to correct them.
Originally by: franny
works ingame, I have 2 POS's set that way, adv reaction otherwise I am emptying it every 3days or so
That wont be an easy fix.
Originally by: Gorfob I take it you want us to use the SourceForge bug tracker and feature requests pages?
Just post them in this thread for now.
line 328 or line 358? what's above and below please. Thanks, -Deluri
Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.16 05:05:00 -
[31]
Originally by: Salia Deluri
line 328 or line 358? what's above and below please. Thanks, -Deluri
328, these are the previous 5 lines:
case 'Done': if ($_SESSION['access'] >= "2" || $_POST['owner_id']==$_SESSION['id']) { for ($n = 1; $n <= $_POST['amount']; $n=$n+1) { $s_id = $_POST['s_id' . $n];
Corporation Management Improvement |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.16 08:06:00 -
[32]
Got it. Works well thanks DB tables will have to wait another day.
-Deluri
Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

darkst0rm
Insidious Existence Interstellar Alcohol Conglomerate
|
Posted - 2007.10.17 05:51:00 -
[33]
the email feature seems broken.
[root@venus pos2]# ./postrackercron.sh PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 sendmail: fatal: No recipient addresses found in message header PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 Message delivery failed...
|

CaldFighter
|
Posted - 2007.10.17 15:48:00 -
[34]
i think i found a huge flaw with the auto-sov...
If you have constellation sov 4, the capital system gets a pos 'bonus' to fuel but the surrounding systems don't BUT they register as having sov 5 so the tracker thinks it's getting the bonus.
Not sure if it's easy to address or not?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.17 17:48:00 -
[35]
Originally by: darkst0rm the email feature seems broken.
[root@venus pos2]# ./postrackercron.sh PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 sendmail: fatal: No recipient addresses found in message header PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 PHP Notice: Undefined variable: _SESSION in /var/www/virtuals/postracker/html/pos2/functions.php on line 652 PHP Notice: Undefined index: reinforced in /var/www/virtuals/postracker/html/pos2/mail.php on line 35 PHP Notice: Undefined index: email in /var/www/virtuals/postracker/html/pos2/mail.php on line 38 Message delivery failed...
I'll have to look into it, this is not something we actually touched, so it may take a while.
Originally by: CaldFighter i think i found a huge flaw with the auto-sov...
If you have constellation sov 4, the capital system gets a pos 'bonus' to fuel but the surrounding systems don't BUT they register as having sov 5 so the tracker thinks it's getting the bonus.
Not sure if it's easy to address or not?
Its not hard to change at all. functions.php, line 622 change from: if($row['constellationSovereignty'] > 0) { to: if($row['constellationSovereignty'] > 0 && $row['sovereigntyLevel'] >= 4) {
That will fix it, but i thought that all systems in the constellation should get the bonus? At least thats how I read it in the dev blog. My only POS in a constellation sov system is in the capital.
Corporation Management Improvement |

Shime
|
Posted - 2007.10.17 17:55:00 -
[36]
There is an error with fuel usage (only on small minmattar and domination minmatar). When we ve a constellation sov, the calc is wrong
If i do same with large tower, there is no problems.
Any idea where is the problems?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.17 18:44:00 -
[37]
Edited by: Johnathan Roark on 17/10/2007 18:44:45
Originally by: Shime There is an error with fuel usage (only on small minmattar and domination minmatar). When we ve a constellation sov, the calc is wrong
If i do same with large tower, there is no problems.
Any idea where is the problems?
So your saying the other races are fine or you have not tested them? Also, is this in the capital?
Corporation Management Improvement |

Shime
|
Posted - 2007.10.17 19:12:00 -
[38]
Don"t test with other races. But test with large domination and large minmatarr and result are ok.
This is a constellation sov, not a capital. 0.7 should be the bonus i thinks.
The requirement are ok, but not the available fuel. (little error (since 1 day ive got an error of 16 mechanical for example)) if i saw, i thinks that rounded up should be up and not down. but not sure thats the problems....
|

Henry Loenwind
|
Posted - 2007.10.17 22:47:00 -
[39]
in editpos.php, this:
echo "<tr><td>Silo ".$i."</td><td>".$row['material_ammount']."</td><td><input type=\"text\" name=\"material_ amount\" value\"".$row['material_ammount']."\" size=\"10\"></td><td>".$row2['material_name']."</td><td><input type=\"submit\" name= \"action\" value=\"Edit Silo\"><input type=\"submit\" name=\"action\" value=\"Update Silo\"></td><tr></form>\n";^M
should be this:
echo "<tr><td>Silo ".$i."</td><td>".$row['material_ammount']."</td><td><input type=\"text\" name=\"material_ amount\" value=\"".$row['material_ammount']."\" size=\"10\"></td><td>".$row2['material_name']."</td><td><input type=\"submit\" name= \"action\" value=\"Edit Silo\"><input type=\"submit\" name=\"action\" value=\"Update Silo\"></td><tr></form>\n";^M
( '=' is missing between 'value' and '\""' )
|

darkst0rm
Insidious Existence Interstellar Alcohol Conglomerate
|
Posted - 2007.10.18 00:37:00 -
[40]
Edited by: darkst0rm on 18/10/2007 00:37:48 the button to update the npc hanger seemed to be missing also.
line 387 editpos.php echo "</table><p><input type=\"submit\" name=\"action\" value=\"Update Hanger\"></form>";
|

Arsen Barghouss
|
Posted - 2007.10.18 16:15:00 -
[41]
Hi, The pos trackers calculation of oxygen need for small caladri tower is not correct with sov1. tracker calculates 2500 oxy for 21 days. correct value should be 3024.
|

Shime
|
Posted - 2007.10.21 06:55:00 -
[42]
Edited by: Shime on 21/10/2007 06:56:30 A friend find that : UPDATE `sovereignty_constellation_static` SET `mechanical_parts` = 2, `coolant` = 2 WHERE `pos_size` = 1
If doing that, sound like ok.
Execpt don"t create another bug.
|

Juan Pollo
Merchants Trade Consortium
|
Posted - 2007.10.22 08:09:00 -
[43]
Wanted to give a thank you bump. You've made life a whole lot easier, and made me not hate POSes as much as I'd started to.
I do have one feature request though. Any chance for a button to say 'refuel all' or something? The idea being that you could drop in the recommended amount of fuel to max the run time, hit that button, and it'd just fill in the blanks.
Thanks again!
|

Barwinius
Ars ex Discordia
|
Posted - 2007.10.22 23:21:00 -
[44]
Is PHP5 a hard requirement? |

Juan Pollo
Merchants Trade Consortium
|
Posted - 2007.10.23 00:41:00 -
[45]
Originally by: Barwinius Is PHP5 a hard requirement?
As near as I can tell... kinda yes. It seems that there are some things in the SOV and Alliance update scripts that don't much care for PHP4. On the other hand, as long as you don't mind it bugging you constantly to update those two, it seems to work well otherwise. That's just my personal experience.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.23 05:39:00 -
[46]
Originally by: Juan Pollo
Originally by: Barwinius Is PHP5 a hard requirement?
As near as I can tell... kinda yes. It seems that there are some things in the SOV and Alliance update scripts that don't much care for PHP4. On the other hand, as long as you don't mind it bugging you constantly to update those two, it seems to work well otherwise. That's just my personal experience.
yes, the update scripts are currently coded for php 5 only. PHP 5 has a lot better xml support then PHP 4. If someone wants to do it, as in someone other than me, it would not take much to port them to php 4. I will test them and then include them, but they will not be supported by me and there use will be discouraged. Another thing to keep in mind that php 4 has reached its end of life.Php.net So it really is in your best interest to migrate to php 5 if possible. One of my host this is as simple as using a custom .htaccess file in folders that I want to use php 5.
Text from the announcement can be found here:
Originally by: php.net The PHP development team hereby announces that support for PHP 4 will continue until the end of this year only. After 2007-12-31 there will be no more releases of PHP 4.4. We will continue to make critical security fixes available on a case-by-case basis until 2008-08-08. Please use the rest of this year to make your application suitable to run on PHP 5.
Corporation Management Improvement |

Beccara
|
Posted - 2007.10.23 11:12:00 -
[47]
So yeah the fuel amounts seem to be really out of whack, sov is showing as sov 2 and the o2 rate is 5/hr which should be 6/hr, looks like a rounding issue maybe?
|

Revanom
|
Posted - 2007.10.24 01:19:00 -
[48]
When i try to run install.php after the edits i get this:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 134 bytes) in /home/XXXXXXXX/public_html/igb/postracker/install.php on line 8
HELP!
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.24 05:10:00 -
[49]
Originally by: Revanom When i try to run install.php after the edits i get this:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 134 bytes) in /home/XXXXXXXX/public_html/igb/postracker/install.php on line 8
HELP!
This is exactly the reason i've included bigdump.php in the package. I said in the first post that if you have any problems with install.php, use bigdump.php instead.
Corporation Management Improvement |

Salia Deluri
Cirrius Technologies O X I D E
|
Posted - 2007.10.24 16:21:00 -
[50]
Anyone else having problems with the silo contents not updating?
I finished the changes in the tables. Just need to convert from Salia scratch to somethign you can read. Also I broke up the database install scripts so that when dealing with a stupid.. er um underpowered provider your updates won;t time out ;P
need some place to post all this stuff.
Otherwise it's workign great for me. Now I'm trying to see about what will be needed for an entire alliance to use this.
-Deluri
Code of Deluri Grant me the serenity to accept the things I cannot change, the courage to change the things I cannot accept, and the wisdom to hide the bodies of those people I had to kill today. |

Nisune
Skynet Evolution Systems Ldt.
|
Posted - 2007.10.24 19:34:00 -
[51]
I just installed the POS Tracker on my Webspace and looks like everything is working as intended!
Great work, its extremely helpfull. \o/
Only Problem i've encountered is the reaction-setup with INPUT and OUTPUT Silo's. ( ... Med-Reactor -> Silo -> Reactor -> ... )
To be honest, i didnt read the everything in this thread (and its predecessors), so maybe this has been mentioned before.
Thanks again for this great work, making the work of POS-Admin's much easier. ;)
|

Ares Splinter
Dark Centuri Inc. Firmus Ixion
|
Posted - 2007.10.26 18:01:00 -
[52]
Edited by: Ares Splinter on 26/10/2007 18:02:13 http://xxxxxxxxx/xxxxxxxxxx/user-transaction.php
Error 404 when i try to reg..
So i try to login and it redirects me to an old postrack directory..
http://xxxxxxxxxx/pos/failure.php
directory doesnt exist, and neither does its database...
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.10.26 18:09:00 -
[53]
Originally by: Ares Splinter Edited by: Ares Splinter on 26/10/2007 18:02:13 http://xxxxxxxxx/xxxxxxxxxx/user-transaction.php
Error 404 when i try to reg..
So i try to login and it redirects me to an old postrack directory..
http://xxxxxxxxxx/pos/failure.php
directory doesnt exist, and neither does its database...
you forgot to edit line 9 in config.php define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/');
Corporation Management Improvement |

Ares Splinter
Dark Centuri Inc. Firmus Ixion
|
Posted - 2007.10.26 19:37:00 -
[54]
ohh duh, thanks :)
|

MrRx7
Amarr Cutting Edge Incorporated RAZOR Alliance
|
Posted - 2007.10.28 05:41:00 -
[55]
Nice new sig btw JR,
Hello everyone, Its been a while since I have posted. For the next week I am completely swamped at work, we are moving our datacenter :), but after that is finshed I am going to sit down with JR and see about working out all of the remaining issues as well as write a wiki install help page.
If you know of a documented error please tell me below and I will check into it next monday.
|

blueska
|
Posted - 2007.11.03 04:59:00 -
[56]
Edited by: blueska on 03/11/2007 04:58:52 Hi,
I am hosted on godaddy, and getting an error on updatesov or update alliances
Fatal error: Cannot instantiate non-existent class: simplexmlelement in /pos/updatesov.php on line 22
My server has both PHP 4 and 5 installed, I think it is trying to run it with php4. Any tips on how to make it use PHP 5 instead so I don't get these errors?
Thanks
|

Rafe Poseidon
Caldari Poseidon Industries
|
Posted - 2007.11.03 11:53:00 -
[57]
Edited by: Rafe Poseidon on 03/11/2007 11:53:47 Edited by: Rafe Poseidon on 03/11/2007 11:53:09
Originally by: blueska Edited by: blueska on 03/11/2007 04:58:52 Hi,
I am hosted on godaddy, and getting an error on updatesov or update alliances
Fatal error: Cannot instantiate non-existent class: simplexmlelement in /pos/updatesov.php on line 22
My server has both PHP 4 and 5 installed, I think it is trying to run it with php4. Any tips on how to make it use PHP 5 instead so I don't get these errors?
Thanks
Try looking at this link for inof on how to setup php5 support on your godaddy account.
http://help.godaddy.com/article.php?article_id=1083&topic_id=&isc=touchdown8
Hope this helps
|

blueska
|
Posted - 2007.11.03 15:10:00 -
[58]
Originally by: Rafe Poseidon Edited by: Rafe Poseidon on 03/11/2007 11:53:47 Edited by: Rafe Poseidon on 03/11/2007 11:53:09
Originally by: blueska Edited by: blueska on 03/11/2007 04:58:52 Hi,
I am hosted on godaddy, and getting an error on updatesov or update alliances
Fatal error: Cannot instantiate non-existent class: simplexmlelement in /pos/updatesov.php on line 22
My server has both PHP 4 and 5 installed, I think it is trying to run it with php4. Any tips on how to make it use PHP 5 instead so I don't get these errors?
Thanks
Try looking at this link for inof on how to setup php5 support on your godaddy account.
http://help.godaddy.com/article.php?article_id=1083&topic_id=&isc=touchdown8
Hope this helps
Thanks! find and replace all from php to php5 fixed it.
|

Jehovah Cooper
Convergent Firmus Ixion
|
Posted - 2007.11.03 15:16:00 -
[59]
Hey we just upgraded from an early beta, love the new features, great tool.
One feature request:
Have you ever considered making it optional to just enter the cpu/grid directly rather than all the structures? In some cases the mods are helpful but other times (like standard deathstar fittings) I just want it to calculate LO & HW right and I don't care to enter all my guns into it.
Thanks!
|

Jehovah Cooper
Convergent Firmus Ixion
|
Posted - 2007.11.03 17:30:00 -
[60]
This was easy to fix but didn't see it noted here already. The correct production value of Phenolic Composites Reaction is 2200, your table has 1800.
|

Mestoth
Minmatar Ars ex Discordia GoonSwarm
|
Posted - 2007.11.09 09:55:00 -
[61]
"Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
1stly: im a nublet with PHP and MYSQL. Im still not sure if i have this set up correctly :P secondly: i got the same "ran out of room error" so went onto the bigdump.php hence the above message. Im a bit confused and generally looking lost :P
oh, any chance you can create a nice "idiot proof" guide :) Installing PHP and MYSQL is easy, and doing the simple config stuff wasnt a prob. but im WAY outa my league right now :P
|

Vincent Liftor
|
Posted - 2007.11.09 19:31:00 -
[62]
I used the bigdump.php file to load the sql information but when I go to the install.php file to create the admin account, I am still getting the error: Fatal error: Out of memory (allocated 74186752) (tried to allocate 134 bytes)
Can you provide some guidance for how to get around this?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.09 20:17:00 -
[63]
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
1stly: im a nublet with PHP and MYSQL. Im still not sure if i have this set up correctly :P secondly: i got the same "ran out of room error" so went onto the bigdump.php hence the above message. Im a bit confused and generally looking lost :P
oh, any chance you can create a nice "idiot proof" guide :) Installing PHP and MYSQL is easy, and doing the simple config stuff wasnt a prob. but im WAY outa my league right now :P
My guess is your running into a actual size issue with your host? I'd check with your host about size restrictions on your database.
There is no way i can make an idiot proof guide. Each host is different and someone will find some way to mess it up. The install scripts are the closest we can come to that.
Originally by: Vincent Liftor I used the bigdump.php file to load the sql information but when I go to the install.php file to create the admin account, I am still getting the error: Fatal error: Out of memory (allocated 74186752) (tried to allocate 134 bytes)
Can you provide some guidance for how to get around this?
your running the wrong install file, if you run bigdump.php, you need to run install2.php (notice the '2' in the name) which should be linked from bigdump.php.
Corporation Management Improvement |

Vincent Liftor
|
Posted - 2007.11.09 20:33:00 -
[64]
There's the problem. Line 707 of bigdump.php links to install.php instead of install2.php. Thanks for the quick reply.
|

Vincent Liftor
|
Posted - 2007.11.10 08:01:00 -
[65]
Another quick question, once a tower has been added to the tracker, how can you add a tower name if none was entered at creation? There doesn't seem to be an edit field for the tower name or really any other way to change this information currently.
Thanks!
|

Lillis85
Gallente Dark Matter Coalition
|
Posted - 2007.11.10 14:33:00 -
[66]
I'm having troubles importing the database using bigdump.
Quote: Error at the line 2001: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
Query: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
MySQL: 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 'SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) V' at line 1
After trying to decrease the ammount of lines importing per cycle I get the same error but on another line. The error seems to appear on the second cycle every time, no matter how many lines I choose to import per cycle. I'm running everything on my local computer. What could be the cause of this?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.10 16:20:00 -
[67]
Originally by: Vincent Liftor Another quick question, once a tower has been added to the tracker, how can you add a tower name if none was entered at creation? There doesn't seem to be an edit field for the tower name or really any other way to change this information currently.
Thanks!
Only current way is to manually edit it in the database.
Originally by: Lillis85 I'm having troubles importing the database using bigdump.
Quote: Error at the line 2001: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
Query: SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) VALUES (40001884, 'Psasa III - Moon 15', 2, 8, 14);
MySQL: 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 'SERT INTO `evenames` (`itemID`, `itemName`, `categoryID`, `groupID`, `typeID`) V' at line 1
After trying to decrease the ammount of lines importing per cycle I get the same error but on another line. The error seems to appear on the second cycle every time, no matter how many lines I choose to import per cycle. I'm running everything on my local computer. What could be the cause of this?
Honestly, I have no clue.
Corporation Management Improvement |

Shime
|
Posted - 2007.11.11 18:17:00 -
[68]
Hello,
Another question ; how work the "secret pos" system ??
Under sql i write 1 to secret pos, but the owner don"t see his own pos after ?? I do not want that all members can see all the pos position and status with the pos tracker.
|

Lillis85
Gallente Dark Matter Coalition
|
Posted - 2007.11.11 21:16:00 -
[69]
I'm able to import the database with bigdump if I'm importing 2 lines per cycle. If I go to 5 it stops after the first cycle. This is really annoying. Anyone else having this problem?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.11 23:04:00 -
[70]
Originally by: Shime Hello,
Another question ; how work the "secret pos" system ??
Under sql i write 1 to secret pos, but the owner don"t see his own pos after ?? I do not want that all members can see all the pos position and status with the pos tracker.
the secret POS is related to highly trusted flag in the user table. This is an incomplete feature but It think is the only things that are missing is the toggle for highly trusted and secret pos.
Corporation Management Improvement |

Wipster
Righteous-Indignation FREGE Alliance
|
Posted - 2007.11.13 21:25:00 -
[71]
Hey, There seem to be alot of bug fixes in this thread and looking at the sourceforge release its a month old and the svn hasn't been touched in about the same, where abouts can I get my hands on an up to date copy or when would a new release be scheduled? Great tool btw, I used an old version for a while, looking forward to the new functionality.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.14 06:57:00 -
[72]
Originally by: Wipster Hey, There seem to be alot of bug fixes in this thread and looking at the sourceforge release its a month old and the svn hasn't been touched in about the same, where abouts can I get my hands on an up to date copy or when would a new release be scheduled? Great tool btw, I used an old version for a while, looking forward to the new functionality.
There really hasn't been many fixes since the last version. I think the SVN has a few more fixes. The only other bugs are small ones in the database, the code should be current as of reversion 95.
I have been considering changing the way it handles passwords. Currently it uses a method that is vulnerable to a rainbow attack, which is no big deal as long as no one gets a copy of your database. I would attempt to make it so you can stay with the current method if I did make this change. Upgrading would mean deleting all the users and asking everyone to re-register.
Corporation Management Improvement |

Xawen
|
Posted - 2007.11.14 14:39:00 -
[73]
Can someone post a simple howto for getting reactions set up on the page? I can't seem to get one to start calculating and show up on the POS View page.
Right now I'm just trying a simple reaction: silo 0 (cadmium) | Reactor --- silo 2 (Caesarium Cadmide) | silo 1 (caesium)
First I set the reactor material to caesarium cadmide. Then I set silo 0 and 1 to the right material, then set them to input and assigned them to the reactor marked caesarium cadmide. Then, I set silo 2 to caesarium cadmide, output and assigned to the reactor. I gave silos 0 and 1 15000 units of material and assumed it would start computing the reaction, but nothing happened. I'm sure I'm missing something simple, but I can't figure out what.
Anyone know what I screwed up?
|

Elfishy
Gallente
|
Posted - 2007.11.17 17:58:00 -
[74]
when trying to update sov:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updatesov.php on line 14
or when trying to update alliance list:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updateallianceinfo.php on line 14
|

CaldFighter
|
Posted - 2007.11.17 20:44:00 -
[75]
anyone notice Liquid Ozone and Heavy water don't seem to calculate properly in outpost view?
Liquid Ozone says 55 but should be closer to 600 Heavy Water says 800 but should be closer to 450
Apart from that, we've had no problems.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.18 06:37:00 -
[76]
Originally by: Xawen Can someone post a simple howto for getting reactions set up on the page? I can't seem to get one to start calculating and show up on the POS View page.
Right now I'm just trying a simple reaction: silo 0 (cadmium) | Reactor --- silo 2 (Caesarium Cadmide) | silo 1 (caesium)
First I set the reactor material to caesarium cadmide. Then I set silo 0 and 1 to the right material, then set them to input and assigned them to the reactor marked caesarium cadmide. Then, I set silo 2 to caesarium cadmide, output and assigned to the reactor. I gave silos 0 and 1 15000 units of material and assumed it would start computing the reaction, but nothing happened. I'm sure I'm missing something simple, but I can't figure out what.
Anyone know what I screwed up?
Try updating the materail in silo 2. Also make sure silo 0 and 1 are set to input. Other than that, I can't tell much without seeing it.
Originally by: Elfishy when trying to update sov:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updatesov.php on line 14
or when trying to update alliance list:
Fatal error: Call to undefined function curl_init() in /var/www/possy/updateallianceinfo.php on line 14
My guess is your host has CURL disabled. That would mean you have 3 options: get them to enable it, switch host, bribe me/someone to convert it to fopen.
Try running the following code on your host: <?php
$curl_version=curl_version(); echo "Your CURL Version: ".$curl_version['version']."<br>";
?>
Originally by: CaldFighter anyone notice Liquid Ozone and Heavy water don't seem to calculate properly in outpost view?
Liquid Ozone says 55 but should be closer to 600 Heavy Water says 800 but should be closer to 450
Apart from that, we've had no problems.
Yea, thats one of the bugs that would be easier for Rx to look at as he wrote that part.
Corporation Management Improvement |

Elfishy
Gallente
|
Posted - 2007.11.18 12:42:00 -
[77]
Quote: My guess is your host has CURL disabled. That would mean you have 3 options: get them to enable it, switch host, bribe me/someone to convert it to fopen.
your were right.. it wasn't installed, but its running on my own server so easy fix and now it works ... thx :)
|

Shime
|
Posted - 2007.11.24 01:39:00 -
[78]
Another error in database with true sansha medium tower
When u have the sov 1, we can see 5 oxygen,2 mechanical,35 hvy water,39 Liquid / hour.
Or in reality : 6,3,42,42
I found the error in sovereignty_static database, but don"t find where i can change the hvy water and LO. (cause in this database there are ok)
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 06:14:00 -
[79]
Edited by: Johnathan Roark on 24/11/2007 06:17:27
Originally by: Shime Another error in database with true sansha medium tower
When u have the sov 1, we can see 5 oxygen,2 mechanical,35 hvy water,39 Liquid / hour.
Or in reality : 6,3,42,42
I found the error in sovereignty_static database, but don"t find where i can change the hvy water and LO. (cause in this database there are ok)
I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Corporation Management Improvement |

Wipster
Righteous-Indignation FREGE Alliance
|
Posted - 2007.11.24 12:57:00 -
[80]
Hey, I'm just setting up the tracker and I'm a bit stuck, we have a reactor going into a silo and then another reactor taking from that silo (because we produce more then we can second reaction) is there a way to let a silo be an input aswell as an output?
Wip
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.24 18:52:00 -
[81]
Originally by: Wipster Hey, I'm just setting up the tracker and I'm a bit stuck, we have a reactor going into a silo and then another reactor taking from that silo (because we produce more then we can second reaction) is there a way to let a silo be an input aswell as an output?
Wip
No, sorry, the silo tracking is a simple solution and can't cover all the possibilities, just most of the more common setups.
With some miner modifications, you probably could trick it into giving the data you want.
Corporation Management Improvement |

Shime
|
Posted - 2007.11.29 03:02:00 -
[82]
Originally by: Johnathan Roark Edited by: Johnathan Roark on 24/11/2007 I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Can"t be that, i saw the problem because ive got somes differences enter the fuel into the tower and on the pos manager.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.29 07:02:00 -
[83]
Originally by: Shime
Originally by: Johnathan Roark Edited by: Johnathan Roark on 24/11/2007 I think your seeing a bug in EVE, not POS-Tracker. EVE starbase control pannel displays the max Liquid ozone and heavy water used per hour. POS-tracker calculates actual use based on the structures you tell it that you have online.
Can"t be that, i saw the problem because ive got somes differences enter the fuel into the tower and on the pos manager.
Yea, your right. I am guessing a rounding error. Others may have the same issue.
This should fix that one: UPDATE `sovereignty_static` SET `oxygen` = '6', `mechanical_parts` = '3' WHERE `sovereignty_static`.`pos_race` =14 AND `sovereignty_static`.`pos_size` =2 AND `sovereignty_static`.`isotope` =127 AND `sovereignty_static`.`oxygen` =5 AND `sovereignty_static`.`mechanical_parts` =2 AND `sovereignty_static`.`coolant` =3 AND `sovereignty_static`.`robotics` =1 AND `sovereignty_static`.`uranium` =2 AND `sovereignty_static`.`ozone` =42 AND `sovereignty_static`.`heavy_water` =42 AND `sovereignty_static`.`strontium` =56 AND `sovereignty_static`.`capacity` =55000 AND `sovereignty_static`.`strontium_hanger` =25000 LIMIT 1 ;
Corporation Management Improvement |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 19:24:00 -
[84]
POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Corporation Management Improvement |

Shime
|
Posted - 2007.11.30 20:40:00 -
[85]
perfectly work ! thks a lot.
In future addon-patch, can u create some a buttons, to order track.php by what we want. That will help when we have many tower.
Because, by default, this is order by Tower Name. Thinks that will be more easy by owner or system name.
Great job anyways 
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.11.30 20:50:00 -
[86]
Originally by: Shime perfectly work ! thks a lot.
In future addon-patch, can u create some a buttons, to order track.php by what we want. That will help when we have many tower.
Because, by default, this is order by Tower Name. Thinks that will be more easy by owner or system name.
Great job anyways 
yea, that shouldn't be too hard to do. I'll probably change the default to system Name anyway. The Tower name is a relic from when it wasn't associated with a specific system.
Corporation Management Improvement |

CaldFighter
|
Posted - 2007.12.01 11:42:00 -
[87]
Can't think of much off the top of my head besides whats been mentioned previously. (Liquid Ozone/Heavy Water Calc in outpost).
Although i think classified pos's should be removed for users not classed as trusted in the pos's tracked list in outpost.
i'm sure i'll think of something else but it's early.
|

Braineater
Minmatar BINFORD Solidus Alliance
|
Posted - 2007.12.03 12:23:00 -
[88]
When adding silos/harvesters/reactors to a POS, both at creation and later on via edit, the corresponding row in silo_info/reactor_info always has it's pos_id set to 0. Is this a bug, or am I doing something wrong? ______
|

Ecid Q'Wulf
Caldari Galactic Fighter Syndicate Knights Of the Southerncross
|
Posted - 2007.12.04 05:00:00 -
[89]
I like your tool, great job done sofar. What could be usefull for alliances, or a bunch of corps working together is multicorp-usability. where for example only Corp A sees all details of Corp B but A sees that B has at planet x moon y pos z.
Also some sort of moon database might be nice, where everyone who has access to it, is able to post new scans in it, and every user of teh tool is able to see em, probably even gets em as automatical choice when trying to set resources for the harvester.
________
A great man once said: "Rabble-Rabble" and "check my Corp-Ticker". Ive you come a across him, make sure to join his ranks (if your not german) |

Tiger Wolf
|
Posted - 2007.12.07 05:25:00 -
[90]
I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks, TW
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.07 07:32:00 -
[91]
Originally by: Tiger Wolf I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks, TW
Yes, its missing, I know I've added it back several times. I'll edit this post tomorrow with whats missing, time for bed now.
Corporation Management Improvement |

Priory
|
Posted - 2007.12.07 12:14:00 -
[92]
Edited by: Priory on 07/12/2007 12:14:49 $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); mysql_select_db(SQL_DB, $conn) or die('Could not select database; ' . mysql_error());
Those are lines 11-15 from an unchanged config.php Every time I try to install it, I get "Parse error: syntax error, unexpected T_STRING in /home/tplacom/public_html/station/config.php on line 12"
Also tried running install2.php and I get a 'Access to database: denied" I know my passwords and all that jazz are correct though.
/me is a noob at this kinda stuff 
|

Metalstein
Beasts of Burden YouWhat
|
Posted - 2007.12.08 01:21:00 -
[93]
Edited by: Metalstein on 08/12/2007 01:22:23 Notice: Undefined variable: count in E:\EasyPHP 2.0b1\www\pos\updatesov.php on line 30 2007-12-08 02:18:31 Success Systems Updated: 5382
Getting this on Updating Sov, and the update doesn't seem to be saved. Updating Alliances works fine though. ----- My posts represent my views and not those of my corporation or alliance. Unless those views are facts. Then they're facts. :) |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.08 06:33:00 -
[94]
Originally by: Tiger Wolf I just downloaded the current version and got it installed today. I got the pos put in the thing but for some reason the information that I put in the corp hanger array for fuel doesnt save. The only button I see to save it is the update fuel button above the hanger array area. I dont know if there is a button missing or something or what, but thought I would say something, maybe someone has a fix for me...
Thanks, TW
Lines 385-387 should look like this in editpos.php
echo "<tr><td><a href=\"showinfo:16275\">Strontium Calthrates</a></td><td>" . $row['strontium'] . "</td><td><input type=\"text\" name=\"hanger_strontium\" value=\"" . $row['strontium'] . "\" size=10></td><td>-</td></tr>"; echo "</table><p><input type=\"submit\" name=\"action\" value=\"Update Hanger\"></form>"; echo"</table></form><br>";
Originally by: Priory Edited by: Priory on 07/12/2007 12:14:49 $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); mysql_select_db(SQL_DB, $conn) or die('Could not select database; ' . mysql_error());
Those are lines 11-15 from an unchanged config.php Every time I try to install it, I get "Parse error: syntax error, unexpected T_STRING in /home/tplacom/public_html/station/config.php on line 12"
Also tried running install2.php and I get a 'Access to database: denied" I know my passwords and all that jazz are correct though.
/me is a noob at this kinda stuff 
Check these linkes again in the config.php file, also remember, it should be renamed to config.php from config.dist.php.
define('SQL_HOST','sql_host'); define('SQL_USER','your_username'); define('SQL_PASS','your_password'); define('SQL_DB','database_name');
The quotes also need to remain on each line, as in the following example, but please don't use password as your password  define('SQL_PASS','password');
Originally by: Metalstein Edited by: Metalstein on 08/12/2007 02:50:44 Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\XAMPP\htdocs\pos\functions.php on line 608
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in E:\XAMPP\htdocs\pos\functions.php on line 608
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in E:\XAMPP\htdocs\pos\register.php on line 12
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in E:\XAMPP\htdocs\pos\register.php on line 12
Getting this on trying to register. Yes, I am using XAMPP. It's a pretty handy application.
First thing that jumps out at me is it says your not using a password, which if its not set correctly it would cause this. The other thing I am not sure about is the ODBC, I haven't used it and not sure if it understands the mysql commands. One thing I would check is if the tables where created and did you use the one of the install scripts included to do so?
Corporation Management Improvement |

Metalstein
Beasts of Burden YouWhat
|
Posted - 2007.12.08 08:11:00 -
[95]
Edited by: Metalstein on 08/12/2007 08:11:38 Figured out my problem. I tried setting this up earlier on EasyPHP and got it working eventually. Had to change config.dist.php to config.php. Then it worked fine.
I promptly forgot that I did this and tried Pos Tracker on XAMPP. So I was confused as hell for a bit :) Renamed it once more and it works again.
Why does the config file come with the default name of config.dist.php anyways? ----- My posts represent my views and not those of my corporation or alliance. Unless those views are facts. Then they're facts. :) |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.08 17:11:00 -
[96]
Originally by: Metalstein Edited by: Metalstein on 08/12/2007 08:11:38 Figured out my problem. I tried setting this up earlier on EasyPHP and got it working eventually. Had to change config.dist.php to config.php. Then it worked fine.
I promptly forgot that I did this and tried Pos Tracker on XAMPP. So I was confused as hell for a bit :) Renamed it once more and it works again.
Why does the config file come with the default name of config.dist.php anyways?
So it doesn't accidentally get over written.
Corporation Management Improvement |

Tiger Wolf
|
Posted - 2007.12.10 21:26:00 -
[97]
Originally by: Johnathan Roark
Originally by: Metalstein Edited by: Metalstein on 08/12/2007 08:11:38 Figured out my problem. I tried setting this up earlier on EasyPHP and got it working eventually. Had to change config.dist.php to config.php. Then it worked fine.
I promptly forgot that I did this and tried Pos Tracker on XAMPP. So I was confused as hell for a bit :) Renamed it once more and it works again.
Why does the config file come with the default name of config.dist.php anyways?
So it doesn't accidentally get over written.
Cause our pos tracker creator is smarter than ccp when it comes to releasing new things...
|

Ulrich Smith
|
Posted - 2007.12.17 18:43:00 -
[98]
Originally by: Johnathan Roark POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Is there a ver 2.1 download out there that has all of the fixes and changes included?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.18 06:59:00 -
[99]
Originally by: Ulrich Smith
Originally by: Johnathan Roark POS-Tracker's future:
To me, it seems most of the bugs have been worked out. Most of the remaining ones seem to be typos in the database exports.
I am now beginning to look toward a 2.1 version and I am wondering what everyone would like to see in it? Currently I am looking at the new starbase api features and how to add them into the tracker. This should be rather easy if we get moon location IDs. This may require some database changes, hopefully nothing too major. I have also been looking at making the install process a little better. The Secret POS/Highly Trusted needs finishing. We where also intending on adding a comment box for towers that we never go arround to coding. The field for this is already in the database.
Is there a ver 2.1 download out there that has all of the fixes and changes included?
No not yet, I hope to have a testing version of 2.1 out in the next week or two. This will be mostly database changes and the addition of the EVEAPI stuff(which is really cool btw). I'm planning on changing the way passwords are stored.
Upgrading from 2.0.94 to 2.1 wont be direct. There are almost are too many database changes along with the password storage change to work. This shouldn't be a problem as most will be able to add there towers from the eveapi. I am also planning on making a xml export/import script so everyone can import there structures and outpost into 2.1 versions. This will also make it easier to change servers and make a backup. I don't intend to export/ import the user table. If for some reason anyone thinks this will be a problem for them, please post or evemail me. SVN is up to date under branches/2.1/ if anyone wants live on the edge and isntall that. The manual API update scripts are currently broken and only 2 of the regional moon SQL files are finished. the other ones included need the table name changed if you want to use them. I'll get the rest done sometime this week hopefully.
Corporation Management Improvement |

Captain Ferros
Caldari Expeditionary Fleet 1 Ka-Tet
|
Posted - 2007.12.18 20:52:00 -
[100]
UNOFFICIAL FILES!
I made these to one.. update my alliance info and sov info while on php4, and 2... cause with the name change of regions..
THese are unofficial, since not made by the people working on this, but ifve tested them on my server first. feel free to look over coding if you dont trust it, there is nothing linking to mine.
I put them all in one zip file, but use the one you need. copy them to your pos tracker root directory, then access them via web.
update.php will update the newly renamed regions in your database. it wont change your pos's
updatesov1.php will add in info from todays xml file, manually parsed (dont fret, took only 10 miniutes to do)
updateallianceinfo1.php will do same for the alliance info (it will delete all alliance info and re-add it in based off of todays manually pased xml file)
I will be attempting to make availaible the manually paresed files once a week, since i use them myself.
download is here http://www.bkoa.us/postracker.zip
oh, and nice program :D ---------------- Captain Ferros Command Fleet Admiral Admin Fleet Cmdr Expeditionary Fleet 1 Ka-tet http://tinyurl.com/2u8eqe[/url |

Shime
|
Posted - 2007.12.19 13:43:00 -
[101]
Hello, Since trinity, there is an error when trying to update the alliance list :
Could not select Member; 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 'LIMIT 1' at line 1
If anyone have an idea ??
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.19 17:37:00 -
[102]
Originally by: Shime Edited by: Shime on 19/12/2007 13:48:50 Hello, Since trinity, there is an error when trying to update the alliance list :
Could not select Member; 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 'LIMIT 1' at line 1
If anyone have an idea ??
(if using katet zip files, update are ok)
Change: foreach ($xml->xpath('//row') as $row) { To: foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) {
That should work, the eveapi xml structure changed. Before, it was grabbing every element called row, taking the allianceID and seeing if it was already in the database, If not, it added it to the database. Now they've added corporations to the alliance list, it can't find an allianceID in the first row for a corporation and then the sql is invalid.
Corporation Management Improvement |

Linkex
Caldari Volition Cult The Volition Cult
|
Posted - 2007.12.19 18:23:00 -
[103]
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.19 19:41:00 -
[104]
Originally by: Linkex
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
try manually creating the database by copy/pasting creat_database.sql into something like phpmyadmin?
Corporation Management Improvement |

Shime
|
Posted - 2007.12.19 21:36:00 -
[105]
Originally by: Johnathan Roark
Originally by: Shime Edited by: Shime on 19/12/2007 13:48:50 Hello, Since trinity, there is an error when trying to update the alliance list :
Could not select Member; 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 'LIMIT 1' at line 1
If anyone have an idea ??
(if using katet zip files, update are ok)
Change: foreach ($xml->xpath('//row') as $row) { To: foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) {
That should work, the eveapi xml structure changed. Before, it was grabbing every element called row, taking the allianceID and seeing if it was already in the database, If not, it added it to the database. Now they've added corporations to the alliance list, it can't find an allianceID in the first row for a corporation and then the sql is invalid.
Thats works  Thks a lot !!
|

Linkex
Caldari Volition Cult The Volition Cult
|
Posted - 2007.12.20 08:05:00 -
[106]
Originally by: Johnathan Roark
Originally by: Linkex
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
try manually creating the database by copy/pasting creat_database.sql into something like phpmyadmin?
Thanks. I got it to work properly in the end, I used ini_set at the top of the install script to set the timeout to 10 mins (600 secs). Took approx 8 mins on my host.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.20 08:18:00 -
[107]
Originally by: Linkex
Originally by: Johnathan Roark
Originally by: Linkex
Originally by: Mestoth "Error at the line 3001: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
Query: pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14);
MySQL: 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 'pID`, `typeID`) VALUES (40003320, 'Maspah VI - Moon 15', 2, 8, 14)' at line 1"
Anyone find the cause of this yet? I've tryed it on our live server and my test server, same issue. I've checked the sql file, line 3001 dosen't have any syntax errors I can see.
I have no max database size on my test server, plus its only getting about 300kb into the database with this.
try manually creating the database by copy/pasting creat_database.sql into something like phpmyadmin?
Thanks. I got it to work properly in the end, I used ini_set at the top of the install script to set the timeout to 10 mins (600 secs). Took approx 8 mins on my host.
That makes me think its a problem with size of the database. Although physical space may not be a limitation, most php installations have a script execution time limit. This should go away in the next version, I am breaking up the moons by region, which will help with performance as you'll only have to add the moons in the regions you operate in.
Corporation Management Improvement |

Nina Mires
Sharks With Frickin' Laser Beams Mercenary Coalition
|
Posted - 2007.12.20 10:41:00 -
[108]
Did the same on my host using phpmyadmin. Server couldn't cope with the import of 35Mb of data.
I used the manual way of importing the database in the end which worked a treat.
I am missing something when it comes to the silo configuration? I would have expected to see a silo fuel (as it were) monitor on the track pos page?
Need to get my head around how you've done the Sov checking / calculations, but these are some really great additions to a program that is almost essential for maintaining a number of pos's.
Keep up the good work.
Nina ---------
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.20 19:54:00 -
[109]
Originally by: Nina Mires
I am missing something when it comes to the silo configuration? I would have expected to see a silo fuel (as it were) monitor on the track pos page?
I have planned on adding a view to the main track page for silos, but its one of those things I haven't had a chance to do.
Originally by: Nina Mires
Need to get my head around how you've done the Sov checking / calculations, but these are some really great additions to a program that is almost essential for maintaining a number of pos's.
Sovereignty is updated through the eveapi into a table called system_status. When it needs to know which table to get the fuel info out of it sends the systemID to a function called getsovstatus(), which returns the name of the proper table to use. depending on sovereignty level. It needs to be updated to check to make sure the the towers alliance and the sov holder are the same.
Corporation Management Improvement |

Hsnopi
Minmatar Paxton Industries
|
Posted - 2007.12.21 17:17:00 -
[110]
so i downloaded this. looks cool. 1. config.dist.php has to be renamed to config.php 2. is the sql the entire eve database? I already have that so can you provide a smaller sql for if we don't have that already installed? or do i need to uninstall my entire database and reinstall it now? (the tables for all of the eve database) 3. in /usr/local/bin/php mail.php /usr/local/bin/php cron_updatesov.php /usr/local/bin/php cron_updateallianceinfo.php
are these fiels going to be written to thsoe locations? or was I supposed to alter them to my path to PSO tracker? thanks Hsnopi
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.21 17:32:00 -
[111]
Originally by: Hsnopi so i downloaded this. looks cool. 1. config.dist.php has to be renamed to config.php 2. is the sql the entire eve database? I already have that so can you provide a smaller sql for if we don't have that already installed? or do i need to uninstall my entire database and reinstall it now? (the tables for all of the eve database) 3. in /usr/local/bin/php mail.php /usr/local/bin/php cron_updatesov.php /usr/local/bin/php cron_updateallianceinfo.php
are these fiels going to be written to thsoe locations? or was I supposed to alter them to my path to PSO tracker? thanks Hsnopi
1. yes, config.dist.php needs to be renamed 2. No, it uses some parts of the eve database dump but modified to better suit this app. 3.No, you shouldn't have to edit that file at all unless you do not want one of those 3 files to run. The path has to do with your php install and it should be fine unless your running a weird setup.
Corporation Management Improvement |

Hsnopi
Minmatar Paxton Industries
|
Posted - 2007.12.21 18:11:00 -
[112]
ok one lest question then.
will the database structure you have provided interfere with the current eve mysql dump I have installed on my db?
|

Hsnopi
Minmatar Paxton Industries
|
Posted - 2007.12.21 18:28:00 -
[113]
for those of you wiht copy paste limitations or a phpmyadmin tool limitation (most have) youc an dothe following suppose your database name is monkey. fromt he command line cd to the directory wiht the create_database.sql directory shell>mysql -u <user> -p <password> mysql>use monkey; mysql> source create_database.sql; looots of lines of Query OK, 1 rows affected.
doone
|

Hsnopi
Minmatar Paxton Industries
|
Posted - 2007.12.21 18:31:00 -
[114]
on running install after creating database.... Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 33723647 bytes) in /<path>/install.php on line 7
which is the file_get_contents. you may want to break that up into various seperate files. You also may want to consider using repalce instead of insert incase of errors on original install. I assume if you have created the db using bigdump or sourceing the file you have touse install2.php?
I would love to help debug this if youa re interested. if not i will shut up:)
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.21 18:55:00 -
[115]
Originally by: Hsnopi on running install after creating database.... Fatal error: Allowed memory size of 20971520 bytes exhausted (tried to allocate 33723647 bytes) in /<path>/install.php on line 7
which is the file_get_contents. you may want to break that up into various seperate files. You also may want to consider using repalce instead of insert incase of errors on original install. I assume if you have created the db using bigdump or sourceing the file you have touse install2.php?
I would love to help debug this if youa re interested. if not i will shut up:)
i've included a copy of bigdump.php which should be able to handle the database size. 2.1 will have the moons broken up by region
Corporation Management Improvement |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.23 08:17:00 -
[116]
I've put a 2.1.0 Beta package together. Please keep in mind that its not complete and a work in progress. yes, there are some bugs, some of the same ones that where in 2.0.94 are in this one. I recommend keeping your old installation until this has been finalized a bit more. If your not familiar with PHP, i suggest waiting. I would prefer bug reports that include possible or likely fixes, not bug real general bug reports telling me its broken.
EVEAPI POS support has been added, but is not complete. updatepos.php will update/add POS. addapi.php will allow you to add keys.
The database has had some changes made, mostly to support the eveapi. A prefix has been added to all the tables 'pos2_'. This is user configurable but the install scripts do not take the user definition into account yet. Moons have been broken up by region. You will only need to add/install those regions you have POS in.
The password hashing method has been changed. New method is currently PHP 5 only, but wont be a problem to include a PHP 4 version in the future. The old method for password hashing was insecure.
Corporation Management Improvement |

Shime
|
Posted - 2007.12.27 18:40:00 -
[117]
just try and my comment :
1st : must activate curl under apache config to work. 2nd : when create admin account, there is an error and i can't create. i must insert manualy into sql.
3nd : when update pos list, there is an error : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in .....updatepos.php on line 10
if we do "done" all seems ok, but there is no module on the pos setting (is it a problem or must we enter the setup?)
Anyway thats a great job.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.27 19:24:00 -
[118]
Originally by: Shime just try and my comment :
1st : must activate curl under apache config to work. 2nd : when create admin account, there is an error and i can't create. i must insert manualy into sql.
3nd : when update pos list, there is an error : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in .....updatepos.php on line 10
if we do "done" all seems ok, but there is no module on the pos setting (is it a problem or must we enter the setup?)
Anyway thats a great job.
1) yes, CURL is needed. Most cases its already on with a PHP 5 installation. Or at least that was my understanding
2) Happen to know what the error was, I think i've already corrected that though in the SVN.
3) Using more then one api key? I've fixed that in the svn already as well. I was overwriting the original sql result and then there wasn't any valid data for the next loop, which has also been fixed.
POS modules are not listed in the eveapi so I can't import them, you'll have to add them manually. I am planning on writing an export script for version 2.0.94 versions and an import script for 2.1.x versions. This isn't high on my priorties list though.
Corporation Management Improvement |

CyPhEr UmOs
Gallente CyPhEr TeChNoLoGiEs EvE Consortium
|
Posted - 2007.12.29 07:50:00 -
[119]
In the database, what should be in the highly_trusted field for a highly trusted member? Default is 0 and when I change it manually to 1, 2 or 3 it doesn't change anything.
Thanks. ==================== [CYPHE] Cypher Technologies Kemerk |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.29 17:40:00 -
[120]
Originally by: CyPhEr UmOs
In the database, what should be in the highly_trusted field for a highly trusted member? Default is 0 and when I change it manually to 1, 2 or 3 it doesn't change anything.
It does, notice the make classified button on edit pos when you have that set to 1? That will hide POS from those how do not have it set to 1.
Originally by: CyPhEr UmOs
I have added a Small Gallente POS with no problems. I added a Medium Shadow Control Tower POS and when I go back to view it I get the following errors:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../viewpos.php on line 175
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../viewpos.php on line 180
Warning: Division by zero in /.../viewpos.php on line 251 [/qoute] those lines tell me that you've added a silo and/or a reactor and something did not work right?
Originally by: CyPhEr UmOs
I also went to add fuel to the first pos that i had no issues with and got this message:
Error retrieving from pos_static in function uptimecalc;Table 'xxxxxxx_postracking.pos2_pos_race_specific' doesn't exist.
Im guessing on the fuel calculator? yea, i haven't gotten arround to removing refrences to that table yet.
Corporation Management Improvement
|

Lillis85
Gallente Dark Matter Coalition
|
Posted - 2007.12.31 11:25:00 -
[121]
I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.31 17:23:00 -
[122]
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Corporation Management Improvement |

IVannaTrump
|
Posted - 2007.12.31 22:23:00 -
[123]
when trying to browse to root/pos/addapi.php. I can input both fields, however I can an error 521. Any Ideas? Just As a note, I can update sov, and other cUrl info. I have cUrl enabaled.
HELP
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2007.12.31 23:57:00 -
[124]
Originally by: IVannaTrump Edited by: IVannaTrump on 31/12/2007 22:44:31 when trying to browse to root/pos/addapi.php. I can input both fields, however I get an error 521. Any Ideas? Just As a note, I can update sov, and other cUrl info. I have cUrl enabaled.
HELP
Its an EVEAPI error code: "Invalid username and/or password passed to UserData.LoginWebUser()."
EVE API Error List
I would check your userid and apikey.
Corporation Management Improvement |

IVannaTrump
|
Posted - 2008.01.01 00:23:00 -
[125]
Originally by: Johnathan Roark
Originally by: IVannaTrump Edited by: IVannaTrump on 31/12/2007 22:44:31 when trying to browse to root/pos/addapi.php. I can input both fields, however I get an error 521. Any Ideas? Just As a note, I can update sov, and other cUrl info. I have cUrl enabaled.
HELP
Its an EVEAPI error code: "Invalid username and/or password passed to UserData.LoginWebUser()."
EVE API Error List
I would check your userid and apikey.
Thats the thing, I have checked it several times over, and smae thing. Is there a failed login timer. or am I missing something in the code?
|

Lillis85
Gallente Dark Matter Coalition
|
Posted - 2008.01.01 12:12:00 -
[126]
Originally by: Johnathan Roark
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Ah yes, I was logged in as admin. Now it's friendly again, but the problem with slightly off fuel requirements are still there. The POS is in a capital constellation and the sov lvl displayed on the page is 5. It's a regular Large Gallente Tower. I have double checked the structures and which ones are offlined and onlined.
The fuels that seem to missmatch is oxygen, isotopes, liquid ozone, heavy water and strontium. Strontium is way off showing only half the required amount then it actually is. Shows 140 when it should be 300.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.01 20:16:00 -
[127]
Originally by: Lillis85 Edited by: Lillis85 on 01/01/2008 12:18:19 Edited by: Lillis85 on 01/01/2008 12:17:54
Originally by: Johnathan Roark
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Did you add the tower or are you viewing the tower with a character other than the corp that actually has the tower? This includes the admin account?
Ah yes, I was logged in as admin. Now it's friendly again, but the problem with slightly off fuel requirements are still there. The POS is in a capital constellation and the sov lvl displayed on the page is 5. It's a regular Large Gallente Tower. I have double checked the structures and which ones are offlined and onlined.
The fuels that seem to missmatch is oxygen, isotopes, liquid ozone, heavy water and strontium. Strontium is way off showing only half the required amount then it actually is. Shows 140 when it should be 300.
Edit: The CPU and PWG used are displaying correct numbers
Sorry, i didn't look at which version you where running, 2.0.94 fuel tables are incorrect. Im hoping the new ones are better, but I just spotted an error in those as well.
Corporation Management Improvement |

Lillis85
Gallente Dark Matter Coalition
|
Posted - 2008.01.01 22:34:00 -
[128]
Ah ok, still very nice work mate. Keep it up. Looking forward for new versions. Will try out the 2.1.0
|

scramke
Horizon.Inc Dark Matter Coalition
|
Posted - 2008.01.02 08:15:00 -
[129]
Originally by: Lillis85 I must say that this is a great tool! Very nice job to you guys! I have a problem though.
When I've added a POS with fuel and structures and then view it, it tells me that the sov status is hostile. It also looks like the fuel requirements are somewhat off. Looks like the bonus from the sov lvl is not kicking in and I can't figure out why the sov status is set to hostile when it shouldn't. The fuel requirements are perfect for our POSes in systems without sov. What could be the cause of this? I'm using the 2.0.94 version.
Thanks
Having the same problem here as well , also fuel requirements for oxygen are wrong for small gallente towers in systems with sov 1 to 3
|

almooja
THE ACORN TREE Fuzzy Nut Attack Squirrels
|
Posted - 2008.01.02 13:15:00 -
[130]
seems as though it is missing some of the high sec systems. ___________________________________ Contact me about your cap ship needs!
Almooja NUTS Production and Manufacturing NUTS Trading |

Pronas
Scoopex The Threshold
|
Posted - 2008.01.02 13:34:00 -
[131]
Edited by: Pronas on 02/01/2008 13:35:27 i found 2 little problem certainely already fix (version use 2.1.0 beta) :
1/ install3.php diff :
58c58,59 < $sql = "INSERT INTO".TBL_PREFIX." user SET eve_id='1', name='Admin', pass='" . my_escape($password) . "', email='" . my_escape($_POST['email']) . "', access=4, datetime='" . $time . "'"; --- > $sql = "INSERT INTO ".TBL_PREFIX."user SET eve_id='1', name='Admin', pass='" . my_escape($password) . "', email='" . my_escape($_POST['email']) . "', access=4, datetime='" . $time . "'"; > // echo $sql; 99c100 < } \ No newline at end of file --- > }
2/ When adding a tower on a fresh install, it's said there is already one installed. Removing the row count test make add tower working.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.03 17:33:00 -
[132]
POS-Tracker 2.1.0 BETA 1
This is release contains mostly bug fixes and some modifications to the EVE API POS update. There is now a link in the admin panel to add api keys as well as to run the update script. It requires access level 3 or higher to run. I've also included a copy for a cron job to run. I personally run it every other hour on my install. The only new feature in this release is the ability to rename towers if you have access level 3 or higher.
Corporation Management Improvement |

franny
Phoenix Knights Dark Nebula Galactic Empire
|
Posted - 2008.01.03 18:33:00 -
[133]
Originally by: Johnathan Roark The only new feature in this release is the ability to rename towers if you have access level 3 or higher.
but it was sooo much fun haxoring my sql db 
nice add, glad to see it's still being worked on franny - retired
PKKP recruitment |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.03 20:39:00 -
[134]
Originally by: almooja seems as though it is missing some of the high sec systems.
Which regions, and where is it giving you problems? Those tables are copied from the eve data dump and the api.
Corporation Management Improvement |

Manoxtra
Gallente Helios Incorporated Insurgency
|
Posted - 2008.01.03 23:00:00 -
[135]
Hi,
Im getting this error;
Could not create user;Table 'manonet_pos.INTOpos_user' doesn't exist
But i could make the sql as a whole, i get this message when i try to create an admin. ------------------------------------------------- Helios Inc |

almooja
THE ACORN TREE Fuzzy Nut Attack Squirrels
|
Posted - 2008.01.04 00:17:00 -
[136]
Originally by: Johnathan Roark
Originally by: almooja seems as though it is missing some of the high sec systems.
Which regions, and where is it giving you problems? Those tables are copied from the eve data dump and the api.
Heimeter Region. It has the .4 systems. but not the .5, .6, .7 systems. ___________________________________ Contact me about your cap ship needs!
Almooja NUTS Production and Manufacturing NUTS Trading |

Shime
|
Posted - 2008.01.04 10:33:00 -
[137]
Originally by: Manoxtra Hi,
Im getting this error;
Could not create user;Table 'manonet_pos.INTOpos_user' doesn't exist
But i could make the sql as a whole, i get this message when i try to create an admin.
yes there is a little error in install3.php At this line : $sql = "INSERT INTO".TBL_PREFIX."user SET eve_id='1 ....
Just add a space enter "INSERT INTO and "
Good line is : $sql = "INSERT INTO ".TBL_PREFIX."user SET eve_id='1'...
|

Gilgamoth
Imperium Technologies
|
Posted - 2008.01.04 13:56:00 -
[138]
Edited by: Gilgamoth on 04/01/2008 13:56:36 Ooops, wrong thread
Regards,
Gil
Live on Eden Underground Radio every Wednesday 19:00 - 21:00 GMT. |

Aelena Thraant
Shadows of the Dead Aftermath Alliance
|
Posted - 2008.01.04 19:12:00 -
[139]
Great tool... A couple of issues I found so far
Outpost days of fuel status isn't correct if you don't have one of the towers it uses. For Example I have just amarr towers for this one outpost. I have all the types of fuel, but since it doesn't need oxygen isotopes the time left comes out 0 so the track screen shows 0
Reinforced is not being pulled from the api. We have a pos that was put into reinforced, but it's not showing up that way. It would be nice to see when it comes out as well.
I would like to see the pos list on track.php to use 100% instead of a fixed size.
It also would be nice to have it pull the outpost fuel from the asset list api call
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.04 19:42:00 -
[140]
Originally by: Aelena Thraant Great tool... A couple of issues I found so far
Outpost days of fuel status isn't correct if you don't have one of the towers it uses. For Example I have just amarr towers for this one outpost. I have all the types of fuel, but since it doesn't need oxygen isotopes the time left comes out 0 so the track screen shows 0
yea, thats one of the things im going to work on. I'll probably end up redoing some of it.
Originally by: Aelena Thraant
Reinforced is not being pulled from the api. We have a pos that was put into reinforced, but it's not showing up that way. It would be nice to see when it comes out as well.
That is something I want to add at some point, but since I don't have any towers in reinforced, its hard to test.
Originally by: Aelena Thraant
I would like to see the pos list on track.php to use 100% instead of a fixed size.
talking about font size or the table width?
Originally by: Aelena Thraant
It also would be nice to have it pull the outpost fuel from the asset list api call
I may do that, also considered seeing if I could get silos from it
Outpost and Silos are defently in need of some work. I plan to try and clean up some of the code and possibly rewrite some of it.
Corporation Management Improvement |

Aelena Thraant
Shadows of the Dead Aftermath Alliance
|
Posted - 2008.01.04 20:27:00 -
[141]
Originally by: Johnathan Roark
Originally by: Aelena Thraant Great tool... A couple of issues I found so far
Originally by: Aelena Thraant
Reinforced is not being pulled from the api. We have a pos that was put into reinforced, but it's not showing up that way. It would be nice to see when it comes out as well.
That is something I want to add at some point, but since I don't have any towers in reinforced, its hard to test.
here is one (location and moon cleared to protect the por little pos :p) <row itemID="558526903" typeID="20060" locationID="xxxxx" moonID="xxxxx" state="3" stateTimestamp="2008-01-05 10:05:48" onlineTimestamp="2008-01-03 18:44:05"/>
Originally by: Johnathan Roark
Originally by: Aelena Thraant
I would like to see the pos list on track.php to use 100% instead of a fixed size.
talking about font size or the table width?
the table width
Originally by: Johnathan Roark
Originally by: Aelena Thraant
It also would be nice to have it pull the outpost fuel from the asset list api call
I may do that, also considered seeing if I could get silos from it
Outpost and Silos are defently in need of some work. I plan to try and clean up some of the code and possibly rewrite some of it.
As far as I know silo amounts are not available via either api :(
|

Rooky2001
Black-Wing Te-Ka
|
Posted - 2008.01.05 00:04:00 -
[142]
Originally by: IVannaTrump
Originally by: Johnathan Roark
Originally by: IVannaTrump Edited by: IVannaTrump on 31/12/2007 22:44:31 when trying to browse to root/pos/addapi.php. I can input both fields, however I get an error 521. Any Ideas? Just As a note, I can update sov, and other cUrl info. I have cUrl enabaled.
HELP
Its an EVEAPI error code: "Invalid username and/or password passed to UserData.LoginWebUser()."
EVE API Error List
I would check your userid and apikey.
Thats the thing, I have checked it several times over, and smae thing. Is there a failed login timer. or am I missing something in the code?
same problem on my xampp server.
my Workaround in addapi.php:
Quote: #$ch = curl_init();
#curl_setopt($ch, CURLOPT_URL, $url); #curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); #curl_setopt($ch, CURLOPT_HEADER, false); #curl_setopt($ch, CURLOPT_POST, 1); #curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); $url = "http://api.eve-online.com/account/Characters.xml.aspx?userid=".$userid."&apikey=".$apikey; if (!($contents = file_get_contents($url))){ exit; } $xml = new SimpleXMLElement($contents); #$xml = new SimpleXMLElement(curl_exec($ch)); #curl_close($ch);
|

Peter Kay
Space Monkeys
|
Posted - 2008.01.06 21:14:00 -
[143]
Seem to be getting the following.
test3test1test2 Fatal error: Call to undefined function hash() in E:\WebSites\mc.friar.info\pos\password.php on line 12
When either doing the admin or registering a new user.
Any ideas?
Thanks
PK
|

Peter Kay
Space Monkeys
|
Posted - 2008.01.06 22:57:00 -
[144]
After some fun with hash then getting curl to work on IIS6. Put the API key in and get error 200
Which Means "Current security level not high enough."/>
Do we know what rights a character needs to view all pos for the corp?
Rgds
PK
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.07 04:00:00 -
[145]
Originally by: Aelena Thraant here is one (location and moon cleared to protect the por little pos :p) <row itemID="558526903" typeID="20060" locationID="xxxxx" moonID="xxxxx" state="3" stateTimestamp="2008-01-05 10:05:48" onlineTimestamp="2008-01-03 18:44:05"/>
I probably will be able to at least get it to change the state, im not sure about it timing the reinfroced atm, I'll have to look into it some more.
Originally by: Aelena Thraant
the table width
I have plans to do some better customizable stylesheets, but it needs to work in both the out of game browser and ingame browser.
Originally by: Rooky2001
same problem on my xampp server.
my Workaround in addapi.php:
Quote: #$ch = curl_init();
#curl_setopt($ch, CURLOPT_URL, $url); #curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); #curl_setopt($ch, CURLOPT_HEADER, false); #curl_setopt($ch, CURLOPT_POST, 1); #curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); $url = "http://api.eve-online.com/account/Characters.xml.aspx?userid=".$userid."&apikey=".$apikey; if (!($contents = file_get_contents($url))){ exit; } $xml = new SimpleXMLElement($contents); #$xml = new SimpleXMLElement(curl_exec($ch)); #curl_close($ch);
Are you having problems with all the update scripts or just that one? did you need to do that hack on all of them or just that one? I'm guessing its how CURL is formating the POST values.
Originally by: Peter Kay Edited by: Peter Kay on 06/01/2008 21:52:59 Seem to be getting the following.
test3test1test2 Fatal error: Call to undefined function hash() in E:\WebSites\mc.friar.info\pos\password.php on line 12
When either doing the admin or registering a new user.
Updating from 5.1.2 which hash should be enabled by default, to 5.2.5 fixed the issue.
Thats odd, maybe an ISS/PHP issue that was fixed in 5.2.5?
Originally by: Peter Kay After some fun with hash then getting curl to work on IIS6. Put the API key in and get error 200
Which Means "Current security level not high enough."/>
Do we know what rights a character needs to view all pos for the corp?
I think you need a full key from a director in your corp to use.
Corporation Management Improvement |

Peter Kay
Space Monkeys
|
Posted - 2008.01.07 12:37:00 -
[146]
I'll try get another API key from director later today.
I'll also pull down the latest svn if i can.
Rgds
PK
|

Peter Kay
Space Monkeys
|
Posted - 2008.01.07 18:33:00 -
[147]
Directors API key not working either both receive same Error 200.
Being new to EvE API makes debugging harder.
Rgds
PK
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.07 18:46:00 -
[148]
Originally by: Peter Kay Directors API key not working either both receive same Error 200.
Being new to EvE API makes debugging harder.
Rgds
PK
Make sure this is the second key.
Corporation Management Improvement |

Peter Kay
Space Monkeys
|
Posted - 2008.01.07 20:02:00 -
[149]
Originally by: Johnathan Roark
Originally by: Peter Kay Directors API key not working either both receive same Error 200.
Being new to EvE API makes debugging harder.
Rgds
PK
Make sure this is the second key.
Got it Full API Key of a Director for the Corp in question.
Auto pulls in all the POS's and fuel levels.
Superb.
Rgds
PK
|

Crotador
Minmatar The Older Gamers R0ADKILL
|
Posted - 2008.01.10 15:14:00 -
[150]
Originally by: Johnathan Roark
Originally by: Peter Kay Edited by: Peter Kay on 06/01/2008 21:52:59 Seem to be getting the following.
test3test1test2 Fatal error: Call to undefined function hash() in E:\WebSites\mc.friar.info\pos\password.php on line 12
When either doing the admin or registering a new user.
Updating from 5.1.2 which hash should be enabled by default, to 5.2.5 fixed the issue.
Thats odd, maybe an ISS/PHP issue that was fixed in 5.2.5?
hash() function wasn't introduced until after 5.1.2 This should maybe check the version and adapt the code accordingly.
My CEO would like his API key to be encrypted in the DB. Is this easily possible??
Great bit of sofware btw. Thanks
|

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'];
|

Riu Stuka
Caldari GeoCorp. Paxton Federation
|
Posted - 2008.01.22 13:23:00 -
[181]
Nvm my question got it fixed by using this:
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://api.eve-online.com/corp/StarbaseList.xml.aspx?userid=".$userid."&apikey=".$apikey."&characterID=".$characterID); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_POST, 1); #curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); $curl_error=curl_errno($ch); if($curl_error!=0) { -----------------------------------------------
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.22 17:21:00 -
[182]
Originally by: perry2 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'];
Are you using code from the SVN? Most of the bugs your finding have already been fixed.
Corporation Management Improvement |

Myrdyr
|
Posted - 2008.01.22 22:40:00 -
[183]
Originally by: Johnathan Roark Edited by: Johnathan Roark on 22/01/2008 17:31:21
Originally by: Viktor Rasmussen 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?
There was some old code doing this, it has been fixed in the SVN.
I just did a `svn update` and the references to $pos_race1 are still there: $ grep -n \$pos_race1 *.php fuel_calculator.php:185: $pos_race1 = 1; fuel_calculator.php:187: $pos_race1 = $pos_race; fuel_calculator.php:199: $sql = "SELECT * FROM " . $db . " WHERE pos_race ='" . $pos_race1 ."' && pos_size = '" . $pos_size . "'"; functions.php:28: $pos_race1 = 1; functions.php:30: $pos_race1 = $pos_race; functions.php:38: $sql = "SELECT * FROM " . $database . " WHERE pos_race = '" . $pos_race1 . "' AND pos_size = '" . $pos_size . "'"; functions.php:196: $pos_race1 = 1; functions.php:198: $pos_race1 = $pos_race; functions.php:209: $sql = "SELECT * FROM " . $database . " WHERE pos_race ='" . $pos_race1 ."' && pos_size = '" . $pos_size . "'"; viewoutpost.php:208: $pos_race1 = 1; viewoutpost.php:210: $pos_race1 = $pos_race;
|

Kartock Maar
Harbingers of Sarrow
|
Posted - 2008.01.23 00:05:00 -
[184]
Originally by: perry2
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?
<?php /* --- Database connection inforamations ---*/
define('SQL_HOST','localhost'); define('SQL_USER','harbi3_postrac'); define('SQL_PASS','postrac'); define('SQL_DB','harbi3_postrac'); define('TBL_PREFIX', 'harbi3_');
define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/postrac/');
$conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); mysql_select_db(SQL_DB, $conn) or die('Could not select database; ' . mysql_error()); /* --- Pos tracker variables ---*/
$absolocation = 1; #Turns absolute tower location on/off
$minimal_fuel = 48; # Minimal fuel that should be kept in the towers at any time $critical_fuel = 24; # Critical fuel level
$minimal_fuel_font_color = "#E5F212" ; # $critical_fuel_text_color = "#E5F212" ; # $owner_text_color = "#FFFFFF" ; # $edited_text_color = "#FFFFFF" ; #
$minimal_fuel_background_color = "#770000" ; # $critical_fuel_background_color = "#FF0000" ; # $owner_background_color = "#001642" ; # $edited_background_color = "#F13600" ; #
?> I will change all the database information. Your signature exceeds the maximum allowed dimensions of 400x120 pixels -Sahwoolo |

perry2
|
Posted - 2008.01.23 00:40:00 -
[185]
Originally by: Kartock Maar
Originally by: perry2
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?
<?php /* --- Database connection inforamations ---*/
define('SQL_HOST','localhost'); define('SQL_USER','harbi3_postrac'); define('SQL_PASS','postrac'); define('SQL_DB','harbi3_postrac'); define('TBL_PREFIX', 'harbi3_');
define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/postrac/');
$conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); mysql_select_db(SQL_DB, $conn) or die('Could not select database; ' . mysql_error()); /* --- Pos tracker variables ---*/
$absolocation = 1; #Turns absolute tower location on/off
$minimal_fuel = 48; # Minimal fuel that should be kept in the towers at any time $critical_fuel = 24; # Critical fuel level
$minimal_fuel_font_color = "#E5F212" ; # $critical_fuel_text_color = "#E5F212" ; # $owner_text_color = "#FFFFFF" ; # $edited_text_color = "#FFFFFF" ; #
$minimal_fuel_background_color = "#770000" ; # $critical_fuel_background_color = "#FF0000" ; # $owner_background_color = "#001642" ; # $edited_background_color = "#F13600" ; #
?> I will change all the database information.
Sorry, but i dont find where error is. 
|

Kartock Maar
Harbingers of Sarrow
|
Posted - 2008.01.23 01:12:00 -
[186]
I am sorry for the confusion. I figured out the syntax error but now I am getting this error.
Could not create user;Table 'harbi3_postrac.INTOpos2_user' doesn't exist
This is happening on step 3 Your signature exceeds the maximum allowed dimensions of 400x120 pixels -Sahwoolo |

Garek Selwonk
Gallente UK Corp Rare Faction
|
Posted - 2008.01.23 23:54:00 -
[187]
Originally by: Kartock Maar I am sorry for the confusion. I figured out the syntax error but now I am getting this error.
Could not create user;Table 'harbi3_postrac.INTOpos2_user' doesn't exist
This is happening on step 3
I'm getting the same problem, on install3 its going:
Could not create user;Table 'gskspursc3.INTOpos2_user' doesn't exist
'gskspursc3' is my 'SQL_DB' - so it seems to be having trouble with the database connection when making the admin user... :S
Proud Member of UKCORP - Currently Recruiting |

Kusai
|
Posted - 2008.01.24 02:56:00 -
[188]
Originally by: Garek Selwonk
Originally by: Kartock Maar I am sorry for the confusion. I figured out the syntax error but now I am getting this error.
Could not create user;Table 'harbi3_postrac.INTOpos2_user' doesn't exist
This is happening on step 3
I'm getting the same problem, on install3 its going:
Could not create user;Table 'gskspursc3.INTOpos2_user' doesn't exist
'gskspursc3' is my 'SQL_DB' - so it seems to be having trouble with the database connection when making the admin user... :S
This was answered on page 5 of this thread.
yes there is a little error in install3.php At this line : $sql = "INSERT INTO".TBL_PREFIX."user SET eve_id='1 ....
Just add a space enter "INSERT INTO and "
Good line is : $sql = "INSERT INTO ".TBL_PREFIX."user SET eve_id='1'...
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.24 07:29:00 -
[189]
I have regenerated the moon install files. This should fix the ones with duplicate moons. I removed the old code to treat all 4 of the main races as the same race in functions.php, fuel_calculator.php, and viewoutpost.php. The hangar sizes where also missing from Caldari, Gallente, and Minmatar towers in the database. These changes can be found in the SVN. I think this is all the bugs that I know about and I'll try to package it up this weekend.
Corporation Management Improvement |

Cristiana
|
Posted - 2008.01.25 18:29:00 -
[190]
hi
very nice tool, but is there any solution if there is the "error 521" ? I¦ve used a Full-Access-APIkey of an director of our corp... if i query the poslist on my own it works, but with the tool i¦m only getting the error as soon as i try to add the api-key at the admin-panel
thank you very much
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.25 19:10:00 -
[191]
Originally by: Cristiana hi
very nice tool, but is there any solution if there is the "error 521" ? I¦ve used a Full-Access-APIkey of an director of our corp... if i query the poslist on my own it works, but with the tool i¦m only getting the error as soon as i try to add the api-key at the admin-panel
thank you very much
There is a work arround at the top of this page. To actually fix it, I would need more details such as webserver software, OS, php and curl version.
Corporation Management Improvement |

Cristiana
|
Posted - 2008.01.25 21:58:00 -
[192]
well, i¦ve tried it... but i dont know what he want¦s with the last open "{" ... without any close ;)
nothing is working... maybe someone can post the working lines of the addapi.php here ? would be great
greetings
btw. currently using a XAMPP on Windows for testing with apache2 and php5
|

Mia Yuuki
|
Posted - 2008.01.25 23:23:00 -
[193]
Heyya,
Just updated to the latest svn and I have to say that I love it. I am stuck on one thing tho, when I logged out, I can no longer log in. Even my admin account will not let me log in. Went to the sql database, reencoded the password in md5 just to be sure, and it matched what was in the database. Deleted a character account and recreated it, then seconds later, it was unable to logon, always failed. the passwords are correct, so not sure where the problem is.
Good luck.
Mia
|

Xies
|
Posted - 2008.01.26 04:09:00 -
[194]
I am having similar issues with passwords. For some reason, the password hash stored in the database is different to the password the 'comparepassword' function is getting passed to it from 'getPasswordHash'.
I modified the 'comparePassword' function to the following:
// compare a password to a hash function comparePassword( $password, $hash ) { $salt = substr( $hash, 0, 8 );
echo getPasswordHash($salt, $password); echo '<br />'; echo $hash; break; return $hash == getPasswordHash($salt, $password);
}
and this is what I got on the output for one of the passwords:
cb50121ff02a8af4ce92dd962e23aaf9 31a1cd3b158e673fe71d5b6fb6da3e58
This function will of course then compare these 2 hashes, and return negative at which point user-transaction.php will redirect to failure.php.
Using PHP Version 5.1.4 with hash enabled on CentOS server with Apache2.
Anyone have any ideas?
|

Yarkan
M'8'S
|
Posted - 2008.01.27 11:19:00 -
[195]
I have downloaded this Progrqamm from sourceforge.net. Just wanted to know which version you keep updating. Is that the link you posted here or is that the sourceforge.net . I am testing atm the sourceforge Version it looks quite nice
|

Yarkan
M'8'S
|
Posted - 2008.01.27 12:57:00 -
[196]
Reaction Things. i have setted up a POS for a Reaction. So i seetted up 4 input Silos and 2 Output Silos. And assigned those silos to the Reaction. The Problem is when i am using 2 output Silos it will fill also 2 output Silos at once. Is there anything planned in the future that you can work with 2 output silos?
|

Akyrah
|
Posted - 2008.01.28 21:24:00 -
[197]
Edited by: Akyrah on 28/01/2008 21:25:35 from the SVN lines 65 and 69 in track.php need to be changed from
$where_statement = "WHERE tower_info.corp = '" . $_SESSION['corp'] ... to
$where_statement = "WHERE ".TBL_PREFIX."tower_info.corp = '" . $_SESSION['corp'] ...
in viewpos.php $hourstofill and $hourstogo should have a check to make sure > 0 to prevent a divide by zero error.
if($rate_vol > 0) { $hourstofill=floor($avalible_silo_vol/$rate_vol); }
if($rate > 0) { $hourstogo=floor($avalible_material/$rate); }
in viewoutpost.php, editoutpost.php added:
// determine if charters are needed $sql = "SELECT count(charters_needed) FROM pos2_tower_info p, pos2_outpost_info o WHERE p.outpost_name = o.outpost_name AND p.charters_needed = 1 AND o.outpost_id = ".$outpost_id; $result3 = mysql_query($sql) or die('Could not select from outpost_update_log; ' . mysql_error()); if (mysql_num_rows($result3) > 0) { $charters_needed = mysql_result($result3,0); }
for empire pos's that use charters.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.29 08:05:00 -
[198]
Originally by: Xies Edited by: Xies on 26/01/2008 04:27:14 I am having similar issues with passwords. For some reason, the password hash stored in the database is different to the password the 'comparepassword' function is getting passed to it from 'getPasswordHash'. Anyone have any ideas?
I've fixed the password.php file to properly salt the passwords. If you have a working install, do not overwrite your current password.php unless you want to delete all of your user accounts.
Originally by: Yarkan I have downloaded this Progrqamm from sourceforge.net. Just wanted to know which version you keep updating. Is that the link you posted here or is that the sourceforge.net . I am testing atm the sourceforge Version it looks quite nice
The link goes to sourceforge.net
Originally by: Yarkan Reaction Things. i have setted up a POS for a Reaction. So i seetted up 4 input Silos and 2 Output Silos. And assigned those silos to the Reaction. The Problem is when i am using 2 output Silos it will fill also 2 output Silos at once. Is there anything planned in the future that you can work with 2 output silos?
I am planning on redoing the silo tracking code, but don't expect it any time soon.
Originally by: Akyrah
from the SVN lines 65 and 69 in track.php need to be changed from
$where_statement = "WHERE tower_info.corp = '" . $_SESSION['corp'] ... to
$where_statement = "WHERE ".TBL_PREFIX."tower_info.corp = '" . $_SESSION['corp'] ...
Yea, missing table prefixes keep on popping up. Adding that is worth it, but if you find a bug, that would be the first thing that needs to be checked.
Originally by: Akyrah
in viewpos.php $hourstofill and $hourstogo should have a check to make sure > 0 to prevent a divide by zero error.
if($rate_vol > 0) { $hourstofill=floor($avalible_silo_vol/$rate_vol); }
if($rate > 0) { $hourstogo=floor($avalible_material/$rate); }
I've been meaning to do that.
Originally by: Akyrah
in viewoutpost.php, editoutpost.php added:
// determine if charters are needed $sql = "SELECT count(charters_needed) FROM pos2_tower_info p, pos2_outpost_info o WHERE p.outpost_name = o.outpost_name AND p.charters_needed = 1 AND o.outpost_id = ".$outpost_id; $result3 = mysql_query($sql) or die('Could not select from outpost_update_log; ' . mysql_error()); if (mysql_num_rows($result3) > 0) { $charters_needed = mysql_result($result3,0); }
for empire pos's that use charters.
I've added a simpler fix in the SVN for this. the outpost() function just needed to return if any POS requires charaters.
Corporation Management Improvement |

Cristiana
|
Posted - 2008.01.29 08:46:00 -
[199]
Edited by: Cristiana on 29/01/2008 08:50:30 hi
well i¦ve added the api-key now by inserting it manually in the database as soon as i hit "update pos from api" i¦m getting the "Error 521" ... whats up with that ? any workarounds ?
greetings and thanks for your help
PS: fixed by editing the updatepos.php with the same lines like addapi.php
|

Pronas
Scoopex The Threshold
|
Posted - 2008.01.29 14:12:00 -
[200]
is there a svn version ?
How contribute to this project ? i have fix the update api code how can only work with 1 api key and fix some setup install code too.
Planning to redo the mail stuff for fuel warning as well
-- The Threshold Diplomat Scoopex CEO
Scoopex is Recruting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.29 16:59:00 -
[201]
Originally by: Cristiana Edited by: Cristiana on 29/01/2008 08:50:30 PS: fixed by editing the updatepos.php with the same lines like addapi.php
What exactly did you change?
Originally by: Pronas is there a svn version ?
Yes, it is at sourceforge.net, POS-Tracker 2 Project
Originally by: Pronas
How contribute to this project ? i have fix the update api code how can only work with 1 api key and fix some setup install code too.
Planning to redo the mail stuff for fuel warning as well
You can contribute by posting changes or email me changes. I was not aware the was a problem with multiple keys, there is just no point in adding multiple keys from the same corp. Only thing I had planned for the install code was adding support for changing the table prefix.
Corporation Management Improvement |

Pronas
Scoopex The Threshold
|
Posted - 2008.01.30 11:10:00 -
[202]
Originally by: Johnathan Roark
What exactly did you change?
A second MySQL connexion for list api. The same connexion is use for list api and select and update pos, when the code reach second result it's bug.
Originally by: Johnathan Roark
You can contribute by posting changes or email me changes. I was not aware the was a problem with multiple keys, there is just no point in adding multiple keys from the same corp. Only thing I had planned for the install code was adding support for changing the table prefix.
I use it for several corporation of our alliance. sure don't see any interrested for 1 corp.
-- The Threshold Diplomat Scoopex CEO
Scoopex is Recruting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.30 20:21:00 -
[203]
2.1.0 Beta 2 Released
This is everything in the SVN as of Reversion 117 bundled up.
Corporation Management Improvement |

Ktor
Caldari Clan Shadow Wolf Sylph Alliance
|
Posted - 2008.01.31 18:15:00 -
[204]
Installed Beta2 over Beta1
All registered corp members could not log in till I deleted and had them recreate there accounts. |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.01.31 19:12:00 -
[205]
Originally by: Ktor Installed Beta2 over Beta1
All registered corp members could not log in till I deleted and had them recreate there accounts.
I changed the password.php file to fix the password salting. Its in the readme file and it was also in the release notes not to overwrite this file if you have a working installation unless you want to delete and re-add all of your users. I also mentioned that I changed it a few post back in this thread.
Corporation Management Improvement |

Ktor
Caldari Clan Shadow Wolf Sylph Alliance
|
Posted - 2008.02.01 02:59:00 -
[206]
So the bug in the software was me then.
Easy fix for ya I bet  Sylph Alliance |

Beseiged
Minmatar Rim Collection RC Zenith Affinity
|
Posted - 2008.02.01 18:28:00 -
[207]
I'm getting an error:
Fatal error: Call to undefined function curl_init() in /var/www/www.rimcrc.com/htdocs/pos/addapi.php on line 64
When i try to add an api key. Your signature exceeds the maximum allowed dimensions of 400x120 pixels and filesize of 24000 bytes -Rauth Kivaro ([email protected])
|

Myrdyr
|
Posted - 2008.02.01 18:34:00 -
[208]
Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ? Please post constructively. ~Saint |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 19:06:00 -
[209]
Originally by: Beseiged I'm getting an error:
Fatal error: Call to undefined function curl_init() in /var/www/www.rimcrc.com/htdocs/pos/addapi.php on line 64
When i try to add an api key.
On the first page of the install script, did it say Yes by the 3 php extentions listed, specifically CURL? If you do not remember, you can safely open the first page again, just do NOT click next.
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
Corporation Management Improvement |

Aria Minasa
|
Posted - 2008.02.01 19:32:00 -
[210]
Originally by: Johnathan Roark
Originally by: Beseiged I'm getting an error:
Fatal error: Call to undefined function curl_init() in /var/www/www.rimcrc.com/htdocs/pos/addapi.php on line 64
When i try to add an api key.
On the first page of the install script, did it say Yes by the 3 php extentions listed, specifically CURL? If you do not remember, you can safely open the first page again, just do NOT click next.
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
oohhhh it didn't say curl ok. Hmm... maybe should have the next button disabled with a prompt saying, curl needs to work.
|

CDLHamma
Dragon Wolf Enterprises EVESpace
|
Posted - 2008.02.01 19:41:00 -
[211]
Won't even install for me at all, prompts to download the install.php in firefox and gives a DNS error of all things in IE |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 19:58:00 -
[212]
Originally by: Aria Minasa
oohhhh it didn't say curl ok. Hmm... maybe should have the next button disabled with a prompt saying, curl needs to work.
Was considering it, but it is possible to use the tracker without it but many of the nicer features would be broken. I may add something to make it more obvious that you may have issues if you continue.
Originally by: CDLHamma Won't even install for me at all, prompts to download the install.php in firefox and gives a DNS error of all things in IE
It sounds like your web host is configured wrong?
Corporation Management Improvement |

CDLHamma
Dragon Wolf Enterprises EVESpace
|
Posted - 2008.02.01 20:08:00 -
[213]
Nope everything is good, all the required apps PHP5 and everything. Also running PHP/MySQL forums and such. The index.php runs but the install.php does nothing. |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.01 20:23:00 -
[214]
Originally by: CDLHamma Nope everything is good, all the required apps PHP5 and everything. Also running PHP/MySQL forums and such. The index.php runs but the install.php does nothing.
Thats very odd, all install.php does is display information about your config.php file and some server settings. It should be located in a subdirectory called install, so http://yourhost.com/pos/install/install.php
Corporation Management Improvement |

CDLHamma
Dragon Wolf Enterprises EVESpace
|
Posted - 2008.02.01 20:32:00 -
[215]
It doesn't show anything at all - no errors or anything.
Perhaps I will check my php log, see if there are any errors listed in there. |

Myrdyr
|
Posted - 2008.02.01 21:18:00 -
[216]
Originally by: Johnathan Roark
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
shows zero for all quantities Please post constructively. ~Saint |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.02 06:26:00 -
[217]
Originally by: Myrdyr
Originally by: Johnathan Roark
Originally by: Myrdyr Is anyone having any problems with the Optimum fuel calculator not working in editpos.php ?
Not working in what way? Wrong quantities? No quantities?
shows zero for all quantities
I really haven't changed anything in editpos.php. Only thing I did was removed a bit of old code that makes all gallente, mimnatar, and caldari towers treated as Amarr towers. What race are your towers?
Corporation Management Improvement |

Myrdyr
|
Posted - 2008.02.03 20:15:00 -
[218]
mine are gallente. i've updated from both SVN and the beta2 release w/ no change so I am guessing it must be a database issue. can you point me towards which tables i can try restoring? I really don't want to lose the POS structures and silo data I've got set up... Please post constructively. ~Saint |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.03 20:22:00 -
[219]
Originally by: Myrdyr mine are gallente. i've updated from both SVN and the beta2 release w/ no change so I am guessing it must be a database issue. can you point me towards which tables i can try restoring? I really don't want to lose the POS structures and silo data I've got set up...
check your tower_static, sovereignty_static, and sovereignty_constellation_static. If what I suspect is going on is correct, you need to reload those tables.
POS-Tracker 2.1.0 Hosting |

Fubar
Eagle Eye Inc.
|
Posted - 2008.02.03 22:52:00 -
[220]
I found a bug in the way the volume_per_cycle is calculated in editpos.php. Lines 96 and 97.
$volume_per_cycle += ceil((($current_pg / $total_pg) * $required_ozone) * 0.4); $volume_per_cycle += ceil((($current_cpu / $total_cpu) * $required_heavy_water) * 0.4);
should be
$volume_per_cycle += (ceil(($current_pg / $total_pg) * $required_ozone) * 0.4); $volume_per_cycle += (ceil(($current_cpu / $total_cpu) * $required_heavy_water) * 0.4);
|

Myrdyr
|
Posted - 2008.02.04 16:25:00 -
[221]
Originally by: Johnathan Roark
Originally by: Myrdyr mine are gallente. i've updated from both SVN and the beta2 release w/ no change so I am guessing it must be a database issue. can you point me towards which tables i can try restoring? I really don't want to lose the POS structures and silo data I've got set up...
check your tower_static, sovereignty_static, and sovereignty_constellation_static. If what I suspect is going on is correct, you need to reload those tables.
confirmed, this did indeed fix my problems. Thanks again! Please post constructively. ~Saint |

XFranc
Caldari Lucian Alliance
|
Posted - 2008.02.04 22:37:00 -
[222]
Edited by: XFranc on 04/02/2008 22:37:55 Hi there,
Great application this!
Came across a couple of errors that i havent seen posted yet :
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /pos/viewpos.php on line 170
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /pos/viewpos.php on line 175
Warning: Division by zero in /pos/viewpos.php on line 246
This is on the http://www.eve-arcane.com/pos/viewpos.php?i=3 page, after adding a Corp Hangar array and a few other things.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.05 07:23:00 -
[223]
Originally by: XFranc
Hi there,
Great application this!
Came across a couple of errors that i havent seen posted yet :
Your silos aren't setup and you really shouldn't post the link to your tracker, although I am rather sure all the security holes have been found, its probably better that you don't help anyone by telling them where it is
POS-Tracker 2.1.0 Hosting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.05 07:52:00 -
[224]
Imports/Exports
I am looking at adding at adding some importing and exporting to POS-Tracker. I am not sure how far to take it though. I could export all the fields in tower_info, plus structues. I am leaning toward something like the following:
<pos-tracker version="0.1"> <currentTime>2008-02-05 07:10:52</currentTime> <pos> <tower typeID="20060" typeName="Amarr Control Tower Small" itemID="12345675" systemID="30000142" systemName="Jita" moonID="40009081"> <fuelbay/> <structures> <structure typeID="17184" typeName="Ballistic Deflection Array" online="1"/> <structure typeID="27675" typeName="System Scanning Array" online="1"/> <structure typeID="17182" typeName="Warp Scrambling Battery" online="1"/> </structures> </tower> </pos> <cachedUntil>2008-02-05 07:16:52</cachedUntil> </pos-tracker>
This would require some info to be filled in after importing such as owner, outpost, corp and alliance. I am considering adding corp and alliance and leaving everything else out. This would be for a full export. I am also thinking about a more limited export with only structures in addition to the full. This would basically be a way to come up with a predefined tower fitting, export the fitting, and then importing it for every tower that has a similar fit. These would be basically tower templates.
Other Apps There are some other POS tools that use XML to store info as well. I am also looking at adding the ability to import there XML into the tracker. I may also be able to generate an export that these apps can use as well.
POS-Tracker 2.1.0 Hosting |

Dan Treva
Raptor Services LTD
|
Posted - 2008.02.05 17:40:00 -
[225]
Being able to get a correct fuel calculation by putting in just the CPU/Power grid numbers would be great.
Added 20+ modules, is a painfull process.
If I have a Gallente Control Tower:
CPU: x of 6,750 used PG: x of 3,750,000 used
If there was an API export of POS modules that indicated if they were online/offline, then individual mods would make sense.
|

Myrdyr
|
Posted - 2008.02.06 15:33:00 -
[226]
I had a thought along the same lines but lazier -- as long as the updates are at least an hour apart you can do a difference of all the values and autocalculate fuel usage, no? I think assuming max usage is ideal until you get enough API grabs to determine actual usage, which can autoupdate if it detects a change in ratios... Please post constructively. ~Saint |

Mark Jones
|
Posted - 2008.02.07 00:47:00 -
[227]
I just got your beta working and have found a small omission in the pos structures. You have reactor which appears to corelate to complex reactor but you have no simple reactor.
One feature that I would like to see is the way you handle silos extended to coupling arrays as I use them in cases where the pos does not have enough cpu to run silos
|

Myrdyr
|
Posted - 2008.02.07 19:02:00 -
[228]
The Reactor Array is the simple reactor, the Medium Reactor Array is the complex reactor. Please post constructively. ~Saint |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.07 19:11:00 -
[229]
Originally by: Dan Treva Being able to get a correct fuel calculation by putting in just the CPU/Power grid numbers would be great.
Added 20+ modules, is a painfull process.
If I have a Gallente Control Tower:
CPU: x of 6,750 used PG: x of 3,750,000 used
If there was an API export of POS modules that indicated if they were online/offline, then individual mods would make sense.
I may add something like that as an option.
Originally by: Myrdyr I had a thought along the same lines but lazier -- as long as the updates are at least an hour apart you can do a difference of all the values and autocalculate fuel usage, no? I think assuming max usage is ideal until you get enough API grabs to determine actual usage, which can autoupdate if it detects a change in ratios...
I've considered doing something like that. The main issue is the api is cached for 6 hours. Its likely not to be as accurate. I may do some test on this though.
Originally by: Mark Jones I just got your beta working and have found a small omission in the pos structures. You have reactor which appears to corelate to complex reactor but you have no simple reactor.
One feature that I would like to see is the way you handle silos extended to coupling arrays as I use them in cases where the pos does not have enough cpu to run silos
The names have been changed since I last exported the sturctures. Medium Reactor is the Simple Reactor, Complex Reactor is just called Reactor Array.
As far as coupling arrays, I am planning on redoing the silo code at some point.
Originally by: Myrdyr The Reactor Array is the simple reactor, the Medium Reactor Array is the complex reactor.
Other way around.
I'd like to more opinions on the import/export feature. Am I wasting my time with this?
POS-Tracker 2.1.0 Hosting |

Mark Jones
|
Posted - 2008.02.07 19:13:00 -
[230]
I verified the cpu usage is that of the complex reactor not the simple.
I am unclear does the program query the api regularly to get fuel levels and such or just when you click the button on the admin panel page?
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.07 20:46:00 -
[231]
Originally by: Mark Jones I verified the cpu usage is that of the complex reactor not the simple.
I am unclear does the program query the api regularly to get fuel levels and such or just when you click the button on the admin panel page?
You have to setup a cron job to run a shell script that will update fuel levels.
POS-Tracker 2.1.0 Hosting |

Mark Jones
|
Posted - 2008.02.08 14:19:00 -
[232]
Having a problem with the mail.php file. When it is run it errors out with the following
Could not get pos_info; Table 'mypos.pos_info' doesn't exist
Any ideas what I have done wrong?
|

Dan Treva
Raptor Services LTD
|
Posted - 2008.02.08 19:14:00 -
[233]
Originally by: Mark Jones Having a problem with the mail.php file. When it is run it errors out with the following
Could not get pos_info; Table 'mypos.pos_info' doesn't exist
Any ideas what I have done wrong?
You need to change a few lines...
Line 16/17: $where_statement = "WHERE ".TBL_PREFIX."tower_info.secret_pos = 0";
$sql = "SELECT ".TBL_PREFIX."tower_info.*, ".TBL_PREFIX."user.name, ".TBL_PREFIX."user.corp , (SELECT ".TBL_PREFIX."user.name FROM ".TBL_PREFIX."user WHERE ".TBL_PREFIX."tower_info.secondary_owner_id=".TBL_PREFIX."user.eve_id ) AS 'backup'FROM ".TBL_PREFIX."tower_info LEFT JOIN ".TBL_PREFIX."user ON ".TBL_PREFIX."tower_info.owner_id=".TBL_PREFIX."user.eve_id " . $where_statement . " ORDER BY ".TBL_PREFIX."tower_info.towerName";
Line 24: $sql = "SELECT * FROM ".TBL_PREFIX."update_log WHERE type_id = '" . $pos_id . "' ORDER BY id DESC";
Line 32: $sql = "SELECT * FROM ".TBL_PREFIX."user WHERE eve_id = '{$owner_id}'";
Line 38: $email = $row2['email'];
Should work properly after doing that.
|

Mark Jones
|
Posted - 2008.02.08 23:37:00 -
[234]
That worked like a charm.
Question: How hard would it be to add the moon location to the e-mail that is reported?
|

Yarkan
M'8'S
|
Posted - 2008.02.11 07:39:00 -
[235]
Missing Structures you can choose a Reactor Silo (thats a complex one) but no simple reactor (missing in database)
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.11 16:23:00 -
[236]
Originally by: Yarkan Missing Structures you can choose a Reactor Silo (thats a complex one) but no simple reactor (missing in database)
CCP changed the names, Simple reactor is the same thing as Medium Reactor Array.
POS-Tracker 2.1.0 Hosting |

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.02.11 20:04:00 -
[237]
Hmm, any chance on someone turning this into english for me?
Quote: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 170
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 175
Warning: Division by zero in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 246
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 170
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 175
Warning: Division by zero in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 246
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 170
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 175
Warning: Division by zero in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 246
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 170
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 175
Warning: Division by zero in /home/masqsorg/public_html/templarsofspace/pos/viewpos.php on line 246
|

Research Rachel
|
Posted - 2008.02.12 16:04:00 -
[238]
Love the api stuff but getting errors when adding a tower manually...
Quote: Notice: Undefined variable: name in /home/public_html/AoAPOS/pos-transaction.php on line 220 Could not redirect; Headers already sent.
Also get similar errors on adding structures.
Also, adding an outpost causes
Quote: Notice: Use of undefined constant outpost_name - assumed 'outpost_name'
followed by a load of...
Quote: Notice: Undefined variable:
and changing the station in editpos brings up...
Quote: Notice: Undefined index: outpost_id in /home/ascentof/public_html/AoAPOS/outpost-transaction.php on line 8 Could not redirect; Headers already sent.
I know it was mentioned the outpost stuff is bugged and needs reworking, but just wondering if theres a way to fix all the undefined variables?
|

Fu Jinmei
|
Posted - 2008.02.12 20:46:00 -
[239]
Hi, I have a couple of issues with the cron jobs - I've fixed the mail one with the fix suggested in this thread but the others are still a problem:
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Any help appreciated
|

IVannaTrump
|
Posted - 2008.02.13 06:36:00 -
[240]
Here is a quick question.
I run a shared account with godaddy cron job, how? anybody with some working knowlede of how to get this feature to work would be of great help as their support staff are clueless.
thx
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.13 06:44:00 -
[241]
Originally by: Research Rachel Love the api stuff but getting errors when adding a tower manually...
Quote: Notice: Undefined variable: name in /home/public_html/AoAPOS/pos-transaction.php on line 220 Could not redirect; Headers already sent.
Also get similar errors on adding structures.
I have no idea why that hasn't shown up before, I'll look into what it should be.
Originally by: Research Rachel
Also, adding an outpost causes
Quote: Notice: Use of undefined constant outpost_name - assumed 'outpost_name'
followed by a load of...
Quote: Notice: Undefined variable:
and changing the station in editpos brings up...
Quote: Notice: Undefined index: outpost_id in /home/ascentof/public_html/AoAPOS/outpost-transaction.php on line 8 Could not redirect; Headers already sent.
I know it was mentioned the outpost stuff is bugged and needs reworking, but just wondering if theres a way to fix all the undefined variables?
Outpost stuff is working fine on all my installations. What version of PHP and MySQL do you have?
Originally by: Fu Jinmei Hi, I have a couple of issues with the cron jobs - I've fixed the mail one with the fix suggested in this thread but the others are still a problem:
the mail stuff will probably be my next project after the import/export stuff is complete.
Originally by: Fu Jinmei
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
I can not find anything that would cause that. What version of PHP do you have?
Originally by: Fu Jinmei
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Pull up the first page in the install script, where it says "Required Modules Installed", there should be 'yes' on the 3 lines below it, if any of these say 'No', it is an issue with your host and you may need to contact your hosting provider to have these modules turned on. They should be on by default in php 5.1.2 installations, at least according to all the PHP documentation I have read on these.
POS-Tracker 2.1.0 Hosting |

Research Rachel
|
Posted - 2008.02.13 11:30:00 -
[242]
Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.15.3 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.13 20:08:00 -
[243]
Originally by: Research Rachel Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.15.3 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
There is actually a very simple solution to your issue, in your php.ini file, find the line error_reporting = E_ALL and change to error_reporting = E_ALL & ~E_NOTICE
The NOTICE errors are generally for developement and the parser can generally figure it out. I will still probably go through the code when I have time and try to correct some of these.
Originally by: IVannaTrump Here is a quick question.
I run a shared account with godaddy cron job, how? anybody with some working knowlede of how to get this feature to work would be of great help as their support staff are clueless.
thx
In the control pannel, there should be a button call Cron Job or something along those lines. Point it to the shell files included, postrackercron.sh and poscron.sh. Give it a dedicated email account as it will fill the box. each host is a little different on exactly how this works
POS-Tracker 2.1.0 Hosting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.14 18:43:00 -
[244]
New Feature Structure List Export/Import - You can now export a towers structure list to XML and import it to MyPOS or another tower. Now if you have 10 towers that have similar structure fits, you only have to enter it once, export it, and then import the list on the other towers. There are currently two styles of Exports: MyPOS Fitting Export and POS-Tracker Fitting Export. MyPOS Fitting Export is to use with the program MyPOS. You will need to change the extentsion to .ptf. POS-Tracker Fitting Export will export the online state of the structure as well and the name of the structure. This feature is currently in the SVN version and the next release will have it.
Example of POS-Tracker Fitting Export:
<?xml version="1.0" encoding="iso-8859-1"?> <pos-tracker version="0.1"> <!--POS-Tracker Fitting Export--> <currentTime>2008-02-10 19:18:14</currentTime> <structures> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="1"/> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="1"/> <structure typeID="27644" typeName="Angel Medium Artillery Battery" online="0"/> <structure typeID="17184" typeName="Ballistic Deflection Array" online="1"/> </structures> </pos-tracker>
POS-Tracker 2.1.0 Hosting |

Fu Jinmei
|
Posted - 2008.02.16 12:04:00 -
[245]
Originally by: Fu Jinmei
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
I can not find anything that would cause that. What version of PHP do you have?
Originally by: Fu Jinmei
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Pull up the first page in the install script, where it says "Required Modules Installed", there should be 'yes' on the 3 lines below it, if any of these say 'No', it is an issue with your host and you may need to contact your hosting provider to have these modules turned on. They should be on by default in php 5.1.2 installations, at least according to all the PHP documentation I have read on these.
Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.12.1 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
|

Research Rachel
|
Posted - 2008.02.17 16:14:00 -
[246]
Something else i think would be handy and not sure if theres a reason it hasn't been asked for but is it possible to add the silo info on a second line so it's easier to see at a glance rather than having to go through every pos to check they've been seen to?
Maybe tidy up the track.php page to something like: Parent Outpost, Reinf, Tower Name, Owner, Last Update, Status, Action, Secret POS then a second line... Silo 1, Days, Silo 2, Days (up to maybe 4 as needed?)
|

Saigo Yumi
|
Posted - 2008.02.18 16:51:00 -
[247]
hi
we use the 2.1 branch, and it works nice so far 
some features we "miss":
- second pos owner, since we administrate each pos in teams of 2
- the mail.php is somewhat outdated, i got it working, but it needs some developer love. for example an alert if the silos are full or empty (output/input)
- view the lowest silo time in the pos overview for each pos. it is a little work to open every pos to check the silo status
- fuel supply locations - we have several locations where whe store our fuel for the pos teams
- an overall pos fuel consumption for a day/week/month of all pos would be nice, too
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.18 18:22:00 -
[248]
Originally by: Research Rachel
Maybe tidy up the track.php page to something like: Parent Outpost, Reinf, Tower Name, Owner, Last Update, Status, Action, Secret POS then a second line... Silo 1, Days, Silo 2, Days (up to maybe 4 as needed?)
I want to redo all the silo code but it will take some time and is planned for 2.2. No point in doing anything to current silo code with the exception of bugs until that is done.
Originally by: Saigo Yumi
some features we "miss": second pos owner, since we administrate each pos in teams of 2
There is some code already in the tracker for a secondary owner. I am guessing you want this for the mail alerts?
Originally by: Saigo Yumi the mail.php is somewhat outdated, i got it working, but it needs some developer love. for example an alert if the silos are full or empty(output/input)
I am planning on doing some work on the mail alerts. Again, no point in adding anything with the silos at this point to redo it in a month or two.
Originally by: Saigo Yumi view the lowest silo time in the pos overview for each pos. it is a little work to open every pos to check the silo status
This is something that is planned with the silo update, but it is still a little ways out. It will be a big change.
Originally by: Saigo Yumi fuel supply locations - we have several locations where we store our fuel for the pos teams
Whats wrong with the outpost tracking for this? It doesn't have to be an outpost.
Originally by: Saigo Yumi an overall pos fuel consumption for a day/week/month of all pos would be nice, too
may be able to do something like this by adapting the outpost code a bit.
POS-Tracker 2.1.0 Hosting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 07:03:00 -
[249]
Originally by: Fu Jinmei
Update POS
<b>Parse error</b>: syntax error, unexpected '{' in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatepos.php</b> on line <b>51</b><br />
I can not find anything that would cause that. What version of PHP do you have?
Originally by: Fu Jinmei
Update SOV
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updatesov.php</b> on line <b>21</b><br />
Update Alliance
<br /> <b>Fatal error</b>: Cannot instantiate non-existent class: simplexmlelement in <b>/home/sites/xxxx.xxx/public_html/postracker2/cron_updateallianceinfo.php</b> on line <b>23</b><br />
Are you still having this issue? By what you've posted, there is no reason it shouldn't work. I know I get some strange errors on occation with the API is down or having some issues.
POS-Tracker 2.1.0 Hosting |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 07:25:00 -
[250]
SVN 119 I have updated the SVN. There are some database changes in the user table for a new feature that relates to the Alert emails. The Tracker will now email users to check if an email address is valid. If the email is valid, it will note this in the user table. There is also a field to Opt-In or Out of the alert mails. This is set in the user panel.
There is an update script under the /install subdirectory that will modify the user table (backup first please) and attempt to validate the email address of all users.
The mail script has also been modified. It now knows about the table prefixes. The message also includes the moon location as well. It will not send emails to non-validated email address or to users who have not Opt-in.
Made some changes to the cron update scripts to format the output and provide more information if there is an error.
A packaged version should be out sometime later this week. I want to make a few more tweaks to the install scripts and I am thinking about making it so users can sort some of the fields on the main track page. Don't hold your breath if your hoping the fuel level column will be sorted. Its calculated after the rows have already been sorted.
POS-Tracker 2.1.0 Hosting |

ToxicAid
Minmatar Sensus Numinis Phoenix Allianz
|
Posted - 2008.02.21 10:01:00 -
[251]
Edited by: ToxicAid on 21/02/2008 10:01:37 Hi
If i load install3.php nothing is show. My Hash is not enabled, maybe this is the cause???
When it is, what can i do?
Current PHP version: 5.2.5-p20080206-pl3-gentoo (Needs to be greater than 5.1.2) Your CURL Version: 7.17.1 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: No
------------------------------------------------------ Non mortem timemus, sed cogitationem mortis _______________ Memento mori. |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 16:09:00 -
[252]
Originally by: ToxicAid Edited by: ToxicAid on 21/02/2008 10:01:37 Hi
If i load install3.php nothing is show. My Hash is not enabled, maybe this is the cause???
When it is, what can i do?
Most likely, that would be the cause. It is used to hash passwords among a few other things. Open up password.php, uncomment line 14 and comment line 13. I suggest though that you ask your host to enable it as hash works a little bit better. This is normally done by editing your php.ini file, but if you have paid hosting, you may want to ask them how to do it.
POS-Tracker 2.1.0 Hosting |

Saigo Yumi
|
Posted - 2008.02.21 17:32:00 -
[253]
Originally by: Johnathan Roark SVN 119 I have updated the SVN. There are some database changes in the user table for a new feature that relates to the Alert emails. The Tracker will now email users to check if an email address is valid. If the email is valid, it will note this in the user table. There is also a field to Opt-In or Out of the alert mails. This is set in the user panel.
There is an update script under the /install subdirectory that will modify the user table (backup first please) and attempt to validate the email address of all users.
The mail script has also been modified. It now knows about the table prefixes. The message also includes the moon location as well. It will not send emails to non-validated email address or to users who have not Opt-in.
Made some changes to the cron update scripts to format the output and provide more information if there is an error.
A packaged version should be out sometime later this week. I want to make a few more tweaks to the install scripts and I am thinking about making it so users can sort some of the fields on the main track page. Don't hold your breath if your hoping the fuel level column will be sorted. Its calculated after the rows have already been sorted.
i updated to 119, but the update script bugged. you forgot to uncomment the line 11: $result = mysql_query($sql) or die('Could not modify user;' . mysql_error());
then the script send out a bunch of emails, but the validation links were all wrong :( so i had to update the database manually to set the email_valid field
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.21 19:42:00 -
[254]
Edited by: Johnathan Roark on 21/02/2008 19:45:00
Originally by: Saigo Yumi
i updated to 119, but the update script bugged. you forgot to uncomment the line 11: $result = mysql_query($sql) or die('Could not modify user;' . mysql_error());
then the script send out a bunch of emails, but the validation links were all wrong :( so i had to update the database manually to set the email_valid field
doh!
Originally by: Saigo Yumi
Edit: It's also impossible to change my own password, it always says "Password Change failed"
An Admin Option to reset an User Password (with Access level 4 of course) would be nice also, becaus one user forgot his password.
I've looked into that, there really is no good way to do it other than to delete the user and make them register again. The password change thing is broken, I'll look into how to fix it.
POS-Tracker 2.1.0 Hosting |

Shime
|
Posted - 2008.02.21 23:01:00 -
[255]
Ive just all reinstall and update with last svm. I ve the same error : "Failed, try again." when i create the admin login/pass.
My config :
Step 1 of 4
Thank you for choosing POS-Tracker 2.0.96. Click Next to begin installing database tables. SQL Host: localhost SQL Username: root SQL Database: pos
Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.16.0 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.22 07:16:00 -
[256]
Originally by: Shime Ive just all reinstall and update with last svm. I ve the same error : "Failed, try again." when i create the admin login/pass
I'm guessing you don't have sendmail or something along those lines? I'll probably have to add a way to disable the mail system
POS-Tracker 2.1.0 Hosting |

Gistii
|
Posted - 2008.02.23 01:12:00 -
[257]
it gives me a warm feeling to see my code/concept still being developed nearly 2 years later!
|

Jomanda
The Wild Hunt Pure.
|
Posted - 2008.02.23 15:13:00 -
[258]
I found that some faction mods have incorrect PG/CPU data. I know for sure Shadow/serpentis rail guns have too high PG usage.
|

Saigo Yumi
|
Posted - 2008.02.23 16:25:00 -
[259]
I found another bug:
in the fuel_calculator.php are some ".TBL_PREFIX." missing, around line 27 and 31 i think (i've fixed it and i'm too lasy to check the lines again)
and another bad behaviour: if you create an outpost as user 1 (admin) and you don't have altered the eveid/corp settings for this char, they are pretty much unusable for other users (level 1 and 2).
greetings
-- Saigo Yumi
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.23 18:58:00 -
[260]
Originally by: Jomanda I found that some faction mods have incorrect PG/CPU data. I know for sure Shadow/serpentis rail guns have too high PG usage.
Without the IDs and correct values, that statement does not do me any good. I exported all the structures from the eve database and I am not about to go through and check every faction module to see if its wrong.
Originally by: Saigo Yumi I found another bug:
in the fuel_calculator.php are some ".TBL_PREFIX." missing, around line 27 and 31 i think (i've fixed it and i'm too lasy to check the lines again)
Found them, fixed in the SVN.
Originally by: Saigo Yumi
and another bad behaviour: if you create an outpost as user 1 (admin) and you don't have altered the eveid/corp settings for this char, they are pretty much unusable for other users (level 1 and 2).
Thats actually correct, the defualt admin account should only be used to change user access levels and run the updates. The admin account is not in a corp or alliance.
POS-Tracker 2.1.0 Hosting |

La Merovingian
|
Posted - 2008.02.25 03:01:00 -
[261]
After entering the admin e-mail address and password and clicking "next" I get the message: "Could not create user;Field 'alliance_id' doesn't have a default value"
Any suggestions?
Thanks in advance
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.25 04:39:00 -
[262]
Originally by: La Merovingian After entering the admin e-mail address and password and clicking "next" I get the message: "Could not create user;Field 'alliance_id' doesn't have a default value"
Any suggestions?
Thanks in advance
Run this using your database software such as myphpadmin: ALTER TABLE `pos2_user` CHANGE `alliance_id` `alliance_id` INT( 20 ) NOT NULL DEFAULT '0'
POS-Tracker 2.1.0 Hosting |

Research Rachel
|
Posted - 2008.02.25 17:09:00 -
[263]
looks like an old issue has slipped in too.
When you have constellation sov, sov 5 should only be in the capital system and not surrounding systems.
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.02.25 20:18:00 -
[264]
Originally by: Research Rachel looks like an old issue has slipped in too.
When you have constellation sov, sov 5 should only be in the capital system and not surrounding systems.
I am very sure that you should get a fuel bonus for all constellation systems. I know the bonus doesn't display correctly in the capital, but not sure if its actually applied in non-capital systems.
POS-Tracker 2.1.0 Hosting |

SuperTina
|
Posted - 2008.02.26 09:08:00 -
[265]
Hello, I was wondering if I could please have some assistance setting up the tracker.
I have uploaded all the files (except for postrackercron.sh and poscron.sh because my host won't allow it) and then tried to run the install.php. First page looks good:
Step 1 of 4
Thank you for choosing POS-Tracker 2.0.96. Click Next to begin installing database tables.
SQL Host: localhost SQL Username: mastakfc_postracker SQL Database: mastakfc_postracker
Current PHP version: 5.1.6 (Needs to be greater than 5.1.2) Your CURL Version: 7.13.2 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes
However then I get this error as I proceed:
Database creation failed on step 3001. Please create database manually from 'install_database.sql'. Error Text: User 'mastakfc_postracker' has exceeded the 'max_questions' resource (current value: 3000)
Im not very good at SQL or PHP, I was wondering what I'm doing wrong...
Thanks!
|

La Merovingian
|
Posted - 2008.02.26 20:31:00 -
[266]
Was following the directions in the README.txt and got to the point where I selected the regions. I loaded the region where my POS's are located. Am I done at this point?
I navigated to the page in-game, tried to register and got the HTTP 404 Page not found error when the browser tried to navigate to "http://[path to pos tracker]/user-transaction.php"
I double checked, and the path is correct, the php file is there. But at this point, I can't register any users.
Thanks in advance
|

Reinoli
|
Posted - 2008.02.26 20:51:00 -
[267]
Hello,
ich have a problem, when ich want to add the api-key. i have the error message "Fatal error: Call to undefined function: http_build_query() in /homepages/33/d18368385/htdocs/POS/addapi.php on line 70"
Please help! thx
|

Mark Jones
|
Posted - 2008.02.27 14:05:00 -
[268]
I added an outpost the other night and found a feature that would be nice to add. When adding fuel to the outpost storage you have to retype all the numbers for all the different fuels or it resets them to zero. This is a bit of a pain when only adding one fuel to the stores.
A related question.. When I fuel a pos that is parented to that outpost does in remove the fuel from the outpost stores automatically?
|

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.02.27 15:09:00 -
[269]
Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
Bug: With sovereignty status "hostile", fuel costs are not being calculated correctly for POS's in sovereign systems.
A good example is a large Caldari tower, requiring eight units of coolant per hour in non-sov and only six in-sov. Right now the tracker shows it consuming eight per hour, with 19 hours left. The game shows over a day left.
|

Dwissi
Amarr Miners Delight
|
Posted - 2008.02.28 01:47:00 -
[270]
This is really driving me nuts now for about 3 days , so i hope someone can tell me what is happening here. Everything is installed, mysql and running apache webserver.
Made the changes as stated on first post and start with install.php and when i try to create the admin user it gives me this message : Could not create user;Field 'alliance_id' doesn't have a default value.
I have read this threat forth and back now about 10 times , but dont see that error commented. Downloaded the version you provide the link for. Step 1 lists following: Thank you for choosing POS-Tracker 2.0.96. Current PHP version: 5.2.5 (Needs to be greater than 5.1.2) Your CURL Version: 7.16.0 Required Modules Instealled: CURL: Yes SimpleXML: Yes Hash: Yes Miners delight - your one stop source for dedicated services and equipment for the mining industry. |

Dwissi
Amarr Miners Delight
|
Posted - 2008.02.28 08:36:00 -
[271]
Well - after some digging into the install_database part myself i figured this part is wrong:
CREATE TABLE `pos2_user` ( `id` bigint(20) unsigned NOT NULL auto_increment, `eve_id` bigint(20) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `pass` varchar(255) NOT NULL default '', `corp` varchar(150) NOT NULL default '', `alliance_id` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `access` tinyint(3) unsigned NOT NULL default '0', `datetime` int(10) unsigned NOT NULL default '0', `away` tinyint(1) NOT NULL default '0', `highly_trusted` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `eve_id` (`eve_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
The parts in bold had to be added to create the admin user at all Miners delight - your one stop source for dedicated services and equipment for the mining industry. |

Research Rachel
|
Posted - 2008.02.28 23:38:00 -
[272]
Edited by: Research Rachel on 28/02/2008 23:38:35
Originally by: Johnathan Roark
I am very sure that you should get a fuel bonus for all constellation systems. I know the bonus doesn't display correctly in the capital, but not sure if its actually applied in non-capital systems.
Hmmmm, bonus's do display correctly in the capital system but surrounding systems are showing sov3 fuel figures so it might be that it's the surrounding systems that are displayed wrong.
Originally by: Mark Jones I added an outpost the other night and found a feature that would be nice to add. When adding fuel to the outpost storage you have to retype all the numbers for all the different fuels or it resets them to zero. This is a bit of a pain when only adding one fuel to the stores.
You can actually change this fairly easily if you edit the 'editoutpost.php' file, but yes it'd be nice to fix it permantly.
Originally by: Mark Jones
A related question.. When I fuel a pos that is parented to that outpost does in remove the fuel from the outpost stores automatically?
Nope, need to update it manually.
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
Have you updated Sov details in the admin panel? login, admin panel and do Sovereignty Update and Alliance Update which 'should' fix it.
|

Altamekz
Clan Shadow Wolf Sylph Alliance
|
Posted - 2008.03.01 14:00:00 -
[273]
Edited by: Altamekz on 01/03/2008 14:04:19 Hi,
I managed to get past the admin creation modifyg the install_database liek dwissi posted,
now I'm stucked while updating alliance data:
Notice: Undefined variable: count in C:\www\pos\updatesov.php on line 47 Could not update sov; Out of range value for column 'constellationSovereignty' at row 1
I dunno how to fix it, anyone?
I'm using on windows:
mysql-essential-5.1.23 php-5.2.5
EDIT:
I went forward anyway and when I update the pos using API I get this:
Notice: Undefined variable: row in C:\www\pos\updatepos.php on line 13
Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
|

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.03.01 18:11:00 -
[274]
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
Have you updated Sov details in the admin panel? login, admin panel and do Sovereignty Update and Alliance Update which 'should' fix it.
No, this does not fix the issue and has already been tried. This is why it's being reported as a bug.
|

SuperTina
|
Posted - 2008.03.02 05:39:00 -
[275]
I don't want to derail the topic, but does anyone know any free webhosting that supports POStracker? I've tried a few and run into problems one way or another.
Much appreciated, thanks
|

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.03.02 18:41:00 -
[276]
Originally by: SuperTina I don't want to derail the topic, but does anyone know any free webhosting that supports POStracker? I've tried a few and run into problems one way or another.
Much appreciated, thanks
Free hosting? No. Most hosts that allow PHP are pay-to-use. However, Mr. Roark does his own hosting for his own tool. Details here:
http://oldforums.eveonline.com/?a=topic&threadID=696957
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.02 19:59:00 -
[277]
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
are you using the admin account or an account in the alliance that has sovereignty?
Originally by: Altamekz
Notice: Undefined variable: count in C:\www\pos\updatesov.php on line 47 Could not update sov; Out of range value for column 'constellationSovereignty' at row 1
Two issues here, first run this on your database: ALTER TABLE `pos2_system_status` CHANGE `constellationSovereignty``constellationSovereignty` INT( 20 ) NOT NULL DEFAULT '0' Most mysql installations it doesn't matter, it just fills the field with the max value if it wont fit. The tracker just needs this to be greater than 1.
Originally by: Altamekz
Notice: Undefined variable: row in C:\www\pos\updatepos.php on line 13
Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
The 'Error: 209' is an eveapi error code, it means the the key is not a director or ceo.
for the error on line 27, add $version=2 before $data = array(
POS-Tracker 2.1.0 Hosting |

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.03.03 18:20:00 -
[278]
Originally by: Johnathan Roark
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
are you using the admin account or an account in the alliance that has sovereignty?
Both actually; neither of the two accounts show proper fuel calculations. I also tried setting the "owner" of each pos to an account that is within a corp within the alliance; this has not worked either.
|

Padyn
Black Eclipse Corp Band of Brothers
|
Posted - 2008.03.03 19:08:00 -
[279]
Originally by: Johnathan Roark
Originally by: Altamekz Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
The 'Error: 209' is an eveapi error code, it means the the key is not a director or ceo.
I added this function to functions.php function getError($err) { //Sets the location of the eveapi xml file to parse $url="http://api.eve-online.com/eve/ErrorList.xml.aspx";
//Begins connecting to eve api
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_POST, 1);
//Create XML Parser $xml = new SimpleXMLElement(curl_exec($ch)); curl_close($ch);
//Parse the file foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) { if($err == my_escape($row['errorCode'])) return my_escape($row['errorText']); } } and changed all occurrences of:echo "Error: ".$error['code']."<br>\n"; to echo "Error: ".getError($error['code'])."<br>\n";
so it displays EVE error text and user doesn't have search for it. Nemo Me Impune Lacessit - "No one strikes me with impunity" |

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.03 20:23:00 -
[280]
Originally by: Johnathan Walker
Originally by: Johnathan Roark
Originally by: Johnathan Walker Bug: When sovereignty is held by the alliance, the tracker displays sovereignty status as "hostile"
are you using the admin account or an account in the alliance that has sovereignty?
Both actually; neither of the two accounts show proper fuel calculations. I also tried setting the "owner" of each pos to an account that is within a corp within the alliance; this has not worked either.
In the user panel, click on the button that says "Update Corp/Alliance". I am guessing your alliance has changed since you've registered on the tracker.
Originally by: Padyn
Originally by: Johnathan Roark
Originally by: Altamekz Notice: Undefined variable: version in C:\www\pos\updatepos.php on line 27 Error: 209
The 'Error: 209' is an eveapi error code, it means the the key is not a director or ceo.
I added this function to functions.php function getError($err) { //Sets the location of the eveapi xml file to parse $url="http://api.eve-online.com/eve/ErrorList.xml.aspx";
//Begins connecting to eve api
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_POST, 1);
//Create XML Parser $xml = new SimpleXMLElement(curl_exec($ch)); curl_close($ch);
//Parse the file foreach ($xml->xpath('/eveapi/result/rowset/row') as $row) { if($err == my_escape($row['errorCode'])) return my_escape($row['errorText']); } } and changed all occurrences of:echo "Error: ".$error['code']."<br>\n"; to echo "Error: ".getError($error['code'])."<br>\n";
so it displays EVE error text and user doesn't have search for it.
Good work, but something that should do the samething without another api call, echo "Error Code: ".$error['code']."::".$error."\n"; More error handling is something I do want to improve on.
POS-Tracker 2.1.0 Hosting |

Chewie Soloh
SkillzKillz United For 0rder
|
Posted - 2008.03.04 12:53:00 -
[281]
Edited by: Chewie Soloh on 04/03/2008 13:03:39 When i got to yourserver.com or whatever (yes i replaced it with localhost and what not) it jsut ends up blank
|

Johnathan Roark
Caldari Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.04 15:56:00 -
[282]
Originally by: Chewie Soloh Edited by: Chewie Soloh on 04/03/2008 13:07:37 Edited by: Chewie Soloh on 04/03/2008 13:03:39 When i got to yourserver.com or whatever (yes i replaced it with localhost and what not) it jsut ends up blank
Step 6. Remove install.php, install2.php create_database.sql, and bigdump.php
I dont have either of those
Your reading the install directions for 2.0.94, look in the readme.txt file. I have no idea if it will work with localhost as the host name, It really depends on exactly how its setup.
POS-Tracker 2.1.0 Hosting |

Johnathan Walker
Caldari Templars of Space Black Star Alliance
|
Posted - 2008.03.05 06:51:00 -
[283]
Originally by: Johnathan Roark
In the user panel, click on the button that says "Update Corp/Alliance". I am guessing your alliance has changed since you've registered on the tracker.
This has no effect, and the corp/alliance info has not changed since installing and registering on the tracker.
Thanks for the suggestions; keep em coming :)
|

Natasha Russo
Ars ex Discordia GoonSwarm
|
Posted - 2008.03.14 20:45:00 -
[284]
Has anyone had trouble with updating towers from the API since the boost patch?
My last update was on 03/11/08. When I go to the Admin panel and select update from API, it runs and tells me Success, and then everything else just lists 0. It used to list all of the towers and their ID's and give me a total of 60 towers.
Did something change in the API that is causing the tower updates to fail but somehow still report success? Please advise...
|

Riu Stuka
GeoCorp. Paxton Federation
|
Posted - 2008.03.14 21:48:00 -
[285]
Same problem here. It tells me success but 0 towers updated. -----------------------------------------------
|

Kirk Hasselen
White Nova Industries Cosmic Anomalies
|
Posted - 2008.03.15 11:14:00 -
[286]
The API is down at the moment (last I checked before hotfix) have a look at most of the other API using programs for instance Eve Fitting tool. It's not a problem with the tracker.
|

Riu Stuka
GeoCorp. Paxton Federation
|
Posted - 2008.03.15 14:12:00 -
[287]
EveMon and EFT is working fine for me atm... only the POS in POSTracker doesnt update. Sov and Alliance update works fine, too in POSTracker. On POS update he states succesfull, no error like when the API was down. Just it does not updates the Towers. -----------------------------------------------
|

Rich Pickings
Malazan Research
|
Posted - 2008.03.15 14:27:00 -
[288]
Im getting the same 
|

Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.15 16:37:00 -
[289]
The POS API is broken. Its returning an non-api error. This is why the tracker is not telling you that it failed.
If you go to http://api.eve-online.com/corp/StarbaseList.xml.aspx?userID=youruserid&apiKey=yourapikey&characterID=yourcharacterid you will see an error page that says "Error Encountered
Sorry, you encountered a fatal error. Please contact the administrators about this if it continues." If you want to give ccp some encoragement on fixing it, file a petition.
POS-Tracker 2.1.0 Hosting |

Natasha Russo
Ars ex Discordia GoonSwarm
|
Posted - 2008.03.15 19:36:00 -
[290]
I have filed a petition. Let's see if that gets it fixed! *crosses fingers*
|

Marshall Knight
Ardent Industrial Hydra Alliance
|
Posted - 2008.03.17 23:25:00 -
[291]
This is a cool tool but im having problems this aint my strongest skill lol anyone able to posta copy of there mail.php postrackercron.sh and the other 2 files so i can see what needs editing and also a possible command for activating the cron job thanks in advance
|

XFranc
Lucian Alliance Arcane Alliance
|
Posted - 2008.03.19 14:43:00 -
[292]
Hi there,
Im having some strange errors at the moment and I cant tell if its down to the API or not .
When I run the Sov update - I get this :
Not a valid xml string
When I run the Alliance update - I get this :
atal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /path/pos/updateallianceinfo.php:25 Stack trace: #0 /path/pos/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /path/pos/updateallianceinfo.php on line 25
Any advice would be appreciated.
Thanks,
|

Ktor
Clan Shadow Wolf Sylph Alliance
|
Posted - 2008.03.19 16:09:00 -
[293]
Sov update worked today Alliance update worked today POS update Error: 309 |

Rich Pickings
Malazan Research
|
Posted - 2008.03.19 16:20:00 -
[294]
Error: 200 Error: 209 Success Towers Added: 0 Towers Updated: 0 Total Towers : 0
This is what i get when i do a pos update now and its been the same since the patch :(
|

Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.19 16:58:00 -
[295]
Originally by: XFranc Hi there,
Im having some strange errors at the moment and I cant tell if its down to the API or not .
When I run the Sov update - I get this :
Not a valid xml string
When I run the Alliance update - I get this :
atal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /path/pos/updateallianceinfo.php:25 Stack trace: #0 /path/pos/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /path/pos/updateallianceinfo.php on line 25
Any advice would be appreciated.
Thanks,
Try it again later. As for the complaints about the POS not updating, the POS API is broken and has been since the patch. This is something CCP will need to fix.
POS-Tracker 2.1.0 Hosting |

XFranc
Lucian Alliance Arcane Alliance
|
Posted - 2008.03.19 18:13:00 -
[296]
Thanks for getting back to me, however its been like this for a couple of weeks.
I recently moved host, but i have amended all of the necessary paths that I could find.
Today I reran the entire install, but still getting the error. All of the pre-install checks checked out ok as well.
Thanks,
|

Rich Pickings
Aliastra
|
Posted - 2008.03.20 17:05:00 -
[297]
Hello,
Please accept my sincere apologies for the delayed reply.
We are already aware of the starbase API currently not working and are looking into it to have it fixed as soon as possible. Please apologize the inconveniences caused by this problem.
Best regards,
EVE Online Customer Support
Reply from my petition
|

Research Rachel
Perkone
|
Posted - 2008.03.20 18:37:00 -
[298]
how longs it take to fix something which should be fairly simple? ffs
anyone noticed pos's in constellation sov not getting the sov 4 bonuses too? only spotted it today when fuel warnings started coming in.
c'mon ccp, get your act together... stop introducing pointless stuff like welcome pages and fixed the stuff thats broken!
|

Marshall Knight
Ardent Industrial Hydra Alliance
|
Posted - 2008.03.22 14:38:00 -
[299]
Hmm think i found a calculation bug. we havea complex reaction for Sylramic Fibers. The program is showing that it produces 3000 units a hour but actually it produces 6000 units. Anyone know what part of the program i can edit to fix this or has anyone else noticed this
thanks
Marshall
|

Research Rachel
Perkone
|
Posted - 2008.03.23 11:38:00 -
[300]
Originally by: Marshall Knight Hmm think i found a calculation bug. we havea complex reaction for Sylramic Fibers. The program is showing that it produces 3000 units a hour but actually it produces 6000 units. Anyone know what part of the program i can edit to fix this or has anyone else noticed this
thanks
Marshall
theres a few that seem wrong but you'll need to edit the database to correct them.
You need to look in material_static for Sylramic Fibers and you'll see material_id is 48
then in reaction_static, look up the matieral_id is 48 and change the material_produced to 6000.
Change any others the same way.
Can't help with an sql script cos it's not really my area.
|

P Stuyvesant
Persnickety Pilots
|
Posted - 2008.03.25 12:48:00 -
[301]
I am having trouble setting up small gallente towers in Postracker. When i look for the 'Optimum' fuel quantity, using the fuel calculator, it shows the optimum fuel quantity as 0 in all fields. is this a bug or am I doing something wrong? I am able to find the optimum fuel quantity on other towers, just not small gallente towers.
|

XFranc
Lucian Alliance Arcane Alliance
|
Posted - 2008.03.25 16:39:00 -
[302]
Originally by: XFranc Hi there,
Im having some strange errors at the moment and I cant tell if its down to the API or not .
When I run the Sov update - I get this :
Not a valid xml string
When I run the Alliance update - I get this :
atal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /path/pos/updateallianceinfo.php:25 Stack trace: #0 /path/pos/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /path/pos/updateallianceinfo.php on line 25
Any advice would be appreciated.
Thanks,
With the help of a friend we managed to resolve this by doing the following :
Removed this line from :
curl_setopt($ch, CURLOPT_POST, 1);
//Begins connecting to eve api
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); // curl_setopt($ch, CURLOPT_POST, 1); $counttotal = 0; $updatestotal = 0; $time = time();
TBH, I dont know why this fixed it, but thought I should share.
|

Johnathan Roark
Quantum Industries Interstellar Alcohol Conglomerate
|
Posted - 2008.03.26 16:55:00 -
[303]
Originally by: XFranc
TBH, I dont know why this fixed it, but thought I should share.
That really shouldn't have caused a problem, but Im guessing ccp changed something, as my install has started doing the same thing.
The POS api is now working again!
POS-Tracker 2.1.0 Hosting |

XFranc
Lucian Alliance Arcane Alliance
|
Posted - 2008.03.27 17:50:00 -
[304]
Phew, so it wasnt just me :D
|

La Vittoria
The Littlest Hobos Insurgency
|
Posted - 2008.03.28 09:38:00 -
[305]
When users are registering, seem to be getting the following error. I have not modified mail.php in anyway way so /me shrugs
Warning: mail() [function.mail]: SMTP server response: 501 <"POS TRACKER"<[email protected]>>: "@" or "." expected after ""POS TRACKER"" in C:\%pathhere%\functions.php on line 737
|

XFranc
Lucian Alliance Arcane Alliance
|
Posted - 2008.04.07 15:39:00 -
[306]
Heres a strange one, whenever I do a cron update - I get this error at the start of the mail :
could not get pos_info; Table '.pos_info' doesn't exist
|

Slayton Ford
|
Posted - 2008.04.09 07:39:00 -
[307]
Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1" --------------- This sig has been censored in fear of recieving the ban hammer... |

Slayton Ford
STK Scientific Black-Out
|
Posted - 2008.04.10 03:54:00 -
[308]
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
Turns out this is caused by a MySQL setting. --------------- This sig has been censored in fear of recieving the ban hammer... |

Zeoliter
Reikoku Band of Brothers
|
Posted - 2008.04.10 11:40:00 -
[309]
This has to be the most worthless piece of w@nk app coded for eve that I ever saw.
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.04.10 16:41:00 -
[310]
Originally by: La Vittoria When users are registering, seem to be getting the following error. I have not modified mail.php in anyway way so /me shrugs
Warning: mail() [function.mail]: SMTP server response: 501 <"POS TRACKER"<[email protected]>>: "@" or "." expected after ""POS TRACKER"" in C:\%pathhere%\functions.php on line 737
try changing line 731 to $headers = "From: ".SITE_EMAIL.">\r\n" . see if that works. Also check the actual email setting in your config. It should be just the email address.
Originally by: XFranc Edited by: XFranc on 07/04/2008 15:51:10 Heres a strange one, whenever I do a cron update of the Alliance info - I get this error at the start of the mail :
could not get pos_info; Table '.pos_info' doesn't exist
I can not find any refrences to pos_info in cron_updateallianceinfo.php, that was the old name of the the database table tower_info. What version are you running?
Originally by: Slayton Ford
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
Turns out this is caused by a MySQL setting.
Yes, you have strict mode on which is default for windows installations. I am still new when it comes to proper SQL. If anyone wants to volunteer to go through and fix all of the mistakes in the sql statements I would be happy, especially if you explained why it needed changing.
Originally by: Zeoliter This has to be the most worthless piece of w@nk app coded for eve that I ever saw.
Lets see yours?
POS-Tracker 2.1.0 Hosting |

Gorespawn
Caldari Galactic Fighter Syndicate
|
Posted - 2008.04.12 02:23:00 -
[311]
Hey, i am having a big issues here, i installed teh latest packagesa from your sourceforge mirror and was unable to install it. I tried it twice, steps doen were as follows:
1. unpacked 2. changed files from readme 3. uploaded 4 went to phpmyadmin, created database 5. added database info on the dist.php thingy 6. uploaded changed files 7. went to server/directory/install/install.php --> did see a normal header and a menue linking back to server/directory/install/login.php etc not server/directory/login.php ... did not see any installsteps went to install2.php - same thing.
Whats wrong or what am i doing wrong ? |

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.04.12 04:40:00 -
[312]
Originally by: Gorespawn Hey, i am having a big issues here, i installed teh latest packagesa from your sourceforge mirror and was unable to install it. I tried it twice, steps doen were as follows:
1. unpacked 2. changed files from readme 3. uploaded 4 went to phpmyadmin, created database 5. added database info on the dist.php thingy 6. uploaded changed files 7. went to server/directory/install/install.php --> did see a normal header and a menue linking back to server/directory/install/login.php etc not server/directory/login.php ... did not see any installsteps went to install2.php - same thing.
Whats wrong or what am i doing wrong ?
view source, see if there are any errors that aren't showing up. There isn't really anything in install.php that should cause any problems. Also, make sure config.dist.php is renamed to config.php. Another thing to check is if your host is set to display errors in php.ini.
POS-Tracker 2.1.0 Hosting |

Gorespawn
Caldari Galactic Fighter Syndicate
|
Posted - 2008.04.13 02:09:00 -
[313]
Originally by: Johnathan Roark
Originally by: Gorespawn [...]
view source, see if there are any errors that aren't showing up. There isn't really anything in install.php that should cause any problems. Also, make sure config.dist.php is renamed to config.php. Another thing to check is if your host is set to display errors in php.ini.
renaming the config file helped. |

S'if
|
Posted - 2008.04.13 20:04:00 -
[314]
Can someone give me the novice guide to setting up the cron process.
I have set up the scheduled task to run postrackercron.sh and poscron.sh. Is that correct? Do I need to edit those two files and if so what do I need to put in them? Whatever I've tried doesn't seem to be working so if someone can take the time to explain in detail what needs to be done it would be much appreciated.
|

XFranc
Caldari Lucian Alliance Arcane Alliance
|
Posted - 2008.04.14 15:42:00 -
[315]
Originally by: XFranc Edited by: XFranc on 07/04/2008 15:51:10 Heres a strange one, whenever I do a cron update of the Alliance info - I get this error at the start of the mail :
could not get pos_info; Table '.pos_info' doesn't exist
Quote:
I can not find any refrences to pos_info in cron_updateallianceinfo.php, that was the old name of the the database table tower_info. What version are you running?
Version that is linked in your starting post : 2.1.0
Could not get pos_info; Table 'dbname.pos_info' doesn't exist2008-04-14 17:00:02<br> Success<br> Systems Updated: 5382SELECT * FROM `pos2_alliance_info` WHERE `allianceID` = 824518128 LIMIT 1<br> SELECT * FROM `pos2
|

XFranc
Caldari Lucian Alliance Arcane Alliance
|
Posted - 2008.04.14 15:49:00 -
[316]
Originally by: S'if Can someone give me the novice guide to setting up the cron process.
I have set up the scheduled task to run postrackercron.sh and poscron.sh. Is that correct? Do I need to edit those two files and if so what do I need to put in them? Whatever I've tried doesn't seem to be working so if someone can take the time to explain in detail what needs to be done it would be much appreciated.
Ensure that the lines in postrackercron.sh
cd ~/<path to>/pos /usr/local/bin/php mail.php
and poscron.sh
cd ~/<path to>/pos /usr/local/bin/php cron_updatepos.php
all point correctly to your directories, and you will need to update the relevant lines in cron_updatesov.php,cron_updatepos.php and cron_updateallianceinfo.php as well
|

Revanom
Gallente Mentis Fidelis R-I-P
|
Posted - 2008.04.15 04:14:00 -
[317]
Hmm it says my sov data is out of date, when i click the button i get:
Not a valid xml string
When I try to update the alliance list I get:
Fatal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /home/nxtlevel/public_html/igb/postracker/updateallianceinfo.php:25 Stack trace: #0 /home/nxtlevel/public_html/igb/postracker/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /home/nxtlevel/public_html/igb/postracker/updateallianceinfo.php on line 25
any thoughts? CEO - Mentis Fidelis We are always recruiting! Check our recruiting post. |

XFranc
Caldari Lucian Alliance Arcane Alliance
|
Posted - 2008.04.15 19:32:00 -
[318]
Heres the fix mate :
Originally by: XFranc Hi there,
Im having some strange errors at the moment and I cant tell if its down to the API or not .
When I run the Sov update - I get this :
Not a valid xml string
When I run the Alliance update - I get this :
atal error: Uncaught exception 'Exception' with message 'String could not be parsed as XML' in /path/pos/updateallianceinfo.php:25 Stack trace: #0 /path/pos/updateallianceinfo.php(25): SimpleXMLElement->__construct('') #1 {main} thrown in /path/pos/updateallianceinfo.php on line 25
Any advice would be appreciated.
Thanks,
With the help of a friend we managed to resolve this by doing the following :
Removed this line from :
curl_setopt($ch, CURLOPT_POST, 1);
//Begins connecting to eve api
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); // curl_setopt($ch, CURLOPT_POST, 1); $counttotal = 0; $updatestotal = 0; $time = time();
TBH, I dont know why this fixed it, but thought I should share.
Hope this helps
|

Revanom
Gallente Mentis Fidelis R-I-P
|
Posted - 2008.04.15 22:05:00 -
[319]
The first problem of "not a valid xml string" still happens when I try to update sov... but alliance update now works CEO - Mentis Fidelis We are always recruiting! Check our recruiting post. |

XFranc
Caldari Lucian Alliance Arcane Alliance
|
Posted - 2008.04.16 15:09:00 -
[320]
Remove the same line in the updatesov.php
|

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.20 07:42:00 -
[321]
This might allready have been pointed out, but I couldn't find Complex Simple reactor arrays in the modules list and had to add these myself. Just a heads up for future release.
|

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.20 17:14:00 -
[322]
Nvm what I said, I saw that they just have other names.
|

Slayton Ford
STK Scientific Black-Out
|
Posted - 2008.04.21 04:39:00 -
[323]
Originally by: XFranc
Originally by: S'if Can someone give me the novice guide to setting up the cron process.
I have set up the scheduled task to run postrackercron.sh and poscron.sh. Is that correct? Do I need to edit those two files and if so what do I need to put in them? Whatever I've tried doesn't seem to be working so if someone can take the time to explain in detail what needs to be done it would be much appreciated.
Ensure that the lines in postrackercron.sh
cd ~/<path to>/pos /usr/local/bin/php mail.php
and poscron.sh
cd ~/<path to>/pos /usr/local/bin/php cron_updatepos.php
all point correctly to your directories, and you will need to update the relevant lines in cron_updatesov.php,cron_updatepos.php and cron_updateallianceinfo.php as well
Any suggestions for those of us running Windows boxes? --------------- This sig has been censored in fear of recieving the ban hammer... |

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.21 07:10:00 -
[324]
I'm getting this error messages sometimes when I run the cron job
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: Entity: line 21: parser error : Extra content at the end of the document in cron_updatepos.php on line 192
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: </eveapi><html> in cron_updatepos.php on line 192
Warning: SimpleXMLElement::__construct() [function.SimpleXMLElement---construct]: ^ in cron_updatepos.php on line 192 Not a valid xml stringCould not get tower_info; Lost connection to MySQL server during query
Sometimes it gets through without errors though. Any idea what the cause could be? I'm running PHP 5.2.5 with CURL, simpleXML and hash installed.
|

Tusseh
|
Posted - 2008.04.21 08:52:00 -
[325]
I was getting error 521 when trying to add an api key, so used the suggested edit to addapi.php from earlier in the thread which was as follows:
Quote:
# $ch = curl_init();
# curl_setopt($ch, CURLOPT_URL, $url); # curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); # curl_setopt($ch, CURLOPT_HEADER, false); # curl_setopt($ch, CURLOPT_POST, 1); # curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($data)); $url = "http://api.eve-online.com/account/Characters.xml.aspx?userid=".$userid."&apikey=".$apikey; if (!($contents = file_get_contents($url))){ exit; } $xml = new SimpleXMLElement($contents); # $xml = new SimpleXMLElement(curl_exec($ch)); # curl_close($ch);
That worked out fine, However when I try and do the update using the api key, I get error 521. Is there a fix or workaround for updatepos.php along the lines of what had to be done for addapi.php?
|

Jake Hunington
|
Posted - 2008.04.23 06:14:00 -
[326]
I've just setup a new hosted instance of the tracker and I keep getting "You do not have access, ask your CEO for access! If your access has been set, please relog back in to the website!", when I try to login after registering. Is there something else, after going into the database and manually setting the access value to 3, that's needed to get this first user to login?
Thanks, Jake
|

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.23 07:30:00 -
[327]
Originally by: Jake Hunington I've just setup a new hosted instance of the tracker and I keep getting "You do not have access, ask your CEO for access! If your access has been set, please relog back in to the website!", when I try to login after registering. Is there something else, after going into the database and manually setting the access value to 3, that's needed to get this first user to login?
Thanks, Jake
Login as user admin with the password you set when you installed the tracker, then go to the admin page and set the user roles there. |

XFranc
Caldari Lucian Alliance Arcane Alliance
|
Posted - 2008.04.23 08:07:00 -
[328]
Also - check that the user has the pos tracker in the IGB trusted sites.
I've seen this before when the trust hadnt applied properly. |

Jake Hunington
|
Posted - 2008.04.23 12:54:00 -
[329]
Originally by: XFranc Also - check that the user has the pos tracker in the IGB trusted sites.
I've seen this before when the trust hadnt applied properly.
You need to login via OGB with admin prior to using the IGB and setting up trusted sites, correct?
I've not registered any characters into the app yet, just still trying to get the "admin" user to login.
A post I found a long while back showed modifing the database for the user changing the access field value to 3 (the install set this value to 4). Is that not required anymore? I've reload three times since my orginal post and I'm getting stopped at this point each time.
The database appears correct, it has all the tables in it. Is there a permission issue somewhere possibly? I've set the whole web directory to read/write/execute for all users.
|

Apocalytica Insomnia
DarkSide Defenders
|
Posted - 2008.04.23 22:51:00 -
[330]
I today (after more then enough struggle, cause my Server runs an too old version of PHP) installed the SVN-Version of the POS tracker (i believe its 2.1). It works great and so far i found no real bugs yet.
However i have a question about the following feature i found in the Admin-pannel: "Install/Uninstall Regional Moons"
What does it do ? It links back to ./install/install3.php --------------------------- Apocalytica Insomnia DarkSide Defenders Accounting and More
|

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.24 16:27:00 -
[331]
Originally by: Apocalytica Insomnia I today (after more then enough struggle, cause my Server runs an too old version of PHP) installed the SVN-Version of the POS tracker (i believe its 2.1). It works great and so far i found no real bugs yet.
However i have a question about the following feature i found in the Admin-pannel: "Install/Uninstall Regional Moons"
What does it do ? It links back to ./install/install3.php
With it you can install (import) the regions with their data like systems, constellations and moons into your database. Having the sql data divided like this will prevent problems when importing files larger than 2mb.
I'm having troubles when I run the POS API script. Most of the time it gets through like it should, but sometimes I loose connection to the database. Could not get tower_info; Lost connection to MySQL server during query Could this be because it takes to long to execute the script? Sometimes I get other errors like I described here http://oldforums.eveonline.com/?a=topic&threadID=612970&page=11#324
Cheers
|

Shime
|
Posted - 2008.04.25 23:00:00 -
[332]
Edited by: Shime on 25/04/2008 23:00:23 Is there a way to use Pos tracker without a mailserver ??
I don"t have one and i cannot install it ... There is an error when trying to create the admin login/pass
|

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.27 12:24:00 -
[333]
I have a strange bug about optimal fuel levels on the editpos.php. The admin user can see the optimal levels with no problems, but other users sees the levels as 0 for all fuels for all our towers except faction towers. The towers we have are small and large gallente towers so I haven't been able to test this on amarr, minmatar or caldari towers though. Any idea why just the admin can see the optimal levels? I've been reading through the code but got stuck a bit.
|

Taraw
Amarr Dark Rising Shadow Executive Outcomes
|
Posted - 2008.04.28 16:35:00 -
[334]
Is the POS update api bugged? I get "Error Code: 200::Current security level not high enough" every time
|

Azure knight
|
Posted - 2008.04.28 23:05:00 -
[335]
just installed this and find the silos a bit confusing, is it possible to have this in there?
|

skilz
Amarr Dark Cartel
|
Posted - 2008.04.29 11:51:00 -
[336]
I would like to see a run cost calculator add on, any chance of that? --
|

Alaris Nightshadow
Caldari Finis Lumen Atlas Alliance
|
Posted - 2008.04.29 22:47:00 -
[337]
Originally by: Taraw Is the POS update api bugged? I get "Error Code: 200::Current security level not high enough" every time
You need to use the Full Access API Key, and the Character needs to be a Director or CEO to pull tower data from the API. ----------------------------------------------- "EVE isn't meant to look like a harsh, uncaring universe..........it is one..." |

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.04.30 10:03:00 -
[338]
Anyone else having problems with the alert mails you should get? It looks like mail.php is an older version and needs to be changed to work with the new databas.
|

Taraw
Amarr Dark Rising Shadow Executive Outcomes
|
Posted - 2008.04.30 15:18:00 -
[339]
Originally by: Alaris Nightshadow
Originally by: Taraw Is the POS update api bugged? I get "Error Code: 200::Current security level not high enough" every time
You need to use the Full Access API Key, and the Character needs to be a Director or CEO to pull tower data from the API.
The API works with the MyPOS application, but not with POS Tracker Beta 2 or 3.
|

MegabitOne
Caldari The Black Ops Black Core Alliance
|
Posted - 2008.05.02 10:39:00 -
[340]
Originally by: Taraw Edited by: Taraw on 30/04/2008 15:29:06
Originally by: Alaris Nightshadow
Originally by: Taraw Is the POS update api bugged? I get "Error Code: 200::Current security level not high enough" every time
You need to use the Full Access API Key, and the Character needs to be a Director or CEO to pull tower data from the API.
The API works with the MyPOS application, but not with POS Tracker Beta 2 or 3. I don't know if this is relevant: I'm using PHP 5.2.5 and MySQL 5 right now but it would be possible to use PHP 4 or MySQL 4
Maybe you're talking about another version, but retrieving POS info works as advertised. Just make sure you have the FULL api key from someone with a DIRECTOR role in your corp. The full key is necessary because CCP needs it and the director role is necessary to get the correct information.
I use POS-Tracker2, latest SourceForge version, rev. 127 at the time of writing. This version runs on the OpenSUSE 10.3 Linux O/S with an XAMPP web server installed and uses PostFix to send out the mails. Works like a charm.... |

skilzrulz
Gallente OneZeRO Enterprises
|
Posted - 2008.05.06 12:34:00 -
[341]
Originally by: skilz I would like to see a run cost calculator add on, any chance of that?
yes/no? |

skilzrulz
Gallente OneZeRO Enterprises
|
Posted - 2008.05.15 06:02:00 -
[342]
this thread dead?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.05.15 07:15:00 -
[343]
Originally by: skilzrulz
Originally by: skilz I would like to see a run cost calculator add on, any chance of that?
yes/no?
both, although it would not be very hard to do, and have considered adding it, I do not currently have the time or will to do it. I will probably go through and fix all the bugs i can find soon and take the 2.1 branch out of beta status. If anyone would like to contribute, a good place to start is by cleaning up the sql. I would rather not add any more features at this point.
POS-Tracker 2.1.0 Hosting |

Lillis85
Task Force Zener Atlas Alliance
|
Posted - 2008.05.15 12:14:00 -
[344]
What is the word on the low fuel warning mails the tracker should send out? I keep getting the error "No recipient addresses found in header" from the script. Have been trying to fix it, but can't see where the problem is. Any help please?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.05.16 05:28:00 -
[345]
Originally by: Lillis85 What is the word on the low fuel warning mails the tracker should send out? I keep getting the error "No recipient addresses found in header" from the script. Have been trying to fix it, but can't see where the problem is. Any help please?
Check your config file, there should be a setting in it for the tracker email.
POS-Tracker 2.1.0 Hosting |

Serraphym
|
Posted - 2008.05.18 18:07:00 -
[346]
Is there a way to stop the Fuel calculator from constantly calculating obscene amounts of strontium equal to whatever time period you attempt to refuel for? I realize its a minor thing, but stront is typically not adjusted until a tower is under siege. So if there is a way to disable it to actually get accurate m3 readings for refueling, someone please share :)
Perhaps a stront time calculator, and dis-including it from the actual normal fuel calculation.
|

p00ky
|
Posted - 2008.05.26 19:55:00 -
[347]
Hi All
great tool, but im still getting a few erros, when i setup a pos with silos and reactors i was getting the erros with the view pos page which i belive i managed to sort by setting my silos up but i still get this error:
Warning: Division by zero in /home/enigma27/public_html/pos/viewpos.php on line 251
Warning: Division by zero in /home/enigma27/public_html/pos/viewpos.php on line 251
Warning: Division by zero in /home/enigma27/public_html/pos/viewpos.php on line 240
Also on the tracker page i would like to add a small box with the actuall pos image icon which i have managed to do but dont know where to code it in, i used similar code for the reinforced icon but everything shifts right and doesnt line up?
|

Apocalytica Insomnia
DarkSide Defenders
|
Posted - 2008.06.02 05:20:00 -
[348]
Originally by: Lillis85 Edited by: Lillis85 on 27/04/2008 15:23:06 I have a strange bug about optimal fuel levels on the editpos.php. The admin user can see the optimal levels with no problems, but other users sees the levels as 0 for all fuels for all our towers except faction towers. The towers we have are small and large gallente towers so I haven't been able to test this on amarr, minmatar or caldari towers though. Any idea why just the admin can see the optimal levels? I've been reading through the code but got stuck a bit.
EDIT Nvm, I realized that fuel capcity and stront capcity was at 0 in the sovereignty_static table for gallente, minmatar and caldari race. When edited with correct numbers it works :)
I changed it in the Soverinty_Statistic table.
However, shortly after it was set to 0 again. --------------------------- Apocalytica Insomnia DarkSide Defenders Accounting, Banking, Brokering, Middleman. |

Flybye
|
Posted - 2008.06.02 19:22:00 -
[349]
Hi,
I'm not too familiar with PHP and have a simple question.
On this line: define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/');
I see several ' ' where I can place my url. Exactly how should this line look using www.myurl.com as an example?
|

Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.03 06:05:00 -
[350]
Originally by: Flybye Hi,
I'm not too familiar with PHP and have a simple question.
On this line: define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/pos/');
I see several ' ' where I can place my url. Exactly how should this line look using www.myurl.com as an example?
it detects the host name, you just need to change the last part '/pos/' to reflect the exact folder where you intall it, so if your tracker is installed at http://www.myrul.com/postracker/, you need to change that line to define('REDIRECT_PATH', 'http://'.$_SERVER['HTTP_HOST'].'/postracker/');
POS-Tracker 2.1.0 Hosting |

Apocalytica Insomnia
DarkSide Defenders
|
Posted - 2008.06.03 13:54:00 -
[351]
Edited by: Apocalytica Insomnia on 03/06/2008 13:56:34 Which reminds me to ask:
firstof all, in teh *********.sh files, i need to change the part, does this need to be the path where teh file is located at ?
I have no clue how to setup the cronjob. I'm using a Plesk-admin-software on my Server, so i now need to add following values:
Minute Hour Day of teh Month month day of teh week and command, (which is obviously teh path top teh ****.sh file.
Now lets say i need to add a chronjob to run every hour at xx:21 and i need one to run one at 15:19 every day, how would i go about this ?
Also, since i'm already posting, i'm wondering if there is away to "get rit" of having to add all teh modules for fuel calculations to get CPU/Pg values.
While this might be a nice idea, and good for players running only minimal posses, it gets kinda stressfull if your managing alot of posses and justtakes long.
Thanks in advance.
--------------------------- Apocalytica Insomnia DarkSide Defenders Accounting, Banking, Brokering, Middleman. |

Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.04 05:00:00 -
[352]
Originally by: Apocalytica Insomnia Edited by: Apocalytica Insomnia on 03/06/2008 13:56:34 Which reminds me to ask:
firstof all, in teh *********.sh files, i need to change the part, does this need to be the path where teh file is located at ?
It needs the absolute path of that file on your server, this has very little to do with the url.
Originally by: Apocalytica Insomnia
I have no clue how to setup the cronjob. I'm using a Plesk-admin-software on my Server, so i now need to add following values:
Minute Hour Day of teh Month month day of teh week and command, (which is obviously teh path top teh ****.sh file.
Now lets say i need to add a chronjob to run every hour at xx:21 and i need one to run one at 15:19 every day, how would i go about this ?
it varies with the admin software your host is running, i would look it up in its documentation.
Originally by: Apocalytica Insomnia
Also, since i'm already posting, i'm wondering if there is away to "get rit" of having to add all teh modules for fuel calculations to get CPU/Pg values.
While this might be a nice idea, and good for players running only minimal posses, it gets kinda stressfull if your managing alot of posses and justtakes long.
Thanks in advance.
Although it is posible, it would need several code changes to do this. In the SVN version, it also supports some import and export functions that work with another pos program called MyPOS.
POS-Tracker 2.1.0 Hosting |

Apocalytica Insomnia
DarkSide Defenders
|
Posted - 2008.06.04 10:35:00 -
[353]
Edited by: Apocalytica Insomnia on 04/06/2008 10:37:49 Some more issues i came across sofar, using SNV Values:
* Cyno Generators and Cyno Jammers dont show any CPU values wether or not online/offline, tho its correctly in the pos_Static Table. * Outpost fuel tracking does not generate the right values for Liquid Ozone correctly. i dunno how it gets do its values, but my fully loaded posses dont take 32 LO per tick in total, thats for sure * People can not register em selfes nemore using SVN-Code. they get to a blank page, that shows no errors.
In regards to MYPos, its a big improvement and help over teh standard capabilities, however, it's still a pain in the ass when having like 30 different posses. --------------------------- Apocalytica Insomnia DarkSide Defenders Accounting, Banking, Brokering, Middleman. |

KIAEnIgMa
KIA Corp KIA Alliance
|
Posted - 2008.06.15 20:12:00 -
[354]
Hey all,
Anyone know what error 213 is when trying to update from API? Since EA came out i cant use pos tracker anymore to update pos's
|

KIAEnIgMa
KIA Corp KIA Alliance
|
Posted - 2008.06.15 20:18:00 -
[355]
sorry i meant error 203 above
|

KIAEnIgMa
KIA Corp KIA Alliance
|
Posted - 2008.06.15 20:22:00 -
[356]
and i get this when trying to add a new api
Error: 214 Corporation is not part of alliance.Could not update api; 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 '1' at line 1
|

Gruntballs
|
Posted - 2008.06.16 15:32:00 -
[357]
Edited by: Gruntballs on 16/06/2008 15:35:02 I have this same problem as KIAEnIgMa
|

Gruntballs
|
Posted - 2008.06.16 16:01:00 -
[358]
Well I found out that the offending line in addapi.php was this line
//Update api info $sql = "UPDATE `".TBL_PREFIX."eveapi` SET `apikey` = '".my_escape($_POST['apikey'])."', `corp` = '".my_escape($_POST['corp'])."', `corpID` = '".my_escape($_POST['corpID'])."', `alliance` = '".my_escape($alliance['name'])."', `allianceID` = '".my_escape($alliance['id'])."' WHERE `".TBL_PREFIX."eveapi`.`characterID` =".my_escape($_POST['characterID'])."LIMIT 1;"; $result = mysql_query($sql) or die('Could not update api; ' . mysql_error());
What I did was put a space in next to " LIMIT 1;"; so it will look like this
//Update api info $sql = "UPDATE `".TBL_PREFIX."eveapi` SET `apikey` = '".my_escape($_POST['apikey'])."', `corp` = '".my_escape($_POST['corp'])."', `corpID` = '".my_escape($_POST['corpID'])."', `alliance` = '".my_escape($alliance['name'])."', `allianceID` = '".my_escape($alliance['id'])."' WHERE `".TBL_PREFIX."eveapi`.`characterID` =".my_escape($_POST['characterID'])." LIMIT 1;"; $result = mysql_query($sql) or die('Could not update api; ' . mysql_error());
|

Gruntballs
|
Posted - 2008.06.16 16:04:00 -
[359]
Edited by: Gruntballs on 16/06/2008 16:04:56 Now I get this error when trying to update alliances and poses
Catchable fatal error: Object of class __PHP_Incomplete_Class could not be converted to string in <web_dir>/pos/track.php on line 65
This is what is in track.php on line 65
$where_statement = "WHERE ".TBL_PREFIX."tower_info.corp = '" . $_SESSION['corp'] . "' AND ".TBL_PREFIX."tower_info.secret_pos = 0" ;
|

Gruntballs
|
Posted - 2008.06.16 16:24:00 -
[360]
Well I found out about this php 5.2.x you are going to get the above error See link PHP link to error
Looking for a way to solve this.
|

Gruntballs
|
Posted - 2008.06.17 21:14:00 -
[361]
It happened again on me. It looks like if the sesson is up for too long then I get that error.
|

DeTox MinRohim
Madhatters Inc. Pure.
|
Posted - 2008.06.24 14:27:00 -
[362]
Edited by: DeTox MinRohim on 24/06/2008 14:35:56 Is this project still alive?
Just wondering as I made myself a lot of modifications over time. I don't remember exactly wich version I took (v2 that's sure but I didn't follow SVN).
Database optimisation (ADODB) Templated the major pages (Smarty) Code Optimisation/Fix HTML tidy
Few screenies (Templated pages) : http://eve.onewayweb.com/images/shots/pos/index.html
Could take a while to clean my mess though before shooting this in the public. ------ This sig space is Read-only ! omgalink - Online Skillsheet |

Frendor
|
Posted - 2008.06.25 11:28:00 -
[363]
Edited by: Frendor on 25/06/2008 11:32:47 I've just had a look through the "install_database.sql" within the install folder (POS-Tracker2.1.0beta2\install) and found all 11 advanced material values are wrong!
The last 11 entries under "Dumping data for table `pos2_reaction_static`" should read...
INSERT INTO `pos2_reaction_static` VALUES (20, 40, 10000, 22, 100, 24, 100, 0, 0, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (21, 41, 200, 21, 100, 33, 100, 25, 100, 28, 100);
INSERT INTO `pos2_reaction_static` VALUES (22, 42, 10000, 22, 100, 26, 100, 0, 0, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (23, 43, 400, 29, 100, 30, 100, 33, 100, 27, 100);
INSERT INTO `pos2_reaction_static` VALUES (24, 44, 3000, 22, 100, 32, 100, 0, 0, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (25, 45, 750, 39, 100, 36, 100, 25, 100, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (26, 46, 1500, 37, 100, 32, 100, 31, 100, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (27, 47, 2200, 35, 100, 21, 100, 39, 100, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (28, 48, 6000, 22, 100, 29, 100, 0, 0, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (29, 49, 10000, 35, 100, 38, 100, 0, 0, 0, 0);
INSERT INTO `pos2_reaction_static` VALUES (30, 50, 10000, 37, 100, 34, 100, 0, 0, 0, 0);
------------------------------------------------
The 3rd value in each of the above were incorrect, if we take the first line has an example it was reading.
INSERT INTO `pos2_reaction_static` VALUES (20, 40, 5000, 22, 100, 24, 100, 0, 0, 0, 0);
The correct value should be
INSERT INTO `pos2_reaction_static` VALUES (20, 40, 10000, 22, 100, 24, 100, 0, 0, 0, 0);
The above example is for Crystalline Carbonide which produces 10,000 units an hour not 5,000
Hope this helps you.
Another problem I seem to be having is that the Silos don't take into account that they have a 100% storage bonus when used with Gallente towers, is there something within the 'install_database.sql' that can be changed to alter this, or I'm I missing something here?
Another problem that's been mentioned within this thread already is that a silo can't be an input and an output silo at the same time. I.e
Harvester--->Simple reactor--->Silo--->Complex reactor. Silo----------/
in the above example the silo receives 200 Crystallite Carbons per hour and the Complex Reactor uses 100 Per hour. The 100 that are stored are shipped off at a later date to be used in another reaction, but because the silo can't be and input and an output it always incorrectly reports the amounts. Last I read was that the silos are going to be re-worked... Any news?
Frendor.
|

Konosbe
|
Posted - 2008.06.25 13:47:00 -
[364]
Please make the download available as .tar.gz or bz2
RAR hurts my "lunax skillz".
Thanks, - K
|

Johnathan Roark
Quantum Industries RAZOR Alliance
|
Posted - 2008.06.25 16:38:00 -
[365]
Originally by: DeTox MinRohim Edited by: DeTox MinRohim on 25/06/2008 12:46:05 Is this project still alive?
Just wondering as I made myself a lot of modifications over time. I don't remember exactly wich version I took (v2 that's sure but I didn't follow SVN).
Database optimisation (ADODB) Templated the major pages (Smarty) Code Optimisation/Fix HTML tidy Various modifications (Silo ouput links for example)
Few screenies (Templated pages) : http://eve.onewayweb.com/images/shots/pos/index.html
Could take a while to clean my mess though before shooting this in the public.
Id like to see your changes and possibly work them into the current svn version.
Originally by: Frendor Edited by: Frendor on 25/06/2008 11:32:47 I've just had a look through the "install_database.sql" within the install folder (POS-Tracker2.1.0beta2\install) and found all 11 advanced material values are wrong!
CCP changed the outputs and I never got around to updating this. Samething with the silo re-work, requires more time then I have for it right now. Silos are currently hardcoded to 20,0000 m3 of space. I was intending to change this to be stored in the database. If all your towers are the same, you can change it in viewpos.php on line 229.
Originally by: Konosbe Please make the download available as .tar.gz or bz2
RAR hurts my "lunax skillz".
Thanks, - K
I'll keep that in mind next time I actually put together a download package, but right now, your better off using SVN.
POS-Tracker 2.1.0 Hosting |

DeTox MinRohim
Madhatters Inc. Pure.
|
Posted - 2008.06.25 17:05:00 -
[366]
Edited by: DeTox MinRohim on 25/06/2008 17:06:33
Originally by: Johnathan Roark
Id like to see your changes and possibly work them into the current svn version.
As I've said, need to clean my mess but to give an example of the end result template:
http://eve.onewayweb.com/images/shots/pos/track.tpl
------ This sig space is Read-only ! omgalink - Online Skillsheet |

DeTox MinRohim
Madhatters Inc. Pure.
|
Posted - 2008.06.27 07:41:00 -
[367]
Just to let you know that while I was cleaning my stuff and going through the parts I did not worked on yet... well... I'll be honest, it's almost a complete rewrite. Putting it in your SVN wouldn't do much good except making a separate branch or you wouldn't see much left of the original at the end of the process.
I might be able to finish today so I'll put it in my own SVN when done and shout here. I made it as a v3.0. I'm not particurlarly interested in supporting a fork of some sort so it'll be your call when it's up. Especially since I removed some stuff like outposts management or didn't put a big deal in the owner things.
Anyway... soon. I'll keep you posted.
------ This sig space is Read-only ! omgalink - Online Skillsheet |

Natasha Russo
Caldari
|
Posted - 2008.07.09 18:14:00 -
[368]
DeTox: any update on your fork? I'd be interested in taking a look at the changes/improvements you've made to the POS Tracker app.
|

DeTox MinRohim
Madhatters Inc. Pure.
|
Posted - 2008.07.10 16:34:00 -
[369]
Originally by: Natasha Russo DeTox: any update on your fork? I'd be interested in taking a look at the changes/improvements you've made to the POS Tracker app.
Yes, I'd say my part is done in a way. Johnathan contacted me and he is actually putting his fingers in it to re-add some functions I didn't bother rewriting (Outpost stuff for example, a bit more security level checks, etc.).
I'll get in touch with him tonight (if he's online and I have time) to see how it goes after this. He had an idea on how to get this out in the open, I'm ok with it.
1 thing sure: It's a v3.0 
------ This sig space is Read-only ! omgalink - Online Skillsheet |

Natasha Russo
Caldari
|
Posted - 2008.07.12 17:38:00 -
[370]
DeTox, good to hear. I'll be watching this thread for any updates.
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.07.23 07:18:00 -
[371]
POS-Tracker 3.0.0 Beta 1 Somethings to keep in mind with this new release: Its not directly compatible with 2.x. I suggest using a fresh install then importing your fittings using the fit import/export. I do not expect to have a need to change the database again, but it could happen. The devs have not released an offical eve database dump, so Black Rise is missing.
The outpost and alert mails are not in yet. I will try to get them done sometime in the next few weeks.
If you find any bugs, post them in this thread. I would also like hear about any features, fixes, mods, templates, etc. Please contact me if you have any of those.
P.S - If anyone is good at making images, I would like an official POS-Tracker banner to place at the top.
POS-Tracker 2.1.0 Hosting |

Audrea
Veto. Veto Corp
|
Posted - 2008.07.23 12:23:00 -
[372]
I never have installed php sql stuff like that..
Is it possible to relatively easily install it on some free webhosting that offers sql and php support? without console access, cron etc?
|

Gilgamoth
Eldritch Storm The Matari Consortium
|
Posted - 2008.07.23 12:26:00 -
[373]
Nice to see this project is still being advanced, however is it worth locking this and starting a new thread?
Regards,
Gil
Live on Eden Underground Radio every Wednesday 19:00 - 21:00 GMT. |

p00ky
|
Posted - 2008.07.23 20:22:00 -
[374]
Hi
Can you help with a couple of errors im gtting.
when i try and update via API i get this error ERROR Failed to update tower info ; Unknown column 'onlineSince' in 'field list'
and i cant update any towers. any idea whats causing that?
Also on the production screen i get this error
Warning: Smarty error: math: parameter y is empty in /home/enigma27/public_html/posbeta/includes/Smarty/Smarty.class.php on line 1088
this is all beta 3 btw.
|

p00ky
|
Posted - 2008.07.23 23:59:00 -
[375]
actually scrap the above i sorted all that.
My only other question is on the tracker page can you sort the towers by system order rather than the order in which run out of fuel?
|

Halada
Caldari Lone Star Joint Venture Wildly Inappropriate.
|
Posted - 2008.07.24 06:57:00 -
[376]
might want to update install notes, they dont match with current config files! 
★ LSJV now recruiting ★ |

Ai Sakura
|
Posted - 2008.07.24 19:48:00 -
[377]
Edited by: Ai Sakura on 24/07/2008 19:48:46 [Thu Jul 24 20:41:06 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125, referer: http://pos.xxx.co.uk/install.php?step=2 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Use of undefined constant cache - assumed 'cache' in C:\\Server\\HTTPD\\pos\\eveconfig\\config.php on line 8 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined variable: mod in C:\\Server\\HTTPD\\pos\\index.php on line 7 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: shorturls in C:\\Server\\HTTPD\\pos\\includes\\eveRender.class.php on line 122 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: access in C:\\Server\\HTTPD\\pos\\includes\\eveclass.php on line 277 [Thu Jul 24 20:41:53 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125
Win2k3, Apache 2, PHP 5.2.6
This happens when getting to Step 3 (After entering the email/password)
|

Princess Morenta
Minmatar Republic Military School
|
Posted - 2008.07.24 22:53:00 -
[378]
Edited by: Princess Morenta on 24/07/2008 22:54:48 Meh
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.07.25 06:18:00 -
[379]
Originally by: p00ky actually scrap the above i sorted all that.
My only other question is on the tracker page can you sort the towers by system order rather than the order in which run out of fuel?
Yes, comment line 112 out in track.php with // in front of it. Line 112 looks like
array_multisort($sortAarr, SORT_ASC, $rows);
What was causing your above issue?
Originally by: Ai Sakura Edited by: Ai Sakura on 24/07/2008 19:48:46 [Thu Jul 24 20:41:06 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125, referer: http://pos.xxx.co.uk/install.php?step=2 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Use of undefined constant cache - assumed 'cache' in C:\\Server\\HTTPD\\pos\\eveconfig\\config.php on line 8 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined variable: mod in C:\\Server\\HTTPD\\pos\\index.php on line 7 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: shorturls in C:\\Server\\HTTPD\\pos\\includes\\eveRender.class.php on line 122 [Thu Jul 24 20:41:18 2008] [error] [client 192.168.1.254] PHP Notice: Undefined index: access in C:\\Server\\HTTPD\\pos\\includes\\eveclass.php on line 277 [Thu Jul 24 20:41:53 2008] [error] [client 192.168.1.254] PHP Fatal error: Call to undefined method eveRender::RedirectUrl() in C:\\Server\\HTTPD\\pos\\install.php on line 125
Win2k3, Apache 2, PHP 5.2.6
This happens when getting to Step 3 (After entering the email/password)
I have no idea why this hasn't shown up with anyone else, but line 125 in install.php should look like the following:
$eve->RedirectUrl('install.php?step=2');
Originally by: Audrea I never have installed php sql stuff like that..
Is it possible to relatively easily install it on some free webhosting that offers sql and php support? without console access, cron etc?
I intend on changing the install process some so ill probably redo it anyway.
POS-Tracker 2.1.0 Hosting |

Ai Sakura
|
Posted - 2008.07.26 18:40:00 -
[380]
Edited by: Ai Sakura on 26/07/2008 18:41:43 Line 123: if ($dbconn->ErrorNo() != 0) { Line 124: $eve->SessionSetVar('errormsg', $dbconn->ErrorMsg() . '<br />' . $query); Line 125: $eveRender->RedirectUrl('install.php?step=2');
Alot of the SQL though is quite screwed on MySQL 5.0 Windows, Cant save API key without modifying the query or adding it manually, A copuple of the regions have --- $id -- instead of -- $id -- that affects the import..
Changing Line 125 works but next page displays: Field 'alliance_id' doesn't have a default value And brings up the list of regions to install.. Alot of the SQL problems seem to stem from the lack of the default value..
|

Halada
Caldari Lone Star Joint Venture Wildly Inappropriate.
|
Posted - 2008.07.31 01:24:00 -
[381]
API is broken... Im using 3.0.0beta1 , registered my char in game, added full API, update... says its successful but adds nothing at all.
I'm CEO of the corp...
Am I missing something, is it just not working?
★ LSJV now recruiting ★ |

DeTox MinRohim
Madhatters Inc. Pure.
|
Posted - 2008.07.31 10:54:00 -
[382]
Hello peeps,
Sorry I didn't give my inputs lately and helped John on the debugging process of this new beta release, I'm on the other side of the planet in vacation far far away from any computers... I'll be back around August 20 and help on all that.
Please remember that it's totally beta, that John has to go through many coding lines he didn't write (and I know it can be a pain reading code not yours) so be easy on him. 
Scanning fast from what I could get, the error of $eve->Redirect is the result of a forgotten line in the install file.
After line 69 wich should be : if (empty($query)) { continue; } There should be this: $query = str_replace("%prefix%", TBL_PREFIX, $query); // Need a more dynamic way.
The redirect error of step 3 will resolve itself.
(Or you can grab the file here)
Seems that whatever you put as login on the install process, the first login is still Admin... That would be something to fix.
The rest was doing ok on my laptop till the administration but this laptop didn't have curl so couldn't go further before getting bitten by the mosquitoes reminding me that I'm stealing the connection from some old folks nearby my tent... And... they scare me at night.
Back in 20 days.
------ This sig space is Read-only ! omgalink - Online Skillsheet |

Brunnis Jetrel
Gallente Shining Horses Black Sun Alliance
|
Posted - 2008.07.31 13:16:00 -
[383]
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
I get a similar error whilst doing exactly the same, my error is:
ERROR Failed to update tower_info; Incorrect integer value: '' for column 'charters' at row 1"
|

Clone 985
|
Posted - 2008.08.01 16:11:00 -
[384]
Originally by: Brunnis Jetrel
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
I get a similar error whilst doing exactly the same, my error is:
ERROR Failed to update tower_info; Incorrect integer value: '' for column 'charters' at row 1"
I managed to sort this out. Went into the My SQL config and disabled 'Strict Mode', and hey presto, it works great.
BTW - This is a truly awesome tool 
|

Shime
|
Posted - 2008.08.02 04:08:00 -
[385]
Edited by: Shime on 02/08/2008 04:14:41 Edited by: Shime on 02/08/2008 04:12:44 Hello,
must we import old datas to a new database ? because same as Halada, when i'm trying to update with API, system says that's ok, but nothing was import and track is still empty.
i import pos_tower_info database into a new, now i see all tower, but API don"t work, nothing is updated.
And no error message too
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.02 05:08:00 -
[386]
Originally by: Clone 985
Originally by: Brunnis Jetrel
Originally by: Slayton Ford Setting the tracker up from scratch. when I try to update POS from API, i get "Could not insert values into tower_info; Incorrect integer value: 'NULL' for column 'pos_id' at row 1"
I get a similar error whilst doing exactly the same, my error is:
ERROR Failed to update tower_info; Incorrect integer value: '' for column 'charters' at row 1"
I managed to sort this out. Went into the My SQL config and disabled 'Strict Mode', and hey presto, it works great.
BTW - This is a truly awesome tool 
Yea, Windows mysql servers have strict mode turned on by default, Its on the list of things to do to make it work in strict mode.
Originally by: Shime Edited by: Shime on 02/08/2008 04:20:12 Edited by: Shime on 02/08/2008 04:14:41 Edited by: Shime on 02/08/2008 04:12:44 Hello,
must we import old datas to a new database ? because same as Halada, when i'm trying to update with API, system says that's ok, but nothing was import and track is still empty.
i import pos_tower_info database into a new, now i see all tower, but API don"t work, nothing is updated.
Correction : Alliance list and Sov works with API. But not the POS import position and fuel. And no error message too
When you try to import your pos via api, what do you see? Does it display the main admin page where you have buttons to import or do you get something like the folowing: Administration
Success Total Number of POS Added: Total Number of POS Updated: Total POSes updated from API:
Done
Towers List:
FYI, im currently building updated tables using the new EA eve data dump.
POS-Tracker 2.1.0 Hosting |

Shime
|
Posted - 2008.08.02 14:31:00 -
[387]
When update POS :
Administration
Success Total Number of POS Added: Total Number of POS Updated: Total POSes updated from API:
Done
Towers List:
--> Tower list is empty and of course Track link too. Same in Sql.
|

Mastah Mazoku
|
Posted - 2008.08.02 14:51:00 -
[388]
Same problem for me, the update POS via API KEY isn't working.
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.02 18:49:00 -
[389]
Edited by: Johnathan Roark on 02/08/2008 18:49:11 Is the api key owned by a director or the ceo? is it a full key? is the key and userid in the database properly? are you running on apache or something else? Windows, Linux or something else?
POS-Tracker 2.1.0 Hosting |

Shime
|
Posted - 2008.08.02 19:12:00 -
[390]
Originally by: Johnathan Roark Edited by: Johnathan Roark on 02/08/2008 18:49:11 Is the api key owned by a director or the ceo? is it a full key? is the key and userid in the database properly? are you running on apache or something else? Windows, Linux or something else?
Ok strange things, i create a new full key api and thats work. Don"t understand why O_o My old key was a full key director .....
Well seems ok
|

Shime
|
Posted - 2008.08.02 19:58:00 -
[391]
Edited by: Shime on 03/08/2008 00:00:39 Some functions don"t seem to work :
import fitting Warning: require_once(config.php) [function.require-once]: failed to open stream: No such file or directory in /pos/importfit.php on line 2 Fatal error: require_once() [function.require]: Failed opening required 'config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /pos/importfit.php on line 2
Sov status : Don't work. when do an edit on a POS we can see : Sovereignty: Yes Sovereignty Status: Hostile --> Or thats wrong we have sov.
And how to add an outpost and do you plan to add "Owner" ?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.03 10:48:00 -
[392]
Originally by: Shime
import fitting Warning: require_once(config.php) [function.require-once]: failed to open stream: No such file or directory in /pos/importfit.php on line 2 Fatal error: require_once() [function.require]: Failed opening required 'config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /pos/importfit.php on line 2
its been corrected in the svn, it will be correct in the next release, which will be done after I get some sleep. old version got in that release :(
Originally by: Shime
Sov status : Don't work. when do an edit on a POS we can see : Sovereignty: Yes Sovereignty Status: Hostile --> Or thats wrong we have sov.
If your logged in as admin, then yea, it will show up like that.
Originally by: Shime
And how to add an outpost and do you plan to add "Owner" ?
Most of the owner stuff is already in, it just needs enabled along with the code to change it. I will work on getting all the owner stuff enabled and working for the beta3 release. Outpost stuff is also mostly done, but probably wont be activated until the beta4 or 5 release.
For the upcoming release, it be updated for Black Rise. I just need to check one more table. Also, I've updated the email alert system so it should work a lot better. I've fixed some bugs as well.
POS-Tracker 2.1.0 Hosting |

Ai Sakura
|
Posted - 2008.08.03 20:23:00 -
[393]
Originally by: Johnathan Roark
Originally by: Shime
import fitting Warning: require_once(config.php) [function.require-once]: failed to open stream: No such file or directory in /pos/importfit.php on line 2 Fatal error: require_once() [function.require]: Failed opening required 'config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /pos/importfit.php on line 2
its been corrected in the svn, it will be correct in the next release, which will be done after I get some sleep. old version got in that release :(
Originally by: Shime
Sov status : Don't work. when do an edit on a POS we can see : Sovereignty: Yes Sovereignty Status: Hostile --> Or thats wrong we have sov.
If your logged in as admin, then yea, it will show up like that.
Originally by: Shime
And how to add an outpost and do you plan to add "Owner" ?
Most of the owner stuff is already in, it just needs enabled along with the code to change it. I will work on getting all the owner stuff enabled and working for the beta3 release. Outpost stuff is also mostly done, but probably wont be activated until the beta4 or 5 release.
For the upcoming release, it be updated for Black Rise. I just need to check one more table. Also, I've updated the email alert system so it should work a lot better. I've fixed some bugs as well.
Getting same blank tower API update - Full access key as a director..
Also you are using the sourceforge SVN? Last update was 11 days ?
|

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.03 23:04:00 -
[394]
I just updated the svn and did a new release. Normally I update while fixing, but wanted to do some testing on it as a single package.
I've started a new thread for the 3.0.0 BranchPOS-Tracker 3.0.0 Please use it from this point on.
POS-Tracker 2.1.0 Hosting |

Natasha Russo
Caldari
|
Posted - 2008.08.04 03:00:00 -
[395]
Originally by: Shime Edited by: Shime on 03/08/2008 00:00:39 Sov status : Don't work. when do an edit on a POS we can see : Sovereignty: Yes Sovereignty Status: Hostile --> Or thats wrong we have sov.
You can fix your admin account to show Sov as being friendly. Just go into your database under the pos2_user table. Select your admin character and edit the sql. All you have to do is enter your alliance_id (copy this from one of the actual player characters) and logout/login admin and towers will show Sov Status of friendly and the fuel calculator will apply the correct Sov related fuel bonuses.
|

Kendolph
Caldari Bulgarian Mafia Squad Sons of Tangra
|
Posted - 2008.08.22 01:01:00 -
[396]
Edited by: Kendolph on 22/08/2008 01:03:57 moved to other thread ;)
|

CasC
Gallente Obsidian Angels Corporation
|
Posted - 2008.08.24 16:35:00 -
[397]
Edited by: CasC on 24/08/2008 16:36:15 Im in abit of a pickle here, everytime i try to add a structure to the POS i just setup i get That doesnt work; Duplicate entry '61' for key 1 Atm i have NO structures on that POS.
Anyone know why? ---------------------------------------------
Watching PvP in EVE is like watching a horde of blindfolded Monkeys in heat trying to have sex - |

Johnathan Roark
Caldari Quantum Industries RAZOR Alliance
|
Posted - 2008.08.24 16:52:00 -
[398]
Originally by: CasC Edited by: CasC on 24/08/2008 16:36:15 Im in abit of a pickle here, everytime i try to add a structure to the POS i just setup i get That doesnt work; Duplicate entry '61' for key 1 Atm i have NO structures on that POS.
Anyone know why?
the correct thread, you'll find your answer there
POS-Tracker 2.1.0 Hosting |

JitFodder
|
Posted - 2008.08.26 00:26:00 -
[399]
Tet
|
|

CCP WeatherMan
C C P

|
Posted - 2008.08.26 05:29:00 -
[400]
locked as per the OP's request
WeatherMan Community Representative EVE Online, CCP Games Email/Netfang
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 .. 14 :: [one page] |