function _updateDayCountersRecord($stamp, $hits_today, $hosts_today, $is_new_host, &$stats_request)
{
$home_hit = $stats_request->isHomeHit() ? 1 : 0;
$audience = $is_new_host && $stats_request->isAudienceHit() ? 1 : 0;
$sql = new SimpleUpdateSQL($this->day_counters_db_table->getTableName());
$sql->addField('hosts = ' . $hosts_today);
$sql->addField('hits = ' . $hits_today);
$sql->addField('home_hits = home_hits + ' . $home_hit);
$sql->addField('audience = audience + ' . $audience);
$sql->addCondition('time =' . $this->makeDayStamp($stamp));
$toolkit =& Limb::toolkit();
$conn =& $toolkit->getDBConnection();
$stmt =& $conn->newStatement($sql->toString());
$stmt->execute();
}
function update($table, $values, $conditions = array())
{
include_once(LIMB_DIR . '/core/db/SimpleUpdateSQL.class.php');
$sql = new SimpleUpdateSQL($table);
$prefixed_values = array();
foreach($values as $key => $value)
{
$sql->addField($key . '=:_' . $key . ':');
$prefixed_values['_' . $key] = $value;
}
$this->_addConditions($sql, $conditions);
$stmt =& $this->conn->newStatement($sql->toString());
$this->_fillStatementVariables($stmt, $prefixed_values);
$this->_fillStatementVariables($stmt, $conditions);
$stmt->execute();
return $stmt->getAffectedRowCount();
}
function update($row, $conditions = array())
{
$row = $this->_filterRow($row);
$conditions = $this->_filterRow($conditions);
include_once(LIMB_DIR . '/core/db/SimpleUpdateSQL.class.php');
$sql = new SimpleUpdateSQL($this->_db_table_name);
$prefixed_row = array();
foreach($row as $key => $value)
{
$sql->addField($key . '=:_' . $key . ':');
$prefixed_row['_' . $key] = $value;
}
$this->_addConditions($sql, $conditions);
$this->_stmt =& $this->_conn->newStatement($sql->toString());
$this->_fillStatementVariables($prefixed_row);
$this->_fillStatementVariables($conditions);
return $this->_stmt->execute();
}
