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