Aller au contenu
Top-Metin2.org - Vous êtes à la recherche d'un serveur Metin 2 ? ×
×
×
  • Créer...
Top-Metin2.org - Vous êtes à la recherche d'un serveur Metin 2 ?
  • 0

Problème table Navicat (Files Starfula 2018)

MrBoogi

Posée par MrBoogi,

 Partager

Question

MrBoogi Newbie

MrBoogi 0

Posté(e)
Posté(e)

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.

Lien vers le commentaire
Partager sur d’autres sites
  • Réponses 3
  • Créé
  • Dernière réponse

Meilleurs contributeurs dans cette question

Jours populaires

Meilleurs contributeurs dans cette question

Jours populaires

3 réponses à cette question

Messages recommandés

Invité
Ce sujet ne peut plus recevoir de nouvelles réponses.
 Partager
Aller à la liste des questions


  • brilliantdiscord_widget

  • Flux d'Activité

    1. 17

      Metin2 40250 / 2014 Serverfiles + Client + SRC [ 15 Langues ]

      super merci
      ketra dans Binaires
    2. 37

      2.1.0.0 | M2KSF Project

      un grand merci !
      ketra dans Binaires
    3. 21

      Metin2 en 2020 peut-on en parler?

      J'ai bien compris votre point de vue, mais même les serveurs avec la deuxième option que vous avez mentionnée en termes de nombre de joueurs ont connu une forte baisse par rapport aux autres pays. C'est regrettable.
      Sojobo dans Metin2
    4. 0

      METIN2Project

      Yo, de retour après de longue années.. Je refais des files je ne vais pas donner beaucoup de détails ici sur les files sinon je vais jamais en finir, rejoignez le Discord [Hidden Content] pour plus d'informations. J'essaye de reproduire des files à l'Officiel sans trop ajouter des systèmes "cassés" ou "leak" sans trop sortir de l'original. Je suis sur le Projet depuis début de l'année 2023 après 1ans de pause je reprends le développement des files. Sur ce on se retrouve sur mon Discord pour plus d'explication & informations !
      • 2
      • Eyes
      • Good
      Kuroko dans Metin2
    5. 3

      Ressources - UnPack - Metin2 Client - Officiel

      merci pour le partage, je cherche des fichiers clients manquant pour complèter mon installation de "System chèque won". Introuvable dans le client Reference Serverfile by TMP4. j'espere trouver mon bonheur avec cela !!
      Root dans Binaires
    6. 0

      Barre des tâches d'argent étendue

      Bonjour j'ai suivis le tuto [Hidden Content] Je me retrouve confronter à une erreur dans le client au lancement après la selection du personnage. 0329 13:24:35491 :: Traceback (most recent call last): 0329 13:24:35491 :: File "networkModule.py", line 247, in SetGamePhase 0329 13:24:35491 :: File "game.py", line 98, in __init__ 0329 13:24:35492 :: File "interfaceModule.py", line 298, in MakeInterface 0329 13:24:35492 :: File "interfaceModule.py", line 150, in __MakeTaskBar 0329 13:24:35493 :: AttributeError 0329 13:24:35493 :: : 0329 13:24:35493 :: 'Interface' object has no attribute 'ToggleExpandedMoneyButton' 0329 13:24:35493 :: Quelqu'un peut m'aiguiller ?
      Root dans Questions & Réponses
    7. 16

      Redémarrage automatique des channels

      Bonjour, j'ai surment mal compris une partie, car pour moi une erreur au lancement du serveur s'affiche ! ./chan_restarter: 8: Syntax error: word unexpected. quelqu'un peut il m'aider ? Alors suite a quelque test j'ai réussi. il fonctionne en changent date pour `date` dans chan_restarter. je vais voir si cela fonctionne sur du long terme.
      Root dans Création & Gestion de Serveur
    8. 311

      Créer un serveur Metin2

      Bonjour, merci poour ce tuto !
      Root dans Création & Gestion de Serveur
    9. 16

      Multi Logo GM / SGM / GA

      Certaines mises à jour ne fonctionnent pas et fonctionnent
      • 2
      • Love
      • Love
      TTV RANDARON dans Programmation & Développement / Codes

  • En ligne récemment

    • Aucun utilisateur enregistré regarde cette page.

Information importante

Conditions d’utilisation / Politique de confidentialité / Règles / Nous avons placé des cookies sur votre appareil pour aider à améliorer ce site. Vous pouvez choisir d’ajuster vos paramètres de cookie, sinon nous supposerons que vous êtes d’accord pour continuer.

  J’accepte