Searching for catalouge items in the database.

[ItsGeorge]

Hello,
I'm trying to search for furniture with the page id of '600' and i sort out the page id too ascending/decending but either of them show the page ID of 600, what can i do too find all the furniture with the page id 600?

Thanks,
ItsGeorge

 

[JayC]

If you're trying to move all the furniture with page ID 600 you can just run a query:

UPDATE catalog_pages WHERE page_id = '600' SET page_id = 'whatever'

otherwise you can do exactly what you did, assort them and find it by hand

 

[ItsGeorge]

If you're trying to move all the furniture with page ID 600 you can just run a query:

UPDATE catalog_pages WHERE page_id = '600' SET page_id = 'whatever'

otherwise you can do exactly what you did, assort them and find it by hand

Trying to change the price of everything under that page, so what query would i search for Updating the credits?

 

[JayC]

Oh Go to your Catalog_Items not pages^

 

[ItsGeorge]

Basically, Im trying to find a Page ID, on Catalogue Items, the page id is 642 to edit the prices of the furniture?

 

[JayC]

If you want all the furniture to be the same price do this query:

UPDATE catalog_items SET cost_credits='COST' WHERE page_id='642'

Change COST to the amount of coins

 

[ItsGeorge]

If you want all the furniture to be the same price do this query:

UPDATE catalog_items SET cost_credits='COST' WHERE page_id='642'

Change COST to the amount of coins

Cheers man that worked perfectly, By any chance do you have like a list of querys that could help me for the near future or?

 

[JayC]

Learn to write them. They are really simple use this template:

UPDATE *table* SET *column*=*value* WHERE *column*=*value*;

Like setting homeroom:

UPDATE users SET 'home_room'='#';

 

[ItsGeorge]

Alright mate thanks.