';
$db = new SQLite3('./.db.db');
$sortcheck = $db->querySingle("SELECT sort FROM users");
if ($sortcheck == "true"){
$blah = $db->query("SELECT * FROM store ORDER BY name ASC");
$i = 1;
$blippity = array();
while($blahblah = $blah->fetchArray(SQLITE3_ASSOC)){
$added_date = $blahblah['added_date'];
$icon = $blahblah['icon'];
$name = $blahblah['name'];
$url = str_replace(" ", "%20", $blahblah['url']);
$base64 = $blahblah['base64'];
$version = $blahblah['version'];
$version_code = $blahblah['version_code'];
$vidz = $blahblah['vidz'];
$app_id = $i;
$i++;
if(!empty($url))
{if($icon == ""){$icon = strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,strpos( $_SERVER["SERVER_PROTOCOL"],'/'))).'://'.$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF'], 2) . '/img/1x1.png';}
if($version == ""){$version = "Uncategorized";}
$output.='
-
'.$app_id.'
'.$version.'
'.$name.'
'.$url.'
'.$icon.'
'.$version_code.'
'.$vidz.'
'.$base64.'
';
}
}
$x = substr($output, -1);
if($x == ",")
{
$output=substr_replace($output,"",-1);
}
$output.='';
echo $output;
}else{
$res = $db->query("SELECT * FROM store");
while ($row = $res->fetchArray()) {
$added_date = $row['added_date'];
$icon = $row['icon'];
$app_id = $row['id'];
$name = $row['name'];
$url = str_replace(" ", "%20", $row['url']);
$base64 = $row['base64'];
$vidz = $row['vidz'];
$version = $row['version'];
$version_code = $row['version_code'];
if(!empty($url))
{if($icon == ""){$icon = strtolower(substr($_SERVER["SERVER_PROTOCOL"],0,strpos( $_SERVER["SERVER_PROTOCOL"],'/'))).'://'.$_SERVER['HTTP_HOST'].dirname($_SERVER['PHP_SELF'], 2) . '/img/1x1.png';}
if($version == ""){$version = "Uncategorized";}
$output.='
-
'.$app_id.'
'.$version.'
'.$name.'
'.$url.'
'.$icon.'
'.$version_code.'
'.$vidz.'
'.$base64.'
';
}
}
$x = substr($output, -1);
if($x == ",")
{
$output=substr_replace($output,"",-1);
}
$output.='';
echo $output;
}
?>