QQ_musorCOPYeloadas.inc
Line #0:<?php
Line #1:
Line #2:if (isset($_SESSION['Dump'])) {
Line #3:
Line #4:}
Line #5:
Line #6:if (isset($_POST[dupla])) $Ikeres.="DUPLA!!!";
Line #7:
Line #8:$sqlfile="qj_musor";
Line #9:
Line #10:if ($wjid==-1 or isset($_POST[dupla]))
Line #11:{
Line #12:
Line #13:$newcim = "INSERT INTO `$sqlfile`
Line #14:( `usr_kod`
Line #15:) VALUES
Line #16:( '$_SESSION[Qusr_kod]'
Line #17:)";
Line #18:
Line #19:if (isset($_SESSION['Dump'])) echo($newcim." <hr>");
Line #20:
Line #21:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #22:
Line #23:$keres = "SELECT * FROM `$sqlfile` order by wid DESC";
Line #24:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #25:
Line #26:$cim_sor = mysql_fetch_array( $csor );
Line #27:$wjid=$cim_sor[wid];
Line #28:
Line #29://echo('<SCRIPT Language="Javascript">
Line #30:///////////////////////////////////////
Line #31://window.open("QJ_musorCREATE.php", "infoframe");
Line #32:///////////////////////////////////////
Line #33://</script>');
Line #34:}
Line #35:
Line #36:
Line #37:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #38:$fid='';
Line #39:while ($row =mysql_fetch_row($eredmeny))
Line #40:{
Line #41: $fid.=$row[0] . ":";
Line #42:}
Line #43:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #44:
Line #45:
Line #46:$h=split(':',$fid);
Line #47:$nur=count($h)-1;
Line #48:
Line #49:if ($_POST[W] or isset($_POST[dupla]))
Line #50:{
Line #51:
Line #52:
Line #53:$W=$_POST[W];
Line #54:
Line #55:$parancs = "UPDATE ".$sqlfile." SET ";
Line #56:
Line #57:$vesszo='';
Line #58:$dk='';
Line #59:
Line #60:for($j=1;$j<$nur;$j++)
Line #61:{
Line #62: if ($h[$j]=="szoveg") $iszov=$j;
Line #63: if ($h[$j]=="datum_kod") $idk=$j;
Line #64: if ($h[$j]=="berlet_Azonosito") $iba=$j;
Line #65:}
Line #66:
Line #67:
Line #68:
Line #69:if (isset($_SESSION['Dump'])) echo($nur."DUPLA<hr>");
Line #70:if (isset($_SESSION['Dump'])) echo ($W[$idk]."/".$idk."/".$iba.": INDEXEK!!!<hr>");
Line #71:if (isset($_SESSION['Dump'])) echo("DUPLA<hr>");
Line #72:
Line #73:$cim_kod="*";
Line #74:$datum_kod="*";
Line #75:for($j=1;$j<$nur;$j++)
Line #76:
Line #77:{
Line #78:
Line #79:// if ($h[$j]=="szoveg") $W[$j]=$W[$idk];
Line #80:// if ($h[$j]=="archiv") $W[$j]="*";
Line #81:// if ($h[$j]=="berlet_Azonosito") $W[$j]=$W[$idk];
Line #82:
Line #83:// if (isset($_POST[dupla]) and $h[$j]=="datum" and isset($_SESSION[musor_ujho]))
Line #84:// $W[$j]=$_SESSION[musor_ujho];
Line #85:// if (isset($_POST[dupla]) and $h[$j]=="datum_evho" and isset($_SESSION[musor_ujevho]))
Line #86:// $W[$j]=$_SESSION[musor_ujevho];
Line #87:
Line #88: if (isset($_POST[dupla]) and $h[$j]=="cim_kod") $cim_kod=$W[$j];
Line #89:
Line #90: if (isset($_POST[dupla]) and $h[$j]=="last_index") $W[$j]=0;
Line #91:// if (isset($_POST[dupla]) and $h[$j]=="datum_url") $W[$j]=$dk;
Line #92: if (isset($_POST[dupla]) and $h[$j]=="datum_kod") {
Line #93: $dk=$W[$j];
Line #94: $W[$j]=$_SESSION[Qusr_kod]."D".substr("00000".$wjid,-5);
Line #95: $datum_kod=$W[$j];
Line #96:
Line #97: }
Line #98: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #99: $vesszo=', ';
Line #100:// echo ($j."***".$parancs."<hr>");
Line #101:
Line #102:}
Line #103:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #104:
Line #105:
Line #106:$Mwid=$wjid;
Line #107:
Line #108:
Line #109:
Line #110://?//
Line #111:
Line #112:
Line #113:if (isset($_SESSION['Dump'])) echo ($parancs.'???<br>'.mysql_error().'<hr>');
Line #114://echo ($nur."DUPLA<hr>");
Line #115://echo ($W[$idk]."/".$idk."/".$iba.": INDEXEK!!!<hr>");
Line #116:
Line #117: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #118:
Line #119:
Line #120:if (isset($_SESSION['Dump'])) echo ($keres.'???<br>'.mysql_error().'<hr>');
Line #121:
Line #122:
Line #123:
Line #124:////////////////////////////////////////////////////////////////////////
Line #125:if (isset($_POST[dupla]) and $cim_kod<>"*" and $datum_kod<>"*") {
Line #126:
Line #127:$eredmeny = mysql_query('show fields from qj_ear');
Line #128:$fid='';
Line #129:while ($row =mysql_fetch_row($eredmeny))
Line #130:{
Line #131: $fid.=$row[0] . ":";
Line #132:}
Line #133:
Line #134:$h=split(':',$fid);
Line #135:$nurM=count($h)-1;
Line #136:
Line #137://$keres = "SELECT * FROM qj_ear WHERE cim_kod='$cim_kod' and datum_kod='$datum_kod'";
Line #138:
Line #139:$keres = "SELECT * FROM qj_ear WHERE datum_kod='$dk'";
Line #140:
Line #141:$nur=mysql_num_rows($eredmeny);
Line #142://$r=mysql_fetch_row($eredmeny);
Line #143:
Line #144:if (isset($_SESSION['Dump'])) echo ($keres."~~~~~~~$nur~~~~~<hr>");
Line #145:
Line #146:while ($r =mysql_fetch_row($eredmeny))
Line #147:{
Line #148:
Line #149:$Nkeres = "SELECT * FROM qj_ear WHERE datum_kod='$datum_kod' and cim_kod='$cim_kod' and szoveg='$r[2]'";
Line #150:
Line #151:$nurN=mysql_num_rows($Neredmeny);
Line #152:
Line #153:if (isset($_SESSION['Dump'])) echo($Nkeres." <hr>");
Line #154:
Line #155:if ($nurN==0) {
Line #156:
Line #157:$newcim = "INSERT INTO `qj_ear`
Line #158:( `usr_kod`
Line #159:) VALUES
Line #160:( '$_SESSION[Qusr_kod]'
Line #161:)";
Line #162:
Line #163:if (isset($_SESSION['Dump'])) echo($newcim." <hr>");
Line #164:mysql_query($newcim) or die("Hiba a $sqlfile insertben");
Line #165:
Line #166:$keres = "SELECT * FROM `qj_ear` order by wid DESC";
Line #167:$csor=mysql_query($keres) or die("Hiba a $sqlfile select-ben");
Line #168:
Line #169:$cim_sor = mysql_fetch_array( $csor );
Line #170:$wjid=$cim_sor[wid];
Line #171:
Line #172:}
Line #173:
Line #174:
Line #175:$parancs = "UPDATE qj_ear SET ";
Line #176:$vesszo='';
Line #177:
Line #178:for($i=1;$i<$nurM;$i++)
Line #179:{
Line #180: if ($h[$i]=="datum_kod") $r[$i]=$datum_kod;
Line #181: if ($h[$i]=="cim_kod") $r[$i]=$cim_kod;
Line #182: $parancs .=$vesszo.$h[$i]."='".$r[$i]."' ";
Line #183: $vesszo=', ';
Line #184:}
Line #185:$parancs .= " WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #186:mysql_query($parancs) or die("Hiba $parancs ");
Line #187:
Line #188:if (isset($_SESSION['Dump'])) echo($parancs."DUPLA<hr>");
Line #189:
Line #190:
Line #191:}}
Line #192:
Line #193:
Line #194:
Line #195:echo('<SCRIPT Language="Javascript">
Line #196:///////////////////////////////////////
Line #197: window.open("QJ_musorCREATEview.php", "infoframe");
Line #198: window.open("QJ_musorPUBLIC.php?&wjid='.$Mwid.'", "adatframe");
Line #199:///////////////////////////////////////
Line #200:</script>');
Line #201:
Line #202:}
Line #203:
Line #204:?>