Originally by: ShadowMaster

---

Every time I try and add structures or import them I get this error;
"That doesnt work; Duplicate entry '28' for key 1"

The entry number has been going up every time I try.

---

Originally by: ShadowMaster

---

Ok, so I decided to just put my old database into the new tracker and see how it goes. It shows my pos and everything, and when I click view I see the button for export but is there a way to export all of my POS at once instead of one at a time? Also when i press the export button what do I do with the page it gives me?

---

Originally by: ShadowMaster

---

How do you use the fitexporter.xml.php file? Will it work if I have my old POS-Tracker on a different database? It currently requires the use of the recent POS-Tracker, so i can not just drop it in with the old one and run it.

---

Originally by: Halada

---

Importing towers with API now works

Cannot add structure, I get same error as above poster

---

Originally by: Ai Sakura

---

Edited by: Ai Sakura on 03/08/2008 23:40:10
Edited by: Ai Sakura on 03/08/2008 23:39:49
Bug report:

Sov still shows hostile even when logged in as my own corp/alliance (Level 4 admin)
Production page is empty.. (? Possible because I have no structures setup)

Adding A Silo results in that wont work - duplicate key message

---

Originally by: ShadowMaster

---

I have applied the bug fix and am still having the same issue when adding structures.

---

Originally by: ShadowMaster

---

yes, and I am 100% sure because it asked me to overwrite.

---

Originally by: ShadowMaster

---

I do not have to re-install the entire DB do I? This was just a patch to add to my current 3b2 instillation?

---

/tmp/phpwDks1X
mypos
8

Array
(
 [0] => SimpleXMLElement Object
 (
 [0] => 24658
 )

 [1] => SimpleXMLElement Object
 (
 [0] => 17184
 )

 [2] => SimpleXMLElement Object
 (
 [0] => 24660
 )

 [3] => SimpleXMLElement Object
 (
 [0] => 17621
 )

 [4] => SimpleXMLElement Object
 (
 [0] => 27576
 )

 [5] => SimpleXMLElement Object
 (
 [0] => 27576
 )

 [6] => SimpleXMLElement Object
 (
 [0] => 27576
 )

 [7] => SimpleXMLElement Object
 (
 [0] => 27579
 )

 [8] => SimpleXMLElement Object
 (
 [0] => 27579
 )

 [9] => SimpleXMLElement Object
 (
 [0] => 27582
 )

 [10] => SimpleXMLElement Object
 (
 [0] => 27582
 )

 [11] => SimpleXMLElement Object
 (
 [0] => 27582
 )

 [12] => SimpleXMLElement Object
 (
 [0] => 27585
 )

 [13] => SimpleXMLElement Object
 (
 [0] => 27585
 )

 [14] => SimpleXMLElement Object
 (
 [0] => 27585
 )

 [15] => SimpleXMLElement Object
 (
 [0] => 24659
 )

 [16] => SimpleXMLElement Object
 (
 [0] => 13780
 )

 [17] => SimpleXMLElement Object
 (
 [0] => 13780
 )

 [18] => SimpleXMLElement Object
 (
 [0] => 13780
 )

 [19] => SimpleXMLElement Object
 (
 [0] => 13780
 )

 [20] => SimpleXMLElement Object
 (
 [0] => 13780
 )

 [21] => SimpleXMLElement Object
 (
 [0] => 17185
 )

 [22] => SimpleXMLElement Object
 (
 [0] => 24656
 )

 [23] => SimpleXMLElement Object
 (
 [0] => 24656
 )

 [24] => SimpleXMLElement Object
 (
 [0] => 24654
 )

 [25] => SimpleXMLElement Object
 (
 [0] => 24654
 )

 [26] => SimpleXMLElement Object
 (
 [0] => 17187
 )

 [27] => SimpleXMLElement Object
 (
 [0] => 12237
 )

)

Originally by: John Xei

---

Tried to import a MyPOS setup but got this


Any idea?

---

Originally by: DeTox MinRohim

---

Edited by: DeTox MinRohim on 04/08/2008 20:29:04
The "Duplicate entry..." thing is an old bug of adodb that was fixed in my test svn but it got wiped by updating to the latest adodb class.

John, see line 31 and 206 for the GenID fix here

Also for John, please contact me at eve [] onewayweb.com I don't have your email on this laptop but I have a few days of connection in front of me. The sound of the see is deafening though

---

Originally by: ShadowMaster

---

I edited both of the lines you suggested. Copied from the document you linked and edited into the appropriate file, works perfectly now. Thank you very much.

---

Originally by: Sly Chick

---

Edited by: Sly Chick on 07/08/2008 10:30:56
I've tested the tracker locally on my pc and it seems to run fine. I've now uploaded it to my hosting isp and I now get the following error when trying to run install.php :

Fatal error: Smarty error: unable to write to $compile_dir '/zzzzzzzz/zzzzzzzz/public_html/postracker/cache/templates_c'. Be sure $compile_dir is writable by the web server user. in /zzzzzzzz/zzzzzzzz/public_html/postracker/includes/Smarty/Smarty.class.php on line 1088

Any suggestions on where to look for the problem is welcome.

Thanks
Sly Chick

---

Originally by: Johnathan Roark

---

Originally by: Sly Chick

---

Edited by: Sly Chick on 07/08/2008 10:30:56
I've tested the tracker locally on my pc and it seems to run fine. I've now uploaded it to my hosting isp and I now get the following error when trying to run install.php :

Fatal error: Smarty error: unable to write to $compile_dir '/zzzzzzzz/zzzzzzzz/public_html/postracker/cache/templates_c'. Be sure $compile_dir is writable by the web server user. in /zzzzzzzz/zzzzzzzz/public_html/postracker/includes/Smarty/Smarty.class.php on line 1088

Any suggestions on where to look for the problem is welcome.

Thanks
Sly Chick

---

As it says, check to make sure /zzzzzzzz/zzzzzzzz/public_html/postracker/cache/templates_c is writable by the web server. CHMOD 775 should work.

---

Originally by: Yorick Downe

---

Sly,

Which version of PHP? The installer claims the code needs PHP 5.1.3 or greater, but I think that's actually incorrect - if memory serves, POS Tracker uses xpath, which means it needs PHP 5.2.1 (possibly 5.2.0) or greater.

---

Originally by: Sly Chick

---

according to my phpinfo, I'm running 5.2.5 , the details can be found here phpinfo

---

Originally by: Yorick Downe

---

Possible bugs:

1) The duplicate ID bug is still present in 3.0beta2b. Fixing it like indicated in this thread worked

---

Originally by: Yorick Downe

---

2) Tower import from API does not add structures, even once 1) is resolved. Is that a bug or a missing feature?

---

Originally by: Yorick Downe

---

3) Spelling error on "about" page. "Managment Website. Combattible" should be "Management Website. Compatible"

---

Originally by: Yorick Downe

---

1) No indication in IGB that "View" etc. buttons aren't functional - this confused some of our users. Display some language to the effect of "you need to use an out-of-game browser to get full functionality"

---

Originally by: Yorick Downe

---

2) Documentation - if I missed it, please point me towards it. I'm puzzling over basic things like "What do the permission levels do, exactly? What does "highly trusted" mean? What is the Absolute Location System? What cron features exist - auto-api updates? What does the Moon Database do for me?"

---

Originally by: Yorick Downe

---

3) Default the DB prefix to pos3_ instead of pos2_ ? Minor detail, to be sure.

---

Originally by: Yorick Downe

---

4) Back buttons in some of the screens, like the View and Edit screens, would be nice. Moving the structure buttons up instead of having them at the bottom of the screen would be nice. Workflow improvement, really.

---

Originally by: Yorick Downe

---

Take all this as constructive feedback, please. I am aware I could contribute code, but I'm busy with other projects. I'm tickled pink to have this tool - so take this list not as criticism, but my way of giving back.

---

Originally by: Marlise

---

I'm not very apt with PhP. I'm a PS/CSS/HTML guy for webdesign mainly.

My cPanel access has cronjob editor... but I don't know which command to enter?

I'd really appreciate help on that as manually updating the API every day is a little tiresome!

Thanks so much!

---

Originally by: ShadowMaster

---

Hey John, is there any ETA on the outpost tracking feature?

---

Originally by: ShadowMaster

---

Also maybe I am just not seeing it, but is there a optimal uptime calculator?

---

Originally by: ScoobieBoy

---

Edited by: ScoobieBoy on 10/08/2008 18:45:10
Cannot seem to get the API import to work.

Error Code: 200::Current security level not high enough.. User ID: Character ID: ######### Corp: SKots INdusTries
This is using the full key for the ceo account.... so it should have the access.
Also any eta on the smaller gif format, instead of the png ?

---

Originally by: Kendolph

---

Why don't You use JOIN and not those crazy SELECTs in SELECT in SELECT ;) and btw that '... ORDER BY MoonName' does not work as far as I an see :). (I'm using MySQL).

---

Originally by: Johnathan Roark

---

There is only one sql statement that I know that uses a select within a select. I didn't write it and have never bothered to change it as it works. The order by moonName does work, but its overwritten by another function that re-orders the towers by how long the tower has remaining on.

---

Originally by: Kendolph

---

Originally by: Johnathan Roark

---

There is only one sql statement that I know that uses a select within a select. I didn't write it and have never bothered to change it as it works. The order by moonName does work, but its overwritten by another function that re-orders the towers by how long the tower has remaining on.

---

Haven't bothered to track the whole output :(. But it would be very nice to be able to sort the table by any (or most of) the columns.

---

//array_multisort($sortAarr, SORT_ASC, $rows);

Originally by: Amerilda Lee

---

Hi

I tryed to install the new pos tracker but gets the error
Parse error: syntax error, unexpected T_STATIC, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /var/www/vhosts/counterearth.net/subdomains/test/httpdocs/includes/adodb/adodb.inc.php on line 430

Someone that have any ide why?

Amerilda

---

Originally by: Amerilda Lee

---

What version of php are you running?

---

Originally by: Bigmamas

---

Hi there, i upload the POS tracker to the server and wen i tried to ***pos-tracker/install nothing happened only a white page....
Can anyone help me on this issue since im a totaly noob in php...

Thanks

---

Originally by: Jacob Roark

---

Originally by: Bigmamas

---

Hi there, i upload the POS tracker to the server and wen i tried to ***pos-tracker/install nothing happened only a white page....
Can anyone help me on this issue since im a totaly noob in php...

Thanks

---

install.php, /install takes you to the directory that stores all the database installation files and you are getting an empty index.html in that directory to hide directory listings

---

Originally by: Johnathan Roark

---

Originally by: Amerilda Lee

---

What version of php are you running?

---

5.0.32-7etch6

Rilda

---

Originally by: Riu Stuka

---

Edited by: Riu Stuka on 27/08/2008 09:47:06
Edited by: Riu Stuka on 27/08/2008 09:40:27
Someone care to explain the silo configuration for me? What is considered input silo, what is considered output?

I am making crystalline carbonide and it seems not to work right. Two silo hold the simple materials (Carbon Polymers and Crystallite Alloy) then the complex reactor and the silo for the complex material which is the output from the reactor ( Crystalline carbonide). So now i wonder whats considered input/output silo? And how to they need to be connected and whats the "link to" thing doing? I ask cause on API import some silos don't get imported (both simple ones and both my complex reaction POS's) and the other ones with the advanced material show me wrong figures... the silos on the moon mining and simple reaction POS's seem to be fine...

---

Originally by: Amerilda Lee

---

Originally by: Johnathan Roark

---

Originally by: Amerilda Lee

---

What version of php are you running?

---

5.0.32-7etch6

Rilda

---

too low, needs to be at least 5.1.2, the more recent, the better off you will be.

---

Originally by: Eton Favre

---

Seems to be a problem with the production amounts on Ceramic Powder input

Fernite Carb reaction using as an input Ceramic Powder Provider 10000 (1m3)
should be 100

---

Originally by: Eton Favre

---

On the Login page if you don't enter a username or password you get:
Fatal error: Call to undefined method Eve::RedirecUrl() in (DirPathtoPOSinstall)/login.php on line 31

---

Originally by: Eton Favre

---

I think someone asked before but did not see an answer. Will charters be a selectable fuel in the future?

---

Originally by: Eton Favre

---

A link to the Source forge project on the about page or possible a link to this thread would be a good idea on the about page.

---

Originally by: Johnathan Roark

---

Input means its emptying, output means its filling. The link to is for when you are stacking two silos. You would add the silo number from the previous silo. The API does not include structures so there is no way to import them with the API.

---

Originally by: Johnathan Roark

---

Originally by: Amerilda Lee

---

Originally by: Johnathan Roark

---

Originally by: Amerilda Lee

---

What version of php are you running?

---

5.0.32-7etch6

Rilda

---

too low, needs to be at least 5.1.2, the more recent, the better off you will be.

---

I have updated to version 6:4.4.4-8+etch6 of the php now and still have the same problem

---

Originally by: Amerilda Lee

---

Edited by: Amerilda Lee on 28/08/2008 16:45:27
Greetings

new error

Parse error: syntax error, unexpected '/' in /var/www/vhosts/counterearth.net/subdomains/test/httpdocs/eveconfig/config.php on line 8

line 8 in my config.php file is
$eve_filepath = /var/www/vhosts/counterearth.net/subdomains/test/httpdocs/;

don't know what to do

Rilda

---

Originally by: DeTox MinRohim

---

Originally by: Amerilda Lee

---

Edited by: Amerilda Lee on 28/08/2008 16:45:27
Greetings

new error

Parse error: syntax error, unexpected '/' in /var/www/vhosts/counterearth.net/subdomains/test/httpdocs/eveconfig/config.php on line 8

line 8 in my config.php file is
$eve_filepath = /var/www/vhosts/counterearth.net/subdomains/test/httpdocs/;

don't know what to do

Rilda

---

Dunno what script you have in your hand Rilda but it's definitly not this version of the tracker since the eve_filepath value is not something you need to change or even touch.

---------------------

Lysander, I can't reproduce the bug anymore with the fix. Think you could try from a complete svn checkout (if possible or course). Maybe I touched something else but can't seem to find a change relevant to it.

---

Originally by: Mike'P

---

Hi John,

Interesting looking tool, still feeling my way with it.

On my install for PHP 5.0.4, I had to make this change to get API character lookup to work:-

Line 3576 in includes/class.pos.php

if ($character === FALSE)

rather than

if (!$character).....

PHP is not as strongly typed as I would prefer, this behaviour might be one of those things that has changed between versions or something in php.ini that is just too tedious to Google out.

In general, if something might be FALSE, but it might be something else as well, the triple-equals test is a better bet.

Hope that helps someone else...

---

Quote:

---

/includes/class.pos.php
line 1437
if($row['constellationSovereignty'] > 0) {
- return array('sovereigntyLevel' => 5, 'allianceID' => $row['allianceID']);
+ return array('sovereigntyLevel' => 3, 'allianceID' => $row['allianceID']);

---

Quote:

---

Fuel Required Available Online
Strontium Calthrates 300 16666 2d 11h

---

Originally by: Apple Boy

---

Edited by: Apple Boy on 03/09/2008 01:13:34
Edited by: Apple Boy on 03/09/2008 00:08:36
great work John! Just a quick issue with constellation sov. It doesn't actually give you any fuel reduction bonus over any other sov level, which was throwing off numbers for some of my POSes.

temporary fix for those who have a POS in a const. sov place:

Quote:

---

/includes/class.pos.php
line 1437
if($row['constellationSovereignty'] > 0) {
- return array('sovereigntyLevel' => 5, 'allianceID' => $row['allianceID']);
+ return array('sovereigntyLevel' => 3, 'allianceID' => $row['allianceID']);

---

edit: that helps somewhat, to finish off the change, change line 1468 to

Quote:

---

if ($sovereignty==6) {

---

that's the only other place in the file that seems to effect fuel information, and it fixed all calculations for me, granted it's a quick hack and other code should be modified to do all of that properly

edit2:
The calculation for nanotransistors is wrong. It's supposed to output 1500/hr, it's only showing 375/hr though

---

Originally by: Gruntballs

---

Edited by: Gruntballs on 03/09/2008 03:25:00
I completed dropped all of my tables for the 2.x one and I copied that into a new directory...this is what I get:

Fatal error: Class 'eveRender' not found in /<path to dir>/pos/install.php on line 12

I am using php5 and this is what line 12 looks like

$eveRender = New eveRender($config, $mod, false);

---

Originally by: source killer

---

Can u add multi and auto fetching of api key dump?

---

Originally by: ScoobieBoy

---

Hey John,
I am trying to use the tracker for multiple corps ( so diff keys ) I had problem when I first setup the db, where by it would not allow me to update via api ( insuff privs ), but after clearing out the api table, and re-adding, all was well, now I am adding a diff corp, so new key, and getting the same error.
Error Code: 200::Current security level not high enough.. User ID: Character ID: 12345678 Corp: XYZ Inc.
The account is the ceo, so has the access, but still get this error.

---

Quote:

---

ERROR Failed to Add tower info ; Incorrect integer value: '' for column 'isotope' at row 1

---

Quote:

---

if (is_null($isotope)) {
$fuel["isotope"] = 0;
} else {
$fuel["isotope"] = $isotope;
}
if (is_null($oxygen)) {
$fuel["oxygen"] = 0;
} else {
$fuel["oxygen"] = $oxygen;
}

if (is_null($mechanical_parts)) {
$fuel["mechanical_parts"] = 0;
} else {
$fuel["mechanical_parts"] = $mechanical_parts;
}
if (is_null($coolant)) {
$fuel["coolant"] = 0;
} else {
$fuel["coolant"] = $coolant;
}
if (is_null($robotics)) {
$fuel["robotics"] = 0;
} else {
$fuel["robotics"] = $robotics;
}
if (is_null($heavy_water)) {
$fuel["heavy_water"] = 0;
} else {
$fuel["heavy_water"] = $heavy_water;
}
if (is_null($uranium)) {
$fuel["uranium"] = 0;
} else {
$fuel["uranium"] = $uranium;
}
if (is_null($strontium)) {
$fuel["strontium"] = 0;
} else {
$fuel["strontium"] = $strontium;
}
if (is_null($ozone)) {
$fuel["ozone"] = 0;
} else {
$fuel["ozone"] = $ozone;
}
if (is_null($heavy_water)) {
$fuel["heavy_water"] = 0;
} else {
$fuel["heavy_water"] = $heavy_water;
}
$fuel["charters"] = 0;

---

Originally by: Shime

---

Hello,
I upload the last svm and i've got some errors :
Warning: require_once(config.php)[function.require-once]: failed to open stream: No such file or directory in /pos3/importfit.php on line 2
Warning: require_once(functions.php) ...
Warning: require_once(header.php) ...

in importfit.php it's write :
require_once 'config.php';
require_once 'functions.php';
require_once 'header.php';

But thoses files are not present under "/"

If you have an idea

(what i'm doing : Track > Edit on a pos > import)

---

Originally by: Engole

---

Any reason starbase charters aren't working in the latest release (beta 2)?

Have been trawling through the code, but haven't figured it out yet.

---

Originally by: Cadiz

---

Edited by: Cadiz on 15/09/2008 08:52:16
I'm having an issue where it is counting system sovereignity status for our 0.0 towers as "hostile", even though our alliance has sovereignity in the systems in question. I've checked database ids for alliance ownership in the relevant systems and our towers, and they match up perfectly. Due to this issue we're not getting sov fuel reduction bonuses. Any suggestions?

---

Originally by: Johnathan Roark

---

Originally by: Cadiz

---

Edited by: Cadiz on 15/09/2008 08:52:16
I'm having an issue where it is counting system sovereignity status for our 0.0 towers as "hostile", even though our alliance has sovereignity in the systems in question. I've checked database ids for alliance ownership in the relevant systems and our towers, and they match up perfectly. Due to this issue we're not getting sov fuel reduction bonuses. Any suggestions?

---

Is the account your using to log into the tracker in the alliance? Using the admin account would cause that.

---

Originally by: Engole

---

Any reason starbase charters aren't working in the latest release (beta 2)?

Have been trawling through the code, but haven't figured it out yet.

---

Originally by: Slayerman

---

Edited by: Slayerman on 16/09/2008 13:16:23
Edited by: Slayerman on 16/09/2008 13:13:58
Hello again,

Another issue, if a tower is anchored (has no fuel and offline) I am still getting an e-mail.

This tower is purposely offline, and is set for future expansion if needed.

Would it be possible to have a flag to turn OFF e-mail alerts for a specific tower, on the request of the owner?

---

Originally by: Slayerman

---

I am also getting all POS's viewable by people NOT in the owner corp.... weird one.

Echo the SQL out, in GetAllPOS2() function is using

Quote:

---

'SELECT pos2_tower_info.*, (SELECT pos2_user.name FROM pos2_user WHERE pos2_tower_info.secondary_owner_id = pos2_user.eve_id ) AS 'backup', (SELECT pos2_evemoons.moonName FROM pos2_evemoons WHERE pos2_tower_info.moonID = pos2_evemoons.moonID) AS 'MoonName' FROM pos2_tower_info ORDER BY MoonName'

---

Don't know if this helps any

---

Originally by: Cowboy Timmy

---

1st Great app, kudos very slick.
just a question i downloaded the svn code last night tried the installer from there and its hanging at the db install screen doesn't seem to be doing anything at all just kinda dies right there.
this still being worked on and i'm jumping the gun? :)

Cheers
Timmah

---

Originally by: Johnathan Roark

---

Originally by: Cowboy Timmy

---

1st Great app, kudos very slick.
just a question i downloaded the svn code last night tried the installer from there and its hanging at the db install screen doesn't seem to be doing anything at all just kinda dies right there.
this still being worked on and i'm jumping the gun? :)

Cheers
Timmah

---

It should work fine. Only thing I can think of is either it corrupted when uploading or you click the upgrade check box when your not really upgrading.

Currently on the SVN, outpost are in and working, charters are just about done, just need to figure out how I want to add the option of turning them on and off.

A new package should be coming soon.

---

Originally by: Cowboy Timmy

---

Originally by: Johnathan Roark

---

Originally by: Cowboy Timmy

---

1st Great app, kudos very slick.
just a question i downloaded the svn code last night tried the installer from there and its hanging at the db install screen doesn't seem to be doing anything at all just kinda dies right there.
this still being worked on and i'm jumping the gun? :)

Cheers
Timmah

---

It should work fine. Only thing I can think of is either it corrupted when uploading or you click the upgrade check box when your not really upgrading.

Currently on the SVN, outpost are in and working, charters are just about done, just need to figure out how I want to add the option of turning them on and off.

A new package should be coming soon.

---

excellent, no it wasn't any of those i tried it both ways i can post the apache php errors spec to what i was experiancing.
i run slackware 12.1
Apache/2.2.8 (Unix) DAV/2 PHP/5.2.6 mod_perl/2.0.4 Perl/v5.8.8

[Sat Sep 20 13:38:45 2008] [error] [client 192.168.0.241] PHP Notice: Undefined

---

Originally by: Elana Vaho

---

Tried the new SVN version and getting an error on the Track Outpost page saying:
Unknown column 'outpost_id' in 'where clause'SELECT pos3_tower_info.* FROM pos3_tower_info WHERE outpost_id = '2' ORDER BY outpost_id

I suspect there is something missing in the database and this will be fixed in a newer version/beta?

---

Originally by: Johnathan Roark

---

Originally by: Elana Vaho

---

Tried the new SVN version and getting an error on the Track Outpost page saying:
Unknown column 'outpost_id' in 'where clause'SELECT pos3_tower_info.* FROM pos3_tower_info WHERE outpost_id = '2' ORDER BY outpost_id

I suspect there is something missing in the database and this will be fixed in a newer version/beta?

---

Yea, if your upgrading from a previous version and not installing a fresh copy. you need to run the following sql statements, first one being more important. Replace %prefix% with your table prefix.

[code]ALTER TABLE `%prefix%tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0';
DROP TABLE `%prefix%outpost_update_log`;

---

Originally by: Johnathan Roark

---

Originally by: Engole

---

Any reason starbase charters aren't working in the latest release (beta 2)?

Have been trawling through the code, but haven't figured it out yet.

---

I think I will have this working soon. They are accounted for, but not displayed. All I need to do to get them working is add them to the templates and make sure all the calculations include them when required.

---

Originally by: Alieuna

---

this looks like a really cool and handy program. I am a complete noob when it comes to website stuff and mysql. Does any one know of a site where this can be hosted for free or does someone want to set one up for me...(isk will appear in your account somehow!!!)

i would like to try it out but have no clue how to. any help would greatly be appreciated.
thanks
alieuna

---

Originally by: Engole

---

Originally by: Johnathan Roark

---

Originally by: Engole

---

Any reason starbase charters aren't working in the latest release (beta 2)?

Have been trawling through the code, but haven't figured it out yet.

---

I think I will have this working soon. They are accounted for, but not displayed. All I need to do to get them working is add them to the templates and make sure all the calculations include them when required.

---

Any news?

---

Originally by: Johnathan Roark

---

Originally by: source killer

---

Can u add multi and auto fetching of api key dump?

---

It already has this. It will fetch any api key you add. ATM though it will only allow you to add a key once, I need to change the duplicate logic.

It does auto download pos information via crontab.

---

Originally by: BoomBoomBam

---

Sorry to have to ask but what is crontab and do I have to do something for the tracker to auto download info from the API at regular intervals? Without touching anything it seems like the API info doesnt auto update (it tells me it is x days out of date unless i click update). Oh and if someone can help me setup the mail part it would be uber. Maybe list an example of mailconfig.php that works (im getting confused with the information to enter there.

Love the tool !

---

Originally by: Johnathan Roark

---

Originally by: BoomBoomBam

---

Sorry to have to ask but what is crontab and do I have to do something for the tracker to auto download info from the API at regular intervals? Without touching anything it seems like the API info doesnt auto update (it tells me it is x days out of date unless i click update). Oh and if someone can help me setup the mail part it would be uber. Maybe list an example of mailconfig.php that works (im getting confused with the information to enter there.

Love the tool !

---

crontab is a scheduling service for linux and Unix based systems. It needs to be pointed at the .sh scripts included. Check with your host on how to do this.

The mailconfig.php will be specific to your install. It needs an email account to work properly. Basically your giving it the details to that email account.

---

Originally by: Pinhas

---

Originally by: Johnathan Roark

---

Originally by: BoomBoomBam

---

Sorry to have to ask but what is crontab and do I have to do something for the tracker to auto download info from the API at regular intervals? Without touching anything it seems like the API info doesnt auto update (it tells me it is x days out of date unless i click update). Oh and if someone can help me setup the mail part it would be uber. Maybe list an example of mailconfig.php that works (im getting confused with the information to enter there.

Love the tool !

---

crontab is a scheduling service for linux and Unix based systems. It needs to be pointed at the .sh scripts included. Check with your host on how to do this.

The mailconfig.php will be specific to your install. It needs an email account to work properly. Basically your giving it the details to that email account.

---

Thanks for the response dude and rgr on the crontab thing. The problem with the mailconfig file is that I have filled out the fields but am not too sure on if I did it right or not (some of the labels im a bit confused about.) Ill post below what ive done so if you can tell me where i went wrong it would be cool (ive replaced some stuff with random names for privacy ect ect):

$mailconfig['site_mail'] ='[email protected]'; Here i put my email addy that is on the same domain as where the tracker is installed.
$mailconfig['site_mail_name']='POS-Tracker'; (havent changed this coz dont know what it is)
$mailconfig['mail_host'] ='mail.mydomain.com'; (i put my SMTP addy here)
$mailconfig['smtp_auth'] =false;
$mailconfig['mail_username'] ='MyUsername'; (I think that one i got right)
$mailconfig['mail_password'] ='mypw';(I think that one i got right)
$mailconfig['mail_port'] =25;
$mailconfig['mail_mailer'] ='smtp'; (do i need to change this?)
$mailconfig['email_enabled']=true;

---

$mailconfig['smtp_auth'] =true;

Originally by: Cowboy Timmy

---

[Wed Sep 24 21:33:00 2008] [error] [client 192.168.0.241] PHP Fatal error: Call to undefined method Eve::RedirecUrl() in /var/www/POSSVN/login.php on line 31, referer: http://192.168.0.1/POSSVN/login.php

---

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 'DEFAULT CHARSET=latin1' at line 25
-- phpMyAdmin SQL Dump -- version 2.9.1.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 14, 
2007 at 12:59 PM -- Server version: 5.0.45 -- PHP Version: 5.2.5 -- -- POS-TRACKER 3.0.0 -- $Id: install_database.sql 134
2008-08-03 21:25:18Z stephenmg $-- -- -------------------------------------------------------- -- -- Table structure for 
table `pos2_alliance_info` -- CREATE TABLE `pos3_alliance_info` ( `allianceID` int(12) NOT NULL, `name` varchar(255) NOT 
NULL, `shortName` varchar(255) NOT NULL, `updateTime` int(20) NOT NULL default '0', PRIMARY KEY (`allianceID`) ) 
ENGINE=MyISAM DEFAULT CHARSET=latin1
Problem?

Originally by: Mexbrutor

---

Beeing a noob I have spent hours trying to install this.
I keep getting this when I try to install:

"Parse error: syntax error, unexpected '/' in /home/zzzzz/public_html/pt/eveconfig/config.php on line 9"

this is what I have in config:

<?php
/**********************************************************/
/* All Eve-Online logos, images, trademark and related */
/* material are copyright CCP http://www.ccpgames.com */
/**********************************************************/

// Path for templates and xml files

$eve_filepath = /public_html/pt/cache/templates_c; // Remember to chmod it 777

//useless line now
$theme = 'posmanager';

I also changed line 9 to "/home/zzzz/public_html/pt/cache/templates_c"

amd just home with out the / befoe it as ut seems to say I have/have not a "/" somwhere?

any ideas?

---

$eve_filepath = realpath(cache);

Originally by: Lillis85

---

What do I do if I don't have an SMTP mail account? Is there a way I can use the standard mail function in PHP instead?

---

$mailconfig['mail_mailer']='mail'

Originally by: Valtrinor

---

Edited by: Valtrinor on 27/09/2008 12:35:16

Hi everyone, I'm also having an issue and hope you can be of assistance...

Error:

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 'DEFAULT CHARSET=latin1' at line 25
-- phpMyAdmin SQL Dump -- version 2.9.1.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Dec 14, 
2007 at 12:59 PM -- Server version: 5.0.45 -- PHP Version: 5.2.5 -- -- POS-TRACKER 3.0.0 -- $Id: install_database.sql 134
2008-08-03 21:25:18Z stephenmg $-- -- -------------------------------------------------------- -- -- Table structure for 
table `pos2_alliance_info` -- CREATE TABLE `pos3_alliance_info` ( `allianceID` int(12) NOT NULL, `name` varchar(255) NOT 
NULL, `shortName` varchar(255) NOT NULL, `updateTime` int(20) NOT NULL default '0', PRIMARY KEY (`allianceID`) ) 
ENGINE=MyISAM DEFAULT CHARSET=latin1
Problem?

I'm getting this at the second step of the install (install.php?step=2) on a fresh install and fresh database (I'd never had it before). All I can really tell from this is what the error message tells me regarding the location of the problem. Beyond that I'm an SQL newbie and not great with PHP yet. If there is any more info that will help please let me know. Unfortunately if a fix requires any kind of direct access to the MySQL server's config I'm out of luck, I'm using commercial hosting that doesn't give me that kind of access.

Thanks in advance!

-Valt

---

Quote:

---

It looks fine to me. I need more details about your setup.

---

Originally by: Johnathan Roark

---

Originally by: Mexbrutor

---

Beeing a noob I have spent hours trying to install this.
I keep getting this when I try to install:

"Parse error: syntax error, unexpected '/' in /home/zzzzz/public_html/pt/eveconfig/config.php on line 9"

this is what I have in config:

<?php
/**********************************************************/
/* All Eve-Online logos, images, trademark and related */
/* material are copyright CCP http://www.ccpgames.com */
/**********************************************************/

// Path for templates and xml files

$eve_filepath = /public_html/pt/cache/templates_c; // Remember to chmod it 777

//useless line now
$theme = 'posmanager';

I also changed line 9 to "/home/zzzz/public_html/pt/cache/templates_c"

amd just home with out the / befoe it as ut seems to say I have/have not a "/" somwhere?

any ideas?

---

Change it back to, there is very little reason to edit config.php at all unless there is something in it that you really need to change. I am also wondering what happened to the rest of the config file as that line 28 which is after the comment in the file that says dont change anything else.

$eve_filepath = realpath(cache);

---

Originally by: Johnathan Roark

---

Change it back to, there is very little reason to edit config.php at all unless there is something in it that you really need to change.

---

Quote:

---

Edit the eveconfig/config.php, eveconfig/dbconfig.php, and eveconfig/mailconfig.php files
Upload to your host

---

Originally by: Steely Dhan

---

Just on the install question

Originally by: Johnathan Roark

---

Change it back to, there is very little reason to edit config.php at all unless there is something in it that you really need to change.

---

The reason I mucked around on the config php was the following in the readme text file

Quote:

---

Edit the eveconfig/config.php, eveconfig/dbconfig.php, and eveconfig/mailconfig.php files
Upload to your host

---

when in fact we don't have to?

---

Originally by: Slayerman

---

Are Charters built in to this release? Cant see them on the track screen?

---

Originally by: Johnathan Roark

---

Originally by: Slayerman

---

Are Charters built in to this release? Cant see them on the track screen?

---

Yes, they are. Individual fuel types are never listed on the track page and never will be. It accounts for charters when it is calculating the lowest fuel type. You can see a detailed status of each fuel type on the viewpos page.

---

Originally by: 'Delete POS'

---

Column 'eve_id' cannot be null: INSERT INTO pos2_update_log (id, eve_id, type_id, type, action, datetime) VALUES (NULL, NULL, '7', '1', 'Delete POS', '1222770997')

---

Originally by: Slayerman

---

<= - Have changed mine to > and will update if this is the fix, im pretty sure it is

---

 $sql = "INSERT INTO ".TBL_PREFIX."update_log (
 eve_id,
 type_id,
 type,
 action,
 datetime)
 VALUES ('0',
 '" . Eve::VarPrepForStore($pos_id) . "',
 '1',
 'Delete POS',
 '" . Eve::VarPrepForStore($time) . "')";

Originally by: Lillis85

---

Is there any easy way of change the owner of the tower? Remeber you could do this in the older 2.x version

---

Originally by: ScoobieBoy

---

I thought I had read that the images would be shrunk ( as the current install is huge 72MB ) but a "quick" scan through the posts, did not yield a quote...
So Johnathan, is this something that is going to happen ? as a reduction from png to jpg yielded me about 90% reduction in size.
Thanks,
Scoob

---

Originally by: source killer

---

Can u add multiple user to one pos, if a pos starts to run out of fuel they all get mail?

---

Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 14, 2007 at 12:59 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5
-- 
-- POS-TRACKER 3.0.0
-- $Id: install_database.sql 176 2008-09-28 17:38:10Z stephenmg $--
-- --------------------------------------------------------
-- 
-- Table structure for table `pos2_alliance_info`
-- 
DROP TABLE IF EXISTS `%prefix%alliance_info`

MySQL said: Documentation
#1046 - No Database Selected 

Originally by: Meritems Phantastic

---

And Ill just add for your convenience that viewpos.php is listing the "correct"* ammount of online time based on the fuel amount.

*That is the;
tower ingame lists 10d 5h
gmt+2 host lists 10d 1h
gmt+X host lists 10d 8h

...so its still abit early to say, just giving an example.
Just saying that the polling and calculation of spesific fuels are working on a pos by pos basis.


By the way, great project. Thumbs up!

---

Originally by: Valtrinor

---

I'm now working with beta 3. I'm no longer getting the charset error, and everything seemed to be going well. Then I noticed the install script was stalling at "Creating/Updating tables" and not progressing or throwing errors. I let it sit for 12 hours to see if it was just going slowly and then used phpMyAdmin to check and see if it was putting anything into the database as it should be and it isn't. The database is still completely empty. It has not thrown any database connection errors but it seems to be failing to create tables and inject the data properly. This morning, for the sake of experimentation and troubleshooting I attempted to use the phpMyAdmin query window's Import Files page to import install_database.sql and received the following error (which may be unrelated to POS Tracker, but I want to provide anything that might help):

---

Originally by: Johnathan Roark

---

*SNIP*

Nope, your tower_info table should have a outpost_id and not a outpost_name column. Did you run the update script or install a fresh copy?

---

SQL query:

ALTER TABLE `pos2_tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0'

MySQL said: Documentation
#1366 - Incorrect integer value: 'None' for column 'outpost_id' at row 1

UPDATE `%prefix%tower_info` set `outpost_name`='0';
ALTER TABLE `%prefix%tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0';

Originally by: Johnathan Roark

---

Before you try importing with phpmyadmin, run a search and replace to replace all the %prefix% with what ever prefix you set in the dbconfig.php file. As far as the actual cause of your issue, im not sure, although I wonder if your bumping into the maximum script execution time limit.

---

Quote:

---

$security=$this->getSystemSecurity($systemID);
if($security<0.35)
{
(integer) $charters_needed=1;
}
else
{
(integer) $charters_needed=0;
}

---

Originally by: source killer

---

Edited by: source killer on 01/10/2008 16:08:41
when i add a 0.0 pos using API it ands charters to the list of fuel need. tried to use the

Quote:

---

$security=$this->getSystemSecurity($systemID);
if($security>0.35)
{
(integer) $charters_needed=1;
}
else
{
(integer) $charters_needed=0;
}

---

But it didn't help, any fix for it?

---

Originally by: B'atou

---

It's a great tool,
but I have a small problem wit the POS Tracker. As a short question, how do I add Coupling Arrays into the planner? It doesn't has them saved, so the won't show up.

---

Originally by: Revanom

---

I am still showing 'hostile' sov in systems which my alliance indeed has sov... the AllianceID values look good in the tables for the system as well. Any thoughts?

---

Originally by: Skyler Thunder

---

During install:
Not Acceptable

An appropriate representation of the requested resource /Pos-Tracker3.0beta3/install.php could not be found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Ive installed all versions successfully so far except this one.

---

Originally by: Halada

---

This happens when I press "test" in install php even after a whole re-upload

Does not work

---

<IfModule mod_security.c>
 SecFilterEngine Off
 SecFilterScanPOST Off
</IfModule>

Originally by: Lillis85

---

Edited by: Lillis85 on 05/10/2008 16:06:51
Is there a way to change the time? I would like it to follow eve time, but atm it's a few hours off.

Edit: Actually it looks like the time never change. I've made the cron to update through the API every hour, but all towers are still showing "last time updated" at 22:00. The cron works though and the towers are really getting updated every hour. The date gets updated, but not the time.

---

Originally by: Halada

---

My hosting provider disabled mod_security in apache for my domain and it still doesn't work.

---

<IfModule mod_security.c>
 SecFilterEngine Off
 SecFilterScanPOST Off
</IfModule>

Originally by: bomerI

---

Edited by: bomerI on 08/10/2008 19:38:34
Well.. to install it, I had to edit the html code to un-disable the Write Config and Install tables buttons. I tried then clicking the Write Config and then Install tables. After that it just gets stuck on the Creating / Updating tables. I had to then change the URL to include the query string ?step=4 to get to creating the moon tables. Installing the moons again had problems because it would give me javascript errors and would not register the moon as being installed (just stuck on "installing").

In the end I believe I have the tables all in there and the moons populated, however I dont have a user in the system. Does this need to be done through the IGB? (which will be a problem as I am working on a development server that isnt accessible from eve).

---

Originally by: Tai Ken

---

Fatal error: Call to undefined function curl_init() in /XXX/pos3/includes/class.pos.php on line 3436

This happens if I put in my API-Key or if I try to update any alliance/souv-data.

Any clue what that can be?

thx

---

Originally by: Slayerman

---

Is the Curl Module installed on your webserver? Curl is used to download the XML from the Eve API.

---

Originally by: bomerI

---

So I tried to install the app on another server, this time one that doesnt report any errors / notices. It appears that the install went through as it proceeded through the steps as I figure it should. My problem now is that I cant log in. Step 2 asks for an email address and password for the admin account. When the rest of the install is done, I figure I can log in with the email address, but it asks for a char name. I figure I need to register the char name, and proceed to the register page using the IGB and register with the same email address and password. When I attempt to log in, it is just going back to the login page as if I entered the password wrong. According to the DB, the user was created.

---

Originally by: Tai Ken

---

Originally by: Slayerman

---

Is the Curl Module installed on your webserver? Curl is used to download the XML from the Eve API.

---

Installscript says: CURL: No (Will use fopen)

So I assume it will use fopen instead. Or I'm wrong?

---

Originally by: Slayerman

---

Originally by: Tai Ken

---

Originally by: Slayerman

---

Is the Curl Module installed on your webserver? Curl is used to download the XML from the Eve API.

---

Installscript says: CURL: No (Will use fopen)

So I assume it will use fopen instead. Or I'm wrong?

---

The install does show that, I've taken a quick look at the code, and there is only code there for cURL as far as i can see, no fopen.

I'm guessing the guys will change that template on the next release.

Can a Dev please confirm this

---

Originally by: Keeper ofDungeonSquad

---

So as i understood from all described problems on stuck while "Creating/installing tables" i need to create MySQL v5 DB ?

Or we can get somewhere *.sql files for MySQL v4 ?

---

Originally by: Justin Barta

---

Just downloaded a fresh copy of 3beta3 and im getting this error on the install script.

Parse error: syntax error, unexpected '}', expecting '{' in H:\inetpub\vhosts\justinbarta.com\subdomains\shield\httpdocs\includes\class.pos.php on line 3446

---

Originally by: DeTox MinRohim

---

My bad... my intention was to use the fopen alternative when the CURL wasn't available but... *cough*... didn't put the code in it... yet!

I know... ... /emote goes back to coding.

---

Originally by: Tai Ken

---

Edited by: Tai Ken on 11/10/2008 09:17:01

Originally by: DeTox MinRohim

---

My bad... my intention was to use the fopen alternative when the CURL wasn't available but... *cough*... didn't put the code in it... yet!

I know... ... /emote goes back to coding.

---

Thx in advance ;)

---

Originally by: DeTox MinRohim

---

Added in latest SVN.

---

Originally by: Tai Ken

---

Originally by: DeTox MinRohim

---

Added in latest SVN.

---

Thx, can you provide me a link to the svn on sourceforge?

---

Originally by: Trisy A

---

I've got Pos-Tracker3.0beta3.zip
Uzipped it on php site. Installed. Now I see thing like

=============
- POS MANAGER -

| Home | Login | Register | About |

If you are using the in-game browser, you must click the "Login" button!
=============

I've registered with my e-mail and created some new password in in-game browser. BTW php site I'm using does not allow e-mail send/receive. Do I need it?

All I managed to do is to see "Welcome <char name> in ingame browser. And same login screen.

What next? Or what exactly should I do to be able to use it?

---

Originally by: DeTox MinRohim

---

[ HERE ] for class.pos.php
[ HERE ] for the full svn tree

---

Originally by: Tai Ken

---

Originally by: DeTox MinRohim

---

[ HERE ] for class.pos.php
[ HERE ] for the full svn tree

---

Thx, now I'm able to update the alliance & sovereignty database.
But after I insert the (director) API-Key and press "Select Character", I get: Error: String could not be parsed as XML

---