dedecms dede arctype是什么？

Of course! Let's break down dede_arctype in detail. This is one of the most important and frequently used tables in the DedeCMS system.

What is dede_arctype?

In simple terms, dede_arctype is the database table that stores all the information about your website's categories (also known as "channels" or "arcsorts" in DedeCMS).

Every time you create or edit a category in your DedeCMS backend, you are adding or modifying a record in this table. It's the foundation for organizing your content, from news articles to product listings.

Key Fields in the dede_arctype Table

Understanding the structure of this table is crucial for developers and advanced users. Here are the most important fields:

How is dede_arctype Used? (Common Scenarios)

Content Organization (The Primary Purpose)

This is the core function. You create a hierarchy of categories.

• Example:
  • reid = 0: News (ID: 1)
  • reid = 1: Company News (ID: 2)
  • reid = 1: Industry News (ID: 3)
  • reid = 2: Press Releases (ID: 4)

When you add an article, you assign it to one of these categories (e.g., ID 4). DedeCMS then knows exactly where to place it in your site structure.

Generating Category URLs

The typedir and namerule2 fields are critical for URL generation.

• typedir: If you set typedir to a/{typedir} for the "Company News" category (ID: 2), DedeCMS will create a physical directory like /a/CompanyNews/.
• namerule2: If you set this to index_{page}.html, the URL for the second page of the "Company News" list will be /a/CompanyNews/index_2.html.

Template Development (Using {dede:channel} and {dede:sonchannel} tags)

When building your website's navigation menu, you will constantly query this table, usually through DedeCMS's built-in template tags.

• {dede:channel}: This tag fetches categories from the dede_arctype table.

  
  （图片来源网络，侵删）
  • By default, it gets all top-level categories (reid=0).
  • You can specify a parent to get its children: {dede:channel reid='1'} gets all sub-categories of the category with id=1.
  • Example (Main Navigation):

    <nav>
      <ul>
        {dede:channel type='top' row='8'}
        <li><a href="[field:typelink/]">[field:typename/]</a></li>
        {/dede:channel}
      </ul>
    </nav>

• {dede:sonchannel}: This is a shortcut to get the direct children of a specific category.

  • Example (Sub-category menu under "News"):

    {dede:sonchannel rsort='sortrank' row='8'}
    <a href="[field:typelink/]">[field:typename/]</a>
    {/dede:sonchannel}

PHP Development (Direct Database Queries)

For custom PHP code or plugin development, you might need to query this table directly.

<?php
// Require the DedeCMS configuration file
require_once (dirname(__FILE__) . "/include/config.php");
// Connect to the database
$dsql = new DedeSql(false);
// --- Example 1: Get all top-level categories ---
$dsql->SetQuery("SELECT id, typename, typedir FROM `#@__arctype` WHERE reid=0 ORDER BY sortrank ASC");
$dsql->Execute('top');
echo "<ul>";
while ($row = $dsql->GetArray('top')) {
    echo "<li><a href='{$row['typedir']}'>{$row['typename']}</a></li>";
}
echo "</ul>";
// --- Example 2: Get all sub-categories of a specific category (e.g., ID = 5) ---
$parent_id = 5;
$dsql->SetQuery("SELECT id, typename, typelink FROM `#@__arctype` WHERE reid={$parent_id} ORDER BY sortrank ASC");
$dsql->Execute('sub');
if ($dsql->GetTotalRow() > 0) {
    echo "<h3>Sub-Categories:</h3>";
    echo "<ul>";
    while ($row = $dsql->GetArray('sub')) {
        // Note: typelink is a virtual field, you might need to construct it manually
        $typelink = $GLOBALS['cfg_cmspath'] . '/' . $row['typedir'] . '/';
        echo "<li><a href='{$typelink}'>{$row['typename']}</a></li>";
    }
    echo "</ul>";
}
$dsql->Close();
?>

Relationship with Other Tables

dede_arctype doesn't exist in a vacuum. It's linked to other core tables:

• #@__archives: This table stores your articles. The typeid field in #@__archives is a foreign key that points to the id field in #@__arctype. This is how an article knows which category it belongs to.
• #@__arccattag: A linking table that connects articles (aid) to multiple categories (typeid). This allows an article to be in more than one category.
• #@__channeltype: Defines the different content models (Article, Image, Download, etc.). The channeltype field in dede_arctype links to this table.

Summary

Understanding dede_arctype is fundamental to mastering DedeCMS, as it underpins the entire content organization and navigation system of your website.