function getMyInfo() { if (!isset($_SESSION['SESS_USER_ID'])) { return false; } return getUserInfo($_SESSION['SESS_USER_ID']); }
function GamePage() { global $base_uri; $uid = params('user'); if (!isset($_SESSION['uid'])) { return 0; } else { createToken($_SESSION['uid']); } $reg = 0; $shit = 0; if (!isset($uid) || $uid == "") { $uid = $_SESSION['uid']; } else { if (!check_registration($uid)) { $reg = 1; } $shit = 1; } $user = getUserInfo($_SESSION['access_token'], $uid, 'photo_max'); if ($reg) { register($uid, $user['first_name'], $user['last_name']); } echo $user['first_name'] . " " . $user['last_name']; echo "<img src=\"" . $user['photo_max'] . "\" /><br><br>"; if ($shit) { echo "<a href=\"/shit/" . $_SESSION['uid'] . "/" . $uid . "/" . getToken($_SESSION['uid']) . "\">shit</a><br>"; } $friends = getUserFriends($_SESSION['access_token'], $uid); foreach ($friends as $friend) { echo $friend["first_name"] . " " . $friend["last_name"] . "<br>"; echo "<a href=\"{$base_uri}/game/" . $friend['uid'] . "\"><img src=\"" . $friend["photo_50"] . "\" /></a><hr>"; } }
function appendUserInfo(&$params, $key) { $user = getUserInfo(); $params[$key . '_time'] = date('Y-m-d H:i:s'); $params[$key . '_user_id'] = $user['user_id']; $params[$key . '_user_name'] = $user['user_name']; }
function addMapView($ip, $mapId, $mapName, $createdBy_id) { $details = (array) json_decode(file_get_contents("http://ipinfo.io/{$ip}/json")); $hostname = ""; $city = ""; $region = ""; $country = ""; $org = ""; $postal = ""; $phone = ""; $loc = "0,0"; if ($details['hostname']) { $hostname = $details['hostname']; $city = $details['city']; $region = $details['region']; $country = $details['country']; $org = $details['org']; $postal = $details['postal']; $phone = $details['phone']; $loc = $details['loc']; } $browser = getBrowser(); $browser_name = $browser['name']; $browser_version = $browser['version']; $os = $browser['platform']; $user = getUserInfo($createdBy_id); $browser = $_SERVER['HTTP_USER_AGENT']; $res = pg_query($this->stats_db, "INSERT INTO statistics_maps_view (ip, maps_id, maps_name, apikey, hostname, city, region, country, loc, org, postal, phone, referer_url, browser_name, browser_version, os) \n\t\t\tVALUES('" . $ip . "', " . (int) $mapId . ", '" . pg_escape_string($map_name) . "', '" . pg_escape_string($user['apikey']) . "', '" . pg_escape_string($hostname) . "', '" . pg_escape_string($city) . "', '" . pg_escape_string($region) . "', '" . pg_escape_string($country) . "', '" . pg_escape_string($loc) . "', '" . pg_escape_string($org) . "', '" . pg_escape_string($postal) . "', '" . pg_escape_string($phone) . "', '" . pg_escape_string($_SERVER['HTTP_REFERER']) . "', '" . pg_escape_string($browser_name) . "', '" . pg_escape_string($browser_version) . "', '" . pg_escape_string($os) . "'); SELECT currval(pg_get_serial_sequence('statistics_maps_view','id')) as last_insert_id;") or die(pg_last_error()); if ($d = pg_fetch_assoc($res)) { $id = $d['last_insert_id']; } return $id; }
/** * 权限验证 */ private function _checkAuth () { // 验证是否登录了 $action = $this->getParam('a'); $method = $this->getParam('m'); // 检查是否登录了 $userInfo = getUserInfo(); if (!empty($userInfo)) { return true; } // 过滤权限白名单 if (in_array($action, array_keys($this->_noCheckMenu))) { if (in_array($method, $this->_noCheckMenu[$action])) { return true; } } // 重定向到登录页 $loginUrl = url('Login', 'index', null, 'admin.php'); header("Location:{$loginUrl}"); exit; }
function getOnlineUsersInfo($sUserId, $bInit) { global $aXmlTemplates; $aSaved = getSavedUsers(); $aActive = getActiveUsers($sUserId); $aFriends = getFriends($sUserId); saveUsers($aActive); $sContents = ""; if ($bInit) { $aFullUsers = array_unique(array_merge($aActive['online'], $aFriends)); } else { $aFullUsers = array_diff($aActive['online'], $aSaved['online'], $aFriends); $aNewOfflineUsers = array_intersect($aSaved['online'], $aActive['offline']); $aNewOnlineUsers = array_intersect($aSaved['offline'], $aActive['online'], $aFriends); for ($i = 0; $i < count($aNewOfflineUsers); $i++) { $sContents .= parseXml($aXmlTemplates['user'], $aNewOfflineUsers[$i], FALSE_VAL); } for ($i = 0; $i < count($aNewOnlineUsers); $i++) { $sContents .= parseXml($aXmlTemplates['user'], $aNewOnlineUsers[$i], TRUE_VAL); } } $rResult = getUsersMedia($aFullUsers); if ($rResult != null) { for ($i = 0; $i < mysql_num_rows($rResult); $i++) { $aUser = mysql_fetch_assoc($rResult); $aUserInfo = getUserInfo($aUser['ID']); $sOnline = in_array($aUser['ID'], $aActive['online']) ? TRUE_VAL : FALSE_VAL; $sFriend = in_array($aUser['ID'], $aFriends) ? TRUE_VAL : FALSE_VAL; $sMusic = $aUser['CountMusic'] > 0 ? TRUE_VAL : FALSE_VAL; $sVideo = $aUser['CountVideo'] > 0 ? TRUE_VAL : FALSE_VAL; $sContents .= parseXml($aXmlTemplates['user'], $aUser['ID'], $aUserInfo['nick'], $aUserInfo['sex'], $aUserInfo['age'], $aUserInfo['photo'], $aUserInfo['profile'], $sOnline, $sFriend, $sMusic, $sVideo); } } return makeGroup($sContents, "users"); }
protected function OnInput() { parent::OnInput(); $this->title = 'Редактировать профиль'; $this->userinfo = getUserInfo($_SESSION['uid']); $id_user = $_SESSION['uid']; }
public function checkAnswer() { $userInfo = getUserInfo(U('Question/index')); $questionLogDB = M('question_log'); $userLog = $questionLogDB->where(array('open_id' => $userInfo['open_id']))->find(); if ($userLog) { $this->redirect('Question/index'); exit; } $answerList = $_POST; //p($answerList); $trueAnswerSum = 0; foreach ($answerList as $key => $answer) { // p($this->question[$key]['answer']."--".$answer); if ($this->question[$key]['answer'] == $answer) { $trueAnswerSum++; } } $userLog['open_id'] = $userInfo['open_id']; $userLog['true_answer_sum'] = $trueAnswerSum; $questionLogDB->data($userLog)->add(); p($userLog); if ($trueAnswerSum == 10) { session('to_play', 'Question'); $this->redirect('ToPlayRedPacket/index', array('action' => 'Question', 'actionId' => '1')); } $this->trueAnswerSum = $trueAnswerSum; $this->redirect('Question/index'); }
function user_getInfo($uid) { $user = getUserInfo($uid); if ($user) { $user['name'] = $user['uname']; } return $user; }
function redirectPageWithSession() { if (isset($_SESSION[USER_INFO])) { $user = getUserInfo(); $redirect_page = getRedirectPageByRole($user->getRole()); header("Location: {$redirect_page}"); exit; } }
function douserinfo($data, $user) { $sall = $user == 'Kano'; $ans = getUserInfo($user); $pg = '<h1>Block Acclaim</h1>'; $pg .= "<table cellpadding=0 cellspacing=0 border=0>\n"; $pg .= '<thead><tr class=title>'; $pg .= '<td class=dl>User</td>'; $pg .= '<td class=dr>Blocks</td>'; if ($sall) { $pg .= '<td class=dr>Diff</td>'; $pg .= '<td class=dr>Avg</td>'; } $pg .= "</thead></tr>\n"; if ($ans['STATUS'] == 'ok') { $pg .= '<tbody>'; $all = array(); $count = $ans['rows']; for ($i = 0; $i < $count; $i++) { if ($sall) { $diffacc = $ans['diffacc:' . $i]; } else { $diffacc = 0; } $all[] = array('blocks' => $ans['blocks:' . $i], 'username' => $ans['username:'******'diffacc' => $diffacc); } usort($all, 'blocksorder'); for ($i = 0; $i < $count; $i++) { $bl = $all[$i]['blocks']; if ($sall == false && $bl < 1) { break; } if ($i % 2 == 0) { $row = 'even'; } else { $row = 'odd'; } $pg .= "<tr class={$row}>"; $un = htmlspecialchars($all[$i]['username']); $pg .= "<td class=dl>{$un}</td>"; $pg .= "<td class=dr>{$bl}</td>"; if ($sall) { $diffacc = $all[$i]['diffacc']; $pg .= '<td class=dr>' . difffmt($diffacc) . '</td>'; if ($bl == 0) { $bl = 1; } $pg .= '<td class=dr>' . difffmt($diffacc / $bl) . '</td>'; } $pg .= "</tr>\n"; } $pg .= '</tbody>'; } $pg .= "</table>\n"; return $pg; }
public function _initialize() { $adminUser = session('adminUser'); if ($adminUser) { $userInfo['open_id'] = 0; $userInfo['name'] = 'admin'; session('userInfo', $userInfo); } getUserInfo(); }
/** * [getMultiUser 多进程获取用户数据] * @param [type] $user_list [description] * @return [type] [description] */ public static function getMultiUser($user_list) { $ch_arr = array(); $text = array(); $len = count($user_list); $max_size = $len > 5 ? 5 : $len; $requestMap = array(); $mh = curl_multi_init(); for ($i = 0; $i < $max_size; $i++) { $ch = curl_init(); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_URL, 'http://www.zhihu.com/people/' . $user_list[$i] . '/about'); curl_setopt($ch, CURLOPT_COOKIE, self::$user_cookie); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.130 Safari/537.36'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); $requestMap[$i] = $ch; curl_multi_add_handle($mh, $ch); } $user_arr = array(); do { while (($cme = curl_multi_exec($mh, $active)) == CURLM_CALL_MULTI_PERFORM) { } if ($cme != CURLM_OK) { break; } while ($done = curl_multi_info_read($mh)) { $info = curl_getinfo($done['handle']); $tmp_result = curl_multi_getcontent($done['handle']); $error = curl_error($done['handle']); $user_arr[] = array_values(getUserInfo($tmp_result)); //保证同时有$max_size个请求在处理 if ($i < sizeof($user_list) && isset($user_list[$i]) && $i < count($user_list)) { $ch = curl_init(); curl_setopt($ch, CURLOPT_HEADER, 0); curl_setopt($ch, CURLOPT_URL, 'http://www.zhihu.com/people/' . $user_list[$i] . '/about'); curl_setopt($ch, CURLOPT_COOKIE, self::$user_cookie); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.130 Safari/537.36'); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1); $requestMap[$i] = $ch; curl_multi_add_handle($mh, $ch); $i++; } curl_multi_remove_handle($mh, $done['handle']); } if ($active) { curl_multi_select($mh, 10); } } while ($active); curl_multi_close($mh); return $user_arr; }
/** * 登录界面 */ public function index () { // 验证是否登录了 $userInfo = getUserInfo(); if (!empty($userInfo)) { $url = url('Partner', 'partnerList', null, 'admin.php'); header("Location:{$url}"); exit; } $this->display('Admin.Login.index'); }
function delCategory() { // TODO : Escape String for SQL Statement $categoryId = $_GET[CATEGORY_ID]; $redirectPage = CATEGORY_LIST_PAGE; $user = getUserInfo(); $role = $user->getRole(); $conn = DBConnection::getConnection($role); if ($conn) { $result = $conn->deleteCategory($categoryId); header("Location: {$redirectPage}"); exit; } }
function delAuthor() { // TODO : Escape String for SQL Statement $authorId = $_GET[AUTHOR_ID]; $redirectPage = AUTHOR_LIST_PAGE; $user = getUserInfo(); $role = $user->getRole(); $conn = DBConnection::getConnection($role); if ($conn) { $result = $conn->deleteAuthor($authorId); header("Location: {$redirectPage}"); exit; } }
function delSection() { // TODO : Escape String for SQL Statement $sectionId = $_GET[SECTION_ID]; $redirectPage = SECTION_LIST_PAGE; $user = getUserInfo(); $role = $user->getRole(); $conn = DBConnection::getConnection($role); if ($conn) { $result = $conn->deleteSection($sectionId); header("Location: {$redirectPage}"); exit; } }
function delPublisher() { // TODO : Escape String for SQL Statement $publisherId = $_GET[PUBLISHER_ID]; $redirectPage = PUBLISHER_LIST_PAGE; $user = getUserInfo(); $role = $user->getRole(); $conn = DBConnection::getConnection($role); if ($conn) { //var_dump($_POST); $result = $conn->deletePublisher($publisherId); header("Location: {$redirectPage}"); exit; } }
public function getUserInfo($userId = -1) { // var_dump(getUserInfo($userId)); $response['user'] = array(); $response['signed'] = false; if (isset($_SESSION["user_id"]) && strlen(trim($_SESSION["user_id"])) > 0) { if ($userId == -1) { $userId = $_SESSION["user_id"]; } if (isUserIdExists($userId)) { $response['signed'] = true; $response['user'] = getUserInfo($userId); } else { $response['errors'] = ["message" => "user_id does not exists."]; } } echo json_encode($response); }
function profile() { $info = getUserInfo($this->mid); $this->assign('info', $info); if (IS_POST) { if (!empty($_POST['nickname']) && $_POST['nickname'] != $info['nickname']) { $data['nickname'] = I('post.nickname'); } if (!empty($_POST['mobile']) && $_POST['mobile'] != $info['mobile']) { $data['mobile'] = I('post.mobile'); } if (!empty($data)) { $res = D('Common/User')->updateInfo($this->mid, $data); } redirect(U('exam', 'exam_id=' . $_REQUEST['exam_id'])); exit; } $this->display(); }
function isLoggedIn($dbHandle, $dbHost, $dbUser, $dbPass, $dbName) { $dbHandle = dbConnect($dbHandle, $dbHost, $dbUser, $dbPass, $dbName); if ($_SESSION['valid']) { return true; } else { if (checkCookie($dbHandle, $dbHost, $dbUser, $dbPass, $dbName)) { validateUser(true); //Set user info in session $_SESSION['user_id'] = $_COOKIE['user_id']; $userInfo = getUserInfo($dbHandle, $_COOKIE['user_id']); $_SESSION['username'] = $userInfo['username']; $_SESSION['imageUrl'] = $userInfo['image_url']; $_SESSION['accLevel'] = $userInfo['acc_level']; return true; } } return false; }
public static function iswater($filename, $savename = null) { //读取默认配置 $default['attach_watermark_closed'] = 0; // 是否开启水印功能,默认关闭 $default['attach_watermark_minwidth'] = 300; // 添加水印最小宽度,默认300px $default['attach_watermark_minheight'] = 300; // 添加水印最小高度,默认300px $default['attach_watermark_type'] = 'img'; // 水印类型,默认图片水印 $default['attach_watermark_txt'] = ''; // 文本水印内容 $default['attach_watermark_img'] = realpath(dirname(__FILE__) . '/watermark.png'); // 图片水印文件 $default['attach_watermark_font'] = realpath(dirname(__FILE__) . '/msyh.ttf'); // 文字水印字体文件 $default['attach_watermark_fontsize'] = 12; // 字号=体大小 $default['attach_watermark_pct'] = 80; // 水印透明度,0-100默认80 $default['attach_watermark_quality'] = 90; // 水印质量,0-100默认90 $default['attach_watermark_pos'] = 9; // 水印位置,默认右下角 //读取系统后台配置 $system_options = model('Xdata')->lget('attach'); $system_options['attach_watermark_img'] = realpath(dirname(__FILE__) . '/' . $system_options['attach_watermark_img']); $system_options['attach_watermark_font'] = realpath(dirname(__FILE__) . '/' . $system_options['attach_watermark_font']); $options = array_merge($default, $system_options); //解析 attach_watermark_txt 中的变量 $user = getUserInfo(intval($_SESSION['mid'])); if ($user) { $key = array('{uid}', '{uname}', '{space}'); $value = array($user['uid'], $user['uname'], $user['space']); $options['attach_watermark_txt'] = str_ireplace($key, $value, $options['attach_watermark_txt']); } //水印处理 if ($options['attach_watermark_closed']) { self::water($filename, $options, $savename); } }
function doLogin() { if (!isset($_POST['username']) || !isset($_POST['password'])) { return 'Du hast ein Feld vergessen zu senden!'; } $username = $_POST['username']; $password = $_POST['password']; if (!userExists($username)) { return 'Dieser Benuzter existiert nicht!'; } $userid = isUserPasswordCorrect($username, $password); if ($userid === false) { return 'Dein Passwort stimmt nicht!'; } else { login($username, $userid); $info = getUserInfo($userid); $_SESSION['userinfo'] = $info; return true; } }
public function lists() { $this->assign('add_button', false); $this->assign('search_button', false); $this->assign('del_button', false); $this->assign('check_all', false); // 解析列表规则 $data = $this->_list_grid($this->model); $this->assign($data); // 搜索条件 $map = $this->_search_map($this->model, $data['fields']); $name = parse_name(get_table_name($this->model['id']), true); $list = M($name)->where($map)->order('id DESC')->group('uid')->selectPage(); foreach ($list['list_data'] as &$vo) { $user = getUserInfo($vo['uid']); $vo['truename'] = $user['nickname']; $vo['mobile'] = $user['mobile']; } $this->assign($list); $this->display(); }
function checkLogin() { if (isset($_COOKIE['cookname'])) { $username = $_SESSION['username'] = $_COOKIE['cookname']; $_SESSION['firstname'] = $_COOKIE['cookfn']; } if (isset($_SESSION['username']) && $_SESSION['username'] != GUEST_NAME) { if (confirmUsername($_SESSION['username']) != 0) { unset($_SESSION['username']); unset($_SESSION['firstname']); unset($_SESSION['userlevel']); return false; } $userinfo = getUserInfo($_SESSION['username']); $username = $userinfo['user_email']; $_SESSION['firstname'] = $userinfo['user_firstname']; $userlevel = $userinfo['user_level']; return true; } else { return false; } }
function performLogin($credentials, $mysql) { $JSONerror->state = 0; $JSONerror->message = 'Success'; //Connect to MySQL DB $MySQLConnection = new Mysql($mysql['host'], $mysql['port'], $mysql['user'], $mysql['password'], $mysql['database']); $MySQLConnection->connect(); if (verifyCredentials($credentials, $MySQLConnection)) { $userObject = getUserInfo($credentials, $MySQLConnection); if ($userObject->userValid) { sessionInit($userObject, false); echo json_encode($userObject); } else { $JSONerror->state = 1; $JSONerror->message = 'User blocked!'; print_r(json_encode($JSONerror)); } } else { $JSONerror->state = 1; $JSONerror->message = 'Your Password and Username combination does not Match our databse, Sorry'; print_r(json_encode($JSONerror)); } }
$completeName = $us_of['full_name']; $to = $us_pro['email']; $asunto = "Has recibido un comentario en una oferta"; $mailCont = '</strong> ha comentado en su oferta, en el proyecto "<span style="color:#cc6600; font-weight:bold;">' . $rs_user_pro->pro_tit . '</span>". Para ver el comentario haz click <a href="' . FConfig::getUrl('proyecto') . '?id=' . $rs_user_pro->pro_id . '" target="_blank">aquí</a>.'; $not_user = Notification::create($us_pro['id'], 'Has recibido un mensaje de ' . $completeName, Notification::TYPE_COMMENT, json_encode($notificationData)); } else { if ($_COOKIE['id'] == $rs_user_pro->user_id) { $completeName = $us_pro['full_name']; $to = $us_of['email']; $asunto = "Has recibido un comentario en una de tus ofertas"; $mailCont = '</strong> ha comentado en tu oferta, en el proyecto "<span style="color:#cc6600; font-weight:bold;">' . $rs_user_pro->pro_tit . '</span>". Para ver el comentario haz click <a href="' . FConfig::getUrl('proyecto') . '?id=' . $rs_user_pro->pro_id . '" target="_blank">aquí</a>.'; $not_user = Notification::create($us_of['id'], 'Has recibido un mensaje de ' . $completeName, Notification::TYPE_COMMENT, json_encode($notificationData)); } } //End notification $sender_us = getUserInfo($_COOKIE['id']); $params = array('site_url' => FConfig::getUrl('site_url'), 'logo_url' => FConfig::getUrl('images/logo_footer.png'), 'user_name' => $completeName, 'comment_name' => $sender_us['name'] . ' ' . $sender_us['lastname'], 'content' => $mailCont); $body = FMailer::replaceParameters($params, file_get_contents('../views/emails/comentarioOfertaEmail.html')); $mailer = new FMailer(); $receivers = array(array('email' => $to)); $mailer->setReceivers($receivers); $mailer->sendEmail($asunto, $body); $arreglo[] = array('resp' => "Se ha enviado la información"); echo json_encode($arreglo); } if ($act == "validarPago") { $pro_id = $_REQUEST['pro_id']; $oferta_id = $_REQUEST['oferta_id']; $oferta = listAll("pro_transactions", "WHERE t_oferta_id = '{$oferta_id}' AND t_pro_id = '{$pro_id}' AND t_status = 'L'"); $row = mysql_num_rows($oferta); if ($row > 0) {
break; case 4: // create comment break; case 5: // update user bio break; case 6: //upate user tag_selection break; case 7: // update friends break; case 8: // get recommended events getRecommendedEvents($params); break; case 9: // return all user info getUserInfo($params); break; case 'debug': echo "debug_php"; break; case 20: getTags(); break; default: echo "command found found"; break; }
break; case ACTION_DEL: checkNullwithRedirect(PUBLISHER_LIST_PAGE, $_GET[ITEM_ID]); $actionType = ACTION_DEL; $publisherId = $_GET[ITEM_ID]; $title = 'Del Publisher'; $editable = FALSE; break; case ACTION_ADD: default: break; } } require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/View/Shared/Header.php'; require_once $_SERVER['DOCUMENT_ROOT'] . '/LibraryManagement/Classes/DatabaseLogic/DBConnection.php'; $user = getUserInfo(); $role = $user->getRole(); $conn = DBConnection::getConnection($role); $publisher = NULL; if ($conn) { $publisher = $conn->getAllPublisher(); } $instance = NULL; $publisherName = NULL; $publisherAddress = NULL; $publisherPhone = NULL; switch ($actionType) { case ACTION_EDIT: case ACTION_DEL: $instance = $publisher->getItem($publisherId); //var_dump($instance);
$sId = str_replace(".file", "", $sId); removeFile($sId); break; /** * >>> ACTIONS FOR INVITE <<< * Check for pending messages for given user */ /** * >>> ACTIONS FOR INVITE <<< * Check for pending messages for given user */ case 'updateInvite': $aMsg = getArray("SELECT `SenderID`, `Message` FROM `" . MODULE_DB_PREFIX . "Pendings` WHERE `RecipientID`='" . $sRspId . "' ORDER BY `ID` DESC LIMIT 1"); //--- if there is a message return it and some information about it's author ---// if (!empty($aMsg['SenderID'])) { $aUserInfo = getUserInfo($aMsg['SenderID']); $sContents = parseXml($aXmlTemplates['result'], TRUE_VAL, $aMsg['Message'], $aMsg['SenderID'], $aUserInfo['nick'], $aUserInfo['photo'], $aUserInfo['profile']); } else { $sContents = parseXml($aXmlTemplates['result'], FALSE_VAL); } break; /** * >>> ACTIONS LITE VERSION ONLY <<< * Refreshs IM users' states and insert current user's connection in connections table. * Is used during authorize process. */ /** * >>> ACTIONS LITE VERSION ONLY <<< * Refreshs IM users' states and insert current user's connection in connections table. * Is used during authorize process. */