FatalLulz catalogue SQL problems?
Dont know if that is the right titel for the problem im having, but I saw some cool customs and wanted to get the SQL's from it.
After installing the SQL's on my main server, nothing is showing in the catalogue, not even a BOX.
http://prntscr.com/6ahfzb
I'll give you a look at one of the custom I tried to add:
Furniture:
Code:
INSERT INTO `furniture` (`id`, `flat_id`, `public_name`, `item_name`, `type`, `width`, `length`, `stack_height`, `can_stack`, `can_sit`, `is_walkable`, `sprite_id`, `allow_recycle`, `allow_trade`, `allow_marketplace_sell`, `allow_gift`, `allow_inventory_stack`, `interaction_type`, `interaction_modes_count`, `vending_ids`, `stack_multiplier`, `subscriber`, `effectid`) VALUES
(972814, -1, 'livtoe', 'livtoe', 's', 1, 1, '1', '0', '1', '0', 2458335, '0', '1', '1', '1', '1', 'default', 1, '0', '0', '0', 0);
Catalog_item:
Code:
INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_belcredits`, `cost_loyalty`, `cost_duckets`, `amounts`, `achievement`, `song_id`, `limited_sells`, `limited_stack`, `offer_active`, `club_only`, `extradata`, `badge`) VALUES
(972814, 6969, '972814', 'livtoe', 5, 0, 0, 0, '1', 0, 0, 0, 0, '1', '0', '0', ''),
Furnidata.xml:
Code:
<furnitype id="2458335" classname="livtoe">
<revision>49500</revision>
<defaultdir>0</defaultdir>
<xdim>1</xdim>
<ydim>1</ydim>
<partcolors>
<color>0</color>
<color>0</color>
<color>0</color>
</partcolors>
<name>livtoe</name>
<description></description>
<adurl/>
<offerid>-1</offerid>
<buyout>1</buyout>
<rentofferid>-1</rentofferid>
<rentbuyout>0</rentbuyout>
<bc>1</bc>
<customparams/>
<specialtype>1</specialtype>
<canstandon>0</canstandon>
<cansiton>1</cansiton>
<canlayon>0</canlayon>
</furnitype>
SWF is in the map 49500.
Tried everything but dont get a solution.
Re: FatalLulz catalogue SQL problems?
It's because 'amount' is set to 0 or you have not applied the furnidata in correct position.
Re: FatalLulz catalogue SQL problems?
Quote:
Originally Posted by
FatalLulz
It's because 'amount' is set to 0 or you have not applied the furnidata in correct position.
Amount is all set to 1, furnidata is in correct poistion. I even replaced my furnidata with yours, did not change anything... still getting nothing in the catalogue.
Re: FatalLulz catalogue SQL problems?
Re: FatalLulz catalogue SQL problems?
Seems like a miss config. Check all id's are correct, check page is enabled to 1, check that the page Id is good. Try adding it to a page that already exists.
Re: FatalLulz catalogue SQL problems?
Quote:
Originally Posted by
FatalLulz
Seems like a miss config. Check all id's are correct, check page is enabled to 1, check that the page Id is good. Try adding it to a page that already exists.
Even when replacing the furni to another existing page the furniture neiter shows up on that page...