fixes for FireFox · 06/19/2008 - Nathan - v0.98g; new DMGR_CALLBACK_EXTRA_ACTIONS callback · 08/26/2008 - Nathan - v0.98h; DMGR_CALLBACK_ACTION, added DMGR_CALLBACK_FOOTER into the DefaultActionHandler() · 11/05/2009 - Nathan - v0.98i; added the rowclass and rowactionclass extensibility · mm/dd/yyyy - [name] - [comment] !!! 1.) before v0.99, we still need to add a standardized search feature including a form and mods to the listing (use a listSQL concept?) also, when only one item is returned from a search, a quick jump to the view/edit would be nice as well !!! 2.) before v1.00, there should be an attempt to support simple multi-checkboxes for a) sets and b) ref lookup join tables [like personRoles] !!! 3.) also before v1.00, it would be nice to have a NEXT/PREV on the EDIT page. And an option to 'Edit after Add' - for setting up lookup infos. !!! 4.) should also get some good DATE, TIME, & DATETIME field handling in here !!! 5.) should add the jump links beneath the list -- example code follows: /// add links so that parts pages can be jumped through $i = 0; $pages = ceil($matchingCount / $displayNum); $currentPage = floor($startAt / $displayNum) + 1; $pagingLinks = ""; while( $pages>1 && $i<=$matchingCount ) { /// do some intelligent skipping to avoid too many nav links... $bDisplay = true; $thisPage++; if( $thisPage%10 == 0 ) { $testval = $currentPage - intval($thisPage/10) * 10; if( $pages>200 && $thisPage%50!=0 && ($testval < -50 || $testval > 50) ) $bDisplay = false; } else { $testval = $currentPage - intval($thisPage/10) * 10; if( $testval < 0 || $testval > 10 ) { $bDisplay = false; } } /// show the page number... if( $bDisplay ) { if( $i == $startAt ) { $pagingLinks .= "  $thisPage "; } else { $pagingLinks .= "  $thisPage "; } } /// continue to the nexct page... $i = $i + $displayNum; } if( $pagingLinks != "" ) echo "
Jump to Page:  $pagingLinks
"; /*/ $DMGR_LicensedTo = "Windshields To Go USA - AutoGlassHosting.com"; if (!@isset($g_INCLUDED["GLOBAL.phi"])) { if (!include(dirname(dirname(__FILE__)) . "/GLOBAL.phi")) exit("
\n\nERROR(0a) GLOBAL requirement failure.\n\n
"); if (!@isset($g_INCLUDED["GLOBAL.phi"])) exit("
\n\nERROR(0b) GLOBAL requirement failure.\n\n
"); } require_once $g_Config->IncPath . "N.phi"; if (!isset($g_Config->ManagerPath) || $g_Config->ManagerPath == "") { $g_Config->ManagerPath = dirname(__FILE__) . "/"; } if (!isset($g_Config->ManagerURL) || $g_Config->ManagerURL == "") $g_Config->ManagerURL = $g_Config->BaseURL . "inc/Manager/"; require $g_Config->ManagerPath . "oManagerInfo.phi"; define("DMGR_MODE_ADMIN", 16); define("DMGR_MODE_ADMIN_ALL", 23); define("DMGR_MODE_SINGLE", 8); define("DMGR_MODE_SINGLE_ALL", 13); define("DMGR_MODE_ALLOW_VIEW", 0); define("DMGR_MODE_ALLOW_EDIT", 1); define("DMGR_MODE_ALLOW_ADD", 2); define("DMGR_MODE_ALLOW_DELETE", 4); define("DMGR_MODE_ALLOW_ALL", 7); define("DMGR_ONLYID_ALL", -1); define("DMGR_ONLYID_NONE", 0); define("DMGR_LOOKUP_UNKNOWN", "(unknown)"); define("DMGR_VAR_ROWCLASS", "_ rowClass"); define("DMGR_VAR_ROWACTIONCLASS", "_ rowActionClass"); define("DMGR_VAR_ROWSTYLE", "_ rowStyle"); define("DMGR_VAR_ROWACTIONSTYLE", "_ rowActionStyle"); define("DMGR_CALLBACK_ACTION", 'Action'); define("DMGR_CALLBACK_HEADER", 'Header'); define("DMGR_CALLBACK_HEADER_HEAD", 'HeaderHead'); define("DMGR_CALLBACK_HEADER_DONE", 'HeaderDone'); define("DMGR_CALLBACK_FOOTER", 'Footer'); define("DMGR_CALLBACK_LIST", 'List'); define("DMGR_CALLBACK_LIST_ITEM", 'List_Item'); define("DMGR_CALLBACK_LIST_FIELD", 'List_Field'); define("DMGR_CALLBACK_LIST_LINK_EDIT", 'List_Link_Edit'); define("DMGR_CALLBACK_LIST_LINK_CUSTOM", 'List_Link_Custom'); define("DMGR_CALLBACK_LIST_LINK_DELETE", 'List_Link_Delete'); define("DMGR_CALLBACK_EDIT", 'Edit'); define("DMGR_CALLBACK_EDIT_FIELD", 'Edit_Field'); define("DMGR_CALLBACK_VIEW", 'View'); define("DMGR_CALLBACK_VIEW_FIELD", 'View_Field'); define("DMGR_CALLBACK_UPDATE_ADD", 'UpdateAdd'); define("DMGR_CALLBACK_UPDATE_ADD_FIELD", 'UpdateAdd_Field'); define("DMGR_CALLBACK_UPDATE_ADD_COMPLETE", 'UpdateAddComplete'); define("DMGR_CALLBACK_DELETE", 'Delete'); define("DMGR_CALLBACK_EXTRA_ACTIONS", 'Extra_Actions'); return true; class DataManager { var $info; var $mode; var $onlyID; var $whereClause; var $carryFields = null; var $forceFields = null; var $extraActions = null; var $extraActionTargets = null; var $extraActionTitle = "Additional Actions"; var $extraActionSingleRow = true; var $actionLinksClass = ""; var $callbacks = null; var $showListPagination = true; var $bDebugging; var $bUseSqlQuote; var $maxListLength = 50; var $listTitle = ""; var $showEditFormHeader = true; var $useRowHighlighting = true; var $licensedTo = "Locke Enterprises (iLocke.com)"; var $extraHead = ""; function DataManager($mode, $onlyID, $itemName, $table, $orderBy = "name", $infoOverrides = "", $hasID = true, $bDebugging = false, $bUseSqlQuote = false) { $this->mode = $mode; $this->onlyID = $onlyID; $this->bDebugging = $bDebugging; $this->bUseSqlQuote = $bUseSqlQuote; $this->extraActions = array(); $this->extraActionTargets = array(); $this->carryFields = array(); $this->ID = "ID"; global $DMGR_LicensedTo; $this->licensedTo = $DMGR_LicensedTo; $this->info = new ManagerInfo($table, $itemName, $orderBy, $infoOverrides, $hasID, $bDebugging); } function DefaultActionHandler($A, $ID, $bDebug = false) { $this->bDebugging = $this->bDebugging || $bDebug; $this->Manager_Header(); $result = true; $action = trim(strtoupper($A)); if ($this->mode & DMGR_MODE_SINGLE) { $ID = intval($this->onlyID); if (($action == "" || $action == "L")) $action = "E"; } if (!($this->mode & DMGR_MODE_ALLOW_EDIT) && $action == "E") $action = "V"; if ($action == "L" || $action == "") { $this->ListItems(); } elseif ($action == "E") { $this->EditItem($ID); } elseif ($action == "A") { $this->UpdateItem($ID); $this->EditItem(0); } elseif ($action == "U") { $this->UpdateItem($ID); $this->EditItem($ID); } elseif ($action == "D") { $this->DeleteItem($ID); $this->ListItems(); } elseif ($action == "V") { $this->ViewItem($ID); } else { if (!isset($this->callbacks[DMGR_CALLBACK_ACTION]) || $this->callbacks[DMGR_CALLBACK_ACTION] == "") { return false; } $result = $this->RunCallback(DMGR_CALLBACK_ACTION, $action, $ID); } if ($result) { $this->RunCallback(DMGR_CALLBACK_FOOTER); } return $result; } function ListItems() { if ($this->mode & DMGR_MODE_SINGLE) $this->ExitMessage("[Error] Ths instance of DataManager->ListItems() is restricted to a single item. (" . $this->mode . ":" . (DMGR_MODE_SINGLE) . ")"); $bEdit = $this->mode & DMGR_MODE_ALLOW_EDIT; $bView = !$bEdit; $bDelete = $this->mode & DMGR_MODE_ALLOW_DELETE; global $PHP_SELF, $g_oNDB; global $B, $N, $S; if ($B < 1) $B = 0; if ($N < 1) $N = 25; $listParams = QueryString(array('B', 'O', 'N', 'S', 'F', 'M')); $extraParams = QueryString($this->carryFields); $listParams .= $extraParams; $where = $this->whereClause; $total = $g_oNDB->getCount($this->info->table, $where); if ($total < 1) { $msg = "Error(0) No matching " . $this->info->itemName . " items found !\n\n


\n"; if (!($this->mode & DMGR_MODE_SINGLE) && ($this->mode & DMGR_MODE_ALLOW_ADD)) { $msg .= "ADD a " . $this->info->itemName . " item.

"; } $this->ExitMessage($msg); } if ($where != "") $where = " WHERE " . $where . " "; $orderBy = $this->info->orderBy != "" ? "ORDER BY " . $this->info->orderBy : ""; $SQL = "SELECT * FROM " . $this->info->table . " " . $where . " " . $orderBy; if ($this->showListPagination) $SQL .= " LIMIT " . $B . ", " . $N; if ($this->bDebugging) echo "\n
\n\n" . $SQL . "\n\n
\n"; $oNRS = new nRS(); if (!($oNRS->open($SQL))) { $this->ExitMessage("Error(1) No items found!"); } if (!$this->RunCallback(DMGR_CALLBACK_LIST, $oNRS, $this->extraActions)) { $this->ExitMessage("

Error(2) Unable to list the items.

"); } echo "
"; echo $this->Manager_HelpLink($this->info->helpInfo['List_ContextID'], $this->info->helpInfo['List_JumpTo']); echo "" . ($this->listTitle != "" ? $this->listTitle : $this->info->itemName . " Manager") . "      
 \n"; echo "
"; echo "Listing items " . ($B + 1) . " through " . ( $B + 1 + $N > $total ? $total : $B + $N ) . " of " . $total . ".
\n"; echo ""; echo "
\n"; echo "\n"; foreach ($this->info->fields as $fieldInfo) { if ($fieldInfo->bInListing) echo "\t\n"; } echo "\t\n"; echo "\n"; $linkClass = $this->actionLinksClass != "" ? "class=\"" . $this->actionLinksClass . "\" " : ""; while ($rData = $oNRS->read()) { if (++$i % 2 == 1) { $rData[DMGR_VAR_ROWCLASS] = "managerRow"; $rData[DMGR_VAR_ROWACTIONCLASS] = "action"; } else { $rData[DMGR_VAR_ROWCLASS] = "managerRow2"; $rData[DMGR_VAR_ROWACTIONCLASS] = "action2"; } $rData[DMGR_VAR_ROWSTYLE] = ""; $rData[DMGR_VAR_ROWACTIONSTYLE] = ""; if (!$this->RunCallback(DMGR_CALLBACK_LIST_ITEM, $rData)) { --$i; continue; } if ($i % 2 == 1) { if (!isset($rData[DMGR_VAR_ROWCLASS])) $rData[DMGR_VAR_ROWCLASS] = "managerRow"; if (!isset($rData[DMGR_VAR_ROWACTIONCLASS])) $rData[DMGR_VAR_ROWACTIONCLASS] = "action"; } else { if (!isset($rData[DMGR_VAR_ROWCLASS])) $rData[DMGR_VAR_ROWCLASS] = "managerRow2"; if (!isset($rData[DMGR_VAR_ROWACTIONCLASS])) $rData[DMGR_VAR_ROWACTIONCLASS] = "action2"; } if (!isset($rData[DMGR_VAR_ROWSTYLE])) $rData[DMGR_VAR_ROWSTYLE] = ""; if (!isset($rData[DMGR_VAR_ROWACTIONSTYLE])) $rData[DMGR_VAR_ROWACTIONSTYLE] = ""; $highlightingScriptTR = !$this->useRowHighlighting ? "" : "onMouseOver=\"mOldColorTR = setBG(this, '#F8F8E0'); return true;\" onMouseOut=\"setBG(this, mOldColorTR); return true;\""; echo ''; foreach ($this->info->fields as $fieldInfo) { $bEditThisField = $bEdit; $bViewThisField = $bView; $bEditOrViewThisField = $this->RunCallback(DMGR_CALLBACK_LIST_LINK_EDIT, $rData, $bEditThisField, $bViewThisField); if ($fieldInfo->bInListing) { $fieldValue = str_replace("\n", " ", str_replace("\r", " ", strip_tags($rData[$fieldInfo->name]))); if ($fieldInfo->type == MGR_TYPE_LOOKUP) { if (isset($fieldInfo->lookups) && is_array($fieldInfo->lookups) && count($fieldInfo->lookups) == 3) { if ($fieldInfo->bEmptyOption && $fieldValue == 0) { $fieldValue = ""; } else { $fieldValue = $g_oNDB->getField(0, "SELECT " . $fieldInfo->lookups[2] . " FROM " . $fieldInfo->lookups[0] . " WHERE " . $fieldInfo->lookups[1] . "='" . $fieldValue . "'", DMGR_LOOKUP_UNKNOWN); } } } if (strlen($fieldValue) > $this->maxListLength) { $fieldValue = htmlspecialchars(substr($fieldValue, 0, $this->maxListLength)) . "..."; if (!($fieldInfo->bIsListingEditLink && $bEditOrViewThisField)) $fieldValue = "" . $fieldValue . ""; } else { $fieldValue = htmlspecialchars($fieldValue); } if ($fieldValue == "") $fieldValue = " "; if (!$this->RunCallback(DMGR_CALLBACK_LIST_FIELD, $fieldInfo, $rData, $fieldValue)) { echo ""; continue; } if ($fieldInfo->bIsListingEditLink && $bEditOrViewThisField) { if ($fieldInfo->hoverTipField != "") $tip = htmlspecialchars(substr(str_replace("\n", " ", str_replace("\r", " ", strip_tags($rData[$fieldInfo->hoverTipField]))), 0, 200)); else $tip = "Click here to " . ($bEditThisField ? "edit" : "view") . " this item. ID # " . $rData[$this->ID]; echo ""; } else { echo ""; } } } $highlightingScriptTD = !$this->useRowHighlighting ? "" : "onMouseOver=\"mOldColorTD = setBG(this, '#E8ECF0'); return true;\" onMouseOut=\"setBG(this, mOldColorTD); return true;\""; if ($bEditOrViewThisField) { echo ""; } else { ""; } foreach ($this->extraActions as $actionName => $actionLink) { if ($this->RunCallback(DMGR_CALLBACK_LIST_LINK_CUSTOM, $actionName, $rData)) { $actionTarget = ""; if (ereg("^(\{[^\}]+\})(.*)$", $actionLink, $rMatches)) { $actionTarget = substr($rMatches[1], 1, strlen($rMatches[1]) - 2); $actionLink = $rMatches[2]; } else { $actionTarget = $this->extraActionTargets[$actionName]; } echo "\n"; } } if ($bDelete) { if ($this->RunCallback(DMGR_CALLBACK_LIST_LINK_DELETE, $rData)) { echo ""; } else { echo ""; } } echo ""; } echo "
" . $fieldInfo->nomen . "Action
·" . $fieldValue . "" . $fieldValue . " " . ($bEditThisField ? "Edit" : "View") . "         " . $actionName . "  info->itemName . " item? ');\" href=\"" . $PHP_SELF . "?A=D&ID=" . $rData[$this->ID] . $listParams . "\">Delete        
 
"; if ($this->showListPagination) { $bLinked = false; $listParams = "&N=" . $N . "&S=" . $S . "&F=" . $F . "&M=" . $M . $extraParams; if ($B > 0) { $bLinked = true; $newB = $B - $N; if ($newB < 0) $newB = 0; echo "< <  Previous    "; } if ($B + $N + 1 < $total) { $bLinked = true; $newB = $B + $N; echo "Next  > >\n"; } $listParams = "&B=" . $B . "&S=" . $S . "&F=" . $F . "&M=" . $M . $extraParams; if ($bLinked) echo "      "; echo "List Items:  10 · 25 · 50 · 100 · 500  at a time
\n"; $listParams = "&N=" . $N . "&B=" . $B . "&S=" . $S . "&F=" . $F . "&M=" . $M . $extraParams; } if (!($this->mode & DMGR_MODE_SINGLE) && ($this->mode & DMGR_MODE_ALLOW_ADD)) { if ($bEdit) echo "
ADD a " . $this->info->itemName . " item.

"; } } function EditItem($ID) { global $PHP_SELF, $g_oNDB; if ($ID > 0) { $SQL = "SELECT * FROM " . $this->info->table . " WHERE " . $this->ID . "='$ID'"; // die($SQL); if ($this->whereClause != "") $SQL .= " AND " . $this->whereClause; if ($this->bDebugging) echo $SQL . "

"; $rData = $g_oNDB->getRow($SQL, "ERROR!"); if (!@is_array($rData)) exit("Error(1) Information not found!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if (!@isset($rData[0])) exit("Error(2) Empty information returned!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if ($rData[0] == "ERROR!") exit("Error(3) Data could not be retrieved!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if ($this->bDebugging) DumpInfo($rData, "rData returned"); $this->DisplayExtraActions("Edit_Header", $rData, $listParams, $linkClass); $title = "Edit " . $this->info->itemName . " Information"; } else { if (($this->mode & DMGR_MODE_SINGLE) || !($this->mode & DMGR_MODE_ALLOW_ADD)) $this->ExitMessage("[Error] No permissions to add an item."); $rData = array(); $title = "Add " . $this->info->itemName . ""; } echo "
"; echo $this->Manager_HelpLink($this->info->helpInfo['Edit_ContextID'], $this->info->helpInfo['Edit_JumpTo']); echo "" . $title . "      "; echo "
"; if (!$this->RunCallback(DMGR_CALLBACK_EDIT, $rData)) { $this->ExitMessage("

Unable to edit that item.

"); exit(); } if (false && $BQ) echo "
\n"; echo "

"; ?> 0?"U":"A"; ?>> carryFields); ?> showEditFormHeader) echo ""; $currentSection = ""; foreach ($this->info->fields as $thisField) { if ($this->bDebugging) DumpInfo($thisField); if (!$this->RunCallback(DMGR_CALLBACK_EDIT_FIELD, $thisField, $rData)) continue; if ($thisField->section != "" && $thisField->section != $currentSection) { $currentSection = $thisField->section; $helpCode = $this->Manager_HelpLink($thisField->helpContextID, $thisField->helpJumpTo); echo "\n"; } if ($ID < 1 && !$thisField->bEditable) continue; echo "\n\t\n"; if ($ID < 1 && !isset($rData[$thisField->name])) $fieldValue = $thisField->defaultValue; else $fieldValue = $rData[$thisField->name]; if ($thisField->format != "") $fieldValue = sprintf($thisField->format, $fieldValue); if (!$thisField->bEditable) { if ($thisField->type == MGR_TYPE_LOOKUP) { if (isset($thisField->lookups) && is_array($thisField->lookups) && count($thisField->lookups) == 3) { $fieldValue = $g_oNDB->getField(0, "SELECT " . $thisField->lookups[2] . " FROM " . $thisField->lookups[0] . " WHERE " . $thisField->lookups[1] . "='" . $fieldValue . "'", DMGR_LOOKUP_UNKNOWN); } } echo "\t\n"; } echo "
FieldValue
extraCellClass . " colspan=2>" . $helpCode . $currentSection . "
extraCellClass . ">" . $thisField->nomen . "  extraCellClass . ">"; if ($thisField->editWith == MGR_EDIT_CHECKBOX) { echo "name . "_x\" value=\"" . $thisField->optionValues[1] . "\"" . ($fieldValue == $thisField->optionValues[1] ? " CHECKED" : "") . ">"; } else { echo "css_class . "\" style=\"" . $thisField->css_style . "\">" . $fieldValue . ""; } } else { echo "\textraCellClass . ">name . "\" value=\"" . $thisField->type . ($thisField->type == MGR_TYPE_BOOL ? "=" . join(":", $thisField->optionValues) : "") . "\">"; $highlighting = "onFocus=\"this.style.color='#0000A0'; this.style.background='#FCFCE8'; return true;\" onBlur=\"this.style.color='#000060'; this.style.background='#F4F4F4'; return true;\""; if ($thisField->editWith == MGR_EDIT_INPUT) { echo "name . "\" class=\"" . $thisField->css_class . "\" style=\"" . $thisField->css_style . "\" $highlighting size=\"" . $thisField->size . "\" maxlength=\"" . $thisField->maxlength . "\" value=\"" . htmlspecialchars($fieldValue) . "\">"; } elseif ($thisField->editWith == MGR_EDIT_TEXTAREA) { echo ""; } elseif ($thisField->editWith == MGR_EDIT_SELECT) { echo ""; } elseif ($thisField->editWith == MGR_EDIT_CHECKBOX) { echo "name . "\" value=\"" . $thisField->optionValues[1] . "\"" . ($fieldValue == $thisField->optionValues[1] ? " CHECKED" : "") . ">"; } } if ($thisField->units != "") echo "" . $thisField->units . ""; if ($thisField->description != "") { echo $thisField->editWith == MGR_EDIT_CHECKBOX ? "" : "  "; echo $thisField->description . ""; } echo "

"; if ($ID > 0) { echo "

"; if ($this->mode & DMGR_MODE_ALLOW_DELETE) echo "info->itemName . " item? ');\" href='" . $PHP_SELF . "?A=D&ID=" . $rData[$this->ID] . "'>DELETE this " . $this->info->itemName . " item.   (Warning: this deletion is final and CANNOT be undone.)

"; $this->DisplayExtraActions("Edit_Footer", $rData, $listParams, $linkClass); } else { echo "

"; } if ($this->mode & DMGR_MODE_ADMIN) { echo "carryFields) . "\">BACK to the " . $this->info->itemName . " list."; } if (false && $BQ) echo "
"; echo "

"; } function ViewItem($ID) { global $PHP_SELF, $g_oNDB; if ($ID > 0) { $SQL = "SELECT * FROM " . $this->info->table . " WHERE " . $this->ID . "='$ID'"; if ($this->whereClause != "") $SQL .= " AND " . $this->whereClause; if ($this->bDebugging) echo $SQL . "

"; $rData = $g_oNDB->getRow($SQL, "ERROR!"); if (!@is_array($rData)) exit("Error(1) Information not found!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if (!@isset($rData[0])) exit("Error(2) Empty information returned!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if ($rData[0] == "ERROR!") exit("Error(3) Data could not be retrieved!
" . ($this->bDebugging ? $g_oNDB->message() : "")); if ($this->bDebugging) DumpInfo($rData, "rData returned"); $title = "View " . $this->info->itemName . " Information"; } else { if (($this->mode & DMGR_MODE_SINGLE) || !($this->mode & DMGR_MODE_ALLOW_ADD)) $this->ExitMessage("[Error] No permissions to add an item."); $rData = array(); $title = "Add " . $this->info->itemName . ""; } echo "
"; echo $this->Manager_HelpLink($this->info->helpInfo['Edit_ContextID'], $this->info->helpInfo['Edit_JumpTo']); echo "" . $title . "      "; echo "
"; if (!$this->RunCallback(DMGR_CALLBACK_VIEW, $rData)) { $this->ExitMessage("

Unable to view that item.

"); exit(); } if (false && $BQ) echo "
\n"; echo "

"; echo ""; if ($this->showEditFormHeader) echo ""; $currentSection = ""; foreach ($this->info->fields as $thisField) { if ($this->bDebugging) DumpInfo($thisField); if ($ID < 1 && !isset($rData[$thisField->name])) $fieldValue = $thisField->defaultValue; else $fieldValue = $rData[$thisField->name]; $fieldValue = htmlspecialchars($fieldValue); if ($thisField->format != "") $fieldValue = sprintf($thisField->format, $fieldValue); if (!$this->RunCallback(DMGR_CALLBACK_VIEW_FIELD, $thisField, $rData, $fieldValue)) continue; if ($thisField->section != "" && $thisField->section != $currentSection) { $currentSection = $thisField->section; $helpCode = $this->Manager_HelpLink($thisField->helpContextID, $thisField->helpJumpTo); echo "\n"; } if ($ID < 1 && !$thisField->bEditable) continue; echo "\n\t\n"; if ($thisField->type == MGR_TYPE_LOOKUP) { if (isset($thisField->lookups) && is_array($thisField->lookups) && count($thisField->lookups) == 3) { $fieldValue = $g_oNDB->getField(0, "SELECT " . $thisField->lookups[2] . " FROM " . $thisField->lookups[0] . " WHERE " . $thisField->lookups[1] . "='" . $fieldValue . "'", DMGR_LOOKUP_UNKNOWN); } } echo "\t\n"; } echo "
FieldValue
extraCellClass . " colspan=2>" . $helpCode . $currentSection . "
extraCellClass . ">" . $thisField->nomen . "  extraCellClass . ">css_class . "\" style=\"" . $thisField->css_style . "\">" . $fieldValue . ""; if ($thisField->units != "") echo "" . $thisField->units . ""; if (false && $thisField->description != "") { echo $thisField->editWith == MGR_EDIT_CHECKBOX ? "" : "  "; echo $thisField->description . ""; } echo "

"; if ($this->mode & DMGR_MODE_ADMIN) { echo "carryFields) . "\">BACK to the " . $this->info->itemName . " list."; } if (false && $BQ) echo "
"; echo "

"; } function UpdateItem($ID) { global $PHP_SELF, $g_oNDB, $HTTP_POST_VARS, $HTTP_GET_VARS; if (!$this->RunCallback(DMGR_CALLBACK_UPDATE_ADD, $ID)) { if ($this->bDebugging) echo ($ID > 0 ? "Update" : "Add") . " of item '" . $ID . "' was barred by callback.
"; return false; } if ($ID > 0) { $SQL = "UPDATE " . $this->info->table . " SET "; } else { $SQL = "INSERT INTO " . $this->info->table . " SET "; } $FieldTypes = RequestFieldNames("^t_", true); if (count($FieldTypes) < 1) $this->ExitMessage("UpdateItem() configuration error -- no fields found.
\n"); foreach ($FieldTypes as $fieldName) { $type = $_POST['t_' . $fieldName]; if (eregi("^" . MGR_TYPE_BOOL, $type)) { $parms = eregi_replace("^" . MGR_TYPE_BOOL, "", $type); $parms = eregi_replace("^=", "", $parms); if ($parms == "") $parms = "N:Y"; $parms = split(":", $parms); if ($this->bUseSqlQuote) { $fieldValue = $g_oNDB->escape($_POST['f_' . $fieldName] == $parms[1] ? $parms[1] : $parms[0], NDB_NO_QUOTES); } else { $fieldValue = $_POST['f_' . $fieldName] == $parms[1] ? $parms[1] : $parms[0]; } } else { if ($this->bUseSqlQuote) { $fieldValue = $g_oNDB->escape($_POST['f_' . $fieldName], NDB_NO_QUOTES); } else { $fieldValue = $_POST['f_' . $fieldName]; } } if (!$this->RunCallback(DMGR_CALLBACK_UPDATE_ADD_FIELD, $ID, $fieldName, $fieldValue)) { if ($this->bDebugging) echo ($ID > 0 ? "Update" : "Add") . " of item '" . $ID . "' was barred by callback.
"; continue; } $SQL .= $fieldName . "='" . $fieldValue . "', "; } $SQL = substr($SQL, 0, strlen($SQL) - 2); if ($ID > 0) $SQL .= " WHERE " . $this->ID . "=" . $ID; if ($this->bDebugging) echo "
\n\n$SQL\n\n
"; if (!$g_oNDB->execute($SQL)) $this->ExitMessage($g_oNDB->message() . ""); if ($ID > 0) { echo "> > Changes saved.

"; } else { echo "> > " . $this->info->itemName . " added.

"; $ID = $g_oNDB->getLastInsertID($this->info->table); } $this->RunCallback(DMGR_CALLBACK_UPDATE_ADD_COMPLETE, $ID); } function DeleteItem($ID) { global $PHP_SELF, $g_oNDB; if (!$this->RunCallback(DMGR_CALLBACK_DELETE, $ID)) { if ($this->bDebugging) echo "Delete of item '" . $ID . "' barred by callback.
"; return false; } $SQL = "DELETE FROM " . $this->info->table . " WHERE " . $this->ID . "='" . $ID . "'"; if ($this->whereClause != "") $SQL .= " AND " . $this->whereClause; if ($this->bDebugging) echo ""; if (!$g_oNDB->execute($SQL)) { $this->ExitMessage($g_oNDB->message() . ""); return true; } if (intval($g_oNDB->affectedRows) == 1) { echo "

>> " . $this->info->itemName . " item deleted.

"; } else { echo "

>> " . intval($g_oNDB->affectedRows) . " item(s) deleted."; if (intval($g_oNDB->affectedRows) < 1) echo " You probably do not have permission to delete that " . $this->info->itemName . " item."; echo "

"; if ($this->bDebugging) echo $g_oNDB->message() . "
"; } return true; } function Manager_Header($title = "", $showLocke = true) { global $g_Config; @session_start(); if (!$this->RunCallback(DMGR_CALLBACK_HEADER)) return; ?> <?php if ($showLocke) echo "LockeMgr: "; ?>Web Content Management System<?php if ($title != "") echo " | " . $title; if ($showLocke) echo " | by iLocke.com"; ?> extraHead; ?> RunCallback(DMGR_CALLBACK_HEADER_HEAD); ?>

RunCallback(DMGR_CALLBACK_HEADER_DONE); } function Manager_HelpLink($contextID, $jumpToRef) { if (intval($contextID) < 1) return ""; $helpLink = str_replace("\$topic", $contextID, $this->info->helpLinkURL); $jumpTo = $jumpToRef; if (!eregi("^HelpJump", $jumpTo)) $jumpTo = "HelpJump" . $jumpTo; $helpLink = str_replace("\$jumpToItem", $jumpTo, $helpLink) . "#" . $jumpTo; $helpCode = "
info->helpPopupSettings . "'); if( winManagerHelp ) { if( winManagerHelp.focus ) { winManagerHelp.focus(); } } return false;\" href=\"$helpLink\">"; if ($this->info->helpLinkIcon != "") { $helpCode .= "info->helpLinkIcon . "\">"; } else { $helpCode .= "help"; } $helpCode .= "
"; return $helpCode; } function RegisterCallback($code, $name) { $this->callbacks[$code] = $name; } function & RunCallback($CODE, &$param1 = null, &$param2 = null, &$param3 = null, &$param4 = null, &$param5 = null) { $default = true; if (!isset($this->callbacks[$CODE]) || $this->callbacks[$CODE] == "") return $default; $callbackFunction = $this->callbacks[$CODE]; if (isset($param5)) { return $callbackFunction($param1, $param2, $param3, $param4, $param5); } elseif (isset($param4)) { return $callbackFunction($param1, $param2, $param3, $param4); } elseif (isset($param3)) { return $callbackFunction($param1, $param2, $param3); } elseif (isset($param2)) { return $callbackFunction($param1, $param2); } elseif (isset($param1)) { return $callbackFunction($param1); } else { return $callbackFunction(); } } function DisplayExtraActions($source, &$rData, $listParams = "", $linkClass = "") { if (!$this->RunCallback(DMGR_CALLBACK_EXTRA_ACTIONS, $source, $rData)) return false; if (count($this->extraActions) < 1) return false; echo ""; if (!$this->extraActionSingleRow) echo ""; foreach ($this->extraActions as $actionName => $actionLink) { if ($this->RunCallback(DMGR_CALLBACK_LIST_LINK_CUSTOM, $actionName, $rData)) { if (!$this->extraActionSingleRow) echo ""; echo ""; if (!$this->extraActionSingleRow) echo ""; } } echo "
  " . $this->extraActionTitle . "  
  ID], $actionLink)) . "\">" . $actionName . "  

"; return true; } function ExitMessage($msg) { echo "

" . $msg . "

"; $this->RunCallback(DMGR_CALLBACK_FOOTER); exit; } }