flyalaska

How can you make to display a text " No Flights" if the pilot hasn't flown yet on the pilots average landing rate? Now if the pilot has no flights it shows an error. I am using this to display the pilots average landing rate in the public profile. <?php echo ''.round(TouchdownStatsData::pilot_average($userinfo->pilotid), 2); ?>

If you mean like this, I still get a blank response. <?php $sql = 'SELECT COUNT(*) as total FROM '.TABLE_PREFIX.'pireps WHERE `pilotid` = '.$pilotid.' AND DATE(`submitdate`) = CURDATE() '; $pireps = DB::get_row($sql); ?> <?php echo $pireps->total; ?>

I can give you my template. You can just your flights and upload it.

I tried that code <?php $sql = 'SELECT COUNT(*) as total FROM '.TABLE_PREFIX.'pireps WHERE `pilotid` = '.$pilotid.' AND DATE(`submitdate`) = CURDATE() '; $pireps = DB::get_row($sql); ?> returns a blank, not a number

That is not 100% true. My ID numbers are in the 600's. I changed someone to 138 and we are still in order. I think you can change the next number in order in the sql. Thats how I did it in FSACARS. Not 100% sure on phpVMS.

Thank you, that's what I was looking for.

Anyone know how to remove the title in the pages? The pages that are made in admin.

I see, I am on 943. Maybe that is why

I don't have the option for the google API anymore. On the left, it refers to the API. Thats the only reference I have.Nothing on updates. Maybe you should do a fresh install.

Where do you see these options? Google API is not needed anymore. I am starting a 2nd VA for jets, never had to set up a API and my map works with no problem. I have the same version on both VA's. (2.1.934)

He didn't say it was stable.

Works perfect, ty

I got that today too!

name it recent_post.php. Replace URL to your forums with the url, leave the backslash. Upload it to your forum directory. <?php // Sets the number of topics to display $topicnumber = 5; // Change this to your PHPBB3 path (no trailing slash "/") $urlPath = "URL to your forums/"; // Database configuration (where your PHPBB3 config.php file is located) include 'config.php'; // Database connection and error messages $table_topics = $table_prefix. "topics"; $table_forums = $table_prefix. "forums"; $table_posts = $table_prefix. "posts"; $table_users = $table_prefix. "users"; $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect"); mysql_select_db("$dbname") or die("Could not select database"); // Main database query $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username FROM $table_topics t, $table_forums f, $table_posts p, $table_users u WHERE t.topic_id = p.topic_id AND f.forum_id = t.forum_id AND /********************** *********************** EXCLUDE THESE FORUM IDs (if you have private forums) *********************** **********************/ t.forum_id != 17 AND t.forum_id != 19 AND t.forum_id != 20 AND /********************** *********************** END EXCLUSIONS *********************** **********************/ /* Back to the query... */ t.topic_status <> 2 AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id ORDER BY p.post_id DESC LIMIT $topicnumber"; $result = mysql_query($query) or die("Query failed"); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { // HTML parsing echo "<a href=\"$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]\" class='topic_new'>" . $row["topic_title"] . "</a><br /><a href=\"$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]\">" . $row["username"] . "</a> on " . date('M j, Y, g:i a', $row["post_time"]) . "<br /><br />"; } mysql_free_result($result); mysql_close($link); ?> <?php include("forums/latest_post.php"); ?>

I know this an old post. I have the code if anyone needs it.

Is there anyway of catching the ip on registration, than we can block their ip through our host cp?

I have used this. It worked for awhile, now all the sudden the spammers are back.

LOL Joeri

TY Jamyboy!

Anyone have this skin? If you can you send it to me?

Is there even a phpVMS 3.0?

What phpVMS version do you have?

Click onOptimize Tables.

Thank you, Seems to be working so far.

This webpage is not available