public static function add_scene(Oedipus_Act $act, $name = NULL)
{
if ($name == NULL) {
$name = Oedipus_DramaHelper::get_next_scene_name_for_act_id($act->get_id());
}
// ADD scene TO DATABASE
$dbh = DB::m();
$act_id = mysql_real_escape_string($act->get_id(), $dbh);
$name = mysql_real_escape_string($name, $dbh);
$sql = <<<SQL
INSERT INTO
\toedipus_scenes
SET
\tname = '{$name}',
\tadded = NOW(),
\tact_id = '{$act_id}'
SQL;
// print_r($sql);exit;
$result = mysql_query($sql, $dbh);
$scene_id = mysql_insert_id($dbh);
$added = date();
$scene = new Oedipus_Scene($scene_id, $scene_name, $added, $act_id);
// print_r($scene);exit;
return $scene;
}
