QQ_cimUPcsoport.inc
Line #0:<?php // include("QJ_start.php"); /*Qjegy2010v02-010 */
Line #1:
Line #2:
Line #3:if (isset($_POST[vissza])) {
Line #4:
Line #5:echo "<script language = javascript>";
Line #6:echo "window.open('QJ_cimtar.php', 'sframe');";
Line #7:echo "</script>";
Line #8:exit;
Line #9:
Line #10:}
Line #11:
Line #12:
Line #13:if (isset($_GET[wjid])) $wjid=$_GET[wjid]; else $wjid=0;
Line #14:$sqlfile='qj_cimtar';
Line #15:$prgcall=$_SESSION['prgcall'];
Line #16:$prgframe=$_SESSION['prgframe'];
Line #17:
Line #18:
Line #19:
Line #20:
Line #21:if (isset($_GET[delete]))
Line #22:{
Line #23:
Line #24:$parancs = "UPDATE `qj_cimtar` SET `nev`='' where `wid`=$wjid";
Line #25:$csor=mysql_query($parancs) or die($parancs." Hiba");
Line #26:
Line #27:?>
Line #28:<SCRIPT Language="Javascript">
Line #29:window.open("QJ_cimtar.php", 'sframe');
Line #30:</script>
Line #31:
Line #32:<?
Line #33:exit;
Line #34:}
Line #35:
Line #36:if ($wjid==-1 or $wjid==-2 or $wjid==0)
Line #37:{
Line #38:
Line #39:if ($wjid==-2) {
Line #40:
Line #41:$newcim = "INSERT INTO `$sqlfile`
Line #42:( `usr_kod`
Line #43:) VALUES
Line #44:( 'OF10'
Line #45:)";
Line #46:echo ($newcim);
Line #47:} else {
Line #48:$newcim = "INSERT INTO `$sqlfile`
Line #49:( `usr_kod`,`regdate`
Line #50:) VALUES
Line #51:( 'OF10',now()
Line #52:)";
Line #53:}
Line #54:
Line #55:mysql_query($newcim) or die($newcim." Hiba a $sqlfile insertben");
Line #56:
Line #57://if ($wjid==-2) exit;
Line #58:
Line #59://include ("gvarlist.php");
Line #60:
Line #61:$keres = "SELECT * FROM $sqlfile order by wid DESC limit=1";
Line #62:$csor=mysql_query($keres) or die($keres."Hiba a $sqlfile select-ben");
Line #63:
Line #64:$cim_sor = mysql_fetch_array( $csor );
Line #65:$wjid=$cim_sor[wid];
Line #66:
Line #67:
Line #68:}
Line #69:
Line #70:
Line #71:$eredmeny = mysql_query('show fields from '.$sqlfile);
Line #72:
Line #73:$fid='';
Line #74:
Line #75:
Line #76:while ($row =mysql_fetch_row($eredmeny))
Line #77:{
Line #78:
Line #79: $fid.=$row[0] . ":";
Line #80:}
Line #81:
Line #82:
Line #83:
Line #84:$disQ="SELECT distinct csoport_kod FROM qj_cimtar ORDER BY csoport_kod";
Line #85:
Line #86:
Line #87:$csI=0;
Line #88:
Line #89:onchange=this.form.submit(); return true name='csoport_kod'>";
Line #90:
Line #91:while ( $disC = mysql_fetch_array( $disR )) {
Line #92:
Line #93:++$csI;
Line #94:$csA[$csI]=$disC[csoport_kod];
Line #95:
Line #96: $selCSOPORT=str_replace("#","",$disC[csoport_kod]);
Line #97:
Line #98:
Line #99:if ($disC[csoport_kod]==$_POST[csoport_kod]) $sel="SELECTED"; else $sel="";
Line #100:$selD.="<option value='$disC[csoport_kod]' $sel >$selCSOPORT</option>";
Line #101:}
Line #102:$selD.="</SELECT>";
Line #103:
Line #104:$keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #105:
Line #106://BI_alert($keres);
Line #107:
Line #108:
Line #109:
Line #110:
Line #111:$h=split(':',$fid);
Line #112:$nur=count($h)-1;
Line #113:
Line #114:
Line #115:
Line #116:if ($_POST[W])
Line #117:{
Line #118:
Line #119:$W=$_POST[W];
Line #120:
Line #121:$parancs = "UPDATE ".$sqlfile." SET logtime=now(), ";
Line #122:
Line #123:$vesszo='';
Line #124:
Line #125:for($j=1;$j<$nur;$j++)
Line #126:{
Line #127: if ($h[$j]=="csoport_kod" and $_POST[new_csoport]<>"") $W[$j]=$_POST[new_csoport];
Line #128:
Line #129: $parancs .=$vesszo.$h[$j]."='".$W[$j]."' ";
Line #130: $vesszo=', ';
Line #131:}
Line #132:$parancs .= ", logtime=now() WHERE CONCAT( wid )='$wjid' LIMIT 1" ;
Line #133:
Line #134://echo($parancs."<hr>");
Line #135:
Line #136:
Line #137:
Line #138:// echo ($parancs.'<br>'.mysql_error().'<br>');
Line #139:
Line #140: $keres = "SELECT * FROM " . $sqlfile. ' WHERE wid='.$wjid;
Line #141:
Line #142:
Line #143:echo "<script language = javascript>";
Line #144:echo "window.open('QJ_cimtar.php', 'sframe');";
Line #145:echo "</script>";
Line #146:exit;
Line #147:
Line #148:
Line #149:// include("QJ_varlist.php");
Line #150:
Line #151:
Line #152://$_SESSION['cimind']=$wjid;
Line #153:
Line #154:
Line #155:
Line #156://echo "<script language = javascript>";
Line #157://echo("history.go(-2);");
Line #158://echo "window.open('frissits.php', 'adatframe');";
Line #159://echo "document.location='exit.php';";
Line #160://echo "</script>";
Line #161:
Line #162:
Line #163: }
Line #164:
Line #165:
Line #166:
Line #167:
Line #168:
Line #169:$bup="<FORM name=orderby action='QQ_cimUP.php?&sqlfile=qj_cimtar&wjid=$wjid&bixupd=$Wjid' method='post'>";
Line #170:$bup.="<table border=1 align=center bgcolor='gold'>";
Line #171:$bup.="<td align=left>";
Line #172:
Line #173:
Line #174:$bup.="<td align=center><font color=red size=+1>RecNo:$wjid</font>";
Line #175:$bup.="<input type='hidden' value='$h[0]' name='Wjid'>";
Line #176:$bup.="</td></tr>";
Line #177:
Line #178://BI_alert($bup);
Line #179:
Line #180:$r=mysql_fetch_row($eredmeny);
Line #181:
Line #182://BI_alert($nur);
Line #183:
Line #184:for($j=1;$j<$nur;$j++)
Line #185:
Line #186:{
Line #187:
Line #188: $bum='W['.$j.']';
Line #189:
Line #190: if (strpos('?'.$h[$j],"_kod")>0 or
Line #191: strpos('?'.$h[$j],"time")>0 or
Line #192: strpos('?'.$h[$j],"login")>0 or
Line #193: strpos('?'.$h[$j],"date")>0
Line #194: ) $ronly="readonly"; else $ronly="";
Line #195:
Line #196:
Line #197: if (strpos('?'.$h[$j],"usr_kod")>0 ) $value="OF10"; else $value=trim($r[$j]);
Line #198: if (strpos('?'.$h[$j],"login")>0 ) $value=$_SESSION['login']; else $value=trim($r[$j]);
Line #199:
Line #200:// $bup.=$bum.'/';
Line #201:
Line #202:// $bup .= '<td with=50> '.$h[$j].' </td>';
Line #203:
Line #204:
Line #205:// if ($h[$j]=="nev")
Line #206:// $torol='<a target=sframe href=QQ_cimUP.php??&wjid='.$r[0].'&delete=Y>
Line #207:
Line #208://else
Line #209:$torol="";
Line #210:
Line #211:
Line #212:
Line #213: if (strpos('?'.$h[$j],"memo")>0)
Line #214:
Line #215: $bup.="<tr><td align=right>".$h[$j]."</td><td>
Line #216: <TEXTAREA NAME = '$bum' COLS = 76 ROWS = 4>$value</TEXTAREA>
Line #217: </td></tr>";
Line #218:
Line #219: elseif ($h[$j]=="csoport_kod") {
Line #220:
Line #221: $v="<SELECT onchange=this.form.submit();
Line #222: return true name='$bum'>";
Line #223:
Line #224: for ($ii=1;$ii<$csI+1;$ii++){
Line #225: $selCSOPORT=$csA[$ii];
Line #226:
Line #227: if ($csA[$ii]==$r[$j]) $sel="SELECTED"; else $sel="";
Line #228: $v=$v."<option value='$csA[$ii]' $sel>$selCSOPORT</option>";
Line #229: }
Line #230:
Line #231: $v=$v."</select>";
Line #232:
Line #233:
Line #234: $bup.="<tr><td align=right>".$h[$j]."</td><td>
Line #235:
Line #236:
Line #237: } else
Line #238:
Line #239: $bup.="<tr><td align=right> $torol ".$h[$j]."</td><td><input $ronly type='text' size=50 value='".$value."' name='".$bum."'></td></tr>";
Line #240:
Line #241:}
Line #242:
Line #243:
Line #244://BI_alert($bup);
Line #245:
Line #246:$bup.="</table></form>";
Line #247:
Line #248:echo($bup);
Line #249:
Line #250:
Line #251:
Line #252:
Line #253:
Line #254: function Bi_back($bi_msg)
Line #255: ////////
Line #256: {
Line #257:
Line #258:// history.go(-1)
Line #259:// history.back(2);
Line #260://echo('<SCRIPT LANGUAGE="JavaScript">alert("'.$bi_msg.'"); history.go(-2); </script>');
Line #261:echo('<SCRIPT LANGUAGE="JavaScript"> history.go(-2); </script>');
Line #262:
Line #263: }
Line #264:
Line #265:
Line #266://~*~// QJ_cimtarUP.php
Line #267:?>