pouët.net

http://pouet.net/prod.php?which=2989
url:
ftp://ftp.scene.org/pub/parties/2000/mekkasymposium00/amiga/in4k/dcs-ao4k.lha

Virtual Dreams is the legal Demodivision of illegal Fairlight, it's not the same group, it's like two groups, it's not a label only
certain members was in VD but not in FL, and vice versa

well no shit, sherlock.

http://www.pouet.net?which=5435
url:
http:/www.icoc.ch/phred/modules/rapunzel_demo.zip

gmbl. forgot a /.. that is then
http://www.icoc.ch/phred/modules/rapunzel_demo.zip

spite: nfo fixed
reed: deathstar split

please delete :
http://www.pouet.net/prod.php?which=3822
because this is a dupe of
http://www.pouet.net/prod.php?which=3820
in fact, full distribution of this diskmag was in 2 floppy disks, and intro of the mag was on the 1st disk and full mag on the 2nd disk
but no need to enter 2 different prods on pouët for this, thanx.

mot: i have no clue about foreign keys but i think so yes. and yes it uses YYYY-MM-DD and yes it parses them into month/year on the php and yes its slow and yes i know and no i wont rewrite it couz it aint my site. i'm more worried about slowness of main page, when i can be bothered to make that load from static sql feed instead of 20 queries then i'll start thinking of the rest.

reed: fixed 3202 and 3057

rest all fixed.
should them all you listed be vd+flt then?

zone: one is for the intro of the mag the other for the mag itself.. why not leave it as 2 dif prods..

ps : imho because other prods can be divided like this, some mags use 1st disk for intro and 2nd disk for full mag. Example Rom issue 3 can be divided too, it will be more hard to divide thousand of prods than glue just one mistake ;)

zone: grah, fine. fixed.

also fixed small persisting bug on oneliner.
atleast its fixed for now.. lets see if it'll fuck up again when the numberoflines gets closer to pageswapping limit again..

ps: Indexes are the things that help speed up queries and eventually the loading of the main page :-) I can help if you want, but I'd have to take a look into the frontpage php code, especially the queries.

A mysqldump would help too, or at least a SHOW CREATE TABLE <table_name> for the most important tables. I am interested in the database structure, not the contents btw.

To give you an idea of what kind of performance gain you get by using indexes, the frontpage of a website at work needed 20 seconds to load. When we put indexes, it only needed 2 seconds :-)

In any case, I am very experienced with PHP/MySQL, willing to help and if you want, you can contact me at mot(at)mediaweb(dot)gr

please rename
http://www.pouet.net/groups.php?which=994
full group name is "Flying Cows Inc."

please rename
http://www.pouet.net/prod.php?which=10775
title is "Pro S.I.A.K."
release date is 10-1993

thanx for your huge work PS ! ;')

please rename :
http://www.pouet.net/prod.php?which=10313
title is "No Brain - No Pain!"

it seems to be a dupe between :
http://www.pouet.net/prod.php?which=1451
url=http://www.pouet.net/prod.php?which=11299

the "coup de coeur" points to the same demo in ages, I think it should be fixed:

http://www.pouet.net

mot I know of at least a country that uses YYYY-MM-DD as it's "human" format. (japan, if you must know)

zone: fixed

stelthz: stfu

stelthz: click on the Random link, you'll get a new "coup de coeur" every time.

poi2: No, in fact I get a boring demo 90% of the time :)

Well, why do you even have a "coup de coeur" when it is never updated?

why not?

stelthz : why did you never update your unuseful comments first? (voting screenshot is so lame, you know what i mean)

I think stelthz is right: If nobody does update that "coup de coeur", why is it still there? Or at least some guys should have access to alter it..?
Wasn't it meant to give special attention to the demos that were good but unappreciated?

In fact, if ps have access to the source code ( even if that's only a portion of it ), technically speaking, he should be able to list the tables of the database and update the appropriate record. The question is : is it up to ps to do everything on pouet.net ? should there be more moderators ?

look, its not just a replace in the index.php, there are sql entries for coup de coeur and a page listing them, and its not up to me to pick the next one, nor up to me to start _testing_ my way into the _right_ way to update it. analogue will update it when analogue will update it. until then watch dope / complex again and again and again couz it rules.

i _could_ do lots of things on pouet. that doesnt mean that i _should_ and it surely wont mean that _i will_ just because _i can_.

if it was up to me alone i would have added donkey hat avatars to shitloads of ppl and deleted shitloads of moronic comments that just annoy me and stuff. im just covering holes and upgrading pages here, im not in charge of the show. :)

ps: :) For sure Dope/complex rulez. And let close the case of the "coup de coeur" and say that pouet.net have a huuuuuge heart.