Dzoge

Installation

Linux

1. Download latest version Minimal ISO CentOS from https://www.centos.org/
2. Install centos with minimal required hardware configuration
   • CPU - 1
   • RAM - 1GB
   • HDD - 20GB
3. optional Create an additional user with the administrator privilages (ex: myuser)

Dzoge

#!/bin/bash
# for a quick installation of this script run the following command
# bash <(curl -L https://gist.github.com/Dzoge/8adb0c80aabb12309c030663247a230a/raw)


# Update Packages
yum upgrade -y

# Install dotnet runtime
rpm -Uvh https://packages.microsoft.com/config/rhel/7/packages-microsoft-prod.rpm

Dzoge

SELECT
  'UPDATE ['+TABLE_SCHEMA+'].['+table_name+'] SET ['+column_name+'] = REPLACE(['+column_name+'], ''existing-text'', ''new-text'');'
  --,table_name as [TableName]
  --,column_name as [ColumnName]
  --,TABLE_SCHEMA as [SchemaName]
from information_schema.columns 
where data_type = 'nvarchar' 
  and character_maximum_length=-1

Dzoge

iOS (with pin, iOS will lookup address too and show that as label)

maps://?q=LAT,LNG

Android, no pin (just open at location)

geo:LAT,LNG