AdsManager: поиск по цене (от и до) - страница 3 - AdsManager

case 'price':
echo "от <input class='inputbox' type='text' size='10' maxlength='20' name='".$field->name."_ot' /> до <input class='inputbox' type='text' size='10' maxlength='20' name='".$field->name."_do' />";
break;

case 'price':
	echo '<input class="inputbox" type="text" size="10" maxlength="20" name="'.$field->name.'_ot" value="от" onblur="if(this.value==\'\') this.value=\'от\';" onfocus="if(this.value==\'от\') this.value=\'\';"/>'.
	'  <input class="inputbox" type="text" size="10" maxlength="20" name="'.$field->name.'_do" value="до" onblur="if(this.value==\'\') this.value=\'до\';" onfocus="if(this.value==\'до\') this.value=\'\';"/>';
	break;

500 - JDatabaseMySQL::query: 1054 - Unknown column '1й' in 'where clause' SQL=SELECT a.id FROM nean7_adsmanager_ads as a INNER JOIN nean7_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN nean7_users as u ON a.userid = u.id INNER JOIN nean7_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN nean7_adsmanager_categories as p ON c.parent = p.id WHERE 1 AND a.ad_price>=1й AND a.published = 1 GROUP BY a.id

Вы не можете посетить текущую страницу по причине:
просроченная закладка/избранное
поисковый механизм, у которого просрочен список для этого сайта
пропущен адрес
у вас нет права доступа на эту страницу
Запрашиваемый ресурс не найден.
В процессе обработки вашего запроса произошла ошибка.

Пожалуйста, перейдите на одну из следующих страниц:
Домашняя страница

Если проблемы продолжатся, пожалуйста, обратитесь к системному администратору сайта и сообщите об ошибке, описание которой приведено ниже..

JDatabaseMySQL::query: 1054 - Unknown column '1й' in 'where clause' SQL=SELECT a.id FROM nean7_adsmanager_ads as a INNER JOIN nean7_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN nean7_users as u ON a.userid = u.id INNER JOIN nean7_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN nean7_adsmanager_categories as p ON c.parent = p.id WHERE 1 AND a.ad_price>=1й AND a.published = 1 GROUP BY a.id
Call stack
#	Function	Location
1	JSite->dispatch()	***/www/index.php:42
2	JComponentHelper::renderComponent()	***/www/includes/application.php:197
3	JComponentHelper::executeComponent()	***/www/libraries/joomla/application/component/helper.php:351
4	require_once()	***/www/libraries/joomla/application/component/helper.php:383
5	JController->execute()	***/www/components/com_adsmanager/adsmanager.php:27
6	AdsManagerController->display()	***/www/libraries/joomla/application/component/controller.php:761
7	JController->display()	***/www/components/com_adsmanager/controller.php:143
8	AdsmanagerViewResult->display()	***/www/libraries/joomla/application/component/controller.php:722
9	AdsmanagerModelContent->getNbContents()	***/www/components/com_adsmanager/views/result/view.html.php:147
10	JDatabase->loadObjectList()	***/www/administrator/components/com_adsmanager/models/content.php:351
11	JDatabaseMySQL->execute()	***/www/libraries/joomla/database/database.php:1100
12	JError::raiseError()	***/www/libraries/joomla/database/database/mysql.php:548
13	JError::raise()	***/www/libraries/joomla/error/error.php:251


Консоль отладки Joomla!
Ошибки
JDatabaseMySQL::query: 1054 - Unknown column '1й' in 'where clause' SQL=SELECT a.id FROM nean7_adsmanager_ads as a INNER JOIN nean7_adsmanager_adcat as adcat ON adcat.adid = a.id LEFT JOIN nean7_users as u ON a.userid = u.id INNER JOIN nean7_adsmanager_categories as c ON adcat.catid = c.id LEFT JOIN nean7_adsmanager_categories as p ON c.parent = p.id WHERE 1 AND a.ad_price>=1й AND a.published = 1 GROUP BY a.idCall stack
#	Function	Location
1	JSite->dispatch()	JROOT/index.php:42
2	JComponentHelper::renderComponent()	JROOT/includes/application.php:197
3	JComponentHelper::executeComponent()	JROOT/libraries/joomla/application/component/helper.php:351
4	require_once()	JROOT/libraries/joomla/application/component/helper.php:383
5	JController->execute()	JROOT/components/com_adsmanager/adsmanager.php:27
6	AdsManagerController->display()	JROOT/libraries/joomla/application/component/controller.php:761
7	JController->display()	JROOT/components/com_adsmanager/controller.php:143
8	AdsmanagerViewResult->display()	JROOT/libraries/joomla/application/component/controller.php:722
9	AdsmanagerModelContent->getNbContents()	JROOT/components/com_adsmanager/views/result/view.html.php:147
10	JDatabase->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/content.php:351
11	JDatabaseMySQL->execute()	JROOT/libraries/joomla/database/database.php:1100
12	JError::raiseError()	JROOT/libraries/joomla/database/database/mysql.php:548
13	JError::raise()	JROOT/libraries/joomla/error/error.php:251

Сессия

Warning: Invalid argument supplied for foreach() in ***/administrator/components/com_adsmanager/models/content.php on line 287

<script language="javascript" type="text/javascript">
function submitbutton() {
	var form = document.forms["Forma"];
	var r = new RegExp("[^0-9\.,]", "i");

	// do field validation
	if (r.exec(form.ad_komnat_ot.value)) {
	alert( "В поля можно вводить только цифры" );
	} else if (r.exec(form.ad_komnat_do.value)) {
	alert( "В поля можно вводить только цифры" );
	} else if (r.exec(form.ad_price_ot.value)) {
	alert( "В поля можно вводить только цифры" );
	} else if (r.exec(form.ad_price_do.value)) {
	alert( "В поля можно вводить только цифры" );
	} else {
      form.submit();
	}
	
}
</script>

case 'price':
echo "от <input class='inputbox' type='text' size='10' maxlength='20' name='".$field->name."_ot' /> до <input class='inputbox' type='text' size='10' maxlength='20' name='".$field->name."_do' />";
break;

case 'price':
echo "от <input class='inputbox' type='text' test="number" size='10' maxlength='20' name='".$field->name."_ot' /> до <input class='inputbox' type='text' test="number" size='10' maxlength='20' name='".$field->name."_do' />";
break;

$("#ad_price_ot, #ad_price_do")

$("input[test=number]")

onkeydown='return validation();'

function validation(){
	if ((event.keyCode>47 && event.keyCode<58)||(event.keyCode>95 && event.keyCode<106)||(event.keyCode==46)||(event.keyCode==8)||(event.keyCode==37)||(event.keyCode==39))
		return true;
	else 
		return false;
}