SoundCloud Downloader - Pengunduhan kode sumber SoundCloud Downloader

SoundCloud Downloader

Kode sumber lainnya

v1.0.10

Unduh

Pengunduh SoundCloud

Aplikasi android untuk mengunduh trek/daftar putar dari SoundCloud.

Pada tanggal 31 Agustus 2018

 7200+ users, 1,38,000+ tracks downloaded

Demo

Unduh

Anda dapat mengunduh APK stabil terbaru dari sini

TODO

Tidak ada untuk saat ini.
Algoritma berjalan melalui.

Bagian yang menyedihkan :(

2 kali disuspend dan 1 kali ditolak dari Google PlayStore.

Pertanyaan Statistik

Pemasangan per tanggal

 SELECT
  DATE ( u . created_at ) AS date ,
  COUNT ( u . id ) AS total_users_joined
FROM
  users u
GROUP BY
  DATE ( u . created_at )
ORDER BY
  date DESC ;

Statistik pengguna

 SELECT
  u . id ,
  u . name ,
  u . email ,
  u . imei ,
  COUNT (DISTINCT r . id ) AS total_requests,
  COUNT (DISTINCT dr . id ) AS total_downloads,
  COUNT (DISTINCT t . id ) AS total_tracks,
  u . is_active ,
  (
  SELECT
    soundcloud_url
  FROM
    requests
  WHERE
    user_id = u . id
  ORDER BY
    id DESC
  LIMIT 1
) AS last_hit
FROM
  users u
LEFT JOIN
  requests r ON r . user_id = u . id
LEFT JOIN
  download_requests dr ON dr . request_id = r . id
LEFT JOIN
  tracks t ON t . request_id = r . id
GROUP BY
  u . id
ORDER BY
  total_requests DESC ;