Linux server.thearyasamaj.org 4.18.0-553.56.1.el8_10.x86_64 #1 SMP Tue Jun 10 05:00:59 EDT 2025 x86_64
Apache
: 103.90.241.146 | : 216.73.216.28
Cant Read [ /etc/named.conf ]
5.6.40
ftpuser@mantra.thearyasamaj.org
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
README
+ Create Folder
+ Create File
/
home /
thearyasamaj /
public_html /
aryaadmin /
Archive /
[ HOME SHELL ]
Name
Size
Permission
Action
common
[ DIR ]
drwxr-xr-x
arya_AdminInclude_11-01-16.php
1002
B
-rw-r--r--
arya_AdminInclude_13-01-16.php
1.06
KB
-rw-r--r--
arya_AdminInclude_16-09-14.php
811
B
-rw-r--r--
arya_addactivities_28-03-14.ph...
16.43
KB
-rw-r--r--
arya_addadminpages_14-08-14.ph...
13.62
KB
-rw-r--r--
arya_addadmissionnotification_...
32.91
KB
-rw-r--r--
arya_addadvertisement_18-12-14...
23.42
KB
-rw-r--r--
arya_addarticle_05-08-14.php
30.03
KB
-rw-r--r--
arya_addarticle_25-11-15.php
29.99
KB
-rw-r--r--
arya_addaryasamajtab_28-03-14....
22.29
KB
-rw-r--r--
arya_addaudioalbum_28-03-14.ph...
23.93
KB
-rw-r--r--
arya_addauthor_13-09-14.php
20.12
KB
-rw-r--r--
arya_adddiscategory_28-03-14.p...
28.26
KB
-rw-r--r--
arya_adddiscover_04-08-14.php
27.41
KB
-rw-r--r--
arya_addelectionappointment_02...
16.17
KB
-rw-r--r--
arya_addengvarriable_25-03-14....
8.84
KB
-rw-r--r--
arya_addevents_26-01-16.php
50.97
KB
-rw-r--r--
arya_addevents_28-03-14.php
50.96
KB
-rw-r--r--
arya_addeventtype_28-03-14.php
29.83
KB
-rw-r--r--
arya_addfestival_23-07-14.php
30.54
KB
-rw-r--r--
arya_addfiledownload_09-12-14....
12.06
KB
-rw-r--r--
arya_addimportantplaces_28-03-...
35.98
KB
-rw-r--r--
arya_addinstituteprofile_02-10...
23.85
KB
-rw-r--r--
arya_addinstituteprofile_09-05...
23.84
KB
-rw-r--r--
arya_addinstitutetype_04-08-14...
33.23
KB
-rw-r--r--
arya_addinstitution_09-10-14.p...
56.08
KB
-rw-r--r--
arya_addlanguage_04-08-14.php
13.81
KB
-rw-r--r--
arya_addmagazines_02-01-15.php
38.12
KB
-rw-r--r--
arya_addmagazinetitle_09-10-14...
44.28
KB
-rw-r--r--
arya_addmember_29-05-14.php
37.84
KB
-rw-r--r--
arya_addmembertype_04-08-14.ph...
22.95
KB
-rw-r--r--
arya_addmobileaudio_05-12-14.p...
23.51
KB
-rw-r--r--
arya_addmobileaudio_06-01-16.p...
9.1
KB
-rw-r--r--
arya_addmobileaudio_08-01-16.p...
8.69
KB
-rw-r--r--
arya_addmobileimage_05-12-14.p...
20.91
KB
-rw-r--r--
arya_addnews_arvind-18-01-19.p...
61.42
KB
-rw-r--r--
arya_addobituary_18-10-14.php
27.42
KB
-rw-r--r--
arya_addphotogallery_28-03-14....
29.04
KB
-rw-r--r--
arya_addportalhomeslidebanner_...
11.62
KB
-rw-r--r--
arya_addportalsection_04-08-14...
22.76
KB
-rw-r--r--
arya_addportaltab_18-04-14.php
24.93
KB
-rw-r--r--
arya_addprimaryrecord_28-03-14...
47.92
KB
-rw-r--r--
arya_addproduct_28-03-14.php
20.39
KB
-rw-r--r--
arya_addradioairing_04-08-14.p...
18.93
KB
-rw-r--r--
arya_addscndtestquestions_12-1...
24.82
KB
-rw-r--r--
arya_addscndtimeline_17-12-14....
24.27
KB
-rw-r--r--
arya_addsecndryfestival_20-02-...
20.89
KB
-rw-r--r--
arya_addsecondaryactivity_18-0...
15.66
KB
-rw-r--r--
arya_addservices_28-03-14.php
17.99
KB
-rw-r--r--
arya_addstreamingbanner_28-03-...
20.97
KB
-rw-r--r--
arya_addtest_28-05-14.php
15.62
KB
-rw-r--r--
arya_addtestlevel_28-05-14.php
22.6
KB
-rw-r--r--
arya_addtestquestions_27-08-14...
45.74
KB
-rw-r--r--
arya_addtimeline_16-12-14.php
16.6
KB
-rw-r--r--
arya_addtimeline_17-12-14.php
16.92
KB
-rw-r--r--
arya_addtimeline_29-12-14.php
14.26
KB
-rw-r--r--
arya_addvacancy_27-05-14.php
34.54
KB
-rw-r--r--
arya_addvideoalbum_28-03-14.ph...
23.91
KB
-rw-r--r--
arya_addvideogallery_28-03-14....
21.82
KB
-rw-r--r--
arya_addwallpaper_28-03-14.php
9.19
KB
-rw-r--r--
arya_addwebsite_28-03-14.php
18.06
KB
-rw-r--r--
arya_adminlogin_18-03-15.php
7.26
KB
-rw-r--r--
arya_articleautoauthor_05-06-1...
342
B
-rw-r--r--
arya_articlependinglist_22-09-...
21.08
KB
-rw-r--r--
arya_autologout_15-03-14.php
1.94
KB
-rw-r--r--
arya_changepasswordpopup_05-05...
5.53
KB
-rw-r--r--
arya_ckeditor2_14-10-14.php
1.64
KB
-rw-r--r--
arya_ckeditor3_14-10-14.php
1.64
KB
-rw-r--r--
arya_downloadallfile_31-03-14....
2.06
KB
-rw-r--r--
arya_downloadfile_20-12-14.php
1.21
KB
-rw-r--r--
arya_downloadpendinglist_03-03...
24.68
KB
-rw-r--r--
arya_editactivities_28-03-14.p...
23.07
KB
-rw-r--r--
arya_editadminpages_14-08-14.p...
17.92
KB
-rw-r--r--
arya_editadmissionnotification...
40.28
KB
-rw-r--r--
arya_editadvertisement_04-08-1...
29.7
KB
-rw-r--r--
arya_editarticle_11-01-16.php
38.44
KB
-rw-r--r--
arya_editarticle_25-11-15.php
38.41
KB
-rw-r--r--
arya_editarticle_27-10-14.php
38.39
KB
-rw-r--r--
arya_editaryasamajtab_28-03-14...
21.9
KB
-rw-r--r--
arya_editaudioalbum_28-03-14.p...
28.46
KB
-rw-r--r--
arya_editauthor_04-11-14.php
24.92
KB
-rw-r--r--
arya_editdiscategory_28-03-14....
16.11
KB
-rw-r--r--
arya_editdiscover_04-08-14.php
34.54
KB
-rw-r--r--
arya_editelectionappointment_1...
20.12
KB
-rw-r--r--
arya_editelectionappointment_1...
20.06
KB
-rw-r--r--
arya_editevents_19-11-14.php
64.12
KB
-rw-r--r--
arya_editeventtype_28-03-14.ph...
20.59
KB
-rw-r--r--
arya_editfestival_28-03-14.php
38.51
KB
-rw-r--r--
arya_editfiledownload_20-12-14...
22.21
KB
-rw-r--r--
arya_editimportantplaces_18-09...
43.96
KB
-rw-r--r--
arya_editinstitutetype_04-08-1...
23.15
KB
-rw-r--r--
arya_editinstitution_01-10-15....
71.83
KB
-rw-r--r--
arya_editinstitution_02-10-15....
73.92
KB
-rw-r--r--
arya_editinstitution_09-10-14....
55.89
KB
-rw-r--r--
arya_editinstitution_29-09-15....
55.8
KB
-rw-r--r--
arya_editlanguage_04-08-14.php
16.45
KB
-rw-r--r--
arya_editmagazines_08-11-14.ph...
54.04
KB
-rw-r--r--
arya_editmagazinetitle_09-10-1...
53.82
KB
-rw-r--r--
arya_editmember_28-03-14.php
47.21
KB
-rw-r--r--
arya_editmembertype_04-08-14.p...
9.27
KB
-rw-r--r--
arya_editmlevelcategory_04-08-...
9.71
KB
-rw-r--r--
arya_editmobileaudio_06-01-16....
8.9
KB
-rw-r--r--
arya_editmobileaudio_08-01-16....
8.5
KB
-rw-r--r--
arya_editmobileaudio_11-12-14....
8.9
KB
-rw-r--r--
arya_editmobileimage_11-12-14....
9.32
KB
-rw-r--r--
arya_editmpowercategory_04-08-...
10.36
KB
-rw-r--r--
arya_editnews_05-12-14.php
70.37
KB
-rw-r--r--
arya_editnews_13-10-15.php
70.37
KB
-rw-r--r--
arya_editobituary_18_10-14.php
31.32
KB
-rw-r--r--
arya_editphotogallery_28-03-14...
22.85
KB
-rw-r--r--
arya_editportalhomeslidebanner...
13.23
KB
-rw-r--r--
arya_editportaltab_16-04-14.ph...
14.91
KB
-rw-r--r--
arya_editportaltab_17-04-14.ph...
15.18
KB
-rw-r--r--
arya_editprimaryrecord_28-03-1...
68.73
KB
-rw-r--r--
arya_editproduct_28-03-14.php
24.67
KB
-rw-r--r--
arya_editquestioncategory_04-0...
4.83
KB
-rw-r--r--
arya_editradioairing_04-08-14....
23.88
KB
-rw-r--r--
arya_editscndtestquestions_27-...
19.24
KB
-rw-r--r--
arya_editscndtimeline_17-12-14...
19.98
KB
-rw-r--r--
arya_editsecndryfestival_20-02...
15.32
KB
-rw-r--r--
arya_editsecondaryactivity_18-...
13.04
KB
-rw-r--r--
arya_editsecondaryservice_18-0...
13.08
KB
-rw-r--r--
arya_editservices_28-03-14.php
27.4
KB
-rw-r--r--
arya_editstreamingbanner_28-03...
24.27
KB
-rw-r--r--
arya_edittestquestions_27-08-1...
36.17
KB
-rw-r--r--
arya_edittestquestions_28-03-1...
34.6
KB
-rw-r--r--
arya_edittimeline_29-12-14.php
16.88
KB
-rw-r--r--
arya_editvacancy_27-05-14.php
44.08
KB
-rw-r--r--
arya_editvideoalbum_28-03-14.p...
29.72
KB
-rw-r--r--
arya_editvideogallery_28-03-14...
26.26
KB
-rw-r--r--
arya_editwallpaper_28-03-14.ph...
10.34
KB
-rw-r--r--
arya_editwebsite_28-03-14.php
22.98
KB
-rw-r--r--
arya_forgotpwd_06-05-14.php
5.37
KB
-rw-r--r--
arya_ftpfile_02-01-15.php
1.44
KB
-rw-r--r--
arya_header_29-10-14.php
7.48
KB
-rw-r--r--
arya_home_24-12-15.php
640
B
-rw-r--r--
arya_insertpamphlet_21-09-15.p...
15.51
KB
-rw-r--r--
arya_insertpamphlet_25-01-16.p...
15.51
KB
-rw-r--r--
arya_insertpamphlet_28-03-14.p...
16.01
KB
-rw-r--r--
arya_instoffpendinglist_26-05-...
19.27
KB
-rw-r--r--
arya_instpendinglist_01-10-15....
17.35
KB
-rw-r--r--
arya_instpendinglist_28-09-15....
16.42
KB
-rw-r--r--
arya_instphotoupload_18-12-14....
14.98
KB
-rw-r--r--
arya_mailinsquickupload_28-11-...
9.64
KB
-rw-r--r--
arya_memberautodelete_21-06-14...
4.96
KB
-rw-r--r--
arya_menu_14-03-16.php
13.82
KB
-rw-r--r--
arya_mgzndownload_20-12-14.php
2.06
KB
-rw-r--r--
arya_mlevelcategory_04-08-14.p...
23.69
KB
-rw-r--r--
arya_mngactivities_19-06-14.ph...
26.23
KB
-rw-r--r--
arya_mngadmin_18-06-14.php
23.63
KB
-rw-r--r--
arya_mngadminpages_19-06-14.ph...
18.29
KB
-rw-r--r--
arya_mngadmissionnotification_...
20.56
KB
-rw-r--r--
arya_mngadvertisement_19-06-14...
24.17
KB
-rw-r--r--
arya_mngarticle_03-11-14.php
80.54
KB
-rw-r--r--
arya_mngarticle_16_Dec_15.php
80.66
KB
-rw-r--r--
arya_mngauthor_13-09-14.php
22.95
KB
-rw-r--r--
arya_mngblocksequence_15-10-14...
11.64
KB
-rw-r--r--
arya_mngcity_19-06-14.php
22.76
KB
-rw-r--r--
arya_mngcountry_19-06-14.php
19.4
KB
-rw-r--r--
arya_mngcurrentadminlogin_15-0...
4.32
KB
-rw-r--r--
arya_mngdiscover_19-06-14.php
31.28
KB
-rw-r--r--
arya_mngdynamicpages_21-06-14....
18.32
KB
-rw-r--r--
arya_mngelectionappointment_11...
26.85
KB
-rw-r--r--
arya_mngelectionappointment_12...
26.84
KB
-rw-r--r--
arya_mngelectionappointment_16...
27.22
KB
-rw-r--r--
arya_mngengvariable_25-03-14.p...
20.87
KB
-rw-r--r--
arya_mngevents_19-06-14.php
43.6
KB
-rw-r--r--
arya_mngfestival_19-06-14.php
30.69
KB
-rw-r--r--
arya_mngfiledownload_12-03-15....
31.33
KB
-rw-r--r--
arya_mngfiledownload_24-09-15....
31.39
KB
-rw-r--r--
arya_mngimportantplaces_19-06-...
35.95
KB
-rw-r--r--
arya_mnginstitution_09-10-14.p...
107.28
KB
-rw-r--r--
arya_mnginstitution_29-09-15.p...
107.21
KB
-rw-r--r--
arya_mnginstmgzadmin_17-06-14....
38.8
KB
-rw-r--r--
arya_mngmagazines_08-11-14.php
25.66
KB
-rw-r--r--
arya_mngmagazinetitle_09-10-14...
51.98
KB
-rw-r--r--
arya_mngmember_03-10-15.php
76.76
KB
-rw-r--r--
arya_mngmember_09-02-16.php
77.33
KB
-rw-r--r--
arya_mngmember_16_dec_15.php
77.04
KB
-rw-r--r--
arya_mngmember_17-10-14.php
76.08
KB
-rw-r--r--
arya_mngmobileaudio_11-06-15.p...
17.53
KB
-rw-r--r--
arya_mngnews_27-11-14.php
52.54
KB
-rw-r--r--
arya_mngobituary_15-10-14.php
23.06
KB
-rw-r--r--
arya_mngperson_19-06-14.php
51.31
KB
-rw-r--r--
arya_mngpollquestions_19-06-14...
33.89
KB
-rw-r--r--
arya_mngportalhomeslidebanner_...
22.52
KB
-rw-r--r--
arya_mngproduct_19-06-14.php
19.32
KB
-rw-r--r--
arya_mngquickuploads_16-12-14....
28.25
KB
-rw-r--r--
arya_mngradioairing_19-06-14.p...
17.72
KB
-rw-r--r--
arya_mngreporter_19-06-14.php
39.48
KB
-rw-r--r--
arya_mngservices_19-06-14.php
25.44
KB
-rw-r--r--
arya_mngstate_19-06-14.php
20.19
KB
-rw-r--r--
arya_mngstreaming_19-06-14.php
21.1
KB
-rw-r--r--
arya_mngstreamingbanner_19-06-...
20.88
KB
-rw-r--r--
arya_mngtestquestions_04-12-14...
33.56
KB
-rw-r--r--
arya_mngtimeline_26-12-14.php
35.04
KB
-rw-r--r--
arya_mngvacancy_19-06-14.php
25.94
KB
-rw-r--r--
arya_mngvacancy_29-04-14.php
26.58
KB
-rw-r--r--
arya_mngvedmantra_19-06-14.php
25.09
KB
-rw-r--r--
arya_mngwallpaper_19-06-14.php
13.99
KB
-rw-r--r--
arya_mngwebsite_19-06-2014.php
19.61
KB
-rw-r--r--
arya_mobileaudiopending_11-12-...
14.4
KB
-rw-r--r--
arya_mpowercategory_04-08-14.p...
26.06
KB
-rw-r--r--
arya_newsphotoupload_31-01-15....
16.3
KB
-rw-r--r--
arya_obituaryphotos_28-03-14.p...
15.62
KB
-rw-r--r--
arya_otherlangvarriable_25-04-...
12.02
KB
-rw-r--r--
arya_pendingtabs_18-12-14.php
5.19
KB
-rw-r--r--
arya_pendingtabs_29-09-15.php
5.26
KB
-rw-r--r--
arya_persnphotoupload_28-03-14...
16.76
KB
-rw-r--r--
arya_placephotoupload_28-03-14...
16.99
KB
-rw-r--r--
arya_pushnotification_23-09-14...
6.45
KB
-rw-r--r--
arya_quickautodelete_14-05-14....
1.39
KB
-rw-r--r--
arya_quickupldpendinglist_19-1...
36.03
KB
-rw-r--r--
arya_reportpendinglist_13-05-1...
53.47
KB
-rw-r--r--
arya_searchvariablename_15-03-...
352
B
-rw-r--r--
arya_sendquickuploadmail_29-10...
4.41
KB
-rw-r--r--
arya_timelinependinglist_17-12...
28.17
KB
-rw-r--r--
arya_uploadtakeatour_28-05-14....
38.87
KB
-rw-r--r--
arya_viewadminLaPower_arvind-1...
9.24
KB
-rw-r--r--
arya_viewadminactivity_27-03-1...
9.14
KB
-rw-r--r--
arya_viewadminactivity_arvind-...
9.15
KB
-rw-r--r--
arya_viewadminhistory_arvind-1...
7.21
KB
-rw-r--r--
arya_viewadminpower_arvind-14-...
12.76
KB
-rw-r--r--
arya_viewadminprofile_arvind-1...
5.43
KB
-rw-r--r--
arya_viewnewsphotos_28-11-14.p...
7.77
KB
-rw-r--r--
arya_viewobituarymessage_15-10...
6.17
KB
-rw-r--r--
arya_viewobituaryphoto_14-03-1...
7.08
KB
-rw-r--r--
arya_viewpendingquickupload_02...
18.1
KB
-rw-r--r--
arya_viewpendingreport_09-04-1...
17.43
KB
-rw-r--r--
arya_viewquickuploads_02-10-14...
17.91
KB
-rw-r--r--
arya_viewreport_09-04-14.php
17.43
KB
-rw-r--r--
arya_wallpaper_24-02-14.php
570
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : arya_mnginstitution_29-09-15.php
<?php //created by vaishali include('arya_AdminInclude.php'); //header start include('arya_header.php'); //header over // link start include("arya_menu.php"); // link over if($_POST['page'] !="") { $_SESSION["lngvarpagesesid"]=$_POST['page']; } else if($_GET["msg"] !="") { $_POST['page']=$_SESSION["lngvarpagesesid"]; } else { unset($_SESSION["lngvarpagesesid"]); } unset($_SESSION["logoses"]); $admusrid=$_SESSION["adminuserid"]; $logindate=date('Y-m-d h:i:s'); $dbusercatid=getFieldValue('admcat_id','arya_adminuser','admuser_id="'.$_SESSION["adminuserid"].'"'); $rightsid=mysql_query('SELECT admsecright_pageid FROM arya_adminsectionrights WHERE admcat_id IN('.$dbusercatid.') AND admuser_id="'.$admusrid.'"'); while($rightfetch=mysql_fetch_array($rightsid)) { $admcatrightsid[]=$rightfetch['admsecright_pageid']; } foreach($admcatrightsid as $key) { $qry="select * from arya_adminpage where page_sectionid='".$key."'"; $q=mysql_query($qry); while($fetch=mysql_fetch_array($q)) { $pagename=$fetch['page_filename']; $path = $_SERVER['REQUEST_URI']; $headername = basename($path); $url_parts = parse_url($headername); $constructed_url = $url_parts['scheme'] . '' . $url_parts['hostname'] . $url_parts['path']; if($constructed_url==$pagename) { $newrightsarray=getFieldValueArray('admsecright_edit,admsecright_delete,admsecright_approve,admsecright_sdelete','arya_adminsectionrights','admsecright_pageid="'.$key.'" AND admuser_id="'.$admusrid.'" AND admcat_id="'.$dbusercatid.'"'); $rightedit=$newrightsarray[0]; $rightdelete=$newrightsarray[1]; $fesaproveid=$newrightsarray[2]; $superdelete=$newrightsarray[3]; } } } $pagesecid=getFieldValue('page_sectionid','arya_adminpage','page_filename="'.$constructed_url.'"'); $modulenm=getFieldValue('page_title','arya_adminpage','page_filename="'.$constructed_url.'"'); $curntdate=date('Y-m-d'); $curnttime= date('h:i:s'); // content start if(isset($_GET["sid"]) && $_GET["sid"]!="") { $instadmid=getFieldValue('user_id','arya_institution','inst_id='.$_GET["sid"].''); $instclientid=getFieldValue('inst_clientuserid','arya_institution','inst_id='.$_GET["sid"].''); $instwebadd=getFieldValue("inst_webadd","arya_institution","inst_id='".$_GET["sid"]."'"); if($_SERVER['HTTP_HOST']=="www.thearyasamaj.org" || $_SERVER['HTTP_HOST']=="thearyasamaj.org") { $_SERVER['HTTP_HOST']=="www.thearyasamaj.org"; $instwebname=substr($instwebadd, 21); } if($_SERVER['HTTP_HOST']=="www.aryasamajdelhi.pb") { $instwebname=substr($instwebadd, 22); } $filename ='../.htaccess'; $ruleurl='RewriteRule ^'.$instwebname.'$'.' /aryasamaj-institutionwebpage.php'; $contents = file_get_contents($filename); // escape special characters in the query $pattern = preg_quote($ruleurl, '/'); // finalise the regular expression, matching the whole line $pattern = "/^.*$pattern.*\$/m"; // search, and store all matching occurences in $matches if(preg_match_all($pattern, $contents, $matches)){ //echo "Found matches:\n"; //echo "<Br>-->".$ruleurl; display perticular line in htaccess //read the entire string $str=implode("",file($filename)); $fp=fopen($filename,'w'); //replace something in the file string - this is a VERY simple example $str=str_replace($ruleurl,'',$str); //now, TOTALLY rewrite the file fwrite($fp,$str,strlen($str)); fclose($fp); //echo implode("\n", $matches[0]); } else{ //echo "not Found matches:\n"; } $smallimage=getFieldValue('inst_image','arya_institution','inst_id="'.$_GET["sid"].'"'); $mainimage=str_replace('SM_','',$smallimage); $mainphotimage=str_replace('media','photo',$mainimage); if($conditionvar=='2') { unlink($smallimage); unlink($mainphotimage); } else { $filesmallimage=getFieldValue('inst_image','arya_institution','inst_id="'.$_GET["sid"].'"'); $image=str_replace("./","media/",$filesmallimage); unlink($image); } if($conditionvar=='1') { include('arya_ftpfile.php'); ftp_delete($srvconnect_id ,$smallimage); ftp_delete($srvconn_id ,$mainimage); } $qryselofficer="Select officer_photo from arya_officer where inst_id='".$_GET["sid"]."'"; $qseloff=mysql_query($qryselofficer); while($fetch=mysql_fetch_array($qseloff)) { $offsmallimage=$fetch['officer_photo']; $offmainimage=str_replace('SM_','',$offsmallimage); $offmainphotimage=str_replace('media','photo',$offmainimage); if($conditionvar=='2') { unlink($offsmallimage); unlink($offmainphotimage); } else { $image=str_replace("./","media/",$offsmallimage); $newimage=str_replace("media","photo",$image); unlink($newimage); unlink($image); } if($conditionvar=='1') { include('arya_ftpfile.php'); ftp_delete($srvconnect_id ,$offsmallimage); ftp_delete($srvconn_id ,$offmainimage); } } $updtsupdeltitle=getFieldValue('inst_name','arya_institution','inst_id="'.$_GET["sid"].'"'); getadminactivity('title_mnginstitution',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$updtsupdeltitle,$curntdate,$curnttime); $Loginid=getFieldValue('login_id','arya_institution','inst_id='.$_GET["sid"]); $delusertype="DELETE FROM arya_institution WHERE inst_id='".$_GET["sid"]."'"; $qrydelusertype=mysql_query($delusertype); if($instadmid>0) { $userid="user_id='".$instadmid."'"; } if($instclientid>0) { $userid="clientuser_id='".$instclientid."'"; } $delquery="DELETE FROM arya_instwebpagecheck WHERE inst_id='".$_GET["sid"]."' AND $userid"; $resdelquery=mysql_query($delquery); if($qrydelusertype) { $delwebpgrights="DELETE FROM arya_instwebpagerights WHERE inst_id='".$_GET["sid"]."'"; $qrywebpgright=mysql_query($delwebpgrights); $delulogin="DELETE FROM arya_officer WHERE inst_id='".$_GET["sid"]."'"; $qryulogin=mysql_query($delulogin); $delulogincheck="DELETE FROM arya_institutecheck WHERE login_id='".$_GET["sid"]."'"; $qryulogincheck=mysql_query($delulogincheck); $delupenreq="DELETE FROM arya_adminpendingrequest WHERE pend_instid='".$_GET["sid"]."'"; $dupenreq=mysql_query($delupenreq); $delwebaddrss="DELETE FROM arya_webaddresses WHERE inst_id='".$_GET["sid"]."'"; $qrywebadress=mysql_query($delwebaddrss); $delcusadd="DELETE FROM thearyas_zencart.address_book WHERE address_book.customers_id='".$Loginid."'"; $qrycusadd=mysql_query($delcusadd); $delcust="DELETE FROM thearyas_zencart.customers WHERE customers.customers_id='".$Loginid."'"; $qrycust=mysql_query($delcust); $delinsttype="DELETE FROM arya_institutiontype WHERE inst_id='".$_GET["sid"]."'"; $qryinsttype=mysql_query($delinsttype); $delinstrequest="DELETE FROM arya_adminpendingrequest WHERE pend_instid='".$_GET["sid"]."'"; $qryinstreque=mysql_query($delinstrequest); $delcustinfo="DELETE FROM thearyas_zencart.customers_info WHERE customers_info.customers_info_id='".$Loginid."'"; $qrycustinfo=mysql_query($delcustinfo); if($qryulogincheck) { $msg=$msgDeleteRecord; //code for copy .htaccess file put by nitesh $today = date('Y-m-d'); $abcd ='../.htaccess'; $nvfilePath='../htaccessfile/delinst_'.$today.'_'.$_GET["sid"].'_usid '.$admusrid.'_htaccess'; copy($abcd ,$nvfilePath); } } $selectquery=mysql_query("select * from arya_institutionphoto where inst_id='".$_GET['sid']."'"); while($fetchsel=mysql_fetch_array($selectquery)) { $fetchsmallimage=$fetchsel['instphoto_name']; $fetchbigimage=str_replace('SM','BG',$fetchsmallimage); if($conditionvar=='2') { unlink($fetchsmallimage); unlink($fetchbigimage); } if($conditionvar=='1') { include('arya_ftpfile.php'); ftp_delete($srvconn_id,$fetchsmallimage); ftp_delete($srvconn_id,$fetchbigimage); } } $qryDelvardetail = "DELETE FROM arya_institutionphoto WHERE inst_id='".$_GET['sid']."'"; $qSqlDel = mysql_query($qryDelvardetail); } if(isset($_GET["sid1"]) && $_GET["sid1"]!="") { $updtdeltitle=getFieldValue('inst_name','arya_institution','inst_id="'.$_GET["sid1"].'"'); getadminactivity('title_mnginstitution',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$updtdeltitle,$curntdate,$curnttime); $delusertype="UPDATE arya_institution SET inst_delstatus='Yes' WHERE inst_id='".$_GET["sid1"]."'"; $qrydelusertype=mysql_query($delusertype); if($qrydelusertype) { } $msg=$msgDeleteRecord; } if($_GET["msg"]=='upd') { $msg=$msgUpdateRecord; } if($_POST['page'] != "") { $_SESSION["pagesesid"]=$_POST['page']; } else if($_GET["msg"] != '' || $_GET["sid"] > 0) { $_POST['page']=$_SESSION["pagesesid"]; } else { unset($_SESSION["pagesesid"]); } if($_POST['page']=="" && $_GET["sid"]=="" && $_GET["clnm"]=="") { unset($_SESSION["instype1"]); unset($_SESSION["inst1"]); unset($_SESSION["level1"]); unset($_SESSION["navin1"]); unset($_SESSION['stsnid1']); unset($_SESSION["ctsnid1"]); unset($_SESSION["insttypeid1"]); unset($_SESSION["autosearch1"]); //unset($_SESSION["insttypeid1"]); //unset($_SESSION['insttypeid1']); } if($_POST["cmbinstitutiontype"] > 0 || $_POST["cmbinstitutionlevel"] > 0 || $_POST["cmbistitution"] > 0 || $_POST['cmbCountry'] > 0 || $_POST['cmbstate'] > 0 || $_POST["cmbcity"] > 0 || $_POST['cmbApprove']=='Yes' || $_POST['cmbApprove']=='No' || $_POST['autosearch']!='') { //$autosearch=getFieldValue('inst_id','arya_institution','inst_name="'.$_POST['autosearch'].'"'); $autosearch=$_POST['autosearch']; $selinstype=$_POST["cmbinstitutiontype"]; $selinslevel=$_POST["cmbinstitutionlevel"]; $selins=$_POST["cmbistitution"]; $cntid = $_POST['cmbCountry']; $sttid = $_POST['cmbstate']; $ctid = $_POST["cmbcity"]; $cmbinstapprove = $_POST['cmbApprove']; $_SESSION["autosearch1"]=$autosearch; //$autosearchval=getFieldValue('inst_name','arya_institution','inst_id="'.$_SESSION['autosearch1'].'"'); $_SESSION["instype1"]=$selinstype; $_SESSION["inst1"]=$selins; $_SESSION["level1"]=$selinslevel; $_SESSION['navin1']=$cntid; $_SESSION['stsnid1']=$sttid; $_SESSION['ctsnid1']=$ctid; $_SESSION["insttypeid1"]=$cmbinstapprove; //$_SESSION['insttypeid1']=$cmbinsttype; } /*else { $_POST["cmbinstitutiontype"]=$_GET["intid"]; $_SESSION["inst1"]=$_GET["inid"]; $_SESSION["level1"]=$_GET["leid"]; $_SESSION["navin1"] = $_GET['cnid']; $_SESSION['stsnid1'] = $_GET['sid']; $_SESSION['ctsnid1'] = $_GET['cid']; $_SESSION['insttypeid1'] = $_GET['insttypeid']; }*/ if($_GET["intid"]>0) { $_SESSION["instype1"]=$_GET["intid"]; } if($_GET["inid"]>0) { $_SESSION["inst1"]=$_GET["inid"]; } if($_GET["leid"]>0) { $_SESSION["level1"]=$_GET["leid"]; } if($_GET["cnid"]>0) { $_SESSION["navin1"]=$_GET["cnid"]; } if($_GET["csttid"]>0) { $_SESSION["stsnid1"]=$_GET["csttid"]; } if($_GET["cid"]>0) { $_SESSION["ctsnid1"]=$_GET["cid"]; } if($_GET["appr"]!='') { $_SESSION["insttypeid1"]=$_GET["appr"]; } if($_GET["instsnm"]!='') { $_SESSION["autosearch1"]=$_GET["instsnm"]; //$autosearchval=getFieldValue('inst_name','arya_institution','inst_id="'.$_SESSION['autosearch1'].'"'); } /*if($_GET["insttypeid"]>0) { $_SESSION["insttypeid1"]=$_GET["insttypeid"]; }*/ $clnm = ""; if ($_GET['clnm']) { $clnm = $_GET['clnm']; } else { $clnm ="inst_name"; } // Get the value of either ascending or descending $order = ""; if ($_GET['order']) { $order = $_GET['order']; } else { $order ="DESC"; } if ($clnm == "") {$clnm = "proposalno"; } // Make the default order sorting if ($order == "") { $order = "ASC"; } elseif ($order == "ASC") { $order = "DESC";} elseif ($order == "DESC") { $order = "ASC";} /*if(isset($_POST["updtseq"])) { foreach($_POST["txtwebadd"] as $key=>$webadd) { $instwebpage=getFieldValue('inst_webadd','arya_institution','inst_id='.$key.''); if($_SERVER['HTTP_HOST']=="www.thearyasamaj.org" || $_SERVER['HTTP_HOST']=="thearyasamaj.org") { $_SERVER['HTTP_HOST']=="www.thearyasamaj.org"; $instwebadd = substr($instwebpage, 21); } if($_SERVER['HTTP_HOST']=="www.aryasamajdelhi.pb") { $instwebadd = substr($instwebpage, 22); } $postwebadd =$_SERVER['HTTP_HOST']."/".addslashes($webadd); $duplicate=getFieldValue('inst_webadd','arya_institution','inst_webadd="'.$postwebadd.'" AND inst_id!="'.$key.'"'); if($duplicate=="") { $filename ='../.htaccess'; $ruleurl1='RewriteRule ^'.$instwebadd.' /aryasamaj-institutionwebpage.php'; $ruleurl='RewriteRule ^'.$webadd.' /aryasamaj-institutionwebpage.php'; $lines =file($filename); foreach($lines as $line_num => $line) { if($postwebadd!=$instwebpage) { $nvremovefirst=explode(" ",substr($line,13)); //echo "<br>--->".$nvremovefirst[0]; display the webaddress in htaccess //echo "<Br>-->".$ruleurl; display perticular line in htaccess //read the entire string $str=implode("",file($filename)); $fp=fopen($filename,'w'); //replace something in the file string - this is a VERY simple example $str=str_replace($ruleurl1,'',$str); //now, TOTALLY rewrite the file fwrite($fp,$str,strlen($str)); } } $contents = file_get_contents($filename); $searchthis = $webadd; $pattern = preg_quote($searchthis, '/'); // finalise the regular expression, matching the whole line $pattern = "/^.*$pattern.*\$/m"; if(preg_match_all($pattern, $contents, $matches)) { //echo "Found matches:\n"; //$msg=$msgDuplicatRecord; } else { //echo "No matches found"; //read the entire string $str=implode(" ",file($filename)); $fp=fopen($filename,'a+'); //replace something in the file string - this is a VERY simple example //$str=str_replace($mgztitlewebadd,$_POST["txtwebadd"],$str); $b=$ruleurl."\n"; //now, TOTALLY rewrite the file fwrite($fp,$b); fclose($fp); } $updsequence="UPDATE arya_institution SET inst_webadd='".$postwebadd."' where inst_id='".$key."'"; $reupdseq=mysql_query($updsequence); if($reupdseq) { $msg=$msgUpdateRecord; } } else { $msg="Please Don't Insert Duplicate Web Address."; break; } } }*/ if($order=='ASC') { $style='class="asecnding"'; $ascdescicon='images/up.png'; } if($order=='DESC') { $style='class="descending"'; $ascdescicon='images/down.png'; } if($_GET['clnm']=='inst_name') { $inst_name='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='insttype_name') { $insttype_name='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='inst_address') { $inst_address='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='inst_approve') { $inst_approve='<img src='.$ascdescicon.' '.$style.' />'; } else { $inst_name='<img src='.$ascdescicon.' '.$style.' />'; } ?> <script language="javascript"> $(document).ready(function(){ $("#autosearch").autocomplete("arya_searchinstitutionname.php", { selectFirst: true }); }); </script> <form action="" method="post" name="frmpaging" id="frmpaging" > <input type="hidden" name="page" value="" /> </form> <form name="frmservices" id="frmservices" method="post" action="arya_mnginstitution.php" enctype="multipart/form-data"> <table width="100%" summary="" border="0" cellpadding="0" cellspacing="0"> <tr><td align="center"> <table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td width="45%"></td> <td align="center" width="15%"><h2 class="bigheader"><?php echo $title_mnginstitution; ?></h2></h2></td> <td width="50%"></td> <td></td> </tr> </table> <td align="center" height="85"></td> </tr> <?php echo SuccessMessage($msg);?> <tr> <td align="center"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td align="right" width="45%">Institution Name : </td> <td align="left"> <input type="text" name="autosearch" id="autosearch" class="txtbox" value="<?php echo $_SESSION["autosearch1"]; ?>"/> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_approve; ?> : </td> <td> <select name="cmbApprove" id="cmbApprove" class="selbox"> <option value=""><?php echo $lbl_selapprove; ?></option> <?php echo getInstapprove($_SESSION['insttypeid1']); ?> </select> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_selectinsttype; ?> : </td> <td align="left"> <select name="cmbinstitutiontype" id="cmbinstitutiontype" class="selbox"> <option value=""><?php echo $lbl_selectinsttype; ?></option> <?php echo getInstitutiontype($_SESSION["instype1"]);?> </select></td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_selectinstlevel; ?> : </td> <td align="left"> <select name="cmbinstitutionlevel" id="cmbinstitutionlevel" class="selbox"> <option value="0"><?php echo $lbl_selectinstlevel; ?></option> <?php echo getInstLevel($_SESSION["level1"]);?> </select></td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_selectinst; ?> : </td> <td align="left"> <select name="cmbistitution" id="cmbistitution" class="selbox"> <option value="0"><?php echo $lbl_selectinst; ?></option> <?php echo getInstitution($_SESSION["inst1"]);?> </select></td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr><td align="right" width="45%"><?php echo $lbl_selectcountry?> : </td> <td> <select name="cmbCountry" id="cmbCountry" class="selbox" onchange="findselectstate(this.value);findselcity(this.value)"> <option value="0"><?php echo $lbl_selectcountry;?></option> <?php echo Getcountry($_SESSION["navin1"]);?> </select> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr><td align="right" width="45%"><?php echo $lbl_selectstate; ?> : </td> <td> <div id="FetchAjaxDatastate"> <select name="cmbstate" id="cmbstate" class="selbox" onchange="return findselcity(this.value);"> <option value="0"><?php echo $lbl_selectstate; ?></option> <?php echo GetState($_SESSION['stsnid1'],$_SESSION["navin1"]);?> </select> </div> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr><td align="right" width="45%"><?php echo $lbl_selectcity;?> : </td> <td> <div id="FetchAjaxDataCity"> <select name="cmbcity" id="cmbcity" class="selbox"> <option value="0"><?php echo $lbl_selectcity; ?></option> <?php echo GetCity($_SESSION['ctsnid1'],$_SESSION['stsnid1'],$_SESSION["navin1"]);?> </select> </div> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr><td></td> <td align="left" colspan="3"> <input type="submit" name="Search" id="Search" value="Search" class="button blue" /></td> </tr> </table> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="center"> <table summary="" border="1" align="center" width="80%" cellpadding="0" cellspacing="0"> <tr align="center" class="tblborder"> <td width="15%"><?php echo $lbl_parentname; ?></td> <td width="15%"><a href="arya_mnginstitution.php?clnm=inst_name&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_instname; ?><?php echo "".$inst_name; ?></a></td> <td width="15%"><a href="arya_mnginstitution.php?clnm=insttype_name&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_insttype; ?><?php echo "".$insttype_name; ?></a></td> <td width="15%"><?php echo $lbl_instlevel; ?></td> <td width="10%"><a href="arya_mnginstitution.php?clnm=inst_address&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_address; ?><?php echo "".$inst_address; ?></a></td> <td width="10%"><?php echo $lbl_email; ?></td> <td width="8%"><?php echo $lbl_photo; ?></td> <?php// if($_SESSION["adminuserid"] == 1) { ?> <!--<td width="8%" align="center">View Password</td>--> <?php //} ?> <!--<td><?php //echo $lbl_webaddress; ?></td>--> <td width="8%"><a href="arya_mnginstitution.php?clnm=inst_approve&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_approve; ?><?php echo "".$inst_approve; ?></a></td> <td width="8%"><?php echo $lbl_edit; ?></td> <td width="8%"><?php echo $lbl_delete; ?></td> <td width="8%"><?php echo $lbl_superdelete; ?></td> </tr> <?php if($dbusercatid=="3") { unset($_SESSION["autosearch"]); unset($_SESSION["instype"]); unset($_SESSION["level"]); unset($_SESSION["inst"]); unset($_SESSION['cntsnid']); unset($_SESSION['stsnid']); unset($_SESSION['ctsnid']); unset($_SESSION['insttypeid']); if($_SESSION["autosearch1"]!='') { $searchword=$_SESSION["autosearch1"]; $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_name LIKE '%$searchword%' ORDER BY $clnm $order"; //$qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_name='".$_SESSION['autosearch1']."'"; $_SESSION["autosearch"]=$_SESSION["autosearch1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; } else if($_SESSION['insttypeid1'] == "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1'] == "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND insttype_id ='".$_SESSION["instype1"]."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["instype"]=$_SESSION["instype1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND insttype_id ='".$_SESSION["instype1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION["inst"]=$_SESSION["inst1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_parentid='".$_SESSION["inst1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if ($clnm=="insttype_name") { $qrySelinstitutions="SELECT * FROM arya_institution,arya_institutiontype WHERE arya_institution.insttype_id=arya_institutiontype.insttype_id ORDER BY $clnm $order"; } else { $qrySelinstitutions="SELECT * FROM arya_institution ORDER BY $clnm $order"; } } else { unset($_SESSION["autosearch"]); unset($_SESSION["instype"]); unset($_SESSION["level"]); unset($_SESSION["inst"]); unset($_SESSION['cntsnid']); unset($_SESSION['stsnid']); unset($_SESSION['ctsnid']); unset($_SESSION['insttypeid']); if($_SESSION["autosearch1"]!='') { $searchword=$_SESSION["autosearch1"]; $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_name LIKE '%$searchword%' ORDER BY $clnm $order"; //$qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_id='".$_SESSION['autosearch1']."'"; $_SESSION["autosearch"]=$_SESSION["autosearch1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']=="" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; } else if($_SESSION['insttypeid1'] == "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1'] == "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND insttype_id ='".$_SESSION["instype1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["instype"]=$_SESSION["instype1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND insttype_id ='".$_SESSION["instype1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND insttype_id ='".$_SESSION["instype1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION["inst"]=$_SESSION["inst1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] == 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']!= "" && $_SESSION["instype1"] == 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_approve='".$_SESSION['insttypeid1']."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; $_SESSION['insttypeid']=$_SESSION['insttypeid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] == 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] == 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] > 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND city_id='".$_SESSION['ctsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; $_SESSION['ctsnid']=$_SESSION['ctsnid1']; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] == 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; } else if($_SESSION['insttypeid1']== "" && $_SESSION["instype1"] > 0 && $_SESSION["inst1"] > 0 && $_SESSION["level1"] > 0 && $_SESSION["navin1"] > 0 && $_SESSION['stsnid1'] > 0 && $_SESSION['ctsnid1'] == 0) { $qrySelinstitutions="SELECT * FROM arya_institution WHERE insttype_id ='".$_SESSION["instype1"]."' AND inst_parentid='".$_SESSION["inst1"]."' AND inst_typelevel ='".$_SESSION["level1"]."' AND cnt_id='".$_SESSION["navin1"]."' AND state_id='".$_SESSION['stsnid1']."' AND inst_delstatus='No' ORDER BY $clnm $order"; $_SESSION["instype"]=$_SESSION["instype1"]; $_SESSION["inst"]=$_SESSION["inst1"]; $_SESSION["level"]=$_SESSION["level1"]; $_SESSION['cntsnid']=$_SESSION["navin1"]; $_SESSION['stsnid']=$_SESSION['stsnid1']; } else if ($clnm=="insttype_name") { $qrySelinstitutions="SELECT * FROM arya_institution,arya_institutiontype WHERE arya_institution.insttype_id=arya_institutiontype.insttype_id AND arya_institution.inst_delstatus='No' ORDER BY $clnm $order"; } else { $qrySelinstitutions="SELECT * FROM arya_institution WHERE inst_delstatus='No' ORDER BY $clnm $order"; } } $qSelinstitutions=mysql_query($qrySelinstitutions); $numrows=mysql_num_rows($qSelinstitutions); //$numrows=mysql_num_rows($qSelinstitutions); if($numrows > 0)//start { $page =$_POST['page']; $limit=25; $script_name="arya_mnginstitution.php"; $pager = getPagerData($numrows, $limit, $page); $numpages=$pager->numPages; $paging=display_paginglist($page,$numrows,$limit,$script_name,$pagequery_vars); $qSelinstitutions=mysql_query($qrySelinstitutions." limit $eu, $limit ") or GoToErrorPage(); while($qFetchinstitutions=mysql_fetch_array($qSelinstitutions))//while start { $insid=$qFetchinstitutions["inst_id"]; $dbuser_id=$qFetchinstitutions["user_id"]; $loginid1=$qFetchinstitutions["login_id"]; $parentname=$qFetchinstitutions["inst_parentid"]; //$insparentname=$qFetchinstitutions["inst_name"]; $insparentname = getFieldValue("inst_name","arya_institution","inst_id=".$parentname.""); $cntid = getFieldValue("cnt_id","arya_institution","inst_id=".$parentname.""); $cntname = getFieldValue("cnt_name","arya_country","cnt_id=".$cntid.""); //$instemail = getFieldValue("login_name","arya_userlogin","login_id=".$loginid1.""); $instemail=$qFetchinstitutions["inst_email"]; $title=stripslashes($qFetchinstitutions["inst_name"]); $instype=$qFetchinstitutions["insttype_id"]; $instypeName=getFieldValue("insttype_name","arya_institutiontype","insttype_id=".$instype.""); $inslevel=$qFetchinstitutions["inst_typelevel"]; $newsphotoalbm=getNumrowsValue('instphoto_id','arya_institutionphoto','inst_id="'.$insid.'"'); if($inslevel=="1") { $InstLevel="Major Level"; } if($inslevel=="2") { $InstLevel="Local Level"; } $insaddress=stripslashes($qFetchinstitutions["inst_address"]); $insapprove=$qFetchinstitutions["inst_approve"]; $clientsidewebadd=$qFetchinstitutions['inst_webadd']; $clientwebaddress = substr($clientsidewebadd, 0, 7); if($clientwebaddress != "http://") { $clientwebaddress = "http://".$clientsidewebadd; } else { $clientwebaddress = $clientsidewebadd; } $delstatus=$qFetchinstitutions["inst_delstatus"]; $webaddress=explode("/",$qFetchinstitutions['inst_webadd']); $wedadd=$webaddress[1]; ?> <?php if($delstatus=='No') { ?> <tr align="center" ><?php } else { ?> <tr align="center" bgcolor="#CCCCCC" ><?php } ?> <td><?php if($insparentname!="") { echo $insparentname." (".$cntname.")"; }?></td> <td><a href="<?php echo $clientwebaddress; ?>" target="_blank"><?php echo $title; ?></a></td> <td><?php echo $instypeName; ?></td> <td><?php echo $InstLevel; ?></td> <td><?php echo $insaddress; ?></td> <td><?php echo $instemail; ?></td> <?php $qrySelinstmtprg="SELECT * FROM arya_institutionphoto WHERE inst_id='".$insid."' ORDER BY instphoto_sequence asc "; $qSelportal=mysql_query($qrySelinstmtprg); $numrows=mysql_num_rows($qSelportal); ?> <td> <?php if($numrows > 0) { ?> <a href="arya_viewinstphotos.php?instgid=<?php echo $insid; ?>&name=<?php echo '1'; ?>" class="iframe6" style="text-decoration:none;" title="Manage Photos"> <b><?php echo $newsphotoalbm; ?></b></a> <?php }else { ?> <a href="arya_instphotoupload.php?instgid=<?php echo $insid; ?>&name=<?php echo '1'; ?>" class="iframe6" style="text-decoration:none;" title="Manage Photos"><b><?php echo $newsphotoalbm; ?></b></a> <?php } ?> </td> <!--<td><input type="text" name="txtwebadd[<?php //echo $insid;?>]" id="txtwebadd[<?php //echo $insid;?>]" value="<?php //echo $wedadd;?>" size="15" onKeyPress="return isAlphawebadd(event)" onpaste="return false;" /></td>--> <?php //if($_SESSION["adminuserid"] == 1) { ?> <!--<td><a class="iframe" href="arya_getpwd.php?intid=<?php //echo $loginid; ?>" title="">Get Password</a></td>--> <?php //} ?> <td><div id="FetchAjaxDataactive[<?php echo $insid;?>]"><?php if($insapprove=='Yes'){ if($dbuser_id==$admusrid && $fesaproveid=='Self') { ?> <img src="images/greenstar.png" title="Click the button then update approve" alt="" onclick="return UpdateActiveInactiveVal('insapp','No',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/greenstar.png" title="Click the button then update approve" alt="" onclick="return UpdateActiveInactiveVal('insapp','No',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/greenstar_d.png" alt=""/> <?php } ?> <?php } else if($insapprove=='No') { if($dbuser_id==$admusrid && $fesaproveid=='Self') { ?> <img src="images/redstar.png" title="Click the button then update approve" alt="" onclick="return UpdateActiveInactiveVal('insapp','Yes',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/redstar.png" title="Click the button then update approve" alt="" onclick="return UpdateActiveInactiveVal('insapp','Yes',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/redstar_d.png" alt=""/> <?php } ?> <?php }?> </div></td> <td> <?php if($dbuser_id==$admusrid && $rightedit=='Self') { ?> <a href="arya_editinstitution.php?sid=<?php echo $insid;?>&scid=<?php echo $pagesecid;?>"> <img src="./images/edit.gif" border="0" alt="" title="Click here to edit this record"/></a> <?php } else if($rightedit=='All') { ?> <a href="arya_editinstitution.php?sid=<?php echo $insid;?>&scid=<?php echo $pagesecid;?>"> <img src="./images/edit.gif" border="0" alt="" title="Click here to edit this record"/></a> <?php } else { ?> <img src="images/edit_disable.gif" border="0" alt="" title="Click here to edit this record" /> <?php } ?> </td> <td> <?php if ($delstatus=='No' && $dbusercatid!="3") { if($dbuser_id==$admusrid && $rightdelete=='Self') { ?> <a href="arya_mnginstitution.php?sid1=<?php echo $insid; ?>" onclick="return confirm('Are you sure want to delete <?php echo $title;?>?')"><img src="images/delete.gif" border="0" alt="" title="Click here to delete this record" /></a> <?php } else if ($rightdelete=='All') { ?> <a href="arya_mnginstitution.php?sid1=<?php echo $insid; ?>" onclick="return confirm('Are you sure want to delete <?php echo $title;?>?')"><img src="images/delete.gif" border="0" alt="" title="Click here to delete this record" /></a> <?php } else { ?> <img src="images/delete_disable.gif" border="0" alt="" title="Click here to edit this record" /> <?php } } else if($dbusercatid=="3") { ?> <div id="FetchAjaxDataundo[<?php echo $insid;?>]"> <?php if($delstatus=='Yes' ) { if($dbuser_id==$_SESSION["adminuserid"] && $rightdelete=='Self') { ?> <img src="images/undo.jpg" title="Click the button then update undo recored" alt="" onclick="return UpdateUndoDeleted('instundo','No',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if($rightdelete=='All') { ?> <img src="images/undo.jpg" title="Click the button then update undo recored" alt="" onclick="return UpdateUndoDeleted('instundo','No',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/undo_disable.jpg" border="0" alt="" /> <?php } } else if($delstatus=='No') { if($dbuser_id==$_SESSION["adminuserid"] && $rightdelete=='Self') { ?> <img src="images/delete.gif" title="Click the button then delete recored" alt="" onclick="return UpdateUndoDeleted('instundo','Yes',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($rightdelete=='All') { ?> <img src="images/delete.gif" title="Click the button then delete recored" alt="" onclick="return UpdateUndoDeleted('instundo','Yes',<?php echo $insid;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/delete_disable.gif" border="0" alt="" /> <?php } } ?> </div> <?php } ?> </td> <td> <?php if($dbuser_id==$admusrid && $superdelete == 'Self') { ?> <a href="arya_mnginstitution.php?sid=<?php echo $insid;?>" onclick="return confirm('are you sure want to delete this institute <?php echo $title;?> ? this record will be removed from server permanently you can not get that record back.');"> <img src="./images/super_delete.png" border="0" title='<?php echo $clickdelete;?>' alt=""/></a><?php } else if($superdelete == 'All') { ?> <a href="arya_mnginstitution.php?sid=<?php echo $insid;?>" onclick="return confirm('are you sure you want to delete this institute <?php echo $title;?>? this record will be removed from server permanently you can not get that record back.');"> <img src="./images/super_delete.png" border="0" title='<?php echo $clickdelete;?>' alt=""/></a> <?php } else { ?> <img src="images/super_delete_disable.png" border="0" alt="" title="Click here to delete this record" /> <?php } //super delete end ?> </td> </tr> <?php } ?> <!--<tr> <td align="right" colspan="6"></td> <td align="center"><input type="submit" name="updtseq" id="updtseq" value="<?php //echo $btn_update;?>"/></td> <td align="right" colspan="7"></td> </tr>--> <?php if($paging!="") { ?> <tr> <td class="pagination" align="center" colspan="11"><!--pagination end--> <?php echo "<b>".$paging."</b>";?> Go To Page <select name="cmbgtpge" id="cmbgtpge" onchange="return OnPageNumSub(this.value);"> <?php echo GotoPageNumber($numpages,$_SESSION["lngvarpagesesid"]);?> </select> </td><!--pagination end--> <?php } } //if($numrows) over else { echo '<tr><td height="20" colspan="10" align="center"><span class="redMsg">'.$msgNoRecordFound.'</span></td></tr>'; } ?> </table> </td> </tr> </table> </form> <?php // content over // footer start include("arya_footer.php"); // footer over ?>
Close