测试注册

主营项目:经营项目
产品分类
产品知识
主营:经营项目

--return --测试 2015-08-28

declare

var_result varchar(75);

var_member_space int;

var_member_id int;

var_shop_id int;

var_Ordernumb int;

var_shopcount int;

var_checkphones int;

var_mf_shop int;

var_send_date varchar(10);

var_end_date varchar(10);

var_re_rst int;

var_re_lid int;

var_out1 refcursor;

var_out2 refcursor;

var_out22 refcursor;

begin

set search_path=byuser,"public";

var_class_id=var_class_id/100*100; -- 网店只到第二级

var_member_space = 100; --信息空间

--检查所用注册手机号或者座机号是否在黑名单

<<block>>

loop

if var_phone > '' then

if exists(select * from by_web_blacklist where black_str =var_phone) then

var_result='警告:您有过恶意行为,已被纪录到黑名单,禁止注册!';

exit block;--goto result

end if;

end if;

if var_mobile > '' then

if exists(select * from by_web_blacklist where black_str =var_mobile) then

var_result='警告:您有过恶意行为,已被纪录到黑名单,禁止注册!' ;

exit block; --goto result

end if;

end if;

if var_IP > '' then

if exists(select * from by_web_blacklist where black_str =var_IP) then

var_result='警告:您有过恶意行为,已被纪录到黑名单,禁止注册!';

exit block; --goto result

end if;

end if;

if not exists(select * from by_member_share where id=var_tid) then

var_result='还没有注册通行证,请先注册通行证!' ;

exit block; --goto result

end if;

var_mf_shop = (select count(*) from byshops.by_shop_detail where member_id in

( select id from by_member where tid =var_tid) and shop_state < 461 ) ;

产品信息

更多...