[MODDB] Ultimate Points 1.0.6

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Get Involved
.jXc
Registered User
Posts: 7
Joined: Wed Oct 28, 2009 6:48 pm

Re: [RC] Ultimate Points 1.0.5

Post by .jXc »

femu wrote:
.jXc wrote:I installed this mod with Automod. I did everything in DIY instructions. Tabs in ACP appeared, but when I click on them I get:

Code: Select all

SQL ERROR [ mysql4 ]

Table 'db936233.POINTS_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM (POINTS_CONFIG_TABLE c)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_points.php
LINE: 38
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_points->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
How can I fix that?
Did you run the installer?
Yes, I did. I wasn't working so I tried to install SQL manual. I still get this error.
ikkeook
Registered User
Posts: 471
Joined: Sun Feb 15, 2004 10:30 pm
Location: holland

Re: [RC] Ultimate Points 1.0.5

Post by ikkeook »

WOOOHOOO

This is such a lovely play tool ty ty ty ty

I installed it and it works so lovely

however i want to install the part
Ultimate Points Lottery Block for the Board3 Portal 1.0.4

i did install the board3 portal

board3 Portal Version: 1.0.2

where can i update to 1.0.4 ?

these updates i have in the portal

board3 Portal - Update from version 1.0.1
MOD Name: board3 Portal - Update from version 1.0.0
MOD Name: board3 Portal - Update from version 1.0.0RC3
MOD Name: board3 Portal - Update from version 1.0.0RC2
MOD Name: board3 Portal - Update from version 1.0.0RC1
MOD Name: board3 Portal - Update from version 0.2.1
MOD Name: board3 Portal - Update from version 0.2.0
MOD Name: board3 Portal - Update from version 0.1.0
MOD Name: board3 Portal - Update from phpbb3portal 1.2.2
MOD Name: board3 Portal - Update from phpbb3portal 1.1.0b

as i try to install the Ultimate Points Lottery Block for the Board3 Portal 1.0.4
i get the following error

Code: Select all

File edits
portal/additional_blocks.phpCannot locate file  language/de/mods/additional_blocks.phpCannot locate file  language/en/mods/additional_blocks.phpCannot locate file  styles/prosilver/portal/additional_blocks_right.htmlCannot locate file  styles/subsilver2/portal/additional_blocks_right.htmlCannot locate file 
could some one help me out here??
Need help with your board we setup a board for you for free yest contact me
Skythron
Registered User
Posts: 2
Joined: Fri Oct 30, 2009 2:00 am

Re: [RC] Ultimate Points 1.0.5

Post by Skythron »

Disclaimer: I am a novice to mods.

Curious as to how to edit Ultimate Points to allow 3 decimal places for points instead of the default 2. I have attempted to edit the database to decimal(10,3) instead of decimal(10,2); however, when attempting changes via the acp the entry fields will round to the nearest hundredth.

Example:

Posts per character on a new topic: 0.001 entered would result in 0.000

Posts per character on a new topic: 0.016 entered would result in 0.020

Any ideas?

Thanks in advance.
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

.jXc wrote:
femu wrote:
.jXc wrote:I installed this mod with Automod. I did everything in DIY instructions. Tabs in ACP appeared, but when I click on them I get:

Code: Select all

SQL ERROR [ mysql4 ]

Table 'db936233.POINTS_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM (POINTS_CONFIG_TABLE c)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_points.php
LINE: 38
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_points->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
How can I fix that?
Did you run the installer?
Yes, I did. I wasn't working so I tried to install SQL manual. I still get this error.
Check you includes/constants.php ... There the tables are defined. If you have them there, check your DB ...
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

ikkeook wrote:WOOOHOOO

This is such a lovely play tool ty ty ty ty

I installed it and it works so lovely

however i want to install the part
Ultimate Points Lottery Block for the Board3 Portal 1.0.4

i did install the board3 portal

board3 Portal Version: 1.0.2

where can i update to 1.0.4 ?

these updates i have in the portal

board3 Portal - Update from version 1.0.1
MOD Name: board3 Portal - Update from version 1.0.0
MOD Name: board3 Portal - Update from version 1.0.0RC3
MOD Name: board3 Portal - Update from version 1.0.0RC2
MOD Name: board3 Portal - Update from version 1.0.0RC1
MOD Name: board3 Portal - Update from version 0.2.1
MOD Name: board3 Portal - Update from version 0.2.0
MOD Name: board3 Portal - Update from version 0.1.0
MOD Name: board3 Portal - Update from phpbb3portal 1.2.2
MOD Name: board3 Portal - Update from phpbb3portal 1.1.0b

as i try to install the Ultimate Points Lottery Block for the Board3 Portal 1.0.4
i get the following error

Code: Select all

File edits
portal/additional_blocks.phpCannot locate file  language/de/mods/additional_blocks.phpCannot locate file  language/en/mods/additional_blocks.phpCannot locate file  styles/prosilver/portal/additional_blocks_right.htmlCannot locate file  styles/subsilver2/portal/additional_blocks_right.htmlCannot locate file 
could some one help me out here??
Check board3.de ... There you will find the most recent version. Not sure, if there's a direct update from 1.0.2 to 1.0.4, since there were major changes from 1.0.2 to 1.0.3 ....
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

katib wrote:I am looking for the same thing:
sajeeb wrote:I want to decrease 1 point or any X-point everyday from certain group like "Subscribed" or "registered" I am able to decrease it manually but it is time consuming. Can you automate the process? Like X-points will be decreased at 12:00 AM of board time. or something like that.
Please ... As mentioned several times ... At this stage of development (we are in the process of getting this MOD into the MODDB), there will be NO addition, NO new features NOR anything else.

Sorry.
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

Dangerell wrote:Hi, again i have a question ... how can i set this mode to send emails to users that have a number of points that i set...

For example when a user reaches 1000 points i want him to receive an automatic message (PM) to let him know about that.

Any suggestions ?

Thx
Not planned yet. Sorry. See answer before for the why ;)
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

valaraukar wrote:Hi Hi!!!

First of all, I love this mod...it didn't have any problems 'til now...

When I try to rob somebody, it sends a PM to the user I tried to rob, that's ok, but this is how the PM looks like:

Image

* Sorry, it's in spanish as the forum is in spanish ^^)!

As you can see, there is a "error" in the PM

any solution?

I have been translating it, but not all the terms...and not in the proper way. I mean that I didn't like the "cash" implication, so I replaced it with the points I use (Health Pts), but i'll translate literally in next weeks...

bye bye!
Try as first step to use the original message as it's provided with the mod. If you translate it remain the structure to be the same. So we use the standard way of sending mails, which normally does not change anything in the layout.
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: [RC] Ultimate Points 1.0.5

Post by femu »

Jirik wrote:Hi, I have problem with this MOD

I can't use points - http://beztv.cz/points.php

Code: Select all

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

What's the problem?
I have already installed PHPBB SEO. I thing, problem is in mod_rewrite in .htaccess?
[sorry for my bad english :) ]
No idea .... :roll: The SEO might cause problems, but I'm not sure, as I never used that one.
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
flaps__
Registered User
Posts: 100
Joined: Wed Apr 22, 2009 9:52 pm

Re: [RC] Ultimate Points 1.0.5

Post by flaps__ »

Heya

I'm really liking the look of this mod... it will definitly come in handy for what we are looking for on our site.

I understand that this works with the Medal Mod - but just a question before I install this..

Is it possible to only allow points to be awarded when they recieve a medal? Like completely turn off awarded points for anything forum post related or anything - just purely to be awarded points when someone recieves a medal?

Thanks in advance :D
lovelysummer
Registered User
Posts: 437
Joined: Fri Mar 20, 2009 1:49 pm

Re: [RC] Ultimate Points 1.0.5

Post by lovelysummer »

Hello,

I have a suggestion. Can you add an option in Robbery Settings ? Option to enter a log to the attacked user into the points log, so that admin can choose send pm or enter log. And user can save time to view all the attack informatons instead of open the pm one by one.

Thank you.
dangioffre
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 2:49 am

Re: [RC] Ultimate Points 1.0.5

Post by dangioffre »

I need help. Im not sure what to do

Code: Select all

SQL ERROR [ mysql4 ]

Table 'gsports.POINTS_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM (POINTS_CONFIG_TABLE c)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_points.php
LINE: 38
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_points->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
User avatar
Mitch1063
Registered User
Posts: 525
Joined: Wed Jul 28, 2004 2:49 pm
Location: WWW

Re: [RC] Ultimate Points 1.0.5

Post by Mitch1063 »

dangioffre wrote:I need help. Im not sure what to do

Code: Select all

SQL ERROR [ mysql4 ]

Table 'gsports.POINTS_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM (POINTS_CONFIG_TABLE c)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_points.php
LINE: 38
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_points->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Did you do these instructions at bottom of install.xml?

Code: Select all

Finally run the database installation by calling root/install_ultimate_points.php from your web browser. Please delete this file after the successful installation. Basic settings, permissions and modules will be created during the installation. 

After you are done with the installation, please go to your ACP and check all the settings.
Hope this helps.
dangioffre
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 2:49 am

Re: [RC] Ultimate Points 1.0.5

Post by dangioffre »

Mitch1063 wrote:
dangioffre wrote:I need help. Im not sure what to do

Code: Select all

SQL ERROR [ mysql4 ]

Table 'gsports.POINTS_CONFIG_TABLE' doesn't exist [1146]

SQL

SELECT config_name, config_value FROM (POINTS_CONFIG_TABLE c)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_points.php
LINE: 38
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_points->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Did you do these instructions at bottom of install.xml?

Code: Select all

Finally run the database installation by calling root/install_ultimate_points.php from your web browser. Please delete this file after the successful installation. Basic settings, permissions and modules will be created during the installation. 

After you are done with the installation, please go to your ACP and check all the settings.
Hope this helps.
Yes I even uninstalled it and reinstalled it.
Abera
Registered User
Posts: 674
Joined: Mon Jan 15, 2007 1:26 am

Re: [RC] Ultimate Points 1.0.5

Post by Abera »

Can someone tell me what this means and maybe how to fix the problem?

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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 '' at line 1 [1064]

SQL

SELECT * FROM (phpbb_users u) WHERE user_id =

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/points/functions_points.php
LINE: 520
CALL: dbal_mysql->sql_query()

FILE: includes/points/points_lottery.php
LINE: 67
CALL: run_lottery()

FILE: includes/functions_module.php
LINE: 507
CALL: points_lottery->main()

FILE: includes/functions_module.php
LINE: 802
CALL: p_master->load_active()

FILE: points.php
LINE: 129
CALL: p_master->load()
Thanks

Return to “[3.0.x] MODs in Development”