function rowsForRef(BfoxRef $ref)
{
global $wpdb;
$tableName = $wpdb->escape($this->tableName);
$indexCol = $wpdb->escape($this->indexCol);
$indexCol2 = $wpdb->escape($this->indexCol2);
if (empty($indexCol2)) {
$refWhere = $ref->sql_where($indexCol);
} else {
$refWhere = $ref->sql_where2($indexCol, $indexCol2);
}
$sql = $wpdb->prepare("SELECT * FROM {$tableName} WHERE {$refWhere}");
$rows = $wpdb->get_results($sql);
return $rows;
}
public function set_ref(BfoxRef $ref)
{
if ($ref->is_valid()) {
$this->ref_str = $ref->get_string();
$this->ref_where = 'AND ' . $ref->sql_where();
$this->description .= ' in ' . $this->ref_str;
}
}
/**
* Return verse content for the given bible ref with minimum formatting
*
* @param BfoxRef $ref
* @return string
*/
public function get_verse_content(BfoxRef $ref)
{
// Get the verse data from the bible translation
$formatter = new BfoxVerseFormatter();
return $this->get_verses($ref->sql_where(), $formatter);
}
