Why is the hof_furni such a large size? My .SWF's zipped up is 180 odd.
Printable View
Why is the hof_furni such a large size? My .SWF's zipped up is 180 odd.
[strike]I get the following errors when import the SQL's:
Catalog_items.sql:
http://img0.www.suckmypic.net/img/q/...alog_items.png
Catalog_pages.sql:
http://img0.www.suckmypic.net/img/q/...alog_pages.png
ecotron_rewards.sql:
http://img0.www.suckmypic.net/img/A/...on_rewards.png
furniture.sql:
http://img0.www.suckmypic.net/img/v/.../furniture.png
How do I fix them? I've the newest licensed Phoenix (3.6.4) and a fresh database.
Or could someone give me a database where it's all done?[/strike]
First empty the catalog_items, catalog_pages, ecotron_rewards and furniture tables with this SQL query:
Then run this SQL query:Code:TRUNCATE `catalog_items`;
TRUNCATE `catalog_pages`;
TRUNCATE `ecotron_rewards`;
TRUNCATE `furniture`;
Code:ALTER TABLE `furniture` ADD `foot_figure` INT NOT NULL AFTER `is_arrow`
[strike]I've now empty the Catalog_items, Catalog_pages, ecotron_rewards and furniture tables.
Only the furniture.sql gives now an error:
http://img0.www.suckmypic.net/img/v/.../furniture.png
How do I fix it?[/strike]
Fixed with this SQL query:
Code:ALTER TABLE `furniture` ADD `foot_figure` INT NOT NULL AFTER `is_arrow`
i get this error [Err] 1062 - Duplicate entry '1' for key 'PRIMARY'
Does this work with Uber?
[strike]How can I make the custom furni only visible for VIP (rank 2)?
I've edited 'min_rank' to 2 and 'vip_only' to 1. But then the custom furni pages (furni will not load) is still visble for users with rank 1 (and the other furni such a "Furni By Range", "Furni By Theme", etc. invisible):
http://img0.www.suckmypic.net/img/G/...tN/Catalog.png
Here is my Catalog_pages.sql:
[SQL] Catalog_pages.sql - Pastebin.com
Or could someone give me Catalog_pages.sql where custom furni only is visible for VIP?
Thanks in advance. :thumbup:[/strike]
I've changed the order_num of "Custom Furni <33" to 600. It's working now. (You can't have anything thats a lower min-rank than another article below it.)
Empty the catalog_items, catalog_pages, ecotron_rewards and furniture tables with this SQL query:
Then run this SQL query:Code:TRUNCATE `catalog_items`;
TRUNCATE `catalog_pages`;
TRUNCATE `ecotron_rewards`;
TRUNCATE `furniture`;
Code:ALTER TABLE `furniture` ADD `foot_figure` INT NOT NULL AFTER `is_arrow`
Can you upload only sql PLEZzzzz
[strike]Does anyone know why the exchange is only visible for rank 2 or higher and the windows in a different category (by Rank 1)?
Rank 1:
http://i44.tinypic.com/20zv75x.png
Rank 2 or higher:
http://i42.tinypic.com/l86c1.png
The min_rank is 1 and vip_only is 0.
Thanks in advance.[/strike]
Fixed (You can't have anything thats a lower min-rank than another article below it, so I've deleted the VIP Catalogue):
Delete this in 'Catalog_items.sql':
Code:(30200761, 1234535, '30200761', 'VIPE1', 1000, 0, 0, 1),
(30200762, 1234535, '30200762', 'VIPE2', 1000, 0, 0, 1),
(80002223, 1234535, '80002223', 'avatar_effect78', 0, 1, 0, 1),
(80002224, 1234535, '80002224', 'avatar_effect79', 0, 1, 0, 1),
(80002225, 1234535, '80002225', 'avatar_effect80', 0, 1, 0, 1),
(80002226, 1234535, '80002226', 'avatar_effect81', 0, 1, 0, 1),
(80002227, 1234535, '80002227', 'avatar_effect82', 0, 1, 0, 1),
(80002228, 1234535, '80002228', 'avatar_effect83', 0, 1, 0, 1),
(80002229, 1234535, '80002229', 'avatar_effect84', 0, 1, 0, 1),
(80002230, 1234535, '80002230', 'avatar_effect85', 0, 1, 0, 1),
(80002231, 1234535, '80002231', 'avatar_effect86', 0, 1, 0, 1),
(80002232, 1234535, '80002232', 'avatar_effect87', 0, 1, 0, 1),
(80002233, 1234535, '80002233', 'avatar_effect88', 0, 1, 0, 1),
(80002234, 1234535, '80002234', 'avatar_effect89', 0, 1, 0, 1),
(80002235, 1234535, '80002235', 'avatar_effect90', 0, 1, 0, 1),
(80002236, 1234535, '80002236', 'avatar_effect91', 0, 1, 0, 1),
(80002237, 1234535, '80002237', 'avatar_effect92', 0, 1, 0, 1),
Delete this in 'Catalog_pages.sql':
Code:(1234535, 3, 'VIP Catalogue!', 3, 28, '1', '1', 2, '0', 69, 'default_3x3', 'catalog_header_VIPs', 'catalog_teaser_VIP', '', 'Thanks for buying Retro VIP! Here you will find rares exclusive to VIP! Feel free to do what you like with them! Thank you and ENJOY!', '', 'Click on a VIP item for more information..', '', '1'),
[strike]Can you read? I've already the 'min_rank' on 1 and 'vip_only' on 0. And also the 'visible' and 'enabled' is on 1.[/strike]
Fixed (You can't have anything thats a lower min-rank than another article below it, so I've deleted the VIP Catalogue):
Delete this in 'Catalog_items.sql':
Code:(30200761, 1234535, '30200761', 'VIPE1', 1000, 0, 0, 1),
(30200762, 1234535, '30200762', 'VIPE2', 1000, 0, 0, 1),
(80002223, 1234535, '80002223', 'avatar_effect78', 0, 1, 0, 1),
(80002224, 1234535, '80002224', 'avatar_effect79', 0, 1, 0, 1),
(80002225, 1234535, '80002225', 'avatar_effect80', 0, 1, 0, 1),
(80002226, 1234535, '80002226', 'avatar_effect81', 0, 1, 0, 1),
(80002227, 1234535, '80002227', 'avatar_effect82', 0, 1, 0, 1),
(80002228, 1234535, '80002228', 'avatar_effect83', 0, 1, 0, 1),
(80002229, 1234535, '80002229', 'avatar_effect84', 0, 1, 0, 1),
(80002230, 1234535, '80002230', 'avatar_effect85', 0, 1, 0, 1),
(80002231, 1234535, '80002231', 'avatar_effect86', 0, 1, 0, 1),
(80002232, 1234535, '80002232', 'avatar_effect87', 0, 1, 0, 1),
(80002233, 1234535, '80002233', 'avatar_effect88', 0, 1, 0, 1),
(80002234, 1234535, '80002234', 'avatar_effect89', 0, 1, 0, 1),
(80002235, 1234535, '80002235', 'avatar_effect90', 0, 1, 0, 1),
(80002236, 1234535, '80002236', 'avatar_effect91', 0, 1, 0, 1),
(80002237, 1234535, '80002237', 'avatar_effect92', 0, 1, 0, 1),
Delete this in 'Catalog_pages.sql':
Code:(1234535, 3, 'VIP Catalogue!', 3, 28, '1', '1', 2, '0', 69, 'default_3x3', 'catalog_header_VIPs', 'catalog_teaser_VIP', '', 'Thanks for buying Retro VIP! Here you will find rares exclusive to VIP! Feel free to do what you like with them! Thank you and ENJOY!', '', 'Click on a VIP item for more information..', '', '1'),
View 4NioEC.png on ScreenSnapr
For some reason when I update the ranks of all rares that I Want to not be shown to rank 4 as the min the other pages dont work at all for rank 1?
Does this fix the landscapes?
It really looks awesome :} Thanks
WoW, It's Great. Nice!
Wahoo! Finally a good catalogue
Thanks so much for this:thumbup:
Epic Catalog! :D
This Catalogue is very nice ! I like it <3
Love your catalogues, always have everythign up-to-date. I would like to see less non-english wording though, still great!
pr0 is all i have to say.
Hi, ^_^
Can you tell me what happen here? :):
http://forum.ragezone.com/attachment...1&d=1330951595
how do you add it to your hotel?
The easy part, i guess.
0. Download cata v6.zip -By Ryan
1. Go to your DB / Database
2. Drop table / Cata_page / Cata_items / Furniture /ecotron_rewards
3. Import the / Cata_page / Cata_items / Furniture /ecotron_rewards in your DB
4. Copy furnidata @ furniproduct to your r63 file , i guess XD
5. Enjoy !
Hak3 , yea i also got prob with this cata :mellow: