ka2

Thank you for your inquiry.

Sorry, in the currently plugin you will not be able to enter the data to the multiple tables at the same time.

Thank you very much for reporting.

Oh surely, there was a syntax mistake in such very first place. I’m so sorry.
“b” within the specified namespace had become to lowercase.

Current wrong code:

CustomDatabaseTables\Lib\factory( 'set_global' );

Correct code:

CustomDataBaseTables\Lib\factory( 'set_global' );

Until the next bug fix version releasing, I think to work with that.

Thank you,

Oh, It differences is insertion place of the filter.
Did you use plugin versions 1.1.15?

The filter needs to be added to the get_data within the method of cdbt.class.php.
The right place is as follows:

function get_data($table_name, $columns='*', $conditions=null, $order=array('created'=>'desc'), $limit=null, $offset=null) {
	global $wpdb;
	list(, , $table_schema) = $this->get_table_schema($table_name);
	$select_clause = is_array($columns) ? implode(',', $columns) : (!empty($columns) ? $columns : '*');
	$where_clause = $order_clause = $limit_clause = null;
	if (!empty($conditions)) {
		$i = 0;
		foreach ($conditions as $key => $val) {
			if (array_key_exists($key, $table_schema)) {
				if ($i == 0) {
					$where_clause = "WHERE <code>$key</code> = '$val' ";
				} else {
					$where_clause .= "AND <code>$key</code> = '$val' ";
				}
				$i++;
			} else {
				continue;
			}
		}
	}
$where_clause = apply_filters( 'cdbt_get_data_conditions', $where_clause, $table_name, $conditions );
	if (!empty($order)) {
		$i = 0;
		foreach ($order as $key => $val) {
			if (array_key_exists($key, $table_schema)) {
				$val = strtoupper($val) == 'DESC' ? 'DESC' : 'ASC';
				if ($i == 0) {
					$order_clause = "ORDER BY <code>$key</code> $val ";
				} else {
					$order_clause .= ", <code>$key</code> $val ";
				}
				$i++;
			} else {
				continue;
			}
		}
	}
	if (!empty($limit)) {
		$limit_clause = "LIMIT ";
		$limit_clause .= (!empty($offset)) ? intval($offset) .', '. intval($limit) : intval($limit);
	}
	$sql = sprintf(
		"SELECT %s FROM <code>%s</code> %s %s %s",
		$select_clause,
		$table_name,
		$where_clause,
		$order_clause,
		$limit_clause
	);
	return $wpdb->get_results($sql);
}

After correct the position of the filter, please try again.

Hmm…that’s troubling, isn’t it.

Please confirm one point.
Do you specify a table name that you want to filter the table name in the condition of “if” statement on the source that you have added to “functions.php” in your theme?

If there is no problem in the above table name specification, please let me know the results of the debug code below.

function custom_get_data_conditions( $where_clause, $table_name, $conditions ){
  $current_user = wp_get_current_user();

  if ('your_created_table' === $table_name) {
    if (empty($conditions)) {
      $where_clause = sprintf( "WHERE userID = %d ", $current_user->ID);
    } else {
      $where_clause .= sprintf( "AND userID = %d ", $current_user->ID);
    }
  }
  var_dump($where_clause);
  return $where_clause;
}
add_filter( 'cdbt_get_data_conditions', 'custom_get_data_conditions', 10, 3);

By this code, I have put a debugging code at “var_dump” to display the variable of $where_clause before that is returned.

Thank you,

Thank you for your inquiry.

Please tell me sql statements of create table when you have failed. I might be able to help you if I will get it.

Thank you,

I’m so sorry for not replying sooner.

By the report from you, I’ve found that there is a bug in the processing of WEB API when not logged in.

I will try to fix that bug which releasing the version 2.
Sorry, please wait for a while.

Thank you for your inquiry.

The menu buttons of “Input data”, “View data” and “Edit data” will be enabled after selecting manageable table. From the tab of “Enable tables list” in “Setting”, please click the specific button of “Set Current Table”. By that table is enabled, each buttons as the “Input data” button will become the enable.

Please try it.