empty($this->allCookiesByLanguage[$language])) { $this->allCookiesByLanguage[$language] = []; $cookiesData = $wpdb->get_results( ' SELECT `cookie_id`, `name` FROM `' . $wpdb->prefix . "borlabs_cookie_cookies` WHERE `language` = '" . esc_sql($language) . "' AND `status` = 1 " ); if (!empty($cookiesData)) { foreach ($cookiesData as $cookieData) { $this->allCookiesByLanguage[$language][$cookieData->cookie_id] = $cookieData->name; } } } return $this->allCookiesByLanguage[$language]; } /** * getCookieData function. * * @param mixed $cookieId */ public function getCookieData($cookieId) { global $wpdb; $data = []; $cookieData = $wpdb->get_results( ' SELECT c.`cookie_id`, c.`name`, cg.`group_id`, cg.`name` as `cookie_group` FROM `' . $wpdb->prefix . 'borlabs_cookie_cookies` as c INNER JOIN `' . $wpdb->prefix . "borlabs_cookie_groups` as cg ON ( c.`cookie_id` = '" . esc_sql($cookieId) . "' AND c.`language` = '" . esc_sql(Multilanguage::getInstance()->getCurrentLanguageCode()) . "' AND c.`status` = 1 AND cg.`id` = c.`cookie_group_id` AND cg.`language` = '" . esc_sql(Multilanguage::getInstance()->getCurrentLanguageCode()) . "' ) " ); if (!empty($cookieData[0]->cookie_id)) { $data = $cookieData[0]; } return $data; } }