BI_sqlRECopy.inc

---

Line #0:<?php
Line #1:
Line #2:$szin=" bgcolor='gold' ";
Line #3:
Line #4:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #5:
Line #6:if (isset($_GET[sqlfile])) $sqlfile=$_GET[sqlfile]; else
Line #7:if (isset($_GET[tabla])) $sqlfile=$_GET[tabla]; else
Line #8:if (isset($_POST[tabla])) $sqlfile=$_POST[tabla];
Line #9:
Line #10://BI_alert($sqlfile);
Line #11:
Line #12:if (isset($_POST[dupla])) $szin=" bgcolor='aqua' ";
Line #13:
Line #14:if ($wjid==-1 or isset($_POST[dupla]))
Line #15:{
Line #16:
Line #17:$szin=" bgcolor='aqua' ";
Line #18:
Line #19:$newcim = "INSERT INTO `$sqlfile`
Line #20:( `usr_kod`
Line #21:) VALUES
Line #22:( '$_SESSION[Qusr_kod]'
Line #23:)";
Line #24:mysql_query($newcim) or die($newcim."Hiba a $sqlfile insertben");
Line #25:
Line #26:$keres = "SELECT * FROM `$sqlfile` order by wid DESC";
Line #27:$csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
Line #28:
Line #29:$cim_sor = mysql_fetch_array( $csor );
Line #30:$wjid=$cim_sor[wid];
Line #31:}
Line #32:
Line #33:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #34:$fid='';
Line #35:
Line #36:while ($row =mysql_fetch_row($eredmeny))
Line #37:{
Line #38: $fid.=$row[0] . ":";
Line #39:}
Line #40:
Line #41:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #42:
Line #43:
Line #44:$h=split(':',$fid);
Line #45:$nur=count($h)-1;
Line #46:
Line #47:if ($_POST[W] or isset($_POST[dupla]))
Line #48:{
Line #49:
Line #50:if (isset($_POST[dupla])) $szin=" bgcolor='aqua' "; else $szin=" bgcolor='silver' ";
Line #51:
Line #52:$W=$_POST[W];
Line #53:$parancs = "UPDATE ".$sqlfile." SET ";
Line #54:$vesszo='';
Line #55:
Line #56:for($j=1;$j<$nur;$j++)
Line #57:{
Line #58:
Line #59: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #60: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #61: $vesszo=', ';
Line #62:}
Line #63:$parancs .= " WHERE wid ='$wjid' LIMIT 1" ;
Line #64:
Line #65://BI_alert($parancs);
Line #66:
Line #67:
Line #68:
Line #69:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #70: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #71:
Line #72:}
Line #73:
Line #74:$Qkeres = "SELECT wid FROM " . $sqlfile;
Line #75:
Line #76:$nurL=mysql_num_rows($Qeredmeny);
Line #77:
Line #78:echo("<a href=javascript:window.close()><font color=blue size=+4>Vissza...</a>");
Line #79:
Line #80:$bup="<FORM name=orderby action='BI_sqlRECopy.php?&wjid=$wjid&tabla=$sqlfile&sqlfile=$sqlfile' method='post'>";
Line #81:$bup.="<table border=1 align=center $szin>";
Line #82:$bup.="<td align=left>";
Line #83:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'>
Line #84:</td>";
Line #85:$bup.="<td align=center colspan=4><b><font color=blue size=+1>$sqlfile:<font color=blue size=+2>$wjid</font><font color=red size=+2>/$nurL</font></b>";
Line #86:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #87:
Line #88:
Line #89:
Line #90:
Line #91:$r=mysql_fetch_row($eredmeny);
Line #92:
Line #93:$tr="</tr><tr>";
Line #94:$colspan="";
Line #95:
Line #96:for($j=1;$j<$nur;$j++)
Line #97:
Line #98:{
Line #99:
Line #100: $bum='W['.$j.']';
Line #101:
Line #102:if (strpos($h[$j],"memo")>0 or strpos($h[$j],"parancs")>0 or
Line #103: strpos($h[$j],"_Title")>0 or strpos($h[$j],"_jpg")>0) {
Line #104: $bup.="<tr><td align=right bgcolor=$Fszin ><b>".$h[$j]."</b></td><td><textarea rows=10 cols=100 name='".$bum."'>".$r[$j]."</textarea></td></tr>";
Line #105:} else {
Line #106:
Line #107:
Line #108: $bup.="<td align=right>".$h[$j]."</td><td $colspan ><input $ronly type='text' size=120 value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #109:}
Line #110:
Line #111:
Line #112:}
Line #113:
Line #114:
Line #115:$bup.="</tr></table></form>";
Line #116:
Line #117:echo($bup);
Line #118:
Line #119:echo("<a href=javascript:window.close()><font color=blue size=+4>Vissza...</a>");
Line #120:
Line #121:
Line #122:?>