← All changes | class-db-resetter.php +8 -9 3.22 → 3.21 View file →

		@@ -72,10 +72,9 @@
72	72	global $wpdb;
73	73	$this->backup = array();
74	74
75	75	foreach ($tables as $table) {
76		- $wpdb->wp_database_reset_table = $table;
77		- $this->backup[$table] = $wpdb->get_results("SELECT * FROM {$wpdb->wp_database_reset_table}");
	76	+ $this->backup[$table] = $wpdb->get_results("SELECT * FROM {$table}");
78	77	}
79	78	}
80	79
81	80	private function set_user_session_tokens()
		@@ -147,10 +146,10 @@
147	146
148	147	$wpdb->query(
149	148	$wpdb->prepare(
150	149	"UPDATE $wpdb->users
151		- SET user_pass = %s, user_activation_key = ''
152		- WHERE ID = %d",
	150	+ SET user_pass = '%s', user_activation_key = ''
	151	+ WHERE ID = '%d'",
153	152	$this->user->user_pass,
154	153	$user_id
155	154	)
156	155	);
		@@ -181,10 +180,9 @@
181	180	{
182	181	global $wpdb;
183	182
184	183	foreach ($tables as $table) {
185		- $wpdb->wp_database_reset_table = $table;
186		- $wpdb->query("DELETE FROM {$wpdb->wp_database_reset_table}");
	184	+ $wpdb->query("DELETE FROM {$table}");
187	185	}
188	186	}
189	187
190	188	private function restore_backup_tables(array $tables)
		@@ -192,15 +190,16 @@
192	190	global $wpdb;
193	191
194	192	foreach ($tables as $table => $data) {
195	193	foreach ($data as $row) {
196		- $data = array();
	194	+ $columns = $values = array();
197	195
198	196	foreach ($row as $column => $value) {
199		- $data[$column] = $value;
	197	+ $columns[] = $column;
	198	+ $values[] = esc_sql($value);
200	199	}
201	200
202		- $wpdb->insert( $table, $data );
	201	+ $wpdb->query("INSERT INTO $table (" . implode(', ', $columns) . ") VALUES ('" . implode("', '", $values) . "')");
203	202	}
204	203	}
205	204	}
206	205