citywebshop_cms/exportdata.php

<?php

error_reporting(E_ERROR);

define('DB_ENGINE','mysql');
define('DB_HOST','localhost');
define('DB_PORT',3306);
define('DB_USER','openws');
define('DB_PW','5jqPQEPGUihnY5XM6oPR');
define('DB_DBNAME','openws');

const API = 'https://szollosil.bbus.smbinfo.hu/api/index.php';
const API_KEY = 'HwHoW92ywx6w2L5h4lV2QHZpOr3q84AM';

function getHotelIdByHash($hash, $options) {
  foreach ($options as $option) {
    if ($option['value'] == $hash) {
      return str_replace('hotel_','',$option['key']);
    }
  }
  return null;
}

$curl = curl_init();

$url = API.'/affiliateapi/getAllHotels';
if ($onlyHotels) {
  $url .= '?onlyhotels=true';
}

curl_setopt_array($curl, array(
  CURLOPT_URL => $url,
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
  CURLOPT_HTTPHEADER => array(
    'DOLAPIKEY: '.API_KEY
  ),
));
$response = curl_exec($curl);
curl_close($curl);
$groups = [];
$response = json_decode($response, true);
foreach ($response as $key => $value) {
  $options[] = array('key' => $key, 'value' => $value);
}

$conn = new mysqli(DB_HOST,DB_USER,DB_PW,DB_DBNAME);
$conn->query("SET NAMES utf8");

$csv = fopen('hotels.csv','r');
$index = [];
while (($data = fgetcsv($csv, 0, ";")) !== FALSE) {
    if ($data[1] && $data[1] != '') {
        $hash = $data[1];
        $hotelID = getHotelIdByHash($data[0], $options);
        $index[$hash][] = $hotelID ? $hotelID : $data[0];
    }
}

foreach ($index as $hash => $hotelIDs) {
    $hotels = $conn->real_escape_string(serialize($hotelIDs));
    $conn->query("UPDATE azonics_admin_users SET admin_dashboard='".$hotels."' WHERE admin_id='".$hash."';");
}