Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 749 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
395 lars 1
<?php
2
 
3
    function smarty_modifier_getIsoCode( $Land = 'Deutschland', $len = 2 )
4
    {
5
        $iso = "DE";
6
        $sql = "SELECT
7
                `iso-" . $len . "` as iso_code
8
            FROM
9
                countries
10
            WHERE
679 lars 11
                `name_de` ='" . $Land . "'
395 lars 12
            OR
679 lars 13
                `name_uk` = '" . $Land . "'
395 lars 14
            OR
15
                `id` = '" . $Land . "'
16
        ";
397 lars 17
        $row = DB::connection( 'cms' )->select( $sql );
749 lars 18
        if ( $row[0] )
395 lars 19
        {
750 lars 20
            $iso = $row[0]->iso_code;
395 lars 21
        }
22
        return $iso;
23
    }
24