Exemplo n.º 1
0
 public static function FetchAllByAuthorID($id, $kwargs = array())
 {
     global $db_connection;
     global $languages;
     $res = array();
     if (!isset($kwargs['all'])) {
         $lang = '';
         if (isset($kwargs['lang'])) {
             $lang = $kwargs['lang'];
         } else {
             $lang = GetLanguage();
         }
         $fetch_table = UserBlock::$table;
         if ($lang != 'rus') {
             $fetch_table .= '_' . $lang;
         }
         $result = $db_connection->query("SELECT * FROM `" . $fetch_table . "` WHERE author_id='" . $id . "' ORDER BY priority DESC, creating_date DESC;");
         if ($result->num_rows < 1) {
             echo $db_connection->error;
             return NULL;
         }
         $res = array();
         for ($i = 0; $i < $result->num_rows; ++$i) {
             $tmp = $result->fetch_assoc();
             $tmp['language'] = $lang;
             array_push($res, UserBlock::FetchFromAssoc($tmp));
         }
     } else {
         foreach ($languages as $key => $value) {
             $tmp = $this->FetchAllByAuthorID($id, array('lang' => $key));
             if ($tmp !== NULL && count($tmp) > 0) {
                 $res = array_merge($res, $tmp);
             }
         }
     }
     return $res;
 }
Exemplo n.º 2
0
 switch ($_POST['type']) {
     case RequestOnRegister::$type:
         $request = RequestOnRegister::FetchByID($_POST['id']);
         if ($request == NULL) {
             $content = AlertMessage('alert-danger', Language::Word('error while user adding'));
         } else {
             if (!User::InsertToDB($request)) {
                 $content = AlertMessage('alert-danger', Language::Word('error while user adding'));
             } else {
                 $content = AlertMessage('alert-success', Language::Word('request is accepted'));
                 RequestOnRegister::Delete($_POST['id']);
             }
         }
         break;
     case UserBlock::$type:
         $usr_block = UserBlock::FetchFromAssoc($_POST);
         if ($usr_block === NULL) {
             $content = AlertMessage('alert-danger', Language::Word('error while user block adding'));
         } else {
             $glob_id = 0;
             if (isset($_POST['glob_id'])) {
                 $glob_id = $_POST['glob_id'];
             }
             if (UserBlock::InsertToDB($usr_block, $_POST['language'], $glob_id)) {
                 $content = AlertMessage('alert-success', Language::Word('user block is successfully added'));
             } else {
                 $content = AlertMessage('alert-danger', Language::Word('error during user block inserting'));
             }
         }
         break;
     case Article::$type: