May Namecheap discount coupon

I was registering some domains, and ran across a discount coupon code for Namecheap registrations. If you enter itsadeal it gives a 10% discount for the order.

Hacking into Wordpress admin account

I setup Wordpress on a domain last week. For those that are familiar, when you first install Wordpress, it gives you a temporary password. Well, I logged in using that temporary password, made some configuration changes, and then logged out (without remember to set a new password!). Of course, I’d forgotten the temporary password… D’oh!

Usually, you can use Wordpress’s “Forgot Password” function, which will send an email to the address you defined for admin during setup. But in this case, this option wasn’t available to me - I might have mistyped the email address when I entered it :(

So I had to research how to hack in and reset the admin password. This is what needs to be done:

This process worked for my Wordpress 2.1.3 setup. Use at own risk!

  • Log into phpMyAdmin (the MySQL admin)
  • Select the database, and click on the SQL tab
  • Enter this:

    SELECT ID, user_login, user_pass FROM wp_users WHERE user_login = ‘admin’;

    where wp_users is the table (wp_users is the default name for Wordpress 2.1.3, but your version might be different, so check!

  • It should show you the table record for the admin account. If it doesn’t, stop here and figure out why that SQL command doesn’t work.
  • Enter this:

    UPDATE wp_users SET user_pass=MD5(’password‘) WHERE user_login =’admin’;

    where wp_users is the table (wp_users is the default name for Wordpress 2.1.3, but your version might be different, so check!
    where password is the new password you want to use

  • If phpMyAdmin returns a successful response, login using the new password!
New Pageranks for all!

Woohoo! It looks like Google has completed its quarterly Pagerank updates.

Pagerank (named after Google’s co-founder Larry Page) is Google’s classification of a site’s relevance. A higher Pagerank means that the site will appear higher up if searches match what’s on your site, which in turns should result in more traffic to the site.

TubeBattle managed to get a Pagerank of 4 (which is pretty good being a new site).
All my other sites have received a Pagerank of 2-3 (mostly 3).
Even wandering.net received a Pagerank of 3.

Website optimization

Recently, I received a recommendation to check out Crazy Egg. I was very impressed by what this site could do. To summarize, Crazy Egg allows you to see where people are clicking on a website. But the beauty is, not only will it show you which links people click on (which you can easily get from many free tools like Google Analytics), Crazy Egg will also show you things that people click on which are not links!

Here is an example of Crazy Egg’s heatmap of TubeBattle’s “live” links:
TubeBattle Heatmap 1
It’s very cool to see where people click, especially when I’m presenting thumbnail pictures.

And this is an example of the heatmap of TubeBattle’s “non-live” links. That is, people are clicking on the page, where nothing happens because it’s just a graphics image and not a real link.
TubeBattle Heatmap 2
As you can see, there are alot of clicks going just to the left of “Featured Video”. That’s because there is a small icon there (which is just used as a bullet) which looks like the “play” icon! Anyway, the obvious solution, now that I know about this “problem”, is to make that icon click-able.

Crazy Egg has a very impressive system, which has taken alot of the guess work in web UI design! Having worked for many years at eBay, I know how hard it is to do UI testing: running hundreds and thousands of people through usability sessions to figure out what people like and don’t like. In under 12 hours, I collected data from all 5000 visitors to TubeBattle… all without me doing any work. I love it!

Posting code in Wordpress (the hard way)

Believe it or not, yesterday’s post with the code snippets was actually very time consuming to write.
Not that the topic was difficult, but because Wordpress (the software that this blog uses) doesn’t handle code very well.

So as a note to myself and other Wordpress bloggers, here are the codes for the special characters that Wordpress doesn’t handle very well. Most of the codes were originally found on Lorelle’s blog, although I did add a few more to the list.

  • " - Quote Mark “
  • ' - Apostrophe ‘
  • © - Copyright symbol ©
  • : - Colon :
  • &#59; - Semi-colon ;
  • &lt; - Less than <
  • &#61; - Equals sign =
  • &gt; - Greater than >
  • &#63; - Question mark ?
  • &#64; - Commercial at @
  • &#35; - Number sign #
  • &divide; - Divide ÷
  • &#33; - Exclamation mark !
  • &#35; - Number sign (pound) #
  • &#36; - Dollar sign $
  • &#37; - Percent sign %
  • &amp; - Ampersand &
  • &#40; - Left parenthesis (
  • &#41; - Right parenthesis )
  • &#42; - Asterisk *
  • &#43; - Plus sign +
  • &#44; - Comma ,
  • &#45; - Hyphen -
  • &#46; - Period (fullstop) .
  • &#47; - Forward slash /
  • &#93; - Close square bracket ]
  • &#94; - Open square bracket [

There are Wordpress plugins that exist to help those who post alot of code. I just do it the hard way, from stupidity ;)