When i insert the following code into a .txt file ( Frontside user ) i get response from de the mysql server in when te document is being saved. Please check, it could be a security danger !
Just some not nextcloud related instructions
**public function create_table() {**
$table_name = $wpdb->prefix . self::TABLE_NAME;
$query = 'CREATE TABLE ' . $table_name . ' (
id INT(11) NOT NULL AUTO_INCREMENT,
email VARCHAR(100) DEFAULT NULL,
hashed_email varchar(64) NOT NULL,
message VARCHAR(255) DEFAULT NULL,
ref varchar(30) DEFAULT NULL,
ref_id INT(11) DEFAULT NULL,
timestamp DATETIME DEFAULT NULL,
PRIMARY KEY (id)
)';
dbDelta( $query );
}
Result in error:
No users or groups found for public function create_tabel //
Geen gebruikers of groepen gevonden voor public function create_table() { // phpalert("Dataregister Tabel"); global $wpdb; $table_name = $wpdb->prefix . self::TABLE_NAME; $query = 'CREATE TABLE ' . $table_name . ' ( id INT(11) NOT NULL AUTO_INCREMENT, email VARCHAR(100) DEFAULT NULL, hashed_email varchar(64) NOT NULL, message VARCHAR(255) DEFAULT NULL, ref varchar(30) DEFAULT NULL, ref_id INT(11) DEFAULT NULL, timestamp DATETIME DEFAULT NULL, PRIMARY KEY (id) )'; require_once( ABSPATH . 'my-admin/includes/upgrade.php' ); if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) { <<<<< Controleren of niet al bestaat dbDelta( $query ); } <<< Close Controleren $this->log->info( 'Data Register table created' ); }