Search results

  1. R

    Safe code set 0000 after fourteen days of inactivity

    We use this to reset VaultStorageLocked passwords to "1111" that havent been used for over 30 dayz. UPDATE `object_data` SET `CharacterID`='1111' WHERE `Classname` = 'VaultStorageLocked' AND `object_data`.`LastUpdated` <= CURRENT_DATE - INTERVAL 30 DAY
  2. R

    Custom Spawn location based on UID?

    the syntax on the OP was wrong CREATE TRIGGER `custom_spawn` BEFORE INSERT ON `survivor` FOR EACH ROW BEGIN DECLARE x INT; DECLARE y varchar(50); SET x = (SELECT `unique_id` FROM `cust_spawn` WHERE `unique_id`=NEW.unique_id); SET y = (SELECT `worldspace` FROM `cust_spawn` WHERE...
  3. R

    Custom Spawn location based on UID?

    This DB trigger should work if we can get the syntax errors sorted. Anyone had any joy?
Back
Top