phpBB.de

Code: Alles auswählen

/**
* Substract points from user, but only if points are positive
*/
function substract_points_condition($user_id, $amount)
{
	global $db, $user;

		// Select users current points
		$sql_array = array(
			'SELECT'    => 'user_points',
			'FROM'      => array(
				USERS_TABLE => 'u',
			),
			'WHERE'		=> 'user_id = ' . (int) $user_id,
		);
		$sql = $db->sql_build_query('SELECT', $sql_array);
		$result = $db->sql_query($sql);
		$user_points = $db->sql_fetchfield('user_points');
		$db->sql_freeresult($result);

		if ( ($user_points - $amount) <= 0 )
		{
			return false;
		}
		else
		{
			// Update the points
			$data = array(
				'user_points'	=> $user_points - $amount,
			);
		
			$sql = 'UPDATE ' . USERS_TABLE . '
				SET ' . $db->sql_build_array('UPDATE', $data) . '
				WHERE user_id = ' . (int) $user_id;
			$db->sql_query($sql);
		}
	return;
}

Code: Alles auswählen

// Start Ultimate Points
		'P_NAME'			=> $config['points_name'],
		'U_LOCKED'			=> !$locked,
		'U_BLOCKED'			=> !$blocked,
		'USE_POINTS'		=> $config['points_enable'],
		'USE_IMAGES_POINTS'	=> $points_config['images_memberlist_enable'],
		'USE_BANK'			=> $points_config['bank_enable'],
		'BANK_GOLD'			=> sprintf(number_format_points($bank_row['holding'])),
		// End Ultimate Points