/** * 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(); }