How Can I Add New User in "group_user" Table?

hf06

I'm trying to customize the "Free Guest Login" extension. First of all, my current code is as follows;

Finteger/Guest/Api/Controllers/User.php

<?php

namespace Finteger\Guest\Api\Controllers;

use Flarum\Database\AbstractModel;
use Illuminate\Support\Facades\DB; // To use the DB class
use Flarum\User\User;

class Guest extends AbstractModel
{
    protected $table = 'users';

    public static function register(string $username): self
    {
        // Create a user instance
        $guest = new static;

        // Assign user information
        $guest->username = $username;
        $guest->password = '';
        $guest->email = '';
        $guest->is_activated = 1;
        $guest->join_time = time();

        // Save the user to the database
        $guest->save();

        // Add the user to the `group_user` table
        if ($guest->id) { // If the user ID is successfully created
            $groupId = 7; // Default group ID is set to 7
            $createdAt = now(); // Current date and time

            DB::table('group_user')->insert([
                'user_id' => $guest->id,  // The new user's ID
                'group_id' => $groupId,    // Default group ID is 7
                'created_at' => $createdAt // Current timestamp
            ]);
        }

        return $guest;
    }
}

I can't see any log records regarding the problem experienced. A new member is added to the "users" table as specified and everything works smoothly. But I cannot add it to the "group_user" table. My guess is that I'm having trouble with the user_id data, but I'm stuck at this point and can't find a solution.

clarkwinkelmann

hf06 what's the error message?

Flarum does not use Laravel facades, you might need to manually resolve the database connection object through resolve() if you want to use that method.

The most reliable solution would probably be to use the existing Eloquent model relationship, $user->groups()->attach($groupId) (not sure of the extract syntax, I think you can attach either a group model or an ID directly)

hf06

clarkwinkelmann Interestingly, there are no errors in either the server or Flarum logs. However, the Clockwork extension shows an error related to the create_date, but this issue doesn’t cause any major problems in the users table.

When a new visitor clicks the "Guest Login" button, an account is automatically created, and everything works fine.

The only problem is that a row for the "guest" group is not being added to the user_groups table for the newly created membership.

English is not my first language, and I am not familiar with Laravel. I know PHP, and I tried customizing the extension, which was already working fine, using ChatGPT Canvas.

My guess is that there’s an issue with the user_id column because the extension didn’t originally use the user_id.