PROCEDURE xingcai.setCoin does not exist天恒杏彩源码修复二次开发问题

天恒源码里应该含有一些函数,如果你少了它们,就会因为代码不完整而报错,一般应该含有以下函数,你可以根据这个核对你的源码是否完整。

//2019.05备注--QQ4770851
ssc_fcoin_bet ssc_fcoin_cash addScore auto_clearData cancelBet clearData clearData2 conComAll conComSingle consumptionCommission delUser delUser2 delUsers getQzInfo isFirstRechargeCom kanjiang pro_count pro_pay readConComSet readRechargeComSet setCoin setRechar geCom setUpFanDian task

 

提示PROCEDURE xingcai.setCoin does not exist,那就是杏彩源码的serCoin函数的问题,请检查你的代码。或找我修复问题,也可以二次开发。自行检查请参考一下杏彩源码的代码。

/*
-- 函数:setCoin
--时间:2019.06.03 
--修改:QQ4770851
*/
 1 CREATE DEFINER=`root`@`localhost` PROCEDURE `setCoin`(_coin float, _fcoin float, _uid int, _liqType int, _type int, _info varchar(255) character set utf8, _extfield0 int, _extfield1 varchar(255) character set utf8, _extfield2 varchar(255) character set utf8)
 2 begin
 3     
 4     DECLARE currentTime INT DEFAULT UNIX_TIMESTAMP();
 5     DECLARE _userCoin FLOAT;
 6     DECLARE _count INT  DEFAULT 0;
 7     
 8     IF _coin IS NULL THEN
 9         SET _coin=0;
10     END IF;
11     IF _fcoin IS NULL THEN
12         SET _fcoin=0;
13     END IF;
14     
15     SELECT COUNT(1) INTO _count FROM blast_coin_log WHERE  extfield0=_extfield0  AND info='***金'  AND `uid`=_uid;
16     IF  _count<1 THEN
17     
18     SELECT coin INTO _userCoin FROM blast_members WHERE `uid`=_uid;
19     
20     INSERT INTO blast_coin_log(coin, fcoin, userCoin, `uid`, actionTime, liqType, `type`, info, extfield0, extfield1, extfield2) VALUES(_coin, _fcoin, _userCoin, _uid, currentTime, _liqType, _type, _info, _extfield0, _extfield1, _extfield2);
21     END IF;
22     
23 end

 

上一篇:30 Day Challenge Day 20 | Leetcode 322. Coin Change


下一篇:clojure GUI编程-1