[cravendale]

Hi,

The code you mentioned to change was already correct in my existing raffles.php file....

	else
	{
		$oldentryopt = "WHERE enddate > $timenow";
	}
	
	$getraffle = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "raffle
		WHERE startdate <= $timenow
		$oldentryopt
		ORDER BY id DESC

I've just checked the " turn off Show Raffles Already Drawn in raffle settings" and it's already turned off and was never on at the point this error was generated.

Originally Posted by nhawk

Edit raffles.php and find this..

if($_REQUEST['do'] == 'main')
{
	require_once(DIR . '/includes/class_bbcode.php');
	$parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());
	$allow_view = true;
	$timenow = TIMENOW;
	if($vbulletin->options['raffle_showold'])
	{
		$oldentryopt = '';
	}
	else
	{
		$oldentryopt = "AND enddate > $timenow";
	}
	$getraffle = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "raffle
		WHERE startdate <= $timenow
		$oldentryopt
		ORDER BY id DESC
	");

Make sure this part says what I show here...

$oldentryopt = "AND enddate > $timenow";

NOT

$oldentryopt = "WHERE enddate > $timenow";

I don't know why your copy would say 'WHERE' but if it does, change it to 'AND'.

If that's not the problem then turn off Show Raffles Already Drawn in raffle settings. I'll have to dig into it to find out why your system has problems with that code.