Skip to content

Instantly share code, notes, and snippets.

View DILL44's full-sized avatar
🌍
on Idcity

Nicolas DILL44

🌍
on Idcity
12 followers · 19 following
View GitHub Profile
@DILL44
DILL44 / node_users_realation_drupal
Created November 29, 2014 02:42
sql requests for show relation between nodes (content) and users
comming bash
SELECT `users`.`name` , `users`.`mail` , `role`.`name`
FROM `users` , `role` , `users_roles`
WHERE `users`.`uid` = `users_roles`.`uid`
AND `role`.`rid` = `users_roles`.`rid`
LIMIT 0 , 30
SELECT `node`.`nid` , `node`.`type` , `node`.`title` , `node`.`status` , `users`.`uid` , `users`.`name` , `users`.`mail`
FROM `node` , `users`
@DILL44
DILL44 / decompresition.sh
Last active November 30, 2015 12:41
mes logiciel linux
###############sytem
sudo apt-get install vim htop git
###############hardware
sudo apt-get install fritzing arduino kicad
###############admin
sudo apt-add-repository 'deb http://liveusb.info/multisystem/depot all main'
wget -q -O - http://liveusb.info/multisystem/depot/multisystem.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install virtualbox testdisk multisystem gsmartcontrol netdiscover
sudo adduser "$USER" adm
@DILL44
DILL44 / config vim
Last active August 29, 2015 13:59
set nocp
syn on
set syntax =on
filetype indent plugin on
set incsearch
set cursorline
set showmatch
@DILL44
DILL44 / adddbuser
Last active August 29, 2015 13:58
#!/bin/bash
read -s -p "Enter root DB Password: " PASSDB
echo ""
read -s -p "Enter new DB Password: " PASSWORD
echo ""
read -s "Enter website server host: " HOST
echo ""
EXPECTED_ARGS=2
@DILL44
DILL44 / select_link_jquery.html
Created February 22, 2014 11:43
@DILL44
DILL44 / bitonio_lampe_velo_
Last active August 29, 2015 13:56
hautrec=84;
largrec=50;
longrec=35;
epeseur=12;
rayon=35;
trou=7;
hautren=37;
largren=26;
difference() {
@DILL44
DILL44 / pnt_en_H.ino
Created February 13, 2014 16:11
int sens1_1 = 8;
int sens1_2 = 9;
int sens2_1 = 10;
int sens2_2 = 11;
int segond=1000;
int led = 13;
void setup() {
pinMode(sens1_1, OUTPUT);
pinMode(sens1_2, OUTPUT);
@DILL44
DILL44 / cups
Created January 31, 2014 11:02
#!/bin/bash
liste(){
ps -eo "%p %P %r %U %G %y %x %c %C"
ecrire=expr`ps -eo "%p %P %r %U %G %y %x %c %C"`
}
arbre_par_pid(){
read -p "donnez le pid d un processus: " pid
while [ ! "$(echo $pid | grep "^[ [:digit:] ]*$")" ]
do
echo "$processus n'est pas un pid "
@DILL44
DILL44 / exo_bash_custom_cp.bash
Last active August 29, 2015 13:55
!#/bin/bash
#exercie
#
#etape 1
#
#creer fonction bash qui permet d'afficher les information d'un fichier ou d'un dossier:
#
#fichier.sh est un fichier
#koalas a les droits en lecture , a les droits en ecriture , a les droits en execution
@DILL44
DILL44 / arduino_led.ino
Last active December 23, 2015 12:29
void setup() {
Serial.begin(9600);
pinMode(13, OUTPUT);
}
void loop() {
if (Serial.available() > 0) { // if there is data coming from the serial port
int data = (int)Serial.read(); // get that data and print it
Serial.println(data);
if (data == 1) { // do what you want with this data
digitalWrite(13, HIGH);