public function updateRecord() { ///////////////////// // update faq table ///////////////////// $db = new Querier(); $qUpFAQ = "UPDATE faq SET question = " . $db->quote(scrubData($this->_question, "text")) . ",\n\t answer = " . $db->quote(scrubData($this->_answer, 'richtext')) . ",\n\t keywords = " . $db->quote(scrubData($this->_keywords, 'text')) . "\n WHERE faq_id = " . scrubData($this->_faq_id, 'integer'); $rUpFAQ = $db->query($qUpFAQ); $this->_debug = "<p>1. update faq: {$qUpFAQ}</p>"; ///////////////////// // clear faq_subject ///////////////////// $qClearSubs = "DELETE FROM faq_subject WHERE faq_id = " . $this->_faq_id; $rClearSubs = $db->query($qClearSubs); $this->_debug .= "<p>2. clear rank: {$qClearSubs}</p>"; if ($rClearSubs === FALSE) { echo blunDer("We have a problem with the clear faq-subs query: {$qClearSubs}"); } ///////////////////// // insert into subject //////////////////// self::modifySubjects(); // wipe entry from intervening table $qClearColls = "DELETE FROM faq_faqpage WHERE faq_id = " . scrubData($this->_faq_id, "integer"); $rClearColls = $db->query($qClearColls); $this->_debug .= "<p>4. wipe faq_faqpage: {$qClearColls}</p>"; if ($rClearColls === FALSE) { echo blunDer("We have a problem with the clear locations query: {$qClearColls}"); } ///////////////////// // insert/update collections //////////////////// self::modifyCollections(); // ///////////////////// // Alter chchchanges table // table, flag, item_id, title, staff_id //////////////////// $updateChangeTable = changeMe("faq", "update", $this->_faq_id, $this->_question, $_SESSION['staff_id']); // message $this->_message = _("Thy Will Be Done. Updated."); }
public function updateBio($new_bio) { $db = new Querier(); $q = "UPDATE staff SET bio = " . $db->quote(scrubData($new_bio, "richtext")) . " WHERE staff_id = " . $this->_staff_id; $this->_debug = "<p class=\"debug\">Bio Update query: {$q}</p>"; $r = $db->exec($q); // now our detailed version $q2 = "UPDATE staff SET bio = " . $db->quote(scrubData($new_bio, "richtext")) . " WHERE staff_id = " . $this->_staff_id; $this->_debug .= "<p class=\"debug\">Bio Update query: {$q2}</p>"; $r2 = $db->query($q2); if ($r) { $updateChangeTable = changeMe("staff", "update", $this->_staff_id, "bio update", $_SESSION['staff_id']); return TRUE; } }
public function updateRecord() { global $use_disciplines; // Check to make sure the title or shortform haven't been changed to create dupes $is_dupe = self::dupeCheck(); if ($is_dupe == TRUE) { $this->_message = _("There is already a guide with this SHORTFORM. The shortform must be unique."); return; } //print_r($_POST); ////////////////// // Encode our extra as json ///////////////// $json_extra = json_encode($this->_extra); ///////////////////// // update subject table ///////////////////// $db = new Querier(); $qUpSubject = "UPDATE subject SET subject = " . $db->quote(scrubData($this->_subject, "text")) . ",\n shortform = " . $db->quote(scrubData($this->_shortform, "text")) . ",\n description = " . $db->quote(scrubData($this->_description, "text")) . ",\n keywords = " . $db->quote(scrubData($this->_keywords, "text")) . ",\n redirect_url = " . $db->quote(scrubData($this->_redirect_url, "text")) . ",\n active = " . $db->quote(scrubData($this->_active, "integer")) . ",\n type = " . $db->quote(scrubData($this->_type, "text")) . ",\n header = " . $db->quote(scrubData($this->_header, "text")) . ",\n extra = " . $db->quote($json_extra) . "\n WHERE subject_id = " . scrubData($this->_subject_id, "integer"); $rUpSubject = $db->exec($qUpSubject); ///////////////////// // clear staff_subject ///////////////////// $qClearSS = "DELETE FROM staff_subject WHERE subject_id = " . $this->_subject_id; $rClearSS = $db->exec($qClearSS); $this->_debug .= "<p>2. clear staff_subject: {$qClearSS}</p>"; ///////////////////// // insert into staff_subject //////////////////// self::modifySS(); ///////////////////// // clear subject_subject -- for parent-child relationships ///////////////////// $qClearSubS = "DELETE FROM subject_subject WHERE subject_child = " . $this->_subject_id; $rClearSubS = $db->exec($qClearSubS); $this->_debug .= "<p>2. clear subject_subject: {$qClearSubS}</p>"; ///////////////////// // insert into subject_subject //////////////////// self::modifySubSub(); ///////////////////// // clear subject_discipline ///////////////////// if ($use_disciplines == TRUE) { $qClearSD = "DELETE FROM subject_discipline WHERE subject_id = " . $this->_subject_id; $rClearSD = $db->query($qClearSD); $this->_debug .= "<p>2. clear subject_discipline: {$qClearSD}</p>"; ///////////////////// // insert into subject_discipline //////////////////// self::modifySD(); } // ///////////////////// // Alter chchchanges table // table, flag, item_id, title, staff_id //////////////////// $updateChangeTable = changeMe("guide", "update", $this->_subject_id, $this->_subject, $_SESSION['staff_id']); if (isset($_REQUEST["wintype"]) && $_REQUEST["wintype"] == "pop") { $this->_message = _("Thy Will Be Done. Guide updated."); } else { $this->_message = _("Thy Will Be Done.") . " <a href=\"guide.php?subject_id=" . $this->_subject_id . "\">" . _("Add Content To Your New Guide") . "</a>"; } }
public function updateRecord($notrack = 0) { $db = new Querier(); // dupe check ///////////////////// // update title table ///////////////////// $db = new Querier(); $our_title = $db->quote(scrubData($this->_title)); $our_alternate_title = $db->quote(scrubData($this->_alternate_title)); $our_prefix = $db->quote(scrubData($this->_prefix)); $qUpTitle = "UPDATE title SET title = " . $our_title . ", alternate_title = " . $our_alternate_title . ", description = " . $db->quote(scrubData($this->_description, "richtext")) . ", pre = " . $our_prefix . " WHERE title_id = " . scrubData($this->_title_id, "integer"); $rUpTitle = $db->exec($qUpTitle); ///////////////////// // clear rank ///////////////////// $qClearRank = "DELETE FROM rank WHERE title_id = " . $this->_title_id; $rClearRank = $db->exec($qClearRank); $this->_debug .= "<p>2. clear rank: {$qClearRank}</p>"; if ($rClearRank === FALSE) { echo blunDer("We have a problem with the clear rank query: {$qClearRank}"); } ///////////////////// // insert into rank //////////////////// self::modifyRank(); // wipe entry from intervening table, location_title $qClearLoc = "DELETE FROM location_title WHERE title_id = " . scrubData($this->_title_id, "integer"); $rClearLoc = $db->exec($qClearLoc); $this->_debug .= "<p>4. wipe location_title: {$qClearLoc}</p>"; if ($rClearLoc === FALSE) { echo blunDer("We have a problem with the clear locations query: {$qClearLoc}"); } ///////////////////// // insert/update locations //////////////////// self::modifyLocation(); // ///////////////////// // Alter chchchanges table // table, flag, item_id, title, staff_id //////////////////// if ($notrack != 1) { $updateChangeTable = changeMe("record", "update", $this->_title_id, $our_title, $_SESSION['staff_id']); } // message $this->_message = _("Thy Will Be Done. Record updated."); }
public function updateRecord() { ///////////////////// // update talkback table ///////////////////// $db = new Querier(); $qUpTB = "UPDATE talkback SET question = " . $db->quote(scrubData($this->_question, 'text')) . ",\n\t q_from = " . $db->quote(scrubData($this->_q_from, 'text')) . ",\n\t answer = " . $db->quote(scrubData($this->_answer, 'richtext')) . ","; if ($this->_a_from == '') { $qUpTB .= "a_from = NULL,"; } else { $qUpTB .= "a_from = " . $db->quote(scrubData($this->_a_from, 'text')) . ","; } $qUpTB .= "display = " . $db->quote(scrubData($this->_display, 'integer')) . ",\n \n tbtags = " . $db->quote(scrubData($this->_tbtags, 'text')) . ",\n cattags = " . $db->quote(scrubData($this->_cattags, 'text')) . "\n \n WHERE talkback_id = " . scrubData($this->_talkback_id, 'integer'); //print $qUpTB; $rUpTB = $db->exec($qUpTB); // ///////////////////// // Alter chchchanges table // table, flag, item_id, title, staff_id //////////////////// $updateChangeTable = changeMe("talkback", "update", $this->_talkback_id, $this->_question, $_SESSION['staff_id']); // message $this->_message = _("Thy Will Be Done. Updated."); }
public function updateBio($new_bio) { $q = "UPDATE staff SET bio = '" . $db->quote(scrubData($new_bio, "richtext")) . "' WHERE staff_id = " . $this->_staff_id; $this->_debug = "<p class=\"debug\">Bio Update query: {$q}</p>"; $r = $db->query($q); if ($r) { $updateChangeTable = changeMe("staff", "update", $this->_staff_id, "bio update", $_SESSION['staff_id']); return TRUE; } }
public function updateRecord() { $db = new Querier(); ///////////////////// // update video table ///////////////////// // print "UPDATE RECORD!!!"; $qUpVid = "UPDATE video SET title = " . $db->quote($this->_title) . ", description = " . $db->quote(scrubData($this->_description, 'text')) . "," . "source = " . $db->quote($this->_source) . "," . "foreign_id = " . $db->quote($this->_foreign_id) . "," . "duration = " . $db->quote($this->_duration) . "," . "date = " . $db->quote($this->_date) . "," . "display = " . $db->quote($this->_display) . "," . "vtags = " . $db->quote($this->_vtags) . "WHERE video_id = " . $db->quote($this->_video_id); //print $qUpVid; $rUpVid = $db->exec($qUpVid); // ///////////////////// // Alter chchchanges table // table, flag, item_id, title, staff_id //////////////////// $updateChangeTable = changeMe("video", "update", $this->_video_id, $this->_title, $_SESSION['staff_id']); // message $this->_message = _("Thy Will Be Done. Updated."); }