Deleting System..

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
User avatar
AmigoJack
Registered User
Posts: 103
Joined: Wed May 04, 2011 7:47 pm
Location: グリーン ヒル ゾーン
Contact:

Re: Deleting System..

Post by AmigoJack » Fri Dec 23, 2011 10:49 am

This should never go into phpBB. Find a DBMS which does what you want - that'd be the best approach.

Real-life-examples would be:
  • Telephone numbers: old ones shouldn't be re-used (at least for a while) so people (still) dialing the number aren't confused about the unexpected person on the other end.
  • Insurance numbers: the life history would be mixed up of all owners.
  • Program versions: nobody would expect 1.0 to be a successor to 2.3.
  • Law paragraphs: avoiding chronological confusion, plus it would make everything unnecessary complex (even more).
In the end the reason is always: historical inconsistency.

User avatar
bantu
3.0 Release Manager
3.0 Release Manager
Posts: 557
Joined: Thu Sep 07, 2006 11:22 am
Location: Karlsruhe, Germany
Contact:

Re: Deleting System..

Post by bantu » Fri Dec 23, 2011 11:17 pm

An id is a unique identifier for an object in a system (in this case a phpBB installation). Reusing an identifier after the associated object has been deleted violates the uniqueness property of an identifier.

User avatar
Dragosvr92
Registered User
Posts: 624
Joined: Tue May 31, 2011 12:08 pm
Location: Romania
Contact:

Re: Deleting System..

Post by Dragosvr92 » Sat Dec 24, 2011 9:13 pm

You both do have a point. But, considering that the last person registered is NOT An important member, and just a spammer. No one would have a link bookmarked to the person, considering it must be just a spammer.

It should be deleted and be seen as it was never there. Just my opinion, its ok if others do not agree :)
Previous user: TheKiller
Avatar on Memberlist 1.0.3

doktornotor
Registered User
Posts: 27
Joined: Wed Dec 21, 2011 5:34 pm

Re: Deleting System..

Post by doktornotor » Sun Dec 25, 2011 9:55 am

TheKiller wrote:You both do have a point. But, considering that the last person registered is NOT An important member, and just a spammer. No one would have a link bookmarked to the person, considering it must be just a spammer.

It should be deleted and be seen as it was never there. Just my opinion, its ok if others do not agree :)
Umh... Your OP proposes doing this for posts and topics as well. That is confusing like hell, if a topic/post is gone, it is gone and should not all of a sudden link to a random "next" one. Even if we reduce the idea to user IDs alone, I can well imagine the IDs being linked via some antispam forums (SFS etc.)

User avatar
Dragosvr92
Registered User
Posts: 624
Joined: Tue May 31, 2011 12:08 pm
Location: Romania
Contact:

Re: Deleting System..

Post by Dragosvr92 » Sun Dec 25, 2011 12:15 pm

StopForumSpam doesnt care what the page of the user is on different forums. They just need the spammer ip, email, username.
Previous user: TheKiller
Avatar on Memberlist 1.0.3

User avatar
AmigoJack
Registered User
Posts: 103
Joined: Wed May 04, 2011 7:47 pm
Location: グリーン ヒル ゾーン
Contact:

Re: Deleting System..

Post by AmigoJack » Mon Dec 26, 2011 12:57 pm

I think your main (psychological) problem is that most IDs are ascending ordinals. If phpBB would use literals (i.e. hashes based on username plus/or e-mail-address) as indices nothing would be lost or wasted by not using one of those indices anymore. Same goes for everything else: forums, topics and posts could have hashes based on their creation time...

User avatar
Ger
Registered User
Posts: 293
Joined: Mon Jul 26, 2010 1:55 pm
Location: 192.168.1.100
Contact:

Re: Deleting System..

Post by Ger » Mon Dec 26, 2011 1:03 pm

I think the main question would be: what's the gain?
IMHO, there is no gain, but there would be loss if such a system (either hashing or reusing id's) is used, since it will slow down performance and it will result in possible inconsistent data.
Above message may contain errors in grammar, spelling or wrongly chosen words. This is because I'm not a native speaker. My apologies in advance.

User avatar
callumacrae
Former Team Member
Posts: 1046
Joined: Tue Apr 27, 2010 9:37 am
Location: England
Contact:

Re: Deleting System..

Post by callumacrae » Mon Dec 26, 2011 7:42 pm

Ger wrote:I think the main question would be: what's the gain?
IMHO, there is no gain, but there would be loss if such a system (either hashing or reusing id's) is used, since it will slow down performance and it will result in possible inconsistent data.
Hashing is a lot cleaner, and is used a lot in NoSQL systems. I haven't really seen it used in MySQL, but it still works.
Made by developers, for developers!
My blog

User avatar
DavidIQ
Customisations Team Leader
Customisations Team Leader
Posts: 1803
Joined: Thu Mar 02, 2006 4:29 pm
Location: Earth
Contact:

Re: Deleting System..

Post by DavidIQ » Tue Dec 27, 2011 12:30 am

Hashes are not recommended for use in SQL Server and Microsoft discourages its use as primary key identifiers.
Image

Post Reply