Andreas Schaefer AndiSHFR

## script-database-users-and-permissions.sql
/**
 * script-database-users-and-permissions.sql
 *
 * Copyright (C) 2020 by Andreas Schaefer <asc@schaefer-it.net>
 *
 * Create a t-sql script that can be used to restore users and
 * persmissions on a sql server database
 *
 * Notes:
 *   - The script will not script built-in accounts or accounts like '##MS%##'

## time-range.html
<!DOCTYPE html>
<!--
  IDEA: How to handle relative time ranges in query selection parameters
-->
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->

## basic-jquery-widget-example.js
/**
 * Minimal jQuery Widget Example
 * Author: Andreas Schaefer <asc@schaefer-it.net>
 *
 * Usage:
 *
 *   <div id="myCoolWidget"></div>
 *
 *   ...
 *

## constants.cc
#define NODE_SET_MEMBER(target, name, value)                                            \
    do {                                                                                \
        v8::Isolate* isolate = target->GetIsolate();                                    \
        v8::Local<v8::Context> context = isolate->GetCurrentContext();                  \
        v8::Local<v8::String> constant_name = v8::String::NewFromUtf8(isolate, (name)); \
        (target)->Set(v8::Local<Value>::New(isolate,                                    \
                          v8::String::NewFromUtf8(isolate, name)),                      \
            value);                                                                     \
    } while (0)

## naturalSort.js

function naturalSort(ar, index){
    var L= ar.length, i, who, next,
    isi= typeof index== 'number',
    rx=  /(\.\d+)|(\d+(\.\d+)?)|([^\d.]+)|(\.(\D+|$))/g;
    function nSort(aa, bb){
        var a= aa[0], b= bb[0], a1, b1, i= 0, n, L= a.length;
        while(i<L){
            if(!b[i]) return 1;
            a1= a[i];

## sort-objects.js

!function() {
    function _dynamicSortMultiple(attr) {
      /*
       * save the arguments object as it will be overwritten
       * note that arguments object is an array-like object
       * consisting of the names of the properties to sort by
       */
      var props = arguments;
      return function (obj1, obj2) {

## omnisharp.json
{
    "FormattingOptions": {
            "NewLine": "\n",
            "UseTabs": false,
            "TabSize": 2,
            "IndentationSize": 2,
            "SpacingAfterMethodDeclarationName": false,
            "SpaceWithinMethodDeclarationParenthesis": false,
            "SpaceBetweenEmptyMethodDeclarationParentheses": false,
            "SpaceAfterMethodCallName": false,

## convert-base2-to-int.sql
-- This sql snippet converts a base2 string (0 and 1 bits)
-- into an integer value

DECLARE @bitmask VARCHAR(8) = '10000000'
--              Bitposition:   76543210

DECLARE @intValue INT

;WITH bits(pos) AS (
 select  1 union select  2 union select  3 union select  4 union

## SqlServerPagingExample.sql
-- Pageing in SQL Server like mysql (LIMIT + OFFSET)
DECLARE @Offset INT = 3
DECLARE @Limit INT = 10

;WITH Results_CTE AS
(
    SELECT
        COUNT(*) OVER () as TotalRows,
        ROW_NUMBER() OVER (ORDER BY name) AS RowNum,
        id, name, crdate, refdate

## lib-php-direct-call-protection.php
<?php

// Protect agains direct calls from the web browser
if(1 == count(get_included_files())) {
  http_response_code(404);
  die( '<h1>404 Not Found</h1><p>The page that you have requested could not be found.</p>');
}

// More library code here
	/**
	* script-database-users-and-permissions.sql
	*
	* Copyright (C) 2020 by Andreas Schaefer <asc@schaefer-it.net>
	*
	* Create a t-sql script that can be used to restore users and
	* persmissions on a sql server database
	*
	* Notes:
	* - The script will not script built-in accounts or accounts like '##MS%##'
	<!DOCTYPE html>
	<!--
	IDEA: How to handle relative time ranges in query selection parameters
	-->
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<!-- The above 3 meta tags must come first in the head; any other head content must come after these tags -->
	/**
	* Minimal jQuery Widget Example
	* Author: Andreas Schaefer <asc@schaefer-it.net>
	*
	* Usage:
	*
	* <div id="myCoolWidget"></div>
	*
	* ...
	*
	#define NODE_SET_MEMBER(target, name, value) \
	do { \
	v8::Isolate* isolate = target->GetIsolate(); \
	v8::Local<v8::Context> context = isolate->GetCurrentContext(); \
	v8::Local<v8::String> constant_name = v8::String::NewFromUtf8(isolate, (name)); \
	(target)->Set(v8::Local<Value>::New(isolate, \
	v8::String::NewFromUtf8(isolate, name)), \
	value); \
	} while (0)

	function naturalSort(ar, index){
	var L= ar.length, i, who, next,
	isi= typeof index== 'number',
	rx= /(\.\d+)\|(\d+(\.\d+)?)\|([^\d.]+)\|(\.(\D+\|$))/g;
	function nSort(aa, bb){
	var a= aa[0], b= bb[0], a1, b1, i= 0, n, L= a.length;
	while(i<L){
	if(!b[i]) return 1;
	a1= a[i];

	!function() {
	function _dynamicSortMultiple(attr) {
	/*
	* save the arguments object as it will be overwritten
	* note that arguments object is an array-like object
	* consisting of the names of the properties to sort by
	*/
	var props = arguments;
	return function (obj1, obj2) {
	{
	"FormattingOptions": {
	"NewLine": "\n",
	"UseTabs": false,
	"TabSize": 2,
	"IndentationSize": 2,
	"SpacingAfterMethodDeclarationName": false,
	"SpaceWithinMethodDeclarationParenthesis": false,
	"SpaceBetweenEmptyMethodDeclarationParentheses": false,
	"SpaceAfterMethodCallName": false,
	-- This sql snippet converts a base2 string (0 and 1 bits)
	-- into an integer value

	DECLARE @bitmask VARCHAR(8) = '10000000'
	-- Bitposition: 76543210

	DECLARE @intValue INT

	;WITH bits(pos) AS (
	select 1 union select 2 union select 3 union select 4 union
	-- Pageing in SQL Server like mysql (LIMIT + OFFSET)
	DECLARE @Offset INT = 3
	DECLARE @Limit INT = 10

	;WITH Results_CTE AS
	(
	SELECT
	COUNT(*) OVER () as TotalRows,
	ROW_NUMBER() OVER (ORDER BY name) AS RowNum,
	id, name, crdate, refdate
	<?php

	// Protect agains direct calls from the web browser
	if(1 == count(get_included_files())) {
	http_response_code(404);
	die( '<h1>404 Not Found</h1><p>The page that you have requested could not be found.</p>');
	}

	// More library code here