it is macro

Tagged: trigger RSS

• 

  bayu 10:00 pm on November 1, 2009 Permalink | Reply
  Tags: gammu (7), sms (8), trigger   

  nice implementation of gammu

  http://matt.bottrell.com.au/archives/205-Nagios-2-way-alerting-via-SMS-Part-2.html

   

  Reply Click here to cancel reply.

  Name (required)

  Email (required)

  Web Site

   
• 

  bayu 11:50 pm on October 30, 2009 Permalink | Reply
  Tags: mail (5), pushmail, sms (8), trigger   

  proven, converts mail to sms format: http://daniel.haxx.se/projects/mail2sms/readme.shtml

   
• 

  bayu 10:23 pm on October 30, 2009 Permalink | Reply
  Tags: mail (5), php (2), shell (10), trigger   

  I use these to do mail-to-db: http://download.gna.org/hpr/fetchmail/FAQ/gmail-pop-howto.html AND http://www.evolt.org/incoming_mail_and_php AND http://userpages.umbc.edu/~ian/procmail.html

   
• 

  bayu 4:41 pm on October 30, 2009 Permalink | Reply
  Tags: perl (3), shell (10), stdin, trigger   

  perl read STDIN: while () { print $_; }

   
• 

  bayu 4:40 pm on October 30, 2009 Permalink | Reply
  Tags: php (2), shell (10), trigger   

  php read STDIN
  $fp = fopen(‘php://stdin’, ‘r’); while($line = fgets($fp, 4096)) { echo $line; };

   
• 

  bayu 11:52 am on October 30, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), shell (10), sms (8), trigger   

  the other half (cron-ed php script)
  mysql_query(‘SELECT * FROM kerja ORDER by id ASC LIMIT 1′)

  $ret=system(‘/usr/bin/uptime’);
  $ret=trim($ret);

   
• 

  bayu 10:04 am on October 30, 2009 Permalink | Reply
  Tags: gammu (7), mysql (5), phone (7), sms (8), trigger   

  half of the actual trigger
  DELIMITER $$
  CREATE TRIGGER kerjakan AFTER INSERT ON inbox FOR EACH ROW BEGIN
  insert into kerja(cmd_id) values(NEW.TextDecoded);
  END $$
  DELIMITER ;

  bayu is discussing. Toggle Comments

   
  • 

    bayu 12:11 am on December 16, 2009 Permalink

    create trigger kerjakan AFTER INSERT ON inbox FOR each row begin insert into kerja(command,sender) values (NEW.TextDecoded,NEW.SenderNumber); END$$