Skip to content

Instantly share code, notes, and snippets.

View bouroo's full-sized avatar
🏠
Remote Working

Kawin Viriyaprasopsook bouroo

🏠
Remote Working
View GitHub Profile
@bouroo
bouroo / zed.json
Created May 27, 2025 09:05
zed config
// Zed settings
//
// For information on how to configure Zed, see the Zed
// documentation: https://zed.dev/docs/configuring-zed
//
// To see all of Zed's default settings without changing your
// custom settings, run `zed: open default settings` from the
// command palette (cmd-shift-p / ctrl-shift-p)
{
"features": {
@bouroo
bouroo / Disable-VBS.cmd
Created May 3, 2025 04:29
Script to disable Virtualization Based Security and Credential Guard
@Echo off
cls
Color 04
Echo ##############################################################################
Echo Script to disable Virtualization Based Security and Credential Guard
Echo Version 20250404 by Metis IT
Echo Script started at %date% %time%
Echo .
Echo DISCLAIMER:
Echo .
@bouroo
bouroo / prompt.md
Last active May 29, 2025 08:28
Assistant Prompt

Helpful assistant

You are an expert assistant who can answer any question, suggest improved solutions, and ask for additional information when needed to ensure clarity and alignment with the user's goals.

Code Optimizer

Optimize code for maximum performance, robustness, clarity, brevity, and effectiveness while preserving original functionality, inputs, outputs, and inline comments; provide the refined code in a Markdown block followed by a concise summary of improvements.
@bouroo
bouroo / find_by_keywords.go
Last active April 10, 2025 09:39
Find files that contains all keywords
package main
import (
"bufio"
"context"
"encoding/csv"
"fmt"
"os"
"path/filepath"
"runtime"
@bouroo
bouroo / reset_traffic.sh
Created December 22, 2024 06:43
Reset Plesk traffic for both incoming and outgoing HTTP traffic for specific domain.
#!/usr/bin/env bash
# Prompt user to enter the domain
read -p "Please enter the domain (e.g., example.com): " domain
# Get the current year and month
current_year=$(date +%Y)
current_month=$(date +%m)
# Get the first day of the current month
@bouroo
bouroo / pgautoupgrade.sh
Created October 20, 2024 08:27
pgauto docker script to update postgres database version
#!/usr/bin/env bash
docker run --name pgauto -it \
--mount type=bind,source=${PGDATA},target=/var/lib/postgresql/data \
-e TZ="Asia/Bangkok" \
-e LANG="C.UTF-8" \
-e POSTGRES_USER="${POSTGRES_USER}" \
-e POSTGRES_PASSWORD="${POSTGRES_PASSWORD}" \
-e PGAUTO_ONESHOT=yes \
pgautoupgrade/pgautoupgrade:17-bookworm
@bouroo
bouroo / intel_pve_vgpu.sh
Last active September 19, 2024 04:58
Intel Gen 12/13 vGPU SR-IOV on Proxmox Host Enabler (Installer)
#!/usr/bin/env bash
# Print header information
cat << "EOF"
+----------------------------------------------------------------------+
| Intel Gen 12/13 vGPU SR-IOV on Proxmox Host Enabler (Installer) |
| https://github.com/Upinel/Intel-vGPU-SRIOV-on-Proxmox |
+----------------------------------------------------------------------+
| This source file is subject to version 2.0 of the Apache license, |
| that is bundled with this package in the file LICENSE, and is |
@bouroo
bouroo / rewrite.js
Last active September 10, 2024 14:17
AWS CloudFront function for static web app on Amazon S3
async function handler(event) {
const request = event.request;
const uri = request.uri;
// Extract pathname and check conditions
const hostnameWithPath = uri.split('//').pop();
const hasQuery = uri.indexOf('?') !== -1;
const hasExtension = uri.indexOf('.') !== -1 && uri.lastIndexOf('.') > uri.lastIndexOf('/');
const pathEndWithSlash = uri.charAt(uri.length - 1) === '/';
const isRootUrl = hostnameWithPath.indexOf('/') === -1 || hostnameWithPath.indexOf('/') === (hostnameWithPath.length - 1);
@bouroo
bouroo / convert_latin1_to_utf8mb4.sql
Last active May 12, 2025 04:18
A script that performs the conversion of `latin1` encoded strings to `utf8mb4` for all columns in all tables of a specific mariadb database. Make sure to back up your data before running scripts that modify it.
DELIMITER //
-- Drop the procedure if it already exists
DROP PROCEDURE IF EXISTS convert_chars_to_utf8mb4 //
-- Create the procedure to convert character set of columns
CREATE PROCEDURE convert_chars_to_utf8mb4(IN db_name VARCHAR(255))
BEGIN
-- Declare variables for cursor and loop control
DECLARE done INT DEFAULT FALSE;
@bouroo
bouroo / update-litespeed-cache.sh
Last active August 24, 2024 06:00
updates the LiteSpeed Cache plugin for all WordPress installations on a DirectAdmin server
#!/usr/bin/env bash
# ------------------------------------------------------------------------------
# Script Name: update-litespeed-cache.sh
# Description: This script updates the LiteSpeed Cache plugin for all WordPress
# installations on a DirectAdmin server. It checks for the WP-CLI
# tool and installs it if not found, then updates the specified plugin
# for each user's domains.
#
# Author: Kawin Viriyaprasopsook