http://www.crucialwebhost.com/code// Ready To Split-Shared Hosting? en-us code@crucialwebhost.com Copyright 2010 2010-02-02T10:29:15+00:00 http://www.crucialwebhost.com/code/block-ip-address/ http://www.crucialwebhost.com/code/block-ip-address/#When:10:29:15Z iptables -I INPUT -s 25.22.22.22 -j DROP 2010-02-02T10:29:15+00:00 http://www.crucialwebhost.com/code/validate-email-address-with-javascript/ http://www.crucialwebhost.com/code/validate-email-address-with-javascript/#When:13:00:14Z /^((([a-z]|d|[!#$%&'*+-/=?^_`{|}~]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])+(.([a-z]|d|[!#$%&'*+-/=?^_`{|}~]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])+)*)|((x22)((((x20|x09)*(x0dx0a))?(x20|x09)+)?(([x01-x08x0bx0cx0e-x1fx7f]|x21|[x23-x5b]|[x5d-x7e]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])|(\([x01-x09x0bx0cx0d-x7f]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF]))))*(((x20|x09)*(x0dx0a))?(x20|x09)+)?(x22)))@((([a-z]|d|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])|(([a-z]|d|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])([a-z]|d|-|.|_|~|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])*([a-z]|d|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF]))).)+(([a-z]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])|(([a-z]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])([a-z]|d|-|.|_|~|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF])*([a-z]|[u00A0-uD7FFuF900-uFDCFuFDF0-uFFEF]))).?$/i 2010-01-08T13:00:14+00:00 http://www.crucialwebhost.com/code/find-duplicate-mysql-records/ http://www.crucialwebhost.com/code/find-duplicate-mysql-records/#When:12:52:27Z SELECT email, count(email) AS total FROM `tbl_mailing_list` GROUP BY email HAVING total > 1 ORDER BY total; 2009-12-16T12:52:27+00:00 http://www.crucialwebhost.com/code/embed-audio-using-the-audio-tag/ http://www.crucialwebhost.com/code/embed-audio-using-the-audio-tag/#When:18:34:46Z <audio controls autoplay autobuffer src="song.mp3"></audio> 2009-12-07T18:34:46+00:00 http://www.crucialwebhost.com/code/import-mysql-dump/ http://www.crucialwebhost.com/code/import-mysql-dump/#When:21:27:27Z mysql -h DBHOST -u DBUSER -pDBPASS DBNAME < dump.sql Replace text in uppercase with the appropriate information: DBHOST - Database hostname, usually localhost DBUSER - User with privileges to the database DBPASS - Password for the user DBNAME - Database name 2009-12-04T21:27:27+00:00 http://www.crucialwebhost.com/code/google-api-jquery-include/ http://www.crucialwebhost.com/code/google-api-jquery-include/#When:21:19:27Z <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> <script type="text/javascript"> $(function() {   }); </script> 2009-12-04T21:19:27+00:00 http://www.crucialwebhost.com/code/print-active-connections-to-port-80-per-ip-address/ http://www.crucialwebhost.com/code/print-active-connections-to-port-80-per-ip-address/#When:20:10:53Z netstat -plan | grep :80 | grep -E "(EST|LIST)" | awk {'print $5'} | cut -d: -f 1 | sort | uniq -c | sort -nk 1 2009-12-04T20:10:53+00:00 http://www.crucialwebhost.com/code/send-email-from-shell/ http://www.crucialwebhost.com/code/send-email-from-shell/#When:20:08:18Z mail -s "Subject" email@address.com < message.txt 2009-12-04T20:08:18+00:00 http://www.crucialwebhost.com/code/install-csf-firewall-and-lfd-log-file-daemon/ http://www.crucialwebhost.com/code/install-csf-firewall-and-lfd-log-file-daemon/#When:20:00:12Z cd /usr/src/ wget http://www.configserver.com/free/csf.tgz tar -xzf csf.tgz cd csf sh install.sh 2009-12-04T20:00:12+00:00 http://www.crucialwebhost.com/code/show-process-cpu-usage/ http://www.crucialwebhost.com/code/show-process-cpu-usage/#When:19:56:20Z Display how much CPU a process is using: ps -eo pcpu,pid -o comm= | sort -k1 -n -r | head -1 For example, show top five CPU using processes: ps -eo pcpu,pid -o comm= | sort -k1 -n -r | head -5 Which will output the following: 0.6 24458 bash 0.3 24457 cphulkd.pl 0.2 7704 php5 0.1 7706 php5 0.1 7705 php5 2009-12-04T19:56:20+00:00 http://www.crucialwebhost.com/code/show-each-process-memory-usage/ http://www.crucialwebhost.com/code/show-each-process-memory-usage/#When:19:50:23Z ps axu Show full command in ps display: ps axu --width=500 2009-12-04T19:50:23+00:00 http://www.crucialwebhost.com/code/html5-starter-page/ http://www.crucialwebhost.com/code/html5-starter-page/#When:16:53:48Z <!doctype html> <html lang="en-us"> <head> <meta charset="utf-8"> <title>My Site</title> <!--[if lte IE 8]> <script src="http://js.cwhcode.com/html5/"></script> <![endif]--> </head> <body> <section> <header role="banner"> <hgroup> <h1><a href="">My Site</a></h1> <h2>Tagline</h2> </hgroup> <nav> <ul role="navigation"> <li><a href="">Item 1</a></li> <li><a href="">Item 2</a></li> <li><a href="">Item 3</a></li> </ul> </nav> </header> <article role="main"> <header> <h3>Article Title</h3> <time datetime="2010-04-20">April, 20, 2010</time> </header> <section> <p>Lorem ipsum dolor sit amet, consectetur adipisicing elit.</p> </section> </article> <aside> <h4>Sidebar Heading</h4> <ul> <li><a href="">Item 1</a></li> <li><a href="">Item 2</a></li> <li><a href="">Item 3</a></li> </ul> </aside> <footer>Copyright © 2010 My Site. All Rights Reserved.</footer> </section> </body> </html> 2009-12-04T16:53:48+00:00 http://www.crucialwebhost.com/code/css-debug/ http://www.crucialwebhost.com/code/css-debug/#When:16:33:44Z * { outline:2px dotted red } * * { outline:2px dotted green } * * * { outline:2px dotted orange } * * * * { outline:2px dotted blue } * * * * * { outline:1px solid red } * * * * * * { outline:1px solid green } * * * * * * * { outline:1px solid orange } * * * * * * * * { outline:1px solid blue } 2009-12-04T16:33:44+00:00 http://www.crucialwebhost.com/code/create-a-mysql-user/ http://www.crucialwebhost.com/code/create-a-mysql-user/#When:15:05:38Z GRANT ALL PRIVILEGES ON `db_name.table_name` (or .*) TO 'username'@'localhost' IDENTIFIED BY 'password'; 2009-12-04T15:05:38+00:00 http://www.crucialwebhost.com/code/mysql-find-and-replace/ http://www.crucialwebhost.com/code/mysql-find-and-replace/#When:15:03:10Z UPDATE `tbl_name` SET tbl_field = replace(tbl_field, 'FIND', 'REPLACE'); 2009-12-04T15:03:10+00:00