Skip to content

Instantly share code, notes, and snippets.

View MisterDaniels's full-sized avatar
👨
Ready to work

Daniel Silva MisterDaniels

👨
Ready to work
59 followers · 76 following
View GitHub Profile
@MisterDaniels
MisterDaniels / concatenated_queries_validator.php
Created June 21, 2024 13:57
<?php
$CONCATENATED_QUERIES_REGEX = '/(SELECT|UPDATE|INSERT\s+INTO|DELETE\s+FROM)\s+[^;|\)]*[\'"]\s*\.\s*\$[a-zA-Z_]\w*/';
function scanDirectory($dir) {
$files = [];
$iterator = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($dir));
foreach($iterator as $file) {
if ($file->isFile() && $file->getExtension() === 'php') {
@MisterDaniels
MisterDaniels / HOW_TO_USE.md
Last active April 24, 2024 16:52
Verify what image is not in dropbox folder 
python verifier.py TOKEN FILE.CSV

Ex:

python verifier.py sl.alldutoken project_images_path.csv
@MisterDaniels
MisterDaniels / Dockerfile
Last active September 18, 2022 00:12
Wordpress security malwares
FROM python:3
WORKDIR /usr/src/app
ENV CHECKSUM_RSA_KEY_FILE /usr/src/app/rsa_key
COPY requirements.txt ./
RUN pip install --no-cache-dir -r requirements.txt
RUN apt update
@MisterDaniels
MisterDaniels / task.md
Last active May 19, 2022 13:37
  • Entrar na maquina dos Wordpress dos clientes (44.201.155.192);
  • Entre com sudo su;
  • Entre na pasta do teu usario cd /home/TEU_USUARIO Ex: cd /home/silva
  • Extrair .sql do Wordpress do cliente mysqldump -pqu46pbwTz8tBcWzN -uroot BANCO_DO_CLIENTE > DOMINIO_DO_CLIENTE.sql; Ex: mysqldump -pqu46pbwTz8tBcWzN -uroot blog-albumgraf-novo > albumgraf.com.br.sql
  • Gerar .zip do Wordpress do cliente zip -r DOMINIO_DO_CLIENTE.zip /var/www/WORDPRESS_DO_CLIENTE; Ex: zip -r albumgraf.com.br.zip /var/www/blog-albumgraf-novo
  • Gerar .zip do certificado do Wordpress do cliente zip -r DOMINIO_DO_CLIENTE-certificados.zip /etc/letsencrypt/live/DOMINIO_DO_CLIENTE; Ex: zip -r albumgraf.com.br-certificados.zip /etc/letsencrypt/live/albumgraf.com.br
@MisterDaniels
MisterDaniels / .env
Last active September 15, 2022 20:19
Wordpress Environment
SERVER_HTTP_PORT=80
SERVER_HTTPS_PORT=443
MYSQL_ROOT_PASSWORD=test
AWS_ACCESS_KEY=test
AWS_SECRET_ACCESS_KEY=test
@MisterDaniels
MisterDaniels / QueriesKilled.log
Last active May 3, 2022 14:13
Kill expensive and duplicated queries of a MySQL process
Executed in 2022-05-03 10:33:21.410481
Connected to MySQL Server version 5.5.5-10.1.30-MariaDB-1~jessie
Catching query: select benchmark(10000000000, md5('when will it end 3?'))
Pokecess: [254, 251, 248, 244, 242, 240, 237, 234, 230]
- Catched pokecess 254
- Catched pokecess 251
- Catched pokecess 248
- Catched pokecess 244
- Catched pokecess 242
- Catched pokecess 240
@MisterDaniels
MisterDaniels / reload-table-dms.sh
Last active February 15, 2022 17:46
#!/usr/bin/env bash
set -e
declare -a tables=("project" "photo_project");
for table in "${tables[@]}"
do
aws dms reload-tables \
--replication-task-arn "arn:aws:dms:sa-east-1:563887512369:task:XGPXOQJKUOT2I5P4HXSB3LQFAVH6XG6WAFDHENY" \
--tables-to-reload "SchemaName=photobook,TableName=$table" \
@MisterDaniels
MisterDaniels / docker-compose-replication.yml
Created November 26, 2021 18:53
Docker banco master & slave
version: '2.1'
services:
mariadb-master:
image: docker.io/bitnami/mariadb:10.6
ports:
- '3308:3306'
volumes:
- 'mariadb_master_data:/bitnami/mariadb'
- ./mysql-dump:/docker-entrypoint-initdb.d
@MisterDaniels
MisterDaniels / .dockerignore
Created November 10, 2021 12:03
Wordpress docker
# Ambient variables
.env
# Git folder
.git
# Docker compose, because, don't
docker-compose.yml
# Ignore files '-'
@MisterDaniels
MisterDaniels / companies.json
Created November 10, 2021 11:52
Auryn - Test email sends
// 20200831170024
// http://modelo.auryn.com.br/publicData/getActiveCompaniesDomain
[
{
"id": 1,
"name": "GeA",
"subdomain": "fotogea.auryn.com.br"
},
{