source: branches/beta/pages/admin_finance_modify.php@ 473

<?
$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];

  mysql_connect($db_server, $db_user, $db_pass);
  mysql_select_db($db_webu);
  mysql_query("SET NAMES 'utf8'");
   $upravit_money = mysql_query("update finance set money='$money' where id='$id2'");
   $upravit_operace = mysql_query("update finance set operation='$operace' where id='$id2'");
   $upravit_popis = mysql_query("update finance set description='$popis' where id='$id2'");
   $upravit_odmenu = mysql_query("update finance set odmena='$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($db_webu);

$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["odmena"]."</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\">";
 }
 ?>