Ошибка: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `fieldcode` = '17'' at line 1
class modDatingSearchHelper
{
function getGenderValue( $fieldcode )
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query ="SELECT " . $db->Quotename("options"). " ";
$query ="FROM " . $db->Quotename("#__community_fields")." ";
$query ="WHERE " . $db->Quotename("fieldcode"). " = " . $db->quote($fieldcode);
$db->setQuery($query);
$results = $db->loadResult();
if($db->getErrorNum()) {
JError::raiseError( 500, $db->stderr() );
}
$options = array();
$options = explode("\n", $results);
array_walk($options, array( 'JString' , 'trim' ) );
return $options;
}
function getCountryValue( $fieldcode )
{
// retrieve field details
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query ="SELECT * FROM " . $db->Quotename("#__community_fields")." ";
$query ="WHERE " . $db->Quotename("fieldcode"). " = " . $db->quote($fieldcode);
$db->setQuery($query);
$results = $db->loadResult();
if($db->getErrorNum()) {
JError::raiseError( 500, $db->stderr() );
}
// load countries from XML
jimport( 'joomla.filesystem.file' );
$file = JPATH_ROOT . DS . 'components' . DS . 'com_community' . DS . 'libraries' . DS . 'fields' . DS . 'countries.xml';
$options = array();
if( JFile::exists( $file ) )
{
$contents = JFile::read( $file );
$parser =& JFactory::getXMLParser('Simple');
$parser->loadFile( $file );
$document =& $parser->document;
$element =& $document->getElementByPath( 'countries' );
$countries = $element->children();
foreach($countries as $country )
{
$options[] = $country->getElementByPath('name')->data();
}
}
array_walk($options, array( 'JString' , 'trim' ) );
return $options;
}
function getFieldType($fieldcode)
{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query ="SELECT " . $db->Quotename("type"). ", " . $db->Quotename("fieldcode"). " ";
$query = "FROM " . $db->Quotename("#__community_fields")." ";
$db->setQuery( $sql );
$results = $db->loadObjectList();
$type = new stdClass();
foreach($fieldcode as $key=>$field)
{
foreach($results as $data)
{
if($field == $data->fieldcode)
{
$type->$key = $data->type;
}
}
}
return $type;
}
}