[Tutorial] Common SQL queries and how to run them
#11
Excellent! thank you very much!
Reply
#12
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.

[Image: iYa29IFsjRtGF.png]


Reply
#13
Look at the third query down after the 'Ok, so what ones might I need??' title...
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Reply
#14
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.
Reply
#15
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...
MyReactions - All Plugins

Can you still feel the butterflies?

Free never tasted like pudding.
Reply
#16
I thank you for providing me this information and your precious time.
Reply
#17
How to set default avatar for new users? Whether this can be done through SQL queries?
Reply
#18
This user has been denied support. This user has been denied support.
What do you mean by this? "requires template changes to remove option to change again"
Reply
#19
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.
Reply
#20
This user has been denied support. This user has been denied support.
Oh so if I where to remove all the sig's or avatars nothing bad would happen right?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)