2011-05-08, 06:09 PM
2011-05-08, 09:33 PM
Yes, it is right.
I recommend backing up your mybb_threads table first though, just in case something goes wrong.
I recommend backing up your mybb_threads table first though, just in case something goes wrong.
2011-09-05, 04:53 AM
With more than one board admin, how does one know what one's uid is? Or are all the admin's uid's the same, meaning it is a group designation and not an individual?
2011-11-29, 09:39 PM
i do upgrade mybb
I gave my password, but show error
I use this training so I changed the password to the test but show :
Error
The password you entered is incorrect. If you have forgotten your password, click here. Otherwise, go back and try again.
Help me
for Change password use this cod ?
UPDATE
X For Me is 1
But my password [test] not Change
please
I gave my password, but show error
I use this training so I changed the password to the test but show :
Error
The password you entered is incorrect. If you have forgotten your password, click here. Otherwise, go back and try again.
Help me
for Change password use this cod ?
UPDATE
mybb_users
SET password
= '098f6bcd4621d373cade4e832627b4f6', salt
= '' WHERE uid
= 'X' X For Me is 1
But my password [test] not Change
please
2012-02-07, 08:21 PM
Is there a query I can run to delete all pm's from a specific member?
2012-02-07, 08:29 PM
DELETE FROM mybb_privatemessages WHERE fromid='uid'
2012-02-07, 09:23 PM
Thanks Paul!
2012-02-19, 11:41 PM
Nice tips though noticed one thing:
You have to sue it?
Quote:Also notice that with these 2 example, the layout is different. One has and ' with spaces between each bit, and one doesn't. Generally speaking, either style will work, but watch out; if you use the first way, you must make sure you [b]sue the correct[/b]
or '. Database tables or column names must have a `, and the information that is to be changed must have a '. SQL query functions are case in- sensetive, so using UPDATE/update, SET/set, WHERE/where will still work fine, whether it's in capitals or not.
You have to sue it?
2012-04-22, 03:51 PM
Is it possible to add to an existing column?
For example if I have a table named Points, and within that table I have a column named Points2
If there were 2 rows in that table, row 1 had 100 for Points2 column, and row 2 had 200 for the Points2 column, is it possible to add 100 to each, so that row 1 would now have 200, and row 2 would have 300?
Also is it possible to prune stuff too?
If one column is used for dates, is it possible to prune from a certain date to another date?
Cheers!
For example if I have a table named Points, and within that table I have a column named Points2
If there were 2 rows in that table, row 1 had 100 for Points2 column, and row 2 had 200 for the Points2 column, is it possible to add 100 to each, so that row 1 would now have 200, and row 2 would have 300?
Also is it possible to prune stuff too?
If one column is used for dates, is it possible to prune from a certain date to another date?
Cheers!
2013-01-06, 02:46 PM
How do i run this on the admin cp.