Posts Tagged ‘How To’

How to Localize WordPress Themes, Plugins and Front-end

For WordPress developers and designers to create a website powered by WordPress for non English clients is very easy. All you have to install the plugin like WordPress CML  from Codecanyon and The WordPress Multilingual Plugin from ICanLocalize. If you want to put some effort in it than read these articles Localizing WordPress Themes and Plugins and How to Convert WordPress in Your Language.

The WordPress community has already translated WordPress into many languages, and there are Themes, translation files, and support available in many other languages. Detail

WordPpress CML

A suite of wordpress plugins that cater for corporate multi-lingual websites. It allows specific country level user control, a detailed post revision mechanism and a host of other features.
You can: Set up the plugin with all the countries you want posts / pages translated into. Designate users as specific country level users, giving them access to only translate their own language. Allow a page / post to be published, while a newer version of the page is worked on in the background.

Detail

The WordPress Multilingual Plugin

WPML makes it easy to run a multilingual website with a single WordPress install. Choose languages for your site and start translating content.

The default install comes with over 40 languages. You can also add your own language variants (like Canadian French or Mexican Spanish) using WPML’s languages editor.

You can arrange different language contents in the same domain (in language directories), in sub-domains or in completely different domains.

Detail

Simply install the TranslateThis Button plugin, and use either the widgetized sidebar or template tagto add the button to your blog.

The plugin comes with a wide variety of options that can be easily customized from your WordPress admin section. Includes controls for text & language options, various display settings and other functionality options.

Download

References and Other Useful Resources:

1. How to translate the Theme Junkie WordPress themes to your language

Theme Junkie Premium WordPress Themes

2. How to make a translatable WordPress theme
3. Localizing WordPress Themes and Plugins
4. Translating WordPress Plugins & Themes
5. Localizing WordPress Themes
6. How to Translate a WordPress Theme
7. Translating the Hybrid theme
8. Localizing a WordPress Plugin Using poEdit
9. Multi Language WordPress Mobile Admin
10. WordPress in your Language
11. WordPress in Your Language
12. Translate a WordPress Theme in 3 Easy Steps
13. How To Change Language In WordPress Blog?
14. Translate WordPress site, plugins into several languages

Most Important SQL queries for WordPress Beginners

Before taking any step make a backup of your current WordPress database. How to make a backup of your WP database? You can use different WordPress Plugins like Smart Backup and WP-DB_Backup, Alternatively you can use phpMyAdmin.
Smart Backup is a complete WordPress solution for database backup and restore operations. You can create backups of your complete WordPress installation, files only, or database only. Backups can be restored with one click.

Where to run WordPress SQL Queries


Hope you know where to run SQL Queries, If not follow these steps: Login to phpMyAdmin panel and select your WordPress database. After selecting your database, Click on the SQL tab which will bring you to a page with a SQL query box.

There are some plugins and script that will increase you SQL experience:

SQL Executionner plugin provides an easy-to-use interface that allows you to run SQL queries directly on your WordPress blog dashboard.

Super MySQL Terminal: Super MySQL Terminal is a php mysql shell emulator. You can work with your share-hosted remote mysql like your localhost.

SQL Comparer – Synchronize your database versions: Compare and synchronize two SQL database schemas and see the difference between them. A very helpful tool when dealing with different versions of a database.

SQL Document Generator: SQL Document Generator is a set of classes for creating documents in various formats based on SQL queries.

Enhanced SQL Web Console for MySQL: This script helps you helps you fire queries from database and export the resultset with a browser on the fly.

Features

1). Drag-drop to use, no setup needed.
2). Smart bookmark feature, you can bookmark your favorite scripts and pickup them to use anytime.
3). Export the query resultset to CSV , Excel, XML , HTML formats.
4). Read-only mode avoiding writable scripts executing.
and more…

MySQL Database Navigation and Pagination: If you are working with hosting MySQL databases, and pick up data from them frequently, this script may make your life easy working with them.

CreativeTable: CreativeTable it’s a php class that builds a table based on the data retrieved by an SQL query or an 2D Array. It has lots of options and it’s very, very configurable.

LogPress: This plugin will help you to debug and speedup development of wordpress plugins and themes. Besides logging PHP error it can log a bunch of other things to help you make your website better.

Most Important WordPress SQL Queries:


How to: Manually reset your WordPress password

What to do if you lost your WordPress password? The easier is to use PhpMyAdmin and execute a simple SQL query to update it. Here’s how to proceed.

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

Source: How to manually reset your WordPress password

Change author attribution on all posts at once

Some bloggers makes the mistake to write their first posts under the name “admin”, until they realize that it’s absolutely not personal. But then, modifying author attribution on each post takes a lot of time. Happilly, here’s a recipe to batch modify author attribution.

UPDATE wp_posts SET post_author=NEW_AUTHOR_ID WHERE post_author=OLD_AUTHOR_ID;

Source:how-to-change-author-attribution-on-all-posts-at-once

Delete post revisions and meta associated to those revisions

Post revisions are very useful, especially in the case of a multi author blog. However, the problem of post revisions is definitely the number of database records it creates.

define('WP_POST_REVISIONS', false);

You can also delete all post revisions by running this query in phpMyAdmin:

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

Source: How To Turn Off Post Revision

Batch delete spam comments

Best way install Akismet! if you want delete more than 6000 spam comments by using this command of line.

DELETE from wp_comments WHERE comment_approved = '0';

Source: How to batch deleting spam comments on a WordPress blog?

Identify Unused Tags

In a WordPress database, if you run a query to delete old posts manually from MySQL, the old tags will remain and appear in your tag cloud/listing. This query allows you to identify the unused tags.

SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

Source: Find unused tags

Find and Replace Data

This tip isn’t specific to WordPress and is a must know for anyone who’s working with MySQL databases.

UPDATE table_name SET field_name = replace( field_name, 'string_to_find', 'string_to_replace' ) ;

Source: MySQL Magic – Find and Replace Data

Get a list of your commentators emails

Over a period of time, your blog will have received many comments. These comments will include the email addresses left by the commenter. You can retrieve all these emails for your mailing list without any duplicate.

SELECT DISTINCT comment_author_email FROM wp_comments;

Source: Export all Comment Emails with no Duplicate

Disable all your plugins at once

Sometimes, for exemple when you have to upgrade your blog, you need to disable all your plugins. Depending to how much plugins you’re using, it can takes a lot of time and be kinda boring.

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

Source: How to: Disable all your plugins in a second

SQL Query to delete all tags

This piece of code will remove all tags and relationships between tags and posts, while leaving categories and taxonomies intact.

DELETE a,b,c
FROM
	database.prefix_terms AS a
	LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id
	LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE (
	c.taxonomy = 'post_tag' AND
	c.count = 0
	);

Source : http://wordpress.org/support/topic/SQL Query to delete all tags

List unused post meta

The following query will show you all the records in the postmeta table that doesn’t have corresponding records in the post table.

SELECT * FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

Source: SQL Query to delete orphans wp_postmeta

Disable comments on older posts

This code will automatically close comments on posts which are too old. This SQL query will close comments on all posts published before January 1, 2009.

UPDATE wp_posts SET comment_status = 'closed' WHERE post_date < '2009-01-01' AND post_status = 'publish';

Source: Enable or Disable Comments and Pingbacks via SQL

Replace commentator url

This SQL query easily replace the old url by your new site url. Simply run this query and you’ll be done!

UPDATE wp_comments SET comment_author_url = REPLACE( comment_author_url, 'http://oldurl.com', 'http://newurl.com' );

Source: WordPress link author comments home page

Replace commentator email adress

This query will replace the email adress provided in the comments field, by a new one.

UPDATE wp_comments SET comment_author_email = REPLACE( comment_author_email, 'old-email@address.com', 'new-email@address.com' );

Source : WordPress-tip-update-email-address-in-the-wordpress-database

Delete all comments with a specific url

The following query will delete all comments with a specific url. The “%” signs means that any url containing the string within the % signs will be deleted.

DELETE from wp_comments WHERE comment_author_url LIKE "%sitetobeDel%" ;

Source : mysql-magic-find-and-replace-data

Other Reference and Resources:

Digging Into WordPress
WordPress Plugin Development: Beginner’s Guide
WordPress 3 Plugin Development Essentials
7 Best Useful SQL Queries for WordPress
15 Best SQL Queries For WordPress Database Administrator
WordPress : 10+ life saving SQL queries
How to be a Rockstar WordPress Designer 2
15 Most Important WordPress SQL Queries: Highly Beneficial

Video Tutorials To Learn WordPress Development, Designing and Blogging

If you think that visual learning is better than reading, this is the list of well explained video tutorials which help you to develop your WordPress skill. These tutorials are very helpful if you are a WordPress Theme Developer as well Bloggers those using WordPress.

WordPress theme development


Designing for WordPress

WordPress is a hugely popular CMS for blogging. The blog section of CSS-Tricks is run on WordPress and I am very happy with it. By popular request, we are going to walk through designing for WordPress. Also check out part 2 and part 3.

Creating a WordPress Template

Here’s a tutorial series (also see part 2 and part 3) for creating a WP template using a variety of free tools such as MAMP (for local machine development) and TextWrangler(a text editor).

Hodgepodge of WordPress Tricks

It’s WordPress Week here at CSS-Tricks, so I wanted to so a WordPress-themed screencast and cover a lot of mini-tips that haven’t made it into previous WordPress screencasts.

WordPress as a CMS

Learn how to create a WordPress site that’s more of a fully-featured content management system (like Drupal or Joomla) rather than a blogging platform using a few tools at your disposal such as the SimplePie WordPress plugin.

How to Modify WordPress Theme

This video tutorial is showing how to work with some WordPress theme codes, that is how to add autoresponder code to the blog sidebar, how to put banner in the single post and similar things that can help you to modify the theme and blog to your needs.  You’ll learn about some Theme Template tags in WordPress.

Add a Twitter Field to Your Form

Instructional video on how to install and configure the wp-twitip-id plugin for WordPress blogs. 5 minutes and you can include a field for your commentators to add their twitter ID.

How to put a Custom Header in your WordPress Blog

WordPress Kubrick Theme, the default theme for WordPress blogs, has a very ugly header graphic. In this easy to follow video tutorial you’ll learn how to change it to a great custom image in just 3 minutes!

Create your first widget

This video tutorial shows you how to create a theme widget for WordPress.

How to make a WordPress plugin

Learn how to create a WordPress plugin that follows the WordPress plugin development guidelines.

WordPress Plugin Development Tutorial (Video & Reading)


WP Tutorial: Your First WP Plugin

Here it is, a video guide to creating your first WordPress plugin (in under 5 minutes!). The tutorial assumes you have some very basic PHP knowledge… syntax, function declarations, etc. Click here to watch

Writing a Plugin

WordPress Plugins allow easy modification, customization, and enhancement to a WordPress blog. Instead of changing the core programming of WordPress, you can add functionality with WordPress Plugins.

How to Write a WordPress Plugin – Introduction

For any WordPress user, plugins are essential. WordPress Plugins allow those with little to no programming skills to extend the functionality of their blog.

Create a Custom WordPress Plugin From Scratch

This tutorial will describe the implementation of a WordPress plugin starting from scratch. The plugin will connect to an external OSCommerce database and display random products on your WordPress site.

Anatomy of a WordPress Plugin

This tutorial will guide you through every step of building a simple, widgetized WordPress plugin with settings.

A Crash-Course in WordPress Plugin Development

Despite an extensive codex, many WordPress users remain unfamiliar with how to create their own custom plugins. In today’s screencast, we’ll start from scratch and build our first usable plugin.

WordPress Plugin Tutorial – Hello World

Learning to develop a WordPress plugin can be both fun and rewarding. In this Tutorial we will go over how to make a simple Hello World plugin that you can create.

The Ultimate Guide to Building a WordPress Plugin

There are often plugins created for basic extended functionality, but what happens when you can’t find the perfect plugin for your needs? It might be easier to just create the plugin yourself.

WorPress Plugin Development with PHP

Nice video tutorial on plugin development.

Tips to Speed Up WordPress Plugin Development

Anyone can create useful WordPress plugins without being a hacker.

Seven Reasons to Write a WordPress Plugin

Listed below are seven reasons why a WordPress user should consider writing a WordPress plugin.

WordPress Plugin Actions

An example of an action would be that you want a execute some code after a user has published a post or left a comment.

WordPress Plugin Filters

WordPress filters allow to you modify virtually any kind of text displayed and are extremely powerful.

Constructing a WordPress Plugin Admin Panel

This tutorial will go into what it takes to successfully create an admin panel for your plugin.

Constructing a WordPress Plugin User’s Panel

This tutorial will go over the steps to add in your own User’s Administration Panel.

Using JavaScript and CSS with your WordPress Plugin

This portion of the series will cover how to load JavaScript and CSS files for your plugin.

Using JavaScript and CSS with your WordPress Plugin

This portion of the series will cover how to load JavaScript and CSS files for your plugin.

Releasing and Promoting Your WordPress Plugin

After you have finished writing your awesome WordPress plugin, there are a few things to consider before releasing and promoting your WordPress plugin.

WP Screencasts WordPress Video Tutorials

The primary target audience is blog authors and editors using WordPress to manage their web-based content.

CSS-Tricks WordPress Video Tutorials

iThemes WordPress Video tutorials

Siteground WordPress Video Tutorials

KillerSites WordPress Video Tutorials

Likoma WordPress Video Tutorials

WordPress Training Video Tutorials

Weblog Tools Videos WordPress Tutorials

ScreenCastCentral WordPress Video Tutorials

Faq.WordPress.Com Screencasts

Youtube WordPress Video Tutorials

Other Tutorial Sites and Articles:

How to add Multiple Product Categories to WP e-Commerce Plugin

WP e-Commerce is a free WordPress Shopping Cart Plugin that lets customers buy your products, services and digital downloads online. PHPurchase is a paid plugin, it seems to be of better quality than the free versions as well as slightly easier to use. It has the more features as compare to the free one. Even there are WordPress Themes with eCommerce features, you can find theme on the following links:

If you are using this plugin as a e-Commerce platform and want to add multiple categories, here give you a solution for that and by using this code you can create your own Plugin to add bulk Product categories for your online shop. You can read all about WP-eCommerce Plugin here: Create Online Store with Free WordPress e-Commerce plugin

<?php
/*
Plugin Name: Add Product Categories
Version: v0.1
Author: WordPress Arena
URL: http://wparena.com
Description: Bulk category import for WP-eCommerce Plugin
Plugin URI: http://wparena.com/?p=10921
Author URI: http://wparena.com
*/
function batch_import_function() {
global $wpdb;
if(isset($_POST['Add'])) {

$group_id = $_POST['groupid'];
$parent_id = $_POST['category'];
$categories = $_POST['categories'];
$cats_array = explode(",",$categories);
print_r ($cats_array);
foreach($cats_array as $key => $value) {
$nice_name = str_replace (" ","-",$value);
echo ($nice_name);
$wpdb->insert(
	'wp_wpsc_product_categories',
	array(
		'group_id' => $group_id,
		'name' => $value,
		'nice-name' => $nice_name,
		'active' => 1,
		'category_parent' => $parent_id
		),
	array(
		'%s',
		'%s',
		'%s',
		'%d',
		'%d'
	)
);
}
  }
?>
<form name="batchcats" action="" method="post">
Group:<input type="text" name="groupid" />
Parent Category:<input type="text" name="category" />
Categories:<textarea name="categories"></textarea>
<input name="Add" type="submit" value="Add" />
</form>
<?php
}
function batch_import() {
      add_menu_page("Import Categories", "Import Categories", 1, "Import Categories", "batch_import_function");
}
add_action('admin_menu', 'batch_import');
?>

Save this file  as a .php and upload it into plugin directory, activate the plugin and you will see “Import Categories” tab in your admin panel. Click on this tab and add Group id number and add Parent Category id, after adding ids entry the categories name separated by commas and click on add button.

WordPress Themes for eCommerce


Create Project Management WebSite on WordPress

Are you a WordPress Developer or Designer and looking to work on a project  to create a Project Management Website? This is fact that Project management is one of the business world’s most in-demand skill sets. It’s also among the fastest growing professional disciplines.

WordPress is already a powerful website management system that not only allows you to manage your content, but have others interact as well. Now you can use WordPress as a Project management tool by implementing WordPress plugin or by using specific theme like GTD Theme  from Templatic.

Project Management By WordPress Themes:


After installing the WordPress, you need a perfect theme to run a Project management site. Theoretically any theme will do the trick, but there are a few themes that have been designed specifically with this concept in mind.

P2 WordPress Theme

P2 is a free WordPress theme, with this theme you can update post from the front page of your blog. Users have the ability to embed images, audio files and videos all from a Twitter-like update box.

Download

GTD Templatic

If you are looking to collaborate with a small team or, you need a private blog where only your team members can view, share files and write the content without going to backend, this is the theme you’ve been looking for.

Download

Prologue

Prologue theme contains very simple option, means you can update limited text  from the front page.

Download

SuperCMS

The SuperCMS WordPress Theme is a super-charged CMS (Content Management System) type WordPress theme with the focus of providing you with a solid platform and set of tools to base your new company website upon. This is not just another blogging theme, but comes equipped to handle Portfolios, Testimonies, Images, Blogs, and any of your business or company needs.

Live preview | Detail

Evento – Event Management WordPress Theme

The new Conference theme lets you add an unlimited number of events. Each event can have its own program, presentation, speakers, sponsors, etc.! Simply archive old events and have displayed a new conference on your front-page.

Evento is an event management WordPress Theme suitable for any type of events:

  • conferences,
  • exhibitions,
  • conventions,
  • trade shows,
  • seminars,
  • workshops
  • and business meetings.

Live preview | Detail

MultiToool – WordPress Theme FrameWork

The intuitive visual user interface makes designing WordPress Themes a breeze. MultiToool provides you with the ability to control every pixel of your website without knowledge of any script- or programming language.

It goes without saying that you never need to touch any template files, because there are none in MultiToool. No worries, of course you can use external JavaScripts or stylesheets, we have a file management built in for this.

Live preview | Detail

Little Smile Multipurpose WordPress Theme

This theme is extremely flexible and user friendly. TurboEditor is advamced tool allowing unexperienced user create rich content pages in WordPress engine without a line of coding. Below is a screenshot of the admin panel

Live preview | Detail

United – Corporate, Business Portfolio WordPress Theme

United is a clean, modern and ultra-readable Premium WordPress Theme. It comes with a lot of features and intuitive options. It includes 6 Custom Widgets, 5 Color Schemes, 3 Custom Portfolio Layouts, Featured slider with around 30 Transitions, sitemap template, and much more..

Live preview | Detail

Project Management By WordPress Plugins:


There are lot of tutorials published about using WordPress as a project management application you can find on following list and there are Plugins for that.

Using WordPress as a Project Management App
How To Use A Self-Hosted WordPress Blog For Project Management
Project or Task Management in WordPress with CollabPress
Project and Task Management for WordPress and WPMU

CollabPress Plugin

The CollabPress plugin builds basic project management, such as task assignments and due dates, into
the dashboard screens. The plugin includes e-mail notifications for newly assigned tasks, and it places a widget on the Dashboard displaying recent activity.

Download: CollabPress | Author Homepage

ProjectManager

This plugin is a datamanager for any recurrent datasets. It can be used to manage and list a DVD collection, to to present portraits (e.g. athlets of a team), simple tabular calendar or anything you can think of. Below is a least of features

Features

  • add as many different projects as you want to
  • widget for any project, controlled via admin panel
  • adding of form fields (text, textfield, e-mail, date, url, selection, checkbox and radio list) for each project independently
  • simple search of any form field and category names
  • template system to easily customize frontend display
  • Ajax enabled editing of datasets
  • easy adding of shortcodes via TinyMCE Button
  • change colorscheme for output tables via admin panel
  • dataset sorting by any form field
  • import and export of datasets from/to CSV file
  • hook projects into user profile
  • manual drag & drop sorting of datasets

Randy Hoyt created a Screencast on the usage of ProjectManager.

Download

Ndizi Project Management

Ndizi lets you select a front-end page of your site, where your clients can authenticate and view their details, invoices, projects (including time totals for each, but not the individual time reports), and each task (with status) assigned to their projects. They can also add new tasks, which are then added to the back end for you to modify, clarify, and assign as-needed

Download

WP-Project

The WordPress administrative interface is friendly and comfortable. For web designers and developers, there is no better place to spend your time. Instead of having to visit several disparate websites to manage your projects and project progress, why not do it from the WordPress interface?

WP-Project provides many of the capabilities you’d expect to see from any standard project management solution. Currently, these capabilities include the following:

  • Track clients
  • Track projects by client
  • Track tasks by project
  • Track time per task with dynamic timer like Harvest

Download

Other Resources:

Premium WordPress Themes
Genesis Framework for WordPress
WordPress for Project Management
Using WordPress for Project Management
8 Steps to Using WordPress for Project Management
Can WordPress Be A Project Management App?
15+ Amazing Project Management and Collaboration Tools
WordPress for Project Management: It’s much easier with WordPress 3.0+
The Thesis Theme framework is a premium template system for WordPress that is designed to serve as the rock-solid foundation beneath any kind of website.

Free & Professional WordPress Security Service Free & Professional WordPress Security Service

We Love WordPress. WordPress Arena is a place for WordPress Developers and Designers, providing Tips, tricks, tools and resources to build a website or blog on WordPress. We also present The WordPress Showcase for all kind of WordPress Powered Websites.

Recent Comments

Anderson

|

Dont work with post_type? ‘post_type=property&numberposts=1′