Thomasha

thanks in advance :-)

PHP-Version: 5.6.37-1+ubuntu16.04.1+deb.sury.org MySQL: Server-Version: 5.7.23-0ubuntu0.16.04.1 I don't know the version with "status" in the table. What does this status show? Is this file anywhere for download? The Hub entry was inserted by ourself. When the pilot is sending the loa its copied out of Auth::$userinfo and entered in this table so that it can be displayed in the loa admin

We are still on Version 2.1.v2.1.935. This module is working since years for us. If you refer to the "hub"... i added this manualy to the database. I also cross checked the installer file with our actual table and they are all correct. We now also saw that the "delete" function also don't works anymore 😞

Hello Guys, does the feature which checks if the pilot has already submitted an loa works for you? For us it didn't but i don't know why... Here our files. Many thanks in advance for your help. BRGDS Thomas ***********************************************************************************************************************************************

Hi, i tried, but it didn't work at first. Nothing was shown in the mail. When i changed this -> $comment = ScreenshotsData::getLatestComment($ss_id); to that $comment = ScreenshotsData::getLatestComment($id); it returns the comment but not the last one. If there are 2 comments bellow the picture the first(older) one is displayed. Therefore i changed this public static function getLatestComment($ss_id) { $sql = "SELECT * FROM ".TABLE_PREFIX."screenshots_comments WHERE ss_id='$ss_id' ORDER BY ss_id DESC LIMIT 1"; return DB::get_row($sql); } to that public static function getLatestComment($ss_id) { $sql = "SELECT * FROM ".TABLE_PREFIX."screenshots_comments WHERE ss_id='$ss_id' ORDER BY id DESC LIMIT 1"; return DB::get_row($sql); } Now everything works fine ! ***************************************************************************************************************************************************** I also received an idea from @web541 . Entering this into the Screenshots.php everything worked fine without changes in the ScreenshotsData.class $comment = ScreenshotsData::get_comments($id); $comment = end($comment); Many thanks to both of you for your great help. 😍 😃

OK thanks for Info. Will do so. He is welcome to fly again with us so no need to block him out 😉

ok thanks for Info. So i will set him only to inactive... for saftey reason 😉

Yes I have access & already thought about it. I just was afraid of this because i tought it must be a reason why the delete & change password button is not available. Maybe there is somewhere standing this pilot is "number 1" and deleting this pilot would crash the system...

Hello Guys, we just wanted to delete a Pilot but the "Pilot options" site stays blank at him. This pilot was the previous admin of our VA but he is not in our VA anymore for some years as acitve Pilot. He has no goups assigned to his account anymore. Do I need to change something in the phpvms so that i can delete him? Thanks in advance

Hi @servetas one further Question... when sending the Pilot the mail that his screenshot was rejected i would like to send him the reason aswell. The Reason is inserted as comment to the screenshot before rejection. I tried with this code but no comment is displayed in the Mail? $comment = ScreenshotsData::get_comments($ss_id); $message = "Dear $pilot->firstname $pilot->lastname," ."<br> unfortunately your screenshot has been rejected." ."<br> Reason: $comment->comment" Thanks in advance for your help.

Thanks, everything working fine now. BRGDS

thanks worked perfect

Is there any chance that a pilot gets a notification when its screenshot was approved/rejected without airmail? Thanks in advnce

Yes it was the failure you described :-) Deleting and searching afterwards can't work. Changed the order and it works perfect. Thank you so much for your help. BRGDS Thomas

Thanks for your quick answer. Tested it but it don't works. 😞 Just for confirmation... with your code i only need to chage the PIREPAdmin.php file?