[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!
Suggested Hosts
Locked
User avatar
kiddo
Registered User
Posts: 41
Joined: Tue Jan 15, 2008 2:59 pm

Re: [RC] Ultimate Points 1.0.3

Post by kiddo » Mon Aug 10, 2009 1:16 pm

NguyTieuNhan wrote:I use Update Simple Points System to UP v1.0.3
import this file sql_update_Simple_Points_to_Ultimate_Points_1.0.3.sql
Did you do all things explained in your ultimate points download
then in contrib folder --> upgrade and others folder --> install upgrades xml file?

the errors you get seem to be from not completely uninstalling your old points system correctly.

User avatar
stathisch
Registered User
Posts: 145
Joined: Fri Jul 24, 2009 11:33 am
Location: Greece
Contact:

Re: [RC] Ultimate Points 1.0.3

Post by stathisch » Tue Aug 11, 2009 12:40 am

OK, this MOD makes way too many SQL Queries.
Some changes I did to the viewtopic.php, to lessen queries. Maybe this will seem useful to someone, or you could do something like this in the next release.
This is a really quickly written version, just gets the job done.

FIND

Code: Select all

$max_post_time = 0;
ADD AFTER

Code: Select all

$sql = $db->sql_build_query('SELECT', array(
	'SELECT'	=> 'b.*',

	'FROM'		=> array(
		POINTS_BANK_TABLE		=> 'b',
		POSTS_TABLE		=> 'p',
	),

	'WHERE'		=> $db->sql_in_set('p.post_id', $post_list) . '
		AND b.user_id = p.poster_id'
));
$result = $db->sql_query($sql);
$poster_bank_data = array();
while ($row = $db->sql_fetchrow($result))
{
	$poster_bank_data[$row['user_id']] = $row;
}
$db->sql_freeresult($result);
FIND

Code: Select all

// Check if user has a bank account
		$sql1 = "SELECT *
			FROM " . POINTS_BANK_TABLE . "
			WHERE user_id = '{$poster_id}'";
		$result1 = $db->sql_query($sql1);
		$check_row = $db->sql_fetchrow($result1);*/
		/*$check_row = $poster_bank_data[$poster_id];

		if ( !isset($check_row['holding']) && $poster_id > 0 )
		{
			$has_account = false;
		}
REPLACE WITH

Code: Select all

$has_account = ( isset($poster_bank_data[$poster_id]) && $poster_id > 0 ) ? true : false;
FIND

Code: Select all

$sql = "SELECT holding
			FROM " . POINTS_BANK_TABLE . "
			WHERE user_id = '$poster_id'";
		$result = $db->sql_query($sql);
		$bank_row = $db->sql_fetchrow($result);
		$holding[$poster_id] = ( $bank_row['holding'] ) ? $bank_row['holding'] : '0';
		$bank_row = '';
REPLACE WITH

Code: Select all

$holding[$poster_id] = ( isset($poster_bank_data[$poster_id]) ) ? $poster_bank_data[$poster_id]['holding'] : '0';

habboblob
Registered User
Posts: 10
Joined: Mon Aug 10, 2009 10:38 am

Re: [RC] Ultimate Points 1.0.3

Post by habboblob » Tue Aug 11, 2009 7:08 am

thanks for this.

User avatar
woipi90
Registered User
Posts: 908
Joined: Mon Feb 16, 2009 5:32 pm
Location: Austria

Re: [RC] Ultimate Points 1.0.3

Post by woipi90 » Tue Aug 11, 2009 4:02 pm

i await a new release with the optimizations included.... do you have a release date?


grz woipi
My mods: Ultimate Board Clubs
Support: only for the UBCS!
-----
function be_friends($uid, $u){return ($u == $user->['user_id']) ? false : true;}
$this->be_friends($uid, $user->['user_id']) ? $allow_pm : echo "You failed again";

User avatar
Wuerzi
Registered User
Posts: 60
Joined: Fri Aug 15, 2008 11:38 pm
Location: Germany/Würzburg
Contact:

Re: [RC] Ultimate Points 1.0.3

Post by Wuerzi » Tue Aug 11, 2009 5:54 pm

woipi90 wrote:i await a new release with the optimizations included.... do you have a release date?

grz woipi
Hello Woipi,

perhaps at Saturday :?

Longhorn9024
Registered User
Posts: 44
Joined: Tue Oct 07, 2008 8:37 pm

Re: [RC] Ultimate Points 1.0.3

Post by Longhorn9024 » Tue Aug 11, 2009 5:59 pm

How can I make it to where people get a specified amount of points per post?

User avatar
oxfordsi
Registered User
Posts: 266
Joined: Sun Jan 06, 2008 10:06 pm
Location: Witney, Oxfordshire, UK

Re: [RC] Ultimate Points 1.0.3

Post by oxfordsi » Tue Aug 11, 2009 6:04 pm

Longhorn9024 wrote:How can I make it to where people get a specified amount of points per post?
ACP >> .MODS (or where you put the points module within the ACP) >> Point Settings (under ULTIMATE POINTS HEADING).

You should see numerous number entry boxes where you can adjust the amount of points users recieve for posts etc

User avatar
woipi90
Registered User
Posts: 908
Joined: Mon Feb 16, 2009 5:32 pm
Location: Austria

Re: [RC] Ultimate Points 1.0.3

Post by woipi90 » Tue Aug 11, 2009 6:14 pm

Wuerzi wrote:
woipi90 wrote:i await a new release with the optimizations included.... do you have a release date?

grz woipi
Hello Woipi,

perhaps at Saturday :?
very good news.... ;) i hope then you will manage to get this mod supplied to the moddb....


grz woipi
My mods: Ultimate Board Clubs
Support: only for the UBCS!
-----
function be_friends($uid, $u){return ($u == $user->['user_id']) ? false : true;}
$this->be_friends($uid, $user->['user_id']) ? $allow_pm : echo "You failed again";

User avatar
codfather
Registered User
Posts: 268
Joined: Tue Aug 11, 2009 7:25 pm
Location: Scotland UK

Re: [RC] Ultimate Points 1.0.3

Post by codfather » Tue Aug 11, 2009 7:32 pm

I have installed this mod to my forum today. It works fine in the posting part, but on the arcade no points are given.
What am I missing ?
It is set to 100.00 and shows that for games, it is enabled. Global Jackpot turned off.

The Codfather.

Longhorn9024
Registered User
Posts: 44
Joined: Tue Oct 07, 2008 8:37 pm

Re: [RC] Ultimate Points 1.0.3

Post by Longhorn9024 » Tue Aug 11, 2009 8:02 pm

ACP >> .MODS (or where you put the points module within the ACP) >> Point Settings (under ULTIMATE POINTS HEADING).

You should see numerous number entry boxes where you can adjust the amount of points users recieve for posts etc
I see points per word and character but not per post. Should points per post be there?

User avatar
Ashley.S.
Registered User
Posts: 468
Joined: Mon Aug 04, 2008 6:01 pm
Location: Falmouth, Cornwall, UK
Name: Ashley .S.
Contact:

Re: [RC] Ultimate Points 1.0.3

Post by Ashley.S. » Tue Aug 11, 2009 8:27 pm

Longhorn9024 wrote:
ACP >> .MODS (or where you put the points module within the ACP) >> Point Settings (under ULTIMATE POINTS HEADING).

You should see numerous number entry boxes where you can adjust the amount of points users recieve for posts etc
I see points per word and character but not per post. Should points per post be there?
look under your forum settings for each forum when you create/edit them, it asks for points per post, topic & edit there

hope that helps
Last edited by Ashley.S. on Tue Aug 11, 2009 11:03 pm, edited 1 time in total.
Regards,
-Ashley.S. [ ProphpBB Free Forum Hosting Moderator ]

User avatar
oxfordsi
Registered User
Posts: 266
Joined: Sun Jan 06, 2008 10:06 pm
Location: Witney, Oxfordshire, UK

Re: [RC] Ultimate Points 1.0.3

Post by oxfordsi » Tue Aug 11, 2009 9:48 pm

Ashley.S. wrote:
Longhorn9024 wrote:
ACP >> .MODS (or where you put the points module within the ACP) >> Point Settings (under ULTIMATE POINTS HEADING).

You should see numerous number entry boxes where you can adjust the amount of points users recieve for posts etc
I see points per word and character but not per post. Should points per post be there?
look under your forum settings for each forum when you create/edit them, it asks for posts per post, topic & edit there

hope that helps
I found there to be no option for points per post. Instead it's points per word within a post. points per post isn't included within the MOD, points per word is!

Longhorn9024
Registered User
Posts: 44
Joined: Tue Oct 07, 2008 8:37 pm

Re: [RC] Ultimate Points 1.0.3

Post by Longhorn9024 » Tue Aug 11, 2009 10:50 pm

Ashley is right! I found it, it is just not in the .MOD section.

Thanks!

Longhorn9024
Registered User
Posts: 44
Joined: Tue Oct 07, 2008 8:37 pm

Re: [RC] Ultimate Points 1.0.3

Post by Longhorn9024 » Wed Aug 12, 2009 12:55 am

Does anyone know of anybody who is making a shop mod for ultimate points besides the Shop Mod by Adrian? I am looking for a simpler version with just items added by the admin.

If not I will request one in the Mod Request forum.

sotis
Registered User
Posts: 294
Joined: Tue Oct 17, 2006 4:56 pm
Location: Bulgaria
Contact:

Re: [RC] Ultimate Points 1.0.3

Post by sotis » Wed Aug 12, 2009 5:11 am

NathanFtw wrote:
sotis wrote:I want to exclude some forum for not giving points in it at all. Can you add this feature to the mod.
Along with the global point settings of the mod, there is also a forum based point settings, just go into the forum edit it and you'll see the options there, if not value is entered there the global will be used.
I know, but I don't want any points at all in some forums, global and forum based.

Locked

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