Register - Login
Views: 99802554
Main - Memberlist - Active users - Calendar - Wiki - IRC Chat - Online users
Ranks - Rules/FAQ - Stats - Latest Posts - Color Chart - Smilies
05-03-22 07:09:01 AM
Jul - Meta - Suggestion: Time limited deletion for non-Xkeeper admins New poll - New thread - New reply
Next newer thread | Next older thread
Lyskar
12210
-The Chaos within trumps the Chaos without-
Level: 192


Posts: 811/12211
EXP: 99321161
For next: 552410

Since: 07-03-07

From: 52-2-88-7

Since last post: 7.4 years
Last activity: 7.3 years

Posted on 11-29-07 07:11:31 PM Link | Quote
11-29-07 01:11:31pm
811 posts
149 days
I don't know why I put this here.
As the current mess shows, there's these admins, and then they have these passwords that get guessed. And then maniacs destroy giant pieces of the posts with them.

But if you made it limit it to, say, deleting one post an hour, then such rampant abuse would be choked, especially if there was a log of what was deleted by said user so it could be restored.

Of course, I'm one to suggest eighty features when one only needs a single new one, but... that's my two cents.

____________________
"My name is Ozymandias, king of kings: Look on my works, ye mighty, and despair!" Nothing beside remains: round the decay Of that colossal wreck, boundless and bare, The lone and level sands stretch far away. -ShelleyDeath to n00bs!
Rena
I had one (1) message in Discord deleted and proceeded to make a huge, huge mess about how it was a violation of free speech and how moderators are supposed to be spam janitors and nobody should have the right to tell me not to talk about school shootings
Level: 135


Posts: 1642/5390
EXP: 29075565
For next: 259440

Since: 07-22-07

Pronouns: he/him/whatever
From: RSP Segment 6

Since last post: 342 days
Last activity: 342 days

Posted on 11-29-07 07:49:29 PM Link | Quote
JL2 - Post #1642 - 11-29-07 02:49:29pm
I've always found it best to simply mark deleted posts as "deleted" instead of actually removing them from the database. That way they can be restored if necessary. If you get a lot of spam, then you can remove them with an SQL query.

That wouldn't stop anyone from just editing them to be empty/stupid, though. I think the best solution is to just require admins to use good passwords.

____________________
Drag
2640
Level: 99


Posts: 434/2641
EXP: 9990129
For next: 9871

Since: 07-03-07


Since last post: 4.2 years
Last activity: 3.4 years

Posted on 11-29-07 07:51:08 PM Link | Quote
Drag's Post #434
I don't think we need to get *that* extreme. Hiryuu just can't be put back into power until he gets a secure password.

____________________
Xkeeper

Level: 263


Posts: 3756/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 11-30-07 07:41:01 AM Link | Quote
It's not what I thought, so that wouldn't help.

Shrug.

____________________
Hiryuu

Level: 207


Posts: 1539/14435
EXP: 127622091
For next: 2162063

Since: 07-06-07


Since last post: 11.8 years
Last activity: 11.7 years

Posted on 11-30-07 01:45:35 PM Link | Quote
Ω > U
Originally posted by Drag
I don't think we need to get *that* extreme. Hiryuu just can't be put back into power until he gets a secure password.


Reiterating that the staff aside from X has absolutely no clue at times...

If we had time-deletion for non-Xkeeper admins, then how would one go about a spree overflow when some spammer/bot comes to town? If X was asleep or something like that, we'd be up shit creek waiting around for it.

____________________
Xkeeper

Level: 263


Posts: 3763/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 11-30-07 01:48:49 PM Link | Quote
To add to that point, there is a fine line:

Efficiency < ---------- > Stability

Obviously, the most stable method is to remove all methods of changing things (just posting/registering). The most efficient method is to allow those in power to do anything.

Walking this line is difficult, but I don't think our recent failures demand a repositioning. We just made mistakes, so we need to repair those and stop them from happening.



____________________
Erika
Catgirl
미안합니다
Level: 68


Posts: 69/1088
EXP: 2637511
For next: 91289

Since: 07-19-07


Since last post: 9.5 years
Last activity: 9.3 years

Posted on 12-09-07 09:29:52 PM Link | Quote
Originally posted by Metal_Man88
As the current mess shows, there's these admins, and then they have these passwords that get guessed. And then maniacs destroy giant pieces of the posts with them.

But if you made it limit it to, say, deleting one post an hour, then such rampant abuse would be choked, especially if there was a log of what was deleted by said user so it could be restored.

Of course, I'm one to suggest eighty features when one only needs a single new one, but... that's my two cents.

Or they could need to enter a "password" or "code" number every time they wanted to do this. This code would not be stored in a cookie and would be given to each admin in a method offline. They would not be able to delete a thread or edit one without this code entered.

Just a idea ._. but obviously I guess we do not need to even do it..
Black Lord

Magic Emperor
Level: 40


Posts: 13/314
EXP: 408466
For next: 32843

Since: 08-01-07

From: Nebraska

Since last post: 11.3 years
Last activity: 9.7 years

Posted on 12-11-07 03:23:48 PM Link | Quote
I think HyperHacker's having a "isDeleted" flag in the database is the best approach here. That's how a lot of software packages we run at work do it, that way it's all still there, and you don't have to rely on backups. Plus it hardly takes up any space in the database (all you need is bit or bool whatever it's dubbed in mysql (although I think bools in mysql are actually smallint(1)).

Time limited deletion would just be a pain to code, and not worth the time of the coding. The isDeleted flag wouldn't take much time at all to code in, and is a perfect solution to the problem, unless the problem is someone with database access or if it's SQL injection (which is likely) but in any case, an isDeleted flag wouldn't be a bad feature to add in the long run.

____________________

Xkeeper

Level: 263


Posts: 3895/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 12-11-07 03:31:21 PM Link | Quote
Originally posted by Black Lord
I think HyperHacker's having a "isDeleted" flag in the database is the best approach here. That's how a lot of software packages we run at work do it, that way it's all still there, and you don't have to rely on backups. Plus it hardly takes up any space in the database (all you need is bit or bool whatever it's dubbed in mysql (although I think bools in mysql are actually smallint(1)).

Time limited deletion would just be a pain to code, and not worth the time of the coding. The isDeleted flag wouldn't take much time at all to code in, and is a perfect solution to the problem, unless the problem is someone with database access or if it's SQL injection (which is likely) but in any case, an isDeleted flag wouldn't be a bad feature to add in the long run.

The sad part is that I had done that with threads (it only deleted them, not all the posts associated with them any more, so recovery was literally piss easy). The only problem is that lately, he likes changing posts to random crap, not deleting them. (Editing is arguably worse, since it becomes harder to tell what got changed.)

It's something to consider later, I suppose.

____________________

Deleted User
Collection of nobodies
Posted on 12-11-07 09:25:24 PM Link | Quote
Wouldn't the database keep a record of the pre-edit post too though (somewhere)?

____________________


===================
[Posted by NightKev]
Xkeeper

Level: 263


Posts: 3903/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 12-12-07 01:45:04 AM Link | Quote
Originally posted by NightKev
Wouldn't the database keep a record of the pre-edit post too though (somewhere)?

If I wanted it to, yes.

____________________

Deleted User
Collection of nobodies
Posted on 12-12-07 05:08:19 AM Link | Quote
Shouldn't you have it do that then?

____________________


===================
[Posted by NightKev]
Xkeeper

Level: 263


Posts: 3906/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 12-12-07 06:22:13 AM Link | Quote
That would require effort on my part.

____________________

Deleted User
Collection of nobodies
Posted on 12-12-07 09:33:42 PM Link | Quote
Originally posted by Xkeeper
That would require effort on my part.
Hm...didn't it do that on board2? You could port that code (maybe...).

____________________


===================
[Posted by NightKev]
Xkeeper

Level: 263


Posts: 3914/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 12-12-07 11:58:46 PM Link | Quote
Originally posted by NightKev
Originally posted by Xkeeper
That would require effort on my part.
Hm...didn't it do that on board2? You could port that code (maybe...).

No, blackhole89 did it, except he did it in a way completely different than I was going to do it.

Actually implementing it would be really easy. But, as said, that requires effort on my part.

____________________

Deleted User
Collection of nobodies
Posted on 12-12-07 11:59:37 PM Link | Quote
Oh, ok.
*NightKev walks into another thread.

____________________


===================
[Posted by NightKev]
Aerakin
Ye Olde Layout
Level: 98


Posts: 772/2550
EXP: 9475899
For next: 178454

Since: 07-06-07

From: From the future

Since last post: 8.0 years
Last activity: 1.2 years

Posted on 12-13-07 12:00:54 AM (last edited by DarkSlaya at 12-12-07 09:01 PM) Link | Quote
The reason why you're willing to put some effort in anything else but the board is a mystery.



____________________
Layout just didn't go well with mood avatars. Might redo it someday.
Xkeeper

Level: 263


Posts: 3915/25353
EXP: 297141143
For next: 1819310

Since: 07-03-07

Pronouns: they/them/????????

Since last post: 3 days
Last activity: 8 min.

Posted on 12-13-07 04:56:28 PM Link | Quote
Originally posted by DarkSlaya
The reason why you're willing to put some effort in anything else but the board is a mystery.



I haven't put much effort into anything else recently either.

Or, translation; everything I try and start ends up dying off a day later or so. Eh.

We'll see.

____________________

Next newer thread | Next older thread
Jul - Meta - Suggestion: Time limited deletion for non-Xkeeper admins New poll - New thread - New reply


Rusted Logic

Acmlmboard - commit 47be4dc [2021-08-23]
©2000-2022 Acmlm, Xkeeper, Kaito Sinclaire, et al.

28 database queries.
Query execution time: 0.083274 seconds
Script execution time: 0.035537 seconds
Total render time: 0.118812 seconds