QQ_sqlCSScopy.inc
Line #0:<? Session_start(); ?>
Line #1:
Line #2:<html>
Line #3:<head>
Line #4:<title>Qjegy2011</title>
Line #5:<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
Line #6:
Line #7:</head>
Line #8:
Line #9:<BODY BORDER=0 background='Qhat.gif' CELLSPACING="0" CELLPADDING="0" align="left">
Line #10:
Line #11:<?
Line #12:
Line #13:require('bilib.inc');
Line #14:BISQLcon();
Line #15:
Line #16:@mysql_query('SET CHARACTER SET latin2');
Line #17:@mysql_query("SET NAMES 'latin2'");
Line #18:
Line #19:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=$_POST[wjid];
Line #20:$sqlfile="qj_sql";
Line #21:
Line #22:if (isset($_GET[CSS_menu])) {
Line #23: $menu=$_GET[CSS_menu];
Line #24: $l=strlen($menu);
Line #25: $keres = "SELECT * FROM `$sqlfile` where szoveg='$menu' ";
Line #26: $csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
Line #27: $row =mysql_fetch_array($csor);
Line #28://?// echo($keres."<hr>".$sqlfile."<hr>");
Line #29: $wjid=$row[wid];
Line #30:}
Line #31:
Line #32://?//echo($keres."<hr>".$_GET[CSS_menu]."?".$wjid."<hr>");
Line #33:
Line #34:if (isset($_POST[dupla])) echo("DUPLA!!!<hr>");
Line #35:
Line #36:if ($wjid==-1 or isset($_POST[dupla]))
Line #37:{
Line #38:
Line #39:$newcim = "INSERT INTO `$sqlfile`
Line #40:( `usr_kod`
Line #41:) VALUES
Line #42:( '$_SESSION[Qusr_kod]'
Line #43:)";
Line #44:mysql_query($newcim) or die($newcim."Hiba a $sqlfile insertben");
Line #45:
Line #46:$keres = "SELECT * FROM `$sqlfile` order by wid DESC";
Line #47:$csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
Line #48:
Line #49:$cim_sor = mysql_fetch_array( $csor );
Line #50:$wjid=$cim_sor[wid];
Line #51:}
Line #52:
Line #53:
Line #54:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #55:
Line #56:$fid='';
Line #57:
Line #58:
Line #59:while ($row =mysql_fetch_row($eredmeny))
Line #60:{
Line #61:
Line #62: $fid.=$row[0] . ":";
Line #63:}
Line #64:
Line #65:
Line #66:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #67:
Line #68:
Line #69:
Line #70:$h=split(':',$fid);
Line #71:$nur=count($h)-1;
Line #72:
Line #73:
Line #74:
Line #75:if ($_POST[W] or isset($_POST[dupla]))
Line #76:{
Line #77:
Line #78:$W=$_POST[W];
Line #79:
Line #80:$parancs = "UPDATE ".$sqlfile." SET ";
Line #81:
Line #82:$vesszo='';
Line #83:
Line #84:for($j=1;$j<$nur;$j++)
Line #85:
Line #86:{
Line #87: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") $W[$j]=$W[1]."D".substr("00000".$wjid,-5);
Line #88: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #89: $vesszo=', ';
Line #90:
Line #91:}
Line #92:$parancs .= " WHERE wid ='$wjid' LIMIT 1" ;
Line #93:
Line #94:
Line #95://??//echo ($parancs.'<br>'.mysql_error().'<br>');
Line #96:
Line #97:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #98:
Line #99:
Line #100:}
Line #101:
Line #102://echo("<a href=javascript:window.close()>Vissza...</a>");
Line #103:
Line #104:$bup="<FORM name=orderby action='QQ_sqlCSScopy.php?&wjid=$wjid&tabla=$sqlfile' method='post'>";
Line #105:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #106:$bup.="<td align=left>";
Line #107:$bup.="<tr><td align=right><input type='submit' value='Ment' name='submit'>
Line #108:</td>";
Line #109:$bup.="<td align=center colspan=4><b>$sqlfile / WID:$wjid</b>
Line #110:
Line #111:$bup.="<input type='hidden' value='$h[0]' name='Wjid'></td>";
Line #112:
Line #113:$bup.="</td></tr><tr>";
Line #114:
Line #115:
Line #116:$r=mysql_fetch_row($eredmeny);
Line #117:
Line #118:$tr="</tr><tr>";
Line #119:$colspan="";
Line #120:
Line #121:for($j=1;$j<$nur;$j++)
Line #122:
Line #123:{
Line #124:
Line #125: $bum='W['.$j.']';
Line #126:
Line #127:if (strpos($h[$j],"parancs")>0) {
Line #128: $bup.="<tr><td align=right bgcolor=$Fszin ><b>".$h[$j].
Line #129: "</b></td><td><textarea rows=16 cols=50 name='".$bum."'>".$r[$j]."</textarea>";
Line #130:} else {
Line #131: $bup.="<input type='hidden' value='".$r[$j]."' name='".$bum."'>";
Line #132:// $bup.="<td align=right>".$h[$j]."</td><td $colspan ><input $ronly type='text' value='".$r[$j]."' name='".$bum."'></td>".$tr;
Line #133:}
Line #134:}
Line #135:
Line #136:
Line #137:$bup.="</tr></table></form>";
Line #138:
Line #139:echo($bup);
Line #140:
Line #141://echo("<a href=javascript:window.close()>Vissza...</a>");
Line #142:
Line #143:
Line #144:?>