Anyone use Navicat or HeidiSql?

[ZarX]

So for some reason none of my database clean up functions are working in either navicat or heidisql.

 

Here is my funtion for Navi.

 

BEGIN

DELETE FROM character_data WHERE Alive = 0;

DELETE FROM object_data WHERE Damage = 1;

RETURN 0;

END

 

And i get this message after it runs.

 

Procedure execution failed

1584 - Incorrect parameters in the call to stored function 'Database clean up'

 

Any ideas? 

 

[3steN8igall]

i use heidiSQL
it is better you separate every event
rightclick on epoch database -> create -> event

DELETE FROM 'character_data' WHERE 'Alive' = 0

DELETE FROM 'object_data' WHERE 'Damage' = 1

[Defent]

-- Dumping structure for event epoch.CleanDead
DELIMITER //
CREATE DEFINER=`YOURUSERNAME`@`%` EVENT `CleanDead` ON SCHEDULE EVERY 3 HOUR STARTS '2014-06-29 21:02:46' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
DELETE FROM `character_data` WHERE `LastLogin` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Generation` > 1 AND `Alive` = 0;
END//
DELIMITER ;


-- Dumping structure for event epoch.CleanDeader
DELIMITER //
CREATE DEFINER=`YOURUSERNAME`@`%` EVENT `CleanDeader` ON SCHEDULE EVERY 6 HOUR STARTS '2014-07-24 17:06:09' ON COMPLETION NOT PRESERVE ENABLE DO delete FROM `character_data`

USING character_data, character_data AS tmpcharacter_data

WHERE NOT character_data.CharacterID=tmpcharacter_data.CharacterID

AND character_data.CharacterID<tmpcharacter_data.CharacterID

AND (character_data.PlayerUID=tmpcharacter_data.PlayerUID)//
DELIMITER ;


-- Dumping structure for event epoch.removeDamagedVehicles
DELIMITER //
CREATE DEFINER=`YOURUSERNAME`@`%` EVENT `removeDamagedVehicles` ON SCHEDULE EVERY 1 DAY STARTS '2014-02-23 11:46:44' ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Removes damaged vehicles' DO DELETE FROM `Object_DATA` WHERE Damage = 1//
DELIMITER ;

These are my cleanup events for vehicles and dead players. Courtesy of the SQL Clean up thread and the people who made them. Copy the code and replace yourusername with your username.

[ZarX]

i use heidiSQL
it is better you separate every event
rightclick on epoch database -> create -> event

DELETE FROM 'character_data' WHERE 'Alive' = 0

DELETE FROM 'object_data' WHERE 'Damage' = 1

 

 

Never mind got it.

[Chainsaw Squirrel]

Im trying to decipher the Object_Data  table data fields .. on vehicles Damage some show 1, some 0, some show like 0.032 etc .. the 0 and 1 damage,  some are zero on fuel and damage , are those cars with issues, need to be purged.. from the db or good to leave ?

[ZamboniBambino]

Im trying to decipher the Object_Data  table data fields .. on vehicles Damage some show 1, some 0, some show like 0.032 etc .. the 0 and 1 damage,  some are zero on fuel and damage , are those cars with issues, need to be purged.. from the db or good to leave ?

 

The structure is as follows:

CREATE TABLE IF NOT EXISTS `Object_DATA` (
  `ObjectID` int(11) unsigned NOT NULL AUTO_INCREMENT, // ID of the object in the table

  `ObjectUID` bigint(24) NOT NULL DEFAULT '0', // UID in game 

  `Instance` int(11) unsigned NOT NULL, // dayZ_instance

  `Classname` varchar(50) DEFAULT NULL, // In-game class name

  `Datestamp` datetime NOT NULL, // Date added

  `LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, // What the type says.. last updated on.. 

  `CharacterID` int(11) unsigned NOT NULL DEFAULT '0', // Attached character

  `Worldspace` varchar(128) NOT NULL DEFAULT '[]', // Position in dayz format ([heading,[x,y,z]])

  `Inventory` longtext, // Array of contents for the vehicle in dayz format

  `Hitpoints` varchar(512) NOT NULL DEFAULT '[]', // Array of which bits of the vehicle are damaged, stored in text in SQL, converted into array in DayZ

  `Fuel` double(13,5) NOT NULL DEFAULT '1.00000', // 1 = full, 0 = empty

  `Damage` double(13,5) NOT NULL DEFAULT '0.00000', // 1 = Destroyed , 0 = Pristine

  PRIMARY KEY (`ObjectID`),
  KEY `ObjectUID` (`ObjectUID`) USING BTREE,
  KEY `Instance` (`Instance`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

[Chainsaw Squirrel]

Thanks Exactly what I was looking for .. for that I offer you a cookie