Index: themes/posmanager/user.tpl
===================================================================
--- themes/posmanager/user.tpl (revision 244)
+++ themes/posmanager/user.tpl (working copy)
@@ -24,6 +24,10 @@
 <td><input type="text" name="email" value="<!--[$email]-->" /></td>
 </tr>
 <tr class="trackheader">
+ <td>Away Status</td>
+ <td><!--[html_options options=$awaystatus name='away' selected=$away]--></td>
+ </tr>
+ <tr class="trackheader">
 <td colspan="2"><input type="submit" value="Change Info" /></td>
 </tr>
 </tbody>

Index: includes/class.pos.php
===================================================================
--- includes/class.pos.php (revision 244)
+++ includes/class.pos.php (working copy)
@@ -438,11 +438,12 @@

 if ($compare) {
 Eve::SessionSetVar('name', $userinfo['name']);
 Eve::SessionSetVar('eve_id', $userinfo['eve_id']);
 Eve::SessionSetVar('access', $userinfo['access']);
 Eve::SessionSetVar('corp', $userinfo['corp']);
 Eve::SessionSetVar('id', $userinfo['id']);
 Eve::SessionSetVar('email', $userinfo['email']);
+ Eve::SessionSetVar('away', $userinfo['away']);
 Eve::SessionSetVar('highly_trusted', $userinfo['highly_trusted']);
 Eve::SessionSetVar('delsid', $userinfo['delsid']);
 Eve::SessionSetVar('allianceID', $userinfo['alliance_id']);
@@ -534,8 +535,9 @@
 'access' => Eve::SessionGetVar('access'),
 'corp' => Eve::SessionGetVar('corp'),
 'id' => Eve::SessionGetVar('id'),
 'eve_id' => Eve::SessionGetVar('eve_id'),
 'email' => Eve::SessionGetVar('email'),
+ 'away' => Eve::SessionGetVar('away'),
 'highly_trusted' => Eve::SessionGetVar('highly_trusted'),
 'delsid' => Eve::SessionGetVar('delsid'),
 'allianceID' => Eve::SessionGetVar('allianceID'));
@@ -562,6 +564,7 @@
 Eve::SessionDelVar('corp');
 Eve::SessionDelVar('id');
 Eve::SessionDelVar('email');
+ Eve::SessionDelVar('away');
 Eve::SessionDelVar('highly_trusted');
 Eve::SessionDelVar('delsid');
 Eve::SessionDelVar('userlogged');
@@ -571,6 +574,42 @@
 }

 /**
+ * POSMGMT::UpdateUserAway()
+ *
+ * @param mixed $args
+ * @return
+ */
+ function UpdateUserAway($args)
+ {
+ if (!isset($args['id'])) {
+ Eve::SessionSetVar('errormsg', 'No ID!');
+ return false;
+ }
+ if (!isset($args['newaway'])) {
+ Eve::SessionSetVar('errormsg', 'No Away Status!');
+ return false;
+ }
+
+ $dbconn =& DBGetConn(true);
+
+ $sql = "UPDATE ".TBL_PREFIX."user
+ SET away = '".Eve::VarPrepForStore($args['newaway'])."'
+ WHERE id = '".Eve::VarPrepForStore($args['id'])."'";
+
+ $dbconn->Execute($sql);
+
+ if ($dbconn->ErrorNo() != 0) {
+ Eve::SessionSetVar('errormsg', $dbconn->ErrorMsg() . $sql);
+ return false;
+ }
+
+ Eve::SessionSetVar('away', $newaway);
+
+ return true;
+ }
+
+
+ /**
 * POSMGMT::UpdateUserMail()
 *
 * @param mixed $args

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Index: cron_mail.php
===================================================================
--- cron_mail.php (revision 244)
+++ cron_mail.php (working copy)
@@ -50,10 +50,6 @@
 $mail = new posMailer();
 $mail->mailinit();

 //Add site URL to $mail object
 $url_path=$eve->GetBaseURL();
 $mail->site_URL=$url_path;
 
 $userinfo = $posmgmt->GetUserInfo();
 $eve->SessionSetVar('userlogged', 1);
 $access = $eve->SessionGetVar('access');
@@ -99,12 +95,12 @@
 'isotope'=>$row['result_optimal']['optimum_isotope']-$row['isotope'],
 'ozone'=>$row['result_optimal']['optimum_ozone']-$row['ozone'],
 'heavy_water'=>$row['result_optimal']['optimum_heavy_water']-$row['heavy_water']);
- if($characterInfo['email_optin']>0)
+ if($characterInfo['away']!=1)
 {
 if($row['result_online']<$config['minimal_fuel'])
 {
 $mail->posalert($characterInfo['email'], $characterInfo['name'], $row, $row3, $diff);
- echo "Mail Sent to: ".$characterInfo['name']."<br><hr>";
+ // echo "Mail Sent to: ".$characterInfo['name']."<br><hr>";

 }
 }
Index: user.php
===================================================================
--- user.php (revision 244)
+++ user.php (working copy)
@@ -65,12 +65,23 @@
 $action = $eve->VarCleanFromInput('action');

 if ($action == 'changeinfo') {
+ $away = $eve->VarCleanFromInput('away');
 $email = $eve->VarCleanFromInput('email');
 $newpass = $eve->VarCleanFromInput('newpass');
 $newpass2 = $eve->VarCleanFromInput('newpass2');

- if (!empty($email) != $userinfo['email']) {
- if (!$posmgmt->UpdateUserMail(array('id' => $userinfo['id'], 'newmail' => $email))) {
+ if (!empty($away) && $away != $userinfo['away']) {
+ if ($posmgmt->UpdateUserAway(array('id' => $userinfo['id'], 'newaway' => $away))) {
+ $eve->SessionSetVar('statusmsg', 'New away status saved!');
+ $eve->RedirectUrl('user.php');
+ }
+ }
+
+ if (!empty($email) && $email != $userinfo['email']) {
+ if ($posmgmt->UpdateUserMail(array('id' => $userinfo['id'], 'newmail' => $email))) {
+ $eve->SessionSetVar('statusmsg', 'New email address saved!');
 $eve->RedirectUrl('user.php');
 }
 }
@@ -97,8 +108,9 @@
 }

 $eveRender->Assign($userinfo);
+$eveRender->Assign('awaystatus', array( 2 => 'No', 1 => 'Yes'));
 $eveRender->Assign('IS_IGB', $IS_IGB);

 $eveRender->Display('user.tpl');

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Originally by: Shareina

---

In the install.php page, I enter all my database information, and the test succeeds. Then I click on write, and it also succeeds.

Then I click on Update Tables, and it loops indefenitely. I waited for 15 minutes and its still looping. I check at the DB and no table has been created.

There are no warning on the page, all the lines about the requirements are "OK" or "YES".

---

Index: eveconfig/config.php
===================================================================
--- eveconfig/config.php (revision 244)
+++ eveconfig/config.php (working copy)
@@ -9,15 +9,18 @@

 $absolocation = 1; #Turns absolute tower location on/off

+$focus_fuel = 72; # Bring the fuel level to our attention
 $minimal_fuel = 48; # Minimal fuel that should be kept in the towers at any time
 $critical_fuel = 24; # Critical fuel level

 $page_limit = 15; #Sets the number of towers to display on tracking page

+$focus_fuel_font_color = "#E5F212" ; #
 $minimal_fuel_font_color = "#E5F212" ; #
 $critical_fuel_text_color = "#E5F212" ; #
 $owner_text_color = "#FFFFFF" ; #
 $edited_text_color = "#FFFFFF" ; #
+$focus_fuel_background_color = "#053D49" ; #
 $minimal_fuel_background_color = "#770000" ; #
 $critical_fuel_background_color = "#FF0000" ; #
 $owner_background_color = "#001642" ; #

Index: track.php
===================================================================
--- track.php (revision 244)
+++ track.php (working copy)
@@ -148,7 +148,7 @@

 //$sortAarr[] = $row['result_online'];

- if ($row['owner_id'] == $_SESSION['id'] ) {
+ if ($row['owner_id'] == $userinfo['eve_id'] || $row['secondary_owner_id'] == $userinfo['eve_id']) {
 $row['bgcolor'] = $colors['owner_background_color'];
 $row['textcolor'] = $colors['owner_text_color'];
 }
@@ -158,6 +158,11 @@
 $row['textcolor'] = $colors['edited_text_color'];
 }

+ if ( isset($focus_fuel) && $row['result_online'] <= $focus_fuel) {
+ $row['bgcolor'] = $colors['focus_fuel_background_color'];
+ $row['textcolor'] = $colors['focus_fuel_font_color'];
+ }
+
 if ($row['result_online'] <= $minimal_fuel) {
 $row['bgcolor'] = $colors['minimal_fuel_background_color'];
 $row['textcolor'] = $colors['minimal_fuel_font_color'];

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

 $sql = "SELECT ".TBL_PREFIX."tower_info.*,
 (SELECT ".TBL_PREFIX."user.name
 FROM ".TBL_PREFIX."user
 WHERE ".TBL_PREFIX."tower_info.secondary_owner_id = ".TBL_PREFIX."user.eve_id ) AS 'backup',
 (SELECT ".TBL_PREFIX."evemoons.moonName
 FROM ".TBL_PREFIX."evemoons
 WHERE ".TBL_PREFIX."tower_info.moonID = ".TBL_PREFIX."evemoons.moonID) AS 'MoonName'
 FROM ".TBL_PREFIX."tower_info
 ORDER BY MoonName";

 $sql = "SELECT count( pos_id ) FROM ".TBL_PREFIX."tower_info";

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Originally by: almooja

---

Originally by: Shareina

---

In the install.php page, I enter all my database information, and the test succeeds. Then I click on write, and it also succeeds.

Then I click on Update Tables, and it loops indefenitely. I waited for 15 minutes and its still looping. I check at the DB and no table has been created.

There are no warning on the page, all the lines about the requirements are "OK" or "YES".

---

I am having the same issue.

---

Index: themes/posmanager/track.tpl
===================================================================
--- themes/posmanager/track.tpl (revision 244)
+++ themes/posmanager/track.tpl (working copy)
@@ -15,7 +15,7 @@
 <td>Tower Name</td>
 <td>Location</td>
 <td>Region</td>
- <!--<td>Owner</td>-->
+ <td>Owner</td>
 <td>Last Update</td>
 <td>Status</td>
 <td>Action</td>
@@ -31,7 +31,7 @@
 <td><!--[$pos.towerName]--></td>
 <td><!--[$pos.MoonName]--></td>
 <td><!--[$pos.region]--></td>
- <!--<td><a href="showinfo:1373//1048666916"> </a></td>-->
+ <td><!--[$pos.corp]--><br><a href="showinfo:1373//<!--[$pos.owner_id]-->"><!--[$pos.name|default:"-"]--></a> / <a href="showinfo:1373//<!--[$pos.secondary_owner_id]-->"><!--[$pos.backup|default:"-"]--></a></td>
 <td><!--[$pos.last_update]--></td>
 <td style="color:<!--[$pos.textcolor]-->;"><!--[$pos.online]--></td>
 <td><button type="button" onclick="window.location.href='viewpos.php?i=<!--[$pos.pos_id]-->'">View</button><button type="button" onclick="window.location.href='fuelbill.php?pos_id=<!--[$pos.pos_id]-->'">Fuel Bill</button><button type="button" onclick="window.location.href='editpos.php?i=<!--[$pos.pos_id]-->'">Edit</button><button type="button" onclick="window.location.href='deletepos.php?i=<!--[$pos.pos_id]-->'">Delete</button></td>

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Index: track.php
===================================================================
--- track.php (revision 244)
+++ track.php (working copy)
@@ -122,10 +123,19 @@

 $rows = $posmgmt->GetAllPos2($args);
 $towercount = $posmgmt->GetAllPos2Count();
+ $disp_towercount = 0;

 $bgcolor = "#111111";
 $textcolor = "#FFFFFF";
 foreach($rows as $key => $row) {
+
+ // Users with Access below 3 -> Only Display the Tower if they are Fuel Tech for it.
+ if ($access <= "2") {
+ if ($row['owner_id'] != $userinfo['eve_id'] && $row['secondary_owner_id'] != $userinfo['eve_id']) {
+ // View Right Denied.
+ continue ;
+ }
+ }

 $row2 = $posmgmt->GetLastPosUpdate($row['pos_id']);

@@ -167,7 +182,9 @@
 $row['bgcolor'] = $colors['critical_fuel_background_color'];
 $row['textcolor'] = $colors['critical_fuel_text_color'];
 }
- $rows[$key] = $row;
+
+ $disp_rows[$key]=$row;
+ $disp_towercount++;
 }
 //array_multisort($sortAarr, SORT_ASC, $rows);
 //echo '<pre>';print_r($_SESSION); echo '</pre>';exit;
@@ -200,7 +217,7 @@

 $pagernumlist=array(10=>'10', 15=>'15', 25=>'25', 30=>'30', 50=>'50', 100=>'100');

- $pager = array('numitems' => $towercount, 'limit' => $args['limit'], 'page' => $args['page']);
+ $pager = array('numitems' => $disp_towercount, 'limit' => $args['limit'], 'page' => $args['page']);

 $eveRender->Assign('pager', $pager);
 $eveRender->Assign('sb', $sb);
@@ -209,7 +226,7 @@
 $eveRender->Assign('arrposize', array(1 => 'Small', 2 => 'Medium', 3 => 'Large'));
 $eveRender->Assign('arrporace', $arrporace);
 $eveRender->Assign('config', $config);
- $eveRender->Assign('poses', $rows);
+ $eveRender->Assign('poses', $disp_rows);

 $eveRender->Display('track.tpl');
Index: fuelbill.php
===================================================================
--- fuelbill.php (revision 244)
+++ fuelbill.php (working copy)
@@ -170,6 +170,13 @@
 //echo '<pre>';print_r($towers); echo '</pre>';exit;
 foreach ($towers as $key => $tower) {

+ // Users with Access below 3 -> Only Display the Tower if they are Fuel Tech for it.
+ if ($access <= "2") {
+ if ($tower['owner_id'] != $userinfo['eve_id'] && $tower['secondary_owner_id'] != $userinfo['eve_id']) {
+ continue ;
+ }
+ }
+
 $required_H_isotope = 0;
 $required_N_isotope = 0;
 $required_O_isotope = 0;
@@ -224,7 +231,7 @@
 $fuel_ozone = $fuel_ozone + $needed_ozone;
 $fuel_heavy_water = $fuel_heavy_water + $needed_heavy_water;

- $towers[$key] = $tower;
+ $disp_towers[$key] = $tower;
 }

 (integer) $fuel_uranium_size = round($fuel_uranium * 1);
@@ -266,7 +273,7 @@
 $eveRender->Assign('fuel_ozone', $fuel_ozone);
 $eveRender->Assign('fuel_heavy_water', $fuel_heavy_water);
 $eveRender->Assign('total_size', $total_size);
- $eveRender->Assign('towers', $towers);
+ $eveRender->Assign('towers', $disp_towers);

 $eveRender->Display('fuelbill.tpl');
Index: fuel_calculator.php
===================================================================
--- fuel_calculator.php (revision 244)
+++ fuel_calculator.php (working copy)
@@ -185,6 +185,14 @@
 $towers = $posmgmt->GetAllPos2();
 $opttowers[0] = 'POS List';
 foreach ($towers as $tower) {
+
+ // Users with Access below 3 -> Only Display the Tower if they are Fuel Tech for it.
+ if ($access <= "2") {
+ if ($tower['owner_id'] != $userinfo['eve_id'] && $tower['secondary_owner_id'] != $userinfo['eve_id']) {
+ continue ;
+ }
+ }
+

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Originally by: almooja

---

AMY FROST

STOP POSTING PAGES OF CODE! ! ! !

Try linking a txt file. Or some other form of not FILLING up a whole damn section. Its nice you are providing what seems to be fixes or what not. But PLEASE stop filling the while page with CODE!

---

Originally by: hendo001

---

Edited by: hendo001 on 27/05/2009 13:44:02
I keep getting this:
Parse error: syntax error, unexpected '{' in /home/rpgcoll/public_html/mjolnir-alliance/pos/includes/class.pos.php on line 4203


whenever i try to install this to my webhost :S

---

Originally by: Shareina

---

In the install.php page, I enter all my database information, and the test succeeds. Then I click on write, and it also succeeds.

Then I click on Update Tables, and it loops indefenitely. I waited for 15 minutes and its still looping. I check at the DB and no table has been created.

There are no warning on the page, all the lines about the requirements are "OK" or "YES".

---

Unknown column 'regionName' in 'field list'SELECT pos_id, typeID, evetowerID, outpost_id, corp, allianceid, pos_size, pos_race, isotope, oxygen, mechanical_parts, coolant, robotics, uranium, ozone, heavy_water, charters, strontium, towerName, systemID, charters_needed, status, owner_id, secondary_owner_id, pos_status, pos_comment, secret_pos, moonID, regionID, regionName FROM pos3_tower_info, pos3_mapsolarsystems WHERE pos3_tower_info.systemID = pos3_mapsolarsystems.solarSystemID AND pos3_mapsolarsystems.regionID = '10000030'

Originally by: t20

---

WE AER GIOGN FRO MROE BREE

---

Originally by: Amy Frost

---

Edited by: Amy Frost on 31/05/2009 20:15:20
function GetAllTowers has a bug when called with $args['regionID']:

Unknown column 'regionName' in 'field list'SELECT pos_id, typeID, evetowerID, outpost_id, corp, allianceid, pos_size, pos_race, isotope, oxygen, mechanical_parts, coolant, robotics, uranium, ozone, heavy_water, charters, strontium, towerName, systemID, charters_needed, status, owner_id, secondary_owner_id, pos_status, pos_comment, secret_pos, moonID, regionID, regionName FROM pos3_tower_info, pos3_mapsolarsystems WHERE pos3_tower_info.systemID = pos3_mapsolarsystems.solarSystemID AND pos3_mapsolarsystems.regionID = '10000030'

How to reproduce: Go to the Fuel Bill Page and select
a Region and apply the filter

PS: Johnathan I've cleaned up/enforced some more of the Access Level handling aswell as some other Display tweaks, any chance for me to send you the patches? I hate it when my locally installed Version differs from the upstream SVN.

---

Quote:

---

[error] PHP Warning: Smarty error: math: parameter y is empty in /home/stks/public_html/POS/includes/Smarty/Smarty.class.php on line 1088
[error] PHP Fatal error: Class 'POSMGMT' not found in /home/stks/public_html/POS/fuelbill.php on line 47

---

Originally by: Adarrye

---

Edited by: Adarrye on 16/06/2009 02:18:17
Edited by: Adarrye on 16/06/2009 02:12:29
I'm having the same issue as :

Shareina
almooja
GreKom
galaxy rider

"Everyhing show as ok, but when you click on Install Table, it hang there doing nothing."

If you cant/dont have time to give support yourself, those would be usefull :
FAQ
Forum
Archive older stable version.
Verbose mode

I would really like to thank you for your work, but it does'nt work.

---

Originally by: Adarrye

---

First, thx a lot for your reply.

Then i did add the table manualy like you just propose, but i was thinking i needed to add all the 1000000*.sql file too. There like 63mb of raw text there it it was giving me some problem :)

Then i tryed to reach step 2 by modifying the code, but i suck at it and went nowhere.
Gonna try with install.php?step=2.

Thx again

---

Originally by: Adarrye

---

Ya, i would like to see the log too, that why i sugested a verbose mod :)

I'm not sure if/where i can find those log. I use commercial webhosting with Ipower and have a vDeck platform for there control panel.

When i checked in phpmyadmin to see if something was created, there was nothing.

If you have an idea where my log could be, i would be glad to check.

---