The weekend in USSM Labs enhancements
DMZ · December 1, 2006 at 8:57 pm · Filed Under Site information
First, on the music, here’s that post:
Corco made us do it. It was either that or Comet Cursor. I’m sorry. Hopefully he relents soon.Update: that was enough of that.
You’ll note this is a particularly frisky weekend for USSM Labs, which usually does its work on weekends.
So far:
-caching up and running
-related posts
-quicktags for comments
- and some other backend stuff
If you see anything you particularly like, please, or if something’s gone wrong, let us know.
Comments
58 Responses to “The weekend in USSM Labs enhancements”
Leave a Reply
You must be logged in to post a comment.
Dammit. I never got to hear the music.
Wow. That didn’t cause a traffic jump at all in my blog or anything. At least you didn’t link to davidjcorcoran.com (the future of the blog in the making). That could have taken down the whole server over there.
I’d just like to say that Corco is the Samuel Pepys of the 21st century.
That’s a bit too much of an honor. I could NEVER write my day with a pen. That would be way too time-consuming.
Am I the only one who’s thoroughly confused here?
Read the end of the last thread.
Good Lord. It’s Friday Night and I’m sitting in front of USSM talkign about Comet Cursor.
College is so strange sometimes. I may get totally hammered one Wednesday night, adn then sit in doing nothing on some Friday night.
We offered arby to Gil Meche? WTF? I know he won’t take it, but still…it’s scary to even leave him with that option.
OK, thanks, Corco — I’d given up on that one about 150 posts in.
As for Meche, no arby, no pick. It had to be done.
The empty related links, btw, are what happens when the related link engine attempts to refer people to a post with no title, like those early in USSM history o’er at blogger. I don’t know how to fix that yet.
That’s easy. Assign titles to every post.
If you give me the keys I’ll do it for free.
(and then take them away, of course)
Yeah, I take that back. That’s more posts than I thought. Good luck.
DMZ, how hard would it be to prevent the same person from posting twice in a row in the same thread?
You know I’d just go get a second username.
and refresh in two browsers at once.
Oh no you wouldn’t.
There are ~1800 posts w/o titles. Essentially everything before 9-3-2004.
I wish there was a way to update each row and even set the title to something that would ID it, like… the date and time, even. I may have to work on that if we decide to keep the related posts function.
We offered arby to Gil Meche? WTF? I know he won’t take it, but still…it’s scary to even leave him with that option.
Is this a technicality that has to be done in order to receive the compensation draft pick?
Also, I think USSM should apply tags to posts.
could you have the script that pulls up links pull up the URL instead? That could work.
19: Yes, and they do.
I wish there was a way to update each row and even set the title to something that would ID it, like… the date and time, even. I may have to work on that if we decide to keep the related posts function.
Do you have those in a database? I’ve never used Blogger, not sure if you can export that.
If you have them in a DB somewhere you could run an SQL query on it, titling empty ones with their date & time, as you mentioned.
DMZ, would you let me write a CorcoBot that submitted all his posts to Eliza and post the output?
w/r/t tags — Tagging’s an interesting problem for us – I’ve been looking at some possibilities to do that. I’m certainly interested in doing some fine tagging work.
on the query — it is all in a database, but I haven’t figured out how to do that yet. I don’t know, I’d want something like
Fun pseudo-SQL!
update postsset title = 'Older post from ' + post_date
where blah blah blah
but I’m not sure how to actually pull that off
24… should be pretty straightforward. Does your host use MySQL or SQL Server?
MySQL. If I wasn’t pretty exhausted from working on all this other stuff, I’d give it a shot. But as it is, I’m going to go chill for a while. Have a beer. Mmm… beer.
Have a beer and then figure it out.
Sometimes I post and then think of something to add, so I’d like people to be able to post twice in a row. More than that I’m less sure
How
about
seven
times
in
a
row?
^
|
+— I call a time out for Corco
Can you make the timeout last for, say, 2 years?
Sorry.
I’m not too familiar with most forms of “direct” SQL-stuff. I work almost exclusively within PHP, but since WordPress does too, it should be a decent match.
Assuming I’m not responsible for any negative effects and you have a this-moment backup.
Of course table names, column names, etc. will need to be edited – and the database name, user and pass up top. If your date and time entries are not already formatted the way you want them (which is probably the case, not sure how WP works) you’ll want to run substr on those to format them the way you like.
If that’s in the area of what you’re looking for but it doesn’t quite work for some reason, just let me know.
Uhhh okay, everything inside the code tag was removed upon posting. Strange. If you’d like me to email it just note.
Something is funky with the bullets on the possibly related links when I view the pages. (I’m running Firefox 1.5.0.8 on Windows XP.) When there are possibly related links, an extra bullet point creeps in somewhere, and in this post, I currently see no possibly related links, but there is a bullet point. Nothing major, but it’s there.
I’ve used quicktags elsewhere, and I feel that they are a good feature. Actually, I think it would be interesting to see how the quicktags work without comment numbering. It makes it much easier for people to emphasize quoted text, and I really don’t like having to scroll back up again to figure out the arbitrary number that some insist on referencing when responding to a comment.
Why the hell did we offer arbitration to Corco? He’s totally going to accept it and get like three million comments next year.
Man, this new stuff is really cool. Cheers, DMZ.
Seriously, I do appreciate the quicktags because I sometimes forget the formatting between different blogs and the spellchecker doesn’t catch tag issues…
Derek, you’re very close on the sql.
I haven’t used MySQL specifically (just Oracle and SQL Server), so I don’t know if you can use ‘+’ as a concatenation operator (SQL Server you can, Oracle you can’t). At any rate, there’s the concat() function.
For the date, again, I don’t know if MySQL will automatically convert the format for you. It should, but then you have no control of the resulting format. (Plus, for days with multiple posts, you need the time as part of a unique name). I’d do something like: DATE_FORMAT(‘%Y-%m-%d_%H:%i:%s’), which will give you a date formatted like ‘2006-12-02_08:45:15′.
As for your where clause, you just need to check for a null title (or an empty string, I suppose): where title is null or title = ”
Putting it together, you can preview it:
select concat(‘Older post from ‘,DATE_FORMAT(‘%Y-%m-%d_%H:%i:%s’))
from posts
where title is null or title = ”
If you like the output, then just change it to an update:
update posts
set title = concat(‘Older post from ‘,DATE_FORMAT(‘%Y-%m-%d_%H:%i:%s’))
where title is null or title = ”
If you want to see more date formats, check out Date_Format
Good luck!
(BTW, the quicktags are cool, though it was’t at all intuitive how to insert the link, add a short text, then close the link…)
Ack, I forgot the date in the DATE_FORMAT call.
So, in the sql, it should be:
DATE_FORMAT(post_date,’%Y-%m-%d_%H:%i:%s’)
my brain hurts.
Three things:
1. Drop the “Code” button. Commenters rarely use that.
2. Here’s the plugin for making comments paged.
3. How about the LiveCommentPreview?
No. The code button is awesome
Oh, and a pony!
What happened to the “Comment of the Day” feature? If it’s reinstated, I nominate this one for the “Comment of the Indefinite Immediate Future:”
Maybe we can introduce Corco to the Blue Jays.
It looks like Jose Guillen will be a Mariner… more to follow soon.
Yeah what’s that Jose Guillen Mariner crap?
Yea. I’ve got a post in the queue about it that will be up in a minute or five.
Let’s go back in time fourteen hours, shall we, to an early comment in the thread.
48
No, no,
Code is awesome!!!Let’s go back in time fourteen hours, shall we, to an early comment in the thread.
Sorry about that. My brain somehow didn’t connect “empty related links” with extraneous dots.