BEGIN
DECLARE COUNTFLAG INT;
/*SET COUNTFLAG = 0;*/
DECLARE LOGINTIME DATETIME;
DECLARE COLLALREADYNUM NUMERIC(10);
DECLARE COLLCANNUM NUMERIC(10);
DECLARE HUNTALREADYNUM NUMERIC(10);
DECLARE HUNTCANNUM NUMERIC(10);
DECLARE DETALPIC VARCHAR(200);
DECLARE USERLEVEL NUMERIC(10);
DECLARE ISEXIST NUMERIC(10);
SET ISFIRST='n';
SET @dt = now();
SELECT COUNT(1) INTO COUNTFLAG FROM USER_BASE_INFO WHERE XIAONEI_ID=XIAONEIID;
IF COUNTFLAG=0 THEN
INSERT INTO USER_BASE_INFO(USER_NAME,REG_TIME,XIAONEI_ID,USER_ICON,SESSION_KEY) VALUES(USERNAME,now(),XIAONEIID,HEADURL,SESSIONKEY);
INSERT INTO USER_DETAILS_INF(USER_NICK_NAME,USER_PIC,USER_SEX,USER_ADDR,USER_SCHOOL,XIAONEI_ID,ISVIP,LOGIN_TIME) VALUES(USERNAME,HEADURL,SEX,ADDR,SHOOL,XIAONEIID,ZIDOU,now());
INSERT INTO USER_PLANT_EARTH(XIAONEI_ID) VALUES(XIAONEIID);
INSERT INTO USER_ANIMAL_CAGE(XIAONEI_ID) VALUES(XIAONEIID);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1190',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1028',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1029',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1030',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1035',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'1036',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'560',2);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'651',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'557',1);
INSERT INTO USER_PACKAGE(XIAONEI_ID,ITEM_ID,ITEM_COUNT) VALUES(XIAONEIID,'450',1);
INSERT INTO USER_DEPOT(XIAONEI_ID,ITEM_ID,ITEM_COUNT,ITEM_STEP) VALUES(XIAONEIID,'561',24,'0');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_POSITION) VALUES(XIAONEIID,'606',1,'t0',(date_sub(@dt,interval 960 minute)),'553.75,314.65');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_POSITION) VALUES(XIAONEIID,'606',1,'t1',(date_sub(@dt,interval 900 minute)),'487,383');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'606',1,'t2',(date_sub(@dt,interval round(960/5*3)minute)),'2','402.25,441.35');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'560',1,'0',(date_sub(@dt,interval round(720/5*4)minute)),'2,2','365.4,556.9');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'560',1,'1',(date_sub(@dt,interval 600 minute)),'0','398.15,624.3');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'564',1,'2',now(),'1','334.625,701');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'564',1,'3',(date_sub(@dt,interval 840 minute)),'0','492.75,553');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'557',1,'4',(date_sub(@dt,interval round(600/5*3)minute)),'0','543.8,626.3');
INSERT INTO USER_ITEM_PLANT(XIAONEI_ID,PLANT_ID,PLANT_TOTAL_STAGE,EARTH_INDEX,PLANT_START_TIME,PLANT_STATUS,PLANT_POSITION) VALUES(XIAONEIID,'557',1,'5',(date_sub(@dt,interval 600 minute)),'0','473.25,704.3');
SET ISFIRST='y';
COMMIT;
END IF;
SELECT A.USER_EXP,C.EXP_LEVEL,A.PROPULAR_ID,A.USER_MONEY,A.USER_MARRIAGE,
A.USER_OMONEY,A.ITEM_BIG_PIC,A.IMG_HOUSE,A.IMG_ENCLOSURE,A.USER_PIC,
A.IMG_BELIEF_BG,A.USER_WELLKNOW,A.USER_OMONEY,A.HAVE_CREATE,A.ISVIP,
A.MANOR_NAME,A.USER_SCHOOL,A.USER_ADDR,A.USER_NICK_NAME, A.USER_EXP,
C.EXPERIENCE,D.PROPULAR_NAME,D.PROPULAR_NEED,A.IMG_PLANT_BG,A.IMG_ANIMAL_BG,
NEWTASK_ISCOMPLE,A.PROPULAR_ID,A.COLLECTION_ALREADY_NUM,A.COLLECTION_CAN,
A.HUNT_ALREADY_NUM,A.HUNT_CAN INTO `EXP`,LEVELS,TITLE,MONEYS,MARRIAGE,COIN,
DOGNEST,HOUSE,NET,USERPIC,MAINBG,WELLKNOW,OMONEY,CREATENUM,VIP,MANORNAME,
SCHOOL,CITY,USERNICKNAME,USEREXP,NEEDEXP,PROPUNAME,PROPUNEED,IMGPLANTBG,
IMGANIMALBG,TASKCOMPLE,USERTITLE,COLLECTNUM,COLLECTCAN,HUNTNUM,HUNTCAN
FROM (SELECT A.*,B.ITEM_BIG_PIC FROM USER_DETAILS_INF A
LEFT JOIN ITEM_INF B ON A.IMG_DOG=B.ITEM_ID WHERE A.XIAONEI_ID=XIAONEIID) A ,
EXP_INF C,PROPULAR_INF D WHERE A.EXP_ID=C.EXP_ID AND A.PROPULAR_ID=D.PROPULAR_ID;
SET YES='yes';
END
分享到:
相关推荐
Mysql存储过程常用语句模板(含变量,if,三种循环等等) Mysql存储过程常用语句模板(含变量,if,三种循环等等) Mysql存储过程常用语句模板(含变量,if,三种循环等等) Mysql存储过程常用语句模板(含变量,if,三...
本文实例讲述了mysql存储过程之返回多个值的方法。分享给大家供大家参考,具体如下: mysql存储函数只返回一个值。要开发返回多个值的存储过程,需要使用带有INOUT或OUT参数的存储过程。咱们先来看一个orders表它的...
mysql经典教程+mysql存储过程讲解 重点讲解Mysql的存储过程,触发器,游标的使用 对mysql不太熟的朋友可以好好学习。。。
c++实现调mysql存储过程,实现存储过程的出参入参,可以支持查询多数据返回,还有存储过程的复杂数据的增删改等
mysql中文手册.chm+mysql命令大全.chm+mysql存储过程.pdf
mysql存储过程实现分页 mysql存储过程实现分页 mysql存储过程实现分页 mysql存储过程实现分页
MySQL存储过程学习 MySQL存储过程 MySQL存储过程
本文实例讲述了MySQL存储过程的异常处理方法。分享给大家供大家参考。具体如下: mysql> mysql> delimiter $$ mysql> mysql> CREATE PROCEDURE myProc -> (p_first_name VARCHAR(30), -> p_last_name VARCHAR(30)...
MySQL存储过程编程 可以看看 数据库 存储过程
mysql存储过程ppt
mysql 存储过程 实战
MySQL存储过程
mysql获取两个时间相差年月日:使用mysql存储过程,实现计算两个时间的差值,并用年月日时分秒的格式输出,且从大到小为0时则不展示对应单位(如:相差1小时20秒 则展示'1时0分20秒')
mysql存储过程,存储函数练习,里面有详细代码,供大家参考
php中调用MySQL存储过程示例
mysql存储过程实例详细介绍了mysql存储过程的开发步骤
mysql存储过程调试工具,可以设置断点,方便查看变量信息等。好用,简单
MySQL存储过程,入门简单,循序渐进,很适合自学,很详尽,很好学。
MySQL存储过程 MySQL存储过程 MySQL存储过程 MySQL存储过程 MySQL存储过程