regilero

#!/bin/bash
##################################################################
# Licensed under GNU GPL v3                                      #
# [email protected]                                          #
#                                                                #
# DNS replacement scrpit in SQL dumps containing (also) PHP      #
# serialized strings.                                            #
# This script use bash and perl' perl is used to increment       #
# serialized string length while performing DNS replacement      #
# It also use sed for other basic DNS replacements               #

regilero

# Change YOUR_TOKEN to your prerender token and uncomment that line if you want to cache urls and view crawl stats
# Change example.com (server_name) to your website url
# Change /path/to/your/root to the correct value

# Generate $prerender_ua bool value based on user agent
# indexation bots will get this as 1, 
# prerender user agent will always get 0 (avoid loops)
map $http_user_agent $prerender_ua {

    default 0;

regilero

SELECT *
FROM (
   SELECT
   (
	SELECT concat('Marie-', string_agg(x,'-'))  as name_first_female
	FROM (
		select start_arr[ 1 + ( (random() * 100)::int) % 32 ]
		FROM
		(
		    select '{Claude,Thérèse,Géraldine,Sylvie,Sophie,Solange,Vivianne,Cunégonde,Albertine,Charlotte,Caroline,Célestine,Bérangère,Sylvianne,Alphonsine,Claire,Françoise,Chantal,Geneviève,Christine,Louise,Adeline,Céleste,Angélique,Clothilde,Jeanne,Pierre,Valentine,Paule,Noëlle,Lise,Cécile}'::text[] as start_arr

regilero

version: '3'
# Fichier docker-compose.yml
# TP Sécurité Web
# --------------
# * DVWA: Damn Vulnerable Web Application (apache/php5.6/MySQL)
# * Varnish: Serveur Reverse Proxy mis en place devant Nodegoat
# * NodeGoat: Application NodeJs+MongoDb Vulnerable
#
#   local           |docker-compose, réseau interne
#                   |

regilero

Gros indexs

Peut être un bug dans celle là...

select
   stats.schemaname,
   stats.relname as table,
   stats.indexrelname as index,
   idx.indisprimary as primary,
   idx.indisunique as unique,