1054: Unknown column 'b.membership_id' in 'where clause' select b.article_id, b.access_type from CMSI_AM_article b WHERE
b.status='A'
AND
IF(b.access_type = 'H'
,
b.membership_id LIKE '%{-1}%' AND
/* CASE D */
CASE b.visibilty_type WHEN 'D' THEN
IF( (RTRIM( LTRIM( b.visibilty_date ) ) <> '' AND b.visibilty_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= b.visibilty_date , 1 )
AND IF( (RTRIM( LTRIM( b.expiry_date ) ) <> '' AND b.expiry_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) <= b.expiry_date, 1 )
AND IF( b.no_of_downloads >0, b.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 )
/* CASE R */
WHEN 'R' THEN
IF(b.visibilty_days > 0 OR b.visible_upto_days > 0,
'' <> '' AND
IF(b.visibilty_days > 0, DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= DATE_ADD('0000-00-00', INTERVAL b.visibilty_days DAY), 1) AND
IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('0000-00-00', INTERVAL (b.visibilty_days + b.visible_upto_days) DAY),1) AND
IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
,
IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
)
/* CASE '' */
WHEN '' THEN b.membership_id LIKE '%{-1}%' END
,
1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/register/public_html/knightstavern/classes/class.procedure.php on line 92
1054: Unknown column 'b.membership_id' in 'where clause' select b.article_id, b.access_type from CMSI_AM_article b WHERE
b.status='A'
AND
IF(b.access_type = 'H'
,
b.membership_id LIKE '%{-1}%' AND
/* CASE D */
CASE b.visibilty_type WHEN 'D' THEN
IF( (RTRIM( LTRIM( b.visibilty_date ) ) <> '' AND b.visibilty_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= b.visibilty_date , 1 )
AND IF( (RTRIM( LTRIM( b.expiry_date ) ) <> '' AND b.expiry_date <> '0000-00-00') , DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) <= b.expiry_date, 1 )
AND IF( b.no_of_downloads >0, b.no_of_view_or_downloads_cnt < b.no_of_downloads, 1 )
/* CASE R */
WHEN 'R' THEN
IF(b.visibilty_days > 0 OR b.visible_upto_days > 0,
'' <> '' AND
IF(b.visibilty_days > 0, DATE_FORMAT( NOW( ) , '%Y-%m-%d' ) >= DATE_ADD('0000-00-00', INTERVAL b.visibilty_days DAY), 1) AND
IF(b.visible_upto_days > 0, DATE_FORMAT( NOW() , '%Y-%m-%d' ) <= DATE_ADD('0000-00-00', INTERVAL (b.visibilty_days + b.visible_upto_days) DAY),1) AND
IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
,
IF(b.no_of_downloads > 0, b.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
)
/* CASE '' */
WHEN '' THEN b.membership_id LIKE '%{-1}%' END
,
1 )
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/register/public_html/knightstavern/classes/class.procedure.php on line 92 Knights Tavern - Living History and Reenactment - Articles
