[Release] client+server Pokemon Green [pokenet based] + Src

Destine121 said:

Buenas a la hora de logearme en el server no me deja entrar y eso que se registra bien en la base de datos del sql :S

Click to expand...

[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 TransferSource Server : ragnarokSource S' at line 1[Err] /*Navicat MySQL Data TransferSource Server : ragnarokSource Server Version : 50140Source Host : localhost:3306Source Database : pokemonTarget Server Type : MYSQLTarget Server Version : 50140File Encoding : 65001Date: 2015-01-17 20:56:24*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for `pn_bag`-- ----------------------------DROP TABLE IF EXISTS `pn_bag`;CREATE TABLE `pn_bag` ( `member` int(11) NOT NULL, `item` int(11) NOT NULL, `quantity` int(11) NOT NULL, PRIMARY KEY (`member`,`item`)) ENGINE=InnoDB DEFAULT CHARSET=ascii;-- ------------------------------ Records of pn_bag-- ----------------------------INSERT INTO `pn_bag` VALUES ('7', '35', '5');INSERT INTO `pn_bag` VALUES ('8', '35', '5');INSERT INTO `pn_bag` VALUES ('9', '35', '5');INSERT INTO `pn_bag` VALUES ('10', '35', '5');INSERT INTO `pn_bag` VALUES ('10', '206', '1');INSERT INTO `pn_bag` VALUES ('11', '1', '6');INSERT INTO `pn_bag` VALUES ('11', '35', '2');INSERT INTO `pn_bag` VALUES ('11', '202', '1');INSERT INTO `pn_bag` VALUES ('11', '206', '4');INSERT INTO `pn_bag` VALUES ('12', '35', '28');INSERT INTO `pn_bag` VALUES ('12', '97', '2');INSERT INTO `pn_bag` VALUES ('12', '168', '3');INSERT INTO `pn_bag` VALUES ('12', '606', '1');INSERT INTO `pn_bag` VALUES ('13', '35', '23');INSERT INTO `pn_bag` VALUES ('13', '200', '1');INSERT INTO `pn_bag` VALUES ('13', '202', '8');INSERT INTO `pn_bag` VALUES ('13', '206', '24');INSERT INTO `pn_bag` VALUES ('13', '207', '5');INSERT INTO `pn_bag` VALUES ('14', '1', '10');INSERT INTO `pn_bag` VALUES ('14', '2', '3');INSERT INTO `pn_bag` VALUES ('14', '35', '2');INSERT INTO `pn_bag` VALUES ('14', '36', '6');INSERT INTO `pn_bag` VALUES ('14', '85', '26');INSERT INTO `pn_bag` VALUES ('14', '91', '18');INSERT INTO `pn_bag` VALUES ('14', '200', '2');INSERT INTO `pn_bag` VALUES ('14', '202', '6');INSERT INTO `pn_bag` VALUES ('14', '203', '2');INSERT INTO `pn_bag` VALUES ('14', '206', '59');INSERT INTO `pn_bag` VALUES ('14', '207', '24');INSERT INTO `pn_bag` VALUES ('14', '209', '4');INSERT INTO `pn_bag` VALUES ('14', '353', '1');INSERT INTO `pn_bag` VALUES ('14', '483', '1');INSERT INTO `pn_bag` VALUES ('14', '603', '1');INSERT INTO `pn_bag` VALUES ('15', '35', '5');INSERT INTO `pn_bag` VALUES ('16', '2', '4');INSERT INTO `pn_bag` VALUES ('16', '36', '14');INSERT INTO `pn_bag` VALUES ('16', '168', '1');INSERT INTO `pn_bag` VALUES ('16', '200', '1');INSERT INTO `pn_bag` VALUES ('16', '206', '30');INSERT INTO `pn_bag` VALUES ('16', '610', '1');INSERT INTO `pn_bag` VALUES ('17', '2', '4');INSERT INTO `pn_bag` VALUES ('17', '35', '5');INSERT INTO `pn_bag` VALUES ('17', '36', '5');INSERT INTO `pn_bag` VALUES ('17', '85', '10');INSERT INTO `pn_bag` VALUES ('17', '200', '1');INSERT INTO `pn_bag` VALUES ('17', '206', '16');INSERT INTO `pn_bag` VALUES ('18', '1', '2');INSERT INTO `pn_bag` VALUES ('18', '35', '5');INSERT INTO `pn_bag` VALUES ('18', '36', '14');INSERT INTO `pn_bag` VALUES ('18', '202', '1');INSERT INTO `pn_bag` VALUES ('18', '206', '12');INSERT INTO `pn_bag` VALUES ('18', '207', '9');INSERT INTO `pn_bag` VALUES ('19', '35', '5');INSERT INTO `pn_bag` VALUES ('20', '35', '5');INSERT INTO `pn_bag` VALUES ('20', '200', '5');INSERT INTO `pn_bag` VALUES ('20', '201', '1');INSERT INTO `pn_bag` VALUES ('20', '204', '1');INSERT INTO `pn_bag` VALUES ('20', '206', '10');-- ------------------------------ Table structure for `pn_bans`-- ----------------------------DROP TABLE IF EXISTS `pn_bans`;CREATE TABLE `pn_bans` ( `playername` varchar(12) NOT NULL, `ip` varchar(16) NOT NULL, PRIMARY KEY (`playername`,`ip`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- ------------------------------ Records of pn_bans-- ----------------------------INSERT INTO `pn_bans` VALUES ('esmeralda', '186.130.37.87');-- ------------------------------ Table structure for `pn_box`-[Err] 1146 - Table 'pokemon.pn_party' doesn't exist[Err] INSERT INTO `pn_party` VALUES ('17', '17', '30', '49', '50', '-1', '-1', '-1');INSERT INTO `pn_party` VALUES ('18', '18', '43', '35', '-1', '-1', '-1', '-1');INSERT INTO `pn_party` VALUES ('19', '19', '36', '-1', '-1', '-1', '-1', '-1');INSERT INTO `pn_party` VALUES ('20', '20', '51', '-1', '-1', '-1', '-1', '-1');-- ------------------------------ Table structure for `pn_pokedex`-- ----------------------------DROP TABLE IF EXISTS `pn_pokedex`;CREATE TABLE `pn_pokedex` ( `pokedexId` int(11) NOT NULL AUTO_INCREMENT, `memberId` int(11) NOT NULL, `1` tinyint(4) NOT NULL, `2` tinyint(4) NOT NULL, `3` tinyint(4) NOT NULL, `4` tinyint(4) NOT NULL, `5` tinyint(4) NOT NULL, `6` tinyint(4) NOT NULL, `7` tinyint(4) NOT NULL, `8` tinyint(4) NOT NULL, `9` tinyint(4) NOT NULL, `10` tinyint(4) NOT NULL, `11` tinyint(4) NOT NULL, `12` tinyint(4) NOT NULL, `13` tinyint(4) NOT NULL, `14` tinyint(4) NOT NULL, `15` tinyint(4) NOT NULL, `16` tinyint(4) NOT NULL, `17` tinyint(4) NOT NULL, `18` tinyint(4) NOT NULL, `19` tinyint(4) NOT NULL, `20` tinyint(4) NOT NULL, `21` tinyint(4) NOT NULL, `22` tinyint(4) NOT NULL, `23` tinyint(4) NOT NULL, `24` tinyint(4) NOT NULL, `25` tinyint(4) NOT NULL, `26` tinyint(4) NOT NULL, `27` tinyint(4) NOT NULL, `28` tinyint(4) NOT NULL, `29` tinyint(4) NOT NULL, `30` tinyint(4) NOT NULL, `31` tinyint(4) NOT NULL, `32` tinyint(4) NOT NULL, `33` tinyint(4) NOT NULL, `34` tinyint(4) NOT NULL, `35` tinyint(4) NOT NULL, `36` tinyint(4) NOT NULL, `37` tinyint(4) NOT NULL, `38` tinyint(4) NOT NULL, `39` tinyint(4) NOT NULL, `40` tinyint(4) NOT NULL, `41` tinyint(4) NOT NULL, `42` tinyint(4) NOT NULL, `43` tinyint(4) NOT NULL, `44` tinyint(4) NOT NULL, `45` tinyint(4) NOT NULL, `46` tinyint(4) NOT NULL, `47` tinyint(4) NOT NULL, `48` tinyint(4) NOT NULL, `49` tinyint(4) NOT NULL, `50` tinyint(4) NOT NULL, `51` tinyint(4) NOT NULL, `52` tinyint(4) NOT NULL, `53` tinyint(4) NOT NULL, `54` tinyint(4) NOT NULL, `55` tinyint(4) NOT NULL, `56` tinyint(4) NOT NULL, `57` tinyint(4) NOT NULL, `58` tinyint(4) NOT NULL, `59` tinyint(4) NOT NULL, `60` tinyint(4) NOT NULL, `61` tinyint(4) NOT NULL, `62` tinyint(4) NOT NULL, `63` tinyint(4) NOT NULL, `64` tinyint(4) NOT NULL, `65` tinyint(4) NOT NULL, `66` tinyint(4) NOT NULL, `67` tinyint(4) NOT NULL, `68` tinyint(4) NOT NULL, `69` tinyint(4) NOT NULL, `70` tinyint(4) NOT NULL, `71` tinyint(4) NOT NULL, `72` tinyint(4) NOT NULL, `73` tinyint(4) NOT NULL, `74` tinyint(4) NOT NULL, `75` tinyint(4) NOT NULL, `76` tinyint(4) NOT NULL, `77` tinyint(4) NOT NULL, `78` tinyint(4) NOT NULL, `79` tinyint(4) NOT NULL, `80` tinyint(4) NOT NULL, `81` tinyint(4) NOT NULL, `82` tinyint(4) NOT NULL, `83` tinyint(4) NOT NULL, `84` tinyint(4) NOT NULL, `85` tinyint(4) NOT NULL, `86` tinyint(4) NOT NULL, `87` tinyint(4) NOT NULL, `88` tinyint(4) NOT NULL, `89` tinyint(4) NOT NULL, `90` tinyint(4) NOT NULL, `91` tinyint(4) NOT NULL, `92` tinyint(4) NOT NULL, `93` tinyint(4) NOT NULL, `94` tinyint(4) NOT NULL, `95` tinyint(4) NOT NULL, `96` tinyint(4) NOT NULL, `97` tinyint(4) NOT NULL, `98` tinyint(4) NOT NULL, `99` tinyint(4) NOT NULL, `100` tinyint(4) NOT NULL, `101` tinyint(4) NOT NULL, `102` tinyint(4) NOT NULL, `103` tinyint(4) NOT NULL, `104` tinyint(4) NOT NULL, `105` tinyint(4) NOT NULL, `106` tinyint(4) NOT NULL, `107` tinyint(4) NOT NULL, `108` tinyint(4) NOT NULL, `109` tinyint(4) NOT NULL, `110` tinyint(4) NOT NULL, `111` tinyint(4) NOT NULL, `112` tinyint(4) NOT NULL, `113` tinyint(4) NOT NULL, `114` tinyint(4) NOT NULL, `115` tinyint(4) NOT NULL, `116` tinyint(4) NOT NULL, `117` tinyint(4) NOT NULL, `118` tinyint(4) NOT NULL, `119` tinyint(4) NOT NULL, `120` tinyint(4) NOT NULL, `121` tinyint(4) NOT N[Msg] Finished - Unsuccessfully--------------------------------------------------

Click to expand...

chaidragon said:

Help Me

You must be registered to see links

Help Me

Click to expand...

Tsumiko said:

Can we skip the web part? and if so how can we make it work without?

Click to expand...

Lucila said:

well, you can use the private server form

Click to expand...

INFO: Maps loadedINFO: Npc sleep timer startedINFO: Movement Service startedINFO: Server started on port 7002INFO: Network Service started.INFO: Time Service startedINFO: Service Manager startup completed.ERROR: Cannot reach time server, reverting to local time

Click to expand...