How would I find out what languages my members are using?<br />so that when I upgrade I know what ones I can dump.

SELECT DISTINCT U_Language FROM w3t_Users

Thanks

Ok, I have now decided to turn OFF display names, but some users still have display names in the DB...<br /><br />What would be the query to change everyone's display name to their login names? (So they are both the same)

?<br />UPDATE w3t_Users<br />SET U_Username = U_LoginName<br /><br />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. <img src="http://www.ubbdev.com/forum/images/graemlins/grin.gif" alt="" />

I need a Query to reset everyones name color to the default "Normal" How would this be done?

well what is normal ? heh <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> BUT you can try<br /><br />UPDATE w3t_Users SET U_Color = ''

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.<br /><br />So my guess is to do...<br />UPDATE w3t_Users SET U_Color = 'normal' <br />(could be worng though. dont run that unless you ask someone) <img src="http://www.ubbdev.com/forum/images/graemlins/smirk.gif" alt="" />

has to be normal? thought it could be empty? they change it? if it has to be normal then yes DrChaos is chaotically correct <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

I said I could be wrong <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />I canged a few and just removed the name of the color where edit the user and nothing happend.<br /><br />then one of my admins said to try to put "normal", because that what all the regular users are set to, and it worked.

well then you are right now wrong and I am wrong not right so glad to meet ya <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

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?<br /><br />It's that time <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

Using the Force Rules mod?<br /><br />UPDATE w3t_Users<br />SET U_Agree = 0

Thanks Josh,I didnt know there was a Mod for that.

Anyone get brave enough to try this out? <br /><br />[] ?<br />UPDATE w3t_Users<br />SET U_Username = U_LoginName<br /><br />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. [/] <br /><br />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 <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />P-

>UPDATE w3t_Users<br />>SET U_Username = U_LoginName<br />>Although I'm not sure if that will pull their U_LoginName, or will actually give everyone the <br />>literal display name of "U_LoginName" so I wouldn't really recommend trying it.<br /><br />Test it with one name first.<br /><br />UPDATE w3t_Users<br />SET U_Username = U_LoginName <br />WHERE U_Number= 124124<br /><br />124124 = your user number

Good idea <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

I ran the follwing query through MyPHPAdmin and it worked...<br /><br />UPDATE w3t_Users<br />SET `U_Username` = `U_LoginName` <br /><br />Thanks Anno<br /><br />P-

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... <br /> <br />

How do I access a list of all of my users e-mail address? Can this be done with a query?