Bi-Dir

QJ_falSEL.inc

Line #0:<BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
Line #1:<?php
Line #2:
Line #3:$Viewpar="";
Line #4://include("QJ_varlist.php");
Line #5:
Line #6:if (!isset($_POST[Qfut])) {
Line #7:
Line #8:if (isset($_GET[meMOD])) $_SESSION[meMOD]=$_GET[meMOD]; else unset($_SESSION[meMOD]);
Line #9: $_POST[Bis]=$_SESSION[Bis];
Line #10: $_POST[goon]=$_SESSION[goon];
Line #11: $_POST[Desc]=$_SESSION[Desc];
Line #12: }
Line #13:
Line #14://include("gvarlist.php");
Line #15:
Line #16:if (isset($_POST[Quick])) {
Line #17:$ipos=strpos($_POST[Quick],"##");
Line #18:}
Line #19:
Line #20:if (isset($_POST[Bis])) {
Line #21:// $Viewpar.="&Bis=".$_POST[Bis];
Line #22: $_GET[Bis]=$_POST[Bis];
Line #23: $_SESSION[Bis]=$_POST[Bis];
Line #24: $Limit="";
Line #25:// $_POST[goon]="Y";
Line #26:} else unset($_SESSION[Bis]);
Line #27:
Line #28:
Line #29:if (isset($_POST[goon])) {
Line #30://$Viewpar.="&goon=Y";
Line #31://$Limit="";
Line #32:$_GET[goon]=$_POST[goon];
Line #33:$_SESSION[goon]=$_POST[goon];
Line #34:} else unset($_SESSION[goon]);
Line #35:
Line #36:
Line #37:if (isset($_POST[Desc])) {
Line #38://///////// SORREND //////////
Line #39:$Viewpar.="&Desc=Y";
Line #40:$_GET[Desc]=$_POST[Desc];
Line #41:$_SESSION[Desc]=$_POST[Desc];
Line #42:} else unset($_SESSION[Desc]);
Line #43:
Line #44:
Line #45:
Line #46:$e=" <SELECT TITLE='Login.... '
Line #47:onchange= return true name='arselect'>
Line #48:";
Line #49:$keres = "SELECT distinct login FROM temaop order by login";
Line #50:
Line #51:$arform="?";
Line #52:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #53:{
Line #54:$e=$e."<option value='".$egy_sor[login]."'>".$egy_sor[login]."</option>";
Line #55:$arform=$egy_sor[login];
Line #56:
Line #57:}
Line #58:
Line #59:$e.="</SELECT>";
Line #60:
Line #61:
Line #62:if (isset($_POST[qcsoport])) $_SESSION[qcsoport]=$_POST[qcsoport];
Line #63: else $_POST[qcsoport]=$_SESSION[qcsoport];
Line #64:
Line #65:$parSQL = "SELECT distinct csoport FROM temaop order by csoport";
Line #66:
Line #67:
Line #68: $q="<SELECT onchange=this.form.submit();
Line #69: return true name='qcsoport'>";
Line #70:
Line #71:
Line #72:while ( $par_sor = mysql_fetch_array( $parQ )) {
Line #73://echo ($par_sor[sql_memo]."/".$par_sor[sql_parancs]."<hr>");
Line #74:if ($_POST[qcsoport]==$par_sor[csoport] ) $sel=" SELECTED "; else $sel="";
Line #75:if (trim($par_sor[csoport])<>"")
Line #76: $q=$q."<option value='".$par_sor[csoport]."' $sel>".$par_sor[csoport]."</option>";
Line #77:}
Line #78:
Line #79:$q=$q."</select>";
Line #80:
Line #81:
Line #82:
Line #83:if (isset($_POST[sorrend]) and $_POST[sorrend]<>"*") {
Line #84:$_SESSION[sorrend]=$_POST[sorrend];
Line #85:} else $_POST[sorrend]=$_SESSION[sorrend];
Line #86:
Line #87:
Line #88:$eredmeny = mysql_query('show fields from temaop');
Line #89:
Line #90: $v="<SELECT onchange=this.form.submit();
Line #91: return true name='sorrend'>";
Line #92:
Line #93:
Line #94:
Line #95:while ($row =mysql_fetch_row($eredmeny))
Line #96:{
Line #97:
Line #98:
Line #99: if ($_SESSION[sorrend]==$row[0]) $sel=" SELECTED "; else $sel="";
Line #100: $v=$v."<option value='$row[0]' $sel > $row[0]</option>";
Line #101:
Line #102:}
Line #103:
Line #104:$v=$v."</select>";
Line #105:
Line #106:?>
Line #107:<table width=100% border=0><tr><td align=left>
Line #108:<FORM name=cimform target=alfej action='QJ_falSEL.php?&meMOD=Y&NewScan=Y' method='post'>
Line #109:
Line #110:<INPUT TYPE='hidden' NAME='Qfut' value="*">
Line #111:
Line #112:
Line #113:
Line #114:<img width=15 height=15 src='../_Screen/plus.ico' border=0></a>   
Line #115:
Line #116:
Line #117:
Line #118:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #119:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #120:
Line #121:
Line #122:
Line #123:<?php echo($v); echo($q);?>
Line #124:
Line #125:onchange=this.form.submit(); return true name='Bis'>
Line #126:
Line #127:<br>
Line #128:
Line #129:
Line #130:
Line #131:
Line #132:
Line #133: TYPE='text' NAME='Bis' size=40
Line #134:value='<? if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
Line #135:>
Line #136:
Line #137:</form>
Line #138:
Line #139:</td><tr><td>
Line #140:
Line #141:<?php
Line #142:if (isset($_POST[qscan])) {
Line #143://include("QJ_cimscan.php");
Line #144:}
Line #145:?>
Line #146:</td><tr>
Line #147:<?php
Line #148:
Line #149:
Line #150:if (!isset($_GET[goon]))
Line #151:{
Line #152: UNSET($_GET[Bis]);
Line #153:}
Line #154:
Line #155:
Line #156:if (!isset($_GET[forgalom])) $_GET[forgalom]=3;
Line #157:
Line #158:
Line #159:if (isset($_GET[Desc])) $Viewpar.="&Desc=Y";
Line #160:if (isset($_GET[Bis])) $Viewpar.="&Bis=".$_GET[Bis];
Line #161:if (isset($_GET[forgalom])) $Viewpar.="&forgalom=".$_GET[forgalom];
Line #162:
Line #163:$ParHead="<table>";
Line #164:$export=false;
Line #165://$tabla=$_GET["tabla"];
Line #166:$biord="";
Line #167:$tabla="temaop";
Line #168:
Line #169:
Line #170:/*if (isset($_POST[Desc])) {
Line #171:
Line #172:}*/
Line #173:
Line #174:
Line #175:if (isset($_POST["biord"])) {
Line #176:$biord= " order by ".$_POST["biord"];
Line #177:if (isset($_POST[Desc])) {
Line #178:
Line #179:$biord.=" DESC";
Line #180:}
Line #181:} else $biord= " order by csoport";
Line #182:
Line #183://///////////// si12 /////////////
Line #184:if (isset($_SESSION[sorrend])) {
Line #185:$biord= " order by ".$_SESSION[sorrend];
Line #186:if (isset($_POST[Desc])) {
Line #187:$biord.=" DESC";
Line #188:}
Line #189:}
Line #190:
Line #191:
Line #192:ECHO('<html>
Line #193:<title>'. $tabla.' </title>
Line #194:');
Line #195:
Line #196:$eredmeny = mysql_query('show fields from '.$tabla);
Line #197:
Line #198:$fid='';
Line #199:$qee='<table width=700 BORDER=1 ><tr>';
Line #200:$fullRec="CONCAT_WS(";
Line #201:$vesszo="";
Line #202:$qee .= '<td width=50> </td>';
Line #203:
Line #204:$i=0;
Line #205:while ($row =mysql_fetch_row($eredmeny))
Line #206:{
Line #207:$fid.=$row[0] . ":";
Line #208://if ($i>2 and $i<8)
Line #209://$qee .= '<td width=100><b><a href="temaop.php?&tabla='.$tabla.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
Line #210:$qee .= '<td width=100><b>'.$row[0].'</b></td>';
Line #211:++$i;
Line #212://$fullRec.=$vesszo."Upper(".$row[0].")";
Line #213:$fullRec.=$vesszo."(".$row[0].")";
Line #214:$vesszo=",'/', ";
Line #215:
Line #216:}
Line #217:
Line #218:$full=$fullRec.")";
Line #219:
Line #220:$fullRec.=") as full";
Line #221:$fid.="full:";
Line #222:
Line #223://echo($fullRec."<hr>");
Line #224:
Line #225:if (isset($_GET[Bis]) and $_GET[Bis]<>"") $wer=" Where usr_kod<>'*DEL' and leiras<>'' and INSTR((".$full."),'".$_GET[Bis]."') "; else $wer=" Where usr_kod<>'*DEL' and leiras<>'' ";
Line #226://INSTR(UPPER(".$full."),'".strtoupper($_GET[Bis])."') "; else $wer="";
Line #227:
Line #228:
Line #229:if (!isset($_POST[goon]) and isset($_POST[Bis])) {
Line #230:$bislen=strlen($_POST[Bis]);
Line #231://if ($bislen>1) $Limit="";
Line #232:$wer=" Where usr_kod<>'*DEL' and leiras<>'' and left(leiras,".$bislen.")='".$_POST[Bis]."'";
Line #233:
Line #234:}
Line #235:
Line #236:
Line #237:$qee .= '</tr>';
Line #238://$keres = "SELECT * ,".$fullRec ." FROM " . $tabla . $wer . $biord;
Line #239:
Line #240:
Line #241:if (substr($_GET[Bis],0,2)=="//" and strlen($_GET[Bis])>4) {
Line #242:
Line #243: $sqlwer=substr($_GET[Bis],2,strlen($_GET[Bis])-2);
Line #244:// echo "<script language = javascript>";
Line #245:// echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
Line #246:// echo "</script>";
Line #247:
Line #248:$keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
Line #249:
Line #250://print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
Line #251:
Line #252:
Line #253:$nurL=mysql_num_rows($eredmeny);
Line #254:$nur=$nurL;
Line #255://$Limit="";
Line #256:$biord="";
Line #257:
Line #258:////////
Line #259:} else {
Line #260:////////
Line #261:
Line #262:
Line #263:$keres = "SELECT wid FROM " . $tabla ;
Line #264:
Line #265:$nurX=mysql_num_rows($eredmeny);
Line #266:
Line #267:$keres = "SELECT wid FROM " . $tabla . $wer . $biord;
Line #268:
Line #269:
Line #270:$nurL=mysql_num_rows($eredmeny);
Line #271:
Line #272:$limit=" ";
Line #273:
Line #274:if (isset($_SESSION[qcsoport]) and $_SESSION[qcsoport]<>"*") {
Line #275:if ($wer<>"")
Line #276:$wer.= " and csoport='".$_SESSION[qcsoport]."'";
Line #277:else $wer= " where csoport_kod='".$_SESSION[qcsoport]."'";
Line #278:}
Line #279:
Line #280:$keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
Line #281:
Line #282:
Line #283:$nur=mysql_num_rows($eredmeny);
Line #284:
Line #285:if (substr($_POST[Bis],0,1)=="*" )
Line #286:{
Line #287:$wid=substr($_POST[Bis],1,strlen($_POST[Bis])-1);
Line #288:$keres = "SELECT * FROM " . $tabla . " where wid=$wid";
Line #289:
Line #290:
Line #291:
Line #292:$nur=mysql_num_rows($eredmeny);
Line #293:
Line #294:}
Line #295:
Line #296:}
Line #297:
Line #298://-?-//echo($keres."<hr>");
Line #299:
Line #300://if ($nurL<1001) $Limit="";
Line #301:
Line #302:$Limit=" ";
Line #303:
Line #304:
Line #305:
Line #306:$head=$ParHead;
Line #307:
Line #308:if ($nur==0) {
Line #309:
Line #310:$ee =$head.$ee. '</table>';
Line #311:echo($ee);
Line #312:
Line #313:echo($nur."/".$keres."<hr>");
Line #314:
Line #315:
Line #316:exit;
Line #317:}
Line #318:
Line #319://if ($nur>20 ) {
Line #320:
Line #321:$keres = "SELECT * FROM " . $tabla . $wer . $biord . " ";
Line #322:
Line #323:
Line #324://if ($_POST[forgalom]==3 or !isset($_POST[forgalom]))
Line #325:
Line #326:
Line #327:
Line #328://$ee =$head.$ee. '</table>';
Line #329://echo($ee);
Line #330:
Line #331://}
Line #332:
Line #333:if (isset($_SESSION[meMOD]) or isset($_POST[submit]))
Line #334:{ $_SESSION[memoSQL]=$keres;
Line #335:$_SESSION[meMOD]="Y";
Line #336:
Line #337:///?///echo($nur."/".$keres."<hr>");
Line #338:
Line #339:echo "<script>
Line #340: window.open('QJ_fal.php', 'adatframe');
Line #341: </script>";
Line #342:exit;} else { unset($_SESSION[memoSQL]); unset($_SESSION[meMOD]);}
Line #343:///?/// echo($nur."/".$keres."<hr>");
Line #344:
Line #345:
Line #346:$nur=mysql_num_rows($eredmeny);
Line #347:
Line #348://echo($nur."<hr>head".$head."<hr>qee".$qee);
Line #349:
Line #350:if ($nur==0) { $head=""; $qee="";}
Line #351:
Line #352:$ii=0;
Line #353:
Line #354:$h=split(':',$fid);
Line #355:
Line #356:$e= $head.$qee;
Line #357:
Line #358:echo($e);
Line #359:
Line #360:
Line #361:$bgszin="white";
Line #362:
Line #363:for($i=0;$i<$nur;$i++) {
Line #364:
Line #365:$e="";
Line #366:
Line #367:$r=mysql_fetch_row($eredmeny);
Line #368:
Line #369:$vevo=$r[0];
Line #370:
Line #371:/*$keresE = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elojegy];
Line #372:
Line #373:$nurE=mysql_num_rows($eredmenyE);
Line #374:
Line #375:$keresF = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elad];
Line #376:
Line #377:$nurF=mysql_num_rows($eredmenyF);
Line #378:*/
Line #379:
Line #380:$ii++;
Line #381:$e .= '<tr width=700 >';
Line #382:$e.='<td width=80 ALIGN=center>';
Line #383:
Line #384:$e.='<a target=sframe href=QJ_falUPD.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #385:
Line #386:
Line #387://$e.=' <a target=sframe href=temaopUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #388:
Line #389:
Line #390:if ($nurF>0)
Line #391:$e.='<br>
Line #392:<A target=sframe STYLE="{vlink : gold}"
Line #393:href="QJ_eladasok.php?&vevo='.$r[0].'">
Line #394:
Line #395:'.$nurF.' db
Line #396:<A target=adatframe STYLE="{vlink : gold}"
Line #397:href="QJ_cimDIRECT.php?&cimjav=Y&vevo='.$r[0].'">
Line #398:
Line #399:
Line #400:if ($nurE>0)
Line #401:$e.='<br>'.$nurE.' db
Line #402:<A target=sframe STYLE="{vlink : gold}"
Line #403:href="QJ_elojegyzesek.php?&vevo='.$r[0].'">
Line #404:
Line #405:
Line #406:$e.='</td>';
Line #407:
Line #408:
Line #409:if ($bgszin=="white") $bgszin="silver"; else $bgszin="white";
Line #410:
Line #411:// email cim kihagyva !!!
Line #412://$e .= '<td width=100 bgcolor='.$bgszin.'> '.$r[3].'<br><font color=red>'.$r[9].'</font> </td>';
Line #413:
Line #414:for($j=0,$k=0;$j<count($r);$j++) {
Line #415:
Line #416:
Line #417://$e .= '<td width=50 bgcolor='.$bgszin.'> '.htmlspecialchars($r[$j]).' </td>';
Line #418:$e .= '<td width=100 bgcolor='.$bgszin.'> '.$r[$j].' </td>';
Line #419:
Line #420:}
Line #421:
Line #422://$e .= '<td width=100 bgcolor='.$bgszin.'><font color=red>'.$r[2].'</font></td>';
Line #423:
Line #424:$e .= '</tr>';
Line #425:
Line #426:
Line #427:echo($e);
Line #428:
Line #429:}
Line #430:
Line #431:$e = '</table>';
Line #432:echo($e);
Line #433:
Line #434:
Line #435:echo($e);
Line #436:
Line #437:?>
Line #438:</tr></table>
Line #439: