open All Channels
seplocked Science and Industry
blankseplocked POS-Tracker 2.0.94/2.1.0 Beta 2
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5 6 7 8 9 ... : last (14)

Author Topic

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2007.10.13 03:52:00 - [1]
 

Edited by: Johnathan Roark on 30/01/2008 20:04:42
Edited by: Johnathan Roark on 03/01/2008 17:34:49

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

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, use 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

Mr Krosis
Gallente
The humble Crew
Posted - 2007.10.13 06:52:00 - [2]
 

Very Happy

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.

Klepto Narg
Ascent of Ages
Cosmic Anomalies
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
Mentis Seorsum
Posted - 2007.10.13 14:27:00 - [4]
 

Edited by: franny on 13/10/2007 14:49:43
much better now Very Happy

err, is it just me or with the
$sql = "SELECT * FROM `evenames` WHERE itemName LIKE '" . my_escape($systemName) . $echo . "'";

does it pull in every moon, regardless of system
makes for a very long list

Kivva
Pator Tech School
Posted - 2007.10.13 15:46:00 - [5]
 

Edited by: Kivva on 13/10/2007 16:29:39
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)

EDIT: Nevermind, I'm an idiot and should learn to read the full OP before opening my mouth -.-

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
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.

Kivva
Pator Tech School
Posted - 2007.10.13 18:51:00 - [7]
 

Edited by: Kivva on 13/10/2007 19:14:55
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). I think this may be due to the scripts assuming hostile sov without the charid from the IGB

Also, I'm unable to assign a parent outpost to an existing tower from the IGB.

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
Posted - 2007.10.13 19:05:00 - [8]
 

Edited by: Johnathan Roark on 13/10/2007 19:14:23
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.

the bug with outpost parent:
editposparent.php line 30 change:
from:
<td><form method="post" action="outpost-transaction.php"><input type="submit" name="action" value="Finsh Change"></form></td></tr>
to:
<td><input type="submit" name="action" value="Finsh Change"></form></td></tr>

Kivva
Pator Tech School
Posted - 2007.10.13 19:16:00 - [9]
 

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.


CaldFighter
Posted - 2007.10.13 23:06:00 - [10]
 

liquid ozone in the outpost view doesn't seem to be calculating properly either. Very Happy

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 Razz

*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
The Graduates
Morsus Mihi
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. Very Happy

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 Razz

*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.

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
Mentis Seorsum
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

Franny
Mentis Seorsum
Posted - 2007.10.14 04:58:00 - [16]
 

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)
Silo 0 Tungsten Input Medium Reactor Array (Rolled Tungsten Alloy) 100 39700 16d 13h
Silo 1 Rolled Tungsten Alloy Output Medium Reactor Array (Rolled Tungsten Alloy) 200 600 4d 1h
Silo 2 Rolled Tungsten Alloy Output Medium Reactor Array (Rolled Tungsten Alloy) 200 600 4d 1h

Sad , it is feeding both at the same time

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
Mentis Seorsum
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

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
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)
Sad , 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.

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. Very Happy

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
Caldari
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!

Gorfob
Minmatar
GoonFleet
GoonSwarm
Posted - 2007.10.15 06:40:00 - [23]
 

I take it you want us to use the SourceForge bug tracker and feature requests pages?

Salia Deluri
Caldari
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. Very Happy


ok it's late so forgive me.
How did you fix this one?



Salia Deluri
Caldari
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!

Salia Deluri
Caldari
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



Franny
Mentis Seorsum
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)
Sad , 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

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 Very Happy

Johnathan Roark
Caldari
The Graduates
Morsus Mihi
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. Very Happy


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.

Salia Deluri
Caldari
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. Very Happy


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



Pages: [1] 2 3 4 5 6 7 8 9 ... : last (14)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only