mark1million

Thanks Jeff I have already duplicated that table to play with, will give that a go in a bit.

Ah no i have the correct output its just i need to update the database, i ran a query and reset the flighttypes all to P lol. oops Im in phpmyadmin trying to run the query to manually update the entries.

You would be better off making a plugin to bounce off the pilots table and return a yes no response then triggering the email verification page the same way as ipb does. I gave up trying after the migration and conversion failed so i stopped wasting any more time on it.

HI, I have been messing about for a few days not but cant seem to get the right code. I want to update a the pireps table flighttype field where flightnum = T1%% that's not important but i cant get it to run. Basically i have tours that i have now created a separate flighttype for, at the moment they are all in there as P for passenger flights, i want to update them to T for tours as im now reporting in the profiles flight types. Any help would be appreciated. Slightly going mad with banging my head against a wall

I was going to change over from ipb to mybb but the converters didnt work correctly, have a look in to the docs over there, there are some ways you can register new members there.

This is more a question for Jeff, My pireps table is massive currently its standing at 163mb uncompressed, Im thinking of removing the log entries over 6 months old, im sure you would do something similar, do you have a cron for the process?

Linode is fine, i have been on them for nearly 2 years now, i started off with the 512 with no problems what so ever.

Sure no problem cheers.

Hey don't apologise, great full as always for all your help Thanks...

Thanks again Dave,

Contact your server admin, looks like your out of space or php isn't configured correctly.

Thank you Dave, one change i had to make was the SUM to COUNT and that brought back the data for me. Thanks again.

Gents i am having a thought about listing flight hours by type, ie i have pax flights and cargo flights, i am looking at listing the hours separately and creating awards based on hours per types, is there anything out there that anyone else has done yet and how difficult would this be to code?

Sure i dont mind im one of the lucky ones i suppose, i run my own servers in my spare bedroom / office with a fiber connection of 50meg down and 10 meg up so running multipul servers isnt a problem for ts3. I will have to have a look about how to setup new TS servers, if i remember right its easy as i already have a licence so im not restricted.

Thats enough.

My error, I put the template in the wrong folder All i want to do now is count and display the number of flights for each pilot and im there I have tried the usual $userinfo but cant get it to display anything, would i need to update the query?

Good luck with your new venture, i would strongly suggest you upgrade to paid hosting as free hosting causes problems. Good looking layout.

Thanks Dave, im just on my way out to work now but its returning a an empty page with just the header and footer only being displayed. Will have another look when i get home tonight.

I have come across this using the pmdg 747, meant to mention to Jeff. If you send him a mail he will respond to you personally.

Dave sorry if this has been covered already i got to page 7 and it was nearly there but not quite. What im after is to display the top xx pilots in average landing rate order, so Pilot name, Average landing rate, limited to 10. I have all their averages listed on my pilots list ok but just want a table with the top 10 pilots sorted with the best average landing rate. Cheers.

Are you running the program as administrator?

HI Jeff, Thanks for that but its not updating, I have changed to the following now but still no luck. If you have any more ideas public static function acceptPilot($pilotid) { return self::updateProfile($pilotid, array( 'confirmed' => PILOT_ACCEPTED, 'retired' => 0 )); if($ret) { $sql = "UPDATE `mydbname`.`mydbrow` SET `retired` = '0', WHERE `pilotid`='.$pilotid"; $res = DB::query($sql); } }

Hi Guys, I want to mod this bit of code to update another row in the database. /** * Accept the pilot (allow them into the system) */ public static function acceptPilot($pilotid) { return self::updateProfile($pilotid, array( 'confirmed' => PILOT_ACCEPTED, 'retired' => 0 )); } I want to update another rows info can i just add a sql query in to the loop like this? /** * Accept the pilot (allow them into the system) */ public static function acceptPilot($pilotid) { return self::updateProfile($pilotid, array( 'confirmed' => PILOT_ACCEPTED, 'retired' => 0 $query = "UPDATE ".TABLE_PREFIX."mytable SET retired = "1" WHERE pilotid='$pilotid'" )); } I have not even tested this yet just thought i would post what i wanted to do first see any comments.

Sounds like your tables have been locked and your data lost, do you have a backup?

Totally Agree, my lot love it