mirror of
https://bitbucket.org/theswgsource/src-1.2.git
synced 2026-07-14 00:01:30 -04:00
13 lines
496 B
SQL
13 lines
496 B
SQL
update objects
|
|
set deleted = 1, deleted_date = sysdate, load_with = null
|
|
where player_controlled = 'N'
|
|
and deleted = 0
|
|
and exists (select 1 from creature_objects c where c.object_id = objects.object_id)
|
|
and not exists (select 1 from scripts s where s.object_id = objects.object_id and s.script='terminal.vendor')
|
|
and script_list not like '%terminal.vendor%';
|
|
|
|
delete object_variables
|
|
where name_id = (select id from object_variable_names where name = 'alreadySpawned')
|
|
and object_id < 10000000;
|
|
|