PHP nzedb\db\DB::ping Examples

Example #1

File: IRCScraper.php Project: Jay204/nZEDb

 /**
  * Updates PRE data in the DB.
  *
  * @access protected
  */
 protected function _updatePre()
 {
     if (empty($this->_curPre['title'])) {
         return;
     }
     $query = 'UPDATE predb SET ';
     $query .= !empty($this->_curPre['size']) ? 'size = ' . $this->_pdo->escapeString($this->_curPre['size']) . ', ' : '';
     $query .= !empty($this->_curPre['source']) ? 'source = ' . $this->_pdo->escapeString($this->_curPre['source']) . ', ' : '';
     $query .= !empty($this->_curPre['files']) ? 'files = ' . $this->_pdo->escapeString($this->_curPre['files']) . ', ' : '';
     $query .= !empty($this->_curPre['reason']) ? 'nukereason = ' . $this->_pdo->escapeString($this->_curPre['reason']) . ', ' : '';
     $query .= !empty($this->_curPre['reqid']) ? 'requestid = ' . $this->_curPre['reqid'] . ', ' : '';
     $query .= !empty($this->_curPre['group_id']) ? 'group_id = ' . $this->_curPre['group_id'] . ', ' : '';
     $query .= !empty($this->_curPre['predate']) ? 'predate = ' . $this->_curPre['predate'] . ', ' : '';
     $query .= !empty($this->_curPre['nuked']) ? 'nuked = ' . $this->_curPre['nuked'] . ', ' : '';
     $query .= !empty($this->_curPre['filename']) ? 'filename = ' . $this->_pdo->escapeString($this->_curPre['filename']) . ', ' : '';
     $query .= empty($this->_oldPre['category']) && !empty($this->_curPre['category']) ? 'category = ' . $this->_pdo->escapeString($this->_curPre['category']) . ', ' : '';
     if ($query === 'UPDATE predb SET ') {
         return;
     }
     $query .= 'title = ' . $this->_pdo->escapeString($this->_curPre['title']);
     $query .= ' WHERE title = ' . $this->_pdo->escapeString($this->_curPre['title']);
     $this->_pdo->ping(true);
     $this->_pdo->queryExec($query);
     $this->_doEcho(false);
 }

Example #2

File: fetchWeb.php Project: nZEDb/nZEDb_IRC_Bots

 /**
  * Get pre from XrelP2P.
  */
 protected function _retrieveXrelP2P()
 {
     echo "Fetching XrelP2P\n";
     $data = $this->_getUrl("https://api.xrel.to/v2/p2p/releases.json?per_page=100");
     if ($data !== false) {
         $data = json_decode($data);
         if ($data) {
             $this->_db->ping(true);
             foreach ($data->list as $release) {
                 $result = array();
                 $result['title'] = trim($release->dirname);
                 $result['date'] = trim($release->pub_time);
                 $result['source'] = 'xrelp2p';
                 if (isset($release->size_mb)) {
                     $result['size'] = trim($release->size_mb) . "MB";
                 }
                 if (isset($release->category->meta_cat) && isset($release->category->sub_cat)) {
                     $result['category'] = ucfirst(trim($release->category->meta_cat)) . " " . trim($release->category->sub_cat);
                 }
                 $this->_verifyPreData($result);
             }
             $this->_echoDone();
             return;
         }
     }
     echo "Update from XrelP2P failed.\n";
 }

Example #3

File: IRCScraper.php Project: nZEDb/nZEDb_IRC_Bots

 /**
  * Updates PRE data in the DB.
  *
  * @access protected
  */
 protected function updatePre()
 {
     if (empty($this->CurPre['title'])) {
         return;
     }
     $query = 'UPDATE predb SET ';
     $query .= !empty($this->CurPre['size']) ? 'size = ' . $this->db->escapeString($this->CurPre['size']) . ', ' : '';
     $query .= !empty($this->CurPre['source']) ? 'source = ' . $this->db->escapeString($this->CurPre['source']) . ', ' : '';
     $query .= !empty($this->CurPre['files']) ? 'files = ' . $this->db->escapeString($this->CurPre['files']) . ', ' : '';
     $query .= !empty($this->CurPre['reason']) ? 'nukereason = ' . $this->db->escapeString($this->CurPre['reason']) . ', ' : '';
     $query .= !empty($this->CurPre['reqid']) ? 'requestid = ' . $this->CurPre['reqid'] . ', ' : '';
     $query .= !empty($this->CurPre['groupid']) ? 'groupid = ' . $this->CurPre['groupid'] . ', ' : '';
     $query .= !empty($this->CurPre['predate']) ? 'predate = ' . $this->CurPre['predate'] . ', ' : '';
     $query .= !empty($this->CurPre['nuked']) ? 'nuked = ' . $this->CurPre['nuked'] . ', ' : '';
     $query .= !empty($this->CurPre['filename']) ? 'filename = ' . $this->db->escapeString($this->CurPre['filename']) . ', ' : '';
     $query .= empty($this->OldPre['category']) && !empty($this->CurPre['category']) ? 'category = ' . $this->db->escapeString($this->CurPre['category']) . ', ' : '';
     if ($query === 'UPDATE predb SET ') {
         return;
     }
     $query .= 'title = ' . $this->db->escapeString($this->CurPre['title']);
     $query .= ', shared = -1 WHERE md5 = ' . $this->CurPre['md5'];
     $this->db->ping(true);
     $this->db->queryExec($query);
     $this->doEcho(false);
     $this->resetPreVariables();
 }

Example #4

File: scrapeM2VRU.php Project: nZEDb/nZEDb_IRC_Bots

<?php

define('pre_settings', true);
define('m2v_settings', true);
require 'settings.php';
require_once 'Classes/DB.php';
$db = new nzedb\db\DB();
for (;;) {
    $db->ping(true);
    $rss_data = getUrl(M2VRU_RSS_LINK);
    if (!$rss_data) {
        echo "Error downloading '" . M2VRU_RSS_LINK . "'\n";
        sleep_printout(M2V_SLEEP_TIME);
        continue;
    }
    $rss_data = @simplexml_load_string($rss_data);
    if (!$rss_data) {
        echo "Error parsing XML data from M2V RSS.\n";
        sleep_printout(M2V_SLEEP_TIME);
        continue;
    }
    echo "Downloaded RSS data from M2V.\n";
    $items = 0;
    foreach ($rss_data->channel->item as $item) {
        if ($item->title == "m2v.ru") {
            continue;
        }
        if ($db->queryOneRow("SELECT id FROM predb WHERE filename != '' AND title = " . $db->escapeString($item->title))) {
            continue;
        }
        $item_data = getUrl($item->link);