Nabeel

Route map not working? Can you link me? The airways table being empty might be a cause. The navdb table can be empty, that's populated as navpoints are used. It seems this one is working: http://dev.flypatriotva.com/index.php/schedules/details/1 Schedules/pireps use the same route_map. But if you can link me to an example - I don't think I back-populated pireps, though That's odd the expenses aren't working. I will check that out too.

Well, all changes are additive (adding columns or tables), so they won't affect any older code

That's a good point, it would. I should change that skin functionality to be in a local config file

No problem

For those, you use the same column names as the table. You can also do: print_r($userinfo); And it will output all the fields you can use. You can do that on any variables and it will show you details

How some people do it is adjust the financials in the individual pirep after it's been filed, and before you accept it. Finances aren't counted until a pirep is accepted (this is def the case post 865/866). xacars is a bit dodgy - try the newest version that he just released, it might be a bit more reliable

It might be available already, depending on the template. Which template were you thinking about? $pilot->joindate or $userinfo->joindate You have to see what's used in the template (like, if you see $pilot->code, replace "code" with "joindate")

Can you PM me your site address, and ftp login details, so I can check it out?

Which template? The pilot's take has a "joindate" column

That's odd.. are you on betas?

Oh ok, so we're on the same cycle. That's odd. Can you paste the route you've entered for these: http://www.kafly.net/index.php/pireps/viewreport/57 http://www.kafly.net/index.php/pireps/viewreport/58 So I can make refinements to my algorithm. Post it with the departure/arrival airports, please

I think there were a few mentions of this in the add-on forum

Thanks, the routes I'm trying to correct the algorithm, right now, if there are multiple points with the same name, it will pick the one which is the shortest distance from the previous route. One thing to make sure about is that your route data you've entered is on the latest AIRAC version. Right now, the navdb is on the latest AIRACS. BTW ,the first two are comical ;D

Thanks, yes, I will refine the errors - this is just the first cut of a rewrite xacars backend code changed since their update. Did you update xacars? When I tested it, it seemed ok. The airway db I changed a column name, so did you drop that table before the update? Try dropping the table again (delete the airways table), and run the update again, see if there are entries. There should be about 8000 entries in that table. Also, check the debug logs for errors.

Gotcha. I would add a LIMIT 1 and a ORDER BY column ASC/DESC so you can select which one in case there are multiples. You can also do one query with get_results() by using GROUP BY aircraft, it will return one result row for each aircraft. Check out the stats functions for examples of that, but it might be more efficient.

Because you don't have any PIREPs

This topic has been moved to Releases. [iurl]http://forum.phpvms.net/index.php?topic=1177.0[/iurl]

What's the code you're using to call it?

You should probably use get_results() to return them all. What are you trying to do? A way to debug.. Change to: $result = DB::get_row($query); DB::debug(); return $result; If you add the debug in, I'll check out the page, it might give some clue as to what's up

Does it work in the admin panel? I see you have no pireps - it won't work if there are no pireps

Yep, these are betas so they are bound to be broken. This one is broken like this on purpose. 877 is up and that should be fixed

Important! Read the changelog, there are a bunch of template updates. Even if you already updated those templates listed from previous, update them again. This one in particular has alot of changes, so if you can check ACARS and make sure they work that'd be great. This one look a little longer because I was checking things through as well, but a 2nd set of eyes always helps. And, if you had imported the navdb and airways tables from the other thread, be sure to drop those tables before you run the update from here Thanks!!

Revision 867: route db, tons of template changes, fixed #145 fixed #174 fixed #177 fixed ...26 January 2010, 10:56 amroute db, tons of template changes, fixed #145 fixed #174 fixed #177 fixed #179 fixed #180 refs #182Source: Revisions of /Download from http://downloads.phpvms.net/phpvms.beta.zip

It's all done through the API's RegistrationData::AddUser() function. So, are you still not able to register?

Nope, haven't looked at it