James – Page 3 – eCodeBook

Install pure-ftpd on CentOS

April 1, 2014JamesLeave a comment

1. rpm –import /etc/pki/rpm-gpg/RPM-GPG-KEY* 2. rpm –import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt 3. cd /tmp 4. wget http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm 5. rpm -ivh rpmforge-release-0.5.2-2.el6.rf.x86_64.rpm 6. rpm –import https://fedoraproject.org/static/0608B895.txt 7. wget http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm 8. rpm -ivh epel-release-6-8.noarch.rpm 9. yum update 10. yum install pure-ftpd 11. cd /etc/pure-ftpd/ 12. vi pure-ftpd.conf UnixAuthentication yes VerboseLog yes PureDB /etc/pure-ftpd/pureftpd.pdb CreateHomeDie yes 13. pure-pw useradd mywebsite -u…

Remove everyting after first / slash in mysql

March 24, 2014JamesLeave a comment

[code lang=”php”]UPDATE my_table SET my_col = SUBSTRING_INDEX(my_col, ‘/’, 1)[/code] From: AAA/BBB/CCC To: AAA

Remove everyting before last / slash in mysql

March 24, 2014JamesLeave a comment

[code lang=”php”]UPDATE `table` SET `column` = SUBSTRING_INDEX(`column`,’/’,-1);[/code] From: AAA/BBB/CCC To: CCC

Install VSFTPD and setup user

March 9, 2014JamesLeave a comment

Install VSFTPD and setup user 1. Type this [code leg=”php”]# cd /tmp[/code] 2. Install VSFTPD [code leg=”php”]# yum install vsftp[/code] 3. Open vsftpd configuration file – /etc/vsftpd/vsftpd.conf [code leg=”php”]# vi /etc/vsftpd/vsftpd.conf[/code] 4. Make sure following line exists (and uncommented) [code leg=”php”]chroot_local_user=YES[/code] 5. Add user to FTP [code leg=”php”]# adduser -c ‘FTP USER Tom’ -m tom…

MySQL combine two columns and add into new column

April 5, 2013JamesLeave a comment

MySQL combine two columns and add into new column [code language=”sql”] UPDATE tablename SET combined = CONCAT(zipcode, ‘ – ‘, city, ‘, ‘, state) [/code] Output: zipcode – city, state MySQL combine two columns and add into new column where year is a number [code language=”sql”] UPDATE `tablename` SET cat_path = CONCAT(year, ‘/’, name) WHERE…

Copy one column from one table to another table column – MySql.

April 5, 2013JamesLeave a comment

Copy one column from one table to another table column – MySql. [code language=”sql”] UPDATE `table` , `table_2` SET table_2.HQ_ID = table.HQ_ID WHERE table_2.name = table.name [/code]

MySQL: Duplicate id into other column in the same table in MySQL

April 5, 2013JamesLeave a comment

Duplicate id into other column in MySQL. [code language=”sql”] UPDATE contest_cat SET pid = id [/code]

PHP: Recursive Directory Navigation

April 4, 2013JamesLeave a comment

[code language=”php”] function readpath($dir,$level,$last,&$dirs,&$files){ //print $dir." (DIR)\n"; $dp=opendir($dir); while (false!=($file=readdir($dp)) && $level == $last){ if ($file!="." && $file!="..") { if (is_dir($dir."/".$file)) { readpath($dir."/".$file,$level+1,$last,$dirs,$files); // uses recursion $dirs[] = "$dir/$file"; // reads the dir into an array } else{ $files[] = "$dir/$file"; // reads the file into an array } } } } /* From PHP.NET…

PHP: Count files in the folder.

April 4, 2013JamesLeave a comment

[code language=”php”] function scan_dir($path){ $dir = $path."/"; // dir location $files = glob("$dir*.*"); $count = $files !== false ? count($files) : 0; return $count; } echo scan_dir("/folder"); [/code]

PHP: Check broken links using curl

April 1, 2013JamesLeave a comment

[code language=”php”] function check_url($url) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, 1); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $data = curl_exec($ch); $headers = curl_getinfo($ch); curl_close($ch); return $headers[‘http_code’]; } $mainurl = "http://www.google.com"; $myurl = "http://www.google.com/gggg"; $mainsite = check_url($mainurl); $satus = check_url($myurl); if($mainsite == ‘200’){ if($satus == ‘200’){ echo "Its works"; }else{ echo "broken url"; } }else{ echo…