/**
* Creates a new instance of this object with attributevalues set to supplied values.
*
* @return Attributes New instance with supplied values
*
* @param array $values The new values
*/
function newWithAssociativeArray($values)
{
$a = PMReflector::getAttributesArray(get_class($this));
for ($i = 0; $i < count($a); $i++) {
if (isset($values[$a[$i]])) {
$this->{$a}[$i] = $values[$a[$i]];
}
}
}
public function getDBData($newFolder = null)
{
if ($newFolder == null) {
$newFolder = Util::getRootPath() . "system/DBData/";
}
if (!isset($_SERVER["HTTP_HOST"])) {
$_SERVER["HTTP_HOST"] = "*";
}
$data = new mInstallation();
if ($newFolder != "") {
$data->changeFolder($newFolder);
}
$data->setAssocV3("httpHost", "=", $_SERVER["HTTP_HOST"]);
#$data->loadCollectionV2();
$n = $data->getNextEntry();
if ($n == null) {
#$data = new mInstallation();
#if($newFolder != "") $data->changeFolder($newFolder);
$data = new mInstallation();
if ($newFolder != "") {
$data->changeFolder($newFolder);
}
$data->setAssocV3("httpHost", "=", "*");
$n = $data->getNextEntry();
}
if ($n != null) {
$n->changeFolder($newFolder);
$d = $n->getA();
} else {
$I = new Installation(-1);
$I->changeFolder($newFolder);
$I->makeNewInstallation();
$d = $I->getA();
}
$I2 = new Installation(-1);
$s = PMReflector::getAttributesArray($I2->newAttributes());
$t = array();
foreach ($s as $key => $value) {
$t[$value] = $d->{$value};
}
$rt = Environment::getS("databaseData", $t);
return $rt;
}
private function translate($table, $A)
{
$t = new $table(-1);
$schema = $t->getLDAPSchema();
#if($as == null)
$as = PMReflector::getAttributesArray($A);
foreach ($schema as $k => $v) {
if ($k == "objectclass") {
continue;
}
foreach ($as as $m) {
$v = str_replace("{" . $m . "}", $A->{$m}, $v);
}
if ($v == "") {
unset($schema[$k]);
continue;
}
$schema[$k] = $v;
}
return $schema;
}
/**
* Creates standard auto completion forms for use as quicksearch results.
* Available modes:
*
* quickSearchLoadFrame
*
* quickSearchSelectionMode
*
* @param string $mode
* @return string
*/
public function getACHTMLBrowser($mode = "")
{
$random = rand();
$_SESSION["BPS"]->setActualClass(get_class($this));
$bps = $_SESSION["BPS"]->getAllProperties();
if ($this->selectionFunctions != "") {
$mode = "quickSearchSelectionMode";
}
#else if($mode == "") $mode = "quickSearchLoadFrame";
$html = "\n\t\t<input type=\"hidden\" id=\"AutoCompleteFields_{$random}\" value=\"" . implode(", ", count($this->showAttributes) == 0 ? $as : $this->showAttributes) . "\" />\n\t\t<input type=\"hidden\" id=\"AutoCompleteNumRows_{$random}\" value=\"" . count($this->attributes) . "\" />\n\t\t<input type=\"hidden\" id=\"ACTranslator\" value=\"{$random}\" />\n\t\t" . (($mode == "quickSearchLoadFrame" or $mode == "quickSearchSelectionMode") ? "<div onmouseover=\"AC.SetMouseIn();\" onmouseout=\"AC.SetMouseOut();\" class=\"ACHandler backgroundColor1\" id=\"ACHandler_{$random}\"><input type=\"checkbox\" id=\"keepOpen\" value=\"1\" onclick=\"AC.makeFreeWindow(this, '{$random}')\" /> Ergebnisse geöffnet lassen</div>" : "") . "\n\t\t<table style=\"border:0px;width:100%;\">\n\t\t\t<colgroup>\n\t\t\t\t<col class=\"backgroundColor2\" />\n\t\t\t</colgroup>";
$l = 1;
for ($i = 0; $i < count($this->attributes); $i++) {
$aid = $this->attributes[$i]->getID();
// get the id of an object separately
$sc = $this->attributes[$i]->getA();
// get the attributes-object from the object
$as = PMReflector::getAttributesArray($sc);
// get an array of attribute-names from the object
$html .= "\n\t\t\t<tr onclick=\"AC.update(13, '', '{$random}');\" onmouseover=\"AC.selectByMouse('autoCompleteTRId{$l}" . "_{$random}');\" onmouseout=\"AC.SetMouseOut();\" id=\"autoCompleteTRId{$l}" . "_{$random}\" style=\"cursor:pointer;\">";
$modeFunction = "";
$actionCol = "";
if ($mode != "") {
switch ($mode) {
case "quickSearchLoadFrame":
$_SESSION["BPS"]->setActualClass(get_class($this));
$bps = $_SESSION["BPS"]->getAllProperties();
if ($bps == -1) {
die("you need to post targetFrame- and targetPlugin-values via BPS!");
}
$html .= "<td style=\"width:20px;\"><img src=\"./images/i2/edit.png\" /></td>";
$actionEditButton = "contentManager.backupFrame('" . $bps["targetFrame"] . "', 'lastCollection'); contentManager.loadFrame('" . $bps["targetFrame"] . "','{$bps['targetPlugin']}','{$aid}')";
if ($this->JSOnEdit != null) {
$actionEditButton = str_replace("%%VALUE%%", $aid, $this->JSOnEdit);
}
$modeFunction = "<input type=\"hidden\" id=\"doACJS%attributeNameId{$l}" . "_{$random}\" value=\"{$actionEditButton}\" />";
break;
case "quickSearchSelectionMode":
$html .= "<td style=\"width:20px;\"><img class=\"mouseoverFade\" src=\"./images/i2/cart.png\" /></td>";
$modeFunction = "<input type=\"hidden\" id=\"doACJS%attributeNameId{$l}" . "_{$random}\" value=\"" . str_replace("%%VALUE%%", $aid, $this->selectionFunctions) . "\" />";
break;
}
}
if (count($this->showAttributes) == 0) {
for ($j = 0; $j < count($as); $j++) {
if (isset($this->dontShow[$as[$j]])) {
continue;
}
if ($i == 0) {
$this->shownCols[] = $as[$j];
}
if (isset($this->parsers[$as[$j]])) {
$parameters = $this->makeParameterStringFromArray($this->parserParameters[$as[$j]], $sc, $aid);
$t = $this->invokeParser($this->parsers[$as[$j]], $sc->{$as}[$j], $parameters);
#eval("\$t = ".$this->parsers[$as[$j]]."(\"".$sc->$as[$j]."\",\"load\",\"".implode("%§%",$this->parserParameters[$as[$j]])."\");");
} else {
$t = $sc->{$as}[$j];
}
$html .= "\n\t\t\t\t\t<td>" . $t . "<input type=\"hidden\" value=\"" . htmlspecialchars(strip_tags($t)) . "\" id=\"autoComplete" . $as[$j] . "Id{$l}" . "_{$random}\" />" . str_replace("%attributeName", $as[$j], $modeFunction) . "</td>";
}
} else {
foreach ($this->showAttributes as $key => $value) {
if ($i == 0) {
$this->shownCols[] = $value;
}
if (isset($this->parsers[$value])) {
$parameters = $this->makeParameterStringFromArray($this->parserParameters[$value], $sc, $aid);
$t = $this->invokeParser($this->parsers[$value], $sc->{$value}, $parameters);
} else {
$t = $sc->{$value};
}
$html .= "\n\t\t\t\t\t<td>" . $t . "<input type=\"hidden\" value=\"" . htmlspecialchars(strip_tags($t)) . "\" id=\"autoComplete" . $value . "Id{$l}" . "_{$random}\" />" . str_replace("%attributeName", $value, $modeFunction) . "</td>";
}
}
$l++;
}
if (count($this->attributes) == 0) {
$html .= "<tr><td>kein Ergebnis</td></tr>";
}
$html .= "\n\t\t</table>";
return $html;
}
public static function fillStdClassWithAssocArray($class, $values)
{
$a = PMReflector::getAttributesArray($class);
for ($i = 0; $i < count($a); $i++) {
$f = $a[$i];
if (isset($values[$a[$i]])) {
$class->{$f} = str_replace("\$", "\\\$", $values[$a[$i]]);
}
}
return $class;
}
function loadMultipleV2($table, $fields, $where, $order = "", $limit = "", $join = array(), $joinConditions = array())
{
$db = @sqlite_open($this->file) or die("SQLite-DB konnte nicht geöffnet werden. DB-Datei: " . $this->file);
$joins = "";
$t = 2;
#$jF = "";
foreach ($join as $key => $value) {
$conditions = "";
if (isset($joinConditions[$key])) {
for ($i = 0; $i < count($joinConditions[$key]); $i++) {
$conditions .= " AND " . $joinConditions[$key][$i][0] . " = '" . $joinConditions[$key][$i][1] . "'";
}
}
$joins .= "LEFT JOIN {$key} t{$t} ON(t1.{$value} = t{$t}.{$value}{$conditions}) ";
$t++;
}
$sql = "SELECT " . implode(", ", $fields) . " FROM {$table} t1 {$joins}" . ($where != "" ? "WHERE {$where}" : "") . " " . ($order != "" ? "ORDER BY {$order}" : "") . " " . ($limit != "" ? "LIMIT {$limit}" : "");
$collector = array();
$ClassAttributes = $table . (count($join) > 0 ? "Join" : "") . "Attributes";
$AS = new $ClassAttributes();
$_SESSION["messages"]->addMessage("executing SQLite: {$sql}");
$q = sqlite_query($db, $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(sqlite_num_rows($q) . " {$table} geladen");
while ($t = sqlite_fetch_array($q)) {
if (count($this->parsers) > 0) {
foreach ($this->parsers as $key => $value) {
eval("\$t[\$key] = " . $value . "(\"" . $t[$key] . "\",\"load\");");
}
}
$newAttributes = $AS->newWithValues(PMReflector::getAttributesArray($ClassAttributes), $t);
$newCOfClass = new $table($t["t1." . $table . "ID"]);
$newCOfClass->setA($newAttributes);
$collector[] = $newCOfClass;
}
sqlite_close($db);
return $collector;
}
public function getContextMenuHTML($identifier)
{
$deTexts = array();
$deTexts["pluginSupport"] = "Bitte beachten Sie, dass ein Plugin diese Einstellungen unterstützen muss, selbst wenn es hier angezeigt wird!";
$deTexts["selectPlugin"] = "Bitte Plugin wählen";
$deTexts["add"] = "hinzufügen";
$deTexts["selectPluginButton"] = "Plugin auswählen";
$deTexts["save"] = "speichern";
$deTexts["select"] = "auswählen";
$deTexts["noPsOptions"] = "keine plugin-spezifischen Optionen vorhanden";
$deTexts["newFieldName"] = "Neuer Feldname";
$deTexts["maybeHidden"] = "Bitte beachten Sie, dass hier interne Namen angezeigt werden, die von der Feldbeschriftung abweichen können!<br />Manche internen Felder werden möglichweise gar nicht angezeigt.";
$ac = new anyC();
$singularLanguageClass = $ac->loadLanguageClass("Userdata");
$text = $singularLanguageClass != null ? $singularLanguageClass->getText() : $deTexts;
$opts = "";
$ps = array_flip($_SESSION["CurrentAppPlugins"]->getAllPlugins());
$ms = $_SESSION["CurrentAppPlugins"]->getAllMenuEntries();
#print_r($ms);
foreach ($ps as $key => $value) {
if ($key == "mUserdata") {
continue;
}
if ($identifier == "4" and !PMReflector::implementsInterface($key, "iPluginSpecificRestrictions")) {
continue;
}
if ($identifier == "4") {
$c = new $key();
if (!$c->getPluginSpecificRestrictions()) {
continue;
}
}
if ($identifier == "5" and !in_array($key, $ms)) {
continue;
}
if ($value == "Kunde") {
continue;
}
if (!$_SESSION["CurrentAppPlugins"]->getIsAdminOnly($key) and $_SESSION["CurrentAppPlugins"]->isCollectionOfFlip($key) != "") {
$opts .= "<option value=\"{$key}:" . $_SESSION["CurrentAppPlugins"]->isCollectionOfFlip($key) . "\">{$value}</option>";
}
}
$s = explode(":", $identifier);
if (isset($s[1])) {
$identifier = $s[0];
}
switch ($identifier) {
case "1":
$c = isset($text["kann nicht erstellen"]) ? $text["kann nicht erstellen"] : "kann nicht\nerstellen";
$b = isset($text["kann nicht bearbeiten"]) ? $text["kann nicht bearbeiten"] : "kann nicht\nbearbeiten";
$l = isset($text["kann nicht löschen"]) ? $text["kann nicht löschen"] : "kann nicht\nlöschen";
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $c . "\" style=\"background-image:url(./images/navi/new.png);\" onclick=\"phynxContextMenu.update('mUserdata','Create','" . str_replace(array("\n", "'"), array(" ", "\\'"), $c) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $b . "\" style=\"background-image:url(./images/navi/editb.png);\" onclick=\"phynxContextMenu.update('mUserdata','Edit','" . str_replace(array("\n", "'"), array(" ", "\\'"), $b) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $l . "\" style=\"background-image:url(./images/navi/trash.png);\" onclick=\"phynxContextMenu.update('mUserdata','Delete','" . str_replace(array("\n", "'"), array(" ", "\\'"), $l) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><img src=\"./images/navi/warning.png\" style=\"float:left;margin-right:4px;\" />" . $text["pluginSupport"] . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "Edit":
case "Delete":
case "Create":
echo "\n\t\t\t\t<input type=\"hidden\" id=\"uRestAction\" value=\"{$identifier}\" />\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"cant{$identifier}\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["add"] . "\" onclick=\"addUserRestriction();\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "3":
case "2":
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"relabelPlugin\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["select"] . "\" onclick=\"phynxContextMenu.update('mUserdata','" . ($identifier == "2" ? "relabel" : "hide") . ":'+\$('relabelPlugin').value.split(':')[1], \$('relabelPlugin').value.split(':')[1]);\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><img src=\"./images/navi/warning.png\" style=\"float:left;margin-right:4px;\" />" . $text["maybeHidden"] . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "5":
case "4":
if ($opts == "") {
die("<p>" . $text["noPsOptions"] . "</p>");
}
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"relabelPlugin\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t" . ($identifier == 4 ? "<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["selectPluginButton"] . "\" onclick=\"phynxContextMenu.update('mUserdata','pS:'+\$('relabelPlugin').value.split(':')[0], \$('relabelPlugin').value.split(':')[0]);\" /></td>\n\t\t\t\t\t</tr>" : "<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["selectPluginButton"] . "\" onclick=\"addHidePlugin();\" /></td>\n\t\t\t\t\t</tr>") . "\n\t\t\t\t</table>";
break;
case "pS":
$c = new $s[1]();
$pSs = $c->getPluginSpecificRestrictions();
$pSopts = "";
foreach ($pSs as $key => $value) {
$pSopts .= "<option value=\"{$key}:{$s['1']}\">{$value}</option>";
}
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"pSSelect\">{$pSopts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["save"] . "\" onclick=\"savePluginSpecificRestriction();\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "hide":
case "relabel":
try {
$c = new $s[1](-1);
$c = $c->newAttributes();
echo "\n\t\t\t\t<input type=\"hidden\" id=\"" . $identifier . "Plugin\" value=\"{$s['1']}\" />\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"" . $identifier . "Field\"><option>" . implode("</option><option>", PMReflector::getAttributesArray($c)) . "</option></select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t" . ($identifier == "relabel" ? "<tr>\n\t\t\t\t\t\t<td>" . $text["newFieldName"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input id=\"relabelTo\" type=\"text\" /></td>\n\t\t\t\t\t</tr>" : "") . "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["save"] . "\" onclick=\"" . ($identifier == "relabel" ? "saveFieldRelabeling();" : "saveFieldHiding();") . "\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
} catch (ClassNotFoundException $e) {
echo "<p>Diese Option steht bei diesem Plugin leider nicht zur Verfügung</p>";
}
break;
case "copyFromUser":
$T = new HTMLTable(2);
$T->useForSelection();
$T->setColWidth(1, 20);
$T->maxHeight(200);
$G = new Users();
$G->addAssocV3("isAdmin", "=", "0");
$G->setLimitV3("10");
$G->lCV3();
while ($t = $G->getNextEntry()) {
$T->addRow(array(new Button("", "./images/i2/copy.png", "icon"), $t->A("username")));
$T->addRowEvent("click", "copyFromOtherUser('" . $t->getID() . "');");
}
echo $T;
break;
case "login":
$T = new HTMLTable(2);
$T->useForSelection();
$T->setColWidth(1, 20);
$T->maxHeight(200);
$apps = Applications::getList();
foreach ($apps as $app) {
#rme("mUserdata","-1","setUserdata",new Array("hidePlugin"+$('relabelPlugin').value.split(":")[0],$('relabelPlugin').value.split(":")[0], "pHide", lastLoadedLeft),"contentManager.reloadFrameLeft()");
$T->addRow(array(new Button("", "./plugins/Userdata/login18.png", "icon"), "Kann sich nicht an '{$app}' anmelden"));
$T->addRowEvent("click", OnEvent::rme(new mUserdata(-1), "setUserdata", array("'loginTo{$app}'", "'0'", "'loginTo'", "lastLoadedLeft"), OnEvent::closeContext() . OnEvent::reload("Left")));
#$T->addRowEvent("click", "copyFromOtherUser('".$t->getID()."');");
}
echo $T;
break;
}
}
function makeNewLine2($table, $A)
{
$fields = PMReflector::getAttributesArray($A);
#if(PHYNX_MYSQL_STRICT)
# $this->fixTypes($table, $A);
$values = "NULL";
$sets = "`" . $table . "ID`";
for ($i = 0; $i < count($fields); $i++) {
if ($fields[$i] == $table . "ID") {
continue;
}
#if(is_numeric($A->$fields[$i])) $values .= ", ".$A->$fields[$i]."\n";
#else
$values .= ", '" . $this->c->real_escape_string($A->{$fields}[$i]) . "'\n";
$sets .= ",\n`" . $fields[$i] . "`";
}
$sql = "INSERT INTO\n {$table}\n ({$sets}) VALUES ({$values})";
$_SESSION["messages"]->addMessage("executing MySQL: {$sql}");
$this->c->query($sql);
DBStorage::$queryCounter++;
if ($this->c->error and $this->c->errno == 1054) {
preg_match("/[a-zA-Z0-9 ]*\\'([a-zA-Z0-9\\.]*)\\'[a-zA-Z ]*\\'([a-zA-Z ]*)\\'.*/", $this->c->error, $regs);
throw new FieldDoesNotExistException($regs[1], $regs[2]);
}
if ($this->c->error and $this->c->errno == 1062) {
throw new DuplicateEntryException($this->c->error);
}
if ($this->c->error) {
throw new StorageException($this->c->error);
}
return $this->c->insert_id;
}
function makeNewLine2($table, $A)
{
$fields = PMReflector::getAttributesArray($A);
$values = "''";
$sets = "`" . $table . "ID`";
for ($i = 0; $i < count($fields); $i++) {
if ($fields[$i] == $table . "ID") {
continue;
}
$values .= ", '" . mysql_real_escape_string($A->{$fields}[$i]) . "'\n";
$sets .= ",\n`" . $fields[$i] . "`";
}
$sql = "INSERT INTO\n {$table}\n ({$sets}) VALUES ({$values})";
$_SESSION["messages"]->addMessage("executing MySQL: {$sql}");
mysql_query($sql);
if (mysql_error() and mysql_errno() == 1054) {
preg_match("/[a-zA-Z0-9 ]*\\'([a-zA-Z0-9\\.]*)\\'[a-zA-Z ]*\\'([a-zA-Z ]*)\\'.*/", $this->c->error, $regs);
throw new FieldDoesNotExistException($regs[1], $regs[2]);
}
if (mysql_error() and mysql_errno() == 1062) {
throw new DuplicateEntryException($this->c->error);
}
if (mysql_error()) {
throw new StorageException();
}
return mysql_insert_id();
}
function makeNewLine2($table, $A)
{
$fields = PMReflector::getAttributesArray($A);
#if(PHYNX_MYSQL_STRICT)
# $this->fixTypes($table, $A);
$values = "NULL";
if (self::$useAsNextID != null) {
$values = self::$useAsNextID;
self::$useAsNextID = null;
}
$sets = "`" . $table . "ID`";
for ($i = 0; $i < count($fields); $i++) {
if ($fields[$i] == $table . "ID") {
continue;
}
#if(is_numeric($A->$fields[$i])) $values .= ", ".$A->$fields[$i]."\n";
#else
$cf = $fields[$i];
$values .= ", '" . $this->cWrite->real_escape_string($A->{$cf}) . "'\n";
$sets .= ",\n`" . $cf . "`";
}
$sql = "INSERT INTO\n {$table}\n ({$sets}) VALUES ({$values})";
$_SESSION["messages"]->addMessage("executing MySQL: {$sql}");
Timer::now("sql start", __FILE__, __LINE__);
$this->cWrite->query($sql);
Timer::now("sql end", __FILE__, __LINE__);
DBStorage::$queryCounter++;
if ($this->cWrite->error and $this->cWrite->errno == 1054) {
preg_match("/[a-zA-Z0-9 ]*\\'([a-zA-Z0-9\\.]*)\\'[a-zA-Z ]*\\'([a-zA-Z ]*)\\'.*/", $this->cWrite->error, $regs);
throw new FieldDoesNotExistException($regs[1], $regs[2]);
}
if ($this->cWrite->error and $this->cWrite->errno == 1062) {
throw new DuplicateEntryException($this->cWrite->error);
}
if ($this->cWrite->error) {
throw new StorageException($this->cWrite->error);
}
if ($this->cWrite->error and PHYNX_USE_SYSLOG) {
syslog(LOG_ERR, "MySQL: " . $this->cWrite->error . "(" . $this->cWrite->errno . ") in {$sql}");
}
return $this->cWrite->insert_id;
}
/**
* Outputs the attributes for this class.
*/
public function tellMe()
{
if ($this->A == null) {
$this->lCV3();
}
$c = PMReflector::getAttributesArray($this->getClearClass() . "Attributes");
for ($i = 0; $i < count($c); $i++) {
echo count($this->A->{$c}[$i]) . " " . $this->getClearClass() . " geladen";
}
}
public function getDBData($newFolder = null)
{
$external = false;
if (file_exists(Util::getRootPath() . "../../phynxConfig")) {
$newFolder = Util::getRootPath() . "../../phynxConfig/";
$external = true;
}
if (file_exists(Util::getRootPath() . "../phynxConfig")) {
$newFolder = Util::getRootPath() . "../phynxConfig/";
$external = true;
}
if ($newFolder == null) {
$newFolder = Util::getRootPath() . "system/DBData/";
}
$findFor = "*";
if (isset($_SERVER["HTTP_HOST"])) {
$findFor = $_SERVER["HTTP_HOST"];
}
$data = new mInstallation();
if ($newFolder != "") {
$data->changeFolder($newFolder);
}
$data->setAssocV3("httpHost", "=", $findFor);
#$data->loadCollectionV2();
$n = $data->getNextEntry();
if ($n == null) {
#$data = new mInstallation();
#if($newFolder != "") $data->changeFolder($newFolder);
$data = new mInstallation();
if ($newFolder != "") {
$data->changeFolder($newFolder);
}
$data->setAssocV3("httpHost", "=", "*");
$n = $data->getNextEntry();
}
if ($n != null) {
$n->changeFolder($newFolder);
$d = $n->getA();
} else {
if (!isset($_SERVER["HTTP_CLOUD"])) {
$I = new Installation(-1);
$I->changeFolder($newFolder);
$I->makeNewInstallation();
$d = $I->getA();
}
}
$I2 = new Installation(-1);
$s = PMReflector::getAttributesArray($I2->newAttributes());
$t = array();
if (isset($d)) {
foreach ($s as $key => $value) {
$t[$value] = $d->{$value};
}
}
$t["external"] = $external;
$rt = Environment::getS("databaseData", $t);
return $rt;
}
function makeNewLine2($table, $A)
{
$mf = new PhpFileDB();
$mf->setFolder($this->folder);
#print_r($fields);
$values = "";
$fields = PMReflector::getAttributesArray($A);
for ($i = 0; $i < count($fields); $i++) {
$values .= ($values != "" ? ", " : "") . "'" . $A->{$fields}[$i] . "'\n";
$fields[$i] = "" . $fields[$i] . "";
}
if ($this->file != "") {
$table = $this->file;
}
$sql = "INSERT INTO\n {$table}\n (" . implode(",\n", $fields) . ") VALUES ({$values})";
$_SESSION["messages"]->addMessage("executing phpFileDB: {$sql}");
$mf->pfdbQuery($sql);
return $mf->pfdbInsertId();
}
public function getContextMenuHTML($identifier)
{
$deTexts = array();
$deTexts["pluginSupport"] = "Bitte beachten Sie, dass ein Plugin diese Einstellungen unterstützen muss, selbst wenn es hier angezeigt wird!";
$deTexts["selectPlugin"] = "Bitte Plugin wählen";
$deTexts["add"] = "hinzufügen";
$deTexts["selectPluginButton"] = "Plugin auswählen";
$deTexts["save"] = "speichern";
$deTexts["select"] = "auswählen";
$deTexts["noPsOptions"] = "keine plugin-spezifischen Optionen vorhanden";
$deTexts["newFieldName"] = "Neuer Feldname";
$deTexts["maybeHidden"] = "Bitte beachten Sie, dass hier interne Namen angezeigt werden, die von der Feldbeschriftung abweichen können!<br />Manche internen Felder werden möglichweise gar nicht angezeigt.";
$ac = new anyC();
$singularLanguageClass = $ac->loadLanguageClass("Userdata");
$text = $singularLanguageClass != null ? $singularLanguageClass->getText() : $deTexts;
$opts = "";
$ps = array_flip($_SESSION["CurrentAppPlugins"]->getAllPlugins());
$ms = $_SESSION["CurrentAppPlugins"]->getAllMenuEntries();
#print_r($ms);
foreach ($ps as $key => $value) {
if ($key == "mUserdata") {
continue;
}
if ($identifier == "4" and !PMReflector::implementsInterface($key, "iPluginSpecificRestrictions")) {
continue;
}
if ($identifier == "5" and !in_array($key, $ms)) {
continue;
}
if (!$_SESSION["CurrentAppPlugins"]->getIsAdminOnly($key) and $_SESSION["CurrentAppPlugins"]->isCollectionOfFlip($key) != "") {
$opts .= "<option value=\"{$key}:" . $_SESSION["CurrentAppPlugins"]->isCollectionOfFlip($key) . "\">{$value}</option>";
}
}
$s = explode(":", $identifier);
if (isset($s[1])) {
$identifier = $s[0];
}
switch ($identifier) {
case "1":
$c = isset($text["kann nicht erstellen"]) ? $text["kann nicht erstellen"] : "kann nicht\nerstellen";
$b = isset($text["kann nicht bearbeiten"]) ? $text["kann nicht bearbeiten"] : "kann nicht\nbearbeiten";
$l = isset($text["kann nicht löschen"]) ? $text["kann nicht löschen"] : "kann nicht\nlöschen";
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $c . "\" style=\"background-image:url(./images/navi/new.png);\" onclick=\"phynxContextMenu.update('mUserdata','Create','" . str_replace(array("\n", "'"), array(" ", "\\'"), $c) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $b . "\" style=\"background-image:url(./images/navi/editb.png);\" onclick=\"phynxContextMenu.update('mUserdata','Edit','" . str_replace(array("\n", "'"), array(" ", "\\'"), $b) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" class=\"bigButton backgroundColor2\" value=\"" . $l . "\" style=\"background-image:url(./images/navi/trash.png);\" onclick=\"phynxContextMenu.update('mUserdata','Delete','" . str_replace(array("\n", "'"), array(" ", "\\'"), $l) . ":');\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><img src=\"./images/navi/warning.png\" style=\"float:left;margin-right:4px;\" />" . $text["pluginSupport"] . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "Edit":
case "Delete":
case "Create":
echo "\n\t\t\t\t<input type=\"hidden\" id=\"uRestAction\" value=\"{$identifier}\" />\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"cant{$identifier}\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["add"] . "\" onclick=\"addUserRestriction();\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "3":
case "2":
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"relabelPlugin\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["select"] . "\" onclick=\"phynxContextMenu.update('mUserdata','" . ($identifier == "2" ? "relabel" : "hide") . ":'+\$('relabelPlugin').value.split(':')[1], \$('relabelPlugin').value.split(':')[1]);\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><img src=\"./images/navi/warning.png\" style=\"float:left;margin-right:4px;\" />" . $text["maybeHidden"] . "</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "5":
case "4":
if ($opts == "") {
die("<p>" . $text["noPsOptions"] . "</p>");
}
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $text["selectPlugin"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"relabelPlugin\">{$opts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t" . ($identifier == 4 ? "<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["selectPluginButton"] . "\" onclick=\"phynxContextMenu.update('mUserdata','pS:'+\$('relabelPlugin').value.split(':')[0], \$('relabelPlugin').value.split(':')[0]);\" /></td>\n\t\t\t\t\t</tr>" : "<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["selectPluginButton"] . "\" onclick=\"addHidePlugin();\" /></td>\n\t\t\t\t\t</tr>") . "\n\t\t\t\t</table>";
break;
case "pS":
$c = new $s[1]();
$pSs = $c->getPluginSpecificRestrictions();
$pSopts = "";
foreach ($pSs as $key => $value) {
$pSopts .= "<option value=\"{$key}:{$s['1']}\">{$value}</option>";
}
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"pSSelect\">{$pSopts}</select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["save"] . "\" onclick=\"savePluginSpecificRestriction();\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
break;
case "hide":
case "relabel":
try {
$c = new $s[1](-1);
$c = $c->newAttributes();
echo "\n\t\t\t\t<input type=\"hidden\" id=\"" . $identifier . "Plugin\" value=\"{$s['1']}\" />\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><select id=\"" . $identifier . "Field\"><option>" . implode("</option><option>", PMReflector::getAttributesArray($c)) . "</option></select></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t" . ($identifier == "relabel" ? "<tr>\n\t\t\t\t\t\t<td>" . $text["newFieldName"] . ":</td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input id=\"relabelTo\" type=\"text\" /></td>\n\t\t\t\t\t</tr>" : "") . "\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input type=\"button\" value=\"" . $text["save"] . "\" onclick=\"" . ($identifier == "relabel" ? "saveFieldRelabeling();" : "saveFieldHiding();") . "\" /></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>";
} catch (ClassNotFoundException $e) {
echo "<p>Diese Option steht bei diesem Plugin leider nicht zur Verfügung</p>";
}
break;
case "copyFromUser":
echo "\n\t\t\t\t<table>\n\t\t\t\t\t<colgroup>\n\t\t\t\t\t\t<col style=\"width:20px;\" />\n\t\t\t\t\t\t<col class=\"backgroundColor2\" />\n\t\t\t\t\t</colgroup>";
$G = new Users();
$G->addAssocV3("isAdmin", "=", "0");
#$G->addAssocV3("UserID","!=",$this->ID);
#$G->addJoinV3("Auftrag","AuftragID","=","AuftragID");
#$G->setAssocV3("is$identifier","=","1");
#if($bps != -1) $G->addAssocV3("GRLBMID","!=",$bps["loadGRLBMID"]);
#$G->addOrderV3("nummer","DESC");
$G->setLimitV3("10");
$G->lCV3();
while ($t = $G->getNextEntry()) {
echo "\n\t\t\t\t\t<tr onclick=\"copyFromOtherUser('" . $t->getID() . "');\" class=\"\" onmouseout=\"this.className='';\" style=\"cursor:pointer;\" onmouseover=\"this.className = 'backgroundColor0';\">\n\t\t\t\t\t\t<td><img src=\"./images/i2/copy.png\" class=\"mouseoverFade\" /></td>\n\t\t\t\t\t\t<td>" . $t->getA()->username . "</td>\n\t\t\t\t\t</tr>";
}
echo "\n\t\t\t\t</table>";
break;
}
}
/**
* Same as lCV4, but without typesafe capabilities.
* @deprecated since version 20160218
* @return Object All objects matching selectStatement
*/
function lCV3()
{
$this->parseSearchString();
if ($this->DBS == null) {
$this->getConnection();
}
if ($this->selectStatement->AttributesClassName == "") {
$this->selectStatement->AttributesClassName = $this->selectStatement->table[0] . (count($this->selectStatement->joinTables) > 0 ? "Join" : "") . "Attributes";
}
if (count($this->selectStatement->fields) == 0) {
$this->selectStatement->fields = PMReflector::getAttributesArray($this->selectStatement->AttributesClassName);
}
#$this->selectStatement->table[0].(count($this->selectStatement->joinTables) > 0 ? "Join" : "")."Attributes");
if (!in_array($this->selectStatement->table[0] . "ID", $this->selectStatement->fields)) {
$this->selectStatement->fields[] = (count($this->selectStatement->joinTables) > 0 ? "t1." : "") . $this->selectStatement->table[0] . "ID";
}
$this->DBS->setParser($this->parsers);
if ($this->affectedRowsOnly) {
$this->affectedRowsOnly = false;
}
$return = $this->DBS->loadMultipleV3($this->selectStatement);
if ($return != null and is_array($return)) {
foreach ($return as $k => $v) {
$v->parsers = $this->hasParsers;
}
}
return $return;
}
function makeNewLine2($table, $A)
{
$fields = PMReflector::getAttributesArray($A);
$values = "NULL";
if (self::$useAsNextID != null) {
$values = self::$useAsNextID;
self::$useAsNextID = null;
}
$sets = "`" . $table . "ID`";
for ($i = 0; $i < count($fields); $i++) {
if ($fields[$i] == $table . "ID") {
continue;
}
$values .= ", " . $this->c->quote($A->{$fields}[$i]) . "\n";
$sets .= ",\n`" . $fields[$i] . "`";
}
$sql = "INSERT INTO\n {$table}\n ({$sets}) VALUES ({$values})";
$_SESSION["messages"]->addMessage("executing PDO: {$sql}");
$this->c->exec($sql);
print_r($this->c->errorInfo());
DBPDOStorage::$queryCounter++;
#if($this->cWrite->error AND $this->cWrite->errno == 1054) {
# preg_match("/[a-zA-Z0-9 ]*\'([a-zA-Z0-9\.]*)\'[a-zA-Z ]*\'([a-zA-Z ]*)\'.*/", $this->cWrite->error, $regs);
# throw new FieldDoesNotExistException($regs[1],$regs[2]);
#}
#if($this->cWrite->error AND $this->cWrite->errno == 1062) throw new DuplicateEntryException($this->cWrite->error);
#if($this->cWrite->error) throw new StorageException($this->cWrite->error);
return $this->c->lastInsertId();
}
