Announcement

Collapse
No announcement yet.

How to...?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to...?

    hi guys,

    my forum was recently hacked and he delete an important member from my forum.
    the old posts of that deleted member are now posted as a guest.

    my question:
    He registered again in my forum, Is possible to join the old posts and threads at the new registration? He are using the same nickname.

    some important info:
    user nickname: S1LV3R
    old userid: 68
    new userid: 104002

    I was looking at the database and found out that:

    Threads start by him:
    Table: vns_thread
    postusername: S1LV3R
    postuserid: 68

    I was thinking to make something like that:
    Code:
    UPDATE vns_thread SET postuserid = REPLACE (postuserid,'68','104002')
    But I am afraid If he found for example a postuserid like 1687 and he replaces with 11040027. It is possible to make that change to all threads that have S1LV3R as postusername? If yes, how? And this idea will be work? Or do you have any better idea to make this possible?





    Posts write by him:
    username: S1LV3R
    userid: 0

    I was thinking to make something like that:
    Code:
    UPDATE vns_post SET userid = REPLACE (userid,'0','104002')
    But I am afraid If he found for example a userid like 101 and he replaces with 11040021. It is possible to make that change to all threads that have S1LV3R as username? If yes, how? And this idea will be work? Or do you have any better idea to make this possible?


    Please help...

    Thank you!

  • #2
    This is untested, but will probably work for you since S1LV3R is still there as postusername and username.
    Code:
    UPDATE vns_thread SET postuserid = '104002' WHERE postusername = 'S1LV3R'
    Code:
    UPDATE vns_post SET userid = '104002' WHERE username = 'S1LV3R'
    If you read it online, it must be true.

    Comment


    • #3
      Alternatively you can use my mod. It does what do you want.

      http://www.vbulletin.org/forum/showthread.php?t=242229

      Comment

      Loading...
      Working...
      X