function __construct()
{
$dbName = isInPath("_test") || isset($_REQUEST["test"]) ? "accounts_test" : "accounts";
if (isset($GLOBALS["DBS"][$dbName])) {
parent::__construct($GLOBALS["DBS"][$dbName]["name"], $GLOBALS["DBS"][$dbName]["host"], $GLOBALS["DBS"][$dbName]["user"], $GLOBALS["DBS"][$dbName]["pass"], FALSE);
}
$this->dbprefix = isset($GLOBALS["DBS"][$dbName]["dbprefix"]) ? $GLOBALS["DBS"][$dbName]["dbprefix"] : "";
}
function __construct()
{
$dbName = "preprintsmeta";
if (isset($GLOBALS["DBS"][$dbName])) {
parent::__construct($GLOBALS["DBS"][$dbName]["name"], $GLOBALS["DBS"][$dbName]["host"], $GLOBALS["DBS"][$dbName]["user"], $GLOBALS["DBS"][$dbName]["pass"], FALSE);
}
$this->dbprefix = isset($GLOBALS["DBS"][$dbName]["dbprefix"]) ? $GLOBALS["DBS"][$dbName]["dbprefix"] : "";
}
function __construct()
{
$dbName = isInPath("/" . PATH_NEWSTEST . "/") || isInPath("/" . PATH_NEWSEDITTEST . "/") || isset($_REQUEST["test"]) ? "newstest" : "news";
//TODO:
if (isset($GLOBALS["DBS"][$dbName])) {
parent::__construct($GLOBALS["DBS"][$dbName]["name"], $GLOBALS["DBS"][$dbName]["host"], $GLOBALS["DBS"][$dbName]["user"], $GLOBALS["DBS"][$dbName]["pass"], FALSE);
}
$this->dbprefix = isset($GLOBALS["DBS"][$dbName]["dbprefix"]) ? $GLOBALS["DBS"][$dbName]["dbprefix"] : "";
// cf. NEWS_DB_PREFIX
}
function __construct()
{
if (isset($GLOBALS["DBS"]["vm"])) {
parent::__construct($GLOBALS["DBS"]["vm"]["name"], $GLOBALS["DBS"]["vm"]["host"], $GLOBALS["DBS"]["vm"]["user"], $GLOBALS["DBS"]["vm"]["pass"], FALSE);
}
$this->dbprefix = isset($GLOBALS["DBS"]["vm"]["dbprefix"]) ? $GLOBALS["DBS"]["vm"]["dbprefix"] : "";
}
function __construct()
{
$dbName = "events";
if (isset($GLOBALS["DBS"][$dbName])) {
parent::__construct($GLOBALS["DBS"][$dbName]["name"], $GLOBALS["DBS"][$dbName]["host"], $GLOBALS["DBS"][$dbName]["user"], $GLOBALS["DBS"][$dbName]["pass"], FALSE);
}
}
static function OutputTestDbSearch()
{
$application = "vm";
// "vm", "test", "cms", "preprints" // lowercase!
$stdout = "";
if (!class_exists("fromdb", FALSE)) {
require_once PATH_CLASSES . "/fromdb.php";
}
if (isset($GLOBALS["DBS"][$application])) {
$dbClass = new fromdb($GLOBALS["DBS"][$application]["name"], $GLOBALS["DBS"][$application]["host"], $GLOBALS["DBS"][$application]["user"], $GLOBALS["DBS"][$application]["pass"], FALSE);
} else {
return "***ERROR***";
}
// --------------------
// -- Test total output form one table at a time:
//$table = "abs_apartments";
//$table = "abs_events";
//$table = "abs_expenses";
//$table = "abs_leases";
//$table = "abs_offices";
//$table = "abs_payment";
//$table = "abs_visits";
//$table = "jam_applicants";
//$table = "jam_documents";
//$table = "jam_posfields";
//$table = "jam_positions";
//$table = "jam_recommendations";
//$table = "jam_reviews";
//$table = "jam_rf";
//$table = "lic_event";
//$table = "lic_host";
//$table = "lic_server";
//$table = "lic_soft";
//$table = "lic_user";
//$table = "wiw_trips";
//$table = "zzz_avatars";
//$table = "zzz_bugs";
//$table = "zzz_countries";
//$table = "zzz_flavors";
//$table = "zzz_huts";
$table = "zzz_list_members";
//$table = "zzz_lists";
//$table = "zzz_logs";
//$table = "zzz_master";
//$table = "zzz_templates";
//$table = "zzz_unit_members";
//$table = "zzz_units";
$sql = "SELECT " . " * " . "FROM " . " " . $table . " " . "WHERE " . " (lm_lid = '40213') " . "";
// --------------------
// -- Test a special case:
/*
$sql =
"SELECT " .
" lm_lid, " .
" lm_key," .
" lm_value " .
"FROM " .
" zzz_list_members " .
"WHERE " .
" (lm_lid = '40213') " .
" AND (lm_id <> '41135') " .
"";
*/
// --------------------
$res = $dbClass->query($sql, FALSE);
$eventlist = array();
if ($dbClass->num_rows($res)) {
$stdout .= "<h2>" . $table . "</h2>\r\n";
while ($record = $dbClass->next_record_assoc($res)) {
ksort($record);
$stdout .= "<br><br><hr>\r\n";
foreach ($record as $idx => $value) {
$stdout .= "<br>[" . $idx . "] = <strong>" . $value . "</strong>\r\n";
}
}
// end while
}
// --------------------
return $stdout;
}
function __construct($db = "", $host = "", $user = "", $pwd = "", $debug = FALSE)
{
// ----------------------
// Initiate GPC variables
// ----------------------
// -- $GLOBALS["variant"]
// @calledby people::OutputPeople()
// @calledby people::outputPeopleList()
// @calledby people::outputConveniencyLinks()
functions::gpc_declare_input("variant", "all");
// -- $GLOBALS["g"]
// Group by
// @calledby
functions::gpc_declare_input("g", false);
//TODO: this seems not to be implemented yet...
switch ($GLOBALS["g"]) {
case "e":
$toplevelid = "employeeType";
break;
case "g":
$toplevelid = "groupid";
break;
default:
$toplevelid = "employeeType";
}
// end switch
// -- $GLOBALS["sort_by"]
//TODO: this seems not to be implemented yet...
functions::gpc_declare_input("sort_by", "sn");
// -- $GLOBALS["u"]
// @calledby people::getPeopleData()
if (!isset($_REQUEST["labelusers"])) {
functions::gpc_declare_input("u", false);
}
// ----------------------
// DB connect parameters
// ----------------------
if (!empty($db) && !empty($host)) {
parent::__construct($db, $host, $user, $pwd, $debug);
}
}
function __construct()
{
// ----------------------
// Initiate GPC variables
// ----------------------
// ...
// ----------------------
// DB connect parameters
// ----------------------
if (isset($GLOBALS["DBS"]["search"])) {
parent::__construct($GLOBALS["DBS"]["search"]["name"], $GLOBALS["DBS"]["search"]["host"], $GLOBALS["DBS"]["search"]["user"], $GLOBALS["DBS"]["search"]["pass"], FALSE);
$this->dbprefix = isset($GLOBALS["DBS"]["search"]["dbprefix"]) ? $GLOBALS["DBS"]["search"]["dbprefix"] : "";
$this->table = $GLOBALS["DBS"]["search"]["table"];
$this->tablevars = $GLOBALS["DBS"]["search"]["tablevars"];
$this->tablestat = $GLOBALS["DBS"]["search"]["tablestat"];
$this->tabletemp = $GLOBALS["DBS"]["search"]["tabletemp"];
}
}
public static function AdbMypearLists()
{
$stdout = "";
$records = array();
if (!class_exists("fromdb", FALSE)) {
require_once PATH_CLASSES . "/fromdb.php";
}
$db = new fromdb($GLOBALS["DBS"]["vm"]["name"], $GLOBALS["DBS"]["vm"]["host"], $GLOBALS["DBS"]["vm"]["user"], $GLOBALS["DBS"]["vm"]["pass"]);
// --------------
$tables = array("zzz_units" => "u", "zzz_lists" => "l");
foreach ($tables as $table => $prefix) {
$sql = "SELECT * FROM " . $table;
$result = $db->query($sql);
if ($db->num_rows($result) > 0) {
while ($rec = $db->next_record_assoc($result)) {
if (isset($rec[$prefix . "_name"]) && isset($rec[$prefix . "_class"])) {
$records[$table . " --> " . $rec[$prefix . "_name"] . " [" . $rec[$prefix . "_class"] . "]"][] = array("id" => $rec[$prefix . "_id"], "parent" => $rec[$prefix . "_parent"]);
}
}
}
// end while
}
//TODO: temporary output:
debug::rr(array_keys($records));
debug::rr($records);
return $stdout;
}
function __construct($stopOnError = FALSE)
{
$application = "rooms";
if (isset($GLOBALS["DBS"][$application])) {
parent::__construct($GLOBALS["DBS"][$application]["name"], $GLOBALS["DBS"][$application]["host"], $GLOBALS["DBS"][$application]["user"], $GLOBALS["DBS"][$application]["pass"], FALSE);
}
/* -- REINSTATE WHEN WE HAVE TRUE ACCESS TO MRBS-- */
/*
$application = "mrbs";
if (isset($GLOBALS["DBS"]["mrbs"])) {
parent::__construct(
$GLOBALS["DBS"]["mrbs"]["name"],
$GLOBALS["DBS"]["mrbs"]["host"],
$GLOBALS["DBS"]["mrbs"]["user"],
$GLOBALS["DBS"]["mrbs"]["pass"],
FALSE);
}
$this->dbprefix = isset($GLOBALS["DBS"]["mbrs"]["dbprefix"]) ? $GLOBALS["DBS"]["mbrs"]["dbprefix"] : "";
$this->connect($stopOnError);
//$this->dbtable = $GLOBALS["DBS"]["mrbs"]["table"];
*/
}
function __construct($db, $host, $user = "", $pwd = "", $debug = FALSE)
{
parent::__construct($db, $host, $user, $pwd, $debug);
}
function __construct()
{
if (isset($GLOBALS["DBS"]["positions"])) {
parent::__construct($GLOBALS["DBS"]["positions"]["name"], $GLOBALS["DBS"]["positions"]["host"], $GLOBALS["DBS"]["positions"]["user"], $GLOBALS["DBS"]["positions"]["pass"], FALSE);
}
}
