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; }
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: