Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
Dispatch_ans_script_setup.php	5.95 KB	-rwxr-xr-x
FormulaEvaluate.php	14.47 KB	-rwxr-xr-x
MarkEntry-Setup.php	23.48 KB	-rwxr-xr-x
MarkEntry-Setup06062012.php	20.42 KB	-rwxr-xr-x
MarkEntry-Setup140911.php	20.42 KB	-rwxr-xr-x
MarkEntry-Setup26062012.php	21.11 KB	-rwxr-xr-x
TarkaFormatStyles.php	15.87 KB	-rwxr-xr-x
TarkaFormatStyles_old.php	3.82 KB	-rwxr-xr-x
absent_entry_setup.php	7.83 KB	-rwxr-xr-x
ack_rv_rt_application.php	7.55 KB	-rwxr-xr-x
ack_rv_rt_application_before_l...	6.12 KB	-rwxr-xr-x
actClass.php	6.38 KB	-rwxr-xr-x
admission_entry_status.php	2.79 KB	-rwxr-xr-x
auto-complete.php	5.04 KB	-rwxr-xr-x
backup_restore.php	8.36 KB	-rwxr-xr-x
backupandrestore.php	10.43 KB	-rwxr-xr-x
cManualMailer.php	2.63 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
candidate-entry.php	42.39 KB	-rwxr-xr-x
candidate-entry_before_auto_fe...	35.53 KB	-rwxr-xr-x
candidate-entry_beforeyearexam...	33.84 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
challan_entries.php	13.59 KB	-rwxr-xr-x
challan_preparation.php	10.47 KB	-rwxr-xr-x
cmailer.php	6.96 KB	-rwxr-xr-x
college_degree_status.php	5.98 KB	-rwxr-xr-x
coutput.php	1.83 KB	-rwxr-xr-x
create_all_grid_files.php	8.8 KB	-rwxr-xr-x
create_all_grid_group_files.ph...	10.18 KB	-rwxr-xr-x
create_all_grid_group_files_ol...	9.85 KB	-rwxr-xr-x
create_all_popup_files.php	6.08 KB	-rwxr-xr-x
create_all_schema_files.php	4.42 KB	-rwxr-xr-x
create_all_views.php	16.87 KB	-rwxr-xr-x
create_html_files.php	52.9 KB	-rwxr-xr-x
create_html_files_without_tab....	45.23 KB	-rwxr-xr-x
create_module_meta_columns.php	5.26 KB	-rwxr-xr-x
crequestbroker.php	2.58 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
custom_mregistry.php	124 B	-rwxr-xr-x
datadictionary.php	4.06 KB	-rwxr-xr-x
display_details_in_grid.php	98.69 KB	-rwxr-xr-x
display_details_in_grid_before...	100.84 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.79 KB	-rwxr-xr-x
display_details_in_grid_studta...	99.65 KB	-rwxr-xr-x
download_upload.php	4.22 KB	-rwxr-xr-x
dynamicmastersdetails.php	120.21 KB	-rwxr-xr-x
dynamicmastersdetails_23.php	122.84 KB	-rwxr-xr-x
dynamicmastersdetails_one.php	122.19 KB	-rwxr-xr-x
entryexitevents.php	3.19 KB	-rwxr-xr-x
execute_query.php	2.59 KB	-rwxr-xr-x
export_import_setup.php	7.8 KB	-rwxr-xr-x
export_import_utility.php	2.75 KB	-rwxr-xr-x
format.php	7.76 KB	-rwxr-xr-x
freeze_Ad_Cl_Me.php	6.81 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.83 KB	-rwxr-xr-x
freeze_module_at_admin_college...	5.94 KB	-rwxr-xr-x
freeze_module_at_university_co...	7.61 KB	-rwxr-xr-x
general_report_format.php	11.33 KB	-rwxr-xr-x
getAutoCompleteFromFrameWork.p...	3.05 KB	-rwxr-xr-x
getdata.php	20.96 KB	-rwxr-xr-x
getdata110911.php	16.47 KB	-rwxr-xr-x
getdata14062012.php	17.27 KB	-rwxr-xr-x
getdata_before_auto_fee.php	17.27 KB	-rwxr-xr-x
getmoduledetails.php	24.23 KB	-rwxr-xr-x
getnumword.php	7.82 KB	-rwxr-xr-x
getreportdetails.php	3.29 KB	-rwxr-xr-x
getreportfilefordisplay.php	1.43 KB	-rwxr-xr-x
getsearchcondition.php	1.37 KB	-rwxr-xr-x
ggridmodel.php	9.59 KB	-rwxr-xr-x
golden_palm_payslip.php	12.86 KB	-rwxr-xr-x
helptext.php	5.54 KB	-rwxr-xr-x
identify_transactions.php	6.56 KB	-rwxr-xr-x
json.php	34 KB	-rwxr-xr-x
login.php	3.29 KB	-rwxr-xr-x
login.php_1	3.25 KB	-rwxr-xr-x
login_old.php	2.92 KB	-rwxr-xr-x
message_board.php	4.81 KB	-rwxr-xr-x
module_setup.php	2.56 KB	-rwxr-xr-x
mregistry.php	52.08 KB	-rwxr-xr-x
mregistry_before_auto_fee.php	52.45 KB	-rwxr-xr-x
mrn_approval.php	9.24 KB	-rwxr-xr-x
receive_rv_rt_application.php	7.78 KB	-rwxr-xr-x
report_setup.php	25.56 KB	-rwxr-xr-x
report_tool.php	74.93 KB	-rwxr-xr-x
revaluation.php	16.95 KB	-rwxr-xr-x
room_allotment.php	7.23 KB	-rwxr-xr-x
sendLoginPassword.php	3.2 KB	-rwxr-xr-x
serchbygrid.php	868 B	-rwxr-xr-x
student_entry.php	31.1 KB	-rwxr-xr-x
student_entry2005.php	31.1 KB	-rwxr-xr-x
system_utility.php	1.89 KB	-rwxr-xr-x
systemsetup.php	78.57 KB	-rwxr-xr-x
transaction-series.php	4.99 KB	-rwxr-xr-x
update_defined_flag.php	3.5 KB	-rwxr-xr-x
uploadmoduledetails.php	40.61 KB	-rwxr-xr-x
usersetup.php	24.63 KB	-rwxr-xr-x

Code Editor : backup_restore.php

<?php
/*Author : M.Srikanth   
    Date    :  2009-07-13
    Project : paycheck
    Description :  This class is for to backup db
*/

//Start :  'backup_restore'  Class

class backup_restore
	{
	  	
		//Start :  Constructor
	           function __construct($aobj_context)
	              {
		              session_start();
		              $this->aobj_context=$aobj_context;
		              $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
					   $this->user_id = $_SESSION['user_id'];
					   $this->BackupSetup();
		           }
		//End : Constructor 
		
				
		        /* This function is for to get market modules names*/
				function BackupSetup()
				{
				 $get_data ="select suse.internal_code,concat('module_',ref_s_user_schema_code) as table_name,
								name,system_name,db_field,concat('module_',ref_module_code) ref_module_table,
								if(ref_s_user_schema_group_code>0,
								concat('user_schema_',ref_s_user_schema_code,'_group_',ref_s_user_schema_group_code),0) as group_table
								from s_user_schema_elements suse inner join
								s_user_schema sus on sus.internal_code=ref_s_user_schema_code
								where module_name='BackUp Setup'";
			
			$lobj_get_data = $this->aobj_context->mobj_db->GetAll($get_data);
			
			foreach($lobj_get_data as $key=>$value)
					{
							if($value[system_name]=='backup_storage_path')
							{
							$this->backup_setup_backup_storage_path=$value[db_field];
							$this->backup_setup_table=$value[table_name];
							}		
							else if($value[system_name]=='mysql_path')
							{
							$this->backup_setup_mysql_path=$value[db_field];
							}					
					}
				}
		         
              function createBackupDb()
                {
                  include_once($this->aobj_context->main_src.'/config.php');
				  $confg_obj=new CConfig();
				 	 $dbhost = $confg_obj->mstr_host;
				     $dbuser =$confg_obj->mstr_user;
				     $dbpass =$confg_obj->mstr_password;
				     $db_name =$confg_obj->mstr_db;
				       if($dbpass == '')
				        $pass_field = "";
				     else
                        $pass_field = " -p";			  
					$get_paths = "select internal_code,{$this->backup_setup_backup_storage_path} as folder_path,
				                            {$this->backup_setup_mysql_path} as mysql_path
					                        from {$this->backup_setup_table} ";
					 $lobj_get_paths = $this->aobj_context->mobj_db->GetRow($get_paths);
			 
						$folder_path = $lobj_get_paths[folder_path];
						$mysql_path = $lobj_get_paths[mysql_path];
                        
				 		system(mkdir($folder_path.date("Ymd")));	 	     		
                     	$folder_path=$folder_path.date("Ymd")."\\";		
						
						$backupFile = $db_name .'_'. date("Ymd").'.sql';
						$command = "{$mysql_path}mysqldump --opt -h {$dbhost}  -u {$dbuser}{$pass_field}{$dbpass} {$db_name}  > {$folder_path}{$backupFile}";
						 //echo $command;
						system(($command),$retval);
	                 }
					 
					function getZipBackup()
					{
					 include_once($this->aobj_context->main_src.'/config.php');
					 	$easy_zip_file_path=$this->aobj_context->main_src."/easy_zip/easy_zip.php";
						require_once($easy_zip_file_path);
					$confg_obj=new CConfig();
				 	 $dbhost = $confg_obj->mstr_host;
				     $dbuser =$confg_obj->mstr_user;
				     $dbpass =$confg_obj->mstr_password;
				     $db_name =$confg_obj->mstr_db;
				       if($dbpass == '')
				        $pass_field = "";
				     else
                        $pass_field = " -p";
						$get_paths = "select internal_code,{$this->backup_setup_backup_storage_path} as folder_path,
				                            {$this->backup_setup_mysql_path} as mysql_path
					                        from {$this->backup_setup_table} ";
					 $lobj_get_paths = $this->aobj_context->mobj_db->GetRow($get_paths);
			 
						$folder_path = $lobj_get_paths[folder_path];
						$mysql_path = $lobj_get_paths[mysql_path];
						
						$zip_path= $this->aobj_context->main_src."/imported_files/inventory_db_".date("Ymd").".sql";
						$command = "{$mysql_path}mysqldump --opt -h {$dbhost}  -u {$dbuser}{$pass_field}{$dbpass} {$db_name}  > {$zip_path}";
						system(($command),$retval);
						$zipobj = new EasyZIP;
						$zipobj -> addFile($zip_path);						 
						$zipobj -> zipFile("{$zip_path}.zip");	 
						header("Expires: 0");
						header("Content-type: application/zip");
						header("Content-Disposition: attachment; filename=$db_name.zip");
						print file_get_contents($zip_path.".zip");
						 unlink(("{$zip_path}.zip"));
						 unlink($zip_path);
						
					}	
                 function restoreBackupDb()
                {

include_once($this->aobj_context.'/config.php');
					$confg_obj=new CConfig();
				 	 $dbhost = $confg_obj->mstr_host;
				     $dbuser =$confg_obj->mstr_user;
					 $dbpass =$confg_obj->mstr_password;
					   $db_name =$confg_obj->mstr_db;
				     if($dbpass == '')
				      $pass_field = "";
				     else
                     $pass_field = " -p";	
					  $get_paths = "select internal_code,{$this->backup_setup_backup_storage_path} as folder_path,
				                            {$this->backup_setup_mysql_path} as mysql_path
					                        from {$this->backup_setup_table} ";
					 $lobj_get_paths = $this->aobj_context->mobj_db->GetRow($get_paths);
			  
						$folder_path = $lobj_get_paths[folder_path];
						$mysql_path = $lobj_get_paths[mysql_path];                  
						  
						   $backupFile = $db_name .'_'. $this->inputdate.'.sql';
						   $file_path = $folder_path.$this->inputdate.'\\'.$backupFile;
						    if(!file_exists($file_path)) 
						    return $db_name;

$view_path=$this->aobj_context->main_src."/src/create_all_views.php";
							include_once($view_path);
						
 						    $backupFile = $db_name .'_'. $this->inputdate.'.sql';
							$file_path = $folder_path.$this->inputdate.'\\'.$backupFile;							 
						   if(file_exists($file_path)) 
						   {
						     $create_db = "create database  if not exists {$db_name} ";
							 		 							 
							 $lobj_create_db = $this->aobj_context->mobj_db->execute($create_db);					 
						      
							 $command = "{$mysql_path}mysql -u $dbuser {$pass_field}{$dbpass} {$db_name} < {$file_path}";
	                         
							// echo $command;
							// die();
							 
							 system($command);
							 CreateView($this->aobj_context);							
							}                           				
					     
					return 0;	
                }				
		 	  		
		
   }
 
//End :  Class file

$restore_db_result = $class_obj->restoreBackupDb(); 
		if(!empty($restore_db_result))
		{
		$data = $restore_db_result . " database file not found";
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"Success");
		}
		else if($restore_db_result == 0)
		{
		// $data = "Database is restored successfully";
		// echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"Success");
		}
	 }
	 
//End :  uploadMarketDeatilsIntoDB()

${this.title}

Code Editor : backup_restore.php