Loop Logged In Pilots Reports Only

[StartVM]

With the following script <?php MainController::Run('PIREPS', 'RecentFrontPage', 5); ?> it displays the last 5 pireps submitted. I am trying to modify the frontpage_reports.tpl file so it displays that users last 5 fives flights instead of everyones.

http://pastebin.com/zNkYd8tF

Can someone please help me out with this? Thanks

[JustinFHI]

Hi,

you can fix it like this:

//Script order
<?php MainController::Run('PIREPS', 'RecentFrontPage'); ?>


//Content of frontpage_recent.tpl
<?php
$pir_sel = "SELECT * FROM pireps WHERE pilotid = 'Auth::$userinfo->pilotid' ORDER BY id DESC LIMIT 5";
$pir_go = mysql_query($pir_sql);
while($report = mysql_fetch_object) {
 <li><a href="<?php echo url('/pireps/viewreport/'.$report->pirepid);?>">#<?php echo $report->pirepid
 . ' - ' . $report->code.$report->flightnum?> <span class="icon-align-left"></span><strong> Flying from <?php echo $report->depICAO . ' to ' . $report->arrICAO?></strong></a></li>
}
?>

I know that doesn't work with modules, but I think it's the easyst method.

[StartVM]

It doesn't work syntax error. Unexpected "<" on line 5

[Tom]

It doesn't work syntax error. Unexpected "<" on line 5

So check line 5 and work it out

Here, I did it for you:

//Script order
<?php MainController::Run('PIREPS', 'RecentFrontPage'); ?>


//Content of frontpage_recent.tpl
<?php
$pir_sel = "SELECT * FROM pireps WHERE pilotid = 'Auth::$userinfo->pilotid' ORDER BY id DESC LIMIT 5";
$pir_go = mysql_query($pir_sql);
while($report = mysql_fetch_object) { ?>
        <li><a href="<?php echo url('/pireps/viewreport/'.$report->pirepid);?>">#<?php echo $report->pirepid
        . ' - ' . $report->code.$report->flightnum?> <span class="icon-align-left"></span><strong> Flying from <?php echo $report->depICAO . ' to ' . $report->arrICAO?></strong></a></li>
<?php
}
?>