From a27ddeff9e1b35344f4f18a0b2dad225cc01b784 Mon Sep 17 00:00:00 2001 From: Anthony Talarico Date: Tue, 1 May 2018 12:14:02 -0400 Subject: [PATCH] testing fix for import script, setting member ids to 0 if they don't have one --- models/admin/management/itemsImport.php | 11 ++++++++--- 1 file changed, 8 insertions(+), 3 deletions(-) diff --git a/models/admin/management/itemsImport.php b/models/admin/management/itemsImport.php index 1762fbe..847e7f4 100644 --- a/models/admin/management/itemsImport.php +++ b/models/admin/management/itemsImport.php @@ -139,11 +139,16 @@ class GlmMembersAdmin_management_itemsImport $forsale_sql = "SELECT * FROM forsale;"; $stmt = $dbh->query($forsale_sql); $forsale = $stmt->fetchAll(PDO::FETCH_ASSOC); - $count = 0; + $count = 0; $exists = false; foreach($forsale as $key=>$value){ - $sql = "SELECT id FROM $members_table WHERE old_member_id = " . $value['member']; - $new_id = $wpdb->get_var($sql); + if(!$value['member'] || $value['member'] !== ''){ + $sql = "SELECT id FROM $members_table WHERE old_member_id = " . $value['member']; + $new_id = $wpdb->get_var($sql); + }else { + $new_id = 0; + } + $parts = false; $res = false; -- 2.17.1