QJ_mailVEZ.inc

---

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