Jau padariau dabar nepagaunu kampo kita beda kai submeniu keiiu veitomis blogai gaunasi keiciasi ne tie kurie reikai kame esme va kodas.
<?php
class muve{
function __construct(){
$this->db = Database::obtain();
}
function up($id){
$tbl_name = "menu";
$row_min = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= ('$id' -1)");
$row_ = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= '$id'");
$data = array();
$data['name'] = $row_min['name'];
$data['listorder'] = $row_min['listorder'];
$this->db->update($tbl_name, $data, "`id`='{$row_['id']}'");
$data = array();
$data['name'] = $row_['name'];
$data['listorder'] = $row_['listorder'];
$this->db->update($tbl_name, $data, "`id`='{$row_min['id']}'");
}
function down($id){
$tbl_name = "menu";
$row_min = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= ('$id' +1)");
$row_ = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= '$id'");
$data = array();
$data['name'] = $row_min['name'];
$data['listorder'] = $row_min['listorder'];
$this->db->update($tbl_name, $data, "`id`='{$row_['id']}'");
$data = array();
$data['name'] = $row_['name'];
$data['listorder'] = $row_['listorder'];
$this->db->update($tbl_name, $data, "`id`='{$row_min['id']}'");
}
function ups($uid, $id){
$tbl_name = "submenu";
$row_min = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= ('$id'-1) AND `uid`='$uid'");
$row_ = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= '$id' AND `uid`='$uid'");
$data = array();
$data['uid'] = $row_min['uid'];
$data['name'] = $row_min['name'];
$this->db->update($tbl_name, $data, "`id`='{$row_['id']}'");
$data = array();
$data['uid'] = $row_['uid'];
$data['name'] = $row_['name'];
$this->db->update($tbl_name, $data, "`id`='{$row_min['id']}'");
}
function downs($uid, $id){
$tbl_name = "submenu";
$row_min = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= ('$id' +1)AND `uid`='$uid'");
$row_ = $this->db->query_first("SELECT * FROM `$tbl_name` WHERE `id`= '$id' AND `uid`='$uid'");
$data = array();
$data['uid'] = $row_min['uid'];
$data['name'] = $row_min['name'];
$this->db->update($tbl_name, $data, "`id`='{$row_['id']}'");
$data = array();
$data['uid'] = $row_['uid'];
$data['name'] = $row_['name'];
$this->db->update($tbl_name, $data, "`id`='{$row_min['id']}'");
}
}
?>