public
|
mixed
|
add (
$data )
Исходный код метода:
$this->db->query("INSERT INTO `" . DB_PREFIX . "ebay_template` SET `name` = '".$this->db->escape($data['name'])."', `html` = '".$this->db->escape($data['html'])."'");
return $this->db->getLastId();
|
public
|
mixed
|
edit (
$id, $data )
Исходный код метода:
$this->db->query("UPDATE `" . DB_PREFIX . "ebay_template` SET `name` = '".$this->db->escape($data['name'])."', `html` = '".$this->db->escape($data['html'])."' WHERE `template_id` = '".(int)$id."' LIMIT 1");
|
public
|
mixed
|
delete (
$id )
Исходный код метода:
$qry = $this->db->query("DELETE FROM `" . DB_PREFIX . "ebay_template` WHERE `template_id` = '".(int)$id."' LIMIT 1");
if($qry->countAffected > 0){
return true;
}else{
return false;
}
|
public
|
mixed
|
get (
$id )
Исходный код метода:
$qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "ebay_template` WHERE `template_id` = '".(int)$id."' LIMIT 1");
if($qry->num_rows){
$row = $qry->row;
$row['link_edit'] = HTTPS_SERVER . 'index.php?route=openbay/ebay_template/edit&token=' . $this->session->data['token'].'&template_id='.$row['template_id'];
$row['link_delete'] = HTTPS_SERVER . 'index.php?route=openbay/ebay_template/delete&token=' . $this->session->data['token'].'&template_id='.$row['template_id'];
return $row;
}else{
return false;
}
|
public
|
mixed
|
getAll (
)
Исходный код метода:
$qry = $this->db->query("SELECT * FROM `" . DB_PREFIX . "ebay_template`");
$templates = array();
if($qry->num_rows){
foreach($qry->rows as $row){
$row['link_edit'] = HTTPS_SERVER . 'index.php?route=openbay/ebay_template/edit&token=' . $this->session->data['token'].'&template_id='.$row['template_id'];
$row['link_delete'] = HTTPS_SERVER . 'index.php?route=openbay/ebay_template/delete&token=' . $this->session->data['token'].'&template_id='.$row['template_id'];
$templates[] = $row;
}
}
return $templates;
|