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']);
}
