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.

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.

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.