<?php include_once 'data.php'; include_once 'functions.php'; session_write_close(); if (isset($_GET['file'])) { $_GET['file'] = intval($_GET['file']); } //DELETE BUTTON IN ITEMS VIEW if (isset($_GET['delete']) && isset($_GET['file']) && isset($_SESSION['permissions']) && $_SESSION['permissions'] == 'A') { database_connect(IL_DATABASE_PATH, 'library'); $error = null; $error = delete_record($dbHandle, $_GET['file']); die($error); } if (isset($_GET['file'])) { // Fetch ids from cache in history. database_connect(IL_DATABASE_PATH, 'history'); if ($_SESSION['orderby'] == 'id') { $result = $dbHandle->query("SELECT itemID FROM `" . $_SESSION['display_files'] . "` WHERE id<=(SELECT id FROM `" . $_SESSION['display_files'] . "` WHERE itemID=" . $_GET['file'] . ")+10 ORDER BY id DESC LIMIT 22"); } else { $result = $dbHandle->query("SELECT itemID FROM `" . $_SESSION['display_files'] . "` WHERE id>=(SELECT id FROM `" . $_SESSION['display_files'] . "` WHERE itemID=" . $_GET['file'] . ")-10 LIMIT 22"); } $export_files = array(); if ($result) { $export_files = $result->fetchAll(PDO::FETCH_COLUMN); } $dbHandle = null; } //CHECK IF ITEM IS STILL IN LIST AFTER CHANGES AND RELOAD if (isset($_GET['checkitem']) && isset($_GET['files'])) {
function scorm_seq_set($what, $scoid, $userid, $attempt = 0, $value = 'true') { $sco = scorm_get_sco($scoid); /// set passed activity to active or not if ($value == false) { delete_record('scorm_scoes_track', 'scoid', $scoid, 'userid', $userid, 'attempt', $attempt, 'element', $what); } else { scorm_insert_track($userid, $sco->scorm, $sco->id, 0, $what, $value); } // update grades in gradebook $scorm = get_record('scorm', 'id', $sco->scorm); scorm_update_grades($scorm, $userid, true); }
function databaseactions() { global $_POST, $MM_editTable, $MM_fieldsStr, $MM_columnsStr, $MM_editRedirectUrl, $MM_editColumn, $MM_recordId; if ($_POST[MM_insert]) { $id = insert_record($MM_editTable, $MM_fieldsStr, $MM_columnsStr, $MM_editRedirectUrl); } if ($_POST[MM_update] & $_POST[MM_recordId]) { $id = update_record($MM_editTable, $MM_recordId, $MM_fieldsStr, $MM_columnsStr, $MM_editRedirectUrl); } if ($_POST[MM_delete] & $_POST[MM_recordId]) { delete_record($MM_editTable, $MM_recordId, $MM_editRedirectUrl); } return $id; }
<?php include_once 'data.php'; include_once 'functions.php'; if (isset($_SESSION['permissions']) && $_SESSION['permissions'] == 'A') { if (!empty($_POST['submit'])) { if (!isset($_POST['ids'])) { $_POST['ids'] = array(); } echo '<div class="details alternating_row" style="font-weight:bold">Number of Deleted Duplicates:</div>' . '<div style="padding:4px 8px">' . count($_POST['ids']) . '</div>' . '<div style="padding:0 8px"><h3>Done.</h3></div>'; // DELETE ITEMS database_connect($database_path, 'library'); delete_record($dbHandle, $_POST['ids']); $dbHandle = null; } elseif (isset($_GET['find_duplicates']) && $_GET['find_duplicates'] == 'similar') { echo '<div class="details alternating_row" style="font-weight:bold">Possible Duplicates:</div>' . '<div style="padding:4px 8px"><input type="checkbox" style="visibility:hidden">' . '<span style="display:inline-block;margin-left:1em;width:4em">ID</span><span style="margin-left:1em">Title</span></div>'; echo '<form action="duplicates.php" method="POST">'; $duplicates_array = array(); database_connect($database_path, 'library'); $dbHandle->exec("PRAGMA cache_size = 200000"); $dbHandle->exec("PRAGMA temp_store = MEMORY"); $dbHandle->exec("PRAGMA synchronous = OFF"); $dbHandle->exec("CREATE TEMPORARY TABLE search_result (id INTEGER PRIMARY KEY,title)"); $dbHandle->exec("INSERT INTO search_result SELECT id,title FROM library"); $result = $dbHandle->query("SELECT id,title FROM search_result ORDER BY id ASC"); $i = 0; while ($title = $result->fetch(PDO::FETCH_ASSOC)) { $title_query = $dbHandle->quote(substr($title['title'], 0, -1) . '%'); $id_result = $dbHandle->query("SELECT id,title FROM search_result WHERE id > {$title['id']} AND lower(title) LIKE lower({$title_query}) LIMIT 1"); $id_result = $id_result->fetch(PDO::FETCH_ASSOC); if (!empty($id_result['id'])) {
$ret = delete_record($args); if ($ret !== true) { output_error($ret); } break; case '/add-record': $ret = add_record($args); if ($ret !== true) { output_error($ret); } break; case '/update-record': $original = $args['record']['original']; $new = $args['record']['new']; $args['record'] = $original; // output_error(print_r($args)); $ret = delete_record($args); if ($ret !== true) { output_error($ret); } $args['record'] = $new; $ret = add_record($args); if ($ret !== true) { $args['record'] = $original; add_record($args); output_error($ret); } break; default: output_error('Requested method is not available.', 501); }
function delete_rhythm($rid) { //Delete rhythm delete_record('rid', $rid, 'nsh_rhythms'); }
$perm_content_edit = "own"; } else { $perm_content_edit = "none"; } $zid = get_zone_id_from_record_id($_GET['id']); if ($zid == NULL) { header("Location: list_zones.php"); exit; } $user_is_zone_owner = verify_user_is_owner_zoneid($zid); $zone_info = get_zone_info_from_id($zid); if ($record_id == "-1") { error(ERR_INV_INPUT); } else { if ($confirm == '1') { if (delete_record($record_id)) { success("<a href=\"edit.php?id=" . $zid . "\">" . SUC_RECORD_DEL . "</a>"); /* update serial after record deletion */ update_soa_serial($zid); } } else { $zone_id = recid_to_domid($record_id); $zone_name = get_zone_name_from_id($zone_id); $user_is_zone_owner = verify_user_is_owner_zoneid($zone_id); $record_info = get_record_from_id($record_id); echo " <h2>" . _('Delete record in zone') . " \"<a href=\"edit.php?id=" . $zid . "\">" . $zone_name . "</a>\"</h2>\n"; if ($zone_info['type'] == "SLAVE" || $perm_content_edit == "none" || $perm_content_edit == "own" && $user_is_zone_owner == "0") { error(ERR_PERM_EDIT_RECORD); } else {
$dbHandle->exec("INSERT OR IGNORE INTO filescategories (fileID,categoryID) SELECT itemID, " . intval($cat) . " FROM history.`" . $_SESSION['display_files'] . "` ORDER BY id DESC"); } $dbHandle->exec("DELETE FROM filescategories WHERE fileID NOT IN (SELECT id from library)"); } // REMOVE FROM CATEGORIES if ($_POST['omnitool'] == '9' && !empty($_POST['category'])) { while (list(, $cat) = each($_POST['category'])) { $dbHandle->exec("DELETE FROM filescategories WHERE categoryID=" . intval($cat) . " AND fileID IN (SELECT itemID FROM history.`" . $_SESSION['display_files'] . "` ORDER BY id)"); } } $dbHandle->commit(); // DELETE ITEMS if ($_POST['omnitool'] == '8' && isset($_SESSION['permissions']) && $_SESSION['permissions'] == 'A') { $result = $dbHandle->query("SELECT itemID FROM history.`" . $_SESSION['display_files'] . "` LIMIT 10000"); $delete_files = $result->fetchAll(PDO::FETCH_COLUMN); delete_record($dbHandle, $delete_files); } $dbHandle = null; } elseif (isset($_SESSION['auth'])) { ?> <div> <table class="threed" cellspacing=0 style="width:100%"> <tr> <td class="threed select_span omnitooltd" style="width:32%;line-height:22px"> <input type="radio" style="display:none" name="omnitool" value="1"> <i class="fa fa-circle-o"></i> Save to Shelf </td> <td class="threed select_span omnitooltd" style="width:32%;line-height:22px"> <input type="radio" style="display:none" name="omnitool" value="5">
// Create the final message. if ($PIC_NEED_APPROVAL) { if ($file_placement == 'no') { $final_message = '' . $lang_upload_php['no_place'] . '<br /><br />' . $lang_db_input_php['upload_success']; } else { $final_message = '' . $lang_upload_php['yes_place'] . '<br /><br />' . $lang_db_input_php['upload_success']; } } else { if ($file_placement == 'no') { $final_message = '' . $lang_upload_php['no_place'] . '<br /><br />' . $lang_upload_php['process_complete']; } else { $final_message = '' . $lang_upload_php['yes_place'] . '<br /><br />' . $lang_upload_php['process_complete']; } } // Delete the temporary data file. delete_record($_POST['unique_ID']); // Send e-mail notification to the admin if requested (added by gaugau: 03-11-09). if ($CONFIG['upl_notify_admin_email'] and $PIC_NEED_APPROVAL) { // Encapsulate so included lang file doesn't interfere with global one function cpg_send_upload_notification() { global $CONFIG; $lang_db_input_php = cpg_get_default_lang_var('lang_db_input_php'); // Get the mail files. include_once 'include/mailer.inc.php'; // Send the message. cpg_mail('admin', sprintf($lang_db_input_php['notify_admin_email_subject'], $CONFIG['gallery_name']), sprintf($lang_db_input_php['notify_admin_email_body'], USER_NAME, $CONFIG['ecards_more_pic_target'] . (substr($CONFIG["ecards_more_pic_target"], -1) == '/' ? '' : '/') . 'editpics.php?mode=upload_approval')); } cpg_send_upload_notification(); } // That was the last one. Create a redirect box.
function ewiki_database_moodle($action, &$args, $sw1, $sw2) { global $wiki, $wiki_entry, $CFG; #-- result array $r = array(); switch ($action) { /* Returns database entry as array for the page whose name was given with the "id" key in the $args array, usually fetches the latest version of a page, unless a specific "version" was requested in the $args array. */ # Ugly, but we need to choose which wiki we are about to change/read case "GET": $id = "'" . anydb_escape_string($args["id"]) . "'"; $version = 0 + @$args["version"] and $version = "AND (version={$version})" or $version = ""; # $result = mysql_query("SELECT * FROM " . EWIKI_DB_TABLE_NAME # . " WHERE (pagename=$id) $version ORDER BY version DESC LIMIT 1" #); #if ($result && ($r = mysql_fetch_array($result, MYSQL_ASSOC))) { # $r["id"] = $r["pagename"]; # unset($r["pagename"]); #} #if (strlen($r["meta"])) { # $r["meta"] = @unserialize($r["meta"]); #} $select = "(pagename={$id}) AND wiki=" . $wiki_entry->id . " {$version} "; $sort = "version DESC"; if ($result_arr = get_records_select(EWIKI_DB_TABLE_NAME, $select, $sort, "*", 0, 1)) { //Iterate to get the first (and unique!) foreach ($result_arr as $obj) { $result_obj = $obj; } } if ($result_obj) { //Convert to array $r = get_object_vars($result_obj); $r["id"] = $r["pagename"]; unset($r["pagename"]); $r["meta"] = @unserialize($r["meta"]); } break; /* Increases the hit counter for the page name given in $args array with "id" index key. */ /* Increases the hit counter for the page name given in $args array with "id" index key. */ case "HIT": #mysql_query("UPDATE " . EWIKI_DB_TABLE_NAME . " SET hits=(hits+1) WHERE pagename='" . anydb_escape_string($args["id"]) . "'"); # set_field does not work because of the "hits+1" construct #print "DO ".anydb__escape_string($args["id"]); exit; execute_sql("UPDATE " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " SET hits=(hits+1) WHERE pagename='" . anydb_escape_string($args["id"]) . "' and wiki=" . $wiki_entry->id, 0); break; /* Stores the $data array into the database, while not overwriting existing entries (using WRITE); returns 0 on failure and 1 if saved correctly. */ /* Stores the $data array into the database, while not overwriting existing entries (using WRITE); returns 0 on failure and 1 if saved correctly. */ case "OVERWRITE": $COMMAND = "REPLACE"; break; case "WRITE": $COMMAND = "WRITE"; $args["pagename"] = $args["id"]; unset($args["id"]); if (is_array($args["meta"])) { $args["meta"] = serialize($args["meta"]); } #$sql1 = $sql2 = ""; #foreach ($args as $index => $value) { # if (is_int($index)) { # continue; # } # $a = ($sql1 ? ', ' : ''); # $sql1 .= $a . $index; # $sql2 .= $a . "'" . anydb_escape_string($value) . "'"; #} #strlen(@$COMMAND) || ($COMMAND = "INSERT"); foreach ($args as $index => $value) { if (is_int($index)) { continue; } $args[$index] = anydb_escape_string($value); } $args["wiki"] = $wiki_entry->id; # Check if Record exists if ($COMMAND == "REPLACE") { if (count_records(EWIKI_DB_TABLE_NAME, "wiki", $wiki_entry->id, "pagename", $args["pagename"], "version", $args["version"])) { delete_record(EWIKI_DB_TABLE_NAME, "wiki", $wiki_entry->id, "pagename", $args["pagename"], "version", $args["version"]); } } # Write $result = insert_record(EWIKI_DB_TABLE_NAME, (object) $args, false); #$result = mysql_query("$COMMAND INTO " . EWIKI_DB_TABLE_NAME . # " (" . $sql1 . ") VALUES (" . $sql2 . ")" #); #return($result && mysql_affected_rows() ?1:0); return $result; break; /* Checks for existence of the WikiPages whose names are given in the $args array. Returns an array with the specified WikiPageNames associated with values of "0" or "1" (stating if the page exists in the database). For images/binary db entries returns the "meta" field instead of an "1". */ /* Checks for existence of the WikiPages whose names are given in the $args array. Returns an array with the specified WikiPageNames associated with values of "0" or "1" (stating if the page exists in the database). For images/binary db entries returns the "meta" field instead of an "1". */ case "FIND": $select = ""; foreach (array_values($args) as $id) { if (strlen($id)) { $r[$id] = 0; $select .= ($select ? " OR " : "") . "(pagename='" . anydb_escape_string($id) . "')"; } } if ($select) { $select = "(" . $select . ") AND wiki=" . $wiki_entry->id; $result = get_records_select(EWIKI_DB_TABLE_NAME, $select); #$sql = "SELECT pagename AS id, meta FROM " . # EWIKI_DB_TABLE_NAME . " WHERE $sql " #); #while ($result && ($row = mysql_fetch_row($result))) { # $r[$row[0]] = strpos($row[1], 's:5:"image"') ? $row[1] : 1; while (list($key, $val) = @each($result)) { $r[$val->pagename] = strpos($val->meta, 's:5:"image"') ? $val->meta : 1; } } break; /* Counts the number of Versions */ /* Counts the number of Versions */ case "COUNTVERSIONS": $sql = "SELECT pagename AS id, count(*) as versioncount" . " FROM " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " WHERE wiki = " . $wiki_entry->id . " GROUP BY pagename"; #print "$sql"; $result = get_records_sql($sql); while (list($key, $val) = each($result)) { $r[$key] = $val->versioncount; } break; /* Returns an array of the lastest versions of __all__ pages, where each entry is made up of the fields from the database requested with the $args array, e.g. array("flags","meta","lastmodified"); */ /* Returns an array of the lastest versions of __all__ pages, where each entry is made up of the fields from the database requested with the $args array, e.g. array("flags","meta","lastmodified"); */ case "GETALL": switch ($CFG->dbfamily) { case 'postgres': // All but the latest version eliminated by DISTINCT // ON (pagename) $sql = "SELECT DISTINCT ON (pagename) pagename AS id, " . implode(", ", $args) . " FROM " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " WHERE wiki = " . $wiki_entry->id . " ORDER BY pagename, version DESC"; break; case 'mysql': // All but the latest version eliminated by // mysql-specific GROUP BY-semantics $sql = "SELECT pagename AS id, " . implode(", ", $args) . " FROM " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " WHERE wiki = " . $wiki_entry->id . " GROUP BY id, version DESC "; default: // All but the latest version are here eliminated in // get_records_sql, since it will return an array // with only one result per id-field value. Note, // that for this to work the query needs to order the // records ascending by version, so later versions // will overwrite previous ones in // recordset_to_array. This is not pretty. $sql = "SELECT pagename AS id, " . implode(", ", $args) . " FROM " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " WHERE wiki = " . $wiki_entry->id . " ORDER BY version"; } $result = get_records_sql($sql); $r = new ewiki_dbquery_result($args); if ($result) { foreach ($result as $val) { $r->add(get_object_vars($val)); } } break; /* Returns array of database entries (also arrays), where the one specified column matches the specified content string, for example $args = array("content" => "text...piece") is not guaranteed to only search/return the latest version of a page */ /* Returns array of database entries (also arrays), where the one specified column matches the specified content string, for example $args = array("content" => "text...piece") is not guaranteed to only search/return the latest version of a page */ case "SEARCH": $field = implode("", array_keys($args)); $content = strtolower(implode("", $args)); if ($field == "id") { $field = "pagename"; } $sql = "SELECT pagename AS id, version, flags" . (EWIKI_DBQUERY_BUFFER && $field != "pagename" ? ", {$field}" : "") . " FROM " . $CFG->prefix . EWIKI_DB_TABLE_NAME . " WHERE {$field} " . sql_ilike() . " '%" . anydb_escape_string($content) . "%' and wiki=" . $wiki_entry->id . " ORDER BY id, version ASC"; $result = get_records_sql($sql); $r = new ewiki_dbquery_result(array("id", "version", $field)); $drop = ""; #while ($result && ($row = mysql_fetch_array($result, MYSQL_ASSOC))) { # $i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"]; # if ($i != $drop) { # $drop = $i; # $r->add($row); # } #} while (list($key, $val) = @each($result)) { $row = get_object_vars($val); $i = EWIKI_CASE_INSENSITIVE ? strtolower($row["id"]) : $row["id"]; if ($i != $drop) { $drop = $i; $r->add($row); } } break; case "DELETE": $id = anydb_escape_string($args["id"]); $version = $args["version"]; #mysql_query("DELETE FROM " . EWIKI_DB_TABLE_NAME ." # WHERE pagename='$id' AND version=$version"); # print "DELETING wiki:".$wiki_entry->id."Pagename: $id Version: $version <br />\n"; delete_records(EWIKI_DB_TABLE_NAME, "wiki", $wiki_entry->id, "pagename", $id, "version", $version); break; case "INIT": #mysql_query("CREATE TABLE " . EWIKI_DB_TABLE_NAME ." # (pagename VARCHAR(160) NOT NULL, # version INTEGER UNSIGNED NOT NULL DEFAULT 0, # flags INTEGER UNSIGNED DEFAULT 0, # content MEDIUMTEXT, # author VARCHAR(100) DEFAULT 'ewiki', # created INTEGER UNSIGNED DEFAULT ".time().", # lastmodified INTEGER UNSIGNED DEFAULT 0, # refs MEDIUMTEXT, # meta MEDIUMTEXT, # hits INTEGER UNSIGNED DEFAULT 0, # PRIMARY KEY id (pagename, version) ) # "); #echo mysql_error(); break; default: } return $r; }
} //DELETE ACTION if (isset($_GET['delete'])) { $id = $_GET['delete']; //sementara delete data tanpa cek ke table lain karna ini cek ke tabel transaksi //CEK DATA IN other table BEFORE DELETE // $cek_exist = count_data(TB_PREF."items", 'id', "id_brand='".$id."'"); // if ($cek_exist[0]>0) { // display_error("Data ini masih digunakan... " // . "| <a href='?".$parameter_key."kd_tabel=tb_stores' />Close</a>"); // } // else{ $table = TB_PREF . "stores"; $field_key = "id"; $field_val = "'" . $id . "'"; $query = delete_record($table, $field_key, $field_val); if ($query) { display_success("Data berhasil dihapus " . "| <a href='?" . $parameter_key . "kd_tabel=tb_stores' />Close</a>"); } else { display_error("Gagal menghapus data <br>" . "(" . mysql_error() . ") | <a href='?" . $parameter_key . "kd_tabel=tb_stores' />Close</a>"); } // } } //-------------------------------FORM----------------------------------------- start_form(); //form input if (isset($_POST['AddNew'])) { start_table("class='form'"); text_field('Store Name: ', 'store_name', $val_selected['store_name'], true); text_area('Description: ', 'description', $val_selected['description']); text_field('Address: ', 'address', $val_selected['address'], false);
function udutu_seq_set($what, $scoid, $userid, $attempt = 0, $value = 'true') { /// set passed activity to active or not if ($value == false) { delete_record('udutu_scoes_track', 'scoid', $scoid, 'userid', $userid, 'element', $what); } else { $sco = udutu_get_sco($scoid); udutu_insert_track($userid, $sco->udutu, $sco->id, 0, $what, $value); } }
function borrar_id($id) { delete_record('ejercicios_ierc_resp', 'id', $id); }
// Create the final message. if ($PIC_NEED_APPROVAL) { if ($file_placement == 'no') { $final_message = '' . $lang_upload_php['no_place'] . '<br /><br />' . $lang_db_input_php['upload_success']; } else { $final_message = '' . $lang_upload_php['yes_place'] . '<br /><br />' . $lang_db_input_php['upload_success']; } } else { if ($file_placement == 'no') { $final_message = '' . $lang_upload_php['no_place'] . '<br /><br />' . $lang_upload_php['process_complete']; } else { $final_message = '' . $lang_upload_php['yes_place'] . '<br /><br />' . $lang_upload_php['process_complete']; } } // Delete the temporary data file. delete_record($superCage->post->getAlnum('unique_ID')); // Send e-mail notification to the admin if requested (added by gaugau: 03-11-09). if ($CONFIG['upl_notify_admin_email'] and $PIC_NEED_APPROVAL) { // Encapsulate so included lang file doesn't interfere with global one function cpg_send_upload_notification() { global $CONFIG; $lang_db_input_php = cpg_get_default_lang_var('lang_db_input_php'); // Get the mail files. include_once 'include/mailer.inc.php'; // Send the message. cpg_mail('admin', sprintf($lang_db_input_php['notify_admin_email_subject'], $CONFIG['gallery_name']), sprintf($lang_db_input_php['notify_admin_email_body'], USER_NAME, $CONFIG['ecards_more_pic_target'] . (substr($CONFIG["ecards_more_pic_target"], -1) == '/' ? '' : '/') . 'editpics.php?mode=upload_approval')); } cpg_send_upload_notification(); } // That was the last one. Create a redirect box.
} foreach ($enrolledusers as $user) { $dataobj = new stdClass(); $dataobj->userid = $user->id; $dataobj->hostid = $mnet_peer->id; $dataobj->courseid = $courseid; $dataobj->rolename = $all_enrolled_users[$user->username]['name']; $dataobj->enroltype = $all_enrolled_users[$user->username]['enrol']; if ($user->wehaverecord == 0) { $dataobj->enroltime = $all_enrolled_users[$user->username]['timemodified']; $dataobj->id = insert_record('mnet_enrol_assignments', $dataobj); } elseif (array_key_exists($user->username, $all_enrolled_users)) { $dataobj->id = $user->enrolid; update_record('mnet_enrol_assignments', $dataobj); } elseif (is_array($all_enrolled_users) && count($all_enrolled_users)) { delete_record('mnet_enrol_assignments', 'id', $user->enrolid); } } unset($enrolledusers); // Read about our remote enrolments in 2 sets // first, get the remote enrolments done via enrol/mnet $mnetenrolledusers // second, get the remote enrolments done with other plugins $remtenrolledusers // NOTE: both arrays are keyed on the userid! $sql = "\n SELECT\n u.id,\n u.firstname,\n u.lastname,\n a.rolename,\n a.enroltype,\n a.courseid\n FROM\n {$CFG->prefix}user u,\n {$CFG->prefix}mnet_enrol_assignments a\n WHERE\n a.userid = u.id AND \n a.courseid={$courseid} AND\n a.enroltype = 'mnet' AND\n u.deleted = 0 AND\n u.confirmed = 1 AND\n u.mnethostid = {$CFG->mnet_localhost_id}\n ORDER BY\n u.firstname ASC,\n u.lastname ASC"; if (!($mnetenrolledusers = get_records_sql($sql))) { $mnetenrolledusers = array(); } $sql = "\n SELECT\n u.id,\n u.firstname,\n u.lastname,\n a.rolename,\n a.enroltype,\n a.courseid\n FROM\n {$CFG->prefix}user u,\n {$CFG->prefix}mnet_enrol_assignments a\n WHERE\n a.userid = u.id AND \n a.courseid={$courseid} AND\n a.enroltype != 'mnet' AND\n u.deleted = 0 AND\n u.confirmed = 1 AND\n u.mnethostid = {$CFG->mnet_localhost_id}\n ORDER BY\n u.firstname ASC,\n u.lastname ASC"; if (!($remtenrolledusers = get_records_sql($sql))) { $remtenrolledusers = array(); }
$show_insert_form_after_error = 1; $show_edit_form_after_error = 1; // display the form $form = build_form($table_name, $action, $fields_labels_ar, $form_type, $res_details, $where_field, $where_value, $show_insert_form_after_error, $show_edit_form_after_error); echo $form; } // end if } // end if break; case "delete": if ($enable_delete == "1") { // deletion of a record from a table, after the deletion we need to redirect to the show results mode $location_url = $site_url . $dadabik_main_file . '?table_name=' . urlencode($table_name) . '&function=search&where_clause=' . urlencode($where_clause); if ($enable_authentication === 0 || $enable_delete_authorization === 0 || current_user_is_owner($where_field, $where_value, $table_name, $fields_labels_ar)) { delete_record($table_name, $where_field, $where_value); } else { $location_url .= '&just_delete_no_authorization=1'; } // end else header('Location: ' . $location_url); exit; } // end if break; case "delete_all": if ($enable_delete == "1" && $enable_delete_all_feature === 1) { $ID_user_field_name = get_ID_user_field_name($fields_labels_ar); delete_multiple_records($table_name, $where_clause, $ID_user_field_name); $location_url = $site_url . $dadabik_main_file . '?table_name=' . urlencode($table_name) . "&function=search&where_clause=&page=0"; if ($enable_browse_authorization === 0 && $ID_user_field_name !== false) {
} // REMOVE FROM CATEGORIES if ($_POST['omnitool'] == '9' && !empty($_POST['category'])) { while (list(, $value) = each($export_files)) { $file_query = $dbHandle->quote($value); while (list(, $cat) = each($_POST['category'])) { print "DELETE FROM filescategories WHERE fileID={$file_query} AND categoryID=" . intval($cat); $dbHandle->exec("DELETE FROM filescategories WHERE fileID={$file_query} AND categoryID=" . intval($cat)); } reset($_POST['category']); } } $dbHandle->commit(); // DELETE ITEMS if ($_POST['omnitool'] == '8' && isset($_SESSION['permissions']) && $_SESSION['permissions'] == 'A') { delete_record($dbHandle, $export_files); } $dbHandle = null; } elseif (isset($_SESSION['auth'])) { ?> <div> <table class="threed" cellspacing=0 style="width:100%"> <tr> <td class="threed select_span omnitooltd" style="width:32%;line-height:22px"> <input type="radio" style="display:none" name="omnitool" value="1"> <i class="fa fa-circle-o"></i> Save to Shelf </td> <td class="threed select_span omnitooltd" style="width:32%;line-height:22px"> <input type="radio" style="display:none" name="omnitool" value="5">
if (isset($_GET['clear_all_records'])) { global $wpdb; $db_table = DB_TABLE_WPWSL_HISTORY; $wpdb->query("delete from {$db_table}"); } function delete_record($id) { global $wpdb; $db_table = DB_TABLE_WPWSL_HISTORY; $wpdb->query("delete from {$db_table} where id='{$id}'"); } if (isset($_GET['action']) && isset($_GET['action2'])) { if ($_GET['action'] == 'delete' || $_GET['action2'] == 'delete') { if (isset($_GET['record'])) { foreach ($_GET['record'] as $r) { delete_record($r); } } } } function results_order() { $orderby = !empty($_GET['orderby']) ? $_GET['orderby'] : 'time'; $order = !empty($_GET['order']) ? $_GET['order'] : 'desc'; return $orderby . " " . $order; } $order = results_order(); $paged = isset($_GET['paged']) ? $_GET['paged'] : 1; $start = ($paged - 1) * SELECT_ROWS_AMOUNT; global $wpdb; //history