__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<?php
/**
* Install RosarioSIS database
*
* Please create your database first
* and then fill in the details in the config.inc.php file.
*
* @since 4.8.3
*/
/**
* Include config.inc.php file.
*
* Do NOT change for require_once, include_once allows the error message to be displayed.
*/
if ( ! include_once 'config.inc.php' )
{
die( 'config.inc.php file not found. Please read the installation directions.' );
}
if ( empty( $DatabaseType ) )
{
// @since 10.0 Add $DatabaseType configuration variable
$DatabaseType = 'postgresql';
}
require_once 'database.inc.php';
// Fix PHP Fatal error maximum execution time of 120 seconds exceeded
set_time_limit( 240 );
// rosariosis_[lang].sql files available for database translation.
$lang = [
'fr' => 'French',
'pt_BR' => 'Portuguese (Brazil)',
'es' => 'Spanish',
];
// Test if database is already installed first.
if ( _configTableCheck() )
{
$result = db_query( "SELECT CONFIG_VALUE
FROM config
WHERE TITLE='LOGIN';" );
$config_login = db_fetch_row( $result );
if ( empty( $_POST['lang'] )
|| ! in_array( $_POST['lang'], array_keys( $lang ) )
|| $config_login['CONFIG_VALUE'] !== 'No' )
{
die( 'Database already installed.' );
}
if ( $DatabaseType === 'mysql' )
{
// @since 10.2 MySQL fix character encoding when translating database
db_query( "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_520_ci" );
// @since 10.4.3 MySQL always use InnoDB (default), avoid MyISAM
db_query( "SET default_storage_engine=InnoDB;" );
}
$addons_sql = $rosariosis_sql = '';
$rosariosis_sql_file = 'rosariosis_' . $_POST['lang'] . '.sql';
$addons_sql_file = 'rosariosis_addons_' . $_POST['lang'] . '.sql';
// Translate Database.
if ( file_exists( $rosariosis_sql_file ) )
{
// Same translation files for both MySQL & PostgreSQL.
$rosariosis_sql = file_get_contents( $rosariosis_sql_file );
if ( file_exists( $addons_sql_file ) )
{
$addons_sql = _getAddonsSQL( $addons_sql_file );
}
}
if ( $rosariosis_sql )
{
db_query( $rosariosis_sql );
}
if ( $addons_sql )
{
db_query( $addons_sql );
}
die( 'Success: database translated. <a href="index.php">Access RosarioSIS</a>' );
}
$sql_file = $DatabaseType === 'mysql' ? 'rosariosis_mysql.sql' : 'rosariosis.sql';
if ( ! file_exists( $sql_file ) )
{
die( 'Error: ' . $sql_file . ' file not found.' );
}
$rosariosis_sql = file_get_contents( $sql_file );
if ( $DatabaseType === 'mysql' )
{
// @since 10.0 Remove DELIMITER $$ declarations before procedures or functions.
$rosariosis_sql = MySQLRemoveDelimiter( $rosariosis_sql );
// @since 10.5 MySQL change database charset to utf8mb4 and collation to utf8mb4_unicode_520_ci
db_query( "ALTER DATABASE " . DBEscapeIdentifier( $DatabaseName ) . " CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_520_ci'" );
}
db_query( $rosariosis_sql );
if ( filter_var( $RosarioNotifyAddress, FILTER_VALIDATE_EMAIL ) )
{
// @since 11.1 Set email for default admin user so he can reset his password
db_query( "UPDATE staff
SET EMAIL='" . DBEscapeString( $RosarioNotifyAddress ) . "'
WHERE USERNAME='admin';" );
}
if ( file_exists( 'rosariosis_addons.sql' ) )
{
// @since 5.1 Install add-ons.
// Same add-ons file for both MySQL & PostgreSQL.
$addons_sql = _getAddonsSQL( 'rosariosis_addons.sql' );
db_query( $addons_sql );
}
?>
<form method="POST">
Translate database to
<select name="lang">
<?php foreach ( $lang as $lang_code => $lang_name ) : ?>
<option value="<?php echo $lang_code; ?>"><?php echo $lang_name; ?></option>
<?php endforeach; ?>
</select>
<br />
<input type="submit" value="Submit" />
<br />
</form>
<br />
<?php
die( 'Success: database' .
( file_exists( 'rosariosis_addons.sql' ) ? ' and add-ons' : '' ) .
' installed. <a href="index.php">Access RosarioSIS</a>' );
/**
* Check if config table exists
*
* @since 10.0 Add MySQL support
*
* @global $DatabaseType Database type: mysql or postgresql
*
* @return bool True if config table exists
*/
function _configTableCheck()
{
global $DatabaseType;
$result = db_query( "SELECT 1
FROM information_schema.tables
WHERE table_schema=" . ( $DatabaseType === 'mysql' ? 'DATABASE()' : 'CURRENT_SCHEMA()' ) . "
AND table_name='config';" );
return $result === false ? false : (bool) db_fetch_row( $result );
}
/**
* Get add-ons SQL
* Both SQL inside file
* and SQL inside \include files.
*
* @since 10.0
* @since 10.9.6 Do not use strtok(), can't handle nested calls for multiple files
*
* @global $DatabaseType Database type: mysql or postgresql
*
* @param string $file Full path to SQL file.
* @return string SQL queries.
*/
function _getAddonsSQL( $file )
{
global $DatabaseType;
$sql_addons_queries = '';
// https://stackoverflow.com/questions/1462720/iterate-over-each-line-in-a-string-in-php
$separator = "\r\n";
$lines = file( $file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES );
foreach ( $lines as $line )
{
if ( strpos( $line, '\include' ) !== false )
{
// \include files.
$sql_addon_include_file = trim( str_replace( [ '\include', "'", ';' ], '', $line ) );
if ( $DatabaseType === 'mysql' )
{
$sql_addon_include_file = str_replace( 'install.sql', 'install_mysql.sql', $sql_addon_include_file );
}
if ( file_exists( $sql_addon_include_file ) )
{
$sql_addon_install = file_get_contents( $sql_addon_include_file );
if ( $DatabaseType === 'mysql' )
{
// @since 10.0 Remove DELIMITER $$ declarations before procedures or functions.
$sql_addon_install = MySQLRemoveDelimiter( $sql_addon_install );
}
$sql_addons_queries .= $sql_addon_install . $separator;
}
}
else
{
$sql_addons_queries .= $line . $separator;
}
}
return $sql_addons_queries;
}
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| ProgramFunctions | Folder | 0755 |
|
|
| assets | Folder | 0755 |
|
|
| cgi-bin | Folder | 0755 |
|
|
| classes | Folder | 0755 |
|
|
| functions | Folder | 0755 |
|
|
| locale | Folder | 0755 |
|
|
| modules | Folder | 0755 |
|
|
| plugins | Folder | 0755 |
|
|
| .gitattributes | File | 483 B | 0644 |
|
| .gitignore | File | 5.08 KB | 0644 |
|
| Bottom.php | File | 3.84 KB | 0644 |
|
| CHANGES.md | File | 86.83 KB | 0644 |
|
| CHANGES_V1_2.md | File | 64.91 KB | 0644 |
|
| CHANGES_V3_4.md | File | 42.24 KB | 0644 |
|
| CHANGES_V5_6.md | File | 41.44 KB | 0644 |
|
| CHANGES_V7_8.md | File | 27.37 KB | 0644 |
|
| CONTRIBUTING.md | File | 2.87 KB | 0644 |
|
| COPYRIGHT | File | 403 B | 0644 |
|
| Gruntfile.js | File | 3.52 KB | 0644 |
|
| Help.php | File | 2.52 KB | 0644 |
|
| Help_en.php | File | 127.36 KB | 0644 |
|
| INSTALL.md | File | 8.33 KB | 0644 |
|
| INSTALL.pdf | File | 56.38 KB | 0644 |
|
| INSTALL_es.md | File | 9.05 KB | 0644 |
|
| INSTALL_es.pdf | File | 57.2 KB | 0644 |
|
| INSTALL_fr.md | File | 9.3 KB | 0644 |
|
| INSTALL_fr.pdf | File | 58.31 KB | 0644 |
|
| InstallDatabase.php | File | 5.63 KB | 0644 |
|
| LICENSE | File | 14.86 KB | 0644 |
|
| Menu.php | File | 2.55 KB | 0644 |
|
| Modules.php | File | 2.71 KB | 0644 |
|
| PasswordReset.php | File | 12.08 KB | 0644 |
|
| README.md | File | 6.12 KB | 0644 |
|
| README.pdf | File | 308.99 KB | 0644 |
|
| Side.php | File | 21.64 KB | 0644 |
|
| WHATS_NEW.md | File | 27.68 KB | 0644 |
|
| Warehouse.php | File | 23.67 KB | 0644 |
|
| apple-touch-icon.png | File | 4.32 KB | 0644 |
|
| composer.json | File | 363 B | 0644 |
|
| config.inc.php | File | 2.06 KB | 0644 |
|
| config.inc.sample.php | File | 2.05 KB | 0644 |
|
| database.inc.php | File | 22.12 KB | 0644 |
|
| diagnostic.php | File | 7.84 KB | 0644 |
|
| favicon.ico | File | 1.62 KB | 0644 |
|
| index.php | File | 16.54 KB | 0644 |
|
| package.json | File | 456 B | 0644 |
|
| rosariosis.sql | File | 131.01 KB | 0644 |
|
| rosariosis_es.sql | File | 14.95 KB | 0644 |
|
| rosariosis_fr.sql | File | 16.84 KB | 0644 |
|
| rosariosis_mysql.sql | File | 121.71 KB | 0644 |
|
| rosariosis_pt_BR.sql | File | 14.96 KB | 0644 |
|
