, * * Beschreibung: * CIS 4.0 Dashboard */ if (! defined('DB_NAME')) exit('No direct script access allowed'); // Add widget: Hallo Welt if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'hallowelt';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "Hallo Welt"
'; } } } // Add widget: News if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'news';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "News"
'; } } } // Add widget: Bookmark if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'url';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "Bookmark"
'; } } } // Add widget: Ampel if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'ampel';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "Ampel"
'; } } } // update stundenplan widget if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'stundenplan';")) { if($db->db_num_rows($result) > 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Renamed Widget "Stundenplan" to "LV-Plan"
'; } } } // Add widget: LV-Plan if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'lvplan';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "LV-Plan"
'; } } } // Add widget: Studiengang if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_widget WHERE widget_kurzbz = 'studiengang';")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_widget: Added Widget "Studiengang"
'; } } } // Add dashboard: CIS if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_dashboard WHERE dashboard_kurzbz = 'CIS';")) { if($db->db_num_rows($result) == 0) { $qry = "INSERT INTO dashboard.tbl_dashboard(dashboard_kurzbz, beschreibung) VALUES('CIS', 'CIS 4.0 Dashboard');"; if(!$db->db_query($qry)) { echo 'dashboard.tbl_dashboard '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_dashboard: Added Dashboard "CIS"
'; } $widgetmappingqry = <<db_query($widgetmappingqry)) { echo 'dashboard.tbl_dashboard_widget '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_dashboard_widget: Added WidgetMapping for Dashboard "CIS"
'; } } } // Add general preset for dashboard: CIS if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_dashboard_preset WHERE funktion_kurzbz IS NULL AND dashboard_id = (select dashboard_id from dashboard.tbl_dashboard where dashboard_kurzbz = 'CIS');")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_dashboard_preset '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_dashboard_preset: Added General Preset for Dashboard "CIS"
'; } } } // Add general preset for dashboard: CIS if($result = @$db->db_query("SELECT 1 FROM dashboard.tbl_dashboard_preset WHERE funktion_kurzbz = 'Student' AND dashboard_id = (select dashboard_id from dashboard.tbl_dashboard where dashboard_kurzbz = 'CIS');")) { if($db->db_num_rows($result) == 0) { $qry = <<db_query($qry)) { echo 'dashboard.tbl_dashboard_preset '.$db->db_last_error().'
'; } else { echo 'dashboard.tbl_dashboard_preset: Added Student Preset for Dashboard "CIS"
'; } } }