Support » Plugin: Mail Subscribe List » mysql_query problem

  • Resolved inpariswithyou

    (@inpariswithyou)


    Relates to this other issue

    Line 272 of the sml.php file uses mysql_query, which is deprecated, and causes MySQL errors to pop up on the page.

    I fixed this changing lines 272-274 to this:

    $exists = $wpdb->query("SELECT * FROM ".$wpdb->prefix."sml where sml_email like '".$wpdb->escape($email)."' limit 1");
    if ($exists < 1) {
    	$wpdb->query("insert into ".$wpdb->prefix."sml (sml_name, sml_email) values ('".$wpdb->escape($name)."', '".$wpdb->escape($email)."')");
    }

    You may want to incorporate a fix into the actual plugin, so this problem doesn’t persist for other people.

    https://wordpress.org/plugins/mail-subscribe-list/

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘mysql_query problem’ is closed to new replies.