Bi-Dir

QJ_musor.old

Line #0:<?php
Line #1:
Line #2:IF (isset($_POST[datum_fej]) and $_SESSION[hely_kod]==$_POST[hely_kod]) $_POST[hely_kod]="*";
Line #3:IF (isset($_POST[hely_kod]) and $_SESSION[datum_fej]==$_POST[datum_fej] ) $_POST[datum_fej]="*";
Line #4:
Line #5:$_SESSION[hely_kod]=$_POST[hely_kod];
Line #6:$_SESSION[datum_fej]=$_POST[datum_fej];
Line #7:
Line #8:
Line #9:$disQ = "SELECT distinct cim FROM qj_musor where archiv<>'*' and future<>'*' and cim<>'' order by cim" ;
Line #10:
Line #11:
Line #12:
Line #13:onchange=this.form.submit(); return true name='eloadas_cim'>";
Line #14:
Line #15:
Line #16:
Line #17:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #18:if ($disC[cim]==$_POST[eloadas_cim]) $sel="SELECTED"; else $sel="";
Line #19:$selE.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #20://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #21:}
Line #22:
Line #23:$selE.="</SELECT>";
Line #24:
Line #25:
Line #26:
Line #27:
Line #28:$disQ = "SELECT distinct helyszin,hely_kod FROM qj_musor where archiv<>'*' and future<>'*' and helyszin<>'' order by hely_kod" ;
Line #29:
Line #30:
Line #31:
Line #32:onchange=this.form.submit(); return true name='hely_kod'>";
Line #33:
Line #34:
Line #35:
Line #36:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #37:if ($disC[hely_kod]==$_POST[hely_kod]) $sel="SELECTED"; else $sel="";
Line #38:$sel2.="<option value='".$disC[hely_kod]."' $sel >".$disC[helyszin]."</option>";
Line #39://echo($disC[hely_kod]."/".$disC[helyszin]."<hr>");
Line #40:}
Line #41:
Line #42:$sel2.="</SELECT>";
Line #43:
Line #44:
Line #45:$disQ = "SELECT distinct datum_fej FROM qj_musor where archiv<>'*' and future<>'*' order by datum_fej" ;
Line #46:
Line #47:
Line #48:$sel3="<SELECT TITLE='Nap'
Line #49:onchange=this.form.submit(); return true name='datum_fej'>";
Line #50:
Line #51:
Line #52:
Line #53:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #54:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #55:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #56:}
Line #57:
Line #58:$sel3.="</SELECT>";
Line #59:
Line #60:
Line #61:
Line #62:
Line #63:?>
Line #64:
Line #65:<FORM name=cimform target=sframe action='QJ_musor.php' method='post'>
Line #66:
Line #67:<? echo($sel3); ?>     <? echo($sel2); ?>     <? echo($selE); ?>
Line #68:
Line #69:</form>
Line #70:
Line #71:<?
Line #72:
Line #73:
Line #74:$x="<td><a href=QJ_musor.php TARGET='sframe'>
Line #75:
Line #76: <td width=10></td>";
Line #77:
Line #78:
Line #79:
Line #80:$y="<tr><td colspan=9><a href=QJ_musSEL.php TARGET='alfej'>
Line #81:
Line #82: ";
Line #83:
Line #84:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*' ";
Line #85:
Line #86:$archiv=" archiv <>'*' and future <>'*'";
Line #87:
Line #88:IF (isset($_GET[hely_kod])) { $full=$x; $wer=" where $archiv and hely_kod='".$_GET[hely_kod]."'";}
Line #89:IF (isset($_GET[cim_kod])) { $full=$x; $cim=str_replace("~"," ",$_GET[cim_kod]); $wer=" where $archiv and cim='".$cim."'";}
Line #90:IF (isset($_POST[eloadas_cim]) and $_POST[eloadas_cim]<>"*") { $full=$x; $cim=str_replace("~"," ",$_POST[eloadas_cim]); $wer=" where $archiv and cim='".$cim."'";}
Line #91:
Line #92:IF (isset($_GET[datum_fej])) { $full=$x; $wer=" where $archiv and datum_fej='".$_GET[datum_fej]."'";}
Line #93:IF (isset($_POST[hely_kod]) and $_POST[hely_kod]<>"*" ) { $full=$x; $wer=" where $archiv and hely_kod='".$_POST[hely_kod]."'";}
Line #94:IF (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*" ) { $full=$x; $wer=" where $archiv and datum_fej='".$_POST[datum_fej]."'";}
Line #95:
Line #96:if ($wer=="" ) $wer=" where $archiv";
Line #97:
Line #98:IF (substr($_SESSION[admin],0,4)=="OF10") { $full=$x; $wer=" where $archiv and hely_kod='".$_SESSION[admin]."'";}
Line #99:
Line #100:
Line #101:$keres = "SELECT * FROM qj_musor $wer ORDER BY `datum_fej`";
Line #102:
Line #103:///////////////////
Line #104://BI_alert($keres);
Line #105:///////////////////
Line #106:
Line #107:
Line #108:$nur=mysql_num_rows($eredmeny);
Line #109:
Line #110:echo('<table STYLE="{color : black; font-size: 12px;}" ALIGN="center">');
Line #111:
Line #112:$li=0;
Line #113:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #114:
Line #115:$h=$egy_sor[helyszin].'<br> '.$egy_sor[cim].'<br> '.$egy_sor[datum];
Line #116://$f=$egy_sor[datum_fej];
Line #117:$u=$egy_sor[datum_url];
Line #118:$q=$egy_sor[datum_kod];
Line #119:$c=$egy_sor[cim_url];
Line #120:$g=$egy_sor[hely_url];
Line #121:
Line #122:$k=$egy_sor[kep_url];
Line #123:
Line #124:
Line #125:$c="QJ_helyrajz.php?&musor_kod=".$egy_sor[datum_kod];
Line #126:
Line #127:$d="QJ_musor.php?&datum_fej=".$egy_sor[datum_fej];
Line #128:
Line #129:$g="QJ_musor.php?&hely_kod=".$egy_sor[hely_kod];
Line #130:
Line #131:$e="QJ_musor.php?&cim_kod=".$cim=str_replace(" ","~",$egy_sor[cim]);
Line #132:
Line #133:
Line #134:
Line #135://$qwe=strtolower($u);
Line #136://if (strpos($qwe, 'http')=0) $u=$c;
Line #137:$u=$c;
Line #138:
Line #139:$fs='';
Line #140://if (!empty($f)) $fs="<b STYLE='{font-size: 12px; color : #000066;}'>".$f."</b><br>";
Line #141:
Line #142://if (empty($u)) $u=$c;
Line #143:
Line #144:$li++;
Line #145:
Line #146:if ($li>3) $li=1;
Line #147:
Line #148: $vez1='<td width=90></td><td>';
Line #149: $vez2='</td>';
Line #150:
Line #151:if ($li=1) {
Line #152: $vez1='<tr><td width=90></td><td>';
Line #153: $vez2='</td>';
Line #154:}
Line #155:
Line #156:if ($li=3) {
Line #157: $vez1='<td width=90></td><td>';
Line #158: $vez2='</td></tr>';
Line #159:}
Line #160:
Line #161:
Line #162://echo '<tr><td width=90></td><td>';
Line #163://echo $vez1;
Line #164:
Line #165://echo "<p bgcolor=green align='center'>
Line #166://<a href=$g TARGET='adatframe'><b STYLE='{font-size: 12px; color : Olive;}'>$egy_sor[helyszin]</b></a><br>
Line #167://<a href=$c TARGET='adatframe'><b STYLE='{font-size: 18px; color : Teal;}'>$egy_sor[cim]</b></a><br>
Line #168://<a href=$u TARGET='adatframe'><b STYLE='{font-size: 14px; color : Teal;}'>$d</b></a><br>
Line #169://".$fs."
Line #170://<a href='wj_box.php?&mfltr=$q' TARGET='adatframe'><img src='mejegyrr.jpg'></a><br>
Line #171://";
Line #172:
Line #173://echo"</p>";
Line #174:
Line #175:if (substr($egy_sor[usr_kod],0,2)=="OF") $cim="<font color=blue><b>".$egy_sor[cim]."</b></font>"; else
Line #176:$cim="<a href=".$e." TARGET='sframe'><b>$egy_sor[cim]</b></a>";
Line #177:
Line #178:echo "<tr>
Line #179:
Line #180:<td><a href=$c TARGET='adatframe'>$w</a></td>
Line #181:<td width=10></td>
Line #182:
Line #183:<td><a href=$d TARGET='sframe'><b>$egy_sor[datum]</b></a><br></td>
Line #184:".$fs."
Line #185:
Line #186:<td width=10></td>
Line #187:
Line #188:<td>$cim</td>
Line #189:<td width=10></td>
Line #190:<td align=left><a href=$g TARGET='sframe'><b>$egy_sor[helyszin]</b></a></td>
Line #191:<td width=10>$full</td>
Line #192:
Line #193:" ;
Line #194:
Line #195:echo"</tr>";
Line #196:
Line #197:
Line #198://<br><center><img src='bar.gif' border='0'></center>
Line #199:
Line #200://echo '</td></tr>';
Line #201://echo $vez2;
Line #202:
Line #203:}
Line #204:
Line #205:echo('</table>');
Line #206:
Line #207:/*echo('<center><img src=../Screen/bar.gif>
Line #208: </center><p align=center>
Line #209: <font face=Verdana, Arial, Helvetica, sans-serif style=FONT-SIZE: 10px color=#000066 size=1>Copyright©
Line #210: <a href="http://www.maxin.hu/Diak" target=_top>Qjegy2011 </a><br>
Line #211: 2010.</font></p>');
Line #212:*/
Line #213:
Line #214:
Line #215:?>
Line #216:
Line #217:<SCRIPT LANGUAGE="JavaScript">
Line #218:
Line #219:
Line #232:
Line #233:</script>
Line #234:
Line #235:
Line #236:
Line #237:<body background='hatadat.jpg' CELLSPACING='0' CELLPADDING='0' onLoad="loadSFrame()" >
Line #238:</body>