string) ? '0' : $id_string;
$sql = "\n\t\t\tSELECT * FROM {$sources_table_name}\n\t\t\tWHERE account_id IN ({$id_string})\n\t\t\tOR account_type = 'business'\n\t\t ";
return $wpdb->get_results($sql, \ARRAY_A);
}
$privilege = '';
if (!empty($privilege)) {
if (isset($id_string)) {
$sql = $wpdb->prepare("\n\t\t\tSELECT * FROM {$sources_table_name}\n\t\t\tWHERE account_id IN ({$id_string})\n\t\t\tAND privilege = %s;\n\t\t ", $privilege);
} else {
$sql = $wpdb->prepare("\n\t\t\tSELECT * FROM {$sources_table_name}\n\t\t\tWHERE account_id = %s\n\t\t\tAND privilege = %s;\n\t\t ", $args['id'], $privilege);
}
} else if (isset($id_string)) {
$sql = "\n\t\t\t\tSELECT * FROM {$sources_table_name}\n\t\t\t\tWHERE account_id IN ({$id_string});\n\t\t\t\t";
} else {
$sql = $wpdb->prepare("\n\t\t\t\tSELECT * FROM {$sources_table_name}\n\t\t\t\tWHERE account_id = %s;\n\t\t\t ", $args['id']);
}
return $wpdb->get_results($sql, \ARRAY_A);
}
/**
* Update a source (connected account)
*
* @param array $to_update
* @param array $where_data
*
* @return false|int
*
* @since 6.0
*/
public function source_update($to_update, $where_data)
{
global $wpdb;
$sources_table_name = $this->sources_table;
$encryption = new \SmashBalloon\YoutubeFeed\Vendor\SB_YouTube_Data_Encryption();
$data = array();
$where = array();
$format = array();
$where_format = array();
if (isset($to_update['type'])) {
$data['account_type'] = $to_update['type'];
$format[] = '%s';
}
if (isset($to_update['privilege'])) {
$data['privilege'] = $to_update['privilege'];
$format[] = '%s';
}
if (isset($to_update['id'])) {
$where['account_id'] = $to_update['id'];
$where_format[] = '%s';
}
if (isset($to_update['access_token'])) {
$data['access_token'] = $encryption->maybe_encrypt($to_update['access_token']);
$format[] = '%s';
}
if (isset($to_update['username'])) {
$data['username'] = $to_update['username'];
$format[] = '%s';
}
if (isset($to_update['info'])) {
$data['info'] = $encryption->maybe_encrypt($to_update['info']);
$format[] = '%s';
}
if (isset($to_update['error'])) {
$data['error'] = $to_update['error'];
$format[] = '%s';
}
if (isset($to_update['expires'])) {
$data['expires'] = $to_update['expires'];
$format[] = '%s';
}
if (isset($to_update['last_updated'])) {
$data['last_updated'] = $to_update['last_updated'];
$format[] = '%s';
}
if (isset($to_update['author'])) {
$data['author'] = $to_update['author'];
$format[] = '%d';
}
if (isset($where_data['type'])) {
$where['account_type'] = $where_data['type'];
$where_format[] = '%s';
}
if (isset($where_data['privilege'])) {
$where['privilege'] = $where_data['privilege'];
$where_format[] = '%s';
}
if (isset($where_data['author'])) {
$where['author'] = $where_data['author'];
$where_format[] = '%d';
}
if (isset($where_data['id'])) {
$where['account_id'] = $where_data['id'];
$where_format[] = '%s';
}
if (isset($where_data['record_id'])) {
$where['id'] = $where_data['record_id'];
$where_format[] = '%d';
}
$affected = $wpdb->update($sources_table_name, $data, $where, $format, $where_format);
return $affected;
}
/**
* New source (connected account) data is added to the
* sbi_sources table and the new insert ID is returned
*
* @param array $to_insert
*
* @return false|int
*
* @since 6.0
*/
public function source_insert($to_insert)
{
global $wpdb;
$sources_table_name = $this->sources_table;
$encryption = new \SmashBalloon\YoutubeFeed\Vendor\SB_Instagram_Data_Encryption();
$data = array();
$format = array();
if (isset($to_insert['id'])) {
$data['account_id'] = $to_insert['id'];
$format[] = '%s';
}
if (isset($to_insert['type'])) {
$data['account_type'] = $to_insert['type'];
$format[] = '%s';
} else {
$data['account_type'] = 'page';
$format[] = '%s';
}
if (isset($to_insert['privilege'])) {
$data['privilege'] = $to_insert['privilege'];
$format[] = '%s';
}
if (isset($to_insert['access_token'])) {
$data['access_token'] = $encryption->maybe_encrypt($to_insert['access_token']);
$format[] = '%s';
}
if (isset($to_insert['username'])) {
$data['username'] = $to_insert['username'];
$format[] = '%s';
}
if (isset($to_insert['info'])) {
$data['info'] = $encryption->maybe_encrypt($to_insert['info']);
$format[] = '%s';
}
if (isset($to_insert['error'])) {
$data['error'] = $to_insert['error'];
$format[] = '%s';
}
if (isset($to_insert['expires'])) {
$data['expires'] = $to_insert['expires'];
$format[] = '%s';
} else {
$data['expires'] = '2100-12-30 00:00:00';
$format[] = '%s';
}
$data['last_updated'] = gmdate('Y-m-d H:i:s');
$format[] = '%s';
if (isset($to_insert['author'])) {
$data['author'] = $to_insert['author'];
$format[] = '%d';
} else {
$data['author'] = get_current_user_id();
$format[] = '%d';
}
return $wpdb->insert($sources_table_name, $data, $format);
}
/**
* Count the sby_feeds table
*
* @return int
*
* @since 6.0
*/
public function feeds_count()
{
global $wpdb;
$feeds_table_name = $this->feeds_table;
$results = $wpdb->get_results("SELECT COUNT(*) AS num_entries FROM {$feeds_table_name}", \ARRAY_A);
return isset($results[0]['num_entries']) ? (int) $results[0]['num_entries'] : 0;
}
/**
* Query the sby_feeds table
*
* @param array $args
*
* @return array|bool
*
* @since 6.0
*/
public function feeds_query($args = array())
{
global $wpdb;
$feeds_table_name = $this->feeds_table;
$page = 0;
if (isset($args['page'])) {
$page = (int) $args['page'] - 1;
unset($args['page']);
}
$offset = max(0, $page * self::RESULTS_PER_PAGE);
if (isset($args['id'])) {
$sql = $wpdb->prepare("\n\t\t\tSELECT * FROM {$feeds_table_name}\n\t\t\tWHERE id = %d;\n\t\t ", $args['id']);
} else {
$sql = $wpdb->prepare("\n\t\t\tSELECT * FROM {$feeds_table_name}\n\t\t\tLIMIT %d\n\t\t\tOFFSET %d;", self::RESULTS_PER_PAGE, $offset);
}
return $wpdb->get_results($sql, \ARRAY_A);
}
/**
* Update feed data in the sbi_feed table
*
* @param array $to_update
* @param array $where_data
*
* @return false|int
*
* @since 6.0
*/
public function feeds_update($to_update, $where_data)
{
global $wpdb;
$feeds_table_name = $this->feeds_table;
$data = array();
$where = array();
$format = array();
foreach ($to_update as $single_insert) {
if ($single_insert['key']) {
$data[$single_insert['key']] = $single_insert['values'][0];
$format[] = '%s';
}
}
if (isset($where_data['id'])) {
$where['id'] = $where_data['id'];
$where_format = array('%d');
} elseif (isset($where_data['feed_name'])) {
$where['feed_name'] = $where_data['feed_name'];
$where_format = array('%s');
} else {
return \false;
}
$data['last_modified'] = gmdate('Y-m-d H:i:s');
$format[] = '%s';
$affected = $wpdb->update($feeds_table_name, $data, $where, $format, $where_format);
return $affected;
}
/**
* New feed data is added to the sby_feeds table and
* the new insert ID is returned
*
* @param array $to_insert
*
* @return false|int
*
* @since 6.0
*/
public function feeds_insert($to_insert)
{
global $wpdb;
$feeds_table_name = $this->feeds_table;
$data = array();
$format = array();
foreach ($to_insert as $single_insert) {
if ($single_insert['key']) {
$data[$single_insert['key']] = $single_insert['values'][0];
$format[] = '%s';
}
}
$data['last_modified'] = gmdate('Y-m-d H:i:s');
$format[] = '%s';
$data['author'] = get_current_user_id();
$format[] = '%d';
$wpdb->insert($feeds_table_name, $data, $format);
return $wpdb->insert_id;
}
/**
* Creates all database tables used in the new admin area in
* the 6.0 update.
*
* TODO: Add error reporting
*
* @since 6.0
*/
public function create_tables($include_charset_collate = \true, $skip_sources = \false)
{
if (!function_exists('dbDelta')) {
require_once \ABSPATH . '/wp-admin/includes/upgrade.php';
}
global $wpdb;
$max_index_length = 191;
$charset_collate = '';
if ($include_charset_collate && method_exists($wpdb, 'get_charset_collate')) {
// get_charset_collate introduced in WP 3.5
$charset_collate = $wpdb->get_charset_collate();
}
$feeds_table_name = $this->feeds_table;
if ($wpdb->get_var("show tables like '{$feeds_table_name}'") !== $feeds_table_name) {
$sql = "\n\t\t\tCREATE TABLE {$feeds_table_name} (\n\t\t\t id bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t feed_name text NOT NULL default '',\n\t\t\t feed_title text NOT NULL default '',\n\t\t\t settings longtext NOT NULL default '',\n\t\t\t author bigint(20) unsigned NOT NULL default '1',\n\t\t\t status varchar(255) NOT NULL default '',\n\t\t\t last_modified datetime NOT NULL,\n\t\t\t PRIMARY KEY (id),\n\t\t\t KEY author (author)\n\t\t\t) {$charset_collate};\n\t\t\t";
$wpdb->query($sql);
}
$error = $wpdb->last_error;
$query = $wpdb->last_query;
$had_error = \false;
if ($wpdb->get_var("show tables like '{$feeds_table_name}'") !== $feeds_table_name) {
$had_error = \true;
}
if (!$had_error) {
}
$feed_caches_table_name = $wpdb->prefix . 'sby_feed_caches';
if ($wpdb->get_var("show tables like '{$feed_caches_table_name}'") !== $feed_caches_table_name) {
$sql = '
CREATE TABLE ' . $feed_caches_table_name . " (\n\t\t\t\tid bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\tfeed_id varchar(255) NOT NULL default '',\n cache_key varchar(255) NOT NULL default '',\n cache_value longtext NOT NULL default '',\n cron_update varchar(20) NOT NULL default 'yes',\n last_updated datetime NOT NULL,\n PRIMARY KEY (id),\n KEY feed_id (feed_id({$max_index_length}))\n ) {$charset_collate};";
$wpdb->query($sql);
}
$error = $wpdb->last_error;
$query = $wpdb->last_query;
$had_error = \false;
if ($wpdb->get_var("show tables like '{$feed_caches_table_name}'") !== $feed_caches_table_name) {
$had_error = \true;
}
if (!$had_error) {
}
$sources_table_name = $wpdb->prefix . 'sby_sources';
if ($skip_sources === \false && $wpdb->get_var("show tables like '{$sources_table_name}'") !== $sources_table_name) {
$sql = '
CREATE TABLE ' . $sources_table_name . " (\n\t\t\t\tid bigint(20) unsigned NOT NULL auto_increment,\n\t\t\t\taccount_id varchar(255) NOT NULL default '',\n account_type varchar(255) NOT NULL default '',\n privilege varchar(255) NOT NULL default '',\n access_token varchar(1000) NOT NULL default '',\n username varchar(255) NOT NULL default '',\n info text NOT NULL default '',\n error text NOT NULL default '',\n expires datetime NOT NULL,\n last_updated datetime NOT NULL,\n author bigint(20) unsigned NOT NULL default '1',\n PRIMARY KEY (id),\n KEY account_type (account_type({$max_index_length})),\n KEY author (author)\n ) {$charset_collate};";
$wpdb->query($sql);
}
$error = $wpdb->last_error;
$query = $wpdb->last_query;
$had_error = \false;
if ($wpdb->get_var("show tables like '{$sources_table_name}'") !== $sources_table_name) {
$had_error = \true;
}
if (!$had_error) {
}
}
public function reset_tables()
{
global $wpdb;
$feeds_table_name = $this->feeds_table;
$wpdb->query("DROP TABLE IF EXISTS {$feeds_table_name}");
$feed_caches_table_name = $wpdb->prefix . 'sbi_feed_caches';
$wpdb->query("DROP TABLE IF EXISTS {$feed_caches_table_name}");
$sources_table_name = $this->sources_table;
$wpdb->query("DROP TABLE IF EXISTS {$sources_table_name}");
}
public function get_results_per_page()
{
return self::RESULTS_PER_PAGE;
}
}
Fatal error: Uncaught Error: Class 'Smashballoon\Customizer\DB' not found in /var/www/html/cronicasdorock.com.br/web/wp-content/plugins/feeds-for-youtube/inc/Customizer/DB.php:7
Stack trace:
#0 /var/www/html/cronicasdorock.com.br/web/wp-content/plugins/custom-twitter-feeds/vendor/composer/ClassLoader.php(571): include()
#1 /var/www/html/cronicasdorock.com.br/web/wp-content/plugins/custom-twitter-feeds/vendor/composer/ClassLoader.php(428): Composer\Autoload\includeFile('/var/www/html/c...')
#2 [internal function]: Composer\Autoload\ClassLoader->loadClass('SmashBalloon\\Yo...')
#3 /var/www/html/cronicasdorock.com.br/web/wp-content/plugins/feeds-for-youtube/youtube-feed.php(76): spl_autoload_call('SmashBalloon\\Yo...')
#4 /var/www/html/cronicasdorock.com.br/web/wp-settings.php(526): include_once('/var/www/html/c...')
#5 /var/www/html/cronicasdorock.com.br/web/wp-config.php(104): require_once('/var/www/html/c...')
#6 /var/www/html/cronicasdorock.com.br/web/wp-load.php(50): require_once('/var/www/html/c...')
#7 /var/www/html/c in /var/www/html/cronicasdorock.com.br/web/wp-content/plugins/feeds-for-youtube/inc/Customizer/DB.php on line 7