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") ; } }