This class can be used by bot plugins to handle updates (get them, install them).
 public function update()
 {
     $backup = new Backup($this->registry);
     $update = new Update($this->registry);
     //$backup->run();
     $update->run();
 }
 private function Update()
 {
     $Update = new Update();
     $Update->ExeUpdate(self::entidade, $this->dados, "WHERE id = :id", "id={$this->id}");
     if ($Update->getRowCount() >= 1) {
         $this->error = ["O registro de <b>{$this->dados['nome']}</b> foi atualizado com sucesso!", WS_ACCEPT];
         $this->result = true;
     }
 }
 public function postNewsPost()
 {
     $posted = Input::get();
     $update = new Update();
     $update->message = $posted['message'];
     $update->date = $posted['date'];
     $update->save();
     return Redirect::to('admin/news')->with('success', 'New update has been posted');
 }
 public static function getByVersionNumber($version)
 {
     $upd = new Update();
     $updates = $upd->getLocalAvailableUpdates();
     foreach ($updates as $up) {
         if ($up->getUpdateVersion() == $version) {
             return $up;
         }
     }
 }
 public function ApTrabalho($Cod)
 {
     $this->Cod = $Cod;
     $update = new Update();
     $Dados = ["status" => "A"];
     $update->ExeUpdate('trabalhos', $Dados, "where codigo = :c", "c={$this->Cod}");
     if ($update->getResult()) {
         echo "<script>alert('Trabalho Aprovado Com Sucesso!');</script>";
         echo "<script>window.location.assign('painel/submetidos.php')</script>";
     }
 }
 public function testChecarSeOSqlRetornaCorretoComWhere()
 {
     $update = new Update();
     $where = new Where();
     $where->set('id', '=', 1);
     $update->where($where);
     $fields = ['name' => 'Erik'];
     $update->fields($fields);
     $sql = $update->sql();
     $this->assertEquals('UPDATE `users` SET `name`=:name WHERE `id`=:id;', $sql);
 }
function admin_controller()
{
    global $mysqli, $session, $route, $updatelogin;
    // Allow for special admin session if updatelogin property is set to true in settings.php
    // Its important to use this with care and set updatelogin to false or remove from settings
    // after the update is complete.
    if ($updatelogin || $session['admin']) {
        $sessionadmin = true;
    }
    // if ($session['userid']==4) $sessionadmin = true;
    if ($sessionadmin) {
        if ($route->action == 'view') {
            $result = view("Modules/admin/admin_main_view.php", array());
        }
        if ($route->action == 'db') {
            $applychanges = get('apply');
            if (!$applychanges) {
                $applychanges = false;
            } else {
                $applychanges = true;
            }
            require "Modules/admin/update_class.php";
            require_once "Lib/dbschemasetup.php";
            $update = new Update($mysqli);
            $updates = array();
            $updates[] = array('title' => "Database schema", 'description' => "", 'operations' => db_schema_setup($mysqli, load_db_schema(), $applychanges));
            if (!$updates[0]['operations']) {
                // In future versions we could check against db version number as to what updates should be applied
                $updates[] = $update->u0001($applychanges);
                //$updates[] = $update->u0002($applychanges);
                $updates[] = $update->u0003($applychanges);
                $updates[] = $update->u0004($applychanges);
            }
            $result = view("Modules/admin/update_view.php", array('applychanges' => $applychanges, 'updates' => $updates));
        }
        if ($route->action == 'users' && $session['write'] && $session['admin']) {
            $result = view("Modules/admin/userlist_view.php", array());
        }
        if ($route->action == 'userlist' && $session['write'] && $session['admin']) {
            $data = array();
            $result = $mysqli->query("SELECT id,username,email FROM users");
            while ($row = $result->fetch_object()) {
                $data[] = $row;
            }
            $result = $data;
        }
        if ($route->action == 'setuser' && $session['write'] && $session['admin']) {
            $_SESSION['userid'] = intval(get('id'));
            header("Location: ../user/view");
        }
    }
    return array('content' => $result);
}
 public function ModelUpdate($id, array $dados)
 {
     $this->instituicao = (int) $id;
     $this->data = $dados;
     $update = new Update();
     $update->Updater(self::Entity, $this->data, 'where instituicao_id = :id', "id={$this->instituicao}");
     if ($update->getResult()) {
         $this->result = true;
     } else {
         $this->result = false;
     }
 }
 private function Update()
 {
     $Update = new Update();
     $Update->ExeUpdate(self::entidade, $this->dados, "WHERE id = :id", "id={$this->id}");
     if ($Update->getResult()) {
         $this->error = ["A Pessoa <b>{$this->dados['nome']}</b> foi atualizada com sucesso!", WS_ACCEPT];
         $this->result = true;
     } else {
         $this->error = ["Não foi possivel atualizar", WS_ERROR];
         $this->result = false;
     }
 }
 public function ModelUpdate($id, array $dados)
 {
     $this->rota = (int) $id;
     $this->data = $dados;
     $dataRota = array('rota_instituicoes' => json_encode($this->data['escolas']), 'tb_veiculos_veiculo_id' => (int) $this->data['rota_veiculo'], 'rota_inicio' => date('Y-m-d', strtotime(str_replace(array('/', '_', ' '), '-', $this->data['inicio']))), 'rota_fim' => date('Y-m-d', strtotime(str_replace(array('/', '_', ' '), '-', $this->data['fim']))), 'rota_saida' => (int) $this->data['rota_inicio'], 'rota_chegada' => (int) $this->data['rota_fim'], 'rota_observacoes' => $this->data['observacoes']);
     $update = new Update();
     $update->Updater(self::Entity, $dataRota, 'where rota_id = :id', "id={$this->rota}");
     if ($update->getResult()) {
         $this->result = true;
     } else {
         $this->result = false;
     }
 }
 public function ModelUpdate($id, array $dados)
 {
     $this->motorista = (int) $id;
     $this->data = $dados;
     $this->data['motorista_nome_url'] = Asserts::CheckName($this->data['motorista_nome']);
     $update = new Update();
     $update->Updater(self::Entity, $this->data, 'where motorista_id = :id', "id={$this->motorista}");
     if ($update->getResult()) {
         $this->result = true;
     } else {
         $this->result = false;
     }
 }
Beispiel #12
0
 public function actionDashboard()
 {
     $update = new Update();
     $messages = $update->getMessages();
     foreach ($messages as $message) {
         Yii::app()->user->setFlash('error', "<h3>" . $message["title"] . "</h3><br>" . $message["data"]);
     }
     if (isset($_POST['Widget'])) {
         $user = User::model()->findByPk(Yii::app()->user->id);
         $user->saveWidget($_POST['Widget']);
         Yii::app()->end();
     }
     $this->render('dashboard', array());
 }
Beispiel #13
0
 public function GravarTrabalho()
 {
     $this->dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
     if (isset($_FILES['fileUpload'])) {
         $nome = $this->dados['titulo'];
         $ext = strtolower(substr($_FILES['fileUpload']['name'], -4));
         //Pegando extensão do arquivo
         $new_name = $nome . $ext;
         //Definindo um novo nome para o arquivo
         $this->LinkAnexo = $new_name;
         $dir = 'uploads/';
         //Diretório para uploads
         move_uploaded_file($_FILES['fileUpload']['tmp_name'], $dir . $new_name);
         //Fazer upload do arquivo
     } else {
         echo "<script>alert('nao foi possivel anexar o arquivo!');</script>";
     }
     if ($this->dados['tipoAtividade'] == "Palestra") {
         $tipoA = 1;
     } elseif ($this->dados['tipoAtividade'] == "MiniCurso") {
         $tipoA = 2;
     } else {
         $tipoA = 3;
     }
     //atualiza pessoa
     $updateP = new Update();
     $dadosUp = ["curriculo" => $this->dados['perfil'], "nivel" => 1, "telefone" => $this->dados['telefone']];
     $updateP->ExeUpdate('pessoas', $dadosUp, "where codigo = :id", "id={$this->dados['idPes']}");
     //cadastra Trabalho
     $cadastrarT = new Create();
     $Dados = ["resumo" => $this->dados['resumo'], "data_submetido" => date("Y-m-d"), "tipo_atividade" => $tipoA, "anexo" => $this->LinkAnexo, "status" => "N", "titulo" => $this->dados['titulo']];
     $cadastrarT->ExeCreate('trabalhos', $Dados);
     $this->idT = $cadastrarT->getResult();
     // Vincula o auto trabalho
     $cadastraAT = new Create();
     $DadosAT = ["codigo_trabalho" => (int) $this->idT, "codigo_autor" => (int) $this->dados['idPes'], "codigo_evento" => 1];
     $cadastraAT->ExeCreate('autor_trabalho', $DadosAT);
     // pega dados da pessoa
     $pessoa = new Read();
     $pessoa->ExeRead('pessoas', "where codigo = :id", "id={$this->dados['idPes']}");
     foreach ($pessoa->getResult() as $resulPes) {
         extract($resulPes);
         //Enviar o Email.
         $enviarEmail = new Email();
         $DadosEmail = ["Assunto" => "Confirmação da Submição de Trabalho DeepDay", "Mensagem" => "Seu Trabalho foi submetido com sucesso.", "RemetenteNome" => "Equipe DeepDay", "RemetenteEmail" => "*****@*****.**", "DestinoNome" => $nome, "DestinoEmail" => $email];
         $enviarEmail->Enviar($DadosEmail);
     }
     echo "<script>alert('Seu trabalho foi submetido com sucesso!');</script>";
     echo "<script>window.location.assign('" . BASE . "/painel')</script>";
 }
 public function ModelUpdate($id, array $dados)
 {
     $this->aluno = (int) $id;
     $this->data = $dados;
     $this->data['aluno_nome_url'] = Asserts::CheckName($this->data['aluno_nome']);
     $this->data['aluno_nascimento'] = date('Y-m-d', strtotime(str_replace(array('/', '_'), '-', $this->data['aluno_nascimento'])));
     $update = new Update();
     $update->Updater(self::Entity, $this->data, 'where aluno_id = :id', "id={$this->aluno}");
     if ($update->getResult()) {
         $this->result = true;
     } else {
         $this->result = false;
     }
 }
 public function setVaga($veiculo)
 {
     $read = new Read();
     $read->Reader(self::Entity, 'where veiculo_id = :id', "id={$veiculo}");
     if ($read->getResult()) {
         $vagas = (int) $read->getResult()[0]['veiculo_vagas'];
         if (0 < $vagas) {
             $update = new Update();
             $update->Updater('tb_veiculos', array('veiculo_vagas' => $vagas - 1), 'where veiculo_id = :id', "id={$veiculo}");
             return true;
         } else {
             return false;
         }
     }
 }
Beispiel #16
0
 /**
  * Проверка номера версии в репозитории Github
  * @return integer
  */
 public static function check_version()
 {
     $respoonse = self::request('https://raw.githubusercontent.com/:rep/:branch/cms/application/bootstrap.php');
     preg_match('/define\\(\'CMS_VERSION\'\\,[\\t\\ ]*\'([0-9\\.]+)\'\\)\\;/i', $respoonse, $matches);
     self::$_remove_version = $matches[1];
     return version_compare(CMS_VERSION, self::$_remove_version);
 }
Beispiel #17
0
 public function doWork($object)
 {
     $this->insert_id = NULL;
     parent::doWork($object);
     $object->setId($this->insert_id);
     return $this->insert_id;
 }
 public function action_update_check()
 {
     // add an extra GUID, in addition to the one in our .xml file to pretend a theme was registered
     Update::add('Test', '10cbaf18-bdd2-48e1-b0d3-e1853a4c649d', '3.0.2');
     // add an extra GUID, in addition to the one in our .xml file to pretend a plugin was registered
     Update::add('Test', '7a0313be-d8e3-11d1-8314-0800200c9a66', '0.9');
 }
 public function view()
 {
     Loader::library('update');
     $this->set('latest_version', Update::getLatestAvailableVersionNumber());
     $tp = new TaskPermission();
     $updates = 0;
     $local = array();
     $remote = array();
     if ($tp->canInstallPackages()) {
         $local = Package::getLocalUpgradeablePackages();
         $remote = Package::getRemotelyUpgradeablePackages();
     }
     // now we strip out any dupes for the total
     $updates = 0;
     $localHandles = array();
     foreach ($local as $_pkg) {
         $updates++;
         $localHandles[] = $_pkg->getPackageHandle();
     }
     foreach ($remote as $_pkg) {
         if (!in_array($_pkg->getPackageHandle(), $localHandles)) {
             $updates++;
         }
     }
     $this->set('updates', $updates);
 }
Beispiel #20
0
 public static function fromResponse($data)
 {
     $arrayOfUpdates = array();
     foreach ($data as $update) {
         $arrayOfUpdates[] = Update::fromResponse($update);
     }
     return $arrayOfUpdates;
 }
Beispiel #21
0
 public function getApplicationUpdateInformation()
 {
     $r = Cache::get('APP_UPDATE_INFO', false);
     if (!is_object($r)) {
         $r = Update::getLatestAvailableUpdate();
     }
     return $r;
 }
Beispiel #22
0
    /**
     * @covers Zend\Db\Sql\Update::getSqlString
     * @todo   Implement testGetSqlString().
     */
    public function testGetSqlString()
    {
        $this->update->table('foo')
            ->set(array('bar' => 'baz'))
            ->where('x = y');

        $this->assertEquals('UPDATE "foo" SET "bar" = \'baz\' WHERE x = y', $this->update->getSqlString());
    }
Beispiel #23
0
 private function __construct()
 {
     $data = DataTable::constructFromCsvFile(new CsvFile('data/updates.csv'))->get();
     foreach ($data as $row) {
         $year = $row['year'];
         $month = $row['month'];
         $day = $row['day'];
         $version = $year . '-' . $month . '-' . $day;
         $change = $row['change'];
         if (!isset($this->updates[$version])) {
             $update = new Update($year, $month, $day);
             $this->updates[$version] = $update;
             $this->latest_version = $update->getVersion();
         }
         $this->updates[$version]->addChange($change);
     }
 }
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index($id)
 {
     $update = Update::get();
     $latest = null;
     foreach ($update as $time) {
         $latest = $time->time;
     }
     return View::make('article')->with('id', $id)->with('latest', $latest);
 }
 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $update = Update::get();
     $latest = null;
     foreach ($update as $time) {
         $latest = $time->time;
     }
     echo $latest;
 }
 public function run()
 {
     // $faker = Faker::create();
     // foreach(range(1, 10) as $index)
     // {
     // 	Update::create([
     // 	]);
     // }
     $updates = new Update();
     $updates->pitch_id = 1;
     $updates->update = "We are half way to our sales goal!  We are so proud of everyone's involvement.  Tell your friends.  More is on the way.";
     $updates->user_id = 1;
     $updates->save();
     $updates = new Update();
     $updates->pitch_id = 1;
     $updates->update = "We will be showing a new video this week showing our brewery facility.  Get excited.";
     $updates->user_id = 1;
     $updates->save();
 }
 public function run()
 {
     $log = new Logging();
     //        $parenClass = new ParentClass();
     // set path and name of log file (optional)
     $log->lfile('log.txt');
     $json = file_get_contents('php://input');
     $log->lwrite("post: " . $json);
     $update = new Update($json);
     $message = $update->getMessage();
     $chat = $message->getChat();
     $chat_id = $chat->getId();
     $text = $message->getText();
     $client = new Client();
     $client->sendMessage($chat_id, $text, null, null, null);
     $client->sendLocation($chat_id, 53.480759, -2.242631, null, null);
     $client->sendPhoto($chat_id, 'pic.jpg', 'sweety', null, null);
     $log->lclose();
 }
Beispiel #28
0
 public static function fromParamArgs(array $args, $class = null)
 {
     if (!$args) {
         throw new \InvalidArgumentException("Args missing for update");
     }
     $cnt = count($args);
     if ($cnt == 1) {
         return $args[0] instanceof self ? $args[0] : new Update($args[0]);
     } elseif ($cnt == 2 || $cnt == 3) {
         if (!is_array($args[0]) && !is_string($args[0])) {
             throw new \InvalidArgumentException("Set must be an array or string");
         }
         $query = new Update();
         $query->set = array_shift($args);
         $query->setParams($args);
         return $query;
     } else {
         throw new \InvalidArgumentException("Unknown args count {$cnt}");
     }
 }
function ol_search_open_learn_cron()
{
    require 'update_cron.class.php';
    //$db_handle = mysql_connect(DB_HOST.":".DB_PORT, DB_USER, DB_PASSWORD);
    //$db_found = mysql_select_db(DB_NAME, $db_handle);
    global $db;
    $db_handle = $db;
    //Create object of update class which is used for updating database
    $obj = new Update();
    $qry = "SELECT * FROM " . TABLE_PREFIX . "config WHERE name='ol_last_updation'";
    $r1 = mysql_query($qry, $db_handle);
    $res1 = mysql_fetch_assoc($r1);
    $qry = "SELECT * FROM " . TABLE_PREFIX . "config WHERE name='ol_url'";
    $r2 = mysql_query($qry, $db_handle);
    $res2 = mysql_fetch_assoc($r2);
    $qry = "SELECT * FROM " . TABLE_PREFIX . "config WHERE name='ol_base_url'";
    $r3 = mysql_query($qry, $db_handle);
    $res3 = mysql_fetch_assoc($r3);
    $obj->parse($res1['value'], $res2['value'], $db_handle, TABLE_PREFIX, $res3['value']);
}
Beispiel #30
0
 public static function update($updateID = null)
 {
     if ($updateID == null) {
         return null;
     }
     $update = Update::load($updateID);
     //	$user = User::load($update->getCreatorID());
     //	$username = $user->getUsername();
     $title = $update->getTitle();
     $accepted = Accepted::load($update->getAcceptedID());
     return array_merge(self::task($accepted->getTaskID()), self::oneCrumb($title, Url::update($updateID)));
 }