phpBB.de

Code: Alles auswählen

	// Dump vars into template
	$template->assign_block_vars('postrow', $postrow);

Code: Alles auswählen

	//
	// F1 WebTipp
	//
	if (!function_exists('get_formel_config'))
	{
 	   include ($phpbb_root_path . 'includes/functions_formel.'.$phpEx);
	}

	$formel_config  = get_formel_config();
	$user->setup('mods/formel');

	if ($formel_config['show_in_viewtopic'])
	{
		// Check if this user has one of the formular 1 admin permission. If this user has one or more of these permissions, he gets also moderator permissions.
		$is_admin = $auth->acl_gets('a_formel_settings', 'a_formel_drivers', 'a_formel_teams', 'a_formel_races');

    	//Is the user member of the restricted group?
		if (!function_exists('group_memberships'))
		{
			include ($phpbb_root_path . 'includes/functions_user.'.$phpEx);
		}

        $is_in_group = group_memberships($formel_config['restrict_to'], $user->data['user_id'], true);

		if ($formel_config['restrict_to'] == 0 || $is_in_group || $is_admin == 1 || $user->data['user_id'] == $formel_config['mod_id'])
		{
			$tippers_rank   = $user->lang['FORMEL_PROFILE_NORANK'];
			$tippers_points = 0;
			$race_done	  = 0;

			// Get tipp data for this user
			$sql = 'SELECT *, sum(tipp_points) as total_points, count(tipp_points) as tipps_made
				FROM ' . FORMEL_TIPPS_TABLE . '
				GROUP BY tipp_user
				ORDER BY total_points DESC';
			$result = $db->sql_query($sql);

			$rank_count = $real_rank  = 1;
			$previous_points = false;

			while ($row_f1 = $db->sql_fetchrow($result))
			{
				if ($row_f1['total_points'] != $previous_points)
				{
					$rank_count = $real_rank;
					$previous_points = $row_f1['total_points'];
				}

				if ($row_f1['tipp_user'] == $poster_id)
				{
					$tippers_points = $row_f1['total_points'];
					$race_done	  	= $row_f1['tipps_made'];
					$tippers_rank   = sprintf($user->lang['FORMEL_PROFILE_RANK'], $rank_count);
					break;
				}

				$real_rank++;
			}

			$db->sql_freeresult($result);

			// Count total races with existing results
			$sql = 'SELECT *
				FROM ' . FORMEL_RACES_TABLE . '
				WHERE race_result <> 0';
			$result = $db->sql_query($sql);

			$race_total = $db->sql_affectedrows($result);
			$db->sql_freeresult($result);

			$formel1 = array(
				'TIPPER_POINTS'		=> $tippers_points,
				'TIPPER_RANK'		=> $tippers_rank,
				'RACE_DONE'			=> sprintf($user->lang['FORMEL_PROFILE_TIPSS'], $race_done, $race_total),
				'U_FORMEL_STATS'	=> append_sid("formel.$phpEx?mode=stats"),
				'U_FORMEL_WEB_TIPP'	=> append_sid("formel.$phpEx"),
			);

			$postrow = array_merge($postrow, $formel1);
		}
	}
	//
	// END of F1 WebTipp
	//