Erro de sintaxe! [Ajuda]

[jhony_8p]

galera, sou novo por aki.. e trago à v6 um errinho q tenho certeza q é simples.. é um unico erro na parte de cima do codigo::

#1064 - Você tem um erro de sintaxe no seu SQL próximo a 'CREATE TABLE `characters` (

`CharID` int(11) NOT NULL auto_increment,

`Nam' na linha 5

segue o codigo..

agradeço desde já.

--

-- Database: `conquer_server`

--

CREATE DATABASE `conquer_server` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

USE `conquer_server`;

-- --------------------------------------------------------

--

-- Table structure for table `accounts`

--

CREATE TABLE `accounts` (

`AccountID` varchar(16) default NULL,

`Password` varchar(40) default NULL,

`Type` int(11) NOT NULL default '0',

`Auth` int(11) NOT NULL default '1',

`Address` int(11) default NULL,

UNIQUE KEY `AccountID` (`AccountID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `accounts`

--

INSERT INTO `accounts` (`AccountID`, `Password`, `Type`, `Auth`, `Address`) VALUES

('test', '', 0, 2, NULL),

-- --------------------------------------------------------

--

-- Table structure for table `characters`

--

CREATE TABLE `characters` (

`CharID` int(11) NOT NULL auto_increment,

`Name` varchar(16) NOT NULL default '',

`Account` varchar(16) NOT NULL default '',

`Server` varchar(16) NOT NULL default '',

`Spouse` varchar(16) NOT NULL default 'None',

`Guild` int(16) NOT NULL default '0',

`Level` int(11) NOT NULL default '1',

`Exp` int(11) NOT NULL default '0',

`Str` int(11) NOT NULL default '0',

`Dex` int(11) NOT NULL default '0',

`Spi` int(11) NOT NULL default '0',

`Vit` int(11) NOT NULL default '0',

`HP` int(11) NOT NULL default '1',

`MP` int(11) NOT NULL default '0',

`PkPoints` int(11) NOT NULL default '0',

`StatPoints` int(11) NOT NULL default '0',

`Money` int(11) NOT NULL default '0',

`CPoints` int(11) NOT NULL default '0',

`VPoints` int(11) NOT NULL default '0',

`WHMoney` int(11) NOT NULL default '0',

`HairStyle` int(11) NOT NULL default '0',

`Model` int(11) NOT NULL default '0',

`Class` int(11) NOT NULL default '0',

`Map` int(11) NOT NULL default '1010',

`xCord` int(11) NOT NULL default '61',

`yCord` int(11) NOT NULL default '109',

`Status` varchar(10) NOT NULL default '0x00000000',

`GRank` int(11) NOT NULL default '0',

`GDonation` int(11) NOT NULL default '0',

`Reborn` int(11) NOT NULL default '0',

PRIMARY KEY (`CharID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1000027 ;

-- --------------------------------------------------------

--

-- Table structure for table `guilds`

--

CREATE TABLE `guilds` (

`GuildID` int(11) NOT NULL auto_increment,

`Name` varchar(16) NOT NULL default '',

`Wins` int(11) NOT NULL default '0',

`HoldingPole` tinyint(1) NOT NULL default '0',

`Bulletin` varchar(50) NOT NULL default '',

`Enemies` varchar(100) NOT NULL default '',

`Allies` varchar(100) NOT NULL default '',

`Fund` int(11) NOT NULL default '0',

`Members` int(11) NOT NULL default '0',

`Leader` varchar(16) NOT NULL default '',

UNIQUE KEY `GuildID` (`GuildID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--

-- Dumping data for table `guilds`

--

INSERT INTO `guilds` (`GuildID`, `Name`, `Wins`, `HoldingPole`, `Bulletin`, `Enemies`, `Allies`, `Fund`, `Members`, `Leader`) VALUES

(1, 'Guild Name Here!', 0, 0, 'Bulletin Here!', '3', '2', 20000, 0, 'Guild Owner Name Here!'),

-- --------------------------------------------------------

--

-- Table structure for table `items`

--

CREATE TABLE `items` (

`CharID` int(11) NOT NULL default '0',

`ItemUID` int(11) NOT NULL default '0',

`Position` int(2) NOT NULL default '0',

`ItemID` int(11) NOT NULL default '0',

`Plus` int(2) NOT NULL default '0',

`Minus` int(2) NOT NULL default '0',

`Enchant` int(3) NOT NULL default '0',

`Soc1` int(3) NOT NULL default '0',

`Soc2` int(3) NOT NULL default '0',

`Dura` int(5) NOT NULL default '0',

`MaxDura` int(5) NOT NULL default '0',

UNIQUE KEY `ItemUID` (`ItemUID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--

-- Table structure for table `maps`

--

CREATE TABLE `maps` (

`MapID` int(11) NOT NULL default '0',

`PkMode` int(11) NOT NULL default '2',

`FlashMode` int(11) NOT NULL default '1',

UNIQUE KEY `MapID` (`MapID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `maps`

--

INSERT INTO `maps` (`MapID`, `PkMode`, `FlashMode`) VALUES

(1002, 2, 1),

(1038, 2, 4),

(700, 3, 1),

(1000, 1, 1),

(1001, 2, 1),

(1003, 2, 1),

(1004, 1, 1),

(1005, 2, 4),

(1006, 1, 1),

(1007, 1, 1),

(1008, 1, 1),

(1009, 1, 1),

(1010, 3, 1),

(1011, 1, 1),

(1012, 2, 1),

(1013, 2, 1),

(1014, 2, 1),

(1015, 2, 1),

(1016, 2, 1),

(1017, 2, 1),

(1018, 2, 4),

(1019, 2, 4),

(1020, 1, 1),

(1021, 2, 1),

(1022, 2, 1),

(1025, 2, 1),

(1026, 2, 1),

(1027, 2, 1),

(1028, 2, 1),

(1029, 2, 1),

(1030, 2, 1),

(1031, 2, 1),

(1032, 2, 1),

(1035, 1, 1),

(1036, 3, 1),

(1037, 2, 4),

(1039, 2, 1),

(1040, 2, 1),

(1041, 2, 1),

(1042, 2, 1),

(1043, 2, 1),

(1044, 2, 1),

(1045, 2, 1),

(1046, 2, 1),

(1047, 2, 1),

(1048, 2, 1),

(1049, 2, 1),

(1050, 2, 1),

(1051, 2, 1),

(1060, 2, 1),

(1061, 2, 1),

(1062, 2, 1),

(1063, 2, 1),

(1064, 2, 1),

(1070, 2, 1),

(1075, 2, 1),

(1076, 2, 1),

(1077, 2, 1),

(1078, 2, 1),

(1079, 2, 1),

(1080, 2, 4),

(1081, 2, 4),

(1082, 2, 4),

(1090, 2, 4),

(1091, 2, 4),

(1098, 3, 1),

(1099, 3, 1),

(1100, 2, 1),

(1101, 2, 1),

(1102, 2, 1),

(1103, 2, 1),

(1104, 2, 1),

(1105, 2, 1),

(1106, 2, 1),

(1107, 2, 1),

(1108, 2, 1),

(1109, 2, 1),

(1201, 2, 1),

(1202, 2, 1),

(1204, 2, 1),

(1205, 2, 1),

(1207, 2, 1),

(1208, 2, 1),

(1210, 2, 1),

(1211, 2, 1),

(1212, 2, 1),

(1213, 2, 1),

(1214, 2, 1),

(1215, 2, 1),

(1216, 2, 1),

(1351, 2, 1),

(1352, 2, 1),

(1353, 2, 1),

(1354, 2, 1),

(1500, 2, 1),

(1501, 2, 1),

(1502, 2, 1),

(1503, 2, 1),

(1505, 2, 1),

(1506, 2, 1),

(1507, 2, 1),

(1508, 2, 1),

(1509, 2, 1),

(1510, 2, 1),

(1511, 2, 1),

(1512, 2, 1),

(1550, 2, 1),

(1551, 2, 1),

(1560, 2, 1),

(1561, 2, 1),

(1601, 2, 1),

(1615, 2, 1),

(1616, 2, 1),

(1617, 2, 1),

(1645, 2, 1),

(1707, 2, 1),

(1700, 2, 1),

(2021, 2, 1),

(2022, 2, 1),

(2023, 2, 1),

(2024, 2, 1),

(5000, 2, 1),

(6000, 2, 3),

(6001, 3, 1);

-- --------------------------------------------------------

--

-- Table structure for table `npcs`

--

CREATE TABLE `npcs` (

`NpcID` int(11) NOT NULL auto_increment,

`NpcType` int(11) NOT NULL default '0',

`SubType` int(11) NOT NULL default '0',

`MapID` int(11) NOT NULL default '0',

`Xcord` int(11) NOT NULL default '0',

`Ycord` int(11) NOT NULL default '0',

`Direction` int(11) NOT NULL default '0',

`Flag` int(11) NOT NULL default '2',

UNIQUE KEY `NpcID` (`NpcID`),

UNIQUE KEY `NpcType` (`NpcType`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10187 ;

--

-- Dumping data for table `npcs`

--

INSERT INTO `npcs` (`NpcID`, `NpcType`, `SubType`, `MapID`, `Xcord`, `Ycord`, `Direction`, `Flag`) VALUES

(10000, 8, 87, 1002, 409, 351, 1, 2),

(10007, 727, 7270, 1002, 443, 242, 0, 2),

(10005, 4, 46, 1002, 412, 366, 0, 1),

(10004, 1, 10, 1002, 413, 351, 0, 1),

(10008, 724, 7240, 1002, 458, 233, 0, 2),

(10009, 807, 8070, 1002, 400, 284, 0, 2),

(10010, 719, 7190, 1002, 400, 288, 0, 2),

(10011, 725, 7256, 1002, 422, 295, 0, 2),

(10012, 27, 270, 1002, 411, 704, 0, 2),

(10013, 620, 6207, 1002, 337, 720, 0, 2),

(10014, 29, 296, 1002, 60, 463, 0, 2),

(10015, 720, 7200, 1002, 76, 401, 0, 2),

(10016, 28, 286, 1002, 435, 440, 0, 2),

(10017, 2, 26, 1002, 412, 376, 0, 2),

(10018, 812, 8126, 1002, 409, 370, 0, 2),

(10024, 107, 1077, 1002, 409, 386, 0, 2),

(10049, 735, 7351, 1002, 444, 290, 0, 2),

(10022, 423, 2706, 1002, 412, 361, 0, 1),

(10032, 6, 60, 1004, 44, 33, 1004, 2),

(10034, 24, 240, 1002, 421, 352, 0, 6),

(10035, 502, 5020, 1002, 424, 350, 0, 2),

(10036, 5, 50, 1002, 452, 330, 0, 1),

(10037, 25, 250, 1002, 457, 332, 0, 5),

(10038, 3, 30, 1002, 466, 327, 0, 1),

(10039, 182, 1820, 1002, 473, 325, 0, 2),

(10040, 738, 7380, 1002, 480, 351, 0, 2),

(10041, 39, 391, 1002, 512, 351, 0, 2),

(10042, 804, 8040, 1002, 372, 407, 0, 2),

(10043, 262, 2620, 1002, 409, 392, 0, 2),

(10044, 15, 150, 1002, 398, 392, 0, 2),

(10045, 115, 1156, 1002, 350, 337, 0, 2),

(10046, 105, 1056, 1002, 350, 335, 0, 2),

(10047, 715, 7150, 1002, 349, 313, 0, 2),

(10048, 840, 8400, 1002, 423, 320, 0, 2),

(10050, 26, 260, 1002, 459, 291, 0, 2),

(10051, 699, 6990, 1002, 396, 233, 0, 2),

(10052, 652, 6520, 1002, 393, 235, 0, 2),

(10053, 835, 8350, 1002, 365, 92, 0, 2),

(10054, 16, 166, 1004, 33, 65, 0, 0),

(10055, 165, 1656, 1004, 33, 53, 0, 0),

(10056, 12, 120, 1004, 56, 33, 0, 0),

(10057, 845, 8450, 1004, 66, 33, 0, 0),

(10058, 923, 9230, 1036, 212, 188, 0, 2),

(10059, 322, 3220, 1036, 212, 184, 0, 2),

(10061, 432, 1390, 1036, 212, 179, 0, 1),

(10062, 433, 330, 1036, 204, 179, 0, 1),

(10063, 141, 32, 1036, 198, 181, 0, 1),

(10064, 333, 3336, 1036, 178, 182, 0, 2),

(10065, 21, 217, 1036, 182, 180, 0, 2),

(10066, 950, 9500, 1036, 178, 192, 0, 2),

(10067, 501, 5015, 1036, 179, 208, 0, 2),

(10068, 941, 9410, 1036, 189, 212, 0, 2),

(10069, 504, 5044, 1036, 193, 212, 0, 2),

(10070, 41, 417, 1036, 215, 220, 0, 2),

(10071, 319, 3196, 1036, 212, 204, 0, 2),

(10072, 429, 4293, 1036, 242, 242, 0, 2),

(10073, 762, 7624, 1036, 240, 249, 0, 2),

(10074, 143, 1432, 1036, 240, 256, 0, 2),

(10075, 241, 2410, 1036, 252, 242, 0, 2),

(10076, 999, 9994, 1036, 260, 242, 0, 2),

(10077, 669, 6690, 1036, 320, 228, 0, 2),

(10078, 668, 6680, 1036, 320, 224, 0, 2),

(10079, 846, 8460, 1036, 291, 200, 0, 2),

(10080, 106, 1067, 1036, 185, 170, 0, 2),

(10081, 850, 8504, 1036, 179, 198, 0, 2),

(10083, 169, 1690, 1036, 139, 139, 0, 19),

(10084, 621, 6217, 1036, 73, 173, 0, 2),

(10085, 808, 8086, 1036, 141, 107, 0, 2),

(10086, 809, 8090, 1036, 168, 99, 0, 2),

(10087, 811, 8111, 1036, 184, 103, 0, 2),

(10088, 806, 8060, 1036, 199, 87, 0, 2),

(10089, 150, 1600, 1036, 192, 193, 0, 2),

(10090, 721, 7210, 1011, 233, 271, 0, 2),

(10091, 101128, 287, 1011, 228, 255, 0, 2),

(10093, 101120, 200, 1011, 227, 246, 0, 2),

(10094, 35, 350, 1011, 242, 237, 0, 7),

(10095, 631, 6317, 1011, 211, 195, 0, 2),

(10097, 101141, 6410, 1011, 206, 255, 0, 2),

(10098, 10014, 235, 1011, 189, 252, 0, 1),

(10099, 11, 116, 1011, 202, 242, 0, 1),

(10100, 10013, 100, 1011, 197, 226, 0, 1),

(10101, 842, 8420, 1011, 182, 214, 0, 2),

(10102, 36, 360, 1011, 178, 224, 0, 2),

(10103, 132, 1320, 1011, 154, 238, 0, 2),

(10104, 716, 7161, 1011, 178, 271, 0, 2),

(10105, 828, 8280, 1011, 324, 187, 0, 2),

(10106, 718, 7187, 1011, 774, 414, 0, 2),

(10107, 723, 7230, 1011, 779, 467, 0, 2),

(10108, 819, 8190, 1011, 783, 456, 0, 2),

(10109, 600, 6000, 1011, 804, 461, 0, 2),

(10110, 921, 9210, 1011, 810, 458, 0, 2),

(10111, 740, 7400, 1011, 800, 471, 0, 2),

(10112, 117, 1176, 1011, 934, 562, 0, 2),

(10113, 698, 6980, 1011, 907, 546, 0, 2),

(10114, 102020, 200, 1020, 576, 542, 0, 2),

(10115, 10030, 90, 1020, 550, 542, 0, 1),

(10116, 728, 7280, 1020, 543, 544, 0, 2),

(10120, 642, 6420, 1020, 552, 559, 0, 2),

(10121, 922, 9220, 1020, 568, 527, 0, 2),

(10127, 261, 2610, 1010, 61, 105, 0, 2),

(10128, 101023, 236, 1010, 80, 62, 0, 2),

(10129, 101011, 117, 1010, 76, 55, 0, 2),

(10130, 101020, 207, 1010, 72, 50, 0, 2),

(10131, 101010, 106, 1010, 66, 46, 0, 2),

(10132, 101017, 177, 1010, 70, 37, 0, 2),

(10133, 101013, 131, 1010, 74, 37, 0, 2),

(10134, 101018, 180, 1010, 85, 41, 0, 2),

(10135, 101269, 2690, 1010, 96, 42, 0, 2),

(10136, 101219, 190, 1010, 88, 31, 0, 2),

(10137, 629, 6296, 1020, 535, 533, 0, 2),

(10138, 739, 7390, 1020, 546, 509, 0, 2),

(10139, 10029, 220, 1020, 560, 508, 0, 1),

(10140, 737, 7371, 1020, 566, 509, 0, 2),

(10141, 131, 1310, 1020, 532, 480, 0, 2),

(10142, 751, 7510, 1020, 381, 33, 0, 2),

(10143, 216, 2160, 1020, 436, 311, 0, 2),

(10144, 237, 2377, 1020, 369, 309, 0, 2),

(10145, 729, 7297, 1020, 88, 387, 0, 2),

(10146, 102117, 1176, 1020, 523, 889, 0, 2),

(10147, 601, 6010, 1015, 707, 545, 0, 2),

(10148, 625, 6257, 1015, 743, 515, 0, 2),

(10149, 626, 6267, 1015, 697, 595, 0, 2),

(10150, 768, 7680, 1015, 715, 584, 0, 2),

(10151, 643, 6430, 1015, 714, 561, 0, 2),

(10152, 691, 6910, 1015, 761, 588, 0, 2),

(10153, 101528, 280, 1015, 789, 566, 0, 2),

(10154, 37, 370, 1015, 756, 545, 0, 2),

(10155, 10026, 30, 1015, 765, 542, 0, 1),

(10156, 10025, 50, 1015, 751, 544, 0, 1),

(10157, 10023, 10, 1015, 721, 541, 0, 1),

(10158, 201521, 210, 1015, 716, 541, 0, 2),

(10159, 702, 7025, 1015, 678, 966, 0, 2),

(10160, 173, 1730, 1000, 489, 551, 0, 2),

(10161, 603, 6030, 1000, 462, 589, 0, 2),

(10162, 829, 8290, 1000, 486, 618, 0, 2),

(10163, 10, 227, 1000, 486, 621, 0, 1),

(10164, 640, 6400, 1000, 481, 630, 0, 2),

(10165, 100028, 280, 1000, 478, 631, 0, 2),

(10166, 100020, 200, 1000, 471, 629, 0, 2),

(10167, 9, 30, 1000, 511, 631, 0, 1),

(10168, 624, 6247, 1000, 520, 620, 0, 2),

(10169, 731, 7317, 1000, 519, 615, 0, 2),

(10170, 628, 6282, 1000, 66, 354, 0, 2),

(10171, 602, 6026, 1000, 77, 326, 0, 2),

(10172, 732, 7327, 1000, 324, 456, 0, 2),

(10173, 100502, 5027, 1000, 469, 273, 0, 2),

(10174, 623, 6236, 1000, 454, 242, 0, 2),

(10175, 730, 7300, 1000, 479, 261, 0, 2),

(10176, 10015, 227, 1000, 493, 255, 0, 1),

(10177, 10016, 31, 1000, 519, 259, 0, 1),

(10178, 920, 9200, 1001, 674, 340, 0, 2),

(10179, 10018, 220, 1013, 30, 24, 0, 1),

(10180, 10017, 37, 1013, 46, 22, 0, 1),

(10182, 113, 1133, 1038, 354, 345, 0, 2),

(10183, 146, 1467, 1038, 339, 338, 0, 2),

(10184, 145, 1457, 1038, 331, 338, 0, 2),

(10185, 147, 1477, 1038, 348, 329, 0, 2),

(10186, 148, 1487, 1038, 348, 320, 0, 2);

-- --------------------------------------------------------

--

-- Table structure for table `portals`

--

CREATE TABLE `portals` (

`PortalID` int(10) unsigned NOT NULL auto_increment,

`StartX` int(10) unsigned NOT NULL default '0',

`StartY` int(10) unsigned NOT NULL default '0',

`StartMap` int(10) unsigned NOT NULL default '0',

`EndX` int(10) unsigned NOT NULL default '0',

`EndY` int(10) unsigned NOT NULL default '0',

`EndMap` int(10) unsigned NOT NULL default '0',

UNIQUE KEY `PortalID` (`PortalID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--

-- Dumping data for table `portals`

--

INSERT INTO `portals` (`PortalID`, `StartX`, `StartY`, `StartMap`, `EndX`, `EndY`, `EndMap`) VALUES

(1, 401, 387, 1002, 51, 69, 1004),

(2, 51, 73, 1004, 402, 391, 1002),

(3, 382, 387, 1002, 38, 31, 1006),

(4, 41, 31, 1006, 387, 390, 1002),

(5, 963, 557, 1002, 12, 378, 1011),

(6, 5, 376, 1011, 957, 557, 1002),

(7, 555, 964, 1002, 379, 16, 1020),

(8, 376, 8, 1020, 555, 957, 1002),

(9, 44, 394, 1002, 157, 96, 1028),

(10, 156, 90, 1028, 54, 398, 1002),

(11, 223, 196, 1002, 1011, 709, 1015),

(12, 1018, 710, 1015, 231, 196, 1002),

(13, 379, 23, 1011, 54, 81, 1013),

(14, 55, 87, 1013, 379, 28, 1011),

(15, 57, 21, 1013, 80, 39, 1014),

(16, 77, 32, 1014, 60, 27, 1013),

(17, 137, 90, 1014, 50, 84, 1016),

(18, 50, 88, 1016, 132, 88, 1014),

(19, 448, 822, 1011, 921, 559, 1020),

(20, 926, 557, 1020, 455, 823, 1011),

(21, 610, 874, 1020, 363, 13, 1075),

(22, 360, 5, 1075, 608, 868, 1020),

(23, 11, 377, 1020, 530, 528, 1012),

(24, 531, 534, 1012, 19, 380, 1020),

(25, 977, 668, 1000, 68, 467, 1002),

(26, 163, 471, 1000, 755, 871, 1077),

(27, 756, 877, 1077, 162, 466, 1000),

(28, 77, 319, 1000, 314, 644, 1001),

(29, 312, 651, 1001, 85, 319, 1000),

(30, 855, 482, 1011, 9, 361, 1076),

(31, 2, 360, 1076, 849, 483, 1011),

(32, 759, 510, 1015, 534, 693, 1015),

(33, 537, 690, 1015, 759, 513, 1015),

(34, 485, 782, 1015, 570, 853, 1015),

(35, 565, 851, 1015, 649, 837, 1015),

(36, 644, 837, 1015, 531, 593, 1015),

(37, 587, 601, 1015, 583, 675, 1015),

(38, 587, 679, 1015, 742, 843, 1015),

(39, 740, 837, 1015, 722, 926, 1015),

(40, 475, 347, 1015, 344, 206, 1015);

-- --------------------------------------------------------

--

-- Table structure for table `servers`

--

CREATE TABLE `servers` (

`Servername` varchar(16) NOT NULL default '',

`ServerIP` varchar(15) NOT NULL default '',

`ServerPort` int(11) NOT NULL default '0',

UNIQUE KEY `Servername` (`Servername`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `servers`

--

INSERT INTO `servers` (`Servername`, `ServerIP`, `ServerPort`) VALUES

('CoFuture', '127.0.0.1', 9958);

-- --------------------------------------------------------

--

-- Table structure for table `shops`

--

CREATE TABLE `shops` (

`ShopID` smallint(5) unsigned NOT NULL default '0',

`Type` tinyint(3) unsigned NOT NULL default '0',

`Items` text collate latin1_general_ci NOT NULL,

PRIMARY KEY (`ShopID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table `shops`

--

INSERT INTO `shops` (`ShopID`, `Type`, `Items`) VALUES

(3, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060020~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(9, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060021~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(10026, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060024~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(10014, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060023~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(10016, 1, '\n1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(10017, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(10030, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060022~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(5, 1, '\n1050000~1050001~1050002~1050020~410301~410005~410015~410025~410035~410045~410055~410065~410075~410085~410095~410105~410115~410125~410135~410143~410153~410163~140173~500301~500005~500015~500025~500035~500045~500055~500065~500075~500085~500095~500105~500115~500125~500135~500143~500153~500163~500173~421301~421005~421015~421025~421045~421065~421075~421085~421105~421125~421135~421143~421153~421163~421173~420005~420015~420025~420035~420045~420055~420065~420075~420085~420095~420105~420115~420125~420135~420143~420153~420163~420173 '),

(10, 1, '1050000~1050001~1050002~1050020~1050021~1050022~1050030~1050031~1050032~1050033~1050040~1050041~1050042~1050043~560003~500005~560013~560025~560035~560045~560055~560065~560075~560085~560095~560105~560115~560125~560135~560143~560153~560163~560173~421301~430003~430013~430025~430035~430045~430055~430065~430075~430085~430095~430105~430115~430125~130135~430143~430153~430163~430173 '),

(10013, 1, '1050000~1050001~105002~1050020~1050021~1050022~1050023~1050030~1050031~1050032~1050033~1050040~1050041~1050042~1050043~561003~561013~561025~561035~561045~561055~561065~561075~561085~561095~561115~561125~561135~561143~561153~561163~561173~510003~510013~510025~510035~510045~510055~510065~510075~510085~510095~510105~510115~510125~510135~510143~510153~510163~510173 '),

(10015, 1, '1050000~1050001~1050002~1050020~1050021~1050022~1050023~1050030~1050031~1050032~1050033~1050040~1050041~1050042~1050043~580003~580013~580025~580036~580045~580055~580065~580075~580085~580095~580105~580115~580125~580135~580143~580153~580163~580173~530003~530013~530025~530035~530045~530055~530065~530075~530085~530095~530105~530115~530125~530135~530143~530153~530163~530173 '),

(10018, 1, '\n450003~450013~450025~450035~450045~450055~450065~450075~450085~450095~450105~450115~450125~450135~450143~450153~450163~450173~480003~480013~480025~480035~480045~480055~480065~480075~480085~480095~480105~480115~480125~480135~480143~480153~480163~480173~540003~540013~540025~540035~540045~540055~540065~540075~540085~540095~540105~540115~540125~540135~540143~540153~540163~540173 '),

(10025, 1, '1050000~1050001~1050002~1050020~1050021~1050022~1050023~1050030~1050031~1050032~1050033~1050040~1050041~1050042~1050043~440003~440013~440025~440035~440045~440055~440065~440075~440085~440095~440105~440115~440125~440135~440143~440153~440163~440173~481003~481013~481025~481035~481045~481055~481065~481075~481085~481095~481105~481115~481125~481135~481143~481153~481163~481173 '),

(10029, 1, '\n1050000~1050001~1050002~1050020~1050021~1050022~1050023~1050030~1050031~1050032~1050033~1050040~1050041~1050042~1050043490003~490013~490025~490035~490045~490055~490065~490075~490085~490095~490105~490115~490125~490135~490143~490153~490163~490173~460003~460013~460025~460035~460045~460055~460065~460075~460085~460095~460105~460115~460125~460135~460143~460153~460163~460173 '),

(3983, 1, '723461~723462~723463 '),

(433, 2, '182345~181365~181345~182335~181375~182305~182315~181335~191305~181305~181405~181505~181605~181705~181805~181905~181315~181415~181515~181615~181715~181815~181915~181325~181425~181525~181625~181725~181825~181925~181355 '),

(432, 2, '1088000~1088001~700073~723017~723700~721258~723583~723584~1200000~1200001~1200002~2100025~2100045~723701~700012~700002~700032~700062~700052~700022~700042~723087~723724~723725~723727 '),

(3623, 1, '1000000~1000010~1000020~1000030~1001000~1001010~1001020~1002000~1002010~1002020~1060020~1001030~1001040~1002030~1002040~720011~720012~720013~1002050 '),

(423, 1, '\n410301~421301~500301~421003~421013~500003~500013~410003~410013~420003~420013~430003~430013~440003~440013~450003~450013~460003~460013~480003~480013~481003~481013~510003~510013~530003~530013~540003~540013~560003~560013~580003~580013~561003~561013 '),

(4100, 1, '720010~720011~720012~720013~720014~720015~720016~720017~1000000~1000010~1000020~1000030~1001040~1002000~1002010~1002020~1002030~1002040~1002050~1050001 '),

(141, 1, '\n10000000~1000010~720030~720031~720032~725000~725001~725002~725003~7250004~725005~725010~725011~725012~725013~725014~725015~725028~725027~725025~725030~725031~725026~725029~725040~725041~725042~725043~725044 '),

(10023, 1, '\n152015~152045~152065~152085~152105~152125~152143~152163~117305~117315~1175325~117335~117345~117353~117363~117373 '),

(1, 1, '150005~150015~150035~150055~150075~150095~150115~150135~150153~160015~160035~160055~160075~160095~160115~160135~160153~120005~120025~120045~120065~120085~120095~120125~120153~562000~1060030~1060040~1060050~1060060~1060070~1060080~1060090 '),

(11, 1, '111335~111435~111345~111445~111355~111455~111363~111463~111373~111473~113305~113405~113315~113415~113325~113425~113335~113435~113343~113443~900315~900415~900335~900435~900353~900453~900373~900473~114335~114435~114345~114445~114355~114455~114363~114463~114373~114473~118335~118345~118355~118363~118373 '),

(4, 1, '132305~132405~132315~132415~133305~133405~133315~133415~133325~133425~133335~133435~133343~133443~133353~133453~133363~133463~133373~133473~131305~131405~131315~131415~131325~131425~131335~131435~131343~131443~131353~131453~131363~131463~131373~131473~134305~134405~134315~134415~134325~134425~134335~134435~134343~134443~134353~134453~134363~134463~134373~134473~130305~130405~130315~130415~130325~130425~130335~130435~130345~130445~130355~130455~130365~130465~130375~130475 '),

(7569, 2, '135999~138999~139999~136999~420339~480339~112319~112339~112349~112389~561339~580339~117399~152259~160249~410339'),

(20565, 1, '1088001~1088000');

-- --------------------------------------------------------

--

-- Table structure for table `skills`

--

CREATE TABLE `skills` (

`CharID` int(11) NOT NULL default '0',

`SkillID` int(11) NOT NULL default '0',

`SkillLevel` int(11) NOT NULL default '0',

`SkillExp` int(11) NOT NULL default '0'

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

[Denis Courcy]

Oi, jhony_8p!

veja a linha que você escreveu antes da declaração de criação da tabela em questão.

INSERT INTO `accounts` (`AccountID`, `Password`, `Type`, `Auth`, `Address`) VALUES 
('test', '', 0, 2, NULL),

ela está terminando em VIRGULA e não em PONTO E VIRGULA.

att

Denis Courcy

P.S. Evite usar o nome CHARACTERS para nome de tabela esta é uma palavra reservada do MySQL e de repente vai dar xabu.

[jhony_8p]

não era isso caro colega.. continua no mesmo erro..

vse você puder tirar a duvida executando o codigo.. (se é que já não fez)

obrigado

(bem q meu amigo disse q v6 era rapidos.. xD )

Edit:::::::::

perdão, passou para linha 6 agora.

obrigado

opah! é legal quando a gnt descobre nossos erros! xD

já arrumei! muito obrigado cara! vlw mesmo! qlqr coisa eu volto xD

:blink: pelo q entendih agora é a senha do database que está errada.. porem está correta!

username: root

password: o mesmo q coloquei na instalação..

tem como ajudar? ",

Editado Novembro 30, 2007 por jhony_8p