db)) { $this->db = $this->get_db(); } $sql = 'SELECT g.group_legend AS group_legend, t.teampage_position AS group_teampage FROM ' . GROUPS_TABLE . ' g LEFT JOIN ' . TEAMPAGE_TABLE . ' t ON (t.group_id = g.group_id) WHERE g.group_id = 5'; $result = $this->db->sql_query($sql); $group_row = $this->db->sql_fetchrow($result); $this->db->sql_freeresult($result); return $group_row; } public function test_ucp_groups_teampage() { $this->group_manage_login(); // Test if group_legend or group_teampage are modified while // submitting the ucp_group_manage page $form = $this->get_group_manage_form(); $teampage_settings = $this->get_teampage_settings(); $crawler = $this->client->submit($form); $this->assertContains($this->lang('GROUP_UPDATED'), $crawler->text()); $this->assertEquals($teampage_settings, $this->get_teampage_settings()); } }