fuzmeister: Kevin Bacon

---

Microsoft has wasted some money and finally proven what we've all known to be true for quite some time. The Kevin Bacon theory is true!

Mood: Eh
Music: Led Zeppelin - I Can't Quit You Baby


Tags (beta): science

Comments (1)

fuzmeister: History

---

Back in 2004, I restarted my posting life on Vent and deleted all previous posts dating back to my first faithful post in July, 2002.


Four years later I'm actually trying to restore the lost posts using tools like the internet archive. It's been pretty unsuccessful so far as one would expect (with the exception of five posts from fall of 2003).



Anyone have any ideas?

Mood: Nostalgic as Hell
Music: Red Hot Chili Peppers - This is The Place


Tags (beta): vent

Comments (4)

fuzmeister: Goo Goo Ga-Joo, Guru...

---

I nominate myself for guru status seeing as how I have been registered on Vent for over six years this month. I also think I am l337 enough to pass the specifications that remain undefined. Petition for it, people!

Also, what ever happened to the ask the gurus page? I had many more questions and there were never enough answers...

Mood: Still Disgusted, Still Hungry
Music: Medeski, Martin and Wood - Spy Kiss


Tags (beta): vent

Comments (5)

fuzmeister: Do you like... HOT DOGS?

---

Try these varieties if you enjoy tube steaks.

Mood: Disgusted, yet Hungry
Music: Medeski, Martin and Wood - Bubblehouse


Tags (beta): food

Comments (0)

fuzmeister: I'm a Statistics FREAK

---

So I'm playing around with the Vent code - specifically this page. I'm trying to add some relevant statistics to the page... however, I've run into an issue with SQL.

If you clicked that link you will notice the page is SLOW. That's because to find the post with the most comments (for the "most active post" column), I have it going through every post and basically if the amount of comments returned with the corresponding post number is greater than what's currently stored in the variable, I replace the variable. There has got to be a better way.

Is anyone aware of a way using SQL to return the the fields with the most occurrences of a like value? That would mean one query in the comments to get the post number that has the most...

Mood: Statistical


Tags (beta): vent, development

Comments (7)