mark1million

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

Well what i did was change that file above to read from, $comment .= 'FSPassengers Flight. No aircraft entered'; Change it to $comment .= 'FSPassengers Flight Pirep'; You can change it to whatever you like really or just comment it out all together.

HI im not sure what you mean, sorry. What codes?

I dont have this on any more, can you send to me and i will have a look

Cheers i will have a look through that.