rendered paste bodyfunction tabel ($tabel, $tingimused, $where, $valjad, $read, $selecti, $act){
list($veerg1,$veerg2) = explode("\-/",$where[0]);
if ($veerg2=="2"){
if($_POST[$act] == "salvesta") {
$rows=$_POST[rows];
$count=count($valjad);
for ($n=1;$n<=$rows;$n++){
for ($k=1;$k<=$count-1;$k++){
sql("UPDATE ".PREFIX."".$tabel." SET ".$veerg1."='".$_POST["muuda_".$veerg1.""]."', ".$valjad[$k]."='".$_POST["".$valjad[$k]."_".$n.""]."' WHERE ".$valjad[0]."='".$_POST["".$valjad[0]."_".$n.""]."'");
}}
sql("DELETE FROM ".PREFIX."".$tabel." WHERE kustuta=1");
red("?".ID.",2,".$_POST["muuda_".$veerg1.""]."");
echo "salvestatud tabelisse ".$tabel."";
}
if($_POST[$act] == "uus kirje") {
list($veerg1,$veerg2) = explode("\-/",$where[0]);
sql("INSERT INTO ".PREFIX."".$tabel." (".$veerg1.") VALUES('".$_POST["muuda_".$veerg1.""]."')");
red("?".ID.",2,".$_POST["muuda_".$veerg1.""]."");
echo "lisatud tabelisse ".$tabel."";
}
?>
<form name=edit id=edit method=post action="?<?echo ID?>" onsubmit="javascript:submitEditor();" enctype="multipart/form-data">
<TABLE class=form width=630>
<INPUT TYPE="text" NAME="muuda_<?echo$veerg1?>" CLASS=field style="width:50%" VALUE="<?echo$where[1]?>">
<TR>
<?
$count_valjad=count($valjad);
for ($i=0;$i<=$count_valjad-1;$i++){
?>
<TH><?echo$valjad[$i]?></TH>
<?}?>
</TR>
<?
$res = sql("SELECT ".$selecti." FROM ".PREFIX."".$tabel." WHERE ".$veerg1."='".$where[1]."' ".$tingimused."");
while ($row=arr($res)){
$n=$n+1;
?>
<TR>
<?
$count_read=count($read);
for ($k=0;$k<=$count_read-1;$k++){
list($veerg3,$veerg4) = explode("\-/",$read[$k]);
if ($veerg3=="checkbox"){?>
<TD><INPUT TYPE="checkbox" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE=1 <?if($row[$veerg4]=="1") echo"CHECKED"?>></TD>
<?}else if($veerg3=="href"){?>
<INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<TD><a href="?<?echo ID?>,2,<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></a></TD>
<?}else if($veerg3=="hidden"){?>
<INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<?}else if($veerg3=="blank"){?>
<TD><?echo$row[$veerg4]?></TD>
<?}else{?>
<TD><INPUT TYPE="text" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"></TD>
<?}}?>
</TR>
<?}?>
</TABLE>
<INPUT TYPE="hidden" NAME="rows" CLASS=field style="width:50%" VALUE="<?echo$n?>">
<INPUT TYPE="button" class=field value="tagasi nimekirja" onclick="javascript:document.location.href='?<?echo ID?>'" style="width: 150px">
<INPUT TYPE="submit" name="<?echo$act?>" value="salvesta" class=field style="width: 150px">
<INPUT TYPE="submit" name="<?echo$act?>" value="uus kirje" class=field style="width: 150px">
</form>
<?
}else{
if($_POST[$act] == "salvesta") {
$rows=$_POST[rows];
$count=count($valjad);
for ($n=1;$n<=$rows;$n++){
for ($k=1;$k<=$count-1;$k++){
sql("UPDATE ".PREFIX."".$tabel." SET ".$valjad[$k]."='".$_POST["".$valjad[$k]."_".$n.""]."' WHERE ".$valjad[0]."='".$_POST["".$valjad[0]."_".$n.""]."'");
}}
sql("DELETE FROM ".PREFIX."".$tabel." WHERE kustuta=1");
red("?".ID."");
echo "salvestatud tabelisse ".$tabel."";
}
if($_POST[$act] == "uus kirje") {
list($veerg1,$veerg2) = explode("\-/",$where[0]);
sql("INSERT INTO ".PREFIX."".$tabel." (".$veerg1.") VALUES('".$_POST[$veerg1]."')");
red("?".ID.",2,".$_POST[$veerg1]."");
echo "lisatud tabelisse ".$tabel."";
}
?>
<form name=edit id=edit method=post action="?<?echo ID?>" onsubmit="javascript:submitEditor();" enctype="multipart/form-data">
<TABLE class=form width=630>
<TR>
<?
$count_valjad=count($valjad);
for ($i=0;$i<=$count_valjad-1;$i++){
?>
<TH><?echo$valjad[$i]?></TH>
<?}?>
</TR>
<?
$res = sql("SELECT ".$selecti." FROM ".PREFIX."".$tabel." ".$tingimused."");
while ($row=arr($res)){
$n=$n+1;
?>
<TR>
<?
$count_read=count($read);
for ($k=0;$k<=$count_read-1;$k++){
list($veerg3,$veerg4) = explode("\-/",$read[$k]);
if ($veerg3=="checkbox"){?>
<TD><INPUT TYPE="checkbox" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE=1 <?if($row[$veerg4]=="1") echo"CHECKED"?>></TD>
<?}else if($veerg3=="href"){?>
<INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<TD><a href="?<?echo ID?>,2,<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></a></TD>
<?}else if($veerg3=="hidden"){?>
<INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>">
<?}else if($veerg3=="hidden2"){?>
<TD><INPUT TYPE="hidden" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"><?echo$row[$veerg4]?></TD>
<?}else if($veerg3=="blank"){?>
<TD><?echo$row[$veerg4]?></TD>
<?}else{?>
<TD><INPUT TYPE="text" NAME="<?echo$veerg4?>_<?echo$n?>" CLASS=field style="width:50%" VALUE="<?echo$row[$veerg4]?>"></TD>
<?}}?>
</TR>
<?}?>
</TABLE>
<INPUT TYPE="hidden" NAME="rows" CLASS=field style="width:50%" VALUE="<?echo$n?>">
<INPUT TYPE="submit" name="<?echo$act?>" value="salvesta" class=field style="width: 150px">
<BR>
<INPUT TYPE="text" NAME="nimetus" CLASS=field style="width:50%" VALUE="<?echo$row[nimetus]?>">
<INPUT TYPE="submit" name="<?echo$act?>" value="uus kirje" class=field style="width: 150px">
</form>
<?
}}