SELECT token
FROM sms_config
LIMIT 1
;
INSERT INTO sys_log_sms_send
SET sender='GOD'
, phone='+393806866740'
, testo='Ciao Simone, sono DIO... Il Dio egizio Anubi... anche detto Dio Cane ;-)'
, data=DATE_FORMAT(now(),'%Y%m%d')
, ora=DATE_FORMAT(now(),'%H:%i')
, sys_save_field=SET_VAL('')
;
UPDATE sms_config
SET token=CAST(
        IF(CAST(token AS DECIMAL(10,0))<=0
                , 0
                , IF( (CAST(token AS DECIMAL(10,0)) - CAST(('1'*1) AS DECIMAL(10,0))) <=0
                        , 0
                        ,(CAST(token AS DECIMAL(10,0)) - CAST(('1'*1) AS DECIMAL(10,0)))
                )
) AS DECIMAL(10,0))
, used_token=CAST(
        (CAST(used_token AS DECIMAL(10,0)) + CAST(('1'*1) AS DECIMAL(10,0)))
AS DECIMAL(10,0))
;
SELECT token
FROM sms_config
LIMIT 1
;
INSERT INTO sys_log_sms_send
SET sender='GOD'
, phone='+393349803176'
, testo='Ciao Saba, sono DIO... Il Dio egizio Anubi... anche detto Dio Cane ;-)'
, data=DATE_FORMAT(now(),'%Y%m%d')
, ora=DATE_FORMAT(now(),'%H:%i')
, sys_save_field=SET_VAL('')
;
UPDATE sms_config
SET token=CAST(
        IF(CAST(token AS DECIMAL(10,0))<=0
                , 0
                , IF( (CAST(token AS DECIMAL(10,0)) - CAST(('1'*1) AS DECIMAL(10,0))) <=0
                        , 0
                        ,(CAST(token AS DECIMAL(10,0)) - CAST(('1'*1) AS DECIMAL(10,0)))
                )
) AS DECIMAL(10,0))
, used_token=CAST(
        (CAST(used_token AS DECIMAL(10,0)) + CAST(('1'*1) AS DECIMAL(10,0)))
AS DECIMAL(10,0))
;