Changeset 685 for trunk/pages/admin_finance_modify.php

Timestamp:

Jan 23, 2010, 9:50:48 PM (14 years ago)

Author:

george

Message:

• Opraveno: Resetování xp a pozice.

File:

• trunk/pages/admin_finance_modify.php (modified) (5 diffs)

trunk/pages/admin_finance_modify.php

@@ -23 +23 @@
 $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 odmena='$odmena' where id='$id2'");
+   $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):
@@ -47 +47 @@
 $db -> select_db($Config['Database']['Database']);
 
-$load_money = $db -> query("SELECT SUM(`money`) FROM `finance`;") -> fetch_array();
+$load_money = $db -> query("SELECT SUM(`Money`) FROM `Finance`;") -> fetch_array();
 
 echo"<p><strong>Aktuální stav financí: ".$load_money[0]." Kč</strong></p>";
@@ -56 +56 @@
       <th>Suma</th>
       <th>Popis</th>
-          <th>Odměna</th>
-          <th>&nbsp;</th>
+    <th>Odměna</th>
+    <th>&nbsp;</th>
     </tr>  
 "; 
-$load_dotation = $db -> query("SELECT * FROM `finance` ORDER BY `id` DESC;");
+$load_dotation = $db -> query("SELECT * FROM `Finance` ORDER BY `Id` DESC;");
   while ($row = $load_dotation -> fetch_array())
   {
-  $id = $row['id'];
+  $id = $row['Id'];
   
-    if ($row["time"] != "")
+    if ($row["Time"] != "")
     {
       
       //$date = $server -> HumanDate ($row["time"],0);
-      $date = $row["time"];
+      $date = $row["Time"];
     }
     else
@@ -75 +75 @@
       $date = "";
     }
-    if($row["money"] > 0) 
+    if($row["Money"] > 0) 
     {$plus = "+";} else{$plus = "";}
-        
-        if($id != $id_upravit):
+  
+  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>
+        <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"):
+  else:
+  $oper = $row["Operation"];
+   if($operace[$oper]=="Nákup"):
    $option = 
    "<option value=\"buy\">Nákup
@@ -127 +127 @@
    
    endif;
-          echo "
-          
-         <tr><form method=post action=\"?page=admin_finance_modify&q=1\"> <input type=hidden name=id value='$id'>
+    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>
+      <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;
+  endif;
   }
  echo "</table>";