EVOLUTION-NINJA

Edit File: my_account_ctrl.php

<?php class my_account_ctrl extends Controller 
{
function my_account_ctrl()
	{
		parent::Controller();
		$this->load->model('camp_overview_model','',TRUE);
		$this->load->model('keywords_model','',TRUE);
		$this->load->model('aff_campaigns_model','',TRUE);
		$this->load->model('aff_networks_model','',TRUE);
		$this->load->model('campaign_setup_model','',TRUE);
		$this->load->model('ppv_accounts_model','',TRUE);
		
		$this->load->model('user_model','',TRUE);
		$this->load->helper(array('text','form','date','url','session','common','error','admin','db','crypto', 'simplexml_load_url_curl'));
		$this->load->library(array('user_entry','validation','form_validation','session'));
		
	}
	function index()
	{
		$table['user_id']=$this->user_entry->get_user();
		$data['ppv_nws']=$this->ppv_accounts_model->get_ppv_nws($table['user_id']);
		$data['aff_nws']=$this->aff_networks_model->get_aff_nws($table['user_id']);
		$data['ppv_accs']=$this->ppv_accounts_model->get_ppv_accs($table['user_id']);
		$data['aff_cps']=$this->keywords_model->get_aff_cps($table['user_id']);
		$table['user_id']=$this->user_entry->get_user();
		$data['ppv_nws']=$this->ppv_accounts_model->get_ppv_nws($table['user_id']);
		$data['aff_nws']=$this->aff_networks_model->get_aff_nws($table['user_id']);
		$data['ppv_accs']=$this->ppv_accounts_model->get_ppv_accs($table['user_id']);
		$data['aff_cps']=$this->keywords_model->get_aff_cps($table['user_id']);
		$data['display']=$this->keywords_model->get_display();
		$data['byday']=$this->keywords_model->get_user_pref_breakdown();
		$data['pref_chart']=$this->keywords_model->get_user_pref_chart();
		$data['show']=$this->keywords_model->get_user_pref_show();
		$data['cpc_or_cpv']=$this->keywords_model->get_user_cpc_or_cpv();
		$data['pre']=$this->keywords_model->get_user_pref_time_predefined();
		
			/*$id=$table['user_id'];
		 $qury="select user_email from pd_users where user_id = '$id'";
		$res=mysql_query($qury);
		$r=mysql_fetch_array($res);
		$emails=$r[0];*/
		$ver['version']=$this->user_model->get_version();
		
		$this->load->view('myaccount',$ver);
	}
	function add_new_user()
	{
		
		$data['user_name']=$this->input->get('uname',true);
		$data['user_email']=$this->input->get('user_email',true);
		$pwd=$this->input->get('pwd',true);
		
		$data['user_timezone']=$this->input->get('user_timezone',true);
		
		$data['user_pass']= sha1($pwd);
		$this->db->insert('pd_users', $data);
		$userid=$this->db->insert_id();
		$qry1="insert into pd_users_pref (user_id) values ('$userid')";
		mysql_query($qry1);
		
	}
function update_subid()
{
	//echo "update_subid";
	$subid=$_POST['subid'];
	$pwd=$_POST['sub_pwd'];
	$data['user_pass']=sha1($pwd);
	/*$fields["subid"]	= 'subid';
	$rules["subid"] = "required";*/
	
	$fields["sub_pwd"]	= 'password';
	$rules["sub_pwd"] = "required";
	
	$this->validation->set_rules($rules);
    $this->validation->set_fields($fields);
	$this->validation->set_error_delimiters('<div id="error" name="error"><font color=red >', '</font></div>');
		
		if ($this->validation->run() == FALSE)
		{
			//echo "val";
			$this->load->view('myaccount');
		}
	
	
	
 	else{
			
			$user_id=$this->user_entry->get_user();
			$qury="select user_pass from pd_users where user_id = '$user_id'";
			$res=mysql_query($qury);
			$r=mysql_fetch_array($res);
			if($r['user_pass']==$data['user_pass'])
			{
				$query1="update pd_users set user_subid= '$subid' where user_id = '$user_id'";
				mysql_query($query1);
				$data1['sub_success']=1;
				$data1['version']=$this->user_model->get_version();
				$this->load->view('myaccount',$data1);
			}
			else
			{
				 $data1['sub_err_msg']="0";
				 $data1['version']=$this->user_model->get_version();
				$this->load->view('myaccount',$data1);
			}
		}
}
function update_timezone()
{
	
	
		$pwd=$_POST['tz_pwd'];
		$user_pass=sha1($pwd);
		$data['user_timezone']=$_POST['LOCATION_ID'];
		if(isset($_POST['DST']))
		 $data['daylight']= $_POST['DST'];
		 $fields["tz_pwd"]	= 'password';
		$rules["tz_pwd"] = "required";
		$this->validation->set_rules($rules);
    $this->validation->set_fields($fields);
	$this->validation->set_error_delimiters('<div id="error" name="error"><font color=red >', '</font></div>');
		
		if ($this->validation->run() == FALSE)
		{
			//echo "val";
			$this->load->view('myaccount');
		}
		
		else
		{
		 
				 $table['user_id']=$this->user_entry->get_user();
				$id=$table['user_id'];
				 $qury="select user_pass from pd_users where user_id = '$id'";
				$res=mysql_query($qury);
				$r=mysql_fetch_array($res);
				
				if($r['user_pass']==$user_pass)
				{
					$this->db->where('user_id',$table['user_id']);
		
					$this->db->where('user_pass',$user_pass);
		
					$status=$this->db->update('pd_users', $data);
		
					$data['tz_success']="Profile Updated successfully";
		
					$data['version']=$this->user_model->get_version();
		
					$this->load->view('myaccount',$data);
		
				}
				else
				{
					
					$data1['tz_err']="Profile Updated successfully";
		
					$data1['version']=$this->user_model->get_version();
					$this->load->view('myaccount',$data1);
				
				}
		} 
		 
}
function hide_logo()
{
		if(isset($_POST['hide_logo']))
		 $data['hide_logo']= $_POST['hide_logo'];
		 else
		  $data['hide_logo']= 0;
		 $query=$this->db->get('pd_logo_status')->row();
		 if($query)
		 {
		 $this->db->where('id',1);
		 $status=$this->db->update('pd_logo_status', $data);
    	 $data['hl_success']="Profile Updated successfully";
		 $data['version']=$this->user_model->get_version();
		 $this->load->view('myaccount',$data);
	     } 
		 else
		 {
		 $this->db->set('id',1);
		 $status=$this->db->insert('pd_logo_status', $data);
    	 $data['hl_success']="Profile Updated successfully";
		 $data['version']=$this->user_model->get_version();
		 $this->load->view('myaccount',$data);
		 }
		 
}
function add_user()
{
			
			 $data['user_timezone']=$_POST['LOCATION_ID1'];
			 if(isset($_POST['DST1']))
			 $data['daylight']= $_POST['DST1'];
			 $data['user_name']= $_POST['uname1'];
			 $data['user_email']= $_POST['user_email1'];
			 $pwd1= $_POST['pwd1'];
			// $data['user_c_pass']= $_POST['cpwd1'];
			 
			 
			 
			 $fields["uname1"]	= 'User Name';
			 $rules["uname1"] = "required";
			 
			 $fields["user_email1"]	= 'User Email';
			 $rules["user_email1"] = "required|valid_email";
			 
			 $fields["pwd1"]	= 'Password';
			 $rules["pwd1"] = "required";
			 
			 $fields["cpwd1"]	= 'Confirm Password';
			 $rules["cpwd1"] = "required|matches[pwd1]";
		
			$this->validation->set_rules($rules);
   			 $this->validation->set_fields($fields);
			$this->validation->set_error_delimiters('<div id="error" name="error"><font color=red >', '</font></div>');
			if ($this->validation->run() == FALSE)
			{
			
				$this->load->view('myaccount');
			}
			
			else
			{
				
				$data['user_pass']= sha1($pwd1);
				$data['user_time_register']=time();
				$this->db->insert('pd_users', $data);
				
			
				$userid=$this->db->insert_id();
				
			    	 $query01="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'Traffic Vance', 0, 0);";
mysql_query($query01);
$nid1=mysql_insert_id();
 $query02="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'LeadImpact', 0, 0);";
mysql_query($query02);
$nid2=mysql_insert_id();
 $query03="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'Media Traffic', 0, 0);";
mysql_query($query03);
$nid3=mysql_insert_id();
 $query04="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'AdOnNetwork', 0, 0);";
mysql_query($query04);
$nid4=mysql_insert_id();
 $query05="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'DirectCPV', 0, 0);";
mysql_query($query05);
$nid5=mysql_insert_id();
 $query06="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'Linksador', 0, 0);";
mysql_query($query06);
$nid6=mysql_insert_id();
 $query07="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'CPV MarketPlace', 0, 0);";
mysql_query($query07);
$nid7=mysql_insert_id();
 $query08="INSERT INTO pd_ppv_networks ( user_id, aff_campaign_id, ppv_network_deleted, ppv_network_name, ppv_network_time, niche_id) VALUES
('$userid', 0, 0, 'CPV Findology', 0, 0);";
mysql_query($query08);
$nid8=mysql_insert_id();
$sql="INSERT INTO pd_ppv_accounts ( user_id, ppv_network_id, ppv_account_name, ppv_account_deleted, ppv_account_time, aff_campaign_id, niche_id, keyword, keyword_check) VALUES
( '$userid', '$nid8', 'Domestic', 0, 1295901729, 0, 0, '{keyword}', 0),
( '$userid', '$nid8', 'International', 0, 1295901742, 0, 0, '{keyword}', 0),
( '$userid', '$nid2', 'My Account', 0, 1295901753, 0, 0, '', 1),
( '$userid', '$nid3', 'My Account', 0, 1295901764, 0, 0, '', 1),
( '$userid',  '$nid6', 'My Account', 0, 1295904019, 0, 0, '{keyword}', 0),
( '$userid', '$nid5', 'Keyword Campaign', 0, 1295902114, 0, 0, '{{keyword}}', 0),
( '$userid', '$nid4', 'My Account', 0, 1295903948, 0, 0, 'SEARCHTEXT', 0),
( '$userid', '$nid5', 'Long Tail URL', 0, 1295902315, 0, 0, '{{vurl}}', 0),
( '$userid', '$nid5', 'Domain Only', 0, 1295902345, 0, 0, '{{sm_vurl}}', 0),
( '$userid', '$nid8', 'My Account', 0, 1295903161, 0, 0, '{{keyword}}{{vurl}}', 0),
( '$userid', '$nid7', 'My Account', 0, 1295905477, 0, 0, '', 1);";
 
mysql_query($sql);
			
				$qry1="insert into pd_users_pref (user_id) values ('$userid')";
				mysql_query($qry1);
				
				$query3="INSERT INTO pd_niche (niche_name, user_id, aff_campaign_id) VALUES
( 'Biz Ops', '$userid', 0),
( 'Health', '$userid', 0),
( 'Financial', '$userid', 0),
( 'Insurance', '$userid', 0),
( 'Dating', '$userid', 0),
( 'Beauty', '$userid', 0),
( 'Real Estate', '$userid', 0),
( 'Weight Loss', '$userid', 0),
( 'Legal', '$userid', 0),
( 'Fitness', '$userid', 0),
('Electronics', '$userid', 0),
( 'Gaming', '$userid', 0),
( 'Holidays', '$userid', 0),
( 'Gambling', '$userid', 0),
( 'Credit / Debit', '$userid', 0),
( 'test niche', '$userid', 0);";
mysql_query($query3);
				
				
				$data2['version']=$this->user_model->get_version();
				$data2['user_success']=$this->user_model->get_version();
				$this->load->view('myaccount',$data2);
				
						
			}
}
function user_pref()
	{
		$fields["nw_pwd"]	= 'Password';
		$rules["nw_pwd"] = "required";
		$fields["nw_cpwd"]	= 'Confirm password';
		$rules["nw_cpwd"] = "required|matches[nw_pwd]";
		$fields["email"]	= 'Email';
		$rules["email"] = "required|valid_email";
		$fields["subid"]	= 'Subid';
		$rules["subid"] = "numeric";
		$fields["old_pwd"]	= 'Old Password';
		$rules["old_pwd"] = "required";
		$this->validation->set_rules($rules);
        $this->validation->set_fields($fields);
		$this->validation->set_error_delimiters('<div id="error" name="error"><font color=red >', '</font></div>');
		
		if ($this->validation->run() == FALSE)
		{
			//echo "aaa";
			$this->load->view('myaccount');
		}
		
		
		else
		{
		$nw_pwd=$_POST['nw_pwd'];
$table['user_id']=$this->user_entry->get_user();
		$data['user_pass']=sha1($nw_pwd);
		
		$this->db->where('user_id',$table['user_id']);
		$row1 = $this->db->get('pd_users')->row();
		
		
		$data['user_email']=$_POST['email'];
		$nw_cpwd=$_POST['nw_cpwd'];
		$old_pwd=$_POST['old_pwd'];
		$o_pwd= sha1($old_pwd);
		$table['user_id']=$this->user_entry->get_user();
		$id=$table['user_id'];
		 $qury="select user_pass from pd_users where user_id = '$id'";
		$res=mysql_query($qury);
		$r=mysql_fetch_array($res);
		if($r['user_pass']==$o_pwd)
		{
		
		
		$apiURI_update= LIC_API_URL."?operation=update_db".
													"&licence_key=".$row1->license_key . 
													"&eMail=".$_POST['email'].
													"&password=".$data['user_pass'];
								
													$xml_update = simplexml_load_url_curl($apiURI_update);
			$this->db->where('user_id',$table['user_id']);
			$this->db->where('user_pass',$o_pwd);
			$status=$this->db->update('pd_users', $data);
			$data['msg']="Profile Updated successfully";
			$data['version']=$this->user_model->get_version();
			//redirect('my_account_ctrl');
			$this->load->view('myaccount',$data);
		}
		else
		{
		//echo $status;
		//$this->load->view('myaccount');
		//$query=mysql_query("insert into")
					$data['error']="please enter the correct old password";
					//echo $data['error'];
					$data['version']=$this->user_model->get_version();
		$this->load->view('myaccount',$data);
		}
		}
		
	}	
	function chech_subid($subid)
{
	$this->db->from('pd_clicks_counter');
	$this->db->select('MAX(click_id) as click_id');
	$query = $this->db->get('');
	$q=$query->row();
	$max= $q->click_id;
	if($max+1 > $subid)
	{
		$name_err="1";
		echo $name_err;
	}
	else
	{
		echo "0";
	}
}
	
function deactivate($id)
{
$data['active']=0;
$this->db->where('user_id',$id);
$this->db->update('pd_users',$data);
$this->session->set_flashdata('d_success','Account Deactivated Succesfully');
redirect('my_account_ctrl#6');
}
function reset_password($id)
{
$this->db->where('user_id',$id);
$data['row'] = $this->db->get('pd_users')->row();
$this->load->view('reset_password',$data);
}
function reset_pwd($id)
{
$data['user_pass']=sha1($_POST['pwd']);
$this->db->where('user_id',$id);
$this->db->update('pd_users',$data);
$this->session->set_flashdata('r_success','Password Reseted Succesfully');
redirect('my_account_ctrl#6');
}
}
?>