Exemplo n.º 1
0
/**
 * @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");
}
Exemplo n.º 2
0
 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;
 }
Exemplo n.º 3
0
 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));
 }