|
||||||
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 |
Kawa |
| ||
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:
Final assembled query:
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 |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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 Posted by BearOso |
Kawa |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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-KirbyHow does that even work? At least, for you. |
Kawa |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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 |
| ||
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 |
Kawa |
| ||
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 GreyMariaHoly crap what? |
Kawa |
| ||
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. |
Main - Posts by Kawa |
Acmlmboard v2.5.5 (10/04/2020) © 2005-2024 Acmlm, Emuz, et al. |
MySQL - queries: 189, rows: 511/545, time: 0.082 seconds. |