mattia

ok i find the error but dont'work the result is 0 <?php $date = date('d-m-Y'); $query = 'SELECT * FROM '.TABLE_PREFIX.'pireps WHERE submitdate < $date; AND pilotid = {$userinfo->pilotid}'; $result = DB::get_row($query); $flightstoday = count($result); echo $flightstoday; ?> is very difficult this code

thanks but dont work this error Parse error: syntax error, unexpected T_VARIABLE in /var/xxxxxxx/pilot_public_profile.tpl on line 87 <?php $today = date('Y-m-d') $query = 'SELECT * FROM '.TABLE_PREFIX.'pireps ------this is line 87 WHERE submitdate < $date; AND pilotid = {$userinfo->pilotid}'; $result = DB::get_row($query); $flightstoday = count($result); echo $flightstoday; ?> many thanks for your help sir

thanks itrobb but still does not work for the first code appears error this Fatal error: Cannot break/continue 1 level in /var/www/virtual/italianivolanti.it/htdocs/iv/core/templates/pilot_public_profile.tpl on line 96 <?php $pilotid = $userinfo->pilotid; $pireps = PIREPData::getAllReportsForPilot($pilotid); $today = date('Y-m-d'); if(($pireps->submitdate) == $today) { echo $pireps; } else { continue;---this is line 96 } ?> for the second code appears error this Parse error: syntax error, unexpected T_STRING in /var/www/xxxxxxxxxx/templates/pilot_public_profile.tpl on line 87 <?php $query = 'SELECT COUNT(*) AS total FROM '.TABLE_PREFIX.'pireps WHERE submitdate < date('Y-m-d');--------------this is line 87 AND pilotid = {$userinfo->pilotid}'; $result = DB::get_row($query); $flightstoday = count($result); echo $flightstoday; ?>

hi itrobb thanks for help.....for the first code appears error this Fatal error: Call to undefined function getAllReportsForPilot() in /varxxxxxxxxxxxxxxxx/templates/pilot_public_profile.tpl on line 87 for the second code nothing appears

ok thanks

Hi kyle hi itrobb thanks for your help but it does not work, the result is always 0, but I have to change dmy in the code?

echo 0 I is not did no flying today

hi all boys I created this code to see, (in pilot_public_profile.tpl,) how many flights did today a pilot, but does not work. the result is always 0 <?php $query = 'SELECT COUNT(*) AS total FROM '.TABLE_PREFIX.'pireps WHERE submitdate >= NOW() -172800 AND pilotid = $userinfo->pilotid '; $result=DB::get_row($query); if (!$result){ echo 0; } else { echo $result->total; } ?> Can you help me to understand why?? thank you very much

Hi Wood What do you mean by: Missions Flown Night Day IFR: Possibly maybe AA kills AG kils Naval kills Static kills

problem solved??

Hi Wood to decrease the text, go to the file: app.config.php in your core folder and find this code # Options for the signature that's generated Config::Set('SIGNATURE_TEXT_COLOR', '#ff0000'); Config::Set('SIGNATURE_USE_CUSTOM_FONT', true); Config::Set('SIGNATURE_FONT_PATH', SITE_ROOT.'/lib/fonts/tahoma.ttf'); Config::Set('SIGNATURE_FONT_SIZE', '10'); Config::Set('SIGNATURE_X_OFFSET', '10'); Config::Set('SIGNATURE_Y_OFFSET', '27'); Config::Set('SIGNATURE_FONT_PADDING', 4); Config::Set('SIGNATURE_SHOW_EARNINGS', true); Config::Set('SIGNATURE_SHOW_RANK_IMAGE', true); Config::Set('SIGNATURE_SHOW_COPYRIGHT', true); This code changes the value: (change the number, look at my badge below) Config::Set('SIGNATURE_Y_OFFSET', '27');

register to this site is free http://www.edi-gla.co.uk

hi Wood I tried on my airline to change the color and it works for me (look at my badge below) for change the signature on the application go in your pilot center and change Signature Background and go in admin center/Site & Settings/ Maintenance Options and click "Reset Signatures" I do not know for hours, trying to do a "reset hours" and "optimize table" in your admin center

sorry but I have not understood your problem, you can not change the color? sorry for my bad english

HI Wood In your app.config.php and in your local.config.php file inside the folder "core" find this code: # Options for the signature that's generated Config::Set('SIGNATURE_TEXT_COLOR', '#FF0000'); Config::Set('SIGNATURE_USE_CUSTOM_FONT', true); Config::Set('SIGNATURE_FONT_PATH', SITE_ROOT.'/lib/fonts/tahoma.ttf'); Config::Set('SIGNATURE_FONT_SIZE', '10'); Config::Set('SIGNATURE_X_OFFSET', '10'); Config::Set('SIGNATURE_Y_OFFSET', '17'); Config::Set('SIGNATURE_FONT_PADDING', 4); Config::Set('SIGNATURE_SHOW_EARNINGS', true); Config::Set('SIGNATURE_SHOW_RANK_IMAGE', true); Config::Set('SIGNATURE_SHOW_COPYRIGHT', true); in the first line Config::Set('SIGNATURE_TEXT_COLOR', '#FF0000'); change "#FF0000" with your favorite color taken from this site: http://www.december.com/html/spec/colorhex.html and finally go in the admin center/Site & Settings/ Maintenance Options and click "Reset Signatures"

i have the same problem

Many thanks Dave now works perfectly!!!

Hi Dave I tried your code works, but in the mail that i have received the spam email is not present "Spam pilot registration rejected using email and IP address 79.4.191.124 on 05/09/2012 at 11:58am" many thanks

Thanks Dave

Hi Simpilot I tried your code but it does not work, I tried to register with an email to my site taken from "http://www.stopforumspam.com" and the registration is successful

wow!! many thanks Kyle

hi all boys You think you can have for every single aircraft stastistiche her? example: B747 Total Flights:... Total Distance:.... Average Flight Distance:.... Total Hours:.... as the page "Aircraft Reports" but each aircraft separated best regards

I'm not sure but try this $this->set('comment', xxxData::xxxSearch($icao)); $this->render('xxx_searche.tpl');

hi flyalaska I tried, but it does not work..thanks for help (I include photos)

hi Nabel I updated my virtual airline but when I click on "Reset Count PIREP Pilot" all my pilot have 0 flights is my problem? thanks for help