Databases
StackOverflow2013
Postsdbo
POLimiting Parallel/Simultaneous Downloads - How to know if download was cancelled?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLimiting Parallel/Simultaneous Downloads - How to know if download was cancelled?
    primarykey
    data
    text
    <p>I have a simple file upload service, written out in PHP, which also includes a script that controls download speeds by sending limited-sized packets when a user requests a download from this site.</p> <p>I want to implement a system to limit parallel/simultaneous downloads to 1 per user if they are not premium members. In the download script above, I can use a MySQL database to store a record that has: (1) the user ID; (2) the file ID; (3) when the download was initiated; and (4) when the last packet was sent, which is updated each time this is done (if DL speed is limited to 150 kB/sec, then after every 150 kB, this record is updated, etc.).</p> <p>However, thus far, the database record will only be deleted once the download has successfully completed — at the end of the script, after the download has been fully served, the record is deleted from the table:</p> <pre><code>insert DB record; while (download is being served) { serve packet of data; update DB record with current date/time; } // Download is now complete delete DB record; </code></pre> <p>How will I be able to detect when a download has been cancelled? Would I just have to have a Cron job (or something similar) detect if an existing download record is more than X minutes/hours old? Or is there something else I can do that I'm missing?</p> <p>I hope I've explained this well enough. I don't think posting specific code is required; I'm interested more in the logistics of how/whether this can be done. If specific is needed, I will gladly provide it.</p> <p>NOTE: I know how to detect if a file was successfully downloaded; I need to know how to detect if it was cancelled, aborted, or otherwise stopped (and not just paused). <strong>This will be useful in stopping parallel downloads, as well as preventing a situation where the user cancels Download #1 and tries to initiate Download #2, only to find that the site claims he is still downloading file #1.</strong></p> <p>EDIT: You can find my download script here: <a href="http://codetidy.com/1319/" rel="nofollow">http://codetidy.com/1319/</a> — it already supports multi-part downloads and download resuming.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USTshepang
    1. USTerranRich
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLimiting Parallel/Simultaneous Downloads - How to know if download was cancelled?
      1. USDani
      1. VTFavorite
    2. VO
      singulars
      1. POLimiting Parallel/Simultaneous Downloads - How to know if download was cancelled?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POLimiting Parallel/Simultaneous Downloads - How to know if download was cancelled?
      1. USMrWhite
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload