3.0.0MPAKÿüÌINFOÌüÿ# 
# This file contains Installation Informations. 
# This file does not include Installation Instructions for the normal User. 
# Please do not edit this file if you are not the Module Author. 
# 

# Module Name 
[name] 
Top Countries (IpCountryFlags)
[/name] 

# Module Directory Name 
[short_name] 
top_countries_ipcountryflags
[/short_name] 

# your name 
[author] 
Wicher 
[/author] 

# your email 
[email] 
--- 
[/email] 

# your webpage url 
[url] 
http://www.detecties.com/phpbb2018
[/url] 

# module version 
[version] 
1.0.1 
[/version] 

# required minimum Statistics Mod Version 
[stats_mod_version] 
3.0.1beta3s 
[/stats_mod_version] 

# default update time 
[update_time] 
0 
[/update_time] 

[check_update_site] 
http://www.detecties.com/phpbb2018
[/check_update_site] 

# extra info for the user 
[extra_info] 
This Module displays top xx which countries your users come from. 
Users whos flag is unknown are not counted.
This module uses IpCountryFlags from 3Di: http://www.you3d.net/ip2/index.php
[/extra_info] 
ÌÌÿINFOÿÌÌÿüÌLANGÌüÿ<?php 

// [lang_english] 
$lang['module_name'] = 'Top Countries'; 
$lang['country'] = 'Country'; 
$lang['flag'] = 'Flag';
$lang['users'] = 'Users';
$lang['Error_message'] = 'IpCountryFlags (<a href="http://www.you3d.net/ip2/index.php" target="_blank">http://www.you3d.net/ip2/index.php</a>) has not been found, please install it before using this module';
// [/lang_english] 

// [lang_dutch] 
$lang['module_name'] = 'Top Landen'; 
$lang['country'] = 'Land'; 
$lang['flag'] = 'Vlag';
$lang['users'] = 'Gebruikers';
$lang['Error_message'] = 'IpCountryFlags (<a href="http://www.you3d.net/ip2/index.php" target="_blank">http://www.you3d.net/ip2/index.php</a>) is niet gevonden, installeer cash mod eerst voor je deze module gebruikt.';
// [/lang_dutch] 

// [lang_german] 
$lang['module_name'] = 'Obere Länder'; 
$lang['country'] = 'Land'; 
$lang['flag'] = 'Markierungsfahne';
$lang['users'] = 'Benutzer';
$lang['Error_message'] = 'IpCountryFlags <a href="http://www.you3d.net/ip2/index.php" target="_blank">http://www.you3d.net/ip2/index.php</a>) ist nicht gefunden worden, es bitte anbringt, bevor man dieses Modul verwendete';
// [/lang_german] 

// [lang_italian]
$lang['module_name'] = 'Paesi Superiori'; 
$lang['country'] = 'Paese'; 
$lang['flag'] = 'Bandierina';
$lang['users'] = 'Utenti';
$lang['Error_message'] = 'IpCountryFlags (<a href="http://www.you3d.net/ip2/index.php" target="_blank">http://www.you3d.net/ip2/index.php</a>) non è stato trovato, prego lo installano prima di per mezzo di questo modulo';
// [/lang_italian]

// [lang_spanish]
$lang['module_name'] = 'Países Superiores'; 
$lang['country'] = 'País'; 
$lang['flag'] = 'Bandera';
$lang['users'] = 'Usuarios';
$lang['Error_message'] = 'IpCountryFlags (<a href="http://www.you3d.net/ip2/index.php" target="_blank">http://www.you3d.net/ip2/index.php</a>) no se ha encontrado, lo instalan por favor antes de usar este módulo';
// [/lang_spanish]


?>ÌÌÿLANGÿÌÌÿüÌMODÌüÿ<?php 
/***************************************************************************
*                            top_countries_ipcountryflags .pak
*                            --------------------
*     begin                :
*     copyright            : (C)      Wicher
*     email                : ---
*
*     $Id: top_countries_ipcountryflags .pak, 2007/01/26 15:41:00 Wicher Exp $
*          for Statistics MOD version 3.0.1beta3s and higher
****************************************************************************/
/***************************************************************************
*
*   This program is free software; you can redistribute it and/or modify
*   it under the terms of the GNU General Public License as published by
*   the Free Software Foundation; either version 2 of the License, or
*   (at your option) any later version.
*
****************************************************************************/

if ( !defined('IN_PHPBB') ) 
{ 
   die("Hacking attempt"); 
} 

// check if mod installed
$sql = "SELECT iso3661_1 FROM " . CF_ISO_TABLE ." LIMIT 1"; 
if (!$result = $db->sql_query($sql))
{
	$there=0;
}
else
{
	$there=1;
}
if ($there == 0)
{
	message_die(GENERAL_MESSAGE, $lang['Error_message']);
}

// true == use db cache 
$core->start_module(true); 

$core->set_content('bars'); 

$core->set_view('rows', $core->return_limit); 
$core->set_view('columns', 6); 

$core->define_view('set_columns', array( 
   $core->pre_defined('rank'), 
   'country' => $lang['country'], 
   'flag' => $lang['flag'],
   'users' => $lang['users'], 
   $core->pre_defined('percent'), 
   $core->pre_defined('graph')) 
); 

$content->percentage_sign = TRUE; 

$core->set_header($lang['module_name']); 

$core->assign_defined_view('align_rows', array( 
   'left', 
   'center', 
   'center', 
   'center', 
   'center', 
   'left') 
); 

$sql = "SELECT COUNT(*) as total_users 
FROM " . USERS_TABLE . " 
WHERE user_id <> " . ANONYMOUS . "
AND user_cf_iso3661_1 <> 'wo'"; 

$result = $core->sql_query($sql, 'Unable to retrieve total users data'); 
$row = $core->sql_fetchrow($result); 

$total_users = $row['total_users']; 

include('./language/lang_'.$userdata['user_lang'].'/lang_extend_ip_cf.'.$phpEx);

$sql = "SELECT DISTINCT(user_cf_iso3661_1), COUNT(user_cf_iso3661_1) AS user_count
FROM " . USERS_TABLE . " 
WHERE user_id <> " . ANONYMOUS . " 
AND user_cf_iso3661_1 <> 'wo' 
GROUP BY user_cf_iso3661_1 
ORDER BY user_count DESC 
LIMIT " . $core->return_limit; 

$result = $core->sql_query($sql, 'Unable to retrieve users language data'); 
$country_data = $core->sql_fetchrowset($result);

$data = array();
for ($i = 0; $i < $core->return_limit; $i++)
{
	if ($country_data[$i]['user_cf_iso3661_1'])
	{
		$data[] = array('country' => $lang['IP2Country'][$country_data[$i]['user_cf_iso3661_1']],
						 'flag' => '<img src="images/flags/small/'.$country_data[$i]['user_cf_iso3661_1'].'.png" width="14" height="9" alt="' . $lang['IP2Country'][$country_data[$i]['user_cf_iso3661_1']] . '" title="' . $lang['IP2Country'][$country_data[$i]['user_cf_iso3661_1']] . '" border="0" />',
						 'usercount' => $country_data[$i]['user_count']
						 );
	}
}

$content->init_math('usercount', $data[0]['usercount'], $total_users); 

$core->set_data($data); 

$core->define_view('set_rows', array( 
   '$core->pre_defined()', 
   '$core->data(\'country\')', 
   '$core->data(\'flag\')', 
   '$core->data(\'usercount\')', 
   '$core->pre_defined()', 
   '$core->pre_defined()') 
); 

$core->run_module(); 

?>ÌÌÿMODÿÌÌ