Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	action.php
Содержимое	<?php /error_reporting(E_ALL); ini_set('display_errors','on');/ $base_url = '../'; require_once("Dklab/Realplexor.php"); require_once('JSON.php'); ini_set('display_errors', 0); require_once($base_url . 'func.php'); $l = db_connect(); sql('set names utf8'); session_start(); if (isset($_SESSION['user_id'])) { $id_user_sess = (int)$_SESSION['user_id']; } function birthday ($birthday){ list($year,$month,$day) = explode("-",$birthday); $year_diff = date("Y") - $year; $month_diff = date("m") - $month; $day_diff = date("d") - $day; if ($day_diff < 0 \|\| $month_diff < 0) $year_diff--; return $year_diff; } $rpl = new Dklab_Realplexor("127.0.0.1", "10010", RPL_PRIVATE_NAMESPACE); switch ($_REQUEST['action']) { case 'add_contact': $result = array(); foreach ( $_REQUEST['contacts'] as $contact ) { $contact = (int) $contact; $exist = sqlval("select id_contact from rpl_contact where id_user='{$id_user_sess}' and id_contact='{$contact}'"); if ($exist['id_contact'] == '') { $row = sqlval("select id, name, sex from user where id='{$contact}'"); sql("insert into rpl_contact values('{$id_user_sess}', '{$contact}', '{$row['name']}')"); $result[] = array( 'id' => $row['id'], 'name' => $row['name'], 'sex' => $row['sex'] ); } } //Get online users foreach ($rpl->cmdOnline() as $onliner) { $online[] = substr( $onliner, 0, strrpos($onliner, "_") ); } $online = array_flip($online); foreach ($result as &$item) { $rs_ban = sqlval("select * from rpl_ban where id_user='{$id_user_sess}' and id_contact='{$item['id']}'"); $item['ban'] = ($rs_ban['id_user'] != '') ? 1 : 0; ( array_key_exists( $item['id'], $online) ) ? $item['online'] = 1 : $item['online'] = 0; } echo json_encode_cyr(array('result'=>$result, 'error'=>0)); break; case 'delete_contact': $_REQUEST['id'] = (int) $_REQUEST['id']; sql("delete from rpl_contact where id_user='{$id_user_sess}' and id_contact='{$_REQUEST['id']}'"); sql("update rpl_incoming set readed='1' where id_sender='{$_REQUEST['id']}' and id_recipient='{$id_user_sess}'"); echo json_encode_cyr(array('error'=>0)); break; case 'load_contacts': $query = "select SQL_CALC_FOUND_ROWS t2.id, t2.name, t2.sex from rpl_contact t1, user t2 where id_user='{$id_user_sess}' and t1.id_contact=t2.id order by t2.name"; $contacts = fetchAll( $query ); //Get online users foreach ($rpl->cmdOnline() as $onliner) { $online[] = substr( $onliner, 0, strrpos($onliner, "_") ); } $online = array_flip($online); $query = "select id_sender from `rpl_incoming` where `id_recipient`='{$id_user_sess}' and `readed`='0' group by `id_sender`"; $result = sql( $query ); while ( $row = sqlget( $result ) ) { $have_new[] = $row['id_sender']; } $have_new = array_flip( $have_new ); //Contact list foreach ($contacts as &$contact) { //$contact['name']=iconv("windows-1251", "UTF-8",$contact['name']); $rs_ban = sqlval("select * from rpl_ban where id_user='{$id_user_sess}' and id_contact='{$contact['id']}'"); $contact['ban'] = ($rs_ban['id_user'] != '') ? 1 : 0; $contact['uid'] = md5($contact['name']); ( array_key_exists( $contact['id'], $online) ) ? $contact['online'] = 1 : $contact['online'] = 0; ( array_key_exists( $contact['id'], $have_new) ) ? $contact['hasUnreadMessage'] = 1 : $contact['hasUnreadMessage'] = 0; } echo json_encode_cyr($contacts); break; case 'get_messages': $messages_array = array(); if ( $_REQUEST['contact'] > 0 ) { $active = intval( $_REQUEST['contact'] ); $query = "select min(timestamp) timestamp from rpl_incoming where id_sender='{$active}' and id_recipient='{$id_user_sess}' and readed='0'"; $unreaded = sqlval( $query ); if ( $unreaded['timestamp'] != '' ) { $query = "select count() from rpl_incoming where timestamp>='{$unreaded['timestamp']}'"; $count = mysql_fetch_row( mysql_query($query) ); } else { $count[0] = 0; } if ( $count[0] < 10 ) { //limits $query = "select id, UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_incoming where id_sender='{$active}' and id_recipient='{$id_user_sess}' order by id desc limit 10"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $k1=>&$message ) { $message['type'] = 'incoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'b'] = $message; } } $query = "select id, UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_outcoming where id_sender='{$id_user_sess}' and id_recipient='{$active}' order by id desc limit 10"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $k=>&$message ) { $message['type'] = 'outcoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'a'] = $message; } } ksort($messages_array); $messages_count = count( $messages_array ); if ( $unreaded['timestamp'] == '' && $messages_count > 10 ) { $messages_array = array_slice( $messages_array, $messages_count - 10 ); } } else { //unreaded $query = "select id, UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_incoming where id_sender='{$active}' and id_recipient='{$id_user_sess}' and timestamp >= '{$unreaded['timestamp']}' order by timestamp desc"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $message ) { $message['type'] = 'incoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = $date = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'b'] = $message; } } $query = "select id, UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_outcoming where id_sender='{$id_user_sess}' and id_recipient='{$active}' and timestamp >= '{$unreaded['timestamp']}' order by timestamp desc"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $message ) { $message['type'] = 'outcoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = $date = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'a'] = $message; } } } } echo json_encode_cyr($messages_array); break; case 'get_all': $messages_array = array(); if ( $_REQUEST['contact'] > 0 ) { $active = intval( $_REQUEST['contact'] ); $query = "select UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_incoming where id_sender='{$active}' and id_recipient='{$id_user_sess}' order by timestamp desc"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $message ) { $message['type'] = 'incoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = $date = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'b'] = $message; } } $query = "select UNIX_TIMESTAMP( timestamp ) timestamp, message, readed from rpl_outcoming where id_sender='{$id_user_sess}' and id_recipient='{$active}' order by timestamp"; $messages = fetchAll( $query ); if ( is_array( $messages ) ) { foreach ( $messages as $message ) { $message['type'] = 'outcoming'; //$message['message'] = iconv("windows-1251", "UTF-8",$message['message']); $message['date'] = $date = date("H:i:s d/m/Y", $message['timestamp']); $messages_array[$message['timestamp'] . 'a'] = $message; } } ksort($messages_array); $messages_count = count( $messages_array ); } echo json_encode_cyr($messages_array); break; case 'mark_readed': $contact = intval( $_REQUEST['contact'] ); $query = "update rpl_incoming set readed='1' where id_sender='{$contact}' and id_recipient='{$id_user_sess}'"; mysql_query( $query ); echo json_encode_cyr(array('error'=>0)); break; case 'clear_history': $contact = (int)$_REQUEST['contact']; mysql_query( "delete from rpl_incoming where id_sender='{$contact}' and id_recipient='{$id_user_sess}'" ); mysql_query( "delete from rpl_outcoming where id_sender='{$id_user_sess}' and id_recipient='{$contact}'" ); echo json_encode_cyr(array('error'=>0)); break; case 'ban_user': $contact = (int)$_REQUEST['contact']; mysql_query("insert into rpl_ban values ('{$id_user_sess}', '{$contact}')"); echo json_encode_cyr(array('error'=>0)); break; case 'unban_user': $contact = (int)$_REQUEST['contact']; mysql_query("delete from rpl_ban where id_user='{$id_user_sess}' and id_contact='{$contact}'"); echo json_encode_cyr(array('error'=>0)); break; case 'send_message': if($id_user_sess!=8){ $rs_ban = sqlval("select from rpl_ban where id_user='{$contact}' and id_contact='{$id_user_sess}'"); }else{ $rs_ban['id_user'] = ""; } $timestamp = time(); $date = date("H:i:s d/m/Y", $timestamp); $createdate= date('Y-m-d H:i:s', $timestamp); $_REQUEST['contact'] = intval( $_REQUEST['contact'] ); $user = sqlval("select id, name from user where id='{$_REQUEST['contact']}'"); $channel = $user['id'] . '_' . md5( $user['name'] . SECRET_KEY ); $mes = $_REQUEST['message']; // $_REQUEST['message'] = iconv ("UTF-8", "WINDOWS-1251", $_REQUEST['message'] ); $_REQUEST['message'] = strip_tags( $_REQUEST['message'] ); $_REQUEST['message'] = preg_replace("/::smile_([0-9]+)::/", "<img src=\"/library/images/smile/anim/\\1.gif\" />", $_REQUEST['message']); $_REQUEST['message'] = nl2br( $_REQUEST['message'] ); $sql_message = mysql_real_escape_string( $_REQUEST['message'] ); sql( "insert into rpl_outcoming values (NULL, '{$id_user_sess}', '{$user['id']}', '{$sql_message}', '1', '{$createdate}')" ); $rs_sex = sqlval("select sex from user where id='{$id_user_sess}'"); $rs_contact = sqlval("select * from rpl_contact where id_user='{$user['id']}' and id_contact='{$id_user_sess}'"); if ($rs_contact['id_contact'] == '' ) { sql("insert into rpl_contact values('{$user['id']}', '{$id_user_sess}', '{$login}')"); } $ban_flag = true; if ($rs_ban['id_user'] == '') { $ban_flag = false; sql( "insert into rpl_incoming values (NULL, '{$id_user_sess}', '{$user['id']}', '{$sql_message}', '0', '{$createdate}')" ); $rpl->send(array( $channel ), array("contid" => $id_user_sess, "message" => $mes, "user"=> $login, "sex" => $rs_sex['sex'], "date"=> $date )); } //$_REQUEST['message'] = iconv ( "WINDOWS-1251", "UTF-8", $_REQUEST['message'] ); echo json_encode_cyr(array('error'=>0, 'message'=>$_REQUEST['message'], "date"=> $date, 'ban'=>$ban_flag)); break; case 'search_user': $_REQUEST['nicname'] = mysql_real_escape_string( $_REQUEST['nicname'] ); $_REQUEST['fullName'] = mysql_real_escape_string( $_REQUEST['fullName'] ); $_REQUEST['age_min'] = intval( $_REQUEST['age_min'] ); $_REQUEST['age_max'] = intval( $_REQUEST['age_max'] ); $_REQUEST['sex'] = intval( $_REQUEST['sex'] ); $query = "select id, name, name_full, sex, berstday from user where 1 "; if ( $_REQUEST['nicname'] != '' ) { //$_REQUEST['nicname'] = iconv ("UTF-8", "WINDOWS-1251", $_REQUEST['nicname'] ); $query .= " and name like '{$_REQUEST['nicname']}%'"; } if ( $_REQUEST['fullName'] != '' ) { //$_REQUEST['fullName'] = iconv ("UTF-8", "WINDOWS-1251", $_REQUEST['fullName'] ); $query .= " and name_full like '%{$_REQUEST['fullName']}%'"; } if ($_REQUEST['age_min'] > 0 && $_REQUEST['age_max'] <= 0) { $data_min = date('Y') - $_REQUEST['age_min']; $query .= " and (EXTRACT(YEAR FROM berstday) <= {$data_min} && EXTRACT(YEAR FROM berstday) <> '0000')"; } if ($_REQUEST['age_min'] <= 0 && $_REQUEST['age_max'] > 0) { $data_max = date('Y') - $_REQUEST['age_max']; $query .= " and (EXTRACT(YEAR FROM berstday) >= {$data_max})"; } if ($_REQUEST['age_min'] > 0 && $_REQUEST['age_max'] > 0) { $data_min = date('Y') - $_REQUEST['age_min']; $data_max = date('Y') - $_REQUEST['age_max']; $query .= " and (EXTRACT(YEAR FROM berstday) <= {$data_min} && EXTRACT(YEAR FROM berstday) >= {$data_max} && EXTRACT(YEAR FROM berstday) <> '0000')"; } if ( $_REQUEST['sex'] >= 0 ) { $_REQUEST['sex'] = intval( $_REQUEST['sex'] ); $query .= " and sex='{$_REQUEST['sex']}'"; } $query .= " limit 0, 50"; $users = fetchAll( $query ); foreach ($rpl->cmdOnline() as $onliner) { $online[] = substr( $onliner, 0, strrpos($onliner, "_") ); } $online = array_flip($online); foreach ($users as &$user) { ( $user['berstday'] != '0000-00-00' ) ? $user['age'] = birthday($user['berstday']) : $user['age'] = '-'; if ( $user['age'] < 0 ) $user['age'] = '-'; ( array_key_exists( $user['id'], $online) ) ? $user['online'] = 1 : $user['online'] = 0; } echo json_encode_cyr(array('result'=>$users, 'error'=>0)); break; }

/private/

Имя	Дата	Размер
..	2026-10-02
imgprivat	2016-02-15
.htaccess	2016-02-15	0 байт
action.php	2017-02-15	14 кб.
index.php	2026-10-01	46 кб.
index.php.bak.rtl	2026-10-01	45 кб.
so.css	2017-02-07	38 кб.
style.css	2016-02-15	5 кб.
style6.css	2016-02-15	60 байт

/private