A lot of things don't work the way I assume, why? #96

jakubforman · 2025-05-07T16:21:55Z

jakubforman
May 7, 2025

First of all the plugin looks fantastic, but after switching it on there are complications and I want to find out if I am doing something wrong or if it is really a bug that should be reported as an issue.

In my seeder I create Levels, this works properly, however when it comes to seed other parts, most things don't work as I would expect. I need to simulate and test data in the application, so I would expect the following:

setPoints() even if the user doesn't have XP sets them to that value, instead I have to use addPoints() so then I don't understand the reason for the existence of setPoints()
If I run a complete migration, including remove_level_id_column_from_users_table.php the level_id column is removed and the code throws an error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'level_id' in 'SET' (Connection: mariadb, SQL: update `users` set `level_id` = 10, `users`.`updated_at` = 2025-05-07 16:19:38 where `id` = 1)

Seedery popisuji níže.

Level Seeder

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use LevelUp\Experience\Models\Level;

class LevelSeeder extends Seeder
{
    public function run(): void
    {
        // Smaž staré levely – pozor na produkci!
        Level::query()->delete();

        // Vygeneruj levely (např. 1 až 99)
        $levels = [];

        // Počáteční XP pro level 1
        $xpRequired = 0;

        // Nastavíme první level s nulovými body pro další úroveň
        $levels[] = [
            'level' => 1,
            'next_level_experience' => null,
        ];

        // Vygeneruj XP pro ostatní levely podle křivky
        for ($level = 2; $level <= 99; $level++) {
            // Použijeme progresivní XP křivku s postupným zvyšováním obtížnosti
            $xpRequired = round(100 * pow($level, 1.5));

            // Počítáme XP na základě předchozí úrovně
            $levels[] = [
                'level' => $level,
                'next_level_experience' => $xpRequired,
            ];
        }

        // Přidej levely do databáze
        Level::add(...$levels);
    }
}

User seeder

<?php

namespace Database\Seeders;

use App\Models\User;
use Illuminate\Database\Seeder;

// use Illuminate\Database\Console\Seeds\WithoutModelEvents;

class UserSeeder extends Seeder
{
    /**
     * Seed the application's database.
     */
    public function run(): void
    {
        /** @var User $user */
        $user = User::factory()->create([
            'username' => 'demo_user',
            'firstname' => 'Demo',
            'lastname' => 'User',
            'email' => 'demo@example.com',
            'password' => 'example_',
        ]);
        $user->authProviders()->create([
            'provider' => 'password',
            'provider_id' => 0,
            'email' => $user->email
        ]);
        $user->setPoints(rand(100, 5000));
        /** @var User $user */
        $user = User::factory()->create([
            'username' => 'admin_user',
            'firstname' => 'Admin',
            'lastname' => 'User',
            'email' => 'admin@example.com',
            'password' => 'example_',
        ]);
        $user->authProviders()->create([
            'provider' => 'password',
            'provider_id' => 0,
            'email' => $user->email
        ]);
        $user->setPoints(rand(5000, 10000));


        // Uživatelé s neverifikovaným emailem
        User::factory(10)->unverifiedEmail()->create(); // 10 unverified

        // Verifikovaní uživatelé
        User::factory(100)->create()->each(function ($user) {
            $user->setPoints(rand(1000, 8000));
        }); // 100 verified account
    }
}

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

A lot of things don't work the way I assume, why? #96

{{title}}

Replies: 0 comments

Select a reply

A lot of things don't work the way I assume, why? #96

jakubforman May 7, 2025

Replies: 0 comments

jakubforman
May 7, 2025