There are a lot of tables in any wordpress installation, in order to reset user password password we have follow some simple steps as :

Step 1

Find out your wp_user table.

Step 2

Find out user_pass column, then locate the ID for which you want to reset password.

Step 3

Delete the existing password.

Step 4

Type your new password in any file (say notepad). Convert MD5 of this string from any web sites and then after computing MD5 paste the string here (user_pass) and you are done.

get cat name() : Retrieve the name of a category from its ID.

Usage

<?php 
    get_cat_name( $cat_id ) 
?> 

Example (On category.php page)

<?php
    // cat is by default category id on category.php page, no need to define this in previous lines
    echo get_cat_name($cat); 
?> 

in your archive.php, find the code:

if (have_posts()) : while (have_posts()) : the_post();

and replace it with:

$cat_posts = new WP_Query($query_string."&orderby=title&order=ASC");
if ($cat_posts->have_posts()):
    while($cat_posts->have_posts()):
        $cat_posts->the_post();

posts_per_page= is used to limit the number of posts that are retrieved by query_posts() wordpress loop

Example :

query_posts ( 'cat=3&posts_per_page=6' ); // posts_per_page

if (have_posts ()):

	while (have_posts()):
	
		the_post ();
		the_title (); // printing title of post
		
		echo "On " . the_time ( 'F jS, Y' ); // printing time of post
		 
	endwhile;
	
 endif;

Our task is to remove footer version that is displayed on the admin login as :

Step 1 : Go to : <Your project root directory>\wp-admin\includes\update.php > find a switch statement

switch ($cur->response)
{
	case 'development' :
		return sprintf ( __ ( 'You are using a development version (%1$s). 
				Cool! Please <a href="%2$s">stay updated</a>.' ), 
		get_bloginfo ( 'version', 'display' ), network_admin_url ( 'update-core.php' ) );
		break;
	
	case 'upgrade' :
		return sprintf ( '<strong>' . __ ( '<a href="%1$s">Get Version %2$s</a>' ) . '</strong>', 
		network_admin_url ( 'update-core.php' ), $cur->current );
		break;
	case 'latest' :
	default :
		return sprintf ( __ ( 'Version %s' ), 1.0 );
		break;
}

Step 2: Remove or comment the lines

switch ($cur->response)
{
	case 'development' :
		return sprintf ( __ ( 'You are using a development version (%1$s). 
				Cool! Please <a href="%2$s">stay updated</a>.' ), 
		get_bloginfo ( 'version', 'display' ), network_admin_url ( 'update-core.php' ) );
		break;
	
/*	case 'upgrade' :
		return sprintf ( '<strong>' . __ ( '<a href="%1$s">Get Version %2$s</a>' ) . '</strong>', 
		network_admin_url ( 'update-core.php' ), $cur->current );
		break;
*/		
	case 'latest' :
	default :
		return sprintf ( __ ( 'Version %s' ), 1.0 );
		break;
}

The WordPress user feature could be confusing for some of us in the beginning. Therefore, to remain effective and efficient, it is paramount to understand the different roles that are available when creating users and defining their capabilities. There are different types of users in WordPress. WordPress offers default roles in the form of Administrator, Editor, Author, Contributor and Subscriber. You can also add a new user and assign him custom roles. The role defines a list of things that the person is allowed to do and is known as the capabilities of the role.
 

Default Setup

The default setup offers six roles with capabilities up to 57. The roles offer several combinations showing the rights/privileges given to the role.
 

Super Administrator

This is the role having the maximum capability. The super administrator can manage multiple blogs from the same domain and can oversee the whole network. They can also be known as the Network Administrator and they are responsible for themes, network users, the network options and the site as a whole.
 
They have access to the blog network administration features. They can use the Network Admin sites screen for reviewing and managing different sites that form part of the network. From this screen, the Super Administrator can also access themes and setting for all the sites on the network. With the help of the Add New Sites Screen, they can add new sites to the network. With the help of the network Admin themes screen, the super administrator can control the themes used for each site. They can activate or deactivate a theme used by a site in the network. When they disables one theme, it can remain selected and if another theme is selected, the disabled theme will be removed from the Site Appearance Theme. This user role is best reserved for owners of sites, chief editors and webmasters.
 

Administrator

In case of a network of sites, an administrator can be considered as a second in command to the Super Administrator. In case the person has only one site to manage, the administrator will be the one holding the ultimate authority, as there is no need of networking abilities and a super administrator. The administrator of a single site manages the themes, the users, and the plugins, updating them whenever necessary as well as editing and importing or exporting of data from the dashboard. The role of the administrator can differ in a single site and in multiple site installations (network). However, all administrators have the following capabilities.
 
Activating plugins, creating users, deleting others’ pages, deleting plugins and posts or private pages and private posts; they can also delete a published page; delete or create users and also edit the dashboard, files, pages, posts, private pages, published pages and posts and edit themes and options. They have the permission to export and import content and manage categories, links and options. The administrator can moderate comments and promote users. They can publish and read private pages and switch themes or upload files.
Administrators of single site installations have additional capabilities, which are available only to Super Administrators in multiple sites. These are updating core, plugins and themes; installing, deleting, editing themes and plugins and editing users.
 

Editor

This role is below the Administrator. The role of the editor is somewhat similar to the editor of a magazine or a newspaper. They can edit the content and create new content. They also has the permission to moderate comments and reply to comments. They has the power to edit categories and links. In case there is no network of sites, but just a single site, the editor is also in charge of handling the everyday tasks.
An editor can delete others’ pages, posts, private pages and posts and published posts. They can also edit others’ posts and pages as well as private posts and published pages. They can manage categories, links and moderate comments. They have the permission to publish pages and posts and read private posts and pages as well as upload files.
 

Author

The author is also a person who can create content, manage it and publish it. However, the author cannot create the pages of the blog or website but only the posts. The difference between an author and an editor should be clearly understood. An author can only make changes and modify their own content, whereas the editor can modify their content as well as the content of any other author. Authors are also given the permission for uploading images, files and other additional material on the site or blog. The author can delete published posts and edit posts. They can read posts and upload files.
 

Contributor

A contributor is a role that has the capability of adding new content. They are given access to a certain part of the dashboard. This is usually the Add New Posts area. Though they have the permission to submit their content, they cannot publish it directly, as the publishing work has to be done by the author or the editor after they review the contributor’s work. The contributor can edit, delete and read posts.
 
Do you accept guest posts on your blog? If so, the WordPress contributor role is very useful. It is the best role for guest posts, as the role of the author includes publishing posts and review posts and you don’t want to give this permission to guest posts. A contributor cannot add images to their post. However, they can add images by the use of a HTML code and then link it to the image hosted at another place. Contributors can also see posts in the dashboard. If the person is someone that you trust, you can also give him or her more rights and permissions. They can even run the guest posting on the blog, but if the person is a onetime guest post, it is better to stick with the contributor’s role.
 

Subscriber

The audience to the website or blog constitutes the subscriber. They cannot do anything on the site without first registering at the site. Once they have registered at the site, they can have access to the content on the site and even leave a comment. They, however, cannot make any changes or modifications to the content. Nevertheless, you can allow subscribers to see private posts and pages with additional plugins and coding.
 

Conclusion

WordPress has offered roles as an integral part of the installation. Such roles allow easy setup of different types of users, which are available as default or as customized. The default user roles consist of the Super Administrator, Administrator, Editor, Author, Contributor and Subscriber. User roles and capabilities are important, especially where there are many people working on and around a blog. They make the sites more manageable, efficient and sustainable.