phpBB.nl

Code: Selecteer alles

function user_update_name($old_name, $new_name)
{
    global $config, $db, $cache, $phpbb_dispatcher;

    $update_ary = array(
        FORUMS_TABLE            => array('forum_last_poster_name'),
        MODERATOR_CACHE_TABLE    => array('username'),
        POSTS_TABLE                => array('post_username'),
        TOPICS_TABLE            => array('topic_first_poster_name', 'topic_last_poster_name'),
    );

    foreach ($update_ary as $table => $field_ary)
    {
        foreach ($field_ary as $field)
        {
            $sql = "UPDATE $table
                SET $field = '" . $db->sql_escape($new_name) . "'
                WHERE $field = '" . $db->sql_escape($old_name) . "'";
            $db->sql_query($sql);
        }
    }

Code: Selecteer alles

UPDATE phpbb_forums SET forum_last_poster_name = 'Angel' WHERE forum_last_poster_name = 'VERANDERDE GEBRUIKERSNAAM' AND forum_last_poster_id = '1';

UPDATE phpbb_posts SET post_username = 'Angel' WHERE post_username = 'VERANDERDE GEBRUIKERSNAAM' AND poster_id = '1';

UPDATE phpbb_topics SET topic_first_poster_name = 'Angel' WHERE topic_first_poster_name = 'VERANDERDE GEBRUIKERSNAAM' AND topic_poster = '1';

UPDATE phpbb_topics SET topic_last_poster_name = 'Angel' WHERE topic_last_poster_name = 'VERANDERDE GEBRUIKERSNAAM' AND topic_last_poster_id = '1';