[Omniscient]

Omfg thank you so much Omniscient now I'm 100% anonymous 👹

Please tell me you're being sarcastic.

[⁠Cammy]

Please tell me you're being sarcastic.

It's sarcastic for it is Dean Winchester posting it

[0x -]

I don't believe you're thinking it through.

You have 2 choices to accomplish your request.

1. Upon showthread.php load you'd have to check every user against any new username changes. And of course you'll need to preg_match or some function to look for the quote text. The username table is large but even if you reduce the query like:

SELECT from mybb_username_history WHERE UID IN(1,3,5423,232333) SORT BY date DESC

The "IN()" would of course grab each UID in the page which is normally 20 UID's. Then it would have to check quote mycode for a possible change. Then update the post in the database for future efficiency.

And realistically it's probably even more complicated than that.

2. Every time a username change occurs you'd run a query with a LIKE statement to find each quoted instance of the old username and then run an UPDATE statement. I can only imagine how long that would take. Almost positive this would choke the server instantly.

Changing showthread.php is not something I do lightly and I make sure mybb_posts table change are minimized because doing any type of LIKE searching will destroy the database. That's why I run a separate service for searching here. You even want to add an UPDATE statement based on the LIKE. No way would it work.

It seems that myBB does stuff differently with their SQL Database as when I made my system, it was really less complicated than that.

If I remember correctly, the correct setup was

-> User Changes their name (STORE THE NEW & OLD NAME INTO A DATABASE CALLED 'USERNAME_CHANGES' with their UID

-> When we want to fetch it (RUN A LOOP WITH A QUERY TO FETCH THE OLD USERNAMES CORRESPONDING TO THAT UID) and print onto our dialog.

As it seems, there's a different way of doing this on myBB like you have explained above.

At least I learned something new about this forum software as I personally do not deal with myBB. I am more of a xenforo user.

[The Supreme Leader]

Sucks that the Username History Search is Ub3r only

[๖ۣۜAverage]

What if you made it where we can delete are posts all at the same time if there older than 6 months old, would remove all old quotes and personally i would love this feature.

[0x -]

What if you made it where we can delete are posts all at the same time if there older than 6 months old, would remove all old quotes and personally i would love this feature.

Then there would be no use of the archive of this forum and we would lose so much data that the forum would look empty.

This is a really bad suggestion, no offence.

[⁠Cammy]

What if you made it where we can delete are posts all at the same time if there older than 6 months old, would remove all old quotes and personally i would love this feature.

I also have a suggestion
Improve your English

[Dean Winchester‎]

Please tell me you're being sarcastic.

I've already been doxed (because of my 1st username) so yeah I guess I was being sarcastic 😝

[Wires]

I also have a suggestion
Improve your English

Lol. It's still a pretty shitty suggestion.

[Omniscient]

It seems that myBB does stuff differently with their SQL Database as when I made my system, it was really less complicated than that.

If I remember correctly, the correct setup was

-> User Changes their name (STORE THE NEW & OLD NAME INTO A DATABASE CALLED 'USERNAME_CHANGES' with their UID

-> When we want to fetch it (RUN A LOOP WITH A QUERY TO FETCH THE OLD USERNAMES CORRESPONDING TO THAT UID) and print onto our dialog.

As it seems, there's a different way of doing this on myBB like you have explained above.

At least I learned something new about this forum software as I personally do not deal with myBB. I am more of a xenforo user.

Yes but how are the posts storing the quoted text? Storing the UID and Username Change is NOT the problem. The problem is changing all posts to reflect updated username changes.

Does Xenforo save quoted text differently in the database besides plain text or BLOB? The only feasible way would be for each quote to be the PID (post ID) that's quoted instead then run a query to grab the updated info from the user table based on the $post['uid']. Which is doable but not with MyBB as it stands and in reality it's not a very efficient way to run showthread page because every quote would require an additional PID query run.

[Savage xD]

This is a great update. Thanks Omni. You are great with finding the correct balance when it comes to changes.

[Tʀᴀᴜᴍᴀ]

I don't believe you're thinking it through.

You have 2 choices to accomplish your request.

1. Upon showthread.php load you'd have to check every user against any new username changes. And of course you'll need to preg_match or some function to look for the quote text. The username table is large but even if you reduce the query like:

SELECT from mybb_username_history WHERE UID IN(1,3,5423,232333) SORT BY date DESC

The "IN()" would of course grab each UID in the page which is normally 20 UID's. Then it would have to check quote mycode for a possible change. Then update the post in the database for future efficiency.

And realistically it's probably even more complicated than that.

2. Every time a username change occurs you'd run a query with a LIKE statement to find each quoted instance of the old username and then run an UPDATE statement. I can only imagine how long that would take. Almost positive this would choke the server instantly.

Changing showthread.php is not something I do lightly and I make sure mybb_posts table change are minimized because doing any type of LIKE searching will destroy the database. That's why I run a separate service for searching here. You even want to add an UPDATE statement based on the LIKE. No way would it work.

You're intelligence is mind blowing.. I know a lot of this may sound easy to you.. But it's just crazy.. Off topic, but truly congratulations on your success.

[0x -]

I didn't catch the system exactly, I mis-understood what the user said but instead of re-making a whole system. Adding a cursor on dialog to the quote BB Function with the list of past usernames, instead of complicating our heads.

Ex: If you quote

example

It would run a query to search if the entered text is a valid user in the database and well, you know the rest.

[Stapleton]

Thanks Omni. This was much needed.

[Krew]

Will this update have impact on https://hackforums.net/uhsearch.php ?