PDA

View Full Version : Share Code Event HATT Phiên Bản Thương Mại Bên China


sgamer
16-01-15, 05:56 PM
DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_1;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_1()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 1 300 20000 0 22246:1:3,24650:1:3,24790:1:10,28113:0:1,26154:1:2 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到300元宝。我们为您奉送诸多充� ��奖励，请注意查收，祝您游戏愉快！ ', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 2 1000 60000 0 22246:1:5,24650:1:10,24790:1:20,28113:0:2,26154:1: 2 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到1000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 3 3000 120000 0 22246:1:10,24651:1:10,24790:1:30,28113:0:3,26159:1 :1,26154:1:3 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到3000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 4 6000 180000 0 22246:1:15,24651:1:20,24790:1:40,28113:0:5,26159:1 :1,26154:1:3 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到6000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 5 10000 240000 0 22246:1:25,24652:1:20,24791:1:25,28113:0:8,26159:1 :2,26154:1:5,24785:1:1,26502:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到10000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 6 20000 380000 0 22246:1:40,24652:1:30,24791:1:40,28113:0:15,26159: 1:3,26154:1:5,26503:1:1,24783:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到20000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 7 30000 600000 0 22246:1:70,24652:1:40,24791:1:50,28113:0:20,26159: 1:5,26154:1:8,26503:1:1,24783:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到30000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 充值有喜，游戏愉快！', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1035 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_1();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_1;




DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_2;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_2()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 1 1000 0 0 26155:0:2,22246:0:4,26505:0:1,28113:0:2 充值有喜 单笔充值达到1000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 2 3000 0 0 26155:0:5,22246:0:8,26154:0:2,24770:0:1,28113:0:6 充值有喜 单笔充值达到3000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 3 5000 0 0 26155:0:10,22246:0:16,26154:0:4,24770:0:2,28113:0: 12 充值有喜 单笔充值达到5000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 4 10000 0 0 26155:0:20,22246:0:40,26154:0:10,24771:0:2,28113:0 :25,9102:1:1 充值有喜 单笔充值达到10000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 5 20000 0 0 26155:0:60,22246:0:85,26154:0:25,24772:0:1,28113:0 :50,9103:1:1 充值有喜 单笔充值达到20000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1051 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_2();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_2;



DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_3;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_3()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 1 300 20000 0 28113:1:1,26153:1:2,20022:1:1,24600:1:1', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 2 1000 60000 0 28113:1:2,26153:1:4,20022:1:2,24600:1:4,21014:1:1' , 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 3 3000 120000 0 28113:1:3,26153:1:8,20022:1:3,24600:1:8,21015:1:1, 26155:1:1', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 4 6000 180000 0 28113:1:5,26153:1:15,20022:1:4,24600:1:16,21015:1: 2,26155:1:3,26216:1:2', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 5 10000 240000 0 28113:1:8,26153:1:20,20022:1:5,24600:1:24,21015:1: 2,26155:1:5,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 6 20000 380000 0 28113:1:15,26153:1:40,20022:1:5,24600:1:48,21015:1 :3,26155:1:6,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 7 30000 600000 0 28113:1:25,26153:1:60,20022:1:5,24600:1:99,21015:1 :3,26155:1:8,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 8 0 0 0 26507:1:1', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1044 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_3();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_3;


DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_4;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_4()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'Cmd Reload 4 0 0', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1037 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);

END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_4();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_4;
sgamer
16-01-15, 06:02 PM
Uplate role_attr_detail2 Sau Khi Gộp SV Đây






DROP PROCEDURE IF EXISTS P_UPDATE_20131122;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_20131122()
BEGIN
if not exists (select 1 from information_schema.columns where table_schema = database() and table_name = 'role_attr_detail2' and column_name = 'tenturntable_data') then
ALTER TABLE `role_attr_detail2` ADD COLUMN `tenturntable_data` varbinary(256) NOT NULL DEFAULT '' AFTER `petjinjie_data`;
end if;
END$$

DELIMITER ;

CALL P_UPDATE_20131122();

DROP PROCEDURE IF EXISTS P_UPDATE_20131122;
Uplate role_attr_detail2
kik4567
18-01-15, 02:01 PM
Cái này dùng làm gì vậy bạn? :(
sgamer
18-01-15, 05:59 PM
Cái này dùng làm gì vậy bạn? :(

Cái Này dùng để tạo event hút máu ấy.
BanBanhQuay
18-01-15, 09:00 PM
DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_1;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_1()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 1 300 20000 0 22246:1:3,24650:1:3,24790:1:10,28113:0:1,26154:1:2 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到300元宝。我们为您奉送诸多充� ��奖励，请注意查收，祝您游戏愉快！ ', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 2 1000 60000 0 22246:1:5,24650:1:10,24790:1:20,28113:0:2,26154:1: 2 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到1000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 3 3000 120000 0 22246:1:10,24651:1:10,24790:1:30,28113:0:3,26159:1 :1,26154:1:3 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到3000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 4 6000 180000 0 22246:1:15,24651:1:20,24790:1:40,28113:0:5,26159:1 :1,26154:1:3 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到6000元宝。我们为您奉送诸多充 值奖励，请注意查收，祝您游戏愉快� �', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 5 10000 240000 0 22246:1:25,24652:1:20,24791:1:25,28113:0:8,26159:1 :2,26154:1:5,24785:1:1,26502:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到10000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 6 20000 380000 0 22246:1:40,24652:1:30,24791:1:40,28113:0:15,26159: 1:3,26154:1:5,26503:1:1,24783:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到20000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 7 30000 600000 0 22246:1:70,24652:1:40,24791:1:50,28113:0:20,26159: 1:5,26154:1:8,26503:1:1,24783:1:1 充值有喜 亲爱的玩家，感谢您在活动期间累计� �值达到30000元宝。我们为您奉送诸多� �值奖励，请注意查收，祝您游戏愉快� ��', 0),
('background', unix_timestamp( ), 2, 'CmdToChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 充值有喜，游戏愉快！', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1035 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_1();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_1;




DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_2;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_2()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 1 1000 0 0 26155:0:2,22246:0:4,26505:0:1,28113:0:2 充值有喜 单笔充值达到1000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 2 3000 0 0 26155:0:5,22246:0:8,26154:0:2,24770:0:1,28113:0:6 充值有喜 单笔充值达到3000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 3 5000 0 0 26155:0:10,22246:0:16,26154:0:4,24770:0:2,28113:0: 12 充值有喜 单笔充值达到5000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 4 10000 0 0 26155:0:20,22246:0:40,26154:0:10,24771:0:2,28113:0 :25,9102:1:1 充值有喜 单笔充值达到10000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 5 20000 0 0 26155:0:60,22246:0:85,26154:0:25,24772:0:1,28113:0 :50,9103:1:1 充值有喜 单笔充值达到20000元宝奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0),
('background', unix_timestamp( ), 2, 'CmdToOnceChongZhiActivityReward 8 0 0 0 28490:1:1 充值有喜 单笔充值奖励', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1051 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_2();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_2;



DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_3;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_3()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 1 300 20000 0 28113:1:1,26153:1:2,20022:1:1,24600:1:1', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 2 1000 60000 0 28113:1:2,26153:1:4,20022:1:2,24600:1:4,21014:1:1' , 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 3 3000 120000 0 28113:1:3,26153:1:8,20022:1:3,24600:1:8,21015:1:1, 26155:1:1', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 4 6000 180000 0 28113:1:5,26153:1:15,20022:1:4,24600:1:16,21015:1: 2,26155:1:3,26216:1:2', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 5 10000 240000 0 28113:1:8,26153:1:20,20022:1:5,24600:1:24,21015:1: 2,26155:1:5,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 6 20000 380000 0 28113:1:15,26153:1:40,20022:1:5,24600:1:48,21015:1 :3,26155:1:6,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 7 30000 600000 0 28113:1:25,26153:1:60,20022:1:5,24600:1:99,21015:1 :3,26155:1:8,26216:1:3', 0),
('background', unix_timestamp( ), 2, 'CmdToConsumeActivityReward 8 0 0 0 26507:1:1', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1044 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);
END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_3();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_3;


DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_4;

DELIMITER $$

CREATE PROCEDURE P_UPDATE_CHRISMAS_4()
BEGIN
INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, 'Cmd Reload 4 0 0', 0);

INSERT INTO `event_gif` (`creator`, `createtime`, `type`, `cmd`, `confirmtime`) VALUES
('background', unix_timestamp( ), 2, CONCAT('CmdToSpeicalActivity 1037 ', unix_timestamp('2013-12-24 00:00:00'), ' ', unix_timestamp('2013-12-27 23:59:00'), ' 0 0'), 0);

END$$

DELIMITER ;

CALL P_UPDATE_CHRISMAS_4();

DROP PROCEDURE IF EXISTS P_UPDATE_CHRISMAS_4;

Cái này là của hùng bá.chạy đâu qua hắc ám thế:D:D:D