Kremilly’s gists

Kremilly / tlds-countries.json

Last active July 24, 2020 05:25

	[
	{
	"country": "Afghanistan",
	"tld": "af"
	},
	{
	"country": "Albania",
	"tld": "al"
	},
	{

Kremilly / email.css

Created August 15, 2020 15:34

*{margin:0;padding:0;font-family:"Helvetica Neue", Helvetica, Helvetica, Arial, sans-serif}.logo{width:10em}img{max-width:100%}.center{text-align:center}.italic{font-style:italic}.border{border:0.05em solid rgba(192,192,192,0.5)}.border-bottom{border-bottom:0.05em solid rgba(192,192,192,0.5)}.bg{background:linear-gradient(to top left, #fff 0, #f7f7f7 100%)}.collapse{margin:0;padding:0}.padding{padding-top:.75em;padding-bottom:.75em}body{-webkit-font-smoothing:antialiased;-webkit-text-size-adjust:none;width:100% !important;height:100%;background:#f7f7f7}a{color:#2ba6cb}.btn{text-decoration:none;color:#fff;background-color:#666;padding:10px 16px;font-weight:700;margin-right:10px;text-align:center;cursor:pointer;display:inline-block}p.callout{padding:10px;font-size:1em;font-weight:600;color:#0076aa;background-color:#fff;margin-bottom:15px}.callout a{font-weight:700;color:#2ba6cb}table.social{background-color:#ebebeb}.social .soc-btn{padding:3px 7px;font-size:12px;margin-bottom:10px;text-decoration:none;color:#ff

Kremilly / iso-countries.json

Created February 6, 2021 05:43

	[
	{
	"Code": "AF",
	"Name": "Afghanistan"
	},
	{
	"Code": "AX",
	"Name": "Åland Islands"
	},
	{

Kremilly / collations.json

Created April 17, 2021 07:44

Collations supported in phpmyadmin

	[
	"big5_chinese_ci",
	"big5_bin",
	"big5_chinese_nopad_ci",
	"big5_nopad_bin",
	"dec8_swedish_ci",
	"dec8_bin",
	"dec8_swedish_nopad_ci",
	"dec8_nopad_bin",
	"cp850_general_ci",

Kremilly / mysql-queries.json

Last active November 23, 2021 21:13

	{
	"server_queries": {
	"processes": "SHOW FULL PROCESSLIST",
	"variables": "SHOW VARIABLES",
	"engines": "SHOW ENGINES",
	"charsets": "SHOW CHARACTER SET",
	"collations": "SHOW COLLATION",
	"logs": "SELECT * FROM mysql.general_log ORDER BY event_time DESC LIMIT __param_offset__, __param_limit__"
	},
	"users_queries": {

Kremilly / intellisense.json

Created November 23, 2021 07:31

	{
	"version": "1.1.27",
	"copyright": "Colisoft",
	"license": "Colisoft License",
	"docs_page": "https://dbackpro.github.io/intellisense/#/",
	"keywords": {
	"using": "USING is useful when both the tables share a column of the exact same name on which they join.",
	"btree": "A B-tree is a balanced tree not a binary tree. Once created, the database maintains the index automatically. It applies every insert, delete and update to the index and keeps the tree in balance, thus causing maintenance overhead for write operations.",
	"engine": "Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle recommends using it for tables except for specialized use cases.",
	"aria": "Aria is a storage engines for the MariaDB and MySQL relational database management systems. Its goal is to make a crash-safe alternative to MyISAM.",

Kremilly / all-links.json

Last active November 24, 2021 10:03

	{
	"version": "1.0.0",
	"author": "Colisoft",
	"apis": {
	"core": "https://localhost/website/apis/",
	"ipify": "https://api.ipify.org/?format=json",
	"is_online": "https://is-online.herokuapp.com?verify={param1}",
	"gravatar": "https://s.gravatar.com/avatar/{param1}?s={param2}",
	"link_scraper": "https://linkscraper.herokuapp.com/gui?link={param1}",
	"virus_total": "https://www.virustotal.com/vtapi/v2/url/report?apikey={param1}&resource={param2}"

Kremilly / activate-w11.bat

Created November 8, 2022 19:51

Script for activate Windows 11 Pro

	slmgr /ipk W269N-WFGWX-YVC9B-4J6C9-T83GX
	slmgr /skms kms8.msguides.com
	slmgr /ato

Kremilly / http-status-code.json

Created March 25, 2023 21:23

HTTP Status Code

	{
	"100": {
	"code": "100",
	"message": "Continue",
	"description": "indicates that the initial part of a request has been received and has not yet been rejected by the server.",
	"spec_title": "RFC7231#6.2.1",
	"spec_href": "https://tools.ietf.org/html/rfc7231#section-6.2.1"
	},
	"101": {
	"code": "101",

Kremilly / countries.json

Last active April 1, 2023 11:24

ISO code of countries in world

	[{"id":4,"alpha2":"af","alpha3":"afg","name":"Afghanistan"},
	{"id":8,"alpha2":"al","alpha3":"alb","name":"Albania"},
	{"id":12,"alpha2":"dz","alpha3":"dza","name":"Algeria"},
	{"id":20,"alpha2":"ad","alpha3":"and","name":"Andorra"},
	{"id":24,"alpha2":"ao","alpha3":"ago","name":"Angola"},
	{"id":28,"alpha2":"ag","alpha3":"atg","name":"Antigua and Barbuda"},
	{"id":32,"alpha2":"ar","alpha3":"arg","name":"Argentina"},
	{"id":51,"alpha2":"am","alpha3":"arm","name":"Armenia"},
	{"id":36,"alpha2":"au","alpha3":"aus","name":"Australia"},
	{"id":40,"alpha2":"at","alpha3":"aut","name":"Austria"},

Kremilly Kremilly