CHOOSE THE APP:";
$no_result = "
NO RESULTS
";
$url = "http://apps.id-ict.eu/en/training-content/support-information/";
$name_button = "New search apps";
}else if ($lang == "es"){
$title = "Elige una aplicación:
"; $no_result = "No se han obtenido resultado
";
$url = "http://apps.id-ict.eu/es/contenido-formativo/informacion-de-soporte/";
$name_button = "Nueva búsqueda";
}else if ($lang == "sl"){
$title = "Izberi program/aplikacijo:
"; $no_result = "Ni zadetkov
";
$url = "http://apps.id-ict.eu/sl/uvod/podpora-informacije/";
$name_button = "Novo iskanje programa/aplikacije";
}else if ($lang == "hr"){
$title = "Odaberi aplikaciju:
"; $no_result = "Nema rezultata
";
$url = "http://apps.id-ict.eu/hr/uvod-2/informativna-podrska/";
$name_button = "Pretraži novu aplikaciju";
}else if ($lang == "it"){
$title = "Scegli un'app:
"; $no_result = "Nessun risultato trovato
";
$url = "http://apps.id-ict.eu/it/introduzione/informazioni-di-supporto/";
$name_button = "Nuova ricerca";
}else if ($lang == "pt"){
$title = "Escolher uma app:
"; $no_result = "Nenhum resultado encontrado
";
$url = "http://apps.id-ict.eu/pt/introducao/informacao-de-apoio/";
$name_button = "Nova pesquisa";
}else if ($lang == "de"){
$title = "Wählen Sie die beste App aus:
"; $no_result = "Keine Ergebnisse
";
$url = "http://apps.id-ict.eu/de/einfuhrung/unterstutzende-informationen/";
$name_button = "Neue App-Suche";
}
if (count($_POST["support-adequate-".$lang.""]) > 0 || count($_POST["support-used-".$lang.""]) > 0 || count($_SESSION["support-adequate-".$lang.""]) > 0 || count($_SESSION["support-used-".$lang.""]) > 0) {
if (count($_POST["support-adequate-".$lang.""]) > 0) {
$_SESSION["support-adequate-".$lang.""] = $_POST["support-adequate-".$lang.""];
}
if (count($_POST["support-used-".$lang.""]) > 0) {
$_SESSION["support-used-".$lang.""] = $_POST["support-used-".$lang.""];
}
if (isset($_POST["support-adequate-".$lang.""])) {
$rows = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.ID, $wpdb->posts.post_title
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_value LIKE '%".$_SESSION["support-adequate-".$lang.""]."%'
AND $wpdb->postmeta.meta_key = 'support-adequate-".$lang."'
GROUP BY $wpdb->posts.post_title
ORDER BY $wpdb->posts.post_title ASC");
}else if (isset($_POST["support-used-".$lang.""])) {
$rows = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.ID, $wpdb->posts.post_title
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE $wpdb->posts.post_status = 'publish'
AND $wpdb->postmeta.meta_value LIKE '%".$_SESSION["support-used-".$lang.""]."%'
AND $wpdb->postmeta.meta_key = 'support-used-".$lang."'
GROUP BY $wpdb->posts.post_title
ORDER BY $wpdb->posts.post_title ASC");
}else{
$rows = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.ID, $wpdb->posts.post_title
FROM $wpdb->posts
LEFT JOIN $wpdb->postmeta ON($wpdb->posts.ID = $wpdb->postmeta.post_id)
WHERE $wpdb->posts.post_status = 'publish'
AND ($wpdb->postmeta.meta_key = 'support-used-".$lang."' OR $wpdb->postmeta.meta_key = 'support-used-".$lang."')
GROUP BY $wpdb->posts.post_title
ORDER BY $wpdb->posts.post_title ASC");
}
// loop through the results
if( $rows )
{
echo $title;
foreach( $rows as $row )
{
// load image src
// - https://www.advancedcustomfields.com/resources/field-types/image/
$src = wp_get_attachment_image_src( get_post_thumbnail_id($row->ID), 'full'); //medium
?>
';
?>