mark1million

There is a file called pilot_public_profile.tpl, if its not in your skins folder then look in the core templates folder then move it to your skins folder and customise.

There must be a way to get this to display in a popup or something. But im stuck as you at the moment with this one

Also if you want a response then dont leave me comments on my profile, your more likely to get something by leaving here in the thread. The code i posted will show the pilots last flights, if you want the last flights of the VA then that code is different. What is it exactly that you need?

With IE8 it does load but it takes a while for some reason, never have been able to get to the bottom of that because its OK in chrome and ff.

OK its using a file called jquery.tablesorter.pager.js this should be in your /lib/js folder. Then simply in your header make sure its included where all the other js includes are. <script type="text/javascript" src="YOURSITEURL/lib/js/jquery.tablesorter.pager.js"></script> I cant upload the file as i have ran out of space lol, just download it from my site. In Fact Here, (function($) { $.extend({ tablesorterPager: new function() { function updatePageDisplay(c) { var s = $(c.cssPageDisplay,c.container).val((c.page+1) + c.seperator + c.totalPages); } function setPageSize(table,size) { var c = table.config; c.size = size; c.totalPages = Math.ceil(c.totalRows / c.size); moveToPage(table); fixPosition(table); } function fixPosition(table) { var c = table.config, o = $(table); if(o.offset) { c.container.css({ top: o.offset().top + o.height() + 'px', position: 'static' }); } c.pagerPositionSet = true; } function moveToFirstPage(table) { var c = table.config; c.page = 0; moveToPage(table); } function moveToLastPage(table) { var c = table.config; c.page = (c.totalPages-1); moveToPage(table); } function moveToNextPage(table) { var c = table.config; c.page++; if(c.page >= (c.totalPages-1)) { c.page = (c.totalPages-1); } moveToPage(table); } function moveToPrevPage(table) { var c = table.config; c.page--; if(c.page <= 0) { c.page = 0; } moveToPage(table); } function moveToPage(table) { var c = table.config; if(c.page < 0 || c.page > (c.totalPages-1)) { c.page = 0; } renderTable(table,c.rowsCopy); } function renderTable(table,rows) { var c = table.config; var l = rows.length; var s = (c.page * c.size); var e = (s + c.size); if(e > rows.length ) { e = rows.length; } var tableBody = $('tbody:first',table).empty(); for(var i = s; i < e; i++) { tableBody.append(rows[i]); } if(!c.pagerPositionSet && c.positionFixed) fixPosition(table,tableBody); updatePageDisplay(c); } this.appender = function(table,rows) { var c = table.config; c.rowsCopy = rows; c.totalRows = rows.length; c.totalPages = Math.ceil(c.totalRows / c.size); renderTable(table,rows); }; this.defaults = { size: 10, offset: 0, page: 0, totalRows: 0, totalPages: 0, container: null, cssNext: '.next', cssPrev: '.prev', cssFirst: '.first', cssLast: '.last', cssPageDisplay: '.pagedisplay', cssPageSize: '.pagesize', seperator: "/", positionFixed: true, appender: this.appender }; this.construct = function(settings) { return this.each(function() { config = $.extend(this.config, $.tablesorterPager.defaults, settings); var table = this, pager = config.container; $(this).trigger("appendCache"); config.size = parseInt($(".pagesize",pager).val()); $(config.cssFirst,pager).click(function() { moveToFirstPage(table); return false; }); $(config.cssNext,pager).click(function() { moveToNextPage(table); return false; }); $(config.cssPrev,pager).click(function() { moveToPrevPage(table); return false; }); $(config.cssLast,pager).click(function() { moveToLastPage(table); return false; }); $(config.cssPageSize,pager).change(function() { setPageSize(table,parseInt($(this).val())); return false; }); }); }; } }); // extend plugin scope $.fn.extend({ tablesorterPager: $.tablesorterPager.construct }); })(jQuery); Save that as jquery.tablesorter.pager.js

I cant remember which js library this uses now, it maybe that its using something else than the stock, in fact i think it is, give me 5 minutes and ill post it up here.

I was looking at this the other day, i didnt manage to get it to work either, the closest i came was to hover over the subject and ecco out to the url the message

Was talking to Rafael What is it you want the pilots last flights or the VA's last flights?

The function is available via the admin section of your site no need to phpmyadmin

That code will work in the public_pilot_profile.tpl only, i think you need different variables for the pilots profile main. Thats why i asked where is it for.

I Had big trouble as well getting this to work i left it for a few and when i went back to it it seemed to be OK. Here is the file i use, i have stripped it down on other divs etc, see how that goes on you site. schedule_results.tpl <?php if(Auth::LoggedIn() == false) { echo '<div id="error">You need to be a member to search the schedules</div>'; return; } ?> <?php if(!$allroutes) { echo '<p align="center">No routes have been found!</p>'; return; } ?> <table id="th" class="tablesorter" width="700" border="1" cellspacing="1" cellpadding="1"> <thead> <tr> <th>Flight Info</th> <th>Options</th> </tr> </thead> <tbody> <?php foreach($allroutes as $route) { /* Uncomment this code if you want only schedules which are from the last PIREP that pilot filed */ /*if(Auth::LoggedIn()) { $search = array( 'p.pilotid' => Auth::$userinfo->pilotid, 'p.accepted' => PIREP_ACCEPTED ); $reports = PIREPData::findPIREPS($search, 1); // return only one if(is_object($reports)) { # IF the arrival airport doesn't match the departure airport if($reports->arricao != $route->depicao) { continue; } } }*/ /* Skip over a route if it's not for this day of week Left this here, so it can be omitted if your VA doesn't use this. Comment out these two lines if you don't want to. */ /* Check if a 7 is being used for Sunday, since PHP thinks 0 is Sunday */ $route->daysofweek = str_replace('7', '0', $route->daysofweek); if(strpos($route->daysofweek, date('w')) === false) continue; /* END DAY OF WEEK CHECK */ /* This will skip over a schedule if it's been bid on This only runs if the below setting is enabled If you don't want it to skip, then comment out this code below by adding // in front of each line until the END DISABLE SCHEDULE comment below If you do that, and want to show some text when it's been bid on, see the comment below */ if(Config::Get('DISABLE_SCHED_ON_BID') == true && $route->bidid != 0) { continue; } /* END DISABLE SCHEDULE ON BID */ /* Skip any schedules which have aircraft that the pilot is not rated to fly (according to RANK), only skip them if they are logged in. */ if(Config::Get('RESTRICT_AIRCRAFT_RANKS') === true && Auth::LoggedIn()) { /* This means the aircraft rank level is higher than what the pilot's ranklevel, so just do "continue" and move onto the next route in the list */ if($route->aircraftlevel > Auth::$userinfo->ranklevel) { continue; } } /* THIS BEGINS ONE TABLE ROW */ ?> <tr> <td> <a href="<?php echo url('/schedules/details/'.$route->id);?>"><?php echo $route->code . $route->flightnum?> <?php echo '('.$route->depicao.' - '.$route->arricao.')'?> </a> <br /> <strong>Departure: </strong><?php echo $route->deptime;?> <strong>Arrival: </strong><?php echo $route->arrtime;?><br /> <strong>Equipment: </strong><?php echo $route->aircraft; ?> (<?php echo $route->registration;?>) <strong>Distance: </strong><?php echo $route->distance . Config::Get('UNITS');?> <br /> <strong>Days Flown: </strong><?php echo Util::GetDaysCompact($route->daysofweek); ?><br /> <?php echo ($route->route=='') ? '' : '<strong>Route: </strong>'.$route->route.'<br />' ?> <?php echo ($route->notes=='') ? '' : '<strong>Notes: </strong>'.html_entity_decode($route->notes).'<br />' ?> <?php # Note: this will only show if the above code to # skip the schedule is commented out if($route->bidid != 0) { echo 'This route has been bid on'; } ?> </td> <td nowrap> <a href="<?php echo url('/schedules/details/'.$route->id);?>">View Details</a><br /> <a href="<?php echo url('/schedules/brief/'.$route->id);?>">Pilot Brief</a><br /> <?php # Don't allow overlapping bids and a bid exists if(Config::Get('DISABLE_SCHED_ON_BID') == true && $route->bidid != 0) { ?> <a id="<?php echo $route->id; ?>" class="addbid" href="<?php echo actionurl('/schedules/addbid');?>">Book Leg</a> <?php } else { if(Auth::LoggedIn()) { ?> <a id="<?php echo $route->id; ?>" class="addbid" href="<?php echo url('/schedules/addbid');?>">Book Leg</a> <?php } } ?> </td> </tr> <?php /* END OF ONE TABLE ROW */ } ?> </tbody> </table> <hr> <div align="right" id="pager" class="pager"> <form> <img src="<?php echo fileurl('lib/images/first.png');?>" class="first"/> <img src="<?php echo fileurl('lib/images/prev.png');?>" class="prev"/> <input type="text" class="pagedisplay"/> <img src="<?php echo fileurl('lib/images/next.png');?>" class="next"/> <img src="<?php echo fileurl('lib/images/last.png');?>" class="last"/> <select class="pagesize"> <option value="10">10 per page</option> <option value="50">50 per page</option> <option value="100">100 per page</option> <option value="500">500 per page</option> <option value="1000">1000 per page</option> </select> </form> </div> <script defer="defer"> $(document).ready(function() { $("#th") .tablesorter({widthFixed: true, widgets: ['zebra']}) .tablesorterPager({container: $("#pager")}); } ); </script> <br /><br /> </div> Let me know how you get on with that.

Its not life or death is it? Let me put it another way if it was that important to you then you would not be on a free host.

Hello, you dont upload the files into the database you run the installer from your site, this will populate the database for you. All you have to do is create a database or define its settings on the install page.

Here you go, <?php if(!$pireps) { echo '<p>Sorry No recent flights have been found</p></div>'; return; } $flights = PIREPData::getLastReports($userinfo->pilotid, '20'); $string = ""; foreach($flights as $flight) { $string = $string.$flight->depicao.'+-+'.$flight->arricao.',+'; } ?> <p align="center"><strong>Pilots Recent Flights</strong><br /><img src="http://www.gcmap.com/map?P=<?php echo $string ?>&MS=bm&MR=240&MX=685x360&PM=pemr:star10:white%2b%22%25I%22:white&PC=orange" /><br /> Maps generated by the <a href="http://www.gcmap.com/">Great Circle Mapper</a> - copyright © <a href="http://www.kls2.com/~karl/">Karl L.Swartz</a></p> You may want to customize how many line 7 plus you may need to remove that div after the end of sorry no flight have been found depending what skin your using. Plus this bit you can customize as you wish, go over to Karl's site and you can see the variables, PM=pemr:star10:white%2b%22%25I%22:white&PC=orange

If you have access to your php.ini you should be able to change from there, if not try creating a file called php.ini and putting the following in your website root, then restart apache or iis. date.timezone =Australia/Sydney Failing that try this, http://www.electrictoolbox.com/php-change-timezone/

Just redownload and upload the install folder, once your finished checking you can rename or delete.

Cor are you assigning the table the class and adding the javascript at the bottom of the page?

To be honest i dont really see the problem in pilots changing their hubs, maybe a future request. But then again i dont get many requests to change so would it be worth it.

Where do you want to display it, Pilots Public profile or pilots profile? The code is on this forum

Ah got you. Cheers Jeff.

Clear your cache.

Not the hub no.

Did you restart apache?

Just quickly going back to this Nabeel if i use your way i get a repeat of the login message for the amount of hubs that i have but if i place the page in the brackets that fixes it, is their another way?