Beispiel #1
0
 /**
  * @param $id
  * @param $id_acc
  * @param $title
  * @param $post
  * @param int $category
  */
 public static function edit($id, $id_acc, $title, $post, $category = 2)
 {
     $cleanPost = \Post::sensor($post, false);
     $sql = sprintf("UPDATE `iniforum`.`posts`\n            SET `post` = :post, `title` = :title, `id_category` = :category, `modified_at`=now()\n            WHERE `posts`.`id` = :id AND `posts`.`id_account` = :id_acc");
     $bindArray = [':id' => $id, ':id_acc' => $id_acc, ':title' => $title, ':post' => $cleanPost, ':category' => $category];
     self::query($sql, $bindArray);
 }
Beispiel #2
0
 public static function create($from, $to, $subject, $msg)
 {
     $cleanMsg = \Post::sensor($msg, false);
     $sql = sprintf("INSERT INTO `iniforum`.`messages` \n            (`id`, `from_account`, `to_account`, `subject`, `text`, `created_at`)\n            VALUES (NULL, :from_member, :to_member, :subject, :msg, CURRENT_TIMESTAMP)");
     $bindArray = [':from_member' => $from, ':to_member' => $to, ':subject' => $subject, ':msg' => $cleanMsg];
     self::query($sql, $bindArray);
 }