Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Gizmo, SteveS), 38 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/07/07
Posts: 4
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 23
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#247744 - 01/09/12 06:24 AM A List of Moderators to Forums
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Does any one have a sql to show what moderators are moderating which forums and there user names ?

Mark = forum 4, 5, 6,11

Its a pain keeping track with 8 moderators and 60 forums.

I did try the sql but could only get this far.

SELECT * FROM `ubbt_MODERATORS` ORDER BY `ubbt_MODERATORS`.`USER_ID` ASC LIMIT 0, 300
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#247746 - 01/09/12 11:57 AM Re: A List of Moderators to Forums [Re: Mark S]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
Sql Query:
SELECT u.USER_DISPLAY_NAME, f.FORUM_ID, f.FORUM_TITLE
FROM ubbt_MODERATORS m, ubbt_USERS u, ubbt_FORUMS f
WHERE u.USER_ID = m.USER_ID
AND m.FORUM_ID = f.FORUM_ID
GROUP BY u.USER_DISPLAY_NAME, m.FORUM_ID
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#247760 - 01/10/12 02:43 AM Re: A List of Moderators to Forums [Re: Mark S]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Thank you very Much Sir "D" and a Happy new year to you too smile
Thank you.

That's going to save me some brain power lol

Mark
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
#247816 - 01/12/12 01:32 PM Re: A List of Moderators to Forums [Re: Mark S]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
This was the kind of thing that I asked to be included in the new version about 3 years ago... Some fundamental scripts (or Reports) of various outputs to assist in managing the Board.

Also asked for a matrix showing which Custom Islands were appearing inside "which" forums.

Anything to help make the administration of the Board easier.

Of course, the BAN SPAMMER function seriously needs to be strengthened. Too bad it couldn't be a ONE-CLICK feature where the IP and EMAIL address are BOTH added simultaneously. ANd -- the topic is locked/or/deleted based upon selection.

Cool, huh?
_________________________
--BIll B
Top
#247817 - 01/12/12 01:43 PM Re: A List of Moderators to Forums [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
I agree.
I have repeatedly asked for years to have some simple tools added to the saved mysql queries in the control panel as a default install.
Currently there are some nice ones here but they are all over the place.
Maybe when I get time I can find most of them and start adding them to the UBB.Wiki.
They should be fairly easy to locate, most all of them come from very few people.
SD,Rick,Gizmo to name most all.
_________________________
Blue Man Group
Top
#247818 - 01/12/12 01:44 PM Re: A List of Moderators to Forums [Re: Ruben]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
If someone is so inclined to point me to some. I will gladly add them.
_________________________
Blue Man Group
Top
#247823 - 01/12/12 02:53 PM Re: A List of Moderators to Forums [Re: Mark S]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Removed.... I found an answer.

Due to spam postings on the UBB.Wiki, all editors must be approved before they can add/edit content. If you're interested in being an editor, please email us here and let us know the username that you signed up with. Please also include your UBBCentral and UBBDev usernames.


Edited by Bill B (01/12/12 03:02 PM)
Edit Reason: Answered
_________________________
--BIll B
Top
#247824 - 01/12/12 03:30 PM Re: A List of Moderators to Forums [Re: Bill B]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL

HUH? I don't get it.
_________________________
Blue Man Group
Top
#247825 - 01/12/12 04:29 PM Re: A List of Moderators to Forums [Re: Ruben]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Sorry... I'll explain... My posting originally asked why I couldn't post in the UBB.Wiki... I wanted to donate a CUSTOM ISLAND. My concept is that EVERYONE can post to a UBB.Wiki, but all input goes into a pool, until a moderator approves it.

Then I went back and saw the comment about "spamming" and "sign up".... So now I understand. Thanks.
_________________________
--BIll B
Top
#247827 - 01/12/12 04:33 PM Re: A List of Moderators to Forums [Re: Mark S]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Bill, due to spammers, we only allow approved editors at the UBB.Wiki (which at this time is only Ruben, Glider, and Myself), if you'd like to donate anything or request anything added feel free to send a PT to Ruben and Myself here on UBB.Central.

We get quite a few spam registrations on the UBB.Wiki every day, so instead of praying they wouldn't cause a mess it was locked down pretty quickly when they started finding the site...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#247828 - 01/12/12 04:35 PM Re: A List of Moderators to Forums [Re: Mark S]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Oh okay.
Since I already have access I did not know that.
I might need to find the moderator approval page. LOL
_________________________
Blue Man Group
Top
#247835 - 01/12/12 05:02 PM Re: A List of Moderators to Forums [Re: Mark S]
Bill B Offline

member
Registered: 10/29/06
Posts: 189
Loc: Issaquah, WA
Yep, I totally understand... I kill about 5 of those a week on my Board.


I'll send you my Island that I built and found useful.
_________________________
--BIll B
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image