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]]
Hi There. Sorry for the delay.
I use reality and always have. The players who could not get in now can join but they are all reporting spawning in the water.
I am seeing this from one of my friends in the rpt log
18:37:37 "STARTING LOGIN: ["1798208",B 1-1-A:1 (Master Simon) REMOTE]"...
Nope. New server created. New database and still it spawns with blank co ordinates. This time however you are spawning with all your equipment (Map etc when you set it in the inventory). I spawned off the north north west of the coast at the top left handside of the map and can swim to land in...
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.