1. 做銷售要有強烈的企圖心 — 成功的欲望
2. 做銷售不要總是為了錢 — 有理想
3. 拜訪量是銷售工作的生命線 — 勤奮
4. 具備“要性”和“血性” — 激情
5. 世界上沒有溝通不了的客戶 — 自信
6. 先“開槍”後“瞄準” — 高效執行
7. 不當“獵手”當“農夫” — 勤懇
9. 勝則舉杯相慶，危則拼死相救 — 團結
8. 堅持不一定成功，但放棄一定失敗 — 執著
10. 今天的努力，明天的結果 — 有目標
[ 發表回應 ] ( 24預覽 ) | 常註連結 |
( 3 / 1784 )mysql> SELECT INET_ATON('209.207.224.40');
-> 3520061480
mysql> SELECT INET_NTOA(3520061480);
-> '209.207.224.40'
e.g.
SELECT `ipaddress` FROM `blockip` ORDERBY INET_ATON(`ipaddress`)
[ 發表回應 ] ( 26預覽 ) | 常註連結 |
( 3 / 1906 )crontab -e
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/php /opt/mailscanner_sql_blockip.php
#!/usr/local/bin/php
<?php
$linkptr = mysql_pconnect ("192.168.50.172","mailwatch","");
mysql_select_db("mailscanner",$linkptr);
$accessfile = "/etc/mail/access";
$sql = "SELECT clientip FROM `maillog` WHERE `sascore` >=10 and `timestamp` > DATE_ADD(now() ,INTERVAL -5 MINUTE) group by clientip ORDER BY INET_ATON(clientip)";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$sql = "SELECT `ipaddress` FROM`ac_blockip` WHERE `ipaddress`= '".$row['clientip']."'";
$resulttemp = mysql_query($sql);
list($r_ipaddress) = mysql_fetch_row($resulttemp);
mysql_free_result($resulttemp);
if ($r_ipaddress == $row['clientip']) {
$sql = "UPDATE ac_blockip SET score=(score + 1),`timeout`=DATE_ADD( now() ,INTERVAL (score*24) HOUR),`status`='B' where ipaddress='".$row['clientip']."'";
mysql_query($sql,$linkptr);
} else {
$sql = "INSERT INTO `ac_blockip`(`ipaddress`, `score`, `timeout`, `status`) VALUES ('".$row['clientip']."',1,DATE_ADD( now() ,INTERVAL 24 HOUR),'B')";
mysql_query($sql,$linkptr);
}
}
mysql_free_result($result);
$sql = "UPDATE `ac_blockip` SET `timeout`=0,`status`='R' where `status` = 'B' and `timeout` < now()";
mysql_query($sql,$linkptr);
$sql = "SELECT `ipaddress` FROM `ac_blockip` where status = 'B'";
$result = mysql_query($sql);
$temp = "";
$fh = fopen($accessfile, 'w') or die("can't open file");
while ($row = mysql_fetch_assoc($result)) {
$temp1 = $row['ipaddress']."\t550 Address invalid\n";
fwrite($fh, $temp1);
}
fclose($fh);
mysql_free_result($result);
system('/usr/sbin/makemap dbm /etc/mail/access < /etc/mail/access');
?>
[ 發表回應 ] ( 77預覽 ) | 常註連結 |
( 3 / 1973 )#!/usr/local/bin/php
<?php
$host = "localhost";
$user = "mailwatch";
$pass = "";
$db = "mailscanner";
$linkptr = mysql_pconnect ($host,$user,$pass);
mysql_select_db($db,$linkptr);
$DATENOW="-3 MONTH";
$QUERY_DELETE="DELETE FROM maillog WHERE timestamp <= DATE_ADD(DATE_FORMAT(NOW(),'%Y-%m-%d'),INTERVAL $DATENOW);";
$QUERY_REPAIR="REPAIR TABLE maillog ";
mysql_query($QUERY_DELETE,$linkptr);
mysql_query($QUERY_REPAIR,$linkptr);
?>
[ 發表回應 ] ( 18預覽 ) | 常註連結 |
( 3 / 1974 )Solaris does support the x option, you're just not using the right ps to get it to work, you need the berkley version;
use /usr/ucb/ps and you'll be able to use the x option.
[ 發表回應 ] ( 39預覽 ) | 常註連結 |
( 3 / 1918 )
日曆
