lechup

Apache

How to make your website to maintenance mode

1. Put maintenance.html into your root directory

2. Open .htaccess file

3. Insert this block in the first line of the file

    ErrorDocument 503 /maintenance.html
    RewriteCond %{DOCUMENT_ROOT}/maintenance.html -f
   

RewriteCond %{REQUEST_URI} !(/maintenance.html)

lechup

CREATE OR REPLACE FUNCTION slugify(str text) RETURNS text AS $$
    BEGIN
        RETURN regexp_replace(
           lower(translate(str,
             'äëïöüáéíóúâêîûôåãõàèìòùřšěčůńýśćłęążźĄŃÝŚĆŁĘÄËÏÖÜÁÉÍÓÚÂÊÎÛÔÅÃÕÀÈÌÒÙŘŠĚČŮŻŹß ²ø®',
             'aeiouaeiouaeiouaaoaeioursecunyscleazzANYSCLEAEIOUAEIOUAEIOUAAOAEIOURSECUZzs-2dR'
             -- missing chars will be removed
           )),
           -- strip all others chars than [^a-z0-9 \-]
           '[^a-z0-9 \-]',