forked from ego008/youbbs-for-sae
/
model.php
135 lines (121 loc) · 4.35 KB
/
model.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
<?php
//一些常用的数据操作
define('ROOT' , pathinfo(__FILE__, PATHINFO_DIRNAME));
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);
unset($setting);
$DBS->free_result($query);
}
//获取链接
function get_links() {
global $MMC;
$links = $MMC->get('site_links');
if($links){
return $links;
}else{
global $DBS;
$query = $DBS->query("SELECT `name`, `url` FROM `yunbbs_links`");
$links = array();
while($link = $DBS->fetch_array($query)) {
$links[$link['name']] = $link['url'];
}
if($links){
$MMC->set('site_links', $links, 0, 72600);
}
unset($link);
$DBS->free_result($query);
return $links;
}
}
// 获取最新添加的分类
function get_newest_nodes() {
global $MMC;
$newest_nodes = $MMC->get('newest_nodes');
if($newest_nodes){
return $newest_nodes;
}else{
global $DBS, $options;
$query = $DBS->query("SELECT `id`, `name`, `articles` FROM `yunbbs_categories` WHERE `id` > '1' ORDER BY `id` DESC LIMIT ".$options['newest_node_num']);
$node_arr = array();
while($node = $DBS->fetch_array($query)) {
$node_arr['n/'.$node['id']] = $node['name'];
}
if($node_arr){
$MMC->set('newest_nodes', $node_arr, 0 ,3600);
}
unset($node);
$DBS->free_result($query);
return $node_arr;
}
}
// 获取热门分类
function get_bot_nodes() {
global $MMC;
$newest_nodes = $MMC->get('bot_nodes');
if($newest_nodes){
return $newest_nodes;
}else{
global $DBS, $options;
$query = $DBS->query("SELECT `id`, `name`, `articles` FROM `yunbbs_categories` WHERE `id` > '1' ORDER BY `articles` DESC LIMIT ".$options['bot_node_num']);
$node_arr = array();
while($node = $DBS->fetch_array($query)) {
$node_arr['n/'.$node['id']] = $node['name'];
}
if($node_arr){
$MMC->set('bot_nodes', $node_arr, 0 ,3600);
}
unset($node);
$DBS->free_result($query);
return $node_arr;
}
}
// 获取站点信息
function get_site_infos() {
global $MMC;
$site_infos = $MMC->get('site_infos');
if($site_infos){
return $site_infos;
}else{
global $DBS;
// 如果删除表里的数据则下面信息不准确
$site_infos = array();
$table_status = $DBS->fetch_one_array("SHOW TABLE STATUS LIKE 'yunbbs_users'");
$site_infos['会员'] = $table_status['Auto_increment'] -1;
$table_status = $DBS->fetch_one_array("SHOW TABLE STATUS LIKE 'yunbbs_categories'");
$site_infos['分类'] = $table_status['Auto_increment'] -1;
$table_status = $DBS->fetch_one_array("SHOW TABLE STATUS LIKE 'yunbbs_articles'");
$site_infos['帖子'] = $table_status['Auto_increment'] -1;
$table_status = $DBS->fetch_one_array("SHOW TABLE STATUS LIKE 'yunbbs_comments'");
$site_infos['回复'] = $table_status['Auto_increment'] -1;
$MMC->set('site_infos', $site_infos, 0 ,3600);
return $site_infos;
}
}
?>