name = "My login process module"
description = "Performs login process"
core = "7.x"
version ="7.x.1.0"
package = "Login/Register"`

<?php

/*
*Implements hook permission
*/


function login_process_hook_permission()
{
 return array(
    'submit login_process' => array(
      'title' => t('Submit login form'),
      'description' => t('Submit the login form')
    ),
  );
}

/*
* Implements hook menu
*/

function login_process_hook_menu() {
  $items = array();
    $items['login-process'] = array(
  'title' => 'login',
  'type' => 'MENU_NORMAL_ITEM',
  'access arguments' => array('submit login_process'),
    'page callback' => 'drupal_get_form',
    'page arguments' => array('login_process_form')
    );
    return $items;
}

/*
* The login form
*/

function login_process_form($form,&$form_state)
{
  $form['Username'] = array(
  '#type' => 'textfield',
  '#title' => t('Username'),
  '#size' => 20,
  '#maxlength' => 20,
  '#required' => TRUE,
  '#description' => t('Please enter a valid username'),
  );

  $form['Password'] = array(
  '#type' => 'textfield',
  '#title' => t('Password'),
  '#size' => 20,
  '#maxlength' => 20,
  '#required' => TRUE,
  '#description' => t('Please enter a valid password'),
  );
  $form['submit'] = array(
  '#type' => 'submit',
  '#value' => t('Add item')

  );
  return $form;
}
/*
* Validation handler for the login_process_form
*/

function login_process_form_validate($form,&$form_state)
{
  print('<pre>'.print_r($form_state['values'],1).'<pre>'); die();
  if (!preg_match("/[a-zA-Z]/",$form_state['values']['Username']))
  {
    form_set_error('Username', t('Username must contain only alphabets'));
    return FALSE;
  }
  return TRUE;
  //add more validations for Username and Password
}

/*
*Submit handler for the login form
*/

function login_process_form_submit($form,&$form_states)
{

  $username = $form_state['values']['Username'];
  $password =  $form_state['values']['Password'];
  $results = db_query("SELECT Username,Password FROM user WHERE Username='".$username."' AND Password='".$password."'"));
  if(is_null($results))
  {
    form_set_error('Username', t('Wrong username or password. Try again!!!!'));
    return FALSE;
  }
  else
  {
  echo "Welcome".$form_state['values']['Username']."<a href="logout.php">Logout</a>" // it will be better if it is displayed in a block
  }
}

$account = db_query("SELECT * FROM {users} WHERE name = :name AND status = 1", array(':name' => $form_state['values']['name']))->fetchObject();

function login_process_form_alter(&$form, $form_state, $form_id) {
  if ($form_id == 'user_login_block' || $form_id == 'user_login') {
    $form['#validate'][] = '_login_process_form_validate';
    $form['#submit'][] = '_login_process_form_submit';
  }
}

function _login_process_form_validate($form, &$form_state) {

}


function _login_process_form_submit($form, &$form_state) {

}