source: branches/posledni/pages/admin_finance_modify.php

<?php
$lvl = $player -> GetGmLvl();
if(1 > 0){
$id_upravit = $_POST['id_upravit'];
$q = $_GET['q'];

if($q==1):

$operace_obracene = array(
  "Nákup" => "buy",
  "Prodej" => "sell",
  "Spotřeba" => "consumption",
  "Internet" => "internet",
  "contribution" => "contribution",
);

$id2 = $_POST['id'];
$money = $_POST['money'];
$oper = $_POST['operace'];
$popis = $_POST['popis'];
$odmena = $_POST['odmena'];

$operace = $operace_obracene[$oper];

   $upravit_money = $db->query("update Finance set Money='$money' where Id='$id2'");
   $upravit_operace = $db->query("update Finance set Operation='$operace' where Id='$id2'");
   $upravit_popis = $db->query("update Finance set Description='$popis' where Id='$id2'");
   $upravit_odmenu = $db->query("update Finance set Reward='$odmena' where Id='$id2'");
   
   if($upravit_money and $upravit_operace and $upravit_popis and $upravit_odmenu):
   $info = "<font color=green><b>Finance byla upravena vpořádku...</b></font>";
   else:
   $info = "<font color=red><b>Při upravování finance došlo k chybě...</b></font>";
   endif;
   
endif;

echo"<p align=center>$info";
$operace = array(
  "buy" => "Nákup",
  "sell" => "Prodej",
  "consumption" => "Spotřeba",
  "internet" => "Internet",
  "contribution" => "Příspěvek od",
);

$db -> select_db($Config['Database']['Database']);

$load_money = $db -> query("SELECT SUM(`Money`) FROM `Finance`;") -> fetch_array();

echo"<p><strong>Aktuální stav financí: ".$load_money[0]." Kč</strong></p>";
echo "
  <table border=\"1\" width=\"540\">
    <tr>
      <th>Datum</th>
      <th>Suma</th>
      <th>Popis</th>
    <th>Odměna</th>
    <th>&nbsp;</th>
    </tr>  
"; 
$load_dotation = $db -> query("SELECT * FROM `Finance` ORDER BY `Id` DESC;");
  while ($row = $load_dotation -> fetch_array())
  {
  $id = $row['Id'];
  
    if ($row["Time"] != "")
    {
      
      //$date = $server -> HumanDate ($row["time"],0);
      $date = $row["Time"];
    }
    else
    {
      $date = "";
    }
    if($row["Money"] > 0) 
    {$plus = "+";} else{$plus = "";}
  
  if($id != $id_upravit):
    echo "
      <tr>
        <td align=\"center\">".$date."</td>
        <td align=\"center\">".$plus.$row["Money"]."</td>
        <td align=\"left\">".$operace[$row["Operation"]]." ".$row["Description"]."</td>
    <td align=\"center\">".$row["Reward"]."</td>
    <form method=post><td align=\"center\" valign=\"middle\"><input type=hidden name='id_upravit' value='$id'><input type=submit value='Upravit'></form></td>
      </tr>  
    ";
  else:
  $oper = $row["Operation"];
   if($operace[$oper]=="Nákup"):
   $option = 
   "<option value=\"buy\">Nákup
   <option value=\"sell\">Prodej
   <option value=\"consumption\">Spotřeba
   <option value=\"internet\">Internet
   <option value=\"contribution\">Příspěvek";
   elseif($operace[$oper]=="Prodej"):
   $option = 
   "<option value=\"buy\">Nákup
   <option value=\"sell\" selected>Prodej
   <option value=\"consumption\">Spotřeba
   <option value=\"internet\">Internet
   <option value=\"contribution\">Příspěvek";
   elseif($operace[$oper]=="Spotřeba"):
  $option = 
   "<option value=\"buy\">Nákup
   <option value=\"sell\" >Prodej
   <option value=\"consumption\" selected>Spotřeba
   <option value=\"internet\">Internet
   <option value=\"contribution\">Příspěvek";
   elseif($operace[$oper]=="Interpret"):
  $option = 
   "<option value=\"buy\">Nákup
   <option value=\"sell\" >Prodej
   <option value=\"consumption\">Spotřeba
   <option value=\"internet\" selected>Internet
   <option value=\"contribution\">Příspěvek";
   elseif($operace[$oper]=="Příspěvek od"):
  $option = 
   "<option value=\"buy\">Nákup
   <option value=\"sell\" >Prodej
   <option value=\"consumption\">Spotřeba
   <option value=\"internet\">Internet
   <option value=\"contribution\" selected>Příspěvek";
   
   endif;
    echo "
    
   <tr><form method=post action=\"?page=admin_finance_modify&q=1\"> <input type=hidden name=id value='$id'>
        <td align=\"center\">".$date."</td>
      <td align=\"center\"><input type=text name=money value=".$row["Money"]." size=4></td>
        <td align=\"left\"><select name=operace>$option</select><input type=text name=popis value='".$row["Description"]."'></td>
     <td align=\"center\"><input type=text name=odmena value='".$row["Odmena"]."'></td>
    <td align=\"center\" valign=\"middle\"><input type=hidden name=id value='$id'><input type=submit value='Upravit'></td>
      </form> </tr> 
    ";
  endif;
  }
 echo "</table>"; 
 
 } else {
 echo"<p align=center><font color=red><b>Nemáte dostatečná oprávnění pro tuto akci!</b></font>";
 echo"<meta http-equiv=\"refresh\" content=\"3;url=?page=main\">";
 }
 ?>