123456789101112131415161718192021222324 |
- <?php
- $language_file = array('registration','messages','userInfo','admin');
- $cidReset = true;
- require '../inc/global.inc.php';
- $track_online_table = Database::get_statistic_table(TABLE_STATISTIC_TRACK_E_ONLINE);
- $tbl_my_user = Database :: get_main_table(TABLE_MAIN_USER);
- $tbl_my_user_friend = Database :: get_main_table(TABLE_MAIN_USER_FRIEND);
- $search=$_POST['search'];
- $date_inter=date('Y-m-d H:i:s',time()-120);
- $html_form='<select id="id_search_name" name="id_search_name" size="8"" class="message-select-box" onmouseout="list_search_hide()">';
- $sql='SELECT DISTINCT u.user_id as id,concat(u.firstname," ",u.lastname," ","( ",u.email," )") as name
- FROM '.$tbl_my_user.' u INNER JOIN '.$track_online_table.' t ON u.user_id=t.login_user_id
- WHERE t.login_date >'."'".$date_inter."'".' AND (u.firstname like "%'.$search.'%" OR u.lastname like "%'.$search.'%"
- OR CONCAT(u.firstname," ",u.lastname) like CONCAT("%","'.$search.'","%"))';
- if (api_get_setting('allow_social_tool')=='true') {
- //$sql.=' INNER JOIN '.$tbl_my_user_friend.' uf ON uf.friend_user_id=u.user_id ';
- }
- $res=api_sql_query($sql,__FILE__,__LINE__);
- while ($row=Database::fetch_array($res,'ASSOC')) {
- $html_form.='<option value="'.$row['id'].'">'.$row['name'].'</option>';
- }
- $html_form.='</select>';
- echo $html_form;
- ?>
|