FatalLulz catalogue SQL problems?

Results 1 to 6 of 6
  1. #1
    Member Aron123 is offline
    MemberRank
    Mar 2013 Join Date
    BelgiumLocation
    88Posts

    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.


  2. #2
    R.I.P Millercent FatalLulz is offline
    Grand MasterRank
    Nov 2012 Join Date
    AustraliaLocation
    2,240Posts

    Re: FatalLulz catalogue SQL problems?

    It's because 'amount' is set to 0 or you have not applied the furnidata in correct position.
    Last edited by FatalLulz; 27-02-15 at 10:01 PM.

  3. #3
    Member Aron123 is offline
    MemberRank
    Mar 2013 Join Date
    BelgiumLocation
    88Posts

    Re: FatalLulz catalogue SQL problems?

    Quote Originally Posted by FatalLulz View Post
    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.

  4. #4
    Member Aron123 is offline
    MemberRank
    Mar 2013 Join Date
    BelgiumLocation
    88Posts

    Re: FatalLulz catalogue SQL problems?

    Bump? :(

  5. #5
    R.I.P Millercent FatalLulz is offline
    Grand MasterRank
    Nov 2012 Join Date
    AustraliaLocation
    2,240Posts

    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.

  6. #6
    Member Aron123 is offline
    MemberRank
    Mar 2013 Join Date
    BelgiumLocation
    88Posts

    Re: FatalLulz catalogue SQL problems?

    Quote Originally Posted by FatalLulz View Post
    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...



Advertisement