Board3

Code: Select all

<?php

    if (!defined('IN_PHPBB'))
    {
       exit;
    }

    if (!defined('IN_PORTAL'))
    {
       exit;
    }

        $sql = "SELECT pf_plz, pf_land
                FROM " . PROFILE_FIELDS_DATA_TABLE . "
                WHERE user_id = " . $user->data['user_id'];

        $result = $db->sql_query_limit($sql, 1);
        $row = $db->sql_fetchrow($result);
        $land = $row['pf_land'];
        $plz = $row['pf_plz'];

$template->assign_vars(array(
        'WETTER_PLZ'     => (!empty($plz) && $land > 0) ? sprintf("%0" . $land_ary[$land][1] . "d", $plz): '20099', // Ändere 20099 in die gewünschte Standard Postleizzahl
        'WETTER_LAND'  => (!empty($land)&& $land > 0) ? $land_ary[$land][0] : 'DE', //Ändere DE in das gewünschte Standard Länderkürzel
    ));

    ?>

Code: Select all

<!-- INCLUDE portal/block/wetter.html -->

Code: Select all

		<div class="signature" style="border-top:none; margin-top: 0;">{SIGNATURE}<br /></div></dd>
<!-- ENDIF -->

Code: Select all

<!-- Wettercode Start -->
		<dd><span class="corners-top"><span></span></span><h3>{USERNAME}'{L_USERWETTER}</h3><br/>
		<div class="signature" style="border-top:none; margin-top: 0;">
                      <a href="http://www.wetter.com/home/extern/ex_search.php?search={WETTE_PLZ}"><img src="http://www.wetter.com/home/woys/woys.php?,C,1,{WETTE_LAND}PLZ,{WETTE_PLZ}" alt="" /></a>
                      <a href="http://www.wetter.com/home/extern/ex_search.php?search={WETTE_PLZ}"><img src="http://www.wetter.com/home/woys/woys.php?,F,1,{WETTE_LAND}PLZ,{WETTE_PLZ}" alt="" /></a></div></dd>
 <!-- Wettercode Ende -->

Code: Select all

		// check 4 plz entry of this user - GeoMap Mod
		$sql_geomap = 'SELECT COUNT(user_id) user_count FROM ' . PROFILE_FIELDS_DATA_TABLE . '
		WHERE pf_plz != 0 AND pf_land != 0 AND user_id = ' . $user_id;
		$result_geomap = $db->sql_query($sql_geomap);
		$poster_plz = $db->sql_fetchfield('user_count');
		$db->sql_freeresult($result_geomap);

Code: Select all

        $sql = 'SELECT pf_plz, pf_land FROM ' . PROFILE_FIELDS_DATA_TABLE . '
        WHERE pf_plz != 0 AND pf_land != 0 AND user_id = ' . $user_id;
        $result = $db->sql_query($sql);
        $row = $db->sql_fetchrow($result);
        $land = $row['pf_land'];
        $plz = $row['pf_plz'];
        $land_ary = array(
                1 => array('DE', 5),
                2 => array('AT', 4),
                3 => array('CH', 4),
);

Code: Select all

			'U_GEOMAP_PROFILE' 		=> ($poster_plz ? append_sid("{$phpbb_root_path}geomap.$phpEx", 'mode=profile&u=' . $user_id) : ''),

Code: Select all

            'WETTE_PLZ'    => (!empty($plz)) ? sprintf("%0" . $land_ary[$land][1] . "d", $plz): '', 
            'WETTE_LAND'   => (!empty($land)) ? $land_ary[$land][0] : '',

Code: Select all

	'SIGNATURE'					=> 'Signatur',

Code: Select all

	'USERWETTER'				=> 's Wetter',

Code: Select all

            'WETTER_LAND'  => (!empty($land)) ? $land_ary[$land][1]