youbbs/admin-link.php at master · jat001/youbbs · GitHub

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
<?php
define('IN_SAESPOT', 1);
define('ROOT', dirname(__FILE__));

include_once(ROOT . '/config.php');
include_once(ROOT . '/common.php');

if (!$cur_user) {
    $error_code = 4012;
    include_once(ROOT . '/error/401.php');
    exit;
}
if ($cur_user['flag']<99) {
    $error_code = 4031;
    include_once(ROOT . '/error/403.php');
    exit;
}

$act = trim($_GET['act']);
$lid = intval($_GET['lid']);
if($lid){
    $query = "SELECT * FROM yunbbs_links WHERE id='$lid'";
    $l_obj = $DBS->fetch_one_array($query);
    if(!$l_obj){
        header('Location: /admin-link-list');
        exit;
    }
}

if($_SERVER['REQUEST_METHOD'] == 'POST'){
    $action = trim($_POST['action']);
    switch ($action) {
        case 'add':
            $n_name = htmlspecialchars(trim($_POST['name']));
                    $n_url = trim($_POST['url']);
                    if($n_name && $n_url){
                        if($DBS->query("INSERT INTO yunbbs_links (name, url) VALUES ('$n_name', '$n_url')")){
                            //更新缓存
                            $MMC->delete('site_links');
                            $tip1 = '已成功添加';
                        }else{
                            $tip1 = '数据库更新失败，修改尚未保存，请稍后再试';
                        }
                    }else{
                        $tip1 = '链接名 和 网址 不能留空';
                    }
            break;


        case 'edit':
            $n_name = htmlspecialchars(trim($_POST['name']));
            $n_url = trim($_POST['url']);
            if($n_name && $n_url){
                if($DBS->unbuffered_query("UPDATE yunbbs_links SET name='$n_name',url='$n_url' WHERE id='$lid'")){
                    //更新缓存
                    $MMC->delete('site_links');
                    $l_obj['name'] = $n_name;
                    $l_obj['url'] = $n_url;
                    $tip2 = '已成功保存';
                }else{
                    $tip2 = '数据库更新失败，修改尚未保存，请稍后再试';
                }

            }else{
                $tip2 = '链接名 和 网址 不能留空';
            }
            break;


        default:
            break;
    }
}else{
    if($act == 'del'){
        $DBS->unbuffered_query("DELETE FROM yunbbs_links WHERE id='$lid'");
        $MMC->delete('site_links');
    }

}

// 获取链接列表
$query_sql = "SELECT * FROM yunbbs_links";
$query = $DBS->query($query_sql);
$linkdb=array();
while ($link = $DBS->fetch_array($query)) {
    $linkdb[] = $link;
}


// 页面变量
$title = '链接管理 - '.$options['name'];


$pagefile = ROOT . '/templates/default/'.$tpl.'admin-link.php';

include_once(ROOT . '/templates/default/'.$tpl.'layout.php');

?>