/** * function get_user_id() * A function to get the user id * @param array $convoArr - the current state of the conversation array * @return array $convoArr **/ function get_user_id($convoArr) { //db globals global $dbConn, $dbn, $unknown_user; runDebug(__FILE__, __FUNCTION__, __LINE__, 'Getting user ID.', 2); //get undefined defaults from the db $sql = "SELECT * FROM `{$dbn}`.`users` WHERE `session_id` = '" . $convoArr['conversation']['convo_id'] . "' limit 1"; $sth = $dbConn->prepare($sql); $sth->execute(); $result = $sth->fetchAll(); $count = count($result); if ($count > 0) { $sth = $dbConn->prepare($sql); $sth->execute(); $row = $sth->fetch(); $convoArr['conversation']['user_id'] = $row['id']; // add user name, if set $convoArr['conversation']['user_name'] = !empty($convoArr['client_properties']['name']) ? $convoArr['client_properties']['name'] : !empty($row['user_name']) ? $row['user_name'] : $unknown_user; $convoArr['client_properties']['name'] = $convoArr['conversation']['user_name']; $msg = "existing"; } else { $convoArr = intisaliseUser($convoArr); $msg = "new"; } runDebug(__FILE__, __FUNCTION__, __LINE__, "Getting {$msg} user id:" . $convoArr['conversation']['user_id'], 4); runDebug(__FILE__, __FUNCTION__, __LINE__, "get_user_id SQL: {$sql}", 3); return $convoArr; }
/** * function get_user_id() * A function to get the user id * @param array $convoArr - the current state of the conversation array * @return the update $convoArr **/ function get_user_id($convoArr) { //db globals global $con, $dbn, $unknown_user; //get undefined defaults from the db $sql = "SELECT * FROM `{$dbn}`.`users` WHERE `session_id` = '" . $convoArr['conversation']['convo_id'] . "' limit 1"; $result = mysql_query($sql, $con); $count = mysql_num_rows($result); if ($count > 0) { $row = mysql_fetch_array($result); $convoArr['conversation']['user_id'] = $row['id']; // add user name, if set $convoArr['conversation']['user_name'] = !empty($row['name']) ? $row['name'] : !empty($convoArr['client_properties']['name']) ? $convoArr['client_properties']['name'] : $unknown_user; $msg = "existing"; } else { $convoArr['conversation']['user_id'] = intisaliseUser($convoArr['conversation']['convo_id']); $msg = "new"; } runDebug(__FILE__, __FUNCTION__, __LINE__, "Getting {$msg} user id:" . $convoArr['conversation']['user_id'], 4); runDebug(__FILE__, __FUNCTION__, __LINE__, "get_user_id SQL: {$sql}", 3); return $convoArr; }
/** * function check_set_convo_id(() * A function to check and set the convo id * @param array $convoArr - the current state of the conversation array * @return $convoArr (updated) **/ function check_set_user($convoArr) { global $default_convo_id, $con, $dbn, $unknown_user; //check to see if user_name has been set if not set as default $convo_id = isset($convoArr['conversation']['convo_id']) ? $convoArr['conversation']['convo_id'] : session_id(); $bot_id = $convoArr['conversation']['bot_id']; $ip = $_SERVER['REMOTE_ADDR']; $convoArr['client_properties']['ip_address'] = $ip; $sql = "select `name`, `id` from `users` where `session_id` = '{$convo_id}' limit 1;"; $result = mysql_query($sql, $con) or $msg = SQL_error(mysql_errno(), __FILE__, __FUNCTION__, __LINE__); $numRows = mysql_num_rows($result); if ($numRows == 0) { $user_id = intisaliseUser($convo_id); } else { $row = mysql_fetch_assoc($result); $user_id = !empty($row['id']) ? $row['id'] : 0; $user_name = !empty($row['name']) ? $row['name'] : 'User'; } $convoArr['conversation']['user_name'] = !empty($user_name) ? $user_name : $unknown_user; #die("User name = $user_name<br />\n"); return $convoArr; }
/** * function check_set_user(() * A function to check and set the user's information * * @link http://blog.program-o.com/?p=1278 * @param array $convoArr - the current state of the conversation array * @return array|int $convoArr (updated) */ function check_set_user($convoArr) { global $dbConn, $dbn, $unknown_user; runDebug(__FILE__, __FUNCTION__, __LINE__, 'Checking and setting the user info, as needed.', 2); //check to see if user_name has been set if not set as default $convo_id = isset($convoArr['conversation']['convo_id']) ? $convoArr['conversation']['convo_id'] : session_id(); if (!isset($convoArr['conversation']['convo_id'])) { $convoArr['conversation']['convo_id'] = $convo_id; } $ip = $_SERVER['REMOTE_ADDR']; $convoArr['client_properties']['ip_address'] = $ip; $sql = "select `user_name`, `id`, `chatlines` from `{$dbn}`.`users` where `session_id` = :convo_id limit 1;"; $row = db_fetch($sql, array(':convo_id' => $convo_id), __FILE__, __FUNCTION__, __LINE__); if ($row === false) { $convoArr = intisaliseUser($convoArr); $user_id = $convoArr['conversation']['user_id']; $user_name = $unknown_user; } else { $user_id = $row['id']; $user_name = !empty($row['user_name']) ? $row['user_name'] : $unknown_user; } $chatlines = !empty($row['chatlines']) ? $row['chatlines'] : 0; $user_name = !empty($user_name) ? $user_name : $unknown_user; $convoArr['conversation']['user_name'] = $user_name; $convoArr['conversation']['user_id'] = $user_id; $convoArr['client_properties']['name'] = $user_name; $convoArr['conversation']['totallines'] = $chatlines; return $convoArr; }