Context Navigation

Changeset 1536495

Timestamp:

11/18/2016 06:52:33 PM (9 years ago)

Author:

seorets

Message:

Added $wpdb reference to inclusion methods for main class

Location:

seo-rets/branches/3.3.72

Files:

r1536471	r1536495
79	79	</div>
80	80	<?php
81		$sql = "SELECT * FROM ~~wp_~~sr_favorites WHERE user_id = " . $index;
	81	$sql = "SELECT * FROM {$wpdb->prefix}sr_favorites WHERE user_id = " . $index;
82	82	$res = SEO_RETS_Plugin::wpdbSelectResults($sql);
83	83	$sr = $this;

r1536471	r1536495
80	80
81	81	<?php
82		$sql = "SELECT * FROM ~~wp_~~sr_savesearch WHERE user_id = " . $index;
	82	$sql = "SELECT * FROM {$wpdb->prefix}sr_savesearch WHERE user_id = " . $index;
83	83	$res = SEO_RETS_Plugin::wpdbSelectResults($sql);
84	84

r1536471	r1536495
53	53	date_default_timezone_set("US/Central");
54	54
55		$sql_getListings = "SELECT * FROM ~~wp_~~sr_stat_mls WHERE mls=" . $_GET['mls'];
	55	$sql_getListings = "SELECT * FROM {$wpdb->prefix}sr_stat_mls WHERE mls=" . $_GET['mls'];
56	56	$res_getListings = $this->wpdbSelectResults($sql_getListings);
57	57	$ar = $res_getListings[0];

-                      r1536471
+                      r1536495
+    {
         global $wpdb;
         $wpdb->query("DELETE FROM `wp_options` where `option_name` LIKE '_transient_timeout_sr%' OR `option_name` LIKE '_transient_sr%';");
+        $wpdb->query("DELETE FROM `{$wpdb->prefix}options` where `option_name` LIKE '_transient_timeout_sr%' OR `option_name` LIKE '_transient_sr%';");
         $this->make_nonce();
 …
         $seo_rets_plugin = $this;
         global $wp_query;
+        global $wp_query,$wpdb;
         ob_start();
         $i = include("{$this->server_plugin_dir}/{$loc}");

-                      r1536471
+                      r1536495
         $users = get_option('sr_users');
         $sql_getListings = "SELECT * FROM wp_sr_stat_mls WHERE mls=" . $l->mls_id;
+        $sql_getListings = "SELECT * FROM {$wpdb->prefix}sr_stat_mls WHERE mls=" . $l->mls_id;
         $res_getListings = $sr->wpdbSelectResults($sql_getListings);
         if (empty($res_getListings)) {
 …
                 'mtype' => $type
             );
+            $lastId = $sr->wpdbInsertRow('wp_sr_stat_mls', $stat);
+            $lastId = $sr->wpdbInsertRow($wpdb->prefix . 'sr_stat_mls', $stat);
+            $sessionId = $sr->wpdbInsertRow($wpdb->prefix . 'sr_stat_sessions', $stat);
+        }
         $ar = $res_getListings[0];
 …
             'time' => date("Y-m-d H:i:s")
         );
         $sr->wpdbInsertRow('wp_sr_stat_option', $statOptAdd);
+        $sr->wpdbInsertRow($wpdb->prefix . 'sr_stat_option', $statOptAdd);
 //        if ($index !== false) {
 //            $users[$index]['favorites'];

Note: See TracChangeset for help on using the changeset viewer.