This scripts removes users with the role subscriber or customer using SQL-script in MySQL.
-- Identify users to be removed
SELECT wp_users.ID, wp_users.user_nicename
FROM wp_users INNER JOIN wp_usermeta
ON wp_users.ID = wp_usermeta.user_id
/** | |
* Custom server.js for NextJS in order to proxy requests to backend api | |
* | |
* Create server.js in root dir, adjust scripts in package.json | |
* | |
* "scripts": { | |
* "dev": "node server.js", | |
* "start": "NODE_ENV=production node server.js" | |
* } | |
*/ |
<html> | |
<head> | |
<title>Progress bar</title> | |
<style> | |
progress { | |
width: 100%; | |
height: 2px; | |
-webkit-appearance: none; | |
} |
diff --git a/packages/oc-s3-storage-adapter/index.js b/packages/oc-s3-storage-adapter/index.js | |
index d6a552c..aebc7ed 100644 | |
--- a/packages/oc-s3-storage-adapter/index.js | |
+++ b/packages/oc-s3-storage-adapter/index.js | |
@@ -27,26 +27,42 @@ module.exports = function(conf) { | |
return true; | |
}; | |
+ // Defaults | |
+ const bucket = (conf.bucket) ? conf.bucket : ''; |
"use strict"; | |
// Same config as the direct connection script above, however tries to connect to s3.amazonaws.com | |
const AWS = require('aws-sdk'); | |
const oc = require('oc'); | |
var configuration = { | |
verbosity: 0, | |
baseUrl: 'http://localhost', | |
port: 3333, |
-- Get age from birthdate | |
select ( | |
case when | |
datepart(year,[BirthDate])>(1900) | |
AND datepart(year,[BirthDate])<datepart(year,getdate()) | |
AND (datepart(month,[BirthDate])>=(1) | |
AND datepart(month,[BirthDate])<=(12)) | |
AND (datepart(day,[BirthDate])>=(1) | |
AND datepart(day,[BirthDate])<=(31)) | |
then |