/** * Erstellt einen neuen Kommentar in einem Event * Returncodes: 0; 50 * @param $EventID * @param $Comment * @param $UserID * @return int */ public function newComment($EventID, $Comment, $UserID) { $PDO = $this->PDO; $query = "INSERT INTO `eventcomment` (`CommentID`, `EventID`, `UserID`,`UserName`, `Text`) VALUES (:CommentID, :EventID, :UserID, :UserName, :Text)"; $CommentID = $this->generateCommentID(); $Comment = str_replace("%20", ' ', $Comment); $stmt = $PDO->prepare($query); $Users = new \Users\User(); $UserName = $Users->getNickname($UserID); $stmt->bindParam(":CommentID", $CommentID, $PDO::PARAM_INT); $stmt->bindParam(":EventID", $EventID, $PDO::PARAM_INT); $stmt->bindParam(":UserID", $UserID, $PDO::PARAM_INT); $stmt->bindParam(":UserName", $UserName, $PDO::PARAM_STR); $stmt->bindParam(":Text", $Comment, $PDO::PARAM_STR); if ($stmt->execute()) { return 0; } else { return 50; } }
/** * Gibt alle Teilnhemer mit Details(bspw. Nutzername) für ein Event aus * Returncodes: 7; 23 * @param $EventID * @return array|int */ public function getEventMembersWithInformation($EventID) { $PDO = $this->PDO; $query = "SELECT UserID FROM `eventmembers` WHERE EventID = :EventID"; $stmt = $PDO->prepare($query); $stmt->bindParam(":EventID", $EventID, $PDO::PARAM_INT); if ($stmt->execute()) { if ($stmt->rowCount() == 0) { return 23; } else { $UserIDs = $stmt->fetchAll($PDO::FETCH_COLUMN); $Users = new User(); $temp2 = array(); foreach ($UserIDs as $UserID) { $Nickname = $Users->getNickname($UserID); $ParticipationState = $this->getParticipantStatus($EventID, $UserID); $temp1 = array('UserID' => $UserID, 'Nickname' => $Nickname, 'ParticipationState' => $ParticipationState); array_push($temp2, $temp1); } return array("Users" => $temp2); } } else { return 7; } }