MyBB Community Forums
[Tutorial] Common SQL queries and how to run them - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Resources (https://community.mybb.com/forum-8.html)
+--- Forum: Tutorials (https://community.mybb.com/forum-38.html)
+--- Thread: [Tutorial] Common SQL queries and how to run them (/thread-44380.html)

Pages: 1 2 3 4 5 6


RE: [Tutorial] Common SQL queries and how to run them - Goggalor - 2009-09-22

Excellent! thank you very much!


RE: [Tutorial] Common SQL queries and how to run them - Jessie S. - 2009-10-05

can i please have a query to change the owners password? I got locked out of my own account and I was wondering if this was possible.


RE: [Tutorial] Common SQL queries and how to run them - Matt - 2009-10-05

Look at the third query down after the 'Ok, so what ones might I need??' title...


RE: [Tutorial] Common SQL queries and how to run them - algernonalton - 2009-10-07

Suppose I want to recover a document that has been accidentally deleted while working. How would I do that? I shall be thankful if you send me the queries.


RE: [Tutorial] Common SQL queries and how to run them - Matt - 2009-10-07

You can't recover a deleted file with an SQL query, they're not stored in the database, and if something is deleted from the database a query won't just add it back unless it's from a backup...


RE: [Tutorial] Common SQL queries and how to run them - algernonalton - 2009-10-08

I thank you for providing me this information and your precious time.


RE: [Tutorial] Common SQL queries and how to run them - ecanikajo - 2010-08-16

How to set default avatar for new users? Whether this can be done through SQL queries?


RE: [Tutorial] Common SQL queries and how to run them - AXVIS - 2010-09-08

What do you mean by this? "requires template changes to remove option to change again"


RE: [Tutorial] Common SQL queries and how to run them - Janota - 2010-09-08

For example if you set everyone thats shown as invisible on the forum to visible:

UPDATE `mybb_users` SET `invisible` = '0' WHERE `invisible` = '1'


And you dont want to allow them to select that option again , you'll need to remove that option from the template so they cant set themselfs as invisible again.

The SQL query will only reset everyone to visible but the option will still remain available unless its removed from the template.


RE: [Tutorial] Common SQL queries and how to run them - AXVIS - 2010-09-08

Oh so if I where to remove all the sig's or avatars nothing bad would happen right?