function fof_db_authenticate_hash($user_name, $user_password_hash) { global $FOF_USER_TABLE; global $fof_connection, $fof_user_id, $fof_user_name, $fof_user_level; fof_trace(); $query = "SELECT * FROM {$FOF_USER_TABLE} WHERE user_name = :user_name AND user_password_hash = :user_password_hash"; $statement = $fof_connection->prepare($query); $statement->bindValue(':user_name', $user_name); $statement->bindValue(':user_password_hash', $user_password_hash); $result = $statement->execute(); $row = fof_db_get_row($statement, NULL, TRUE); if (!$row) { $fof_user_id = NULL; $fof_user_name = NULL; $fof_user_level = NULL; fof_log("u:'{$user_name}' uph:'{$user_password_hash}' FAIL", 'auth'); return false; } $fof_user_id = $row['user_id']; $fof_user_name = $row['user_name']; $fof_user_level = $row['user_level']; fof_log("u:'{$user_name}' uph:'{$user_password_hash}' OK ui:'{$fof_user_id}' un:'{$fof_user_name}' ul:'{$fof_user_level}'", 'auth'); return true; }
function fof_apply_tags($feed_id, $item_id) { global $fof_subscription_to_tags; if (!isset($fof_subscription_to_tags)) { $fof_subscription_to_tags = fof_db_get_subscription_to_tags(); } fof_trace("subs_to_tags:" . var_export($fof_subscription_to_tags, TRUE)); if (isset($fof_subscription_to_tags[$feed_id])) { $feed_subs = $fof_subscription_to_tags[$feed_id]; if (is_array($feed_subs)) { foreach ($feed_subs as $user_id => $tags) { if (is_array($tags)) { foreach ($tags as $tag) { fof_db_tag_items($user_id, $tag, $item_id); } } } } } }