示例#1
0
    /**
     * Display the settings page (only one so far)
     *
     * @return null
     * @access public
     */
    public function display_settings()
    {
        $sql = 'SELECT user_change, only_title FROM ' . $this->tables->get_table('settings');
        $result = $this->db->sql_query($sql);
        $row = $this->db->sql_fetchrow($result);
        $active = $row['user_change'];
        $only_title = $row['only_title'];
        $this->db->sql_freeresult($result);
        $user_id = $this->user->data['user_id'];
        $username = $this->user->data['username'];
        // Get lastname and firstname from the phpbb_users or the extern table
        if (\kommodore\secondname\tables::$externTable == true) {
            $sql = 'SELECT ' . \kommodore\secondname\tables::$column['firstname'] . ' AS firstname, ' . \kommodore\secondname\tables::$column['lastname'] . ' AS lastname
						FROM ' . \kommodore\secondname\tables::$tableName . ' WHERE ' . \kommodore\secondname\tables::$externUsername . ' = "' . $this->db->sql_escape($username) . '"';
        } else {
            $sql = 'SELECT ' . \kommodore\secondname\tables::$column['firstname'] . ', ' . \kommodore\secondname\tables::$column['lastname'] . '
						FROM ' . USERS_TABLE . ' WHERE user_id = ' . (int) $user_id;
        }
        $result = $this->db->sql_query($sql);
        $row = $this->db->sql_fetchrow($result);
        $this->db->sql_freeresult($result);
        // Pass the second set of variables to the template
        $this->template->assign_vars(array('U_FIRSTNAME' => $row['firstname'], 'U_LASTNAME' => $row['lastname'], 'U_USERNAME' => $u_c, 'U_ONLY_TITLE' => $only_title == 1 ? false : true, 'S_ACTIVATED' => $active == 1 ? true : false, 'S_NOT_ACTIVATED' => $active == 0 ? true : false));
        // Get all titles from the database where the user is a member of the assigned group
        $sql = 'SELECT name, id FROM ' . $this->tables->get_table('titles') . ' INNER JOIN ' . USER_GROUP_TABLE . ' ON group_id = groups';
        $result = $this->db->sql_query($sql);
        while ($row = $this->db->sql_fetchrow($result)) {
            $this->template->assign_block_vars('title_block', array('NAME' => $row['name'], 'ID' => $row['id']));
        }
    }
示例#2
0
 /**
  * Delete a title
  *
  * @param int id The ID of the title to be deleted
  * @return null
  * @access public
  */
 public function delete_title($id)
 {
     $sql = 'DELETE FROM ' . $this->tables->get_table("titles") . ' WHERE id = ' . (int) $id;
     $res = $this->db->sql_query($sql);
 }