Notings of Attention™
Acmlmboard 2 Released
Github/GIT | @acmlmboard
Chatting Places
Discord

Affiliates
Super Mario Bros. X | Kuribo64
Views: 8,952,098
Main | FAQ | IRC chat | Memberlist | Active users | Latest posts | Stats | Ranks | Online users | Search
03-28-24 08:24 AM
Guest: Register | Login

Main - Posts by Kawa

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122

Kawa
Posted on 02-03-12 04:15 PM, in ABΔ, or Delta, an OOP messageboard attempt Link | ID: 5033
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 401/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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.


Kawa
Posted on 02-03-12 05:18 PM, in How's the weather today? Link | ID: 5039
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 404/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
It's snowing. I don't like it.


Kawa
Posted on 02-03-12 05:39 PM, in Kafuka's CitiHall: "Scattered before you there are three tomes.." Link | ID: 5041
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 405/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
On a totally different note, does the current thread title refer to what I think it refers to?


Kawa
Posted on 02-03-12 05:43 PM, in what did you catch so far? Link | ID: 5042
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 406/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
Just grabbed a Red Shell, holding out for Hitler now.

That sounds bad ^_^


Kawa
Posted on 02-03-12 05:45 PM, in Simulation genre games Link | ID: 5043
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 407/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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.


Kawa
Posted on 02-03-12 05:49 PM, in SNES9x to possibly get MSU1 support? Link | ID: 5044
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 408/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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 :D
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.



Kawa
Posted on 02-03-12 06:01 PM, in What'd you eat? Link | ID: 5048
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 409/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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 :(


Kawa
Posted on 02-03-12 06:05 PM, in Say something nice about the person who post before you! Link | ID: 5049
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 410/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
Oh don't make me laugh.

@Emuz has a good sense of justice.


Kawa
Posted on 02-03-12 06:09 PM, in Noxico -- writers needed Link | ID: 5050
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 411/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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.


Kawa
Posted on 02-03-12 06:34 PM, in Ask the resident blunt douche bag Link | ID: 5052
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 412/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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.


Kawa
Posted on 02-03-12 06:38 PM, in How's the weather today? Link | ID: 5054
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 413/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
I don't think the weather's quite that... personally involved, actually.


Kawa
Posted on 02-03-12 07:11 PM, in what did you catch so far? Link | ID: 5062
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 414/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
I think I saw a Robocop in there, but no Ed. And yes, AFAIK he's not in the rotation either.


Kawa
Posted on 02-03-12 07:13 PM, in Ask the resident blunt douche bag Link | ID: 5063
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 415/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
If you were a FiM pony, what would you look like?


Kawa
Posted on 02-03-12 07:13 PM, in the thread has farted Link | ID: 5064
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 416/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
Bob-ombs in the toilet? Are you sure that's wise?


Kawa
Posted on 02-03-12 07:15 PM, in @ linking shouldn't apply inside [code] tags Link | ID: 5065
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 417/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
See, this is why I prefer tags that are bounded on both sides. And less confusable with half an email addy.


Kawa
Posted on 02-03-12 07:46 PM, in Ask the resident blunt douche bag Link | ID: 5070
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 418/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
So, a bit like this, perhaps?


Kawa
Posted on 02-03-12 07:48 PM, in the thread has farted Link | ID: 5071
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 419/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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?


Kawa
Posted on 02-03-12 07:50 PM, in the thread has farted Link | ID: 5073
Retired Staff

Not okay
Prophet of Celestia
Level: 93


Posts: 420/2423
EXP: 7973646
Next: 79164

Since: 01-01-12
From: The Netherlands

Last post: 1999 days
Last view: 314 days
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.

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122


Main - Posts by Kawa


Acmlmboard v2.5.5 (10/04/2020)
© 2005-2024 Acmlm, Emuz, et al.

Page rendered in 0.106 seconds. (838KB of memory used)
MySQL - queries: 189, rows: 511/545, time: 0.082 seconds.