<?php
	
/* 
	Deense Kroon
	Contact
	
	Mike Ontwerpt 2012
	www.mikeontwerpt.nl
	
	initContact(); 
	

*/
function initContact(){
	$output = '';
	$output .= showContact();
	return $output;
}


function showContact(){
	/* get mysqli */
	global $mysqli;
	$output = '';
	
	/* get info */
	$query = 'SELECT c.title , c.titleEn, c.titleDe, c.titleFr, c.image, c.descriptionLeft, c.descriptionLeftEn, c.descriptionRight,c.descriptionRightEn
			  FROM contact AS c, content_status AS s
			  WHERE s.active = 1
			  AND s.itemId = c.id
			  AND s.linkname = "contact"
			  AND c.published = 1 
			  ORDER BY c.itemOrder DESC
			  LIMIT 1';
	if($result = $mysqli->query($query)){
		
		$record = $result->fetch_assoc();
		$title = fromDatabase($record['title']);
		switch($_SESSION['lang']){
			case 'en':
				if(!empty($record['titleEn'])) $title = fromDatabase($record['titleEn']);
			break;	
			case 'de':
				if(!empty($record['titleDe'])) $title = fromDatabase($record['titleDe']);
			break;
			case 'fr':
				if(!empty($record['titleFr'])) $title = fromDatabase($record['titleFr']);
			break;
		}
		
		$_SESSION['lang'] == 'nl' || empty($record['descriptionLeftEn']) ? $descriptionLeft = fromDatabase($record['descriptionLeft']) : $descriptionLeft = fromDatabase($record['descriptionLeftEn']);
		$_SESSION['lang'] == 'nl' || empty($record['descriptionRightEn']) ? $descriptionRight = fromDatabase($record['descriptionRight']) : $descriptionRight = fromDatabase($record['descriptionRightEn']);

		$image = replaceShortcodes($record['image']);

        $output .= '
            <div class="contained-layout image-text about">
                <div class="col-3 col-image image-holder"> 
                 ' . $image . '          
                </div>
                <div class="col-3 col-text">
                    <div class="text-block">
                        <h1>'.$title.'</h1>
                        ' . $descriptionLeft . '                        
                        ' . $descriptionRight . '                        
                    </div>
                    
                    <div class="about-social-holder">
                        <div class="btn-social">
                            <a href="https://www.facebook.com/pages/Deense-Kroon/270632859677919" target="_blank" class="btn-facebook">
                                <span class="btn-facebook btnhover"></span>
                            </a>
                        </div>
                        <div class="btn-social">
                            <a href="http://twitter.com/#!/deensekroon" class="btn-twitter" target="_blank" >
                                <span class="btn-twitter btnhover"></span>
                            </a>
                        </div>
                    </div>
                </div>
            </div>';
		
		
	}
	return $output;	
}

?>