This is it! Foursquare has once again created a special badge and logo for 4sqday! We’re super proud to unveil the new 4sqday 2011 logo and confirm that users will be able to unlock a 4sqday badge by checking in on April 16th, 2011! Details on exactly how to unlock the badge has yet to be revealed, but stay tuned! via Announcing the official foursquare badge, logo and T-shirt! « Foursquare Day.
There are several sites aligning themselves with this day/event, but nothing from foursquare officially. That makes me think this it is a grass-root movement. It’s cool though.
According to their tweet today it appears McDonalds is planning something for 4/16/11.
Show off your <body> on April 9, 2011. This year they’re calling it Naked CSS Day and there’s more plugins, tools, and code than ever before to help web designers strip their sites of CSS – down to bare HTML.
This is not an April Fools joke. It’s real. Web geeks have been doing this since 2006. Look for the hashtag #cssnakedday on Twitter and make plans to go CSS-Naked on April 9.
Here’s the text from the Naked CSS Day website:
Where did the design go
The website you just came from is not broken, the owner of it has decided to participate in Naked CSS Day 2011! Naked CSS Day is a event that is held once per year to celebrate good & well planned design. The website you arrived from will be back to its normal styled state tomorrow. Keep calm and carry on.
What does that mean
The idea behind this event is to promote Web Standards. Plain and simple. This includes proper use of html, semantic markup, a good hierarchy structure, and of course, a good ‘ol play on words. It’s time to show off your <body> for what it really is.
How to Participate
Enter your email address to be alerted before April 9th of Naked CSS Day, this will give you time to get your name in our official list of participants.
Then on April 9th, simply remove all CSS from your website, stripping it entirely of its design.
Also, Developers, Some have suggested codes & scripts have been put together into a nice list.
“This is a fun idea, fully in line with the reasons for creating CSS in the first place.
While most designers are attracted by the extra presentational capabilities, saving HTML from becoming a presentational language
was probably a more important motivation for most people who participated in the beginning.” – Håkon Wium Lie
It seems the site where I got the content for Naked CSS Day 2011 isn’t participating – ironic I know. But, there are a few around the world Tweeting about Naked CSS day.
We we’re seated in the ‘villa’ section which has concrete floors and a vaulted wooden ceiling. It was nicely decorated, but 1 large party made enough noise in the room that my wife and I could hardly hear each other. My comment to her was, ‘How much does it cost to sit out in the patio area.’ (ambiance 3 stars)
We had two servers stopping by every 5 minutes (1 in training maybe?) – we felt a little rushed. That coupled with the noise was the opposite of a relaxed Italian meal. (service 3 stars)
The food tasted fresh; however, both our meals were not what we expected: too much of one ingredient not enough of the traditional ingredients. (food 3 stars)
Now we know Luigi’s, not so much.
The restaurant was beautifully decorated. The servers were attentive. The food was good.
Design quirks like concrete floors and wooden ceilings make putting 20 people a mistake.
The microscopic table combined with a server in training and trainer hovering right behind made us conscious of two servers there at all times.
My veal scallopini (Saltimbocca alla Romana) came with scalloped potatoes covered with a cheese blanket and chefs vegetables. The veal had some breading and was smothered in a prosciutto and sage sauce; odd. My wife ordered the chicken parmigiana (Pollo Parmigiana allo Stile di Luigi). It was chicken smothered in a deep red tomato sauce. It was a little too much. She said maybe serve the chicken on top of a bed of pasta with a little sauce on the side.
We also kept comparing it to other restaurants in the area. Needless to say, there were other places that we like more. So we decided, Luigi’s, not so much.
I’m putting this post on my site because I’m tired of searching for the commands.
There are plugins that will clean up your WordPress wp_posts table, but if you have access to the database you can do this yourself.
Backup the Database
You should always make a backup copy of your database just in case something goes wrong. This is a “duh” – but it happens – and things can go wrong. You’ll be deleting records from a table so before you do, make a backup.
Run the DELETE Query
Run the following command on your database. If you have a shared host with a cPanel you probably have phpmyadmin which is your user interface to your MySQL database. WordPress usually installs in MySQL as wrdp. You want click on the right database for your WordPress install. Once you are in the right database you can run this query:
DELETE FROM wp_posts WHERE post_type = "revision";
This will delete all the revisions from WordPress. Just out of curiousity you might take a note of how much space the wp_posts table was taking up before and after running this query. That will tell you how much room you recovered.
Optionally, You Can OPTIMIZE
This step is optional. If you are sweating bullets right now after deleting 20,000 revision posts, you can skip this step.
Optimization “releases” the data you deleted from memory thus freeing memory. Its like delete puts data in the trashcan and optimize empties the trash. To optimize the wp_posts table run the following query:
OPTIMIZE TABLE wp_posts;
Check to see the size of this table. In the YIW database, the “wp_posts” is only 3,4 Mb in size, as you can see in the photo below. It’s a lot of space saved, don’t you think?
I’ve run this query several times over the years. It’s like cleaning up your computer’s hard drive – the more you use it the more you should clean it up. There were my numbers.
Start 407 rows | 792.1 KB
Deleted 61 rows | 96.1 KB
Finish 346 rows | 695.4 KB
Hope this works for you. I know it works for me and I use it about once a year or so.