1146: Table 'articlej_secret.CMSI_video_details' doesn't exist select b.video_id, b.access_type from CMSI_video b LEFT JOIN CMSI_video_details a on a.video_id = b.video_id WHERE
b.status='1'
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, a.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, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
,
IF(b.no_of_downloads > 0, a.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/articlej/public_html/secretbuyer/members/classes/class.procedure.php on line 92
1054: Unknown column 'parent_cat_id' in 'field list' SELECT parent_cat_id, category, slug from CMSI_video_category where category_id='' Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/articlej/public_html/secretbuyer/members/classes/class.procedure.php on line 92
1146: Table 'articlej_secret.CMSI_video_details' doesn't exist select b.video_id, b.access_type from CMSI_video b LEFT JOIN CMSI_video_details a on a.video_id = b.video_id WHERE
b.status='1'
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, a.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, a.no_of_view_or_downloads_cnt < b.no_of_downloads,1)
,
IF(b.no_of_downloads > 0, a.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/articlej/public_html/secretbuyer/members/classes/class.procedure.php on line 92
function access_permission_text()
{
document.getElementById('access_permission').innerHTML="You Don't have download/access permission on this Video, please click here to upgrade your membership";
}
