/ var / www / html / cai / application / models / [ HOME SHELL ]

Name	Size	Permission	Action
070623-Evnt_model.php	3.67 KB	-rwxr-x--x
15122022-Prod_model.php	4.71 KB	-rwxr-x--x
250123-Home_model.php	1.93 KB	-rwxr-x--x
Blog_model.php	2.88 KB	-rwxr-x--x
Content_model.php	21.72 KB	-rwxr-x--x
Crose_model.php	10.52 KB	-rwxr-x--x
Crosej_model.php	10.52 KB	-rwxr-x--x
Evnt_model.php	3.67 KB	-rwxrwxrwx
Fun_model.php	11.14 KB	-rwxr-x--x
Gblsetup_model.php	61.64 KB	-rwxr-x--x
Home_model.php	5.04 KB	-rwxr-x--x
Itmsetup_model.php	6.27 KB	-rwxr-x--x
Jobc_model.php	10.52 KB	-rwxr-x--x
Login_model.php	4.03 KB	-rwxr-x--x
Mdc_model.php	10.21 KB	-rwxr-x--x
Mems_model.php	3.09 KB	-rwxr-x--x
Pages_model.php	6.04 KB	-rwxr-x--x
Prod_model.php	4.99 KB	-rwxr-x--x
Proj_model.php	10.59 KB	-rwxr-x--x
Publ_model.php	6.72 KB	-rwxr-x--x
Stat_model.php	7.25 KB	-rwxr-x--x
User_model.php	11.63 KB	-rwxr-x--x
Wrks_model.php	10.52 KB	-rwxr-x--x
index.html	131 B	-rwxr-x--x

Code Editor : Login_model.php

<?php
class Login_model extends CI_Model {

public function __construct()
	{
			parent::__construct();
	}
	public function LoginCheck($uv_USERNAME,$uv_USERPASS)
	{
		$uv_USERPASS = md5($uv_USERPASS);
		$sql = "USERNAME='".$uv_USERNAME."' AND USERPASS='".$uv_USERPASS."' AND UTYPE<>'".USR_USR."' AND STATUS='".STATUS_A."'";
		$this->db->select('*');
		$this->db->from($this->data['TBL']['LGN']);
		$this->db->where($sql);
        $query = $this->db->get();
		$total = $query->num_rows();
		if($query->num_rows() == 1)
		{
			$row = $query->row();
			if($this->fm->fldVal($this->data['TBL']['USR'],'PRPIC',"UID='".$row->UID."'")!='' && $row->UID!=1) 
			{
				 $USER_PIC = base_url().DIR_USR.'/'.DIR_STN.'/'.$this->fm->fldVal($this->data['TBL']['USR'],'PRPIC',"UID='".$row->UID."'");
			}
	        else
			{
			  $USER_PIC = base_url().DIR_UPLOAD.DFAULT_IMG;
			}
			$data = array(
						'dv_ID'=>$row->ID,
						'dv_UID'=>$row->UID,
						'dv_EMAIL'=>dbOut($row->EMAIL),
						'dv_USERNAME'=>$row->USERNAME,
						'dv_USERPASS'=>$row->USERPASS,
						'dv_UTYPE'=>$row->UTYPE,
						'dv_PRPIC'=>$USER_PIC,
						'dv_FNAME'=>$this->fm->fldVal($this->data['TBL']['USR'],'FNAME',"UID='".$row->UID."'"),
						'dv_LNAME'=>$this->fm->fldVal($this->data['TBL']['USR'],'LNAME',"UID='".$row->UID."'"),
						'session_id'=>session_id(),
						'LOGGEDIN'=>TRUE);
			$this->session->set_userdata($data);
			if ($this->agent->is_browser())$agent = $this->agent->browser().'('.$this->agent->version().')';
			elseif ($this->agent->is_robot())$agent = $this->agent->robot();
			elseif ($this->agent->is_mobile())$agent = $this->agent->mobile();
			else $agent = 'Unidentified User Agent';
			$Logdata = array('UID' =>$row->UID,
							'LOGIN' =>DB_IN_DT,
							'LOGOUT' =>'',
							'OS' =>CaseU(dbOut($this->agent->platform())),
							'BROWSER' =>CaseU(dbOut($agent)),
							'SYSNAME' =>gethostname());
			$dv_LOG_ID =$this->fm->addId($this->data['LOG']['LGN'],$Logdata);
			$this->session->set_userdata('dv_LOG_ID', $dv_LOG_ID);
			return TRUE;
		}
		else
		 return FALSE;
	}
	public function GenPwdChngCode($Email,$Mobile=9836489468)
	{
	$this->db->select('*');
	$this->db->from($this->data['TBL']['PWD']);
	$this->db->where('Email', $Email);
	$this->db->where('Status',STATUS_A);
	$query = $this->db->get();
	if($query->num_rows() <= 0)
	{
		$EndDate = date("Y-m-d H:i:s", strtotime('+1 hours'));
		$Code = rand(000000,999999);
		$data = array(
		'Type' =>1,
		'Email' => $Email,
		'Mobile' => $Mobile,
		'Code' =>$Code,
		'Start' =>date('Y-m-d H:i:s'),
		'End' =>$EndDate,
		'Status' =>STATUS_A);
		$this->db->insert($this->data['TBL']['PWD'], $data);
		if($this->db->affected_rows()==1)
		{
		$Id = $this->db->insert_id();
		//$this->fm->emailSentConfig(PWD_RQST,"mId='".$mId."'",'','',$Email,$Code);
		return TRUE;
		}
		else return FALSE;	
	}
	else
	{
	$EndDate = date("Y-m-d H:i:s", strtotime('+1 hours'));
	$Code = rand(000000,999999);
	$data = array(
	'Code' =>$Code,
	'Start' =>date('Y-m-d H:i:s'),
	'End' =>$EndDate,
	'Status' =>STATUS_A);
	$this->db->where("Email='".$Email."' AND Mobile='".$Mobile."'"); 
	$this->db->update($this->data['TBL']['PWD'], $data);
	//$this->fm->emailSentConfig(PWD_RQST,"mId='".$mId."'",'','',$Email,$Code);
	return TRUE;
	}
	}
	public function fnYrTbls()
	{
	   $loginLogTbl='login_log_'.FnYr();
		if (!$this->db->table_exists($loginLogTbl))
		{
		  $lgnLogFlds = array(
					'ID' => array('type' => 'INT','constraint' =>10,'auto_increment' => TRUE),
					'UID' => array('type' => 'INT','constraint' =>10),
					'LOGIN' => array('type' => 'DATETIME'),
					'LOGOUT' => array('type' => 'DATETIME'),
					'OS' => array('type' => 'VARCHAR','constraint' =>110),
					'BROWSER' => array('type' => 'VARCHAR','constraint' =>100),
					'SYSNAME' => array('type' => 'VARCHAR','constraint' =>110));
		$this->dbforge->add_field($lgnLogFlds);
		$this->dbforge->add_key('ID',TRUE);
		$this->dbforge->create_table($loginLogTbl,TRUE,array('ENGINE' => 'MyISAM'));
		}
	   return true;
	}	
}
?>

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.