Username Colour Change MOD

[BMercer]

Ok then, here is the list of the forums:

ID= 1 = Welcome
ID= 2 = Introduction
ID= 3 = Usefull things
ID= 4 = Usefull application
ID= 5 = Off topic

Ok then:

If user has
Total posts in forums (Forums ID= 1+2+3+4) > 150 ( total posts less the posts in ID= 5)
&&
Total posts in forum (Forum ID= 2) > 0 ( has said welcome to the board)
&&
Total Post in forum (Forum ID= 3) > 49 ( has posted at least 50 posts in Usefull things)

Then the user is able to change its username color.

[mtrs]

Yes, it is possible, but you need to do that on your own by custom coding to the mod. Noone asked to base it on post counts in forums.
I give basic support in this topic.
Besides, every calculation uses an sql query, it seems not worth.

[BMercer]

Mmm, ok then.
I guess i could find another solution.
Thanks.

[BMercer]

We previously talk about the posts in a certain forum. What if i'd like to count the topic only?

[mtrs]

For topic counts, you'll need run sql queries on TOPICS_TABLE

[BMercer]

For X posts limit, it is simple,
After installing this mod

Open
includes/ucp/ucp_profile.php
Find

Code: Select all

if ($auth->acl_get('u_change_colour'))

Replace with

Code: Select all

if ($auth->acl_get('u_change_colour') && $user->data['user_posts'] > 999)

For X posts limit in some forums
Open
includes/ucp/ucp_profile.php
Find

Code: Select all

if ($auth->acl_get('u_change_colour'))

Replace with

Code: Select all

	// Count users post in $X forum ID
		$X = 555; //forum_id where posts will be counted //change to an appropriate number you need
		$sql = 'SELECT COUNT(post_id) as posts_num
			FROM ' . POSTS_TABLE . '
			WHERE poster_id = ' . $user->data['user_id'] . ';
				AND forum_id = ' . $X;
		$result = $db->sql_query($sql);
		$user_posts_num = (int) $db->sql_fetchfield('posts_num');
		$db->sql_freeresult($result);
if ($auth->acl_get('u_change_colour') && $user_posts_num > 99 && $user->data['user_posts'] > 999)

Also you can use the user permissions to only allow certain users

Note: code is not tested, you need to test. Replace 99 and 999 number with your limit.

Don't we just need to replace "user_posts" or "post_num" with "user_topic" or "topic_num"?

[BMercer]

No answers?

[mtrs]

No, it is not that simple. User topics count is not stored at database, you'll have to run a query to learn topics count.

[BMercer]

Sorry, but i thought:
When you use the search.php functions and you search topic of a certain user in a certain forum isnt that the same? Anyway i dont know anything, i can just try to help you helping me.

[mtrs]

search.php runs sql queries to count them. User topic number are not stored or updated at database, unless you install a mod.
$user->data['user_posts'] exists by default, but $user->data['user_topics'] is not used at an unmodded board.

[Ephemeraboy]

it doesn't appear at UCP...??
any solution...??

[mtrs]

After installing the mod, also read DIY instructions. You should set the user permissions.

[Bobski2000]

HI,

Will you be updating this mod so it works with 3.0.6?

Ta

Dave

[mtrs]

Mod works with 3.0.6 fine, no update needed.

[Bobski2000]

Hi, im installing this mod on my new board and im up to editing the first edit includes/acp/acp_board.php.

Find:

Code: Select all

'warnings_expire_days'	=> array('lang' => 'WARNINGS_EXPIRE',		'validate' => 'int',	'type' => 'text:3:4', 'explain' => true, 'append' => ' ' . $user->lang['DAYS']),

Add After:

Code: Select all

			// Begin : Username Colour Change MOD
		//If other mods are installed you may have to change legend3 to the next available legend number
					'legend3'						=> 'USERNAME_COLOUR_CHANGE',
					'uccm_euclidean_distance'		=> array('lang' => 'SIMILAR_COLOUR_CHECK',	'validate' => 'int:0:650',	'type' => 'text:4:4', 'explain' => true),
					'uccm_disallowed_colours'		=> array('lang' => 'DISALLOWED_COLOURS',	'validate' => 'string',	'type' => 'text:25:255', 'explain' => true),
		// End : Username Colour Change MOD

But i see that i already have legend3?

Code: Select all

'legend3'					=> 'ACP_SUBMIT_CHANGES',

Any ideas please?
Will this be a problem?