Change date post

Serialcode

https://www.youtube.com/watch?v=22qm29deUHE
Registered
Joined
Sep 5, 2019
Messages
20
Points
3

Reputation:

how can I change the date of all posts or feature resources?
example: Sep 7,2019
not Andy change date
not Andy change date resource
in your forum do you use addons from Andy change date?

thank you in advance!
 
Last edited:

rOckEt

OldSchool
Collaborate
Registered
Joined
Aug 9, 2019
Messages
55
Points
43

Reputation:

also its easy to write sql to update thread post dates , i tried to do so and got success to it via sql

these are two sql statement i used to change post date on my local server for testing

For threads
SQL:
UPDATE  `test`.`xf_thread` SET  `post_date` =  '14516100001451610000', `last_post_date` =  '1456653155' WHERE  `xf_thread`.`node_id` =2;
For posts
SQL:
UPDATE  `test`.`xf_post` SET  `post_date` =  '14516100001451610000' WHERE  `xf_post`.`message_state` = 'visible';
Replace/update details with your one
  1. test with your database name
  2. `xf_thread`.`node_id` =2; update node id that you have, of that forum whose post date you want to change

take a backup before using these sql query

Credits: Google
 

Serialcode

https://www.youtube.com/watch?v=22qm29deUHE
Registered
Joined
Sep 5, 2019
Messages
20
Points
3

Reputation:

this query no longer works, I had already read this article somewhere, on .rocks I think
 

sucre13

Moderator
Staff member
Moderator
Collaborate
Registered
Joined
Jan 19, 2019
Messages
836
Points
153

Reputation:

My question is why do you want to change the date?
 

Serialcode

https://www.youtube.com/watch?v=22qm29deUHE
Registered
Joined
Sep 5, 2019
Messages
20
Points
3

Reputation:

brò I really need help, can you help me with teamviewer please? thanks a lot
 
Top