Skip to content

Instantly share code, notes, and snippets.

View fiko's full-sized avatar

Fiko Borizqy fiko

2 followers · 1 following
View GitHub Profile
@fiko
fiko / mongod.conf
Created October 11, 2018 10:10
MongoDB conf configuration
# /etc/mongod.conf
processManagement:
fork: true
net:
bindIp: 127.0.0.1
port: 27017
storage:
dbPath: /home/fiko/applications/mongodb/db
systemLog:
@fiko
fiko / mongod.service
Last active October 11, 2018 11:42
MongoDB service configuration
# /lib/systemd/system/mongod.service
[Unit]
Description=An object/document-oriented database
After=network.target
[Service]
User=fiko
ExecStart=/home/fiko/applications/mongodb/bin/mongod --auth --quiet --config=/etc/mongod.conf
@fiko
fiko / pdo-connect.php
Last active June 22, 2019 04:56
PHP script to connect to database using PDO library/class
<?PHP
$config = [
'DB_HOSTNAME' => 'localhost',
'DB_USERNAME' => 'root',
'DB_PASSWORD' => 'rootpassword',
'DB_DATABASE' => 'dummy_database'
];
$dsn = "mysql:host={$config['DB_HOSTNAME']};dbname={$config['DB_DATABASE']};charset=utf8mb4";
@fiko
fiko / docker-compose.yml
Last active July 3, 2019 04:49
Docker Compose version of MGT Commerce
version: "3"
# This is docker compose version of MGT Commerce base on this:
# https://www.mgt-commerce.com/documentation/mgt-development-environment-run-container
services:
mgt-development-environment-7.2:
volumes:
- ./public_html:/home/cloudpanel/htdocs
- /var/lib/mysql
restart: always
@fiko
fiko / example.com.conf
Created July 28, 2019 10:51
Simple Magento 2 nginx configuration (/etc/nginx/sites-enabled/example.com.conf).
server {
listen 80;
server_name local.example.com;
ssl_session_cache builtin:1000 shared:SSL:10m;
ssl_session_timeout 10m;
ssl_protocols TLSv1.1 TLSv1.2;
ssl_ciphers 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128:AES256:AES:DES-CBC3-SHA:HIGH:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK';
@fiko
fiko / Magento2 VHOST
Last active July 28, 2019 17:10
Default Magento2 VHOST [mgt-commerce](https://www.mgt-commerce.com/documentation/mgt-development-environment-run-container)
server {
listen 80;
{{ssl_listener}}
server_name local.replace.me;
{{ssl_certificate}}
{{ssl_certificate_key}}
ssl_session_cache builtin:1000 shared:SSL:10m;
ssl_session_timeout 10m;
ssl_protocols TLSv1.1 TLSv1.2;
ssl_ciphers 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128:AES256:AES:DES-CBC3-SHA:HIGH:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK';
@fiko
fiko / AutoLogin
Created April 14, 2022 22:58 — forked from akbaryahya/AutoLogin
Script Auto Login Wifi.id dengan Mikrotik
:local currentQueue 0;
:local nolock true;
:local gurl "https://welcome2.wifi.id";
:local guxx "http://www.msftconnecttest.com/redirect";
:local username "";
:local password "";
:local int "WIFI";
:local gwp "WAG-DX-PTR";
:local mdlan "MSTMA000xx-N/TLK-CI-xx33x:xxx";
:local type "WzMS";
@fiko
fiko / index.php
Last active June 20, 2022 09:23
How to backup database without mysqldump
<?php
# https://github.com/ifsnop/mysqldump-php
require_once('vendor/autoload.php');
use Ifsnop\Mysqldump as IMysqldump;
$host = 'localhost';
$db = 'database_name';
@fiko
fiko / Magento244CodeSnifferPHP81.patch
Last active July 20, 2022 08:03
ERROR: Referenced sniff "PHPCompatibility.FunctionUse.RemovedFunctions" does not exist
diff --git a/vendor/squizlabs/php_codesniffer/src/Util/Standards.php b/vendor/squizlabs/php_codesniffer/src/Util/Standards.php
--- a/vendor/squizlabs/php_codesniffer/src/Util/Standards.php
+++ b/vendor/squizlabs/php_codesniffer/src/Util/Standards.php
@@ -33,6 +33,8 @@
}
$resolvedInstalledPaths = [];
+ $vendorDir = dirname(dirname(dirname(dirname(__DIR__))));
+ $phpCompatibilityDir = $vendorDir . '/phpcompatibility/php-compatibility/PHPCompatibility';
+ if (is_dir($phpCompatibilityDir)) {
@fiko
fiko / Magento 2 - Quotes
Last active October 21, 2022 05:48 — forked from rafaelstz/Magento 2 - Remove all customer data
Remove all Magento 2 test Sample Data
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;