Marcus marcus-at-localhost

As a flat file CMS, Kirby stores all content in folders and files. This is not only true for pages, but also for files and user accounts, which are by default stored in the /site/accounts folder.

But in the same way as you can incorporate content from other sources like spreadsheets, feeds or databases to create (link: text: virtual pages in Kirby), you can also replace users stored in the file system with users stored in a database (or some other source).

In this recipe, we will see how we can achieve this. For this purpose, we will start with a simple read-only solution and then extend this basic setup step-by-step into a solution that lets us create and edit database users from the Panel, including multi-language user content.

Note that using users from a database as described in this recipe will **not** solve potential performance issues with thousands of users.

Effective September 2021, Dropbox will be deprecating long-lived access tokens.

This GIST generally describes how to authenticate requests to Dropbox API v2, for anyone working on a server-side PHP Dropbox implementation.

It's important to understand three types of codes you'll encounter:

Access Code - this is a one-time code that represents user-granted app access.
Access Token - this is short-lived token that provides access to Dropbox API endpoints.
Refresh Token - this is a long-lived token that allows you to fetch a fresh Access Token.

Offline and Connection Detection and Web Component

I got some inspiration from here: https://mxb.dev/blog/youre-offline/ and then I tried to understand how classes, events and Web Components in JS are working.

I have no idea if this is the best approach.

Icons: https://dev.materialdesignicons.com/getting-started/webfont

A Pen by Marcus Obst on CodePen.

	const echoPostRequest = {
	url: 'https://<my url>.auth0.com/oauth/token',
	method: 'POST',
	header: 'Content-Type:application/json',
	body: {
	mode: 'application/json',
	raw: JSON.stringify(
	{
	client_id:'<your client ID>',
	client_secret:'<your client secret>',

	.sticky {
	position: sticky;
	top: 0;
	align-self: flex-start;
	height: auto;
	}

	<?php

	use Psr\Http\Message\RequestInterface;

	class AuthenticationHandler
	{

	private $username;

	private $password;

	/*
	*
	* Google Maps Formulas for Google Sheets
	*
	* Written by Amit Agarwal
	*
	* Web: https://labnol.org/google-maps-formulas-for-sheets-200817
	*
	*/

	// API https://public.opendatasoft.com/explore/dataset/georef-germany-postleitzahl/api/

	function geo2zip(a) {
	let url = 'https://public.opendatasoft.com/api/records/1.0/search/?dataset=georef-germany-postleitzahl&q=' + a + '&facet=plz_name&facet=lan_name&facet=lan_code';
	var response = UrlFetchApp.fetch(url);
	var res = JSON.parse(response.getContentText());
	return res.records[0].fields.plz_name_long;

	//console.log(a,url, res.records[0].fields.plz_name_long);
	//var auth = JSON.parse(response.getContentText());

	document.addEventListener("visibilitychange", () => {
	const state = document.visibilityState;
	if (state === "hidden") {
	// your PWA is now in the background
	}

	if (state === "visible") {
	// your PWA is now in the foreground
	refreshData();
	}