public function __construct()
{
$this->feather = \Slim\Slim::getInstance();
$this->config = $this->feather->config;
$this->user = $this->feather->user;
$this->request = $this->feather->request;
$this->hooks = $this->feather->hooks;
DB::configure('id_column_overrides', array('pms_data' => array('conversation_id', 'user_id')));
}
public static function init_db(array $config, $log_queries = false)
{
$config['db_prefix'] = !empty($config['db_prefix']) ? $config['db_prefix'] : '';
switch ($config['db_type']) {
case 'mysql':
DB::configure('mysql:host=' . $config['db_host'] . ';dbname=' . $config['db_name']);
DB::configure('driver_options', array(\PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
break;
case 'sqlite':
case 'sqlite3':
DB::configure('sqlite:./' . $config['db_name']);
break;
case 'pgsql':
DB::configure('pgsql:host=' . $config['db_host'] . 'dbname=' . $config['db_name']);
break;
}
DB::configure('username', $config['db_user']);
DB::configure('password', $config['db_pass']);
DB::configure('prefix', $config['db_prefix']);
if ($log_queries) {
DB::configure('logging', true);
}
DB::configure('id_column_overrides', array($config['db_prefix'] . 'groups' => 'g_id'));
}
public function addMessage(array $data = array(), $conv_id = null, array $uid = array())
{
$add = DB::for_table('pms_messages')->create()->set($data)->set('conversation_id', $conv_id);
$add->save();
$update_data = ['last_post_id' => $add->id()];
// If it is a new conversation:
if (!empty($uid)) {
$update_data['first_post_id'] = $add->id();
}
$update = DB::for_table('pms_conversations')->find_one($conv_id)->set($update_data);
// Increment replies count
if (empty($uid)) {
$update->set_expr('num_replies', 'num_replies+1');
}
$update = $update->save();
DB::configure('id_column', array('conversation_id', 'user_id'));
if (!empty($uid)) {
// New conversation
foreach ($uid as $user) {
$notifs = DB::for_table('pms_data')->create()->set(array('conversation_id' => $conv_id, 'user_id' => $user, 'viewed' => $user == User::get()->id ? '1' : '0'))->save();
}
} else {
// Reply
$notifs = DB::for_table('pms_data')->where('conversation_id', $conv_id)->where_not_equal('user_id', User::get()->id)->find_result_set();
$notifs->set('viewed', 0)->save();
}
return $add && $update && $notifs ? $add->id() : false;
}