Bgames
Olá visitante! Seja bem vindo ao nosso fórum!

Para você ter total acesso ao nosso fórum é preciso que você se cadastre.

Cadastre-se Aqui!


PARA VER LINKS E IMAGENS É PRECISO SE REGISTRAR!

[Duvida] Me Ajuda Urgentemente

Ver o tópico anterior Ver o tópico seguinte Ir em baixo

[Duvida] Me Ajuda Urgentemente

Mensagem por XMikaelX em Sab 25 Ago 2012 - 21:56

Como Faço Para Coloca Os Hordas Nascerem Em Orgrimmar Eos Allys Em Stormwind Alguem Poderia Me Ajuda

XMikaelX


Mensagens : 226
Pontos : 698

Ver perfil do usuário http://brutalhost.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por Erictemponi em Sab 25 Ago 2012 - 22:08

Aqui está um 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),(1,3,0,0,-8949.95,-132.493,83.5312,0),(1,7,0,12,-8949.95,-132.493,83.5312,0),(1,11,0,12,-8949.95,-132.493,83.5312,0),(2,2,1,14,-618.518,-4251.67,38.718,0),(2,5,1,14,-618.518,-4251.67,38.718,0),(2,8,1,14,-618.518,-4215.67,38.718,0),(2,11,1,14,-618.518,-4215.67,38.718,0),(3,7,0,1,-6240.32,331.033,382.758,6.17716),(3,8,0,1,-6240.32,331.033,382.758,6.17716),(3,9,0,1,-6240.32,331.033,382.758,6.17716),(3,11,0,1,-6240.32,331.033,382.758,6.17716),(4,2,1,141,10311.3,832.463,1326.41,5.69632),(4,7,1,141,10311.3,832.463,1326.41,5.69632),(4,8,1,141,10311.3,832.463,1326.41,5.69632),(4,9,1,141,10311.3,832.463,1326.41,5.69632),(5,2,0,85,1676.71,1678.31,121.67,2.70526),(5,3,0,85,1676.71,1678.31,121.67,2.70526),(5,7,0,85,1676.71,1678.31,121.67,2.70526),(5,11,0,85,1676.71,1678.31,121.67,2.70526),(6,2,1,215,-2917.58,-257.98,52.9968,0),(6,4,1,215,-2917.58,-257.98,52.9968,0),(6,5,1,215,-2917.58,-257.98,52.9968,0),(6,8,1,215,-2917.58,-257.98,52.9968,0),(6,9,1,215,-2917.58,-257.98,52.9968,0),(7,2,0,1,-6240.32,331.033,382.758,0),(7,3,0,1,-6240.32,331.033,382.758,0),(7,5,0,1,-6240,331,383,0),(7,7,0,1,-6240,331,383,0),(7,11,0,1,-6240,331,383,0),(8,2,1,14,-618.518,-4251.67,38.718,0),(8,9,1,14,-618.518,-4251.67,38.718,0),(8,11,1,14,-618.518,-4251.67,38.718,0),(10,1,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,7,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,11,530,3431,10349.6,-6357.29,33.4026,5.31605),(11,4,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,9,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,11,530,3526,-3961.64,-13931.2,100.615,2.08364);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;


Copia esse código, entre no SQLyog, vá na dataBase world, vá em playercreateinfo(somente playercreateinfo)
clique em cima de playercreateinfo com o botao esquerdo do mouse, cole o código na tabela de query, e execute o query
Bom, espero ter ajudado, se ajudei, clica no +. Boa sorte

Erictemponi


Mensagens : 1825
Pontos : 7296
Evolução : 2


Ver perfil do usuário http://www.fury-share.blogspot.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por XMikaelX em Sab 25 Ago 2012 - 22:12

Num Tem Como Vc Coloca Esse Codigo Numa Bloco de nota ou numa pasta chamando .sql depois se eu copiar errado da erro ai to fudido

XMikaelX


Mensagens : 226
Pontos : 698

Ver perfil do usuário http://brutalhost.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por Erictemponi em Sab 25 Ago 2012 - 22:14

[Você precisa estar registrado e conectado para ver este link.]
aew está

Erictemponi


Mensagens : 1825
Pontos : 7296
Evolução : 2


Ver perfil do usuário http://www.fury-share.blogspot.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por XMikaelX em Sab 25 Ago 2012 - 22:20

E Assim Que Tenho Que Fazer Eric Temponi


[Você precisa estar registrado e conectado para ver esta imagem.]

XMikaelX


Mensagens : 226
Pontos : 698

Ver perfil do usuário http://brutalhost.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por Erictemponi em Sab 25 Ago 2012 - 22:25

Assim mesmo
executar como query

Erictemponi


Mensagens : 1825
Pontos : 7296
Evolução : 2


Ver perfil do usuário http://www.fury-share.blogspot.com.br/

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por definitely not Baina em Dom 26 Ago 2012 - 7:44

Olá michelvzx,
Por favor tome mais atenção onde você cria os tópicos, dúvidas devem ser postadas em 'WoW | Dúvidas'. .

Tópico Movido para 'WoW | Dúvidas'

Erictemponi sempre que for a postar algum código use a ferramenta Code, veja como fica o codigo que você postou se usar essa ferramenta:

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),(1,3,0,0,-8949.95,-132.493,83.5312,0),(1,7,0,12,-8949.95,-132.493,83.5312,0),(1,11,0,12,-8949.95,-132.493,83.5312,0),(2,2,1,14,-618.518,-4251.67,38.718,0),(2,5,1,14,-618.518,-4251.67,38.718,0),(2,8,1,14,-618.518,-4215.67,38.718,0),(2,11,1,14,-618.518,-4215.67,38.718,0),(3,7,0,1,-6240.32,331.033,382.758,6.17716),(3,8,0,1,-6240.32,331.033,382.758,6.17716),(3,9,0,1,-6240.32,331.033,382.758,6.17716),(3,11,0,1,-6240.32,331.033,382.758,6.17716),(4,2,1,141,10311.3,832.463,1326.41,5.69632),(4,7,1,141,10311.3,832.463,1326.41,5.69632),(4,8,1,141,10311.3,832.463,1326.41,5.69632),(4,9,1,141,10311.3,832.463,1326.41,5.69632),(5,2,0,85,1676.71,1678.31,121.67,2.70526),(5,3,0,85,1676.71,1678.31,121.67,2.70526),(5,7,0,85,1676.71,1678.31,121.67,2.70526),(5,11,0,85,1676.71,1678.31,121.67,2.70526),(6,2,1,215,-2917.58,-257.98,52.9968,0),(6,4,1,215,-2917.58,-257.98,52.9968,0),(6,5,1,215,-2917.58,-257.98,52.9968,0),(6,8,1,215,-2917.58,-257.98,52.9968,0),(6,9,1,215,-2917.58,-257.98,52.9968,0),(7,2,0,1,-6240.32,331.033,382.758,0),(7,3,0,1,-6240.32,331.033,382.758,0),(7,5,0,1,-6240,331,383,0),(7,7,0,1,-6240,331,383,0),(7,11,0,1,-6240,331,383,0),(8,2,1,14,-618.518,-4251.67,38.718,0),(8,9,1,14,-618.518,-4251.67,38.718,0),(8,11,1,14,-618.518,-4251.67,38.718,0),(10,1,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,7,530,3431,10349.6,-6357.29,33.4026,5.31605),(10,11,530,3431,10349.6,-6357.29,33.4026,5.31605),(11,4,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,9,530,3526,-3961.64,-13931.2,100.615,2.08364),(11,11,530,3526,-3961.64,-13931.2,100.615,2.08364);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;



Cumprimentos,
Baina

definitely not Baina


Mensagens : 917
Pontos : 15124
Evolução : 100


Ver perfil do usuário

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por Aquilla em Dom 26 Ago 2012 - 7:59

bom o eric deu a solução feita eu vo postar o link de um tutorial aonde vc vai aprender a mudar . eu acho muito melhor assim pois vc aprenderá a muda os personagens para nascer em outros locais caso queira.

[Você precisa estar registrado e conectado para ver este link.]

Aquilla


Mensagens : 1305
Pontos : 16155

Ver perfil do usuário http://www.google.com.br

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por DeltaServers em Dom 26 Ago 2012 - 9:16

AquillaSaphyra escreveu:bom o eric deu a solução feita eu vo postar o link de um tutorial aonde vc vai aprender a mudar . eu acho muito melhor assim pois vc aprenderá a muda os personagens para nascer em outros locais caso queira.

[Você precisa estar registrado e conectado para ver este link.]

Seria ótimo pois tem vez que ao colocar esse tipo de código em banco de dados diferente, ele acaba danificando a base do servidor, é mais aconselhável fazer isso manualmente.

DeltaServers


Mensagens : 373
Pontos : 380

Ver perfil do usuário https://www.deltaservers.com.br

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por FireWave em Dom 26 Ago 2012 - 10:11

Resolvido amigo Bgames?

FireWave


Mensagens : 691
Pontos : 1314
Evolução : 4


Ver perfil do usuário http://www.bgames.com.br

Voltar ao Topo Ir em baixo

Re: [Duvida] Me Ajuda Urgentemente

Mensagem por Conteúdo patrocinado Hoje à(s) 10:28


Conteúdo patrocinado


Voltar ao Topo Ir em baixo

Ver o tópico anterior Ver o tópico seguinte Voltar ao Topo


 
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum