Gemiddelde score is nu:"; //print $resultae->GameScore; //einde kijken of gebruiker(ip) al gestemd heeft }else{ //gebruiker mag stemmen //oude stem gedeelte hier kan je stemmen(hier stond het stemveld) $query = "SELECT GameScore FROM $Stem_DB_Master WHERE BatchID= :BatchID"; $stmt = $conn_vote->prepare($query); $stmt->bindParam(':BatchID', $BatchID); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_ASSOC); $resultae = $stmt->fetch(); if($resultae['GameScore'] != ""){ //print $resultae->GameScore; }else{ //echo"nog niet op gestemd"; $Score = "n"; }; }}; //einde gebruiker mag stemmen if($stem == "ja" && $nr != "" && $c != ""){ $StemDoor = ""; if($c == 10){ $StemDoor = "gevonden"; }; if($c == 8){ $StemDoor = "gevonden"; }; if($c == 6){ $StemDoor = "gevonden"; }; if($c == 4){ $StemDoor = "gevonden"; }; if($c == 1){ $StemDoor = "gevonden"; }; if($StemDoor == ""){ exit; }; //al gestemd check $UserIP = getRemoteIPAddress(); $UserBatchID = $nr; $query = "SELECT UserIP, UserBatchID FROM `".$vote_pdo_dbname."`.".$Stem_DB_Slave." WHERE UserIP= :UserIP && UserBatchID= :UserBatchID"; $stmt = $conn_vote->prepare($query); $stmt->bindParam(':UserIP', $UserIP); $stmt->bindParam(':UserBatchID', $UserBatchID); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_ASSOC); $resultie = $stmt->fetch(); if($resultie['UserIP'] != ""){ echo"je hebt al gestemd hallo Wouter?"; exit; }; //einde al gestemd check //stem toevoegen aan db $UserIP = getRemoteIPAddress(); $UserTimeStamp = strtotime ("now"); $UserBatchID = $nr; $UserVote = $c; $query = "INSERT INTO `".$vote_pdo_dbname."`.".$Stem_DB_Slave." VALUES ('$UserIP','$UserTimeStamp','$UserBatchID','$UserVote')"; $conn_vote->exec($query); //************************************** //hier volgt de stemberekening... $UserBatchID = $nr; $query = "SELECT UserIP, UserBatchID, UserVote FROM `".$vote_pdo_dbname."`.".$Stem_DB_Slave." WHERE UserBatchID= :UserBatchID"; $stmt = $conn_vote->prepare($query); $stmt->bindParam(':UserBatchID', $UserBatchID); $stmt->execute(); $stmt->setFetchMode(PDO::FETCH_ASSOC); $m = 0; while($resbek = $stmt->fetch()){ $GameVotesScore += $resbek['UserVote']; $m++; }; $GameVotesAantal = $m; //inputten in nieuwe db. //nieuwe record invoegen... if($m == 1){ $BatchID = $nr; $GameScore = $GameVotesScore; $query = "INSERT INTO `".$vote_pdo_dbname."`.".$Stem_DB_Master." VALUES ('$BatchID','$GameVotesAantal','$GameVotesScore','$GameScore')"; $conn_vote->exec($query); }else{ //bestaande record updaten... $BatchID = $nr; $GameScore = round(($GameVotesScore / $GameVotesAantal), 8); $query = "UPDATE `".$vote_pdo_dbname."`.".$Stem_DB_Master." SET GameVotesAantal = '$GameVotesAantal', GameVotesScore = '$GameVotesScore', GameScore = '$GameScore' WHERE BatchID = '$BatchID'"; $conn_vote->exec($query); }; //einde stemberekening... //************************************** //einde stem toevoegen aan db //doorheaderen if($bg != ""){ $vote_add = "vote.php?bg=$bg&d=$enccc_bid"; }else{ $vote_add = "vote.php?d=$enccc_bid"; }; header("Location: $vote_url$vote_add"); //einde doorheaderen exit; }; ?>
$page_title"; //einde title outputten ?>