Post revisions

The post_text table right now:
parent_post
message
revision
where revision is coupled to posts.last_revision

Suggested format:
id
parent_post
message
and remove posts.last_revision.

WHAT?

Grab the most recent revision for a post (say, #42) by subquery: ORDER BY id DESC LIMIT 0, 1
Grab revision N for the same like this: ORDER BY id ASC LIMIT N-1, 1

So basically grab revisions not by a "revision #" field, but by limit range.

Example:

id parent_post message 66 41 Well, I don't know. 67 42 Your mother sucks cock in Hell! 68 42 Your mother is a classy lady! 69 42 (Mod note: there was an insult here at first) SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id DESC LIMIT 0, 1 --> (Mod note: there was an insult here at first) -- request revision #1 (original), so N = 1 0, 1 SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1 --> Your mother sucks cock in Hell! -- Note the ascending sort order. -- request revision #2 1, 1 SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1 --> Your mother is a classy lady! -- request revision #3 (most recent) 2, 1 SELECT message FROM post_text WHERE parent_post = 42 ORDER BY id ASC LIMIT (N-1), 1 --> (Mod note: there was an insult here at first)

Could probably simplify a little bit if you consider revision 0 to be the original, and not refer to it as a revision at all.

Final assembled query:

SELECT posts.*, (SELECT message FROM post_text WHERE parent_post = posts.id ORDER BY id DESC LIMIT 0, 1) message, (SELECT COUNT(*)-1 FROM post_text WHERE parent_post = post.id) revision FROM posts WHERE whatever

Instead of SELECT * FROM posts LEFT JOIN post_text ON post_text.parent_post = posts.id AND post_text.revision = posts.last_revision.

This is an actual thing, even though there's no "edit post" interface yet.

It's snowing. I don't like it.

On a totally different note, does the current thread title refer to what I think it refers to?

Just grabbed a Red Shell, holding out for Hitler now.

That sounds bad

I've played a bit of The Sims 3, and I do so like simulation games, or non-simulation games with sim aspects more so. In fact, I keep trying to sneak sim aspects into my own designs.

It's more likely than you'd think.

Posted by byuu

---

Side-note: how would you feel about MSU1 support in Snes9X? There's now a full-fledged game for it that's pretty cool:
http://dforce3000.de/
Data portion is child's play, but the audio portion would require a mixer (blend 32KHz SMP+44KHz MSU1 audio to one output stream; about 5KB of code for Hermite. Easy way: 44khz->32khz, queue SMP+MSU1 32khz samples to a buffer, when each buffer has > 1 sample, output (a+b)/2 to sound card.) This mixer would also be required for Super Game Boy support, so it's two birds with one stone. With the audio mixer, MSU1 is about 3KB of code.

Not a big deal or a rush. I certainly like it being a unique feature for me
But being in 9x would allow more people to enjoy it.

---

Posted by BearOso

---

Concerning the MSU1, I've thought about adding it before, but never done anything about it. It might be a fun project to do, especially if there's no heavy timing involved. So it's definitely possible.

---

I had a weenie for dinner. It was nice.

But also very much the only thing I'd have if I hadn't gotten a sandwich afterwards

Oh don't make me laugh.

@Emuz has a good sense of justice.

Added a little something to detect if you're running on a *nix system that should fix the key repeat thing. I've tested it on a VirtualBox'd Arch Linux, and I'm currently waiting for Niko to pop up for a repeat test.

Also, if anybody here has MacOS X, please contact me so I know if I should extend the test to cover that too. Mono on Windows (silly as that is) has no key repeat trouble whatsoever so that's good.

Also also, updated the planfile to have colorcoding for things that are done and such. Among some content changes. Might be interesting.

Posted by Green-Kirby

---

While I have a very dirty mind and such, I have no sexual drive whatsoever.

---

How does that even work? At least, for you.

I don't think the weather's quite that... personally involved, actually.

I think I saw a Robocop in there, but no Ed. And yes, AFAIK he's not in the rotation either.

If you were a FiM pony, what would you look like?

Bob-ombs in the toilet? Are you sure that's wise?

See, this is why I prefer tags that are bounded on both sides. And less confusable with half an email addy.

So, a bit like this, perhaps?

Posted by GreyMaria

---

(Yesterday? I noticed that the rave lights in the disco scene are just a bunch of superimposed Bowser-head-shaped rock formations from Super Mario World.)

---

Holy crap what?

Let's not derail this thread any further, though. Show me in a PM or something, we can start a thread about things you've missed in movies later.