$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'); if (!$DBS->geterrdesc()) { header('location: /'); exit('数据已经装好了, 不能重复安装, 若要重装,先删除mysql 里全部数据。 <a href="/">现在直接进入首页</a><br />'); }
$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 $db_ucode = md5($new_uid . $pwmd5 . $timestamp . '00'); $cur_uid = $new_uid; setcookie("cur_uid", $cur_uid, $timestamp + 86400 * 365, '/'); setcookie("cur_uname", $name, $timestamp + 86400 * 365, '/'); setcookie("cur_ucode", $db_ucode, $timestamp + 86400 * 365, '/'); header('location: /'); exit;
$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); $saxdb = unserialize(substr($saxdb, 34)); $settingsdata = $saxdb[1]; $saxdb = $saxdb[0][0];
makeinput(array('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) { p('<p>Current dababase: <a href="javascript:setdb(\'' . $dbname . '\');">' . $dbname . '</a>'); if ($tablename) { p(' | Current Table: <a href="javascript:settable(\'' . $tablename . '\');">' . $tablename . '</a> [ <a href="javascript:settable(\'' . $tablename . '\', \'structure\');">Structure</a> ]'); } p('</p>'); $sql_query = isset($P['sql_query']) ? $P['sql_query'] : ''; if ($tablename && !$sql_query) { $sql_query = "SELECT * FROM {$tablename} LIMIT 0, 30";
function mysqlconn($configfile) { include $configfile; //包含配置文件,并使用它连接数据库 include 'func_db_mysql.php'; $DB = new DB_MySQL(); $quit = False; //创建一个新的数据库对象 $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect, $dbcharset); unset($servername, $dbusername, $dbpassword, $usepconnect); //销毁变量 $curr_php_version = PHP_VERSION; //PHP的版本 if ($curr_php_version < '4.0.6') { echo "<font color=\"#FF0000\">由于您的PHP版本过低, 无法继续安装 ,请更换版本大于4.0.6的PHP版本。3秒后返回配置页面</font></br>"; echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>"; echo "<meta http-equiv='refresh' content='3; url=setting.php'>"; exit; } $query = $DB->query("SELECT VERSION()"); //查询mysql版本信息 $curr_mysql_version = $DB->result($query, 0); if ($curr_mysql_version < '3.23') { //mysql版本< 3.23 echo "<font color=\"#FF0000\">您的MySQL版本低于3.23, 无法继续安装 ,建议您换 MySQL4 的数据库服务器。3秒后返回配置页面</font></br>"; echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>"; echo "<meta http-equiv='refresh' content='3; url=setting.php'>"; exit; } /**************执行建立数据库***************/ $DB->query("DROP DATABASE IF EXISTS {$dbname}"); if (mysql_get_server_info() > '4.1') { $DB->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}"); } else { $DB->query("CREATE DATABASE {$dbname}"); } $DB->select_db($dbname); $tablenum = '0'; runquery($sqlfile, $DB, $db_prefix, $tablenum = '0', $dbcharset); //执行SQL 语句 }
echo '<link>http://' . $site_domain . $site_catalog . 'forum.php?fid=' . $ForumArr['fid'] . '</link>'; } echo '<description>' . stripslashes($ForumArr['synopsis']) . '</description>'; echo '<copyright>Copyright(C) PhpSay</copyright>'; echo '<generator>AlanZhu</generator>'; echo '<lastBuildDate>' . date('r') . '</lastBuildDate>'; echo '<ttl>120</ttl>'; echo '<image>'; echo '<url>http://' . $site_domain . $site_catalog . 'images/slogo.gif</url>'; echo '<title>' . $site_name . '</title>'; echo '<link>http://' . $site_domain . $site_catalog . '</link>'; echo '</image>'; $TSQL = "SELECT I.`tid`,I.`author`,I.`subject`,I.`dateline`,T.`message` FROM `" . $table_post . "` I "; $TSQL .= "LEFT JOIN `" . $table_post2 . "` T ON I.`pid`=T.`pid` "; $TSQL .= "WHERE I.`fid`=" . $ForumArr['fid'] . " AND I.`replyfloor`=0 ORDER BY I.`pid` DESC LIMIT 50"; $Result = $DB->query($TSQL); while ($Re = $DB->fetch_array($Result)) { echo '<item>'; echo '<title>' . filterHTML($Re['subject']) . '</title>'; if ($site_rewrite) { echo '<link>http://' . $site_domain . $site_catalog . 'topic-' . $Re['tid'] . '-1.html</link>'; } else { echo '<link>http://' . $site_domain . $site_catalog . 'topic.php?tid=' . $Re['tid'] . '</link>'; } echo '<description><![CDATA[' . showStr($Re['message']) . ']]></description>'; echo '<category>' . stripslashes($ForumArr['name']) . '</category>'; echo '<author>' . stripslashes($Re['author']) . '</author>'; echo '<pubDate>' . date('r', $Re['dateline']) . '</pubDate>'; echo '</item>'; } echo '</channel>';
$_POST = sax_stripslashes($_POST); $_COOKIE = sax_stripslashes($_COOKIE); } if ($_POST['sax_cookie_auth']) { list($sax_uid, $sax_pw, $sax_logincount) = explode("\t", authcode($_POST['sax_cookie_auth'], 'DECODE')); } else { list($sax_uid, $sax_pw, $sax_logincount) = $_COOKIE['sax_auth'] ? explode("\t", authcode($_COOKIE['sax_auth'], 'DECODE')) : array('', '', 0); } $sax_uid = (int) $sax_uid; $sax_pw = sax_addslashes($sax_pw); $sax_logincount = (int) $sax_logincount; $sax_group = 4; $_EVO = array(); $seccode = 0; if ($sax_uid) { $query = $DB->query("SELECT userid AS sax_uid, username AS sax_user, password AS sax_pw, groupid AS sax_group, logincount AS sax_logincount, email as sax_email, url as sax_url, lastpost, lastip, lastvisit, lastactivity\r\n\t\tFROM {$db_prefix}users\r\n\t\tWHERE userid='{$sax_uid}' AND password='******' AND logincount='{$sax_logincount}'"); $_EVO = $DB->fetch_array($query); if (!$_EVO) { dcookies(); } } @extract($_EVO); $lastvisit = !$lastvisit ? $timestamp : $lastvisit; if (!$sax_uid || !$sax_user) { $sax_uid = $sax_logincount = 0; $sax_user = ''; $sax_group = 6; } if ($sax_group == 1) { error_reporting(7); }
PRIMARY KEY (mid), KEY slug (slug), KEY displayorder (displayorder) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS {$db_prefix}relationships; CREATE TABLE {$db_prefix}relationships ( cid mediumint(8) unsigned NOT NULL DEFAULT '0', mid mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (cid,mid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; EOT; //添加新表 runquery($add); $query = $DB->query("SELECT cid, name, displayorder FROM {$db_prefix}categories"); while ($cate = $DB->fetch_array($query)) { $DB->query("INSERT INTO {$db_prefix}metas (name, type, displayorder) VALUES ('" . addslashes($cate['name']) . "', 'category', '" . addslashes($cate['displayorder']) . "')"); $mid = $DB->insert_id(); $articles = $DB->query("SELECT articleid, visible FROM {$db_prefix}articles WHERE cid='" . $cate['cid'] . "'"); while ($article = $DB->fetch_array($articles)) { $r = $DB->fetch_one_array("SELECT cid FROM {$db_prefix}relationships WHERE mid='{$mid}' LIMIT 1"); if (!$r) { $DB->query("INSERT INTO {$db_prefix}relationships (cid,mid) VALUES ('" . $article['articleid'] . "', '{$mid}')"); } else { if ($article['articleid'] != $r['cid']) { $DB->query("INSERT INTO {$db_prefix}relationships (cid,mid) VALUES ('" . $article['articleid'] . "', '{$mid}')"); } } if ($article['visible']) { $DB->unbuffered_query("UPDATE {$db_prefix}metas SET count=count+1 WHERE mid='{$mid}' AND type='category'");
if (!$l_obj) { header('location: /admin-link-list'); 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 == 'add') { $n_name = trim($_POST['name']); $n_url = trim($_POST['url']); if ($n_name && $n_url) { if ($DBM->query("INSERT INTO `yunbbs_links` (`id`,`name`,`url`) VALUES (null,'{$n_name}','{$n_url}')")) { //更新缓存 $MMC->delete('site_links'); $tip1 = '已成功添加'; } else { $tip1 = '数据库更新失败,修改尚未保存,请稍后再试'; } } else { $tip1 = '链接名 和 网址 不能留空'; } } else { if ($action == 'edit') { $n_name = trim($_POST['name']); $n_url = trim($_POST['url']); if ($n_name && $n_url) { if ($DBM->unbuffered_query("UPDATE `yunbbs_links` SET `name`='{$n_name}',`url`='{$n_url}' WHERE `id`='{$lid}'")) {
} else { $errors[] = '用户名 太长了'; } } else { $errors[] = '用户名 必填'; } // if (!$errors) { $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`,`expires`) VALUES (null,'{$name}', {$flag}, '', {$timestamp}, " . $_SESSION["expires"] . ")"); $new_uid = $DBM->insert_id(); $MMC->delete('site_infos'); // update qqweibo $DBM->unbuffered_query("UPDATE `yunbbs_weibo` SET `uid` = '{$new_uid}' WHERE `openid`='{$openid}'"); //设置cookie $db_ucode = md5($new_uid . '' . $timestamp . '00'); $cur_uid = $new_uid; setcookie("cur_uid", $cur_uid, $timestamp + 86400 * 365, '/'); setcookie("cur_uname", $name, $timestamp + 86400 * 365, '/'); setcookie("cur_ucode", $db_ucode, $timestamp + 86400 * 365, '/'); $gotohome = "1"; $getavatar = "1"; //header('location: /'); //exit; }
$_SESSION["nick"] = $user_info['nickname']; $_SESSION["avatar"] = $user_info['figureurl_2']; // 尝试获取微博信息 if (strpos(' ' . $_SESSION["scope"], 'get_info')) { $user_info2 = get_info(); if ($user_info2['data']['name']) { $name = $user_info2['data']['name']; } if ($user_info2['data']['head']) { $_SESSION["avatar"] = $user_info2['data']['head'] . '/100'; } } } else { echo 'no info scope'; exit; } // 获取QQ 空间信息 结束 if ($db_openid) { if ($db_openid['uid']) { // pass } else { header("Location:/qqsetname"); exit; } } else { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); $DBM->query("INSERT INTO `yunbbs_qqweibo` (`id`,`uid`,`name`,`openid`,`token`,`expires`) VALUES (null,'0','{$name}', '{$openid}', '" . $cb["access_token"] . "', '" . $expires . "')"); header("Location:/qqsetname"); exit; }
} elseif ($step == '5') { $username = addslashes(trim($_POST['username'])); $password = $_POST['password']; $email = addslashes(trim($_POST['email'])); ?> <h2>第五步:导入数据</h2> <p> <?php include $configfile; include '../include/class/mysql.class.php'; $DB = new DB_MySQL(); $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect); unset($servername, $dbusername, $dbpassword, $usepconnect); runquery($sql); $today = gmdate('Y-m-d', time() + 8 * 3600); $DB->query("INSERT INTO {$db_prefix}users (username, password, email, groupid) VALUES ('{$username}', '" . md5($password) . "', '{$email}', '1')"); ?> </p> <p>共创建了<?php echo $tablenum; ?> 个数据表.</p> <hr noshade="noshade" /> <p>安装程序已经顺利执行完毕,请尽快删除整个 install 目录,以免被他人恶意利用。</p> <p>感谢您使用Sa系列Web应用程序.</p> <p> </p> <p>用户名: <span style="color:#f00;"><?php echo $username; ?> </span></p> <p>密码: <span style="color:#f00;"><?php
$DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); // spam_words if ($options['spam_words'] && $cur_user['flag'] < 99) { $spam_words_arr = explode(",", $options['spam_words']); $check_con = ' ' . $c_content; foreach ($spam_words_arr as $spam) { if (strpos($check_con, $spam)) { // has spam word $DBM->unbuffered_query("UPDATE `yunbbs_users` SET `flag`='0' WHERE `id`='{$cur_uid}'"); $MMC->delete('u_' . $cur_uid); exit('403: dont post any spam.'); } } } $c_content = htmlspecialchars($c_content); $DBM->query("INSERT INTO `yunbbs_comments` (`id`,`articleid`,`uid`,`addtime`,`content`) VALUES (null,{$tid}, {$cur_uid}, {$timestamp}, '{$c_content}')"); $new_rid = $DBM->insert_id(); $DBM->unbuffered_query("UPDATE `yunbbs_articles` SET `ruid`='{$cur_uid}',`edittime`='{$timestamp}',`comments`=`comments`+1 WHERE `id`='{$tid}'"); $DBM->unbuffered_query("UPDATE `yunbbs_users` SET `replies`=`replies`+1,`lastreplytime`='{$timestamp}' WHERE `id`='{$cur_uid}'"); // 更新u_code $new_ucode = md5($cur_uid . $cur_user['password'] . $cur_user['regtime'] . $cur_user['lastposttime'] . $timestamp); 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, '/'); $MMC->delete('u_' . $cur_uid); // del cache
$DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); } $DBM->unbuffered_query("UPDATE `yunbbs_favorites` SET `articles`='1',`content`='{$tid}' 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'); } } else { if (!isset($DBM)) { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); } $user_fav = array('id' => '', 'uid' => $cur_uid, 'articles' => 1, 'content' => $tid); $DBM->query("INSERT INTO `yunbbs_favorites` (`id`,`uid`,`articles`,`content`) VALUES (null,'{$cur_uid}','1','{$tid}')"); $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'); } } else { if ($act == 'del') { // 删除 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]);
/** * 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; }
$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); unset($setting); $DBS->free_result($query); } //获取链接 function get_links() { global $MMC;
} 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}'"); } } } // $tags = implode(",", $mingci);
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 . "'"); if ($check_obj) { $tip1 = $n_name . ' 分类名已存在,请修改为不同的分类名'; } else { if ($DBM->query("INSERT INTO `yunbbs_categories` (`id`,`name`,`about`) VALUES (null,'{$n_name}','{$n_about}')")) { //更新缓存 $MMC->delete('newest_nodes'); $MMC->delete('bot_nodes'); $MMC->delete('site_infos'); $tip1 = '已成功添加'; } else { $tip1 = '数据库更新失败,修改尚未保存,请稍后再试'; } } } else { $tip1 = '分类名不能留空'; } } else { if ($action == 'edit') { $n_name = trim($_POST['name']);
echo '403: spam info forbidden.'; exit; } } if ($timestamp - $cur_user['lastposttime'] > $options['article_post_space']) { if ($p_title) { if (mb_strlen($p_title, 'utf-8') <= $options['article_title_max_len'] && mb_strlen($p_content, 'utf-8') <= $options['article_content_max_len']) { $conmd5 = md5($p_title . $p_content); if ($MMC->get('cm_' . $conmd5)) { $tip = '请勿发布相同的内容 或 灌水'; } else { $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); $p_title = htmlspecialchars($p_title); $p_content = htmlspecialchars($p_content); $DBM->query("INSERT INTO `yunbbs_articles` (`id`,`cid`,`uid`,`title`,`content`,`addtime`,`edittime`) VALUES (null,{$cid},{$cur_uid}, '{$p_title}', '{$p_content}', {$timestamp}, {$timestamp})"); $new_aid = $DBM->insert_id(); $DBM->unbuffered_query("UPDATE `yunbbs_categories` SET `articles`=`articles`+1 WHERE `id`='{$cid}'"); $DBM->unbuffered_query("UPDATE `yunbbs_users` SET `articles`=`articles`+1, `lastposttime`={$timestamp} WHERE `id`='{$cur_uid}'"); // 更新u_code $cur_user['lastposttime'] = $timestamp; // $MMC->delete('u_' . $cur_uid); $new_ucode = md5($cur_uid . $cur_user['password'] . $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, '/');