public function getPosition($params){
$query = sprintf("SELECT * FROM `positions` WHERE `id`='%s'",
mysql_real_escape_string($params['id'])
);
return parent::queryOne($res);
}
public function getSelectedEvent($params){
$query = sprintf("SELECT * FROM `events` WHERE `id`='%s'",
mysql_real_escape_string($params['id'])
);
return parent::queryOne($query);
}
public function setVisible($params){
$query = sprintf("SELECT * FROM `destinations` WHERE `id`='%s'",
mysql_real_escape_string($params['id'])
);
$row = parent::queryOne($query);
//Change visible status
$query = sprintf("UPDATE `destinations` SET `visible`='%s' WHERE `id`='%s'",
mysql_real_escape_string(1 - $row['visible']),
mysql_real_escape_string($params['id'])
);
parent::run($query);
return true;
}
public function getAdditionalInfo($params, $tbl, $col){
if($tbl == 'accomodation_types'){
$query = sprintf("SELECT `accomodation_types`.`%s` AS `info` FROM `accomodation_types` WHERE `link_name`='%s'",
mysql_real_escape_string($col),
mysql_real_escape_string($params['name'])
);
return parent::queryOne($query);
}elseif($tbl == 'accomodations'){
$query = sprintf("SELECT `accomodations`.`%s` AS `info` FROM `accomodations`
WHERE `accomodations`.`link_name`='%s'",
mysql_real_escape_string($col),
mysql_real_escape_string($params['name'])
);
return parent::queryOne($query);
}
}
public function getConditions(){
$query = sprintf("SELECT * FROM `conditions` ORDER BY `modif` DESC");
return parent::queryOne($query);
}
public function getOldFileName($params){
$query = sprintf("SELECT * FROM `accomodation_images` WHERE `id`='%s'",
mysql_real_escape_string($params['img_id'])
);
return parent::queryOne($query);
}
public function getCarousel($params){
$query = sprintf("SELECT * FROM `carousel` WHERE `id`='%s'",
mysql_real_escape_string($params['id'])
);
return parent::queryOne($query);
}
public function getOldFileName($id){
$query = sprintf("SELECT * FROM `rent_a_car` WHERE `id`='%s'",
mysql_real_escape_string($id)
);
return parent::queryOne($query);
}
public function getOldFileNameSecond($id){
$query = sprintf("SELECT * FROM `accomodation_type_images` WHERE `id`='%s'",
mysql_real_escape_string($id)
);
return parent::queryOne($query);
}
