PHP get_schema_version函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中get_schema_version函数的典型用法代码示例。如果您正苦于以下问题：PHP get_schema_version函数的具体用法？PHP get_schema_version怎么用？PHP get_schema_version使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了get_schema_version函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: log_error

 function log_error($errno, $errstr, $file, $line, $context)
 {
     if (Db::get() && get_schema_version() > 117) {
         $errno = Db::get()->escape_string($errno);
         $errstr = Db::get()->escape_string($errstr);
         $file = Db::get()->escape_string($file);
         $line = Db::get()->escape_string($line);
         $context = DB::get()->escape_string($context);
         $owner_uid = $_SESSION["uid"] ? $_SESSION["uid"] : "NULL";
         $result = Db::get()->query("INSERT INTO ttrss_error_log\n\t\t\t\t(errno, errstr, filename, lineno, context, owner_uid, created_at) VALUES\n\t\t\t\t({$errno}, '{$errstr}', '{$file}', '{$line}', '{$context}', {$owner_uid}, NOW())");
         return Db::get()->affected_rows($result) != 0;
     }
     return false;
 }

开发者ID:XelaRellum，项目名称:tt-rss，代码行数:14，代码来源:sql.php

示例2: log_error

 function log_error($errno, $errstr, $file, $line, $context)
 {
     if (Db::get() && get_schema_version() > 117) {
         $errno = Db::get()->escape_string($errno);
         $errstr = Db::get()->escape_string($errstr);
         $file = Db::get()->escape_string($file);
         $line = Db::get()->escape_string($line);
         $context = '';
         // backtrace is a lot of data which is not really critical to store
         //$context = $this->dbh->escape_string(serialize($context));
         $owner_uid = $_SESSION["uid"] ? $_SESSION["uid"] : "NULL";
         $result = Db::get()->query("INSERT INTO ttrss_error_log\n\t\t\t\t(errno, errstr, filename, lineno, context, owner_uid, created_at) VALUES\n\t\t\t\t({$errno}, '{$errstr}', '{$file}', '{$line}', '{$context}', {$owner_uid}, NOW())");
         return Db::get()->affected_rows($result) != 0;
     }
     return false;
 }

开发者ID:Verisor，项目名称:tt-rss，代码行数:16，代码来源:sql.php

示例3: set_pref

function set_pref($link, $key, $value, $user_id = false)
{
    $key = db_escape_string($key);
    $value = db_escape_string($value);
    if (!$user_id) {
        $user_id = $_SESSION["uid"];
        $profile = $_SESSION["profile"];
    } else {
        $user_id = sprintf("%d", $user_id);
        $prefs_cache = false;
    }
    if ($profile) {
        $profile_qpart = "AND profile = '{$profile}'";
    } else {
        $profile_qpart = "AND profile IS NULL";
    }
    if (get_schema_version($link) < 63) {
        $profile_qpart = "";
    }
    $result = db_query($link, "SELECT type_name \n\t\t\tFROM ttrss_prefs,ttrss_prefs_types \n\t\t\tWHERE pref_name = '{$key}' AND type_id = ttrss_prefs_types.id");
    if (db_num_rows($result) > 0) {
        $type_name = db_fetch_result($result, 0, "type_name");
        if ($type_name == "bool") {
            if ($value == "1" || $value == "true") {
                $value = "true";
            } else {
                $value = "false";
            }
        } else {
            if ($type_name == "integer") {
                $value = sprintf("%d", $value);
            }
        }
        if ($pref_name == 'DEFAULT_ARTICLE_LIMIT' && $value == 0) {
            $value = 30;
        }
        db_query($link, "UPDATE ttrss_user_prefs SET \n\t\t\t\tvalue = '{$value}' WHERE pref_name = '{$key}' \n\t\t\t\t\t{$profile_qpart}\n\t\t\t\t\tAND owner_uid = " . $_SESSION["uid"]);
        $_SESSION["prefs_cache"] = array();
    }
}

开发者ID:buggithubs，项目名称:Tiny-Tiny-RSS，代码行数:40，代码来源:db-prefs.php

示例4: update_daemon_common

/**
 * Update a feed batch.
 * Used by daemons to update n feeds by run.
 * Only update feed needing a update, and not being processed
 * by another process.
 *
 * @param mixed $link Database link
 * @param integer $limit Maximum number of feeds in update batch. Default to DAEMON_FEED_LIMIT.
 * @param boolean $from_http Set to true if you call this function from http to disable cli specific code.
 * @param boolean $debug Set to false to disable debug output. Default to true.
 * @return void
 */
function update_daemon_common($limit = DAEMON_FEED_LIMIT, $from_http = false, $debug = true)
{
    // Process all other feeds using last_updated and interval parameters
    $schema_version = get_schema_version();
    if ($schema_version != SCHEMA_VERSION) {
        die("Schema version is wrong, please upgrade the database.\n");
    }
    define('PREFS_NO_CACHE', true);
    // Test if the user has loggued in recently. If not, it does not update its feeds.
    if (!SINGLE_USER_MODE && DAEMON_UPDATE_LOGIN_LIMIT > 0) {
        if (DB_TYPE == "pgsql") {
            $login_thresh_qpart = "AND ttrss_users.last_login >= NOW() - INTERVAL '" . DAEMON_UPDATE_LOGIN_LIMIT . " days'";
        } else {
            $login_thresh_qpart = "AND ttrss_users.last_login >= DATE_SUB(NOW(), INTERVAL " . DAEMON_UPDATE_LOGIN_LIMIT . " DAY)";
        }
    } else {
        $login_thresh_qpart = "";
    }
    // Test if the feed need a update (update interval exceded).
    if (DB_TYPE == "pgsql") {
        $update_limit_qpart = "AND ((\n\t\t\t\t\tttrss_feeds.update_interval = 0\n\t\t\t\t\tAND ttrss_user_prefs.value != '-1'\n\t\t\t\t\tAND ttrss_feeds.last_updated < NOW() - CAST((ttrss_user_prefs.value || ' minutes') AS INTERVAL)\n\t\t\t\t) OR (\n\t\t\t\t\tttrss_feeds.update_interval > 0\n\t\t\t\t\tAND ttrss_feeds.last_updated < NOW() - CAST((ttrss_feeds.update_interval || ' minutes') AS INTERVAL)\n\t\t\t\t) OR ttrss_feeds.last_updated IS NULL\n\t\t\t\tOR last_updated = '1970-01-01 00:00:00')";
    } else {
        $update_limit_qpart = "AND ((\n\t\t\t\t\tttrss_feeds.update_interval = 0\n\t\t\t\t\tAND ttrss_user_prefs.value != '-1'\n\t\t\t\t\tAND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL CONVERT(ttrss_user_prefs.value, SIGNED INTEGER) MINUTE)\n\t\t\t\t) OR (\n\t\t\t\t\tttrss_feeds.update_interval > 0\n\t\t\t\t\tAND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ttrss_feeds.update_interval MINUTE)\n\t\t\t\t) OR ttrss_feeds.last_updated IS NULL\n\t\t\t\tOR last_updated = '1970-01-01 00:00:00')";
    }
    // Test if feed is currently being updated by another process.
    if (DB_TYPE == "pgsql") {
        $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < NOW() - INTERVAL '10 minutes')";
    } else {
        $updstart_thresh_qpart = "AND (ttrss_feeds.last_update_started IS NULL OR ttrss_feeds.last_update_started < DATE_SUB(NOW(), INTERVAL 10 MINUTE))";
    }
    // Test if there is a limit to number of updated feeds
    $query_limit = "";
    if ($limit) {
        $query_limit = sprintf("LIMIT %d", $limit);
    }
    $query = "SELECT DISTINCT ttrss_feeds.feed_url, ttrss_feeds.last_updated\n\t\t\tFROM\n\t\t\t\tttrss_feeds, ttrss_users, ttrss_user_prefs\n\t\t\tWHERE\n\t\t\t\tttrss_feeds.owner_uid = ttrss_users.id\n\t\t\t\tAND ttrss_users.id = ttrss_user_prefs.owner_uid\n\t\t\t\tAND ttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL'\n\t\t\t\t{$login_thresh_qpart} {$update_limit_qpart}\n\t\t\t\t{$updstart_thresh_qpart}\n\t\t\t\tORDER BY last_updated {$query_limit}";
    // We search for feed needing update.
    $result = db_query($query);
    if ($debug) {
        _debug(sprintf("Scheduled %d feeds to update...", db_num_rows($result)));
    }
    // Here is a little cache magic in order to minimize risk of double feed updates.
    $feeds_to_update = array();
    while ($line = db_fetch_assoc($result)) {
        array_push($feeds_to_update, db_escape_string($line['feed_url']));
    }
    // We update the feed last update started date before anything else.
    // There is no lag due to feed contents downloads
    // It prevent an other process to update the same feed.
    if (count($feeds_to_update) > 0) {
        $feeds_quoted = array();
        foreach ($feeds_to_update as $feed) {
            array_push($feeds_quoted, "'" . db_escape_string($feed) . "'");
        }
        db_query(sprintf("UPDATE ttrss_feeds SET last_update_started = NOW()\n\t\t\t\tWHERE feed_url IN (%s)", implode(',', $feeds_quoted)));
    }
    $nf = 0;
    // For each feed, we call the feed update function.
    foreach ($feeds_to_update as $feed) {
        if ($debug) {
            _debug("Base feed: {$feed}");
        }
        //update_rss_feed($line["id"], true);
        // since we have the data cached, we can deal with other feeds with the same url
        $tmp_result = db_query("SELECT DISTINCT ttrss_feeds.id,last_updated,ttrss_feeds.owner_uid\n\t\t\tFROM ttrss_feeds, ttrss_users, ttrss_user_prefs WHERE\n\t\t\t\tttrss_user_prefs.owner_uid = ttrss_feeds.owner_uid AND\n\t\t\t\tttrss_users.id = ttrss_user_prefs.owner_uid AND\n\t\t\t\tttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL' AND\n\t\t\t\tfeed_url = '" . db_escape_string($feed) . "' AND\n\t\t\t\t(ttrss_feeds.update_interval > 0 OR\n\t\t\t\t\tttrss_user_prefs.value != '-1')\n\t\t\t\t{$login_thresh_qpart}\n\t\t\tORDER BY ttrss_feeds.id {$query_limit}");
        if (db_num_rows($tmp_result) > 0) {
            while ($tline = db_fetch_assoc($tmp_result)) {
                if ($debug) {
                    _debug(" => " . $tline["last_updated"] . ", " . $tline["id"] . " " . $tline["owner_uid"]);
                }
                update_rss_feed($tline["id"], true);
                ++$nf;
            }
        }
    }
    require_once "digest.php";
    // Send feed digests by email if needed.
    send_headlines_digests($debug);
    return $nf;
}

开发者ID:cs-team，项目名称:tiny_tiny_rss-openshift-quickstart，代码行数:92，代码来源:rssfuncs.php

示例5: sanity_check

function sanity_check()
{
    require_once 'errors.php';
    global $ERRORS;
    $error_code = 0;
    $schema_version = get_schema_version(true);
    if ($schema_version != SCHEMA_VERSION) {
        $error_code = 5;
    }
    if (DB_TYPE == "mysql") {
        $result = db_query("SELECT true", false);
        if (db_num_rows($result) != 1) {
            $error_code = 10;
        }
    }
    if (db_escape_string("testTEST") != "testTEST") {
        $error_code = 12;
    }
    return array("code" => $error_code, "message" => $ERRORS[$error_code]);
}

开发者ID:nota-ja，项目名称:tt-rss，代码行数:20，代码来源:functions.php

示例6: write

 function write($pref_name, $value, $user_id = false, $strip_tags = true)
 {
     $pref_name = db_escape_string($pref_name);
     $value = db_escape_string($value, $strip_tags);
     if (!$user_id) {
         $user_id = $_SESSION["uid"];
         @($profile = $_SESSION["profile"]);
     } else {
         $user_id = sprintf("%d", $user_id);
         $prefs_cache = false;
     }
     if ($profile) {
         $profile_qpart = "AND profile = '{$profile}'";
     } else {
         $profile_qpart = "AND profile IS NULL";
     }
     if (get_schema_version() < 63) {
         $profile_qpart = "";
     }
     $type_name = "";
     $current_value = "";
     if (isset($this->cache[$pref_name])) {
         $type_name = $this->cache[$pref_name]["type"];
         $current_value = $this->cache[$pref_name]["value"];
     }
     if (!$type_name) {
         $result = db_query("SELECT type_name\n                FROM ttrss_prefs,ttrss_prefs_types\n                WHERE pref_name = '{$pref_name}' AND type_id = ttrss_prefs_types.id");
         if (db_num_rows($result) > 0) {
             $type_name = db_fetch_result($result, 0, "type_name");
         }
     } elseif ($current_value == $value) {
         return;
     }
     if ($type_name) {
         if ($type_name == "bool") {
             if ($value == "1" || $value == "true") {
                 $value = "true";
             } else {
                 $value = "false";
             }
         } elseif ($type_name == "integer") {
             $value = sprintf("%d", $value);
         }
         if ($pref_name == 'USER_TIMEZONE' && $value == '') {
             $value = 'UTC';
         }
         db_query("UPDATE ttrss_user_prefs SET\n                value = '{$value}' WHERE pref_name = '{$pref_name}'\n                    {$profile_qpart}\n                    AND owner_uid = " . $_SESSION["uid"]);
         if ($user_id == $_SESSION["uid"]) {
             $this->cache[$pref_name]["type"] = $type_name;
             $this->cache[$pref_name]["value"] = $value;
         }
     }
 }

开发者ID:adrianpietka，项目名称:bfrss，代码行数:53，代码来源:prefs.php

示例7: getline

<?php 
function getline($fp, $delim)
{
    $result = "";
    while (!feof($fp)) {
        $tmp = fgetc($fp);
        if ($tmp == $delim) {
            return $result;
        }
        $result .= $tmp;
    }
    return $result;
}
$op = $_POST["op"];
$version = get_schema_version($link);
$update_files = glob("schema/versions/" . DB_TYPE . "/*sql");
$update_versions = array();
foreach ($update_files as $f) {
    $m = array();
    preg_match_all("/schema\\/versions\\/" . DB_TYPE . "\\/(\\d*)\\.sql/", $f, $m, PREG_PATTERN_ORDER);
    if ($m[1][0]) {
        $update_versions[$m[1][0]] = $f;
    }
}
ksort($update_versions, SORT_NUMERIC);
$latest_version = max(array_keys($update_versions));
if ($version == $latest_version) {
    if ($version != SCHEMA_VERSION) {
        print_error(__("Could not update database"));
        print "<p>" . __("Could not find necessary schema file, need version:") . " " . SCHEMA_VERSION . __(", found: ") . $latest_version . "</p>";

开发者ID:RulerOf，项目名称:Tiny-Tiny-IRC，代码行数:30，代码来源:update.php

示例8: set_pref

function set_pref($link, $pref_name, $value, $user_id = false, $strip_tags = true)
{
    $pref_name = db_escape_string($pref_name);
    $value = db_escape_string($value, $strip_tags);
    if (!$user_id) {
        $user_id = $_SESSION["uid"];
        @($profile = $_SESSION["profile"]);
    } else {
        $user_id = sprintf("%d", $user_id);
        $prefs_cache = false;
    }
    if ($profile) {
        $profile_qpart = "AND profile = '{$profile}'";
    } else {
        $profile_qpart = "AND profile IS NULL";
    }
    if (get_schema_version($link) < 63) {
        $profile_qpart = "";
    }
    $type_name = "";
    $current_value = "";
    if (!defined('DISABLE_SESSIONS') && !defined('PREFS_NO_CACHE')) {
        if ($_SESSION["prefs_cache"] && @$_SESSION["prefs_cache"][$pref_name]) {
            $type_name = $_SESSION["prefs_cache"][$pref_name]["type"];
            $current_value = $_SESSION["prefs_cache"][$pref_name]["value"];
        }
    }
    if (!$type_name) {
        $result = db_query($link, "SELECT type_name\n\t\t\t\tFROM ttrss_prefs,ttrss_prefs_types\n\t\t\t\tWHERE pref_name = '{$pref_name}' AND type_id = ttrss_prefs_types.id");
        if (db_num_rows($result) > 0) {
            $type_name = db_fetch_result($result, 0, "type_name");
        }
    } else {
        if ($current_value == $value) {
            return;
        }
    }
    if ($type_name) {
        if ($type_name == "bool") {
            if ($value == "1" || $value == "true") {
                $value = "true";
            } else {
                $value = "false";
            }
        } else {
            if ($type_name == "integer") {
                $value = sprintf("%d", $value);
            }
        }
        if ($pref_name == 'DEFAULT_ARTICLE_LIMIT' && $value == 0) {
            $value = 30;
        }
        if ($pref_name == 'USER_TIMEZONE' && $value == '') {
            $value = 'UTC';
        }
        db_query($link, "UPDATE ttrss_user_prefs SET\n\t\t\t\tvalue = '{$value}' WHERE pref_name = '{$pref_name}'\n\t\t\t\t\t{$profile_qpart}\n\t\t\t\t\tAND owner_uid = " . $_SESSION["uid"]);
        if (!defined('DISABLE_SESSIONS')) {
            if ($user_id == $_SESSION["uid"]) {
                $_SESSION["prefs_cache"][$pref_name]["type"] = $type_name;
                $_SESSION["prefs_cache"][$pref_name]["value"] = $value;
            }
        }
    }
}

开发者ID:bohoo，项目名称:tiny_tiny_rss-openshift-quickstart-1，代码行数:64，代码来源:db-prefs.php

示例9: sanity_check

function sanity_check($link)
{
    error_reporting(0);
    $error_code = 0;
    $schema_version = get_schema_version($link);
    if ($schema_version != SCHEMA_VERSION) {
        $error_code = 5;
    }
    if (DB_TYPE == "mysql") {
        $result = db_query($link, "SELECT true", false);
        if (db_num_rows($result) != 1) {
            $error_code = 10;
        }
    }
    if (db_escape_string("testTEST") != "testTEST") {
        $error_code = 12;
    }
    error_reporting(DEFAULT_ERROR_LEVEL);
    if ($error_code != 0) {
        print_error_xml($error_code);
        return false;
    } else {
        return true;
    }
}

开发者ID:wangroot，项目名称:Tiny-Tiny-RSS，代码行数:25，代码来源:functions.php

示例10: login

 function login()
 {
     if (!SINGLE_USER_MODE) {
         $login = $this->dbh->escape_string($_POST["login"]);
         $password = $_POST["password"];
         $remember_me = $_POST["remember_me"];
         if ($remember_me) {
             session_set_cookie_params(SESSION_COOKIE_LIFETIME);
         } else {
             session_set_cookie_params(0);
         }
         @session_start();
         if (authenticate_user($login, $password)) {
             $_POST["password"] = "";
             if (get_schema_version() >= 120) {
                 $_SESSION["language"] = get_pref("USER_LANGUAGE", $_SESSION["uid"]);
             }
             $_SESSION["ref_schema_version"] = get_schema_version(true);
             $_SESSION["bw_limit"] = !!$_POST["bw_limit"];
             if ($_POST["profile"]) {
                 $profile = $this->dbh->escape_string($_POST["profile"]);
                 $result = $this->dbh->query("SELECT id FROM ttrss_settings_profiles\n\t\t\t\t\t\tWHERE id = '{$profile}' AND owner_uid = " . $_SESSION["uid"]);
                 if ($this->dbh->num_rows($result) != 0) {
                     $_SESSION["profile"] = $profile;
                 }
             }
         } else {
             $_SESSION["login_error_msg"] = __("Incorrect username or password");
             user_error("Failed login attempt from {$_SERVER['REMOTE_ADDR']}", E_USER_WARNING);
         }
         if ($_REQUEST['return']) {
             header("Location: " . $_REQUEST['return']);
         } else {
             header("Location: " . SELF_URL_PATH);
         }
     }
 }

开发者ID:cs-team，项目名称:tiny_tiny_rss-openshift-quickstart，代码行数:37，代码来源:public.php

示例11: login

 function login()
 {
     $_SESSION["prefs_cache"] = array();
     if (!SINGLE_USER_MODE) {
         $login = db_escape_string($_POST["login"]);
         $password = $_POST["password"];
         $remember_me = $_POST["remember_me"];
         if (authenticate_user($this->link, $login, $password)) {
             $_POST["password"] = "";
             $_SESSION["language"] = $_POST["language"];
             $_SESSION["ref_schema_version"] = get_schema_version($this->link, true);
             $_SESSION["bw_limit"] = !!$_POST["bw_limit"];
             if ($_POST["profile"]) {
                 $profile = db_escape_string($_POST["profile"]);
                 $result = db_query($this->link, "SELECT id FROM ttrss_settings_profiles\n\t\t\t\t\t\tWHERE id = '{$profile}' AND owner_uid = " . $_SESSION["uid"]);
                 if (db_num_rows($result) != 0) {
                     $_SESSION["profile"] = $profile;
                     $_SESSION["prefs_cache"] = array();
                 }
             }
         } else {
             $_SESSION["login_error_msg"] = __("Incorrect username or password");
         }
         if ($_REQUEST['return']) {
             header("Location: " . $_REQUEST['return']);
         } else {
             header("Location: " . SELF_URL_PATH);
         }
     }
 }

开发者ID:bohoo，项目名称:tiny_tiny_rss-openshift-quickstart-1，代码行数:30，代码来源:public.php

示例12: foreach

    print "  --convert-filters    - convert type1 filters to type2\n";
    print "  --force-update       - force update of all feeds\n";
    print "  --list-plugins       - list all available plugins\n";
    print "  --help               - show this help\n";
    print "Plugin options:\n";
    foreach (PluginHost::getInstance()->get_commands() as $command => $data) {
        $args = $data['arghelp'];
        printf(" --%-19s - %s\n", "{$command} {$args}", $data["description"]);
    }
    return;
}
if (!isset($options['daemon'])) {
    require_once "errorhandler.php";
}
if (!isset($options['update-schema'])) {
    $schema_version = get_schema_version();
    if ($schema_version != SCHEMA_VERSION) {
        die("Schema version is wrong, please upgrade the database.\n");
    }
}
define('QUIET', isset($options['quiet']));
if (isset($options["log"])) {
    _debug("Logging to " . $options["log"]);
    define('LOGFILE', $options["log"]);
}
if (!isset($options["daemon"])) {
    $lock_filename = "update.lock";
} else {
    $lock_filename = "update_daemon.lock";
}
if (isset($options["task"])) {

开发者ID:cs-team，项目名称:tiny_tiny_rss-openshift-quickstart，代码行数:31，代码来源:update.php

示例13: authenticate

    function authenticate($login, $password)
    {
        $pwd_hash0 = hash_password($password);
        $pwd_hash1 = encrypt_password($password);
        $pwd_hash2 = encrypt_password($password, $login);
        $login = db_escape_string($login);
        $otp = db_escape_string($_REQUEST["otp"]);
        if (get_schema_version() > 96) {
            if (!defined('AUTH_DISABLE_OTP') || !AUTH_DISABLE_OTP) {
                $result = db_query("SELECT otp_enabled,salt FROM ttrss_users WHERE\n\t\t\t\t\tlogin = '{$login}'");
                if (db_num_rows($result) > 0) {
                    require_once "lib/otphp/vendor/base32.php";
                    require_once "lib/otphp/lib/otp.php";
                    require_once "lib/otphp/lib/totp.php";
                    $base32 = new Base32();
                    $otp_enabled = sql_bool_to_bool(db_fetch_result($result, 0, "otp_enabled"));
                    $secret = $base32->encode(sha1(db_fetch_result($result, 0, "salt")));
                    $topt = new \OTPHP\TOTP($secret);
                    $otp_check = $topt->now();
                    if ($otp_enabled) {
                        if ($otp) {
                            if ($otp != $otp_check) {
                                return false;
                            }
                        } else {
                            $return = urlencode($_REQUEST["return"]);
                            ?>
<html>
								<head><title>Tiny Tiny RSS</title></head>
								<?php 
                            echo stylesheet_tag("css/utility.css");
                            ?>
							<body class="otp"><div class="content">
							<form action="public.php?return=<?php 
                            echo $return;
                            ?>
"
									method="POST" class="otpform">
								<input type="hidden" name="op" value="login">
								<input type="hidden" name="login" value="<?php 
                            echo htmlspecialchars($login);
                            ?>
">
								<input type="hidden" name="password" value="<?php 
                            echo htmlspecialchars($password);
                            ?>
">
								<input type="hidden" name="bw_limit" value="<?php 
                            echo htmlspecialchars($_POST["bw_limit"]);
                            ?>
">
								<input type="hidden" name="remember_me" value="<?php 
                            echo htmlspecialchars($_POST["remember_me"]);
                            ?>
">
								<input type="hidden" name="profile" value="<?php 
                            echo htmlspecialchars($_POST["profile"]);
                            ?>
">

								<label><?php 
                            echo __("Please enter your one time password:");
                            ?>
</label>
								<input autocomplete="off" size="6" name="otp" value=""/>
								<input type="submit" value="Continue"/>
							</form></div>
							<script type="text/javascript">
								document.forms[0].otp.focus();
							</script>
							<?php 
                            exit;
                        }
                    }
                }
            }
        }
        $result = db_query("SELECT id,pwd_hash FROM ttrss_users WHERE\n\t\t\tlogin = '{$login}'");
        if (db_num_rows($result) === 1) {
            if (version_compare(PHP_VERSION, '5.5.0', '<')) {
                require_once 'vendor/ircmaxell/password-compat/lib/password.php';
            }
            $pwd_hash_dp = db_fetch_result($result, 0, "pwd_hash");
            if (password_verify($password, $pwd_hash_dp)) {
                return db_fetch_result($result, 0, "id");
            }
        }
        if (get_schema_version() > 87) {
            $result = db_query("SELECT salt FROM ttrss_users WHERE\n\t\t\t\tlogin = '{$login}'");
            if (db_num_rows($result) !== 1) {
                return false;
            }
            $salt = db_fetch_result($result, 0, "salt");
            if ($salt == "") {
                $query = "SELECT id\n\t\t\t\t\tFROM ttrss_users WHERE\n\t\t\t\t\tlogin = '{$login}' AND (pwd_hash = '{$pwd_hash1}' OR\n\t\t\t\t\tpwd_hash = '{$pwd_hash2}')";
                // verify and upgrade password to new salt base
                $result = db_query($query);
                if (db_num_rows($result) === 1) {
                    // upgrade password to MODE2
                    $salt = substr(bin2hex(get_random_bytes(125)), 0, 250);
//.........这里部分代码省略.........

开发者ID:adrianpietka，项目名称:bfrss，代码行数:101，代码来源:init.php

示例14: authenticate

    function authenticate($login, $password)
    {
        $pwd_hash1 = encrypt_password($password);
        $pwd_hash2 = encrypt_password($password, $login);
        $login = db_escape_string($login);
        $otp = db_escape_string($_REQUEST["otp"]);
        if (get_schema_version($this->link) > 96) {
            if (!defined('AUTH_DISABLE_OTP') || !AUTH_DISABLE_OTP) {
                $result = db_query($this->link, "SELECT otp_enabled,salt FROM ttrss_users WHERE\n\t\t\t\t\tlogin = '{$login}'");
                if (db_num_rows($result) > 0) {
                    require_once "lib/otphp/vendor/base32.php";
                    require_once "lib/otphp/lib/otp.php";
                    require_once "lib/otphp/lib/totp.php";
                    $base32 = new Base32();
                    $otp_enabled = sql_bool_to_bool(db_fetch_result($result, 0, "otp_enabled"));
                    $secret = $base32->encode(sha1(db_fetch_result($result, 0, "salt")));
                    $topt = new \OTPHP\TOTP($secret);
                    $otp_check = $topt->now();
                    if ($otp_enabled) {
                        if ($otp) {
                            if ($otp != $otp_check) {
                                return false;
                            }
                        } else {
                            $return = urlencode($_REQUEST["return"]);
                            ?>
<html>
								<head><title>Tiny Tiny RSS</title></head>
							<body>
							<form action="public.php?return=<?php 
                            echo $return;
                            ?>
"
									method="POST">
								<input type="hidden" name="op" value="login">
								<input type="hidden" name="login" value="<?php 
                            echo htmlspecialchars($login);
                            ?>
">
								<input type="hidden" name="password" value="<?php 
                            echo htmlspecialchars($password);
                            ?>
">

								<label><?php 
                            echo __("Please enter your one time password:");
                            ?>
</label>
								<input type="password" size="6" name="otp"/>
								<input type="submit" value="Continue"/>
							</form>
							<script type="text/javascript">
								document.forms[0].otp.focus();
							</script>
							<?php 
                            exit;
                        }
                    }
                }
            }
        }
        if (get_schema_version($this->link) > 87) {
            $result = db_query($this->link, "SELECT salt FROM ttrss_users WHERE\n\t\t\t\tlogin = '{$login}'");
            if (db_num_rows($result) != 1) {
                return false;
            }
            $salt = db_fetch_result($result, 0, "salt");
            if ($salt == "") {
                $query = "SELECT id\n\t            FROM ttrss_users WHERE\n\t\t\t\t\tlogin = '{$login}' AND (pwd_hash = '{$pwd_hash1}' OR\n\t\t\t\t\tpwd_hash = '{$pwd_hash2}')";
                // verify and upgrade password to new salt base
                $result = db_query($this->link, $query);
                if (db_num_rows($result) == 1) {
                    // upgrade password to MODE2
                    $salt = substr(bin2hex(get_random_bytes(125)), 0, 250);
                    $pwd_hash = encrypt_password($password, $salt, true);
                    db_query($this->link, "UPDATE ttrss_users SET\n\t\t\t\t\t\tpwd_hash = '{$pwd_hash}', salt = '{$salt}' WHERE login = '{$login}'");
                    $query = "SELECT id\n\t\t            FROM ttrss_users WHERE\n\t\t\t\t\t\tlogin = '{$login}' AND pwd_hash = '{$pwd_hash}'";
                } else {
                    return false;
                }
            } else {
                $pwd_hash = encrypt_password($password, $salt, true);
                $query = "SELECT id\n\t\t         FROM ttrss_users WHERE\n\t\t\t\t\tlogin = '{$login}' AND pwd_hash = '{$pwd_hash}'";
            }
        } else {
            $query = "SELECT id\n\t         FROM ttrss_users WHERE\n\t\t\t\tlogin = '{$login}' AND (pwd_hash = '{$pwd_hash1}' OR\n\t\t\t\t\tpwd_hash = '{$pwd_hash2}')";
        }
        $result = db_query($this->link, $query);
        if (db_num_rows($result) == 1) {
            return db_fetch_result($result, 0, "id");
        }
        return false;
    }

开发者ID:bohoo，项目名称:tiny_tiny_rss-openshift-quickstart-1，代码行数:93，代码来源:init.php

示例15: initialize_user_prefs

function initialize_user_prefs($link, $uid, $profile = false)
{
    $uid = db_escape_string($uid);
    if (!$profile) {
        $profile = "NULL";
        $profile_qpart = "AND profile IS NULL";
    } else {
        $profile_qpart = "AND profile = '{$profile}'";
    }
    db_query($link, "BEGIN");
    $result = db_query($link, "SELECT pref_name,def_value FROM ttirc_prefs");
    $u_result = db_query($link, "SELECT pref_name \n\t\t\tFROM ttirc_user_prefs WHERE owner_uid = '{$uid}' {$profile_qpart}");
    $active_prefs = array();
    while ($line = db_fetch_assoc($u_result)) {
        array_push($active_prefs, $line["pref_name"]);
    }
    while ($line = db_fetch_assoc($result)) {
        if (array_search($line["pref_name"], $active_prefs) === FALSE) {
            //				print "adding " . $line["pref_name"] . "<br>";
            if (get_schema_version($link) < 63) {
                db_query($link, "INSERT INTO ttirc_user_prefs\n\t\t\t\t\t\t(owner_uid,pref_name,value) VALUES \n\t\t\t\t\t\t('{$uid}', '" . $line["pref_name"] . "','" . $line["def_value"] . "')");
            } else {
                db_query($link, "INSERT INTO ttirc_user_prefs\n\t\t\t\t\t\t(owner_uid,pref_name,value, profile) VALUES \n\t\t\t\t\t\t('{$uid}', '" . $line["pref_name"] . "','" . $line["def_value"] . "', {$profile})");
            }
        }
    }
    db_query($link, "COMMIT");
}

开发者ID:RulerOf，项目名称:Tiny-Tiny-IRC，代码行数:28，代码来源:functions.php

注：本文中的get_schema_version函数示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP get_screen_icon函数代码示例发布时间：2022-05-15

PHP get_schema_markup函数代码示例发布时间：2022-05-15

CVE-2022-30203

1 CVE-2022-30203

Windows Boot Manager Security Feature Bypass Vulnerability.

阅读：894|2022-07-29

2 PacktPublishing/Python-Machine-Learning-

PacktPublishing/Python-Machine-Learning-Second-Edition: Python Machine Learning

阅读：975|2022-08-18

3 altair-viz/altair: Declarative statistic

altair-viz/altair: Declarative statistical visualization library for Python

阅读：1108|2022-08-15

4 sussillo/hfopt-matlab: A parallel, cpu-b

sussillo/hfopt-matlab: A parallel, cpu-based matlab implemention of the Hessian

阅读：999|2022-08-17

5 鲁东大学一米网:Win7系统USB驱动器RAM的操

win7系统电脑使用过程中有不少朋友表示遇到过win7系统USB驱动器RAM的状况，当出现win7

阅读：891|2022-11-06

6 emersion/go-ostatus: An OStatus library

emersion/go-ostatus: An OStatus library written in Go

阅读：752|2022-08-17

7 小程序云开发获取不到openid

这篇文章讲的很好但是那位老哥你唯一没有说的就是最后结局方法里面的 env:“jnfrie

阅读：575|2022-07-18

8 elipapa/markdown-cv: a simple template t

elipapa/markdown-cv: a simple template to write your CV in a readable markdown f

阅读：514|2022-08-17

9 zju-sclab/NDT-library: These is ndt libr

zju-sclab/NDT-library: These is ndt library for ndt_mapping and ndt_localization

阅读：735|2022-08-16

10 卡莉·蕾·吉普森是谁?不雅录像是怎么回事?

Call Me Maybe 中英字幕对于加拿大歌手卡莉·蕾·吉普森很多人有些陌生，她隶属于贾

阅读：632|2022-11-06

客服电话

电子邮件

PHP get_schema_version函数代码示例

示例1: log_error

示例2: log_error

示例3: set_pref

示例4: update_daemon_common

示例5: sanity_check

示例6: write

示例7: getline

示例8: set_pref

示例9: sanity_check

示例10: login

示例11: login

示例12: foreach

示例13: authenticate

示例14: authenticate

示例15: initialize_user_prefs

请发表评论

全部评论

上一篇：

下一篇：

PacktPublishing/Python-Machine-Learning-

Delphi实现窗体自适应调整尺寸以适应不同屏

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

CVE-2022-29467

CVE-2022-30203

PacktPublishing/Python-Machine-Learning-

altair-viz/altair: Declarative statistic

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

关于我们

产品与服务

解决方案

139-2527-9053