Previous Thread
Next Thread
Print Thread
Rate Thread
Page 3 of 3 1 2 3
Joined: Apr 2002
Posts: 474
Enthusiast
Enthusiast
Offline
Joined: Apr 2002
Posts: 474
How would I find out what languages my members are using?
so that when I upgrade I know what ones I can dump.

Sponsored Links
Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
SELECT DISTINCT U_Language FROM w3t_Users

Last edited by scroungr; 05/27/2004 2:39 PM.
Joined: Apr 2002
Posts: 474
Enthusiast
Enthusiast
Offline
Joined: Apr 2002
Posts: 474
Thanks

Joined: Aug 2002
Posts: 100
Journeyman
Journeyman
Offline
Joined: Aug 2002
Posts: 100
Ok, I have now decided to turn OFF display names, but some users still have display names in the DB...

What would be the query to change everyone's display name to their login names? (So they are both the same)

Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
?
UPDATE w3t_Users
SET U_Username = U_LoginName

Although I'm not sure if that will pull their U_LoginName, or will actually give everyone the literal display name of "U_LoginName" so I wouldn't really recommend trying it.

Sponsored Links
Joined: Mar 2004
Posts: 16
Newbie
Newbie
Offline
Joined: Mar 2004
Posts: 16
I need a Query to reset everyones name color to the default "Normal" How would this be done?

Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
well what is normal ? heh BUT you can try

UPDATE w3t_Users SET U_Color = ''

Joined: Sep 2003
Posts: 803
Coder
Coder
Offline
Joined: Sep 2003
Posts: 803
If you want to make the color of the names the default color you have to type "Normal" into the color section. It will make them the forum default.

So my guess is to do...
UPDATE w3t_Users SET U_Color = 'normal'
(could be worng though. dont run that unless you ask someone)

Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
has to be normal? thought it could be empty? they change it? if it has to be normal then yes DrChaos is chaotically correct

Joined: Sep 2003
Posts: 803
Coder
Coder
Offline
Joined: Sep 2003
Posts: 803
I said I could be wrong

I canged a few and just removed the name of the color where edit the user and nothing happend.

then one of my admins said to try to put "normal", because that what all the regular users are set to, and it worked.

Sponsored Links
Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
well then you are right now wrong and I am wrong not right so glad to meet ya

charts #258597 10/28/2004 1:42 AM
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
Can anyone tell me the query to require all users to review the Forum Rules and accept or reject on their next visit to the board?

It's that time

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Using the Force Rules mod?

UPDATE w3t_Users
SET U_Agree = 0

Daine #258599 10/28/2004 5:25 AM
Joined: Nov 2002
Posts: 554
Code Monkey
Code Monkey
Offline
Joined: Nov 2002
Posts: 554
Thanks Josh,I didnt know there was a Mod for that.

Joined: Feb 2004
Posts: 16
Newbie
Newbie
Offline
Joined: Feb 2004
Posts: 16
Anyone get brave enough to try this out?

[] ?
UPDATE w3t_Users
SET U_Username = U_LoginName

Although I'm not sure if that will pull their U_LoginName, or will actually give everyone the literal display name of "U_LoginName" so I wouldn't really recommend trying it. [/]

I have a bunch of users who I need to make their eamil / fake email and user name / display name all match. A SQL call like this would save me a lot of time

P-

Joined: May 2001
Posts: 550
Code Monkey
Code Monkey
Offline
Joined: May 2001
Posts: 550
>UPDATE w3t_Users
>SET U_Username = U_LoginName
>Although I'm not sure if that will pull their U_LoginName, or will actually give everyone the
>literal display name of "U_LoginName" so I wouldn't really recommend trying it.

Test it with one name first.

UPDATE w3t_Users
SET U_Username = U_LoginName
WHERE U_Number= 124124

124124 = your user number

Joined: Feb 2004
Posts: 16
Newbie
Newbie
Offline
Joined: Feb 2004
Posts: 16
Good idea

Joined: Feb 2004
Posts: 16
Newbie
Newbie
Offline
Joined: Feb 2004
Posts: 16
I ran the follwing query through MyPHPAdmin and it worked...

UPDATE w3t_Users
SET `U_Username` = `U_LoginName`

Thanks Anno

P-

Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
Here is the old query by RandyJG that JoshPet used in the Stylesheet Popularity mod. Since we have been able to store queries in the past couple of versions, the mod is no longer needed, but the query could still be helpful...

Code
 <br />SELECT COUNT(*) as total,U_StyleSheet as style <br />FROM w3t_Users <br />GROUP BY U_StyleSheet <br />ORDER BY total DESC <br />

Joined: Aug 2004
Posts: 173
Member
Member
Offline
Joined: Aug 2004
Posts: 173
How do I access a list of all of my users e-mail address? Can this be done with a query?

Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
SELECT U_RegEmail, U_Email, U_Fakeemail FROM w3t_Users;


Nikos
Joined: Aug 2004
Posts: 173
Member
Member
Offline
Joined: Aug 2004
Posts: 173
Worked a treat, thank you

Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
Select U_Email from w3t_Users where u_number > 1;

Joined: Nov 2001
Posts: 134
Journeyman
Journeyman
Offline
Joined: Nov 2001
Posts: 134
How about a script to show user ID's that have been created from the same IP address, even if you dont know the IP address?

Daine #258610 01/30/2005 2:44 PM
Joined: Nov 2001
Posts: 134
Journeyman
Journeyman
Offline
Joined: Nov 2001
Posts: 134
[]JoshPet said:
Using the Force Rules mod?

UPDATE w3t_Users
SET U_Agree = 0 [/]

This one no longer seems to work on 6.5.. is there a new way of doing this?

Ta

Joined: Mar 2003
Posts: 159
Member
Member
Joined: Mar 2003
Posts: 159
What would the script be to reset/update all users to no avatar?

Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
UPDATE w3t_Users SET U_Picture = ''

Joined: Dec 2002
Posts: 7
Lurker
Lurker
Offline
Joined: Dec 2002
Posts: 7
I am wondering if anyone could help out with a query to basically duplicate a group under another name? I have about 5000 members and we're looking for a simple way to plan one heck of a going away party for one of our members without his knowledge. It would seem that this could be easily done by creating a new group and adding all members in the "users" group to this new group.... and then removing our guest of honor from the new group so he wouldn't have permissions to see our "hidden" party planning forum.

Any ideas? I've played with doing this manually, a couple members at a time, but it is rediculously slow going.

Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
version of threads would be helpful since...most versions can do it already at least 6.4 and 6.5 by just adding a new user group and then selecting everyone in user group and adding them to new group?

234234 #258615 04/15/2005 10:09 AM
Joined: Dec 2002
Posts: 7
Lurker
Lurker
Offline
Joined: Dec 2002
Posts: 7
6.4.1

I've already tried to do this through the AP using the "mass group change" but if I try to do any more then 4 or 5 members at a time it just grinds to a halt.

Joined: Jan 2003
Posts: 263
Member
Member
Joined: Jan 2003
Posts: 263
I need a query to do the following:

List all usernames + email adresses + number of PM's in their inbox from users with more than 2 PM's in their INBOX

How?

Joined: Jan 2003
Posts: 263
Member
Member
Joined: Jan 2003
Posts: 263
Ok, I think I got it, but I'm not 100% if this is correct:


--------------------------------------------------------------------------------

SELECT w3t_Users.U_Email,
w3t_Users.U_LoginName,
w3t_Users.U_Username,
COUNT(w3t_Messages.M_Uid)
FROM w3t_Messages, w3t_Users
GROUP BY w3t_Users.U_Number
HAVING COUNT(w3t_Messages.M_uid) > 2

I tried to run this, but my browser seemed to hang. I cancelled the query after 20 minuten (my whole database is only 40mb).

What am I doing wrong here ?

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3

To delete pm's (like all those welcome pm's that re-appear after upgrading), try these commands:

Code

DELETE FROM `ubbt_PRIVATE_MESSAGE_TOPICS` WHERE `TOPIC_SUBJECT` = 'Welcome'

DELETE FROM `ubbt_PRIVATE_MESSAGE_POSTS` WHERE `POST_BODY` LIKE '%Welcome to our forums%'

Change the topic subject wording to whatever you send to new registered members. smile

There's still the ubbt_PRIVATE_MESSAGE_USERS table - I imagine a script would need to be written to match the pm with the topic id being deleted above and clean that out too.


- Allen wavey
- What Drives You?
Joined: Mar 2004
Posts: 118
Journeyman
Journeyman
Offline
Joined: Mar 2004
Posts: 118
This is what I do:
Code
 
SELECT R_Rating, R_Rater, U_Username, U_Totalposts, R_What
FROM _forum_Ratings, _forum_Users
WHERE R_Rater = U_Number
AND R_Type = 'u'
AND U_Totalposts < 50
ORDER BY U_Totalposts, R_Rater ASC

I get a list of Users who have less than 50 posts and have done a rating on somebedy.

I also get the name of the user who rated but I don't know how to get the name of the user who WAS rated (R_What is user ID).

Can anyone provide me with solution?


Kind regards,
PaNTerSan
Joined: Mar 2004
Posts: 118
Journeyman
Journeyman
Offline
Joined: Mar 2004
Posts: 118
Next question is how to update U_Rating, U_Rates, U_RealRating to match values in R_Rating?

Of course without having to write a script but rathrer running a query smile


Kind regards,
PaNTerSan
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
What version are you running?


- Allen wavey
- What Drives You?
Joined: Mar 2004
Posts: 118
Journeyman
Journeyman
Offline
Joined: Mar 2004
Posts: 118
Originally Posted by AllenAyres
What version are you running?
6.5.5

I'll write the script but I would like to learn how to do it via sql if possible smile


Kind regards,
PaNTerSan
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Originally Posted by PaNTerSan
This is what I do:
Code
 
SELECT R_Rating, R_Rater, U_Username, U_Totalposts, R_What
FROM _forum_Ratings, _forum_Users
WHERE R_Rater = U_Number
AND R_Type = 'u'
AND U_Totalposts < 50
ORDER BY U_Totalposts, R_Rater ASC

I get a list of Users who have less than 50 posts and have done a rating on somebedy.

I also get the name of the user who rated but I don't know how to get the name of the user who WAS rated (R_What is user ID).

Can anyone provide me with solution?


You are querying for R_What - that's not giving you the result you are looking for?


- Allen wavey
- What Drives You?
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
This really isn't quite a mod, but may help those wanting to increase activity on their sites. Currently it's a bit of a jump through the hoops to get emails for watched topics and forums - I've repeatedly had to tell people the couple of things they have to do to get emails.

Here's the mysql commands you put into your SQL Command window to set everyone to receive emails for replies to any topics they are watching:

Code

UPDATE ubbt_USER_PROFILE SET USER_EMAIL_WATCHLISTS = '1'

Code

UPDATE ubbt_WATCH_LISTS SET WATCH_NOTIFY_IMMEDIATE = '1'

and if you also want to set all users to receive email when they get a pm, use this one:

Code

UPDATE ubbt_USER_PROFILE SET USER_NOTIFY_ON_PM = 'yes'

And lastly, if you want all users to receive emails from admins, then use this one:

Code

UPDATE ubbt_USER_PROFILE SET USER_ACCEPT_ADMIN_EMAILS = 'yes'

note: the last one might get a few complaints since I believe it specifically is set by the user to opt out, I may be wrong - it's been a while since I was a newbie wink


- Allen wavey
- What Drives You?
Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
In addition to those commands from Allen, I would strongly recommend editing all your emails that go out - at the moment they are very weak, and do not let the user know how to unsubscribe from the email that they have just received.

For example my notification of a PM says...

Quote
You have received a private message at Fans Focus. You can go to http://www.fansfocus.com/forums/ubbthreads.php to view it.

You can turn off these notifications from http://www.fansfocus.com/forums/ubbthreads.php/ubb/editdisplay on the forums.

http://www.fansfocus.com

--------------------

Nothing elaborate - but it gets around anyone accusing us of spamming them.

And all my emails have the subject starting...

FansFocus.Com:



Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)
Page 3 of 3 1 2 3

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)