Bitcoin Forum
May 06, 2024, 01:58:46 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 [2]  All
  Print  
Author Topic: Question for admins: Add one more post in my thread maybe?  (Read 445 times)
LoyceV
Legendary
*
Offline Offline

Activity: 3304
Merit: 16600


Thick-Skinned Gang Leader and Golden Feather 2021


View Profile WWW
July 06, 2021, 08:50:11 AM
 #21

He used the term "repurpose". I believe he checks the database of already deleted posts (posts deleted at one point in the past) and just reallocates the message ID of a matching post to a different forum member.
It looks like it Shocked This is going to mess up some of the forum scraping.
Your new msgID was originally created by skillscreating.

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.
As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.

1714960726
Hero Member
*
Offline Offline

Posts: 1714960726

View Profile Personal Message (Offline)

Ignore
1714960726
Reply with quote  #2

1714960726
Report to moderator
1714960726
Hero Member
*
Offline Offline

Posts: 1714960726

View Profile Personal Message (Offline)

Ignore
1714960726
Reply with quote  #2

1714960726
Report to moderator
It is a common myth that Bitcoin is ruled by a majority of miners. This is not true. Bitcoin miners "vote" on the ordering of transactions, but that's all they do. They can't vote to change the network rules.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714960726
Hero Member
*
Offline Offline

Posts: 1714960726

View Profile Personal Message (Offline)

Ignore
1714960726
Reply with quote  #2

1714960726
Report to moderator
FatFork
Legendary
*
Offline Offline

Activity: 1596
Merit: 2588


Top Crypto Casino


View Profile WWW
July 06, 2021, 09:14:05 AM
 #22

He used the term "repurpose". I believe he checks the database of already deleted posts (posts deleted at one point in the past) and just reallocates the message ID of a matching post to a different forum member.
It looks like it Shocked This is going to mess up some of the forum scraping.
Your new msgID was originally created by skillscreating.

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.
As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.

Really? I didn't know that. Damn, that must be one hell of a database.
I can see how reallocating the message IDs presents problems for scraping forum posts. Good luck with dealing with that mess. Grin However, theymos' solution is quite elegant for this situation. I can't think of any simpler way to do this.
 

█████████████████████████
████▐██▄█████████████████
████▐██████▄▄▄███████████
████▐████▄█████▄▄████████
████▐█████▀▀▀▀▀███▄██████
████▐███▀████████████████
████▐█████████▄█████▌████
████▐██▌█████▀██████▌████
████▐██████████▀████▌████
█████▀███▄█████▄███▀█████
███████▀█████████▀███████
██████████▀███▀██████████
█████████████████████████
.
BC.GAME
▄▄░░░▄▀▀▄████████
▄▄▄
██████████████
█████░░▄▄▄▄████████
▄▄▄▄▄▄▄▄▄██▄██████▄▄▄▄████
▄███▄█▄▄██████████▄████▄████
███████████████████████████▀███
▀████▄██▄██▄░░░░▄████████████
▀▀▀█████▄▄▄███████████▀██
███████████████████▀██
███████████████████▄██
▄███████████████████▄██
█████████████████████▀██
██████████████████████▄
.
..CASINO....SPORTS....RACING..
█░░░░░░█░░░░░░█
▀███▀░░▀███▀░░▀███▀
▀░▀░░░░▀░▀░░░░▀░▀
░░░░░░░░░░░░
▀██████████
░░░░░███░░░░
░░█░░░███▄█░░░
░░██▌░░███░▀░░██▌
░█░██░░███░░░█░██
░█▀▀▀█▌░███░░█▀▀▀█▌
▄█▄░░░██▄███▄█▄░░▄██▄
▄███▄
░░░░▀██▄▀


▄▄████▄▄
▄███▀▀███▄
██████████
▀███▄░▄██▀
▄▄████▄▄░▀█▀▄██▀▄▄████▄▄
▄███▀▀▀████▄▄██▀▄███▀▀███▄
███████▄▄▀▀████▄▄▀▀███████
▀███▄▄███▀░░░▀▀████▄▄▄███▀
▀▀████▀▀████████▀▀████▀▀
hilariousandco
Global Moderator
Legendary
*
Offline Offline

Activity: 3794
Merit: 2616


Join the world-leading crypto sportsbook NOW!


View Profile
July 06, 2021, 11:46:29 AM
 #23

Globals can't do it, but I suppose you could maybe get around it with some trickery by splitting the threads and then merging them with another you created. Probably much easier to get an admin to do it though  Grin.

I can’t imagine the administration would want to start wasting their time handling requests like this. I can only imagine the door they’d be opening to unleash a wave of nonsense on themselves. I would think the preferred method of handling something like this would be to create a new thread and lock the old thread. That way you could handle the issue yourself without admin help.

It's happened a few times before and I think if it's necessary on a important or substantial thread then it should be done. It's provably rare that people run into this issue anyway.

  ▄▄███████▄███████▄▄▄
 █████████████
▀▀▀▀▀▀████▄▄
███████████████
       ▀▀███▄
███████████████
          ▀███
 █████████████
             ███
███████████▀▀               ███
███                         ███
███                         ███
 ███                       ███
  ███▄                   ▄███
   ▀███▄▄             ▄▄███▀
     ▀▀████▄▄▄▄▄▄▄▄▄████▀▀
         ▀▀▀███████▀▀▀
░░░████▄▄▄▄
░▄▄░
▄▄███████▄▀█████▄▄
██▄████▌▐█▌█████▄██
████▀▄▄▄▌███░▄▄▄▀████
██████▄▄▄█▄▄▄██████
█░███████░▐█▌░███████░█
▀▀██▀░██░▐█▌░██░▀██▀▀
▄▄▄░█▀░█░██░▐█▌░██░█░▀█░▄▄▄
██▀░░░░▀██░▐█▌░██▀░░░░▀██
▀██
█████▄███▀▀██▀▀███▄███████▀
▀███████████████████████▀
▀▀▀▀███████████▀▀▀▀
▄▄██████▄▄
▀█▀
█  █▀█▀
  ▄█  ██  █▄  ▄
█ ▄█ █▀█▄▄█▀█ █▄ █
▀▄█ █ ███▄▄▄▄███ █ █▄▀
▀▀ █    ▄▄▄▄    █ ▀▀
   ██████   █
█     ▀▀     █
▀▄▀▄▀▄▀▄▀▄▀▄
▄ ██████▀▀██████ ▄
▄████████ ██ ████████▄
▀▀███████▄▄███████▀▀
▀▀▀████████▀▀▀
█████████████LEADING CRYPTO SPORTSBOOK & CASINO█████████████
MULTI
CURRENCY
1500+
CASINO GAMES
CRYPTO EXCLUSIVE
CLUBHOUSE
FAST & SECURE
PAYMENTS
.
..PLAY NOW!..
PrimeNumber7
Copper Member
Legendary
*
Offline Offline

Activity: 1624
Merit: 1899

Amazon Prime Member #7


View Profile
July 06, 2021, 12:44:21 PM
 #24

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.
Does this mean that you do not keep track of the content of deleted posts? If not, that sounds risky. What did you do with the database entry for the old post?

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.

I think it is more likely that when a post is "deleted" that a field in a table in a record associated with the post is updated to reflect that the post is no longer publically available, so it will not be displayed when someone views a thread. However, the record is kept in the database. Occasionally posts will be removed in error, and when this happens, the admins may restore deleted posts.
I think you're confusing deleting posts with archiving (threads) which is kind of like sending it to trash.
The "trash" for most forums is actually a board that is unavailable to the public but is still available to the moderators and/or admins (depending on the forum). It is very rare for threads to be removed from a forum database.
hosseinimr93
Legendary
*
Offline Offline

Activity: 2394
Merit: 5235



View Profile
July 06, 2021, 01:25:51 PM
Merited by PrimeNumber7 (1)
 #25

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.
As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.
Just to add to LoyceV's reply:
I think when a post is deleted, it's actually moved to a topic which is visible only to admins.
If you go to your report history and click on a deleted post, you will see that the topic ID has been changed.

For example, this post had been made on topic number 5346386. When I click on it in my report history, I go to topic number 5346379 which is not visible to us.

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
Pmalek (OP)
Legendary
*
Offline Offline

Activity: 2758
Merit: 7132



View Profile
July 06, 2021, 01:34:32 PM
 #26

I can see how reallocating the message IDs presents problems for scraping forum posts. Good luck with dealing with that mess.
Luckily, it's not something that happens that often. In whole of Bitcointalk's history, I would be surprised if more than 10 people asked the administration to add a new post in their threads. Maybe those numbers will increase following this discussion. LoyceV's scrapper picks up only new posts. It doesn't register changes made to already existing posts. That's also why if you mentioned a user's name in an edited post, that user wouldn't be notified of the mention even if he is using LoyceV's bot.

Globals can't do it, but I suppose you could maybe get around it with some trickery by splitting the threads and then merging them with another you created. Probably much easier to get an admin to do it though  Grin.
But that would also require the assistance of admins and global mods. Ordinary users can't merge two threads, can they Huh

How would that merging go exactly? If I have a thread where there has been 20 replies and I create a new thread to merge it with my first two posts, what goes where exactly? Can the forum staff merge it in a way that the OP of my new thread becomes the 3rd post in my old thread? Please explain the process a bit?

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
theymos
Administrator
Legendary
*
Offline Offline

Activity: 5194
Merit: 12972


View Profile
July 06, 2021, 01:49:49 PM
Merited by Daniel91 (1), FatFork (1)
 #27

Does this mean that you do not keep track of the content of deleted posts?

Deleted posts are at first just hidden from public view. To steal the ID from such a post, the deleted post is given a new ID. The deleted spam post in this case now has ID 57394364.

After about a year, deleted posts are moved off of the live database and into an archive database, and no longer occupy their original message ID in the live database. After about another year, deleted posts are deleted from the archive database as well, though they will probably still exist in offline backups.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
Pages: « 1 [2]  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!