I have a few Drupal based blog posts. Each of them are tagged with the "Drupal" taxonomy term from my "Blog-Vocab" vocabulary.
I have created a new block that I want to display in my left sidebar, but here's my wrinkle . . . I only want it to display on blog posts that are tagged with the "Drupal" taxonomy term.
I recently took on a project where the client had lost their Joomla Admin password.
The admin password cannot be recovered but can be reset since the passwords are stored using a one-way MD5 hash.
Here's how to generate a new admin password:
Using a tool like phpMyAdmin or MySQL Query Browser, find the admin user on the jos_users table
Copy and paste the complete password field's value into notepad
It will look something like this:
If you need to recover the passwords from a Windows XP or Windows Vista Machine, the easiest thing to do to retrieve your password is to use OPHCrack live CD.
I inherited a Dell Precision 340 the other day with Windows XP on it. It had been sitting in a PC graveyard for some time before being shipped to me.
This is how I was able to recover the administrator password to get this machine setup.
Use Derived Tables instead of Temp Tables in SQL Server
The biggest benefit of using derived tables over using temporary tables is that they require fewer steps, and everything
happens in memory instead of a combination of memory and disk.
The fewer the steps involved, along with less I/O, the faster the performance.
Here are the steps when you use a temporary table:
1) CREATE the temporary table (write activity)
2) SELECT data & INSERT data (read & write activity)
3) SELECT data from temporary table (read activity)
4) DROP TABLE (write activity)
From the command line you can check your MX records using dig
I’m sure there are other ways but I’ve recently learned a method to check your MX records using the dig command.
Dig is a pretty powerful command to have in your arsenal. Perhaps, I’ll provide a more complete tutorial someday but for now I’ll stick with this example.
I have a mySQL database with a table of email addresses but some of the email addresses have single quotes for odd some reason.
I'll need to add some validation to my form eventually.
I need to find them and fix them now.
Here's the SQL to find them
SELECT * FROM tbl_email WHERE LOCATE("'",user_email) > 0