Nabeel

fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/191" title="enhancement: Expand Admin Email Section (closed: fixed)">#191</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/198" title="bug: TOTAL_HOURS missing from settings (closed: fixed)">#198</a> fixed <a class="closed ticket" href="http://bugs.phpvms.net/ticket/202" title="bug: Pirep charts noticed #34;min#34;: 1, #34;max#34;: 1, (closed: fixed)">#202</a>, refs <a class="accepted ticket" href="http://bugs.phpvms.net/ticket/182" title="enhancement: draw routes on database on pireps/schedules/acars (accepted)">#182</a> View more details, download from here Notes You can drop these two tables: phpvms_navdb phpvms_airways The install/navdata.sql file has to be manually imported as well. Mouse over the links above to see which bugs have been fixes. Routes aren't cached anymore except for PIREPs. Re-wrote the route parsing mechanism - only uses 2 queries flat, instead of the (n+n) queries (where n = number of segments in the route). The new table format helps with this. The file is almost smaller with fewer entries, but does cover nearly everything. Let me know if something huge is missing. Also added two config options to set specific email address(es) to get notifications for new registrations or PIREPs. Note 2 Fresh install won't work with this - the update will complete but throws an error. Just create an "airways.sql" file which is blank in the /install directory

What does having one for vacentral accomplish? I tried searching, couldn't find too many details. I guess my point is, why should we run one? Would it be its own type of "vatsim", or does it connect to vatsim, but it's just another communication server?

Make sure you're using absolute URLs with the http:// in front.

Yes you have to make sure hostnames are working properly, and that mysql is setup to listen on those hostnames

What exactly is that?

Unless they use ACARS, then they can still file that way, and then be marked unretired automatically

Do a search, this has come up at least a dozen times before

Hey, FSPax is a little tricky - under Documentation above, goto ACARS guides and then FSPax, there's a video tutorial for that. See if that helps you out first

You didn't follow what I said. Did you check the user that you've created for that database? What databases does that user show? If you do "use phpvms" (if that's the databse name), does it change to the database? If you're using phpMyAdmin, goto Privileges on the front page page, create a new user called phpvms, and have it create a database and grant all privledges for that user. Then try that. phpMyAdmin accesses it as root if that's how you're logging in, and it sees all databases

The link to the notam might have changed, I would check that

There's a video tutorial here, courtesy of Keith: http://forum.phpvms.net/page/index.html?record=22

Check it on his though, it's not always the same. You shouldn't be accessing as root from your scripts. There should be another user setup. When you do SHOW DATABASES; (on his server), does that database you setup show? And then log out and log back in as that user, and do SHOW DATABASES again, and make sure that's showing up. Its a DB issue somewhere

schedule_results.tpl inside that foreach loop, you'll see there are other checks there for the schedules

Then the database is not setup properly. Login to mysql as root mysql -uroot -p Then type SHOW DATABASES; And see if the db shows up under there. If it does, then your user above probably doesn't have privledges to that db`

rofl :lol:

Yes what simpilot said. Also try connecting in the command line: mysql -uUSER -p DATABASE_NAME If you can't connect that way, then there's an issue with your database install

It checks last login time and the last pirep. if its 30 days from the last pirep, it till check the pirep. if there's no pirep, it will check the login date. IIRC, that's how it goes

I would goto your ISP and find out the database address

Yeah, it's just a string unique to the aircraft. http://en.wikipedia.org/wiki/Aircraft_registration

That's strange... yeah, it's something client side... Are they running the latest version of FSACARS? There's an additional supplement on the FSACARS site to also download. With the Sitelog - can you enable DEBUG_LOG, and do a flight, and then send the core/logs/fsacars.txt file? I wonder how it reports that.

Poke around in the SiteCMS.class.php in core/common. you can modify those to include a category id, or an airline id. you can add in a drop-down with the airlines list, so that would simply that. so you'd just have to pass the $this->post->airlineid variable through to the query

Simplify this up there for ya: $bids = SchedulesData::getAllBids(); if(isset($bids)) { foreach($bids as $bid) { $bid_time = strtotime($bid->dateadded); $diff = abs(time() - $bid_time); if ($diff > 60*60*24*2) /* two days, in seconds */ { SchedulesData::removeBid($bid->bidid); } } }

I'm going to rearrange this post and place it into the Code Snippets forum. Also, this line still said $route, so I changed it: if(Config::Get('DISABLE_SCHED_ON_BID') == true && $schedule->bidid != 0)

Do a search on the TOTAL_HOURS bug, you have to add an entry into the settings table. It's missing for some odd reason