Extensions Database 3.2 / 3.3

Post by **riofriz** » 08 Jun 2020, 14:19

Extension Name: Better Ranks
Author: riofriz

Special thanks to: dmzx for the support and Posey for the original idea

Extension Description:

Allows users to display every group that has a rank connected to it (as long as it has a banner image) on post view, profile view and pm view. Users will also be able to manage which banners will be shown from UCP -> Profile -> Banners.
Ranks that are directly assigned to users without going through Groups first, won't be showing in the UCP and will take priority over groups (will basically show on the very top).

Extension Download:

Download-link: Better Ranks v2.0.1

Installation:

Download the latest release.
Unzip the downloaded release, and change the name of the folder to `betterranks`.
In the `ext` directory of your phpBB board, create a new directory named `vcc` (if it does not already exist).
Copy the `betterranks` folder to `/ext/vcc/` if done correctly, you'll have the main extension class at
(your forum root)/ext/vcc/betterranks/composer.json
Navigate in the ACP to `Customise -> Manage extensions`
Look for `Better Ranks` under the Disabled Extensions list, and click its `Enable` link.

Post by **riofriz** » 11 Jun 2020, 13:36

Fixed bug on pm view, if users removed every single banner it'd throw an exception.
No need to disable/delete data, just get the latest code on your server.

Changelog:

Code: Select all

https://github.com/riofriz/vcc_betterranks/commit/b0ad0987972567985a2398b835da2f8c5f6a54ff#diff-5b16f81e26748b1551589589de97e98a

Post by **SalyaDarken** » 30 Jun 2020, 02:33

Wow I been looking for something like this. Thanks. ^^

Keep up the good work!

Post by **riofriz** » 30 Jun 2020, 15:01

SalyaDarken wrote: 30 Jun 2020, 02:33 wow I been looking for something like this. Thanks. ^^

Keep up the good work!

Thanks! Glad someone else found it useful

Post by **miri4ever** » 02 Jul 2020, 22:42

Got this error if watching banners:

Code: Select all

phpbb_user_group' doesn't exist [1146]

SQL

SELECT phpbb_user_group.order, phpbb_user_group.show_banner, phpbb_user_group.group_id, phpbb_groups.group_name, phpbb_groups.group_colour, phpbb_users.user_rank, phpbb_groups.group_rank, phpbb_ranks.rank_image, phpbb_user_group.user_id FROM phpbb_user_group LEFT JOIN phpbb_users ON phpbb_users.user_id = phpbb_user_group.user_id LEFT JOIN phpbb_groups ON phpbb_user_group.group_id = phpbb_groups.group_id LEFT JOIN phpbb_ranks ON phpbb_ranks.rank_id = phpbb_groups.group_rank WHERE phpbb_groups.group_rank != 0 AND phpbb_user_group.user_id = 4 ORDER BY phpbb_user_group.order ASC

Not everyone using phpbb_ as table prefix only.

Post by **riofriz** » 02 Jul 2020, 22:46

miri4ever wrote: 02 Jul 2020, 22:42 Got this error if watching banners:

Code: Select all

phpbb_user_group' doesn't exist [1146]

SQL

SELECT phpbb_user_group.order, phpbb_user_group.show_banner, phpbb_user_group.group_id, phpbb_groups.group_name, phpbb_groups.group_colour, phpbb_users.user_rank, phpbb_groups.group_rank, phpbb_ranks.rank_image, phpbb_user_group.user_id FROM phpbb_user_group LEFT JOIN phpbb_users ON phpbb_users.user_id = phpbb_user_group.user_id LEFT JOIN phpbb_groups ON phpbb_user_group.group_id = phpbb_groups.group_id LEFT JOIN phpbb_ranks ON phpbb_ranks.rank_id = phpbb_groups.group_rank WHERE phpbb_groups.group_rank != 0 AND phpbb_user_group.user_id = 4 ORDER BY phpbb_user_group.order ASC

Not everyone using phpbb_ as table prefix only.

Will sort tomorrow, thanks for reporting it :)

Post by **riofriz** » 06 Jul 2020, 13:34

Extension updated to 2.0.1, fixed the issue reported by miri4ever, added translatable text and general performance improvements.
Thanks dmzx for the changes!

Post by **miri4ever** » 06 Jul 2020, 17:31

Banners now display fine but if I hit the checkbox at the banners and pressing submit button I got this:

Code: Select all

AJAX-FEHLER
Service Unavailable

So it seems I cant select or deselect any of the banners.

Post by **riofriz** » 06 Jul 2020, 17:57

miri4ever wrote: 06 Jul 2020, 17:31 Banners now display fine but if I hit the checkbox at the banners and pressing submit button I got this:
Code: Select all
AJAX-FEHLER
Service Unavailable
So it seems I cant select or deselect any of the banners.

Uhm, this doesn't happen to me, did you clear the cache after updating the module?
Try

Code: Select all

rm -rv cache/production/*

from the phpbb root folder

Post by **miri4ever** » 08 Jul 2020, 19:41

I try but it wont helped me. Can't turn off any of those I dont want to display. I dont know if this is a result from phpbb 3.3.0 still having a lot of problems with AJAX Buttons or if you runing an older version. Just can tell you what I saw on mine in hope it was a real bug maybe to others aswell.

Post by **spaceworld** » 02 Jan 2021, 19:46

Hello

doesn't work to me ... 3.3.2 can't see !

Post by **SalyaDarken** » 03 Jan 2021, 02:43

Update plz

Post by **dmzx** » 04 Jan 2021, 13:19

Just tested and still works for me.

What is not working for you?

Post by **spaceworld** » 04 Jan 2021, 15:03

dmzx wrote: 04 Jan 2021, 13:19 Just tested and still works for me.

What is not working for you?

Hello Thx for your reply !

It's ok now ... perfect ! I don't know what's the problem before ... Maybe the cache ! ...

Best

Post by **Kimera_V2** » 10 Sep 2021, 22:38

Error after backup restore:

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 'order) VALUES (5, 2, 1, 0, 1, 1),(4, 2, 1, 0, 1, 1),(4, 63, 0, 0, 1, 1),(2, 71, ' at line 1 [1064]

SQL

INSERT INTO phpbb_user_group (group_id, user_id, group_leader, user_pending, show_banner, order) VALUES (5, 2, 1, 0, 1, 1),(4, 2, 1, 0, 1, 1),(4, 63, 0, 0, 1, 1),(2, 71, 0, 0, 1, 1),(2, 63, 0, 0, 1, 1),(2, 2, 0, 0, 1, 1),(2, 68, 0, 0, 1, 1),(2, 69, 0, 0, 1, 1),(2, 64, 0, 0, 1, 1),(10, 2, 0, 0, 1, 1),(12, 71, 0, 0, 1, 1),(12, 2, 0, 0, 1, 1),(8, 71, 1, 0, 1, 1),(1, 1, 0, 0, 1, 1),(11, 2, 1, 0, 1, 1),(6, 3, 0, 0, 1, 1),(6, 4, 0, 0, 1, 1),(6, 5, 0, 0, 1, 1),(6, 6, 0, 0, 1, 1),(6, 7, 0, 0, 1, 1),(6, 8, 0, 0, 1, 1),(6, 9, 0, 0, 1, 1),(6, 10, 0, 0, 1, 1),(6, 11, 0, 0, 1, 1),(6, 12, 0, 0, 1, 1),(6, 13, 0, 0, 1, 1),(6, 14, 0, 0, 1, 1),(6, 15, 0, 0, 1, 1),(6, 16, 0, 0, 1, 1),(6, 17, 0, 0, 1, 1),(6, 18, 0, 0, 1, 1),(6, 19, 0, 0, 1, 1),(6, 20, 0, 0, 1, 1),(6, 21, 0, 0, 1, 1),(6, 22, 0, 0, 1, 1),(6, 23, 0, 0, 1, 1),(6, 24, 0, 0, 1, 1),(6, 25, 0, 0, 1, 1),(6, 26, 0, 0, 1, 1),(6, 27, 0, 0, 1, 1),(6, 28, 0, 0, 1, 1),(6, 29, 0, 0, 1, 1),(6, 30, 0, 0, 1, 1),(6, 31, 0, 0, 1, 1),(6, 32, 0, 0, 1, 1),(6, 33, 0, 0, 1, 1),(6, 34, 0, 0, 1, 1),(6, 35, 0, 0, 1, 1),(6, 36, 0, 0, 1, 1),(6, 37, 0, 0, 1, 1),(6, 38, 0, 0, 1, 1),(6, 39, 0, 0, 1, 1),(6, 40, 0, 0, 1, 1),(6, 41, 0, 0, 1, 1),(6, 42, 0, 0, 1, 1),(6, 43, 0, 0, 1, 1),(6, 44, 0, 0, 1, 1),(6, 45, 0, 0, 1, 1),(6, 46, 0, 0, 1, 1),(6, 47, 0, 0, 1, 1)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 994
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/acp/acp_database.php
LINE: 257
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_database->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()

3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Better Ranks

Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks

Re: Better Ranks