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_mngmember_09-02-16.php
<?php include('arya_AdminInclude.php'); //created by joshi himanshu 21/08/12 Manage Member //header start include('arya_header.php'); //header over // link start include("arya_menu.php"); // link over include("common/excelwriter.class.php"); //This is used for admin rights wise display field Start Added By Vaishali 23/01/2013 $admsessionid=$_SESSION["adminuserid"]; $dbusercatid=getFieldValue('admcat_id','arya_adminuser','admuser_id="'.$admsessionid.'"'); $rightsid=mysql_query('SELECT admsecright_pageid FROM arya_adminsectionrights WHERE admcat_id IN('.$dbusercatid.') AND admuser_id="'.$admsessionid.'"'); 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="'.$admsessionid.'" 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.'"'); //This is used for admin rights wise display field End Added By Vaishali 23/01/2013 $logindate=date('Y-m-d h:i:s'); // content start $curntdate=date('Y-m-d'); $curnttime= date('h:i:s'); if(isset($_POST["updtseq"])) { foreach($_POST["txtuptseqid"] as $Member_ID=>$M_sequence) { $updsequence="UPDATE arya_member SET meb_sequence=".$M_sequence." where meb_id='".$Member_ID."'"; $reupdseq=mysql_query($updsequence); } if($reupdseq) { $updtseqmembtitle=getFieldValue('meb_firstname','arya_member','meb_id="'.$Member_ID.'"'); getadminactivity('title_mngmember',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$updtseqmembtitle,$curntdate,$curnttime); $msg=$msgUpdateRecord; } } if(isset($_POST['submitdelete'])) { foreach($_POST["txtsupercheck"] as $MemdelId) { $updtsupdelmembtitle=getFieldValue('meb_firstname','arya_member','meb_id="'.$MemdelId.'"'); getadminactivity('title_mngmember',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$updtsupdelmembtitle,$curntdate,$curnttime); $filesmallimage=getFieldValue('meb_profilephoto','arya_member','meb_id='.$MemdelId); $image=str_replace("./","media/",$filesmallimage); $filebigimage=str_replace('SM','BG',$image); unlink($image); unlink($filebigimage); $smallimage=getFieldValue('meb_profilephoto','arya_member','meb_id='.$MemdelId); $bigimage=str_replace('SM','BG',$smallimage); $mainimage=str_replace('SM_','',$smallimage); $mainphotimage=str_replace('media','photo',$mainimage); if($conditionvar=='2') { unlink($smallimage); unlink($bigimage); unlink($mainphotimage); } if($conditionvar=='1') { include('arya_ftpfile.php'); ftp_delete($srvconnect_id ,$smallimage); ftp_delete($srvconnect_id ,$bigimage); ftp_delete($srvconn_id ,$mainimage); } $suploginid=getFieldValue('login_id','arya_member','meb_id='.$MemdelId); $delusertype="DELETE FROM arya_member WHERE meb_id='".$MemdelId."'"; $qrydelusertype=mysql_query($delusertype); if($qrydelusertype) { $delulogin="DELETE FROM arya_userlogin WHERE login_id='".$suploginid."'"; $qryulogin=mysql_query($delulogin); if($qryulogin) { $delulogincheck="DELETE FROM arya_usercheck WHERE login_id='".$suploginid."'"; $qryulogincheck=mysql_query($delulogincheck); if($qryulogincheck) { $msg=$msgDeleteRecord; } } } } } if($_POST['page'] !="") { $_SESSION["lngvarpagesesid"]=$_POST['page']; } else if($_GET["msg"] !="") { $_POST['page']=$_SESSION["lngvarpagesesid"]; } else { unset($_SESSION["lngvarpagesesid"]); } if(isset($_POST['btnexprtdata'])) { $excel=new ExcelWriter("MemberExportData.xls"); if($excel==false) echo $excel->error; //$myArr=array("Member Id","Login Id","Language","Country","Firstname","Lastname","Gender","Date Of Birth","Member Type","Profile Photo","Address","Mobile No","Profile Name","Tag Line","Language Known","Term & Conditions","Sequence","Visible","Verify Date","Update Date","Verification","Show Home","Enable/Disable","Delete Status","User Id","IP Address","Random No","Record Date"); //$excel->writeLine($myArr); $myArr=array("Name","Email","Country","Member Since","Last Visited","Verified"); $excel->writeLine($myArr); $qry=mysql_query("select * from arya_member"); $numrws=mysql_num_rows($qry); $i=1; while($fetchrw=mysql_fetch_array($qry)) { $dbLang_id=$fetchrw['lang_id']; $dbCnt_id=$fetchrw['cnt_id']; $dbLgn_id=$fetchrw['login_id']; $dbLgn_recorddate=$fetchrw['recorddate']; $dbLgn_lastlogin=date("d-m-Y H:i:s",strtotime($dbLgn_recorddate)); $dbMem_typeid=$fetchrw['meb_type']; $dbMem_firstname=$fetchrw['meb_firstname']; $dbMem_lastnameEnglish=$fetchrw['meb_lastname']; $dbMem_memname=stripslashes($dbMem_firstname." ".$dbMem_lastnameEnglish); $member_email=getFieldValue('login_name','arya_userlogin','login_id="'.$dbLgn_id.'"'); $lang_name=getFieldValue('lang_name','arya_language','lang_id="'.$dbLang_id.'"'); $country_name=getFieldValue('cnt_name','arya_country','cnt_id="'.$dbCnt_id.'"'); $membr_typname=getFieldValue('mtype_name','arya_membertype','mtype_id="'.$dbMem_typeid.'"'); $membr_langknwn=getFieldValue("lang_name","arya_language","lang_id IN (".$dbMem_langknwn.")"); $dbMem_langknwn=$fetchrw['meb_langknown']; //$dbMem_langknwn=explode(",",$fetchrw['meb_langknown']); //$myArr=array($fetchrw['meb_id'],$fetchrw['login_id'],$lang_name,$country_name,$fetchrw['meb_firstname'],$fetchrw['meb_lastname'],$fetchrw['meb_gender'],$fetchrw['meb_dob'],$membr_typname,$fetchrw['meb_profilephoto'],$fetchrw['meb_address'],$fetchrw['meb_mobno'],$fetchrw['meb_profilename_english'],$fetchrw['meb_tagline'],$dbMem_langknwn,$fetchrw['meb_termcond'],$fetchrw['meb_sequence'],$fetchrw['meb_visible'],$fetchrw['meb_verifydate'],$fetchrw['meb_updatedate'],$fetchrw['meb_verification'],$fetchrw['meb_showhome'],$fetchrw['meb_enabledisable'],$fetchrw['mem_delstatus'],$fetchrw['user_id'],$fetchrw['meb_ip'],$fetchrw['mem_randno'],$fetchrw['recorddate']); $myArr=array($dbMem_memname,$member_email,$country_name,$fetchrw['meb_verifydate'],$dbLgn_lastlogin,$fetchrw['meb_verifydate']); // foreach($dbMem_langknwn as $val) // { // if($val!="") // { // //echo $val; // echo $M_langName=getFieldValue('lang_name','arya_language','lang_id="'.$val.'"'); // // } // // } $excel->writeLine($myArr); $i++; } //RedirecPage('download.php?filename=MemberExportData.xls'); ?> <script language="javascript"> var y = confirm("Do You Want To Download MemberData?"); if(y==true) { var url = "download.php?filename=MemberExportData.xls"; var win = window.open(url, '_blank'); win.document.title = "Export Member Data"; win.setTimeout('self.close()', 2000); alert("Export Data Successfully."); } //win.close(); //setTimeout(function () { win.close();}, 300000); </script> <?php } if(isset($_GET["delid1"]) && $_GET["delid1"]!="") { $updtdelmembtitle=getFieldValue('meb_firstname','arya_member','meb_id="'.$_GET["delid1"].'"'); getadminactivity('title_mngmember',$pagesecid,$_SESSION["adminuserid"],$_SERVER["REMOTE_ADDR"],$updtdelmembtitle,$curntdate,$curnttime); $Loginid=getFieldValue('login_id','arya_member','meb_id='.$_GET["delid1"]); $delusertype="UPDATE arya_member SET mem_delstatus='Yes' WHERE meb_id='".$_GET["delid1"]."'"; $qrydelusertype=mysql_query($delusertype); if($qrydelusertype) { $delulogin="UPDATE arya_userlogin SET login_delstatus='Yes' WHERE login_id='".$Loginid."'"; $qryulogin=mysql_query($delulogin); if($qryulogin) { $delulogincheck="UPDATE arya_usercheck SET usercheck_delstatus='Yes' WHERE login_id='".$Loginid."'"; if($qryulogincheck) { $msg=$msgDeleteRecord; } } } } if($_POST['page']=="" && $_GET["delid"]=="" && $_GET['clnm']=="") //not use pagination that time unset all session { unset($_SESSION["sesverserid"]); unset($_SESSION["sesmememailid"]); unset($_SESSION["sesmemnmid"]); unset($_SESSION["sesmemlevlid"]); unset($_SESSION["sesmemlangid"]); unset($_SESSION["cmbrcdprpge"]); unset($_SESSION["sesmemfrstnmid"]); unset($_SESSION['sesmidnmid']); /*$_SESSION["sesverserid"]=$cmbmemverify; $_SESSION["sesmememailid"]=$cmbmemEmail; $_SESSION["sesmemnmid"]=$cmbmemName; $_SESSION["sesmemlevlid"]=$cmbmemLevel; $_SESSION["sesmemlangid"]=$cmblmemlng; $_SESSION["cmbrcdprpge"]=$cmbrcdprpge;*/ } if($_GET["msg"]!="" && $_GET["msg"]=='updt') { $msg=$msgUpdateRecord; } if($_GET["msg"]!="" && $_GET["msg"]=='upd') { $msg=$msgUpdateRecord; } if($_POST['cmbMemEmail']!="" || $_POST['cmbMemNm']!="" || $_POST['cmbMLevel']!="" || $_POST['cmbLange']!="" || $_POST['cmbVerify']=='No' || $_POST['cmbVerify']=='Yes' || $_POST['cmbrcdprpge']>0) { $cmbmemverify=$_POST['cmbVerify']; $cmbmemEmail=$_POST['cmbMemEmail']; $postcmbMemNm=explode(" ",$_POST['cmbMemNm']); $cmbmemfrstnm=$postcmbMemNm[0]; $cmbmemlastnm=$postcmbMemNm[1]; $cmbmemName=$_POST['cmbMemNm']; $cmbmemLevel=$_POST['cmbMLevel']; $postmeblang=explode(",",$_POST['cmbLange']); $cmblmemlng=$postmeblang[1]; $cmbrcdprpge=$_POST['cmbrcdprpge']; $_SESSION["sesverserid"]=$cmbmemverify; $_SESSION["sesmememailid"]=$cmbmemEmail; $_SESSION["sesmemfrstnmid"]=$cmbmemfrstnm; $_SESSION['sesmidnmid']=$cmbmemlastnm; $_SESSION["sesmemlevlid"]=$cmbmemLevel; $_SESSION["sesmemlangid"]=$cmblmemlng; $_SESSION["cmbrcdprpge"]=$cmbrcdprpge; } /*if($_POST['cmbMemEmail']!="" || $_POST['cmbmember']>0 || $_POST['cmbVerify']=='Yes' || $_POST['cmbVerify']=='No' || $_POST['cmbrcdprpge']>0) { //$cmbmemverify=$_POST['cmbVerify']; $cmbmemtype=$_POST['cmbmember']; $cmbmemEmail=$_POST['cmbMemEmail']; $cmbrcdprpge=$_POST['cmbrcdprpge']; $_SESSION["sesverserid"]=$cmbmemverify; $_SESSION["sesmemtyserid"]=$cmbmemtype; $_SESSION["sesmememailid"]=$cmbmemEmail; $_SESSION["cmbrcdprpge"]=$cmbrcdprpge; }*/ if($_GET['mverfy']=='Yes' || $_GET['mverfy']=='No') { $_SESSION["sesverserid"]=$_GET['mverfy']; //$cmbmemverify = $_GET['memverify']; //$cmbmemtype = $_GET['memtypeid']; } if($_GET['mtypid'] > 0) { $_SESSION["sesmemtyserid"]=$_GET['mtypid']; } if($_GET['mlogid'] > 0) { $_SESSION["sesmememailid"]=$_GET['mlogid']; } $columnname = ""; if ($_GET['clnm']) { $columnname = $_GET['clnm']; } else { $columnname ="recorddate"; } // Get the value of either ascending or descending $order = ""; if ($_GET['order']) { $order = $_GET['order']; } else { $order ="ASC"; } if ($columnname == "") { $columnname = "proposalno"; } // Make the default order sorting if ($order == "") { $order = "ASC"; } elseif ($order == "ASC") { $order = "DESC";} elseif ($order == "DESC") { $order = "ASC";} if($fesaproveid=="Self" || $fesaproveid=="All") { $disbut=""; } else { $disbut='disabled="disabled"'; } //this is use for come from edit form display select page start if($_POST['page'] != "") { $_SESSION["pagesesid"]=$_POST['page']; } else if($_GET["msg"] != '' || $_GET["delid"] > 0) { $_POST['page']=$_SESSION["pagesesid"]; } else { unset($_SESSION["pagesesid"]); } //this is use for come from edit form display select page end if($order=='ASC') { $style='class="asecnding"'; $ascdescicon='images/up.png'; } if($order=='DESC') { $style='class="descending"'; $ascdescicon='images/down.png'; } if($_GET['clnm']=='meb_firstname') { $meb_firstname='<img src='.$ascdescicon.' '.$style.' />'; } if($_GET['clnm']=='mlevel_id') { $mlevel_id='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='login_name') { $login_name='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_verifydate') { $meb_verifydate='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='recorddate') { $recorddate='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_type') { $mtype_name='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_verification') { $meb_verification='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_visible') { $meb_visible='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_enabledisable') { $meb_enabledisable='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='meb_ip') { $meb_ipadrs='<img src='.$ascdescicon.' '.$style.' />'; } else if($_GET['clnm']=='lang_id') { $meb_langid='<img src='.$ascdescicon.' '.$style.' />'; } else { $recorddate='<img src='.$ascdescicon.' '.$style.' />'; } ?> <script language="javascript"> $(document).ready(function(){ $("#cmbMemEmail").autocomplete("arya_searchmemberemail.php", { selectFirst: true }); $("#cmbMemEmail").result(function(event, data, formatted) { var hidden = $("#rowID"); hidden.val(data[1]); var b=$("#rowID").val(); }); $("#cmbMemNm").autocomplete("arya_searchmembrnm.php", { selectFirst: true }); $("#cmbMemNm").result(function(event, data, formatted) { var hidden = $("#rowID12"); hidden.val(data[1]); var b=$("#rowID12").val(); }); $('#check_all').click(function() { if( $('#check_all').is(":checked") ) { $(':checkbox').each(function() { this.checked = true; }); } else { $(':checkbox').each(function() { this.checked = false; }); } }); $('input[id="txtsupercheck[]"]').bind('change', function() { if ( $('input[id="txtsupercheck[]"]').filter(':not(:checked)').length == 0 ) { $('#check_all').attr("checked",true); } else { $('#check_all').attr("checked",false); } }); }); </script> <!--use for paginination start--> <form action="" method="post" name="frmpaging" id="frmpaging" > <input type="hidden" name="page" value="" /> </form> <!--use for paginination end--> <script language="javascript"> $(function(){ //DELETE BUTTON AND SEE IF CHECKBOXES ARE CHECKED $('#submitdelete').click(function(){ $('input[type=checkbox]:checked').each(function(){ var the_id = $(this).val(); var data = "id="+the_id; //DELETES THE ITEMS ONE AT A TIME }); }); //FOR THE CHECKBOX $("input[type=checkbox]").click(function(){ var x = $("input[type=checkbox]:checked").length; var t = $("input[type=checkbox]").length; //IF EVERY CHECKBOX IS CHECKED... if(t==x){ //HIDES 'CHECK ALL' AND SHOWS UNCHECK ALL' & 'DELETE' BUTTONS $("#chkall").hide(); $("#submitdelete").show(); } else { //IF NOT, ALL BUTTONS WILL BE SHOWN, HIDES 'UNCHECK ALL' & 'DELETE' IF NOTHING IS CHECKED $("#chkall").hide(); $("#submitdelete").show(); if(x==0){ $("#submitdelete").hide(); if($("#submitdelete").hide()) { $("#chkall").show(); } } } }); //IF CHECK ALL IS PRESS... $("#chkall").live("click", function(){ //FILL IN ALL CHECKBOXES $("input[type=checkbox]").each(function(){ $(this).attr("checked", true); }); //JUST SHOWS 'UNCHECK ALL' & 'DELETE' BECAUSE NOW ALL BOXES ARE CHECKED $(this).hide(); $("#submitdelete").show(); }); //IF UNCHECK ALL IS PRESS... //CLEARS IN ALL CHECKBOXES $("input[type=checkbox]").each(function(){ $(this).attr("checked", false); }); //JUST SHOWS 'CHECK ALL' BECAUSE NOW ALL BOXES ARE UNCHECKED $("#submitdelete").hide(); $("#chkall").show(); }); </script> <form action="http://<?php echo $_SERVER['HTTP_HOST'];?>/publicprofilepage" method="post" name="frmpubprofile" id="frmpubprofile" target="_new"> <input type="hidden" name="clientuserid" id="clientuserid" value="" /> </form> <form method="post" action="arya_mngmember.php" name="frmmngmember" id="frmmngmember" enctype="multipart/form-data"> <table width="100%" summary="" border="0" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" height="85"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr><td width="45%"></td> <td align="center" width="12%"><h2 class="bigheader"><?php echo $title_mngmember; ?></h2></td> <td width="55%"></td> </tr> </table> </td> </tr> <?php echo SuccessMessage($msg);?> <tr> <td align="right" width="45%"><?php echo $lbl_name; ?> : </td> <td> <input type="text" name="cmbMemNm" id="cmbMemNm" class="txtbox" value="<?php if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION['sesmidnmid']!=""){echo $_SESSION["sesmemfrstnmid"]." ".$_SESSION['sesmidnmid'];}?>"/> <input type="hidden" name="rowID" id="rowID" value=""/> <input type="hidden" name="rowID12" id="rowID12" value=""/> </td> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_selectemail; ?> : </td> <td> <input type="text" name="cmbMemEmail" id="cmbMemEmail" class="txtbox" value="<?php echo $_SESSION["sesmememailid"];?>"/> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_sellevel; ?> : </td> <td> <select name="cmbMLevel" id="cmbMLevel" class="selbox"> <option value=""><?php echo $lbl_sellevel; ?></option> <?php echo GetMemberLevel($_SESSION["sesmemlevlid"]);?> </select></td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_prefredlange; ?> : </td> <td> <select name="cmbLange" id="cmbLange" class="selbox"> <option value=""><?php echo $lbl_selectlanguage; ?></option> <?php echo GetAllLanguage($_SESSION["sesmemlangid"]); ?> </select> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_verify; ?> : </td> <td> <select name="cmbVerify" id="cmbVerify" class="selbox"> <option value=""><?php echo $lbl_selverify; ?></option> <?php echo getMemberVerify($_SESSION["sesverserid"]); ?> </select> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr> <td align="right" width="45%"><?php echo $lbl_selctrecdprpge; ?> : </td> <td> <select name="cmbrcdprpge" id="cmbrcdprpge" class="selbox"> <option value="0"><?php echo $lbl_selctrecdprpge; ?></option> <?php echo getRecordPrPg($_SESSION["cmbrcdprpge"]); ?> </select> </td> </tr> <tr><td height="5" colspan="2"></td></tr> <tr><td> </td><td height="5"> <input type="submit" name="btnsearch" id="btnsearch" value="Search"/> <div align="right" style="margin-right:35px;"> <input type="submit" name="btnexprtdata" id="btnexprtdata" value="Export Data To Excel"/> </div> </td> </tr> <tr><td height="5"></td></tr> <tr><td align="center" colspan="2"> <table summary="" border="1" align="center" width="95%" cellpadding="0" cellspacing="0"> <tr class="tblborder" align="center"> <td><input type="checkbox" id="check_all" name="check_all" value='Yes' />Select All</td> <!--td width="10%"><?php //echo $lbl_delete; ?></td--> <td align='center' width="10%"><?php echo $lbl_photo;?></td> <td width="15%"><a href="arya_mngmember.php?clnm=meb_firstname&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_name; ?><?php echo $meb_firstname; ?></a></td> <td width="10%"><a href="arya_mngmember.php?clnm=mlevel_id&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_level; ?><?php echo $mlevel_id; ?></a></td> <td width="15%"><a href="arya_mngmember.php?clnm=login_name&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_email; ?><?php echo $login_name; ?></a></td> <td width="10%"><a href="arya_mngmember.php?clnm=meb_verifydate&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_since; ?><?php echo $meb_verifydate; ?></a></td> <td width="10%"><a href="arya_mngmember.php?clnm=recorddate&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_lastvisited; ?><?php echo $recorddate; ?></a></td> <td width="10%"><a href="arya_mngmember.php?clnm=meb_ip&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_lastvisitipadrs; ?><?php echo $meb_ipadrs; ?></a></td> <td width="10%"><a href="arya_mngmember.php?clnm=lang_id&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_prefredlange;?><?php echo $meb_langid;?></a></td> <td width="10%"><?php echo $lbl_viewprofile;?></td> <?php if($_SESSION["adminuserid"] == 1) { ?> <td width="8%" align="center">View Password</td> <?php } ?> <td width="6%"><a href="arya_mngmember.php?clnm=meb_verification&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_verify; ?><?php echo $meb_verification; ?></a></td> <td width="8%"><a href="arya_mngmember.php?clnm=meb_enabledisable&order=<?php echo $order;?>" style="text-decoration:none;"><?php echo $lbl_enable; ?><?php echo $meb_enabledisable; ?></a></td> <td align='center' width="8%"><?php echo $lbl_edit;?></td> </tr> <?php $admincatid=getFieldValue('admcat_id','arya_adminuser','admuser_id="'.$_SESSION["adminuserid"].'"'); if($admincatid=="3") { unset($_SESSION["memfrstnmid"]); unset($_SESSION["midnmid"]); unset($_SESSION["mememailid"]); unset($_SESSION["memlangid"]); unset($_SESSION["verserid"]); unset($_SESSION["rcdprpge"]); unset($_SESSION["rcdlevelid"]); if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0 && $_SESSION["sesmemlevlid"]>0) //name,email,lang,verf,prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //name,email,lang,verf,prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //name,email,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //name,email,lang,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //name,email,lang,verf,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //name,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //email,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //lang,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //verf,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!=0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]==0 && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0 && $_SESSION["sesmemlevlid"]>0) //prp,level { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.mlevel_id='".$_SESSION["sesmemlevlid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["rcdlevelid"]=$_SESSION["sesmemlevlid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]>0 && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //name,email,lang,verf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //name,email,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //name,email { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //name,email,lang,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //name,email,lang { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //email,lang,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //email,lang { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //email,lang,vrf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //email,lang,vrf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //lang,verf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //lang,verf,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //lang,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //lang { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; } // else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmidnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //lang // { // echo "1".$selmem="SELECT *,CONCAT( meb_firstname, ' ', meb_middlename, ' ', meb_lastname ) AS meb_firstname FROM arya_member,arya_userlogin WHERE meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; // // $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; // // // } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //name { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //email { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //vrf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //lang { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]==0) //name,lang { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //name,lang,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //name,vrf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //name,vrf,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //email,vrf { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //email,vrf,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //vrf,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //name,email,ver,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //name,email,ver { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]=="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]!=0) //email,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //name,lang,ver { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]!="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]!=0) //name,lang,ver { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE arya_member.meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.lang_id='".$_SESSION["sesmemlangid"]."' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["memlangid"]=$_SESSION["sesmemlangid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]!="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]!="" && $_SESSION["cmbrcdprpge"]==0) //name,email,ver,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.meb_verification='".$_SESSION["sesverserid"]."' AND arya_userlogin.login_name='".$_SESSION["sesmememailid"]."' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["mememailid"]=$_SESSION["sesmememailid"]; $_SESSION["verserid"]=$_SESSION["sesverserid"]; } else if($_SESSION["sesmemfrstnmid"]!="" && $_SESSION["sesmememailid"]=="" && $_SESSION["sesmemlangid"]=="" && $_SESSION["sesverserid"]=="" && $_SESSION["cmbrcdprpge"]>0) //name,email,ver,prp { $selmem="SELECT * FROM arya_member,arya_userlogin WHERE meb_firstname LIKE '%".$_SESSION["sesmemfrstnmid"]."%' AND arya_member.login_id = arya_userlogin.login_id ORDER BY arya_member.$columnname $order"; $_SESSION["memfrstnmid"]=$_SESSION["sesmemfrstnmid"]; $_SESSION["rcdprpge"]=$_SESSION["cmbrcdprpge"]; $limit=$_SESSION["rcdprpge"]; } else if($columnname=="login_name") { $selmem="SELECT * FROM arya_member,arya_userlogin ORDER BY $columnname $order"; } else { $selmem="SELECT * FROM arya_member ORDER BY $columnname $order"; } } $qrymem=mysql_query($selmem); $numrows=mysql_num_rows($qrymem); if($numrows > 0) { $page =$_POST['page']; if($_SESSION["cmbrcdprpge"]>0) { $limit=$_SESSION["cmbrcdprpge"]; } else { $limit=$mngmemberpagelimit; } /*$script_name="arya_mngmember.php"; $paging=display_paginglist($page,$numrows,$limit,$script_name,$pagequery_vars); $qrymem=mysql_query($selmem." limit $eu, $limit ") or GoToErrorPage();*/ $script_name="arya_mngmember.php"; $pager = getPagerData($numrows, $limit, $page); $numpages=$pager->numPages; $paging=display_paginglist($page,$numrows,$limit,$script_name,$pagequery_vars); $qrymem=mysql_query($selmem." limit $eu, $limit ") or GoToErrorPage(); while($fetchmem=mysql_fetch_array($qrymem)) { $M_Profile_Photo=$fetchmem["meb_profilephoto"]; $imagename=str_replace("./","",$M_Profile_Photo); $M_Type=$fetchmem["meb_type"]; $Member_ID=$fetchmem["meb_id"]; $Member_levelID=$fetchmem["mlevel_id"]; $Member_levelName=getFieldValue("mlevel_name","arya_memberlevel","mlevel_id=".$Member_levelID.""); $dbuserid=$fetchmem["user_id"]; $Member_Login=$fetchmem["login_id"]; $Member_Langid=$fetchmem["lang_id"]; $M_firstname=stripslashes($fetchmem["meb_firstname"]); $M_firstnamedev=stripslashes($fetchmem["meb_firstnamhindi"]); $M_firstnameother=stripslashes($fetchmem["meb_firstnameother"]); $M_middlenameEnglish=stripslashes($fetchmem["meb_middlename"]); $M_middlenameHindi=stripslashes($fetchmem["meb_middlenamehindi"]); $M_middlenameOther=stripslashes($fetchmem["meb_middlenameother"]); $M_lastnameEnglish=stripslashes($fetchmem["meb_lastname"]); $M_lastnameHindi=stripslashes($fetchmem["meb_lastnamehindi"]); $M_lastnameOther=stripslashes($fetchmem["meb_lastnameother"]); $M_sequence=$fetchmem["meb_sequence"]; $delstatus=$fetchmem["mem_delstatus"]; $M_showhome=$fetchmem["meb_showhome"]; $M_approve=$fetchmem["meb_verification"]; $M_visible=$fetchmem["meb_visible"]; $M_enabledisable=$fetchmem["meb_enabledisable"]; $M_recorddate=$fetchmem['recorddate']; $meb_verifydate=$fetchmem['meb_verifydate']; $meb_ipadrs=$fetchmem['meb_ip']; if($M_recorddate=="0000-00-00 00:00:00") { $M_lastlogin="0000-00-00 00:00:00"; } else { $M_lastlogin=date("d-M-Y H:i:s",strtotime($M_recorddate)); } if($meb_verifydate=="0000-00-00 00:00:00") { $M_verifydate="0000-00-00 00:00:00"; } else { $M_verifydate=date("d-M-Y H:i:s",strtotime($meb_verifydate)); } $membertype=getFieldValue("mtype_name","arya_membertype","mtype_id=".$M_Type.""); $M_Email=getFieldValue("login_name","arya_userlogin","login_id=".$Member_Login.""); $M_langName=getFieldValue('lang_name','arya_language','lang_id="'.$Member_Langid.'"'); $memname=stripslashes($M_firstname." ".$M_middlenameEnglish." ".$M_lastnameEnglish); //use for display total site view user wise start date : 27-11-15 $selq = mysql_query("SELECT * FROM arya_totalsiteview WHERE user_id = '".$Member_Login."'"); $totalvw=""; if(mysql_num_rows($selq)>0) { $v=1; while($fetvwsite=mysql_fetch_array($selq)) { if($v==1) { $totalvw=$fetvwsite["view_total"]; } else { $totalvw+=$fetvwsite["view_total"]; } $v++; } } //use for display total site view user wise end ?> <?php //if($delstatus=='No'){ ?> <!--<tr align="center" ><?php //} else {?> <tr align="center" bgcolor="#CCCCCC" >--><?php //} ?> <tr align="center" > <td> <?php if($fesaproveid == 'Self') { ?> <input type="checkbox" name="txtsupercheck[<?php echo $Member_ID; ?>]" id="txtsupercheck[]" value="<?php echo $Member_ID; ?>" /> <?php } else if($fesaproveid=='All') { ?> <input type="checkbox" name="txtsupercheck[<?php echo $Member_ID; ?>]" id="txtsupercheck[]" value="<?php echo $Member_ID; ?>"/> <?php } else { ?> <input type="checkbox" name="txtsupercheck[<?php echo $Member_ID; ?>]" id="txtsupercheck[]" value="<?php echo $Member_ID; ?>" disabled="true" /> <?php } ?> </td> <td> <?php if($M_Profile_Photo=="adult.png") { ?> <img src='../images/adult.png' border='0' alt='' title='' height='100' width='100'> <?php } else if($M_Profile_Photo=="yung.png") { ?> <img src='../images/yung.png' border='0' alt='' title='' height='100' width='100'> <?php } else if($M_Profile_Photo=="oldage.png") { ?> <img src='../images/oldage.png' border='0' alt='' title='' height='100' width='100'> <?php } else if($M_Profile_Photo!="") { ?> <img src='<?php echo $pathvar.$imagename; ?>' border='0' alt='' title='' height="100" width="100" > <?php } else { ?> <img src="images/imagesnot.jpeg" alt="" height="100" width="100" /> <?php } ?> </td> <td><?php echo $memname; ?> </td> <td><?php echo $Member_levelName; ?> </td> <td><?php echo $M_Email;?><?php if($totalvw != "") { ?> (<?php echo $totalvw; ?>) <?php } ?> </td> <td><?php echo $M_verifydate;?></td> <td><?php echo $M_lastlogin;?></td> <td><?php echo $meb_ipadrs;?></td> <td><?php echo $M_langName;?></td> <td><a href="javascript:RedirectFinduserid(<?php echo $Member_Login; ?>);"><?php echo $lbl_viewprofile;?></a></td> <?php if($_SESSION["adminuserid"] == 1) { ?> <td><a class="iframe" href="arya_getpwd.php?intid=<?php echo $Member_Login; ?>" title=''>Get Password</a></td> <?php } ?> <td><div id="FetchAjaxDataVisible[<?php echo $Member_ID;?>]"><?php if($M_approve=='Yes'){ if($dbuserid==$admsessionid && $fesaproveid=='Self') { ?> <img src="images/greendot.png" title="Click the button then update verify" alt="" onclick="return UpdateVisibleInvisibleVal('memapp','No',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/greendot.png" title="Click the button then update verify" alt="" onclick="return UpdateVisibleInvisibleVal('memapp','No',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/greendot_d.png" alt=""/> <?php } ?> <?php } else if($M_approve=='No') { if($dbuserid==$admsessionid && $fesaproveid=='Self') { ?> <img src="images/reddot.png" title="Click the button then update verify" alt="" onclick="return UpdateVisibleInvisibleVal('memapp','Yes',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/reddot.png" title="Click the button then update verify" alt="" onclick="return UpdateVisibleInvisibleVal('memapp','Yes',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/reddot_d.png" alt=""/> <?php } ?> <?php }?> </div></td> <td> <div id="FetchAjaxDataEnable[<?php echo $Member_ID;?>]"> <?php if($M_enabledisable=='Yes'){ if($dbuserid==$admsessionid && $fesaproveid=='Self') { ?> <img src="images/greenstar.png" title="Click the button then update member enable" alt="" onclick="return UpdateEnableDisableVal('memenbl','No',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/greenstar.png" title="Click the button then update member enable" alt="" onclick="return UpdateEnableDisableVal('memenbl','No',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/greenstar_d.png" alt=""/> <?php } ?> <?php } else if($M_enabledisable=='No') { if($dbuserid==$admsessionid && $fesaproveid=='Self') { ?> <img src="images/redstar.png" title="Click the button then update member enable" alt="" onclick="return UpdateEnableDisableVal('memenbl','Yes',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else if ($fesaproveid=='All') { ?> <img src="images/redstar.png" title="Click the button then update member enable" alt="" onclick="return UpdateEnableDisableVal('memenbl','Yes',<?php echo $Member_ID;?>,<?php echo $pagesecid; ?>);" style="cursor:pointer;"/> <?php } else { ?> <img src="images/redstar_d.png" alt=""/> <?php } ?> <?php }?> </div> </td> <td> <?php if($dbuserid==$admsessionid && $rightedit=='Self') { ?> <a href="arya_editmember.php?memid=<?php echo $Member_ID;?>&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_editmember.php?memid=<?php echo $Member_ID;?>&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> </tr> <?php } ?> <tr align="center"> <td align="center"> <?php if($fesaproveid == 'Self') { ?> <input class="chktoggle" id="chkall" type="button" value="<?php echo "Super Delete"; ?>" disabled="true"><input id="submitdelete" name="submitdelete" type="submit" value="<?php echo "Super Delete"; ?>" onclick="return confirm('Are you sure you want to permanent delete this record?')" /> <?php } else if($fesaproveid=='All') { ?> <input class="chktoggle" id="chkall" type="button" value="<?php echo "Super Delete"; ?>" disabled="true"><input id="submitdelete" name="submitdelete" type="submit" value="<?php echo "Super Delete"; ?>" onclick="return confirm('Are you sure you want to permanent delete this record?')" /> <?php } else { ?> <input type="submit" name="submitdelete" id="submitdelete" value="<?php echo "Super Delete"; ?>" disabled="true" /> <?php } ?> </td> <td colspan="13"></td> </tr> <?php if($paging!="") { ?> <tr> <!--<td class="pagination" align="center" colspan="13"> <?php //echo $paging;?> </td>--><!--pagination end--> <td class="pagination" align="center" colspan="14"><!--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> <?php }// if($paging!="") } else { echo '<tr><td align="center" colspan="12"><span class="redMsg">'.$msgNoRecordFound.'</span></td></tr>'; } ?> </table> </td> </tr> </table> </form> <?php // content over // footer start include("arya_footer.php"); // footer over ?>
Close
