Snipplr

(SQL) Repair crashed tables - jessibird

Tue, 26 Apr 2011 07:21:35 UTC

Not totally sure if this is correct. Haven't tested it.

(MySQL) Delete WordPress revisions - jessibird

Tue, 28 Sep 2010 23:56:17 UTC

Change \"wp\" to your database prefix. Note, this is the quick and dirty way. The more thorough way, which will also clean any tags or categories that are now unused, is here: http://www.snipplr.com/view/29570/get-rid-of-unused-post-revisions/

(Apache) redirect index.htm and index.html to root - jessibird

Sat, 14 Aug 2010 07:43:38 UTC

For WordPress, put this code at the top of your .htaccess file. Make sure it's above the WordPress-generated rewrite section.

(CSS) Wrap long URLs and text with CSS - jessibird

Tue, 01 Jun 2010 13:01:52 UTC

To wrap long URLs, strings of text, and other content, just apply this carefully crafted chunk of CSS code to any block-level element (e.g., perfect for <pre> tags):

(CSS) Style a submit button to look like a link - jessibird

Thu, 01 Apr 2010 11:09:12 UTC

I made my own modifications to this.

(MySQL) reset id auto increment - jessibird

Mon, 22 Mar 2010 15:20:04 UTC

Set the counter back to zero.

(MySQL) Get rid of unused post revisions - jessibird

Wed, 10 Mar 2010 21:17:42 UTC

Just run the following query on your WordPress database, and all revisions (As well as meta associated with it) will be deleted from your database.

(HTML) Add body class just for IE - jessibird

Thu, 20 Aug 2009 23:04:49 UTC

Now you can write IE specific styles in a regular stylesheet, by prefacing the CSS selectors with body.ie

(CSS) Hide submit button text - jessibird

Tue, 18 Aug 2009 18:31:51 UTC

Sometimes you can't use an image button, you have to use a submit button, but you still want to hide the text and show an image instead. The width and height can be changed, of course. The point is that they are specified. Display:block is needed for IE, according to the original article. Not sure if the font-size and line-height are strictly needed; I didn't test extensively.

(Perl) Search and replace across multiple files - jessibird

Tue, 18 Aug 2009 11:49:01 UTC

-p tells perl to assume a simple loop around the code we give it to run. -i.bak tells perl that we wish to create backups of the files we modify with the suffix .bak. -e "..." tells perl that we wish to execute the code inside the quotes. And finally the file list is the list of files that we wish to operate upon. Escape special characters such as ".", "?", "*", or "/" by preceding them with the "\" character. Example: change "Bob" to "Steve" on all HTML files in the current directory: perl -pi.bak -e "s/Bob/Steve/g" *.html

(PHP) wordpress body_class - jessibird

Tue, 16 Jun 2009 23:57:08 UTC

Template Tag body_class The coming WordPress 2.8 provides a new Template Tag, body_class. This function gives the body element different classes, which gives you the possibility to use it effectively with CSS.

(CSS) A hasLayout fix without side-effects - jessibird

Fri, 29 May 2009 01:09:52 UTC

Assign this class to any element that needs to have layout (hasLayout=true) and it will get it. ...with the style placed inside IE conditional comments, it will be ignored by the validator, which removes the only obstacle to using zoom:1 - which has no side effects*. ...*zoom is supported by IE5.5+, that is not supported by IE5.

(CSS) Remove link border outlines - jessibird

Sat, 28 Feb 2009 13:52:08 UTC