Automatically fixing item names in the catalogue

[Synapse]

I made a simple SQL query that will update all of your catalog_items catalog_name to match the furni's public name. This specific code should work fine with MySql
Arcturus

Spoiler

UPDATE catalog_items INNER JOIN items_base ON catalog_items.item_ids = items_base.id SET catalog_items.catalog_name = items_base.public_name

Plus R2

Spoiler

 UPDATE catalog_items INNER JOIN furniture ON catalog_items.item_id = furniture.id SET catalog_items.catalog_name = furniture.public_name

For the newbies:
Run this SQL using Navicat/phpmyadmin, go to your hotel and type :update catalog

 

[sorenkai]

Fixed my problems, thanks!

 

[Beast92]

I didn't work as you can see in my screenshot. I use arcturus morningstar.

You must be registered for see images attach