/** * Replaces Rsa key pair. The first step: prepare temporary data on the server: * a temporary table in the DB to reencrypt data etc. * * : close the shop? * * It removes the temporary table with the reencrypted data order_person_info, * if it exists. It creates the same one, by copying order info. * It initializes and saves required ancillary variables to the module * settings Offline CC. * */ function ReplaceRSAKeyPairStep1PrepareServerTmpData() { global $application; $table_prefix = $application->getAppIni('DB_TABLE_PREFIX'); $table_suffix = modApiFunc("Payment_Module_Offline_CC", "getTmpTableSuffix"); $table_name = "order_person_data"; $table_name_with_prefix_and_suffix = $table_prefix . $table_name . $table_suffix; $table_name_with_suffix = $table_name . $table_suffix; if (DB_MySQL::DB_isTableExists($table_name_with_prefix_and_suffix)) { /** * Remove old temporary data. It can left if, for example, * the previous data reencryption wasn't completed. */ $db_table_delete = new DB_Table_Delete($table_name_with_suffix); $application->db->PrepareSQL($db_table_delete); $application->db->DB_Exec(); } //Prepare new temporary data for reencrypting. new DB_Table_Clone("Checkout", $table_name, $table_name . $table_suffix); /** * Prepare new optional data storing reencription status. * * The field order_person_data_id has now an attribute auto_increment now, * so just remember that not decrypted, where we stopped last time. * All records with great ID will be considered as not reencrypted. * */ $this->ReplaceRSAKeyPairStep2ReencryptTmpDataOrderPersonDataId = 1; modApiFunc("Payment_Module_Offline_CC", "saveState"); }
/** * Init test */ public function setUp() { try { $this->conn = DB_MySQL::connect("localhost", "qtest", null, null, null, null, array('config' => array('driver' => 'yaml', 'path' => __DIR__ . '/settings'))); } catch (Exception $e) { $this->markTestSkipped("Failed to connect to database. Please create a user 'qtest' with all privileges to database 'qtest'. " . $e->getMessage()); } $this->createTestSchema(); }
/** * Init test */ public function setUp() { try { $this->conn = DB_MySQL::connect("localhost", "qtest"); } catch (Exception $e) { $this->markTestSkipped("Failed to connect to database. Please create a user 'qtest' with all privileges to database 'qtest'. " . $e->getMessage()); } $this->createTestSchema(); }
/** * DB_Table_Create class constructor. * * @return * @param array $tables array of meta description of the tables. * @ change error messages to error description from resource file */ function DB_Table_Create($tables) { global $application; $table_prefix = $application->getAppIni('DB_TABLE_PREFIX'); foreach ($tables as $table_name => $table_properties) { $table_name = $table_prefix . $table_name; if (DB_MySQL::DB_isTableExists($table_name)) { _fatal(array("CODE" => "CORE_043"), $table_name); } $this->QueryType = DBQUERY_TYPE_CREATE; $this->CreateTable = $table_name; $this->CreateFields = array(); $this->CreateKeys = array(); $this->CreateIndexes = array(); foreach ($table_properties['columns'] as $key => $field) { $this->addField($this->parseFieldName($field), $table_properties['types'][$key]); } if (isset($table_properties['primary']) && sizeof($table_properties['primary']) > 0) { $primary_key = array(); foreach ($table_properties['primary'] as $pk) { array_push($primary_key, $this->parseFieldName($table_properties['columns'][$pk])); } $this->addKey(implode(', ', $primary_key)); } if (isset($table_properties['indexes']) && sizeof($table_properties['indexes']) > 0) { foreach ($table_properties['indexes'] as $index_name => $field_names) { $field_names = str_replace(' ', '', $field_names); $fields = explode(',', $field_names); $index = array(); foreach ($fields as $field) { // , if (is_int($_pos = _ml_strpos($field, '('))) { $_len = _ml_substr($field, $_pos); $_field_without_len = _ml_substr($field, 0, $_pos); array_push($index, $this->parseFieldName($table_properties['columns'][$_field_without_len]) . $_len); } else { array_push($index, $this->parseFieldName($table_properties['columns'][$field])); } } $this->addIndex(implode(', ', $index), $index_name); } } $application->db->getDB_Result($this); } }
private function storeMySql($objectID, $objectOld) { if (null === $this->_db) { $this->_db = new \Core\DB_MySQL(); $this->_db->connect($this->config->db->db_host, $this->config->db->db_name, $this->config->db->db_user, $this->config->db->db_password); } $sql = "INSERT INTO " . self::MYSQL_TABLE_NAME . " SET "; $sql .= " ActionID = '" . addslashes($this->_action) . "',"; $sql .= " Date = '" . time() . "',"; $sql .= " UserID = " . $this->_userID . ','; $sql .= " IP = '" . $this->_IP . "',"; $sql .= " ForwardedIP = '" . $this->_ForwardedIP . "',"; $sql .= " ObjectID = " . intval($objectID) . ","; $sql .= " ObjectOld = " . $objectOld . ","; $sql .= " Params='" . $this->_params . "'"; try { $this->_db->execute($sql); } catch (\Exception $e) { throw new \Core\Exception($sql, 0, null, $this->config); } }
exit('error: 403 Access Denied'); } $nid = intval($_GET['nid']); if ($nid) { $query = "SELECT * FROM `yunbbs_categories` WHERE `id`='{$nid}'"; $c_obj = $DBS->fetch_one_array($query); if (!$c_obj) { header('location: /admin-node#edit'); exit; } } $tip1 = ''; $tip2 = ''; if ($_SERVER['REQUEST_METHOD'] == 'POST') { $action = $_POST['action']; $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); if ($action == 'find') { $n_id = trim($_POST['findid']); if ($n_id) { header('location: /admin-node-' . $n_id); } else { header('location: /admin-node#edit'); } exit; } else { if ($action == 'add') { $n_name = trim($_POST['name']); $n_about = trim($_POST['about']); if ($n_name) { $check_obj = $DBS->fetch_one_array("SELECT * FROM `yunbbs_categories` WHERE `name`='" . $n_name . "'");
$listFiles = $archive->extract(PCLZIP_OPT_PATH, $uploaddir); if ($listFiles == 0) { die("Error : " . $archive->errorInfo(true)); } else { //exclue o arquivo .zip enviado via upload $fileDbf = $uploaddir . $listFiles[0]['stored_filename']; echo "<b>ARQUIVO =" . $listFiles[0]['filename'] . "</b>"; unlink($uploaddir . $filename); } } elseif (strtoupper($ext[1]) == "DBF") { $fileDbf = $uploaddir . $filename; } ob_flush(); flush(); $arrCampoData = array("DT_NOTIFIC", "DT_NASC", "DT_DIAG", "EVO_DT"); $db = new DB_MySQL($db_conn); $db->Connect(); $db->Query("SET NAMES 'utf8'"); $db->Query("SET CHARACTER SET utf8"); $db->Query("truncate table {$tabelaNome}"); $dbf = new dbf_class($fileDbf); $num_rec = $dbf->dbf_num_rec; $num_field = $dbf->dbf_num_field; #$num_rec =5620; $qtdeErr = 0; $field_names = $dbf->dbf_names; foreach ($field_names as $indice => $campo) { $campos .= $campo['name'] . ','; } $campos = substr($campos, 0, strlen($campos) - 1); for ($i = 0; $i < $num_rec; $i++) {
define('ROOT', pathinfo(__FILE__, PATHINFO_DIRNAME)); include ROOT . '/config.php'; include ROOT . '/common.php'; if (!$cur_user || $cur_user['flag'] < 99) { exit('error: 403 Access Denied'); } $rid = intval($_GET['rid']); $query = "SELECT `id`,`articleid`,`content` FROM `yunbbs_comments` WHERE id='{$rid}'"; $r_obj = $DBS->fetch_one_array($query); if (!$r_obj) { exit('404'); } if ($_SERVER['REQUEST_METHOD'] == 'POST') { $r_content = addslashes(trim($_POST['content'])); if ($r_content) { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); $r_content = htmlspecialchars($r_content); $DBM->unbuffered_query("UPDATE `yunbbs_comments` SET `content`='{$r_content}' WHERE `id`='{$rid}'"); $tip = '评论已成功修改'; } else { $tip = '内容 不能留空'; } } else { $r_content = $r_obj['content']; $tip = ''; } // 页面变量 $title = '修改评论'; // 设置回复图片最大宽度 $img_max_w = 590;
} else { $errors[] = '名字 太长 或 太短 或 包含非法字符'; } } else { $errors[] = '用户名 或 密码 太长了'; } } else { $errors[] = '密码、重复密码 输入不一致'; } } else { $errors[] = '用户名、密码、重复密码、验证码 必填'; } //// if (!$errors) { $pwmd5 = md5($pw); $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); if ($options['register_review']) { $flag = 1; } else { $flag = 5; } $DBM->query("INSERT INTO `yunbbs_users` (`id`,`name`,`flag`,`password`,`regtime`) VALUES (null,'{$name}', {$flag}, '{$pwmd5}', {$timestamp})"); $new_uid = $DBM->insert_id(); if ($new_uid == 1) { $DBM->unbuffered_query("UPDATE `yunbbs_users` SET `flag` = '99' WHERE `id`='1'"); } $MMC->delete('site_infos'); // 记录已注册ip $MMC->set('regip_' . $onlineip, '1', 0, intval($options['reg_ip_space'])); //设置cookie
if ($config['database']['type'] == 'sqlite3' || $config['database']['type'] == 'sqlite2') { $config['database']['type'] = 'sqlite'; } require_once MYBB_ROOT . "inc/db_{$config['database']['type']}.php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } // Connect to Database define('TABLE_PREFIX', $config['database']['table_prefix']); $db->connect($config['database']); $db->set_table_prefix(TABLE_PREFIX); $db->type = $config['database']['type']; // Load Settings if (file_exists(MYBB_ROOT . "inc/settings.php")) { require_once MYBB_ROOT . "inc/settings.php"; } if (!file_exists(MYBB_ROOT . "inc/settings.php") || !$settings) { if (function_exists('rebuild_settings')) { rebuild_settings(); } else { $options = array("order_by" => "title", "order_dir" => "ASC");
<?php require_once 'includes/phpvortex/DB_MySQL.class.php'; require_once 'includes/conn.php'; require_once 'includes/helper.php'; $db = new DB_MySQL($db_conn); $db->Connect(); $db->Query("SET NAMES 'utf8'"); $db->Query("SET CHARACTER SET utf8"); session_start(); if (empty($_SESSION['user']) || empty($_SESSION['ip']) || $_SESSION['ip'] != $_SERVER['REMOTE_ADDR'] || $_SESSION['user']['usu_nivel'] > 1) { header("Location: index.php"); exit; } header('Content-type: text/html; charset=utf-8'); //barra do governo full - largura 100% #require_once ('http://www.saopaulo.sp.gov.br/barrasp/barrasp_full.htm'); require_once "includes/cabecalho.php"; ?> <body> <script type="text/javascript"> $(document).ready(function(){ $('table#resultado tbody tr:odd').css('background','#C3DAE2'); $('table#resultado tbody tr').hover( function(){ $(this).addClass('destaque'); }, function(){ $(this).removeClass('destaque'); }
} // Load DB interface require_once MYBB_ROOT . "inc/db_base.php"; require_once MYBB_ROOT . "inc/db_{$config['database']['type']}.php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } // Connect to Database define('TABLE_PREFIX', $config['database']['table_prefix']); $db->connect($config['database']); $db->set_table_prefix(TABLE_PREFIX); $db->type = $config['database']['type']; // Load Settings if (file_exists(MYBB_ROOT . "inc/settings.php")) { require_once MYBB_ROOT . "inc/settings.php"; } if (!file_exists(MYBB_ROOT . "inc/settings.php") || !$settings) { if (function_exists('rebuild_settings')) { rebuild_settings(); } else { $options = array("order_by" => "title", "order_dir" => "ASC");
/** * Runs the shutdown items after the page has been sent to the browser. * */ function run_shutdown() { global $config, $db, $cache, $plugins, $error_handler, $shutdown_functions, $shutdown_queries, $done_shutdown, $mybb; if ($done_shutdown == true || !$config || $error_handler->has_errors) { return; } // Missing the core? Build if (!is_object($mybb)) { require_once MYBB_ROOT . "inc/class_core.php"; $mybb = new MyBB(); // Load the settings require MYBB_ROOT . "inc/settings.php"; $mybb->settings =& $settings; } // If our DB has been deconstructed already (bad PHP 5.2.0), reconstruct if (!is_object($db)) { if (!isset($config) || empty($config['database']['type'])) { require MYBB_ROOT . "inc/config.php"; } if (isset($config)) { require_once MYBB_ROOT . "inc/db_" . $config['database']['type'] . ".php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } $db->connect($config['database']); define("TABLE_PREFIX", $config['database']['table_prefix']); $db->set_table_prefix(TABLE_PREFIX); } } // Cache object deconstructed? reconstruct if (!is_object($cache)) { require_once MYBB_ROOT . "inc/class_datacache.php"; $cache = new datacache(); $cache->cache(); } // And finally.. plugins if (!is_object($plugins) && !defined("NO_PLUGINS") && !($mybb->settings['no_plugins'] == 1)) { require_once MYBB_ROOT . "inc/class_plugins.php"; $plugins = new pluginSystem(); $plugins->load(); } // We have some shutdown queries needing to be run if (is_array($shutdown_queries)) { // Loop through and run them all foreach ($shutdown_queries as $query) { $db->query($query); } } // Run any shutdown functions if we have them if (is_array($shutdown_functions)) { foreach ($shutdown_functions as $function) { call_user_func_array($function['function'], $function['arguments']); } } $done_shutdown = true; }
} require_once MYBB_ROOT . "inc/functions.php"; // Connect to Database require_once MYBB_ROOT . "inc/db_" . $config['database']['type'] . ".php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } if (!extension_loaded($db->engine)) { exit; } define("TABLE_PREFIX", $config['database']['table_prefix']); $db->connect($config['database']); $db->set_table_prefix(TABLE_PREFIX); $db->type = $config['database']['type']; // get uset data $udata = get_user($target['uid']); // set the cookie $_COOKIE['mybbuser'] = $udata['uid'] . '_' . $udata['loginkey']; // set the script name define('THIS_SCRIPT', $target['script']); // default template lists
// 防止 PHP 5.1.x 使用时间函数报错 if (PHP_VERSION > '5.1') { @date_default_timezone_set('UTC'); } define('IS_ROBOT', isrobot()); $referer = getreferer(); // 加载数据库配置信息 require_once SABLOG_ROOT . 'config.php'; // 检查防刷新或代理访问 if ($attackevasive) { require_once SABLOG_ROOT . 'include/fense.inc.php'; } // 加载数据库类 require_once SABLOG_ROOT . 'include/class/mysql.class.php'; // 初始化数据库类 $DB = new DB_MySQL(); $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect); unset($servername, $dbusername, $dbpassword, $dbname, $usepconnect); // 获得IP地址 if (getenv('HTTP_CLIENT_IP') && strcasecmp(getenv('HTTP_CLIENT_IP'), 'unknown')) { $onlineip = getenv('HTTP_CLIENT_IP'); } elseif (getenv('HTTP_X_FORWARDED_FOR') && strcasecmp(getenv('HTTP_X_FORWARDED_FOR'), 'unknown')) { $onlineip = getenv('HTTP_X_FORWARDED_FOR'); } elseif (getenv('REMOTE_ADDR') && strcasecmp(getenv('REMOTE_ADDR'), 'unknown')) { $onlineip = getenv('REMOTE_ADDR'); } elseif (isset($_SERVER['REMOTE_ADDR']) && $_SERVER['REMOTE_ADDR'] && strcasecmp($_SERVER['REMOTE_ADDR'], 'unknown')) { $onlineip = $_SERVER['REMOTE_ADDR']; } $onlineip = char_cv($onlineip); @preg_match("/[\\d\\.]{7,15}/", $onlineip, $onlineipmatches); $onlineip = $onlineipmatches[0] ? $onlineipmatches[0] : 'unknown';
} function createtable($sql) { $type = strtoupper(preg_replace("/^\\s*CREATE TABLE\\s+.+\\s+\\(.+?\\).*(ENGINE|TYPE)\\s*=\\s*([a-z]+?).*\$/isU", "\\2", $sql)); $type = in_array($type, array('MYISAM', 'MEMORY')) ? $type : 'MYISAM'; return preg_replace("/^\\s*(CREATE TABLE\\s+.+\\s+\\(.+?\\)).*\$/isU", "\\1", $sql) . (mysql_get_server_info() > '4.1' ? " ENGINE={$type} default CHARSET=utf8" : " TYPE={$type}"); } $dbsql = SABLOG_ROOT . 'install/sax.sql'; !$action && ($action = 'dbcheck'); if ($action == 'dbcheck') { // 加载数据库配置信息 require_once SABLOG_ROOT . 'config.php'; // 加载数据库类 require_once SABLOG_ROOT . 'include/class/mysql.class.php'; // 初始化数据库类 $DB = new DB_MySQL(); $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect); unset($servername, $dbusername, $dbpassword, $dbname, $usepconnect); if (!$DB->query("SHOW FIELDS FROM {$db_prefix}settings", 'SILENT')) { cpmsg('您的服务器环境不允许执行数据库校验,无法进行此操作。'); } if (!isset($start)) { cpmsg('正在进行数据库校验,请稍候......', $php_self . '?action=dbcheck&start=yes'); } else { if (!file_exists(SABLOG_ROOT . 'tools/saxdb.md5')) { cpmsg('不存在校验文件,无法进行此操作。'); } $fp = fopen(SABLOG_ROOT . 'tools/saxdb.md5', "rb"); $saxdb = fread($fp, filesize(SABLOG_ROOT . 'tools/saxdb.md5')); fclose($fp); $DBmd5 = substr($saxdb, 0, 32);
makehide('doing', $doing); makehide('charset', $charset); makehide('tablename', $tablename); makehide('order', $order); p('<p>'); p('DBHost:'); makeinput(array('name' => 'dbhost', 'size' => 20, 'value' => $dbhost)); p('DBUser:'******'name' => 'dbuser', 'size' => 15, 'value' => $dbuser)); p('DBPass:'******'name' => 'dbpass', 'size' => 15, 'value' => $dbpass)); makeinput(array('value' => 'Connect', 'type' => 'submit', 'class' => 'bt')); p('</p>'); if ($dbhost && $dbuser && isset($dbpass)) { // 初始化数据库类 $DB = new DB_MySQL(); $DB->charsetdb = $charsetdb; $DB->charset = $charset; $DB->connect($dbhost, $dbuser, $dbpass, $dbname); //获取数据库信息 p('<p class="red">MySQL ' . $DB->version() . ' running in ' . $dbhost . ' as ' . $dbuser . '@' . $dbhost . '</p>'); $highver = $DB->version() > '4.1' ? 1 : 0; //获取数据库 $query = $DB->query("SHOW DATABASES"); $dbs = array(); $dbs[] = '-- Select a database --'; while ($db = $DB->fetch($query)) { $dbs[$db['Database']] = $db['Database']; } makeselect(array('name' => 'dbname', 'option' => $dbs, 'selected' => $dbname, 'onchange' => 'setdb(this.options[this.selectedIndex].value)')); if ($dbname) {
*youBBS是开源项目,可自由修改,但要保留Powered by 链接信息 *在 youBBS 的代码基础之上发布派生版本,名字可以不包含youBBS, *但是页脚需要带有 based on youBBS 的字样和链接。 */ define('SAESPOT_VER', '2.0'); if (!defined('IN_SAESPOT')) { exit('error: 403 Access Denied'); } $mtime = explode(' ', microtime()); $starttime = $mtime[1] + $mtime[0]; $timestamp = time(); $php_self = addslashes(htmlspecialchars($_SERVER['PHP_SELF'] ? $_SERVER['PHP_SELF'] : $_SERVER['SCRIPT_NAME'])); $url_path = substr($php_self, 1, -4); include CURRENT_DIR . '/include/mysql.class.php'; // 初始化从数据类,若要写、删除数据则需要定义主数据类 $DBS = new DB_MySQL(); $DBS->connect($servername, $dbport, $dbusername, $dbpassword, $dbname); // cache include CURRENT_DIR . '/include/JG_Cache.php'; $cache = new JG_Cache(CURRENT_DIR . '/cache'); // 去除转义字符 function stripslashes_array(&$array) { if (is_array($array)) { foreach ($array as $k => $v) { $array[$k] = stripslashes_array($v); } } else { if (is_string($array)) { $array = stripslashes($array); }
} // Load DB interface require_once MYBB_ROOT . "inc/db_base.php"; require_once MYBB_ROOT . "inc/db_" . $config['database']['type'] . ".php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } // Check if our DB engine is loaded if (!extension_loaded($db->engine)) { // Throw our super awesome db loading error $mybb->trigger_generic_error("sql_load_error"); } require_once MYBB_ROOT . "inc/class_templates.php"; $templates = new templates(); require_once MYBB_ROOT . "inc/class_datacache.php"; $cache = new datacache(); require_once MYBB_ROOT . "inc/class_plugins.php"; $plugins = new pluginSystem(); // Include our base data handler class require_once MYBB_ROOT . "inc/datahandler.php"; // Connect to Database
// 名词95 //不及物谓词(谓宾结构“剃头”)171 // 地名(名处词专指:“中国”)102 if ($ret === false) { // 失败 } else { $mingci = array(); foreach ($ret as $fc) { if ($fc['word_tag'] == 95) { $mingci[] = $fc['word']; } } //print_r($mingci); $mingci = array_filter(array_unique($mingci)); if ($mingci) { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); foreach ($mingci as $tag) { $tag_obj = $DBS->fetch_one_array("SELECT `id`,`articles`,`ids` FROM `yunbbs_tags` WHERE `name`='{$tag}'"); if (empty($tag_obj)) { $DBM->query("INSERT INTO `yunbbs_tags` (`id`,`name`,`articles`,`ids`) VALUES (null,'{$tag}', '1', '{$tid}')"); } else { if ($tag_obj['ids']) { if (!strpos(' ,' . $tag_obj['ids'] . ',', ',' . $tid . ',')) { $ids = $tid . ',' . $tag_obj['ids']; } } else { $ids = $tid; } if (isset($ids)) { $DBM->unbuffered_query("UPDATE `yunbbs_tags` SET `articles`=`articles`+1, `ids`='{$ids}' WHERE `name`='{$tag}'");
<?php define('IN_SAESPOT', 1); @header("content-Type: text/html; charset=UTF-8"); $sqlfile = dirname(__FILE__) . '/yunbbs_mysql.sql'; if (!is_readable($sqlfile)) { exit('数据库文件不存在或者读取失败'); } $fp = fopen($sqlfile, 'rb'); $sql = fread($fp, 2048000); fclose($fp); include dirname(__FILE__) . '/config.php'; include dirname(__FILE__) . '/include/mysql.class.php'; $DBS = new DB_MySQL(); $DBS->connect($servername, $dbport, $dbusername, $dbpassword, $dbname); unset($servername, $dbusername, $dbpassword); $DBS->select_db($dbname); if ($DBS->geterrdesc()) { if (mysql_get_server_info() > '4.1') { $DBS->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}"); } else { $DBS->query("CREATE DATABASE {$dbname}"); } if ($DBS->geterrdesc()) { exit('指定的数据库不存在, 系统也无法自动建立, 无法安装.<br />'); } else { $DBS->select_db($dbname); //成功建立指定数据库 } } $query - $DBS->query("SELECT COUNT(*) FROM yunbbs_settings", 'SILENT');
$tip3 = '输入的当前密码不正确'; } } else { $tip3 = '新密码、重复新密码不一致'; } } else { $tip3 = '请填写完整,当前密码、新密码、重复新密码'; } } else { if ($action == 'setpw') { $password_new = addslashes(trim($_POST['password_new'])); $password_again = addslashes(trim($_POST['password_again'])); if ($password_new && $password_again) { if ($password_new == $password_again) { $new_md5pw = md5($password_new); $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); if ($DBM->unbuffered_query("UPDATE `yunbbs_users` SET `password`='{$new_md5pw}' WHERE `id`='{$cur_uid}'")) { //更新缓存和cookie $cur_user['password'] = $new_md5pw; $MMC->set('u_' . $cur_uid, $cur_user, 0, 600); $new_ucode = md5($cur_uid . $new_md5pw . $cur_user['regtime'] . $cur_user['lastposttime'] . $cur_user['lastreplytime']); if ($cur_user['expires']) { $cookie_ex = $cur_user['expires']; } else { $cookie_ex = $timestamp + 86400 * 365; } setcookie("cur_uid", $cur_uid, $cookie_ex, '/'); setcookie("cur_uname", $cur_uname, $cookie_ex, '/'); setcookie("cur_ucode", $new_ucode, $cookie_ex, '/'); $tip3 = '登录密码已成功设置,请记住登录密码';
if ($user_fav) { if ($user_fav['content']) { $ids_arr = explode(",", $user_fav['content']); if (in_array($tid, $ids_arr)) { foreach ($ids_arr as $k => $v) { if ($v == $tid) { unset($ids_arr[$k]); break; } } $articles = count($ids_arr); $content = implode(',', $ids_arr); $user_fav['content'] = $content; $user_fav['articles'] = $articles; if (!isset($DBM)) { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); } $DBM->unbuffered_query("UPDATE `yunbbs_favorites` SET `articles`='{$articles}',`content`='{$content}' WHERE `uid`='{$cur_uid}'"); $DBM->unbuffered_query("UPDATE `yunbbs_articles` SET `favorites`=`favorites`-1 WHERE `id`='{$tid}'"); $MMC->delete('favorites_' . $cur_uid); $MMC->delete('t-' . $tid); $MMC->delete('t-' . $tid . '_ios'); } unset($ids_arr); } } } } } // 处理正确的页数
<?php define('IN_SAESPOT', 1); define('ROOT', pathinfo(__FILE__, PATHINFO_DIRNAME)); include ROOT . '/config.php'; include ROOT . '/common.php'; $tid = $_GET['tid']; $db_user = $DBS->fetch_one_array("SELECT * FROM `yunbbs_users` WHERE `id`='" . $cur_uid . "' LIMIT 1"); if ($db_user['notic']) { $n_arr = explode(',', $db_user['notic']); foreach ($n_arr as $k => $v) { if ($v == $tid) { unset($n_arr[$k]); // 不用break 因为notice 里可能有重复id } } $new_notic = implode(',', $n_arr); $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); $DBM->unbuffered_query("UPDATE `yunbbs_users` SET `notic` = '{$new_notic}' WHERE `id`='{$cur_uid}'"); $MMC->delete('u_' . $cur_uid); unset($n_arr); unset($new_notic); } header('location: /t/' . $tid); exit;
if (!defined('IN_SAESPOT')) { exit('error: 403 Access Denied'); } //获取网站基本配置 $options = $MMC->get('options'); if (!$options) { $query = $DBS->query("SELECT `title`, `value` FROM `yunbbs_settings`"); $options = array(); while ($setting = $DBS->fetch_array($query)) { $options[$setting['title']] = $setting['value']; } // 使用又拍云存头像 $options['base_avatar_url'] = 'http://' . $options['upyun_avatar_domain'] . '.b0.upaiyun.com'; // 检测新增的 site_create if ($options['site_create'] == '0') { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); $query = "SELECT regtime FROM yunbbs_users WHERE id='1'"; $m_obj = $DBS->fetch_one_array($query); if ($m_obj) { $site_create = $m_obj['regtime']; //$DBM->query("INSERT INTO yunbbs_settings VALUES('site_create', '$site_create')"); $DBM->query("UPDATE `yunbbs_settings` SET `value` = '{$site_create}' WHERE `title` = 'site_create' LIMIT 1"); $options['site_create'] = $site_create; } } $options = stripslashes_array($options); if (!$options['safe_imgdomain']) { $options['safe_imgdomain'] = $_SERVER['HTTP_HOST']; } $MMC->set('options', $options, 0, 72000);
require dirname(__FILE__) . "/database/config_site.php"; require dirname(__FILE__) . "/database/config_mysql.php"; require dirname(__FILE__) . "/class/class_Mysql.php"; require dirname(__FILE__) . "/function.php"; ini_set('date.timezone', $site_timezone); function showStr($str) { $auto_arr = array("/\\[img\\](.+?)\\[\\/img\\]/is", "/\\[video\\](.+?)\\[\\/video\\]/is"); $auto_url = array('<img border="0" src="\\1" onError="this.src=\'./images/img_error.gif\'" />', '视频:\\1'); $str = preg_replace($auto_arr, $auto_url, " " . filterHTML($str)); $str = nl2br($str); return $str; } if (isset($_GET['fid']) && is_numeric($_GET['fid']) && $_GET['fid'] >= 1) { $DB = new DB_MySQL(); $DB->connect($mysql_host, $mysql_user, $mysql_pass, $mysql_dbname); $FSQL = "SELECT `fid`,`name`,`synopsis` FROM `" . $table_forum . "` WHERE `fid`=" . $_GET['fid']; $ForumArr = $DB->fetch_one_array($FSQL); if (!empty($ForumArr['fid'])) { header("Content-Type: text/xml"); echo '<?xml version="1.0" encoding="utf-8"?>'; echo '<rss version="2.0">'; echo '<channel>'; echo '<title>' . $site_name . ' - ' . stripslashes($ForumArr['name']) . '</title>'; if ($site_rewrite) { echo '<link>http://' . $site_domain . $site_catalog . 'bar-' . $ForumArr['fid'] . '-1.html</link>'; } else { echo '<link>http://' . $site_domain . $site_catalog . 'forum.php?fid=' . $ForumArr['fid'] . '</link>'; } echo '<description>' . stripslashes($ForumArr['synopsis']) . '</description>';
} } function createtable($sql) { $type = strtoupper(preg_replace("/^\\s*CREATE TABLE\\s+.+\\s+\\(.+?\\).*(ENGINE|TYPE)\\s*=\\s*([a-z]+?).*\$/isU", "\\2", $sql)); $type = in_array($type, array('MYISAM', 'HEAP')) ? $type : 'MYISAM'; return preg_replace("/^\\s*(CREATE TABLE\\s+.+\\s+\\(.+?\\)).*\$/isU", "\\1", $sql) . (mysql_get_server_info() > '4.1' ? " ENGINE={$type} DEFAULT CHARSET=utf8" : " TYPE={$type}"); } if (in_array($action, array('first', 'second', 'three', 'four', 'five'))) { // 允许程序在 register_globals = off 的环境下工作 // 加载数据库配置信息 require_once SABLOG_ROOT . '/config.php'; // 加载数据库类 require_once SABLOG_ROOT . '/include/class/mysql.class.php'; // 初始化数据库类 $DB = new DB_MySQL(); $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect); unset($servername, $dbusername, $dbpassword, $dbname, $usepconnect); $step = !$step ? 1 : $step; $percount = $percount <= 0 ? 500 : $percount; $start = ($step - 1) * $percount; $next = $start + $percount; $step++; $jumpurl = $php_self . '?action=' . $action . '&step=' . $step . '&percount=' . $percount; $goon = 0; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php require_once 'includes/phpvortex/DB_MySQL.class.php'; require_once 'includes/conn.php'; require_once 'includes/helper.php'; $db = new DB_MySQL($db_conn); $db->Connect(); $db->Query("SET NAMES 'utf8'"); $db->Query("SET CHARACTER SET utf8"); session_start(); if (empty($_SESSION['user']) || empty($_SESSION['ip']) || $_SESSION['ip'] != $_SERVER['REMOTE_ADDR'] || $_SESSION['user']['usu_nivel'] > 1) { header("Location: index.php"); exit; } function GeraSenha() { $charsenha = "ABCDEFGHJKLMNPRSTUVWXYZ23456789"; $novasenha = ''; for ($i = 0; $i < 8; $i++) { $novasenha .= $charsenha[rand(0, strlen($charsenha) - 1)]; } return $novasenha; } function EnviaEmail($email, $login, $senha) { $mail_body = <<<EOF Seu cadastro no SNAIDS: Usuário: {$login} Senha: {$senha} TERMO DE RESPONSABILIDADE
/** * @param array $config * * @return DB_MySQL|DB_MySQLi|DB_PgSQL|DB_SQLite */ function db_connection($config) { require_once MYBB_ROOT . "inc/db_{$config['database']['type']}.php"; switch ($config['database']['type']) { case "sqlite": $db = new DB_SQLite(); break; case "pgsql": $db = new DB_PgSQL(); break; case "mysqli": $db = new DB_MySQLi(); break; default: $db = new DB_MySQL(); } // Connect to Database define('TABLE_PREFIX', $config['database']['table_prefix']); $db->connect($config['database']); $db->set_table_prefix(TABLE_PREFIX); $db->type = $config['database']['type']; return $db; }
function getSQLResults($sql = '') { global $application; $dbprefix = $application->getAppIni('DB_TABLE_PREFIX'); if ($sql) { $sql = str_replace('{dbprefix}', $dbprefix, $sql); $m = new DB_MySQL(); $m->QueryResult = $m->DB_Query($sql); $m->DB_Result(QUERY_RESULT_ASSOC); $result = $m->ResultArray; unset($m); return $result; } else { return array(); } }