[Duvida] Me Ajuda Urgentemente

Erictemponi

XMikaelX

6 participantes

BGames :: Jogos :: World of Warcraft :: WoW | Dúvidas :: Arquivos: Dúvidas Resolvidas

[Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 22:56

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

Re: [Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 23: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

Re: [Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 23: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

Re: [Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 23:14

[Tens de ter uma conta e sessão iniciada para poderes visualizar este link]
aew está

Re: [Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 23:20

E Assim Que Tenho Que Fazer Eric Temponi

[Tens de ter uma conta e sessão iniciada para poderes visualizar esta imagem]

Re: [Duvida] Me Ajuda UrgentementeSáb 25 Ago 2012 - 23:25

Assim mesmo
executar como query

Re: [Duvida] Me Ajuda UrgentementeDom 26 Ago 2012 - 8: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

Re: [Duvida] Me Ajuda UrgentementeDom 26 Ago 2012 - 8: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.

[Tens de ter uma conta e sessão iniciada para poderes visualizar este link]

Re: [Duvida] Me Ajuda UrgentementeDom 26 Ago 2012 - 10: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.

[Tens de ter uma conta e sessão iniciada para poderes visualizar 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.