install.php

<?php

/**
 *  @module         foldergallery
 *  @version        see info.php of this module
 *  @author         cms-lab (initiated by Jürg Rast)
 *  @copyright      2010-2018 cms-lab 
 *  @license        GNU General Public License
 *  @license terms  see info.php of this module
 *  @platform       see info.php of this module
 * 
 */
 
// include class.secure.php to protect this file and the whole CMS!
if (defined('LEPTON_PATH')) {	
	include(LEPTON_PATH.'/framework/class.secure.php'); 
} else {
	$oneback = "../";
	$root = $oneback;
	$level = 1;
	while (($level < 10) && (!file_exists($root.'/framework/class.secure.php'))) {
		$root .= $oneback;
		$level += 1;
	}
	if (file_exists($root.'/framework/class.secure.php')) { 
		include($root.'/framework/class.secure.php'); 
	} else {
		trigger_error(sprintf("[ <b>%s</b> ] Can't include class.secure.php!", $_SERVER['SCRIPT_NAME']), E_USER_ERROR);
	}
}
// end include class.secure.php

// check if older release is already installed
if(file_exists(LEPTON_PATH.'/modules/foldergallery_jq/info.php')) {
	require_once LEPTON_PATH.'/modules/foldergallery/upgrade.php';
} else {
	/*
	 * Create new module db-tables
	 */
	$table_name = 'mod_foldergallery_settings';
	$table_fields='
		`section_id` INT NOT NULL DEFAULT 0,
		`page_id` INT NOT NULL DEFAULT 0,
		`root_dir` VARCHAR(255) NOT NULL ,
		`extensions` VARCHAR(255) NOT NULL,
		`invisible` VARCHAR( 255 ) NOT NULL ,
		`background` VARCHAR(50) NOT NULL DEFAULT "#FFFFFF",
		`thumb_size` INT NOT NULL DEFAULT 150,
		`ratio` VARCHAR(10) NOT NULL,
		`pics_pp` INT NOT NULL DEFAULT 15,
		`lightbox` VARCHAR(50) NOT NULL DEFAULT "colorbox",
		`catpic` TINYINT NOT NULL DEFAULT 0,
		PRIMARY KEY ( `section_id` )
		';
	LEPTON_handle::install_table($table_name, $table_fields);


	$table_name = 'mod_foldergallery_files';
	$table_fields='
		`id` INT NOT NULL AUTO_INCREMENT,
		`parent_id` INT NOT NULL DEFAULT 0,
		`file_name` VARCHAR(255) NOT NULL,
		`position` INT NOT NULL DEFAULT 0,
		`caption` TEXT NOT NULL,
		PRIMARY KEY ( `id` )
		';	
	LEPTON_handle::install_table($table_name, $table_fields);

	$table_name = 'mod_foldergallery_categories';
	$table_fields='
		`id` INT NOT NULL AUTO_INCREMENT,
		`section_id` INT NOT NULL DEFAULT 0,
		`parent_id` INT NOT NULL DEFAULT 0,
		`categorie` VARCHAR(255) NOT NULL,
		`parent` VARCHAR(255) NOT NULL,
		`cat_name` VARCHAR(255) NOT NULL,
		`active` TINYINT NOT NULL DEFAULT 1,
		`is_empty` INT NOT NULL DEFAULT 1,
		`position`INT NOT NULL DEFAULT 0,
		`niveau` INT NOT NULL DEFAULT -1,
		`has_child` INT NOT NULL DEFAULT 0,
		`childs` VARCHAR(255) NOT NULL,
		`description` VARCHAR(255) NOT NULL,
		PRIMARY KEY ( `id` )
		';	
	LEPTON_handle::install_table($table_name, $table_fields);
}
?>