/** * @deprecated * @param $parent_module_id * @return array */ function get_columns($parent_module_id) { return db::get_assoc("SELECT id, name FROM " . TABLE_SUBMODULES_COLUMNS . " WHERE submodule_id = " . db::input($parent_module_id) . " ORDER BY `order` ASC"); }
public static function getActiveAuthorsId_Fio() { $activeAuthorsId_Fio = db::get_assoc('SELECT id, fio FROM ' . TABLE_USERS . ' WHERE group_id=' . Author::ROLE_ID . ' AND blocked = 0 AND black_list = 0'); if (is_array($activeAuthorsId_Fio)) { asort($activeAuthorsId_Fio); } else { $activeAuthorsId_Fio = array(); } return $activeAuthorsId_Fio; }
public static function getAuthors($discipline_id) { return db::get_assoc("\n SELECT u.id, u.fio\n FROM " . TABLE_USERS . " u\n JOIN " . TABLE_AUTHOR_TO_DISCIPLINE . " atd ON atd.author_id = u.id\n WHERE\n u.group_id in ( " . Author::ROLE_ID . " ) AND\n u.blocked = 0 AND\n u.black_list = 0 AND\n atd.discipline_id = " . db::input($discipline_id)); }