Premium Partner

Alle Partner

Executive Partner

$db     = &JFactory::getDBO();
$sql = "SELECT b.user_id, b.field_id, b.value FROM #__users a INNER JOIN #__community_fields_values b ON a.block = 0 AND a.id=b.user_id AND b.field_id IN (43,47,41) AND b.user_id NOT IN (1225,1233,1261) AND a.gid=".$db->Quote(21)." INNER JOIN #__community_fields_values c ON a.id=c.user_id AND c.field_id=70 and c.value = 'Executive Partner'";
$db->setQuery($sql);
$result = array();
foreach($db->loadObjectList() as $row) { $result[$row->user_id][$row->field_id] = $row->value; }
usort($result, "cmp"); $i = 1; $c = count($result); foreach($result as $id => $entry) { $url = $entry['47']; if(strpos($url, 'http://')===false) $url = 'http://' . $url; echo ''; $i++; if(2 == $i) echo ''; }
?>

Partner

function cmp($a, $b)
{
if ($a['41'] == $b['41']) {
return 0;
}
return ($a['41'] < $b['41']) ? -1 : 1;
}

$db     = &JFactory::getDBO();
$sql = "SELECT b.user_id, b.field_id, b.value, IF(c.value='',NULL,c.value) partnerstatus FROM #__users a INNER JOIN #__community_fields_values b ON a.block = 0 AND a.id=b.user_id AND b.field_id IN (43,47,41,70) AND user_id NOT IN (1225,1233,1261,2682,3139) AND a.gid=".$db->Quote(21)." LEFT JOIN #__community_fields_values c ON a.id=c.user_id AND c.field_id=70";
$db->setQuery($sql);
$result = array();
foreach($db->loadObjectList() as $row) if(is_null($row->partnerstatus)) $result[$row->user_id][$row->field_id] = $row->value;
usort($result, "cmp");
$i = 1; $c = count($result); foreach($result as $id => $entry) { $url = $entry['47']; if(strpos($url, 'http://')===false) $url = 'http://' . $url; echo ''; $i++; }
?>

Banking Partner

Sparkasse

Insurance Partner

Sparkasse

Förderer

Stiftung Sparkasse

Die Stiftung Südtiroler Sparkasse unterstützt Südstern als Förderer.

Autonome Provinz Bozen

Die Autonome Provinz Bozen Südtirol unterstützt Südstern als Förderer.

Kooperationspartner

Media Partner

Event Suppliers