Base Building keypad/gate code not working

S

statik

Well-Known Member
I can build the keypad and gate, and the code works fine until a server restart. After restart the keypad and gate are still there, but code fails. The code is not saving to database. Has anyone had this problem or know of a fix? Thanks.
 
what dayz-version/Mod?
You can also try to use google and look for seeweaduk's posts, I've had the same problem and he helped me with that. For my it was the Database-Schema
 
i dont know if there is a difference between vanilla DayZ and Overwatch but just in case here is my:

Code: 
CREATE TABLE IF NOT EXISTS `instance_deployable` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(60) NOT NULL,
  `deployable_id` smallint(5) unsigned NOT NULL,
  `owner_id` int(10) unsigned NOT NULL,
  `instance_id` bigint(20) unsigned NOT NULL DEFAULT '1',
  `worldspace` varchar(60) NOT NULL DEFAULT '[0,[0,0,0]]',
  `inventory` varchar(2048) NOT NULL DEFAULT '[]',
  `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Hitpoints` varchar(500) NOT NULL DEFAULT '[]',
  `Fuel` double(13,0) NOT NULL DEFAULT '0',
  `Damage` double(13,0) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx1_instance_deployable` (`deployable_id`),
  KEY `idx2_instance_deployable` (`owner_id`),
  KEY `idx3_instance_deployable` (`instance_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=943 ;
 
I compared my DB Schema and it is pretty much the same except for mine has these two differences.

'Fuel' double (13,5) NOT NULL DEFAULT '0',

and

AUTO_INCREMENT=95
 
i dont know if it could help, but have you checked rosskas fixes? They helped me alot to this done. maybe you can compare the default files from Overwatch, Base-Building 1.2 and rosskas fixes.
Cant help you alot with Overwatch :oops:
 
go to where it says pvdz_publish or w/e in the keypad files and make sure your DB variables are right. For example if it says blah blah blah %1 %2 %3 and the code to save to the database actually has 5 items tying to be written in then it wont work. If you look over kikyous base building improvements it will make more sense. Even if you create the instance_deployable table you will have to make sure the string of code to save your codes and objects has as many characters as is required to save an item/object or code. Sorry if this doesnt make since. DB issues can be tricky. I will post an example line of code to show if you have not solved the issue soon.
 
and as far as the kikyou update goes, it works, just needs to be updated too. Since the last relesae of dayz_code everything must be updated.
 
This code is what i was saying before
Code: 
_key = format["CHILD:308:%1:%2:%3:%4:%5:", dayz_instance, _class, _charID, _worldspace, _uid];
This is very important when saving uid charcter id and codes to objects. See how there are as many variables as child:308 hive writes? Im not saying this is a complete fix but its how you have to pick thru it and make sure all ur variables and hive write requests match up.
 
i wouldnt be so sure about that, because as far as i know epoch is using a bit other database schema. Looks like Overwatch and DayZ Vanilla have quite the same schema so he needs to make some more changes to get this working, without any promise to get a result, though
 
You must log in or register to reply here.
Back
Top