Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create User function can't run properly. #14

Open
1itt1eB0y opened this issue Mar 21, 2024 · 0 comments
Open

Create User function can't run properly. #14

1itt1eB0y opened this issue Mar 21, 2024 · 0 comments

Comments

@1itt1eB0y
Copy link

1itt1eB0y commented Mar 21, 2024

when you create a new user (cmd or web either), it will only add record in oddslingers_user table. with docker-compose.yml and default config.
I manually added root to the stats table。
here is the POC

DO
$$
DECLARE
    _table_name text;
    _column_name text;
    _uuid text := 'b43794a3-d81b-42fa-90a7-791e5e7ad864';
    _query text;
    _result int;
BEGIN
    FOR _table_name, _column_name IN (SELECT table_name, column_name FROM information_schema.columns WHERE table_schema = 'public' AND data_type = 'uuid')
    LOOP
        _query := format('SELECT COUNT(*) FROM %I WHERE %I = %L', _table_name, _column_name, _uuid);
        EXECUTE _query INTO _result;
        IF _result > 0 THEN
            RAISE NOTICE 'Table % contains the UUID', _table_name;
        END IF;
    END LOOP;
END
$$

图片

web error screenshots
图片
图片
图片
图片

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant