123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321 |
- <?php
- function LoginCheck($uid)
- {
- global $_course;
- $uid = (int) $uid;
- $online_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
- if (!empty($uid))
- {
- $login_ip = '';
- if(!empty($_SERVER['REMOTE_ADDR']))
- {
- $login_ip = Database::escape_string($_SERVER['REMOTE_ADDR']);
- }
- $reallyNow = time();
- $login_date = date("Y-m-d H:i:s",$reallyNow);
-
-
- if (is_array($_course) && count($_course)>0 && !empty($_course['id']))
- {
- $query = "REPLACE INTO ".$online_table ." (login_id,login_user_id,login_date,login_ip, course) VALUES ($uid,$uid,'$login_date','$login_ip', '".$_course['id']."')";
- }
- else
- {
- $query = "REPLACE INTO ".$online_table ." (login_id,login_user_id,login_date,login_ip) VALUES ($uid,$uid,'$login_date','$login_ip')";
- }
- @Database::query($query);
- }
- }
- function online_logout() {
- global $_configuration, $extAuthSource;
-
- $query_string='';
- if (!empty($_SESSION['user_language_choice'])) {
- $query_string='?language='.$_SESSION['user_language_choice'];
- }
-
- $tbl_track_login = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_LOGIN);
-
- $uid = intval($_GET['uid']);
- $sql_last_connection="SELECT login_id, login_date FROM $tbl_track_login WHERE login_user_id='$uid' ORDER BY login_date DESC LIMIT 0,1";
- $q_last_connection=Database::query($sql_last_connection);
- if (Database::num_rows($q_last_connection)>0) {
- $i_id_last_connection=Database::result($q_last_connection,0,"login_id");
- }
- if (!isset($_SESSION['login_as'])) {
- $current_date=date('Y-m-d H:i:s',time());
- $s_sql_update_logout_date="UPDATE $tbl_track_login SET logout_date='".$current_date."' WHERE login_id='$i_id_last_connection'";
- Database::query($s_sql_update_logout_date);
- }
- LoginDelete($uid, $_configuration['statistics_database']);
-
-
-
-
-
- $uinfo = api_get_user_info($uid);
- if (($uinfo['auth_source'] != PLATFORM_AUTH_SOURCE) && is_array($extAuthSource)) {
- if (is_array($extAuthSource[$uinfo['auth_source']])) {
- $subarray = $extAuthSource[$uinfo['auth_source']];
- if (!empty($subarray['logout']) && file_exists($subarray['logout'])) {
- require_once($subarray['logout']);
- $logout_function = $uinfo['auth_source'].'_logout';
- if (function_exists($logout_function)) {
- $logout_function($uinfo);
- }
- }
- }
- }
- require_once api_get_path(SYS_PATH) . 'main/chat/chat_functions.lib.php';
- exit_of_chat($uid);
- api_session_destroy();
- global $logout_no_redirect;
- if (!$logout_no_redirect) {
- header("Location: index.php$query_string");
- return;
- }
- }
- function LoginDelete($user_id)
- {
- $online_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
- $user_id = (int) $user_id;
- $query = "DELETE FROM ".$online_table ." WHERE login_user_id = '".Database::escape_string($user_id)."'";
- @Database::query($query);
- }
- function WhoIsOnline($valid, $friends = false)
- {
- $valid = (int) $valid;
- $current_date = date('Y-m-d H:i:s',time());
- $track_online_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
- $friend_user_table = Database::get_main_table(TABLE_MAIN_USER_REL_USER);
- $query = '';
- if ($friends) {
-
- $query = " SELECT distinct login_user_id,login_date
- FROM $track_online_table
- INNER JOIN $friend_user_table ON (friend_user_id = login_user_id)
- WHERE DATE_ADD(login_date,INTERVAL $valid MINUTE) >= '".$current_date."' AND friend_user_id <> '".api_get_user_id()."' AND relation_type='".USER_RELATION_TYPE_FRIEND."' AND user_id = '".api_get_user_id()."' ";
- } else {
-
- $query = "SELECT login_user_id,login_date FROM ".$track_online_table ." WHERE DATE_ADD(login_date,INTERVAL $valid MINUTE) >= '".$current_date."' ";
- }
- global $_configuration;
- if ($_configuration['multiple_access_urls']==true) {
- $tbl_user_rel_access_url= Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_USER);
- $access_url_id = api_get_current_access_url_id();
- if ($access_url_id != -1) {
- if ($friends) {
-
- $query = " SELECT distinct login_user_id,login_date
- FROM $track_online_table
- INNER JOIN $tbl_user_rel_access_url user_rel_url ON (user_rel_url.user_id = track.login_user_id)
- INNER JOIN $friend_user_table ON (friend_user_id = login_user_id)
- WHERE access_url_id = $access_url_id AND DATE_ADD(login_date,INTERVAL $valid MINUTE) >= '".$current_date."' AND friend_user_id <> '".api_get_user_id()."' AND relation_type='".USER_RELATION_TYPE_FRIEND."' AND user_id = '".api_get_user_id()."' ";
- } else {
-
- $query = " SELECT login_user_id,login_date FROM ".$track_online_table ." track
- INNER JOIN $tbl_user_rel_access_url user_rel_url
- ON (user_rel_url.user_id = track.login_user_id)
- WHERE access_url_id = $access_url_id AND DATE_ADD(login_date,INTERVAL $valid MINUTE) >= '".$current_date."' ";
- }
- }
- }
- $result = @Database::query($query);
- if (count($result)>0) {
- $rtime = time();
- $rdate = date("Y-m-d H:i:s",$rtime);
- $validtime = mktime(date("H"),date("i")-$valid,date("s"),date("m"),date("d"),date("Y"));
- $rarray = array();
- while(list($login_user_id,$login_date)= Database::fetch_row($result)) {
- $barray = array();
- array_push($barray,$login_user_id);
- array_push($barray,$login_date);
-
- $hour = substr($login_date,11,2);
- $minute = substr($login_date,14,2);
- $secund = substr($login_date,17,2);
- $month = substr($login_date,5,2);
- $day = substr($login_date,8,2);
- $year = substr($login_date,0,4);
-
- $dbtime = mktime($hour,$minute,$secund,$month,$day,$year);
- if ($dbtime>$validtime) {
- array_push($rarray,$barray);
- }
- }
- return $rarray;
- } else {
- return false;
- }
- }
- function GetFullUserName($uid)
- {
- $uid = (int) $uid;
- $uid = Database::escape_string($uid);
- $user_table = Database::get_main_table(TABLE_MAIN_USER);
- $query = "SELECT firstname,lastname FROM ".$user_table." WHERE user_id='$uid'";
- $result = @Database::query($query);
- if (count($result)>0) {
- $str = '';
- while(list($firstname,$lastname)= Database::fetch_array($result)) {
- $str = str_replace(' ', ' ', api_get_person_name($firstname, $lastname));
- return $str;
- }
- }
- }
- function chatcall() {
- global $_user, $_cid;
- if (!$_user['user_id']) {
- return (false);
- }
- $track_user_table = Database::get_main_table(TABLE_MAIN_USER);
- $sql="select chatcall_user_id, chatcall_date from $track_user_table where ( user_id = '".$_user['user_id']."' )";
- $result=Database::query($sql);
- $row=Database::fetch_array($result);
- $login_date=$row['chatcall_date'];
- $hour = substr($login_date,11,2);
- $minute = substr($login_date,14,2);
- $secund = substr($login_date,17,2);
- $month = substr($login_date,5,2);
- $day = substr($login_date,8,2);
- $year = substr($login_date,0,4);
- $calltime = mktime($hour,$minute,$secund,$month,$day,$year);
- $time = time();
- $time = date("Y-m-d H:i:s", $time);
- $minute_passed=5;
- $limittime = mktime(date("H"),date("i")-$minute_passed,date("s"),date("m"),date("d"),date("Y"));
- if (($row['chatcall_user_id']) and ($calltime>$limittime)) {
- $webpath=api_get_path(WEB_CODE_PATH);
- $message=get_lang('YouWereCalled').' : '.GetFullUserName($row['chatcall_user_id'],'').'<br>'.get_lang('DoYouAccept')
- ."<p>"
- ."<a href=\"".$webpath."chat/chat.php?cidReq=".$_cid."&origin=whoisonlinejoin\">"
- . get_lang("Yes")
- ."</a>"
- ." | "
- ."<a href=\"".api_get_path('WEB_PATH')."webchatdeny.php\">"
- . get_lang("No")
- ."</a>"
- ."</p>";
- return($message);
- }
- else
- {
- return(false);
- }
- }
- function who_is_online_in_this_course($uid, $valid, $coursecode=null)
- {
- if(empty($coursecode)) return false;
- $track_online_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
- $coursecode = Database::escape_string($coursecode);
- $valid = Database::escape_string($valid);
- $query = "SELECT login_user_id,login_date FROM ".$track_online_table ." WHERE course='".$coursecode."' AND DATE_ADD(login_date,INTERVAL $valid MINUTE) >= NOW() ";
- $result = Database::query($query);
- if (count($result)>0) {
- $rtime = time();
- $rdate = date("Y-m-d H:i:s",$rtime);
- $validtime = mktime(date("H"),date("i")-$valid,date("s"),date("m"),date("d"),date("Y"));
- $rarray = array();
- while(list($login_user_id,$login_date)= Database::fetch_row($result)) {
- $barray = array();
- array_push($barray,$login_user_id);
- array_push($barray,$login_date);
-
- $hour = substr($login_date,11,2);
- $minute = substr($login_date,14,2);
- $secund = substr($login_date,17,2);
- $month = substr($login_date,5,2);
- $day = substr($login_date,8,2);
- $year = substr($login_date,0,4);
-
- $dbtime = mktime($hour,$minute,$secund,$month,$day,$year);
- if ($dbtime >= $validtime)
- {
- array_push($rarray,$barray);
- }
- }
- return $rarray;
- } else {
- return false;
- }
- }
|