using System;
using System.IO;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Xml;
using Discuz.Common;
using Discuz.Forum;
namespace Discuz.Plugin
{
///<summary>
///Discuz!NT XShell插件
///<summary>
public class XShell
{
//定义输出的HTML代码保存变量
static string showFile = string.Empty;
/// <summary>
/// 显示页面
/// </summary>
/// <returns>页面HTML代码</returns>
public static string HtmlShow()
{
//定义XShell模板文件夹
string strFilePatch = Utils.GetMapPath(BaseConfigFactory.GetForumPath + "Xshell/");
//定义XShell文件位置
string filePatch = strFilePatch + "XShell.html";
if (File.Exists(filePatch))
{
using (StreamReader strReader = new StreamReader(filePatch, Encoding.UTF8))
{
System.Text.StringBuilder strOutput = new System.Text.StringBuilder();
strOutput.Append(strReader.ReadToEnd());
strReader.Close();
showFile = strOutput.ToString();
HtmlReplace(filePatch);
return showFile;
}
}
else return "Error!!";
}
#region 私有方法
/// <summary>
/// 标签处理
/// </summary>
/// <param name="filePatch">模板地址</param>
/// <returns>处理标签后的HTML代码</returns>
private static string HtmlReplace(string filePatch)
{
//定义论坛关键字
string fourmKeywords = string.Empty;
//定义论坛附加字
string fourmTitle2 = string.Empty;
//定义论坛标题
string fourmTitle = string.Empty;
//定义论坛描述
string fourmDescription = string.Empty;
//定义论坛新帖
string fourmNewTopic = string.Empty;
//定义论坛公告
string fourmNotice = string.Empty;
//定义论坛大分类
string fourmClass = string.Empty;
//定义最新论坛主题
string fourmTopic = string.Empty;
//定义论坛访问路径
string fourmUrl = string.Empty;
//配置文件路径
string configFilePatch = Utils.GetMapPath(BaseConfigFactory.GetForumPath + "config/");
XmlDocument XmlDoc = new XmlDocument();
XmlDoc.Load(configFilePatch + "general.config");
XmlNodeList NodeList = XmlDoc.SelectSingleNode("ConfigInfo").ChildNodes;
//处理参数
foreach (XmlNode Xn in NodeList)
{
XmlElement Xe = (XmlElement)Xn;
if (Xe.Name == "Forumurl") fourmUrl = Xe.InnerText;
if (Xe.Name == "Forumtitle") fourmTitle = Xe.InnerText;
if (Xe.Name == "Seotitle") fourmTitle2 = Xe.InnerText;
if (Xe.Name == "Seokeywords") fourmKeywords = Xe.InnerText;
if (Xe.Name == "Seodescription") fourmDescription = Xe.InnerText;
}
//定义数据库连接,处理最新帖子列表
OleDbDataReader reader = Database.ExecuteReader(CommandType.Text, "SELECT [tid], [fid], [title], [lastpost] FROM [" + BaseConfigFactory.GetTablePrefix + "topics] Order By [lastpost] DESC");
if (reader != null)
{
int i = 0;
StringBuilder newTopic = new StringBuilder();
while (reader.Read())
{
OleDbDataReader readerFourm = Database.ExecuteReader(CommandType.Text, "SELECT [name] FROM [" + BaseConfigFactory.GetTablePrefix + "forums] WHERE fid =" + reader[1].ToString().Trim());
readerFourm.Read();
newTopic.Append("<a href=\"" + fourmUrl + "/showtopic-" + reader[0].ToString().Trim() + ".aspx\"" + " title=\"" + reader[2].ToString().Trim() + "\">");
newTopic.Append("[" + readerFourm[0].ToString().Trim() + "]" + reader[2].ToString().Trim() + "</A><Br />");
readerFourm.Close();
i++;
if (i == 10) break;
}
reader.Close();
fourmTopic = newTopic.ToString();
}
else fourmTopic = "暂无帖子!";
//论坛大分类
OleDbDataReader readerFourmClass = Database.ExecuteReader(CommandType.Text, "SELECT [fid], [name] FROM [" + BaseConfigFactory.GetTablePrefix + "forums] Where parentid = 0");
if (readerFourmClass != null)
{
StringBuilder fourmClasslist = new StringBuilder();
while (readerFourmClass.Read())
{
fourmClasslist.Append("<a href=\"showforum-" + readerFourmClass[0].ToString().Trim() + ".aspx\" target=\"_blank\">");
fourmClasslist.Append(readerFourmClass[1].ToString() + "</a><br />");
}
fourmClass = fourmClasslist.ToString();
}
else fourmClass = "尚无分类";
//处理最新发布帖子
OleDbDataReader readerNewTopic = Database.ExecuteReader(CommandType.Text, "SELECT [tid], [fid], [title], [lastpost], [posterid], [poster] FROM [" + BaseConfigFactory.GetTablePrefix + "topics] Order By lastpost DESC");
if (readerNewTopic != null)
{
readerNewTopic.Read();
string poster = readerNewTopic[5].ToString().Trim();
string posterid = readerNewTopic[4].ToString().Trim();
fourmNewTopic = readerNewTopic[2].ToString().Trim();
showFile = showFile.Replace("{$LastTopic_Title}", fourmNewTopic);
fourmNewTopic = readerNewTopic[3].ToString().Trim();
showFile = showFile.Replace("{$LastTopic_Time}", fourmNewTopic);
OleDbDataReader readerNewTopicContent = Database.ExecuteReader(CommandType.Text, "SELECT [message] FROM [" + BaseConfigFactory.GetTablePrefix + "posts1] where title = '" + readerNewTopic[2].ToString().Trim() + "' and poster = '" + poster + "' and posterid = " + posterid);
readerNewTopicContent.Read();
fourmNewTopic = readerNewTopicContent[0].ToString().Trim();
showFile = showFile.Replace("{$LastTopic_Content}", fourmNewTopic);
readerNewTopicContent.Close();
readerNewTopic.Close();
}
else
{
showFile = showFile.Replace("{$LastTopic_Title}", "No Topic");
showFile = showFile.Replace("{$LastTopic_Time}", "No Topic");
showFile = showFile.Replace("{$LastTopic_Content}", "No Topic");
}
//公告标签处理
OleDbDataReader readerNotice = Database.ExecuteReader(CommandType.Text, "SELECT [id], [title], [message], [starttime] FROM [" + BaseConfigFactory.GetTablePrefix + "announcements] Order By id DESC");
if (readerNotice != null)
{
int i = 0;
StringBuilder NoticeList = new StringBuilder();
while (readerNotice.Read())
{
i++;
NoticeList.Append("<a href=\"announcement.aspx#" + readerNotice[0].ToString().Trim() + "\" target=\"_blank\">");
NoticeList.Append(readerNotice[1] + "</a><br />");
if (i == 10) break;
showFile = showFile.Replace("{$LastNotice_Title_" + i.ToString() + "}", readerNotice[1].ToString());
showFile = showFile.Replace("{$LastNotice_Time_" + i.ToString() + "}", readerNotice[3].ToString());
showFile = showFile.Replace("{$LastNotice_Content_" + i.ToString() + "}", readerNotice[2].ToString());
}
fourmNotice = NoticeList.ToString();
showFile = showFile.Replace("{$NoticeList}", fourmNotice);
readerNotice.Close();
}
//标签处理
showFile = showFile.Replace("{$FourmName}", fourmTitle + " - " + fourmTitle2);
showFile = showFile.Replace("{$Keywords}", fourmKeywords);
showFile = showFile.Replace("{$Description}", fourmDescription);
showFile = showFile.Replace("{$NewTopic}", fourmTopic);
showFile = showFile.Replace("{$FourmClass}", fourmClass);
return showFile;
}
#endregion
}
}
