Walasac, muito obrigado mesmo cara, tava tentando faze funfa , mais tava dificil, com a sua dica funcionou, me diz como da rep+, sou novo em foruns =)
walasac escreveu:loucalan,
usa o navicat e troca o realmlist la, so assim vc vai entrar no server, instala o navicat e depois abre a db, entao vai na tabela do realmd e vai em realmlist, e troca pelo seu. Se ajudei manda + Rep
Erictemponi escreveu:Olá loucalan
Você está utilizando qual realmlist no seu diretório de WoW?
Use: Set Realmlist 127.0.0.1
Entre no SQLyog/auth/realmlist/andress
Em andress coloque seu IP do No-IP
Se você não conseguir logar é porque suas portas do modem não estão todas liberadas (as necessárias)
Cordialmente, Erictemponi
Erictemponi escreveu:Ué
se vc nao usa nem no ip nem hamach, quer entrar no server de que jeito?:
Código:
/*
SQLyog Community Edition- MySQL GUI v6.5 Beta2
MySQL - 5.5.9 : Database - world
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
create database if not exists `world`;
USE `world`;
/*Table structure for table `playercreateinfo` */
DROP TABLE IF EXISTS `playercreateinfo`;
CREATE TABLE `playercreateinfo` (
`race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`map` smallint(5) unsigned NOT NULL DEFAULT '0',
`zone` mediumint(8) unsigned NOT NULL DEFAULT '0',
`position_x` float NOT NULL DEFAULT '0',
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
PRIMARY KEY (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `playercreateinfo` */
insert into `playercreateinfo`(`race`,`class`,`map`,`zone`,`position_x`,`position_y`,`position_z`,`orientation`) values (1,1,0,12,-8949.95,-132.493,83.5312,0),(1,2,0,12,-8949.95,-132.493,83.5312,0),(1,4,0,12,-8949.95,-132.493,83.5312,0),(1,5,0,12,-8949.95,-132.493,83.5312,0),(1,8,0,12,-8949.95,-132.493,83.5312,0),(1,9,0,12,-8949.95,-132.493,83.5312,0),(2,1,1,14,-618.518,-4251.67,38.718,0),(2,3,1,14,-618.518,-4251.67,38.718,0),(2,4,1,14,-618.518,-4251.67,38.718,0),(2,7,1,14,-618.518,-4251.67,38.718,0),(2,9,1,14,-618.518,-4251.67,38.718,0),(3,1,0,1,-6240.32,331.033,382.758,6.17716),(3,2,0,1,-6240.32,331.033,382.758,6.17716),(3,3,0,1,-6240.32,331.033,382.758,6.17716),(3,4,0,1,-6240.32,331.033,382.758,6.17716),(3,5,0,1,-6240.32,331.033,382.758,6.17716),(4,1,1,141,10311.3,832.463,1326.41,5.69632),(4,3,1,141,10311.3,832.463,1326.41,5.69632),(4,4,1,141,10311.3,832.463,1326.41,5.69632),(4,5,1,141,10311.3,832.463,1326.41,5.69632),(4,11,1,141,10311.3,832.463,1326.41,5.69632),(5,1,0,85,1676.71,1678.31,121.67,2.70526),(5,4,0,85,1676.71,1678.31,121.67,2.70526),(5,5,0,85,1676.71,1678.31,121.67,2.70526),(5,8,0,85,1676.71,1678.31,121.67,2.70526),(5,9,0,85,1676.71,1678.31,121.67,2.70526),(6,1,1,215,-2917.58,-257.98,52.9968,0),(6,3,1,215,-2917.58,-257.98,52.9968,0),(6,7,1,215,-2917.58,-257.98,52.9968,0),(6,11,1,215,-2917.58,-257.98,52.9968,0),(7,1,0,1,-6240.32,331.033,382.758,0),(7,9,0,1,-6240,331,383,0),(7,8,0,1,-6240,331,383,0),(7,4,0,1,-6240,331,383,0),(8,1,1,14,-618.518,-4251.67,38.718,0),(8,3,1,14,-618.518,-4251.67,38.718,0),(8,4,1,14,-618.518,-4251.67,38.718,0),(8,5,1,14,-618.518,-4251.67,38.718,0),(8,7,1,14,-618.518,-4251.67,38.718,0),(8,8,1,14,-618.518,-4251.67,38.718,0),(10,2,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,3,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,4,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,5,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,8,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,9,530,3431,10349.6,-6357.29,33.4026,5.31605),(11,1,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,2,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,3,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,5,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,7,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,8,530,3526,-3961.64,-13931.2,100.615,2.08364),(1,6,609,4298,2355.84,-5664.77,426.028,3.65997),(2,6,609,4298,2358.44,-5666.9,426.023,3.65997),(3,6,609,4298,2358.44,-5666.9,426.023,3.65997),(4,6,609,4298,2356.21,-5662.21,426.026,3.65997),(5,6,609,4298,2356.21,-5662.21,426.026,3.65997),(6,6,609,4298,2358.17,-5663.21,426.027,3.65997),(7,6,609,4298,2355.05,-5661.7,426.026,3.65997),(8,6,609,4298,2355.05,-5661.7,426.026,3.65997),(10,6,609,4298,2355.84,-5664.77,426.028,3.65997),(11,6,609,4298,2358.17,-5663.21,426.027,3.65997);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
Código:
/*
SQLyog Community Edition- MySQL GUI v6.5 Beta2
MySQL - 5.5.9 : Database - world
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
create database if not exists `world`;
USE `world`;
/*Table structure for table `playercreateinfo` */
DROP TABLE IF EXISTS `playercreateinfo`;
CREATE TABLE `playercreateinfo` (
`race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`class` tinyint(3) unsigned NOT NULL DEFAULT '0',
`map` smallint(5) unsigned NOT NULL DEFAULT '0',
`zone` mediumint(8) unsigned NOT NULL DEFAULT '0',
`position_x` float NOT NULL DEFAULT '0',
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
PRIMARY KEY (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `playercreateinfo` */
insert into `playercreateinfo`(`race`,`class`,`map`,`zone`,`position_x`,`position_y`,`position_z`,`orientation`) values (1,1,0,1519,-8952.6,566.102,93.7933,0),(1,2,0,1519,-8952.6,566.102,93.7933,0),(1,4,0,1519,-8952.6,566.102,93.7933,0),(1,5,0,1519,-8952.6,566.102,93.7933,0),(1,8,0,1519,-8952.6,566.102,93.7933,0),(1,9,0,1519,-8952.6,566.102,93.7933,0),(2,1,1,1637,1434.25,-4398.33,25.4628,0),(2,3,1,1637,1434.25,-4398.33,25.4628,0),(2,4,1,1637,1434.25,-4398.33,25.4628,0),(2,7,1,1637,1434.25,-4398.33,25.4628,0),(2,9,1,1637,1434.25,-4398.33,25.4628,0),(3,1,0,1519,-8952.6,566.102,93.7933,0),(3,2,0,1519,-8952.6,566.102,93.7933,0),(3,3,0,1519,-8952.6,566.102,93.7933,0),(3,4,0,1519,-8952.6,566.102,93.7933,0),(3,5,0,1519,-8952.6,566.102,93.7933,0),(4,1,0,1519,-8952.6,566.102,93.7933,0),(4,3,0,1519,-8952.6,566.102,93.7933,0),(4,4,0,1519,-8952.6,566.102,93.7933,0),(4,5,0,1519,-8952.6,566.102,93.7933,0),(4,11,0,1519,-8952.6,566.102,93.7933,0),(5,1,1,1637,1434.25,-4398.33,25.4628,0),(5,4,1,1637,1434.25,-4398.33,25.4628,0),(5,5,1,1637,1434.25,-4398.33,25.4628,0),(5,8,1,1637,1434.25,-4398.33,25.4628,0),(5,9,1,1637,1434.25,-4398.33,25.4628,0),(6,1,1,1637,1434.25,-4398.33,25.4628,0),(6,3,1,1637,1434.25,-4398.33,25.4628,0),(6,7,1,1637,1434.25,-4398.33,25.4628,0),(6,11,1,1637,1434.25,-4398.33,25.4628,0),(7,1,0,1519,-8952.6,566.102,93.7933,0),(7,9,0,1519,-8952.6,566.102,93.7933,0),(7,8,0,1519,-8952.6,566.102,93.7933,0),(7,4,0,1519,-8952.6,566.102,93.7933,0),(8,1,1,1637,1434.25,-4398.33,25.4628,0),(8,3,1,1637,1434.25,-4398.33,25.4628,0),(8,4,1,1637,1434.25,-4398.33,25.4628,0),(8,5,1,1637,1434.25,-4398.33,25.4628,0),(8,7,1,1637,1434.25,-4398.33,25.4628,0),(8,8,1,1637,1434.25,-4398.33,25.4628,0),(10,2,1,1637,1434.25,-4398.33,25.4628,0),(10,3,1,1637,1434.25,-4398.33,25.4628,0),(10,4,1,1637,1434.25,-4398.33,25.4628,0),(10,5,1,1637,1434.25,-4398.33,25.4628,0),(10,8,1,1637,1434.25,-4398.33,25.4628,0),(10,9,1,1637,1434.25,-4398.33,25.4628,0),(11,1,0,1519,-8952.6,566.102,93.7933,0),(11,2,0,1519,-8952.6,566.102,93.7933,0),(11,3,0,1519,-8952.6,566.102,93.7933,0),(11,5,0,1519,-8952.6,566.102,93.7933,0),(11,7,0,1519,-8952.6,566.102,93.7933,0),(11,8,0,1519,-8952.6,566.102,93.7933,0),(1,6,0,1519,-8952.6,566.102,93.7933,0),(2,6,1,1637,1434.25,-4398.33,25.4628,0),(3,6,0,1519,-8952.6,566.102,93.7933,0),(4,6,0,1519,-8952.6,566.102,93.7933,0),(5,6,1,1637,1434.25,-4398.33,25.4628,0),(6,6,1,1637,1434.25,-4398.33,25.4628,0),(7,6,0,1519,-8952.6,566.102,93.7933,0),(8,6,1,1637,1434.25,-4398.33,25.4628,0),(10,6,1,1637,1434.25,-4398.33,25.4628,0),(11,6,0,1519,-8952.6,566.102,93.7933,0);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;