dedecms添加自定义属性

// 添加自定义属性
$fieldname = 'custom_field'; // 自定义字段名称
$fieldtype = 'text'; // 字段类型
$fieldlength = 255; // 字段长度

// 检查字段是否已存在
if (!field_exists($fieldname)) {
    $sql = "ALTER TABLE `dede_archives` ADD `$fieldname` VARCHAR($fieldlength) NOT NULL DEFAULT ''";
    $dsql->ExecuteNoneQuery($sql);
}

// 更新系统缓存
$cachekey = 'fieldinfo';
$cachevalue = getcache($cachekey, 'sysdata');
if ($cachevalue === false) {
    $query = "SELECT * FROM `dede_fieldtype` ORDER BY id";
    $dsql->SetQuery($query);
    $dsql->Execute();
    while ($row = $dsql->GetArray()) {
        $fieldinfo[$row['fieldname']] = $row;
    }
    setcache($cachekey, $fieldinfo, 'sysdata', 3600);
}
$fieldinfo[$fieldname] = array(
    'fieldname' => $fieldname,
    'fieldtype' => $fieldtype,
    'fieldlength' => $fieldlength,
    'notnull' => true,
    'default' => '',
);

// 更新内容模型
$modelid = 1; // 内容模型ID
$modelname = '文章'; // 内容模型名称
$modelinfo = $dsql->GetOne("SELECT * FROM `dede_arctype` WHERE id=$modelid");
$modelinfo['fields'] .= ",$fieldname";
$dsql->ExecuteNoneQuery("UPDATE `dede_arctype` SET fields='$modelinfo[fields]' WHERE id=$modelid");