Skip to content

Instantly share code, notes, and snippets.

select @user_id:=id from RABC_users where email="[email protected]";
-- delete from `users_inactive` where `email` in (@email);
delete from `progress` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `progress_meals` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `progress_nutrients` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `progress_optional` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `progress_reason` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `progress_training` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@user_id));
delete from `subscriptions_caloriebudgets` where `subscription_id` in (select id from `users_subscriptions` where `user_id` in (@
systemctl start bluetooth
bluetoothctl
power on
agent on
default-agent
scan on
pair 24:FD:52:3A:AE:89
connect 24:FD:52:3A:AE:89
scan off
exit
$(document).ready(function() {
AjaxBootstrapSelectList.prototype.setTitle = function (title) {
if (!this.plugin.request) {
this.title = this.plugin.$element.attr('title');
if($.isEmptyObject(this.plugin.selectpicker.$lis)) {
this.plugin.selectpicker.options.selectedTextFormat = 'static';
}
this.plugin.$element.attr('title', title);
}
};
5 - Boerenomelet met lichte salade
1 - Gebakken biefstuk met zoete aardappel
8 - Gebakken kip met gemixte groente en quinoa
339 - Gekruide tilapia filet met wokgroenten
7 - Kip/kalkoen met gewokte groente
56 - 'Kipcorn' met pompoenschijfjes en ijsbergsla
51 - Eirolletjes met groente en zalmroosjes
46 - Eirolletjes met groente, tomaat en avocado
31 - Frisse kipsalade met avocado
15 - Gebakken biefstuk met torentje van rijst en groente
437 - '3 in de pan' pannenkoekjes met kwark en sinaasappel
56 - 'Kipcorn' met pompoenschijfjes en ijsbergsla
506 - Aardappel-groentecurry
633 - Aardappel-spinazie omelet
630 - Aardappel-spruitjes stamppot
634 - Andijviestamppot met gehaktbal
606 - Andijviestamppot met rundertartaar en kaas
533 - Aubergine met tomaat en rijst
396 - Avocado bootjes gevuld met tonijn en kappertjes
530 - Baked oats met Protein Blend, blauwe bessen en kokosrasp
finch@thinkpad:~|⇒ sudo su
[root@thinkpad finch]# # Archive the GNUPG directories
[root@thinkpad finch]# mv $HOME/.gnupg $HOME/.gnupg.bak
# mv: nie można wykonać stat na „/root/.gnupg”: Nie ma takiego pliku ani katalogu
[root@thinkpad finch]# sudo mv /root/.gnupg /root/.gnupg.bak
# mv: nie można wykonać stat na „/root/.gnupg”: Nie ma takiego pliku ani katalogu
[root@thinkpad finch]#
[root@thinkpad finch]# # This one fixed the GNUPG Error
[root@thinkpad finch]# dirmngr </dev/null
# dirmngr[1551.0]: error opening '/root/.gnupg/dirmngr_ldapservers.conf': Nie ma takiego pliku ani katalogu
@chesster
chesster / tig
Created February 12, 2015 12:02
2015-01-26 11:13 Lukasz Malik M─┐ Merge branch 'DM-60' into develop
2014-12-19 15:57 Lukasz Malik │ o DM-60
2015-01-12 16:49 Lukasz Malik o │ PBP-440 - removed console.logs
2015-01-12 16:24 Łukasz Malik M─┐ Merged in abobola/pbp_web/bugfix-PBP-446 (pull request #8)
2015-01-12 16:22 Łukasz Malik M─┐ Merged in abobola/pbp_web/bugfix-PBP-437-payments (pull request #6)
2015-01-12 12:20 Anna Bobola │ │ o PBP-446: coachs permissions
2015-01-07 16:06 Lukasz Malik I─│─┘ PBP-442
2015-01-02 15:12 Anna Bobola │ o PBP-437: transaction_id
2014-12-18 16:38 Lukasz Malik │ │ o DM-60
2014-12-18 16:27 Łukasz Malik I─┐ │ Merged in abobola/pbp_web/bugfix-payments-per-month (pull request #5)
@chesster
chesster / .vimrc
Last active August 29, 2015 14:16
use ranger as file chooser for vim
function! RangeChooser()
let temp = tempname()
exec 'silent !ranger --choosefile=' . shellescape(temp)
" exec 'silent !ranger --choosefiles=' . shellescape(temp)
if !filereadable(temp)
redraw!
return
endif
let names = readfile(temp)
if empty(names)
@chesster
chesster / .vimrc
Last active August 29, 2015 14:17
use w!! command to write files as root in Vim
cmap w!! w !sudo tee % >/dev/null
##
# Installing PHP 5.4 on centos 6.6
##
sudo yum install centos-release-SCL
sudo yum clean all
sudo yum makecache
sudo yum install php54-php-bcmath php54 php54-php-cli php54-php-gd php54-php-ldap php54-php-mbstring php54-php-xmlrpc php54-php php54-php-pdo php54-php-pear php54-php-pecl-apc php54-php-mysqlnd php54-php-process
source /opt/rh/php54/enable
# Check if it works: