QJ_rendezvenyVIEW.inc
Line #0:<?php
Line #1:
Line #2:include("QJ_selectMUSOR.inc");
Line #3:
Line #4:
Line #5:?>
Line #6:
Line #7:<FORM name=cimform target=sframe action='QJ_rendezvenyVIEW.php' method='post'>
Line #8:
Line #9:<? echo($selH);
Line #10:/*<input type='text' value='<?php print $datumjel; ?>' name='datumjel' size=50>
Line #11:<input type='text' value='<?php print $datum; ?>' name='datum'>
Line #12: */
Line #13:?>
Line #14:
Line #15:
Line #16:</form>
Line #17:
Line #18:<?
Line #19:
Line #20:
Line #21:
Line #22:
Line #23:
Line #24:
Line #25:
Line #26:
Line #27:
Line #28:IF (isset($_SESSION[berlet_nev])) { $wer=" where cim='".$_SESSION[berlet_nev]."'";}
Line #29:IF ($_SESSION[berlet_nev]=="")
Line #30: { $wer="";}
Line #31://////////////////////////////////////
Line #32:IF (isset($_POST[hely_nev])) { $wer=" and helyszin='".$_POST[hely_nev]."'";}
Line #33:IF ($_POST[hely_nev]=="") { $wer="";}
Line #34:if ($_SESSION['admin']=='UNIQ')
Line #35:$Qwhere=" where (INSTR('".$_SESSION[Quniq]."',datum_kod)) and future<>'*' "; else $Qwhere=" where future<>'*' ";
Line #36:
Line #37:$keres = "SELECT * FROM qj_musor $Qwhere and left(datum_fej,1)<>'B' and archiv<>'*' $wer ORDER BY `cim`";
Line #38://////////////////
Line #39://BI_alert($keres);
Line #40:///////////////////
Line #41://echo($keres."<br>");
Line #42:
Line #43:
Line #44:$nur=mysql_num_rows($eredmeny);
Line #45:
Line #46:IF ($nur==0) {
Line #47:
Line #48:
Line #49:
Line #50:
Line #51:} else {
Line #52:
Line #53:echo('<table border=1 STYLE="{color : black; font-size: 12px;}" ALIGN="center">');
Line #54:
Line #55:$berlet_kod="*";
Line #56:$li=0;
Line #57:while ( $egy_sor = mysql_fetch_array( $eredmeny )) {
Line #58:
Line #59:$wjid=$egy_sor[wid];
Line #60:$h=$egy_sor[helyszin].'<br> '.$egy_sor[cim].'<br> '.$egy_sor[datum];
Line #61:$q=$egy_sor[datum_kod];
Line #62:
Line #63:$berlet_kod=$egy_sor[berlet_Azonosito];
Line #64:
Line #65:$datumjel=str_replace(" ","~",$datumjel);
Line #66:
Line #67:
Line #68:$rel_rejt="<a target=infoframe href='QJ_sqlJEGY.php?¶ncs=// Update qj_musor set berlet_nev=~".
Line #69:
Line #70:else $rel_rejt="";
Line #71:
Line #72:
Line #73:
Line #74:$c="QJ_helyrajz.php?&musor_kod=".$egy_sor[datum_kod];
Line #75:$atf="QJ_musorPUBLIC.php?&wjid=".$egy_sor[wid];
Line #76: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 #77:else { $OKEZ=""; }
Line #78:
Line #79://$bh="QJ_SIforgat.php?&musor_kod=".$egy_sor[datum_kod];
Line #80:$bh=$bhurl.$egy_sor[datum_kod];
Line #81:
Line #82:/*$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 #83:
Line #84:$nur=mysql_num_rows($Jeredmeny);*/
Line #85:
Line #86: if ($egy_sor[JeBe] =="Napi") {
Line #87:
Line #88: $mind=(strpos("1Su 2Mo 3Tu 4We 5Th 6Fr 7Sa",substr(date("D"),0,2))/3);
Line #89:
Line #90:
Line #91: $nap[3]=" Kedd ";
Line #92: $nap[4]=" Szerda ";
Line #93:
Line #94:
Line #95: $nap[7]=" Szombat ";
Line #96:
Line #97: $datum=date("Y.m.d")." ".$nap[$mind-1];
Line #98:
Line #99: $SQLarc = "UPDATE `qj_musor` SET
Line #100: `datum`='$datum'
Line #101: where `wid`='".$wjid."'; ";
Line #102:
Line #103:
Line #104: } else $datum=$egy_sor[datum];
Line #105:
Line #106:
Line #107:echo "<tr>
Line #108:<td><a href=$c TARGET='adatframe'>$ww</a></td>
Line #109:<td><b>$datum</b></td>
Line #110:<td><font color=red ><b>$egy_sor[cim]</td>
Line #111:<td align=left><b>$egy_sor[helyszin]</b></td>
Line #112:</tr>";
Line #113:
Line #114:}
Line #115:
Line #116:echo('</table>');
Line #117:
Line #118:}
Line #119:include("../_inc_BI/BI_Copyright.php");
Line #120:
Line #121:include("QJ_stop.php")
Line #122:
Line #123:?>
Line #124:
Line #125:<SCRIPT LANGUAGE="JavaScript">
Line #126:<!-- Begin
Line #127:function loadSFrame() {
Line #128:
Line #129:msg=window.open("QJ_musSEL.php", 'alfej');
Line #130:msg=window.open("QJ_musSELvez.php", 'infoframe');
Line #131:
Line #132:}
Line #133:// End -->
Line #134:</script>
Line #135:
Line #136:<BODY BORDER=0 background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left"
Line #137:onLoad="loadSFrame()" >