• 2
RalFingerLP

"Dead" people respawning with gear at random location on the map

Question

Dear all,

since a couple of days we have this issue where dead players respawn at a random location after they have been shot (or even respawn right beside their dead body). They also don´t have any kind of bambi status and have gear from diffrent player, almost full equiped. This is gamebreaking for us.

We did a full clear of the sql database and forced to only keep a single entry for each player account_uid. This somehow is not the sollution. We do have diffrent players with almost the same entries and we don´t know how, an example:

2cz39zn.png

The server is running since around 6 hours and we do have a lot of those players in the list. 

To clean up our DB we used the following script to deleete and rewrite for a cleanup, feel free to use it for your own needs:

CREATE TABLE IF NOT EXISTS `playerBackup` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `account_uid` varchar(32) NOT NULL,
  `is_alive` tinyint(1) NOT NULL DEFAULT '1',
  `damage` double unsigned NOT NULL DEFAULT '0',
  `fatigue` double unsigned NOT NULL DEFAULT '0',
  `hunger` double unsigned NOT NULL DEFAULT '100',
  `thirst` double unsigned NOT NULL DEFAULT '100',
  `alcohol` double unsigned NOT NULL DEFAULT '0',
  `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
  `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_head` double unsigned NOT NULL,
  `hitpoint_body` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_hands` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_legs` double unsigned NOT NULL DEFAULT '0',
  `direction` double NOT NULL DEFAULT '0',
  `position_x` double NOT NULL DEFAULT '0',
  `position_y` double NOT NULL DEFAULT '0',
  `position_z` double NOT NULL DEFAULT '0',
  `spawned_at` datetime NOT NULL,
  `died_at` datetime DEFAULT NULL,
  `assigned_items` text NOT NULL,
  `backpack` varchar(64) NOT NULL,
  `backpack_items` text NOT NULL,
  `backpack_magazines` text NOT NULL,
  `backpack_weapons` text NOT NULL,
  `current_weapon` varchar(64) NOT NULL,
  `goggles` varchar(64) NOT NULL,
  `handgun_items` varchar(255) NOT NULL,
  `handgun_weapon` varchar(64) NOT NULL,
  `headgear` varchar(64) NOT NULL,
  `binocular` varchar(64) NOT NULL,
  `loaded_magazines` varchar(255) NOT NULL,
  `primary_weapon` varchar(64) NOT NULL,
  `primary_weapon_items` varchar(255) NOT NULL,
  `secondary_weapon` varchar(64) NOT NULL,
  `secondary_weapon_items` varchar(255) NOT NULL,
  `uniform` varchar(64) NOT NULL,
  `uniform_items` text NOT NULL,
  `uniform_magazines` text NOT NULL,
  `uniform_weapons` text NOT NULL,
  `vest` varchar(64) NOT NULL,
  `vest_items` text NOT NULL,
  `vest_magazines` text NOT NULL,
  `vest_weapons` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `player_uid` (`account_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
ALTER TABLE `playerBackup` 
ADD UNIQUE INDEX `id_UNIQUE` (`account_uid` ASC);
 
INSERT IGNORE INTO `playerBackup` SELECT * FROM `player`;
TRUNCATE TABLE `player`;
ALTER TABLE `player` 
ADD UNIQUE INDEX `id_UNIQUE` (`account_uid` ASC);
INSERT IGNORE INTO `player`  SELECT * FROM `playerBackup`;
DROP TABLE `playerBackup`;

This worked good, but didn´t fix our problem. Does anyone else can relate to this problem?

Edit

After we added the change in the exile.ini nothing realy happend. But we found somehting which will explain what happend. Take a look here:

x4km6c.png

In the first line you see two entries with ID 0, the first line is me with my account_uid (player id in game) and the second line is the real TheDMD.We both have the same stats if it comes to thurst, hunger and location. This is messed up! Sadly your tweak on the .ini didn´t change anything for us.

Edited by RalFingerLP
Eichi´s answer didn´t fix the problem

Share this post


Link to post
Share on other sites

1 answer to this question

  • 0

That is a problem related to Arma. Somehow a player can be "alive" but still have 100% damage. To work-around this issue until the next patch from us, go to @ExileServer\extDB\sql_custom_v2\exile.ini and change this:

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Player related queries
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[hasAlivePlayer]
SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND is_alive = 1) THEN 'true' ELSE 'false' END
Number of Inputs = 1
SQL1_INPUTS = 1

to this

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Player related queries
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[hasAlivePlayer]
SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND is_alive = 1 AND damage < 1) THEN 'true' ELSE 'false' END
Number of Inputs = 1
SQL1_INPUTS = 1

Let me know if this helps.

Share this post


Link to post
Share on other sites
Advertisement

  • Recently Browsing   0 members

    No registered users viewing this page.