feef

function update_old_pwd($password, $uid)
{
    global  $db, $config;

    //This query is so stupid i know but work :/
    $sql = 'DELETE a FROM ' . FB_OLD_PWD_TABLE . ' AS a
        INNER JOIN (SELECT MIN(user_password_time) AS min_time FROM ' . FB_OLD_PWD_TABLE . ') b
            INNER JOIN (SELECT COUNT(user_id) AS user_count FROM ' . FB_OLD_PWD_TABLE . ' WHERE user_id = ' . (int) $uid . ' ) c
                WHERE a.user_password_time  = b.min_time
                    AND c.user_count >=' . $config['fp_mod_max_old'];
    $db->sql_query_limit($sql, 1);

    $sql_ary = array(
        //'password_id'         => 0, //auto-increment
        'user_id'               => (int) $uid,
        'user_password'         => phpbb_hash($password),//old password will NEVER, NEVER be clear !!!
        'user_password_time'    => (int) time()
    );
    $db->sql_query('INSERT INTO ' . FB_OLD_PWD_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));
}