GMWeb/www/app/notifications.php

<?php
	include("../functions.php");
	$con = startdb();
		
	//Get user entry
	// 1=0 Old API is now disabled
	$q = mysqli_query($con, "SELECT id, action, title_es, title_en, title_eu, text_es, text_en, text_eu FROM notification WHERE 1 = 0 AND dtime > NOW() - INTERVAL duration MINUTE ORDER BY dtime DESC ;");
	while ($r = mysqli_fetch_array($q)){
		echo("<notification>\n");
		echo("\t<id>$r[id]</id>\n");
		echo("\t<action>$r[action]</action>\n");
		echo("\t<title_es>$r[title_es]</title_es>\n");
		echo("\t<title_en>$r[title_en]</title_en>\n");
		echo("\t<title_eu>$r[title_eu]</title_eu>\n");
		echo("\t<text_es>$r[text_es]</text_es>\n");
		echo("\t<text_en>$r[text_en]</text_en>\n");
		echo("\t<text_eu>$r[text_eu]</text_eu>\n");
		echo("</notification>\n");
	}
?>