gcc -Wall -fPIC -I/usr/include/mysql -I. -shared lib_mysqludf_sys.c -o lib_mysqludf_sys.so

DROP FUNCTION IF EXISTS lib_mysqludf_sys_info;

DROP FUNCTION IF EXISTS sys_get;

DROP FUNCTION IF EXISTS sys_set;

DROP FUNCTION IF EXISTS sys_exec;

DROP FUNCTION IF EXISTS sys_eval;

CREATE FUNCTION lib_mysqludf_sys_info RETURNS STRING SONAME 'lib_mysqludf_sys.so';

CREATE FUNCTION sys_get RETURNS STRING SONAME 'lib_mysqludf_sys.so';

CREATE FUNCTION sys_set RETURNS INT SONAME 'lib_mysqludf_sys.so';

CREATE FUNCTION sys_exec RETURNS INT SONAME 'lib_mysqludf_sys.so';

CREATE FUNCTION sys_eval RETURNS STRING SONAME 'lib_mysqludf_sys.so';

DELIMITER $$

USE `sailing`$$

DROP TRIGGER /*!50032 IF EXISTS */ `pay_check_trig`$$

CREATE

    /*!50017 DEFINER = 'root'@'%' */

    TRIGGER `pay_check_trig` AFTER INSERT ON `pay_record`

    FOR EACH ROW BEGIN

    DECLARE ret INT DEFAULT 999;

    IF new.status = 1 THEN

        SET ret = sys_exec(CONCAT('/mysql_udf/pay_ok.py ',new.playerId,' ',new.value));

    END IF;

    END;

$$

DELIMITER ;

#!/usr/bin/python

#coding:utf-8

import sys

import smtplib

from email.mime.text import MIMEText

mailto_list=['123456789@qq.com']

mail_host="smtp.163.com"  #设置服务器

mail_user="888888888@163.com"   #用户名

mail_pass=""   #口令

mail_postfix="163.com"  #发件箱的后缀

def send_mail(to_list,sub,content):

    me=u"sailing server"+"<"+mail_user+"@"+mail_postfix+">"

    msg = MIMEText(content,_subtype='plain',_charset='gb2312')

    msg['Subject'] = sub

    msg['From'] = me

    msg['To'] = ";".join(to_list)

    try:

        server = smtplib.SMTP()

        server.connect(mail_host)

        server.login(mail_user,mail_pass)

        server.sendmail(me, to_list, msg.as_string())

        server.close()

        return True

    except Exception, e:

        print str(e)

        print 'error'

        return False

if __name__ == '__main__':

    playerid = sys.argv[1]

    value = sys.argv[2]

    send_mail(mailto_list,u"成功充值通知",u"玩家ID：%s 刚刚成功购买了 %s 个金币！" % (playerid,value))