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'");
}
}
}
echo '<div class="install_main">';
echo '<p class="p2">成功重建所有分类数据</p><p class="p2"><a href="' . $php_self . '?action=second">程序将自动跳转.如果没有自动跳转,请点击这里.</a></p>';
echo '<meta HTTP-EQUIV="REFRESH" content="2;URL=' . $php_self . '?action=second">';
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>';
echo '<copyright>Copyright(C) PhpSay</copyright>';
echo '<generator>AlanZhu</generator>';
echo '<lastBuildDate>' . date('r') . '</lastBuildDate>';
@set_magic_quotes_runtime(0);
// 判断 magic_quotes_gpc 状态
if (@get_magic_quotes_gpc()) {
$_GET = stripslashes_array($_GET);
$_POST = stripslashes_array($_POST);
$_COOKIE = stripslashes_array($_COOKIE);
}
// 获取当前用户
$cur_user = null;
$cur_uid = isset($_COOKIE['cur_uid']) ? intval($_COOKIE['cur_uid']) : '';
$cur_uname = isset($_COOKIE['cur_uname']) ? $_COOKIE['cur_uname'] : '';
$cur_ucode = isset($_COOKIE['cur_ucode']) ? $_COOKIE['cur_ucode'] : '';
if ($cur_uname && $cur_uid && $cur_ucode) {
$u_key = 'u_' . $cur_uid;
// 从数据库里读取
$db_user = $DBS->fetch_one_array("SELECT * FROM yunbbs_users WHERE id='" . $cur_uid . "' LIMIT 1");
if ($db_user) {
$db_ucode = md5($db_user['id'] . $db_user['password'] . $db_user['regtime'] . $db_user['lastposttime'] . $db_user['lastreplytime']);
if ($cur_uname == $db_user['name'] && $cur_ucode == $db_ucode) {
//设置cookie
setcookie('cur_uid', $cur_uid, $timestamp + 86400 * 365, '/');
setcookie('cur_uname', $cur_uname, $timestamp + 86400 * 365, '/');
setcookie('cur_ucode', $cur_ucode, $timestamp + 86400 * 365, '/');
$cur_user = $db_user;
unset($db_user);
}
}
}
include CURRENT_DIR . '/model.php';
// 获得散列
function formhash()
@set_magic_quotes_runtime(0);
// 判断 magic_quotes_gpc 状态
if (@get_magic_quotes_gpc()) {
$_GET = stripslashes_array($_GET);
$_POST = stripslashes_array($_POST);
$_COOKIE = stripslashes_array($_COOKIE);
}
// 获取当前用户
$cur_user = null;
$cur_uid = isset($_COOKIE['cur_uid']) ? intval($_COOKIE['cur_uid']) : '';
$cur_uname = isset($_COOKIE['cur_uname']) ? $_COOKIE['cur_uname'] : '';
$cur_ucode = isset($_COOKIE['cur_ucode']) ? $_COOKIE['cur_ucode'] : '';
if ($cur_uname && $cur_uid && $cur_ucode) {
$u_key = 'u_' . $cur_uid;
// 从数据库里读取
$db_user = $DBS->fetch_one_array("SELECT * FROM yunbbs_users WHERE id='" . $cur_uid . "' LIMIT 1");
if ($db_user) {
$db_ucode = md5($db_user['id'] . $db_user['password'] . $db_user['regtime'] . $db_user['lastposttime'] . $db_user['lastreplytime']);
if ($cur_uname == $db_user['name'] && $cur_ucode == $db_ucode) {
//设置cookie
setcookie('cur_uid', $cur_uid, $timestamp + 86400 * 365, '/');
setcookie('cur_uname', $cur_uname, $timestamp + 86400 * 365, '/');
setcookie('cur_ucode', $cur_ucode, $timestamp + 86400 * 365, '/');
$cur_user = $db_user;
unset($db_user);
}
}
// 取出未读私信数量
$db_msg = $DBS->fetch_one_array("SELECT count(1) as count FROM yunbbs_messages WHERE IsRead=0 and ToUID='" . $cur_uid . "'");
if ($db_msg) {
$msg_count = $db_msg['count'];
$cur_ucode = $_COOKIE['cur_ucode'];
// 清空缓存 测试时偶尔会用
//$MMC->flush();
if ($cur_uname && $cur_uid && $cur_ucode) {
$u_key = 'u_' . $cur_uid;
// 尝试从缓存里取出
$mc_user = $MMC->get($u_key);
if ($mc_user) {
$mc_ucode = md5($mc_user['id'] . $mc_user['password'] . $mc_user['regtime'] . $mc_user['lastposttime'] . $mc_user['lastreplytime']);
if ($cur_uname == $mc_user['name'] && $cur_ucode == $mc_ucode) {
$cur_user = $mc_user;
unset($mc_user);
}
} else {
// 从数据库里读取
$db_user = $DBS->fetch_one_array("SELECT * FROM `yunbbs_users` WHERE `id`='" . $cur_uid . "' LIMIT 1");
if ($db_user) {
$db_ucode = md5($db_user['id'] . $db_user['password'] . $db_user['regtime'] . $db_user['lastposttime'] . $db_user['lastreplytime']);
if ($cur_uname == $db_user['name'] && $cur_ucode == $db_ucode) {
//设置缓存和cookie
$MMC->set($u_key, $db_user, 0, 600);
if ($db_user['expires']) {
$cookie_ex = $db_user['expires'];
} else {
$cookie_ex = $timestamp + 86400 * 365;
//$cookie_ex = $timestamp - 86400 * 365;
}
setcookie('cur_uid', $cur_uid, $cookie_ex, '/');
setcookie('cur_uname', $cur_uname, $cookie_ex, '/');
setcookie('cur_ucode', $cur_ucode, $cookie_ex, '/');
$cur_user = $db_user;
<?php
// ========================== 文件说明 ==========================//
// 本文件说明：WAP文章附件缩略图输出
// --------------------------------------------------------------//
// 本程序作者：angel
// --------------------------------------------------------------//
// 本程序版本：SaBlog-X Ver 2.0
// --------------------------------------------------------------//
// 本程序主页：http://www.sablog.net
// ==============================================================//
define('SABLOG_ROOT', substr(dirname(__FILE__), 0, -3));
// 加载数据库配置信息
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);
require_once 'global.php';
require_once SABLOG_ROOT . 'data/cache/cache_settings.php';
$attachid = (int) $_GET['attachid'];
$attachinfo = $DB->fetch_one_array("SELECT at.* FROM {$db_prefix}attachments at LEFT JOIN {$db_prefix}articles ar ON (ar.articleid=at.articleid) WHERE ar.visible='1' AND at.attachmentid='{$attachid}'");
$filepath = SABLOG_ROOT . $options['attachments_dir'] . $attachinfo['filepath'];
if (file_exists($filepath)) {
Thumb_GD($filepath, 200, 200);
}
