<?php
//xna artilces
require_once('global.php');
if (in_array($action, array('taglist', 'getalltags'))) {
	if($action == 'taglist') {
		$order = $_GET['ordered'] == 'usenum' ? 'usenum' : 'tagid';
		if($page) {
			$start_limit = ($page - 1) * 30;
		} else {
			$start_limit = 0;
			$page = 1;
		}
		$numsql = "LIMIT $start_limit, 30";
		$rs = $db->fetch_one_array("SELECT count(*) AS tags FROM {$tablepre}xna_tags");
		$tatol = $rs['tags'];
		$multipage = multi($tatol, 30, $page, 'index.php?job=category&action=taglist');
	} else {
		$order = 'tagid';
		$numsql = '';
	}
    $query = $db->query("SELECT tagid,tag,usenum FROM {$tablepre}xna_tags ORDER BY $order DESC $numsql");
	$tagdb = array();
    while ($tag = $db->row($query)) {
		$tag['url'] = urlencode($tag['tag']);
		$tag['item'] = htmlspecialchars($tag['tag']);
		$tagdb[] = $tag;
	}
	unset($tag);
	$db->free($query);

	if($action == 'taglist') {
		$subnav = '全部标签';
	} else {
		include template("getalltags", _ROOT ."/template/digg/");
		exit;
	}
}
$tags = is_string($_GET[tags]) ? $_GET[tags]:"";
if (!empty($tags)){
    $arg .= " WHERE tags='$tags ' ";
}else{
    $arg .= "";
}
$query = $db->query("SELECT * FROM {$tablepre}xna_tags $arg ORDER BY tagid DESC");
while ($row = $db->row($query)) {
    $row[$row[tags]][id] = $row[tags];
    $row[sum] = $xnum[$row[id]];
    $ret[] = $row;
}
include template("tags", _ROOT ."/template/digg/");


$action = $_REQUEST["action"];
if ($_POST['refer'] == 'refer'){
    if (empty($_POST["tfield"])) {
        echo "" . _LANG_0103 . "";
        exit;
    }
    $sql = "SELECT tags FROM {$tablepre}xna_tags WHERE tags='" . $_POST["tfield"] . "'";
    $rt = $PlusDB->execute($sql);
    while ($row = $rt->fetchRow()){
        if ($row[tags] = $_POST["tfield"] || empty($_POST["tfield"])){
            echo "" . _LANG_0101 . "";
            exit;
        }
    }
    $record["tags"] = $_POST["tfield"];
    $ok = $PlusDB->autoexecute($xnadb, $record, "INSERT");
    if ($ok) {
        echo "" . _LANG_0102 . "";
        exit;
    }else{
        echo $PlusDB->errorMsg();
        echo "" . _LANG_1111 . "";
        exit;
    }
}
?>