Example #1
0
 public function save()
 {
     $keys = $this->index();
     Database::insert($this->tableName(), $this->_data, true);
     $t = Database::lastID();
     $this->{$keys[0]} = $t;
     return true;
 }
Example #2
0
if (isset($_POST["titlechange"]) && $isadmin == 1) {
    $tickid = $mydb->clean($_POST["tickid"], '', '');
    $mydb->query_update("list", array('title' => $_POST["titlechange"]), "id='{$tickid}'");
    echo "Title changed.";
}
if (isset($_POST["closeticket"]) && $isadmin == 1) {
    $closeticket = $mydb->clean($_POST["tickid"], '', '');
    $mydb->query_update('list', array('status' => 0, 'finished' => time()), "id='{$closeticket}'");
    echo "Ok";
}
if (isset($_POST["openticket"]) && $isadmin == 1) {
    $closeticket = $mydb->clean($_POST["tickid"], '', '');
    $mydb->query_update('list', array('status' => 1, 'finished' => '0'), "id='{$closeticket}'");
    echo "Ok";
}
if (isset($_POST["changepri"]) && $isadmin == 1) {
    $changepri = $mydb->clean($_POST["changepri"], '', '');
    $id = $mydb->clean($_POST["id"], '', '');
    $mydb->query_update('list', array('priority' => $changepri), "id='{$id}'");
    //print_r($_POST);
}
// adds to do items
if (isset($_POST["addtodo"])) {
    $id = $mydb->clean($_POST["id"], '', '');
    $mydb->query_insert('todo_list', array('id' => 'null', 'tid' => $_POST['id'], 'content' => $_POST['item'], 'status' => 0));
    echo $mydb->lastID();
}
if (isset($_POST["markfinish"])) {
    $mydb->query_update('todo_list', array('status' => 1), "id='" . $mydb->clean($_POST["id"], '', '') . "'");
}
//print_r($_POST);
Example #3
0
        echo "{$errstr} ({$errno})<br />\n";
    } else {
        $out = "GET /api/v1/xml/" . $user_proj . "/commits/master HTTP/1.1\r\n";
        $out .= "Host: google.com \r\n";
        $out .= "Connection: Close\r\n\r\n";
        fwrite($fp, $out);
        while (!feof($fp)) {
            $results .= fgets($fp, 128);
        }
        fclose($fp);
    }
    $post_results = parseHttpResponse($results);
    $objXML = new xml2Array();
    $arrOutput = $objXML->parse($post_results);
    $github_result = $arrOutput[0]['children'];
    for ($i = 0; $i < count($github_result); $i++) {
        $commit_id = $github_result[$i]['children'][4]['tagData'];
        $message = $github_result[$i]['children'][0]['tagData'];
        $date = str_replace('T', ' T ', $github_result[$i]['children'][5]['tagData']);
        $commiter = $github_result[$i]['children'][3]['children'][0]['tagData'] . "/" . $github_result[$i]['children'][3]['children'][1]['tagData'];
        $unix_stamp = strtotime($date);
        echo "{$message} [{$commit_id}] was commited by {$commiter} on " . $unix_stamp . " \n";
        if (strlen($mydb->first("SELECT `sum` FROM commits WHERE `sum`='{$commit_id}'")) == 0) {
            $ar = array('id' => null, 'user' => $commiter, 'message' => $message, 'sum' => $commit_id, 'project' => $r['id']);
            $mydb->query_insert('commits', $ar);
            $LASTID = $mydb->lastID();
            $s->n($LASTID, '', 'git', $r['id'], $unix_stamp);
        }
        //echo "<a href='#' onclick=\"insertAtCursor(document.reply.report, '[GIT]".$commit_id."[/GIT]');\" title=\".". $date . "\">" .$message . "</a><small>[" . $commit_id . "]</small>";
    }
}
Example #4
0
$gui = new AdminGui($db);
$works_records = $gui->select('works');
$media_records = $gui->joinThree('works', 'media_for_works', 'media', 'media_title', 'work_id', 'media_id');
$categories_records = $gui->joinThree('works', 'categories_for_works', 'categories', 'category', 'work_id', 'category_id');
$techniques_records = $gui->joinThree('works', 'techniques_for_works', 'techniques', 'technique', 'work_id', 'technique_id');
$technologies_records = $gui->joinThree('works', 'technologies_for_works', 'technologies', 'technology', 'work_id', 'technology_id');
if (!empty($_POST)) {
    $post_works = array_slice($_POST, 0, 2);
    $db->table('works');
    $validator = new Validator($db, $errorHandler);
    $validation = $validator->check($post_works, ['work_title' => ['required' => true], 'work_description' => ['required' => false]]);
    if ($validation->fails()) {
        echo '<pre>', print_r($validation->errors()->all()), '</pre>';
    } else {
        if ($db->insert($post_works)) {
            $last_id = $db->lastID();
            if ($_POST['media']) {
                $post_media = $_POST['media'];
                for ($m = 0; $m < count($post_media); $m++) {
                    $insert_media = ['media_id' => $post_media[$m], 'work_id' => $last_id];
                    $db->table('media_for_works')->insert($insert_media);
                }
            }
            if ($_POST['category']) {
                $post_category = $_POST['category'];
                for ($n = 0; $n < count($post_category); $n++) {
                    $insert_category = ['category_id' => $post_category[$n], 'work_id' => $last_id];
                    $db->table('categories_for_works')->insert($insert_category);
                }
            }
            if ($_POST['technique']) {
Example #5
0
 public static function query($query, $inputArray)
 {
     // Run the query
     $result = self::$database->prepare($query);
     if (!$result->execute($inputArray)) {
         return false;
     }
     // Get Last ID that was inserted into the database (if applicable)
     self::$lastID = (int) self::$database->lastInsertId();
     // Retrieve the number of rows that were affected
     self::$rowsAffected = (int) $result->rowCount();
     return true;
 }