Infraction [extension]

[eunaumtenhoid]

Could someone please update this extension to the current phpbb, 3.3.14? and perhaps advance its development.
https://github.com/rfdy/infractions

EDIT
she gets this error when installing, Where can I find the extensions SQL so I can edit and correct this part?

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank tinyint(4) DEFAULT '0' NOT NULL, point_level mediumint(8) UNSIGNED DEFA' at line 5 [1064]

SQL

CREATE TABLE phpbb_infr_user_rules ( id mediumint(8) UNSIGNED NOT NULL auto_increment, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, rank tinyint(4) DEFAULT '0' NOT NULL, point_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (id) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

[Anișor]

https://github.com/rfdy/infractions/blo ... _0_0_1.php

[danieltj]

https://github.com/rfdy/infractions/blo ... _0_0_1.php

That extension is made for 3.1 and based on the OP, doesn’t work. Please add context in future rather than just pasting a link without any explanation.

[Anișor]

https://github.com/rfdy/infractions/blo ... _0_0_1.php

That extension is made for 3.1 and based on the OP, doesn’t work. Please add context in future rather than just pasting a link without any explanation.

EDIT
she gets this error when installing, Where can I find the extensions SQL so I can edit and correct this part?

I guess It was straightforward.
Although I doubt they ever looked into the files to make it at least compatible with the latest version. Should've recommended to do the workaround instead.

Try replacing infractions/config/services.yml with:

Code: Select all

imports:
    - { resource: parameters.yml }

services:
    infractions.listener:
        class: rfd\infractions\Event\main_listener
        arguments:
            - '@auth'
            - '%core.root_path%'
            - '%core.php_ext%'
            - '@user'
        tags:
            - { name: event.listener }

    infractions.infraction_manager:
        class: rfd\infractions\Service\InfractionManager
        arguments:
            - '@dbal.conn.driver'
            - { infractions: %tables.infractions%, rules: %tables.infraction_rules% }

    infractions.rules_manager:
        class: rfd\infractions\Service\InfractionRulesManager
        arguments:
            - '@dbal.conn.driver'
            - { rules: %tables.infraction_rules% }

    infractions.user_infractions_manager:
        class: rfd\infractions\Service\UserInfractionsManager
        arguments:
            - '@infractions.rules_manager'
            - '@dbal.conn.driver'
            - { inf_users: %tables.infractions_users%, group_applied: %tables.groups_applied% }

    cron.task.core.prune_infractions:
        class: rfd\infractions\cron\task\core\prune_infractions
        arguments:
            - '@infractions.user_infractions_manager'
            - '@request'
            - '@config'
            - '@dbal.conn.driver'
        calls:
            - [set_name, [cron.task.core.prune_infractions]]
        tags:
            - { name: cron.task }

And infraction/config/parameters.yml with:

Code: Select all

parameters:
    tables.infractions: '%core.table_prefix%infractions'
    tables.infraction_rules: '%core.table_prefix%infraction_rules'
    tables.infractions_users: '%core.table_prefix%infractions_users'
    tables.groups_applied: '%core.table_prefix%infr_user_rules'

[eunaumtenhoid]

tks for help

but the error continues

Code: Select all

SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank tinyint(4) DEFAULT '0' NOT NULL, point_level mediumint(8) UNSIGNED DEFA' at line 5 [1064]

SQL

CREATE TABLE phpbb_infr_user_rules ( id mediumint(8) UNSIGNED NOT NULL auto_increment, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, rank tinyint(4) DEFAULT '0' NOT NULL, point_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (id) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

[Paul]

To receive extension support please visit our Extensions Database and post in the specific extension's designated support area. The link to the support area for each released extension is also available in the first post of each released extension listed in the [3.3.x] Extension Database Releases forum. For extensions still in development (not recommended for a live board) support is in that extension's topic in the Extensions in Development forum.