Bi-Dir

_Q_musorCREATEview.inc

Line #0:<?php
Line #1:
Line #2:IF (isset($_GET[limit])) $limit=" limit $_GET[limit] "; else $limit=" limit 0,50 ";
Line #3:
Line #4://IF (isset($_POST[musor_cim])) $_SESSION[musor_cim]=$_POST[musor_cim];
Line #5://IF (isset($_SESSION[musor_cim])) $musor_cim=$_SESSION[musor_cim];
Line #6:
Line #7:IF (isset($_POST[musor_cim])) $_SESSION[musor_cim]=$_POST[musor_cim];
Line #8:IF (isset($_SESSION[musor_cim])) $musor_cim=$_SESSION[musor_cim];
Line #9:;
Line #10:IF (isset($_POST[cimkezd])) $_SESSION[_SEL_cimkezd]=$_POST[cimkezd];
Line #11:IF (isset($_SESSION[_SEL_cimkezd])) $cimkezd=$_SESSION[_SEL_cimkezd] ;
Line #12:
Line #13:IF (isset($_POST[datumjel])) $_SESSION[datumjel]=$_POST[datumjel];
Line #14:IF (isset($_SESSION[datumjel])) $datumjel=$_SESSION[datumjel];
Line #15:IF (isset($_POST[datum])) $_SESSION[datum]=$_POST[datum];
Line #16:IF (isset($_SESSION[datum])) $datum=$_SESSION[datum];
Line #17:
Line #18:
Line #19:if ($cimkezd<>"") $wer= " where INSTR('$cimkezd',cim) "; else $wer="";
Line #20:
Line #21:
Line #22:$selE.="</SELECT>";
Line #23:
Line #24:$disQ = "SELECT distinct cim FROM qj_musor $wer order by cim" ;
Line #25:
Line #26:
Line #27://?//echo($disQ."<br>");
Line #28:$sel2="<SELECT TITLE='musor_cim'
Line #29:onchange=this.form.submit(); return true name='musor_cim'>";
Line #30:
Line #31:
Line #32:
Line #33:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #34:if ($disC[cim]==$_POST[musor_cim]) $sel="SELECTED"; else $sel="";
Line #35:$sel2.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #36:}
Line #37:
Line #38:$sel2.="</SELECT>";
Line #39:
Line #40:
Line #41:$sql="SELECT * FROM qj_sql where szoveg='musor_ord' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #42:
Line #43:$psor = mysql_fetch_array( $sqlpar );
Line #44:$fid=$psor[sql_memo];
Line #45:$h=split(':',$fid);
Line #46:$nORD=count($h)-1;
Line #47:
Line #48:if (!isset($_POST[sorrend])) $_POST[sorrend]="wid";
Line #49:$ord=" order by ".$_POST[sorrend];
Line #50:
Line #51:$sel5="  <b>Sorrend:</b><SELECT TITLE='Sorrend'
Line #52:onchange=this.form.submit(); return true name='sorrend'>";
Line #53:
Line #54:for ($i=0;$i<$nORD;$i++) {
Line #55:
Line #56:if ($h[$i]==$_POST[sorrend]) $sel="SELECTED"; else $sel="";
Line #57:$sel5.="<option value='".$h[$i]."' $sel >".$h[$i]."</option>";
Line #58:}
Line #59:
Line #60:$sel5.="</SELECT>";
Line #61:
Line #62:
Line #63:
Line #64:?>
Line #65:
Line #66:<FORM name=cimform target=infoframe action='QJ_musorCREATEview.php' method='post'>
Line #67:
Line #68:
Line #69:
Line #70:<? echo($sel2. " " .$sel5); //
Line #71:/*<input type='text' value='<?php print $datumjel; ?>' name='datumjel' size=50>
Line #72:<input type='text' value='<?php print $datum; ?>' name='datum'>
Line #73: */
Line #74:?>    
Line #75:
Line #76:
Line #77:
Line #78:</form>
Line #79:
Line #80:<?
Line #81:
Line #82:
Line #83:
Line #84:
Line #85:
Line #86:
Line #87:
Line #88:
Line #89:
Line #90:IF (isset($_SESSION[musor_cim])) { $wer=" where cim='".$_SESSION[musor_cim]."'";}
Line #91:
Line #92:IF ($_SESSION[musor_cim]=="") { $wer="";}
Line #93:
Line #94://
Line #95:$keres = "SELECT * FROM qj_musor $wer ORDER BY `wid` DESC";
Line #96://echo($keres."<br>");
Line #97:
Line #98:
Line #99:if ($musor_cim<>""){
Line #100: $keres = "SELECT * FROM qj_musor where cim='$musor_cim' $ord DESC ";
Line #101:} else {
Line #102: $keres = "SELECT * FROM qj_musor $ord DESC $limit";
Line #103:}
Line #104:
Line #105://?//echo($keres."<br>");
Line #106:
Line #107:
Line #108:$nur=mysql_num_rows($eredmeny);
Line #109:
Line #110:echo('<table border=1 STYLE="{color : black; font-size: 12px;}" ALIGN="center">');
Line #111:
Line #112:$berlet_kod="*";
Line #113:$li=0;
Line #114:$ind=0;
Line #115:
Line #116:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #117:
Line #118:
Line #119:if ($egy_sor[archiv]=="*") $rejtett="<br><font color=red> Rejtett</font>"; else $rejtett="";
Line #120:
Line #121:$h=$egy_sor[helyszin].'<br> '.$egy_sor[cim].'<br> '.$egy_sor[datum];
Line #122:$q=$egy_sor[datum_kod];
Line #123:
Line #124:$berlet_kod=$egy_sor[berlet_Azonosito];
Line #125:
Line #126:$datumjel=str_replace(" ","~",$datumjel);
Line #127:
Line #128:
Line #129:$rel_rejt="<a target=infoframe href='QJ_sqlJEGY.php?&parancs=// Update qj_musor set musor_cim=~".
Line #130:
Line #131:else $rel_rejt="";
Line #132:
Line #133:
Line #134:
Line #135:$c="QJ_helyrajz.php?&musor_kod=".$egy_sor[datum_kod];
Line #136:$atf="QJ_musorPUBLIC.php?&wjid=".$egy_sor[wid];
Line #137: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 #138:else { $OKEZ=""; }
Line #139:
Line #140:$OKEZ="<a target=adatframe
Line #141:
Line #142:
Line #143:
Line #144:
Line #145://$bh="QJ_SIforgat.php?&musor_kod=".$egy_sor[datum_kod];
Line #146:$bh=$bhurl.$egy_sor[datum_kod];
Line #147:
Line #148:$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 #149:
Line #150:$nur=mysql_num_rows($Jeredmeny);
Line #151:
Line #152:
Line #153:if (isset($_POST[earmod]))
Line #154:$esql = "SELECT * FROM qj_ear WHERE datum_kod='".$egy_sor[datum_kod]."'";
Line #155:else
Line #156:$esql = "SELECT * FROM qj_ear WHERE datum_kod='".$egy_sor[datum_url]."'";
Line #157:
Line #158:
Line #159:
Line #160:$r="";
Line #161:$br="";
Line #162:while ( $esor = mysql_fetch_array( $etabla ) )
Line #163:{
Line #164:
Line #165:$r=$r.$br."<a href=QJ_earCOPY.php?&wnew=$egy_sor[datum_kod],&wjid=$esor[wid]
Line #166: target=adatframe >".
Line #167:$esor[szoveg].":<b>".$esor[qj_ear1]."</b></a>";
Line #168:$br="<br>" ;
Line #169:}
Line #170:
Line #171:
Line #172:
Line #173:++$ind;
Line #174:
Line #175:$helyszin=$egy_sor[helyszin]."<br>";
Line #176:if ($egy_sor[rovid_helyszin]<>"") $helyszin=$egy_sor[rovid_helyszin]."<br>";
Line #177:
Line #178:
Line #179:
Line #180:echo "<tr>
Line #181:<td align=right><font color=green><b>$egy_sor[datum_evho]</font>
Line #182:<font color=blue><b>$egy_sor[berlet_kod]<br>
Line #183:<font size=+2>$nur</font></b><br>
Line #184:<font color=red size=+1><b>$egy_sor[datum_fej]</font>$rejtett</td>
Line #185:<td><a href=$atf TARGET='adatframe'>$qq</a><br>
Line #186:$ind<hr>
Line #187: <a href=$c TARGET='adatframe'>$ww</a></td>
Line #188:<td><font size=+1><b>$egy_sor[datum]</b><br><font color=blue size=+1><b>
Line #189: $egy_sor[datum_kod]</b></font></td>
Line #190:<td>$egy_sor[hely_kod] <b>$helyszin<font size=+1 color=red>$egy_sor[cim]
Line #191: </b></td>
Line #192:<td align=right><b>$egy_sor[FormaJel] $egy_sor[JeBe]</b><br> $r </td>
Line #193:" ;
Line #194:echo"</tr>";
Line #195:}
Line #196:
Line #197:echo('</table>');
Line #198:
Line #199:
Line #200:include("../_inc_BI/BI_Copyright.php");
Line #201:
Line #202:include("QJ_stop.php")
Line #203:
Line #204:?>
Line #205:
Line #206:
Line #207:
Line #208:<body background='hatadat.jpg' CELLSPACING='0' CELLPADDING='0' >
Line #209:</body>