Exemple #1
1
 public function save(Comment $comment)
 {
     DB::db()->query('INSERT INTO comments (`theme_id`, `date`, `comment`, `author`) VALUES(?, ?, ?, ?)', [$comment->getThemeId(), $comment->getDate(), $comment->getComment(), $comment->getAuthor()]);
 }
Exemple #2
1
 /**
  * Guarda un comentario en la base de datos
  *
  * @param Comment $coment
  *        	El comentario a ser guardado
  * @throws PDOException Si ocurre un error de base de datos
  * @return void
  */
 public function save(Comment $comment)
 {
     $stmt = $this->db->prepare("INSERT INTO comments(`dateComment`,`content`,`numLikes`,`author`,`idPost`) values(?,?,?,?,?)");
     $stmt->execute(array($comment->getDate(), $comment->getContent(), 0, $comment->getAuthor(), $comment->getIdPost()));
 }
             $response[2] .= '<input class="btn btn-primary" type="submit" value="'.$langSubmit.'" onclick="xmlhttpPost(\''.$urlServer.'modules/comments/comments_perso_blog.php\', \'editSave\','.$comment->getRid().', \''.$comment->getRtype().'\', \''.$langCommentsSaveConfirm.'\', '.$comment->getId().');"/>';
         } else {
             $response[0] = 'ERROR';
             $response[1] = "<div class='alert alert-warning'>".$langCommentsEditNoPerm."</div>";
         }
     } else {
         $response[0] = 'ERROR';
         $response[1] = "<div class='alert alert-warning'>".$langCommentsLoadFail."</div>";
     }
     echo json_encode($response);
 } else if ($_POST['action'] == 'editSave') {
     $comment = new Comment();
     if ($comment->loadFromDB(intval($_POST['cid']))) {
         $permEdit = false;
         if (isset($_SESSION['uid'])) {
             if ($comment->getAuthor() == $uid) {
                 $permEdit = true;
             }
             $blog_user = Database::get()->querySingle("SELECT user_id FROM blog_post WHERE id = ?d", $comment->getRid());
             if ($blog_user->user_id == $uid) {
                 $permEdit = true;
             }
             if (isset($is_admin) && $is_admin) {
                 $permEdit = true;
             }
         }
         if ($permEdit) {
             if ($comment->edit($_POST['commentText'])) {
                 $response[0] = 'OK';
                 $response[1] = "<div class='alert alert-success'>".$langCommentsSaveSuccess."</div>";
                 $response[2] = '<div id="comment_content-'.$comment->getId().'">'.q($comment->getContent()).'</div>';
Exemple #4
0
        $post_actions = '<div class="pull-right">';
        $post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\''.$urlServer.'modules/comments/comments.php?course='.$course_code.'\', \'editLoad\', '.$_POST['rid'].', \''.$_POST['rtype'].'\', \'\', '.$comment->getId().')">';
        $post_actions .= icon('fa-edit', $langModify).'</a> ';
        $post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\''.$urlServer.'modules/comments/comments.php?course='.$course_code.'\', \'delete\', '.$_POST['rid'].', \''.$_POST['rtype'].'\', \''.$langCommentsDelConfirm.'\', '.$comment->getId().')">';
        $post_actions .= icon('fa-times', $langDelete).'</a>';
        $post_actions .='</div>';   
        
        $response[0] = 'OK';
        $response[1] = "<div class='alert alert-success'>".$langCommentsSaveSuccess."</div>";
        $response[2] = $comment->getId();
        $response[3] = "
 <div class='row margin-bottom-thin margin-top-thin comment' id='comment-".$comment->getId()."'>
            <div class='col-xs-12'>
                <div class='media'>
                    <a class='media-left' href='#'>
                        ". profile_image($comment->getAuthor(), IMAGESIZE_SMALL) ."
                    </a>
                    <div class='media-body bubble'>
                        <div class='label label-success media-heading'>".nice_format($comment->getTime(), true).'</div>'.
                            "<small>".$langBlogPostUser.display_user($comment->getAuthor(), false, false)."</small>".
                            $post_actions
                            ."<div class='margin-top-thin' id='comment_content-".$comment->getId()."'>". q($comment->getContent()) ."</div>
                    </div>
                </div>
            </div>
        </div>                    
        ";
    } else {
        $response[0] = 'ERROR';
        $response[1] = "<div class='alert alert-warning'>".$langCommentsSaveFail."</div>";
    }
Exemple #5
0
 //[0] -> status, [1] -> message, other positions -> other data
 $response = array();
 if ($_POST['action'] == 'new') {
     if (Commenting::permCreate($is_editor, $uid, $course_id)) {
         $comment = new Comment();
         if ($comment->create($_POST['commentText'], $uid, $_POST['rtype'], intval($_POST['rid']))) {
             $post_actions = '<div class="pull-right">';
             $post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\'' . $urlServer . 'modules/comments/comments.php?course=' . $course_code . '\', \'editLoad\', ' . $_POST['rid'] . ', \'' . $_POST['rtype'] . '\', \'\', ' . $comment->getId() . ')">';
             $post_actions .= icon('fa-edit', $langModify) . '</a> ';
             $post_actions .= '<a href="javascript:void(0)" onclick="xmlhttpPost(\'' . $urlServer . 'modules/comments/comments.php?course=' . $course_code . '\', \'delete\', ' . $_POST['rid'] . ', \'' . $_POST['rtype'] . '\', \'' . $langCommentsDelConfirm . '\', ' . $comment->getId() . ')">';
             $post_actions .= icon('fa-times', $langDelete) . '</a>';
             $post_actions .= '</div>';
             $response[0] = 'OK';
             $response[1] = "<div class='alert alert-success'>" . $langCommentsSaveSuccess . "</div>";
             $response[2] = $comment->getId();
             $response[3] = "\r\n         <div class='row margin-bottom-thin margin-top-thin comment' id='comment-" . $comment->getId() . "'>\r\n                    <div class='col-xs-12'>\r\n                        <div class='media'>\r\n                            <a class='media-left' href='#'>\r\n                                " . profile_image($comment->getAuthor(), IMAGESIZE_SMALL) . "\r\n                            </a>\r\n                            <div class='media-body bubble'>\r\n                                <div class='label label-success media-heading'>" . nice_format($comment->getTime(), true) . '</div>' . "<small>" . $langBlogPostUser . display_user($comment->getAuthor(), false, false) . "</small>" . $post_actions . "<div class='margin-top-thin' id='comment_content-" . $comment->getId() . "'>" . q($comment->getContent()) . "</div>\r\n                            </div>\r\n                        </div>\r\n                    </div>\r\n                </div>                    \r\n                ";
         } else {
             $response[0] = 'ERROR';
             $response[1] = "<div class='alert alert-warning'>" . $langCommentsSaveFail . "</div>";
         }
     } else {
         $response[0] = 'ERROR';
         $response[1] = "<div class='alert alert-warning'>" . $langCommentsNewNoPerm . "</div>";
     }
     echo json_encode($response);
 } else {
     if ($_POST['action'] == 'delete') {
         $comment = new Comment();
         if ($comment->loadFromDB(intval($_POST['cid']))) {
             if ($comment->permEdit($is_editor, $uid)) {
                 if ($comment->delete()) {
Exemple #6
0
 /**
  * Saves a comment
  * 
  * @param Comment $comment The comment to save
  * @throws PDOException if a database error occurs
  * @return void
  */
 public function save(Comment $comment)
 {
     $stmt = $this->db->prepare("INSERT INTO comments(content, author, post) values (?,?,?)");
     $stmt->execute(array($comment->getContent(), $comment->getAuthor()->getUsername(), $comment->getPost()->getId()));
 }
Exemple #7
0
 /**
  * Write comment to XML format
  *
  * @param 	Shared_XMLWriter		$objWriter 			XML Writer
  * @param	string							$pCellReference		Cell reference
  * @param 	Comment				$pComment			Comment
  * @param	array							$pAuthors			Array of authors
  * @throws 	Exception
  */
 public function _writeComment(Shared_XMLWriter $objWriter = null, $pCellReference = 'A1', Comment $pComment = null, $pAuthors = null)
 {
     // comment
     $objWriter->startElement('comment');
     $objWriter->writeAttribute('ref', $pCellReference);
     $objWriter->writeAttribute('authorId', $pAuthors[$pComment->getAuthor()]);
     // text
     $objWriter->startElement('text');
     $this->getParentWriter()->getWriterPart('stringtable')->writeRichText($objWriter, $pComment->getText());
     $objWriter->endElement();
     $objWriter->endElement();
 }
require_once '../database_access.php';
$comment = new Comment();
if (isset($_POST['creation_date'])) {
    $comment->setCreationDate($_POST['creation_date']);
}
if (isset($_POST['edit_date'])) {
    $comment->setEditDate($_POST['edit_date']);
}
if (isset($_POST['author_user_id'])) {
    $comment->setAuthorUserId($_POST['author_user_id']);
}
if (isset($_POST['target_event_id'])) {
    $comment->setTargetEventId($_POST['target_event_id']);
}
if (isset($_POST['comment_text'])) {
    $comment->setCommentText($_POST['comment_text']);
}
if (!$comment->validate()) {
    foreach ($comment->getValidationFailures() as $failure) {
        echo '<p><strong>Error in ' . $failure->getPropertyPath() . ' field!</strong> ' . $failure->getMessage() . '</p>';
    }
    unset($failure);
} else {
    $comment->save();
    // add the author name and return the JSON
    $comment_json = json_decode($comment->toJSON());
    $author = $comment->getAuthor();
    $comment_json->authorFirstName = $author->getFirstName();
    $comment_json->authorLastName = $author->getLastName();
    echo json_encode($comment_json);
}