• 0
MrBoogi

en cours Problème table Navicat (Files Starfula 2018)

Question

Petit problème quand j'execute les files account et log ..

Si quelqu’un à une solution .. !  🤗 

 

 :3101442018-12-31-17h50-50.png

 

Le message en entier

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Navicat MySQL Data Transfer

 Source Server         : Santeria
 Source Server' at line 1
[Err] Navicat MySQL Data Transfer

 Source Server         : Santeria
 Source Server Type    : MySQL
 Source Server Version : 50641
 Source Host           : 37.59.60.220:3306
 Source Schema         : account

 Target Server Type    : MySQL
 Target Server Version : 50641
 File Encoding         : 65001

 Date: 27/09/2018 21:21:46


-- ----------------------------
-- Table structure for 3rdshop_items
-- ----------------------------
DROP TABLE IF EXISTS `3rdshop_items`;
CREATE TABLE `3rdshop_items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `vnum` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `attrtype0` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue0` smallint(6) NOT NULL DEFAULT 0,
  `attrtype1` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue1` smallint(6) NOT NULL DEFAULT 0,
  `attrtype2` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue2` smallint(6) NOT NULL DEFAULT 0,
  `attrtype3` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue3` smallint(6) NOT NULL DEFAULT 0,
  `attrtype4` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue4` smallint(6) NOT NULL DEFAULT 0,
  `attrtype5` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue5` smallint(6) NOT NULL DEFAULT 0,
  `attrtype6` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue6` smallint(6) NOT NULL DEFAULT 0,
  `socket0` int(5) NOT NULL DEFAULT 1,
  `socket1` int(5) NOT NULL DEFAULT 1,
  `socket2` int(5) NOT NULL DEFAULT 1,
  `time` int(11) NOT NULL DEFAULT 0,
  `percent` int(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 248 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(30) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `password` varchar(45) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `real_name` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
  `social_id` varchar(13) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `email` varchar(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `phone1` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `phone2` varchar(16) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `address` varchar(128) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `zipcode` varchar(7) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
  `create_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `question1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `answer1` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `question2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `answer2` varchar(48) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT NULL,
  `is_testor` tinyint(1) NOT NULL DEFAULT 0,
  `status` varchar(8) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT 'OK',
  `securitycode` varchar(192) CHARACTER SET ascii COLLATE ascii_general_ci NULL DEFAULT '',
  `newsletter` tinyint(1) NULL DEFAULT 0,
  `empire` tinyint(4) NOT NULL DEFAULT 0,
  `name_checked` tinyint(1) NOT NULL DEFAULT 0,
  `availDt` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `mileage` int(11) NOT NULL DEFAULT 0,
  `cash` int(11) NOT NULL DEFAULT 0,
  `gold_expire` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `silver_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
  `safebox_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
  `autoloot_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
  `fish_mind_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
  `marriage_fast_expire` datetime(0) NOT NULL DEFAULT '2035-05-05 21:00:00',
  `money_drop_rate_expire` datetime(0) NOT NULL DEFAULT '0000-0
[Err] 1146 - Table 'account.bank_log' doesn't exist
[Err] INSERT INTO `bank_log` VALUES ('fefe', '1', 1000000, '2018-08-18 20:58:37', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('fefe', '3', 1000000, '2018-08-18 20:58:51', '90.125.207.133', 'vacerre');
INSERT INTO `bank_log` VALUES ('vacerre', '4', 1000000, '2018-08-18 20:58:51', '************', 'fefe');
INSERT INTO `bank_log` VALUES ('fefe', '1', 1000000, '2018-08-18 21:02:23', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('fefe', '3', 1000000, '2018-08-18 21:02:32', '90.125.207.133', 'vacerre');
INSERT INTO `bank_log` VALUES ('vacerre', '4', 1000000, '2018-08-18 21:02:32', '************', 'fefe');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:04:34', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:06:55', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:09:12', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:10:33', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:12:26', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:13:34', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:45:03', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:47:56', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:48:48', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:49:39', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:50:50', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:52:34', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:53:32', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:55:20', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:57:23', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 21:58:32', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:00:52', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:03:36', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:09:36', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:11:15', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:13:11', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:15:00', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '1', 1000000, '2018-08-18 22:17:38', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('vacerre', '2', 25000000, '2018-08-18 22:34:54', '90.125.207.133', '************');
INSERT INTO `bank_log` VALUES ('albeate', '1', 10000, '2018-08-19 03:33:19', '95.186.177.25', '************');
INSERT INTO `bank_log` VALUES ('maximick', '1', 45652904, '2018-08-19 23:05:13', '87.66.77.172', '************');
INSERT INTO `bank_log` VALUES ('maximick', '2', 45652904, '2018-08-19 23:11:44', '87.66.77.172', '************');
INSERT INTO `bank_log` VALUES ('Namour', '1', 1000000, '2018-08-20 11:46:03', '93.31.137.6', '************');
INSERT INTO `bank_log` VALUES ('Namour', '2', 1000000, '2018-08-20 11:48:40', '93.31.137.6', '************');

-- ----------------------------
-- Table structure for bank_user
-- ----------------------------
DROP TABLE IF E
[Err] 1146 - Table 'account.bank_user' doesn't exist
[Err] INSERT INTO `bank_user` VALUES ('zebi', 0, '1234');

-- ----------------------------
-- Table structure for block_exception
-- ----------------------------
DROP TABLE IF EXISTS `block_exception`;
CREATE TABLE `block_exception`  (
  `login` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = MyISAM CHARACTER SET = big5 COLLATE = big5_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of block_exception
-- ----------------------------
INSERT INTO `block_exception` VALUES ('admin');

-- ----------------------------
-- Table structure for drsshop_items
-- ----------------------------
DROP TABLE IF EXISTS `drsshop_items`;
CREATE TABLE `drsshop_items`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `vnum` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `attrtype0` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue0` smallint(6) NOT NULL DEFAULT 0,
  `attrtype1` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue1` smallint(6) NOT NULL DEFAULT 0,
  `attrtype2` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue2` smallint(6) NOT NULL DEFAULT 0,
  `attrtype3` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue3` smallint(6) NOT NULL DEFAULT 0,
  `attrtype4` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue4` smallint(6) NOT NULL DEFAULT 0,
  `attrtype5` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue5` smallint(6) NOT NULL DEFAULT 0,
  `attrtype6` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue6` smallint(6) NOT NULL DEFAULT 0,
  `socket0` int(5) NOT NULL DEFAULT 1,
  `socket1` int(5) NOT NULL DEFAULT 1,
  `socket2` int(5) NOT NULL DEFAULT 1,
  `time` int(11) NOT NULL DEFAULT 0,
  `percent` int(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 248 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for gametime
-- ----------------------------
DROP TABLE IF EXISTS `gametime`;
CREATE TABLE `gametime`  (
  `UserID` varchar(50) CHARACTER SET euckr COLLATE euckr_korean_ci NOT NULL DEFAULT '',
  `paymenttype` tinyint(2) NOT NULL DEFAULT 1,
  `LimitTime` int(11) NULL DEFAULT 0,
  `LimitDt` datetime(0) NULL DEFAULT '1990-01-01 00:00:00',
  `Scores` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`UserID`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = euckr COLLATE = euckr_korean_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for gametimeip
-- ----------------------------
DROP TABLE IF EXISTS `gametimeip`;
CREATE TABLE `gametimeip`  (
  `ipid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET euckr COLLATE euckr_korean_ci NULL DEFAULT NULL,
  `ip` varchar(11) CHARACTER SET euckr COLLATE euckr_korean_ci NOT NULL DEFAULT '000.000.000',
  `startIP` int(11) NOT NULL DEFAULT 0,
  `endIP` int(11) NOT NULL DEFAULT 255,
  `paymenttype` tinyint(2) NOT NULL DEFAULT 1,
  `LimitTime` int(11) NOT NULL DEFAULT 0,
  `LimitDt` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `readme` varchar(128) CHARACTER SET euckr COLLATE euckr_korean_ci NULL DEFAULT NULL,
  PRIMARY KEY (`ipid`) USING BTREE,
  UNIQUE INDEX `ip_uniq`(`ip`, `startIP`, `endIP`) USING BTREE,
  INDEX `ip_idx`(`ip`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = euckr COLLATE = euckr_korean_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for gametimelog
-- ----------------------------
DROP TABLE IF EXISTS `gametimelog`;
CREATE TABLE `gametimelog`  (
  `login` varchar(16) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `type` enum('IP_FREE','FREE','IP_TIME','IP_DAY','TIME','DAY') CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `logon_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `logout_time` datetime(0) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `use_time` int(11) NULL DEFAULT NULL,
  `ip` varchar(15) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL DEFAULT '000.000.000.000',
  `server` varchar(32)
[Err] 1146 - Table 'account.itemshop_items' doesn't exist
[Err] INSERT INTO `itemshop_items` VALUES (84, 4, 41295, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (85, 4, 41296, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (86, 4, 41297, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (87, 4, 41298, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (88, 4, 41308, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (89, 4, 41312, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (90, 4, 41316, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (91, 4, 41321, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (92, 4, 41325, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (93, 4, 41482, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (94, 4, 41483, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (95, 5, 45002, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (96, 5, 45003, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (97, 5, 45005, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (98, 5, 45007, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (99, 5, 45009, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (100, 5, 45011, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (101, 5, 45013, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (102, 5, 45015, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (103, 5, 45053, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (104, 5, 45055, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (105, 5, 45057, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (106, 5, 45075, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (107, 5, 45076, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (108, 5, 45077, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (109, 6, 45078, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (110, 5, 45079, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (111, 5, 45119, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (112, 5, 45120, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (113, 5, 45121, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (114, 5, 45122, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (115, 5, 45135, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (116, 5, 45147, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (117, 5, 45151, 105, 0, 0, 0, 0, 0, 0, 0, 0,
[Err] 1146 - Table 'account.itemshop_items' doesn't exist
[Err] INSERT INTO `itemshop_items` VALUES (184, 9, 40142, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (185, 9, 40143, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (186, 9, 40144, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (187, 9, 40145, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (188, 9, 40146, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (189, 9, 40147, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (190, 9, 40148, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (191, 9, 40149, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (192, 9, 40150, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (194, 9, 40152, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (195, 9, 40153, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (196, 9, 40154, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (197, 9, 40155, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (198, 9, 40156, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (199, 9, 40157, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (200, 9, 40158, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (201, 9, 40159, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (202, 9, 40164, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (203, 9, 40165, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (204, 9, 40166, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (205, 9, 40169, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (206, 9, 40170, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (207, 9, 40171, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (208, 9, 40179, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (209, 9, 40180, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (210, 9, 40181, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (211, 9, 40184, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (212, 9, 40185, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (213, 9, 40186, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (214, 10, 40004, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (215, 10, 49000, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1728000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (216, 10, 49001, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1728000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (217, 10, 49002, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1728000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (218, 10, 49003, 105, 0, 0, 0,
[Err] 1146 - Table 'account.itemshop_items' doesn't exist
[Err] INSERT INTO `itemshop_items` VALUES (285, 10, 80014, 105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (286, 10, 80015, 505, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);
INSERT INTO `itemshop_items` VALUES (287, 10, 80016, 1005, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2592000, 1, 1, 0, 0);

-- ----------------------------
-- Table structure for itemshop_logs
-- ----------------------------
DROP TABLE IF EXISTS `itemshop_logs`;
CREATE TABLE `itemshop_logs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `vnum` int(11) NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 1,
  `item_id` int(11) NOT NULL,
  `attrtype0` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue0` smallint(6) NOT NULL DEFAULT 0,
  `attrtype1` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue1` smallint(6) NOT NULL DEFAULT 0,
  `attrtype2` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue2` smallint(6) NOT NULL DEFAULT 0,
  `attrtype3` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue3` smallint(6) NOT NULL DEFAULT 0,
  `attrtype4` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue4` smallint(6) NOT NULL DEFAULT 0,
  `attrtype5` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue5` smallint(6) NOT NULL DEFAULT 0,
  `attrtype6` tinyint(4) NOT NULL DEFAULT 0,
  `attrvalue6` smallint(6) NOT NULL DEFAULT 0,
  `socket0` int(5) NOT NULL DEFAULT 1,
  `socket1` int(5) NOT NULL DEFAULT 1,
  `socket2` int(5) NOT NULL DEFAULT 1,
  `price` int(11) NOT NULL,
  `date` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1039 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Table structure for monarch
-- ----------------------------
DROP TABLE IF EXISTS `monarch`;
CREATE TABLE `monarch`  (
  `empire` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `pid` int(10) UNSIGNED NULL DEFAULT NULL,
  `name` varchar(16) CHARACTER SET big5 COLLATE big5_chinese_ci NULL DEFAULT NULL,
  `windate` datetime(0) NULL DEFAULT NULL,
  `money` bigint(20) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`empire`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = big5 COLLATE = big5_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `titel` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `inhalt` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `datum` int(10) UNSIGNED NOT NULL,
  `hot` tinyint(1) NOT NULL,
  `kategorie` int(10) UNSIGNED NOT NULL,
  `author` int(10) UNSIGNED NOT NULL,
  `anzeigen` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for news_web
-- ----------------------------
DROP TABLE IF EXISTS `news_web`;
CREATE TABLE `news_web`  (
  `titel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `inhalt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `datum` timestamp(6) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for r1z_dmca
-- ----------------------------
DROP TABLE IF EXISTS `r1z_dmca`;
CREATE TABLE `r1z_dmca`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `types` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ro` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `en` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `es` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ---------------------------
[Err] 1146 - Table 'account.r1z_tos' doesn't exist
[Err] INSERT INTO `r1z_tos` VALUES (38, '1', 'r)     You may not give false information to or intentionally hide any information from WoM, such as e-mail addresses, account information, billing information, which may be required at the time you register with the WoM service. It is your responsibility to keep this information current.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (39, '1', 's)    You may not use, create, play, or provide any server emulation, or services where WoM products or services may be played. You may not communicate, solicit, use or otherwise distribute any utilities, emulators, applications, or other programs/software related to WoM that does not have the express written permission of FOX WARE SRL to be used with the services.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (40, '1', 't)     You may not attempt to interfere with, hack, or otherwise decipher any transmissions to or from the servers running the WoM services, nor its providers.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (41, '1', 'u)    You may not violate the intellectual property rights of a third party. You may not upload, transmit, or otherwise communicate copyrighted material which you do not own the rights to without express written permission of the author and/or copyright holder through the WoM services.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (42, '1', 'v)    You may not intentionally accept an item that has been altered or otherwise manipulated outside of the designed game mechanic or intended feature from anyone inside or outside the game or services. WoM has the right to confiscate any such item(s), without reparation, even if a player had no prior knowledge of the item\'s origin.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (43, '1', 'w)    You may not do anything that interferes with the capability of other WoM users to enjoy playing WoM games or using the WoM services as defined by the respective Terms of Service and/or Rules of Conduct, or that increases the expense or difficulty of WoM in maintaining the WoM services for its users.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (44, '1', 'x)    You may not intentionally submit inaccurate information, nor otherwise abuse any help, email, or petitioning system.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (45, '1', 'y)    You may not attempt to play any WoM product on any service that is not authorized, approved, or controlled by FOX WARE SRL or applicable license holders.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (46, '1', 'By use of the WoM service you acknowledge that you agree to these terms and will follow them in their entirety. You agree that these terms will apply to anyone who has access to your WoM account. This includes access via your approval, permission, or by otherwise having access to your WoM account or account information (in whole or in part). You further agree that you are responsible and liable for any and all consequences which may include, (but are not restricted to) warnings, suspensions or terminations of your account based upon violations of these terms by any person.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (47, '1', 'FOX WARE SRL may find it necessary to alter, reset, or otherwise change certain parameters of, an on-going product or service in order to realign the \'balance\' of the product or service. These modifications or resets may affect in-game assets, avatars, in-game personas, and may regress the product or service.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (48, '1', 'These rules may be modified, amended, or otherwise changed at any time. You agree to visit the WoM website to review any changes to these rules/terms which may have been made. You agree to carefully read these terms and conditions.', ' ', ' ');
INSERT INTO `r1z_tos` VALUES (49, '1', 'If you encounter any conduct or user submitted content on the WoM which is in violation of these ToS, it is your duty and responsibility as an WoM community member to report said action to us as we cannot and do not prescreen all forms of communication in the community. We reserve the exclusive rig
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

 

En postant ma demande d'aide, j'affirme avoir lu et accepté le Règlement de Funky-Emulation.

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 1

OMG cache les Ip's stp  

 

Sinon avez tu deja des table deja existant sous le meme nom? (si oui, supprime les et retest)

2eme possibilité passe en query pour etre sur de l'implatation de ta table des fois sa passe mieux. (demande moi pas pourquoi lol)

Share this post


Link to post
Share on other sites
  • 0

Désolé du retard ..

 

J'ai essayer les 2 pas trouver de différence 😭

 

Ou tu vois mon IP ?

 

 

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.