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
	//

Code: Alles auswählen

        //
        // F1 WebTipp
        //
        include_once($phpbb_root_path . 'includes/functions_formel.'.$phpEx);
        $formel_config  = get_formel_config();
        $user->setup('mods/formel');

        if ( $formel_config['show_in_profile'] ) 
        {
            // 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');
            
            if ( $formel_config['restrict_to'] == 0 || get_formel_auth() || $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
        //