functions login = ".$login;echo "
functions pword = ".$pword;
function checkLogin($uname,$passwd){
return executeSingleRowQuery("select * from admin where uname='$uname' and passwd='$passwd'");
};
function checkURL($url){
return executeSingleRowQuery("select * from mylinks where url='$url'");
};
function addURL($title,$url,$uname,$passwd){
$query="insert into mylinks(title,url,uname,passwd) values('$title','$url','$uname','$passwd')";
return executeInsertQuery($query);
};
function removeURL($id=0,$url=""){
if($id) $query="delete from mylinks where id='$id'";
elseif(!empty($url)) $query="delete from mylinks where url='$url'";
else return false;
return executeInsertUpdateDeleteQuery($query);
};
function updateLink($lid,$title,$url,$uname,$passwd){
$query="update mylinks set title='$title', url='$url', uname='$uname',passwd='$passwd' where id='$lid'";
return executeInsertUpdateDeleteQuery($query);
};
function getURL($id){
return executeSingleRowQuery("select * from mylinks where id='$id'");
};
function getURLList(){
$query="select * from mylinks order by title asc";
return executeMultipleRowQuery($query);
};
function checkFile($fl){
return executeSingleRowQuery("select * from myfiles where file='$fl'");
};
function addFile($title="",$rename="",$file,$file_name){
$ctime=time();
if(!empty($rename)) $fln=$rename;
else $fln=$file_name;
if(uploadFile($file,$fln)){
$query="insert into myfiles(ctime,title,file) values('$ctime','$title','$fln')";
return executeInsertQuery($query);
}else
return false;
};
function deleteFile($file){
global $__FTP_SET;
$retval=false;
$ftp=ftp_connect($__FTP_SET['host']);
if($ftp){
$log=ftp_login($ftp,$__FTP_SET['user'],$__FTP_SET['pass']);
if($log){
if(@ftp_chdir($ftp,$__FTP_SET['path'])){
if(ftp_delete($ftp,$file)){
executeInsertUpdateDeleteQuery("delete from myfiles where file='$file'");
$retval=true;
}elseif(@unlink("mybriefcase/".$file)){
executeInsertUpdateDeleteQuery("delete from myfiles where file='$file'");
$retval=true;
}
}
}
@ftp_quit($ftp);
}
return $retval;
};
function uploadFile($file,$fln){
global $__FTP_SET;
$retval=false;
$ftp=ftp_connect($__FTP_SET['host']);
if($ftp){
$log=ftp_login($ftp,$__FTP_SET['user'],$__FTP_SET['pass']);
if($log){
if(@ftp_chdir($ftp,$__FTP_SET['path'])){
if(ftp_put($ftp, "$fln", "$file", FTP_BINARY)){
ftp_site($ftp,"chmod 777 $fln");
$retval=true;
}
}
}
@ftp_quit($ftp);
}
return $retval;
};
function getFileList(){
return executeMultipleRowQuery("select * from myfiles order by ctime desc");
};
function getMyFiles(){
$fl=getFileList();
global $__FTP_SET;
$retval=false;
$far=array();
$ftp=ftp_connect($__FTP_SET['host']);
if($ftp){
$log=ftp_login($ftp,$__FTP_SET['user'],$__FTP_SET['pass']);
if($log){
if(@ftp_chdir($ftp,$__FTP_SET['path'])){
//-------------
if($fl){
for($x=0;$x1024) $size=round($size/1024,2)." KB";
elseif($size>(1024*1024)) $size=round($size/(1024*1024),2)." MB";
else $size= $size." Bytes";
$far[$x]['size']=$size;
$fdt = ftp_mdtm($ftp,$fl[$x]['file']);
$far[$x]['date']=date("d-m-Y h:i",$fdt);
}
$retval=$far;
}
//---------------
}
}else echo "Error: Please Check FTP Settings";
@ftp_quit($ftp);
}else echo "Error: Please check FTP Settings";
return $retval;
};
function createNewFile($title,$filename,$matter){
$retval=false;
$fp=fopen("mybriefcase/".$filename,"w");
if($fp){
if(fputs($fp,stripslashes($matter))){
$retval=true;
$ctime=time();
$query="insert into myfiles(ctime,title,file) values('$ctime','$title','$filename')";
executeInsertQuery($query);
}
}
@fclose($fp);
system("chown {$__FTP_SET['user']} mybriefcase/".$filename);
return $retval;
};
function saveFile($filename,$matter){
global $__FTP_SET;
$retval=false;
$fp=fopen("mybriefcase/".$filename,"w");
if($fp){
if(fputs($fp,stripslashes($matter)))
$retval=true;
}
@fclose($fp);
system("chown {$__FTP_SET['user']} mybriefcase/".$filename);
return $retval;
};
function fileRead($filename){
$retval="";
$fp=fopen("mybriefcase/".$filename,"r");
if($fp){
$retval="";
while($line=fgets($fp,1024))
$retval .= stripslashes($line);
fclose($fp);
}
return $retval;
};
function addContact($catid,$name,$cname,$address,$city,$state,$country,$res_phone,$off_phone,$mobile,$fax,$email,$url,$stdcode,$brief){
$query = "insert into phonebook(catid,name,cname,address,city,state,country,resd_phone,off_phone,mobile,fax,email,url,stdcode,brief) ";
$query .= "values('$catid','$name','$cname','$address','$city','$state','$country','$res_phone','$off_phone','$mobile','$fax','$email','$url','$stdcode','$brief')";
return executeInsertQuery($query);
};
function updateContact($cid,$name,$cname,$address,$city,$state,$country,$res_phone,$off_phone,$mobile,$fax,$email,$url,$stdcode,$brief){
$query ="update phonebook set name='$name',cname='$cname',address='$address',";
$query .="city='$city',state='$state',country='$country',resd_phone='$res_phone',";
$query .="off_phone='$off_phone',mobile='$mobile',fax='$fax',email='$email',";
$query .="url='$url',stdcode='$stdcode',brief='$brief' where id='$cid'";
return executeInsertUpdateDeleteQuery($query);
};
function checkCategory($catname){
return executeSingleRowQuery("select * from category where category='$catname'");
};
function addCategory($catname,$uid=0){
return executeInsertQuery("insert into category(category,userid) values('$catname','$uid')");
};
function getCategoryList(){
return executeMultipleRowQuery("select * from category order by category");
};
function getCategory($catid){
return executeSingleRowQuery("select * from category where id='$catid'");
};
function getContactList($catid=0){
return executeMultipleRowQuery("select * from phonebook where catid='$catid' order by name");
};
function getContactDetail($cid){
return executeSingleRowQuery("select * from phonebook where id='$cid'");
};
function removeContact($cid){
return executeInsertUpdateDeleteQuery("delete from phonebook where id='$cid'");
};
function deleteCategory($catid){
deleteCategoryContacts($catid);
return executeInsertUpdateDeleteQuery("delete from category where id='$catid'");
};
function deleteCategoryContacts($catid){
return executeInsertUpdateDeleteQuery("delete from phonebook where catid='$catid'");
};
///////////////////////////////////////////////////////////////////////////////////////////////////
function addUser($uname,$passwd,$emailid,$description){
$atime=time();
// $desc=addslashes(stripslashes($desc));
// $calltime=make24ClockTime($calltime);
$query ="insert into admin(uname,passwd,emailid,description,atime) ";
$query .="values('$uname','$passwd','$emailid','$description','$atime') ";
return executeInsertQuery($query);
};
function deleteUser($clid){
return executeInsertUpdateDeleteQuery("delete from admin where id='$clid'");
};
function getUserList(){
return executeMultipleRowQuery("select * from admin where uname != 'admin' order by uname");
};
function updateUser($lid,$uname,$passwd,$emailid,$description){
$query="update admin SET uname='$uname',passwd='$passwd',emailid='$emailid',description='$description' WHERE id='$lid'";
return executeInsertUpdateDeleteQuery($query);
};
function getOtherUsers($id){
return executeMultipleRowQuery("select * from admin where id!='$id' AND uname!='admin'");
};
function getAllUsers(){
return executeMultipleRowQuery("select * from admin");
};
function getUser($lid){
return executeSingleRowQuery("select * from admin where id='$lid'");
};
function getUserById($userid){
return executeSingleRowQuery("select * from admin where id='$userid'");
};
function getUserDetails($uname){
return executeSingleRowQuery("select * from admin where uname='$uname'");
};
///////////////////////////////////////////////////////////////////////////////////////////////////
function addCall($cname,$name,$phone,$email,$calltime,$calldate,$desc){
$ctime=time();
$desc=addslashes(stripslashes($desc));
$calltime=make24ClockTime($calltime);
$query ="insert into mycalls(cname,name,phone,email,calltime,calldate,description,ctime) ";
$query .="values('$cname','$name','$phone','$email','$calltime','$calldate','$desc','$ctime') ";
return executeInsertQuery($query);
};
function deleteCall($clid){
return executeInsertUpdateDeleteQuery("delete from mycalls where id='$clid'");
};
function getCallList($date=""){
if(empty($date)) $date=date("d-m-Y",time());
$query="select * from mycalls where calldate='$date' order by calltime";
return executeMultipleRowQuery($query);
};
function getCallDateList(){
$query="select calldate from mycalls group by calldate order by calldate desc";
return executeMultipleRowQuery($query);
};
/*
function addEvent($edate,$etime,$desc="",$status=0){
$ctime=time();
if(empty($status)) $status=0;
$desc = addslashes($desc);
$query = "insert into myevents(ctime,event_date,event_time,event_desc,status) ";
$query .= "values('$ctime','$edate','$etime','$desc','$status')";
return executeInsertQuery($query);
};
*/
function addEvent($userid,$edate,$etime,$desc="",$access_ids,$status=0){
$ctime=time();
if(empty($status)) $status=0;
$desc = addslashes($desc);
$query = "insert into myevents(userid,ctime,event_date,event_time,event_desc,access_ids,status) ";
$query .= "values('$userid','$ctime','$edate','$etime','$desc','$access_ids','$status')";
return executeInsertQuery($query);
};
function checkUserAccess($mpl,$pmd){
$found=false;
if(count($mpl)>0){
for($x=0;$x
My Manager » Login