"text/h323", "acx" => "application/internet-property-stream", "ai" => "application/postscript", "aif" => "audio/x-aiff", "aifc" => "audio/x-aiff", "aiff" => "audio/x-aiff", "asf" => "video/x-ms-asf", "asr" => "video/x-ms-asf", "asx" => "video/x-ms-asf", "au" => "audio/basic", "avi" => "video/x-msvideo", "axs" => "application/olescript", "bas" => "text/plain", "bcpio" => "application/x-bcpio", "bin" => "application/octet-stream", "bmp" => "image/bmp", "c" => "text/plain", "cat" => "application/vnd.ms-pkiseccat", "cdf" => "application/x-cdf", "cer" => "application/x-x509-ca-cert", "class" => "application/octet-stream", "clp" => "application/x-msclip", "cmx" => "image/x-cmx", "cod" => "image/cis-cod", "cpio" => "application/x-cpio", "crd" => "application/x-mscardfile", "crl" => "application/pkix-crl", "crt" => "application/x-x509-ca-cert", "csh" => "application/x-csh", "css" => "text/css", "dcr" => "application/x-director", "der" => "application/x-x509-ca-cert", "dir" => "application/x-director", "dll" => "application/x-msdownload", "dms" => "application/octet-stream", "doc" => "application/msword", "dot" => "application/msword", "dvi" => "application/x-dvi", "dxr" => "application/x-director", "eps" => "application/postscript", "etx" => "text/x-setext", "evy" => "application/envoy", "exe" => "application/octet-stream", "fif" => "application/fractals", "flr" => "x-world/x-vrml", "gif" => "image/gif", "gtar" => "application/x-gtar", "gz" => "application/x-gzip", "h" => "text/plain", "hdf" => "application/x-hdf", "hlp" => "application/winhlp", "hqx" => "application/mac-binhex40", "hta" => "application/hta", "htc" => "text/x-component", "htm" => "text/html", "html" => "text/html", "htt" => "text/webviewhtml", "ico" => "image/x-icon", "ief" => "image/ief", "iii" => "application/x-iphone", "ins" => "application/x-internet-signup", "isp" => "application/x-internet-signup", "jfif" => "image/pipeg", "jpe" => "image/jpeg", "jpeg" => "image/jpeg", "jpg" => "image/jpeg", "js" => "application/x-javascript", "latex" => "application/x-latex", "lha" => "application/octet-stream", "lsf" => "video/x-la-asf", "lsx" => "video/x-la-asf", "lzh" => "application/octet-stream", "m13" => "application/x-msmediaview", "m14" => "application/x-msmediaview", "m3u" => "audio/x-mpegurl", "man" => "application/x-troff-man", "mdb" => "application/x-msaccess", "me" => "application/x-troff-me", "mht" => "message/rfc822", "mhtml" => "message/rfc822", "mid" => "audio/mid", "mny" => "application/x-msmoney", "mov" => "video/quicktime", "movie" => "video/x-sgi-movie", "mp2" => "video/mpeg", "mp3" => "audio/mpeg", "mpa" => "video/mpeg", "mpe" => "video/mpeg", "mpeg" => "video/mpeg", "mpg" => "video/mpeg", "mpp" => "application/vnd.ms-project", "mpv2" => "video/mpeg", "ms" => "application/x-troff-ms", "mvb" => "application/x-msmediaview", "nws" => "message/rfc822", "oda" => "application/oda", "p10" => "application/pkcs10", "p12" => "application/x-pkcs12", "p7b" => "application/x-pkcs7-certificates", "p7c" => "application/x-pkcs7-mime", "p7m" => "application/x-pkcs7-mime", "p7r" => "application/x-pkcs7-certreqresp", "p7s" => "application/x-pkcs7-signature", "pbm" => "image/x-portable-bitmap", "pdf" => "application/pdf", "pfx" => "application/x-pkcs12", "pgm" => "image/x-portable-graymap", "pko" => "application/ynd.ms-pkipko", "pma" => "application/x-perfmon", "pmc" => "application/x-perfmon", "pml" => "application/x-perfmon", "pmr" => "application/x-perfmon", "pmw" => "application/x-perfmon", "pnm" => "image/x-portable-anymap", "pot" => "application/vnd.ms-powerpoint", "ppm" => "image/x-portable-pixmap", "pps" => "application/vnd.ms-powerpoint", "ppt" => "application/vnd.ms-powerpoint", "prf" => "application/pics-rules", "ps" => "application/postscript", "pub" => "application/x-mspublisher", "qt" => "video/quicktime", "ra" => "audio/x-pn-realaudio", "ram" => "audio/x-pn-realaudio", "ras" => "image/x-cmu-raster", "rgb" => "image/x-rgb", "rmi" => "audio/mid", "roff" => "application/x-troff", "rtf" => "application/rtf", "rtx" => "text/richtext", "scd" => "application/x-msschedule", "sct" => "text/scriptlet", "setpay" => "application/set-payment-initiation", "setreg" => "application/set-registration-initiation", "sh" => "application/x-sh", "shar" => "application/x-shar", "sit" => "application/x-stuffit", "snd" => "audio/basic", "spc" => "application/x-pkcs7-certificates", "spl" => "application/futuresplash", "src" => "application/x-wais-source", "sst" => "application/vnd.ms-pkicertstore", "stl" => "application/vnd.ms-pkistl", "stm" => "text/html", "svg" => "image/svg+xml", "sv4cpio" => "application/x-sv4cpio", "sv4crc" => "application/x-sv4crc", "t" => "application/x-troff", "tar" => "application/x-tar", "tcl" => "application/x-tcl", "tex" => "application/x-tex", "texi" => "application/x-texinfo", "texinfo" => "application/x-texinfo", "tgz" => "application/x-compressed", "tif" => "image/tiff", "tiff" => "image/tiff", "tr" => "application/x-troff", "trm" => "application/x-msterminal", "tsv" => "text/tab-separated-values", "txt" => "text/plain", "uls" => "text/iuls", "ustar" => "application/x-ustar", "vcf" => "text/x-vcard", "vrml" => "x-world/x-vrml", "wav" => "audio/x-wav", "wcm" => "application/vnd.ms-works", "wdb" => "application/vnd.ms-works", "wks" => "application/vnd.ms-works", "wmf" => "application/x-msmetafile", "wps" => "application/vnd.ms-works", "wri" => "application/x-mswrite", "wrl" => "x-world/x-vrml", "wrz" => "x-world/x-vrml", "xaf" => "x-world/x-vrml", "xbm" => "image/x-xbitmap", "xla" => "application/vnd.ms-excel", "xlc" => "application/vnd.ms-excel", "xlm" => "application/vnd.ms-excel", "xls" => "application/vnd.ms-excel", "xlt" => "application/vnd.ms-excel", "xlw" => "application/vnd.ms-excel", "xof" => "x-world/x-vrml", "xpm" => "image/x-xpixmap", "xwd" => "image/x-xwindowdump", "z" => "application/x-compress", "zip" => "application/zip" ); $extension = end(explode('.', $fileToAttach)); $mimeType = $mimeTypes[strtolower($extension)]; $fileName = end(explode('/', $fileToAttach)); $attachment = chunk_split(base64_encode(file_get_contents($fileToAttach))); $message=""; //$message=""; $headers=""; # Common Headers $headers .= 'From: <'.$from.'>'.$eol; $headers .= 'Reply-To: <'.$from.'>'.$eol; $headers .= 'Return-Path: <'.$from.'>'.$eol; // these two to set reply address //$headers .= "CC: sapna.maru@alliance-infotech.com".$eol; //Bcc not working //$headers .= "BCC: sapna.maru@alliance-infotech.com".$eol; //$headers .= "Cc: sudip.samaddar@alliance-infotech.com".$eol; //$headers .= "X-Mailer: PHP/".phpversion().$eol; $headers .= "Message-ID: <".$from.">".$eol; //$headers .= "X-Mailer: PHP v".phpversion().$eol; // These two to help avoid spam-filters # Boundry for marking the split & Multitype Headers $mime_boundary=md5(time()); $headers .= 'MIME-Version: 1.0'.$eol; $headers .= "Content-Type: multipart/related; boundary=\"".$mime_boundary."\"".$eol; $msg = ""; # Text Version $msg .= "--".$mime_boundary.$eol; $msg .= "Content-Type: text/html; charset=iso-8859-1".$eol; $msg .= "Content-Transfer-Encoding: 8bit".$eol; $msg .= "".$eol; $msg .= "$emailext$message".$eol.$eol; # Attachment /*$msg .= "--".$mime_boundary.$eol; $msg .= "Content-Type: audio/x-wav; name=\"".$fileName."\"".$eol; $msg .= "Content-Transfer-Encoding: base64".$eol; $msg .= "Content-Disposition: attachment; filename=\"".$fileName."\"".$eol.$eol; // !! This line needs TWO end of lines !! IMPORTANT !! $msg .= $attachment.$eol.$eol;*/ # Setup for text OR html //$msg .= "Content-Type: multipart/alternative".$eol; /*# HTML Version $msg .= "--".$mime_boundary.$eol; $msg .= "Content-Type: text/html; charset=iso-8859-1".$eol; $msg .= "Content-Transfer-Encoding: 8bit".$eol; $msg .= $body.$eol.$eol;*/ # Finished $msg .= "--".$mime_boundary."--".$eol.$eol; // finish with two eol's for better security. see Injection. //print $msg; # SEND THE EMAIL //ini_set(sendmail_from,'hide@address.com'); // the INI lines are to force the From Address to be used ! $msgg=mail($to,$subject, $msg, $headers); return $msgg; } /************FUNCTION TO GET THE COMPANYID OF USERID************************/ function company_id($userid) { global $link; $sql1="select I_CompanyID from tbl_mst_user_company where I_UserID='$userid'"; //print $sql1; $res1=mysqli_query($link,$sql1); $row1 = mysqli_fetch_array($res1); $company_id = $row1['I_CompanyID']; return $company_id; } /**************END OF THE FUNCTION************************/ ############## CODE TO FIND THE COMPANY NAME ################33 ############### AUTHOR :: SUSHILA function company_name($company_id) { global $link; $sql_company="select V_CompanyName from tbl_mst_company where I_CompanyID='$company_id'"; //print $sql_company; $res_company=mysqli_query($link,$sql_company) or die (mysqli_error()); $row_company=mysqli_fetch_array($res_company); $company_name=$row_company['V_CompanyName']; return $company_name; } ################### END OF CODE #############################3 /************FUNCTION TO GET THE DATABASE OF PARTICULAR COMPANY ID************************/ function database_name($company_id) { global $link; $sql_database="select a.V_Company_DBName,a.I_CompanyID,b.I_CompanyID from tbl_mst_company a,tbl_mst_user_company b where (a.I_CompanyID=b.I_CompanyID) and a.I_CompanyID='$company_id'"; //print $sql_database; $res_database=mysqli_query($link,$sql_database); $row_database=mysqli_fetch_array($res_database); $database_name=$row_database['V_Company_DBName']; //$database_name=strtolower($database_name); return $database_name; } /**************END OF THE FUNCTION************************/ function failed_login($table_name,$usname,$reason_failure,$database_name) { mysqli_select_db($link,$database_name); $modificationtime = date("Y-m-d G:i:s"); $ip =getenv('REMOTE_ADDR'); $id=maximum_id($table_name,'SNo'); $sql="insert into $table_name(SNo,IP,AccessedAt,UserName,Reason) values('$id','$ip','$modificationtime','$usname','$reason_failure')"; $res=mysqli_query($link,$sql) or die(mysqli_error("error")) ; } //mysqli_close($link); function date_difff($llogin,$clogin) { global $link; $llogin=split("-",$llogin); $clogin=split("-",$clogin); $cloginstr=mktime(0,0,0,$clogin[1],$clogin[2],$clogin[0]); $lloginstr=mktime(0,0,0,$llogin[1],$llogin[2],$llogin[0]); $diffseconds = $cloginstr-$lloginstr; $days=$diffseconds/(60*60*24); return ceil($days); } /* comment by sush due to dupliacay of function name as already exists in function_doc.php function StoreDateIntoDataBase($date0) { $date1=explode("-",$date0); $date2=$date1[2]."-".$date1[1]."-".$date1[0]; return $date2; }*/ function F_Count_UserID($companyid,$dbname) { global $link; $sql_user_ID = "select count(I_UserID) as ID from $dbname.tbl_mst_user_company where I_UserStatus=1 and I_CompanyID='$companyid'"; $Fetch_USERID=mysqli_query($link,$sql_user_ID); $row=mysqli_fetch_array($Fetch_USERID); return $USERID=$row['ID']; } function F_CompanyUserLicense($companyid,$dbname) { global $link; $sql_user_lience="select * from $dbname.tb_mst_user_licence where I_organistionID='$companyid'"; $res_user_lience=mysqli_query($link,$sql_user_lience) or die(mysqli_error()); while ($fetch_result=mysqli_fetch_array($res_user_lience)) { $I_NUSERS=$fetch_result['I_NUSERS']; } return $I_NUSERS; } function totaluseravialable() { global $link; $companyid = $_SESSION['companyid']; $sql_total_user = "select count(I_CompanyID) as countcid from tbl_mst_user_company where I_UserStatus=1 and I_CompanyID='$companyid'"; $Fetch_CompanyId=mysqli_query($link,$sql_total_user); $row=mysqli_fetch_array($Fetch_CompanyId); $I_CompanyId1=$row['countcid']; return $I_CompanyId1; } ?>