Yeah. Found the version of this that actually works.
DELIMITER $$
DROP TRIGGER IF EXISTS tr_updateHouseInv$$
CREATE
DEFINER = 'dayz'@'localhost'
TRIGGER tr_updateHouseInv
BEFORE UPDATE
ON object_data
FOR EACH ROW
BEGIN
IF (NEW.CharacterID IS NOT NULL AND (NEW.inventory LIKE...
When i try to run this in MySql it says there is a syntax error on line 10
SIGNAL SQLSTATE '45000'; <--- Says that this is the wrong syntax !!!
Any ideas guys ???
Zombieshack. Read ALL the pages of this thread and you will see that many people have a working Origins server up and running including myself thanks to the fantastic help from the guys here.
Hi,
I am seeing this in the hiveExt.log file.
2013-06-23 13:52:42 Database: [Error] Error 1062 (Duplicate entry '123456789' for key 'uq_profile') in MySQLStmtExecute SQL: 'insert into profile (`unique_id`, `name`) values (?, ?) VALUES("123456789", "Vytas")' <---- ID CHANGED
2013-06-23...
Users are reporting bandages, and tents are doubling.
They have 2 tents. They leave the server and rejoin and they have 4 tents. Same with bandages.
They have said the same for flares
I can confirm that this works a treat. Thanks skaronator. Just a few people moaning saying things are double spawning but i don't see any of these entities in the database
You are also erroring out with a vehicle co ordinate. In position 61 it is coming up with the following error
[0[7217.437, 2314.2693, -0.055636108]]
It is missing a ,
It should be
[0,[7217.437, 2314.2693, -0.055636108]]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.