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); }