<?php

function nb_get_content() {
	$content = '';
	if (get_option('pd_nb_debug','false') == 'true') {
		$content .= '<!-- ATTENTION BAR: ' . NB_VERSION . ' START -->' . chr(13);
	}
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_data";
	$table_notifications = $wpdb->prefix . "nb_nottypes";
	if (function_exists('date_default_timezone_set')) {
		$timezone = date_default_timezone_get();
		date_default_timezone_set(get_option('timezone_string'));
	}
	$phptime = date('y-m-d H:i:s',time());
	if (function_exists('date_default_timezone_set')) {
		date_default_timezone_set($timezone);
	}
	if (get_option('pd_nb_debug','false') == 'true') {
		$content .= '<!-- PHPTIMEWITHOFFSET: ' . $phptime . ' -->' . chr(13);
	}
	$sql = "SELECT timebegin,timeend,content,bgcolor,fontcolor,nottype FROM " . $table_name . " WHERE ('" . $phptime ."'  >= timebegin AND '" . $phptime . "' <= timeend AND status = 1) OR (timebegin IS NULL AND status = 1) ORDER BY timebegin";
	if (get_option('pd_nb_debug','false') == 'true') {
		$content .= '<!-- SQL: ' . $sql . ' -->' . chr(13);
	}
        $myrows = $wpdb->get_results( $sql );
	if (get_option('pd_nb_debug','false') == 'true') {
		$content .= '<!-- FOUND: ' . count($myrows) . ' -->' . chr(13);
		$content .= '<!-- PHPTIME: ' . date('y-m-d H:i:s e',time()) . ' -->' . chr(13);
		$content .= '<!-- PHPTIMEZONE: ' . date_default_timezone_get() . ' -->' .chr(13);
		$content .= '<!-- WPTIMEOFFSET: ' .get_option('gmt_offset').' -->' .chr(13);
		$content .= '<!-- WPTIMEZONE: ' . get_option('timezone_string') . ' -->' .chr(13);
		$content .= '<!-- WPTIMEFORMAT: ' . get_option('time_format') . ' -->' .chr(13);
		$content .= '<!-- WPDATEFORMAT: ' . get_option('date_format') . ' -->' .chr(13);
		$content .= '<!-- COOKIEHASH: ' . md5('cookieHash') . ' -->' .chr(13);
	}
        if (count($myrows) != 0) {
	        // Create messages
		$initialbgcolor = '';
		$initialfontcolor = '';
		$messages = '"text": [';
		$annmessages = '"text": [';
		$annfontsize = '"fontSize": [';
		$backgroundcolor ='"backgroundColor": [';
		$fontcolor = '"fontColor": [';
		$afontcolor = '"aFontColor": [';
		$annimages = '"image": [';
		$annnames = '"name": [';
	        foreach ($myrows as $myrows) {
			if (get_option('pd_nb_debug','false') == 'true') {
				$content .= '<!-- STOREDENTRYTIME: ' . $myrows->timebegin . ' -->' .chr(13);
				$content .= '<!-- ENTRYTIME: ' . date('y-m-d H:i:s e',strtotime($myrows->timebegin)) . ' -->' .chr(13);
				$content .= '<!-- GMDATE: ' . gmdate('y-m-d H:i:s e',strtotime($myrows->timebegin)-$offset) . ' -->' .chr(13);
			}
		        $messages .= '"' . str_replace('"','\'',stripslashes($myrows->content)) . '",';
			if (empty($myrows->bgcolor)) {
				if(empty($myrows->nottype)) {
					$rawbgcolor = get_option('pd_nb_barcolor','darkred');
					$backgroundcolor .= '"' . $rawbgcolor . '",';
				} else {
					$rawbgcolor = $wpdb->get_var( "SELECT bgcolor FROM " . $table_notifications . " WHERE id = " . $myrows->nottype );
					$backgroundcolor .= '"' . $rawbgcolor . '",';
				};
			} else {
				$rawbgcolor = $myrows->bgcolor;
				$backgroundcolor .= '"' . $rawbgcolor . '",';
			};
			// check for initial background color, so no swapping occurs when first building up the bar
			if (empty($initialbgcolor)) {
				$initialbgcolor = $rawbgcolor;
			};
			if (empty($myrows->fontcolor)) {
				if(empty($myrows->nottype)) {
					$rawfontcolor = get_option('pd_nb_fontcolor','white');
					$fontcolor .= '"' . $rawfontcolor . '",';
					$afontcolor .= '"' . $rawfontcolor . '",';
				} else {
					$rawfontcolor = $wpdb->get_var( "SELECT fontcolor FROM " . $table_notifications . " WHERE id = " . $myrows->nottype );
                                        $fontcolor .= '"' . $rawfontcolor . '",';
					$afontcolor .= '"' . $rawfontcolor . '",';
				};
			} else {
				$rawfontcolor = $myrows->fontcolor;
				$fontcolor .= '"' . $rawfontcolor .'",';
				$afontcolor .= '"' . $rawfontcolor .'",';
			};
			// check for initial fontcolor, so no swapping occurs when first building up the bar
			if (empty($initialfontcolor)) {
				$initialfontcolor = $rawfontcolor;
			};
			$tmpnottext = $wpdb->get_var( "SELECT name FROM " . $table_notifications . " WHERE id = " . $myrows->nottype );
			if (empty($tmpnottext)) {
				$annmessages .= '"' . get_option('pd_nb_bartext', 'IMPORTANT!') . '",';
			} else {
				$annmessages .= '"' . str_replace('"','\'',stripslashes($tmpnottext)) . '",';
			}
			$tmpnotsize = $wpdb->get_var( "SELECT size FROM " . $table_notifications . " WHERE id = " . $myrows->nottype );
			if (empty($tmpnotsize)) {
				$annfontsize .= '"' . get_option('pd_nb_notsize','18') . 'pt",';
			} else {
				$annfontsize .= '"' . $tmpnotsize . 'pt",';
			}
			if (empty($myrows->nottype)) {
				$annimages .= '"",';
				$annnames .= '"' . get_option('pd_nb_bartext') . '",';
			} else {
				$tmpnoticon = $wpdb->get_results( "SELECT icon,name FROM " . $table_notifications . " WHERE id = " . $myrows->nottype );
				foreach ($tmpnoticon as $tmpnoticon) {
					$annimages .= '"' . $tmpnoticon->icon . '",';
					$annnames .= '"' . $tmpnoticon->name . '",';
				}
			}
	        }
        $messages = substr($messages, 0, -1);
	$backgroundcolor = substr($backgroundcolor, 0, -1);
	$fontcolor = substr($fontcolor, 0, -1);
	$annmessages = substr($annmessages, 0, -1);
	$annfontsize = substr($annfontsize, 0, -1); 
	$annimages = substr($annimages, 0, -1);
	$annnames = substr($annnames,0 ,-1);
        $content .= '<script type="text/javascript">';
        $content .= 'jQuery(function(){';
        $content .= 'jQuery.attentionbar({';
	$content .= '"positioning" : "' . get_option('pd_nb_bartype','fixed') . '",';
        $content .= '"display" : "' . get_option('pd_nb_displaytype','delayed') . '",';
        $content .= '"displayDelay" : ' . get_option('pd_nb_displaydelay','2000') .',';
        $content .= '"speed" : 500,';
        $content .= '"height" : ' . get_option('pd_nb_barheight','30') . ',';
        $content .= '"collapsedButtonHeight" : ' . get_option('pd_nb_buttonheight','30') . ',';
        $content .= '"messagesFadeDelay" : 1500,';
        $content .= '"easing" : "' . get_option('pd_nb_easingtype','swing') . '",';
	$content .= '"fontSize" : "' . get_option('pd_nb_fontsize','10') . 'pt",';
	$content .= '"fontColor" : "' . $initialfontcolor . '",';
        $content .= '"aFontColor" : "' . $initialfontcolor . '",';
	$content .= '"aFontSize" : "' . get_option('pd_nb_fontsize','10') . 'pt",';
	$content .= '"backgroundColor" : "' . $initialbgcolor . '", ';
        $content .= '"positionClose" : "' . get_option('pd_nb_buttonposition','left') . '", ';
        $content .= '"enableCookie" : ' . get_option('pd_nb_cookie','false') . ', ';
	if (get_option('pd_nb_cookiehash','true') == 'true') {
		$content .= '"cookieHash" : "' . md5($messages) . '", ';
	}
	$content .= '"cookieExpire" : ' . get_option('pd_nb_cookieexpire','1') . ', ';
        $content .= '"messagesDelay" : 5000,';
        $content .= '"buttonTheme" : "long-arrow",';
	$content .= '"announcementClass" : "announcement",';
	$content .= '"messages": {';
	$content .= $backgroundcolor;
	$content .= '],';
	$content .= $fontcolor;
	$content .= '],';
        $content .= $afontcolor;
	$content .= '],';
	$content .= $messages;
        $content .= ']';
	$content .= '},';
        $content .= '"announcement" : {';
        $content .= '"icon": [{';
        $content .= $annnames;
	$content .= '],';
	$content .= $annimages;
	$content .= ']';
        $content .= '}],';
	$content .= $annmessages;
	$content .= '],';
        $content .= '"fontColor" : "' . $initialfontcolor . '",';
        $content .= $annfontsize;
	$content .= ']}';
        $content .= '});';
        $content .= '});';
        $content .= '</script>' . chr(13);
        } else {
		if (get_option('pd_nb_debug','false') == 'true') {
			$sql = "SELECT * from  " . $table_name;
			$myrows = $wpdb->get_results($sql);
			$content .= '<!-- NO RESULTS FOUND DEBUGING -->' .chr(13);
			foreach ($myrows as $myrows) {
				$content .= '<!-- ID: ' . $myrows->id . ' -->' . chr(13);
				$content .=  '<!-- NAME: ' . $myrows->name . ' -->' . chr(13);
				$content .=  '<!-- CONTENT: ' . $myrows->content . ' -->' . chr(13);
       	                	$content .=  '<!-- TIMEBEGIN: ' . $myrows->timebegin . ' -->' . chr(13);
       	        	        $content .=  '<!-- TIMEEND: ' . $myrows->timeend . ' -->' . chr(13);
       		                $content .=  '<!-- TIMECREATED: ' . $myrows->timecreated . ' -->' . chr(13);
				$content .=  '<!-- STATUS: ' . $myrows->status . ' -->' . chr(13);
		}
		}
	}
	if (get_option('pd_nb_debug','false') == 'true') {
		$content .= '<!-- ATTENTION BAR ' . NB_VERSION . ' END -->' . chr(13);
	}
	if (get_option('pd_nb_showversion','true') == 'true') {
		return chr(13) . '<!-- Attention bar: ' . NB_VERSION . ' START -->' . chr(13) . $content . '<!-- Attention bar: ' . NB_VERSION . ' END -->';
	} else {
		return $content;
	}
}
?>