+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Help & Support (https://lckb.dev/forum/forumdisplay.php?fid=157)
+----- Forum: Ep2 Support (https://lckb.dev/forum/forumdisplay.php?fid=166)
+------ Forum: Solved Topics (https://lckb.dev/forum/forumdisplay.php?fid=144)
+------ Thread: Looking for t_title (/showthread.php?tid=2627)
- Triralith - 11-04-2013
Hey! Im looking for t_title table with everything not edited. I would like to get navicat sql code. I would like to get records from a_index 1 till 90
Thanks in advance.
- Paramount - 11-04-2013
/*
Navicat MySQL Data Transfer
Source Server : RUS_30W_E00_SRV
Source Server Version : 50532
Source Host : 127.0.0.1:3306
Source Database : data
Target Server Type : MYSQL
Target Server Version : 50532
File Encoding : 65001
Date: 2013-11-04 20:04:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_title
-- ----------------------------
DROP TABLE IF EXISTS `t_title`;
CREATE TABLE `t_title` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_name` varchar(40) NOT NULL DEFAULT ,
`a_enable` tinyint(3) NOT NULL DEFAULT 0,
`a_describe` varchar(255) DEFAULT NULL,
`a_effect_name` varchar(255) DEFAULT NULL,
`a_attack` varchar(255) DEFAULT NULL,
`a_damage` varchar(255) DEFAULT NULL,
`a_time` int(11) NOT NULL DEFAULT 0,
`a_bgcolor` varchar(10) NOT NULL DEFAULT ,
`a_color` varchar(10) NOT NULL DEFAULT ,
`a_option_index0` int(11) NOT NULL DEFAULT -1,
`a_option_level0` tinyint(3) unsigned NOT NULL DEFAULT 0,
`a_option_index1` int(11) NOT NULL DEFAULT -1,
`a_option_level1` tinyint(3) unsigned NOT NULL DEFAULT 0,
`a_option_index2` int(11) NOT NULL DEFAULT -1,
`a_option_level2` tinyint(3) unsigned NOT NULL DEFAULT 0,
`a_option_index3` int(11) NOT NULL DEFAULT -1,
`a_option_level3` tinyint(3) unsigned NOT NULL DEFAULT 0,
`a_option_index4` int(11) NOT NULL DEFAULT -1,
`a_option_level4` tinyint(3) unsigned NOT NULL DEFAULT 0,
`a_item_index` int(11) NOT NULL DEFAULT 0,
`a_flag` int(11) unsigned NOT NULL DEFAULT 0,
`a_castle_num` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`a_index`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of t_title
-- ----------------------------
INSERT INTO `t_title` VALUES (1, , 1, , eff_nameORANGE, , , -1, E30000FF, 00FF00FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 5005, 0, 0);
INSERT INTO `t_title` VALUES (2, , 1, , cao_ti_am_5, , , -1, C0C0C0FF, FF0000FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 5006, 0, 0);
INSERT INTO `t_title` VALUES (3, , 1, , cao_ti_am_5, , , -1, C0C0C0FF, FF0000FF, 4, 4, 4, 3, 4, 5, 5, 4, 5, 4, 5007, 0, 0);
INSERT INTO `t_title` VALUES (4, , 1, , eff_nameORANGE, , , -1, 000000FF, F9ED30FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 5008, 0, 0);
INSERT INTO `t_title` VALUES (5, , 1, , eff_nameS, , mHitElectricBall, -1, 00005DFF, FF00FFFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 5009, 0, 0);
INSERT INTO `t_title` VALUES (6, , 1, , eff_nameH, , , -1, FFFFFFFF, 00FF00FF, 4, 5, -1, 0, -1, 0, -1, 0, -1, 0, 5010, 0, 0);
INSERT INTO `t_title` VALUES (7, , 1, , cao_hw_arm_2, , , -1, C0C0C0FF, 000000FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 5011, 0, 0);
INSERT INTO `t_title` VALUES (9, , 1, , , , , -1, C0C0C0FF, FF8000FF, 4, 5, 5, 5, 55, 1, 66, 1, -1, 0, 5972, 0, 0);
INSERT INTO `t_title` VALUES (10, , 1, , , , , -1, C0C0C0FF, FF0000FF, 4, 5, 5, 5, 55, 1, 66, 1, -1, 0, 5973, 0, 0);
INSERT INTO `t_title` VALUES (14, , 1, , , , , -1, C0C0C0FF, 000000FF, 11, 4, -1, 0, -1, 0, -1, 0, -1, 0, 5150, 0, 0);
INSERT INTO `t_title` VALUES (15, , 1, , , , , -1, C0C0C0FF, 01CD15FF, 11, 5, 18, 5, -1, 0, -1, 0, -1, 0, 5151, 0, 0);
INSERT INTO `t_title` VALUES (16, , 1, , , , , -1, C0C0C0FF, 000000FF, 3, 4, -1, 0, -1, 0, -1, 0, -1, 0, 5154, 0, 0);
INSERT INTO `t_title` VALUES (17, , 1, , , , , -1, C0C0C0FF, C9F18DFF, 3, 5, 4, 5, -1, 0, -1, 0, -1, 0, 5155, 0, 0);
INSERT INTO `t_title` VALUES (18, , 1, , , , , -1, C0C0C0FF, 000000FF, 1, 1, -1, 0, -1, 0, -1, 0, -1, 0, 5158, 0, 0);
INSERT INTO `t_title` VALUES (19, , 1, , , , , -1, C0C0C0FF, F4A30BFF, 1, 2, 0, 1, -1, 0, -1, 0, -1, 0, 5159, 0, 0);
INSERT INTO `t_title` VALUES (20, , 1, , , , , -1, 808080FF, 80FFFFFF, 58, 1, -1, 0, -1, 0, -1, 0, -1, 0, 5967, 0, 0);
INSERT INTO `t_title` VALUES (21, , 1, , , , , -1, 000000FF, FF0080FF, 66, 3, 55, 3, -1, 0, -1, 0, -1, 0, 5968, 0, 0);
INSERT INTO `t_title` VALUES (22, , 1, , , , , -1, 000000FF, F9EF2FFF, 64, 2, -1, 0, -1, 0, -1, 0, -1, 0, 5953, 0, 0);
INSERT INTO `t_title` VALUES (23, , 1, , , , , -1, 000000FF, 80FF00FF, 71, 6, 72, 6, -1, 0, -1, 0, -1, 0, 6085, 0, 0);
INSERT INTO `t_title` VALUES (24, , 1, , cao_hw_arm_2, , , -1, 000439FF, 41FFFFFF, 24, 1, 24, 1, 73, 4, -1, 0, -1, 0, 6236, 0, 0);
INSERT INTO `t_title` VALUES (25, , 1, , eff_nameT, , , -1, C0C0C0FF, FF0000FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6237, 0, 0);
INSERT INTO `t_title` VALUES (26, , 1, , eff_nameN, , , -1, C0C0C0FF, 0000FFFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6238, 0, 0);
INSERT INTO `t_title` VALUES (27, , 1, , eff_nameH, , , -1, C0C0C0FF, 00FF00FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6239, 0, 0);
INSERT INTO `t_title` VALUES (28, , 1, , eff_nameM, , , -1, C0C0C0FF, 00006AFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6240, 0, 0);
INSERT INTO `t_title` VALUES (29, , 1, , eff_nameR, , , -1, C0C0C0FF, FF8000FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6241, 0, 0);
INSERT INTO `t_title` VALUES (30, , 1, , eff_nameS, , , -1, C0C0C0FF, 400080FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6242, 0, 0);
INSERT INTO `t_title` VALUES (31, , 1, , eff_nameS, , , -1, C0C0C0FF, F90296FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6243, 0, 0);
INSERT INTO `t_title` VALUES (32, , 1, , eff_nameYELLOW, , , -1, C0C0C0FF, FFFF00FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6244, 0, 0);
INSERT INTO `t_title` VALUES (33, , 1, , cao_ma_am_5, , , -1, C0C0C0FF, 000000FF, 83, 5, -1, 0, -1, 0, -1, 0, -1, 0, 6245, 0, 0);
INSERT INTO `t_title` VALUES (34, , 1, , , , , -1, FF0000FF, 000000FF, 82, 5, -1, 0, -1, 0, -1, 0, -1, 0, 6246, 0, 0);
INSERT INTO `t_title` VALUES (35, , 1, , eff_nameGREEN, , , 14, 00FF00FF, FFFFFFFF, 58, 2, 4, 1, -1, 0, -1, 0, -1, 0, 6247, 0, 0);
INSERT INTO `t_title` VALUES (36, , 1, , eff_namePURPLE, , , 14, 55006DFF, FFFFFFFF, 4, 5, 4, 5, 25, 2, 58, 1, -1, 0, 6248, 0, 0);
INSERT INTO `t_title` VALUES (37, , 1, , eff_nameORANGE, , , -1, 000000FF, D27200FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6249, 0, 0);
INSERT INTO `t_title` VALUES (38, , 1, , , , , -1, C0C0C0FF, 000000FF, 2, 1, -1, 0, -1, 0, -1, 0, -1, 0, 6309, 0, 0);
INSERT INTO `t_title` VALUES (39, , 1, , , , , -1, C0C0C0FF, FF595EFF, 2, 2, 1, 1, -1, 0, -1, 0, -1, 0, 6310, 0, 0);
INSERT INTO `t_title` VALUES (40, , 1, , , , , -1, C0C0C0FF, 000000FF, 5, 4, -1, 0, -1, 0, -1, 0, -1, 0, 6357, 0, 0);
INSERT INTO `t_title` VALUES (41, , 1, , , , , -1, C0C0C0FF, A06CEEFF, 5, 5, 17, 4, -1, 0, -1, 0, -1, 0, 6358, 0, 0);
INSERT INTO `t_title` VALUES (42, , 1, , , , , -1, C0C0C0FF, 000000FF, 20, 5, -1, 0, -1, 0, -1, 0, -1, 0, 6375, 0, 0);
INSERT INTO `t_title` VALUES (43, , 1, , , , , -1, C0C0C0FF, 94E4C7FF, 20, 6, 4, 5, -1, 0, -1, 0, -1, 0, 6376, 0, 0);
INSERT INTO `t_title` VALUES (44, , 1, , , , , -1, C0C0C0FF, 000000FF, 21, 4, -1, 0, -1, 0, -1, 0, -1, 0, 6379, 0, 0);
INSERT INTO `t_title` VALUES (45, , 1, , , , , -1, C0C0C0FF, FFFF00FF, 21, 4, 23, 3, -1, 0, -1, 0, -1, 0, 6380, 0, 0);
INSERT INTO `t_title` VALUES (46, , 1, , , , , -1, C0C0C0FF, 000000FF, 50, 3, -1, 0, -1, 0, -1, 0, -1, 0, 6386, 0, 0);
INSERT INTO `t_title` VALUES (47, , 1, , , , , -1, C0C0C0FF, FF80C0FF, 50, 4, 55, 3, -1, 0, -1, 0, -1, 0, 6387, 0, 0);
INSERT INTO `t_title` VALUES (48, , 1, , , , , -1, C0C0C0FF, 000000FF, 23, 4, 20, 4, -1, 0, -1, 0, -1, 0, 6396, 0, 0);
INSERT INTO `t_title` VALUES (49, , 1, , , , , -1, C0C0C0FF, 98CBE0FF, 23, 5, 20, 6, 64, 1, -1, 0, -1, 0, 6397, 0, 0);
INSERT INTO `t_title` VALUES (50, , 1, , , , , -1, C0C0C0FF, 000000FF, 62, 2, 60, 1, -1, 0, -1, 0, -1, 0, 6404, 0, 0);
INSERT INTO `t_title` VALUES (51, , 1, , , , , -1, C0C0C0FF, FFFFFFFF, 62, 2, 60, 1, 61, 1, 63, 2, -1, 0, 6405, 0, 0);
INSERT INTO `t_title` VALUES (52, , 1, , eff_nameN, , , -1, 000000FF, D20000FF, 24, 4, 52, 5, 58, 4, -1, 0, -1, 0, 6250, 0, 0);
INSERT INTO `t_title` VALUES (53, , 1, , , , , -1, 00000000, 0000FFFF, 66, 3, 55, 3, -1, 0, -1, 0, -1, 0, 4690, 0, 0);
INSERT INTO `t_title` VALUES (54, , 1, , , , , -1, 00000000, FF0080FF, 21, 2, -1, 0, -1, 0, -1, 0, -1, 0, 5963, 0, 0);
INSERT INTO `t_title` VALUES (55, , 1, , , , , -1, 000000FF, 0000FFFF, 23, 3, -1, 0, -1, 0, -1, 0, -1, 0, 5964, 0, 0);
INSERT INTO `t_title` VALUES (58, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 5, 55, 3, -1, 0, -1, 0, -1, 0, 6701, 0, 0);
INSERT INTO `t_title` VALUES (59, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 5, 55, 3, 66, 1, -1, 0, -1, 0, 6702, 0, 0);
INSERT INTO `t_title` VALUES (60, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 3, -1, 0, -1, 0, 6703, 0, 0);
INSERT INTO `t_title` VALUES (61, , 1, , cao_hw_arm_2, , , -1, 262626FF, 49FFFFFF, 55, 6, 55, 6, 66, 5, -1, 0, -1, 0, 6704, 0, 0);
INSERT INTO `t_title` VALUES (62, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 3, 66, 3, 83, 1, 6705, 0, 0);
INSERT INTO `t_title` VALUES (63, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 6, 83, 2, -1, 0, 6706, 0, 0);
INSERT INTO `t_title` VALUES (64, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 5, 66, 5, 83, 3, 6707, 0, 0);
INSERT INTO `t_title` VALUES (65, , 1, , cao_hw_arm_2, , , -1, 0000FFFF, FF0000FF, 55, 6, 55, 6, 66, 6, 66, 3, 83, 4, 6708, 0, 0);
INSERT INTO `t_title` VALUES (66, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 6, 66, 5, 83, 5, 6709, 0, 0);
INSERT INTO `t_title` VALUES (67, , 1, , , , , -1, 262626FF, A6FF55FF, 55, 6, 55, 6, 66, 6, 66, 6, 82, 1, 6710, 0, 0);
INSERT INTO `t_title` VALUES (69, , 1, , pupu_2, , , -1, 262626FF, F5D80AFF, 4, 5, 5, 5, 55, 2, 66, 2, 4, 5, 6888, 0, 0);
INSERT INTO `t_title` VALUES (70, , 1, , , , , -1, 262626FF, FF0080FF, 11, 4, 18, 4, -1, 0, -1, 0, -1, 0, 6930, 0, 0);
INSERT INTO `t_title` VALUES (71, , 1, , , , , -1, 000000FF, DF8B0DFF, 0, 5, 1, 5, 2, 5, 3, 5, -1, 0, 7108, 0, 0);
INSERT INTO `t_title` VALUES (72, , 1, , , , , -1, 262626FF, FF0080FF, 11, 2, 18, 2, 55, 1, 66, 1, -1, 0, 7109, 0, 0);
INSERT INTO `t_title` VALUES (73, , 1, , , , , -1, 262626FF, FF0080FF, 11, 4, 18, 4, 55, 2, 66, 2, -1, 0, 7110, 0, 0);
INSERT INTO `t_title` VALUES (81, , 1, , , , , -1, 808080FF, FFA6D2FF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 6984, 0, 0);
INSERT INTO `t_title` VALUES (83, , 1, , , , , -1, 808080FF, 80FFFFFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 7347, 0, 0);
INSERT INTO `t_title` VALUES (84, , 1, , eff_nameS, , SHK_PADOCS_ATT01, -1, FF004DFF, 00FFFAFF, 64, 2, 21, 5, 21, 5, 73, 4, 59, 4, 7348, 0, 0);
INSERT INTO `t_title` VALUES (85, , 1, , cao_hw_arm_2, , , -1, 000000FF, FF0000FF, 64, 2, 59, 2, -1, 0, -1, 0, -1, 0, 7397, 0, 0);
INSERT INTO `t_title` VALUES (86, , 1, , cao_hw_arm_2, , , -1, 000000FF, FF0000FF, 64, 1, 59, 1, -1, 0, -1, 0, -1, 0, 7396, 0, 0);
INSERT INTO `t_title` VALUES (87, , 1, , cao_hw_arm_2, , , -1, 000000FF, FF0000FF, 4, 5, 59, 1, -1, 0, -1, 0, -1, 0, 7395, 0, 0);
INSERT INTO `t_title` VALUES (88, , 1, , , , , -1, 000040FF, FFFFFFFF, 4, 5, 4, 5, -1, 0, -1, 0, -1, 0, 7394, 0, 0);
INSERT INTO `t_title` VALUES (89, , 1, , , , , -1, 000040FF, FFFFFFFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 7393, 0, 0);
INSERT INTO `t_title` VALUES (90, , 1, , , , , -1, 000040FF, FFFFFFFF, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, 7392, 0, 0);
- Triralith - 11-04-2013
Thanks a lot. Can be closed and moved.
- Paramount - 11-04-2013
Aight :p