Rajesh Patadiya RajeshPatadiya

## vmwk17key.txt
Install VMWare Workstation PRO 17 (Read it right. PRO!)

Sub to me on youtube pls - PurpleVibe32
if you want more keys - call my bot on telegram. @purector_bot (THE BOT WONT REPLY ANYMORE) - Or: https://cdn.discordapp.com/attachments/1040615179894935645/1074016373228978277/keys.zip - the password in the zip is 102me.
---
This gist can get off at any time.
PLEASE, DONT COPY THIS. IF YOU FORK IT, DONT EDIT IT.
*If you have a problem comment and people will try to help you!
*No virus
*No spam just license key

## nearby-coordinates.sql
---
METHOD 1

This should roughly sort the items on distance in MySQL, and should work in SQLite.
If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
---
SELECT *
FROM table
ORDER BY ((lat-$user_lat)*(lat-$user_lat)) + ((lng - $user_lng)*(lng - $user_lng)) ASC

## phpstorm_evaluation_license_reset.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                RajeshPatadiya
                / phpstorm_evaluation_license_reset.md
            
            
              Created
              August 3, 2022 09:19
                — forked from Gyvastis/phpstorm_evaluation_license_reset.md
            
              
                PhpStorm reset evaluation license/period
              
          
    PhpStorm reset evaluation license/period

Make sure to export/import your settings through File -> Manage IDE settings before/after
Windows 10


Close PHPStorm
Run these in PowerShell to remove PhpStorm configuration:

Remove-Item '.\AppData\Local\Jetbrains\PhpStorm*'
Remove-Item '.\AppData\Roaming\Jetbrains\PhpStorm*'


## hosts
# This hosts file is brought to you by Dan Pollock and can be found at
# http://someonewhocares.org/hosts/
# You are free to copy and distribute this file for non-commercial uses,
# as long the original URL and attribution is included.

#<localhost>
127.0.0.1	localhost
127.0.0.1	localhost.localdomain
255.255.255.255	broadcasthost
::1		localhost

## double_metaphone.sql
-- This SQL implements the Double Metaphone algorythm (c) 1998, 1999 by Lawrence Philips
-- it was translated to Python, and then to SQL from the C source written by Kevin Atkinson (http://aspell.net/metaphone/)
-- By Andrew Collins (atomodo.com) - Feb, 2007 who claims no rights to this work
-- github.com/AtomBoy/double-metaphone
-- Tested with MySQL 5.1 on Ubuntu 6.01 and Ubuntu 10.4
-- Updated Nov 27, 2007 to fix a bug in the 'CC' section
-- Updated Jun 01, 2010 to fix a bug in the 'Z' section - thanks Nils Johnsson!
-- Updated Jun 25, 2010 to fix 16 signifigant bugs - thanks again Nils Johnsson for a spectacular
--   bug squashing effort. There were many cases where this function wouldn't give the same output
--   as the original C source that were fixed by his careful attention and excellent communication.

## sharing_session.html

<!DOCTYPE html>
<html>
	<head>
		<title>Sharing sessionStorage between tabs for secure multi-tab authentication</title>
	</head>
	<body>
		<h3><a href=''>sessionStorage</a></h3>
		<h3 id="stData"></h3>
		<button id="btnSet">Set session storage</button>

## aws-multipartUpload.js
// Based on Glacier's example: http://docs.aws.amazon.com/AWSJavaScriptSDK/guide/examples.html#Amazon_Glacier__Multi-part_Upload
var fs = require('fs');
var AWS = require('aws-sdk');
AWS.config.loadFromPath('./aws-config.json');
var s3 = new AWS.S3();

// File
var fileName = '5.pdf';
var filePath = './' + fileName;
var fileKey = fileName;

## s3 and laravel.txt
S3

simple research:
https://artisansweb.net/upload-file-s3-using-laravel-filesystem/
https://mattstauffer.com/blog/laravel-5.0-cloud-file-drivers/
https://itsolutionstuff.com/post/laravel-5-amazon-s3-file-upload-tutorial-part-1example.html
https://www.youtube.com/watch?v=BK_hhyBJxuU
https://chrisblackwell.me/upload-files-to-aws-s3-using-laravel/
https://www.youtube.com/watch?v=nMDIVQsESBY&lc=UgxINeYXcc618oxgy-14AaABAg

## adminer_setup.sh
# Secure adminer setup
# Author Taras Kozlov

# download adminer to separate directory
mkdir -p /var/www/admin
cd /var/www/admin
wget http://www.adminer.org/latest.php -O adminer.php
echo '<?php phpinfo(); >' > info.php

sudo -i

## EloquentCheatSheet.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                RajeshPatadiya
                / EloquentCheatSheet.md
            
            
              Created
              February 2, 2021 17:25
                — forked from avataru/EloquentCheatSheet.md
            
              
                Eloquent relationships cheat sheet
              
          
    Overview

Source: https://medium.com/@Mahmoud_Zalt/eloquent-relationships-cheat-sheet-5155498c209


One to one
(1-1)
One to many
(1-n)
Poly one to many
(1x-n)
Many to many
(n-n)
Poly many to many
(nx-n)


Number of models
2 only
2 only
3 and above
2 only
3 and above


Number of tables
2 (1/model)
2 (1/model)
3+ (1/model)
3 (1/model + pivot)
4+ (1/model + pivot)


Pivot table
-
-
-
required
	Install VMWare Workstation PRO 17 (Read it right. PRO!)

	Sub to me on youtube pls - PurpleVibe32
	if you want more keys - call my bot on telegram. @purector_bot (THE BOT WONT REPLY ANYMORE) - Or: https://cdn.discordapp.com/attachments/1040615179894935645/1074016373228978277/keys.zip - the password in the zip is 102me.
	---
	This gist can get off at any time.
	PLEASE, DONT COPY THIS. IF YOU FORK IT, DONT EDIT IT.
	*If you have a problem comment and people will try to help you!
	*No virus
	*No spam just license key
	---
	METHOD 1

	This should roughly sort the items on distance in MySQL, and should work in SQLite.
	If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
	---
	SELECT *
	FROM table
	ORDER BY ((lat-$user_lat)(lat-$user_lat)) + ((lng - $user_lng)(lng - $user_lng)) ASC
	# This hosts file is brought to you by Dan Pollock and can be found at
	# http://someonewhocares.org/hosts/
	# You are free to copy and distribute this file for non-commercial uses,
	# as long the original URL and attribution is included.

	#<localhost>
	127.0.0.1 localhost
	127.0.0.1 localhost.localdomain
	255.255.255.255 broadcasthost
	::1 localhost
	-- This SQL implements the Double Metaphone algorythm (c) 1998, 1999 by Lawrence Philips
	-- it was translated to Python, and then to SQL from the C source written by Kevin Atkinson (http://aspell.net/metaphone/)
	-- By Andrew Collins (atomodo.com) - Feb, 2007 who claims no rights to this work
	-- github.com/AtomBoy/double-metaphone
	-- Tested with MySQL 5.1 on Ubuntu 6.01 and Ubuntu 10.4
	-- Updated Nov 27, 2007 to fix a bug in the 'CC' section
	-- Updated Jun 01, 2010 to fix a bug in the 'Z' section - thanks Nils Johnsson!
	-- Updated Jun 25, 2010 to fix 16 signifigant bugs - thanks again Nils Johnsson for a spectacular
	-- bug squashing effort. There were many cases where this function wouldn't give the same output
	-- as the original C source that were fixed by his careful attention and excellent communication.

	<!DOCTYPE html>
	<html>
	<head>
	<title>Sharing sessionStorage between tabs for secure multi-tab authentication</title>
	</head>
	<body>
	<h3><a href=''>sessionStorage</a></h3>
	<h3 id="stData"></h3>
	<button id="btnSet">Set session storage</button>
	// Based on Glacier's example: http://docs.aws.amazon.com/AWSJavaScriptSDK/guide/examples.html#Amazon_Glacier__Multi-part_Upload
	var fs = require('fs');
	var AWS = require('aws-sdk');
	AWS.config.loadFromPath('./aws-config.json');
	var s3 = new AWS.S3();

	// File
	var fileName = '5.pdf';
	var filePath = './' + fileName;
	var fileKey = fileName;
	S3

	simple research:
	https://artisansweb.net/upload-file-s3-using-laravel-filesystem/
	https://mattstauffer.com/blog/laravel-5.0-cloud-file-drivers/
	https://itsolutionstuff.com/post/laravel-5-amazon-s3-file-upload-tutorial-part-1example.html
	https://www.youtube.com/watch?v=BK_hhyBJxuU
	https://chrisblackwell.me/upload-files-to-aws-s3-using-laravel/
	https://www.youtube.com/watch?v=nMDIVQsESBY&lc=UgxINeYXcc618oxgy-14AaABAg
	# Secure adminer setup
	# Author Taras Kozlov

	# download adminer to separate directory
	mkdir -p /var/www/admin
	cd /var/www/admin
	wget http://www.adminer.org/latest.php -O adminer.php
	echo '<?php phpinfo(); >' > info.php

	sudo -i
	One to one (`1-1`)	One to many (`1-n`)	Poly one to many (`1x-n`)	Many to many (`n-n`)	Poly many to many (`nx-n`)
Number of models	2 only	2 only	3 and above	2 only	3 and above
Number of tables	2 (1/model)	2 (1/model)	3+ (1/model)	3 (1/model + pivot)	4+ (1/model + pivot)
Pivot table	-	-	-	required