[3.2][3.3][RC] Advanced Points System

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Ideas Centre
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Points System

Post by mrgoldy »

You had not deleted the data from the Ultimate Points extension probably.
That made the migration of the Advanced Points System that is responsible for adding database table not execute.
You will first have to remove it before you will have to completely reinstall APS.

What you could try before deleting Ultimate Points, is renaming the user column in the USERS_TABLE to user_points1.
Then completely uninstall Ultimate Points.
Then completely re-install Advanced Points System.
Then run the following SQL query on your USERS_TABLE:
UPDATE phpbb_users SET user_points = user_points1;
That should transfer all Ultimate Points points to the Advanced Points System points.
Then now you can delete the user_points1 column manually from the USERS_TABLE.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Points System

Post by mrgoldy »

eunaumtenhoid wrote:
Sun Dec 08, 2019 10:08 am
look how weird, I changed a user's points and after he created a topic the points disappeared

Image
I can not reproduce this in any matter.
Perhaps the user purchases a shop item worth 2075 points, that does not show up on that specific log.

Once again, please provide a couple of steps to specifically recreate the issue..
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Points System

Post by Lona »

We have: Ultimate Points Extension v1.2.3.
It's disabled.

1. We come to: DB (phpmyadmin) ---> table "phpbb_users" on the left. Click it.
2. We go to the structure tab and choose line "user_points". Rename "user_points" ---> "user_points1".
3. We go to ACP. Choose "delete data" in the line "Ultimate Points Extension". So we can't see Advanced Points System any more in our list of extensions.
4. Open Total Commander and copy files from /AdvancedPointsSystem-master to /ext. Rename copied folder ("AdvancedPointsSystem-master" ---> "aps").
5. Now we can see Advanced Points System in our list of extensions.

But we can't see "user_points" in our DB. So when SQL query on our USERS_TABLE:

Code: Select all

UPDATE phpbb_users SET user_points = user_points1;
it says:

Code: Select all

#1054-Unknown column 'user_points' in 'field list'
We tried to restart the server (OSpanel).
We also checked folder permission.

What are we doing wrong?
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Points System

Post by Lona »

Gods! We just had to enabled it in APC! :lol:
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Points System

Post by mrgoldy »

I am glad you've managed to get it working :mrgreen: :tada:

I've also thrown together a 'quick extension' that will do these steps for you automatically.
Well, I guess not for you anymore as you already figured it out, but for possibly other users.
I will see to release it tomorrow over at the Studio.

Regards,
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Points System

Post by Lona »

mrgoldy,
Thank you so much. Success would not have been possible without Your help! :roll:
User avatar
3Di
Former Team Member
Posts: 16038
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.2][BETA] Advanced Points System

Post by 3Di »

Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Points System

Post by Lona »

3Di,
thank You, we will consider this for the future.
---------------

Now the nuance became clear. Installed phpbb 3.2.8., OSPanel. One has exts, the other doesn't. After installing aps same situation: we go to ACP --> aps --> coins --> add button and we get:

Code: Select all

Catchable fatal error: Argument 1 passed to phpbbstudio\aps\points\reasoner::fill() must be of the type array, boolean given, called in H:\OSPanel\domains\mag2\ext\phpbbstudio\aps\controller\acp_controller.php on line 452 and defined in H:\OSPanel\domains\mag2\ext\phpbbstudio\aps\points\reasoner.php on line 140
What are we doing wrong?
User avatar
eunaumtenhoid
Registered User
Posts: 998
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Points System

Post by eunaumtenhoid »

mrgoldy wrote:
Mon Dec 09, 2019 2:42 pm
eunaumtenhoid wrote:
Sun Dec 08, 2019 10:08 am
look how weird, I changed a user's points and after he created a topic the points disappeared

Image
I can not reproduce this in any matter.
Perhaps the user purchases a shop item worth 2075 points, that does not show up on that specific log.

Once again, please provide a couple of steps to specifically recreate the issue..
no no, the user did not buy any items, but I noticed that this only happens when sometimes a topic is created
only thing the user did was create a topic
done that sometimes the points are reset
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
mrgoldy
Development Team Member
Development Team Member
Posts: 1392
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][BETA] Advanced Points System

Post by mrgoldy »

Lona wrote:
Sun Dec 15, 2019 2:07 pm
3Di,
thank You, we will consider this for the future.
---------------

Now the nuance became clear. Installed phpbb 3.2.8., OSPanel. One has exts, the other doesn't. After installing aps same situation: we go to ACP --> aps --> coins --> add button and we get:

Code: Select all

Catchable fatal error: Argument 1 passed to phpbbstudio\aps\points\reasoner::fill() must be of the type array, boolean given, called in H:\OSPanel\domains\mag2\ext\phpbbstudio\aps\controller\acp_controller.php on line 452 and defined in H:\OSPanel\domains\mag2\ext\phpbbstudio\aps\points\reasoner.php on line 140
What are we doing wrong?
Nothing. This is a bug in APS when trying to add a new reason. This will be fixed in the next release.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
Lona
Registered User
Posts: 14
Joined: Mon Dec 09, 2019 2:20 am

Re: [3.2][BETA] Advanced Points System

Post by Lona »

I get it. Thank you :)
User avatar
eunaumtenhoid
Registered User
Posts: 998
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][BETA] Advanced Points System

Post by eunaumtenhoid »

Hi again? I noticed that the disappearance of the points is related to the add function, if I add the same after a while and when the user posts a topic, but if I use the function change the same does not disappear.
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
3Di
Former Team Member
Posts: 16038
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

[3.2][RC] Advanced Points System

Post by 3Di »

A new version has been released: 1.0.5-RC1
  1. Disable the extension
  2. Do NOT delete data
  3. Delete the phpbbstudio/aps folder
  4. Upload the download to phpbbstudio/aps
  5. Enable the extension
v1.0.5-RC1 on 20-12-2019

- Entered the stage features frozen.
- Fixed a bug where points were displayed on profile despite the setting
- Fixed a bug where excluded points were still receiving points
- Added an option to ignore points which do not meet certain criteria
- Added an option to determine where the Points link shows up
- Enhanced the CSS to be altered more easily for other styles
2019-12-20 22_42_26-Advanced Points System • Settings.png
2019-12-20 22_43_22-328email - Index page.png
2019-12-20 22_43_22-328email - Index page.png (9.57 KiB) Viewed 665 times
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
User avatar
eunaumtenhoid
Registered User
Posts: 998
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][RC] Advanced Points System

Post by eunaumtenhoid »

fantastic updates, thanks, would be pretty cool and it would be in the "default" PHPBB to show the name of the points before the value in the dropbox just like the profile for example, but it's just a suggestion
2019-12-20 22_43_22-328email - Index page.png
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
3Di
Former Team Member
Posts: 16038
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: [3.2][RC] Advanced Points System

Post by 3Di »

The line is consistent with phpBB already. Also, just hover over it with the mouse.


2019-12-22 17_54_06-328email - Index page.png
2019-12-22 17_54_06-328email - Index page.png (5.83 KiB) Viewed 638 times

And finally we have already said that we are at the frozen features stage, no other requests will be accepted, only bug fixes.
3Di wrote:
Fri Dec 20, 2019 6:37 pm
- Entered the stage features frozen.
Enjoy what you have.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
Looking for a specific feature or alternative option? We will rock you! 🚀
Post Reply

Return to “Extensions in Development”