servetas

Host '31.170.160.103' is not allowed to connect to this MySQL server Contact your web hosting company and ensure that the database details you are using are correct.

Where did you downloaded phpVMS from? Have you tried reuploading the files on your server?

Have you checked if it is working too? I mean, does it blocks you from registering until you fill in the captcha form correctly?

What is your website url? Does your registration form includes captcha?

During the last year, PHP-Mods Team has started offering web hosting services. What is better than offering something free for the phpVMS community? For a limited time only, we have decided to share with you a total period of nine months of free hosting on our Standard Web Hosting Plan. Three clients will receive three months of free hosting. The first three who will get in touch with us at info@php-mods or via pm to my account will receive the 100% discount. Below you can see the list of the requirements: You should have already registered or register a new domain name (no free domains allowed). It is not required to register or transfer the domain to PHP-Mods. You should host an active virtual airline website in your web hosting plan (no under construction page). You should add a link back to PHP-Mods Website on the footer of your phpVMS website or your partners page. You should accept and comply with all the PHP-Mods Terms and Conditions. Kind Regards, Servetas George

I do not believe that it is currently offered (to get the airlines listing using xml). Which statistics of your va do you want to show? (I am moving the thread to the VACentral support board)

Have you tried clearing the browser cached data? First of all I would suggest visiting the forum via opening a "private window". Also, have you tried accessing the forum through another url? Maybe forum.phpvms.net instead of phpvms.net or even http://forum.phpvms.net/index.php ?

Check this.

Check this: http://forum.phpvms.net/topic/22846-lance-skin-some-errors-help/#entry120959

Version 2.6 Released

Delete your phpVMS files and database, reupload the files and reinstall phpVMS.

First of all I would suggest trying a full clean install.

Which version are you using? Did the error happen after a clean install or it started happening on a system which was working without any problem before?

Are you sure that you have uploaded the module correctly?

A better way to do this is adding the following in your core/local.config.php file: Config::Set('PILOT_ORDER_BY', 'p.joindate ASC');

Are you sure that you have uploaded the skin you want on your lib/skins folder?

Which phpvms version are you using? I would suggest downloading and installing simpilot's. It works with php 5.5 without problems. https://github.com/DavidJClark/phpvms_5.5.x

Iraklis, where is your problem exactly? It would be better if you could describe the problem more than just pasting a link to a page which is not accessible by anyone else in the forum but you.

As i can understand it is a template problem, it seems that the developer has used wrong variables. Open your lib/skins/lance/pilot_public_profile.tpl (or .php based on your phpVMS version) and replace its content with the following: <style> .bg{ background-color: #ffffff; margin-left: 200px; margin-right: 200px; border-bottom-color: aqua; } a{ color:#212121; } </style> <div class="bg"> <?php if(!$userinfo) { echo '<h3>This pilot does not exist!</h3>'; return; } ?> <h3>Profile For <?php echo $userinfo->firstname . ' ' . $userinfo->lastname?></h3> <table> <tr> <td align="center" valign="top"> <?php if(!file_exists(SITE_ROOT.AVATAR_PATH.'/'.$userinfocode.'.png')) { echo 'No avatar'; } else { echo '<img src="'.SITE_URL.AVATAR_PATH.'/'.$userinfocode.'.png'.'" alt="No Avatar" /> '; } ?> <br /><br /> <img src="<?php echo $userinfo->rankimage?>" alt="" /> </td> <td valign="top"> <ul> <li><strong>Pilot ID: </strong><?php echo $userinfocode ?></li> <li><strong>Rank: </strong><?php echo $userinfo->rank;?></li> <li><strong>Total Flights: </strong><?php echo $userinfo->totalflights?></li> <li><strong>Total Hours: </strong><?php echo Util::AddTime($userinfo->totalhours, $userinfo->transferhours); ?></li> <li><strong>Location: </strong> <img src="<?php echo Countries::getCountryImage($userinfo->location);?>" alt="<?php echo Countries::getCountryName($userinfo->location);?>" /> <?php echo Countries::getCountryName($userinfo->location);?> </li> <?php // Show the public fields if($allfields) { foreach($allfields as $field) { echo "<li><strong>$field->title: </strong>$field->value</li>"; } } ?> </ul> <p> <strong>Awards</strong> <?php if(is_array($allawards)) { ?> <ul> <?php foreach($allawards as $award) { /* To show the image: <img src="<?php echo $award->image?>" alt="<?php echo $award->descrip?>" /> */ ?> <li><?php echo $award->name ?></li> <?php } ?> </ul> <?php } ?> </p> </td> </tr> </table> <!-- Google Chart Implementation - OFC Replacement - simpilot --> <img src="<?php echo $chart_url ?>" alt="Pirep Chart" /> </div>

Could you please send me a url?

If you click any name, it redirects you to the same url? This means that the pilot id is hard coded and it's not correct. You will have to use variables instead.

For the pax carried per pilot add this before the ending bracket of the code/common/StasData.class.php file: public static function TotalPilotPax($pilotid) { $key = 'total_pax'; $key .= '_'.$pilotid; $total = CodonCache::read($key); if($total === false) { $total = 0; $sql = "SELECT * FROM ".TABLE_PREFIX."pireps WHERE pilotid='$pilotid' AND accepted=1"; $results = DB::get_results($sql); if($results) { foreach($results as $result) { $total += $result->load; } } CodonCache::write($key, $total, '15minute'); } return $total; } And you can use the code below in order to echo the passengers carried by a pilot. <?php echo StatsData::TotalPilotPax($pilotid); ?> Once again, do not forget to take care of the $pilotid variable on the second part of code. You will have to "pass" the correct variable according to the page you want to include it. As far as i know, phpVMS does not have a cargo value on each pilot's pireps. Are you using any custom pirep field for this?

Open your core/common/StatsData.class.php file and before the last closing bracket (}) add this: public static function TotalPilotMiles($pilotid) { $key = 'total_miles'; $key .= '_'.$pilotid; $total = CodonCache::read($key); if($total === false) { $total = 0; $sql = "SELECT * FROM ".TABLE_PREFIX."pireps WHERE pilotid='$pilotid' AND accepted=1"; $results = DB::get_results($sql); if($results) { foreach($results as $result) { $total += $result->distance; } } CodonCache::write($key, $total, '15minute'); } return $total; } and after that, you can echo the pilot's miles using the part of code below: <?php echo StatsData::TotalPilotMiles($pilot->pilotid); ?> PS: Pay special attention to the $pilot->pilotid, you will have to replace $pilot if the page is using a different variable name. Just to let you know that this script counts the total miles flown by a pilot based on his accepted pireps.

The topbanner does not exist or the location you shared with us is wrong.

<body> <!--start contain--> <p align="center"><img src="http://www.omanair-va.org/resources/charts.jpg" width="923" height="300" alt=""/> </p> <p> </p> <p><strong><em>Charts Files : - </em></strong></p> <p align="center"><strong>Muscat Int Airport </strong></p> <p align="center"><?php if(Auth::$userinfo->totalflights >= 10) { ?> <a href="http://www.omanair-va.org/resources/OOMS.pdf"><img src="http://www.omanair-va.org/resources/Download-Icon.png" width="100" height="100" alt=""/></a><?php } else { echo 'You have to fly at least 10 flights to download.';} ?></p> <p> </p> <p align="center"><strong>Salalah Int Airport </strong></p> <p align="center"><?php if(Auth::$userinfo->totalflights >= 10) { ?><a href="http://www.omanair-va.org/resources/OOSA salalah.pdf"><img src="http://www.omanair-va.org/resources/Download-Icon.png" width="100" height="100" alt=""/></a><?php } else { echo 'You have to fly at least 10 flights to download.';} ?></p> <!--end contain--> </body> Check the above.