FAQ. Problems with moving objects on maps

How to move objects from one map to another

PostgreSQL (UserSide version 3.13+)

To do this, find out the ID of the old map (from where we transfer) and the new map (to where we transfer). In the database, these are the userside3.pbl_map.CODE fields - check the values for your maps.

Then execute the transfer commands in the database: Replace 0 with the ID of the old map, replace 999 with the ID of the new map

UPDATE userside3.pbl_map_obj SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_optica_house SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_med_house SET MAPCODE = 999 WHERE MAPCODE = 0;

PostgreSQL (UserSide version 3.12)

To do this, find out the ID of the old map (from where we transfer) and the new map (to where we transfer). In the database, these are the userside3.pbl_map.CODENUMBER fields - check the values for your maps.

Then execute the transfer commands in the database: Replace 0 with the ID of the old map, replace 999 with the ID of the new map

UPDATE userside3.pbl_coord SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_map_obj SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_optica_house SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_med_house SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE userside3.pbl_adr_city SET MAPCODE = 999 WHERE MAPCODE = 0;

MySQL (UserSide versions up to 3.12)

To do this, find out the ID of the old map (from where we transfer) and the new map (to where we transfer). In the database, these are the tbl_map.CODENUMBER fields - check the values for your maps.

Then execute the transfer commands in the database: Replace 0 with the ID of the old map, replace 999 with the ID of the new map

UPDATE tbl_coord SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE tbl_map_obj SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE tbl_optica_house SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE tbl_med_house SET MAPCODE = 999 WHERE MAPCODE = 0;
UPDATE tbl_adr_city SET MAPCODE = 999 WHERE MAPCODE = 0;