Exemplo n.º 1
0
 function updateOptions()
 {
     if (!isset($this->_options)) {
         return false;
     }
     $update_sql_template = 'REPLACE INTO userdata_plugins_options values ( ' . $this->id . ', %s, %s )';
     foreach ($this->_options as $option_name => $option_value) {
         $update_sql = sprintf($update_sql_template, $this->dbcon->qstr($option_name), $this->dbcon->qstr($option_value));
         if (!$this->dbcon->Execute($update_sql)) {
             AMP_DebugSQL($update_sql, 'Option Update');
         }
     }
     $this->dbcon->CacheFlush();
 }
Exemplo n.º 2
0
 function assembleSQL(&$lookup)
 {
     $distinct = $lookup->distinct ? " distinct " : "";
     $sql = "Select " . $distinct . $lookup->id_field . ", " . $lookup->result_field . " from " . $lookup->datatable;
     if ($lookup->criteria) {
         $sql .= " where " . $lookup->criteria;
     }
     if ($lookup->sortby) {
         $sql .= " order by " . $lookup->sortby;
     }
     if (AMP_DISPLAYMODE_DEBUG_LOOKUPS) {
         AMP_DebugSQL($sql, get_class($lookup));
     }
     return $sql;
 }
Exemplo n.º 3
0
 function getListsByUser($user_id)
 {
     $set = array();
     $this->addCriteriaUser($user_id);
     $sql = "SELECT listid " . $this->_makeSource() . $this->_makeCriteria();
     $set = $this->dbcon->CacheGetArray($sql);
     if (defined($this->_debug_constant) && constant($this->_debug_constant)) {
         AMP_DebugSQL($sql, get_class($this) . " lookup " . $field);
     }
     $final_set = array();
     foreach ($set as $key => $row) {
         $final_set[] = $row['listid'];
     }
     return $final_set;
 }
Exemplo n.º 4
0
 function getData($id = null)
 {
     $this->id = $id;
     $fieldset = array_keys($this->fields);
     $sql = "Select " . join(",", $fieldset) . " from " . $this->datatable;
     if (isset($id) && $id) {
         $sql .= " where id=" . $id;
         $datablock = $this->dbcon->Execute($sql);
         $dataset = $datablock->FetchRow();
         $this->form->setDefaults($dataset);
     } else {
         if (isset($this->list['criteria'])) {
             $sql .= ' WHERE ' . join(" AND ", $this->list['criteria']);
         }
         if (isset($this->list['sort'])) {
             $sql .= " ORDER BY " . $this->list['sort'];
         }
         $dataset = $this->dbcon->CacheGetAll($sql);
     }
     if (AMP_DISPLAYMODE_DEBUG) {
         AMP_DebugSQL($sql, get_class($this));
     }
     return $dataset;
 }
Exemplo n.º 5
0
 function getSet($options)
 {
     $list_sql = $this->_render_sql();
     if (AMP_DISPLAYMODE_DEBUG) {
         AMP_DebugSQL($list_sql, get_class($this) . $this->instance);
     }
     $this->results = $this->dbcon->CacheGetAll($list_sql);
     return is_array($this->results);
 }
Exemplo n.º 6
0
 function getLookup($field, $use_sort = false)
 {
     $set = array();
     if (!$this->makeReady()) {
         $sql = "SELECT " . $this->getIdFieldLookups() . ", {$field} " . $this->_makeSource() . $this->_makeCriteria();
         if ($use_sort) {
             $sql .= $this->_makeSort();
         }
         $set = $this->dbcon->CacheGetAssoc($sql);
         if (defined($this->_debug_constant) && constant($this->_debug_constant)) {
             AMP_DebugSQL($sql, get_class($this) . " lookup " . $field);
         }
         if (!$set && ($db_error = $this->dbcon->ErrorMsg())) {
             trigger_error(sprintf(AMP_TEXT_ERROR_LOOKUP_SQL_FAILED, get_class($this) . __FUNCTION__, $db_error) . $sql);
         }
     } else {
         while ($record = $this->getData()) {
             $set[$record['id']] = $record[$field];
         }
     }
     return $set;
 }
Exemplo n.º 7
0
 function _register_plugins()
 {
     $plugins = array();
     $this->plugins =& $plugins;
     $dbcon = $this->dbcon;
     $sql = "SELECT id, namespace, action FROM userdata_plugins WHERE instance_id=";
     $sql .= $dbcon->qstr($this->instance) . " AND active='1' ORDER BY priority";
     if (AMP_DISPLAYMODE_DEBUG_PLUGINS) {
         AMP_DebugSQL($sql, get_class($this));
     }
     $rs = $dbcon->CacheExecute($sql) or die("Couldn't register module data: " . $dbcon->ErrorMsg());
     $r = false;
     if ($rs->RecordCount() != 0) {
         while ($plugin = $rs->FetchRow()) {
             $namespace = $plugin['namespace'];
             $action = $plugin['action'];
             $plugin_instance = $plugin['id'];
             $r =& $this->registerPlugin($namespace, $action, $plugin_instance) and $r;
         }
     } else {
         if (method_exists($this, '_register_default_plugins')) {
             $this->_register_default_plugins();
         }
     }
     $this->_register_lists();
     return $r;
 }
Exemplo n.º 8
0
//echo $sql;
$sqlct = "SELECT  COUNT(DISTINCT id)  from articles" . $sql;
$listct = $dbcon->CacheExecute("{$sqlct}") or die("could not get list count" . $dbcon->ErrorMsg());
$sqlsel = "SELECT  DISTINCTROW  id, link, linkover, shortdesc, date, usedate, author,  source, sourceurl, picuse, picture, title FROM articles";
if (isset($_GET['offset'])) {
    $soffset = $_GET['offset'];
} else {
    $soffset = 0;
}
$sqloffset = " LIMIT {$soffset},{$limit} ";
if (isset($_GET['all'])) {
    $sqloffset = "";
}
$sql = $sqlsel . $sql . $sqloffset;
if (isset($_GET['debug'])) {
    AMP_DebugSQL($sql, 'list_default');
}
$list = $dbcon->CacheExecute("{$sql}") or die("Could not build list:<br>" . $sql . '<br>' . $dbcon->ErrorMsg());
// calll the layout file
if (isset($listlayoutreplace) && $listlayoutreplace != NULL) {
    include "{$listlayoutreplace}";
} else {
    include "AMP/List/list.layout.inc.php";
}
// show pagination
if ($limit < $listct->fields[0]) {
    echo '<br><br><div align="right">';
    $MM_removeList = "&offset=, &all=,&nointro=";
    reset($_GET);
    if (!isset($MM_keepURL)) {
        $MM_keepURL = "";
Exemplo n.º 9
0
function fof_do_query($sql, $live = 0)
{
    $dbcon = AMP_Registry::getDbcon();
    // echo "[$sql]<br>";
    if (AMP_DISPLAYMODE_DEBUG) {
        AMP_DebugSQL($sql, 'Feeds on Feeds');
    }
    if ($live) {
        return $dbcon->Execute($sql);
    } else {
        $result = $dbcon->Execute($sql);
        if (!$result) {
            die("Cannot query database.  Have you run <a href=\"install.php\"><code>install.php</code></a>? MySQL says: <b>" . $dbcon->ErrorMsg() . "</b>");
        }
        return $result;
    }
}
Exemplo n.º 10
0
 function &return_items($fieldset, $criteria, $orderby = null, $return_qty = "*", $offset = 0)
 {
     $empty_value = false;
     $sql = "SELECT {$fieldset} from userdata ";
     if (is_array($criteria) && !empty($criteria)) {
         $sql .= "where " . join(" AND ", $criteria);
     }
     $sql .= isset($orderby) ? " ORDER BY " . $orderby : "";
     if ($pager = $this->udm->getPlugins('Pager')) {
         $pager =& $pager[key($pager)];
         $sql .= $pager->return_qty != "*" ? " LIMIT " . strval($pager->offset) . ", " . strval($pager->return_qty) : "";
     } else {
         $sql .= $return_qty != "*" ? " LIMIT " . strval($offset) . ", " . strval($return_qty) : "";
     }
     if (AMP_DISPLAYMODE_DEBUG) {
         AMP_DebugSQL($sql, "udmsearch");
     }
     if ($dataset = $this->dbcon->CacheExecute($sql)) {
         return $dataset;
     } else {
         return $empty_value;
     }
 }
Exemplo n.º 11
0
 function _countSqlItems($sql)
 {
     $start_crit = strpos(strtoupper($sql), "FROM ");
     if ($start_crit === FALSE) {
         return;
     }
     $count_sql = "SELECT count(*) as AMPqty " . substr($sql, $start_crit);
     if (AMP_DISPLAYMODE_DEBUG_NAVS) {
         AMP_DebugSQL($count_sql, $this->nav->getName() . " count");
     }
     if ($result = $this->nav->dbcon->CacheExecute($count_sql)) {
         return $this->nav->setCount($result->Fields("AMPqty"));
     }
     if ($error = $this->nav->dbcon->ErrorMsg()) {
         trigger_error($this->nav->getName() . ' nav count failed: ' . $error);
     }
     return false;
 }
Exemplo n.º 12
0
 function clearEventCache($cal_id)
 {
     $sql = "SELECT * FROM calendar WHERE ";
     $sql .= "id='" . $cal_id . "'";
     $this->dbcon->CacheFlush();
     if (defined($this->_debug_cache_constant) && constant($this->_debug_cache_constant)) {
         AMP_DebugSQL($sql, get_class($this) . " cleared cache");
     }
 }
Exemplo n.º 13
0
 function clearItemCache($id)
 {
     $sql = $this->_assembleSqlByID($id);
     $this->dbcon->CacheFlush($sql);
     if (defined($this->_debug_cache_constant) && constant($this->_debug_cache_constant)) {
         AMP_DebugSQL($sql, get_class($this) . " cleared cache");
     }
     $data_set =& $this->_getSearchSource();
     $data_set->clearCache();
 }
Exemplo n.º 14
0
 function return_events($fieldset, $criteria, $orderby = null, $return_qty = "*", $offset = 0)
 {
     $sql = "SELECT {$fieldset} from calendar where " . join(" AND ", $criteria);
     $sql .= isset($orderby) ? " ORDER BY " . $orderby : "";
     if ($pager =& $this->calendar->getPlugin('Output', 'Pager')) {
         $sql .= $pager->return_qty != "*" ? " LIMIT " . strval($pager->offset) . ", " . strval($pager->return_qty) : "";
     } else {
         $sql .= $return_qty != "*" ? " LIMIT " . strval($offset) . ", " . strval($return_qty) : "";
     }
     if (AMP_DISPLAYMODE_DEBUG) {
         AMP_DebugSQL($sql, "calendar_main");
     }
     if ($eventset = $this->dbcon->CacheGetAll($sql)) {
         return $eventset;
     } else {
         return false;
     }
 }
Exemplo n.º 15
0
 function get_index($index_col = null, $orderby = null)
 {
     $options = $this->getOptions();
     if (!$options['show_jumplist']) {
         return false;
     }
     if (isset($this->_index_set)) {
         return $this->_index_set;
     }
     $criteria = $this->udm->sql_criteria;
     if (!isset($this->udm->sortby)) {
         $this->udm->setSort();
     }
     if (!isset($index_col)) {
         $index_col = $this->udm->sortby['select'];
     }
     if (!isset($orderby)) {
         $orderby = $this->udm->sortby['orderby'];
     }
     $index_sql = "SELECT " . $index_col . " from userdata ";
     if (is_array($criteria)) {
         $index_sql .= "where " . join(" AND ", $criteria);
     }
     if (isset($orderby)) {
         $index_sql .= " ORDER BY " . $orderby;
     }
     if (AMP_DISPLAYMODE_DEBUG) {
         AMP_DebugSQL($index_sql, "udm_pager");
     }
     if ($indexset =& $this->dbcon->CacheGetAll($index_sql)) {
         $this->_index_set = $indexset;
         return $indexset;
     }
     return false;
 }
Exemplo n.º 16
0
}
$sqlct = "SELECT  COUNT(DISTINCT id)  from articles" . $sql;
$listct = $dbcon->CacheExecute("{$sqlct}") or die($dbcon->ErrorMsg());
$sqlsel = "SELECT  DISTINCTROW  id, link, linkover, shortdesc, date, usedate, author, source, source, sourceurl, picuse, picture, title FROM articles";
if (isset($_GET[offset])) {
    $soffset = $_GET[offset];
} else {
    $soffset = 0;
}
$sqloffset = " LIMIT {$soffset},{$limit} ";
if (isset($_GET[all])) {
    $sqloffset = "";
}
$sql = $sqlsel . $sql . $sqloffset;
if (isset($_GET['debug'])) {
    AMP_DebugSQL($sql, 'list_general');
}
$list = $dbcon->CacheExecute("{$sql}") or die($dbcon->ErrorMsg());
if ($listlayoutreplace != NULL) {
    include "{$listlayoutreplace}";
} else {
    include "AMP/List/list.layout.inc.php";
}
?>


<br><br>
<div align="right">