Hoofdpagina: verschil tussen versies

/etc/modules

create trigger MAG_CUST_ID_BR
before insert on MAGENTO_CUSTOMERS
for each row
begin
select MAG_CUST_ID.nextval into :new.CUST_ID from SYS.dual;
end;
update magento_products mp 
   set (price) = (
        select prijs3 
          from artikelen 
         where mp.sku = artikelen.artikel_nr
   )
   where ( nvl(mp.price,0) = 0) 
     and sku in (
        select to_char(artikel_nr) 
          from artikelen 
         where nvl(prijs3,0) > 0)
     )
UPDATE suppliers	
   SET supplier_name = (
         SELECT customers.name
           FROM customers
          WHERE customers.customer_id = suppliers.supplier_id)
            AND 1=1
       ),
       roland = 1
 WHERE EXISTS (
         SELECT customers.name
           FROM customers
          WHERE customers.customer_id = suppliers.supplier_id
            AND 1=1
       );
   AND 1=1
select *
from  
( select * 
  from emp 
  order by sal desc ) 
where ROWNUM <= 5;
select * from 
( select a.*, ROWNUM rnum from 
  ( <your_query_goes_here, with order by> ) a 
  where ROWNUM <= :MAX_ROW_TO_FETCH )
where rnum  >= :MIN_ROW_TO_FETCH;
MERGE INTO Movie_Ratings M
       USING (SELECT 1 AS mid, 3 AS aid, 8 AS rating FROM dual) N
          ON (M.mid = N.mid AND M.aid = N.aid)
       WHEN     MATCHED THEN UPDATE SET M.rating = N.rating
       WHEN NOT MATCHED THEN INSERT(  mid,   aid,   rating)
                             VALUES(N.mid, N.aid, N.rating);
DELETE FROM core_url_rewrite WHERE NOT HEX(request_path) REGEXP '^([0-7][0-9A-F])*$';
delimiter |
DROP TRIGGER IF EXISTS after_insert_member|
 CREATE TRIGGER after_insert_member AFTER INSERT ON mVibesEMail.EmailPromotionQueue
  FOR EACH ROW BEGIN
     UPDATE mVibes.Member SET PromotionDateTime = NOW(), NumberOfPromotions = NumberOfPromotions+1 WHERE MemberId = NEW.MemberId;
  END;
|
delimiter ;
tune2fs -c 0 -i 0d /dev/disk/by-id/usb-WD_My_Book_575532553130303331333730-part1

May 11 11:20:23 localhost automount[18777]: >> /dev/disk/by-id/usb-WD_My_Book_575532553130303331333730-part1 has been mounted 35 times without being checked, check forced.

Subsystem sftp /usr/lib/openssh/sftp-server -u 002

Subsystem sftp internal-sftp

Match group sftponly
         ChrootDirectory /home/%u
         X11Forwarding no
         AllowTcpForwarding no
         ForceCommand internal-sftp
adduser --ingroup sftponly --shell /bin/false <username>
tcpdump -nvv -s 0 -w snoopport10295.snoop port 10295
cat logs/access_log|grep 05/Feb/2007:14|awk '{print $1}'|sort|uniq -c
lsof -p #PID
ls -ltr|tail -n1
tar xvfz backup.tar.gz home/www/login.mobilebridges.com --exclude=*.log --exclude=*.xml
tar tvfz backup.tar.gz home/www/login.mobilebridges.com --exclude=*.log --exclude=*.xml
dd if=/dev/zero of=/dev/hda bs=1M
1. Use fdisk to create the filesystem: fdisk /dev/hda - follow the prompts
2. Format it using mkfs.vfat -F 32 /dev/hda6
3. Add it to fstab

adduser --gid 1010 --shell /usr/bin/false --home /home/www/peru charly
find /home/www/login.mobilebridges.com/htdocs/Delivery/Error/ -mtime +5 -exec rm {} \;
rename 's/\.11\.csv$/\.csv/' *.csv
/home/www/peru# du --max-depth=1 -h
tcpdump host 85.146.37.248 and icmp
netstat -pan|grep :80|sed 's/:/ /g'|awk '{print $6}'|sort|uniq -c
rsync -av --rsh='ssh -p2222' source destination
svnadmin create --fs-type fsfs /var/svn-repos/project_zen
chown -R www-data:subversion /var/svn-repos/*
chmod -R 770 /var/svn-repos/*
<Location /project_zen>
        DAV svn
        SVNPath /var/svn-repos/project_zen
        AuthType Basic
        AuthName "Subversion Repository"
        AuthUserFile /etc/apache2/dav_svn.passwd
        Require valid-user
#       SSLRequireSSL
</Location>

echo "Check deze logfile" | mutt -a /var/log/message rolandow@gmail.com
$ su
# apt-get install build-essential
# apt-get install foomatic-filters
# apt-get install cupsys
$ wget -O foo2zjs.tar.gz http://foo2zjs.rkkda.com/foo2zjs.tar.gz
$ tar zxf foo2zjs.tar.gz
$ cd foo2zjs
$ make
$ ./getweb 1020
OR other printer
$ su
# make install install-hotplug cups
2012-02-20 11:12:42,405 fail2ban.actions.action: ERROR  iptables -N fail2ban-apache
iptables -A fail2ban-apache -j RETURN
iptables -I INPUT -p tcp -m multiport --dports http,https -j fail2ban-apache returned 200

        def __processCmd(self, cmd, showRet = True):
                beautifier = Beautifier()
                for c in cmd:
                        time.sleep(0.1)
                        beautifier.setInputCmd(c)
                        try:
ab -n 100 -c 10 http://bla.nl/test/
cd /home/www/marticle
chown -R marticle:marticle *
find . -type d -exec chmod 2771 '{}' \;
find . -type f -exec chmod 0664 '{}' \;
/usr/bin/php "$@"
man -P "less -p 'Expands  to  the positional'" bash
for i in *bmp; do convert "$i" "${i%.*}.jpg" ; done
mogrify -format jpg *.bmp
/* Global UI font */
* { 
  font-size: 10pt !important;
}
<?xml version="1.0"?>
<root>
  <devicevendordef>
    <vendorname>LOGITECH</vendorname>
    <vendorid>0x046d</vendorid>
  </devicevendordef>

  <deviceproductdef>
    <productname>LOGITECH_K750_KEYBOARD</productname>
    <productid>0x4012</productid>
  </deviceproductdef>

  <item>
    <name>Swap the Tilda(~) key with Section (§) (logitech k750)</name>
    <identifier>private.logitech_k750_tilda_section</identifier>
    <device_only>DeviceVendor::LOGITECH, DeviceProduct::LOGITECH_K750_KEYBOARD</device_only>
    <autogen>__KeyToKey__ KeyCode::BACKQUOTE,  KeyCode::UK_SECTION</autogen>
    <autogen>__KeyToKey__ KeyCode::UK_SECTION, KeyCode::BACKQUOTE</autogen>
  </item>
</root>
-vcodec flv -f flv -r 29.97 -vf scale=640:480 -aspect 4:3 -b:v 700k -g 160 -cmp dct  -subcmp dct  -mbd 2 -flags +aic+cbp+mv0+mv4 -trellis 1 -ac 1 -ar 44100 -b:a 56k

flvmeta tom_klimt.flv tom_klimt_stream.flv

ffmpeg -i tom.mp4 -ar 22050 -f flv -qmax 2 tom_q2_no_scale.flv

NET USE * http://cloud.stumpel.nl/files/webdav.php yourPass /USER:roland
cipher /w:x:\folder

route delete 0.0.0.0
route add 81.175.103.10 mask 255.255.255.255 172.16.0.10
route add 0.0.0.0 mask 0.0.0.0 172.16.255.14
netsh interface ip set dns "LAN-verbinding" static 8.8.8.8 primary
netsh interface ip add dns name="LAN-verbinding" 208.67.222.222
netsh interface ip add dns name="LAN-verbinding" 208.67.220.220
netsh interface ip add dns name="LAN-verbinding" 172.16.0.131
#threadPaneBox{-moz-box-direction: reverse;}
2010-10-18 11:22:45 rejected EHLO from localhost [127.0.0.1]: syntactically invalid argument(s): (no argument given)

production:
  delivery_method: :sendmail
#  delivery_method: :smtp
#  smtp_settings:
#    address: "localhost"
#    port: 25

setsebool -P httpd_can_network_connect 1
error: Your local changes to 'bin/svnstat' would be overwritten by merge.  Aborting.
Please, commit your changes or stash them before you can merge.

git fetch --all
git reset --hard origin/master
tcpdump -nniany -vvs0 -w huesman2.pcap not port 22
IFS=$'\n' ; for f in `ls -1 *.mp3` ; do FILE=$(basename "$f" .mp3) ; ffmpeg -i "$FILE.mp3" -ar 8000 -ac 1 -ab 64 "$FILE.wav" -ar 8000 -ac 1 -ab 64 -f alaw "$FILE.alaw" -map 0:0 -map 0:0 ; done
[radio]
mode=custom
application=/usr/local/bin/mpg123 -q -s --mono -r 8000 -f 4096 -b 0 http://icecast.omroep.nl/3fm-sb-mp3
#screensave uitzetten
/usr/bin/setterm -blank 0 -powersave off -powerdown 0
protocol=namecheap
use=web, web=checkip.dyndns.com/, web-skip='IP Address'
server=dynamicdns.park-your-domain.com
login=rolandow.net
password='key'
home

@@ Regel 441: / Regel 441: @@
 <source lang="bash">
 for i in *bmp; do convert "$i" "${i%.*}.jpg" ; done
+</source>
+Een andere mogelijkheid is mogrify gebruiken, dat ook bij ImageMagick hoort:
+<source lang="bash">
+mogrify -format jpg *.bmp
 </source>

Server	authsmtp.vodafone.nl
User	mail06xxxxxxxx (xxx = telnr)
Password	Zelfde als op My Vodafone

Hoofdpagina: verschil tussen versies

Versie van 27 jun 2013 om 08:04

Inhoud

PHP

Oracle

Toad driver

Update from table

Limit rows

datum vergelijken met sysdate

INSERT .. ON DUPLICATE

mySQL

remove high ascii rows

trigger

Linux

rsync

Passive FTP

Disable periodical fsck check's

SFTP umask

SFTP chroot

Software RAID

Linux trics

SVN

Create repository

Mail attachment command-line

sar / sysstat / rs-sysmon monitor

iptables

CUPS / HP Laserjet 1020 printer

Mac Client

device descriptor read/8, error -110

fail2ban

returned 200

Apache benchmark

Nagios

chmod directories

positional parameters $* $@

batch convert .bmp to .jpg

Mac OS X

Thunderbird

Shortcut (maximize)

Toetsen omdraaien

Windows 7

USB disk

Partitie maken

HP support assistant

Software

Wintendo

FLV filmpjes

FLV filmpjes op de site

CD/DVD branden

Virtueel CD/DVD station

WebDAV mounten

Flowcharts

Naar DVD converteren

Cipher: wipe files

Linux

DNS cache

MS-DOS

Route

DNS

Magento

HP

Mozilla Thunderbird

Redmine

Exchange

Signature

Video

RegExp (textpad)

Mobile Bridges standards naar Zend standards

Dreamhost

Backup

TransIP

Plesk 11

wordpress

Encoding

Magento

Git

Update forceren

Rescue disk

HIREN

Android