How to change where players starting point

Robroymac · #1 12-21-2008, 05:13 AM

I am using a repack server that starts all characters on Gm Island, can this be changed back to default
settings (ie. each class starts at the original starting point)? It is Theo's fun server repack.

THANK YOU

Rob Roy Mac :smile:

Morphex · #2 12-22-2008, 07:16 AM

yes its possible, but it will take you a long time to fix so i suggest you use another repack.

Morphex · #3 12-25-2008, 01:03 PM

I will post a sql file that you have to run into our db.

Morphex · #4 12-25-2008, 01:13 PM

Before you execute this into your db, i suggest you take a back-up of it. Just in case

Code:

/*
MySQL Data Transfer
Source Host: localhost
Source Database: arcemu_world
Target Host: localhost
Target Database: arcemu_world
Date: 25.12.2008 13:09:48
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo
-- ----------------------------
DROP TABLE IF EXISTS `playercreateinfo`;
CREATE TABLE `playercreateinfo` (
  `Index` tinyint(3) unsigned NOT NULL auto_increment,
  `race` tinyint(3) unsigned NOT NULL default '0',
  `factiontemplate` int(10) unsigned NOT NULL default '0',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `mapID` int(10) unsigned NOT NULL default '0',
  `zoneID` int(10) unsigned NOT NULL default '0',
  `positionX` float NOT NULL default '0',
  `positionY` float NOT NULL default '0',
  `positionZ` float NOT NULL default '0',
  `displayID` smallint(5) unsigned NOT NULL default '0',
  `BaseStrength` tinyint(3) unsigned NOT NULL default '0',
  `BaseAgility` tinyint(3) unsigned NOT NULL default '0',
  `BaseStamina` tinyint(3) unsigned NOT NULL default '0',
  `BaseIntellect` tinyint(3) unsigned NOT NULL default '0',
  `BaseSpirit` tinyint(3) unsigned NOT NULL default '0',
  `BaseHealth` int(10) unsigned NOT NULL default '0',
  `BaseMana` int(10) unsigned NOT NULL default '0',
  `BaseRage` int(10) unsigned NOT NULL default '0',
  `BaseFocus` int(10) unsigned NOT NULL default '0',
  `BaseEnergy` int(10) unsigned NOT NULL default '0',
  `attackpower` int(10) unsigned NOT NULL default '0',
  `mindmg` float NOT NULL default '0',
  `maxdmg` float NOT NULL default '0',
  `introid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Index`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=latin1 COMMENT='Player System';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `playercreateinfo` VALUES ('1', '1', '1', '1', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '23', '20', '22', '20', '20', '60', '0', '1000', '0', '0', '29', '5', '6', '81');
INSERT INTO `playercreateinfo` VALUES ('2', '2', '2', '1', '1', '14', '-618.518', '-4251.67', '38.718', '51', '26', '17', '24', '17', '23', '80', '0', '1000', '0', '0', '35', '6', '7', '21');
INSERT INTO `playercreateinfo` VALUES ('3', '3', '3', '1', '0', '1', '-6240.32', '331.033', '382.758', '53', '25', '16', '25', '19', '19', '90', '0', '1000', '0', '0', '33', '5', '6', '41');
INSERT INTO `playercreateinfo` VALUES ('4', '4', '4', '1', '1', '141', '10311.3', '832.463', '1326.41', '55', '20', '25', '21', '20', '20', '50', '0', '1000', '0', '0', '23', '4', '5', '61');
INSERT INTO `playercreateinfo` VALUES ('5', '5', '5', '1', '0', '85', '1676.35', '1677.45', '121.67', '57', '22', '18', '23', '18', '25', '70', '0', '1000', '0', '0', '27', '4', '5', '2');
INSERT INTO `playercreateinfo` VALUES ('6', '6', '6', '1', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '28', '15', '24', '15', '22', '80', '0', '1000', '0', '0', '39', '6', '7', '141');
INSERT INTO `playercreateinfo` VALUES ('7', '7', '115', '1', '0', '1', '-6237.02', '329.659', '382.703', '1563', '18', '23', '21', '23', '20', '50', '0', '1000', '0', '0', '19', '3', '4', '101');
INSERT INTO `playercreateinfo` VALUES ('8', '8', '116', '1', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '24', '22', '23', '16', '21', '70', '0', '1000', '0', '0', '31', '5', '6', '121');
INSERT INTO `playercreateinfo` VALUES ('9', '1', '1', '2', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '22', '20', '22', '20', '21', '58', '80', '0', '0', '0', '27', '4', '5', '81');
INSERT INTO `playercreateinfo` VALUES ('10', '3', '3', '2', '0', '1', '-6240.32', '331.033', '382.758', '53', '24', '16', '25', '19', '20', '88', '79', '0', '0', '0', '31', '5', '6', '41');
INSERT INTO `playercreateinfo` VALUES ('11', '2', '2', '3', '1', '14', '-618.518', '-4251.67', '38.718', '51', '23', '20', '23', '17', '24', '76', '82', '0', '0', '0', '25', '4', '5', '21');
INSERT INTO `playercreateinfo` VALUES ('12', '3', '3', '3', '0', '1', '-6240.32', '331.033', '382.758', '53', '22', '19', '24', '19', '20', '86', '84', '0', '0', '0', '23', '4', '5', '41');
INSERT INTO `playercreateinfo` VALUES ('15', '4', '4', '3', '1', '141', '10311.3', '832.463', '1326.41', '55', '17', '28', '20', '20', '21', '46', '85', '0', '0', '0', '27', '4', '5', '61');
INSERT INTO `playercreateinfo` VALUES ('16', '6', '6', '3', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '25', '18', '23', '15', '23', '76', '80', '0', '0', '0', '25', '4', '5', '141');
INSERT INTO `playercreateinfo` VALUES ('17', '8', '116', '3', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '25', '22', '16', '22', '66', '81', '0', '0', '0', '28', '5', '6', '121');
INSERT INTO `playercreateinfo` VALUES ('18', '1', '1', '4', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '21', '23', '21', '20', '20', '55', '0', '0', '0', '100', '26', '4', '5', '81');
INSERT INTO `playercreateinfo` VALUES ('19', '2', '2', '4', '1', '14', '-618.518', '-4251.67', '38.718', '51', '24', '20', '23', '17', '23', '75', '0', '0', '0', '100', '26', '4', '5', '21');
INSERT INTO `playercreateinfo` VALUES ('20', '3', '3', '4', '0', '1', '-6240.32', '331.033', '382.758', '53', '23', '19', '24', '19', '19', '85', '0', '0', '0', '100', '24', '4', '5', '41');
INSERT INTO `playercreateinfo` VALUES ('21', '4', '4', '4', '1', '141', '10311.3', '832.463', '1326.41', '55', '18', '28', '20', '20', '20', '45', '0', '0', '0', '100', '28', '5', '6', '61');
INSERT INTO `playercreateinfo` VALUES ('22', '5', '5', '4', '0', '85', '1676.35', '1677.45', '121.67', '57', '20', '21', '22', '18', '25', '65', '0', '0', '0', '100', '23', '4', '5', '2');
INSERT INTO `playercreateinfo` VALUES ('23', '7', '115', '4', '0', '1', '-6237.02', '329.659', '382.703', '1563', '16', '26', '20', '23', '20', '45', '0', '0', '0', '100', '24', '4', '5', '101');
INSERT INTO `playercreateinfo` VALUES ('24', '8', '116', '4', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '22', '25', '22', '16', '21', '65', '0', '0', '0', '100', '29', '5', '6', '121');
INSERT INTO `playercreateinfo` VALUES ('25', '1', '1', '5', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '20', '22', '23', '52', '160', '0', '0', '0', '10', '2', '3', '81');
INSERT INTO `playercreateinfo` VALUES ('26', '3', '3', '5', '0', '1', '-6240.32', '331.033', '382.758', '53', '22', '16', '23', '21', '22', '82', '145', '0', '0', '0', '12', '2', '3', '41');
INSERT INTO `playercreateinfo` VALUES ('27', '4', '4', '5', '1', '141', '10311.3', '832.463', '1326.41', '55', '17', '25', '19', '22', '23', '51', '160', '0', '0', '0', '7', '2', '2', '61');
INSERT INTO `playercreateinfo` VALUES ('28', '5', '5', '5', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '21', '20', '28', '62', '130', '0', '0', '0', '9', '2', '3', '2');
INSERT INTO `playercreateinfo` VALUES ('29', '8', '116', '5', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '22', '21', '18', '24', '62', '128', '0', '0', '0', '11', '2', '3', '121');
INSERT INTO `playercreateinfo` VALUES ('30', '2', '2', '7', '1', '14', '-618.518', '-4251.67', '38.718', '51', '24', '17', '23', '18', '25', '77', '73', '0', '0', '0', '30', '5', '6', '21');
INSERT INTO `playercreateinfo` VALUES ('31', '6', '6', '7', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '26', '15', '23', '16', '24', '77', '71', '0', '0', '0', '34', '5', '6', '141');
INSERT INTO `playercreateinfo` VALUES ('32', '8', '116', '7', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '22', '22', '22', '17', '23', '67', '72', '0', '0', '0', '26', '4', '5', '121');
INSERT INTO `playercreateinfo` VALUES ('34', '1', '1', '8', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '20', '23', '22', '52', '165', '0', '0', '0', '10', '2', '3', '81');
INSERT INTO `playercreateinfo` VALUES ('35', '5', '5', '8', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '21', '21', '27', '62', '135', '0', '0', '0', '9', '2', '3', '2');
INSERT INTO `playercreateinfo` VALUES ('36', '7', '115', '8', '0', '1', '-6237.02', '329.659', '382.703', '1563', '15', '23', '19', '26', '22', '51', '210', '0', '0', '0', '5', '1', '2', '101');
INSERT INTO `playercreateinfo` VALUES ('37', '8', '116', '8', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '22', '21', '19', '23', '62', '119', '0', '0', '0', '11', '2', '3', '121');
INSERT INTO `playercreateinfo` VALUES ('38', '1', '1', '9', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '21', '22', '22', '53', '140', '0', '0', '0', '10', '2', '3', '81');
INSERT INTO `playercreateinfo` VALUES ('39', '2', '2', '9', '1', '14', '-618.518', '-4251.67', '38.718', '51', '23', '17', '23', '19', '25', '73', '109', '0', '0', '0', '13', '2', '3', '21');
INSERT INTO `playercreateinfo` VALUES ('40', '5', '5', '9', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '22', '20', '27', '63', '110', '0', '0', '0', '9', '2', '3', '2');
INSERT INTO `playercreateinfo` VALUES ('41', '7', '115', '9', '0', '1', '-6237.02', '329.659', '382.703', '1563', '15', '23', '20', '25', '22', '43', '185', '0', '0', '0', '5', '1', '2', '101');
INSERT INTO `playercreateinfo` VALUES ('42', '4', '4', '11', '1', '141', '10311.3', '832.463', '1326.41', '55', '18', '25', '19', '22', '22', '53', '100', '0', '0', '0', '16', '3', '4', '61');
INSERT INTO `playercreateinfo` VALUES ('43', '6', '6', '11', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '26', '15', '22', '17', '24', '74', '67', '0', '0', '0', '32', '5', '6', '141');
INSERT INTO `playercreateinfo` VALUES ('44', '11', '1629', '1', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '24', '17', '21', '21', '22', '50', '0', '1000', '0', '0', '31', '5', '6', '163');
INSERT INTO `playercreateinfo` VALUES ('45', '11', '1629', '2', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '23', '17', '21', '21', '23', '48', '95', '0', '0', '0', '29', '5', '6', '163');
INSERT INTO `playercreateinfo` VALUES ('46', '11', '1629', '3', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '20', '20', '21', '23', '46', '100', '0', '0', '0', '23', '4', '5', '163');
INSERT INTO `playercreateinfo` VALUES ('47', '11', '1629', '5', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '17', '19', '23', '25', '51', '175', '0', '0', '0', '11', '2', '3', '163');
INSERT INTO `playercreateinfo` VALUES ('48', '11', '1629', '7', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '22', '17', '20', '22', '24', '47', '105', '0', '0', '0', '26', '4', '5', '163');
INSERT INTO `playercreateinfo` VALUES ('49', '11', '1629', '8', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '17', '19', '24', '24', '51', '180', '0', '0', '0', '11', '2', '3', '163');
INSERT INTO `playercreateinfo` VALUES ('50', '10', '1610', '2', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '19', '22', '20', '24', '20', '38', '140', '0', '0', '0', '21', '4', '4', '162');
INSERT INTO `playercreateinfo` VALUES ('51', '10', '1610', '3', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '25', '19', '24', '20', '45', '145', '0', '0', '0', '24', '4', '5', '162');
INSERT INTO `playercreateinfo` VALUES ('52', '10', '1610', '4', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '18', '25', '19', '24', '19', '44', '0', '0', '0', '100', '25', '4', '5', '162');
INSERT INTO `playercreateinfo` VALUES ('53', '10', '1610', '5', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '18', '26', '22', '50', '220', '0', '0', '0', '7', '2', '2', '162');
INSERT INTO `playercreateinfo` VALUES ('54', '10', '1610', '8', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '18', '27', '21', '50', '225', '0', '0', '0', '7', '2', '2', '162');
INSERT INTO `playercreateinfo` VALUES ('55', '10', '1610', '9', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '19', '26', '21', '42', '200', '0', '0', '0', '7', '2', '2', '162');
INSERT INTO `playercreateinfo` VALUES ('56', '1', '1', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '49', '23', '20', '22', '20', '20', '60', '0', '0', '0', '0', '29', '5', '6', '165');
INSERT INTO `playercreateinfo` VALUES ('57', '2', '2', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '51', '26', '17', '24', '17', '23', '80', '0', '0', '0', '0', '35', '6', '7', '165');
INSERT INTO `playercreateinfo` VALUES ('58', '3', '3', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '53', '25', '16', '25', '19', '19', '90', '0', '0', '0', '0', '33', '5', '6', '165');
INSERT INTO `playercreateinfo` VALUES ('59', '4', '4', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '55', '20', '25', '21', '20', '20', '50', '0', '0', '0', '0', '23', '4', '5', '165');
INSERT INTO `playercreateinfo` VALUES ('60', '5', '5', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '57', '22', '18', '23', '18', '25', '70', '0', '0', '0', '0', '27', '4', '5', '165');
INSERT INTO `playercreateinfo` VALUES ('61', '6', '6', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '59', '28', '15', '24', '15', '22', '80', '0', '0', '0', '0', '39', '6', '7', '165');
INSERT INTO `playercreateinfo` VALUES ('62', '7', '115', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '1563', '18', '23', '21', '23', '20', '50', '0', '0', '0', '0', '19', '3', '4', '165');
INSERT INTO `playercreateinfo` VALUES ('63', '8', '116', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '1478', '24', '22', '23', '16', '21', '70', '0', '0', '0', '0', '31', '5', '6', '165');
INSERT INTO `playercreateinfo` VALUES ('64', '11', '1629', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '16125', '24', '17', '21', '21', '22', '50', '0', '0', '0', '0', '31', '5', '6', '165');
INSERT INTO `playercreateinfo` VALUES ('65', '10', '1610', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '15476', '19', '22', '20', '24', '20', '38', '0', '0', '0', '0', '21', '4', '4', '165');