SQL Query Change all coin values to pixels in catalog

[Queef]

Hi, i was wondering if there was a SQL query that could change all furniture in the catalog so that you buy it with pixels and not credits.

Thanks,

 

[Sledmore]

Yes, now depending on your catalog_items structure it would go something like this:

UPDATE `catalog_items` SET `cost_credits` = '0';

That will make them all 0c (if that is that right structure)

UPDATE `catalog_items` SET `cost_pixels` = 'PRICE';

This will make the items cost what you set.

Or if you mean to swap them the best thing would just be rename the columns, also back up your database before you do this.

 

[Queef]

Yes, now depending on your catalog_items structure it would go something like this:

UPDATE `catalog_items` SET `cost_credits` = '0';

That will make them all 0c (if that is that right structure)

UPDATE `catalog_items` SET `cost_pixels` = 'PRICE';

This will make the items cost what you set.

Or if you mean to swap them the best thing would just be rename the columns, also back up your database before you do this.

Legend, according to my Database it worked but my catalog still says the original prices.\

Dont worry i fixed it, thanks again for the help mate.