ainsofs

metadata:
    type: drupal8
    infrastructure: ^5.1
services:
    ipt:
        enabled: true
        required: true
        image: 'gbif/ipt:2.4.2'
        ports:
            - 'edge::80:8080/tcp'

ainsofs

# export content type using drupal console

drupal config:export:content:type page \
  --module="demo" \
  --optional-config \
  --remove-uuid \
  --remove-config-hash
  
  more: https://drupalconsole.com/docs/en/commands/config-export-content-type

ainsofs

# rebuild permissions
drush php-eval "node_access_rebuild();"

# remove missing module

drush sql-query "DELETE FROM key_value WHERE collection='system.schema' AND name='module_name';"

# how to re-apply drupal update

drush ev "drupal_set_installed_schema_version('field_group', 8000)"

ainsofs

<!-- requires url rewrite module --->
<!-- https://docs.microsoft.com/en-us/archive/blogs/dawiese/redirect-from-http-to-https-using-the-iis-url-rewrite-module -->

<system.webServer>
    <rewrite>
        <rules>
            <rule name="Redirect http to https" patternSyntax="Wildcard" stopProcessing="true">
                <match url="*" />
                <conditions>
                    <add input="{HTTPS}" pattern="off" />

ainsofs

-- kill all connections For MS SQL Server 2000, 2005, 2008

USE master;

DECLARE @kill varchar(8000); SET @kill = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'  
FROM master..sysprocesses  
WHERE dbid = db_id('MyDB')

EXEC(@kill); 

ainsofs

For Alfresco 4.x and Solr 1.4:

#! /bin/bash
export ALF_HOME=/opt/alfresco4
export SOLR_HOME=/opt/alfresco4/alf_data/solr

$ALF_HOME/alfresco.sh stop
sleep 10

rm -rf $SOLR_HOME/workspace/SpacesStore/*

ainsofs

## login to a database
psql -U [username] [database_name]

## check database size
SELECT pg_size_pretty( pg_database_size('dbname') );

## check table sizes (top 5)
SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
  FROM pg_class C

ainsofs

# ensure you have backed up the database and files before running these commands
# mysql/mariadb
drush sql-dump --gipz --result-file

#postgres
pg_dump -U postgres -h localhost "[YOUR_DATABASE]" | gzip > [dbname]-[date]00.sql.gz

# remove old files
rm -rf images/ includes/ misc/ modules/ profiles/ scripts/ themes/
rm -f .* *.php *.txt *.config

ainsofs

interface IWebApiResponse {
        bool ApiSuccess { get; set; }
        string ApiError { get; set; }
        string ApiStackTrace { get; set; }
    }

ainsofs

public class DnnLogger {
    private EventLogController Controller;

    public DnnLogger() {
      Controller = new EventLogController();
    }

    public void AddLog(string message)
    {
      var log = CreateLogDefaults();