mark1million

If your ever dealing with sql just export as sql, excel does some wired formatting that screws things up. What i would suggest os to try that what i pasted above and debug from the results.

You cant use excel to import pilots to the site i dont think.

Its Ok on my system, what did you do?

you can do it two ways, copy paste in to phpmyadmin or upload the file, What you need it this, INSERT INTO `phpvms_pilots` (`pilotid`, `firstname`, `lastname`, `email`, `code`, `location`, `hub`, `password`, `salt`, `bgimage`, `lastlogin`, `totalflights`, `totalhours`, `totalpay`, `payadjust`, `transferhours`, `rankid`, `rank`, `ranklevel`, `confirmed`, `retired`, `joindate`, `lastpirep`, `lastip`, `comment`)VALUES (1, 'Iain', 'Robb', 'i_robb@tiscali.co.uk', 'FRX', 'SCOTLAND', 'EGPF', '4b480c21f898ddfccf616da93c2b5760', '1ccc2062de1101f0fb20d4f7033d3f20', 'new_signature.png', '2011-10-18', 0, 1.5, 0, 0, 0, 1, 'Trainee', 1, 1, 0, '2010-09-21 11:05:16', '2011-07-21 02:59:24', '81.129.82.248', 'CEO'); See if that lets you import. Usually you can empty the table and just import the sql file but im not sure how you managed to get the A B C etc

You need this, INSERT INTO `phpvms_pilots` (`pilotid`, `firstname`, `lastname`, `email`, `code`, `location`, `hub`, `password`, `salt`, `bgimage`, `lastlogin`, `totalflights`, `totalhours`, `totalpay`, `payadjust`, `transferhours`, `rankid`, `rank`, `ranklevel`, `confirmed`, `retired`, `joindate`, `lastpirep`, `lastip`, `comment`)

HI thats the wrong table structure

My mistake sorry, I have just looked and its all there in the skins folder brilliance and the template you want is layout.tpl

Ok let me have a quick look , I will download that skin now.

Hi, I am not too familiar with that skin but if you look in the core navigation top that would probably be a good place to start.

The setting is in teh local.config.php file in your core, for the UK i use, # Google Map Options Config::Set('MAP_WIDTH', '700px'); Config::Set('MAP_HEIGHT', '600px'); # Valid types are G_NORMAL_MAP, G_SATELLITE_MAP, G_HYBRID_MAP, G_PHYSICAL_MAP Config::Set('MAP_TYPE', 'G_PHYSICAL_MAP'); Config::Set('MAP_LINE_COLOR', '#ff0000'); Config::Set('MAP_CENTER_LAT', '52.187405'); Config::Set('MAP_CENTER_LNG', '-0.878906'); Config::Set('MAP_ZOOM_LEVEL', 12); Remember to set your own size for the map.

Dave i have tried many permutations but no still not making any difference, just to check i changed the else to another colour just to make sure it would and that's fine. Just seems to be the conditions its not picking up.

A kind bump please

Your cache folder is in the core, or just go to the admin section and clear the cache from there.

Try this, <?php error_reporting(E_ALL); ini_set('display_errors', 'on'); include '/PUT YOUR PATH HERE/public_html/core/codon.config.php'; $allpilots = PilotData::getAllPilots(); foreach($allpilots as $pilot) { } ?> <h3>Pilot Hours Validation</h3> <p>To Quick search name or pilot id hit Ctrl + F and and type in data.</p> <?php if(!$allpilots) { echo 'There are no pilots!</div>'; return; } ?> <table width="380" cellspacing="1" cellpadding="5" border="1"> <thead> <tr> <th width="60px">Pilot ID</th> <th width="200px">Name</th> <th width="55px">Hours</th> <th width="65px">Active/Inactive</th> <th>Vatsim ID</th> </tr> </thead> <tbody> <?php foreach($allpilots as $pilot) { /* To include a custom field, use the following example: <td> <?php echo PilotData::GetFieldValue($pilot->pilotid, 'VATSIM ID'); ?> </td> For instance, if you added a field called "IVAO Callsign": echo PilotData::GetFieldValue($pilot->pilotid, 'IVAO Callsign'); */ ?> <tr> <td width="1%" nowrap><a href="<?php echo SITE_URL?>/index.php/profile/view/<?php echo $pilot->pilotid?>"> <?php echo PilotData::GetPilotCode($pilot->code, $pilot->pilotid)?></a> </td> <td> <div align="left"><img src="<?php echo Countries::getCountryImage($pilot->location);?>" alt="<?php echo Countries::getCountryName($pilot->location);?>" /> <?php echo $pilot->firstname.' '.$pilot->lastname?> </div></td> <td><div align="center"><?php echo $pilot->totalhours?></div></td> <td><div align="center"><?php If ($pilot->retired == 0) { echo '<img src="/images/green-status.gif" />'; } else { echo '<img src="/images/red-status.gif" />'; } ?></div></td> </div></td> <td><?php echo PilotData::GetFieldValue($pilot->pilotid, 'VATSIM ID'); ?></td> <?php } ?> </div> </tbody> </table> You get the idea you can edit the thing to suite your needs, this is a php file that site in my root directory so Aerosoft can validate pilot hours.All you will need to update is your path to your codon config file.

I have just been looking at how the pirep log is displayed, <?php # Simple, each line of the log ends with * # Just explode and loop. $log = explode('*', $pirep->log); foreach($log as $line) { echo $line .'<br />'; } ?> If it possible to style based on an event, for example If the log contains Stall format that text in Red Bold for example, or if it contains a landing rate < -500 that is also formatted, im just trying to get some ideas on how to format the output based on different events and even if it is possible. Thanks.

Yes this works only with the beta release, there have been a heck of a lot of changes from the stable release, i would take some time if your not on a beta to thoroughly read the changes and understand them as there are loads.

Have you edit the code for pilots auth? Simpilot posted a code update for inactive pilots, just check that file as thats where its coming from.

What message are they getting?

Looking at that code they should not be getting any message as that is blank.

Nabeel, every time my cron runs the maintenance.php it send out an email to all the inactive pilots, is there any way to restrict this so that inactive pilots dont keep getting the mail as i run this script about 3 times a week.

You need to be using the beta for the groups. Have a look here that should help. http://forum.phpvms.net/topic/5053-rev-v21934-143-gbee20b6-added-automatic-group-add-to-retired-statuses-installer-updates/

Yes i think it does, it will effect the amount of pireps, I have been pondering this for a while now, to delete or just to lock out, i decided to make use of the groups and after the pre defined inactivity the pilots account gets locked out so they cant login or file a pirep. That was all the flights are preserved and should the pilot wish to come back they can pick up from where they left off.

When you delete a pilot it removes all their flights / hours pireps etc

Cheers Jeff, Had to use $userinfo->pilotid works great

Is there a function to show a pilots total miles flown?