public function add() { $email = $_REQUEST['email']; $exists = DB::query("select * from suscribers where email = '" . $email . "'", 1); $json = "already_suscribed"; if (!$exists) { DB::write("insert into suscribers set email = '" . $email . "'"); $json = "success"; } return array('result' => $json); }
public function add_cam_code() { $webcams = DB::query('select * from webcams', 0); foreach ($webcams as $cam) { if ($cam['code'] == '') { $code = substr(md5(uniqid(mt_rand(), true)), 0, 12); DB::write('update webcams set code = \'' . $code . '\' where id = ' . $cam['id']); } } return []; }
public function login() { extract($_REQUEST); $data = DB::query("select * from users \n\t\t\twhere email = '" . $email . "' and pass = '******' \n\t\t\tor username = '******' and pass = '******'", 1); DB::write('update users set lastlogin_ts = ' . time() . ' where id = ' . $data['id']); $json = 0; if ($data) { $json = 1; AuthController::add_session($data); } return array('result' => $json); }
public function register_preview() { extract($_REQUEST); $exists = DB::query("select * from users where email = '" . $email . "'", 1); $json = "email_not_evailable"; $id = 0; if (!$exists) { $id = DB::write("insert into suscribers set \n\t\t\t\t\ttitle = '" . $title . "',\n\t\t\t\t\temail = '" . $email . "',\n\t\t\t\t\tusername = '******'"); $json = "email_evailable"; } return array('result' => $json, 'id' => $id); }
public function follow() { extract($_POST); $following = DB::query('select id from follows where user_id = ' . $_SESSION['user_id'] . ' and user2_id = ' . $id, 1); $title = DB::query('select title from users where id = ' . $id, 2, 'title'); if (!$following) { $success = DB::write('insert into follows set user_id = ' . $_SESSION['user_id'] . ', user2_id = ' . $id); } else { $success = DB::write('delete from follows where user_id = ' . $_SESSION['user_id'] . ' and user2_id = ' . $id); } return array('success' => $success, 'title' => $title); }
public function add() { extract($_REQUEST); $now = time(); $lastid = DB::update('feed', $id, '*'); /* preg_match_all('/(#\w+)/', $status, $matches); foreach ($matches[0] as $hashtag) echo $hashtag . ' '; */ preg_match_all("/(@\\w+)/", $status, $matches); foreach ($matches[0] as $mentiontag) { $user_id = DB::query('select id from users where username = \'' . str_replace('@', '', $mentiontag) . '\'', '2', 'id'); if ($user_id) { DB::write('insert into mentions set user_id = ' . $_SESSION['user_id'] . ', user2_id = ' . $user_id . ', feed_id = ' . $lastid . ', created_ts = ' . $now); } } $entry = feedController::status($lastid); return array('entry' => $entry); }
private function keep_online() { DB::write('update users set last_ts = ' . time() . ' where id = ' . $_SESSION['user_id']); }