public function deleteCurrency($currencyId)
{
global $mySession;
$db = new Db();
$condition1 = "currency_id='" . $currencyId . "'";
$db->delete(CURRENCY, $condition1);
}
public function deleteSpecification($specId)
{
echo $specId;
global $mySession;
$db = new Db();
$condition1 = "spec_id='" . $specId . "'";
$db->delete(SPECIFICATION, $condition1);
$db->delete(SPEC_CHILD, $condition1);
}
public function deleteAttribute($attributeId)
{
global $mySession;
$db = new Db();
$condition1 = "attribute_id='{$attributeId}'";
$db->delete(ATTRIBUTE, $condition1);
//delete all attribute_ans entries
$condition2 = "ans_attribute_id= '{$attributeId}'";
$db->delete(ATTRIBUTE_ANS, $condition2);
}
public function deletereview($ptyleId)
{
global $mySession;
$db = new Db();
$condition1 = "review_id='" . $ptyleId . "'";
$chkQuery = $db->runQuery("select * from " . OWNER_REVIEW . " where review_id = '" . $ptyle_id . "' ");
if ($chkQuery[0]['parent_id'] == '0') {
$condition = "parent_id=" . $ptyle_id;
$db->delete(OWNER_REVIEW, $condition);
}
$db->delete(OWNER_REVIEW, $condition1);
}
public function deleteAmenity($ptyleId)
{
global $mySession;
$db = new Db();
$condition1 = "amenity_id='" . $ptyleId . "'";
$db->delete(AMENITY, $condition1);
}
protected function delete()
{
if (empty($this->id)) {
throw new Exception('Delete error - Undefined ' . self::getClass() . ' id');
}
return Db::delete('DELETE FROM ' . self::getDbTable() . ' WHERE id = :id', array('id' => $this->id));
}
public function deleteProtype($ptyleId)
{
global $mySession;
$db = new Db();
$condition1 = "ptyle_id='" . $ptyleId . "'";
$db->delete(PROPERTYTYPE, $condition1);
}
function upload()
{
global $root;
if ($_FILES['sub']['size'] == 0 && $_FILES['sub']['error'] > 0) {
return 'Error al subir el subtítulo.';
}
$file = $_FILES['sub']['name'];
$frame = Request::getPost('frame');
$comment = Request::getPost('comment');
$credits = Request::getPost('credits');
if (empty($frame)) {
return 'Falta el frame.';
}
$format = substr($file, -3);
$formatName = Formats::get($format);
if (empty($formatName)) {
return 'El archivo no es de un formato válido.';
}
$filename = substr($file, 0, strlen($file) - 4);
$id = Db::insert('subs', array('filename' => $filename, 'ext' => $format, 'frame' => $frame, 'comment' => $comment, 'credits' => $credits, 'time' => time()));
$fullpath = "{$root}/upload/{$id}";
# $fullpath = "/var/www/subs/$id";
if (!@move_uploaded_file($_FILES['sub']['tmp_name'], $fullpath)) {
if ($id) {
Db::delete('subs', "id = '{$id}'");
}
return 'No se logró subir el archivo, intente nuevamente en unos minutos.';
}
header("Location: /{$id}.html");
}
public function clearAllSessions($user)
{
if (empty($user)) {
return;
}
Db::delete('Session', 'user_id = ?', array($user->getId()));
}
public function deleteOffer($sId)
{
global $mySession;
$db = new Db();
$condition1 = "id='" . $sId . "'";
$db->delete(SPCL_OFFER_TYPES, $condition1);
}
public function deleteNews($ptyleId)
{
global $mySession;
$db = new Db();
$condition1 = "news_id='" . $ptyleId . "'";
$db->delete(NEWS, $condition1);
}
public static function save()
{
if (self::$settings !== null) {
// Da nicht gewährleistet ist, dass überhaupt ein Eintrag existiert, oder dass es wirklich nur einer ist,
// einfach die Settings-Tabelle komplett platt machen und den Eintrag neu erzeugen.
Db::delete('settings', '1', array());
Db::insert('settings', array('json' => json_encode(self::$settings)));
}
}
/**
* @return integer
*/
public function delete()
{
if (null === $this->identifier) {
throw new Exception('Identifier not found.');
}
$affected = $this->db->delete($this->table, array($this->identifier => $this->properties[$this->identifier]->get()));
$this->clear();
return $affected;
}
/**
* 删除水印
*
* @param int $id 记录ID
* @return bool 布尔类型的返回结果
*/
public function delStoreWM($id){
if (intval($id) > 0){
$where = " wm_id = '". intval($id) ."'";
$result = Db::delete('store_watermark',$where);
return $result;
}else {
return false;
}
}
public function UpdateGroupTopic($dataForm, $topic_id)
{
global $mySession;
$db = new Db();
$sqlstr = "select * from " . GROUP_TPOIC . " where topic_name='" . $dataForm['topic_name'] . "' and topic_id!='" . $topic_id . "'";
$chkQry = $db->runQuery($sqlstr);
if ($chkQry != "" and count($chkQry) > 0) {
return 0;
} else {
$dataForm['topic_status'] = 1;
$dataForm['created_by'] = $mySession->adminId;
$update_condition = "topic_id='" . $topic_id . "'";
$topicgroup = $dataForm['topic_group'];
unset($dataForm['topic_group']);
if ($dataForm['topic_access_type'] == 1) {
$groupMember = $dataForm['group_member'];
} else {
$groupMember = "";
}
unset($dataForm['group_member']);
$db->modify(GROUP_TPOIC, $dataForm, $update_condition);
$condition = "topic_id='" . $topic_id . "'";
$db->delete(GROUP_TPOIC_CATEGORIES, $condition);
$data['m_status'] = 1;
$db->modify(GROUP_MEMBER, $data, $condition);
//$db->delete(GROUP_MEMBER,$condition);
unset($dataForm);
if (is_array($topicgroup)) {
foreach ($topicgroup as $key => $value) {
$dataForm['category_id'] = $value;
$dataForm['topic_id'] = $topic_id;
$db->save(GROUP_TPOIC_CATEGORIES, $dataForm);
unset($dataForm);
}
}
if (is_array($groupMember)) {
foreach ($groupMember as $key => $value) {
if (isset($dataForm)) {
unset($dataForm);
}
$dataForm['m_status'] = 1;
$sqlstr = "select * from " . GROUP_MEMBER . " where member_id='" . $value . "' and topic_id='" . $topic_id . "'";
if ($chkQry != "" and count($chkQry) > 0) {
$update_condition = "member_id='" . $value . "' and topic_id='" . $topic_id . "'";
$db->modify(GROUP_MEMBER, $dataForm, $update_condition);
} else {
$dataForm['member_id'] = $value;
$dataForm['topic_id'] = $topic_id;
$db->save(GROUP_MEMBER, $dataForm);
}
unset($dataForm);
}
}
return 1;
}
}
/**
* 更新
*
* @param unknown_type $param
*/
public function del($id)
{
if (intval($id) > 0) {
$where = " view_id = '" . intval($id) . "'";
$result = Db::delete('view', $where);
return $result;
} else {
return false;
}
}
/**
* 删除
*
* @param int $id 记录ID
* @return bool 布尔类型的返回结果
*/
public function del($id)
{
if (intval($id) > 0) {
$where = " id = '" . intval($id) . "'";
$result = Db::delete('mb_feedback', $where);
return $result;
} else {
return false;
}
}
public static function delete($id)
{
// verify Csrf token
if (Csrf::verify(Input::post('token')) === false) {
Notifications::set('error', 'Invalid token');
return false;
}
Db::delete('pages', array('id' => $id));
Notifications::set('success', Lang::line('pages.page_success_delete', 'Your page has been deleted'));
return true;
}
public function removeSize($sno)
{
$db = new Db();
$res = false;
if ($sno && (int) $sno > 0) {
error_log('removeSize sno: ' . $sno);
$condition = "sizeid='" . (int) $sno . "'";
$res = $db->delete(TSHIRT_SIZE, $condition);
}
return $res;
}
public function saveReview($dataForm)
{
global $mySession;
$db = new Db();
$data_update = array();
$chckArr = $db->runQuery("select * from " . PROPERTY . " where propertycode = '" . trim($dataForm['ppty_no']) . "' and status = '3'");
if (count($chckArr) > 0 && $chckArr != "") {
$data_update['guest_name'] = $dataForm['full_name'];
$data_update['location'] = $dataForm['location'];
$check_in = explode("/", $dataForm['check_in']);
$data_update['check_in'] = date('Y-m-d', strtotime($check_in[2] . "-" . $check_in[1] . "-" . $check_in[0]));
$data_update['rating'] = $dataForm['rating'];
$data_update['user_id'] = $mySession->LoggedUserId;
$data_update['headline'] = $dataForm['headline'];
$data_update['comment'] = $dataForm['comment'];
$data_update['review'] = $dataForm['review'];
$data_update['uType'] = $mySession->LoggedUserType == '1' ? "1" : "0";
$data_update['review_date'] = date("Y-m-d");
$data_update["property_id"] = $chckArr[0]['id'];
$data_update['guest_image'] = $mySession->LoggedUser['image'];
copy(SITE_ROOT . "images/" . $mySession->LoggedUser['image'], SITE_ROOT . "images/profile/" . $mySession->LoggedUser['image']);
$db->save(OWNER_REVIEW, $data_update);
$review_id = $db->lastInsertId();
//====== code to enter new latest review properties ===============
//two cases are there
//1. if already an entry is there within latest reviews
//2. first entry is made for specific property
$reviewPptyArr = $db->runQuery("select * from " . LATEST_REVIEW . " where r_property_id = '" . $chckArr[0]['id'] . "' ");
//case 1
if (count($reviewPptyArr) > 0 && $reviewPptyArr != "") {
$db->delete(LATEST_REVIEW, "r_id = " . $reviewPptyArr[0]['r_id']);
$updateData = array();
$updateData['r_order'] = new Zend_Db_Expr('r_order-1');
$db->modify(LATEST_REVIEW, $updateData, "r_order > " . $reviewPptyArr[0]['r_order']);
} else {
$updateData = array();
$updateData['r_order'] = new Zend_Db_Expr('r_order+1');
$db->modify(LATEST_REVIEW, $updateData);
$saveData = array();
$saveData['r_property_id'] = $chckArr[0]['id'];
$saveData['r_order'] = '1';
//$saveData['r_review_id'] = $review_id;
$saveData['r_status'] = '1';
$db->save(LATEST_REVIEW, $saveData);
}
//-----------------------------------------------------------------
return 1;
} else {
return 0;
}
}
public function deleteSpeccat($cId)
{
global $mySession;
$db = new Db();
//check if the child entry is there
$chkQuery = $db->runQuery("select * from " . SPECIFICATION . " where cat_id = '" . $cId . "' ");
if ($chkQuery != "" && count($chkQuery) > 0) {
return 0;
} else {
$condition1 = "cat_id='" . $cId . "'";
$db->delete(PROPERTY_SPEC_CAT, $condition1);
return 1;
}
}
public function deletemsgsAction()
{
global $mySession;
$db = new Db();
if ($_REQUEST['Id'] != "") {
$arrId = explode("|", $_REQUEST['Id']);
if (count($arrId) > 0) {
foreach ($arrId as $key => $Id) {
$condition1 = "message_id='" . $Id . "'";
$db->delete(MESSAGES, $condition1);
}
}
}
exit;
}
public function deletecommentAction()
{
global $mySession;
$db = new Db();
if ($_REQUEST['Id'] != "") {
$arrId = explode("|", $_REQUEST['Id']);
if (count($arrId) > 0) {
foreach ($arrId as $key => $Id) {
$condition1 = "comment_id='" . $Id . "'";
$db->delete(POST_COMMENT, $condition1);
}
}
}
exit;
}
public function delete()
{
$id = $_POST['id'];
if (is_numeric($id)) {
$Db = new Db();
$query = $Db->query('user', array(array('id', '=', $id, '')));
$numrows = mysqli_num_rows($query);
if ($numrows != 1) {
$_SESSION['alert'] = 'Error, please try again.';
} else {
$delete = $Db->delete('user', array(array('id', '=', $id, '')));
if (!$delete) {
$_SESSION['alert'] = 'User account could not be deleted.';
} else {
$_SESSION['alert'] = 'User deleted.';
}
}
}
}
public function unassignAllConntectedDataTableRows($row_id, $connection_id)
{
$connected_data_table = $this->getConnectedDataTableById($connection_id);
if ($connected_data_table !== false) {
$row_id = intval($row_id);
$res = Db::delete($connected_data_table['dbTable'], "`" . $connected_data_table['dbKeySelf'] . "` = :rowId", array(':rowId' => $row_id));
return $res !== false;
}
return false;
}
public function drop($param)
{
$where = $this->getCondition($param);
return Db::delete(self::TABLE_NAME, $where);
}
public function dropInform($param)
{
$where = $this->getCondition($param);
return Db::delete('inform', $where);
}
/**
* 页面导航
*/
public function navigationOp()
{
$lang = Language::getLangContent();
$model_navigation = Model('navigation');
/**
* 删除
*/
if (chksubmit()) {
if (is_array($_POST['del_id']) && !empty($_POST['del_id'])) {
$del_str = implode(',', $_POST['del_id']);
$where = "where nav_id in (" . $del_str . ")";
Db::delete("navigation", $where);
dkcache('nav');
$this->log(L('navigation_index_del_succ') . '[ID:' . $del_str . ']', null);
showMessage($lang['navigation_index_del_succ']);
} else {
showMessage($lang['navigation_index_choose_del']);
}
}
/**
* 检索条件
*/
$condition['like_nav_title'] = trim($_GET['search_nav_title']);
$condition['nav_location'] = trim($_GET['search_nav_location']);
$condition['order'] = 'nav_sort asc';
/**
* 分页
*/
$page = new Page();
$page->setEachNum(10);
$page->setStyle('admin');
$navigation_list = $model_navigation->getNavigationList($condition, $page);
/**
* 整理内容
*/
if (is_array($navigation_list)) {
foreach ($navigation_list as $k => $v) {
switch ($v['nav_location']) {
case '0':
$navigation_list[$k]['nav_location'] = $lang['navigation_index_top'];
break;
case '1':
$navigation_list[$k]['nav_location'] = $lang['navigation_index_center'];
break;
case '2':
$navigation_list[$k]['nav_location'] = $lang['navigation_index_bottom'];
break;
}
switch ($v['nav_new_open']) {
case '0':
$navigation_list[$k]['nav_new_open'] = $lang['nc_no'];
break;
case '1':
$navigation_list[$k]['nav_new_open'] = $lang['nc_yes'];
break;
}
}
}
Tpl::output('navigation_list', $navigation_list);
Tpl::output('page', $page->show());
Tpl::output('search_nav_title', trim($_GET['search_nav_title']));
Tpl::output('search_nav_location', trim($_GET['search_nav_location']));
Tpl::showpage('navigation.index');
}
/**
* 删除分享商品
*/
public function delSharestore($condition)
{
if (empty($condition)) {
return false;
}
$condition_str = '';
if ($condition['share_id'] != '') {
$condition_str .= " and share_id='{$condition['share_id']}' ";
}
if ($condition['share_memberid'] != '') {
$condition_str .= " and share_memberid='{$condition['share_memberid']}' ";
}
return Db::delete('sns_sharestore', $condition_str);
}
function delete()
{
if ($_ENV['sessionUseDb']) {
$data = Db::delete($_ENV['sessionDbTable'], array('id' => $_COOKIE['sessionId']));
} else {
$data = unlink($this->file);
}
}