function useDefaultMySQLData($httpHost = "*")
{
$PFDB = new PhpFileDB();
$PFDB->setFolder($this->absolutePath . "system/DBData/");
$q = $PFDB->pfdbQuery("SELECT * FROM Installation WHERE httpHost = '{$httpHost}'");
$Data = $PFDB->pfdbFetchAssoc($q);
$this->setMySQLData($Data["host"], $Data["user"], $Data["password"], $Data["datab"]);
}
echo implode("\n", $tempDirSubdirs) . "\n";
#echo "Apache-User: "******"\n";
echo "MySQLi-Modul:\t\t\t\t" . generic(extension_loaded("mysqli"), "geladen") . "\n";
echo "MySQL-Modul:\t\t\t\t" . generic(extension_loaded("mysql"), "geladen") . "\n";
echo "Reflection-Modul:\t\t\t" . generic(extension_loaded("reflection"), "geladen") . "\n";
echo "GD-Modul:\t\t\t\t" . generic(extension_loaded("gd"), "geladen") . " (bisher nur für multiCMS)\n";
echo "Curl-Modul:\t\t\t\t" . generic(extension_loaded("curl"), "geladen") . " (pixelLetter-Plugin)\n";
echo "Session-Modul:\t\t\t\t" . generic(extension_loaded("session"), "geladen") . "\n";
echo "Pear Imagick-Klasse:\t\t\t" . generic(class_exists("Imagick"), "geladen") . " (Exifer-Erweiterung für multiCMS)\n\n";
echo "alle geladenen Module:\n";
echo wordwrap(implode(", ", get_loaded_extensions()), 100) . "\n\n";
echo "Cookies:\t\t\t\t" . generic(isset($_COOKIE["TestCookie"]), "akzeptiert") . "\n";
echo "JavaScript:\t\t\t\t<span style=\"color:red;\" id=\"jstest\">nicht aktiviert</span>\n\n";
echo "MySQL-Server:\t\t\t\t" . generic($mysql, "erreichbar") . " (es werden nur localhost und 127.0.0.1 getestet)\n";
while ($t = $pf->pfdbFetchAssoc()) {
echo "\t<b>" . str_pad($t["host"], 20) . "" . str_pad($t["datab"], 20) . "</b>\n";
$r = mysql_connect($t["host"], $t["user"], $t["password"]);
echo "\t\tMySQL server: " . mysql_get_server_info() . "\n";
echo "\t\tMySQL client: " . mysql_get_client_info() . "\n";
if (extension_loaded("mysqli")) {
$ri = new mysqli($t["host"], $t["user"], $t["password"], $t["datab"]);
#print_r($ri);
echo "\t\tMySQLi client: " . $ri->client_info . "\n";
}
$ts = mysql_fetch_assoc(mysql_query("SELECT @@sql_mode"));
echo "\t\tMode: " . str_replace(array("STRICT_TRANS_TABLES", "STRICT_ALL_TABLES"), array("<span style=\"color:red;\">STRICT_TRANS_TABLES</span>", "<span style=\"color:red;\">STRICT_ALL_TABLES</span>"), $ts["@@sql_mode"]);
echo "\n";
if ($r) {
#$qG = mysql_query("SHOW GRANTS");
#$tG = mysql_fetch_array($qG);
function useDefaultMySQLData($httpHost = "*")
{
$PFDB = new PhpFileDB();
if (file_exists($this->absolutePath . "../phynxConfig")) {
$PFDB->setFolder($this->absolutePath . "../phynxConfig/");
} else {
$PFDB->setFolder($this->absolutePath . "system/DBData/");
}
$Data = false;
if ($httpHost != "*") {
$q = $PFDB->pfdbQuery("SELECT * FROM Installation WHERE httpHost = '{$httpHost}'");
$Data = $PFDB->pfdbFetchAssoc($q);
} else {
$q = $PFDB->pfdbQuery("SELECT * FROM Installation WHERE httpHost = '" . $_SERVER["HTTP_HOST"] . "'");
$Data = $PFDB->pfdbFetchAssoc($q);
}
if ($Data === false) {
$q = $PFDB->pfdbQuery("SELECT * FROM Installation WHERE httpHost = '*'");
$Data = $PFDB->pfdbFetchAssoc($q);
}
$this->setMySQLData($Data["host"], $Data["user"], $Data["password"], $Data["datab"]);
}
function loadMultipleV4(SelectStatement $statement)
{
$mf = new PhpFileDB();
$mf->setFolder($this->folder);
$table = $statement->table[0];
$where = "";
foreach ($statement->whereFields as $key => $value) {
$where .= ($where != "" ? " " . $statement->whereLogOp[$key] . " " : "") . ($statement->whereFields[$key] == $table . "ID" ? "ID" : $statement->whereFields[$key]) . " " . $statement->whereOperators[$key] . " '" . $statement->whereValues[$key] . "'";
}
$order = "";
foreach ($statement->order as $key => $value) {
$order .= ($order != "" ? ", " : "") . $statement->order[$key] . " " . $statement->orderAscDesc[$key];
}
unset($statement->fields[array_search($statement->table[0] . "ID", $statement->fields)]);
#".implode(", ",$statement->fields)."
$sql = "SELECT * FROM " . $statement->table[0] . "" . ($where != "" ? " WHERE {$where}" : "") . (count($statement->group) > 0 ? " GROUP BY " . implode(", ", $statement->group) : "") . ($order != "" ? " ORDER BY {$order}" : "") . (count($statement->limit) > 0 ? " LIMIT " . implode(", ", $statement->limit) : "");
$collector = array();
$Class = $statement->table[0];
$Class = new $Class(-1);
$AS = $Class->newAttributes();
$_SESSION["messages"]->addMessage("executing phpFileDB: {$sql}");
$q = $mf->pfdbQuery($sql);
#echo $sql;
#if(mysql_error() AND mysql_errno() == 1146) throw new TableDoesNotExistException();
#if(mysql_error() AND mysql_errno() == 1046) throw new DatabaseNotSelectedException();
#if(mysql_error() AND mysql_errno() != 1146) echo mysql_error()." ".mysql_errno();
#if(mysql_affected_rows() == 0) throw new ZeroRowsException();
#$_SESSION["messages"]->addMessage(mysql_affected_rows()." $table geladen");
while ($t = $mf->pfdbFetchAssoc($q)) {
$t[$table . "ID"] = $t["ID"];
unset($t["ID"]);
foreach ($t as $key => $value) {
$t[$key] = $mf->unescapeString($value);
}
if (count($this->parsers) > 0) {
foreach ($this->parsers as $key => $value) {
eval("\$t[\$key] = " . $value . "(\"" . $t[$key] . "\",\"load\");");
}
}
$newAttributes = new stdClass();
foreach ($t as $key => $value) {
$newAttributes->{$key} = $value;
}
#$newAttributes = $AS->newWithValues(PMReflector::getAttributesArray($ClassAttributes),$t);
$newCOfClass = new $table($t[$table . "ID"]);
$newCOfClass->setA($newAttributes);
$collector[] = $newCOfClass;
}
return $collector;
}
