Catalogue_items > offer_id updater

[Flam0]

Hi,

I wanted to make the search on items possible in the Catalogue, I have a tool that converted all the furnidata.xml furni-id's to offer_id's (the same)
Because the default was -1. But, now in my catalog_items table, literally every offer_id is -1. Does anybody have a tool to update this all with my current furnidata.xml? i'm using Arcturus Morningstar.

 

[Wieiscool]

Assuming you mean, you want to change the "offer_id" to the same value as "item_ids" you can do that easily with a simple SQL code.

UPDATE `catalog_items` SET `offer_id` = `item_ids`

Go to your table, and press SQL.

You must be registered for see links

When you paste it in that, press the start button, after that every "offer_id" is the same as the "items_id" in your "catalog_items" table.


If I may ask, what tool did you use to convert the data in the furnidata.xml?

 

[Flam0]

It's fixed Thanks!

If you need the link for the ZIP just ask me.

And, i downloaded a tool called FurniIDToOfferId so that converted all the furnidata furni id's to offer-id's.

 

[Liam]

This is an interesting, common problem a lot of people seem to have.

So a program fixes this? Sounds fairly simple. You should make a tutorial.

 

[Wieiscool]

And, i downloaded a tool called FurniIDToOfferId so that converted all the furnidata furni id's to offer-id's.

Thank you, googled a bit and found it. And like Liam said, you should make a tutorial about it, you can help a lot of people!