/**
* Записывает видео в топ саммых папулярных видео если оно подходит по балам или видео в топе не привышает MAX_POPULAR_VIDEO_IN_CATEGORY
* @param $videoId
* @param $categoriesIds
* @param $balls
* @throws Exception
*/
public function setPopularVideo($videoId, $categoriesIds, $balls)
{
if (!empty($categoriesIds)) {
$categories = explode(',', $categoriesIds);
foreach ($categories as $category) {
// Если видео есть в списке популярных то в нем просто обновляются баллы
$this->db->query("UPDATE video_popular SET balls = :balls WHERE video_id = :videoId AND category_id = :categoryId", ['videoId' => $videoId, 'categoryId' => $category, 'balls' => $balls]);
if ($this->db->getConnect()->affected_rows < 1) {
// если нет видео, получается видео с самым меньшим колличеством баллов
$minBallsVideo = $this->db->fetchRow("SELECT SQL_CALC_FOUND_ROWS * FROM video_popular WHERE category_id = :categoryId ORDER BY balls ASC LIMIT 1", ['categoryId' => $category]);
$foundRows = $this->db->fetchOne("SELECT FOUND_ROWS();");
$insertVideo = false;
// если популярных видео в категории меньше чем значение это значит что мы можем просто добавить видео в популярные
if ($foundRows < self::MAX_POPULAR_VIDEO_IN_CATEGORY) {
$insertVideo = true;
} else {
if ($minBallsVideo['balls'] < $balls) {
// если у текущего видео балл выше чем у видео с наименьшим балом, то заменяем видео с наименьшим балом на текущее.
$insertVideo = true;
$this->db->query("DELETE FROM video_popular WHERE video_id = :videoId AND category_id = :categoryId", ['videoId' => $minBallsVideo['video_id'], 'categoryId' => $minBallsVideo['category_id']]);
}
}
if ($insertVideo) {
$this->db->query("INSERT INTO video_popular (video_id, category_id, balls) VALUES (:videoId, :categoryId, :balls)", ['videoId' => $videoId, 'categoryId' => $category, 'balls' => $balls]);
}
}
}
}
}
public static function pos($inmueble)
{
$pos = Db::fetchOne(Db::select(array('pos' => 'MAX(posicion)'), 'inmuebles_paginas', array('inmueble_id' => $inmueble)));
if (empty($pos)) {
$pos = 0;
}
return $pos;
}
if (!empty($_POST)) {
$email = strtolower($_POST['email']);
$password = $_POST['password'];
$passwordagain = $_POST['passwordagain'];
$captcha = strtolower($_POST['captcha']);
if (!Session::captchaCompare('signup', $captcha)) {
$error['captcha'] = true;
}
if (!isEmail($email)) {
$error['email'] = true;
}
if (strlen($password) < 6) {
$error['password'] = true;
}
if ($passwordagain != $password) {
$error['passwordagain'] = true;
}
if (empty($error)) {
$emailexists = Db::fetchOne("SELECT email FROM users\n WHERE email = '{$email}'");
if (!empty($emailexists)) {
$error['email'] = true;
}
}
if (empty($error)) {
Db::insert('users', array('email' => $email, 'password' => md5($password)));
$uid = Db::inserted();
Db::update('projects_access', array('uid' => $uid), "email = '{$email}'");
header("Location: {$config['root']}signin/?email={$email}");
}
}
require_once "{$root}/themes/{$theme}/signup.php";
include_once "{$root}/common.php";
$title = __('TLDsSuggest');
if (!empty($_POST)) {
$domain = $_POST['domain'];
$description = $_POST['description'];
$captcha = strtolower($_POST['captcha']);
if (substr($domain, 0, 1) == '.') {
$domain = substr($domain, 1);
}
$domain = strtolower($domain);
if (!Session::captchaCompare('tldssuggest', $captcha)) {
$error['captcha'] = true;
}
if (strlen($domain) < 2 || !isTLD($domain)) {
$error['domain'] = true;
}
if (!empty($description) && strlen($description) > 140) {
$error['description'] = true;
}
if (empty($error)) {
$tldexists = Db::fetchOne("SELECT domain FROM tlds\n WHERE LCASE(domain) = '{$domain}'");
if (!empty($tldexists)) {
$error['domainexists'] = true;
}
}
if (empty($error)) {
Db::insert('tlds', array('domain' => $domain, 'description' => $description, 'suggest' => 1));
header("Location: {$config['root']}tlds/");
}
}
require_once "{$root}/themes/{$theme}/tldssuggest.php";
include_once "{$root}/config.php";
include_once "{$root}/common.php";
if (Session::$logged) {
header("Location: {$config['root']}dd/");
}
$title = __('RestoreTitle');
$error = array();
if (isset($_GET['email']) && isEmail($_GET['email'])) {
$email = $_GET['email'];
}
if (!empty($_POST)) {
$email = $_POST['email'];
if (!isEmail($email)) {
$error['email'] = true;
} else {
$uid = Db::fetchOne("SELECT uid FROM users\n WHERE email = '{$email}'");
if (empty($uid)) {
$error['email'] = true;
}
}
if (empty($error)) {
$password = '';
for ($i = 0; $i < 8; $i++) {
$password .= rand(0, 9);
}
Db::update('users', array('password' => md5($password)), "uid = '{$uid}'");
/**
* @todo Send email.
*/
header("Location: {$config['root']}signin/?email={$email}");
}
if (!empty($_POST)) {
$name = $_POST['name'];
$description = $_POST['description'];
$public = $_POST['public'] ? 1 : 0;
$domains = $_POST['domain'];
if (strlen($name) < 3) {
$error['name'] = true;
}
if (!empty($description) && strlen($description) > 140) {
$error['description'] = true;
}
if (empty($error)) {
if ($pid) {
if (!empty($domains) && is_array($domains)) {
foreach ($domains as $tid => $active) {
if (!$active) {
continue;
}
$tldexists = Db::fetchOne("SELECT tid FROM projects_tlds\n WHERE pid = '{$pid}' AND tid = '{$tid}'");
if (empty($tldexists)) {
Db::insert('projects_tlds', array('pid' => $pid, 'tid' => $tid));
}
}
Db::query("DELETE FROM projects_tlds\n WHERE pid = '{$pid}'\n AND tid NOT IN ( '" . implode("', '", array_keys($domains)) . "' )");
}
Db::update('projects', array('name' => $name, 'description' => $description, 'public' => $public), "pid = '{$pid}'");
}
header("Location: {$config['root']}dd/projects/");
}
}
require_once "{$root}/themes/{$theme}/ddprojectsedit.php";
protected function getValue($name)
{
$this->autoload();
if (isset($this->all[$name])) {
return $this->all[$name];
}
$value = Db::fetchOne('SELECT option_value FROM `' . Common::prefixTable('option') . '` ' . 'WHERE option_name = ?', $name);
if ($value === false) {
return false;
}
$this->all[$name] = $value;
return $value;
}
/**
* Devuelve la cantidad de registros en una tabla.
*
* @param string $table
* @param string|array|null $where
* @return integer
*/
public static function count($table, $where = null)
{
$where = self::where($where);
return Db::fetchOne("SELECT COUNT(*) FROM {$table}\n WHERE {$where}");
}
<?php
$root = '.';
include_once "{$root}/config.php";
include_once "{$root}/common.php";
if (!Session::$logged) {
header("Location: {$config['root']}signin/?next={$config['root']}dd/projects/");
}
$title = __('ProjectsTitle');
$count = Db::fetchOne("SELECT COUNT(*) FROM projects WHERE uid = '" . Session::_('uid') . "'");
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$start = ($page - 1) * $config['perpage'];
$projects = Db::fetchAssoc("SELECT pid, name, description\n FROM projects\n WHERE uid = '" . Session::_('uid') . "'\n ORDER BY name\n LIMIT {$start},{$config['perpage']}");
$pagination = pagination("{$config['root']}dd/projects/", $count, $config['perpage'], $page);
require_once "{$root}/themes/{$theme}/ddprojects.php";
protected function exists($id)
{
$exists = Db::fetchOne("SELECT COUNT(id_user)\n FROM twcensus_users\n WHERE id_user = '******'");
return $exists > 0;
}
/**
* Get the SiteId from the given site url using mysql
* driver.
*
* @param string $domain
*
* @return int $id
*/
public function getSiteId($domain)
{
$parsedDomain = parse_url($domain);
$domain = 'http://' . $parsedDomain['path'];
$siteId = Db::fetchOne('SELECT idsite FROM piwik_site WHERE main_url=?', array($domain));
if (!$siteId) {
$siteId = Db::fetchOne('SELECT idsite FROM piwik_site_url WHERE url=?', array($domain));
}
return $siteId;
}
