New script uploaded, yet a couple of problems

RayWilk · February 22, 2012, 12:34am

Hello, just uploaded a new script, yet a couple of problems,

if you go to: http://numberthree.netne.net/login.php

then Click on Stores at the top of the page and you will see one of the problems,

your help appreciated

ServerStorm · February 22, 2012, 2:32am

Hey Ray,

clicking the provide link give us ‘The site is under review for malicious content…’ message, so we can’t review it yet.

Steve

RayWilk · February 22, 2012, 2:57am

Hi

this link seems to be fine

http://numberthree.netne.net/index.php

wonshikee · February 22, 2012, 4:13am

The script shows exactly what’s wrong.

It’s a SQL error, caused by not having a limit start value

LIMIT , 20

Should be LIMIT 20 or LIMIT 0, 20.

RayWilk · February 22, 2012, 5:06am

Hello wonshikee, thank you for your reply

ok what do I do now?

in the stores.php I find this with a ‘limit’ search

Line 111: $limit = 20;

Line 115: $limit_link = ‘&start=’ . $start . ‘&limit=’ . $limit;

Line 117: $pagination = paginate($start, $limit, $nb_stores, ‘stores.php’, $additional_vars . $order_link);

LIne 123: ORDER BY " . $order_field . " " . $order_type . " LIMIT " . $start . ", " . $limit);

your help appreciated

wonshikee · February 22, 2012, 6:33am

put this on line 112 and move what’s currently on line 112 down
$start = (int) $start;

RayWilk · February 22, 2012, 8:05am

Fantastic Thank you wonshikee that corrected the problem.

ok now the next php with a Error message is: list_site_users.php

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: 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 ' 20' at line 9
SQL Query: SELECT u.user_id, u.name, u.username, u.email, u.active, u.approved, u.reg_date, u.payment_mode, u.balance, u.tax_account_type, u.tax_reg_number, u.tax_apply_exempt, u.tax_exempted, u.is_seller, u.preferred_seller, u.auction_approval, u.seller_verified, u.preferred_seller_exp_date, u.tax_company_name, c.name AS country_name, s.name AS state_name, u.mail_activated, u.bidder_verified FROM users u LEFT JOIN countries c ON u.country=c.id LEFT JOIN countries s ON u.state=s.id ORDER BY u.reg_date DESC LIMIT , 20

…

here is a limit search on the list_site_users.php

Line 45: $balance_v2 = 1; ## balance limit (debit balance option)

Line 156: c.parent_id=0 ORDER BY c.country_order ASC, c.name ASC LIMIT 1", ‘id’);

Line 416: $limit = 20;

Line 423: $limit_link = ‘&start=’ . $start . ‘&limit=’ . $limit;

Line 527: $template->set(‘query_results_message’, display_pagination_results($start, $limit, $nb_users));

Line 537: ORDER BY " . $order_field . " " . $order_type . " LIMIT " . $start . ", " . $limit);

Line 726: $pagination = paginate($start, $limit, $nb_users, ‘list_site_users.php’, $additional_vars . $order_link . $show_link);

Line 733: $template->set(‘page_order_username’, page_order(‘list_site_users.php’, ‘u.username’, $start, $limit, $additional_vars . $show_link,AMSG_USERNAME));

Line 734: $template->set(‘page_order_reg_date’, page_order(‘list_site_users.php’, ‘u.reg_date’, $start, $limit, $additional_vars . $show_link, AMSG_REG_DATE));

SpikeZ · February 22, 2012, 8:14am

remove the , between LIMIT and 20

Belsnickle · February 22, 2012, 8:17am

For starters you need to do the same thing you did to the other page here on line 417 this time because you’re filling limit with a variable. So long as that variable is either there or unassigned you’ll throw an SQL error.

RayWilk · February 22, 2012, 9:13am

Thank you Belsnickle, I thought to add the $start = (int) $start; line, just was not 100% sure,

I have added it, and the list_site_users.php is loading fine now

RayWilk · February 22, 2012, 9:15am

Now if you could help me solve the problem on the Sell and Wanted Ads pages.

http://numberthree.netne.net/index.php

On the Sell & Wanted Ads pages, you need to Select a Category. eg: Art - Modern

the Category Select does not complete, no On Click,

you will need to Register to access the Sell & Wanted Ads pages.

or PM me and I will send you a Log In Username & Password

all help and ideas greatly appreciated

RayWilk · February 23, 2012, 11:53pm

Hello

this is the Error message for the php shown below,

I have corrected other Errors, by adding: $start = (int) $start;

$limit = 20;
$start = (int) $start;

yet this php has no $limit = 20; line

your help appreciated

…
A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: 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 ' 10' at line 8
SQL Query: SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM auctions a FORCE INDEX(auctions_start_time) LEFT JOIN users u ON u.user_id=a.owner_id WHERE a.closed=0 AND a.active=1 AND a.approved=1 AND a.deleted=0 AND a.creation_in_progress=0 AND a.list_in!='store' AND a.closed=0 AND (a.list_in='auction' OR u.shop_active='1') GROUP BY a.auction_id ORDER BY a.start_time DESC LIMIT , 10

…

<?
#################################################################

PHP Pro Bid v6.05

##-------------------------------------------------------------##

auctions_show.php

##-------------------------------------------------------------##
#################################################################

session_start();

define (‘IN_SITE’, 1);

include_once (‘includes/global.php’);

include_once (‘global_header.php’);

$option = (in_array($_REQUEST[‘option’], array(‘featured’, ‘recent’, ‘popular’, ‘ending’))) ? $_REQUEST[‘option’] : ‘popular’;

switch ($option)
{
case ‘featured’:
$page_header_msg = MSG_FEATURED_AUCTIONS;
$where_query = “WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND
a.list_in!=‘store’ AND a.close_in_progress=0 AND a.hpfeat=1”;

	$order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'a.end_time'; 
	$order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'ASC'; 
	
	break;
case 'recent':
	$page_header_msg = MSG_RECENTLY_LISTED_AUCTIONS;
	$where_query = "WHERE a.closed=0 AND a.active=1 AND a.approved=1 AND a.deleted=0 AND 
		a.creation_in_progress=0 AND a.list_in!='store'";
	
	$order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'a.start_time'; 
	$order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'DESC'; 

	break;
case 'popular':
	$page_header_msg = MSG_POPULAR_AUCTIONS;
	$where_query = "WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND 
		a.list_in!='store' AND a.creation_in_progress=0 AND a.nb_bids&gt;0 ";
	//"WHERE a.closed=0 AND a.active=1 AND a.approved=1 AND a.deleted=0 AND a.crea"
	$order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'a.max_bid'; 
	$order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'DESC'; 
	break;
case 'ending':
	$page_header_msg = MSG_ENDING_SOON_AUCTIONS;
	$where_query = "WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND 
		a.list_in!='store' AND a.creation_in_progress=0";

	$order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'a.end_time'; 
	$order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'ASC'; 
	break;

}

$header_browse_auctions = header5($page_header_msg);
/**

below we have the variables that need to be declared in each separate browse page
*/
$page_url = ‘auctions_show’;

$order_field = (in_array($order_field, $auction_ordering)) ? $order_field : ‘a.end_time’;
$order_type = (in_array($order_type, $order_types)) ? $order_type : ‘ASC’;

$additional_vars = ‘&option=’ . $_REQUEST[‘option’];

include_once(‘includes/page_browse_auctions.php’);

include_once (‘global_footer.php’);

echo $template_output;

?>

wonshikee · February 24, 2012, 12:52am

You should take the time to understand why my solution (or even my first response) fixes your problem.

Once you understand it, you will be able to apply it to this problem as well.

RayWilk · February 24, 2012, 1:05am

Hello wonshikee

yes you are correct, I would like to understand the why, and how to fix,

ok so in the first Error we had: DESC LIMIT , 20 (use near ’ 20’ at line 9)

this time I have: DESC LIMIT , 10 (use near ’ 10’ at line 8)

you said: …

The script shows exactly what’s wrong.

It’s a SQL error, caused by not having a limit start value

LIMIT , 20

Should be LIMIT 20 or LIMIT 0, 20.

…

so this php is also missing a Limit Start value ?

RayWilk · February 24, 2012, 6:52am

Hello wonshikee

ok after lots of looking and trying to understand why I placed the ($start = (int) $start;) code 4 times here,

auctions_show.php

##-------------------------------------------------------------##
#################################################################

session_start();

define (‘IN_SITE’, 1);

include_once (‘includes/global.php’);

include_once (‘global_header.php’);

$option = (in_array($_REQUEST[‘option’], array(‘featured’, ‘recent’, ‘popular’, ‘ending’))) ? $_REQUEST[‘option’] : ‘popular’;

switch ($option)
{
case ‘featured’:
$page_header_msg = MSG_FEATURED_AUCTIONS;
$where_query = “WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND
a.list_in!=‘store’ AND a.close_in_progress=0 AND a.hpfeat=1”;
$start = (int) $start;
$order_field = ($_REQUEST[‘order_field’]) ? $_REQUEST[‘order_field’] : ‘a.end_time’;
$order_type = ($_REQUEST[‘order_type’]) ? $_REQUEST[‘order_type’] : ‘ASC’;

break;
case ‘recent’:
$page_header_msg = MSG_RECENTLY_LISTED_AUCTIONS;
$where_query = “WHERE a.closed=0 AND a.active=1 AND a.approved=1 AND a.deleted=0 AND
a.creation_in_progress=0 AND a.list_in!=‘store’”;
$start = (int) $start;
$order_field = ($_REQUEST[‘order_field’]) ? $_REQUEST[‘order_field’] : ‘a.start_time’;
$order_type = ($_REQUEST[‘order_type’]) ? $_REQUEST[‘order_type’] : ‘DESC’;

break;
case ‘popular’:
$page_header_msg = MSG_POPULAR_AUCTIONS;
$where_query = "WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND
a.list_in!=‘store’ AND a.creation_in_progress=0 AND a.nb_bids>0 ";
//“WHERE a.closed=0 AND a.active=1 AND a.approved=1 AND a.deleted=0 AND a.crea”
$start = (int) $start;
$order_field = ($_REQUEST[‘order_field’]) ? $_REQUEST[‘order_field’] : ‘a.max_bid’;
$order_type = ($_REQUEST[‘order_type’]) ? $_REQUEST[‘order_type’] : ‘DESC’;
break;
case ‘ending’:
$page_header_msg = MSG_ENDING_SOON_AUCTIONS;
$where_query = “WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0 AND
a.list_in!=‘store’ AND a.creation_in_progress=0”;
$start = (int) $start;
$order_field = ($_REQUEST[‘order_field’]) ? $_REQUEST[‘order_field’] : ‘a.end_time’;
$order_type = ($_REQUEST[‘order_type’]) ? $_REQUEST[‘order_type’] : ‘ASC’;
break;
}

$header_browse_auctions = header5($page_header_msg);
/**

below we have the variables that need to be declared in each separate browse page
*/
$page_url = ‘auctions_show’;

$order_field = (in_array($order_field, $auction_ordering)) ? $order_field : ‘a.end_time’;
$order_type = (in_array($order_type, $order_types)) ? $order_type : ‘ASC’;

$additional_vars = ‘&option=’ . $_REQUEST[‘option’];

include_once(‘includes/page_browse_auctions.php’);

include_once (‘global_footer.php’);

echo $template_output;

and it worked!

thank you

RayWilk · February 24, 2012, 8:22am

All is well

http://numberthree.netne.net/index.php

centered_effect · February 24, 2012, 11:52am

You sure?
http://numberthree.netne.net/categories.php?category=antiques-and-art&parent_id=215

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: 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 ' 10' at line 7
SQL Query: SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM auctions a LEFT JOIN users u ON u.user_id=a.owner_id WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.creation_in_progress=0 AND a.closed=0 AND (a.category_id IN (215, 216, 217, 218, 219, 220, 221, 222, 224, 223, 225, 226, 227, 228, 229, 230, 232, 231, 237, 233, 234, 235, 236, 238, 239, 240, 241, 242, 255, 243, 244, 245, 247, 248, 249, 246, 250, 254, 251, 252, 253, 256, 257, 258, 259, 261, 260, 262) OR a.addl_category_id IN (215, 216, 217, 218, 219, 220, 221, 222, 224, 223, 225, 226, 227, 228, 229, 230, 232, 231, 237, 233, 234, 235, 236, 238, 239, 240, 241, 242, 255, 243, 244, 245, 247, 248, 249, 246, 250, 254, 251, 252, 253, 256, 257, 258, 259, 261, 260, 262)) AND (a.list_in='auction' OR u.shop_active='1') GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT , 10

http://numberthree.netne.net/categories.php?category=collectables&parent_id=669

A Mysql error has occurred while running the script:

The query you are trying to run is invalid
Mysql Error Output: 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 ' 10' at line 7
SQL Query: SELECT a.auction_id, a.name, a.start_price, a.max_bid, a.nb_bids, a.currency, a.end_time, a.closed, a.bold, a.hl, a.buyout_price, a.is_offer, a.reserve_price, a.owner_id, a.postage_amount, a.fb_current_bid, a.auction_type, a.start_time, a.is_relisted_item, a.enable_swap FROM auctions a LEFT JOIN users u ON u.user_id=a.owner_id WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.creation_in_progress=0 AND a.closed=0 AND (a.category_id IN (669, 670, 672, 673, 674, 676, 677, 675, 678, 679, 680, 681, 671, 682, 688, 683, 684, 685, 686, 687, 2293, 689, 691, 692, 694, 693, 696, 695, 690, 697, 698, 699, 700, 703, 702, 701, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 715, 716, 717, 714, 718, 719, 720, 728, 721, 722, 723, 724, 725, 726, 727, 729, 731, 733, 732, 730, 734, 735, 736, 738, 737, 740, 741, 739, 742, 743, 746, 744, 745, 747, 749, 748, 750, 751, 752, 1878, 1880, 1881, 1882, 1902, 1883, 1884, 1885, 1886, 1887, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 769, 768, 770, 774, 773, 775, 771, 772, 776, 777, 778, 779, 781, 782, 780, 783, 784, 785, 786, 787, 789, 788, 790, 791, 792, 793, 794, 795, 796, 797, 799, 800, 801, 802, 803, 798, 804, 805, 806, 807, 809, 808, 812, 810, 811, 858, 859, 860, 861, 814, 813, 815, 753, 755, 754, 757, 756, 816, 817, 818, 819, 820, 825, 821, 823, 824, 822, 826, 828, 829, 830, 827, 836, 831, 833, 832, 834, 835, 843, 844, 1879, 1888, 1889, 1890, 1899, 1891, 1892, 1898, 1897, 1901, 1894, 1893, 1900, 1896, 1895, 837, 839, 840, 838, 841, 842, 845, 847, 846, 848, 849, 850, 851, 854, 856, 855, 852, 857, 853, 862, 863, 865, 866, 864, 867, 868, 869, 873, 870, 874, 876, 875, 872, 871) OR a.addl_category_id IN (669, 670, 672, 673, 674, 676, 677, 675, 678, 679, 680, 681, 671, 682, 688, 683, 684, 685, 686, 687, 2293, 689, 691, 692, 694, 693, 696, 695, 690, 697, 698, 699, 700, 703, 702, 701, 704, 705, 706, 707, 708, 709, 710, 711, 712, 713, 715, 716, 717, 714, 718, 719, 720, 728, 721, 722, 723, 724, 725, 726, 727, 729, 731, 733, 732, 730, 734, 735, 736, 738, 737, 740, 741, 739, 742, 743, 746, 744, 745, 747, 749, 748, 750, 751, 752, 1878, 1880, 1881, 1882, 1902, 1883, 1884, 1885, 1886, 1887, 758, 759, 760, 761, 762, 763, 764, 765, 766, 767, 769, 768, 770, 774, 773, 775, 771, 772, 776, 777, 778, 779, 781, 782, 780, 783, 784, 785, 786, 787, 789, 788, 790, 791, 792, 793, 794, 795, 796, 797, 799, 800, 801, 802, 803, 798, 804, 805, 806, 807, 809, 808, 812, 810, 811, 858, 859, 860, 861, 814, 813, 815, 753, 755, 754, 757, 756, 816, 817, 818, 819, 820, 825, 821, 823, 824, 822, 826, 828, 829, 830, 827, 836, 831, 833, 832, 834, 835, 843, 844, 1879, 1888, 1889, 1890, 1899, 1891, 1892, 1898, 1897, 1901, 1894, 1893, 1900, 1896, 1895, 837, 839, 840, 838, 841, 842, 845, 847, 846, 848, 849, 850, 851, 854, 856, 855, 852, 857, 853, 862, 863, 865, 866, 864, 867, 868, 869, 873, 870, 874, 876, 875, 872, 871)) AND (a.list_in='auction' OR u.shop_active='1') GROUP BY a.auction_id ORDER BY a.list_in ASC, a.end_time ASC LIMIT , 10

Looks like the same problem - LIMIT , 10. Check your other pages/scripts.

RayWilk · February 24, 2012, 12:59pm

Hello centered effect

thank you for looking in at my site,

below is the categories.php

all help appreciated

<?
#################################################################

PHP Pro Bid v6.10

##-------------------------------------------------------------##

categories.php

##-------------------------------------------------------------##
#################################################################

session_start();

define (‘IN_SITE’, 1);

include_once (‘includes/global.php’);
include_once (‘includes/class_formchecker.php’);
include_once (‘includes/class_custom_field.php’);

$parent_id = intval($_REQUEST[‘parent_id’]);
$is_category = $db->count_rows(‘categories’, “WHERE category_id='” . $parent_id . “'”);
$parent_id = ($is_category) ? $parent_id : 0;
$_REQUEST[‘parent_id’] = $parent_id;

$user_id = intval($_REQUEST[‘user_id’]);

$protected_page = protected_page(0, $parent_id);

if ($protected_page[‘private_category’] && !category_logged_in($parent_id))
{
header_redirect(‘protected_page.php?redirect_url=categories&category_id=’ . $parent_id);
}
else
{
include_once (‘global_header.php’);

$template-&gt;set('parent_id', $parent_id);
	
define('IS_CATEGORIES', 1);
				
$main_category_id = $db-&gt;main_category($parent_id);
$category_details = $db-&gt;get_sql_row("SELECT image_path, minimum_age FROM " . DB_PREFIX . "categories 
	WHERE category_id='" . $main_category_id . "'");

$category_logo = $category_details['image_path'];	
$category_logo = (!empty($category_logo)) ? '&lt;img src="' . $category_logo . '" border="0"&gt;' : '';
$template-&gt;set('category_logo', $category_logo);

$categories_header_menu = category_navigator($parent_id, true, true, 'categories.php');
$template-&gt;set('categories_header_menu', $categories_header_menu);

if ($_REQUEST['option'] == 'agree_adult')
{
	$session-&gt;set('adult_category', 1);	
}

if ($category_details['minimum_age'] &gt; 0 && !$session-&gt;value('adult_category'))
{
	$template-&gt;set('minimum_age', $category_details['minimum_age']);
	$template_output .= $template-&gt;process('adult_category_warning.tpl.php');
}
else 
{		
	$src_details = array_merge($_GET, $_POST);
	$src_details = $db-&gt;rem_special_chars_array($src_details);
	
	/**
	 * featured items, recently listed and ending soon code
	 */
	if ($layout['catfeat_nb'])
	{
		(array) $item_details = null;

		$where_query = " WHERE a.active=1 AND a.approved=1 AND a.closed=0 AND a.deleted=0
			AND a.list_in!='store' AND a.catfeat='1'";
		$where_query = browse_filter_query($src_details, $where_query);					
		
		$template-&gt;set('featured_columns', min((floor($db-&gt;count_rows('auctions a', $select_condition)/$layout['catfeat_nb']) + 1), ceil($layout['catfeat_max']/$layout['catfeat_nb'])));
	
		$item_details = $db-&gt;random_rows('auctions a', 'a.auction_id, a.name, a.start_price, a.max_bid, a.currency, a.end_time', $where_query, $layout['catfeat_max']);
		$template-&gt;set('item_details', $item_details);
	}
	
	/**
	 * shop in stores code snippet
	 */
	
	if ($parent_id)
	{
		$where_query = " WHERE a.active=1 AND a.approved=1 
			AND a.closed=0 AND a.deleted=0 AND	a.list_in!='auction' 
			AND a.owner_id=us.user_id AND us.active='1' AND us.shop_active='1' AND us.shop_name!=''";
		$where_query = browse_filter_query($src_details, $where_query);					
		
		$sql_select_stores = $db-&gt;query("SELECT us.user_id, us.shop_name FROM 
			" . DB_PREFIX . "users us, " . DB_PREFIX . "auctions a 
			" . $where_query . " 
			GROUP BY us.user_id");
		
		$is_shop_stores = $db-&gt;num_rows($sql_select_stores);
		$template-&gt;set('is_shop_stores', $is_shop_stores);
		
		if ($is_shop_stores)
		{
			(string) $shop_stores_content = null;
			while ($store_details = $db-&gt;fetch_array($sql_select_stores))
			{
				$background = ($counter++%2) ? 'c1' : 'c2';
			
				$shop_stores_content .= '&lt;tr&gt; '.
					'	&lt;td width="100%" class="contentfont"&gt;&nbsp;&raquo;&nbsp;&lt;a href="shop.php?user_id=' . $store_details['user_id'] . '&parent_id=' . $parent_id . '"&gt;' . $store_details['shop_name'] . '&lt;/a&gt;&lt;/td&gt; '.
					'&lt;/tr&gt; ';					
			}
			
			$template-&gt;set('shop_stores_content', $shop_stores_content);
		}
	}
	$categories_header .= $template-&gt;process('categories_header.tpl.php');
	$categories_footer = $template-&gt;process('categories_footer.tpl.php');
			
	/**
	 * below we have the variables that need to be declared in each separate browse page
	 */
	$page_url = 'categories';
	
	$where_query = " WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.creation_in_progress=0";
	
	$order_field = (in_array($_REQUEST['order_field'], $auction_ordering)) ? $_REQUEST['order_field'] : 'a.end_time'; 
	$order_type = (in_array($_REQUEST['order_type'], $order_types)) ? $_REQUEST['order_type'] : 'ASC';
	
	$template-&gt;set('categories_header', $categories_header);
	$template-&gt;set('categories_footer', $categories_footer);
	
	include_once('includes/page_browse_auctions.php');
}

include_once ('global_footer.php');

echo $template_output;

}
?>

RayWilk · February 24, 2012, 1:33pm

Ok I seem to have corrected it by adding the red line below

/**

below we have the variables that need to be declared in each separate browse page
*/
$page_url = ‘categories’;

$where_query = " WHERE a.active=1 AND a.approved=1 AND a.deleted=0 AND a.creation_in_progress=0";
$start = (int) $start;
$order_field = (in_array($_REQUEST[‘order_field’], $auction_ordering)) ? $_REQUEST[‘order_field’] : ‘a.end_time’;
$order_type = (in_array($_REQUEST[‘order_type’], $order_types)) ? $_REQUEST[‘order_type’] : ‘ASC’;

$template->set(‘categories_header’, $categories_header);
$template->set(‘categories_footer’, $categories_footer);

include_once(‘includes/page_browse_auctions.php’);
}

include_once (‘global_footer.php’);

echo $template_output;
}
?>

system · October 8, 2014, 2:00am