";
$query = mysqli_query($conx, "SELECT id,app_uqid,snooze,hidden FROM user_apps WHERE uid='$u_uid' ORDER BY arrange");
while ($app = mysqli_fetch_assoc($query)) {
$uapp_id = $app['id'];
$app_uqid = $app['app_uqid'];
$app_snooze = $app['snooze'];
$app_hidden = $app['hidden'];
$appy = mysqli_query($conx, "SELECT uqid,title,app_color,app_titlecolor,link,icon FROM apps WHERE uqid='$app_uqid'");
while($ap = mysqli_fetch_assoc($appy)) {
$app_uqqid = $ap['uqid'];
$app_color = $ap['app_color'];
$app_tcolor = $ap['app_titlecolor'];
$app_name = $ap['title'];
$app_link = $ap['link'];
$app_icon = $ap['icon'];
}
echo "$app_name
";
if($app_snooze == 'yes') {
echo " snoozed";
}
else {
echo " woke";
}
echo " | ";
echo " move up";
echo " | ";
echo " move down";
echo " | ";
if($app_uqid != 'settings') {
if($app_hidden == 'yes') {
echo " hidden";
}
else {
echo " visible";
}
}
else {
echo " visible";
}
echo "
";
echo "tap to launch this app
";
echo "
";
}
?>