| View previous topic :: View next topic |
| Author |
Message |
Cutriss
Staff Member
Joined: 24 Jan 2002
|
0.  Posted: Thu Aug 07, 2003 2:50 pm Post subject: Banned users listing and other DB maintenance |
 |
|
Sorry that the title sucks, but I couldn't really think of a better way to describe this.
On the HardOCP forums, whenever a user gets banned, his/her postrank changes to "Banned". I think it might be useful if something along these lines was implemented here. Yeah, it's more for morbid curiosity than anything else, but there are certain instances when it's useful to know why certain people aren't around anymore...and that could cut down on "Whatever happened to ???" threads being made.
Also, on a separate note - I think it would be trivial to modify the query executed by phpBB for Memberlist to remove users that haven't actually made any posts...Something like
SELECT * FROM USERS WHERE (POSTCOUNT > 0) AND ...
It'd probably cut the list in half...and it'd make searching for a particular user's name *much* easier. And I *really* can't see a reason why those accounts are being held onto anyway, or why anyone would want to search for them to begin with. Surely they could be pruned after, say, one month of inactivity with zero posts...
_________________
Sentient Mode is capable... |
|
| Back to top |
|
 |
Edible Bondage Tape
Trick Member
Joined: 26 Jan 2002
Location: Kerri |
| 1. Posted: Thu Aug 07, 2003 3:15 pm Post subject: |
|
|
becasue we arnt supposed to talk about banned members it would thoerticly cause us to question the mods decisions and we arnt supposed to do taht becsaue the mods ae suposed to be infallible
as for your second idea that would mean even MORE monkeying with the code and all the work so far as already buggered to forums halfway to hell
_________________
|
|
| Back to top |
|
|
Cutriss
Staff Member
Joined: 24 Jan 2002
|
| 2. Posted: Thu Aug 07, 2003 4:41 pm Post subject: |
|
|
| Excited Bishounen Toucher wrote: | | becasue we arnt supposed to talk about banned members it would thoerticly cause us to question the mods decisions and we arnt supposed to do taht becsaue the mods ae suposed to be infallible |
Uh...this is DDRFreak, not GameFAQs. The mods here are reasonable and sensible. And most importantly, human, just like everyone else.
And people talk all the time about Sl1p (However the fsck you spell it), Tran, and most recently Skip, so your comment doesn't make sense at all, even if it was intended to be funny. | Excited Bishounen Toucher wrote: | | as for your second idea that would mean even MORE monkeying with the code and all the work so far as already buggered to forums halfway to hell |
Hardly. Not all the problems are a result of the "monkeying around" you know. Some friends of mine and I host a much much smaller phpBB that rarely has more than three simultaneous users, and we've got postbug on ours. It's a problem with phpBB/mySQL, and not with the custom mods.
If anything, the suggestion I made above would lighten the load, *reducing* the number of instances of problems (albeit in a small way).
_________________
Sentient Mode is capable... |
|
| Back to top |
|
|
mrÖ¼selfÖ¼Äestruct
Maniac Member
Joined: 10 Mar 2002
Location: a warm place |
| 3. Posted: Thu Aug 07, 2003 4:57 pm Post subject: |
|
|
| Cutriss wrote: | | Uh...this is DDRFreak, not GameFAQs. The mods here are reasonable and sensible. And most importantly, human, just like everyone else. |
God I wish everyone felt that way =\
At least it's good to know some people here do =D
_________________
|
|
| Back to top |
|
|
onoessnaked
Staff Member
Joined: 22 Aug 2002
Location: UK |
|
| Back to top |
|
|
Mr. Deus
Trick Member
Joined: 27 Dec 2002
Location: smooveville |
| 5. Posted: Thu Aug 07, 2003 5:30 pm Post subject: |
|
|
| Excited Bishounen Toucher wrote: | | becasue we arnt supposed to talk about banned members it would thoerticly cause us to question the mods decisions and we arnt supposed to do taht becsaue the mods ae suposed to be infallible |
No, it's because they get enough shit from people already. Not because they're some autonomous Leauge of Assholes |
|
| Back to top |
|
|
Mouse
Staff Member
Joined: 28 Jan 2002
Location: Toon Town |
| 6. Posted: Thu Aug 07, 2003 5:45 pm Post subject: |
|
|
you know, you people complain too much about the mods. every chance that comes up to say something like, "TEH MODS R STOOPID!", somebody says something. I think we get the point. no need to beat it into the dirt. it's already dead. I don't think it's going to get up and run anymore.
and about cutting out members that haven't made any posts, that isn't necessarily a good thing. somebody may have made an account and something may have come up preventing them from posting right away. sometimes people will come back and finally start posting after they've had an account for awhile.
_________________
|
|
| Back to top |
|
|
J Dogg
Administrator
Joined: 16 Jan 2002
Location: Sunnyvale, CA |
| 7. Posted: Thu Aug 07, 2003 5:51 pm Post subject: |
|
|
Some people make accounts to submit/modify machine locations, and might not necessarily post.
_________________
|
|
| Back to top |
|
|
Bringer of Death
Trick Member
Joined: 08 Apr 2002
Location: Saving the world, one death at a time. |
| 8. Posted: Thu Aug 07, 2003 7:11 pm Post subject: |
|
|
Let's not forget that J Dogg CAN afford to have users with zero postcounts. There was a thread on this a while back...
_________________
| iperson wrote: | | EBT wrote: | | Hey man, what's for dinner tonight? |
You have asked for infinity and you don't deserve it. |
 |
|
| Back to top |
|
|
Cutriss
Staff Member
Joined: 24 Jan 2002
|
| 9. Posted: Thu Aug 07, 2003 7:16 pm Post subject: |
|
|
| Mouse damnit! wrote: | | and about cutting out members that haven't made any posts, that isn't necessarily a good thing. somebody may have made an account and something may have come up preventing them from posting right away. sometimes people will come back and finally start posting after they've had an account for awhile. |
Well, I hardly think that it'd be inconveniencing them that much. At the very least, if the account is unused and stays that way for 30 days, cancel it and send a notification e-mail to the person that registered it. If they wanna post here that badly, then they can do it again. | J Dogg wrote: | | Some people make accounts to submit/modify machine locations, and might not necessarily post. |
Got me there... I was going to spend a couple of minutes writing some hypothetical SQL statements to pull a list of unused accounts from a list of submitted machine location submissions, usernames to be subtracted from a list of unused logins in the users table...but enh...whatever.  | The Anti-Hero wrote: | | Let's not forget that J Dogg CAN afford to have users with zero postcounts. There was a thread on this a while back... |
I'm not sure how you mean. Larger table sizes don't affect runtime of a database, *unless* there are queries which frequently access that table. When that happens, in the case of using the Memberlist, which is the specific instance I was referring to, then larger table sizes mean longer times for a human to parse the table, which means a larger number of queries on the table. Voila. Increased DB activity.
This particular case could be easily solved by modifying the query done by Memberlist so that it excludes 0-post members that haven't used the forums in 30 days.. They wouldn't need to be pruned, but this would save resources.
Alternatively, a better interface to Memberlist could be developed, so that usernames could be found more quickly.
The reason this sticks out in my mind is this - Suppose I want to look at someone's profile. Profiles are indexed by usernumber, which is unintelligible to end users. So, to look up a profile, you have to find a post/thread made by that user (which could take forever, and likely involves the now-unavailable Search). *OR*...You sort the Memberlist alphabetically, and start doing the human equivalent of the binary search, until you finally find the page containing the user you're looking for.
A query already exists in the Administrative Panel to do member profile lookups based on entering the username. It's fast, since it's a single select and comparison. So, if memberlist.php was edited to include a form for that query, the problem could also be solved that way.
_________________
Sentient Mode is capable... |
|
| Back to top |
|
|
Edible Bondage Tape
Trick Member
Joined: 26 Jan 2002
Location: Kerri |
| 10. Posted: Fri Aug 08, 2003 3:16 am Post subject: |
|
|
| Cutriss wrote: | | Excited Bishounen Toucher wrote: | | becasue we arnt supposed to talk about banned members it would thoerticly cause us to question the mods decisions and we arnt supposed to do taht becsaue the mods ae suposed to be infallible |
Uh...this is DDRFreak, not GameFAQs. The mods here are reasonable and sensible. And most importantly, human, just like everyone else.
And people talk all the time about Sl1p (However the fsck you spell it), Tran, and most recently Skip, so your comment doesn't make sense at all, even if it was intended to be funny. |
i wasnt being funny its even in the faq (or it was when I joined) locked topics and banned members are both black listed from public descution.
_________________
|
|
| Back to top |
|
|
Bringer of Death
Trick Member
Joined: 08 Apr 2002
Location: Saving the world, one death at a time. |
| 11. Posted: Sat Aug 09, 2003 9:47 am Post subject: |
|
|
| Cutriss wrote: | | I'm not sure how you mean. |
What I mean is that J Dogg has the money to afford...say...1kb, if that, for all those users with zero postcounts. I don't know, maybe I got what you said mixed up.
_________________
| iperson wrote: | | EBT wrote: | | Hey man, what's for dinner tonight? |
You have asked for infinity and you don't deserve it. |
|
|
| Back to top |
|
|
Cutriss
Staff Member
Joined: 24 Jan 2002
|
| 12. Posted: Sat Aug 09, 2003 1:04 pm Post subject: |
|
|
| Excited Bishounen Toucher wrote: | | i wasnt being funny its even in the faq (or it was when I joined) locked topics and banned members are both black listed from public descution. |
It's not there now. | The Anti-Hero wrote: | | Cutriss wrote: | | I'm not sure how you mean. |
What I mean is that J Dogg has the money to afford...say...1kb, if that, for all those users with zero postcounts. I don't know, maybe I got what you said mixed up. |
I'm not talking about disk space. I'm talking about CPU time. My suggestion, in a very minimal way, would help speed up the server by reducing the number of probable DB transactions.
_________________
Sentient Mode is capable... |
|
| Back to top |
|
|
MPB3.Radio
Trick Member
![]()
Joined: 05 Dec 2002
Location: P-Town |
| 13. Posted: Tue Aug 12, 2003 2:48 pm Post subject: |
|
|
The query modification would actually increase load since MySQL would still have to sift through the entire table with a field comparison added to that. Pruning the user base would be the most logical thing to do as far as reducing load. Editing a single query that is isolated to a certain module of the board isn't going to affect any other pages.
If the goal is to reduce overhead, then it would be more logical to disable the searching functions. I get little or no results using it, and I can only assume that it takes a good deal of time to go through the hundreds of thousands of posts on this forum. |
|
| Back to top |
|
|
Cutriss
Staff Member
Joined: 24 Jan 2002
|
| 14. Posted: Tue Aug 12, 2003 3:09 pm Post subject: |
|
|
| Radio wrote: | | The query modification would actually increase load since MySQL would still have to sift through the entire table with a field comparison added to that. Pruning the user base would be the most logical thing to do as far as reducing load. Editing a single query that is isolated to a certain module of the board isn't going to affect any other pages. |
No, no, no!
The point is *not* to reduce the amount of time that SQL takes to run the query. The point is to reduce the number of queries that a user might execute on the database to execute a particular task. Doing a comparison against the table with a fixed size has a runtime of O(1), whereas doing the name-hunt takes O(ln n), because it's a human-executed binary search. It's a totally different concept.
_________________
Sentient Mode is capable... |
|
| Back to top |
|
|
MPB3.Radio
Trick Member
![]()
Joined: 05 Dec 2002
Location: P-Town |
| 15. Posted: Tue Aug 12, 2003 8:34 pm Post subject: |
|
|
| I was referring to just the retrieval of user data for the memberlist. I'm sure the search functions can be easily divided seeing as doing a full scan of posts isn't exactly an efficient means of looking for users. |
|
| Back to top |
|
|
rampage
Administrator
Joined: 24 Jan 2002
Location: Redmond, WA |
| 16. Posted: Wed Aug 13, 2003 12:17 pm Post subject: |
|
|
| Such a retrieval mechanism wouldn't make queries any faster or slower. All of those fields are indexes so it's not like it'd require any more of a full table scan than just a standard ML. |
|
| Back to top |
|
|
thechibiknight
Trick Member
Joined: 13 Apr 2003
Location: Tacoma, WA |
| 17. Posted: Wed Aug 13, 2003 4:41 pm Post subject: |
|
|
God you guys are pathetic...
Skip should not have been banned (yes I made a thread about it). He didn't do anything wrong, I know skip--he's not a bad guy.
Sheesh the mods at ddrfreak are terrible. No wonder I post at atlantabemani....
What is wrong with you people? Just let people have a little fun on the forums...
Is that really too much to ask?
-TCK
_________________
Team Screaming Fetus!!
�`�[�����ÑÌÙ� !!! (Team �����ÑÌ�����)
"No Fetus can beat us..." - Yucko |
|
| Back to top |
|
|
IguanaGrrl
Staff Member
Joined: 17 Jan 2002
Location: Sacramento, CA |
| 18. Posted: Wed Aug 13, 2003 6:02 pm Post subject: |
|
|
| thechibiknight wrote: | God you guys are pathetic...
Skip should not have been banned (yes I made a thread about it). He didn't do anything wrong, I know skip--he's not a bad guy.
Sheesh the mods at ddrfreak are terrible. No wonder I post at atlantabemani....
What is wrong with you people? Just let people have a little fun on the forums...
Is that really too much to ask?
-TCK |
http://www.ddrfreak.com/phpBB2/faq.php
Take a look at the FAQ. Rules were broken, he got banned. I didn't like having to give him those final points, but he earned them, like it or not. I have no personal issues with the guy, I was just doing my job as a moderator.
Get past it.
_________________
|
|
| Back to top |
|
|
mrÖ¼selfÖ¼Äestruct
Maniac Member
Joined: 10 Mar 2002
Location: a warm place |
| 19. Posted: Thu Aug 14, 2003 12:58 am Post subject: |
|
|
| thechibiknight wrote: | God you guys are pathetic...
Skip should not have been banned (yes I made a thread about it). He didn't do anything wrong, I know skip--he's not a bad guy.
Sheesh the mods at ddrfreak are terrible. No wonder I post at atlantabemani....
What is wrong with you people? Just let people have a little fun on the forums...
Is that really too much to ask?
-TCK |
then uh..... don't post here?
Seriously, if you hate all of us so much and that's the type of attitude you have towards someone who was doing what they had to, then I really doubt you'll be missed.
_________________
|
|
| Back to top |
|
|
|
Forums FAQ
Search
Memberlist
Usergroups
Register
Profile
Login to check your private messages
Login
