Since I wrote this here CMS thingy, I have learned quite a bit about database structure and normalisation and stuff. Therefore, I have been going through my queries and straightening them out. So far I've squished around two thirds of the queries I had, by optimising and generally refining my code. Using INDEXes and JOINs and stuff, oh yes.

...

Yes, my life really is that boring... :P
I haven't had much else to do other than organise my house move (not confirmed yet, lots going on but seemingly nothing happening) and being ill and stuff *yawn*.

Sick of using the name 'admin' to login to your WP installation? Have a user with the login 'PiNkbUnNiEz!1" but want to change it without that user losing all their posts/creating a new account etc.? Tried to do it but found the field disabled in your WP admin panel?
Here is what you need to do.

1. Before you do anything, backup your database. If you don't know how to do this, ask at the WP forums or Google it - there are some plugins that will do this for you if you don't have access to things like phpMyAdmin (a MySQL tool which can be used to backup your database - Jem has a tutorial on this which may be useful)

2. Paste this into a file. Name it anything you like, as long as it has a .php extension:

   <?php
$existing_username = 'admin';
$new_username = 'MY_NEW_USERNAME';

   // —————

   if (!file_exists('wp-config.php')) exit('Could not find wp-config.php, please make sure you place this file in the same directory as all your WP files.');

   require 'wp-config.php';

   $link = @mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) exit('Could not connect to MySQL');
mysql_select_db(DB_NAME, $link) or exit('Could not connect to MySQL');

   if (mysql_query('UPDATE `' . $table_prefix . "users` SET `user_login` = '" . mysql_real_escape_string($new_username, $link) . "' WHERE `user_login` = '" . mysql_real_escape_string($existing_username, $link) . "' LIMIT 1", $link)) echo 'Username updated, your username is now ' . $new_username . '.';
else echo 'Could not update your username. MySQL said: ' . mysql_error($link);

   mysql_close($link);
?>

   Change the first two lines (excluding the one that says '<?php', obviously :P ) to your existing username (probably admin) and your new desired username. Save the file, then upload it to your WordPress directory. Make sure this file is in the same place as wp-config.php.

3. Go to the file in your browser, e.g. yoursite/wordpress/the-file.php and voilà! :D

It's CSS Naked Day 2008, so my site has taken its clothes off to boast its web standardiness and stuff. :D

(And yes, the navigation links do appear back to front... I'll explain that another time :P )

Edit: It's the end of CSS Naked Day here in the UK, so the styles are now back up. See you next year!