Jump to content

Thomasha

Members
  • Posts

    39
  • Joined

  • Last visited

Posts posted by Thomasha

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

  2. On 12/31/2020 at 2:29 AM, ProAvia said:

     

    What version of phpVMS are you using?

    Did you run the SQL file to add to the database? This adds a new table for the LOA module.

     

    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 😞

    Unbenannt.PNG

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

     

     

    LoaData.PNG.45fd00034590ad03f5e7b3f4423c0d82.PNG

     

    ***********************************************************************************************************************************************

     

    LOA.PNG.95688de92ffc0dc4c05ad7d0e19635b5.PNG

     

  4. 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.  😍 😃

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

     

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

  7. Thanks for your answer,

    I tried it but it don't worked:

    In the log there stands only: "Deleted a comment to PIREP #:"

     

    Here the inserted code:

     

     public function deletecomment() {
            
            if (!isset($this->post)) {
                return;
            }
    
            PIREPData::deleteComment($this->post->id);
    		
    		$commentid = DB::escape($this->post->id);
    		$pirep = "SELECT * FROM ".TABLE_PREFIX."pirepcomments WHERE `id` = '$commentid'";
            LogData::addLog(Auth::$userinfo->pilotid, 'Deleted a comment to PIREP #: '.$pirep->pirepid);
    
            $this->set('message', 'Comment deleted!');
            $this->render('core_success.tpl');
        }

     

  8. Hello Guys,

    when a comment is deleted from a pirep there is only "Deleted a comment" written in the Log.

    Is there a chance that (like when a pirep comment is added) there is also written the pirep number from which the comment was delete?

    I tried with "LogData::addLog(Auth::$userinfo->pilotid, 'Deleted a comment' . $pirepid);" but without success.

    Thanks in advance for your help.

    BRGDS Thomas

     

  9. Hello Guys,

    we in our Airline got our complete schedule in utc time.

    At the end of the Month we are switching to the "wintertime" and so we must reschedule all Flights.

    Is there an way that we can change all Flights in mysql to be set deptime -1 Hour ???

    Thanks in advance for your help.

    BRGDS

  10. Hi Parkho!

    first thanks for these wunderful addon.

    Is there a chance to convert the full skycondition in text? Currently only the first 2 are written and the 3rd one is missing.

    i.E.: FEW050 SCT070 BKN080 ->FEW Clouds At 5000 Feet / SCT Clouds At 7000 Feet     -----> means "BKN 8000 is missing

    Another questions is if there is any posibillity to show the BARO in HPA iso. Hg

     

    Thanks in advance for your answer.

    BRGDS

  11. script type="text/javascript" src="https://maps.googleapis.com/maps/api/js?key=MY-API-KEY"></script>

     

    Maybe stupid Question... Is your code as above or have you entered the API code instead of the red marked script???

×
×
  • Create New...