How do i make a VIP catalogue? R63 [RevCMS]

[Vezel]

Hi, as the title sais i want to know how to add a VIP catalogue for the people that buys VIP. I havnt found any tutorials for that so does anyone know what i should do?

[MentaL]

[haziq5207]

edit from ur database....
add a catalogue page and set up the rank....

[Vezel]

edit from ur database....
add a catalogue page and set up the rank....

Could you please tell me step by step? what should i put on ID?

[haziq5207]

Could you please tell me step by step? what should i put on ID?

Try this

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
(106, -1, 'VIP Catalogue', 1, 1, '1', '1', 2, '0', 110, 'default_3x3', '', '', '', '', '', '', '', '1', '', '');

[Vezel]

Try this

Ok, now i got a catalouge for VIP, but how do i add stuffs for it? thanks!

[haziq5207]

go to catalogue items....and change the page id....

[Vezel]

go to catalogue items....and change the page id....

what should i take as page id?

[haziq5207]

if u copy mine sql...so it will be 106....

[Vezel]

if u copy mine sql...so it will be 106....

Ok thanks, but when i search for my rares like black dragon lamp it dosnt find them...

[haziq5207]

hmm....search at database??? or in client??

[Vezel]

hmm....search at database??? or in client??

I search in Navicat for MySQL so in database, and also. How do i change rare of the week, since i cant find any rares except thrones in my database i dont know how i can change it. thanks again!

[haziq5207]

hmm...i cant help with that problem...coz u must search it 1 by 1...just find it....page id for rare of the week is 16 i guess......

[Jess]

Everything in your database isn't necessarily named under its catalogue name.
You also have around 4 pages of furni in your catalog_items, if you look at the bottom right in your table there's little arrows taking you to the next page.
If you click the "page_id" column and then click "sort ascending" it will sort by page_id. Go onto page 2 using your little arrows. Rares are on pages 94 and 105. Page 94 has Rares like the Nellies, Throne, Samovar, DJ, Parasols, etc. Page 105 has all the different coloured Dragons, Pillows, ICMs, etc.

To change the Weekly Rare, find the Rare you want from these pages and change the page_id to 16. Number 16 is the page_id of Weekly Rare. You should also probably change the cost_credits because you don't want them being too cheap.
To remove the Parasols or whatever's in the Weekly Rare atm, go back onto page 1 using your arrows and scroll to the top, then go down until you find "page_id" as 16, it'll be right after all the wallpapers and floors (there's a lot of them). Change the IDs of these to 94 and then you're done.
:update_items and :update_catalogue in the hotel and your Weekly will be changed. Remember when changing it the week after to put your current Weekly Rare furni back to page_id 94/105. If you delete it it will be gone from your catalogue.

[FullmetalPride]

Everything in your database isn't necessarily named under its catalogue name.
You also have around 4 pages of furni in your catalog_items, if you look at the bottom right in your table there's little arrows taking you to the next page.
If you click the "page_id" column and then click "sort ascending" it will sort by page_id. Go onto page 2 using your little arrows. Rares are on pages 94 and 105. Page 94 has Rares like the Nellies, Throne, Samovar, DJ, Parasols, etc. Page 105 has all the different coloured Dragons, Pillows, ICMs, etc.

To change the Weekly Rare, find the Rare you want from these pages and change the page_id to 16. Number 16 is the page_id of Weekly Rare. You should also probably change the cost_credits because you don't want them being too cheap.
To remove the Parasols or whatever's in the Weekly Rare atm, go back onto page 1 using your arrows and scroll to the top, then go down until you find "page_id" as 16, it'll be right after all the wallpapers and floors (there's a lot of them). Change the IDs of these to 94 and then you're done.
:update_items and :update_catalogue in the hotel and your Weekly will be changed. Remember when changing it the week after to put your current Weekly Rare furni back to page_id 94/105. If you delete it it will be gone from your catalogue.

..

Why would you post this :l


If you want to create a VIP catalog, set the VIP rank to '2' and create the min_rank as '2' for the catalog page :)

[Jess]

..

Why would you post this :l


If you want to create a VIP catalog, set the VIP rank to '2' and create the min_rank as '2' for the catalog page :)

Because in his other posts he's wrote:

1. Ok thanks, but when i search for my rares like black dragon lamp it dosnt find them...

2. I search in Navicat for MySQL so in database, and also. How do i change rare of the week, since i cant find any rares except thrones in my database i dont know how i can change it. thanks again!

So I was just attempting to help him. If you don't like what I comment, then there's just no need to reply to it. I'm just trying to help someone who doesn't understand by trying to put it in the simplest terms because he doesn't seem to understand.

[Vezel]

Because in his other posts he's wrote:

1. Ok thanks, but when i search for my rares like black dragon lamp it dosnt find them...

2. I search in Navicat for MySQL so in database, and also. How do i change rare of the week, since i cant find any rares except thrones in my database i dont know how i can change it. thanks again!



So I was just attempting to help him. If you don't like what I comment, then there's just no need to reply to it. I'm just trying to help someone who doesn't understand by trying to put it in the simplest terms because he doesn't seem to understand.

Worked! Thanks

[Jess]

Anytime :)