SQL to restore username

Discussion in 'MySQL' started by Maxman, Jan 26, 2006.

0
  1. #1
    I had an admin delete himself from my phpbb site. All his posts are now displayed as GUEST.

    I am sure there is a why to replace GUEST with his username with a SQL statement. I just don't know the proper Syntax.

    Can anyone help me out here? Thanks!
     
    Maxman, Jan 26, 2006 IP
  2. vectorgraphx

    vectorgraphx Guest

    Messages:
    545
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    PHPBB gets the word "Guest" from the language file. you might be able to change the language file to achieve the results you're after.

    file: lang_english/lang_main.php

    line 257 reads:

    $lang['Guest'] = 'Guest';

    change the variable there, like this

    $lang['Guest'] = 'Bob the EX admin who conveniently deleted himself.';

    that might work for you -

    VG
     
    vectorgraphx, Jan 27, 2006 IP
  3. vectorgraphx

    vectorgraphx Guest

    Messages:
    545
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #3
    also, if you can get into your mysql database, you might be able to put him back - but that would be a bit trickier than changing the language file.
     
    vectorgraphx, Jan 27, 2006 IP
  4. Maxman

    Maxman Peon

    Messages:
    66
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    I did the language file thing...the problem was it made the Who's Online Guest read as his username.

    I was hoping to get the exact SQL statement.
     
    Maxman, Jan 27, 2006 IP