[ABD] Ultimate Points

[mrgoldy]

Ultimate Points
Author: dmzx & posey
Version: 1.1.1



Requirements:

• PHP >= 5.3.3
• phpBB >= 3.1.0

3.0 MOD Authors:
This is a port of the 3.0 MOD: Ultimate Points, written by: femu & Wuerzi

Features:

• Points System
  • Receive points per new topic/post or edit (Able to set per forum)
  • Receive points per words/characters in the post
  • Receive points for attachments/polls
  • Receive points for registering
  • Lose points per warning
  • Pay points per attachment download (Able to set per forum)
  • Pay points per topic (Able to set per forum)
  • Pay points per post (Able to set per forum)
  • Users can Transfer points to other users
  • Users pay a Transfer Fee
  • Receive random Bonus Points
  • Complete list of users and their points
  • UCP Configurable
• Bank
  • Personal Bank Name
  • Interest Rate
  • Interest Pay-out time
  • Withdrawal fee
  • Banking fee
• Lottery
  • Personal Lottery Name
  • Multiple Tickets
  • Jackpot Win Rate and base amount
  • Private Message to the Winner
  • Complete history of previous lottery results!
• Robbery
  • Users can rob other users
  • Can set chance success of a robbery
  • Notifications sent to the person who got robbed
  • Penalty on a failed robbery
• User Guide
  • Detailed explanation on how everything works, so make sure to check for the most common questions and their respective answers!

GitHub Repository: Repository
Installation:

1. Download the latest release: GitHub Direct Download
2. Create a new folder in the /ext/ directory, named: dmzx (If it doesn't exist already)
3. Create a new folder in /ext/dmzx/ named ultimatepoints
4. Copy the contents from the Ultimate-Points-Extension-master folder from your download into /ext/dmzx/ultimatepoints/
5. The main extension class should now be at: root/ext/dmzx/ultimatepoints/composer.json
6. Nagivate in the Administration Control Panel (ACP) to Customise -> Manage Extensions
7. Look for Ultimate Points in the Disabled Extensions list and click Enable!

Changelog:

• v1.0.0 (Initial Release)
• v.1.1.0 (BETA Release)
• v.1.1.1

Screenshots:

[mrgoldy]

[ CHANGELOG ]

<!-- BEGIN (1.0.0) to (1.1.0) -->
[ADDED]

• Log Entries
  • Robbery
  • Bank Balance Edit
  • User Points Edit
  • Bank Interest Pay Out
• Notifications
  • Bank Edit
  • Bank Interest Pay Out
  • Random Bonus Points
• Random Bonus Points
• Forum Cost Attachment
  • Show cost in-line with attachment
• Forum Cost Topic
• Forum Cost Post
• Permissions
  • Now in seperate 'Ultimate Points' tab
  • Pay for new Topic
  • Pay for new Post

[CHANGED]

• Notification ID moved from points_values table to config

[REMOVED]

• values table: robbery_notify_id

[/size]<!-- END -->

<!-- BEGIN (1.1.0) to (1.1.1) -->
[ADDED]

• Transfer Fee (percentage of total amount)
• Modify Points expanded (set, add, substract)
• Points List (Lists all users with their respective points)
• UCP Panel

[/size]<!-- END -->

[DevMakoto]

subscribe topic :3

[Fast_Eddie]

This is looking pretty cool! Looking at it now on a test board. Is there a way to limit access to different functions of the board? (let's say for example PM's)

You need XXX Points to access this function

All I can find so far is charging points to d/l attachments. But overall this is looking awesome !

[LordOfFlies]

Hi,
ext it working fine, but when I try to download a file i get this error:

SQL ERROR [ mysqli ]

Unknown column 'f.forum_cost' in 'field list' [1054]

SQL

SELECT f.forum_cost FROM (phpbb_forums_watch f) LEFT JOIN phpbb_topics t ON (t.forum_id = f.forum_id) WHERE t.topic_id = 384

Will check phpmyadmin if ext created forum_cost column propertly. Setting forum cost in acp works fine.

[SalazarAG]

posey, you are the man! I am your fan

You work in the extensions I love most. Congratulations!

Already tested on localhost and it works fine! I will subscribe to the topic.

[mrgoldy]

Hi,
SELECT f.forum_cost FROM (phpbb_forums_watch f) LEFT JOIN phpbb_topics t ON (t.forum_id = f.forum_id) WHERE t.topic_id = 384

You are completely correct, sorry about that! I've already adjusted it on GitHub but Line #488 in /event/listener/ should be FORUMS_TABLE and not FORUMS_WATCH_TABLE.

Thanks for letting us know.

[SalazarAG]

Hello posey, got this error when I make a donation to another user:

Code: Select all

Erro Geral
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(point_send, point_recv, point_amount, point_sendold, point_recvold, point_comme' at line 1 [1064]

SQL

INSERT INTO (point_send, point_recv, point_amount, point_sendold, point_recvold, point_comment, point_type, point_date) VALUES (2, 63, 33333, '112586.00', '37000.00', 'dksdkjskdsdsd', '1', 1448842197)

BACKTRACE

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

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

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
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]/ext/dmzx/ultimatepoints/core/points_transfer.php
LINE: 179
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/ultimatepoints/controller/main.php
LINE: 270
CALL: dmzx\ultimatepoints\core\points_transfer->main()

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\ultimatepoints\controller\main->handle_ultimatepoints()

FILE: [ROOT]/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php
LINE: 117
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php
LINE: 61
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 33
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

[mrgoldy]

Thanks once again for helping us find these small errors.
On Line #85 of /core/points_transfer.php it should say $this->points_log_table instead of bank .

GitHub has been updated.
Keep the tests coming

[SalazarAG]

Thank you updated.

But when you give up the points and writes a message to the user, the MP nothing appears, neither the title nor the amount of donated points and not the message.

[mrgoldy]

Thank you updated.

But when you give up the points and writes a message to the user, the MP nothing appears, neither the title nor the amount of donated points and not the message.

If you mean by MP, the Moderator Control Panel, then that's correct. It isn't logged there. It's logged in the Points Log table - viewable through the Points Control Panel.

If this can be viewed and who can view this is set up in the ACP. Through the Extension settings and through permissions. In the ACP you can also set if the receiver of the donation gets a Private Message with the comment.

[SalazarAG]

Thank you updated.

But when you give up the points and writes a message to the user, the MP nothing appears, neither the title nor the amount of donated points and not the message.

If you mean by MP, the Moderator Control Panel, then that's correct. It isn't logged there. It's logged in the Points Log table - viewable through the Points Control Panel.

If this can be viewed and who can view this is set up in the ACP. Through the Extension settings and through permissions. In the ACP you can also set if the receiver of the donation gets a Private Message with the comment.

I expressed myself badly, sorry

I meant it did not appear the title of the private message and not its contents to the user after donation - even if set to YES in the ACP.

But I could already solve this: I created a folder / languages with the name of the default language in my forum and everything returned to normal

[LordOfFlies]

Glad to help guys. Awesome work from you.

[NinaQc]

Is there a way to override the control panel panel with the prosilver theme ?
The plugin works fine on my board but had to remove it, because the control panel page is all messed up with few sentences here and there. I use a theme i purchased on themeforest but, is there a way to make the control panel show up as the prosilver theme without affecting the rest of the site ?

[Webwatcher_eu]

Looks good...
any way to buy Points by e.g. paypal?