Re: ArMS 0.4我很想有一个“相关信息”块，它可以将链接到其他相关内容。最好是它能自动维护关系，然而，即使可以有手动标记关系的能力也很好。
Re: ArMS 0.4Hi sunsnapper，我也在寻找这种相关信息块。我在下载部分尝试了关系管理器： https://xoops.org.cn/modules/mydownloads/singlefile.php?cid=24&lid=395
但是我只看到了一个空白屏幕（Xoops 2.05），我不知道为什么。
您尝试过这个吗？
Aloha
ArMS 0.4 数据库创建脚本当与 mysql Ver 14.12 Distrib 5.0.22, for -netbsdelf (i386) using EditLine wrapper 运行时，创建脚本中的主键默认值变得非常怪异（也许也因为它们的默认值都是字符串）
不过，您可以在以下地方找到我对SQL脚本的修改
http://f00li5h.pin21.com/xoops_arm_sql.sql
（我知道如果放在版本控制中会更好——但是那样我需要一个公开的cvs）
我还未能使其具备分类（除了用mysql shell和插入语句外）——就像人们说的那样，这也是另一个问题。
Re: ArMS 0.4 数据库创建脚本由于MySQL 5.1中ISAM已不再有效。请查看以下有效的MySQL文件（将 TYPE = MyISAM 替换为 ENGINE = MyISAM）
==============================================================================
# 在 ArMS 0.3 中添加了 arms_categories 表
# ==============================================================================
CREATE TABLE arms_categories (
cat_id smallint(3) unsigned NOT NULL auto_increment,
cat_title varchar(100) default "" NOT NULL,
cat_desc text default "" NOT NULL,
cat_order smallint(3) unsigned default 0 NOT NULL,
PRIMARY KEY (cat_id)
) ENGINE = MyISAM;
# ==============================================================================
# ArMS 0.3 插件
# ---------------
# cat_id - 分类ID
# sec_image - 部分图像
# ==============================================================================
CREATE TABLE arms_sections (
sec_id smallint(3) unsigned NOT NULL auto_increment,
cat_id smallint(3) unsigned default 0 NOT NULL,
sec_order smallint(3) unsigned default 1 NOT NULL,
sec_title varchar(100) default "" NOT NULL,
sec_desc text default "" NOT NULL,
sec_image varchar(255) default "" NOT NULL,
PRIMARY KEY (sec_id)
) ENGINE = MyISAM;
CREATE TABLE arms_articals_levels (
level_id smallint(3) unsigned NOT NULL auto_increment,
level_name varchar(100) default "" NOT NULL,
level_desc text default "" NOT NULL,
level_image varchar(100) default "" NOT NULL,
PRIMARY KEY (level_id)
) ENGINE = MyISAM;
# ==============================================================================
# ArMS 0.3 插件
# ---------------
# art_onhold - 当 art_onhold 为 1 时，只有管理员和作者可以看到这篇文章
# ==============================================================================
CREATE TABLE arms_articals (
art_id int(5) unsigned NOT NULL auto_increment,
sec_id smallint(3) unsigned default 0 NOT NULL,
level_id smallint(3) unsigned default 0 NOT NULL,
uid int(5) unsigned default 0 NOT NULL,
uip varchar(15) default "" NOT NULL,
art_title varchar(255) default "" NOT NULL,
art_desc text default "" NOT NULL,
art_updatecount smallint(3) unsigned default 0 NOT NULL,
art_posttime int(11) unsigned default 0 NOT NULL,
art_lastupdate int(11) unsigned default 0 NOT NULL,
art_lastupdateby int(5) unsigned default 0 NOT NULL,
art_lastupdatebyip varchar(15) default "" NOT NULL,
art_ratetotal mediumint(8) unsigned default 0 NOT NULL,
art_ratecount mediumint(8) unsigned default "1" NOT NULL,
art_views int(11) unsigned default 0 NOT NULL,
art_activated tinyint(1) default 0 NOT NULL,
art_onhold tinyint(1) default "1" NOT NULL,
主键 (art_id)
) ENGINE = MyISAM;
创建表 arms_pages (
page_id int(6) unsigned NOT NULL auto_increment,
page_order smallint(3) unsigned default 1 NOT NULL,
art_id int(5) unsigned default 0 NOT NULL,
level_id smallint(3) unsigned default 0 NOT NULL,
uid int(5) unsigned default 0 NOT NULL,
uip varchar(15) default "" NOT NULL,
page_title varchar(255) default "" NOT NULL,
page_desc text default "" NOT NULL,
page_text text default "" NOT NULL,
page_allow_html tinyint(1) default 0 NOT NULL,
page_allow_emotions tinyint(1) default 0 NOT NULL,
page_allow_bbcode tinyint(1) default "1" NOT NULL,
page_updatecount smallint(3) unsigned default 0 NOT NULL,
page_posttime int(11) unsigned default 0 NOT NULL,
page_lastupdate int(11) unsigned default 0 NOT NULL,
page_lastupdateby int(5) unsigned default 0 NOT NULL,
page_lastupdatebyip varchar(15) default "" NOT NULL,
page_views int(11) unsigned default 0 NOT NULL,
主键 (page_id)
) ENGINE = MyISAM;
创建表 arms_votelog (
vote_id int(5) unsigned NOT NULL auto_increment,
vote_time int(11) unsigned default 0 NOT NULL,
art_id int(5) unsigned default 0 NOT NULL,
uid int(5) unsigned default 0 NOT NULL,
uip varchar(15) default "" NOT NULL,
主键 (vote_id)
) ENGINE = MyISAM;
创建表 arms_moderators(
mod_id smallint(3) unsigned NOT NULL auto_increment,
uid int(5) unsigned default 0 NOT NULL,
sec_id smallint(3) unsigned default 0 NOT NULL,
主键 (mod_id)
) ENGINE = MyISAM;
# ==============================================================================
# 在 ArMS 0.3 中添加的 arms_permissions 表
# 注意：在 ArMS 0.3 中未实现 can_add_files 和 can_delete_files 字段
# 请等待 ArMS 0.4 以添加文件附件...
# ==============================================================================
创建表 arms_permissions(
p_id int(6) unsigned NOT NULL auto_increment,
art_id int(6) unsigned default 0 NOT NULL,
uid int(5) unsigned default 0 NOT NULL,
added_by int(5) unsigned default 0 NOT NULL,
can_edit_pages tinyint(1) default "1" NOT NULL,
can_add_pages tinyint(1) default 0 NOT NULL,
can_delete_pages tinyint(1) default 0 NOT NULL,
can_add_files tinyint(1) default 0 NOT NULL,
can_delete_files tinyint(1) default 0 NOT NULL,
主键 (p_id)
) ENGINE = MyISAM;
# ==============================================================================
# 在 ArMS 0.3 中添加的 arms_cross_section 表
# ==============================================================================
创建表 arms_cross_section (
cs_id int(9) unsigned NOT NULL auto_increment,
art_id int(6) unsigned default 0 NOT NULL,
sec_id smallint(3) unsigned default 0 NOT NULL,
主键 (cs_id)
) ENGINE = MyISAM;
| Stats | |
| Goal: | $100.00 |
| Due Date: | Aug 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|
