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(); }