Adiatna Sukmana syn-arch

## Auto indext for sublime text 3.json
{"keys": ["ctrl+shift+x"], "command": "reindent", "args": {"single_line": false}}

## mod_rewrite_guide.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                syn-arch
                / mod_rewrite_guide.md
            
            
              Last active
              January 11, 2022 07:07
                — forked from dario2994/mod_rewrite_guide.md
            
              
                Enable mod_rewrite in apache
              
          
Apache configuration file

ubuntu -> /etc/apache2/apache2.conf
arch -> /etc/httpd/conf/httpd.conf


Add mod_rewrite and .htaccess support for your site
At the end of the configuration files add these lines:
#My site mod_rewrite configuration
<Directory "/var/www/">
  AllowOverride All


## mysqld.conf
Step 1:

sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
Step 2: Go to last line and add the following

sql_mode = ""
Step 3: Save

Step 4: Restart mysql server.

## permission.js
navigator.permissions.query({name: 'microphone'})
	.then((permissionObj) => {
		console.log(permissionObj.state);
	})
	.catch((error) => {
		console.log('Got error :', error);
	})

	navigator.permissions.query({name: 'camera'})
	.then((permissionObj) => {

## mysql.sql
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';

## change mass.sql
UPDATE tableB
INNER JOIN tableA ON tableB.name = tableA.name
SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
WHERE tableA.name = 'Joe'

## folderlock.bat
cls

@ECHO OFF

title Folder Locker

if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK

if NOT EXIST Locker goto MDLOCKER

## Laravel htaccess
<IfModule mod_rewrite.c>

RewriteEngine On

RewriteRule ^(.*)$ public/$1 [L]

</IfModule>
	Step 1:

	sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
	Step 2: Go to last line and add the following

	sql_mode = ""
	Step 3: Save

	Step 4: Restart mysql server.
	navigator.permissions.query({name: 'microphone'})
	.then((permissionObj) => {
	console.log(permissionObj.state);
	})
	.catch((error) => {
	console.log('Got error :', error);
	})

	navigator.permissions.query({name: 'camera'})
	.then((permissionObj) => {
	SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
	FROM information_schema.tables
	WHERE table_schema = 'MyDatabaseName';
	UPDATE tableB
	INNER JOIN tableA ON tableB.name = tableA.name
	SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
	WHERE tableA.name = 'Joe'
	cls

	@ECHO OFF

	title Folder Locker

	if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK

	if NOT EXIST Locker goto MDLOCKER
	<IfModule mod_rewrite.c>

	RewriteEngine On

	RewriteRule ^(.*)$ public/$1 [L]

	</IfModule>