public function actionSubmit()
 {
     if (($message_text = Yii::$app->request->post('chatText', null)) == null) {
         // if nothing was submitted
         return;
     }
     $chat = new UserChatMessage();
     $chat->message = $message_text;
     $chat->save();
 }
 public static function onDailyCron($event)
 {
     $controller = $event->sender;
     $controller->stdout("Deleting old chat_messages... ");
     $timeout = Setting::Get('timeout', 'humhubchat');
     if (!$timeout || $timeout == null || $timeout <= 0) {
         $controller->stdout('skipped! no timeout set.' . PHP_EOL, \yii\helpers\Console::FG_YELLOW);
         return;
     }
     // delete old chats
     UserChatMessage::deleteAll(['<', 'created_at', Yii::$app->formatter->asDatetime(strtotime("- {$timeout} day"), 'php:Y-m-d H:i:s')]);
     $controller->stdout('done.' . PHP_EOL, \yii\helpers\Console::FG_GREEN);
 }
 public function down()
 {
     $this->dropTable(UserChatMessage::tableName());
     return true;
 }
 public function down()
 {
     $this->dropTable(UserChatMessage::tableName());
     $this->createTable(UserChatMessage::tableName(), ['id' => $this->primaryKey(), 'author' => $this->string(16)->notNull(), 'gravatar' => $this->string(255)->notNull(), 'text' => $this->string(255)->notNull(), 'ts' => $this->timestamp()->notNull()->defaultValue('CURRENT_TIMESTAMP')]);
     return true;
 }