2012-08-20, 12:17 AM
Pages: 1 2
2012-08-20, 12:29 AM
your hosting website>Login>PHPMYADMIN>the database you installed mybb on>there
you must edit the mybb_users table as well to change he posts count
the my sql query to get it done
THEOLDUSERNAME = with the old Author of the thread
theTIDOFTHETHREADS = with the tid of the threads
here is how to change the username posts count
THENEWNUMBER = the new number of the posts which in this case will be -1 of the original number
THEOLDNUMBER = the old number of the posts
or you can do it throw the ACP>users and groups>users>username>edit>profile>posts count>save!
you must edit the mybb_users table as well to change he posts count
the my sql query to get it done
UPDATE mybb_threads SET username=THENEWUSERNAME
WHERE username='THEOLDUSERNAME' and tid='theTIDOFTHETHREADS'
THENEWUSERNAME = with the new Author of the threadTHEOLDUSERNAME = with the old Author of the thread
theTIDOFTHETHREADS = with the tid of the threads
here is how to change the username posts count
UPDATE mybb_users SET postnum=THENEWNUMBER
WHERE postnum='THEOLDNUMBER'
THEUSERNAME = the usernameTHENEWNUMBER = the new number of the posts which in this case will be -1 of the original number
THEOLDNUMBER = the old number of the posts
or you can do it throw the ACP>users and groups>users>username>edit>profile>posts count>save!
2012-08-20, 10:41 AM
I writed wrong title I need to change Change MyBB THREAD Author
EDIT:
I found thread that I want to edit in " mybb_threads" and there I changed author but author is still same! What to do?
EDIT:
I found thread that I want to edit in " mybb_threads" and there I changed author but author is still same! What to do?
2012-08-20, 10:46 AM
you did the query that i told you to do ?
2012-08-20, 10:53 AM
I don't even know where to type that query. :/
I loged in into phpmyadmin. I though that I should type it in "SQL" but it looks like I should type that query somewhere else.
I loged in into phpmyadmin. I though that I should type it in "SQL" but it looks like I should type that query somewhere else.
2012-08-20, 10:54 AM
PHPMYADMIN>databases>the databse you installed mybb on>sql tab>enter the query>execute
2012-08-20, 10:59 AM
I get this "1 row affected. ( Query took 0.0005 sec )"
UPDATE mybb_threads SET username = 'Gold' WHERE username = 'Eaglo' AND tid = '8'
BUT EVERYTHING IS AGIAN SAME!
UPDATE mybb_threads SET username = 'Gold' WHERE username = 'Eaglo' AND tid = '8'
BUT EVERYTHING IS AGIAN SAME!
2012-08-20, 11:05 AM
try this query
UPDATE mybb_threads SET username = 'Gold' WHERE tid = '8'
2012-08-20, 11:07 AM
(2012-08-20, 11:05 AM)illusionalp Wrote: [ -> ]try this query
UPDATE mybb_threads SET username = 'Gold' WHERE tid = '8'
Still same. :/
2012-08-20, 11:08 AM
hmm weird
can you go to your PHPmyadmin and open the mybb_threads then take screenshot of the thread with tid8
and is it saying query has been executed ?
can you go to your PHPmyadmin and open the mybb_threads then take screenshot of the thread with tid8
and is it saying query has been executed ?
Pages: 1 2