function photo_delete() { $return = "done"; $ID = isset($_REQUEST['ID']) ? $_REQUEST['ID'] : ""; $art = new \DB\SQL\Mapper($this->f3->get("DB"), "dir_items_photos"); $art->load("ID='{$ID}'"); $art->erase(); return $GLOBALS["output"]['data'] = $return; }
function edit($f3) { $video = new DB\SQL\Mapper($f3->get('db'), 'videos'); $video->load(array('id=?', $f3->get('PARAMS.videoID'))); if ($f3->get('POST.delete') == '1') { $video->erase(); } else { $video->startTime = $f3->get('POST.startTime'); $video->endTime = $f3->get('POST.endTime'); $video->save(); } $f3->reroute('@channelList'); }
function post_delete_food($f3) { $orm = new DB\SQL\Mapper($f3->get('DB'), 'MEAL'); $selectIds = $f3->get('POST.selectId'); $redirect = $f3->get("POST.destination"); if (isset($selectIds)) { foreach ($selectIds as $meal) { $orm->load(array('id = ?', $meal)); if (!$orm->dry()) { $orm->erase(); } $orm->reset(); } AlertControl::message_info("Valitut annokset on poistettu"); $f3->reroute($redirect); } $menuId = $f3->get('POST.menuId'); $id = $f3->get('PARAMS.id'); $orm->load(array('id=?', $id)); $meal_name = $orm->name; $orm->erase(); AlertControl::message_info("Annos {$meal_name} on poistettu"); $f3->reroute("/menu/{$menuId}"); }
static function remove($ID) { $timer = new timer(); $f3 = \base::instance(); // test_array($values); $art = new \DB\SQL\Mapper($f3->get("DB"), "dir_users"); $art->load("ID='{$ID}'"); $art->erase(); $timer->_stop(__NAMESPACE__, __CLASS__, __FUNCTION__, func_get_args()); return "done"; }
public function deleteShout($id) { $delete = new \DB\SQL\Mapper($this->db, $this->prefix . 'shoutbox'); if ($delete->count(["id = ?", $id]) == 0) { return FALSE; } $delete->erase(["id = ?", $id]); return TRUE; }
public function libraryBookFavDelete($params) { if (empty($params['id'][0]) or empty($params['id'][1])) { return FALSE; } if (in_array($params["id"][0], ["AU", "RC", "SE", "ST"])) { $mapper = new \DB\SQL\Mapper($this->db, $this->prefix . 'user_favourites'); $mapper->load(array("uid=? AND item=? AND type=? AND bookmark=?", $_SESSION['userID'], $params["id"][1], $params["id"][0], array_key_exists("bookmark", $params) ? 1 : 0)); if (NULL !== ($fid = $mapper->get('fid'))) { $mapper->erase(); return TRUE; } unset($mapper); return FALSE; } }
$table = $schema->createTable('pastes'); $table->addColumn('data')->type_text(); $table->addColumn('crdate')->type_datetime(); $table->addColumn('lifetime')->type_datetime(); $table->addColumn('uuid')->type_varchar(30)->index(true); $table->build(); echo "installed"; } else { echo "already installed"; } }); // stats and cleanup $f3->route(array('GET @stats: /stats', 'GET @cleanup: /cleanup'), function (Base $f3, $params) { $mapper = new \DB\SQL\Mapper($f3->get('DB'), $f3->get('db_table')); if ($f3->get('ALIAS') == 'cleanup') { $f3->set('cleanup', $mapper->erase(array('lifetime < ?', date('Y-m-d H:i:s')))); } $f3->set('all', $mapper->count()); $f3->set('old', $mapper->count(array('lifetime < ?', date('Y-m-d H:i:s')))); $f3->set('sub_tmpl', 'stats.html'); echo \Template::instance()->render('layout.html'); }); // error handler $f3->set('ONERROR', function (Base $f3) { $error = $f3->get('ERROR'); while (ob_get_level()) { ob_end_clean(); } if ($f3->get('AJAX')) { echo json_encode($error); exit;
/** * Удаляет элементы связанные с нодом * @param int $pid id нода, для которого надо удалить элементы */ private function deleteItems($pid) { $mapper = new \DB\SQL\Mapper($this->db, $this->table . '__items'); // TODO: Сделать удаление связанных файлов (изображений) $res = $mapper->erase(array('pid=?', $pid)); //echo $res, '<br>'; }
function edit($f3) { $db = $f3->get('db'); $channel = new DB\SQL\Mapper($db, 'channels'); $channel->load(array('id=?', $f3->get('PARAMS.channelID'))); // Delete Channel if ($f3->get('POST.delete') == '1') { $channel->erase(); $db->exec('DELETE FROM videos WHERE channel=?', $f3->get('PARAMS.channelID')); $db->exec('DELETE FROM schedule WHERE channel=?', $f3->get('PARAMS.channelID')); $f3->reroute('@channelList'); // Update Name } else { $channel->name = $f3->get('POST.name'); $channel->live = $f3->get('POST.live'); $channel->save(); $f3->reroute('@channelList'); } }