Kartones

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

arthurbeggs

#!/bin/bash

################################################################################
###                       OpenCV2 Installation Script                        ###
################################################################################
#            Source code at https://github.com/arthurbeggs/scripts             #
################################################################################
#                                                                              #
#     Feel free to copy and modify this file. Giving me credit for it is your  #
# choice, but please keep references to other people's work, which I don't     #

sloanlance

Editing remote files in Vim with SSH

1. Configure SSH

   In ~/.ssh/config, include the lines:

   Host *
   ControlPath ~/.ssh/sockets/%r@%h-%p
   

Sanix-Darker

<?php
    // Configure your keys (secret, piblic): https://www.google.com/recaptcha
    $siteKey = 'XXXXXXXXXXXXXXXXXXXXXX'; // votre clé publique
?>
<form action="submit.php">
....
  <div class="g-recaptcha" id="Optional-id"></div> 
</form>
<script src="https://www.google.com/recaptcha/api.js?onload=onloadCallback&render=explicit" async defer></script>
<script type="text/javascript" charset="utf-8">

Sanix-Darker

// Using the core $.ajax() method
$.ajax({
    // The URL for the request
    url: "post.php",
    // The data to send (will be converted to a query string)
    data: {
        id: 123
    },
    // Whether this is a POST or GET request
    type: "GET",

Geoyi

How to install virtualenv:

Install pip first

sudo apt-get install python3-pip

Then install virtualenv using pip3

sudo pip3 install virtualenv 

Sanix-Darker

sudo su -
cat >/etc/apt/sources.list.d/webupd8team-java.list<< EOF
deb http://ppa.launchpad.net/webupd8team/java/ubuntu trusty main
deb-src http://ppa.launchpad.net/webupd8team/java/ubuntu trusty main 
EOF
apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys EEA14886
apt-get update
apt-get install oracle-java8-installer
java -version

Sanix-Darker

// Sublime Text 3 License Keys //

Sublime Text 2.x (for all Builds)
—– BEGIN LICENSE —–
Andrew Weber
Single User License
EA7E-855605
813A03DD 5E4AD9E6 6C0EEB94 BC99798F
942194A6 02396E98 E62C9979 4BB979FE
91424C9D A45400BF F6747D88 2FB88078

Sanix-Darker

	function InsertOrNot($BD){ // Permet de savoir si oui ou non, un truc a ete inserer dans la base de donnees ou pas!
		$stmt = $BD->query("SELECT LAST_INSERT_ID()");
		$lastId = $stmt->fetch(PDO::FETCH_NUM);
		$lastId = $lastId[0];

		if($lastId>0){
	        echo "<center><i class=\"green\"><i class=\"fa fa-check\"></i> Op&eacute;ration &eacute;ffectu&eacute;e<i></center>";
	    }else{
	        echo "<center><i class=\"red\"><i class=\"fa fa-times\"></i>Erreur d&eacute;tect&eacute;e<i></center>";
	    }

Sanix-Darker

<?php 
	if(isset($_REQUEST['src'])){
		$file_name = $_REQUEST['src'];
		header('Content-Type: application/octet-stream');
		header("Content-Transfer-Encoding: Binary"); 
		header("Content-disposition: attachment; filename=\"".$file_name."\""); 
		readfile('../Your_Path_Here/'.$file_name);
		exit;
	}
?>