Search Results

Hi,

I need help. I want to capture an output from a USSD then sms it to a certain number for checking credits balance.

I tried with this:

echo "asterisk -rx 'gsm send ussd 1 *888#'"|...

It does what I want:

# crontab -l
* 7 * * * asterisk -rx 'gsm send sms 1 7666 "TM ON"'
* 7 * * * asterisk -rx 'gsm send sms 3 7666 "TM ON"'

Thanks! :)

Hi Don Cragun!

Thank you so much for your answer. But how if i want 2 cron job? should it be like this:

#!/bin/sh
#custom mod - send sms once a day, at 07:00....

Hi,

I created this cron job for asterisk to send sms daily to a number

#!/bin/sh
#custom mod - send sms once a day, at 07:00.
CRON_PATH="/etc/asterisk/gw/crontabs_root";
if ! grep 'gsm send...

:) thank you brother. you have my word, i will donate 5% to a local charity. will be pm you with pics.

the script doesn't give me an email

heres the code:

VALIDATION="$(mysql...

is this right? i changed to:

CNT=0 # use to check if any of the group errors are found
for GRP in $((mysql --skip-column-names -uroot -p123456 smsd -e "SELECT sms_keyword FROM kontak_group") >...

Do you mean like this?

GRP_email_subject=$(mysql -uroot -p123456 smsd -e "SELECT email_subject FROM kontak_group")
GRP_email_address_list=$(mysql -uroot -p123456 smsd -e "SELECT email_group FROM...

thank you brother.

but what i'm saying is, can i run a script that reads my table row like this:

if message contain a word from one of sms_keyword field then email it to the corresponden row...

Hi, currently I have a script with conditional checking. But it's not flexible to use, because i must create a more conditional script if there are more keyword (see table) required. Question is: Can...

hmm.. now i understand what Alister said.

Thanks Just Ice. ok now I can run the code with:

CHECKER=$(mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox...

Dear Alister, thanks for your repply.

variable assigned to CHECKER are right:

mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime...

Thanks Bro, but it doesn't work out. I already tried use your script. btw, Im using debian squeeze.

The result are:

+ ADMemails=acme@gmail.com
+ HCSemails=acme@gmail.com
+ ADMSubject=Email to...

changed and echo from $CHECKER :

mysql -u root --password=123456 smsd -e "SELECT ID, SenderNumber, TextDecoded FROM inbox ORDER BY ReceivingDateTime DESC LIMIT 1 \G" |egrep -w...

Hi, thanks for your repply.

I changed the code to this:

status=0
PTMemails="acme@gmail.com"
HCSemails="acme@gmail.com"
PTMSubject="Email to group status - Sent"
HCSSubject="Email to group...

Hi, Im new with bash scripting and I want to create a conditional emailing with bash scripting. But it doesn't workout.

the conditional requirement are; if the TextDecoded value from inbox table...

Hi, i want to create a table automatically based on another table (sms_key).
For example;

If user create a new row with sms_keyword field: IRC then a table created automatically (with some...

Hi, im using mysql. the script are trigered with bash script:

mysql -uroot -p123456 smsd -e "INSERT INTO inbox_spam
SELECT * FROM inbox WHERE TextDecoded
NOT regexp ( select concat_ws ( '',...

Hi, I already succeed moving a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).
...

Hi thanks pravin27! and also thanks to vidyadhar85. now it showed percent and comma. :-)

---------- Post updated at 01:08 AM ---------- Previous update was at 01:04 AM ----------

Hi...

already changed it to:
CHECK_KEYWORD="$( mysql -uroot -p123456 smsd -N -s -r -e "SELECT sms_keyword FROM sms_key" | sed 's/^0/+62/g' | tr '\n' '%,' | sed 's/,$//g' )"
mysql -uroot -p123456 smsd -e...

Hi, thanks for your repply.

The result is:
mysql -uroot -p123456 smsd -e INSERT INTO inbox_spam SELECT * FROM inbox WHERE TextDecoded NOT LIKE '(IRC,PTM,ADM,BS)%'


and i think the correct...

Hi, I want to move a new row to another table if the field from new row doesn't have the first word that I categorized (like: IRC blablabla, PTM blablabla, ADM blablabla, BS blablabla).

I already...

hi, im learning python language. and my teacher gives me this question on class:

Boolean expression :
not (p or not q)

what is the correct answer for that? i still dont understand, and please...

Thank you Brother PikK45 !, now it can delete the new record. :-D thank you so much for your help.

Thanks PikK45,

using this:

BLOCKLIST="$( mysql -uroot -pabcde smsd -N -s -r -e "SELECT senderNumber FROM blacklist WHERE senderBlock='Y'" | sed 's/^0/+61/g' | tr '\n' ',' | sed 's/,$//g' )"...