Improve your WordPress installation with SQL hacks
Jean-Baptiste Jung shares how you can perform very useful tasks and tweaks for your WordPress blog with the use of database SQL queries. Database manipulation may be a bit advanced for the average WordPress user, but for those who are curious, this article is a great start as the tutorials are not really intimidating at all.
Here’s the shortlist:
- Creating a Backup of Your Database
- Batch Delete Post Revisions
- Erase 5000 Spam Comments in a Second
- Change the Post Attribution
- Manually Reset Your Password
- Change Your WordPress Domain Name
- Display the Number of SQL Queries on Your blog
- Restore Your WordPress Database
View other WordPress posts on Smashing Magazine here.
WordPress video tutorials for everyone
Speckyboy has compiled dozens of video tutorials that will teach you just about everything you need to know about WordPress. And even if you know your way around the PHP files and the admin dashboard, you’ll still be able to learn several new things just by watching.
This post is a must-bookmark! It’s amazing how generous people from the WordPress community are.
Get $1000 off on your blog design with The Blog Studio
Is your blog in dire need of a redesign? Or are you a new blogger who wants a personalized look for your new blog? This offer by The Blog Studio might be for you:
For the remainder of the month of November 2008, all new design projects will receive an automatic $1000 discount. Please note: this only applies to new design projects with contracts signed by November 30 2008.
Check out their past work at the Portfolio (these guys specialize in custom WordPress sites), then hit the request for proposal form or the contact form.
WordPress App for LinkedIn adds your blog to your professional profile
If you’re networking professionally at LinkedIn, you’ll be pleased to know that you can now add your WordPress-powered blog to your profile with the WordPress app. Just look for it in the Application Directory, add your blog URL, and you’re all set. Your recent blog posts will now be displayed on your profile.
Users of both WordPress.com (hosted) and WordPress.org (self-hosted) can use this app, so don’t hesitate! Why use LinkedIn? It’s a great way to build your professional network online.
WordPress Helper add-on for Firefox
Power users of WordPress and Firefox will certainly love this one: the WordPress Helper add-on for Firefox gives you quick access to WordPress documentation and to the admin panels of website profiles you have entered.
The extension eases the fast and simple access to develop-relevant pages of the WordPress Codex. So you always have all the necessary help at your fingertips. It’s also possible to search after strings of text that is currently marked. Furthermore it’s possible to easily switch to WordPress backend of current site. More than that, a small Icon indicates wether the currently displayed website makes use of WordPress.
Sometimes you have to search all over the WordPress.org Codex and even 3rd-party sites to answer that WP-related question, so this extension makes it a more pleasant experience.
And even if you’re not much of a WordPress developer, this tool will make learning about the inner workings of WordPress more efficient and convenient. Sometimes all you need is a little nudge, like this one.
WordPress Comment Moderator for Adobe Air
Daniel Dura presented a sneak peek of an Adobe Air application that lets you moderate comments on your blog:
This screenshot is the application actually working. I have it running against a local version of a Wordpress installation. It gives alerts when new comments are awaiting moderation, tells you how many comments are awaiting moderation in the dock menu, and allows you to approve comments, mark them as spam, or delete them.
This looks like a convenient way to keep track of comments from your own desktop. Since Adobe Air is cross-platform. It should work whether you’re a Windows, Mac, or Linux user.
Since this is just a preview, though, you can’t download it yet. Daniel says it will be out in a couple of weeks. Visit the blog post to leave your questions and suggestions.
Performancing Ads Launches!
Performancing, the team whose main goal is to help bloggers succeed, has recently launched Performancing Ads. The system is meant to be both an adserver and a marketplace where bloggers can feature their sites, and where advertisers can look for great sites to sponsor.
There are many reasons why we think bloggers should sign up for Performancing Ads. Among my favorites are the ad-exchange feature, where you can exchange ads with other users (sort of like link exchanges). I also particularly like the fact that you can book your own ads. This way, you can use Perf Ads as your ad server.
Performancing Ads presents a radical alternative (or complement) to the usual pay-per-click ad programs like Google Adsense and the like. Image/button advertising highlights more the brand rather than the context of a link. So advertisers who are looking to enhance brand awareness would love how Performancing ads can help.
Perf Ads also offers an affiliate system whereby each successful referral will earn users both a bonus and also residual commissions from referral sales.
For Philippine bloggers, Perf ads does not offer localized means of presenting ads, though, but it’s a good start for bloggers who want to make money out of their publications.
