function antiddos_search() { $appname = @mysql_escape_string($_REQUEST['appname']); if (!$appname) { die_(1, "'appname' is required"); } $data = db_get_data("select accesskey,service_status,domain_status from anti_ddos where appname='{$appname}'"); if ($data === False) { die_(1, db_last_error()); } die_(0, $data); }
function update_item_controls($window) { global $id_edit, $curr_cat; $table = "item"; $data = db_get_data($table, $id_edit, null, "", FETCH_ASSOC); $data = $data[0]; wb_set_text(wb_get_control($window, ID_NAME), $data["name"]); wb_set_text(wb_get_control($window, ID_DESCRIPTION), $data["description"]); // Select the appropriate values from the combo boxes wb_set_selected(wb_get_control($window, ID_CATLIST), (int) array_search($curr_cat === null ? $data["cat"] : $curr_cat, db_get_data("cat", null, "id"))); wb_set_selected(wb_get_control($window, ID_PRIORLIST), (int) array_search($data["priority"], db_get_data("priority", null, "id"))); wb_set_selected(wb_get_control($window, ID_SEVERLIST), (int) array_search($data["severity"], db_get_data("severity", null, "id"))); }
/** * db_get_index() * * Returns the index of the record identified by $id * * @param $tablename * @param $id * @param string $idfield * @return index or FALSE */ function db_get_index($tablename, $id, $idfield = "id") { $data = db_get_data($tablename, null, $idfield); return array_search($id, $data); }
function update_prior_controls($window) { global $mainwin, $prior_table; $itemlist = wb_get_control($window, ID_PRIORITYLIST); $id = db_get_id($prior_table, wb_get_selected($itemlist)); wb_set_text(wb_get_control($window, ID_NAME), db_get_data($prior_table, $id, "name")); $sel = wb_get_selected($itemlist); wb_set_enabled(wb_get_control($window, ID_SETITEM), $sel != -1); wb_set_enabled(wb_get_control($window, ID_DELETEITEM), $sel != -1); }
function get_selected_tree_item_index($window) { global $cat_table, $it_list; // Below: get id of selected treeview element. See comment in update_items() $it_list = wb_get_control($window, ID_TREE); $sel_text = wb_get_text($it_list); $cat_data = db_get_data("cat", null, "name"); $sel_index = (int) array_search($sel_text, $cat_data); return $sel_index; }
function db_get_row($sql, $name = "default") { $data = db_get_data($sql, $name); return @reset($data); }
function todo_export_text($data) { $spaces = str_repeat("-", 80); $txt = COMPLETENAME . "\r\n" . "Generated automatically by " . APPNAME . " in " . date("m/d/Y") . "\r\n(" . count($data) . " items)\r\n\r\n{$spaces}\r\n"; foreach ($data as $entry) { $id = $entry[0]; $name = trim($entry[1]); $desc = trim($entry[2]); if (!$desc) { $desc = "(No description)"; } $cat = db_get_data("cat", null, "name", "id == {$entry[3]}"); $prior = db_get_data("priority", null, "name", "id == {$entry[4]}"); $sever = db_get_data("severity", null, "name", "id == {$entry[5]}"); $txt .= "\r\nItem/bug #{$id}: {$name}\r\n{$sever}, {$prior} priority\r\n\r\n{$desc}\r\n\r\n{$spaces}\r\n"; } return $txt; }