function DBConnect()
{
global $_SYSHCVOL;
CheckDBParams();
$db = mysql_connect($_SYSHCVOL['MYSQLServer'], $_SYSHCVOL['MYSQLUsername'], $_SYSHCVOL['MYSQLPassword']);
if (!$db) {
$str = "bad mysql_connect " . mysql_error();
error_log($str . $_SYSHCVOL['MYSQLServer']);
bw_error($str);
}
if (!mysql_select_db($_SYSHCVOL['MYSQLDB'], $db)) {
$str = "bad mysql_select_db " . mysql_error();
error_log($str . " select db {$_SYSHCVOL['MYSQLDB']}");
bw_error($str);
}
// Line to force use of UTF-8
// Natively dabase is sio latin1
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");
mysql_query("SET collation_connection='utf8_general_ci'");
global $i_am_the_mailbot;
if ('auto' == PVars::getObj('db')->dbupdate && !(isset($_SYSHCVOL['NODBAUTOUPDATE']) ? $_SYSHCVOL['NODBAUTOUPDATE'] : true) && !(isset($i_am_the_mailbot) ? $i_am_the_mailbot : false)) {
DBUpdateCheck();
}
// Adding a time limit
set_time_limit(15);
// No page must go longer than this number of seconds
// mysql_query("SET CHARACTER SET 'utf8'", $db );
}
/**
* @see /htdocs/bw/lib/lang.php
*/
public function __construct()
{
parent::__construct();
// TODO: it is fun to offer the members the language of the volunteers, i.e. 'prog',
// so I don't make any exceptions here; but we miss the flag - the BV flag ;-)
// TODO: is it consensus we use "WelcomeToSignup" as the decision maker for languages?
$query = '
SELECT `ShortCode`
FROM `words`
WHERE code = \'WelcomeToSignup\'';
$result = $this->dao->query($query);
while ($row = $result->fetch(PDB::FETCH_OBJ)) {
$this->_langs[] = $row->ShortCode;
}
global $i_am_the_mailbot, $_SYSHCVOL;
if ('auto' == PVars::getObj('db')->dbupdate && !(isset($_SYSHCVOL['NODBAUTOUPDATE']) ? $_SYSHCVOL['NODBAUTOUPDATE'] : true) && !(isset($i_am_the_mailbot) ? $i_am_the_mailbot : false)) {
require_once "../././htdocs/bw/lib/dbupdate.php";
DBUpdateCheck();
// die("<br />Please refresh again now, database has been updated") ;
}
}
