source: quests/form.php@ 263

<?php
include('includes/global.php');    

  if (array_key_exists('ID', $_GET)) {
    $QuestID = mysql_escape_string($_GET['ID']);  

    $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests Where ID = $QuestID"));
     
    $LineAJ = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests Where Language = '0' 
    AND entry = '".$Line['entry']."'"));
 
    $User = @$_SESSION['User'];
    $IDUser = $Database->SQLCommand("SELECT * FROM user Where id = '".$Line['User']."'");
    $LineUser = mysql_fetch_array($IDUser);
  
      
      if ($Line['Language'] <> '0' and $LineUser['user'] <> '') echo 'Pøelo¾il: <b>'.$LineUser['user'].'</b> <br />';
      if ($Line['Take'] <> '0' and $Line['Take'] <> $Line['ID']) {
        $Language = mysql_fetch_array($Database->SQLCommand("SELECT Language FROM quests Where ID = '".$Line['Take']."'"));
       // echo $Language['Language'].'  '.$Line['Take'];
        if ($Language['Language'] <> 0)
          echo 'Pøevzato z: <a href="form.php?ID='.$Line['Take'].'">'.$Line['Take'].'</a> <br />';
      }
    echo 'Quest: ';
    if ($Line['Language'] <> '0') {
      if ($Line['complete'] == 1) echo ' <b>Hotov</b><br />';
      else echo ' <b> Ulo¾en v rozepsaných</b><br />';
    } else {
      echo ' <b>Anglická, pùvodní verze</b>';
    }
    
    if ($Line['Language'] <> '0') {
      echo 'Známka Questu: <b>'.$Line['Vote'].'</b><br />';
    }
    
    
  if (Licence(0) and ($LineUser['ID'] <> $_SESSION['UserID']) and ($Line['Language'] <> 0)) {
    $LineVote = mysql_fetch_array($Database->SQLCommand("SELECT * FROM quests_vote WHERE 
    IDuser = ".$_SESSION['UserID']." AND IDquest = $QuestID"));
    if (!$LineVote) {
      echo ' Hodnotit Quest: ';
        for ($i=1; $i<6; ++$i)   
          echo '<a href="action.php?vote='.$i.'&amp;ID='.$QuestID.'">'.$i.'</a> ';
      echo ' bodù (5 nejlep¹í)';
    } else { echo ' Ji¾ jsi hlasoval: '.$LineVote['vote']; }  
  }
    echo '<br><a href="ListQuests.php?searchentry='.$Line['entry'].'">Zobrazit v¹echny verze tohoto questu</a>';

//    Speciální znaky: $B - Odøádkování, $N - Jméno, $C - povolání
?>    
  <form action="save.php" method="post">
<?php
  if (Licence(0)) {
    echo '<input type="submit" value="Ulo¾it do rozepsaných" name="save" Title="Kliknìte na ulo¾it pro pozdìj¹í dokonèení Q">
    <input type="submit" value="Dokonèeno" name="End" Title="Kliknìte na Dokonèeno jesli jsou v¹echny texty hotové a chcete ji¾ publikovat">';

  }


  if (Licence(1) and $Line['Language'] <> 0) {
    echo '<input type="submit" value="Opravit" name="Repair" Title="Opravit po u¾ivateli chyby (Moderator only)">';  
  }
      if (Licence(1) and ($Line['Language'] <> 0)) {
      //  echo '<input type="submit" value="Opravit Q" name="Repair"> Kliknìte Jestli si pøejete opravit chyby v Questu<br>';
        
        echo ' <input type="hidden" name="UserRepair" value="'.$Line['User'].'">';
        echo ' <a style="color: Red" title="smazat (Moderator only)" href="action.php?delete=1&amp;ID='.$QuestID.'">x</a>  
        <a style="color: Red" title="Není hotovo (Moderator only)" href="action.php?NotComplete=1&amp;ID='.$QuestID.'"><-</a> 
        
        ';  
      }
?>
    <input type="hidden" name="entry" value="<?php echo $LineAJ['entry']?>">
    <input type="hidden" name="user" value="<?php echo $User ?>">
    <input type="hidden" name="ID" value="<?php echo $QuestID ?>">
    <table border="1" cellpadding="1" cellspacing="0">
      <tr>
        <th>Èíslo Q.: <?php echo $LineAJ['entry'];?></th>
        <th>Nepøelo¾ené</th>
        <th>Pøelo¾ené</th>
      </tr>
      <tr>
        <th>Jazyk</th>
        <td width="300">Anglický</td>
        <td>
          Pøelo¾eno do: <?php 
          if ($Line['Language'] <> 0) 
              $Language = $Line['Language']; 
          else {
            $IDUser = $Database->SQLCommand("SELECT * FROM user Where id = '".@$_SESSION['UserID']."'");
            $LineUser = mysql_fetch_array($IDUser);
            $Language = $LineUser['Language'];  //jiný user vyèítám
          }
              WriteLanguages($Language);
              ?>
        </td>
      </tr>
      <tr>
        <th>Title</th>
        <td width="300"><?php echo htmlspecialchars($LineAJ['Title'])?></td>
        <td><input type="text" size="45" name="Title" value="<?php echo htmlspecialchars($Line['Title']) ?>"></td>
      </tr>
      
<?php  foreach($Texts as $Index => $TextItem)
          {          
          if (($LineAJ[$TextItem[0]] <> '') or ($Line[$TextItem[0]] <> ''))  
            echo '
      <tr>
        <th>'.$TextItem[0].'</th>
        <td width="300">'.htmlspecialchars($LineAJ[$TextItem[0]]).'</td>
        <td><textarea style="width: 300px; height: 100%;" name="'.$TextItem[0].'">'.htmlspecialchars($Line[$TextItem[0]]).'</textarea></td>
      </tr>';
          }
?> 
    </table>
  </form>
<?php    

  } else {
   // include 'ListQuests.php';   
    
    echo 'Nebylo zadáno ID <a href="index.php">zpìt</a>';
    
  }


  
   ShowFooter();
?>