Changeset 210 for quests/action.php

Timestamp:

Jan 12, 2008, 12:24:07 AM (17 years ago)

Author:

maron

Message:

Hlasování pomocí známek 1-5

File:

• quests/action.php (modified) (1 diff)

quests/action.php

@@ -20 +20 @@
     $IDuser = $_SESSION['UserID'];
 
-    if ($vote <> 1 and $vote <> -1 and Licence(1) == False) die('');
+  //  if (Licence(0)) die('Hlasovat mùžou jenom registrovaní!');
 
 
-    $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM vote WHERE IDuser = '$IDuser' AND ID = '$questID'"));
-    if (!$Line) {
-    
-    $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote FROM quests WHERE ID = '$questID'"));
+    $Line = mysql_fetch_row($Database->SQLCommand("SELECT * FROM vote WHERE IDuser = '$IDuser' AND IDquest = '$questID'"));
+    if (!$Line) {  
+      $Line = mysql_fetch_array($Database->SQLCommand("SELECT Vote,CountVote FROM quests WHERE ID = '$questID'"));
+      $CountVote = $Line['CountVote']+1;
+      $OldVote = $Line['Vote']*$Line['CountVote'];
+      $NewVote = ($OldVote+$vote)/$CountVote;
       
-      $vote = $Line['Vote']+$vote;
+      echo $NewVote;
 
-      $Database->SQLCommand("UPDATE quests SET Vote = '$vote' WHERE ID = '$questID'");
+      $Database->SQLCommand("UPDATE quests SET Vote = '$NewVote', CountVote = '$CountVote' WHERE ID = '$questID'");
     
       $Database->SQLCommand("INSERT INTO `vote` ( `IDquest` , `IDuser` , `vote` ) VALUES ( '$questID', '$IDuser', '$vote');");