function assignFromDB($userid) { global $tpl, $opt; $rs = sql("SELECT `p`.`id`, IFNULL(`tt`.`text`, `p`.`name`) AS `name`, `p`.`default_value`, `p`.`check_regex`, `p`.`option_order`, `u`.`option_visible`, `p`.`internal_use`, `p`.`option_input`, IFNULL(`u`.`option_value`, `p`.`default_value`) AS `option_value`\r\n\t\t FROM `profile_options` AS `p`\r\n\t\t LEFT JOIN `user_options` AS `u` ON `p`.`id`=`u`.`option_id` AND (`u`.`user_id` IS NULL OR `u`.`user_id`='&1')\r\n\t\t LEFT JOIN `sys_trans` AS `st` ON `p`.`trans_id`=`st`.`id` AND `p`.`name`=`st`.`text`\r\n\t\t LEFT JOIN `sys_trans_text` AS `tt` ON `st`.`id`=`tt`.`trans_id` AND `tt`.`lang`='&2'\r\n\t\t ORDER BY `p`.`internal_use` DESC, `p`.`option_order`", $userid + 0, $opt['template']['locale']); $tpl->assign_rs('useroptions', $rs); sql_free_result($rs); }
public function run() { sql('set @allowdelete=1'); sql('DELETE FROM `user` WHERE `date_created`<DATE_ADD(NOW(), INTERVAL -21 DAY) AND `is_active_flag`=0 AND `activation_code`!=\'\''); }
function find($gamearr) { $number_of_games = count($gamearr); if ($number_of_games == 0) { echo "No Game Choosen."; } else { $table = []; $max_cpu = 0; $max_gpu = 0; for ($i = 0; $i < $number_of_games; $i++) { $sql = "SELECT cpuscore, gpuscore FROM game WHERE game.name LIKE'%{$gamearr[$i]}%'"; $result = sql($sql, 1); $row = $result->fetch_assoc(); //echo 'cpuscore: '.$row['cpuscore']; $table[$i] = $row; } // 'cpuscore: '.$table[0]['cpuscore']. ' gpuscore: '.$table[0]['gpuscore']; for ($x = 0; $x < $number_of_games; $x++) { $cur_cpuscore = $table[$x]['cpuscore']; $cur_gpuscore = $table[$x]['gpuscore']; if ($cur_cpuscore > $max_cpu) { $max_cpu = $cur_cpuscore; } if ($cur_gpuscore > $max_gpu) { $max_gpu = $cur_gpuscore; } } echo 'needed cpu score: ' . $max_cpu . ' needed gpu score: ' . $max_gpu; } }
function create_databases($base) { $tables = array($base . 'cache', $base . 'meta', $base . 'stats'); sql('DROP TABLE IF EXISTS ' . implode(',', $tables)); sql('CREATE TABLE ' . $base . 'cache (' . 'id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,' . 'url VARCHAR(255),' . 'lastscanned DATETIME, ' . 'jsondata TEXT, ' . 'start INT UNSIGNED, ' . 'end INT UNSIGNED' . ')'); // TODO: Add UNIQUE key to url, start, end. sql('CREATE TABLE ' . $base . 'meta (' . 'id VARCHAR(20) PRIMARY KEY,' . 'lastscanned DATETIME, ' . 'jsondata TEXT' . ')'); sql('CREATE TABLE ' . $base . 'stats (' . 'name VARCHAR(100), ' . 'message VARCHAR(255), ' . 'timestamp DATETIME, ' . 'microtime INT UNSIGNED' . ')'); }
function mq_edit($p, $o, $res = '') { list($p, $o) = ajxp($res, $p, $o); $r = sql('select ' . $p . ' from ' . $o . ';', ''); //if($r)foreach($r as $v)$ret.=lj('','popup_plup___mysqm_mq*edit_'.$v[0],$v[0]); return $ret; }
static function getAttrbutesListArrayInternal($cacheId, $bOnlySelectable) { global $opt; $attributes = array(); $rsAttrGroup = sql("SELECT `attribute_groups`.`id`, \r\n\t\t IFNULL(`tt1`.`text`, `attribute_groups`.`name`) AS `name`, \r\n\t\t IFNULL(`tt2`.`text`, `attribute_categories`.`name`) AS `category`, \r\n\t\t `attribute_categories`.`color`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM `attribute_groups` \r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN `attribute_categories` ON `attribute_groups`.`category_id`=`attribute_categories`.`id`\r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN `sys_trans` AS `t1` ON `attribute_groups`.`trans_id`=`t1`.`id` AND `attribute_groups`.`name`=`t1`.`text` \r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN `sys_trans_text` AS `tt1` ON `t1`.`id`=`tt1`.`trans_id` AND `tt1`.`lang`='&1' \r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN `sys_trans` AS `t2` ON `attribute_categories`.`trans_id`=`t2`.`id` AND `attribute_categories`.`name`=`t2`.`text` \r\n\t\t\t\t\t\t\t\t\t\t LEFT JOIN `sys_trans_text` AS `tt2` ON `t2`.`id`=`tt2`.`trans_id` AND `tt2`.`lang`='&1' \r\n\t\t\t\t\t\t\t\t\t\t\tORDER BY `attribute_groups`.`id` ASC", $opt['template']['locale']); while ($rAttrGroup = sql_fetch_assoc($rsAttrGroup)) { $attr = array(); $bFirst = true; if ($cacheId == 0) { $sAddWhereSql = ''; if ($bOnlySelectable == true) { $sAddWhereSql = ' AND `cache_attrib`.`selectable`=1'; } $rsAttr = sql("SELECT `cache_attrib`.`id`, IFNULL(`tt1`.`text`, `cache_attrib`.`name`) AS `name`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIFNULL(`tt2`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`, `cache_attrib`.`icon`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `cache_attrib`\r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans` AS `t1` ON `cache_attrib`.`trans_id`=`t1`.`id` AND `cache_attrib`.`name`=`t1`.`text` \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt1` ON `t1`.`id`=`tt1`.`trans_id` AND `tt1`.`lang`='&1' \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans` AS `t2` ON `cache_attrib`.`html_desc_trans_id`=`t2`.`id` \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt2` ON `t2`.`id`=`tt2`.`trans_id` AND `tt2`.`lang`='&1' \r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE `cache_attrib`.`group_id`='&2'\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY `cache_attrib`.`group_id` ASC", $opt['template']['locale'], $rAttrGroup['id']); } else { $rsAttr = sql("SELECT `cache_attrib`.`id`, IFNULL(`tt1`.`text`, `cache_attrib`.`name`) AS `name`,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tIFNULL(`tt2`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`, `cache_attrib`.`icon`\r\n\t\t\t\t\t\t\t\t\t\t\t\t FROM `caches_attributes` \r\n\t\t\t\t\t\t\t\t\t INNER JOIN `cache_attrib` ON `caches_attributes`.`attrib_id`=`cache_attrib`.`id` \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans` AS `t1` ON `cache_attrib`.`trans_id`=`t1`.`id` AND `cache_attrib`.`name`=`t1`.`text` \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt1` ON `t1`.`id`=`tt1`.`trans_id` AND `tt1`.`lang`='&2' \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans` AS `t2` ON `cache_attrib`.`html_desc_trans_id`=`t2`.`id` \r\n\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt2` ON `t2`.`id`=`tt2`.`trans_id` AND `tt2`.`lang`='&2' \r\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE `caches_attributes`.`cache_id`='&1' AND `cache_attrib`.`group_id`='&3'\r\n\t\t\t\t\t\t\t\t\t\t\t\tAND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY `cache_attrib`.`group_id` ASC", $cacheId, $opt['template']['locale'], $rAttrGroup['id']); } while ($rAttr = sql_fetch_assoc($rsAttr)) { $attr[] = $rAttr; } sql_free_result($rsAttr); if (count($attr) > 0) { $attributes[] = array('name' => $rAttrGroup['name'], 'color' => $rAttrGroup['color'], 'category' => $rAttrGroup['category'], 'attr' => $attr); } } sql_free_result($rsAttrGroup); return $attributes; }
function queues_check_compoundrecordings() { global $db; $compound_recordings = array(); $sql = "SELECT extension, descr, agentannounce_id, ivr_id FROM queues_config WHERE (ivr_id != 'none' AND ivr_id != '') OR agentannounce_id != ''"; $results = sql($sql, "getAll", DB_FETCHMODE_ASSOC); if (function_exists('ivr_get_details')) { $ivr_details = ivr_get_details(); foreach ($ivr_details as $item) { $ivr_hash[$item['id']] = $item; } $check_ivr = true; } else { $check_ivr = false; } foreach ($results as $result) { $agentannounce = $result['agentannounce_id'] ? recordings_get_file($result['agentannounce_id']) : ''; if (strpos($agentannounce, "&") !== false) { $compound_recordings[] = array('extension' => $result['extension'], 'descr' => $result['descr'], 'error' => _("Agent Announce Msg")); } if ($result['ivr_id'] != 'none' && $result['ivr_id'] != '' && $check_ivr) { $id = $ivr_hash[$result['ivr_id']]['announcement_id']; $announce = $id ? recordings_get_file($id) : ''; if (strpos($announce, "&") !== false) { $compound_recordings[] = array('extension' => $result['extension'], 'descr' => $result['descr'], 'error' => sprintf(_("IVR Announce: %s"), $ivr_hash[$result['ivr_id']]['displayname'])); } } } return $compound_recordings; }
public function run() { $rsCache = sql("SELECT `cache_id`, `latitude`, `longitude` FROM `caches` WHERE `need_npa_recalc`=1"); while ($rCache = sql_fetch_assoc($rsCache)) { sql("DELETE FROM `cache_npa_areas` WHERE `cache_id`='&1' AND `calculated`=1", $rCache['cache_id']); $rsLayers = sql("SELECT `id`, `type_id`, AsText(`shape`) AS `geometry` \n FROM `npa_areas` WHERE `exclude`=0 AND MBRWITHIN(GeomFromText('&1'), `shape`)", 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')'); while ($rLayers = sql_fetch_assoc($rsLayers)) { if (gis::ptInLineRing($rLayers['geometry'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')')) { $bExclude = false; // prüfen, ob in ausgesparter Fläche $rsExclude = sql("SELECT `id`, AsText(`shape`) AS `geometry`\n FROM `npa_areas`\n WHERE `exclude` = 1\n AND `type_id`='&1'\n AND MBRWITHIN(GeomFromText('&2'), `shape`)", $rLayers['type_id'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')'); while (($rExclude = sql_fetch_assoc($rsExclude)) && $bExclude == false) { if (gis::ptInLineRing($rExclude['geometry'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')')) { $bExclude = true; } } sql_free_result($rsExclude); if ($bExclude == false) { sql("INSERT INTO `cache_npa_areas` (`cache_id`, `npa_id`, `calculated`)\n VALUES ('&1', '&2', 1) ON DUPLICATE KEY UPDATE `calculated`=1", $rCache['cache_id'], $rLayers['id']); } } } sql_free_result($rsLayers); sql("UPDATE `caches` SET `need_npa_recalc`=0 WHERE `cache_id`='&1'", $rCache['cache_id']); } sql_free_result($rsCache); }
function plug_tags($p, $o) { req('mod,spe'); if ($_GET['sources']) { $r = sql('mail', 'qda', 'k', ''); $go = 'source'; //source foreach ($r as $k => $v) { if ($k != 'mail' && trim($k)) { $reb[preplink($k)] += 1; } } } else { $cat = $p ? $p : 'tag'; //$reb=tags_list($cat); $ra = sql('idtag,idart', 'qdta', 'k', ''); arsort($ra); $rb = sql('id,tag', 'qdt', 'kv', 'cat="' . $cat . '"'); arsort($ra); foreach ($ra as $k => $v) { if ($rb[$k]) { $reb[$rb[$k]] = $v; } } } if ($o) { $ret = tags_cloud($reb, 12, 27, ' ', $cat); } else { $ret = tg_list($reb, $go); } return divc('txtcadr', count($reb) . ' ' . ($p ? $p : 'Tags')) . $ret; }
public function run() { $rsDuplicatePic = sql('SELECT `object_id`, `title` FROM `pictures` WHERE `object_type`=1 GROUP BY `object_id`, `title` HAVING COUNT(*) > 1'); while ($rDuplicatePic = sql_fetch_assoc($rsDuplicatePic)) { $rsInstances = sql(" SELECT `pictures`.`id` `picid`, `cache_logs`.`cache_id` `cache_id`\n FROM `pictures`\n LEFT JOIN `cache_logs` ON `cache_logs`.`id` = `pictures`.`object_id`\n WHERE `pictures`.`object_type`=1 AND `pictures`.`object_id`='&1' AND `pictures`.`title`='&2'\n ORDER BY `pictures`.`date_created`", $rDuplicatePic['object_id'], $rDuplicatePic['title']); $instances = sql_fetch_assoc_table($rsInstances); foreach ($instances as &$instance) { $instance['pic'] = new picture($instance['picid']); $instance['filesize'] = @filesize($instance['pic']->getFilename()); } $countInstances = count($instances); for ($n = 1; $n < $countInstances; ++$n) { if ($instances[$n]['filesize'] !== false) { // ensure that pic is stored locally for ($nn = $n - 1; $nn >= 0; --$nn) { if ($instances[$nn]['filesize'] === $instances[$n]['filesize']) { if (file_get_contents($instances[$nn]['pic']->getFilename()) == file_get_contents($instances[$n]['pic']->getFilename())) { $picture = $instances[$n]['pic']; echo 'deleting duplicate picture ' . $picture->getPictureId() . ' ("' . $picture->getTitle() . '")' . ' from log ' . $rDuplicatePic['object_id'] . ' of cache ' . $instances[$n]['cache_id'] . "\n"; $picture->delete(false); $instances[$n]['filesize'] = false; break; } } } } } } sql_free_result($rsDuplicatePic); }
function run() { db_connect(); $rsCache = sql("SELECT `cache_id`, `latitude`, `longitude` FROM `caches` WHERE `need_npa_recalc`=1"); while ($rCache = mysql_fetch_assoc($rsCache)) { $sql = sql("DELETE FROM `cache_npa_areas` WHERE `cache_id`='&1' AND `calculated`=1", $rCache['cache_id']); mysql_query($sql); // Natura 2000 $rsLayers = sql("SELECT `id`, AsText(`shape`) AS `geometry` FROM `npa_areas` WHERE WITHIN(GeomFromText('&1'), `shape`)", 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')'); while ($rLayers = mysql_fetch_assoc($rsLayers)) { if (gis::ptInLineRing($rLayers['geometry'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')')) { $sql = sql("INSERT INTO `cache_npa_areas` (`cache_id`, `npa_id`, `calculated`) VALUES ('&1', '&2', 1) ON DUPLICATE KEY UPDATE `calculated`=1", $rCache['cache_id'], $rLayers['id']); mysql_query($sql); } } mysql_free_result($rsLayers); // Parki PL $rsLayers = sql("SELECT `id`, AsText(`shape`) AS `geometry` FROM `parkipl` WHERE WITHIN(GeomFromText('&1'), `shape`)", 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')'); while ($rLayers = mysql_fetch_assoc($rsLayers)) { if (gis::ptInLineRing($rLayers['geometry'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')')) { $sql = sql("INSERT INTO `cache_npa_areas` (`cache_id`, `parki_id`, `calculated`) VALUES ('&1', '&2', 1) ON DUPLICATE KEY UPDATE `calculated`=1", $rCache['cache_id'], $rLayers['id']); mysql_query($sql); } } mysql_free_result($rsLayers); // End of Parki PL $sql = sql("UPDATE `caches` SET `need_npa_recalc`=0 WHERE `cache_id`='&1'", $rCache['cache_id']); mysql_query($sql); } mysql_free_result($rsCache); db_disconnect(); }
function resetDBData() { $resetData = array( 'users' => array( array( 'uid' => 1, 'username' => 'jonathan', 'password' => 'password', 'profile' => 'The best web developer EVAR!', ), ), 'posts' => array( array( 'pid' => 1, 'uid' => 1, 'content' => 'I think I rock alot', ) ) ); foreach ($resetData as $table => $data) { foreach ($data as $row) { $columns = implode(',', array_keys($row)); $values = implode(',', array_map('hackSQLEncode', array_values($row))); sql("INSERT INTO {$table} ({$columns}) VALUES ({$values});"); } } }
public function run() { // cleanup XML session data sql_temp_table('tmpsessiondata'); sql('CREATE TEMPORARY TABLE &tmpsessiondata ENGINE=MEMORY SELECT DISTINCT `xmlsession_data`.`session_id` FROM `xmlsession_data` LEFT JOIN `xmlsession` ON `xmlsession`.`id`=`xmlsession_data`.`session_id` WHERE `xmlsession`.`id` IS NULL'); $count = sql_value('SELECT COUNT(*) FROM `xmlsession_data` WHERE `session_id` IN (SELECT `session_id` FROM &tmpsessiondata)', 0); if ($count) { sql("DELETE FROM `xmlsession_data`\n WHERE `session_id` IN (SELECT `session_id` FROM &tmpsessiondata)"); echo 'orphan_cleanup: dropped ' . $count . " record(s) from xmlsession_data\n"; } sql_drop_temp_table('tmpsessiondata'); // cleanup map data sql_temp_table('tmpsessiondata'); sql('CREATE TEMPORARY TABLE &tmpsessiondata ENGINE=MEMORY SELECT DISTINCT `map2_data`.`result_id` FROM `map2_data` LEFT JOIN `map2_result` ON `map2_result`.`result_id`=`map2_data`.`result_id` WHERE `map2_result`.`result_id` IS NULL'); $count = sql_value("SELECT COUNT(*) FROM `map2_data`\n WHERE `result_id` IN (SELECT `result_id` FROM &tmpsessiondata)", 0); if ($count) { sql("DELETE FROM `map2_data`\n WHERE `result_id` IN (SELECT `result_id` FROM &tmpsessiondata)"); echo 'orphan_cleanup: dropped ' . $count . " record(s) from map2_data\n"; } sql_drop_temp_table('tmpsessiondata'); }
public static function getAttrbutesListArrayInternal($cacheId, $bOnlySelectable, $firstLetterUppercase) { global $opt; $attributes = array(); $rsAttrGroup = sql("SELECT `attribute_groups`.`id`,\n\t\t IFNULL(`tt1`.`text`, `attribute_groups`.`name`) AS `name`,\n\t\t IFNULL(`tt2`.`text`, `attribute_categories`.`name`) AS `category`,\n\t\t `attribute_categories`.`color`\n\t\t\tFROM `attribute_groups`\n\t\t\tINNER JOIN `attribute_categories` \n\t\t\t ON `attribute_groups`.`category_id`=`attribute_categories`.`id`\n\t\t\tLEFT JOIN `sys_trans` AS `t1` \n\t\t\t ON `attribute_groups`.`trans_id`=`t1`.`id` \n\t\t\t AND `attribute_groups`.`name`=`t1`.`text`\n\t\t\tLEFT JOIN `sys_trans_text` AS `tt1` \n\t\t\t ON `t1`.`id`=`tt1`.`trans_id` \n\t\t\t AND `tt1`.`lang`='&1'\n\t\t\tLEFT JOIN `sys_trans` AS `t2` \n\t\t\t ON `attribute_categories`.`trans_id`=`t2`.`id` \n\t\t\t AND `attribute_categories`.`name`=`t2`.`text`\n\t\t\tLEFT JOIN `sys_trans_text` AS `tt2` \n\t\t\t ON `t2`.`id`=`tt2`.`trans_id` \n\t\t\t AND `tt2`.`lang`='&1'\n\t\t\tORDER BY `attribute_groups`.`id` ASC", $opt['template']['locale']); while ($rAttrGroup = sql_fetch_assoc($rsAttrGroup)) { $attr = array(); $bFirst = true; $bSearchGroupDefault = false; if ($cacheId == 0) { $sAddWhereSql = ''; if ($bOnlySelectable == true) { $sAddWhereSql .= ' AND `cache_attrib`.`selectable`=1'; } $rsAttr = sql("SELECT `cache_attrib`.`id`, \n IFNULL(`tt1`.`text`, `cache_attrib`.`name`) AS `name`,\n\t\t\t\t\t\t\tIFNULL(`tt2`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`,\n\t\t\t\t\t\t\t`cache_attrib`.`icon`, `cache_attrib`.`search_default`\n\t\t\t\t\tFROM `cache_attrib`\n\t\t\t\t\tLEFT JOIN `sys_trans` AS `t1` \n\t\t\t\t\t ON `cache_attrib`.`trans_id`=`t1`.`id` \n\t\t\t\t\t AND `cache_attrib`.`name`=`t1`.`text`\n\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt1` \n\t\t\t\t\t ON `t1`.`id`=`tt1`.`trans_id` \n\t\t\t\t\t AND `tt1`.`lang`='&1'\n\t\t\t\t\tLEFT JOIN `sys_trans` AS `t2` \n\t\t\t\t\t ON `cache_attrib`.`html_desc_trans_id`=`t2`.`id`\n\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt2` \n\t\t\t\t\t ON `t2`.`id`=`tt2`.`trans_id` \n\t\t\t\t\t AND `tt2`.`lang`='&1'\n\t\t\t\t\tWHERE `cache_attrib`.`group_id`='&2'" . $sAddWhereSql . "\n\t\t\t\t\tAND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1\n\t\t\t\t\tORDER BY `cache_attrib`.`group_id` ASC", $opt['template']['locale'], $rAttrGroup['id']); } else { $rsAttr = sql("SELECT `cache_attrib`.`id`, \n IFNULL(`tt1`.`text`, `cache_attrib`.`name`) AS `name`,\n\t\t\t\t\t\t\tIFNULL(`tt2`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`,\n\t\t\t\t\t\t\t`cache_attrib`.`icon`, `cache_attrib`.`search_default`\n\t\t\t\t\tFROM `caches_attributes`\n\t\t\t\t\tINNER JOIN `cache_attrib` \n\t\t\t\t\t ON `caches_attributes`.`attrib_id`=`cache_attrib`.`id`\n\t\t\t\t\tLEFT JOIN `sys_trans` AS `t1` \n\t\t\t\t\t ON `cache_attrib`.`trans_id`=`t1`.`id` \n\t\t\t\t\t AND `cache_attrib`.`name`=`t1`.`text`\n\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt1` \n\t\t\t\t\t ON `t1`.`id`=`tt1`.`trans_id` \n\t\t\t\t\t AND `tt1`.`lang`='&2'\n\t\t\t\t\tLEFT JOIN `sys_trans` AS `t2` \n\t\t\t\t\t ON `cache_attrib`.`html_desc_trans_id`=`t2`.`id`\n\t\t\t\t\tLEFT JOIN `sys_trans_text` AS `tt2` \n\t\t\t\t\t ON `t2`.`id`=`tt2`.`trans_id`\n\t\t\t\t\t AND `tt2`.`lang`='&2'\n\t\t\t\t\tWHERE `caches_attributes`.`cache_id`='&1' \n\t\t\t\t\tAND `cache_attrib`.`group_id`='&3'\n\t\t\t\t\tAND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1\n\t\t\t\t\tORDER BY `cache_attrib`.`group_id` ASC", $cacheId, $opt['template']['locale'], $rAttrGroup['id']); } while ($rAttr = sql_fetch_assoc($rsAttr)) { if ($firstLetterUppercase) { $rAttr['name'] = mb_strtoupper(mb_substr($rAttr['name'], 0, 1)) . mb_substr($rAttr['name'], 1); } $attr[] = $rAttr; if ($rAttr['search_default']) { $bSearchGroupDefault = true; } } sql_free_result($rsAttr); if (count($attr) > 0) { $attributes[] = array('id' => $rAttrGroup['id'], 'name' => $rAttrGroup['name'], 'color' => $rAttrGroup['color'], 'category' => $rAttrGroup['category'], 'search_default' => $bSearchGroupDefault, 'attr' => $attr); } } sql_free_result($rsAttrGroup); return $attributes; }
function searchUser() { global $tpl; $username = isset($_REQUEST['username']) ? $_REQUEST['username'] : ''; $msg = isset($_REQUEST['msg']) ? $_REQUEST['msg'] : ''; $tpl->assign('username', $username); $tpl->assign('msg', $msg); $rs = sql("SELECT `user_id`, `username`, `email`, `date_created`, `last_modified`, `is_active_flag`, `activation_code`, `first_name`, `last_name` FROM `user` WHERE `username`='&1' OR `email`='&1'", $username); $r = sql_fetch_assoc($rs); sql_free_result($rs); if ($r == false) { $tpl->assign('error', 'userunknown'); $tpl->display(); } $tpl->assign('showdetails', true); $r['hidden'] = sql_value("SELECT COUNT(*) FROM `caches` WHERE `user_id`='&1'", 0, $r['user_id']); $r['hidden_active'] = sql_value("SELECT COUNT(*) FROM `caches` WHERE `user_id`='&1' AND `status`=1", 0, $r['user_id']); $r['logentries'] = sql_value("SELECT COUNT(*) FROM `cache_logs` WHERE `user_id`='&1'", 0, $r['user_id']); $r['last_known_login'] = sql_value("SELECT MAX(`last_login`) FROM `sys_sessions` WHERE `user_id`='&1'", 0, $r['user_id']); $tpl->assign('user', $r); $user = new user($r['user_id']); if (!$user->exist()) { $tpl->error(ERROR_UNKNOWN); } $tpl->assign('candisable', $user->canDisable()); $tpl->assign('candelete', $user->canDelete()); $tpl->display(); }
function pane_art($id) { $im = best_img(sql('img', 'qda', 'v', 'id=' . $id)); $suj = suj_of_id($id); //spe return divs('background:url(/img/' . $im . ') center; background-size:cover; height:180px;', divs('position:relative; background:rgba(0,0,0,0.4); color:rgba(255,255,255,0.8); font-shadow:1px 1px 2px rgba(0,0,0,0.8); font-size:22px; top:50%;', $suj)); }
function cleanup_mapresult2($slaveId) { global $opt; // cleanup old entries $rs = sql("SELECT SQL_BUFFER_RESULT `result_id` FROM `map2_result` WHERE DATE_ADD(`date_created`, INTERVAL '&1' SECOND)<NOW()", $opt['map']['maxcacheage']); while ($r = sql_fetch_assoc($rs)) { sql("DELETE FROM `map2_result` WHERE `result_id`='&1'", $r['result_id']); } sql_free_result($rs); // now reduce table size? (29 bytes is the average row size) if (sql_value_slave("SELECT COUNT(*) FROM `map2_data`", 0) > $opt['map']['maxcachesize'] / 29) { while (sql_value_slave("SELECT COUNT(*) FROM `map2_data`", 0) > $opt['map']['maxcachereducedsize'] / 29) { $resultId = sql_value("SELECT `result_id` FROM `map2_result` WHERE `slave_id`='&1' ORDER BY `date_lastqueried` DESC LIMIT 1", 0, $slaveId); if ($resultId == 0) { return; } sql("DELETE FROM `map2_result` WHERE `result_id`='&1'", $resultId); } } $nMinId = sql_value("SELECT MIN(`result_id`) FROM `map2_result`", 0); if ($nMinId == 0) { sql("DELETE FROM `map2_data`"); } else { sql("DELETE FROM `map2_data` WHERE `result_id`<'&1'", $nMinId); } }
public static function getFromCache($cacheid) { $rs = sql("SELECT latitude, longitude FROM caches WHERE cache_id = &1", $cacheid); $r = sql_fetch_array($rs); mysql_free_result($rs); return new Coordinate_Coordinate($r['latitude'], $r['longitude']); }
function render_clan_view($clan, $clan_name = null, $clan_long_searched = null, $sql) { if (!$clan_name && !$clan_long_searched) { return ''; // No viewing criteria available. } $search = "clan = '" . sql($clan_name) . "'"; if ($clan_long_searched) { $search = "clan_long_name = '" . sql($clan_long_searched) . "'"; } $members = $sql->FetchAll("SELECT uname, clan, clan_long_name, level, days \n FROM players \n WHERE {$search} AND confirmed = 1 order by health, level desc"); $max_list = $sql->FetchAll("SELECT max(level) as max \n FROM players WHERE {$search} AND confirmed = 1"); $max_array = reset($max_list); $max = $max_array['max']; //$members = @natsort2d($members, 'days'); $res = "<div id='clan-members'>\n <h3 id='clan-members-title'>" . ($clan_long_searched ? "Clan {$clan_long_searched}" : $clan . "'s Clan") . "</h3>\n <div id='clan-members-count'>Clans Members: " . count($members) . "</div>\n <ul id='clan-members-list'>"; foreach ($members as $member) { $member['size'] = floor(($member['level'] - $member['days'] < 1 ? 0 : $member['level'] - $member['days']) / $max * 2) + 1; if ($member['uname'] == $member['clan']) { $member['size'] = $member['size'] + 2; $member['size'] = $member['size'] > 2 ? 2 : $member['size']; } $res .= "<li class='member size{$member['size']}'>\n <a href='player.php?player={$member['uname']}'>{$member['uname']}</a>\n </li>"; } $res .= "</ul>\n </div>"; return $res; }
function select($aql = null, $clause = null) { if ($aql) { $this->aql = $aql; } if ($clause) { $this->clause = $clause; } //pagination settings $default_limit = if_not($this->clause['default_limit'], 25); if (!$_GET['limit' . $this->i]) { $_GET['limit' . $this->i] = $default_limit; } $this->offset = $_GET['page' . $this->i] * $_GET['limit' . $this->i] - $_GET['limit' . $this->i]; $this->clause['limit'] = $_GET['limit' . $this->i]; $this->clause['offset'] = $this->offset; $this->rs = aql::select($this->aql, $this->clause); $this->first_row = $this->offset + 1; $this->last_row = count($this->rs) + $this->first_row - 1; $c = aql::sql($this->aql, $this->clause); $c = sql($c['sql_count']); $this->total_rows = $c->Fields('count'); $this->num_pages = ceil($this->total_rows / $_GET['limit' . $this->i]); return $this->rs; }
function CheckThrottle() { global $opt, $tpl; $ip_string = $_SERVER['REMOTE_ADDR']; $ip_blocks = mb_split('\\.', $ip_string); $ip_numeric = $ip_blocks[3] + $ip_blocks[2] * 256 + $ip_blocks[1] * 65536 + $ip_blocks[0] * 16777216; sql('CREATE TABLE IF NOT EXISTS &tmpdb.`sys_accesslog` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, `ip` INT UNSIGNED NOT NULL, `access_time` TIMESTAMP NOT NULL, INDEX (`access_time`), INDEX (`ip`)) ENGINE = MEMORY'); $rsStaus = sql("SHOW STATUS LIKE 'Threads_connected'"); $rStatus = sql_fetch_array($rsStaus); sql_free_result($rsStaus); if ($rStatus) { if ($rStatus[1] > $opt['db']['throttle_connection_count']) { $access_count = sql_value("SELECT COUNT(*) FROM &tmpdb.`sys_accesslog` WHERE ip ='&1'", 0, $ip_numeric); if ($access_count > $opt['db']['throttle_access_count']) { $tpl->error(ERROR_THROOTLE); } } } // remove old entries every 100st call if (mt_rand(0, 100) == 50) { sql("DELETE FROM &tmpdb.`sys_accesslog` WHERE `access_time`<CURRENT_TIMESTAMP()-'&2'", $ip_numeric, $opt['db']['throttle_access_time']); } sql("INSERT INTO &tmpdb.`sys_accesslog` (`ip`, `access_time`) VALUES ('&1', CURRENT_TIMESTAMP())", $ip_numeric); }
function isGeokretInCache($cacheid) { $sql = "SELECT wp_oc, wp_gc, wp_nc,wp_ge,wp_tc FROM caches WHERE cache_id = '" . sql_escape(intval($cacheid)) . "'"; $cache_record = mysql_fetch_array(mysql_query($sql)); // get cache waypoint $cache_wp = ''; if ($cache_record['wp_oc'] != '') { $cache_wp = $cache_record['wp_oc']; } else { if ($cache_record['wp_gc'] != '') { $cache_wp = $cache_record['wp_gc']; } else { if ($cache_record['wp_nc'] != '') { $cache_wp = $cache_record['wp_nc']; } else { if ($cache_record['wp_ge'] != '') { $cache_wp = $cache_record['wp_ge']; } else { if ($cache_record['wp_tc'] != '') { $cache_wp = $cache_record['wp_tc']; } } } } } $geokret_sql = "SELECT id FROM gk_item WHERE id IN (SELECT id FROM gk_item_waypoint WHERE wp = '" . sql_escape($cache_wp) . "') AND stateid<>1 AND stateid<>4 AND stateid <>5 AND typeid<>2"; $geokret_query = sql($geokret_sql); if (mysql_num_rows($geokret_query) == 0) { // no geokrets in this cache return 0; } else { return 1; } }
static function get_all_products() { $products = sql("SELECT * FROM products ORDER BY id"); foreach ($products as $product) { $ret[] = new Product($product); } return $ret; }
function ud_segment($id, $pos) { $d = sql('msg', 'qdm', 'v', 'id=' . $id); $t = sql('suj', 'qda', 'v', 'id=' . $id); $ret = lj('txtcadr', 'popup_popart__3_' . $id . '_3', $t) . br(); $ret .= substr($d, $pos - 50, 100); return $ret; }
static function cus_attrs($pid, $attrs) { $result = sql("SELECT * FROM `products` WHERE attr_list LIKE '{$attrs}' and id={$pid}"); if (!count($result) == 1) { return false; } return true; }
function run() { global $opt; $rsCache = sql("SELECT `caches`.`cache_id`, `caches`.`latitude`, `caches`.`longitude` FROM `caches` LEFT JOIN `cache_location` ON `caches`.`cache_id`=`cache_location`.`cache_id` WHERE ISNULL(`cache_location`.`cache_id`) UNION SELECT `caches`.`cache_id`, `caches`.`latitude`, `caches`.`longitude` FROM `caches` INNER JOIN `cache_location` ON `caches`.`cache_id`=`cache_location`.`cache_id` WHERE `caches`.`last_modified`>`cache_location`.`last_modified`"); while ($rCache = sql_fetch_assoc($rsCache)) { $sCode = ''; $rsLayers = sql("SELECT `level`, `code`, AsText(`shape`) AS `geometry` FROM `nuts_layer` WHERE WITHIN(GeomFromText('&1'), `shape`) ORDER BY `level` DESC", 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')'); while ($rLayers = sql_fetch_assoc($rsLayers)) { if (gis::ptInLineRing($rLayers['geometry'], 'POINT(' . $rCache['longitude'] . ' ' . $rCache['latitude'] . ')')) { $sCode = $rLayers['code']; break; } } sql_free_result($rsLayers); if ($sCode != '') { $adm1 = null; $code1 = null; $adm2 = null; $code2 = null; $adm3 = null; $code3 = null; $adm4 = null; $code4 = null; if (mb_strlen($sCode) > 5) { $sCode = mb_substr($sCode, 0, 5); } if (mb_strlen($sCode) == 5) { $code4 = $sCode; $adm4 = sql_value("SELECT `name` FROM `nuts_codes` WHERE `code`='&1'", null, $sCode); $sCode = mb_substr($sCode, 0, 4); } if (mb_strlen($sCode) == 4) { $code3 = $sCode; $adm3 = sql_value("SELECT `name` FROM `nuts_codes` WHERE `code`='&1'", null, $sCode); $sCode = mb_substr($sCode, 0, 3); } if (mb_strlen($sCode) == 3) { $code2 = $sCode; $adm2 = sql_value("SELECT `name` FROM `nuts_codes` WHERE `code`='&1'", null, $sCode); $sCode = mb_substr($sCode, 0, 2); } if (mb_strlen($sCode) == 2) { $code1 = $sCode; // try to get localised name first $adm1 = sql_value("SELECT IFNULL(`sys_trans_text`.`text`, `countries`.`name`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM `countries`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans` ON `countries`.`trans_id`=`sys_trans`.`id` AND `countries`.`name`=`sys_trans`.`text`\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN `sys_trans_text` ON `sys_trans`.`id`=`sys_trans_text`.`trans_id` AND `sys_trans_text`.`lang`='&2'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE `countries`.`short`='&1'", null, $sCode, $opt['template']['default']['locale']); if ($adm1 == null) { $adm1 = sql_value("SELECT `name` FROM `nuts_codes` WHERE `code`='&1'", null, $sCode); } } sql("INSERT INTO `cache_location` (`cache_id`, `adm1`, `adm2`, `adm3`, `adm4`, `code1`, `code2`, `code3`, `code4`) VALUES ('&1', '&2', '&3', '&4', '&5', '&6', '&7', '&8', '&9') ON DUPLICATE KEY UPDATE `adm1`='&2', `adm2`='&3', `adm3`='&4', `adm4`='&5', `code1`='&6', `code2`='&7', `code3`='&8', `code4`='&9'", $rCache['cache_id'], $adm1, $adm2, $adm3, $adm4, $code1, $code2, $code3, $code4); } else { $sCountry = sql_value("SELECT IFNULL(`sys_trans_text`.`text`, `countries`.`name`)\r\n\t\t\t\t FROM `caches` \r\n\t\t\t\t INNER JOIN `countries` ON `caches`.`country`=`countries`.`short`\r\n\t\t\t\t LEFT JOIN `sys_trans` ON `countries`.`trans_id`=`sys_trans`.`id` AND `countries`.`name`=`sys_trans`.`text`\r\n\t\t\t\t LEFT JOIN `sys_trans_text` ON `sys_trans`.`id`=`sys_trans_text`.`trans_id` AND `sys_trans_text`.`lang`='&2'\r\n\t\t\t\t WHERE `caches`.`cache_id`='&1'", null, $rCache['cache_id'], $opt['template']['default']['locale']); $sCode1 = sql_value("SELECT `caches`.`country` FROM `caches` WHERE `caches`.`cache_id`='&1'", null, $rCache['cache_id']); sql("INSERT INTO `cache_location` (`cache_id`, `adm1`, `code1`) VALUES ('&1', '&2', '&3') ON DUPLICATE KEY UPDATE `adm1`='&2', `adm2`=NULL, `adm3`=NULL, `adm4`=NULL, `code1`='&3', `code2`=NULL, `code3`=NULL, `code4`=NULL", $rCache['cache_id'], $sCountry, $sCode1); } } sql_free_result($rsCache); }
function featurecodes_delFeatureCode($modulename, $featurename) { $s = "DELETE "; $s .= "FROM featurecodes "; $s .= "WHERE modulename = " . sql_formattext($modulename) . " "; $s .= "AND featurename = " . sql_formattext($featurename); sql($s, 'query'); return true; }
public function getOption($table, $value, $text, $now) { $res = sql(1, $table, ""); foreach ($res as $row) { $active = $now == $row[$value] ? 'selected' : ''; $x .= '<option value="' . $row[$value] . '" ' . $active . '>' . $row[$text] . '</option>'; } return $x; }
function __construct($name, $opts = 0) { if (($opts & self::NOSQL) == 0) { $this->sql = sql($name); } if (($opts & self::NOSQL) == 0 && ($opts & self::NOORM) == 0) { $this->model = new modelhelper($name); } }
function isFriend($id) { if ($id == $_SESSION['userid']) { return true; } $in = "{$_SESSION['userid']},{$id}"; $f = sql("SELECT * FROM `friend` WHERE `from_whom` IN ({$in}) OR `from_whom` IN ({$in})"); return !empty($f); }