public function is_user_id_allowed_to_view_drama($user_id, Oedipus_Drama $drama) { $user = NULL; $drama_id = $drama->get_id(); if (InputValidation_NumberValidator::validate_database_id($user_id)) { $dbh = DB::m(); $user_id = mysql_real_escape_string($user_id, $dbh); $query = <<<SQL SELECT \tcount(user_id) AS count FROM \toedipus_users_allowed_to_view_drama_links WHERE \toedipus_users_allowed_to_view_drama_links.user_id = {$user_id} \tAND \toedipus_users_allowed_to_view_drama_links.drama_id = {$drama_id} SQL; $result = mysql_query($query, $dbh); if ($row = mysql_fetch_assoc($result)) { if ($row['count'] == 1) { return TRUE; } return FALSE; } } }
private function get_drama_tr(Oedipus_Drama $drama) { $tr = new HTMLTags_TR(); //$tr->set_attribute_str('id', 'drama'); $link = new HTMLTags_A($drama->get_name()); $link->set_href($this->get_drama_page_url_for_drama($drama)); $name_td = $this->get_td_with_id($link->get_as_string(), 'name'); $tr->append($name_td); $added_td = $this->get_td_with_id($drama->get_human_readable_added(), 'added'); $tr->append($added_td); return $tr; }
public static function get_view_page_url(Oedipus_Drama $drama = NULL) { if (isset($drama)) { # $url = new HTMLTags_URL(); # $url->set_file('/dramas/'. $drama->get_unique_name()); #// $url->set_get_variable('oo-page', 1); #// $url->set_get_variable('page-class', 'Oedipus_DramaEditorPage'); # #// $url->set_get_variable('drama_unique_name', ); return PublicHTML_URLHelper::get_oo_page_url('Oedipus_DramaPage', array('drama_id' => $drama->get_id())); return $url; } else { return PublicHTML_URLHelper::get_oo_page_url('Oedipus_DramaPage'); } }
public function get_drama_by_id($drama_id) { $dbh = DB::m(); $query = <<<SQL SELECT \t* \tFROM \t\toedipus_dramas \tWHERE \t\tid = {$drama_id} SQL; // print_r($query);exit; $result = mysql_query($query, $dbh); $row = mysql_fetch_array($result); if ($row == FALSE) { throw new Oedipus_DramaNotFoundException('ID ' . $drama_id); } // print_r($row);exit; $drama = new Oedipus_Drama($row['id'], $row['name'], $row['unique_name'], $row['added'], $row['status']); // Add the acts to this Drama // Get all acts for this drama $acts_query = <<<SQL SELECT \t* \tFROM \t\toedipus_acts \tWHERE \t\tdrama_id = {$drama_id} SQL; // print_r($acts_query);exit; $acts_result = mysql_query($acts_query, $dbh); // Add the acts to the drama object // if ($acts_result) { while ($act_result = mysql_fetch_array($acts_result)) { $act_id = $act_result['id']; $act = self::get_act_by_id($act_id); $drama->add_act($act); } } // print_r($drama);exit; return $drama; }
public static function get_mod_rewrite_drama_page_url(Oedipus_Drama $drama = NULL) { if (isset($drama)) { $url = new HTMLTags_URL(); $url->set_file('/dramas/' . $drama->get_unique_name()); return $url; } else { return self::get_drama_page_url(); } }
public function add_table(Oedipus_Drama $drama, $table_name) { // ADD TABLE TO DATABASE $drama_id = $drama->get_id(); $dbh = DB::m(); $sql = <<<SQL INSERT INTO \toedipus_tables SET \tname = '{$table_name}', \tdrama_id = {$drama_id}, \tadded = NOW() SQL; // print_r($sql);exit; $result = mysql_query($sql, $dbh); $table_id = mysql_insert_id($dbh); // ADD DEFAULT ACTOR tO DATABASE $actor_name = 'First Actor'; $actor_color = 'red'; $sql2 = <<<SQL INSERT INTO \toedipus_actors SET \tname = '{$actor_name}', \tcolor = '{$actor_color}', \ttable_id = {$table_id}, \tadded = NOW() SQL; // print_r($sql);exit; $result2 = mysql_query($sql2, $dbh); $actor_id = mysql_insert_id($dbh); $actor = new Oedipus_Actor($actor_id, $actor_name, $actor_color); $actors = array(); $actors[] = $actor; foreach ($actors as $actor) { // ADD DEFAULT stated_intention tO DATABASE $stated_intention_position = '1'; $stated_intention_doubt = ''; $sql3 = <<<SQL INSERT INTO \toedipus_stated_intentions SET \tposition = '{$stated_intention_position}', \tdoubt = '{$stated_intention_doubt}' SQL; // print_r($sql);exit; $result3 = mysql_query($sql3, $dbh); $stated_intention_id = mysql_insert_id($dbh); // ADD DEFAULT option tO DATABASE $option_name = 'First Option'; $sql4 = <<<SQL INSERT INTO \toedipus_options SET \tname = '{$option_name}', \tactor_id = {$actor_id}, \tstated_intention_id = {$stated_intention_id}, \tadded = NOW() SQL; // print_r($sql);exit; $result4 = mysql_query($sql4, $dbh); $option_id = mysql_insert_id($dbh); $stated_intention = new Oedipus_StatedIntention($stated_intention_id, $stated_intention_position, $stated_intention_doubt); $actors_option = new Oedipus_Option($option_id, $option_name, $stated_intention); $actor->add_option($actors_option); } // Create default positions foreach ($actors as $actor) { foreach ($actor->get_options() as $option) { $positions = array(); foreach ($actors as $position_actor) { // ADD DEFAULT position tO DATABASE $position_position = '1'; $position_doubt = ''; $option_id = $option->get_id(); $actor_id = $position_actor->get_id(); $sql5 = <<<SQL INSERT INTO \toedipus_positions SET \tposition = '{$position_position}', \tdoubt = '{$position_doubt}', \toption_id = {$option_id}, \tactor_id = {$actor_id} SQL; // print_r($sql5);exit; $result5 = mysql_query($sql5, $dbh); $position_id = mysql_insert_id($dbh); $positions[$position_actor->get_name()] = new Oedipus_Position($position_id, $position_position, $position_doubt, $position_actor); } $option->add_positions($positions); } } $table = new Oedipus_Table($table_id, $drama_id, $table_name, $actors); // print_r($table);exit; // // Update Drama Object with new Table // $drama->add_table($table); return $table; }