INSERT INTO `playercreateinfo` VALUES (1, 1, 1, 1, 0, 12, -8946.42, -131.35, 83.63, 49, 23, 20, 22, 20, 20, 60, 0, 1000, 0, 0, 29, 5, 6, 81, '2'); INSERT INTO `playercreateinfo` VALUES (9, 1, 1, 2, 0, 12, -8946.42, -131.35, 83.63, 49, 22, 20, 22, 20, 21, 58, 80, 0, 0, 0, 27, 4, 5, 81, '2'); INSERT INTO `playercreateinfo` VALUES (18, 1, 1, 4, 0, 12, -8946.42, -131.35, 83.63, 49, 21, 23, 21, 20, 20, 55, 0, 0, 0, 100, 26, 4, 5, 81, '2'); INSERT INTO `playercreateinfo` VALUES (25, 1, 1, 5, 0, 12, -8946.42, -131.35, 83.63, 49, 20, 20, 20, 22, 23, 52, 160, 0, 0, 0, 20, 3, 4, 81, '2'); INSERT INTO `playercreateinfo` VALUES (34, 1, 1, 8, 0, 12, -8946.42, -131.35, 83.63, 49, 20, 20, 20, 23, 22, 52, 165, 0, 0, 0, 20, 3, 4, 81, '2'); INSERT INTO `playercreateinfo` VALUES (38, 1, 1, 9, 0, 12, -8946.42, -131.35, 83.63, 49, 20, 20, 21, 22, 22, 53, 140, 0, 0, 0, 20, 3, 4, 81, '2'); INSERT INTO `playercreateinfo` VALUES (56, 1, 1, 6, 609, 4298, 2355.23, -5661.32, 426.028, 49, 23, 20, 22, 21, 21, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (2, 2, 2, 1, 1, 14, -618.51, -4251.66, 38.71, 51, 26, 17, 23, 17, 22, 70, 0, 1000, 0, 0, 35, 6, 7, 21, '4194304'); INSERT INTO `playercreateinfo` VALUES (11, 2, 2, 3, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 20, 22, 17, 23, 66, 82, 0, 0, 0, 25, 4, 5, 21, '4194304'); INSERT INTO `playercreateinfo` VALUES (19, 2, 2, 4, 1, 14, -618.51, -4251.66, 38.71, 51, 24, 20, 22, 17, 22, 65, 0, 0, 0, 100, 26, 4, 5, 21, '4194304'); INSERT INTO `playercreateinfo` VALUES (30, 2, 2, 7, 1, 14, -618.51, -4251.66, 38.71, 51, 24, 17, 22, 18, 24, 69, 73, 0, 0, 0, 23, 4, 5, 21, '4194304'); INSERT INTO `playercreateinfo` VALUES (39, 2, 2, 9, 1, 14, -618.51, -4251.66, 38.71, 51, 23, 17, 22, 19, 24, 63, 109, 0, 0, 0, 26, 4, 5, 21, '4194304'); INSERT INTO `playercreateinfo` VALUES (57, 2, 2, 6, 609, 4298, 2355.23, -5661.32, 426.028, 51, 26, 17, 23, 18, 22, 1, 0, 0, 0, 0, 29, 7, 8, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (3, 3, 3, 1, 0, 1, -6240.31, 331.03, 382.75, 53, 28, 16, 23, 19, 19, 70, 0, 1000, 0, 0, 39, 6, 7, 41, '32'); INSERT INTO `playercreateinfo` VALUES (10, 3, 3, 2, 0, 1, -6240.31, 331.03, 382.75, 53, 27, 16, 23, 19, 20, 68, 79, 0, 0, 0, 37, 6, 7, 41, '32'); INSERT INTO `playercreateinfo` VALUES (12, 3, 3, 3, 0, 1, -6240.31, 331.03, 382.75, 53, 25, 19, 22, 19, 20, 66, 84, 0, 0, 0, 26, 4, 5, 41, '32'); INSERT INTO `playercreateinfo` VALUES (20, 3, 3, 4, 0, 1, -6240.31, 331.03, 382.75, 53, 26, 19, 22, 19, 19, 65, 0, 0, 0, 100, 27, 4, 5, 41, '32'); INSERT INTO `playercreateinfo` VALUES (26, 3, 3, 5, 0, 1, -6240.31, 331.03, 382.75, 53, 25, 16, 21, 21, 22, 62, 145, 0, 0, 0, 30, 5, 6, 41, '32'); INSERT INTO `playercreateinfo` VALUES (58, 3, 3, 6, 609, 4298, 2355.23, -5661.32, 426.028, 53, 28, 16, 23, 20, 19, 1, 0, 0, 0, 0, 29, 8, 9, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (4, 4, 4, 1, 1, 141, 10311.9, 832.25, 1326.39, 55, 19, 24, 22, 20, 20, 60, 0, 1000, 0, 0, 21, 4, 4, 61, '100663296'); INSERT INTO `playercreateinfo` VALUES (15, 4, 4, 3, 1, 141, 10311.9, 832.25, 1326.39, 55, 16, 27, 21, 20, 21, 56, 85, 0, 0, 0, 25, 4, 5, 61, '100663296'); INSERT INTO `playercreateinfo` VALUES (21, 4, 4, 4, 1, 141, 10311.9, 832.25, 1326.39, 55, 17, 27, 21, 20, 20, 55, 0, 0, 0, 100, 26, 4, 5, 61, '100663296'); INSERT INTO `playercreateinfo` VALUES (27, 4, 4, 5, 1, 141, 10311.9, 832.25, 1326.39, 55, 16, 24, 20, 22, 23, 52, 160, 0, 0, 0, 12, 2, 3, 61, '100663296'); INSERT INTO `playercreateinfo` VALUES (42, 4, 4, 11, 1, 141, 10311.9, 832.25, 1326.39, 55, 17, 24, 20, 22, 22, 54, 100, 0, 0, 0, 14, 3, 3, 61, '100663296'); INSERT INTO `playercreateinfo` VALUES (59, 4, 4, 6, 609, 4298, 2355.23, -5661.32, 426.028, 55, 19, 24, 22, 21, 20, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (5, 5, 5, 1, 0, 85, 1676.62, 1677.2, 121.67, 57, 22, 18, 22, 18, 25, 60, 0, 1000, 0, 0, 27, 4, 5, 2, '1024'); INSERT INTO `playercreateinfo` VALUES (22, 5, 5, 4, 0, 85, 1676.62, 1677.2, 121.67, 57, 20, 21, 21, 18, 25, 55, 0, 0, 0, 100, 23, 4, 5, 2, '1024'); INSERT INTO `playercreateinfo` VALUES (28, 5, 5, 5, 0, 85, 1676.62, 1677.2, 121.67, 57, 19, 18, 20, 20, 28, 52, 130, 0, 0, 0, 18, 3, 4, 2, '1024'); INSERT INTO `playercreateinfo` VALUES (35, 5, 5, 8, 0, 85, 1676.62, 1677.2, 121.67, 57, 19, 18, 20, 21, 27, 52, 135, 0, 0, 0, 18, 3, 4, 2, '1024'); INSERT INTO `playercreateinfo` VALUES (40, 5, 5, 9, 0, 85, 1676.62, 1677.2, 121.67, 57, 19, 18, 21, 20, 27, 53, 110, 0, 0, 0, 18, 3, 4, 2, '1024'); INSERT INTO `playercreateinfo` VALUES (60, 5, 5, 6, 609, 4298, 2355.23, -5661.32, 426.028, 57, 22, 18, 22, 19, 25, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (6, 6, 6, 1, 1, 215, -2917.58, -257.98, 52.99, 59, 28, 16, 23, 16, 22, 68, 0, 1000, 0, 0, 39, 6, 7, 141, '2097152'); INSERT INTO `playercreateinfo` VALUES (16, 6, 6, 3, 1, 215, -2917.58, -257.98, 52.99, 59, 25, 19, 22, 16, 23, 64, 81, 0, 0, 0, 26, 4, 5, 141, '2097152'); INSERT INTO `playercreateinfo` VALUES (31, 6, 6, 7, 1, 215, -2917.58, -257.98, 52.99, 59, 26, 16, 22, 17, 24, 67, 72, 0, 0, 0, 24, 4, 5, 141, '2097152'); INSERT INTO `playercreateinfo` VALUES (43, 6, 6, 11, 1, 215, -2917.58, -257.98, 52.99, 59, 26, 16, 21, 18, 24, 62, 68, 0, 0, 0, 32, 5, 6, 141, '2097152'); INSERT INTO `playercreateinfo` VALUES (61, 6, 6, 6, 609, 4298, 2355.23, -5661.32, 426.028, 59, 28, 16, 23, 17, 22, 1, 0, 0, 0, 0, 29, 8, 9, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (7, 7, 115, 1, 0, 1, -6240.31, 331.03, 382.75, 1563, 18, 22, 22, 24, 20, 60, 0, 1000, 0, 0, 19, 3, 4, 101, '32'); INSERT INTO `playercreateinfo` VALUES (23, 7, 115, 4, 0, 1, -6240.31, 331.03, 382.75, 1563, 16, 25, 21, 24, 20, 55, 0, 0, 0, 100, 23, 4, 5, 101, '32'); INSERT INTO `playercreateinfo` VALUES (36, 7, 115, 8, 0, 1, -6240.31, 331.03, 382.75, 1563, 15, 22, 20, 27, 22, 52, 225, 0, 0, 0, 10, 2, 3, 101, '32'); INSERT INTO `playercreateinfo` VALUES (41, 7, 115, 9, 0, 1, -6240.31, 331.03, 382.75, 1563, 15, 22, 21, 26, 22, 53, 200, 0, 0, 0, 10, 2, 3, 101, '32'); INSERT INTO `playercreateinfo` VALUES (62, 7, 115, 6, 609, 4298, 2355.23, -5661.32, 426.028, 1563, 18, 22, 22, 25, 20, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (8, 8, 116, 1, 1, 14, -618.51, -4251.66, 38.71, 1478, 24, 22, 22, 16, 21, 60, 0, 1000, 0, 0, 31, 5, 6, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (17, 8, 116, 3, 1, 14, -618.51, -4251.66, 38.71, 1478, 21, 25, 21, 16, 22, 56, 81, 0, 0, 0, 28, 5, 5, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (24, 8, 116, 4, 1, 14, -618.51, -4251.66, 38.71, 1478, 22, 25, 21, 16, 21, 55, 0, 0, 0, 100, 29, 5, 6, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (29, 8, 116, 5, 1, 14, -618.51, -4251.66, 38.71, 1478, 21, 22, 20, 18, 24, 52, 128, 0, 0, 0, 22, 4, 5, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (32, 8, 116, 7, 1, 14, -618.51, -4251.66, 38.71, 1478, 22, 22, 21, 17, 23, 59, 72, 0, 0, 0, 26, 4, 5, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (37, 8, 116, 8, 1, 14, -618.51, -4251.66, 38.71, 1478, 21, 22, 20, 19, 23, 52, 119, 0, 0, 0, 22, 4, 5, 121, '4194304'); INSERT INTO `playercreateinfo` VALUES (63, 8, 116, 6, 609, 4298, 2355.23, -5661.32, 426.028, 1478, 24, 22, 22, 17, 21, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (50, 10, 1610, 2, 530, 3430, 10354.9, -6363.56, 34.97, 15476, 19, 22, 22, 23, 19, 58, 125, 0, 0, 0, 21, 4, 4, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (51, 10, 1610, 3, 530, 3430, 10354.9, -6363.56, 34.97, 15476, 17, 25, 21, 23, 19, 56, 130, 0, 0, 0, 24, 4, 5, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (52, 10, 1610, 4, 530, 3430, 10354.9, -6363.56, 34.97, 15476, 18, 25, 21, 23, 18, 55, 0, 0, 0, 100, 25, 4, 5, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (53, 10, 1610, 5, 530, 3430, 10354.9, -6363.56, 34.97, 15476, 17, 22, 20, 25, 21, 52, 205, 0, 0, 0, 14, 3, 3, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (54, 10, 1610, 8, 530, 3430, 10354.9, -6363.56, 34.97, 15476, 17, 22, 20, 26, 20, 52, 210, 0, 0, 0, 14, 3, 3, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (55, 10, 1610, 9, 530, 3430, 10354.9, -6363.56, 36.18, 15476, 17, 22, 21, 25, 20, 53, 185, 0, 0, 0, 14, 3, 3, 162, '0 0 131072'); INSERT INTO `playercreateinfo` VALUES (65, 10, 1610, 6, 609, 4298, 2355.23, -5661.32, 426.028, 15476, 20, 22, 22, 24, 18, 1, 0, 0, 0, 0, 29, 6, 7, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952'); INSERT INTO `playercreateinfo` VALUES (44, 11, 1629, 1, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 24, 17, 22, 20, 22, 60, 0, 1000, 0, 0, 31, 5, 6, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (45, 11, 1629, 2, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 23, 17, 22, 20, 23, 58, 80, 0, 0, 0, 29, 5, 6, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (46, 11, 1629, 3, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 21, 20, 21, 20, 23, 56, 85, 0, 0, 0, 23, 4, 5, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (47, 11, 1629, 5, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 21, 17, 20, 22, 25, 52, 160, 0, 0, 0, 22, 4, 5, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (48, 11, 1629, 7, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 22, 17, 21, 21, 24, 59, 90, 0, 0, 0, 21, 4, 4, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (49, 11, 1629, 8, 530, 3524, -3961.63, -13931.2, 100.61, 16125, 21, 17, 20, 23, 24, 52, 165, 0, 0, 0, 22, 4, 5, 163, '0 0 536870912'); INSERT INTO `playercreateinfo` VALUES (64, 11, 1629, 6, 609, 4298, 2355.23, -5661.32, 426.028, 16125, 24, 17, 22, 21, 22, 1, 0, 0, 0, 0, 29, 7, 8, 165, '4294967295 4093640703 830406655 0 33570816 1310944 3250593812 73752 896 67111952');
Добавлено (12.01.2012, 12:51) ---------------------------------------------
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', `taximask` tinytext, PRIMARY KEY (`Index`) ) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=latin1 COMMENT='Player System'
вот дамп и табличка чтобы видеть какой номер к чему относится
Сообщение #
13 написано 12.01.2012 в 12:51