<?php
\ndefined('BASEPATH') or exit('No direct script access allowed');
\n
\nclass Manager_model extends CI_Model
\n{
\n
\n\tpublic function new_auto_message($name, $content, $data_ad_message)
\n\t{
\n\t\t$data = array(
\n\t\t\t'name' => $name,
\n\t\t\t'content' => $content,
\n\t\t\t'author' => 6180319,
\n\t\t\t'publish_date' => now()
\n\t\t);
\n
\n\t\tif(is_array($data_ad_message))
\n\t\t{
\n\t\t\t$data['type'] = $data_ad_message['message_type'];
\n\t\t\t$data['periodicity'] = $data_ad_message['periodicity'];
\n\t\t\t$data['instant_publish'] = $data_ad_message['instant_publish'];
\n\t\t}
\n\t\t
\n\t\t$this->db->insert('messages_auto', $data);
\n\t}
\n
\n\tpublic function get_auto_messages($offset, $limit)
\n\t{
\n\t\treturn $this->db->select('id, type, periodicity, name, views')->order_by('id','desc')->get('messages_auto')->result();
\n\t}
\n
\n\tpublic function get_message_views()
\n\t{
\n\t\t$this->db->select('messages_auto_views.id ,messages_auto_views.date, messages_auto_views.user_id, users.nickname, messages_auto_views.date, messages_auto.name');
\n\t\t$this->db->join('messages_auto', 'messages_auto.id = messages_auto_views.guid');
\n\t\t$this->db->join('users', 'users.id = messages_auto_views.user_id');
\n\t\t$this->db->order_by('id','desc');
\n\t\t$this->db->limit(500);
\n\t\treturn $this->db->get('messages_auto_views')->result();
\n\t}
\n
\n
\n}