5 disks should be enough for everybody?

category: general [glöplog]
just thinking of adding more download links on prods for additional disks. already added 1 more even but i started wondering that ppl would ask for a third and then a forth couz i remember prods that use them..

and no, url for video is not included on that math, thats a diferent link, and is already added, just not visible anywhere couz only gloperators can edit the prods to add that link, but dump the url to the videos on the bbs threads and we'll update them...

i just want to know how many disks download urls are enough.. does 5 sound more then enough? (only the ones in use will be shown anyways..)

can only remember that amiga demo (odyssey?) using 5 disks.. is anything else bigger? (on c64 or speccy maybe...?) anyone knows?
added on the 2004-09-13 08:52:30 by psenough psenough
download all disks, pack them together and upload them to scene.org (not you, ps, but the one adding the stuff).
added on the 2004-09-13 08:58:50 by unlock unlock
for amiga that's quite doable but for c64 and speccy?.. well, you _could_ just zip everything into 1 file but... would rather keep the original filenames and release integrity then to repack stuff.. imho..
added on the 2004-09-13 09:03:06 by psenough psenough
that's an argument i do accept ;-) what about doing it dynamically? like let the user select how many disks and then display that many links/input fields?
added on the 2004-09-13 09:06:25 by unlock unlock
i suspect that the pouet.net database design is somewhat fucked up by now :) No BNF for you my friend!
Normalization is for wankers.

Variable number of disks does however seem like the least ugly solution.

SELECT * FROM downloadLinks WHERE demoID=which

...or something?
added on the 2004-09-13 09:17:57 by gammawave gammawave
i doubt that many people care about the aesthetics of the upload form.
added on the 2004-09-13 11:19:04 by psonice psonice
so 5 is enough then? :P
added on the 2004-09-13 17:48:58 by psenough psenough
added on the 2004-09-13 18:40:28 by troll troll
5 is the right number for sure
We don't know that.. but probably. In any case, I realize that it would be a pain in the ass to support an arbitrary number of download links per prod... so yes, five should be enough.

Great work btw, ps!
added on the 2004-09-13 18:42:57 by gammawave gammawave
well, it wouldnt be hard to do, just create one more table and change a few forms but im lazy so i go for the restrictive hack way instead :)
added on the 2004-09-13 19:35:01 by psenough psenough
5 dicks should be enough for everybody.
added on the 2004-09-13 20:34:54 by Bagpuss Bagpuss
Ive never had a demo that spanned more than 4 disks, so 5 should be nuff..

How about a possibility to sort the results of a group search after a date which states which prod was last commented on.. Sometimes I wonder if some old prod of ours has got a new comment and going through all 45 prods kind of sucks :)
added on the 2004-09-13 21:04:08 by loaderror loaderror
As far as I'm aware First Association is the only Speccy demo that even stretches to a second disk. (Of course, all real Spectrum sceners use infinitely long tapes.) Anyhow, 99% of Speccy downloads on Pouet are leeched from my website, and I have no such reservations about repacking demos that are released in stupid formats, so don't expect to see any multiple-zipfile Speccy demos here any time soon :-)

By the way, zxdemo.org uses a separate table for downloads, and it's a right pain in the arse when you want to want to do the listing pages in a single query with a LIMIT 50, but can't because you've got a join that fucks up the numbering.
added on the 2004-09-13 21:53:58 by gasman gasman
loaderror: was thinking of adding "lastcomment on" column on groups?which=xx .. its starting to get abit heavy of a page though...

gasman: i've seen several speccy diskmags take 2 disls.. btw, can i do for zxdemo.org / speccy stuff on pouet something similar to what i've done with csdb / c64 ? would allow ppl to go to zxdemo.org counterpart of the scener/group/prod/event faster..
not sure if you want all the traffic and pouet trolls snooping around your site though which is why im asking before implementing..
added on the 2004-09-14 06:50:08 by psenough psenough
guess i shouldnt mention the amiga music collection dance diverse 2/suburban base which is 13 disks, plus one with a fix ;)
added on the 2004-09-14 08:13:40 by hollowman hollowman
hollowman: yes you shouldnt :P
added on the 2004-09-14 19:26:48 by psenough psenough
ps: sure thing, go ahead! Maybe I'll even get round to adding more info fields some day, so there's a bit more to look at beyond what people already see on pouet...
added on the 2004-09-14 20:32:27 by gasman gasman
cool, i'll update some .php's tomorow or something.
added on the 2004-09-14 21:59:23 by psenough psenough
ps, wouldn't you also have to move all existing download links from the prod table to the download link table, and instead add references to the latter to those prods so that they aren't fetched any differently than newly added ones? That was the pain in the ass I was referring to :)
added on the 2004-09-14 23:05:53 by gammawave gammawave
The databasedesign of pouet is simply amazing >D
added on the 2004-09-14 23:42:31 by Hatikvah Hatikvah
it works, its not slow as fuck, im happy.

if any scener mastered in database code wishes to help me out optimizing the thing, he's welcome to take a look at the thing like moT did a couple months ago.

btw, zxdemo id things implemented now.
and so are the 5 downloads thing.
added on the 2004-09-14 23:51:09 by psenough psenough
ps: 2 is enough imho, there were SO FEW demos that required more than 2 disks on Atari and Amiga for instance.

For the others, one can still post the url in the comments when needed.
added on the 2004-09-15 00:09:35 by keops keops
too late, already added 5. you dont _have_ to use them. ;)
added on the 2004-09-15 00:26:51 by psenough psenough