OK so i have something very crude working here, just got to figure out how to put the pilot details next to the images.
For anyone who has a bit more experience here is the code below,
<?php
//simpilotgroup addon module for phpVMS virtual airline system
//
//simpilotgroup addon modules are licenced under the following license:
//Creative Commons Attribution Non-commercial Share Alike (by-nc-sa)
//To view full icense text visit http://creativecommons.org/licenses/by-nc-sa/3.0/
//
//@author David Clark (simpilot)
//@copyright Copyright (c) 2009-2010, David Clark
//@license http://creativecommons.org/licenses/by-nc-sa/3.0/
?>
<table width="100%">
<tr>
<td width="50%"><h3>Screenshot Gallery</h3></td>
<td width="50%" align="right">
<?php
if(Auth::LoggedIn())
{
if(PilotGroups::group_has_perm(Auth::$usergroups, ACCESS_ADMIN))
{
echo '<form method="link" action="'.SITE_URL.'/index.php/screenshots/approval_list">
<input class="mail" type="submit" value="Screenshot Approval List"></form><br />';
}
echo '<form method="link" action="'.SITE_URL.'/index.php/screenshots/upload">
<input class="mail" type="submit" value="Upload A New Screenshot"></form></td>';
}
else
{
echo 'Login to rate or upload screenshots.';
}
?>
</tr>
</table>
<hr />
<?php
//max displayed per page
$per_page = 12;
//get start variable
$start = $_GET['start'];
//count records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM screenshots"));
//count max pages
$max_pages = $record_count / $per_page; //may come out as decimal
if (!$start)
$start = 0;
//display data
$get = mysql_query("SELECT * FROM screenshots LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))
{
// get data
$image = $row['id'];
$pilot = $row['pilot_id'];
echo "<table width 400px>";
echo "<tr>";
echo "<td><img src =\"../pics/" . $row['file_name']."\" width=\"400px\"></td>";
echo "<td>This is where the pilot info will go</td>";
echo "</tr>";
echo "</table>";
}
//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;
//show prev button
if (!($start<=0))
echo "<a href='?start=$prev'>Prev</a> ";
//show page numbers
//set variable for first page
$i=1;
for ($x=0;$x<$record_count;$x=$x+$per_page)
{
if ($start!=$x)
echo " <a href='?start=$x'>$i</a> ";
else
echo " <a href='?start=$x'><b>$i</b></a> ";
$i++;
}
//show next button
if (!($start>=$record_count-$per_page))
echo " <a href='?start=$next'>Next</a>";
?>
<center>
<br /><br />