Jump to content

Change starting locations


Obikan

Recommended Posts

Hey guys, recently just started my own Private server with a friend. I must say, we have learnt a lot from this project, kudos to all that started it.

I recently installed the repack Grims Ultimate Battlegrounds V6. In this repack, he changed the start locations for every race to be in stormwind and Orgrimmar, as well as putting in npcs which give level 80 items and all skills ect. The reason why i did this was because i couldnt figure out how to setup the MySQL from the installation guide, and grim included one in his pack which was as simple as a double click.

I changed the starting level, gold, and got rid of all those npc's. I was just wondering how i would go about restoring the starting locations and intro cinematics to what they were originally. Would it be a dbc file? or something i need to change in the DB or configs?

I'm using the latest Mangos version (3.3.5a) and heidiSQL to log into the database.

Im new here, so if i put this help request in the wrong thread or whatever, please give me grace :D

Thanks.

Link to comment
Share on other sites

Here you go....

-- Delete Original Starting Locations

DELETE FROM `playercreateinfo` WHERE (`class`='1');

DELETE FROM `playercreateinfo` WHERE (`class`='2');

DELETE FROM `playercreateinfo` WHERE (`class`='3');

DELETE FROM `playercreateinfo` WHERE (`class`='4');

DELETE FROM `playercreateinfo` WHERE (`class`='5');

DELETE FROM `playercreateinfo` WHERE (`class`='7');

DELETE FROM `playercreateinfo` WHERE (`class`='8');

DELETE FROM `playercreateinfo` WHERE (`class`='9');

DELETE FROM `playercreateinfo` WHERE (`class`='11');

-- Add New Starting Locations

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '2', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('1', '9', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('3', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('3', '2', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('3', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('3', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('3', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('7', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('7', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('7', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('7', '9', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('4', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('4', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('4', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('4', '11', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('4', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '2', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '7', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('11', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('2', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('2', '7', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('2', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('2', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('2', '9', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '7', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('8', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('6', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('6', '7', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('6', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('6', '11', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('5', '1', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('5', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('5', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('5', '9', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('5', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '2', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '3', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '4', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '8', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '9', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

INSERT INTO `playercreateinfo` (`race`, `class`, `map`, `zone`, `position_x`, `position_y`, `position_z`) VALUES

('10', '5', '571', '5735.047852', '521.400024', '649.452515', '4.703896');

Link to comment
Share on other sites

What exactly do i do with this?
What you are asking for.
Is this an SQL query?
Yes.
If so will it put all races at their preset starting points, and play the correct race intro?
It does not touch the intro itself, but maybe the intro depends to the starting location. Just give it a try.

As a personal opinion, you should not use a repack just because of problems while getting started. If you are yet not able to compile, install & configure a server by yourself, you are also not able to give support, so you better should work on your sql problem, its not a miracle to run a selfmade mangos server.

Link to comment
Share on other sites

What exactly do i do with this?
What you are asking for.
Is this an SQL query?
Yes.
If so will it put all races at their preset starting points, and play the correct race intro?
It does not touch the intro itself, but maybe the intro depends to the starting location. Just give it a try.

As a personal opinion, you should not use a repack just because of problems while getting started. If you are yet not able to compile, install & configure a server by yourself, you are also not able to give support, so you better should work on your sql problem, its not a miracle to run a selfmade mangos server.

1. I Just need to know where to enter the SQL query, i am new to this, i can provide a screenshot for the setup of my DB if it helps. From what i understand, it is useless if you just input queries anywhere.

2. The repack was what my friend had already started looking at, i have been trying to help him build onto it. The only problem i had personally, was setting up of the MySQL in the installation guide (when trying it myself). It left me thinking "wtf is this all about" as it was not very clear on what needed to be done.

Right now, i just need to know where i need to input the SQL code that Tim gave to me :)

I'm no MySQL genius, but I know it is tricky, if it wasn't i wouldn't be asking for help right now.

I could toy around with it, making backups. But if there's any other relevant advice for using that code, it could save me quite a bit of time.

Link to comment
Share on other sites

Right before i added in tims code for my own play around, i realised the co-ordinates were all the same.... Nice try tim

Edit: frozen sea? You are absolutely hilarious :)

Edit2: just realised you could have done it in order for me to add correct values :E, if so, i am an idiot and do apolagise. Late night, quite annoyed at other things :(

Link to comment
Share on other sites

Managed to fix this, thanks to tim pointing me in the direction of the 'playercreateinfo' thingo in the db.

Ran this SQL query in the mangos database, which i managed to pull out of the mangos.sql file

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;

--

-- Dumping data for table `playercreateinfo`

--

LOCK TABLES `playercreateinfo` WRITE;

/*!40000 ALTER TABLE `playercreateinfo` DISABLE KEYS */;

INSERT INTO `playercreateinfo` VALUES

(1,1,0,12,-8949,-132,84,0),

(1,2,0,12,-8949,-132,84,0),

(1,4,0,12,-8949,-132,84,0),

(1,5,0,12,-8949,-132,84,0),

(1,6,609,4298,2355.84,-5664.77,426.028,3.659973),

(1,8,0,12,-8949,-132,84,0),

(1,9,0,12,-8949,-132,84,0),

(2,1,1,14,-618,-4251,39,0),

(2,3,1,14,-618,-4251,39,0),

(2,4,1,14,-618,-4251,39,0),

(2,6,609,4298,2358.44,-5666.9,426.023,3.659973),

(2,7,1,14,-618,-4251,39,0),

(2,9,1,14,-618,-4251,39,0),

(3,1,0,1,-6240,331,383,6.177156),

(3,2,0,1,-6240,331,383,6.177156),

(3,3,0,1,-6240,331,383,6.177156),

(3,4,0,1,-6240,331,383,6.177156),

(3,5,0,1,-6240,331,383,6.177156),

(3,6,609,4298,2358.44,-5666.9,426.023,3.659973),

(4,1,1,141,10311,832,1327,5.696318),

(4,3,1,141,10311,832,1327,5.696318),

(4,4,1,141,10311,832,1327,5.696318),

(4,5,1,141,10311,832,1327,5.696318),

(4,6,609,4298,2356.21,-5662.21,426.026,3.659973),

(4,11,1,141,10311,832,1327,5.696318),

(5,1,0,85,1676,1677,122,2.70526),

(5,4,0,85,1676,1677,122,2.70526),

(5,5,0,85,1676,1677,122,2.70526),

(5,6,609,4298,2356.21,-5662.21,426.026,3.659973),

(5,8,0,85,1676,1677,122,2.70526),

(5,9,0,85,1676,1677,122,2.70526),

(6,1,1,215,-2917,-257,53,0),

(6,3,1,215,-2917,-257,53,0),

(6,6,609,4298,2358.17,-5663.21,426.027,3.659973),

(6,7,1,215,-2917,-257,53,0),

(6,11,1,215,-2917,-257,53,0),

(7,1,0,1,-6240,331,383,0),

(7,4,0,1,-6240,331,383,0),

(7,6,609,4298,2355.05,-5661.7, 426.026,3.659973),

(7,8,0,1,-6240,331,383,0),

(7,9,0,1,-6240,331,383,0),

(8,1,1,14,-618,-4251,39,0),

(8,3,1,14,-618,-4251,39,0),

(8,4,1,14,-618,-4251,39,0),

(8,5,1,14,-618,-4251,39,0),

(8,6,609,4298,2355.05,-5661.7, 426.026,3.659973),

(8,7,1,14,-618,-4251,39,0),

(8,8,1,14,-618,-4251,39,0),

(10,2,530,3431,10349.6,-6357.29,33.4026,5.316046),

(10,3,530,3431,10349.6,-6357.29,33.4026,5.316046),

(10,4,530,3431,10349.6,-6357.29,33.4026,5.316046),

(10,5,530,3431,10349.6,-6357.29,33.4026,5.316046),

(10,6,609,4298,2355.84,-5664.77,426.028,3.659973),

(10,8,530,3431,10349.6,-6357.29,33.4026,5.316046),

(10,9,530,3431,10349.6,-6357.29,33.4026,5.316046),

(11,1,530,3526,-3961.64,-13931.2,100.615,2.083644),

(11,2,530,3526,-3961.64,-13931.2,100.615,2.083644),

(11,3,530,3526,-3961.64,-13931.2,100.615,2.083644),

(11,5,530,3526,-3961.64,-13931.2,100.615,2.083644),

(11,6,609,4298,2358.17,-5663.21,426.027,3.659973),

(11,7,530,3526,-3961.64,-13931.2,100.615,2.083644),

(11,8,530,3526,-3961.64,-13931.2,100.615,2.083644);

/*!40000 ALTER TABLE `playercreateinfo` ENABLE KEYS */;

UNLOCK TABLES;

Fixed all the spawn issues.

Thanks!

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use