QQ_evhoSELECT.inc

---

Line #0:<?php
Line #1:IF (!isset($_POST[Rhonap]) and !isset($_SESSION[Rhonap]) or substr($_SESSION[Rhonap],0,1)<>"2")
Line #2:$_POST[Rhonap]=date("Y.m");
Line #3:
Line #4:IF (isset($_POST[Rhonap])) $_SESSION[Rhonap]=$_POST[Rhonap];
Line #5:IF (isset($_SESSION[Rhonap])) $_POST[Rhonap]=$_SESSION[Rhonap];
Line #6:
Line #7://////////////////////////////////////////////////////////////////////////////////////////
Line #8:
Line #9://////////////////////////////////////////////////////////////////////////////////////////
Line #10://$disQ = "SELECT distinct datum_evho as datum FROM qj_musor order by datum_evho " ;
Line #11:
Line #12:$disQ = "SELECT * FROM qj_musor where datum_evho='' order by datum_kod " ;
Line #13://?//echo($disQ."<hr>");
Line #14:
Line #15:
Line #16:$nur=mysql_num_rows($disR);
Line #17:
Line #18:if ($nur>0 and $_SESSION[login]=="BI(c)" and isset($_SESSION[qontroll])) {
Line #19://////////////////////////////////////////////////
Line #20:
Line #21:echo "<tr bgcolor=silver>
Line #22:
Line #23:
Line #24:
Line #25:
Line #26:
Line #27:<td align=right>FormaJel - JeBe</td>
Line #28:</tr>" ;
Line #29:
Line #30:
Line #31:while ( $musor = mysql_fetch_array( $disR ) ) {
Line #32:
Line #33:if ($musor[archiv]=="*") $rejtett="<br><font color=red> Rejtett</font>"; else $rejtett="";
Line #34:
Line #35:
Line #36:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$musor[wid]
Line #37: target=adatframe><IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #38: </a>";
Line #39:
Line #40: $mcall="<a href=QJ_helyrajz.php?&musor_kod=$musor[datum_kod]
Line #41: target=adatframe><IMG width=20 height=20 SRC='../_Screen/time.gif' border=0>
Line #42: </a>";
Line #43:
Line #44:
Line #45:echo "<tr>
Line #46:<td align=right>$medi<br>$mcall<font size=+2 color=GREEN>$musor[datum_evho]</font></td>
Line #47:<td align=right><font color=red size=+1><b>$musor[datum_fej]</font></td>
Line #48:<td align=right><font color=blue size=+1><b>$musor[datum_kod]</b><br>$musor[berlet_Azonosito]<font color=red ><br>$musor[berlet_kod]</i></font></td>
Line #49:<td><font size=+1><b>$musor[cim]</b><br><b>$musor[datum]</b></td>
Line #50:<td>$musor[hely_kod] <br>$musor[helyszin]</font></td>
Line #51:<td align=right><b>$musor[FormaJel] $musor[JeBe]</b><br> $r $rejtett</td>
Line #52:" ;
Line #53:echo"</tr>";
Line #54:
Line #55:$disY="SELECT distinct left(logtime,7) as datum_evho FROM qj_jegy where
Line #56: ar>0 and future <>'*' and $_SESSION[SQL_elad] and datum_kod='$musor[datum_kod]' ORDER BY logtime DESC";
Line #57://?//echo($disY."<hr>");
Line #58:
Line #59:
Line #60:$nur=mysql_num_rows($disC);
Line #61:
Line #62:if ($nur>0) {
Line #63:
Line #64: $Rhonap=str_replace("-",".",$egy_sor[datum_evho]); // biztos, ami biztos !!!
Line #65:
Line #66: $egy_sor = mysql_fetch_array( $disC );
Line #67: $disY="Update qj_musor set datum_evho='$Rhonap' where datum_kod='$musor[datum_kod]' ";
Line #68:
Line #69:
Line #70:echo"<tr><td colspan=10>$disY</td></tr>";
Line #71:
Line #72:}
Line #73:
Line #74:}
Line #75:
Line #76:echo('</table>');
Line #77:
Line #78:}
Line #79:
Line #80:
Line #81:if ($selEVHO=="jegy")
Line #82:$disQ="SELECT distinct left(logtime,7) as datum_evho FROM qj_jegy where
Line #83: ar>0 and future <>'*' and $_SESSION[SQL_elad] ORDER BY logtime";
Line #84:else
Line #85:$disQ = "SELECT distinct datum_evho FROM qj_musor order by datum_evho " ;
Line #86:
Line #87://?//echo($disQ."<hr>");
Line #88:
Line #89:
Line #90:
Line #91:
Line #92:onchange=this.form.submit(); return true name='Rhonap'>";
Line #93:
Line #94:
Line #95:
Line #96:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #97:
Line #98:$datum=$disC[datum_evho];
Line #99:
Line #100:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #101:if (trim($datum)<>"")
Line #102:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #103:else
Line #104:$sel4.="<option value='".$datum."' $sel >*NINCS*</option>";
Line #105:}
Line #106:
Line #107:$sel4.="</SELECT>";
Line #108:
Line #109:if (isset($_GET[nyomtat])) $bord='0'; else $bord='1';
Line #110:
Line #111:if (!isset($_GET[nyomtat])) {
Line #112:echo "
Line #113:<form name='formF' method='POST' target='' action=''>
Line #114:
Line #115:$sel4
Line #116:";
Line #117:
Line #118:echo "
Line #119:</form>";
Line #120:
Line #121:}
Line #122:?>