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