William

Nope, I wasn't sure.... Just like I wasn't sure about the "Secret" 😃 I copied it from the API interface within Mailgun, they call it API address so I thought..... Well, you already know what I thought Let me try with just americanva.org.......

Fantastic article. At the time of me reading this article I believe the module you mentioned above already came out as I saw the ability to create the mentioned separate profiles. The only thing I can add (and that only applies to some extent) is that it could get a bit complicated/time consuming to structure the setup as described when running a major operations including 100s of aircraft with many different configurations like for instance replicating a big airline. Other than that, the explication is perfect and very much appreciated!!

I know I am missing something small somewhere because I'm still getting no joy..... Attached the link for the log where I cannot find error about the mail (Mailgun is not receiving anything either) and the ENV.php screenshot of the config. https://www.dropbox.com/s/1unt7p21nqi13rl/laravel-2022-01-18.log?dl=0

Great answer as always, thanks. So the Secret is the API and that clears the concept. I will modify the ENV.php with the mailgun code posted above as per the docs and see where we go from there. To be continued.....

Need a bit of help with the email config as well as it does not seem to work properly. I signed up for Mailgun and they gave me 2 options: API or SMTP Couldn't really follow the explanation in the phpvms docs (as I do not know where to find the "Secret" as shown below) [quote] To use Mailgun, set your env.php like: MAIL_MAILER=mailgun MAILGUN_DOMAIN='your mailgun domain' MAILGUN_SECRET='your mailgun secret', [quote] so I choose SMTP and configured the ENV.php as follows: MAIL_MAILER='mailgun' MAIL_FROM_NAME='American Virtual Admin' MAIL_FROM_ADDRESS='admin@americanva.org' MAIL_HOST= 'smtp.mailgun.org' MAIL_PORT='587' MAIL_ENCRYPTION= 'TLS' MAIL_USERNAME= 'postmaster@americanva.org' MAIL_PASSWORD= 'our password' No joy. What am I missing please?

Thanks! For now I am just exploring.... If we do end up choosing to move forward, I am sure we will have more than one question and we will interact many times again Cheers

That's actually a pretty good suggestion, thanks! Obviously, it worked just fine.... On a side note I also started looking into your work and it's really cool. Really appreciate all you do for the community. We are one of the oldest and largest VA (since 2004) and now evaluating if it may be time to make the switch to phpVMS new version.

Been with phpvms since 2010 and testing the water with the new version. Same thing happened here on a fresh phpvms 7 install (last available release). The error is "CSV file doesn't seem to match import type" for "Flights" and/or "Aircraft" Multiple tests have been done, including one starting from the template provided in Downloads. All field are filled correctly and triple checked. Still the same error. Not sure where the hiccup is but there's one.

Thanks for the thought, but nope, it's 465. Regardless, it doesn't even work with GMAIL or any other SMTP provider for that matter. Really don't know what to try anymore.....

Hi Guys, can I re-hash this thread since it's not too old? So here's the problem we have. When use of SMTP in the local_config is off the system sends emails and works as it should BUT when turned on there's no sending emails anywhere....Nada the config is right, checked, double checked and triple checked against several different servers (including Gmail) - No dice As soon as the setting is set to "TRUE" there's no more emails, transactional or not Tried the fix in this thread and the different version of PHPMailer - No joy The Util Class also was also checked. The problem is that we really need to be able to use SMTP as we will rely to a new email server because our hosting is on a overly aggressive Microsoft spam blocklist and that is creating a ton of issues. I'm at a loss and don't know where to look anymore, any thoughts? PHPVms is Simpilot 5.5.2 running on PHP 5.5

Thanks ProAvia. Really for all your help and suggestions

Yes, I'm sure you did, but with over 200 active pilots, I'm not about to go fiddle with things that can break the site and create bigger problems unless I have to, especially over something small like LOA requests that I can easily delete straight from the DB. Also we have add-on nobody else does so it's hard to compare. Anyway, thanks for looking into it

That's part of the problem. We cannot use php 7.2 as it breaks other things. This VA is running on 20+ different add-on modules and I don't have to explain any of you what a headache it is to make them all work together nicely. 😉

The version is 1.0, the last one available. It was throwing more errors as already described by many members in different posts and I cleaned them all up. The only thing which still does not work is the error thrown when we try to delete a LOA request. That error is connected to the function in Line 63 that Sean had posted about. Basically, it's not talking to the DB and the function needs to be rewritten, but I didn't have time.

You already have the response lol We are the same VA, that's why he mentioned William in his previous post. I thought it was inferred from my previous response as well, sorry.

It's mysqli

As a matter of fact with the changes I made, the module works as it should. The only thing we cannot do is delete the LOA requests from within Admin. That's when the error is thrown (at line 63) so we have to delete them directly in the DB. I didn't get around to fix that yet.

Hey ProAvia, thanks for the response. Yes, a cleaned up version of V1 is what we have on the site now and I resolved most of the errors, but I still have a couple of function errors I wanted to get rid off. For instance when I try to delete a submitted LOA, it throws an error saying mysqli_query expecting a value and not finding it and as a consequence does not delete the request from the DB or the Admin panel. I'm on my phone now, but I can be more clear in the errors I mentioned when I get to the computer. Thanks

Yes, thanks, but that's not much help. Already have that and was looking for something that's a bit more up to date.

Hey guys, does anyone left from this topic has the latest updated version? FlyAlaska link is dead. Any info/help would be appreciated Thanks

Hey, Great work Vangelis. If I wanted to add PHP to have a drop down menu for DEP and ARR retrieving the ICAO present in the DB how would I write that? I tried to add the code myself but did not succeed. I also saw a JSON line commented out in the module, is that related to it? Appreciate the help guys!

Any news on this one??

Interesting as I have the same exact error. Is it really that we can't come up with a solution or workaround? Always appreciate any input EDIT: Apparently we can't!

Thanks for the response. The problem is not so much the modal setup, it is instead the fact the map link/page sows up blank. And yes, this is a module that shows up in the front end. However it has permissions coded in and also inherits Admin permissions too. I tried copying over the code from Pirep_list, but it still comes up blank. <a id="dialog" class="jqModal" style="font-weight: 400;" href="<?php echo SITE_URL?>admin/action.php/operations/viewmap?type=pirep&id=<?php echo $pirep->pirepid;?>">View Map</a> For the time being, I solved it by pointing to Pirep recap as shown here (it's dark because you're not logged in) http://americanva.org/crew/index.php/pireps/view/310 But ideally I wanted to show the map only and put it on a modal

I would like to show the Map modal (as it show in Pirep Admin) somewhere else (aka the HubOps pirep admin page). I'll post the picture and the code below. I'm missing something in my code as the map link shows a blank page. <?php if(!$pireps) { echo '<p>No reports have been found</p></div>'; } else { ?> <p>There are a total of <?php echo count($pireps);?> flight reports in this category. <a href="<?php echo SITE_URL ?>/<?php echo $mloc ?>.php/HubOps/approveallpireps/<?php echo $hub->icao ?>">Click to approve all PIREPs for this Hub</a></p> <table class="cc_hubadm_tablea"> <tr> <th>Date</th> <th>Flight</th> <th>From</th> <th>To</th> <th>Pilot</th> <th>Aircraft</th> <th>Flighttime</th> <th>Fuel Used</th> <th>Landingrate</th> <th>Finance</th> <th>Log</th> <th>Route</th> <?php if(PilotGroups::group_has_perm(Auth::$usergroups, FULL_ADMIN) || $pilotpermissions->editpireps == '1') { ?> <th>Comments</th> <th>Edit</th> <th>Options</th> <?php } ?> </tr> <?php foreach($pireps as $pirep) { if($pirep->accepted == PIREP_PENDING) $td_class = 'pending'; else $td_class = ''; $error = false; ?> <?php if($pirep->accepted == "0") { ?> <tr class="cc_hubadm_pendingfield"> <?php } elseif($pirep->accepted == "2") { ?> <tr class="cc_hubadm_rejectedfield"> <?php } else { ?> <tr> <?php } ?> <td><?php echo date(DATE_FORMAT, $pirep->submitdate); ?></td> <td><?php echo $pirep->code.$pirep->flightnum; ?><br />ID: <?php echo $pirep->pirepid; ?></td> <td><?php echo $pirep->depicao; ?><br /><?php echo substr($pirep->depname,0,20); ?></td> <td><?php echo $pirep->arricao; ?><br /><?php echo substr($pirep->arrname,0,20); ?></td> <td><?php echo PilotData::GetPilotCode($pirep->pcode, $pirep->pilotid) . '<br />' .$pirep->firstname .' ' . $pirep->lastname;?></td> <td><?php if($pirep->aircraft == '') { $error = true; echo '<span style="color: red">No aircraft! Edit to change</span>'; } else echo $pirep->aircraft. "<br />($pirep->registration)"; ?></td> <td><?php echo $pirep->flighttime_stamp; ?></td> <td><?php echo ($pirep->fuelused!='') ? $pirep->fuelused.Config::Get('LIQUID_UNIT_NAMES', Config::Get('LiquidUnit')) : '-';?></td> <td><?php echo $pirep->landingrate; ?> ft/min</td> <td>Revenue: <?php echo FinanceData::formatMoney($pirep->revenue);?><br /> Pilot Pay: <?php echo FinanceData::formatMoney($pirep->pilotpay);?></td> <td><span id="<?php echo $pirep->pirepid; ?>" class="log cc_hubadm_link_tbl_pir">View Log</span></td> <td><a class="cc_hubadm_link_tbl_pir" href="<?php echo SITE_URL?>/admin/action.php/operations/viewmap?type=pirep&id=<?php echo $pirep->pirepid;?>">View Map</a> </td> <?php if(PilotGroups::group_has_perm(Auth::$usergroups, FULL_ADMIN) || $pilotpermissions->editpireps == '1') { ?> <td><span id="<?php echo $pirep->pirepid; ?>" class="comment cc_hubadm_link_tbl_pir">Comments <span class="hubcommentcount<?php echo $pirep->pirepid; ?>" style="font-size: 12px; margin-top: -3px; font-weight:bold;">(<?php echo PIREPData::getCommentCount($pirep->pirepid); ?>)</span></span></td> <td><span id="<?php echo $pirep->pirepid; ?>" class="editpirep cc_hubadm_link_tbl_pir">Edit</span></td> <td><span id="<?php echo $pirep->pirepid ?>" name="<?php echo $pirep->pilotid; ?>" class="acceptpirep cc_hubadm_greenbutt pirepactions">Accept</span><br /><span id="<?php echo $pirep->pirepid ?>" name="<?php echo $pirep->pilotid; ?>" class="rejectpirep cc_hubadm_redbutt pirepactions">Reject</span><br /><span id="<?php echo $pirep->pirepid ?>" name="<?php echo $pirep->pilotid; ?>" class="deletepirep cc_hubadm_redbutt pirepactions">Delete</span></td> <?php } ?> </tr> <?php } ?> </table> <?php } ?> <div id="pirepinfoscreen"></div>