ArMS 0.4 - Modules - XOOPS News - XOOPS Web Application System

XOOPS

News

News World of XOOPS Developers Hacks Themes Archive Submit News

Modules: ArMS 0.4

Posted by: IlijaOn 2003/11/16 17:42:52 7465 reads

ArMS (Article Management System) is XOOPS 2 module for managing multipage articles, tutorijals and everything else that has multipage text content.

Key features:

- 4 level data strucure:
-- categories
--- section
---- articles
----- pages
- crossposting (one article in more than one section)
- coauthoring (author of article can add extra permission to other users to help him write and maintain article)
- rating 1 - 5 (in ArMS 0.4 it is option - can be turned off from admin)
- XOOPS comments and search
- articles can be OnHold (article is not finished)
- smart hiding (if category or section is empty it will be hidden)
- blocks

NOTE: There is some known bugs and I don`t know how to fix them. Please take a look at docs/KNOWNBUGS.txt.

Download from XOOPS Modules/Themes

The comments are owned by the author. We aren't responsible for their content.

Re: ArMS 0.4

sunsnapper Published 11/16/2003 21:48 Friend of XOOPS Joined 04/10/2002 Comments 403

I would love a "related information" block. Something that could link to other related content. Preferably it would maintain relations automatically, however, even the ability to indicate relations manually would be nice.

Re: ArMS 0.4

svaha Published 11/16/2003 22:11 Just can't stay away Joined 08/02/2003 Comments 896

Hi sunsnapper, I'm also looking for this kind of related information blok. I tried the relation manager that you can find in the download section : https://xoops.org/modules/mydownloads/singlefile.php?cid=24&lid=395
But I got only a blank screen (Xoops 2.05) I don't know why.
Have you tried this one?

Aloha

ArMS 0.4 database create script

f00li5h Published 09/02/2006 14:13 Just popping in Joined 09/02/2006 Comments 2

When running against mysql Ver 14.12 Distrib 5.0.22, for -netbsdelf (i386) using EditLine wrapper the create sql goes crazy on the defaults for primary keys (perhaps also because their defaults are all strings)

anyway, you can get my hacks on the sql script here:
http://f00li5h.pin21.com/xoops_arm_sql.sql

(I know it would be better if that were in version controll - but then i'd need a public cvs)

I also haven't managed to trick it into having categories (other than grabing a mysql shell and doing insert statements) but that's another fish to fry, as they say.

Re: ArMS 0.4 database create script

katzaau Published 06/13/2008 11:20 Just popping in Joined 07/21/2006 Comments 11

Since MySQL 5.1 ISAM is not longer valid. See the following WORKING MySQL file (TYPE = MyISAM replaced with ENGINE = MyISAM)

==============================================================================
# Table arms_categories added in ArMS 0.3
# ==============================================================================

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 addons
# ---------------
# cat_id - category id
# sec_image - section 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 Addons
# ---------------
# art_onhold - while art_onhold is 1 only admin and author can see this artical
# ==============================================================================

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,
PRIMARY KEY (art_id)
) ENGINE = MyISAM;

CREATE TABLE 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,
PRIMARY KEY (page_id)
) ENGINE = MyISAM;

CREATE TABLE 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,
PRIMARY KEY (vote_id)
) ENGINE = MyISAM;

CREATE TABLE 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,
PRIMARY KEY (mod_id)
) ENGINE = MyISAM;

# ==============================================================================
# Table arms_permissions added in ArMS 0.3
# Note: fiels can_add_files and can_delete_files not implemented in ArMS 0.3
# please wait ArMS 0.4 for file attachments...
# ==============================================================================

CREATE TABLE 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,
PRIMARY KEY (p_id)
) ENGINE = MyISAM;

# ==============================================================================
# Table arms_cross_section added in ArMS 0.3
# ==============================================================================

CREATE TABLE 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,
PRIMARY KEY (cs_id)
) ENGINE = MyISAM;

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Modules: ArMS 0.4

Re: ArMS 0.4

Re: ArMS 0.4

ArMS 0.4 database create script

Re: ArMS 0.4 database create script

Login

Search

Recent Comments

Re: New Admin Theme for XOOPS (Beta)

Sanford Pharmacy: Exceptional Pharmacy Services Tailored to You

Re: New Admin Theme for XOOPS (Beta)

Re: XOOPS 2.5.12 Beta-2 available for Testing

Re: XOOPS 2.5.12 Beta-2 available for Testing

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

Archives

News archives