Stuff

by ethereal1
created with TinyPad



 

Large File Search:

====================

find . -type f -size +5000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

 

Anulaciones Query:

====================

SELECT o.transactionCod, o.id, o.nspCod, u.email FROM users u, operationsnew o WHERE o.transactionCod = 'W9FXPGW' AND u.id=o.iduser

 

Cancelation Query:

====================

SELECT u.firstName,u.lastName, u.document, u.tel, u.email, o.transactionCod,o.performanceDate, o.movieName, o.idCinema, o.butacas FROM users u, operationsnew o WHERE o.idCinema = '103' AND o.movieName Like '%avatar%' AND o.transactionCod != '0' and o.performanceDate LIKE '2010-09-27 19:45%' AND u.id=o.iduser

 

Next DNS'

===================

ns1.nextsolution.net - 64.94.136.11

ns2.nextsolution.net - 64.237.45.34

ns3.nextsolution.net - 64.94.136.13

ns5.nextsolution.net - 212.100.247.15

 

Concurso Query

===================

SELECT DISTINCT nombre, dni, email, telefono, sucursal, concurso

FROM `concursos_2009`

WHERE `concurso` LIKE 'CONCURSO %Milenium 2%'

AND sucursal NOT LIKE '%alto noa%'

AND sucursal NOT LIKE '%salta%'

AND sucursal NOT LIKE '%cordoba%'

AND sucursal NOT LIKE '%Patio Olmos%'

AND sucursal NOT LIKE '%centro%'

AND sucursal NOT LIKE '%Sucursal%'

ORDER BY RAND()

LIMIT 0 , 15

 

Multiplex Pure-FTPd

===================

(puertos 2021 y 21) en /etc/pure-ftpd.conf y /etc/pure-ftpd_defualt.conf

Cambios /etc/rc.d/init.d/pure-ftpd:

$DAEMONIZE $fullpath /etc/pure-ftpd.conf -O clf:/var/log/xferlog $OPTIONS --daemonize

$DAEMONIZE $fullpath /etc/pure-ftpd_default.conf -O clf:/var/log/xferlog $OPTIONS --daemonize