Bi-Dir

QQ_remoteVIEW.inc

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