Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
system	[ DIR ]	drwxr-xr-x
auto-complete.php	4.89 KB	-rwxr-xr-x
backup_restore.php	9.12 KB	-rwxr-xr-x
backupandrestore.php	10.18 KB	-rwxr-xr-x
cappcontext.php	3.19 KB	-rwxr-xr-x
cmailer_new.php	3.48 KB	-rwxr-xr-x
coutput.php	1.75 KB	-rwxr-xr-x
coutput_24042018.php	1.75 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
db_sync.php	7.54 KB	-rwxr-xr-x
display_custom_html.php	8.47 KB	-rwxr-xr-x
display_details_in_grid.php	71.04 KB	-rwxr-xr-x
display_details_in_grid_custom...	2.67 KB	-rwxr-xr-x
forgot_password.php	3.76 KB	-rwxr-xr-x
format.php	6.75 KB	-rwxr-xr-x
getnumword.php	6.19 KB	-rwxr-xr-x
header.php	306 B	-rwxr-xr-x
jsmin.php	10.69 KB	-rwxr-xr-x
json.php	33.22 KB	-rwxr-xr-x
login.php	6.76 KB	-rwxr-xr-x
mregistry.php	2.96 KB	-rwxr-xr-x
sendLoginPassword.php	3.11 KB	-rwxr-xr-x
send_mail.php	2.88 KB	-rwxr-xr-x
system_utility.php	4.71 KB	-rwxr-xr-x

Code Editor : system_utility.php

<?php
function ChangeTablesToInnoDB($aobj_context)
{
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$get_all_create_table="show TABLES";
	$lobj_get_all_create_table = $aobj_context->mobj_db->GetAll($get_all_create_table);
	foreach($lobj_get_all_create_table as $key=>$value)
			{
				foreach($value as $k=>$v)
				{
				 $table_name=$v;
				 $alter_table="alter table {$table_name} ENGINE=INNODB";
				$lobj_alter_table = $aobj_context->mobj_db->Execute($alter_table);   								
				}
			}
}
function TruncateEntryTables($aobj_context)
{
 
$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$get_all_create_table="SELECT CONCAT(system_module_table_name,'_',system_group_table_name,'_entry') AS entry_table
							FROM s_user_schema_group ug
							INNER JOIN s_user_schema s ON s.internal_code=ug.ref_s_user_schema_code
							 WHERE multiple=1";
	$lobj_get_all_create_table = $aobj_context->mobj_db->GetAll($get_all_create_table);
	foreach($lobj_get_all_create_table as $key=>$value)
			{
				$table_name=$value['entry_table'];
				$truncate_table="delete from  {$table_name} where login_cnt={$login_cnt}";
				$lobj_alter_table = $aobj_context->mobj_db->Execute($truncate_table);   								
				 
			}
	$get_gandhi_grid_tables="select concat('module_',internal_code,'_',{$login_cnt}) as tablename
							from s_user_schema where 
							grid_type='Ggrid'";	
		$lobj_get_gandhi_grid_tables = $aobj_context->mobj_db->GetAll($get_gandhi_grid_tables);		
		foreach($lobj_get_gandhi_grid_tables as $gk=>$gv)
			{
			$drop_table_name=$gv[tablename];
			$get_show_tables="show tables like '%{$drop_table_name}%'";
			$lobj_get_show_tables = $aobj_context->mobj_db->GetAll($get_show_tables);		
				foreach($lobj_get_show_tables as $sk=>$sv)
				{
					foreach($sv as $svk=>$svv)
					{
					 $lobj_alter_table = $aobj_context->mobj_db->Execute(" drop table {$svv}");   
					}
					 
				}
			}
		 		
}
function DropTempTables($aobj_context)
{
	$temp_tables_arr=array("temp","tmp");
	foreach($temp_tables_arr as $k=>$v)
	{
			$drop_table_name=$v;
			$get_show_tables="show tables like '%{$drop_table_name}%'";
			$lobj_get_show_tables = $aobj_context->mobj_db->GetAll($get_show_tables);		
				foreach($lobj_get_show_tables as $sk=>$sv)
				{
					foreach($sv as $svk=>$svv)
					{
					 $lobj_alter_table = $aobj_context->mobj_db->Execute(" drop table {$svv}");   
					}
					 
				}
	}
}
function RepairTables($aobj_context)
{
$get_show_tables="show tables";
$lobj_get_show_tables = $aobj_context->mobj_db->GetAll($get_show_tables);		
	foreach($lobj_get_show_tables as $sk=>$sv)
	{
		foreach($sv as $svk=>$svv)
		{
		$repair_cmd="repair table {$svv}";
		$lobj_alter_table = $aobj_context->mobj_db->Execute($repair_cmd);
		
		$opt_cmd="optimize table {$svv}";
		$lobj_opt_cmd = $aobj_context->mobj_db->Execute($opt_cmd);   
		}
		 
	} 
}function DeleteTempFiles($aobj_context)
{
$folder_path=$aobj_context->main_src."/imported_files/";
 		
			$files = scandir($folder_path);
			 foreach ($files as $file)
				{
				$full_file_path=$folder_path.'//'.$file;
					if ($file != "." && $file != ".."&&$file!="Thumbs.db" && is_file($full_file_path)) 
					{
					 unlink($full_file_path);
					  
					}
				}
		 
}	
?>

${this.title}

Code Editor : system_utility.php