Просмотр кода страницы FAQ. Problems with moving objects on maps

[[FAQ._Problems_with_moving_objects_on_maps|en]] | [[FAQ._Проблемы_с_переносом_объектов_на_картах|ru]]

'''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;