/***************************************************************************
* google maps mod markers file
* -------------------------------------------------
*
* begin : 2007-11-06
* copyright : Š ixdude.com
* version : 2.3.2 Beta
*
***************************************************************************/

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

$mod_version = '2.3.2';

error_reporting(E_ALL ^ E_NOTICE);

define('IN_PHPBB', true);
$phpbb_root_path = './';

include( $phpbb_root_path . "extension.inc" );
include( $phpbb_root_path . "common.$phpEx" );

init_userprefs( array( ) );

function krzaczki( $txt )
{
$a = array( 'ą', 'ć', 'ę', 'ł', 'ń', 'ó', 'ś', 'Ą', 'ż', 'ˇ', 'Ć', 'Ę', 'Ł', 'Ń', 'Ó', 'Ś', 'Ź', 'Ż', '°' );
$b = array( 'ą', 'ć', 'ę', 'ł', 'ń', 'ó', 'ś', 'ź', 'ż', 'Ą', 'Ć', 'Ę', 'Ł', 'Ń', 'Ó', 'Ś', 'Ź', 'Ż', '°' );
return str_replace( $a, $b, htmlspecialchars( $txt ) );
}

$body = "\r\n\r\n";

$sql = " select user_id, username, user_from, user_lat, user_long, user_posts, user_level, user_jr,
user_avatar_type, user_avatar, user_allowavatar, '' as place_description
from " . USERS_TABLE . "
where user_lat <> 0
and user_long <> 0
and user_zoom <> 0

UNION

select rank_id,
from " . RANKS_TABLE . "

UNION

select concat( 'p', place_id ), place_name, place_location, place_lat, place_long, 0, 9, 0,
" . MAP_PLACE . ", place_icon, 1, place_description
from " . MAP_PLACES_TABLE . "
order by IF( user_level = 0, 8, user_level ) ASC, user_id ASC";

$results = $db->sql_query( $sql );

if( !$results )
{
$body .= "
" . mysql_error() . "\" />\r\n";
}

while( $row = $db->sql_fetchrow( $results ) )
{

$avatar = '';

if ( $row['user_avatar_type'] && $row['user_allowavatar'] )
{
switch( $row['user_avatar_type'] )
{
case USER_AVATAR_UPLOAD:
$avatar = ( $board_config['allow_avatar_upload'] ) ? $board_config['avatar_path'] . '/' . $row['user_avatar'] : '';
break;
case USER_AVATAR_REMOTE:
$avatar = $userdata['user_avatar'];
break;
case USER_AVATAR_GALLERY:
$avatar = ( $board_config['allow_avatar_local'] ) ?
$board_config['avatar_gallery_path'] . '/' .
$userdata['user_avatar'] : '';
break;
case MAP_PLACE:
$avatar = $row['user_avatar'];
break;
}
}

$user_color = ( ( $row['user_level'] == ADMIN ) ? $theme['fontcolor_admin'] : ( ( $row['user_level'] == MOD ) ? $theme['fontcolor_mod'] : ( ( $row['user_jr'] ) ? $theme['fontcolor_jradmin'] : '' ) ) );

if( $row['rank_id'] == 2 )
{
$user_color = '66CC00';
}

$row['user_from'] = ( $row['user_from'] ) ? $row['user_from'] : '---';
$username = krzaczki( $row['username'] );
$from = krzaczki( $row['user_from'] );
$userid = $row['user_id'];
$posts = intval( $row['user_posts'] );
$level = intval( $row['user_level'] );
$description = krzaczki( $row['place_description'] );

$body .= "\r\n";
}

$body .= "";

header("Content-type: text/xml");
echo $body;

?>