/** * @param bool $is_admin code to be executed on an admin (dashboard) page * @return array|null|object */ public function getCodeItemsToExecute($is_admin) { global $wpdb; $this->plugin->ensureDatabaseTableInstalled(); // ensure created in multisite $table = $this->plugin->getTableName(); $sql = "select * from {$table} where enabled = 1"; if ($is_admin) { $sql .= " and inadmin = 1"; } $sql .= " order by id"; return $wpdb->get_results($sql, ARRAY_A); }
public function updateItem($item) { $this->ensureAllIndexesSet($item); $this->conformInputValues($item); global $wpdb; $this->plugin->ensureDatabaseTableInstalled(); // ensure created in multisite $table = $this->plugin->getTableName(); $sql = $wpdb->prepare("update {$table} set name = %s, description = %s, capability = %s, enabled = %d, shortcode = %d, buffer = %d, inadmin = %d, code = %s where id = %d", $item['name'], $item['description'], $item['capability'], $item['enabled'], $item['shortcode'], $item['buffer'], $item['inadmin'], $item['code'], $item['id']); $wpdb->query($sql); return $item['id']; }