chamilo-lms2/plugin/vchamilo/install.php

<?php
/* PHP code to install the plugin
 * For example:
 *
    // To query something to the database

    $table = Database::get_main_table(TABLE_MAIN_USER); // TABLE_MAIN_USER is a constant check the main/inc/database.constants.inc.php
    $sql = "SELECT firstname, lastname FROM $table_users ";
    $users = Database::query($sql);

    You can also use the Chamilo classes
    $users = UserManager::get_user_list();

 */

api_protect_admin_script();

$table = 'vchamilo';
$tablename = Database::get_main_table($table);
$sql = "
    CREATE TABLE IF NOT EXISTS $tablename (
    id int NOT NULL AUTO_INCREMENT,
    sitename varchar(80) NOT NULL,
    slug varchar(255) NOT NULL,
    institution varchar(80) NOT NULL,
    root_web varchar(120),
    db_host varchar(80) NOT NULL,
    db_user varchar(16) DEFAULT 'root',
    db_password varchar(32),  
    table_prefix varchar(16),
    db_prefix varchar(16),
    main_database varchar(60) DEFAULT 'chamilo',
    url_append varchar(32),
    course_folder varchar(80),
    visible int,
    lastcrongap int,
    lastcron int,
    croncount int,
    template varchar(255),
    password_encryption varchar(255),
    archive_url varchar(255),
    home_url varchar(255),
    upload_url varchar(255),
    course_url varchar(255),
    css_theme_folder varchar(255),
    PRIMARY KEY (id)
) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
";

/*ALTER TABLE vchamilo ADD COLUMN archive_url varchar(255);
ALTER TABLE vchamilo ADD COLUMN home_url varchar(255);
ALTER TABLE vchamilo ADD COLUMN upload_url varchar(255);
ALTER TABLE vchamilo ADD COLUMN course_url varchar(255);*/
Database::query($sql);

$table = 'vchamilo_config';
$tablename = Database::get_main_table($table);
// TODO: rename "name" and "value" fields - these are reserved keywords
$sql = "CREATE TABLE IF NOT EXISTS $tablename (
    id int(11) NOT NULL AUTO_INCREMENT, 
    component int(11) NOT NULL,
    `name` varchar(64) NOT NULL,
    `value` varchar(255) NOT NULL,
    longvalue varchar(255) NOT NULL,
    PRIMARY KEY (id)
)
";
Database::query($sql);

api_add_setting(0, 'vchamilo_cron_lasthost', 'vchamilo', 'setting', 'Plugins');
api_add_setting(0, 'vchamilo_vcrontime', 'vchamilo', 'setting', 'Plugins');
api_add_setting(0, 'vchamilo_vcrontickperiod', 'vchamilo', 'setting', 'Plugins');

// create root storage directory for templates
global $_configuration;
if (!is_dir($_configuration['root_sys'].'plugin/vchamilo/templates')) {
    mkdir($_configuration['root_sys'].'plugin/vchamilo/templates', 0777, true);
}