Ryan McCue’s Blog

Just found out about Get Satisfaction’s brand new Help Center and tried to install it? No doubt you’ll run into a few bugs along the way. However, follow this guide and you should be fine.

Install Smarty into an include directory

1. This is most easily done by extracting the lib/ directory from the Smarty package into a new directory called includes/
2. Rename the lib/ directory to smarty/
3. Add the following line to your Help Center’s config file:
   set_include_path(get_include_path() . PATH_SEPARATOR . '/path/to/includes/');

Install the HTTP_Request PEAR library

Install this like any other PEAR library. If you don’t have PEAR, download the archive and extract the HTTP_Request-* into the previously created includes directory. Then rename the HTTP_Request-* to HTTP

Setup the database

1. Create a database called “sprinkles”
2. Import the schema from the included SQL file, sprinkles-schema.sql

Create a folder for compiled templates

Create the templates_c/ directory in the Help Center directory to hold the compiled templates for Smarty and make sure it is writable.

Edit your config

Edit config.php in your Help Center installation and add the following, replacing “root” and “password” with your respective database username and password:
$mysql_username = 'root';
$mysql_password = 'password';

Run the web installer

Head to your installation of Help Center in your browser and the web installer will kick in.

Hopefully this process becomes easier in the future. I would recommend to the Get Satisfaction developers to include HTTP_Request and Smarty with the Help Center package.

What follows is a night well spent on #brisbanecreative. Each person wrote up to a sentance each and we continued each others stories. Hover over a line to see who wrote it. Enough talking, let’s begin:

“Fuck you”,
Sally muttered
while she
sat down
on the
quite peculiar
floor. She
was not
impressed with
SHRIKEE’s lack
of intelligence.
She could
not take
any more
of it.
“Not again”,
said SHRIKEE,
while unwrapping
the dog.
He only
had himself
to blame
for the
large hole
in his
anus.
Sally quit
her job
because she
had a huge
pile of
magazines under
her pillow
. The pile
contained such
filth that
her boss
wanted to
let her
bend over
and let him
touch her
under her
belt. So
she decided
that she
would not
allow him
to grope
her udder.
She couldn’t decide
who would be allowed
to touch the
udder. Which is
her favourite body part so she had to be careful about
letting anyone rub their
greasy paws on
her. So she quit.
It was a new beginning for Sandy, no longer did she want to think about her udder, a body part that no human should have.
Sally just wanted to be like all the other girls at school, with their
udderless bellies.
She decided to look up udderless in the
urban dictionary, what she found was
that normal
girls refer to them as bewbs
and that they are normally placed
higher on the chest but an udder did have its benefits such as,
giving milk, and stimulate the
navel more directly
now that she had four
teats.
Sally was soon known as the super-navel-stimulator.
which scared the boys at first…
until they too tried the
naval stimulation that Sally could provide them.
Sally wasn’t happy yet, she still
could only pleasure 4 guys at once.
She contacted a VET to see if they had more
transplant udders lying about unused, she was surprised to find
that they didn’t keep them in storage
but that they were infact looking for udder-donors.
and especially udders that could be mounted on her back, which is a special treat for men.
Sally died on operating table trying to get a 10th udder attached. The End.

After my last post on how to reset your WordPress password manually, people have asked for the patch and the changed files for the bug in 2.5.1. I’ve grabbed these files straight from Trac, so they should work (hopefully ).

• Grab the patch
• Grab the changed files (zip)

Most users will want the changed files zip. To use this, extract the archive into your wordpress directory and upload wp-login.php and pluggable.php.

For users who wish to use the patch, I’ll assume you know how to do that

Edit: If this appears not to work, Doug has kindly worked out why and notes how to fix that. Thanks Doug!

Ever wanted to reset your password in WordPress, but for some reason or other you can’t use the reset password section? 2.5.1 has a bug where the reset password page doesn’t work, so this might be handy for you.

The phpMyAdmin way

Browse into the wp_users table in your database. Find your username and click on the edit icon () next to your username.

On the edit page, select MD5 from the Function dropdown next to the user_pass row. Change the value on the user_pass row to your new password and then hit Go.

Now log into WordPress with your new password and it will upgrade your password to the new phpass hashing.

The SQL query way

This applies where your database is wordpress and your login name is admin. Replace PASSWORD with whatever you want your new password to be.

UPDATE `wordpress`.`wp_users` SET `user_pass` = MD5('PASSWORD') WHERE `wp_users`.`user_login` = 'admin' LIMIT 1;

After you login on your WordPress installation, it will upgrade your password to the new phpass hashing.

As a tip to everyone who uses WordPress 2.5 and needs to input their FTP details every time, you can force WordPress to remember them by adding this to your wp-config.php:

define('FTP_HOST', 'ftp://example.com/');
define('FTP_USER', 'example_user');
define('FTP_PASS', 'example_pass');
//Set to true if your host uses SSL connections
define('FTP_SSL', false);

This can be reduced to just your password, if your database already remembers the other details.

I’m currently making a WordPress magazine site. Among other things, it needs to show only the posts from the current issue on the front page. It uses categories to mark which issue an article belongs to.

I thought I’d share the code to do this, as it may be of use to some of you. This code sits just before your loop in index.php. It takes all categories under category 8 (the ‘Issues’ category for the magazine), gets the ID of the most recently added category under these and then sets the query to use that.

Please use at your own risk, etc:

$category = get_categories('child_of=8&order=DESC');
$category = array_values($category);
query_posts('cat=' . $category[0]->cat_ID);