Bi-Dir

BiViewTable.php

Line #0:<?php include("QJ_start.php");
Line #1:
Line #2:
Line #3:if (isset($_GET[bimod])) { $_GET[Desc]="*"; $_GET[biord]="wid";}
Line #4:
Line #5:if (isset($_GET[goon])) $_POST[goon]=$_GET[goon];
Line #6:if (isset($_GET[Desc])) $_POST[Desc]=$_GET[Desc];
Line #7:if (isset($_GET[Bis])) $_POST[Bis]=$_GET[Bis];
Line #8:if (isset($_GET[Export])) $_POST[Export]=$_GET[Export];
Line #9:if (isset($_GET[biord])) $_POST[biord]=$_GET[biord];
Line #10:if (isset($_GET[Limit])) $_POST[Limit]=$_GET[Limit];
Line #11:if (!isset($_POST[Limit])) $_POST[Limit]=50;
Line #12:
Line #13:$_POST[Bis]=trim($_POST[Bis]);
Line #14:if (isset($_GET[sql])) $_POST[Bis]=$_GET[sql];
Line #15:
Line #16:
Line #17:?>
Line #18:
Line #19:<BODY background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
Line #20:<?
Line #21:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #22:?>
Line #23:
Line #24:<FORM name=cimform action='BiViewTable.php?&tabla=<? echo($_GET[tabla]); ?>' method='post'>
Line #25:   
Line #26:
Line #27:<? if (isset($_POST[goon])) echo(' CHECKED '); ?>
Line #28:onchange=this.form.submit(); return true name='goon'
Line #29:
Line #30:> Egyedi... </a><?if (isset($_POST[goon])) echo("(E)");?>  
Line #31:
Line #32:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #33:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #34:
Line #35:> Sorrend<?if (isset($_POST[Desc])) echo("(S)");?>  
Line #36:
Line #37:
Line #38:
Line #39: TYPE='text' NAME='Bis' size=60
Line #40: value='<?php if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
Line #41:> Limit:
Line #42:
Line #43:
Line #44:
Line #45:
Line #46: TYPE='text' NAME='Limit' size=5
Line #47: value='<?php if (isset($_POST[Limit])) echo($_POST[Limit]); ?>'
Line #48:> Keres:
Line #49:
Line #50:
Line #51:
Line #52:>
Line #53:
Line #54:
Line #55:
Line #56:onchange=this.form.submit(); return true name='Bis'>
Line #57:<br>
Line #58:
Line #59:<?
Line #60:
Line #61:$Viewpar="";
Line #62:$Limit=" Limit ".$_POST[Limit];
Line #63://// IDEIGLENES ///
Line #64://$_POST[Desc]="Y";
Line #65:
Line #66:if (isset($_POST[Del])) $Viewpar.="&Del=Y";
Line #67:if (isset($_POST[Desc])) $Viewpar.="&Desc=Y";
Line #68://if (isset($_POST[Export])) { $Viewpar.="&Export=Y"; $Limit=""; }
Line #69:if (isset($_POST[Export])) $Viewpar.="&Export=Y";
Line #70:if (isset($_POST[Last])) $Viewpar.="&Last=".$_POST[Last];
Line #71:if (isset($_POST[Limit])) $Viewpar.="&Limit=".$_POST[Limit];
Line #72:if (isset($_POST[Bis])) $Viewpar.="&Bis=".trim($_POST[Bis]);
Line #73:if (isset($_POST[Modate])) $Viewpar.="&Modate=".$_POST[Modate];
Line #74:
Line #75:$ParHead="";
Line #76:$export=false;
Line #77:$tabla=$_GET["tabla"];
Line #78:$biord="";
Line #79:
Line #80:// echo "<script language = javascript>";
Line #81:// echo "alert('".$Viewpar."');";
Line #82:// echo "</script>";
Line #83:
Line #84://echo "<script language = javascript>";
Line #85:
Line #86://echo "</script>";
Line #87:
Line #88:$_SESSION['sqlfile']=$tabla;
Line #89:
Line #90:echo("<a target=NEWframe href='bisqlupd.php?&sqlfile=&wjid=-1'
Line #91:
Line #92:
Line #93:if (isset($_POST[Last])) {
Line #94:
Line #95:}
Line #96:
Line #97:if (isset($_POST[Desc])) {
Line #98:
Line #99:}
Line #100:
Line #101:if (isset($_POST["biord"])) {
Line #102:$biord= " order by ".$_POST["biord"];
Line #103:if (isset($_POST[Desc])) {
Line #104:
Line #105:$biord.=" DESC";
Line #106:}
Line #107:}
Line #108:
Line #109:if (isset($_POST[Del])) {
Line #110:
Line #111:$Viewpar.="&Del=*";
Line #112:}
Line #113:
Line #114:if (isset($_POST[Export])) {
Line #115:
Line #116:$export=true;
Line #117:}
Line #118:
Line #119:ECHO('<html>
Line #120:<title>'. $tabla.' </title>
Line #121:');
Line #122:
Line #123:
Line #124:$ee='<table BORDER=1 bgcolor="#DBE6E0" ><tr><td></td>';
Line #125:$fullRec="CONCAT_WS(";
Line #126:$vesszo="";
Line #127:$fid='';
Line #128:
Line #129:$eredmeny = mysql_query('show fields from '.$tabla);
Line #130:
Line #131:while ($row =mysql_fetch_row($eredmeny))
Line #132:{
Line #133:$fid.=$row[0] . ":";
Line #134:$ee .= '<td with=50><b><a href="BiViewTable.php?&tabla='.$tabla.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
Line #135:
Line #136:$fullRec.=$vesszo."(".$row[0].")";
Line #137:$vesszo=",'/', ";
Line #138:
Line #139:}
Line #140:
Line #141:$full=$fullRec.")";
Line #142:
Line #143:$fullRec.=") as full";
Line #144:$fid.="full:";
Line #145:
Line #146:if (isset($_POST[Bis]) and $_POST[Bis]<>"") $wer=" Where INSTR((".$full."),'".($_POST[Bis])."') "; else $wer="";
Line #147:
Line #148:if (strpos('?'.$fid,"deleted")>0) $totolve="deleted=0";
Line #149:if (strpos('?'.$fid,"torolve")>0) $totolve="torolve=0";
Line #150:
Line #151:if (isset($_POST[Del])) {
Line #152:
Line #153:if ($wer<>"")
Line #154:$wer.= " and ".$totolve;
Line #155:else
Line #156:$wer.= " Where ".$totolve;
Line #157:}
Line #158:
Line #159:if (isset($_POST[Modate])) {
Line #160:
Line #161:if (strpos('?'.$fid,"sync_date")>0)
Line #162:$datumscan="INSTR((sync_date),'".($_POST[Modate])."') ";
Line #163:else
Line #164:$datumscan="INSTR((".$full."),'".($_POST[Modate])."') ";
Line #165:
Line #166:if ($wer<>"")
Line #167:$wer.= " and " .$datumscan;
Line #168:else
Line #169:$wer.= " Where ".$datumscan;
Line #170:
Line #171:}
Line #172:
Line #173:if (isset($_POST[Last]) and strpos("?".$fid,"sync_id")>0) {
Line #174:
Line #175:if ($wer<>"")
Line #176:$wer.= " and sync_id=".$_POST[Last];
Line #177:else
Line #178:$wer.= " Where sync_id=".$_POST[Last];
Line #179:}
Line #180:
Line #181:
Line #182:$ee .= '</tr>';
Line #183:
Line #184:if (substr($_POST[Bis],0,2)=="//" and strlen($_POST[Bis])>4) {
Line #185:
Line #186: $sqlwer= str_replace("~", "'",substr($_POST[Bis],2,strlen($_POST[Bis])-2));
Line #187:// Use of the count parameter is available as of PHP 5.0.0
Line #188://$str = str_replace("ll", "", "good golly miss molly!", $count);
Line #189://echo $count; // 2
Line #190:
Line #191:
Line #192:// echo "<script language = javascript>";
Line #193:// echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
Line #194:// echo "</script>";
Line #195:
Line #196:$keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
Line #197:
Line #198:print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
Line #199:
Line #200:
Line #201:$nurL=mysql_num_rows($eredmeny);
Line #202:$nur=$nurL;
Line #203:$Limit="";
Line #204:$biord="";
Line #205:
Line #206:////////
Line #207:} else {
Line #208:////////
Line #209:
Line #210:$keres = "SELECT * FROM " . $tabla . $wer . $biord;
Line #211://echo("<hr>".$keres."<hr>");
Line #212:
Line #213:
Line #214:$nurL=mysql_num_rows($eredmeny);
Line #215:
Line #216:$keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
Line #217://echo("<hr>".$keres."<hr>");
Line #218:
Line #219:
Line #220:
Line #221:$nur=mysql_num_rows($eredmeny);
Line #222:
Line #223:}
Line #224:
Line #225:///////////////////////////////////
Line #226://echo("<hr>".$keres."<hr>");
Line #227:///////////////////////////////////
Line #228:
Line #229:if ($nurL<1001) $Limit="";
Line #230:
Line #231:
Line #232:'</font></b><hr>';
Line #233:
Line #234:$head=$head.'<b>'.($tabla).
Line #235:'</b>  Reccount:<b>  '.$nurL.
Line #236:'</b> <font color=blue> <b>'.$biord.
Line #237:'</b>  <b>'.$Limit.
Line #238:'</b></font><br></table>';
Line #239:
Line #240:if (!$nur) {
Line #241:
Line #242:$ee =$head.$ee. '</table>';
Line #243:echo($ee);
Line #244:
Line #245:
Line #246:
Line #247:include ("gvarlist.php");
Line #248:
Line #249:exit;
Line #250:}
Line #251:
Line #252:$ii=0;
Line #253:
Line #254:$h=split(':',$fid);
Line #255:
Line #256:$e= $head.$ee;
Line #257:
Line #258:
Line #259:for($i=0;$i<$nur;$i++) {
Line #260:
Line #261:$r=mysql_fetch_row($eredmeny);
Line #262:
Line #263:$ii++;
Line #264:// $e .= '<tr bgcolor="#A7C2B3"><td bgcolor=gold>'.$i.'</td>';
Line #265:$e .= '<tr bgcolor="#A7C2B3">';
Line #266:$e .= '<td>
Line #267:<A STYLE="{vlink : gold}" target=ediFrame
Line #268:href="BI_ediTable.php?&wjid='.$r[0].'&sqlfile='.$tabla.'">
Line #269:<IMG width=20 height=20 SRC="../Screen/edit.png" border=0></a>
Line #270:';
Line #271:
Line #272:$e .= '
Line #273:<A STYLE="{vlink : gold}" target=ediFrame
Line #274:href="BI_sqlRECopy.php?&wjid='.$r[0].'&tabla='.$tabla.'">
Line #275:<IMG width=20 height=20 SRC="../Screen/plus.ico" border=0></a>
Line #276:</td>';
Line #277:
Line #278:for($j=0,$k=0;$j<count($r);$j++) {
Line #279:$e .= '<td with=50> '.htmlspecialchars($r[$j]).' </td>';
Line #280:}
Line #281:$e .= '</tr>';
Line #282:
Line #283:if ($ii==50 and $export==false) {
Line #284:$e .= '</table>';
Line #285:echo($e);
Line #286:$ii=0;
Line #287:$e=$ee;
Line #288:}
Line #289:
Line #290:}
Line #291:
Line #292:$e .= '</table>';
Line #293:echo($e);
Line #294:
Line #295:echo($e);
Line #296:echo("<a href=javascript:window.close()>Vissza...</a>");
Line #297:
Line #298://mysql_free_result ($eredmeny);
Line #299://include ("gvarlist.php");
Line #300:///////
Line #301:/// BiViewTable.php /// 2009.09.07. 10:58:30
Line #302:?>
Line #303:
Line #304:</body>