/**
* Get a user id from their real name
*
* @param string $p_realname Realname
* @return array
*/
function user_get_id_by_realname($p_realname)
{
global $g_cache_user;
if ($t_user = user_search_cache('realname', $p_realname)) {
return $t_user['id'];
}
$t_user_table = db_get_table('user');
$query = "SELECT * FROM {$t_user_table} WHERE realname=" . db_param();
$result = db_query_bound($query, array($p_realname));
$row = db_fetch_array($result);
if (!$row) {
return false;
} else {
user_cache_database_result($row);
return $row['id'];
}
}
/**
* Get a user id from their real name
*
* @param string $p_realname The realname to retrieve data for.
* @return array
*/
function user_get_id_by_realname($p_realname)
{
global $g_cache_user;
if ($t_user = user_search_cache('realname', $p_realname)) {
return $t_user['id'];
}
$t_query = 'SELECT * FROM {user} WHERE realname=' . db_param();
$t_result = db_query($t_query, array($p_realname));
$t_row = db_fetch_array($t_result);
if (!$t_row) {
return false;
} else {
user_cache_database_result($t_row);
return $t_row['id'];
}
}
/**
* is cookie valid?
* @param string $p_cookie_string
* @return bool
* @access public
*/
function auth_is_cookie_valid($p_cookie_string)
{
global $g_cache_current_user_id;
# fail if DB isn't accessible
if (!db_is_connected()) {
return false;
}
# fail if cookie is blank
if ('' === $p_cookie_string) {
return false;
}
# succeeed if user has already been authenticated
if (null !== $g_cache_current_user_id) {
return true;
}
if (user_search_cache('cookie_string', $p_cookie_string)) {
return true;
}
# look up cookie in the database to see if it is valid
$t_user_table = db_get_table('user');
$query = "SELECT *\n\t\t\t\t FROM {$t_user_table}\n\t\t\t\t WHERE cookie_string=" . db_param();
$result = db_query_bound($query, array($p_cookie_string));
# return true if a matching cookie was found
if (1 == db_num_rows($result)) {
user_cache_database_result(db_fetch_array($result));
return true;
} else {
return false;
}
}
