59 lines
3.6 KiB
PHP
59 lines
3.6 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$schools = db_query("SELECT * FROM schools WHERE event_calendar = 'Y'");
|
|
|
|
while ($row = db_fetch_array($schools)) {
|
|
$orgType = $row['type'];
|
|
$school_num = $row['record_num'];
|
|
$name = $row['school_name'];
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Holiday','N','Y','Y','FFFFFF','FF0000')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Special Event','Y','Y','N','FF0000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Council Event','Y','Y','N','FF0000','DDDDDD')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Other','Y','Y','N','000000','FFFFFF')");
|
|
|
|
|
|
if ($orgType == 'School' || $orgType == 'Elementary' || $orgType == 'Private') {
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Hot Lunch','Y','Y','N','000000','F0D060')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'School Event','Y','Y','N','000000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Early Dismissal','Y','Y','N','000000','FF8000')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Professional Day','N','Y','Y','FF0000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Family Fun','Y','Y','N','FFFFFF','00A000')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Kid Friendly Activity','Y','Y','N','FFFFFF','00A000')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Dance Event','Y','Y','N','000000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Musical Event','Y','Y','N','000000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Sporting Event','Y','Y','N','000000','FFFFFF')");
|
|
|
|
db_query("INSERT INTO event_types (school_num,event_type_title,school_in_session,hotlunch_menu_on_date,display_on_order_form,text_color,bg_color) " .
|
|
"VALUES ($school_num,'Theatrical Event','Y','Y','N','000000','FFFFFF')");
|
|
|
|
}
|
|
}
|
|
|
|
?>
|