American Idol catalogue page [Phoenix]

[Philly]

Don't know if this is more of a tutorial than a release.. Sorry if its in the wrong section.
This was tested on my hotel, which is running on Phoenix.
I'm hoping that you know a bit of basic editing etc before you go ahead with this, as you may need to change the parent_id / page_id etc if it does not work for you.

End result:

First off, execute this code in your database.
// This will remove the existing american idol furni from the promo page.

DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1875;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1895;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1867;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1880;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1885;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1866;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1869;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1864;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1870;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1879;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1888;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1873;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1896;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1941;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 2295;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 2305;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 2313;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1878;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1934;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1887;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1874;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1871;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1894;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1876;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1904;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1884;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1933;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1881;
DELETE FROM `phoenix3`.`catalog_items` WHERE `catalog_items`.`id` = 1930;

Now also, execute this code.
// This will create the catalogue page for America idol, the page will be placed under the 'Themed furni' in your catalogue.

INSERT INTO `catalog_pages` (`id`, `parent_id`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `page_link_description`, `page_link_pagename`) VALUES
(750, 351, 'American idol', 0, 92, '1', '1', 1, '0', 160, 'default_3x3', 'idol', 'catalog_djshop_teaser1', '', 'Get your hands on the latest american idol furniture. Page created by Philly', '', 'Click on an item for more information.', '', '0', '', '');

Finally, you just need to execute this bit of code.
// This will add all of the american idol furniture into the new page we just made.

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`, `vip`) VALUES
(1864, 750, '1441', 'ads_idol_floor1', 10, 0, 0, 1, '0'),
(1866, 750, '1443', 'ads_idol_desk', 10, 0, 0, 1, '0'),
(1867, 750, '1444', 'ads_idol_ch', 10, 0, 0, 1, '0'),
(1869, 750, '1446', 'ads_idol_drape', 10, 0, 0, 1, '0'),
(1870, 750, '1447', 'ads_idol_floor2', 10, 0, 0, 1, '0'),
(1871, 750, '1453', 'ads_idol_piano', 10, 0, 0, 1, '0'),
(1873, 750, '1464', 'ads_idol_jukebox*1', 10, 0, 0, 1, '0'),
(1874, 750, '1465', 'ads_idol_pchair', 10, 0, 0, 1, '0'),
(1875, 750, '1467', 'ads_idol_audChr', 10, 0, 0, 1, '0'),
(1876, 750, '1468', 'ads_idol_trax', 10, 0, 0, 1, '0'),
(1877, 750, '1469', 'ads_idol_tele', 10, 0, 0, 1, '0'),
(1878, 750, '1474', 'ads_idol_mic', 10, 0, 0, 1, '0'),
(1879, 750, '1475', 'ads_idol_hotspot', 10, 0, 0, 1, '0'),
(1880, 750, '1476', 'ads_idol_clRack', 10, 0, 0, 1, '0'),
(1881, 750, '1477', 'ads_idol_voting_ch', 10, 0, 0, 1, '0'),
(1884, 750, '1509', 'ads_idol_tube', 10, 0, 0, 1, '0'),
(1885, 750, '1511', 'ads_idol_cork', 10, 0, 0, 1, '0'),
(1887, 750, '1518', 'ads_idol_newsDsk', 10, 0, 0, 1, '0'),
(1888, 750, '1524', 'ads_idol_ichair', 10, 0, 0, 1, '0'),
(1894, 750, '1533', 'ads_idol_tblCloth', 10, 0, 0, 1, '0'),
(1895, 750, '1534', 'ads_idol_carpet', 10, 0, 0, 1, '0'),
(1896, 750, '1535', 'ads_idol_lamp', 10, 0, 0, 1, '0'),
(1904, 750, '1563', 'ads_idol_trophy', 10, 0, 0, 1, '0'),
(1930, 750, '1752', 'ads_idol_wall', 10, 0, 0, 1, '0'),
(1933, 750, '1758', 'ads_idol_tv', 10, 0, 0, 1, '0'),
(1934, 750, '1760', 'ads_idol_mirror', 10, 0, 0, 1, '0'),
(1941, 750, '1770', 'ads_idol_logo', 10, 0, 0, 1, '0'),
(2295, 750, '20073', 'ads_idol_l_carpet', 10, 0, 0, 1, '0'),
(2305, 750, '20147', 'ads_idol_l_logo', 10, 0, 0, 1, '0'),
(2313, 750, '20148', 'ads_idol_l_tv', 10, 0, 0, 1, '0');

Notes:

• The american idol page will be placed under the Themed furni section, if you no longer have this section, edit the code on the catalogue page, just change the number '351' to a different parent id.
• It may be a good idea to back up your database, just incase this fails for you.
• I did place the american idol header in the page, and a DJ teaser, if you can't view them, you will need to download them and place them in your c_images/catalogue (If your hosting your own DCR's..)

Save this as catalog_djshop_teaser1

Save this as idol

Any problems, post below!

 

[Deion]

The point of this is? Hotels already have this furni..

 

[Philly]

The point of this is? Hotels already have this furni..

Yes, but all of this furni appears in the promo page, which is only accessible by staff.
The point is, to help people who may not know how to do this..

 

[Deion]

Yes, but all of this furni appears in the promo page, which is only accessible by staff.
The point is, to help people who may not know how to do this..

That's why people release catalogue updates...

 

[JizzyCat ;3]

He is helping. Gtfo with the grief.

 

[Philly]

That's why people release catalogue updates...

That's nice.

 

[Deion]

He is helping. Gtfo with the grief.

Of course it's helping, the point is who.. This has been released already, in fact several times.. YEARS AGO.

 

[Iwassim]

someone needs to chillax​

 

[Philly]

Of course it's helping, the point is who.. This has been released already, in fact several times.. YEARS AGO.

Nuh-uh. I searched for it on multiple forums, found nothing ;'3

 

[Deion]

Nuh-uh. I searched for it on multiple forums, found nothing ;'3

It also comes in db when you start hotel... I would understand if you we're posting a tut on how to move furni, ndd add images to catalogue, but this is a release for something that's been there..

If you say this hadn't been released how do you have it ndd other hotels...

someone needs to chillax​

Someone needs to stay on-topic, that's probably why you have to keep recreating accounts..

 

[Philly]

It also comes in db when you start hotel... I would understand if you we're posting a tut on how to move furni, ndd add images to catalogue, but this is a release for something that's been there..

If you say this hadn't been released how do you have it ndd other hotels...


Someone needs to stay on-topic, that's probably why you have to keep recreating accounts..

The release is, a seperate catalogue page for American idol furni, which is originated in the promo page. I didn't say the furni hadn't been released, i said codes for a seperate page hadn't..