getPrefix(); $linksTable = $prefix . 'mirai_links'; $metasTable = $prefix . 'metas'; $security = Typecho_Widget::widget('Widget_Security'); if (!$user->pass('administrator')) { throw new Typecho_Widget_Exception(_t('禁止访问'), 403); } $panelName = 'MiraiCore/Links/manage-categories.php'; $panelUrl = $options->adminUrl('extending.php?panel=' . urlencode($panelName), true); $action = isset($_GET['action']) ? trim($_GET['action']) : 'list'; $mid = isset($_GET['mid']) ? intval($_GET['mid']) : 0; $success = ''; $error = ''; if ($_SERVER['REQUEST_METHOD'] === 'POST') { try { $security->protect(); $name = trim((string)$_POST['name']); $description = trim((string)$_POST['description']); $order = isset($_POST['order']) ? intval($_POST['order']) : 0; if ($name === '') { throw new Exception('分类名称不能为空'); } $exists = $db->fetchRow($db->select('mid') ->from($metasTable) ->where('type = ?', 'link_category') ->where('name = ?', $name) ->where('mid != ?', $mid) ->limit(1)); if ($exists) { throw new Exception('分类名称已存在'); } $data = array( 'name' => $name, 'description' => $description, 'order' => $order, 'type' => 'link_category' ); if ($mid > 0) { $db->query($db->update($metasTable)->rows($data)->where('mid = ?', $mid)->where('type = ?', 'link_category')); $success = '分类已更新'; } else { $db->query($db->insert($metasTable)->rows($data)); $success = '分类已添加'; } $action = 'list'; $mid = 0; } catch (Exception $e) { $error = $e->getMessage(); $action = 'edit'; } } if ($action === 'delete' && $mid > 0) { try { $security->protect(); $linkCount = intval($db->fetchObject( $db->select(array('COUNT(*)' => 'num'))->from($linksTable)->where('category = ?', $mid) )->num); if ($linkCount > 0) { $error = '该分类下还有 ' . $linkCount . ' 个链接，请先删除或移动这些链接'; } else { $db->query($db->delete($metasTable)->where('mid = ?', $mid)->where('type = ?', 'link_category')); $success = '分类已删除'; } } catch (Exception $e) { $error = '删除失败'; } $action = 'list'; } $currentCategory = null; if ($action === 'edit' && $mid > 0) { $currentCategory = $db->fetchRow( $db->select()->from($metasTable)->where('mid = ?', $mid)->where('type = ?', 'link_category')->limit(1) ); } $categories = $db->fetchAll( $db->select()->from($metasTable)->where('type = ?', 'link_category')->order('order', Typecho_Db::SORT_ASC) ); foreach ($categories as &$cat) { $cat['count'] = intval($db->fetchObject( $db->select(array('COUNT(*)' => 'num'))->from($linksTable)->where('category = ?', $cat['mid']) )->num); } unset($cat); ?>

添加分类

getTokenUrl($panelUrl . '&action=delete&mid=' . $cat['mid']); ?>

排序	分类名称	描述	链接数	操作
没有任何分类
				编辑删除

getTokenUrl($panelUrl . ($mid > 0 ? '&mid=' . $mid : '')); ?>

没有任何分类