/**
* 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;
}
}
