CPC900

How do I change the color values in the stats pie chart?? From the profile_stats.tpl file?

Average? Anyone?

Yes, thanks again Jeff!!!

But Jeff, how do you get the lines to show ON the map? It just shows a blank map with the flights listed in text underneath?! What is the point of the map?! Actually, wait....you are asking for that same thing, aren't you? Sorry.

BTW, I know we have the "my stats" thing through the pilot center; I just wanted to basically add the listing of flight hours by numbers with a graphical "certified" pic in a separate chart, maybe below the current pie chart....if you see what I mean.

On my old site, I had a page that showed a pilots stats by aircraft type. It listed how many hours a pilot flew per aircraft and had a "certified" picture if he flew enough hours.... Anyways, how is the best way to go about pulling out that info from the database? To give you an idea of what I had a long time ago... <? print "<center>"; print "<b><font size=+3 color=#D86C4D>$callsign Fleet Stats</font></b><br>"; print "<hr width=800 align=center>"; $conn = mysql_connect mysql_select_db $query = "SELECT pilotid, equipment, ROUND((SUM(time_to_sec(duration))/3600),2) AS block, COUNT(duration) AS flights FROM pireps WHERE callsign = '$callsign' GROUP BY equipment"; $result = mysql_query($query) or die(mysql_error()); echo "<table border='1'>"; echo "<tr> <th>Aircraft</th> <th>Flights</th> <th>Hours</th> <th>Certified</th></tr>"; while($row = mysql_fetch_array($result)){ echo "<tr><td align=left>"; echo $row['equipment']; echo "</td><td align=center>"; echo $row['flights']; echo "</td><td align=center>"; echo $row['block']; echo "</td><td align=center>"; $var1 = '<img src="../pics/misc/orangerank.gif">'; if($row['block']>9.9 && $row['equipment']=='DC3'){ echo $var1; }if($row['block']>9.9 && $row['equipment']=='DC6'){ echo $var1; }if($row['block']>99.9 && $row['equipment']=='B737-200'){ echo $var1; }if($row['block']>124.9 && $row['equipment']=='B727-100'){ echo $var1; }if($row['block']>124.9 && $row['equipment']=='B727-200'){ echo $var1; }if($row['block']>159.9 && $row['equipment']=='DC8-43'){ echo $var1; }if($row['block']>159.9 && $row['equipment']=='DC8-53'){ echo $var1; }if($row['block']>159.9 && $row['equipment']=='DC8-55'){ echo $var1; }if($row['block']>199.9 && $row['equipment']=='DC8-63'){ echo $var1; }if($row['block']>274.9 && $row['equipment']=='DC10-10'){ echo $var1; }if($row['block']>299.9 && $row['equipment']=='DC10-30'){ echo $var1; }if($row['block']>499.9 && $row['equipment']=='B747-200'){ echo $var1; }if($row['block']>39.9 && $row['equipment']=='ATR72-500'){ echo $var1; }if($row['block']>59.9 && $row['equipment']=='CRJ-200'){ echo $var1; }if($row['block']>74.9 && $row['equipment']=='BAe146-200'){ echo $var1; }if($row['block']>124.9 && $row['equipment']=='B737-300'){ echo $var1; }if($row['block']>124.9 && $row['equipment']=='B737-700'){ echo $var1; }if($row['block']>149.9 && $row['equipment']=='B757-200'){ echo $var1; }if($row['block']>299.9 && $row['equipment']=='B767-300'){ echo $var1; }if($row['block']>399.9 && $row['equipment']=='MD11'){ echo $var1; }if($row['block']>499.9 && $row['equipment']=='B747-400'){ echo $var1; } echo "</td></tr>"; } echo "</table>"; ?> Is there a template that already does something like that?

Yes Jeff, I am familiar with that thread It was just that, incorporating a new menu into my already completed drop down system, was proving difficult for me. I just don't get it sometimes. It seemed like adding a multi level to what I had should be easy, but I couldn't get it to work correctly.

Yes, I have seen it, but he doesn't have a second tier for his menu either. I like my dropdown menu, that I have.....I just want to add a 2nd tier to my menu choic for some values and it seems like a pain in the butt to edit mine to do this. I am sure it is not that hard for someone who knows what they are doing, but it looks like I will have to do mine over from scratch. If you look at my site, for instance... http://www.canadianclassicairlines.com/CPC/ You would see a lot more choices if you are a member and logged in, of course. But I would want to just add a menu that juts out from one of the dropdown menu choices. That is why I posted my code, in hopes someone could give me a hint. Anyways, forget about it. I will rewrite the .css and core_navigation.tpl files using one of the many examples out there.

Well, the current script works fine for a single menu, and I understand it. I find when I go to change it, I need to change a bunch of stuff that i don't get how it actually should work. I have screwed around with it, but I always %&$#% it up. The only way I can see to fix it, is completely starting over with my dropdown menu.....I was just hoping someone could give a quick heads up on how to do a quick fix to what I already have.

And just so you know....I HAVE looked at the previous links to drop down menus and HAVE read about them, but I obviously have a serious brain cramp in making it work with what I already have. I just don't want to start over with the menu thing, because it looks great and works fine the way it is, but I need to add a second tier to break up the menus for spacing and have had no luck with my current menu code by making changes that I read on varios .css sites. Thanks so much.

Ok, sorry to bring this up again, but I am getting pissed off that I can't figure this out. I want to expand my drop down menu and I have tried and tried, but can't get it right without starting from scratch. I just want to add a 2 tier to the menu. Can someone tell me what to do with my current css and tpl to make this happen easily. body { behavior:url("csshover.htc"); } #sddm { background-color: #AD1919; width: 100%; overflow:hidden; text-align:center; margin: 0 auto; padding: 0; z-index: 30 } #sddm ul { margin: 0 auto; padding:0; text-align:center; } #sddm li { margin: 0 auto; padding: 0; list-style: none; float: left; font: bold 11px arial } #sddm li a { display: block; margin: 0 1px 0 0; padding: 4px 10px; width: 90px; background: #AD1919; color: #FFF; text-align: center; text-decoration: none } #sddm li a:hover { background: #AD1919 } #sddm div { position: absolute; visibility: hidden; margin: 0; padding: 0; background: #EAEBD8; border: 1px solid #AD1919 } #sddm div a { position: relative; display: block; margin: 0; padding: 5px 10px; width: auto; white-space: nowrap; text-align: left; text-decoration: none; background: #F6643B; color: #000000; font: 11px arial } #sddm div a:hover { background: #AD1919; color: #FFF } I can paste my full core_navigation.tpl if needed, but here is a sample of that as well... <ul id="sddm"> <li><a href="<?php echo SITE_URL ?>/index.php/Frontpage">Home</a> </li> <?php if(!Auth::LoggedIn()) { // Show these if they haven't logged in yet ?> <li><a href="<?php echo SITE_URL ?>/index.php/login" onmouseover="mopen('m1')" onmouseout="mclosetime()">User Log In</a> <div id="m1" onmouseover="mcancelclosetime()" onmouseout="mclosetime()"> <a class="main_link" href="<?php echo SITE_URL ?>/index.php/login">Login</a> <a class="main_link" href="<?php echo SITE_URL ?>/index.php/registration">Sign Up</a> </div> </li>

Yeah, it doesn't show on IE8 at home here. But FF is fine. Oh well. There is a javascript error. Here is what it shows: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDC; InfoPath.1; OfficeLiveConnector.1.5; OfficeLivePatch.1.3) Timestamp: Sun, 20 Jun 2010 03:14:16 UTC Message: Unspecified error. Line: 25 Char: 517 Code: 0 URI: http://maps.gstatic.com/intl/en_ca/mapfiles/api-3/1/5a/main.js Message: Unspecified error. Line: 8 Char: 90 Code: 0 URI: http://maps.gstatic.com/intl/en_ca/mapfiles/api-3/1/5a/main.js Message: Unspecified error. Line: 26 Char: 70 Code: 0 URI: http://maps.gstatic.com/intl/en_ca/mapfiles/api-3/1/5a/main.js

Checked it at work...IE6, and it was fine. Will check it again when home, which was IE8. Can't remember if it was same thing with Firefox?!

Seems like I have lost the red line on the acars map that shows the route?! I see the arrival/departure icons and nav icons along the way....bur NO red line showing the route. Any idea why this would disappear? I did not do anything, it just left. I cleared the cache and optimized tables, but this was after the line went away??

Yes, it almost needs to have otpions to grab different data from different sites based on what ident you choose. Although, I did get notam results from all the ones I did check on that ourairports.com site, so I am happy with it......for now.

So for the other site, which seems to have more data, try: <td width="50%" ><?php echo "{$schedule->depname} ($schedule->depicao)"; ?><br /> <a href="http://www.ourairports.com/airports/<?php echo $schedule->depicao?>/pilot-info.html" target="_blank">Click here to check the Notam's & Airport Info</a></td> <td width="50%" ><?php echo "{$schedule->arrname} ($schedule->arricao)"; ?><br /> <a href="http://www.ourairports.com/airports/<?php echo $schedule->arricao?>/pilot-info.html" target="_blank">Click here to check the Notam's & Airport Info</a></td>

Sorry to be the bad guy here, but..... KLAX came back with the same "No Data Available" as well, but... http://ourairports.mobi/airports/KLAX/notams.html That will show you a wealth of Notams for KLAX. So I assume, the notams.com site has a lack of data or I am missing something?!

Yes, it says "No Data Available". But it should give current notams of: 100178 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ TWY AG CLSD TIL APRX 1007292359 100179 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ THR 23 DISPLACED 200 FT BEYOND PUB DTHR DUE OBST 1100 FT NE OF PUB DTHR 23, 38 FT AGL, 592 MSL, MARKED BY ORANGE MARKERS AND WING BAR LGT EITHER SIDE OF RWY. DECLARED DIST: RWY 05: TORA 11120 TODA 11435 ASDA 11120 LDA 10985 RWY 23: TORA 11120 TODA 12120 ASDA 11120 LDA 10435 ILS OR NDB RWY 23 APCH: TCH TO READ 45 FT VICE 55 FT RWY 23 DEP: ACFT REQUIRING FULL LEN MUST NOTIFY GROUND CTL UPON INITIAL CTC. TIL APRX 1007311700 100266 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ WEF 1006030901 AMEND CANADA AIR PILOT VOL 4: ALL LDG CHARTS: TWY G EAST OF TWY E CLSD 100267 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ STAR(RNAV) QUIET HR PROCEDURE RWY 05, 06L 06R, 23 24L, 24R WASIE TWO ARR: WASIE ON REQUEST REPORTING POINT: RWY 05, 06L, 06R: MNM ALT TO READ 10000 FT VICE 11000 FT 1006030901 TIL APRX 1008301400 100274 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ SEQUENCED FLASHING APCH LGT 24R U/S TIL APRX 1009031410 100298 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ TWY B CLSD BTN TWY B4 AND TWY R DUE MAINT 1005171100 TIL 1006181800 100311 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ ILS CAT II AND III APCH RWY 05 NOT AUTH. ILS OUTSIDE CAT II TOLERANCES TIL APRX 1009161600 100312 CYYZ TORONTO/LESTER B.PEARSON INTL ZLP- MEADOWVALE NDB 341 U/S TIL 1007162359 100313 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ TWY B2 CLSD. TWY B CLSD BTN TWY AG AND TWY S. TWY R CLSD BTN RWY 33R/15L AND TWY B. DUE CONST. 1006181801 TIL 1008202200 100314 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ RWY 33R/15L CLSD DUE MAINT 1006181400 TIL 1006181800 100315 CYYZ TORONTO/LESTER B.PEARSON INTL CYYZ RWY 06R/24L CLSD 1006181600 TIL 1006191900

I tried CYYZ and CYUL, but it showed NO notams.

That seems to omit Notams from North America now, though. It would be nice to find a happy medium.

Thanks for the country link thing. So this 'code' literrally just gets enterred as text and all works fine? I have never used it before, so that is why I was wondering from someone who has. I am just not used to doing something "without" code, as it were.

I am new to this .htaccess thing. Can you post an example of what you have added?! Thanks.

One last question(hopefully), about drop down menus.....I see my dropdown menus fine on IE7 and IE8, but I want them to work with IE6 as well. Is there something I can do to force that on my end? Because I can't change anything on the computer that won't show the menus in IE6(long story). Other drop downs show up, so not sure why mine don't in IE6?!?

Ok, it is ONLY the B732, on the "EPA" company, that does not show fuel. I missed the HS748 in the fuel.tpl, so that is fine now, but it is that B732 that is weird. But for whatever reason. it shows the fuel details for the B732, except EPA's?! I have checked the database and it is basically the same details. I am probably just missing something obvious.

No, they ALL have flight times.