$SQL = “SELECT “.$wpdb->prefix.”posts.ID, mt2.meta_value FROM “.$wpdb->prefix.”posts
LEFT JOIN “.$wpdb->prefix.”postmeta AS mt2 ON (“.$wpdb->prefix.”posts.ID = mt2.post_id AND mt2.meta_key = ‘packageID’)
WHERE “.$wpdb->prefix.”posts.post_type = ‘”.THEME_TAXONOMY.”_type’
AND ( “.$wpdb->prefix.”posts.post_status = ‘draft’ OR “.$wpdb->prefix.”posts.post_status = ‘publish’ )
AND mt2.meta_key IS NULL
GROUP BY “.$wpdb->prefix.”posts.ID”;
LINE 52 $result = mysql_query($SQL, $wpdb->dbh);
LINE 53 if (mysql_num_rows($result) > 0) {
while ($val = mysql_fetch_object($result)){
update_post_meta($val->ID,’packageID’,$_POST[‘to’]);
}
}
I get an error when going to;
Theme setup>Listing Packages>Statistics
Choosing ‘Transfer Listings’ ‘Everything Else’>’Custom’
Warning: mysqli_query() expects parameter 1 to be mysqli, string given in /REDACTED/themes/CT/framework/admin/_5.php on line 52
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /REDACTED/themes/CT/framework/admin/_5.php on line 53
if(isset($_POST[‘TransferFormListings’]) && is_numeric($_POST[‘from’]) && is_numeric($_POST[‘to’])){
if($_POST[‘from’] == “-2”){
$SQL = “SELECT “.$wpdb->prefix.”posts.ID, mt2.meta_value FROM “.$wpdb->prefix.”posts
LEFT JOIN “.$wpdb->prefix.”postmeta AS mt2 ON (“.$wpdb->prefix.”posts.ID = mt2.post_id AND mt2.meta_key = ‘packageID’)
WHERE “.$wpdb->prefix.”posts.post_type = ‘”.THEME_TAXONOMY.”_type’
AND ( “.$wpdb->prefix.”posts.post_status = ‘draft’ OR “.$wpdb->prefix.”posts.post_status = ‘publish’ )
AND mt2.meta_key IS NULL
GROUP BY “.$wpdb->prefix.”posts.ID”;
LINE 52 $result = mysql_query($SQL, $wpdb->dbh);
LINE 53 if (mysql_num_rows($result) > 0) {
while ($val = mysql_fetch_object($result)){
update_post_meta($val->ID,’packageID’,$_POST[‘to’]);
}
}
Wondering if this is a bug
Members Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login NowMembers Only Content
This reply is for PremiumPress customers only.
Login Now