source: npc_action.php@ 4

<?php

  include('includes/global.php');

  if (array_key_exists('delete', $_GET) and Licence(1)) {
    $npc_ID = $_GET['ID'];       
    $Database->SQLCommand("DELETE FROM npc_text WHERE ID = '$npc_ID' AND Language <> '0'");
    echo 'NPC_text byl smazán!';   
      WriteLog('NPC_text smazán! <a href="form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 6);
  }

  if (array_key_exists('NotComplete', $_GET) and Licence(1)) {
    $npc_ID = $_GET['ID'];
    $Database->SQLCommand("UPDATE npc_text SET Complete = '0' WHERE ID = '$npc_ID'");
    echo 'NPC_text byl vrácen k opravì!';   
      WriteLog('NPC_text byl vrácen k opravì <a href="form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 6);
  }

  if (array_key_exists('vote', $_GET)) {
    $npc_ID = $_GET['ID'];
    $vote = $_GET['vote'];
    $IDuser = $_SESSION['UserID'];
    
    if (($vote > 5) OR ($vote < 1)) die ('Spadná známka');
    
  //TODO:  if (Licence(0)) die('Hlasovat mù¶ou jenom registrovaní!');

    $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM npc_vote WHERE IDuser = '$IDuser' AND IDnpc = '$npc_ID'"));
    if (!$Line) {  
      $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote,CountVote FROM npc_text WHERE ID = '$npc_ID'"));
      $CountVote = $Line['CountVote']+1;
      $OldVote = $Line['Vote']*$Line['CountVote'];
      $NewVote = ($OldVote+$vote)/$CountVote;
      
      $Database->SQLCommand("UPDATE npc_text SET Vote = '$NewVote', CountVote = '$CountVote' WHERE ID = '$npc_ID'");
    
      $Database->SQLCommand("INSERT INTO `npc_vote` ( `IDnpc` , `IDuser` , `vote` ) VALUES ( '$npc_ID', '$IDuser', '$vote');");
      echo 'Hlas byl ulo¾en! Hlasoval jste: '.$vote.'<br /> Nyní je známka npc_textu '.$NewVote;   
    
      WriteLog('U¾ivatel hlasoval: '.$vote.'! Nyní je známka npc_text  (<a href="npc_form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>): '.$NewVote, 5);
    } else echo 'Ji¾ jste hlasoval!';
  }

  ShowFooter();      
?>