How to change post/discussion time?

ganuonglachanh

Can we change it by PHP?

frans

ganuonglachanh you can directly edit your forum database. Do only when urgent!

clarkwinkelmann

What and when are you trying to do exactly ?

Alter time when a new post is created ?
Alter all dates in a Flarum install ?
Change the format it's displayed in ?
Something else ?

Note: everything visual is done through javascript (format + language)

ganuonglachanh

clarkwinkelmann

I want to make a forum migration/import script in PHP, which mean I can post to flarum with time of the original post.

frans

Edit the database is that last option ? I prefer something like:

$post($post_id)->time = $new_date;

Something like this post:
https://discuss.flarum.org/d/1922-api-users-is-it-possible-to-force-time-related-properties

clarkwinkelmann

ganuonglachanh How are you importing your data ? With PHP ?

Because if you're importing through SQL you can simply use timestamps and configure the timezone on source and destination servers.

If you're importing with PHP through a Flarum extension or a Laravel application you should be able to set the dates on the model. You can use Carbon\Carbon or DateTime objects on these properties.

To find the field names you can have a look at the migration files https://github.com/flarum/core/blob/v0.1.0-beta.6/migrations/2015_02_24_000000_create_discussions_table.php and https://github.com/flarum/core/blob/v0.1.0-beta.6/migrations/2015_02_24_000000_create_posts_table.php

The way you set the column depends on the method you use in PHP (Eloquent models in Flarum or Laravel, raw SQL commands, another ORM, ...)