|
СТАРТ В СТАРТОВЫХ СТАЛИЦАХ
|
|
У каво есть патч чтобы все стартовали у себя в столице ! дайте пожалусто с меня +++++
!
Сообщение # 1 написано 17.12.2012 в 11:44
|
вот держи алы старт в шморме, орда - огри
Code Replace `playercreateinfo` VALUES
(1, 1, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 2, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 4, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 5, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 8, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 9, 0, 1519, -8915, 523, 93.9, 2.25013),
(2, 1, 1, 14, 1388, -4368, 27.1, 0.073785),
(2, 3, 1, 14, 1388, -4368, 27.1, 0.073785),
(2, 4, 1, 14, 1388, -4368, 27.1, 0.073785),
(2, 7, 1, 14, 1388, -4368, 27.1, 0.073785),
(2, 9, 1, 14, 1388, -4368, 27.1, 0.073785),
(3, 1, 0, 1519, -8915, 523, 93.9, 2.25013),
(3, 2, 0, 1519, -8915, 523, 93.9, 2.25013),
(3, 3, 0, 1519, -8915, 523, 93.9, 2.25013),
(3, 4, 0, 1519, -8915, 523, 93.9, 2.25013),
(3, 5, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 1, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 3, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 4, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 5, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 11, 0, 1519, -8915, 523, 93.9, 2.25013),
(5, 1, 1, 14, 1388, -4368, 27.1, 0.073785),
(5, 4, 1, 14, 1388, -4368, 27.1, 0.073785),
(5, 5, 1, 14, 1388, -4368, 27.1, 0.073785),
(5, 8, 1, 14, 1388, -4368, 27.1, 0.073785),
(5, 9, 1, 14, 1388, -4368, 27.1, 0.073785),
(6, 1, 1, 14, 1388, -4368, 27.1, 0.073785),
(6, 3, 1, 14, 1388, -4368, 27.1, 0.073785),
(6, 7, 1, 14, 1388, -4368, 27.1, 0.073785),
(6, 11, 1, 14, 1388, -4368, 27.1, 0.073785),
(7, 1, 0, 1519, -8915, 523, 93.9, 2.25013),
(7, 9, 0, 1519, -8915, 523, 93.9, 2.25013),
(7, 8, 0, 1519, -8915, 523, 93.9, 2.25013),
(7, 4, 0, 1519, -8915, 523, 93.9, 2.25013),
(8, 1, 1, 14, 1388, -4368, 27.1, 0.073785),
(8, 3, 1, 14, 1388, -4368, 27.1, 0.073785),
(8, 4, 1, 14, 1388, -4368, 27.1, 0.073785),
(8, 5, 1, 14, 1388, -4368, 27.1, 0.073785),
(8, 7, 1, 14, 1388, -4368, 27.1, 0.073785),
(8, 8, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 2, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 3, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 4, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 5, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 8, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 9, 1, 14, 1388, -4368, 27.1, 0.073785),
(11, 1, 0, 1519, -8915, 523, 93.9, 2.25013),
(11, 2, 0, 1519, -8915, 523, 93.9, 2.25013),
(11, 3, 0, 1519, -8915, 523, 93.9, 2.25013),
(11, 5, 0, 1519, -8915, 523, 93.9, 2.25013),
(11, 7, 0, 1519, -8915, 523, 93.9, 2.25013),
(11, 8, 0, 1519, -8915, 523, 93.9, 2.25013),
(1, 6, 0, 1519, -8915, 523, 93.9, 2.25013),
(2, 6, 1, 14, 1388, -4368, 27.1, 0.073785),
(3, 6, 0, 1519, -8915, 523, 93.9, 2.25013),
(4, 6, 0, 1519, -8915, 523, 93.9, 2.25013),
(5, 6, 1, 14, 1388, -4368, 27.1, 0.073785),
(6, 6, 1, 14, 1388, -4368, 27.1, 0.073785),
(7, 6, 0, 1519, -8915, 523, 93.9, 2.25013),
(8, 6, 1, 14, 1388, -4368, 27.1, 0.073785),
(10, 6, 1, 14, 1388, -4368, 27.1, 0.073785),
(11, 6, 0, 1519, -8915, 523, 93.9, 2.25013);
Сообщение # 2 написано 17.12.2012 в 12:02
|
Не мне нетакой мне как в PVE сервах
Сообщение # 3 написано 17.12.2012 в 13:15
|
Перезалей таблицу playercreateinfo на чистую.
Сообщение # 4 написано 17.12.2012 в 14:54
|
Сообщение # 5 написано 17.12.2012 в 15:11
|
/*
MySQL Data Transfer
Source Host: localhost
Source Database: world
Target Host: localhost
Target Database: world
Date: 17.12.2012 13:33:47
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for 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;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `playercreateinfo` VALUES ('1', '1', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('1', '2', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('1', '4', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('1', '5', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('1', '8', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('1', '9', '0', '12', '-8949.95', '-132.493', '83.5312', '0');
INSERT INTO `playercreateinfo` VALUES ('2', '1', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('2', '3', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('2', '4', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('2', '7', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('2', '9', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('3', '1', '0', '1', '-6240.32', '331.033', '382.758', '6.17716');
INSERT INTO `playercreateinfo` VALUES ('3', '2', '0', '1', '-6240.32', '331.033', '382.758', '6.17716');
INSERT INTO `playercreateinfo` VALUES ('3', '3', '0', '1', '-6240.32', '331.033', '382.758', '6.17716');
INSERT INTO `playercreateinfo` VALUES ('3', '4', '0', '1', '-6240.32', '331.033', '382.758', '6.17716');
INSERT INTO `playercreateinfo` VALUES ('3', '5', '0', '1', '-6240.32', '331.033', '382.758', '6.17716');
INSERT INTO `playercreateinfo` VALUES ('4', '1', '1', '141', '10311.3', '832.463', '1326.41', '5.69632');
INSERT INTO `playercreateinfo` VALUES ('4', '3', '1', '141', '10311.3', '832.463', '1326.41', '5.69632');
INSERT INTO `playercreateinfo` VALUES ('4', '4', '1', '141', '10311.3', '832.463', '1326.41', '5.69632');
INSERT INTO `playercreateinfo` VALUES ('4', '5', '1', '141', '10311.3', '832.463', '1326.41', '5.69632');
INSERT INTO `playercreateinfo` VALUES ('4', '11', '1', '141', '10311.3', '832.463', '1326.41', '5.69632');
INSERT INTO `playercreateinfo` VALUES ('5', '1', '0', '85', '1676.71', '1678.31', '121.67', '2.70526');
INSERT INTO `playercreateinfo` VALUES ('5', '4', '0', '85', '1676.71', '1678.31', '121.67', '2.70526');
INSERT INTO `playercreateinfo` VALUES ('5', '5', '0', '85', '1676.71', '1678.31', '121.67', '2.70526');
INSERT INTO `playercreateinfo` VALUES ('5', '8', '0', '85', '1676.71', '1678.31', '121.67', '2.70526');
INSERT INTO `playercreateinfo` VALUES ('5', '9', '0', '85', '1676.71', '1678.31', '121.67', '2.70526');
INSERT INTO `playercreateinfo` VALUES ('6', '1', '1', '215', '-2917.58', '-257.98', '52.9968', '0');
INSERT INTO `playercreateinfo` VALUES ('6', '3', '1', '215', '-2917.58', '-257.98', '52.9968', '0');
INSERT INTO `playercreateinfo` VALUES ('6', '7', '1', '215', '-2917.58', '-257.98', '52.9968', '0');
INSERT INTO `playercreateinfo` VALUES ('6', '11', '1', '215', '-2917.58', '-257.98', '52.9968', '0');
INSERT INTO `playercreateinfo` VALUES ('7', '1', '0', '1', '-6240.32', '331.033', '382.758', '0');
INSERT INTO `playercreateinfo` VALUES ('7', '9', '0', '1', '-6240', '331', '383', '0');
INSERT INTO `playercreateinfo` VALUES ('7', '8', '0', '1', '-6240', '331', '383', '0');
INSERT INTO `playercreateinfo` VALUES ('7', '4', '0', '1', '-6240', '331', '383', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '1', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '3', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '4', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '5', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '7', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('8', '8', '1', '14', '-618.518', '-4251.67', '38.718', '0');
INSERT INTO `playercreateinfo` VALUES ('10', '2', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('10', '3', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('10', '4', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('10', '5', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('10', '8', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('10', '9', '530', '3431', '10349.6', '-6357.29', '33.4026', '5.31605');
INSERT INTO `playercreateinfo` VALUES ('11', '1', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('11', '2', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('11', '3', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('11', '5', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('11', '7', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('11', '8', '530', '3526', '-3961.64', '-13931.2', '100.615', '2.08364');
INSERT INTO `playercreateinfo` VALUES ('1', '6', '609', '4298', '2355.84', '-5664.77', '426.028', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('2', '6', '609', '4298', '2358.44', '-5666.9', '426.023', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('3', '6', '609', '4298', '2358.44', '-5666.9', '426.023', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('4', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('5', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('6', '6', '609', '4298', '2358.17', '-5663.21', '426.027', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('7', '6', '609', '4298', '2355.05', '-5661.7', '426.026', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('8', '6', '609', '4298', '2355.05', '-5661.7', '426.026', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('10', '6', '609', '4298', '2355.84', '-5664.77', '426.028', '3.65997');
INSERT INTO `playercreateinfo` VALUES ('11', '6', '609', '4298', '2358.17', '-5663.21', '426.027', '3.65997');
Сообщение # 6 отредактировано Dissy - Понедельник, 17.12.2012, 15:27
|
Сообщение # 7 написано 17.12.2012 в 15:50
|
Код update playercreateinfo set position_x='1433.983398' , position_y='-4392.486328' , position_z='26.764771' , map='1' , zone='1637' where race='2';
update playercreateinfo set position_x='1433.983398' , position_y='-4392.486328' , position_z='26.764771' , map='1' , zone='1637' where race='5';
update playercreateinfo set position_x='1433.983398' , position_y='-4392.486328' , position_z='26.764771' , map='1' , zone='1637' where race='6';
update playercreateinfo set position_x='1433.983398' , position_y='-4392.486328' , position_z='26.764771' , map='1' , zone='1637' where race='8';
update playercreateinfo set position_x='1433.983398' , position_y='-4392.486328' , position_z='26.764771' , map='1' , zone='1637' where race='10';
update playercreateinfo set position_x='-8974.603516' , position_y='504.423920' , position_z='98.020515' , map='0' , zone='1519' where race='1';
update playercreateinfo set position_x='-8974.603516' , position_y='504.423920' , position_z='98.020515' , map='0' , zone='1519' where race='3';
update playercreateinfo set position_x='-8974.603516' , position_y='504.423920' , position_z='98.020515' , map='0' , zone='1519' where race='4';
update playercreateinfo set position_x='-8974.603516' , position_y='504.423920' , position_z='98.020515' , map='0' , zone='1519' where race='7';
update playercreateinfo set position_x='-8974.603516' , position_y='504.423920' , position_z='98.020515' , map='0' , zone='1519' where race='11';
 
Сообщение # 8 написано 29.01.2013 в 11:07
|
