5Hits Tournament 5095

Tabela Do Navicat

Código:

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 40017
Source Host           : localhost:3306
Source Database       : zf

Target Server Type    : MYSQL
Target Server Version : 40017
File Encoding         : 65001

Date: 2015-08-21 23:33:31
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `5hits`
-- ----------------------------
DROP TABLE IF EXISTS `5hits`;
CREATE TABLE `5hits` (
  `id` int(4) NOT NULL default '0',
  `additional_point` int(4) NOT NULL default '0',
  `health` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- ----------------------------
-- Records of 5hits
-- ----------------------------

SQL DO TORNEIO:

Código:


##################################################NPC#############################################################################
REPLACE INTO `cq_npc` VALUES ('124011', '0', '0', '5HitTournament', '0002', '0400', '-1', '1002', '0437', '0290', '721230', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '', '0000', '00', '00', '0000', '00', null);
REPLACE INTO `cq_npc` VALUES ('124012', '0', '0', '5-Hit-Prize', '0002', '0400', '-1', '7147', '0049', '0039', '721289', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '', '0000', '00', '00', '0000', '00', '0000');
##########################################################ACTION##################################################################
REPLACE INTO `cq_action` VALUES ('721230', '721231', '0000', '0101', '0', 'Hello %user_name its a prof tournament would you like to enter?');
REPLACE INTO `cq_action` VALUES ('721231', '721232', '0000', '0102', '0', 'Yes. 721233');
REPLACE INTO `cq_action` VALUES ('721232', '15003', '0000', '0102', '0', 'Thanks. 0');

REPLACE INTO `cq_action` VALUES ('721233', '721234', '721235', '0123', '5', '25 29');
REPLACE INTO `cq_action` VALUES ('721234', '721236', '721285', '1073', '0', 'stc(266,10) == 5');
REPLACE INTO `cq_action` VALUES ('721285', '721272', '721286', '1073', '0', 'stc(25,10) == 1');
REPLACE INTO `cq_action` VALUES ('721286', '721272', '000000', '1074', '0', 'stc(25,10) += 1 1');
REPLACE INTO `cq_action` VALUES ('721272', '721237', '721273', '1065', '0', '4 410');
REPLACE INTO `cq_action` VALUES ('721273', '721237', '721274', '1065', '0', '4 420');
REPLACE INTO `cq_action` VALUES ('721274', '721237', '721275', '1065', '0', '5 410');
REPLACE INTO `cq_action` VALUES ('721275', '721237', '721276', '1065', '0', '5 420');
REPLACE INTO `cq_action` VALUES ('721276', '721277', '0000', '0101', '0', 'You~Must~Wear~Blade~Or~Sword~In~Your~Hand');
REPLACE INTO `cq_action` VALUES ('721235', '721277', '0000', '0101', '0', 'Sorry Come At xx 25');
REPLACE INTO `cq_action` VALUES ('721236', '721277', '0000', '0101', '0', 'Sorry You Got 5 hits come later');
REPLACE INTO `cq_action` VALUES ('721277', '15003', '0000', '0102', '0', 'Thanks. 0');
###############################################ACTIONLOGIN#################################################################
REPLACE INTO `cq_action` VALUES ('721287', '721258', '0', '1073', '0', 'stc(25,10) == 1');
##################################################ACTIONEVENT##########################################################################
REPLACE INTO `cq_action` VALUES ('721237', '721301', '0000', '1003', '0', '7147 50 50');
REPLACE INTO `cq_action` VALUES ('721301', '721302', '0000', '1001', '0', 'life += 99999999');
REPLACE INTO `cq_action` VALUES ('721302', '721303', '0000', '1001', '0', 'e_money += 1');
REPLACE INTO `cq_action` VALUES ('721303', '721284', '0000', '1039', '0', '1115');
REPLACE INTO `cq_action` VALUES ('721284', '721241', '0000', '0127', '0', 'Insert into 5hits set id=%user_id');  
REPLACE INTO `cq_action` VALUES ('721241', '721242', '0000', '1077', '1', 'select additional_point from cq_user where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721242', '721243', '0000', '0127', '0', 'update 5hits set additional_point=%iter_var_data1 where id=%user_id');  
REPLACE INTO `cq_action` VALUES ('721243', '721244', '0000', '1001', '0', 'addpoint += -%iter_var_data1');
REPLACE INTO `cq_action` VALUES ('721244.','721245', '0000', '1077', '2', 'select health from cq_user where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721245', '721246', '0000', '0127', '0', 'update 5hits set health=%iter_var_data2 where id=%user_id');  
REPLACE INTO `cq_action` VALUES ('721246', '721247', '0000', '1001', '0', 'health += -%iter_var_data2');
REPLACE INTO `cq_action` VALUES ('721247', '721248', '0000', '1001', '0', 'health += 2000');
REPLACE INTO `cq_action` VALUES ('721248', '721238', '0000', '1001', '0', 'life += 99999999');
REPLACE INTO `cq_action` VALUES ('721238', '721249', '0000', '1001', '0', 'e_money += -1');
REPLACE INTO `cq_action` VALUES ('721249', '000000', '0000', '1071', '0', '0 721250');
REPLACE INTO `cq_action` VALUES ('721250', '721256', '721251', '1073', '0', 'stc(266,10) == 5');
REPLACE INTO `cq_action` VALUES ('721251', '721278', '721257', '2003', '0', '%user_map_id == 7147');
REPLACE INTO `cq_action` VALUES ('721278', '721239', '721279', '1065', '0', '4 410');
REPLACE INTO `cq_action` VALUES ('721279', '721239', '721280', '1065', '0', '4 420');
REPLACE INTO `cq_action` VALUES ('721280', '721239', '721281', '1065', '0', '5 410');
REPLACE INTO `cq_action` VALUES ('721281', '721239', '721282', '1065', '0', '5 420');
REPLACE INTO `cq_action` VALUES ('721282', '721283', '0000', '1003', '0', '1002 429 378');
REPLACE INTO `cq_action` VALUES ('721283', '721258', '0000', '0125', '2005', '[ %user_name ] Changed His Weapon And System Sent Him Out');
REPLACE INTO `cq_action` VALUES ('721239.','721252', '0000', '1077', '3', 'select life from cq_user where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721252', '721249', '721253', '1001', '0', 'life == %iter_var_data3');
REPLACE INTO `cq_action` VALUES ('721253', '721267', '0000', '1074', '0', 'stc(266,10) += 1 1');
REPLACE INTO `cq_action` VALUES ('721267', '721256', '721240', '1073', '0', 'stc(266,10) == 5');
REPLACE INTO `cq_action` VALUES ('721240', '000000', '0000', '1071', '0', '0 721254');
REPLACE INTO `cq_action` VALUES ('721254', '721255', '0000', '1077', '4', 'select  data from cq_statistic where player_id=%user_id and event_type=266 and  data_type=10');
REPLACE INTO `cq_action` VALUES ('721255', '721248', '0000', '0125', '2005', '[ %user_name ] Had Got [ %iter_var_data4 ] Hit In tournament #29');
REPLACE INTO `cq_action` VALUES ('721256', '721257', '0000', '0125', '2005', '[ %user_name ] Had Got [ 5 ] Hits And Send Out To Twin City  #29');
REPLACE INTO `cq_action` VALUES ('721257', '721258', '0000', '1003', '0', '1002 429 378');
REPLACE INTO `cq_action` VALUES ('721258', '721259', '0000', '1077', '5', 'select additional_point from 5hits where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721259', '721260', '0000', '1001', '0', 'addpoint += %iter_var_data5');
REPLACE INTO `cq_action` VALUES ('721260.','721261', '0000', '1077', '6', 'select health from cq_user where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721261', '721262', '0000', '1001', '0', 'health += -%iter_var_data6');
REPLACE INTO `cq_action` VALUES ('721262.','721263', '0000', '1077', '7', 'select health from 5hits where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721263', '721264', '0000', '1001', '0', 'health += +%iter_var_data7');
REPLACE INTO `cq_action` VALUES ('721264', '721265',  '0000', '0127', '0', 'delete from 5hits where id=%user_id');
REPLACE INTO `cq_action` VALUES ('721265', '721266', '0000', '1001', '0', 'life += 99999999');
REPLACE INTO `cq_action` VALUES ('721266', '721288', '0000', '1001', '0', 'e_money += 1');
REPLACE INTO `cq_action` VALUES ('721288', '0', '0000', '1074', '0', 'stc(25,10) = 0 1');
###############################################Prize###############################################################
REPLACE INTO `cq_action` VALUES ('721289', '721290', '0000', '0101', '0', 'Hello [ %user_name ] its a prof tournament event are you only here?');
REPLACE INTO `cq_action` VALUES ('721290', '721291', '0000', '0102', '0', 'Yes. 721292');
REPLACE INTO `cq_action` VALUES ('721291', '15003', '0000', '0102', '0', 'Thanks. 0');

REPLACE INTO `cq_action` VALUES ('721292', '721293', '721297', '0123', '5', '30 59');
REPLACE INTO `cq_action` VALUES ('721293', '721294', '721298', '302', '7147', 'alive_user == 1');
REPLACE INTO `cq_action` VALUES ('721294', '721295', '0000', '1001', '0', 'e_money += 500000');
REPLACE INTO `cq_action` VALUES ('721295', '721296', '0000', '1003', '0', '1002 429 378');
REPLACE INTO `cq_action` VALUES ('721296', '721304', '0000', '0125', '2005', '[ %user_name ] Has Won In 5 Hit tournament And Got [ 500,000 ] Cps #07');
REPLACE INTO `cq_action` VALUES ('721297', '721277', '0000', '0101', '0', 'Sorry Come At xx 30');
REPLACE INTO `cq_action` VALUES ('721298', '721277', '0000', '0101', '0', 'Sorry You Not Alone In The Tournament');
REPLACE INTO `cq_action` VALUES ('721304', '0', '0', '2013', '0', '1002 721299 -1');  
REPLACE INTO `cq_action` VALUES ('721299', '721300', '0000', '1074', '0', 'stc(266,10) = 0 1');
REPLACE INTO `cq_action` VALUES ('721300', '721258', '0000', '0127', '0', 'update cq_statistic set data=0 where event_type=266 and data_type=10');
#####################################################################Map####################################################
REPLACE INTO `cq_map` VALUES ('7147', '5-hits-tourament', 'Franco', '1787', '0007', '0', '0000', '-1', '0000', '0000', '0000', '0049', '0038', '0025', '0000', '000', '000', '0000', '0000', '0000', '000', '4294967295');
#############################################TASK##############################################################################
Replace INTO `cq_task` VALUES ('721230','721230',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721231','721231',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721232','721232',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721233','721233',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721234','721234',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721235','721235',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721236','721236',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721237','721237',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721238','721238',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721239','721239',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721240','721240',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721241','721241',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721242','721242',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721243','721243',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721244','721244',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721245','721245',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721246','721246',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721247','721247',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721248','721248',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721249','721249',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721250','721250',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721251','721251',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721252','721252',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721253','721253',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721254','721254',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721255','721255',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721256','721256',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721257','721257',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721258','721258',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721259','721259',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721260','721260',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721261','721261',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721262','721262',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721263','721263',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721264','721264',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721265','721265',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721266','721266',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721267','721267',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721268','721268',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721269','721269',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721270','721270',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721271','721271',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721272','721272',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721273','721273',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721274','721274',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721275','721275',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721276','721276',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721277','721277',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721278','721278',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721279','721279',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721280','721280',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721281','721281',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721282','721282',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721283','721283',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721284','721284',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721285','721285',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721286','721286',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721287','721287',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721288','721288',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721289','721289',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721290','721290',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721291','721291',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721292','721292',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721293','721293',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721294','721294',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721295','721295',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721296','721296',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721297','721297',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721298','721298',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721299','721299',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721300','721300',0,'','',0,0,0,0,1000,0,0,0,-1,0);
Replace INTO `cq_task` VALUES ('721304','721304',0,'','',0,0,0,0,1000,0,0,0,-1,0);  

                                                                                                                                                                                                                                                                                   Crédito: Vantom

cmo add no meu co

Basta executar os código na Query do navicat...

meu ficou bugado ficou um tapete

Não ta bugado basta você troca a lookface do npc...

vlw

Nao funciona, voce entra no mapa aparece que vc tomou 5hits e vc eh levado para tc!