source: trunk/pages/admin_novinky_modify.php@ 561

<?php
$lvl = $player -> GetGmLvl();
if($lvl > 0){
echo "<center>";
$q = $_GET['q'];
if(empty($q)):
echo"<h2>Vyber kategorii</h2>";
echo"<p align=center>";
echo"<a href=\"?page=admin_novinky_modify&q=1&c=0\">Všechny</a> <br />";
echo"<a href=\"?page=admin_novinky_modify&q=1&c=1\">Server novinky</a> <br />";
echo"<a href=\"?page=admin_novinky_modify&q=1&c=2\">Gm novinky</a> <br />";
echo"<a href=\"?page=admin_novinky_modify&q=1&c=3\">In-Game novinky</a> <br />";
echo"<a href=\"?page=admin_novinky_modify&q=1&c=4\">Články</a> <br />";

elseif($q == 1):
$kategorie = $_GET['c'];

if($kategorie == 0):
$where = " ";
else:
$where = "WHERE category='$kategorie'";
endif;

mysql_connect($db_server, $db_user, $db_pass);
  mysql_select_db($db_webu);
  mysql_query("SET NAMES 'utf8'");
 $pocet = mysql_num_rows(mysql_query("SELECT id FROM articles $where"));
   
   if($pocet != 0):
   echo"<table align=center border=1><tr><td><b>Autor</b><td><b>Datum</b><td><b>Nadpis</b><td></tr>";
   
 $query = mysql_query("SELECT * from articles $where order by date DESC");
 while($row = mysql_fetch_array($query)){
 $id = $row['id'];
 echo"<tr>
 <td align=center valign=middle>$row[date]
 <td align=center valign=middle>$row[autor]
 <td align=center valign=middle>$row[title]
 <form method=post action=\"?page=admin_novinky_modify&q=2\">
 <td align=center valign=middle>
 <input type=hidden name=id value='$id'><input type=submit value='Upravit'>
 </form></tr>";
 
 }  
 echo"</table>";
 
    else:
   echo"<b>V této kategorii nejsou žádné novinky!</b>";
   endif;
   
 elseif($q == 2):
 $id = $_POST['id'];

mysql_connect($db_server, $db_user, $db_pass);
  mysql_select_db($db_webu);
  mysql_query("SET NAMES 'utf8'");
   $query = mysql_query("SELECT * from articles where id='$id'");
   
   while($row = mysql_fetch_array($query)){
   $autor = $row['autor'];
    $title = $row['title'];
         $text = $row['text'];
          $kategorie = $row['category'];
   }
      if($kategorie==1):
   $option1 = "<option value=1>Server novinky";
   $option2 = "<option value=2>Gm novinky";
   $option3 = "<option value=3>In-Game novinky";
   $option4 = "<option value=4>Články";
   elseif($kategorie==2):
   $option1 = "<option value=2>Gm novinky";
   $option2 = "<option value=1>Server novinky";
   $option3 = "<option value=3>In-Game novinky";
   $option4 = "<option value=4>Články";
   elseif($kategorie==3):
   $option1 = "<option value=3>In-Game novinky";
   $option2 = "<option value=2>Gm novinky";
   $option3 = "<option value=1>Server novinky";
   $option4 = "<option value=4>Články";
   elseif($kategorie==4):
   $option1 = "<option value=4>Články";
   $option2 = "<option value=2>Gm novinky";
   $option3 = "<option value=3>In-Game novinky";
   $option4 = "<option value=1>Server novinky";
   endif;
   
   echo"<form method=post action=\"?page=admin_novinky_modify&q=3\"><table align=center><p align=center>";
   echo"<input type=hidden name=id value='$id'><input type=hidden name=upravit value=1>";
   echo"<tr><td align=right><b>Autor:</b> <td><input type=text value='$autor' name=autor><br />";
   echo"<tr><td align=right><b>Nadpis:</b> <td><input type=text value='$title' name=title><br />";
   echo"
   <tr><td align=right>
   <b>Kategorie:</b> 
   <td><select name=kategorie>
   $option1
   $option2
   $option3
   $option4
   </select>
   </table><br /><br />";
   echo"<table align=center><tr><td valign=top><b>Text:</b> <td><textarea name=text cols=\"30\" rows=\"5\">$text</textarea></table><br />";
   echo"<br><input type=submit value='Upravit'>";
   
  elseif($q == 3):
   $autor = $_POST['autor'];
    $title = $_POST['title'];
         $text = $_POST['text'];
          $kategorie = $_POST['kategorie'];
           $id = $_POST['id'];
            $upravit = $_POST['upravit'];
          
          if($upravit==1 and $lvl > 0):
           
  mysql_connect($db_server, $db_user, $db_pass);
  mysql_select_db($db_webu);
  mysql_query("SET NAMES 'utf8'");
   $upravit_autor = mysql_query("update articles set autor='$autor' where id='$id'");
   $upravit_title = mysql_query("update articles set title='$title' where id='$id'");
   $upravit_text = mysql_query("update articles set text='$text' where id='$id'");
   $upravit_kategorie = mysql_query("update articles set category='$kategorie' where id='$id'");
  
   if($upravit_autor and $upravit_title and $upravit_text and $upravit_kategorie):
    echo"<p align=center><font color=green><b>Úprava novinky byla provedena úspěšně!</b></font><br>";
    echo"<a href=\"?page=admin\"><-- Do administrace</a>";
   else:
    echo"<p align=center><font color=red><b>Při úpravě novinky došlo k chybě, zkuste to prosím později!</b></font><br>";
    echo"<a href=\"?page=admin\"><-- Do administrace</a>";
   endif;
   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\">";
   endif;
   
   endif; 
   echo"</center>";
  
   } 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\">";
 }
 
 ?>