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(11) 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(1),
  `lastcrongap` int(11),
  `lastcron` int(11),
  `croncount` int(11),
  `template` varchar(255),
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
";
Database::query($sql);

$table = 'vchamilo_config';
$tablename = Database::get_main_table($table);
$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);
}