QJ_musorEAR.inc
Line #0:<?php
Line #1:
Line #2:
Line #3:IF (isset($_POST[berlet_nev])) $_SESSION[berlet_nev]=$_POST[berlet_nev];
Line #4:IF (isset($_SESSION[berlet_nev])) $berlet_nev=$_SESSION[berlet_nev];
Line #5:
Line #6:IF (isset($_POST[datumjel])) $_SESSION[datumjel]=$_POST[datumjel];
Line #7:IF (isset($_SESSION[datumjel])) $datumjel=$_SESSION[datumjel];
Line #8:IF (isset($_POST[datum])) $_SESSION[datum]=$_POST[datum];
Line #9:IF (isset($_SESSION[datum])) $datum=$_SESSION[datum];
Line #10:
Line #11:
Line #12:$selE.="</SELECT>";
Line #13:
Line #14:$disQ = "SELECT distinct cim FROM qj_musor where JeBe='Jegy' and future<>'*' order by cim" ;
Line #15:
Line #16:
Line #17:$sel2="<SELECT TITLE='berlet_nev'
Line #18:onchange=this.form.submit(); return true name='berlet_nev'>";
Line #19:
Line #20:
Line #21:
Line #22:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #23:if ($disC[cim]==$_POST[berlet_nev]) $sel="SELECTED"; else $sel="";
Line #24:$sel2.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #25:}
Line #26:
Line #27:$sel2.="</SELECT>";
Line #28:
Line #29:
Line #30:
Line #31:
Line #32:?>
Line #33:
Line #34:<FORM name=cimform action='QJ_musorEAR.php' method='post'>
Line #35:
Line #36:<? echo($sel2); ?> <br>
Line #37:<input type='text' value='<?php print $datumjel; ?>' name='datumjel' size=50>
Line #38:<input type='text' value='<?php print $datum; ?>' name='datum'>
Line #39:
Line #40:</form>
Line #41:
Line #42:<?
Line #43:
Line #44:
Line #45:
Line #46:
Line #47:
Line #48:
Line #49:
Line #50:
Line #51:
Line #52:IF (isset($_SESSION[berlet_nev])) { $wer=" where cim='".$_SESSION[berlet_nev]."'";}
Line #53:
Line #54:IF ($_SESSION[berlet_nev]=="") { $wer="";}
Line #55:
Line #56:$keres = "SELECT * FROM qj_musor $wer ORDER BY `wid` DESC";
Line #57:
Line #58://$keres = "SELECT * FROM qj_musor ORDER BY `wid` DESC";
Line #59:///////////////////
Line #60://BI_alert($keres);
Line #61:///////////////////
Line #62:echo($keres."<br>");
Line #63:
Line #64:
Line #65:$nur=mysql_num_rows($eredmeny);
Line #66:
Line #67:echo('<table border=1 STYLE="{color : black; font-size: 12px;}" ALIGN="center">');
Line #68:
Line #69:$berlet_kod="*";
Line #70:$li=0;
Line #71:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #72:
Line #73:$h=$egy_sor[helyszin].'<br> '.$egy_sor[cim].'<br> '.$egy_sor[datum];
Line #74:$q=$egy_sor[datum_kod];
Line #75:
Line #76:$berlet_kod=$egy_sor[berlet_Azonosito];
Line #77:
Line #78:$datumjel=str_replace(" ","~",$datumjel);
Line #79:
Line #80:
Line #81:$rel_rejt="<a target=infoframe href='QJ_sqlJEGY.php?¶ncs=// Update qj_musor set berlet_nev=~".
Line #82:
Line #83:else $rel_rejt="";
Line #84:
Line #85:
Line #86:
Line #87:$c="QJ_helyrajz.php?&musor_kod=".$egy_sor[datum_kod];
Line #88:$atf="QJ_musorPUBLIC.php?&wjid=".$egy_sor[wid];
Line #89:if ($egy_sor[JeBe]=="Jegy" and $egy_sor[last_index]<2 ) $OKEZ="<a href=QJ_musorSTART.php?&wjid=$egy_sor[wid]&berlet_kod=$berlet_kod&datum=$datum&datumjel=$datumjel TARGET='adatframe'>$yy</a>";
Line #90:else { $OKEZ=""; }
Line #91:
Line #92://$bh="QJ_SIforgat.php?&musor_kod=".$egy_sor[datum_kod];
Line #93:$bh=$bhurl.$egy_sor[datum_kod];
Line #94:
Line #95:$Jkeres = "SELECT * FROM qj_jegy where datum_kod='$egy_sor[datum_kod]' and archiv='-' and statusz<>'' and left(statusz,2)<>'St' and left(statusz,2)<>'El'";
Line #96:
Line #97:$nur=mysql_num_rows($Jeredmeny);
Line #98:
Line #99:
Line #100:echo "<tr>
Line #101:<td>$OKEZ<br>
Line #102:<td><a href=$atf TARGET='adatframe'>$qq</a><br>
Line #103:<td><a href=$c TARGET='adatframe'>$ww</a><br>
Line #104:<td><b>$egy_sor[datum]</b><br><font color=blue size=+1><b>$egy_sor[datum_kod]</b></font></td>
Line #105:<td><font size=+1 color=red><b>$egy_sor[cim]<br><font color=blue size=+1><b>$egy_sor[datum_fej]</b></font></td>
Line #106:<td align=left>$egy_sor[helyszin]<br><font color=blue><b>$egy_sor[berlet_kod]<br><font size=+2>$nur</font></b></td>
Line #107:<td><font size=+1 color=red><b>$egy_sor[berlet_nev]<br><font color=blue size=+1><b>$egy_sor[berlet_kod]</b></font></td>
Line #108:
Line #109:" ;
Line #110:
Line #111:echo"</tr>";
Line #112:
Line #113:echo "<tr>
Line #114:<td colspan=10><table width=100% border=1 bgcolor=yellow>
Line #115:
Line #116:<td width=10%><b>$egy_sor[alapar1]
Line #117:<td width=10%><b>$egy_sor[alapar2]
Line #118:<td width=10%><b>$egy_sor[alapar3]
Line #119:<td width=10%><b>$egy_sor[alapar4]
Line #120:<td width=10%><b>$egy_sor[alapar5]
Line #121:<td width=10%><b>$egy_sor[alapar6]
Line #122:<td width=10%><b>$egy_sor[alapar7]
Line #123:<td width=10%><b>$egy_sor[alapar8]
Line #124:<td width=10%><b>$egy_sor[alapar9]
Line #125:<td width=10%><b>$egy_sor[alapar0]
Line #126:</table>
Line #127:" ;
Line #128:
Line #129:echo"</tr>";
Line #130:
Line #131:
Line #132:}
Line #133:
Line #134:echo('</table>');
Line #135:
Line #136:
Line #137:include("../_Lib_Bi/BI_Copyright.php");
Line #138:
Line #139:include("QJ_stop.php")
Line #140:
Line #141:?>
Line #142:
Line #143:
Line #144:
Line #145:<body background='hatadat.jpg' CELLSPACING='0' CELLPADDING='0' >
Line #146:</body>