Esempio n. 1
0
function get_by_id($id, $conn)
{
    $query = query("\n\t\tSELECT * FROM posts WHERE id = :id LIMIT 1", array("id" => $id), $conn);
    if ($query) {
        return $query->fetchAll();
    }
}
Esempio n. 2
0
function get_products($page, $per_page, $short = false)
{
    $start = abs($page * $per_page);
    $fields = $short ? 'product.id' : '*';
    if (isset($_GET['sort'])) {
        $sort_query = $_GET['sort'];
    } elseif (!empty($_POST['sort'])) {
        $sort_query = $_POST['sort'];
    } else {
        $sort_query = 'id_asc';
    }
    $cache_key = build_cache_key($page, $sort_query);
    $result = get_cache($cache_key);
    if (!$result) {
        $sort_data = get_sort($sort_query);
        $sort = $sort_data['sort'];
        $sort_field = $sort_data['sort_field'];
        if ($sort_field == 'id') {
            $q = 'select ' . $fields . ' from product JOIN (SELECT ' . $sort_field . ' FROM product ' . $sort . ' LIMIT ' . $start . ',' . $per_page . ') as b ON b.id = product.id';
        } elseif ($sort_field == 'price') {
            $q = 'select ' . $fields . ' from product JOIN (SELECT id, price FROM product ' . $sort . ' LIMIT ' . $start . ',' . $per_page . ') as b ON b.id = product.id';
        }
        $res = query($q);
    } else {
        $q = 'select ' . $fields . ' from product where id in(' . $result . ');';
        $res = query($q);
    }
    return $res;
}
Esempio n. 3
0
function netbios_setup($name)
{
    $infp = XNODE_getpathbytarget("", "inf", "uid", $name, 0);
    $stsp = XNODE_getpathbytarget("/runtime", "inf", "uid", $name, 0);
    if ($infp == "" || $stsp == "") {
        SHELL_info($_GLOBALS["START"], "infsvcs_setup: (" . $name . ") not exist.");
        SHELL_info($_GLOBALS["STOP"], "infsvcs_setup: (" . $name . ") not exist.");
        return;
    }
    $addrtype = query($stsp . "/inet/addrtype");
    $ipaddr = query($stsp . "/inet/ipv4/ipaddr");
    $devnam = query($stsp . "/devnam");
    $hostname = query("device/hostname");
    startcmd("hostname " . $hostname . "\n");
    if ($ipaddr == "" || $devnam == "") {
        return;
    }
    if ($addrtype == "ipv4" || $addrtype == "ipv6") {
        //jef add +   for support use shareport.local to access shareportmobile
        $web_file_access = query("/webaccess/enable");
        if ($web_file_access == 1) {
            startcmd("netbios -i " . $devnam . " -r " . $hostname . " -r shareport.local -r shareport &\n");
            startcmd("llmnresp -i " . $devnam . " -r " . $hostname . "  -r shareport.local -r shareport &\n");
        } else {
            //jef add -
            startcmd("netbios -i " . $devnam . " -r " . $hostname . " &\n");
            startcmd("llmnresp -i " . $devnam . " -r " . $hostname . " &\n");
        }
        stopcmd("killall netbios");
        stopcmd("killall llmnresp");
    }
}
Esempio n. 4
0
function GetId($username)
{
    $query = "SELECT id FROM USERS WHERE username = '******'";
    $result = query($query);
    $row = mysqli_fetch_array($result);
    return $row[0];
}
Esempio n. 5
0
 public function exclui($obj)
 {
     foreach ($this->get_related_objects() as $obj) {
         $obj->exclui();
     }
     return query('DELETE FROM ' . $this->get_table_name() . ' WHERE id = ' . $this->id);
 }
Esempio n. 6
0
function check_dmz_setting($path, $addrtype, $lan_ip, $mask)
{
    if (query($path . "/enable") == "1") {
        anchor($path);
        $hostid = query("hostid");
        if ($hostid == "") {
            set_result("FAILED", $path . "/hostid", i18n("DMZ IP Address cannot be empty."));
            return "FAILED";
        }
        if ($hostid <= 0) {
            set_result("FAILED", $path . "/hostid", i18n("DMZ IP Address is not a valid IP Address."));
            return "FAILED";
        }
        if ($addrtype == "ipv4") {
            $dmzip = ipv4ip($lan_ip, $mask, $hostid);
            if (INET_validv4host($dmzip, $mask) == 0) {
                set_result("FAILED", $path . "/hostid", i18n("DMZ IP Address is not a valid IP Address."));
                return "FAILED";
            }
        }
    } else {
        set($path . "/enable", "0");
    }
    return "OK";
}
Esempio n. 7
0
function dhcps_setcfg($prefix, $svc)
{
    /* set dhcpX of inf */
    $inf = cut($svc, 1, ".");
    $svc = tolower(cut($svc, 0, "."));
    $base = XNODE_getpathbytarget("", "inf", "uid", $inf, 0);
    $dhcps_uid = query($prefix . "/inf/" . $svc);
    set($base . "/" . $svc, $dhcps_uid);
    /* copy the dhcp profile. */
    $uid = INF_getinfinfo($inf, $svc);
    $spath = XNODE_getpathbytarget($prefix . "/" . $svc, "entry", "uid", $dhcps_uid, 0);
    $dhcps = XNODE_getpathbytarget("/" . $svc, "entry", "uid", $uid, 0);
    if ($dhcps != "") {
        if ($svc == "dhcps4") {
            copy_dhcps4($spath, $dhcps);
        } else {
            if ($svc == "dhcps6") {
                $_GLOBALS["SETCFG_DHCPS6_SRC_PATH"] = $spath;
                $_GLOBALS["SETCFG_DHCPS6_DST_PATH"] = $dhcps;
                $b = "/htdocs/phplib/setcfg/libs";
                dophp("load", $b . "/dhcps6.php");
            }
        }
    } else {
        TRACE_error("SETCFG/DHCPS: no dhcps entry for [" . $uid . "] found!");
    }
}
Esempio n. 8
0
function ShowEquipTable($query)
{
    $numRows = mysqli_num_rows(query($query));
    echo "<br><p class='center-align'>" . ($numRows > 0 ? $numRows : "Nenhum") . " " . ($numRows > 1 ? "items." : "item.") . "</p>";
    PrintEquipTable(query($query));
    echo "<div class=\"divider\"></div>";
}
Esempio n. 9
0
function check_qos_setting($path)
{
    $enable = query($path . "/device/qos/enable");
    $auto = query($path . "/device/qos/autobandwidth");
    if ($enable == "1") {
        if ($auto == "0") {
            if (isdigit(query($path . "/inf/bandwidth/upstream")) == "0" || query($path . "/inf/bandwidth/upstream") > 102400 || query($path . "/inf/bandwidth/upstream") < 1) {
                set_result("FAILED", $path . "/inf/bandwidth/upstream", i18n("The input uplink speed is invalid."));
                return "FAILED";
            } else {
                // Remove the leading zeros.
                $upstream_dec = strtoul(query($path . "/inf/bandwidth/upstream"), 10);
                set($path . "/inf/bandwidth/upstream", $upstream_dec);
            }
        } else {
            set($path . "/device/qos/autobandwidth", "1");
        }
        $type = query($path . "/inf/bandwidth/type");
        if ($type == "AUTO" || $type == "ADSL" || $type == "CABLE") {
        } else {
            set_result("FAILED", $path . "/inf/bandwidth/type", i18n("Unsupported Connection type be assigned."));
            return "FAILED";
        }
    } else {
        set($path . "/device/qos/enable", "0");
    }
    return "OK";
}
Esempio n. 10
0
 public function build($settings, $board_name)
 {
     global $config, $board;
     openBoard($board_name);
     $recent_images = array();
     $recent_posts = array();
     $stats = array();
     $query = query(sprintf("SELECT *, `id` AS `thread_id`,\n\t\t\t\t(SELECT COUNT(`id`) FROM ``posts_%s`` WHERE `thread` = `thread_id`) AS `reply_count`,\n\t\t\t\t(SELECT SUM(`num_files`) FROM ``posts_%s`` WHERE `thread` = `thread_id` AND `num_files` IS NOT NULL) AS `image_count`,\n\t\t\t\t'%s' AS `board` FROM ``posts_%s`` WHERE `thread`  IS NULL ORDER BY `bump` DESC", $board_name, $board_name, $board_name, $board_name, $board_name)) or error(db_error());
     while ($post = $query->fetch(PDO::FETCH_ASSOC)) {
         $post['link'] = $config['root'] . $board['dir'] . $config['dir']['res'] . sprintf($config['file_page'], $post['thread'] ? $post['thread'] : $post['id']);
         $post['board_name'] = $board['name'];
         if ($post['embed'] && preg_match('/^https?:\\/\\/(\\w+\\.)?(?:youtube\\.com\\/watch\\?v=|youtu\\.be\\/)([a-zA-Z0-9\\-_]{10,11})(&.+)?$/i', $post['embed'], $matches)) {
             $post['youtube'] = $matches[2];
         }
         if (isset($post['files'])) {
             $files = json_decode($post['files']);
             if ($files[0]->file == 'deleted') {
                 continue;
             }
             $post['file'] = $config['uri_thumb'] . $files[0]->thumb;
         }
         $recent_posts[] = $post;
     }
     $required_scripts = array('js/jquery.min.js', 'js/jquery.mixitup.min.js', 'js/catalog.js');
     foreach ($required_scripts as $i => $s) {
         if (!in_array($s, $config['additional_javascript'])) {
             $config['additional_javascript'][] = $s;
         }
     }
     file_write($config['dir']['home'] . $board_name . '/catalog.html', Element('themes/catalog/catalog.html', array('settings' => $settings, 'config' => $config, 'boardlist' => createBoardlist(), 'recent_images' => $recent_images, 'recent_posts' => $recent_posts, 'stats' => $stats, 'board' => $board_name, 'link' => $config['root'] . $board['dir'])));
 }
Esempio n. 11
0
function vote($id)
{
    $link = connect();
    $query = "UPDATE quotes SET score = score +1 WHERE id={$id}";
    query($query);
    close($link);
}
Esempio n. 12
0
function putMailSettings($data)
{
    // кнопка «Сохранить»
    if ($data) {
        foreach ($data as $data_key => $data_value) {
            $sql = "UPDATE ntn_settings SET value = '{$data_value}' WHERE param = '{$data_key}'";
            // file_put_contents('sql',$sql."\n",FILE_APPEND);
            query($sql);
            $sql = <<<EOD
                INSERT INTO ntn_settings (param, value)
                    SELECT '{$data_key}', '{$data_value}'
                    FROM DUAL
                    WHERE NOT EXISTS (
                        SELECT 1
                        FROM ntn_settings
                        WHERE param = '{$data_key}' AND value = '{$data_value}'
                    )
EOD;
            // file_put_contents('sql',$sql."\n",FILE_APPEND);
            query($sql);
        }
    }
    return true;
    // почему-то эта функция всегда должна возвращать true, хотя ниже может быть и другой вариант развития событий
}
Esempio n. 13
0
function sConfig($key, $value)
{
    $key = db_escape($key);
    $value = db_escape($value);
    $sql = "REPLACE INTO " . PREF . "config\n\t\tVALUE ('{$key}', '{$value}')";
    query($sql);
}
Esempio n. 14
0
function getPersonalInfoById($id)
{
    $sql = "SELECT * FROM personal WHERE id='{$id}'";
    $res = query($sql);
    $result = mysql_fetch_object($res);
    return $result;
}
Esempio n. 15
0
/**
 * get a specific route informations (name, color and stations along the route)
 * from cache (MySQL database) based on route number.
 */
function query_route($route_number)
{
    // get a specific route informations (name, color and stations along the route)
    // from cache (MySQL database) based on route number. Store in array $query
    $query = query("SELECT * FROM routes WHERE number = ?", $route_number);
    // iterate each row, there is actually only 1 row in $query.
    // 4 row in $query[0]: number, name, color and config
    foreach ($query[0] as $key => $value) {
        if ($key === 'config') {
            // return an array of strings, each of which is a substring of string $value
            // formed by splitting it by ',', each element in the array is a station along
            // the route
            $config = explode(',', $value);
            foreach ($config as $station_abbr) {
                // query current station
                $query = query("SELECT * FROM stations WHERE abbr = ?", $station_abbr);
                // build associative array
                $station = [];
                foreach ($query[0] as $key => $value) {
                    $station[$key] = $value;
                }
                $route['config'][] = $station;
            }
        } else {
            // $route['numbr'] =.., $route['color'] =..,$route['name'] =..,
            $route[$key] = $value;
        }
    }
    // $route is an array with 3 basic elements and 1 element('config') that itself is a big array
    return $route;
}
Esempio n. 16
0
function login()
{
    global $error;
    if (isset($_GET['error'])) {
        error_handler($_GET['error']);
    }
    if (!isset($_POST['username']) or !isset($_POST['password'])) {
        return false;
    }
    $username = $_POST['username'];
    $password = $_POST['password'];
    if (empty($username) and empty($password)) {
        $error = 'You did not fill out all forms. Do so please.';
        return false;
    }
    if (!filter_var($username, FILTER_VALIDATE_EMAIL)) {
        $error = 'This is not an email, please fill in an email-address.';
        return false;
    }
    $user = query('SELECT id FROM users WHERE email = "' . $username . '" AND password = "******" ');
    if ($_POST["vercode"] != $_SESSION["vercode"] or $_SESSION["vercode"] == '') {
        echo '<strong>Wrong verification code.</strong>';
    } else {
        if (count($user) < 1) {
            $error = 'Wrong email, password or verification code.';
            return false;
        }
    }
    $_SESSION['id'] = $user[0]['id'];
    header('Location: ../views/resultpage.php');
    exit;
}
Esempio n. 17
0
 public static function news($settings)
 {
     global $config;
     $query = query("SELECT * FROM `news` ORDER BY `time` DESC") or error(db_error());
     $news = $query->fetchAll(PDO::FETCH_ASSOC);
     return Element('themes/categories/news.html', array('settings' => $settings, 'config' => $config, 'news' => $news));
 }
Esempio n. 18
0
 static function new_image($image)
 {
     global $_zp_exifvars;
     $entry_locale = getUserLocale();
     $languages = generateLanguageList();
     $languageTags = $element = array();
     $candidates = self::getTaggingItems();
     foreach ($candidates as $key) {
         if ($meta = $image->get($key)) {
             setupCurrentLocale('en_US');
             $en_us = $element[] = exifTranslate($meta);
             foreach ($languages as $language) {
                 setupCurrentLocale($language);
                 $xlated = exifTranslate($meta);
                 if ($xlated != $en_us) {
                     // the string has a translation in this language
                     $element[] = $xlated;
                     $languageTags[$language] = $xlated;
                 }
             }
         }
     }
     setupCurrentLocale($entry_locale);
     $element = array_unique(array_merge($image->getTags(), $element));
     $image->setTags($element);
     $image->save();
     foreach ($languageTags as $language => $tag) {
         $sql = 'UPDATE ' . prefix('tags') . ' SET `language`=' . db_quote($language) . ' WHERE `name`=' . db_quote($tag) . ' AND `language`=NULL OR `language` LIKE ""';
         query($sql, false);
     }
     return $image;
 }
Esempio n. 19
0
function ShowManutTable($query)
{
    $numRows = mysqli_num_rows(query($query));
    echo "<div class=\"divider\"></div>";
    echo "<br>" . ($numRows > 0 ? $numRows : "Nenhuma") . " " . ($numRows > 1 ? "manutenções." : "manutenção.");
    PrintTable(query($query));
}
Esempio n. 20
0
 function tearDown()
 {
     // Don't use naked queries outside of a model layer elsewhere.
     query("delete from password_reset_requests where nonce = '777777' or nonce = '77778877' or nonce = '7777777' or nonce = :nonce or _account_id = :id", [':nonce' => isset($this->nonce) ? $this->nonce : null, ':id' => $this->account_id]);
     TestAccountCreateAndDestroy::purge_test_accounts();
     query("delete from password_reset_requests where nonce = '777777' or nonce = '77778877' or nonce = '7777777' or nonce = :nonce or _account_id = :id", [':nonce' => isset($this->nonce) ? $this->nonce : null, ':id' => $this->account_id]);
 }
Esempio n. 21
0
function setup()
{
    $sql = "CREATE TABLE IF NOT EXISTS mopclass (" . setupIddBase() . " name VARCHAR(64) NOT NULL DEFAULT ''," . " ord INT NOT NULL DEFAULT 0, INDEX(ord)" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopclasscontrol (" . " cid INT NOT NULL, id INT NOT NULL," . " leg TINYINT NOT NULL, ord TINYINT NOT NULL," . " PRIMARY KEY(cid, id, leg, ord), " . " ctrl INT NOT NULL DEFAULT 0" . ") ENGINE = MyISAM";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopcompetition (" . setupIddBase() . " name VARCHAR(64) NOT NULL DEFAULT ''," . " date DATE NOT NULL DEFAULT '2013-11-04'," . " organizer VARCHAR(64) NOT NULL DEFAULT ''," . " homepage VARCHAR(128) NOT NULL DEFAULT ''" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopcompetitor (" . setupIddBase() . setupBaseCompetitor() . ", tstat TINYINT NOT NULL DEFAULT 0," . " it INT NOT NULL DEFAULT 0," . " timestamp INT NOT NULL DEFAULT 0" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopcontrol (" . setupIddBase() . " name VARCHAR(64) NOT NULL DEFAULT ''" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS moporganization (" . setupIddBase() . " name VARCHAR(64) NOT NULL DEFAULT ''" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopradio (" . " cid INT NOT NULL, id INT NOT NULL," . " ctrl INT NOT NULL," . " PRIMARY KEY(cid, id, ctrl), " . " rt INT NOT NULL DEFAULT 0," . " timestamp INT NOT NULL DEFAULT 0" . ") ENGINE = MyISAM";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopteam (" . setupIddBase() . setupBaseCompetitor() . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS mopteammember (" . " cid INT NOT NULL, id INT NOT NULL," . " leg TINYINT NOT NULL, ord TINYINT NOT NULL," . " PRIMARY KEY(cid, id, leg, ord), " . " rid INT NOT NULL DEFAULT 0" . ") ENGINE = MyISAM";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS resultblog (" . " rcid int(11) NOT NULL," . " timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP," . " text varchar(256) CHARACTER SET utf8 NOT NULL" . ") ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultclass` (\n      `rcid` int(11) NOT NULL,\n      `cid` int(11) NOT NULL default '0',\n      `id` int(11) NOT NULL,\n      `sid` int(11) NOT NULL,\n      `panel` tinyint(2) NOT NULL default '1',\n      KEY `rcid` (`rcid`),\n      KEY `cid` (`cid`),\n      KEY `id` (`id`),\n      KEY `sid` (`sid`)\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultconfig` (\n      `rcid` int(11) NOT NULL,\n      `name` varchar(64) character set utf8 NOT NULL,\n      `active` tinyint(1) NOT NULL default '0' COMMENT '1=active',\n      PRIMARY KEY  (`rcid`)\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultradio` (\n      `idsender` tinyint(3) unsigned NOT NULL,\n      `idreceiver` tinyint(3) unsigned NOT NULL,\n      `senderbattery` smallint(6) unsigned NOT NULL,\n      `rxlevel` int(10) NOT NULL,\n      `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultradioconfig` (\n      `srcid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'screen radio competition id',\n      `srcname` varchar(30) NOT NULL,\n      `srcmap` varchar(120) NOT NULL,\n      `srcx0` double NOT NULL DEFAULT '0',\n      `srcy0` double NOT NULL DEFAULT '0',\n      `srcx1` double NOT NULL DEFAULT '100',\n      `srcy1` double NOT NULL DEFAULT '100',\n      PRIMARY KEY (`srcid`)\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci AUTO_INCREMENT=1 ;";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultradioposition` (\n      `srcid` int(10) unsigned NOT NULL,\n      `radioid` int(10) unsigned NOT NULL,\n      `radiox` double NOT NULL,\n      `radioy` double NOT NULL\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
    $sql = "CREATE TABLE IF NOT EXISTS `resultscreen` (\n      `rcid` int(11) NOT NULL,\n      `sid` int(11) NOT NULL,\n      `cid` int(11) NOT NULL DEFAULT '0',\n      `style` varchar(128) DEFAULT 'co2016-04-01s.css',\n      `title` varchar(128) DEFAULT 'Title',\n      `titlesize` tinyint(4) DEFAULT '24',\n      `titlecolor` varchar(6) DEFAULT '000000',\n      `subtitle` varchar(128) DEFAULT NULL,\n      `subtitlesize` tinyint(4) DEFAULT '16',\n      `subtitlecolor` varchar(6) DEFAULT '000000',\n      `titleleftpict` varchar(128) DEFAULT NULL,\n      `titlerightpict` varchar(128) DEFAULT NULL,\n      `panelscount` tinyint(2) DEFAULT '2' COMMENT 'Number of panels (1 to 4)',\n      `panel1content` tinyint(4) DEFAULT '2' COMMENT '1=picture, 2=text, 3=html, 4=start, 5=result, 6=summary, 7=blog, 8=slides',\n      `panel1mode` tinyint(2) DEFAULT '1',\n      `panel1tm_count` int(10) unsigned NOT NULL DEFAULT '2',\n      `panel1alternate` tinyint(2) DEFAULT '0',\n      `panel1pict` varchar(128) DEFAULT NULL,\n      `panel1txt` varchar(512) DEFAULT NULL,\n      `panel1txtsize` tinyint(4) DEFAULT '12',\n      `panel1txtcolor` varchar(6) DEFAULT '000000',\n      `panel1html` varchar(128) DEFAULT NULL,\n      `panel1firstline` int(10) unsigned NOT NULL DEFAULT '1',\n      `panel1fixedlines` tinyint(4) NOT NULL DEFAULT '3',\n      `panel1scrolledlines` tinyint(4) NOT NULL DEFAULT '17',\n      `panel1scrolltime` tinyint(4) NOT NULL DEFAULT '3',\n      `panel1scrollbeforetime` tinyint(4) NOT NULL DEFAULT '50',\n      `panel1scrollaftertime` tinyint(4) NOT NULL DEFAULT '50',\n      `panel1updateduration` int(11) NOT NULL DEFAULT '10',\n      `panel1lastrefresh` int(11) NOT NULL DEFAULT '0',\n      `panel1lastredraw` int(11) NOT NULL DEFAULT '0',\n      `panel2content` tinyint(2) DEFAULT '5' COMMENT '1=picture, 2=text, 3=html, 4=start, 5=result, 6=summary, 7=blog, 8=slides',\n      `panel2mode` tinyint(2) DEFAULT '1',\n      `panel2tm_count` int(10) unsigned NOT NULL DEFAULT '2',\n      `panel2alternate` tinyint(2) DEFAULT '0',\n      `panel2pict` varchar(128) DEFAULT NULL,\n      `panel2txt` varchar(512) DEFAULT NULL,\n      `panel2txtsize` tinyint(4) DEFAULT '12',\n      `panel2txtcolor` varchar(6) DEFAULT '000000',\n      `panel2html` varchar(128) DEFAULT NULL,\n      `panel2firstline` int(10) unsigned NOT NULL DEFAULT '1',\n      `panel2fixedlines` tinyint(4) NOT NULL DEFAULT '3',\n      `panel2scrolledlines` tinyint(4) NOT NULL DEFAULT '17',\n      `panel2scrolltime` tinyint(4) NOT NULL DEFAULT '3' COMMENT 'en 1/10s',\n      `panel2scrollbeforetime` tinyint(4) NOT NULL DEFAULT '50' COMMENT 'en 0.1s',\n      `panel2scrollaftertime` tinyint(4) NOT NULL DEFAULT '50' COMMENT 'en 0.1s',\n      `panel2updateduration` int(11) NOT NULL DEFAULT '10',\n      `panel2lastrefresh` int(11) NOT NULL DEFAULT '0',\n      `panel2lastredraw` int(11) NOT NULL DEFAULT '0',\n      `panel3content` tinyint(2) DEFAULT '5' COMMENT '1=picture, 2=text, 3=html, 4=start, 5=result, 6=summary, 7=blog, 8=slides',\n      `panel3mode` tinyint(2) DEFAULT '1',\n      `panel3tm_count` int(10) unsigned NOT NULL DEFAULT '2',\n      `panel3alternate` tinyint(2) DEFAULT '0',\n      `panel3pict` varchar(128) DEFAULT NULL,\n      `panel3txt` varchar(512) DEFAULT NULL,\n      `panel3txtsize` tinyint(4) DEFAULT '12',\n      `panel3txtcolor` varchar(6) DEFAULT '000000',\n      `panel3html` varchar(128) DEFAULT NULL,\n      `panel3firstline` int(10) unsigned NOT NULL DEFAULT '1',\n      `panel3fixedlines` tinyint(4) NOT NULL DEFAULT '3',\n      `panel3scrolledlines` tinyint(4) NOT NULL DEFAULT '17',\n      `panel3scrolltime` tinyint(4) NOT NULL DEFAULT '3' COMMENT 'en 1/10s',\n      `panel3scrollbeforetime` tinyint(4) NOT NULL DEFAULT '50' COMMENT 'en 0.1s',\n      `panel3scrollaftertime` tinyint(4) NOT NULL DEFAULT '50' COMMENT 'en 0.1s',\n      `panel3updateduration` int(11) NOT NULL DEFAULT '10',\n      `panel3lastrefresh` int(11) NOT NULL DEFAULT '0',\n      `panel3lastredraw` int(11) NOT NULL DEFAULT '0',\n      `panel4content` tinyint(4) DEFAULT '5' COMMENT '1=picture, 2=text, 3=html, 4=start, 5=result, 6=summary, 7=blog, 8=slides',\n      `panel4mode` tinyint(2) DEFAULT '1',\n      `panel4tm_count` int(10) unsigned NOT NULL DEFAULT '2',\n      `panel4alternate` tinyint(2) DEFAULT '0',\n      `panel4pict` varchar(128) DEFAULT NULL,\n      `panel4txt` varchar(512) DEFAULT NULL,\n      `panel4txtsize` tinyint(4) DEFAULT '12',\n      `panel4txtcolor` varchar(6) DEFAULT '000000',\n      `panel4html` varchar(128) DEFAULT NULL,\n      `panel4firstline` int(10) unsigned NOT NULL DEFAULT '1',\n      `panel4fixedlines` tinyint(4) NOT NULL DEFAULT '3',\n      `panel4scrolledlines` tinyint(4) NOT NULL DEFAULT '17',\n      `panel4scrolltime` tinyint(4) NOT NULL DEFAULT '10',\n      `panel4scrollbeforetime` tinyint(4) NOT NULL DEFAULT '50',\n      `panel4scrollaftertime` tinyint(4) NOT NULL DEFAULT '80',\n      `panel4updateduration` int(11) NOT NULL DEFAULT '3',\n      `panel4lastrefresh` int(11) NOT NULL DEFAULT '0',\n      `panel4lastredraw` int(11) NOT NULL DEFAULT '0',\n      `refresh` int(11) NOT NULL DEFAULT '0',\n      PRIMARY KEY  (`rcid`,`sid`),\n      KEY `cid` (`cid`)\n      ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
    query($sql);
}
Esempio n. 22
0
function get_by_id($id, $conn)
{
    $query = query('SELECT *FROM posts WHERE id= :id', array('id' => $id), $conn);
    if ($query) {
        return $query->fetchAll();
    }
}
Esempio n. 23
0
/**
* Função que valida um usuário e senha
*
* @param string $usuario - O usuário a ser validado
* @param string $senha - A senha a ser validada
*
* @return bool - Se o usuário foi validado ou não (true/false)
*/
function validaUsuario($login, $senha)
{
    global $_SG;
    $cS = $_SG['caseSensitive'] ? 'BINARY' : '';
    // Usa a função addslashes para escapar as aspas
    $nlogin = addslashes($login);
    $nsenha = addslashes($senha);
    // Monta uma consulta SQL (query) para procurar um usuário
    $sql = "SELECT `user_id`, `username`, `root` FROM `" . $_SG['tabela'] . "` WHERE " . $cS . " `login` = '" . $nlogin . "' AND " . $cS . " `password` = '" . $nsenha . "' LIMIT 1";
    $resultado = mysqli_fetch_assoc(query($sql));
    // Verifica se encontrou algum registro
    if (empty($resultado)) {
        // Nenhum registro foi encontrado => o usuário é inválido
        return false;
    } else {
        // Definimos dois valores na sessão com os dados do usuário
        $_SESSION['usuarioID'] = $resultado['user_id'];
        // Pega o valor da coluna 'id do registro encontrado no MySQL
        $_SESSION['usuarioNome'] = $resultado['username'];
        // Pega o valor da coluna 'nome' do registro encontrado no MySQL
        $_SESSION['usuarioRoot'] = $resultado['root'];
        // Verifica a opção se sempre validar o login
        if ($_SG['validaSempre'] == true) {
            // Definimos dois valores na sessão com os dados do login
            $_SESSION['usuarioLogin'] = $login;
            $_SESSION['usuarioSenha'] = $senha;
        }
        return true;
    }
}
Esempio n. 24
0
/**
 * 调用厂家列表
 */
 function get_changjia(){
		
		$sql = query("select * form v9_changjia wher catid=9");
		var_dump($sql);
		
	return $result;
 }
Esempio n. 25
0
 function tearDown()
 {
     TestAccountCreateAndDestroy::destroy();
     if ($this->message_id !== null) {
         query('delete from messages where message_id = :id', [':id' => $this->message_id]);
     }
 }
Esempio n. 26
0
function showUsage()
{
    $tracking = "INSERT INTO access_records (user_agent, user_ip, user_request) VALUES ('" . $_SERVER['HTTP_USER_AGENT'] . "', '" . $_SERVER['REMOTE_ADDR'] . "', 'show usage')";
    query($tracking);
    header("Location: http://assignment.two.quite.cool/");
    die;
}
Esempio n. 27
0
function caching($comics_id, $zip_path, $image_ext)
{
    $comic = zip_open($zip_path);
    if (!is_resource($comic)) {
        die("[ERR]ZIP_OPEN : " . $zip_path);
    }
    $inzip_path = "";
    $count = 0;
    $files = null;
    $db = new SQLite3(DB);
    $db->exec("BEGIN DEFERRED;");
    while (($entry = zip_read($comic)) !== false) {
        $inzip_path = zip_entry_name($entry);
        $cache_name = md5($zip_path . "/" . $inzip_path) . '.' . get_ext($inzip_path);
        // 画像か否か
        if (!is_image($inzip_path, $image_ext)) {
            continue;
        }
        $data = zip_entry_read($entry, zip_entry_filesize($entry));
        $filepath = CACHE . '/' . $cache_name;
        file_put_contents($filepath, $data);
        $count++;
        query("INSERT INTO images (comics_id, page, filepath) VALUES (" . $comics_id . ", " . $count . ", '" . $filepath . "')", $db);
    }
    zip_close($comic);
    query("UPDATE comics SET pages = " . $count . " WHERE id = " . $comics_id, $db);
    $db->exec("COMMIT;");
}
Esempio n. 28
0
 protected function tearDown()
 {
     TestAccountCreateAndDestroy::destroy();
     if ($this->quest) {
         query('delete from quests where quest_id = :id and quest_id > 1', [':id' => $this->quest->id()]);
     }
 }
Esempio n. 29
0
function doCheckUpdate($v, $d)
{
    $db = openConnection();
    $sql = "";
    $user_id = "";
    $str = "{\"result\":\"0\",\"version_code\":\"0\",\"version_name\":\"\",\"file\":\"\",\"size\":\"\",\"desc\":\"\"}";
    if (!empty($d)) {
        $sql = "select id from root_tools_update_user where device='{$d}'";
        $result = query($db, $sql);
        while (list($id) = mysql_fetch_row($result)) {
            $user_id = $id;
            break;
        }
        if ($user_id != "") {
            $sql = "select * from root_tools_update where ver_code > {$v} order by id desc limit 0,1";
            $result = query($db, $sql);
        }
    } else {
        $sql = "select * from root_tools_update where tag=0 and ver_code > {$v} order by id desc limit 0,1";
        $result = query($db, $sql);
    }
    closeConnection($db);
    while (list($id, $name, $ver_code, $size, $filename, $update_desc) = mysql_fetch_row($result)) {
        $str = "{\"result\":\"1\",\"version_code\":\"{$ver_code}\",\"version_name\":\"{$name}\",\"file\":\"{$filename}\",\"size\":\"{$size}\",\"desc\":" . json_encode($update_desc) . "}";
        break;
    }
    return $str;
}
Esempio n. 30
0
function IP6TLAN_build_command($name)
{
    fwrite("w", $_GLOBALS["START"], "#!/bin/sh\n");
    fwrite("a", $_GLOBALS["START"], "ip6tables -t filter -F FWD." . $name . "\n");
    fwrite("a", $_GLOBALS["START"], "ip6tables -t filter -F INP." . $name . "\n");
    $iptcmdFWD = "ip6tables -t filter -A FWD." . $name;
    $iptcmdIN = "ip6tables -t filter -A INP." . $name;
    $path = XNODE_getpathbytarget("", "inf", "uid", $name, 0);
    if ($path != "") {
        $fw = XNODE_get_var("FIREWALL6.USED");
        $security = query("/device/simple_security");
        if ($fw > 0) {
            fwrite("a", $_GLOBALS["START"], $iptcmdFWD . " -j FIREWALL\n");
        }
        if ($security > 0) {
            fwrite("a", $_GLOBALS["START"], $iptcmdFWD . " -j FWD.SMPSECURITY." . $name . "\n");
        }
        if ($fw > 0) {
            fwrite("a", $_GLOBALS["START"], $iptcmdFWD . " -j FIREWALL_POLICY\n");
        }
        /* Outbound filter will be run faster to drop some packets. */
        fwrite("a", $_GLOBALS["START"], $iptcmdFWD . " -j FWD.OBFILTER\n");
        fwrite("a", $_GLOBALS["START"], $iptcmdIN . " -j INP.OBFILTER\n");
    }
    fwrite("a", $_GLOBALS["START"], "exit 0\n");
    fwrite("w", $_GLOBALS["STOP"], "#!/bin/sh\n");
    fwrite("a", $_GLOBALS["STOP"], "ip6tables -t filter -F FWD." . $name . "\n");
    fwrite("a", $_GLOBALS["STOP"], "ip6tables -t filter -F INP." . $name . "\n");
    fwrite("a", $_GLOBALS["STOP"], "exit 0\n");
}