function delete_event($id) { $event = R::load('events', $id); //reloads our event R::trash($event); //for one bean }
public static function clean($f3, $filename) { $total_filesize = R::getCell('select sum(filesize) as total_filesize from cache'); $cache_total_filesize_limit = $f3->get("UPLOAD.cache_total_size_limit"); $cache_total_filesize_limit = PFH_File_helper::convert_filesize_in_bytes($cache_total_filesize_limit); if ($total_filesize > $cache_total_filesize_limit) { $caches = R::find("cache", "ORDER BY datetime"); $count = count($caches); // 只有一個不刪除 //if ($count < 2) { // return; //} foreach ($caches as $key => $cache) { //不刪除最後一個 //if ($key > $count - 1) { // return; //} if ($cache->path === $filename) { continue; } //throw new Exception("$key $cache->path"); //echo $cache->path . "<br />"; if (is_file($cache->path)) { unlink($cache->path); } $total_filesize = $total_filesize - $cache->filesize; R::trash($cache); if ($total_filesize < $cache_total_filesize_limit) { break; } } } }
function delete_news($id) { $news = R::load('news', $id); //reloads our event R::trash($news); //for one bean }
public static function doDeleteById($id) { $user = R::dispense('user'); $user->id = $id; R::trash($user); //for one bean }
public function deleteFromList($id) { $ban = R::load('banlist', $id); $value = $ban->value; R::trash($ban); return $value; }
/** * Test SQLite table rebuilding. * * @return void */ public function testRebuilder() { $toolbox = R::$toolbox; $adapter = $toolbox->getDatabaseAdapter(); $writer = $toolbox->getWriter(); $redbean = $toolbox->getRedBean(); $pdo = $adapter->getDatabase(); R::dependencies(array('page' => array('book'))); $book = R::dispense('book'); $page = R::dispense('page'); $book->ownPage[] = $page; $id = R::store($book); $book = R::load('book', $id); asrt(count($book->ownPage), 1); asrt((int) R::getCell('SELECT COUNT(*) FROM page'), 1); R::trash($book); asrt((int) R::getCell('SELECT COUNT(*) FROM page'), 0); $book = R::dispense('book'); $page = R::dispense('page'); $book->ownPage[] = $page; $id = R::store($book); $book = R::load('book', $id); asrt(count($book->ownPage), 1); asrt((int) R::getCell('SELECT COUNT(*) FROM page'), 1); $book->added = 2; R::store($book); $book->added = 'added'; R::store($book); R::trash($book); asrt((int) R::getCell('SELECT COUNT(*) FROM page'), 0); }
/** * Check for a role * * @param string $contextname The name of a context... * @param string $rolename The name of a role.... * * @return void */ public function delrole($contextname, $rolename) { $cname = R::findOne('rolecontext', 'name=?', array($contextname)); $rname = R::findOne('rolename', 'name=?', array($rolename)); $bn = R::findOne('role', 'rolecontext_id=? and rolename_id=? and user_id=? and start <= UTC_TIMESTAMP() and (end is NULL or end >= UTC_TIMESTAMP())', array($cname->getID(), $rname->getID(), $this->bean->getID())); if (is_object($bn)) { R::trash($bn); } }
public static function eliminar() { if (isset($_GET['id'])) { $user = R::load('user', $_GET['id']); $username = $user->name; R::trash($user); //$_SESSION['flash'] = "Usuario $username eliminado exitosamente"; } }
public static function destruir() { global $session, $logged; if (isset($logged) && isset($session)) { R::trash($session); setcookie("logged", "", time() - 1); $_SESSION['flash'] = 'Ha cerrado sesión correctamente'; } header('Location:/'); }
/** * Function to clear invalid login attempts * @param string $username email or username of user * @return int login attempts left * **/ public function clearInvalidLoginAttempts($username) { $userRow = \R::findOne('users', 'email=:ui OR user_name = :ui', array(':ui' => $username)); if ($userRow) { $userAttemptRow = \R::findOne($this->_name, 'user_id = :ui', array(':ui' => $userRow->id)); if ($userAttemptRow) { \R::trash($userAttemptRow); } } }
public function delete_page($args) { $page_id = array_shift($args); if ($page = R::load('page', $page_id)) { $old = clone $page; R::trash($page); Audit::create($old, NULL, 'Developer deleted page from system'); } $this->redirect(PACKAGE_URL); }
public function deleteMessage($user_id, $m_id) { $message = R::findOne('message', ' recipient_id = ? && id = ? ', [$user_id, $m_id]); if ($message == NULL) { return NULL; } R::trash($message); $data = array("rc" => 0); return json_encode($data); }
public function deleteCity() { $count = R::count('jobs', " city=:city ", array(':city' => $this->_id)); if (!$count) { $city = R::load('cities', $this->_id); R::trash($city); return true; } return false; }
public function show_deleteUser() { if ($this->user->password != Framework::hash($_POST['password'])) { $this->error('Das Passwort war falsch!'); } R::trash($this->user); $this->show_Logoff(); $this->output('deleted', true); $this->output('message', 'Der Account wurde gelöscht.'); }
public function deleteCategory() { $count = R::count('jobs', " category=:category ", array(':category' => $this->_id)); if (!$count) { $category = R::load('categories', $this->_id); R::trash($category); return true; } return false; }
public function delete($args) { $posttype = array_shift($args); $id = array_shift($args); $post = current(R::findOrDispense('post', 'id = :id', ['id' => $id])); if ($post->getID()) { R::trash($post); } $this->redirect(PACKAGE_URL . "posts/view/{$posttype}"); }
private function handleChanges() { if (!isset($_POST['entryAction'])) { return; } if ($_POST['entryAction'] == 'add') { $bean = R::dispense($this->currentTable); } elseif ($_POST['entryAction'] == 'edit' && is_numeric($_POST['entryId'])) { $bean = R::load($this->currentTable, $_POST['entryId']); if (!$bean->id) { die('Invalid ID'); } } elseif ($_POST['entryAction'] == 'delete' && is_numeric($_POST['entryId'])) { $bean = R::load($this->currentTable, $_POST['entryId']); if (!$bean->id) { die('Invalid ID'); } R::trash($bean); Framework::Redir("game/db_admin"); return; } elseif ($_POST['entryAction'] == 'duplicate' && is_numeric($_POST['entryId'])) { $bean = R::load($this->currentTable, $_POST['entryId']); if (!$bean->id) { die('Invalid ID'); } $newBean = R::dispense($this->currentTable); foreach ($this->dbTables[$this->currentTable] as $f) { $newBean->{$f} = $bean->{$f}; } R::store($newBean); Framework::Redir("game/db_admin"); return; } else { Framework::Redir("game/db_admin"); return; } // load stuff into bean $bean->import($_POST['entry'], implode(",", $this->dbTables[$this->currentTable])); // check if any special prehooks defined for current table $beanHook = 'prehook' . ucfirst($this->currentTable); if (method_exists($this, $beanHook)) { $this->{$beanHook}($bean); } // store bean R::store($bean); // post hook $beanHook = 'posthook' . ucfirst($this->currentTable); if (method_exists($this, $beanHook)) { $this->{$beanHook}($bean); } Framework::Redir("game/db_admin"); }
/** * Tests dependencies (variation). * * @return void */ public function testDependency4() { R::dependencies(array('bean' => array('can'))); $can = $this->createCanForBean(); asrt(R::count('bean'), 1); R::trash($can); asrt(R::count('bean'), 0); R::dependencies(array()); $can = $this->createCanForBean(); asrt(R::count('bean'), 1); R::trash($can); asrt(R::count('bean'), 1); }
/** * Test for issue90. * Checking 'own' relationship, makes it impossible to trash a bean. * * @return void */ public function testIssue90() { $s = R::dispense('box'); $s->name = 'a'; $f = R::dispense('bottle'); $s->ownBottle[] = $f; R::store($s); $s2 = R::dispense('box'); $s2->name = 'a'; R::store($s2); R::trash($s2); pass(); }
public static function completar() { //global $logged; if (isset($_POST['id'])) { $request = R::load('request', $_POST['id']); $completed = R::dispense('completed'); $completed->import($request->export(), 'name, user_id'); $completed->date = R::isoDateTime(); $completed->agregado = $request->date; $id = R::store($completed); R::trash($request); echo json_encode(["exito" => 1]); } }
public function Delete() { if (isset($_GET["id"])) { $user = R::load('user', $_GET['id']); if (!$user) { throw new Exception("Unknown user"); } else { R::trash($user); } } else { throw new Exception("Unknown user"); } return array(); }
public function after_update() { // check if amount == 0 if ($this->amount <= 0) { R::trash($this->bean); return; } // check if merging two entries is possible $mergeTo = R::findOne('bank_locker', " param = ? AND user_id = ? AND item_id = ? AND id != ?", array($this->param, $this->user->id, $this->item->id, $this->id)); if ($mergeTo != false) { R::exec("UPDATE bank_locker SET amount = ? WHERE id = ?", array($this->amount + $mergeTo->amount, $this->id)); R::trash($mergeTo); } }
public static function removeChild($table, $parentBean, $bean) { //we still need 2 separate queries because the parent's left_id can't be updated... R::begin(); try { R::trash($bean); R::exec('UPDATE ' . $table . ' SET left_id = left_id-2 WHERE left_id > ?', array($bean->right_id)); R::exec('UPDATE ' . $table . ' SET right_id = right_id-2 WHERE right_id >= ?', array($bean->right_id)); $parentBean->right_id -= 2; R::commit(); } catch (Exception $e) { R::rollback(); throw $e; } }
public function show_Cancel() { if (!$this->user->hasPremium()) { $this->error('Nur für Premiumaccounts.'); } if (!is_numeric($this->get(1)) || $this->get(1) < 1) { $this->error('Ungültige ID'); } $crule = R::relatedOne($this->myCompany, 'crule', 'id = ?', array($this->get(1))); if (!$crule) { $this->error('Die ID wurde nicht gefunden.'); } R::trash($crule); $this->output('load', 'show'); }
public function cancel() { $cs = Config::getConfig("company_quests"); $details = $cs[$this->name]; //$company = R::relatedOne($this->bean, 'company'); $user = R::relatedOne($this->bean, 'user'); if ($user == null) { R::trash($this->bean); return; } $company = R::findOne('company', 'user_id = ?', array($user->id)); $company->balance -= floor($details["oncomplete"]["cash"] * 0.1); R::begin(); R::trash($this->bean); R::store($company); R::commit(); }
public function execute() { $this->template->heading('ORM Example'); // Call ORM plugin. $this->factory('orm'); // Will create a table called 'book'; $book = R::dispense('example_book'); // Deleting a record if (!empty($_GET['delete'])) { $sold = R::load("example_book", $_GET['delete']); R::trash($sold); $this->template->note(sprintf('Record %s was deleted', $_GET['delete'])); } // Sell a book if (!empty($_GET['sell'])) { $title = urldecode($_GET['title']); $this->template->ok("Great, thanks for buying \"{$title}\". You are a little weird reading this, but who are we to judge.", false, false); } // To update a field, you need to provide the id (always id) like so; // $book->id = 1; // Will execute saving to database. if (!empty($_GET['sell'])) { $sold = $book->import($_GET, 'category,type,author,price,title'); if ($sold) { $this->template->ok("That went well, we just sold another book.", false, false); } R::store($book); } // Reading from ORM is just as simple... $books = R::find('example_book'); $book1 = $this->navigation->sefURL(null, 'sell=true&category=books&type=Sci-Fiction&author=Peter Viljoen&price=3.99&title=The Robot Rapist'); $book2 = $this->navigation->sefURL(null, 'sell=true&category=books&type=Health&author=Samie Caster&price=2.99&title=Getting hard again'); $book3 = $this->navigation->sefURL(null, 'sell=true&category=books&type=Horror&author=Lion Wessels&price=8.99&title=Cinderella goes rogue'); // Please see http://redbeanphp.com/ for complete manual. // For all R methods see : http://www.redbeanphp.com/api/class_r.html $view = $this->factory('views'); $view->set('delete', $this->navigation->sefURL(null, 'delete=')); $view->set('special1', $book1); $view->set('special2', $book2); $view->set('special3', $book3); $view->set('books', $books); $view->show(); }
public function cancel_Order() { // when deleting an order, cash and ress must be returned to company $company = R::relatedOne($this->bean, 'company'); if ($this->type == 'buy') { // buy order needs cash updated $company->balance += $this->r_amount * $this->price; R::store($company); R::trash($this->bean); } else { // sell order needs ress updated if ($this->r_type == 'resource') { $holder = R::findOne('company_ress', ' company_id = ?', array($company->id)); } else { $holder = R::findOne('company_products', ' company_id = ?', array($company->id)); } $holder->{$this->r_name} += $this->r_amount; R::store($holder); R::trash($this->bean); } }
private function MoveItem($id, $direction) { $take = $direction == "take" ? "bank_locker" : "inventory"; $put = $direction == "take" ? "inventory" : "bank_locker"; $action = $direction == "take" ? "storage" : "store"; $item = R::findOne($take, ' user_id = ? AND id = ?', array($this->user->getID(), $id)); if (!$item) { $this->output('maintext', 'Ungültiges Item angegeben!'); return; } $amount = isset($_POST["amount"]) && is_numeric($_POST["amount"]) ? $_POST["amount"] : -1; if ($item->amount > 1 && ($amount == -1 || $amount > $item->amount)) { $this->output('maintext', 'Wie oft möchtest du ' . htmlspecialchars($item->item->name) . ' ' . ($direction == "take" ? "mitnehmen" : "abgeben") . '?'); $this->output('form', array('target' => $action . '/' . $item->id, 'elements' => array(array('desc' => 'Menge', 'type' => 'text', 'name' => 'amount', 'value' => $item->amount)))); return; } if ($amount == -1 || $amount > $item->amount) { $amount = 1; } $locker = R::dispense($put); $locker->user = $this->user; $locker->item = $item->item; $locker->amount = $amount; $locker->param = $item->param; R::$adapter->startTransaction(); R::store($locker); $item->amount -= $amount; if ($item->amount == 0) { R::trash($item); } else { R::store($item); } R::$adapter->commit(); $this->output('maintext', 'Du hast das Item ' . htmlspecialchars($item->item->name) . ' ' . $amount . 'x ' . ($direction == "take" ? "mitgenommen" : "abgegeben")); $this->output('options', array("interact" => "Zurück")); return; }
/** * Test if RedBeanPHP can properly handle keywords. * * @return void */ public function testKeywords() { $keywords = array('anokeyword', 'znokeyword', 'group', 'DROP', 'inner', 'JOIN', 'select', 'table', 'int', 'cascade', 'float', 'CALL', 'in', 'status', 'order', 'limit', 'having', 'else', 'if', 'while', 'distinct', 'like'); R::setStrictTyping(FALSE); RedBean_OODBBean::setFlagBeautifulColumnNames(FALSE); foreach ($keywords as $k) { R::nuke(); $bean = R::dispense($k); $bean->{$k} = $k; $id = R::store($bean); $bean = R::load($k, $id); $bean2 = R::dispense('other'); $bean2->name = $k; $bean->bean = $bean2; $bean->ownBean[] = $bean2; $bean->sharedBean[] = $bean2; $id = R::store($bean); R::trash($bean); pass(); } RedBean_OODBBean::setFlagBeautifulColumnNames(TRUE); R::setStrictTyping(TRUE); }
/** * Test boxing beans. * * @return void */ public function testBoxing() { R::nuke(); $bean = R::dispense('boxedbean')->box(); R::trash($bean); pass(); $bean = R::dispense('boxedbean'); $bean->sharedBoxbean = R::dispense('boxedbean')->box(); R::store($bean); pass(); $bean = R::dispense('boxedbean'); $bean->ownBoxedbean = R::dispense('boxedbean')->box(); R::store($bean); pass(); $bean = R::dispense('boxedbean'); $bean->other = R::dispense('boxedbean')->box(); R::store($bean); pass(); $bean = R::dispense('boxedbean'); $bean->title = 'MyBean'; $box = $bean->box(); asrt($box instanceof Model_Boxedbean, TRUE); R::store($box); }