function passbuilder_template($template) { $url = new UrlParams(); $current_role = Helper::getRole(); $urlParams = $url->getQueryArray(); if (array_key_exists('pass-builder', $urlParams)) { if (is_user_logged_in()) { if ($current_role != '') { // form submit handle here if ($_POST['formAction']) { $handler = new FormHandler($_POST['formAction']); $handler->handleSubmit(); } if ($_GET['action']) { $handler = new ActionHandler($_GET['action']); $handler->fireAction(); } return dirname(__FILE__) . '/templates/page-pass-template.php'; } else { return dirname(__FILE__) . '/templates/page-permission-exceptions.php'; } } else { $loginUrl = ICL_LANGUAGE_CODE == 'en' ? get_site_url() . '/log-in/' : get_site_url() . '/da/log-in-2/'; wp_redirect($loginUrl); } } return $template; }
$selcal = new SelectMenu($lang->get("calendar_select", "Select Calendar"), "calsel", "pgn_cal_calendars", "NAME", "CALID", "1"); $filtermenu = new StdMenu(""); $filtermenu->addMenuEntry($lang->get("calendars_edit", "Edit Calendar"), "edit.php", "", "CALENDAR_EDIT"); $filtermenu->addMenuEntry($lang->get("calendars_define", "Define Calendars"), "calendars.php", "", "CALENDAR_CREATE"); $filtermenu->addMenuEntry($lang->get("calendars_cat_define", "Define Categories"), "categories.php", "", "CALENDAR_CREATE"); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_calendars WHERE CALID = {$oid}"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_appointments WHERE CALID = {$oid}"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_categories WHERE CALID = {$oid}"); $oid = value("oid", "NUMERIC"); if ($selcal->selected != "0" && $selcal->selected != "-1") { if ($oid == "0" && $page_action != "INSERT") { $form = new MenuForm($lang->get("sel_event", "Select Event or Appointment"), array($lang->get("startdate", "Startdate"), $lang->get("starttime", "Starttime"), $lang->get("title", "Title")), "pgn_cal_appointment", "APID", array("STARTDATE", "STARTTIME", "TITLE"), "CALID=" . $selcal->selected); $form->newAction = "plugin/calendar/edit.php?sid={$sid}&go=create"; } else { $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_appointment WHERE APID = {$oid}"); $addtext = ": " . getDBCell("pgn_cal_appointment", "TITLE", "APID = " . $oid); $form = new stdEDForm($lang->get("cal_edit", "Edit Appointment") . $addtext); $form->addHeaderLink(crHeaderLink('Back', "plugin/calendar/edit.php?sid={$sid}")); $cond = $form->setExPK("pgn_cal_appointment", "APID"); $form->add(new TextInput($lang->get("title"), "pgn_cal_appointment", "TITLE", $cond, "type:text,width:300,size:64", "MANDATORY")); $form->add(new RichEditInput($lang->get("description"), "pgn_cal_appointment", "DESCRIPTION", $cond, "type:rich,width:350,size:6", "")); $form->add(new DateInput($lang->get("startdate"), "pgn_cal_appointment", "STARTDATE", $cond, "param:form1", "MANDATORY")); $form->add(new TimeInput($lang->get("starttime"), "pgn_cal_appointment", "STARTTIME", $cond)); $form->add(new DateInput($lang->get("endate"), "pgn_cal_appointment", "ENDDATE", $cond, "param:form1", "MANDATORY")); $form->add(new TimeInput($lang->get("endtime"), "pgn_cal_appointment", "ENDTIME", $cond)); $form->add(new SelectOneInput($lang->get("category"), "pgn_cal_appointment", "CATID", "pgn_cal_categories", "NAME", "CATID", "CALID = " . $selcal->selected, $cond)); $form->add(new NonDisplayedValueOnInsert("pgn_cal_appointment", "CALID", $cond, $selcal->selected, "NUMBER")); $form->add(new SubTitle("st", $lang->get("Report", "Veranstaltungsbericht"), 3)); $form->add(new RichEditInput($lang->get("report"), "pgn_cal_appointment", "REPORT", $cond, "type:rich,width:350,size:6", ""));
**********************************************************************/ require_once "../../config.inc.php"; $auth = new auth("COMPOUND_GROUPS"); $page = new page("Compound Groups"); $filter = new Filter("compound_groups", "CGID"); $filter->addRule($lang->get("name"), "NAME", "NAME"); $filter->setAdditionalCondition("VERSION = 0"); $filter->icon = "li_cggroup.gif"; $filter->type_name = $lang->get("cp_group"); $filtermenu = new Filtermenu($lang->get("cp_group"), $filter); $filtermenu->tipp = $lang->get("help_compgrp", "Compound group is a group of clusters. Clusters templates may have an own layout. This enables you to build your homepage out of blocks, e.g. News-Article, Poll, Image-Gallery all on one page and on demand."); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM compound_groups where CGID=$oid AND CGID > 999"); $deleteHandler->addDbAction("DELETE FROM compound_group_members where CGID=$oid"); $form = new stdEDForm($lang->get("ed_cpgroup", "Edit Compound Group")); $cond = $form->setPK("compound_groups", "CGID"); if ($oid != "" && $page_action != "DELETE") { $form->buttonbar->add("todo", $lang->get("launch"), "submit", ""); $form->headerlink = crHeaderLink($lang->get("ed_cpgroup"), "modules/compoundgroup/compound_group_members.php?sid=$sid&oid=$oid&go=update"); } $form->add(new TextInput($lang->get("group_name"), "compound_groups", "NAME", $cond, "type:text,width:200,size:32", "MANDATORY&UNIQUE")); $form->add(new TextInput($lang->get("group_description", "Description"), "compound_groups", "DESCRIPTION", $cond, "type:textarea,width:340,size:2", "")); $form->add(new Hidden("todo", "")); $values = array();
<? /********************************************************************** * @module Application **********************************************************************/ require_once "../../config.inc.php"; $auth= new auth("CUSTOMERCAREADMIN"); $page= new page ("Tickets Category Administration"); $filter = new Filter("tickets_categories", "id"); $filter->addRule("Category", "name", "name"); $menu = new Filtermenu("Edit Categories", $filter); include "menudef.inc.php"; $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM tickets_categories where id=$oid"); $form = new stdEDForm("Edit Ticket Categories", ""); $cond = $form->setPK("tickets_categories", "id"); $form->add(new TextInput("Name", "tickets_categories", "name", $cond, "type:text,width:200,size:32", "MANDATORY&UNIQUE")); $form->add(new TextInput("POP-Server", "tickets_categories", "pophost", $cond, "type:text,width:200,size:32", "MANDATORY")); $form->add(new TextInput("POP-Username", "tickets_categories", "popuser", $cond, "type:text,width:200,size:32", "MANDATORY")); $form->add(new TextInput("POP-Password", "tickets_categories", "poppass", $cond, "type:text,width:200,size:32", "MANDATORY")); $form->add(new TextInput("Reply-To-Address", "tickets_categories", "replyto", $cond, "type:text,width:200,size:32", "MANDATORY")); $form->add(new TextInput("Notify From", "tickets_categories", "notify_from", $cond, "type:text,width:200,size:64", "")); $form->add(new TextInput("Notify To", "tickets_categories", "notify_to", $cond, "type:text,width:200,size:64", "")); $form->add(new TextInput("Notify Subject", "tickets_categories", "notify_subject", $cond, "type:text,width:200,size:64", "")); $form->add(new TextInput("Notify ReplyTo", "tickets_categories", "notify_replyto", $cond, "type:text,width:200,size:64", "")); $form->add(new TextInput("Notify Body", "tickets_categories", "notify_body", $cond, "type:textarea,width:350,size:6", ""));
$page = new page("Role Administration"); $filter = new Filter("roles", "ROLE_ID"); $filter->addRule($lang->get("role_name"), "ROLE_NAME", "ROLE_NAME"); $filter->setAdditionalCondition("UPPER(ROLE_NAME) <> 'ADMINISTRATOR'"); $filter->prevent_sysvar_disp = false; $filter->icon = "li_role.gif"; $filter->type_name = "Roles"; $filtermenu = new Filtermenu($lang->get("role_filtermenu"), $filter); $filtermenu->addMenuEntry($lang->get("user_link"), "user_general.php"); $filtermenu->addMenuEntry($lang->get("group_link"), "group_general.php"); $filtermenu->addMenuEntry($lang->get("role_link"), "role_general.php"); $filtermenu->tipp = ""; //$filtermenu->addLink("test", "test.php"); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM roles where role_id=$oid AND role_id>999"); $deleteHandler->addDbAction("DELETE FROM user_permissions where role_id=$oid AND role_id > 999"); $deleteHandler->addDbAction("DELETE FROM role_sys_functions where role_id=$oid AND role_id > 999"); if ($oid == 0) { $addtext = ""; } else { $addtext = ": " . getDBCell("roles", "ROLE_NAME", "ROLE_ID = " . $oid); } $form = new stdEDForm($lang->get("role_head"). $addtext, "i_role.gif"); $cond = $form->setExPK("roles", "ROLE_ID"); $cond .= " AND UPPER(ROLE_NAME) <> 'ADMINISTRATOR'"; if ($oid != "") {
/** * Create a new Record with the given $this->fkid in the database. * Initialize with standard values! */ function createRecord() { $createHandler = new ActionHandler("CREATE"); $createHandler->addDBAction("INSERT INTO {$this->management_table} ({$this->pk_name}) VALUES ({$this->fkid})"); $createHandler->process("CREATE"); }
require "../../config.inc.php"; require "menudef.inc.php"; $menu->tipp= $lang->get("help_synccl", "A feature used for synchronizing clusters after having modified/changed a cluster template."); $auth = new auth("SYNC_CLUSTERS"); $page = new page("Synchronize Clusters"); $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm($lang->get("sync_clusters")); $form->addToTopText($lang->get("sync_clusters_descr", "Whe you are changing a cluster template, the clusters are not automatically synched. They are synched when you are working with them the next time. You can sync all of them here.")); $maintenanceHandler = new ActionHandler("sync"); $maintenanceHandler->addFncAction("syncClids"); $form->addCheck("sync", $lang->get("sync_clusters")." ", $maintenanceHandler); $page->add($form); $page->addMenu($menu); $page->draw(); $db->close(); function syncClids() { global $db, $form; $counter = 0; $sql = "SELECT cv.CLID FROM cluster_variations cv, cluster_node cn WHERE cv.DELETED=0 AND cv.CLNID=cn.CLNID AND cn.VERSION=0"; $query = new query($db, $sql); while ($query->getrow()) { syncCluster($query->field("CLID"));
* along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require "../../config.inc.php"; $auth = new auth("MAINTENANCE"); $page = new page("Clear TempCache"); $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm($lang->get("clear_cache", "Clear Cache")); $form->addToTopText($lang->get("mt_clear_cache", "Clear the temporory cache files.")); $maintenanceHandler = new ActionHandler("generate"); $maintenanceHandler->addFncAction("emptyTMPCache"); $form->addCheck("generate", $lang->get("clear_cache", "Clear Cache"), $maintenanceHandler); $page->add($form); $page->draw(); $db->close(); function emptyTMPCache() { global $c; $dir = $c["dyncachepath"]; $files = opendir($dir); while ($file = readdir ($files)) { if($file != "." && $file != "..") {
} if ($action == "createarticle") { $go = "CREATE"; $page_action = "INSERT"; $form = new stdEDForm($lang->get("create_article", "Create new Article in channel") . " " . getDBCell("channels", "NAME", "CHID = " . $chid), ""); $cond = $form->setPK("channel_articles", "ARTICLE_ID"); $oname = new TextInput($lang->get("name"), "channel_articles", "TITLE", $cond, "type:text,width:300,size:64", "MANDATORY"); $form->add($oname); $form->add(new SelectOneInput($lang->get("template"), "channel_articles", "CLT_ID", "cluster_templates, channel_cluster_templates", "NAME", "channel_cluster_templates.CLT_ID AS CLT", "cluster_templates.CLT_ID = channel_cluster_templates.CLT_ID AND channel_cluster_templates.CHID = {$chid} ORDER BY POSITION ASC", $cond, "TYPE:DROPDOWN", "MANDATORY")); $form->add(new SelectOneInput($lang->get("category"), "channel_articles", "CH_CAT_ID", "channel_categories", "NAME", "CH_CAT_ID", "CHID = {$chid}", $cond, "type:dropdown", "MANDATORY")); $form->add(new PositionInput($lang->get("position", "Position"), "channel_articles", "POSITION", $cond, "CHID={$chid} AND VERSION=0", "size:4,width:50")); $form->add(new Hidden("action", "createarticle")); $form->add(new NonDisplayedValueOnInsert("channel_articles", "CHID", $cond, $chid, "NUMBER")); $form->add(new NonDisplayedValueOnInsert("channel_articles", "ARTICLE_DATE", $cond, "NOW()", "NUMBER")); $form->forbidDelete(true); $handler = new ActionHandler("INSERT"); $handler->addFncAction("createClusterNodeForArticle"); $form->registerActionHandler($handler); $page->add($form); $page->drawAndForward("modules/channels/edit.php?sid={$sid}&oid=<oid>&go=update"); } else { // Flag for configuration of cluster-panel... $clt = getDBCell("channel_articles", "CLT_ID", "ARTICLE_ID = {$oid}"); $isArticle = true; $page_action = "UPDATE"; $clid = syncArticleVariation($oid, $variation); syncCluster($clid); $view = initValue("view", doc() . "view", 1); $title = getDBCell("channel_articles", "TITLE", "ARTICLE_ID = {$clnid}"); $form = new PanelForm($lang->get("edit_article", "Edit Article") . " " . $title, "", 'articlesform'); $form->quickpanel = true;
if ($userinfo['datum_anmeldung']) { $numberOfRegisteredDays = round(($website->getNowAsTimestamp() - $userinfo['datum_anmeldung']) / (3600 * 24)); BadgesDataService::awardBadgeIfApplicable($website, $db, $userId, 'membership_since_x_days', $numberOfRegisteredDays); } $_SESSION['badgechecked'] = 1; } // get page ID and parse it by router $pageId = $website->getRequestParameter(PARAM_PAGE); $pageId = PageIdRouter::getTargetPageId($website, $i18n, $pageId); $website->setPageId($pageId); $validationMessages = null; // handle action $actionId = $website->getRequestParameter(PARAM_ACTION); if ($actionId !== NULL) { try { $targetId = ActionHandler::handleAction($website, $db, $i18n, $actionId); if ($targetId != null) { $pageId = $targetId; } } catch (ValidationException $ve) { $validationMessages = $ve->getMessages(); $website->addFrontMessage(new FrontMessage(MESSAGE_TYPE_ERROR, $i18n->getMessage('validation_error_box_title'), $i18n->getMessage('validation_error_box_message'))); } catch (Exception $e) { $website->addFrontMessage(new FrontMessage(MESSAGE_TYPE_ERROR, $i18n->getMessage('errorpage_title'), $e->getMessage())); } } $website->setPageId($pageId); // get and set navigation items $navItems = NavigationBuilder::getNavigationItems($website, $i18n, $page, $pageId); $parameters['navItems'] = $navItems; // get and set breadcrumb
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require_once "../../config.inc.php"; require_once "ingredient_editor.php"; require_once "tag_selector.php"; $auth = new auth("ADMINISTRATOR"); $page = new Page("Edit Recipe"); $form = new stdEDForm($lang->get("edrecipe", "Edit Recipe")); $cond = $form->setPK("pgn_recipes", "ID"); $form->addHeaderLink(crHeaderLink($lang->get("back"), "plugin/recipe/overview.php?sid=" . $sid)); $form->add(new TextInput($lang->get("name", "NAME"), "pgn_recipes", "NAME", $cond, "type:text,size:64,width:200", "MANDATORY")); if ($page_action == "UPDATE") { $values = createNameValueArrayEx("pgn_recipes_tags", "TAG", "TAG_ID", "1", "ORDER BY TAG ASC"); $form->add(new TagEditor("Tags", "pgn_recipes_tag_relation", "REC_ID", $oid, "TAG_ID", $values)); } $form->add(new SubTitle("st", $lang->get("ingredients", "Ingredients"), 2)); $form->add(new IngredientEditor("pgn_recipes", $cond)); $form->add(new SubTitle("st", $lang->get("preparation", "Preparation"), 2)); $form->add(new TextInput($lang->get("preparation", "Preparation"), "pgn_recipes", "PREPARATION", $cond, "type:textarea,size:6,width:300", "")); $form->add(new TextInput($lang->get("description", "Description"), "pgn_recipes", "DESCRIPTION", $cond, "type:textarea,size:6,width:300", "")); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM pgn_recipes WHERE ID={$oid} "); $deleteHandler->addDbAction("DELETE FROM pgn_recipes_tag_relation WHERE REC_ID={$oid} "); $form->registerActionHandler($deleteHandler); $page->add($form); $page->draw();
if ($auth->checkAccessToFunction("CHANNEL_LAUNCH")) { $form->buttonbar->add("action", $lang->get("launch")); $form->add(new Hidden("action", "")); if (value("action") == $lang->get("launch")) { launchChannel($oid); if ($errors == "") { $form->addToTopText($lang->get("chnlaunched", "The channel was launched successfully.")); $form->topicon = "ii_success.gif"; } else { $form->addToTopText($lang->get("chnlaunchederr", "An error occured while launching the channel.")); $form->topicon = "ii_error.gif"; } $page_action = "UPDATE"; $go = "update"; $processing = "no"; $page_state = "start"; } } $form->add(new TextInput($lang->get("name"), "channels", "NAME", $cond, "type:text,width:200,size:64", "MANDATORY&UNIQUE")); if ($page_action != "INSERT") { $updateHandler = new ActionHandler("UPDATE"); $updateHandler->addFNCAction("syncSPMVariations"); $form->registerActionHandler($updateHandler); $members = createNameValueArrayEx("cluster_templates", "NAME", "CLT_ID", "CLT_TYPE_ID=1 AND DELETED=0 AND VERSION=0"); $form->add(new SelectMultiple2Input($lang->get("spm_variations"), "sitepage_variations", "VARIATION_ID", "SPM_ID=" . $oid, "variations", "NAME", "VARIATION_ID", "DELETED=0")); $form->add(new SelectMultipleInputPos($lang->get("clt_select", "Select cluster templates"), $members, "channel_cluster_templates", "CLT_ID", "CHID", $cond, "cluster_templates", "CLT_ID", "NAME", "standardlight", 2)); } $page->addMenu($filtermenu); $page->add($form); $page->drawAndForward("modules/channels/channels.php?sid={$sid}&oid=<oid>&go=update"); echo $errors;
* but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require_once "../../config.inc.php"; $auth = new auth("NEWSLETTERADM"); $page = new page("Newsletter configuration"); include "logic/menudef.inc.php"; $filter = new Filter("mailinglist", "MAILINGLIST_ID"); $filter->addRule($lang->get("name"), "NAME", "NAME"); $filter->type_name = $lang->get("newsletter", "Newsletter"); $filtermenu = new Filtermenu($lang->get("newsletter"), $filter); $deleteHandler = new ActionHandler("Delete"); $deleteHandler->addDBAction("Delete from mailinglist Where MAILINGLIST_ID = <oid>"); $form = new StdEDForm($lang->get("edit_newsletter", "Edit newsletter")); $cond = $form->setPK("mailinglist", "MAILINGLIST_ID"); $form->add(new TextInput($lang->get("name"), "mailinglist", "NAME", $cond, "type:text,width:300,size:128", "MANDATORY&UNIQUE")); $form->add(new TextInput($lang->get("description"), "mailinglist", "DESCRIPTION", $cond, "type:textarea,width:300,size:8")); $form->add(new TextInput($lang->get("from_name", 'Sender Name'), "mailinglist", "FROM_NAME", $cond, "type:text,width:300,size:128", "MANDATORY")); $form->add(new TextInput($lang->get("from_email", 'Sender EMail'), "mailinglist", "FROM_EMAIL", $cond, "type:text,width:300,size:128", "MANDATORY")); $form->registerActionHandler($deleteHandler); $page->addMenu($filtermenu); $page->add($form); $page->draw(); echo $errors; ?>
} //// ACL Check //// $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm("Destroy Tree"); $pageHandler = new ActionHandler("destroypages"); $pageHandler->addFNCAction("destroyTree"); $form->addCheck("destroypages", $lang->get("destroy_tree", "Destroy Tree"), $pageHandler); $clusterHandler = new ActionHandler("destroycluster"); $clusterHandler->addFNCAction("destroyTree"); $form->addCheck("destroycluster", $lang->get("destroy_exclusive_content", "Destroy exclusive content"), $clusterHandler); $form->backpage="modules/sitepages/sitepagebrowser.php?sid=".$sid; $form->add(new Hidden("del", value("del"))); $form->add(new Hidden("sid", $sid)); $form->add(new LinkLabel("lbl", $lang->get("back_sp", "Back to Website").">>", "modules/sitepages/sitepagebrowser.php?sid=".$sid, "_self", "informationheader", 2)); $destroyexecuted = false; $page->add($form); $page->draw(); echo $errors; function destroyTree() { global $destroyexecuted, $form, $db;
* GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require_once "../../config.inc.php"; $auth = new auth("ADMINISTRATOR|QUOTER"); $page = new page("Quote of the day"); $filter = new Filter("pgn_quote", "QUOTE_ID"); $filter->addRule("Title", "TITLE", "TITLE"); $filter->addRule("Quote", "QUOTE", "TITLE"); $filtermenu = new Filtermenu("Browse Quotes", $filter); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM pgn_quote where QUOTE_ID=$oid"); $form = new stdEDForm("Edit Quote", ""); $cond = $form->setPK("pgn_quote", "QUOTE_ID"); $form->add(new TextInput("Title", "pgn_quote", "TITLE", $cond, "type:text,width:300,size:64", "MANDATORY&UNIQUE")); $form->add(new TextInput("Quote", "pgn_quote", "QUOTE", $cond, "type:textarea,width:300,size:3", "")); $form->registerActionHandler($deleteHandler); $page->addMenu($filtermenu); $page->add($form); $page->draw(); ?>
$filter->icon = "li_user.gif"; $filter->type_name = "Users"; $filtermenu = new Filtermenu($lang->get("user_filtermenu"), $filter); $filtermenu->addMenuEntry($lang->get("user_link"), "user_general.php", "user_premissions.php"); $filtermenu->addMenuEntry($lang->get("group_link"), "group_general.php"); $filtermenu->addMenuEntry($lang->get("role_link"), "role_general.php"); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM users where user_id=$oid and user_id > 999"); $deleteHandler->addDbAction("DELETE FROM temp_vars where user_id=$oid and user_id > 999"); $deleteHandler->addDbAction("DELETE FROM user_session where user_id=$oid and user_id > 999"); $deleteHandler->addDbAction("DELETE FROM user_permissions where user_id=$oid and user_id > 999"); $insertHandler = new ActionHandler("INSERT"); $insertHandler->addDbAction("INSERT INTO user_session (USER_ID) VALUES (<oid>)"); $insertHandler->addDbAction("INSERT INTO temp_vars (NAME, USER_ID, VALUE) VALUES ('variation', <oid>, 1)"); $insertHandler->addDBAction("INSERT INTO temp_vars (NAME, USER_ID, VALUE) VALUES ('mid', <oid>, 0)"); if ($oid == 0) { $addtext = ""; } else { $addtext = ": " . getDBCell("users", "USER_NAME", "USER_ID = " . $oid); } $form = new stdEDForm($lang->get("user_head"). $addtext, "i_myprofile.gif"); $form->submitButtonAction = "if (document.form1.users_PASSWORD_1.value != '') document.form1.users_PASSWORD_1.value = document.form1.users_PASSWORD_2.value = hex_md5(document.form1.users_PASSWORD_1.value);"; $cond = $form->setPK("users", "USER_ID");
<?php require "../../config.inc.php"; $filtermenu = new StdMenu('Export Translation File'); include "menu.php"; $auth = new auth("SYNC_CLUSTERS"); $page = new page("Export Translation File"); $go = value("go"); $export = ""; if ($go == "0") { $go = "start"; } $form = new CommitForm('Export Translation'); $form->addToTopText('Export Translation File as CSV'); $maintenanceHandler = new ActionHandler("export"); $maintenanceHandler->addFncAction("exportLanguages"); $form->addCheck("export", "Export ", $maintenanceHandler); $page->add($form); $page->addMenu($filtermenu); $page->draw(); $db->close(); if ($export != "") { echo '<textarea style="width:600px;height:300px;font-size:9px;">' . $export . '</textarea>'; } function exportLanguages() { global $export, $recordsets; $variations = createDBCArray("variations", "VARIATION_ID", '1', 'ORDER BY VARIATION_ID ASC'); $variations2 = createDBCArray("variations", "SHORTTEXT", '1', 'ORDER BY VARIATION_ID ASC'); $export = 'TYPE|KEY1|KEY2'; for ($i = 0; $i < count($variations2); $i++) {
$auth = new auth("USER_MANAGEMENT"); $page = new page("User Administration"); $page->setJS("md5"); $filter = new Filter("auth_user", "user_id"); $filter->addRule($lang->get("email"), "email", "email"); $filter->icon = "li_user.gif"; $filter->type_name = "Users"; $filtermenu = new Filtermenu($lang->get("user_filtermenu"), $filter); $filtermenu->addMenuEntry($lang->get("user_link"), "user_general.php", "user_premissions.php"); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM auth_user where user_id=$oid and user_id > 999"); $form = new stdEDForm($lang->get("user_head"), "i_myprofile.gif"); $form->submitButtonAction = "if (document.form1.auth_user_password_1.value != '') document.form1.auth_user_password_1.value = document.form1.auth_user_password_2.value = hex_md5(document.form1.auth_user_password_1.value);"; $cond = $form->setPK("auth_user", "user_id"); $form->add(new TextInput($lang->get("email"), "auth_user", "email", $cond, "type:text,width:300,size:64", "MANDATORY&UNIQUE")); $form->add(new TextInput($lang->get("password"), "auth_user", "password", $cond, "type:text,width:200,size:40", "MANDATORY")); $form->add(new CheckboxInput($lang->get("user_active"), "auth_user", "active", $cond, "1", "0")); $form->add(new TextInput($lang->get("confirmcode", "Confirm-Code"), "auth_user", "confirm", $cond, "type:text,width:300,size:40", "MANDATORY&UNIQUE")); // Control Information $form->add(new NonDisplayedValueOnInsert("auth_user", "registration_date", $cond, "NOW()", "TIMESTAMP")); $form->registerActionHandler($deleteHandler);
/** * Uninstalls a Plugin * @param integer GUID of the plugin to uninstall. */ function uninstallPlugin($oid) { global $db; // module uninstall handler includePGNSource($oid); $modRef = createPGNRef($oid, 0); if ($modRef != null) { $modRef->registration(); $modRef->_uninstaller(); // content deletion $delHandler = new ActionHandler("DELETE"); $sql = "SELECT CID FROM content WHERE MODULE_ID = {$oid}"; $query = new query($db, $sql); while ($query->getrow()) { $cid = $query->field("CID"); $delHandler->addDBAction("DELETE FROM meta WHERE CID = {$cid}"); $delHandler->addDBAction("UPDATE cluster_template_items SET FKID=0 WHERE FKID={$cid}"); $delHandler->addDBAction("DELETE FROM content_variations WHERE CID = {$cid}"); $delHandler->addDBAction("DELETE FROM content WHERE CID = {$cid}"); } // meta-templates deletion. $mtid = getDBCell("modules", "MT_ID", "MODULE_ID = {$oid}"); if ($mtid != 0) { $delHandler->addDBAction("DELETE FROM meta_template_items WHERE MT_ID = {$mtid}"); $delHandler->addDBAction("DELETE FROM meta_templates WHERE MT_ID = {$mtid}"); } $delHandler->addDBAction("DELETE FROM modules WHERE MODULE_ID = {$oid}"); $delHandler->process("DELETE"); $delHandler = new ActionHandler("DELETE"); // cluster deletion. $delHandler->addDBAction("UPDATE cluster_template_items SET FKID = 0 WHERE FKID = {$oid} AND CLTITYPE_ID=2"); $cltis = createDBCArray("cluster_template_items", "CLTI_ID", "CLTITYPE_ID = 2 AND FKID = {$oid}"); for ($i = 0; $i < count($cltis); $i++) { $id = $cltis[$i]; $delHandler->addDBAction("DELETE FROM cluster_content WHERE CLTI_ID = {$id}"); } $delHandler->process("DELETE"); writeDataTypeArray(); } }
<?php require_once "../../config.inc.php"; $auth = new auth("CALENDAR_CREATE"); $page = new Page("Edit Calendars"); $selcal = new SelectMenu($lang->get("calendar_select", "Select Calendar"), "calsel", "pgn_cal_calendars", "NAME", "CALID", "1"); $filter = new Filter("pgn_cal_calendars", "CALID"); $filter->addRule($lang->get("cal_name", "Calendar Name"), "NAME", "NAME"); $filter->type_name = $lang->get("calendars", "Calendars"); $filtermenu = new Filtermenu("", $filter); $filtermenu->addMenuEntry($lang->get("calendars_edit", "Edit Calendar"), "edit.php", "", "CALENDAR_EDIT"); $filtermenu->addMenuEntry($lang->get("calendars_define", "Define Calendars"), "calendars.php", "", "CALENDAR_CREATE"); $filtermenu->addMenuEntry($lang->get("calendars_cat_define", "Define Categories"), "categories.php", "", "CALENDAR_CREATE"); $filtermenu->tipp = $lang->get("calendars_tipp", "You can create several calendars here. Each calendar will have its own events and dates."); $deleteHandler = new ActionHandler("DELETE"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_calendars WHERE CALID = {$oid}"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_appointment WHERE CALID = {$oid}"); $deleteHandler->addDbAction("DELETE FROM pgn_cal_categories WHERE CALID = {$oid}"); if ($oid == 0) { $addtext = ""; } else { $addtext = ": " . getDBCell("pgn_cal_calendars", "NAME", "CALID = " . $oid); } $form = new stdEDForm($lang->get("calendar", "Calendar") . $addtext); $cond = $form->setExPK("pgn_cal_calendars", "CALID"); $form->add(new TextInput($lang->get("name"), "pgn_cal_calendars", "NAME", $cond, "type:text,width:200,size:64", "MANDATORY&UNIQUE")); $form->registerActionHandler($deleteHandler); $page->addMenu($filtermenu); $page->add($form); $page->draw();
/** * Create a new Record with the given $this->fkid in the database. * Initialize with standard values! */ function createRecord() { $createHandler = new ActionHandler("CREATE"); $createHandler->addDBAction("INSERT INTO $this->management_table ($this->pk_name, FILENAME, ALT, WIDTH, HEIGHT, COPYRIGHT) VALUES ($this->fkid, '', '', 0,0,'')"); $createHandler->process("CREATE"); }
<?php require_once "../../config.inc.php"; require "sitemap.php"; $auth = new auth("GOOGLESITEMAP"); $page = new page("Google Sitemaps"); $variations = createDBCArray("variations", "VARIATION_ID", "1"); if (!isset($go)) { $go = "start"; } $form = new CommitForm($lang->get("udgoogles", 'Update Google Sitemaps')); $updateHandler = new ActionHandler("updategs"); $updateHandler->addFNCAction("updateSitemap"); $form->addCheck("updategs", $lang->get("startgoogles", 'Update the Google Sitemap XML to: ') . $c["host"] . $c["livedocroot"] . 'sitemap.xml', $updateHandler); $page->add($form); $page->draw(); $db->close(); /** * Creates the new sitemap.xml */ function updateSitemap() { global $c; // Create sitemap $map = new GoogleSiteMap(); // Get the startnode of the live website; $startNode = translateState(0, 10); // Is there a live-website? if (strlen($startNode) > 0) { addWebsite($startNode, $map); $map->CloseMap();
$folderHandler->addDBAction("DELETE FROM categories WHERE DELETED=1"); $form->addCheck("folders", $lang->get("purge_folder"), $folderHandler); $variationHandler = new ActionHandler("variations"); $variationHandler->addFNCAction("purgeVariations"); $form->addCheck("variations", $lang->get("purge_var"), $variationHandler); $contentHandler = new ActionHandler("content"); $contentHandler->addFNCAction("purgeContent"); $form->addCheck("content", $lang->get("purge_content"), $contentHandler); $clusterHandler = new ActionHandler("cluster"); $clusterHandler->addFNCAction("purgeCluster"); $form->addCheck("cluster", $lang->get("purge_cluster"), $clusterHandler); $metaHandler = new ActionHandler("meta"); $metaHandler->addFNCAction("purgeMeta"); $form->addCheck("meta", $lang->get("purge_meta"), $metaHandler); $cltHandler = new ActionHandler("clt"); $cltHandler->addFNCAction("purgeClusterTemplates"); $form->addCheck("clt", $lang->get("purge_clt"), $cltHandler); $spmHandler = new ActionHandler("spm"); $spmHandler->addFNCAction("purgeSitepages"); $form->addCheck("spm", $lang->get("purge_pages"), $spmHandler); $page->add($form); $page->draw(); $db->close(); ?>
$catname = new TextInput($lang->get("r_foldername"), "categories", "CATEGORY_NAME", $cond, "type:text,width:200,size:32", "MANDATORY&UNIQUE"); $catname->setFilter("PARENT_CATEGORY_ID = $pnode"); $form->add($catname); $form->add(new Hidden("action", $lang->get("new_folder"))); $form->add(new Hidden("pnode", $pnode)); $form->add(new NonDisplayedValueOnInsert("categories", "PARENT_CATEGORY_ID", $cond, $pnode, "NUMBER")); $form->add(new NonDisplayedValueOnInsert("categories", "DELETED", $cond, 0, "NUMBER")); $form->forbidDelete(true); $page->add($form); $handled = true; $forward = doc(); } else if ($action == $lang->get("del_folder") && $auth->checkAccessToFunction("DELETE_FOLDER") && $pnode != "0") { if (!isset($go)) $go = "start"; $delhandler = new ActionHandler("deletefolder"); // removed comment-out from following line because deleting folders didn't work anymore. $oid = $pnode; if ($go != $lang->get("Cancel")) { $amount = 0; $sql1 = "SELECT COUNT(CATEGORY_ID) AS ANZ FROM content WHERE CATEGORY_ID = $oid AND DELETED=0"; $sql2 = "SELECT COUNT(CATEGORY_ID) AS ANZ FROM cluster_templates WHERE CATEGORY_ID = $oid AND DELETED=0"; $sql3 = "SELECT COUNT(CATEGORY_ID) AS ANZ FROM categories WHERE PARENT_CATEGORY_ID = $oid AND DELETED=0"; $query = new query($db, $sql1); $query->getrow(); $amount += $query->field("ANZ"); $query = new query($db, $sql2);
require "../../config.inc.php"; $filtermenu = new StdMenu('Synchronize Languages'); include "menu.php"; $auth = new auth("SYNC_CLUSTERS"); $page = new page("Synchronize Clusters"); $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm($lang->get("sync_clusters")); $form->addToTopText($lang->get("sync_lang_desc", "Creates an instance of each content in all languages defined.")); $maintenanceHandler = new ActionHandler("sync"); $maintenanceHandler->addFncAction("syncLanguages"); $form->addCheck("sync", $lang->get("sync_lang", 'Synchronize Languages')." ", $maintenanceHandler); $page->add($form); $page->addMenu($filtermenu); $page->draw(); $db->close(); function syncLanguages() { global $db, $auth; $variations = createDBCArray('variations', 'VARIATION_ID'); // enable languages in all templates $spms = createDBCArray('sitepage_master', 'SPM_ID', 'VERSION=0'); for ($i=0; $i<count($spms); $i++) { for ($j=0; $j<count($variations); $j++) {
} } } if ($action == $lang->get("cl_launch") && $aclf->checkAccessToFunction("B_EXPIRE_LAUNCH")) { launchCluster($clnid, 10, $variation); } else if ($action == $lang->get("cl_expire") && $aclf->checkAccessToFunction("B_EXPIRE_LAUNCH")) { expireCluster($clnid, $variation); } if ($action == $lang->get("CL_DEL") && $aclf->checkAccessToFunction("DELETE_CL")) { //if (!isset($go)) $go = "start"; if ($go == "0" || $go == "") $go = "start"; $delhandler = new ActionHandler("deleteobject"); if (value("decision") == $lang->get("yes")) { $delhandler->addDBAction("UPDATE cluster_node SET DELETED = 1 WHERE CLNID = $oid"); $delhandler->addDBAction("UPDATE cluster_content SET FKID=0 WHERE FKID = $oid"); $delhandler->addDBAction("UPDATE cluster_template_items SET FKID=0 WHERE FKID = $oid"); $delhandler->process("deleteobject"); $handled = true; } else if (value("decision") != $lang->get("no")) { $title = getDBCell("cluster_node", "NAME", "CLNID = $oid"); $form = new YesNoForm($lang->get("cl_del"). " $title", $lang->get("cl_delmes", "Do you really want to delete this cluster-instance?")); $form->add(new Hidden("action", $lang->get("CL_DEL"))); $form->add(new Hidden("oid", $oid)); $page->add($form);
* You should have received a copy of the GNU General Public License * along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require "../../config.inc.php"; $auth = new auth("MAINTENANCE"); $page = new page("Rebuild Cache"); $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm($lang->get("rb_cache", "Rebuild Cache")); $form->addToTopText($lang->get("mt_rb_cache_mes", "Rebuild Cache of all live pages")); $maintenanceHandler = new ActionHandler("generate"); $maintenanceHandler->addFncAction("rebuildRecipeCache"); $form->addCheck("generate", $lang->get("rb_cache", "Rebuild Cache"), $maintenanceHandler); $page->add($form); $page->draw(); $db->close(); function rebuildRecipeCache() { global $db; $recipes = createNameValueArrayEx("pgn_recipes", "NAME", "ID", "1"); } ?>
} } catch (ServiceException $e) { Logger::exception($e); if ($output_type == "xml") { header('Content-Type: text/xml'); print "<error>"; $ec = new ReflectionClass("Error"); $constants = $ec->getConstants(); $constants = array_flip($constants); $code = $constants[$e->getCode()]; $message = $e->getMessage(); if (!$message) { $message = $code; } print "<code>{$code}</code>"; print "<message>{$message}</message>"; print "</error>"; } } catch (Exception $e) { Logger::exception($e); if ($output_type == "xml") { header('Content-Type: text/xml'); print "<error>"; print "<code>UNEXPECTED_ERROR</code>"; print "<message>" . $e->getMessage() . "</message>"; print "</error>"; } else { $_REQUEST['error_message'] = $e->getMessage(); $obj = ActionHandler::handleAction("ErrorPage"); } }
/** * Create a new Record with the given $this->fkid in the database. * Initialize with standard values! */ function createRecord() { $createHandler = new ActionHandler("CREATE"); $createHandler->addDBAction("INSERT INTO $this->management_table ($this->pk_name, CONTENT) VALUES ($this->fkid, '')"); $createHandler->process("CREATE"); }
* GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with N/X; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA **********************************************************************/ require "../../config.inc.php"; $auth = new auth("ADMINISTRATOR"); $page = new page("Rebuild Cache"); $go = value("go"); if ($go == "0") $go = "start"; $form = new CommitForm($lang->get("mt_lw_site")); $form->addToTopText($lang->get("mt_lws_messages", "Do you really want to launch the whole website?")); $maintenanceHandler = new ActionHandler("generate"); $maintenanceHandler->addFncAction("launchWholeSite"); $chllaunchHandler = new ActionHandler("launchchannels"); $chllaunchHandler->addFncAction("launchAllChannels"); $form->addCheck("generate", $lang->get("mt_lw_site"), $maintenanceHandler); $form->addCheck("launchchannels", $lang->get("mt_lwc", "Launch all articles"), $chllaunchHandler); $page->add($form); $page->draw(); $db->close(); ?>