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); }