XOOPS Installation Guide

Chapter 6: Final System Configuration

With all of the information added, the Installation Wizard is ready to write all the information to the mainfile.php and the secure.php file. If the information provided about the database was correct, the result should be similar to Figure 11.

image001.png

Figure 11: You have another chance to take a look at what you entered If all data is correct, push the [Next] button and the Installation Wizard will attempt to connect to the database server to confirm the MySQL database is active and running and then will try to connect to the database specified.

If the MySQL server is setup correctly, the Installation Wizard will try to access the database, in this case the one called “xoops250final”. If it accessed the database successfully, the required tables for XOOPS.

image001.png

Figure 12: Database table creation list

Screen 8/14 (Figure 12) presents all of the database tables that support the System Module of a new XOOPS site.

A new XOOPS site creates 32 tables. Following is a list of the tables and a brief description of their function:

Table Description
xef9_avatar Holds the identity, path and name of user avatars.
xef9_avatar_user_link Ties an avatar's id with a user's id, so each user “knows” its avatar.
xef9_banner Holds all the information about a specific banner.
xef9_bannerclient Holds all the information about a banner customer.
xef9_bannerfinish Holds all the information about expired banners, with their click count.
xef9_block_module_link link Ties a block's id with a module's id, so each block “knows” the module to which it belongs.
xef9_cache_model holds value for cache model.
xef9_config Holds XOOPS general configuration variables.
xef9_configcategory Holds the configuration categories.
xef9_configoption Holds configuration options.
xef9_group_permission Holds the details of permissions granted to each group of users.
xef9_groups Holds the identity of users' groups.
xef9_groups_users_link Ties a user's id with a group's id, so each group "knows" its users, or each user "knows" to which group it belongs.
xef9_image Holds all the information about an image stored in the system.
xef9_imagebody Holds an image, in case you decide to write images in the database.
xef9_imagecategory Holds the image categories you define in the Image Manager.
xef9_imgset Holds the identity of an image set.
xef9_imgset_tplset_link Ties an image set's it with a template set's id, so a template set "knows" what images belong to it.
xef9_imgsetimg not used.
xef9_modules Holds all the information about a module.
xef9_newblocks Holds all the defining attributes of a block.
xef9_online Holds the information about users online.
xef9_priv_msgs Holds all the information about a private message.
xef9_ranks Holds the users ranks defined in the admin area, to qualify user's participation in the site.
xef9_session Holds the information about a session.
xef9_smiles Holds the information about the codes used to display smilies.
xef9_tplfile Holds the metadata of a file that's part of a template set.
xef9_tplset Holds the information about a template set.
xef9_tplsource Holds the data (the source code) of a file that's part of a template set.
xef9_users Holds all the information about a user.
xef9_xoopscomments Holds all the information about a comment.
xef9_xoopsnotifications Holds all the information about notifications.

All tables are created blank, ready to be populated.

The list of tables will grow with each module that is added to the site. As noted earlier, the tables listed above are for the System Module only.