function LoadFromTable(JaxpMySqlTable $table_source, $title_field, $value_field, $date_field, $id_field, $link_template)
{
$table_source->SortBy($table_source->Columns[$date_field], true);
foreach ($table_source->SortedRows as $sr) {
$date = new JaxpDate(JAXP_DATE_FROM_TIMESTAMP, $sr->Columns[$date_field]->Value);
$link = $link_template;
$link = str_replace("%DOMAIN%", $this->PlatformSettings->BaseUrl, $link);
$link = str_replace("%YEAR%", $date->Year, $link);
$link = str_replace("%MONTH%", $date->Month, $link);
$link = str_replace("%DAY%", $date->Day, $link);
$link = str_replace("%TITLE%", ToJaxpString($sr->Columns[$title_field]->Value)->ToFriendlyUrlText(), $link);
$link = str_replace("%ID%", $sr->Columns[$id_field]->Value, $link);
$this->Channel->AddItem(new JaxpRssFeedItem($date->ToFormattedString("d/m/Y H:i") . " - " . $sr->Columns[$title_field]->Value, $sr->Columns[$value_field]->Value, $link, $date));
}
}
/**
* Removes data from a table.
*
* @param $table JaxpMySqlTable
* Affected table.
*
* @param $conditions JaxpMySqlConditions
* Parameters for deletion.
*
* @return int
* Number of affected rows.
*
* @uses JaxpMySqlTable, JaxpMySqlConditions
* @access public
* @since 1.1
*/
function Delete(JaxpMySqlTable $table, JaxpMySqlConditions $conditions)
{
$sql_query_template = "DELETE FROM %s WHERE %s";
$destination_table = $table->TableName;
# Build SQL query for deletion.
foreach ($table->GetColumnNames(true) as $column_name) {
$c = $table->Columns[$column_name];
}
$where = $conditions->ParseToStringList();
$sql_query = sprintf($sql_query_template, $destination_table, $where);
# Execute query.
mysql_query('SET NAMES utf8');
mysql_query($sql_query);
# Return the number of affected rows.
return mysql_affected_rows();
}
