<?php
// database options
function nb_insert_entry() {
        global $wpdb;
	$table_name = $wpdb->prefix . "nb_data";
	$name = $_POST['nb_name'];
	$content = $_POST['nb_content'];
	$status = $_POST['nb_status'];
	$begin = $_POST['nb_timebegin'];
	$end = $_POST['nb_timeend'];
	$bgcolor = $_POST['nb_bgcolor'];
	$fontcolor = $_POST['nb_fontcolor'];
	$nottype = $_POST['nb_nottype'];
	if(empty($begin) || empty($end)) {
		$wpdb->insert( $table_name, array( 'status' => 0, 'timecreated' => current_time('mysql',0), 'name' => $name, 'content' => $content, 'status' => $status, 'bgcolor' => $bgcolor, 'fontcolor' => $fontcolor, 'nottype' => $nottype ) );
	} else {
        	$wpdb->insert( $table_name, array( 'status' => 0, 'timecreated' => current_time('mysql',0), 'name' => $name, 'content' => $content, 'status' => $status, 'timebegin' => $begin, 'timeend' => $end, 'bgcolor' => $bgcolor, 'fontcolor' => $fontcolor, 'nottype' => $nottype ) );
	}
}

function nb_delete_entry($id) {
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_data";
        $wpdb->query('DELETE FROM ' . $table_name .' WHERE id = ' . $id);
}

function nb_change_status($id,$status) {
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_data";
        $wpdb->update( $table_name, array( 'status' => $status ), array( 'id' => $id));

}

function nb_edit_entry($id) {
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_data";
	$bgcolor = $_POST['nb_bgcolor'];
	$fontcolor = $_POST['nb_fontcolor'];
	$begin = $_POST['nb_timebegin'];
	$end = $_POST['nb_timeend'];
	if(empty($begin) || empty($end)) {
		$wpdb->update( $table_name, array( 'status' => $_POST['nb_status'], 'name' => $_POST['nb_name'], 'content' => $_POST['nb_content'], 'bgcolor' => $bgcolor, 'fontcolor' => $fontcolor, 'nottype' => $_POST['nb_nottype']), array('id' => $id));
	} else {
        	$wpdb->update( $table_name, array( 'status' => $_POST['nb_status'], 'timebegin' => $begin, 'timeend' => $end, 'name' => $_POST['nb_name'], 'content' => $_POST['nb_content'], 'bgcolor' => $bgcolor, 'fontcolor' => $fontcolor, 'nottype' => $_POST['nb_nottype']), array('id' => $id));
	}
}

function nb_insert_nottype() {
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_nottypes";
	$icon = $_POST['nb_noticon'];
	$name = $_POST['nb_notname'];
	$bgcolor = $_POST['nb_notbgcolor'];
	$fontcolor = $_POST['nb_notfontcolor'];
	$size = $_POST['nb_notsize'];
        $wpdb->insert( $table_name, array( 'size' => $size, 'name' => $name, 'icon' => $icon, 'bgcolor' => $bgcolor, 'fontcolor' => $fontcolor ) );
}

function nb_edit_nottype($id) {
	global $wpdb;
        $table_name = $wpdb->prefix . "nb_nottypes";
	$wpdb->update ($table_name, array( 'size' => $_POST['nb_notsize'], 'name' => $_POST['nb_notname'], 'icon' => $_POST['nb_noticon'], 'bgcolor' => $_POST['nb_notbgcolor'], 'fontcolor' => $_POST['nb_notfontcolor']), array('id' => $id));
}

function nb_delete_nottype($id) {
        global $wpdb;
        $table_name = $wpdb->prefix . "nb_nottypes";
        $wpdb->query('DELETE FROM ' . $table_name .' WHERE id = ' . $id);
}

// end database options
?>