#$@%#$%!

Ngiler SH3LL 360
: / var / softaculous / humogen /

Information Server
MySQL : OFF Perl : OFF CURL : ON WGET : OFF PKEXEC : OFF

Directive	Local Value
IP Address	63.250.38.10
System	Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
User	likhxapw
PHP Version	8.3.30
Software	LiteSpeed
Doc root	Writable

Edit File : db_login.php \| Size : 5.02 KB
<?php // * To make HuMo-genealogy work, fill these lines properly! * // * Om HuMo-genealogy werkend te krijgen onderstaande regels GOED invullen! * define("DATABASE_HOST", '[[softdbhost]]'); define("DATABASE_USERNAME", '[[softdbuser]]'); define("DATABASE_PASSWORD", '[[softdbpass]]'); define("DATABASE_NAME", '[[softdb]]'); // * Needed for Docker * $DATABASE_HOST= ''; $DATABASE_USERNAME=''; $DATABASE_PASSWORD=''; $DATABASE_NAME= ''; $USE_ENV_FOR_DB= true; // * DON'T CHANGE ANYTHING BELOW THIS LINE! * // * HIERONDER NIETS WIJZIGEN! * // * Check if PDO driver is available * if (!defined('PDO::ATTR_DRIVER_NAME')) { echo '<html> <header><title>ERROR</title><body> <h2>ERROR: The PDO driver is unavailable!</h2> Possible solutions:<br><br> 1) Update PHP to 7.x<br> 2) Check if the PDO driver is enabled.<br> 3) If the PDO driver is enabled but you receive this message from the Admin screen, try adding these three lines to the admin/php.ini file:<br> extension=pdo.so<br> extension=pdo_sqlite.so<br> extension=pdo_mysql.so<br> <p>If it\'s not possible to use PDO, you have to downgrade to HuMo-genealogy 4.9.4!<br> 1) Download HuMo-genealogy 4.9.4 at: <a href="https://sourceforge.net/projects/humo-gen/files">Sourceforge</a><br> 2) Follow <a href="https://sourceforge.net/projects/humo-gen/files/HuMo-gen_Manual/">HuMo-gen installation</a> instructions. </body></html> '; exit(); } // * Override the database connection values with environment variables * $temp_db_value = getenv("MYSQL_DATABASE", true); if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') { $DATABASE_NAME=$temp_db_value; //$temp_db_value = getenv("MYSQL_HOST", true); //if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') { // $DATABASE_HOST=$temp_db_value; $DATABASE_HOST='mariadb'; $temp_db_value = getenv("MYSQL_USER", true); if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') { $DATABASE_USERNAME=$temp_db_value; } $temp_db_value = getenv("MYSQL_PASSWORD", true); if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') { $DATABASE_PASSWORD=$temp_db_value; } // * Open database using PDO $conn = 'mysql:host='.$DATABASE_HOST.';dbname='.$DATABASE_NAME.';charset=utf8'; try { $dbh = new PDO($conn,$DATABASE_USERNAME,$DATABASE_PASSWORD); @$database_check=1; } catch (PDOException $e) { unset($database_check); if(!isset($ADMIN)) { echo '<br><font color=red><b> Database is not yet installed! Possible problems:<br> - Login file not yet configured.<br> - Database not yet installed.<br> Go to the <a href="admin">administration area</a> to solve this problem. <p>De database is nog niet bereikbaar! Mogelijke oorzaken:<br> - Het login bestand is niet goed ingevuld.<br> - De database is nog niet gemaakt.<br> Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen. </b></font>'; exit(); } } } else{ // * Open database using PDO //$conn = 'mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME; $conn = 'mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME.';charset=utf8'; try { //$dbh = new PDO($conn,DATABASE_USERNAME,DATABASE_PASSWORD,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $dbh = new PDO($conn,DATABASE_USERNAME,DATABASE_PASSWORD); @$database_check=1; } catch (PDOException $e) { unset($database_check); //echo $e->getMessage() . "<br/>"; if(!isset($ADMIN)) { echo '<br><font color=red><b> Database is not yet installed! Possible problems:<br> - Login file not yet configured.<br> - Database not yet installed.<br> Go to the <a href="admin">administration area</a> to solve this problem. <p>De database is nog niet bereikbaar! Mogelijke oorzaken:<br> - Het login bestand is niet goed ingevuld.<br> - De database is nog niet gemaakt.<br> Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen. </b></font>'; exit(); } } } if (isset($database_check) and $database_check == 1) { // TODO improve genealogical dates in database, then remove this code. // * Added in mar. 2022: disable NO_ZERO_DATE and NO_ZERO_IN_DATE. To solve sorting problems in genealogical dates. * $dbh->query("SET SESSION sql_mode=(SELECT REPLACE( REPLACE(@@SESSION.sql_mode,'NO_ZERO_DATE','') ,'NO_ZERO_IN_DATE',''));"); // TODO improve queries, then remove this code. // * Added in mar. 2023. To prevent double results in search results * $dbh->query("SET SESSION sql_mode=(SELECT REPLACE( REPLACE(@@SESSION.sql_mode,'ONLY_FULL_GROUP_BY','') ,'NO_ZERO_IN_DATE',''));"); } Back

Edit File : db_login.php | Size : 5.02 KB

<?php
// *** To make HuMo-genealogy work, fill these lines properly! ***
// *** Om HuMo-genealogy werkend te krijgen onderstaande regels GOED invullen! ***
define("DATABASE_HOST", '[[softdbhost]]');
define("DATABASE_USERNAME", '[[softdbuser]]');
define("DATABASE_PASSWORD", '[[softdbpass]]');
define("DATABASE_NAME", '[[softdb]]');

// *** Needed for Docker ***
$DATABASE_HOST= '';
$DATABASE_USERNAME='';
$DATABASE_PASSWORD='';
$DATABASE_NAME= '';
$USE_ENV_FOR_DB= true;

// *** DON'T CHANGE ANYTHING BELOW THIS LINE! ***
// *** HIERONDER NIETS WIJZIGEN! ***

// *** Check if PDO driver is available ***
if (!defined('PDO::ATTR_DRIVER_NAME')) {
 echo '<html>
 <header><title>ERROR</title><body>
 <h2>ERROR: The PDO driver is unavailable!</h2>
 Possible solutions: 
 1) Update PHP to 7.x 
 2) Check if the PDO driver is enabled. 
 3) If the PDO driver is enabled but you receive this message from the Admin screen, try adding these three lines to the admin/php.ini file: 
 extension=pdo.so 
 extension=pdo_sqlite.so 
 extension=pdo_mysql.so

If it\'s not possible to use PDO, you have to downgrade to HuMo-genealogy 4.9.4! 
 1) Download HuMo-genealogy 4.9.4 at: <a href="https://sourceforge.net/projects/humo-gen/files">Sourceforge</a> 
 2) Follow <a href="https://sourceforge.net/projects/humo-gen/files/HuMo-gen_Manual/">HuMo-gen installation</a> instructions.
 </body></html>
 ';
 exit();
}

// *** Override the database connection values with environment variables ***
$temp_db_value = getenv("MYSQL_DATABASE", true);
if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') {
    $DATABASE_NAME=$temp_db_value;

//$temp_db_value = getenv("MYSQL_HOST", true);
    //if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') {
    //	$DATABASE_HOST=$temp_db_value;
    $DATABASE_HOST='mariadb';

$temp_db_value = getenv("MYSQL_USER", true);
    if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') {
        $DATABASE_USERNAME=$temp_db_value;
    }

$temp_db_value = getenv("MYSQL_PASSWORD", true);
    if ($USE_ENV_FOR_DB && $temp_db_value != false && $temp_db_value != '') {
        $DATABASE_PASSWORD=$temp_db_value;
    }

// *** Open database using PDO **
 $conn = 'mysql:host='.$DATABASE_HOST.';dbname='.$DATABASE_NAME.';charset=utf8';
 try {
 $dbh = new PDO($conn,$DATABASE_USERNAME,$DATABASE_PASSWORD);
 @$database_check=1; 
 } catch (PDOException $e) {
 unset($database_check);
 if(!isset($ADMIN)) {
 echo ' 
 Database is not yet installed! Possible problems: 
 - Login file not yet configured. 
 - Database not yet installed. 
 Go to the <a href="admin">administration area</a> to solve this problem.
 De database is nog niet bereikbaar! Mogelijke oorzaken: 
 - Het login bestand is niet goed ingevuld. 
 - De database is nog niet gemaakt. 
 Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen.
 ';
 exit();
 }
 }
}
else{
 // *** Open database using PDO **
 //$conn = 'mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME;
 $conn = 'mysql:host='.DATABASE_HOST.';dbname='.DATABASE_NAME.';charset=utf8';
 try {
 //$dbh = new PDO($conn,DATABASE_USERNAME,DATABASE_PASSWORD,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
 $dbh = new PDO($conn,DATABASE_USERNAME,DATABASE_PASSWORD);
 @$database_check=1; 
 } catch (PDOException $e) {
 unset($database_check);
 //echo $e->getMessage() . " ";
 if(!isset($ADMIN)) {
 echo ' 
 Database is not yet installed! Possible problems: 
 - Login file not yet configured. 
 - Database not yet installed. 
 Go to the <a href="admin">administration area</a> to solve this problem.
 De database is nog niet bereikbaar! Mogelijke oorzaken: 
 - Het login bestand is niet goed ingevuld. 
 - De database is nog niet gemaakt. 
 Ga naar het <a href="admin">administratie scherm</a> om dit probleem op te lossen.
 ';
 exit();
 }
 }
}

if (isset($database_check) and $database_check == 1) {
    // TODO improve genealogical dates in database, then remove this code.
    // *** Added in mar. 2022: disable NO_ZERO_DATE and NO_ZERO_IN_DATE. To solve sorting problems in genealogical dates. ***
    $dbh->query("SET SESSION sql_mode=(SELECT
        REPLACE(
            REPLACE(@@SESSION.sql_mode,'NO_ZERO_DATE','')
        ,'NO_ZERO_IN_DATE',''));");

// TODO improve queries, then remove this code.
    // *** Added in mar. 2023. To prevent double results in search results ***
    $dbh->query("SET SESSION sql_mode=(SELECT
        REPLACE(
            REPLACE(@@SESSION.sql_mode,'ONLY_FULL_GROUP_BY','')
        ,'NO_ZERO_IN_DATE',''));");
}

Back