Changeset 3147276

Timestamp:

09/05/2024 08:51:03 PM (18 months ago)

Author:

matthewrubin

Message:

minor bug fixes

Location:

review-manager

Files:

• tags/2.2/activate.php (modified) (2 diffs)
• tags/2.2/admin/setting.php (modified) (1 diff)
• tags/2.2/include/function.php (modified) (2 diffs)
• tags/2.2/review-manager.php (modified) (2 diffs)
• trunk/activate.php (modified) (2 diffs)
• trunk/admin/setting.php (modified) (1 diff)
• trunk/include/function.php (modified) (2 diffs)
• trunk/review-manager.php (modified) (2 diffs)

review-manager/tags/2.2/activate.php

@@ -69 +69 @@
                 source varchar(50) CHARACTER SET utf8 DEFAULT NULL,
                 location varchar(150) CHARACTER SET utf8 DEFAULT NULL,
-                group varchar(100) CHARACTER SET utf8 DEFAULT NULL,
+                review_group varchar(100) CHARACTER SET utf8 DEFAULT NULL,
                 author varchar(50) CHARACTER SET utf8 DEFAULT NULL,
                 rating varchar(5) CHARACTER SET utf8 DEFAULT NULL,
@@ -112 +112 @@
     // v:2.2             
     $review_row_3 = $wpdb->get_results("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
-        WHERE table_name = '$table_mryrm_reviews' AND column_name = 'group'");
+        WHERE table_name = '$table_mryrm_reviews' AND column_name = 'review_group'");
     if (empty($review_row_3)) {
         $review_alter_3 = "ALTER TABLE {$wpdb->prefix}mryrm_reviews 
-        ADD `group` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL  AFTER `location`;";
+        ADD `review_group` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL  AFTER `location`;";
         $wpdb->query($review_alter_3);
     }

review-manager/tags/2.2/admin/setting.php

@@ -159 +159 @@
                             'source' => stripcslashes(esc_sql($obj->source)),
                             'location' => stripcslashes(esc_sql($location)), 
-                            'group' => stripcslashes(esc_sql($obj->review_group)),
+                            'review_group' => stripcslashes(esc_sql($obj->review_group)),
                             'author' => stripcslashes(esc_sql($obj->author)),
                             'rating' => $obj->rating,

review-manager/tags/2.2/include/function.php

@@ -228 +228 @@
         $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE location = '$location' ORDER BY created_at DESC"; 
     }else if($group != ''){
-        $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE group = '$group' ORDER BY created_at DESC";
+        $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE review_group = '$group' ORDER BY created_at DESC";
     }else if($city != ''){
         $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE city = '$city' ORDER BY created_at DESC";
@@ -242 +242 @@
             $obj->source = trim($item->source);
             $obj->location = trim($item->location);
-            $obj->group = trim($item->group);
+            $obj->review_group = trim($item->review_group);
             $obj->author = trim($item->author);
             $obj->rating = trim($item->rating);

review-manager/tags/2.2/review-manager.php

@@ -137 +137 @@
             'source' => stripcslashes(esc_sql($obj['source'])),
             'location' => stripcslashes(esc_sql($location)),
-            'group' => stripcslashes(esc_sql($obj['review_group'])),
+            'review_group' => stripcslashes(esc_sql($obj['review_group'])),
             'author' => stripcslashes(esc_sql($obj['author'])),
             'rating' => $obj['rating'],
@@ -237 +237 @@
                 'source' => stripcslashes(esc_sql($obj['source'])),
                 'location' => stripcslashes(esc_sql($location)),
-                'group' => stripcslashes(esc_sql($obj['review_group'])),
+                'review_group' => stripcslashes(esc_sql($obj['review_group'])),
                 'author' => stripcslashes(esc_sql($obj['author'])),
                 'rating' => $obj['rating'],

review-manager/trunk/activate.php

@@ -69 +69 @@
                 source varchar(50) CHARACTER SET utf8 DEFAULT NULL,
                 location varchar(150) CHARACTER SET utf8 DEFAULT NULL,
-                group varchar(100) CHARACTER SET utf8 DEFAULT NULL,
+                review_group varchar(100) CHARACTER SET utf8 DEFAULT NULL,
                 author varchar(50) CHARACTER SET utf8 DEFAULT NULL,
                 rating varchar(5) CHARACTER SET utf8 DEFAULT NULL,
@@ -112 +112 @@
     // v:2.2             
     $review_row_3 = $wpdb->get_results("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS
-        WHERE table_name = '$table_mryrm_reviews' AND column_name = 'group'");
+        WHERE table_name = '$table_mryrm_reviews' AND column_name = 'review_group'");
     if (empty($review_row_3)) {
         $review_alter_3 = "ALTER TABLE {$wpdb->prefix}mryrm_reviews 
-        ADD `group` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL  AFTER `location`;";
+        ADD `review_group` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL  AFTER `location`;";
         $wpdb->query($review_alter_3);
     }

review-manager/trunk/admin/setting.php

@@ -159 +159 @@
                             'source' => stripcslashes(esc_sql($obj->source)),
                             'location' => stripcslashes(esc_sql($location)), 
-                            'group' => stripcslashes(esc_sql($obj->review_group)),
+                            'review_group' => stripcslashes(esc_sql($obj->review_group)),
                             'author' => stripcslashes(esc_sql($obj->author)),
                             'rating' => $obj->rating,

review-manager/trunk/include/function.php

@@ -228 +228 @@
         $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE location = '$location' ORDER BY created_at DESC"; 
     }else if($group != ''){
-        $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE group = '$group' ORDER BY created_at DESC";
+        $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE review_group = '$group' ORDER BY created_at DESC";
     }else if($city != ''){
         $review_sql = "SELECT * FROM {$wpdb->prefix}mryrm_reviews WHERE city = '$city' ORDER BY created_at DESC";
@@ -242 +242 @@
             $obj->source = trim($item->source);
             $obj->location = trim($item->location);
-            $obj->group = trim($item->group);
+            $obj->review_group = trim($item->review_group);
             $obj->author = trim($item->author);
             $obj->rating = trim($item->rating);

review-manager/trunk/review-manager.php

@@ -137 +137 @@
             'source' => stripcslashes(esc_sql($obj['source'])),
             'location' => stripcslashes(esc_sql($location)),
-            'group' => stripcslashes(esc_sql($obj['review_group'])),
+            'review_group' => stripcslashes(esc_sql($obj['review_group'])),
             'author' => stripcslashes(esc_sql($obj['author'])),
             'rating' => $obj['rating'],
@@ -237 +237 @@
                 'source' => stripcslashes(esc_sql($obj['source'])),
                 'location' => stripcslashes(esc_sql($location)),
-                'group' => stripcslashes(esc_sql($obj['review_group'])),
+                'review_group' => stripcslashes(esc_sql($obj['review_group'])),
                 'author' => stripcslashes(esc_sql($obj['author'])),
                 'rating' => $obj['rating'],