[BETA] Advanced Points System v.0.9.2

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
neo4u
Registered User
Posts: 162
Joined: Sun May 25, 2008 2:25 pm

Re: [BETA] Advanced Points System v.0.8.2

Post by neo4u » Fri Apr 03, 2009 4:09 pm

Update: I discovered that since im using the prosilver SE style.

That if you are applying the theme edits, in the style xml file it says to open the:
Open: styles/prosilver/theme/buttons.css
Find
Tip: This may be a partial find and not the whole line.

Code:Select All
.sitehome

Add after
Tip: Add these lines on a new blank line after the preceding line(s) to find.

Code:Select All
.icon-points,
Well If you add the "," after icon-points it causes the problem described above

XLitte
Registered User
Posts: 137
Joined: Sat Jun 21, 2008 4:54 pm

Re: [BETA] Advanced Points System v.0.8.2

Post by XLitte » Sat Apr 04, 2009 4:37 pm

I install this mod with AutoMod and it work fine, just had to make some little fix. But when I go to my website I get this error...
General Error
SQL ERROR [ mysql4 ]

Unknown column 'points' in 'field list' [1054]

SQL

SELECT user_id, username, user_colour, points FROM phpbb_users WHERE points > 0 ORDER BY points DESC, username_clean ASC LIMIT 18446744073709551615

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: index.php
LINE: 183
CALL: dbal->sql_query_limit()
Also at the end of the install.xml it says...
Run points_install/install.php to update databases and add auth's.
Remove points_install directoty after installation.
What does that mean?

Also I can use my ACP but no the page.

One more thing I cant find this line in overall_header...

Code: Select all

<a href="{U_FAQ}"><img src="{T_THEME_PATH}/images/icon_mini_faq.gif" width="12" height="13" alt="*" /> {L_FAQ}</a>
I am using this style...

http://www.phpbb.com/community/viewtopi ... 5&t=592814

Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Advanced Points System v.0.8.2

Post by Adrian1 » Sat Apr 04, 2009 5:12 pm

Use search.
RPG MOD for phpbb3

Windsor
Registered User
Posts: 84
Joined: Sat Aug 23, 2008 2:59 pm

Re: [BETA] Advanced Points System v.0.8.2

Post by Windsor » Sun Apr 05, 2009 6:08 pm

Great mod. Took me a while to figure how to make it work but its working fine now

User avatar
daGrevis
Registered User
Posts: 146
Joined: Sat Jan 10, 2009 7:41 am
Location: Latvia

Re: [BETA] Advanced Points System v.0.8.2

Post by daGrevis » Tue Apr 07, 2009 9:52 pm

Recommendation: If U want to get support faster and U want to be sure, that someone help U, then ask it in official APS web!
Here it is - phpBB Gods! :geek: :geek: :geek:
P.S. If Adrians forgot to say (I dont know), then new version of APS is available for donors in phpBB Gods... ;)

User avatar
TraXy
Registered User
Posts: 41
Joined: Sat Feb 12, 2005 11:46 pm
Location: Nottingham
Contact:

Re: [BETA] Advanced Points System v.0.8.2

Post by TraXy » Wed Apr 08, 2009 11:09 pm

I thought it might be a thing I missed in translation (I was translating the mod files into Swedish, as it's meant to run on a Swedish-forum - let me know where I can send the files if you want them! :)), but it's the same in English. If I go to the bank page on my points ucp, it says the following rather than the descriptions it should have:

{ ACTIONS }
{ DEPOSIT } { WITHDRAW } (buttons)
{ USER_BALANCE }
{ TOTAL_ACCS }

There are TOTAL_ACCOUNTS, BANK_ACTIONS, BUTTON_WITHDRAW, BUTTON_DEPOSIT and HOLDING specified in points.php but they don't seem to be properly connected with the actual output on the page. I can mod forums by following instructions but I don't code php, so I don't know quite how to solve this on my own, unfortunately.

Other than that, I had no problems installing it and am having tremendous fun playing with this mod! It's way better than the CashMod I used in phpBB2 - here there's both a lottery and a bank! Awesome! :D I also saw somewhere that this mod also has an associated shop mod, but I can't seem to find it?

User avatar
milkboy31
Registered User
Posts: 422
Joined: Tue Aug 09, 2005 2:44 pm

Re: [BETA] Advanced Points System v.0.8.2

Post by milkboy31 » Thu Apr 09, 2009 2:32 pm

Can someone please confirm or deny the following features of this mod?

- Admins can edit points of users
- Donations between members are possible without admin interaction
- Point amounts show up in memberlist/profiles/posts
- Point amounts are set for events by admins (per post, per word, per character, etc...)
- Point awards can be disabled for certain forums (spam or testing forums shouldn't be paid)

Thanks!

Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Advanced Points System v.0.8.2

Post by Adrian1 » Thu Apr 09, 2009 5:30 pm

Yes it have this future
RPG MOD for phpbb3

tomy91
Registered User
Posts: 41
Joined: Wed Apr 16, 2008 11:13 am

Re: [BETA] Advanced Points System v.0.8.2

Post by tomy91 » Thu Apr 09, 2009 10:25 pm

YES! This mod could be the right thing that I nedd if you get it working with thank post mod. Propably will donate if you get it right!

My strategy. This mod + hide mod. User posts some link or other valuable information and hides it with hide mod, and other users can get the hidden content by paying some points. Example: User donates 1$ to the board and gets 100 points, to view the hidden content user has to pay 10 points and they goes to the author of topic so he can get some other content.

Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Advanced Points System v.0.8.2

Post by Adrian1 » Fri Apr 10, 2009 11:18 am

Give me more info by pm.
RPG MOD for phpbb3

User avatar
milkboy31
Registered User
Posts: 422
Joined: Tue Aug 09, 2005 2:44 pm

Re: [BETA] Advanced Points System v.0.8.2

Post by milkboy31 » Sat Apr 11, 2009 3:25 pm

Adrian1 wrote:Yes it have this future
I'm sorry... does this mean it DOES CURRENTLY have these features, or that it WILL have these features in the future?

If it doesn't currently have all of them, can you tell me which it does and doesn't?

Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Advanced Points System v.0.8.2

Post by Adrian1 » Sat Apr 11, 2009 5:29 pm

milkboy31 wrote:
Adrian1 wrote:Yes it have this future
I'm sorry... does this mean it DOES CURRENTLY have these features, or that it WILL have these features in the future?

If it doesn't currently have all of them, can you tell me which it does and doesn't?
It have this in the current version.
RPG MOD for phpbb3

Adrian1
Registered User
Posts: 630
Joined: Tue Jul 15, 2008 11:21 am
Contact:

Re: [BETA] Advanced Points System v.0.9.0

Post by Adrian1 » Sat Apr 11, 2009 5:32 pm

New version released 0.9.0

Change from 0.8.2:
[Fixing] Fixied many language bug.
[Fixing] Fixing language bug in subsilver2
[Fixing] Fixing template style subsilver2, thanks to allen
[Fixing] Some display problem
[Improvet] Many code improvet
[Adding] A robbery system.
[Adding] A points statistics on main page
[Adding] Many new change in ACP.

Download: http://www.phpbbgods.org/community/view ... f=28&t=186
RPG MOD for phpbb3

User avatar
milkboy31
Registered User
Posts: 422
Joined: Tue Aug 09, 2005 2:44 pm

Re: [BETA] Advanced Points System v.0.9.0

Post by milkboy31 » Sat Apr 11, 2009 9:54 pm

Good timing Adrian! I'll install this soon and test it out on ProSilver SE and GuildWarsAlliance (SubSilver based).

User avatar
milkboy31
Registered User
Posts: 422
Joined: Tue Aug 09, 2005 2:44 pm

Re: [BETA] Advanced Points System v.0.9.0

Post by milkboy31 » Mon Apr 13, 2009 2:42 pm

There are some major issues with the install.xml file... the "Memberlist.php" section is missing almost all the <edit> and </edit> tags which cause them to not show up in a browser. You may want to fix that. ;-)

Here is the updated code:

Code: Select all

<open src="memberlist.php ">
					<edit>
						<find><![CDATA[			$age = (int) ($now['year'] - $bday_year - $diff);
		}
	}
]]></find>
						<action type="after-add"><![CDATA[	//--[Points Modification]--
	//-----------------Get config from Database-----------------
	global $db;
	$sql = 'SELECT * FROM ' . POINTS_CONFIG_TABLE;
	$result = $db->sql_query($sql);
	$Points = $db->sql_fetchrow($result);
	$db->sql_freeresult($result);
	$Locked = false;
	//--------------------------------------------------------------------
	if ($Points['points_enable']) {
		$UA = new auth();
		$UA->acl($data);
		$Locked = $UA->acl_get('u_use_points');
	}
	if ($config['bank_enabled']) {
		$UA = new auth();
		$UA->acl($data);
		$BLocked = $UA->acl_get('u_use_bank');
	}
      // Bank Code
      if ( empty($holding['user_id']) )
      {
	$sql = "SELECT holding
		FROM " . BANK_TABLE . "
		WHERE user_id = '{$data['user_id']}'";
	$result = $db->sql_query($sql);
	$bank_row = $db->sql_fetchrow($result);

	$bank_row['holding'] = ( empty($bank_row['holding']) ) ? '0' : $bank_row['holding'];
      }
	//--[Points Modification]--
]]></action>
</edit>
<edit>
						<find><![CDATA[		'USER_JABBER'		=> $data['user_jabber'],
		'USER_JABBER_IMG'	=> ($data['user_jabber']) ? $user->img('icon_contact_jabber', $data['user_jabber']) : '',

		'L_VIEWING_PROFILE'	=> sprintf($user->lang['VIEWING_PROFILE'], $username),
]]></find>
						<action type="after-add"><![CDATA[		//--[Points Modification]--
		'U_POINTS1'		=>	$data['points'],
		'U_ID'			=>	$data['user_id'],
		'P_NAME'		=>	$Points['points_name'],
		'U_LOCKED'		=>	!$Locked,
		'U_BLOCKED'		=>	!$BLocked,
		'USE_POINTS'	=>	$Points['points_enable'],
		'USE_IMAGES_POINTS' => $Points['points_images_memberlist'],
		'USE_BANK'	=>	$config['bank_enabled'],
      	'BANK_GOLD' => $bank_row['holding'],
		//--[Points Modification]--
]]></action>
</edit>
<edit>
<find><![CDATA['U_REMOVE_FOE'		=> ($foe) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=zebra&remove=1&mode=foes&usernames[]=' . $user_id) : '',]]></find>
						<action type="after-add"><![CDATA[		//--[Points Modification]--
	            'L_MOD_USER_POINTS'	=> ($auth->acl_get('a_') || $auth->acl_get('m_chg_points')) ? sprintf($user->lang['MODIFY_POINTS']) : '',
			'U_POINTS_MODIFY'	=> ($auth->acl_get('a_') || $auth->acl_get('m_chg_points')) ? append_sid("{$phpbb_root_path}edit_points.$phpEx", "user_id=".$user_id."&adm_points=1")  : '',
			'L_MOD_USER_BANK'	=> ($auth->acl_get('a_') || $auth->acl_get('m_chg_bank')) ? sprintf($user->lang['MODIFY_POINTS']) : '',
			'U_BANK_MODIFY'	=> ($auth->acl_get('a_') || $auth->acl_get('m_chg_bank')) ? append_sid("{$phpbb_root_path}edit_bank.$phpEx", "user_id=".$user_id."&adm_points=1")  : '',
		      'U_POINTS_DONATE'	=> ($auth->acl_get('u_use_points')) ? append_sid("{$phpbb_root_path}points.$phpEx", "mode=transfer&i=".$user_id) : '',
		      'L_DONATE'			=> ($auth->acl_get('u_use_points')) ? sprintf($user->lang['DONATE']) : '',		
		//--[Points Modification]--
]]></action>
</edit>
<edit>
<find><![CDATA[$user->setup(array('memberlist', 'groups'));]]></find>
<inline-edit>
<inline-find><![CDATA[ 'groups']]></inline-find>
<inline-action type="after-add"><![CDATA[, 'mods/points']]></inline-action>
</inline-edit>
</edit>
				</open>
Edit: Also a couple of typos... the SubSilver2.xml file is named SubSilber2.xml and the ACP interface for points system settings says "usep" and some point instead of "user".

Locked

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