Skip to main content

Posts

Showing posts from October, 2016

Query 3

SELECT count(*) as cnt FROM ( SELECT job_mail.*, CASE WHEN nuser.mail IS NOT NULL THEN nuser.mail WHEN cuser.mail IS NOT NULL THEN cuser.mail WHEN admin.mail IS NOT NULL THEN admin.mail ELSE consultant.mail END AS mail, CASE WHEN nuser.nick_name IS NOT NULL THEN nuser.nick_name WHEN cuser.nick_name IS NOT NULL THEN cuser.nick_name WHEN admin.name IS NOT NULL THEN admin.name ELSE consultant.nick_name END AS nick_name, topic.subject,private_message.content,private_message.author_id,private_message_user.user_id FROM job_mail left join topic on job_mail.topic_id = topic.id left join private_message on job_mail.item_id = private_message.id left join private_message_user on private_message.id = private_message_user.pm_id left join nuser on private_message_user.user_id = nuser.id left join cuser on private_message_user.user_id = cuser.id left join consultant on private_message_user.user_id = consultant.id left join admin on private_message_user.user_i...

bash 5

nickfarow:~$ cat ~/bin/rand_email #!/bin/bash # bash generate random alphanumeric string # # TODO add params # bash generate random 32 character alphanumeric string (upper and lowercase) and NEW_UUID=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1) # bash generate random 32 character alphanumeric string (lowercase only) cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 10 | head -n 1 nickfarow:~$ cat ~/bin/rand_email2 #!/bin/bash # bash generate random alphanumeric string # # TODO add params mail_tail="@mailinator.com" # bash generate random 32 character alphanumeric string (upper and lowercase) and NEW_UUID=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1) # bash generate random 32 character alphanumeric string (lowercase only) rand_email_name=$(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 10 | head -n 1) rand_mail_full=$rand_email_name$mail_tail; COUNTER=0 while [ $COUNTER -lt 100...

Mail 4

 Mail::raw('Houston weve had 2 problem', function ($message) {             $message->from('vandung53cc@gmail.com', $name = 'Jimi');             $message->sender('mtischer53@gmail.com', $name = 'Evan Clark');             $message->to('dung.nguyen.van@ntq-solution.com.vn', $name = 'Aaron');         }); Sender vs From:  http://stackoverflow.com/questions/4367358/whats-the-difference-between-sender-from-and-return-path Result: From: Jimi (same), email: [From] change from vand => mtister53 To: same Sender: no affect How ssmtp work ? http://linuxpitstop.com/install-ssmtp-to-send-emails-to-gmail-and-office3655/