Delete the Quote Name (User X) in a Quote

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bonee
    New Member
    • Jul 2017
    • 28
    • 3.8.x

    Delete the Quote Name (User X) in a Quote

    Hi there,

    I had a user "X" that wanted his forum account to be deleted. After deleting his account his name is still shown in the "quote information" of others useres that have quoted the deleted user "X".

    How can I get rid of the User "X" information in quotes that others useres have used?

    Thanks!
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73979

    #2
    Edit the topic so that the quote tag doesn't include the parameters when it was opened.

    You would change something that looks like:


    [quote==Bonee;n4414773]

    to

    [quote]


    However, if you've deleted the User, then it is just text. It links to the post that was quoted. If someone tries to access the user profile, nothing will exist.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • Bonee
      New Member
      • Jul 2017
      • 28
      • 3.8.x

      #3
      Yes, when I click on the user name "x" in the quote, the forum directs me to the start page. However, this is not enough for european laws to delte personal data.

      SInce the user "x" is now listed as "guest" I would have to check all forum-posts for possible quotes by others useres that have quoted the user "X" (as this information is still in the quote). This is impossible when you have >160.000 posts.

      I need a way to delete the name "X" in the quote information. The best would be to delete the quote completly (so not only the user X information but the whole quote).

      Since I want his nickname "X" completly deleted from all posts (including all mentioning of "X") I need help here.

      Is there a way to change the name "x" to "deleted guest" for the whole forum (all posts in all threads in all forums)?

      Thanks!

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73979

        #4
        There is currently no reliable way to do this.

        Quotes aren't actually tied to a user. The only reference is the Text in the field. You can try scrubbing the previewtext and rawtext fields text table and remove all references to the user name but this isn't guaranteed to work. You may be able to use the REPLACE function in MySQL to do this but we do not support this style of query.

        https://dev.mysql.com/doc/refman/8.0...nction_replace

        If the username was a common word, then it can cause disruptions in your other posts as well.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • Bonee
          New Member
          • Jul 2017
          • 28
          • 3.8.x

          #5
          That is no good news as I need to delete / replace all inserts named "UserX" with "Gast" (I have to by european laws)

          So, how does such a query look like?

          Let's say, I want to replace all text named "Bonee" (ijncluding the quote link) with "Gast".

          Thanks

          Comment

          • Bonee
            New Member
            • Jul 2017
            • 28
            • 3.8.x

            #6
            Please, I need help here!

            Is there a way to search for quotes that others users made "User X wrote ..." so that I can change/delete the nickname manually?

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73979

              #7
              Did you follow the link I provided? It tells you how to write a query to try and change this.

              UPDATE text SET rawtext=REPLACE(rawtext,'Bonee','Gast');

              However, this is not a supported action so if it destroys your database and content then we can't fix it.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • Bonee
                New Member
                • Jul 2017
                • 28
                • 3.8.x

                #8
                Thanks, when I save the "old" database with mysqlDumper I am able to reset the query when uploading the "old" databse again, right?

                Comment

                • Wayne Luke
                  vBulletin Technical Support Lead
                  • Aug 2000
                  • 73979

                  #9
                  The "old" database should contain unmodified data.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment

                  • Bonee
                    New Member
                    • Jul 2017
                    • 28
                    • 3.8.x

                    #10
                    Hi again, the query

                    UPDATE text SET rawtext=REPLACE(rawtext,'UserX','Gast');
                    did not solve the problem. The quote "User X wrote ..." is still there.

                    Any idea what I can do to get the rid of the Name: UserX in a quote?

                    Thanks!

                    Comment

                    • Mark.B
                      vBulletin Support
                      • Feb 2004
                      • 24286
                      • 6.0.X

                      #11
                      Make sure you clear the cache in the admincp.

                      How many rows did it report it had changed when you ran the query?

                      Note that, as Wayne stated, this isn't a supported method so we can only can only go so far to assist with it.
                      MARK.B
                      vBulletin Support
                      ------------
                      My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
                      My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

                      Comment

                      • Bonee
                        New Member
                        • Jul 2017
                        • 28
                        • 3.8.x

                        #12
                        Okay, after clearing the system cache the name "UserX" isn't shown in the quotes anymore.

                        Rows: Betroffene Zeilen: 187 (0,4339s)

                        Thanks!

                        Comment

                        • Bonee
                          New Member
                          • Jul 2017
                          • 28
                          • 3.8.x

                          #13
                          One last thing though ...

                          I still see some "last edited by UserX at ...." in posts that the UserX has edited (the poststarter is shown as "guest", but the edit information is still the old users name "UserX"). I wanted to block this information or change the name UserX here as well. I have tried to only show this edit information for admins / moderators within the usergroups-settings, but it is still shown for everyone.

                          Is there an "easy" way to do this (get rid of the UserX in the "last edited by ..." information), or do I have to use another query here?

                          Comment

                          • Wayne Luke
                            vBulletin Technical Support Lead
                            • Aug 2000
                            • 73979

                            #14
                            You would need another query...

                            Code:
                            UPDATE postedithistory SET username='Gast' WHERE username='Bonee';
                            Updating the username to something random before deleting them should change this information in the future.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud demonstration site.
                            vBulletin 5 API

                            Comment

                            • Bonee
                              New Member
                              • Jul 2017
                              • 28
                              • 3.8.x

                              #15
                              Originally posted by Wayne Luke
                              ...

                              Updating the username to something random before deleting them should change this information in the future.
                              That is the lesson I've learned here. Thanks for your support, appreciated!

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...