當你用illustrator做完layout design 後會發現有好多link file 同埋fonts
你想比其他人改你個AI file 你需要抄晒所有linking file 同fonts
ArtFile 可以幫到你,ArtFIle 係Adobe Illustrator 既plug-in 可以做到export 所有file path
» 2013 » January の記事
apt-get install php5-mcrypt /etc/init.d/apache2 restart
如果php connect mysql 時出現以下情況
Warning: mysqli_connect(): (HY000/2002): No such file or directory in *****.php on line 8 Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in *****.php on line 9 Connect failed
只要將connect DB 由localhost 改回127.0.0.1 就可以了
define('DATABASE_SERVER', '127.0.0.1');
在config.inc.php 加上或修改以下coding
$cfg['LoginCookieValidity'] = 3600 * 9; // 9 hours
完成
linux command 搵folder 入面 jpg,png,gif 以外的files
假設要找尋的folder 為 /var/www 的所有file
find . ! -name '*.jpg' ! -name '*.png' ! -name '*.gif'
SELECT `accountname` FROM `tablename` where `log_date`>'2012-12-30 00:00:00' and `log_date`<'2013-01-03 23:59:59' group by `log_date`,`accountname` having COUNT(DISTINCT date(log_date));
~ 列出連續5天有紀錄 ~
先要create function
DELIMITER // CREATE FUNCTION bits_find_N1(bits BIGINT, trait BIGINT) RETURNS BOOL BEGIN WHILE bits <> 0 DO IF ((bits & trait) = trait) THEN RETURN TRUE; END IF; SET bits = bits >> 1; END WHILE; RETURN FALSE; END// DELIMITER ;
mysql statement
SELECT accountname AS bit FROM tablename WHERE log_date BETWEEN '2012-12-30 00:00:00' AND '2013-01-03 23:59:59' GROUP BY uid HAVING bits_find_N1(BIT_OR(1 << datediff(log_date, '2012-12-30')), b'11111') IS TRUE;
如果某column 數目要到一定數目
SELECT accountname AS bit, sum(cardamount) FROM tablename WHERE log_date BETWEEN '2012-12-30 00:00:00' AND '2013-01-03 23:59:59' GROUP BY uid HAVING bits_find_N1(BIT_OR(1 << datediff(log_date, '2012-12-30')), b'11111') IS TRUE and sum(cardamount)>=1200;
詳細可參考
http://www.mysqlops.com/2012/03/06/an_interesting_query.html
先安裝RootKit Hunter
cd /tmp wget http://ncu.dl.sourceforge.net/project/rkhunter/rkhunter/1.4.0/rkhunter-1.4.0.tar.gz
tar -xvf rkhunter-1.4.0.tar.gz cd rkhunter-1.4.0 ./installer.sh --layout default --install
cd /usr/local/bin mv rkhunter /usr/bin/
之後update db
rkhunter --update rkhunter --propupd
之後要修改/etc/rkhunter.conf
nano /etc/rkhunter.conf
加入hidden file whitelist
SCRIPTDIR=/usr/local/lib/rkhunter/scripts ALLOWHIDDENDIR="/etc/.java" ALLOWHIDDENDIR="/dev/.udev" ALLOWHIDDENFILE="/dev/.initramfs" SCRIPTWHITELIST=/usr/bin/unhide.rb
Scan Machine 方法
rkhunter --checkall
完成
rm -r rkhunter-1.4.0 rm -r rkhunter-1.4.0.tar.gz
« Previous Page | HOME |
Recent Comments