Recoloured Red TV's! [CODED]

Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Recoloured Red TV's! [CODED]

    Hey RaGEZONE, it is I.

    Here to release my collection of recoloured Red TV's. I done 3 colours, but I don't what other colours to do. If you want any, please comment them below.

    Here is the screenie;



    Nice, right?

    Here's the codes:

    Catalogue_Items!
    Code:
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES 
    (987091, PAGEID, '987091', 'loptv1', 2500, 0, 0, 1),
    (987092, PAGEID, '987092', 'loptv2', 2500, 0, 0, 1),
    (987093, PAGEID, '987093', 'loptv3', 2500, 0, 0, 1),
    Furniture!

    Code:
    INSERT INTO `furniture` (`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`) VALUES
    (987091, 'loptv1', 'loptv1', 's', 1, 1, 1, '0', '0', '0', 987091, '1', '1', '1', '1', '1', 'default', 4, '0'),
    (987092, 'loptv2', 'loptv2', 's', 1, 1, 1, '0', '0', '0', 987092, '1', '1', '1', '1', '1', 'default', 4, '0'),
    (987093, 'loptv3', 'loptv3', 's', 1, 1, 1, '0', '0', '0', 987093, '1', '1', '1', '1', '1', 'default', 4, '0');
    Furnidata!

    Code:
    ["s","987091","loptv1","25824","0","1","1","0,0,0","Recoloured TV's","Created By </Loophole>","","-1","-1"],
    ["s","987092","loptv2","25824","0","1","1","0,0,0","Recoloured TV's","Created By </Loophole>","","-1","-1"],
    ["s","987093","loptv3","25824","0","1","1","0,0,0","Recoloured TV's","Created By </Loophole>","","-1","-1"],
    SWF Download - Finished 1 1.rar | localhostr.com - share &hellip; anything

    Hope you like.

    - </Loophole>

    Some credits to JohnHearfield for fixing up the SQL's.
    Last edited by zMagenta; 03-12-11 at 12:52 PM.


  2. #2
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Re: Recoloured Red TV's! [CODED]

    Wow, this is unique, nice.

  3. #3
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Re: Recoloured Red TV's! [CODED]

    Quote Originally Posted by JohnHearfield View Post
    Wow, this is unique, nice.
    Thanks John and SQL correct I think?

  4. #4
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Re: Recoloured Red TV's! [CODED]

    Quote Originally Posted by </Loophole> View Post
    Thanks John and SQL correct I think?
    Nope :)
    Code:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
    Stupid me, had to delete the ; at the end:

    PHP Code:
    INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES 
    ('987091''16''987091''loptv1''2500''0''0''1'),
    (
    '987092''16''987092''loptv2''2500''0''0''1'),
    (
    '987093''16''987093''loptv3''2500''0''0''1'); 
    Furniture ids are wrong, you cant have name of furni as it,
    PHP Code:
    INSERT INTO `furniture` (`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`) VALUES
    (987091'loptv1''loptv1''s'111'0''0''0'987091'1''1''1''1''1''default'4'0'),
    (
    987092'loptv2''loptv2''s'111'0''0''0'987092'1''1''1''1''1''default'4'0'),
    (
    987093'loptv3''loptv3''s'111'0''0''0'987093'1''1''1''1''1''default'4'0'); 

  5. #5
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Re: Recoloured Red TV's! [CODED]

    Erm, what?

  6. #6
    Eye Eye Capt'n Spheral is offline
    MemberRank
    May 2010 Join Date
    TumptonshireLocation
    2,488Posts

    Re: Recoloured Red TV's! [CODED]

    (987091, 'loptv1', 'loptv1', 's', 1, 1, 1, '0', '0', '0', loptv1, '1', '1', '1', '1', '1', 'default', 4, '0'),

    says that loptv1 is not a valid field, so you change to this;

    (987091, 'loptv1', 'loptv1', 's', 1, 1, 1, '0', '0', '0', 987091, '1', '1', '1', '1', '1', 'default', 4, '0'),

  7. #7
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Re: Recoloured Red TV's! [CODED]

    Better? And thanks.

  8. #8
    No longer active... -_- Tha Matrix is offline
    MemberRank
    Apr 2011 Join Date
    Void.Location
    1,090Posts

    Re: Recoloured Red TV's! [CODED]

    Awesome. Stole my Plan. but Anywayz- :D 8/10

  9. #9
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Re: Recoloured Red TV's! [CODED]

    Quote Originally Posted by </Matrix> View Post
    Awesome. Stole my Plan. but Anywayz- :D 8/10
    Haha, you ever wanna make some customs with me, just PM me. I've seen some of your work, not bad..

  10. #10
    Enthusiast JordanSel is offline
    MemberRank
    Nov 2011 Join Date
    48Posts

    Re: Recoloured Red TV's! [CODED]

    thnx and nice btw

  11. #11
    Member Aish is offline
    MemberRank
    Nov 2011 Join Date
    71Posts

    Re: Recoloured Red TV's! [CODED]

    Nice, Stole my idea too ^_^ Liked & +rep :D

  12. #12
    Alpha Member zMagenta is offline
    MemberRank
    Jun 2011 Join Date
    1,860Posts

    Re: Recoloured Red TV's! [CODED]

    LOL, Looks like I stole everyone's Idea. And thanks.

  13. #13
    Account Upgraded | Title Enabled! Pookie is offline
    MemberRank
    Mar 2011 Join Date
    1,038Posts

    Re: Recoloured Red TV's! [CODED]

    Good release. Try and use shading though.

  14. #14
    Novice Toni7 is offline
    MemberRank
    Nov 2011 Join Date
    2Posts

    Re: Recoloured Red TV's! [CODED]

    Its good :D ! SQL Its good... but the ; at the finish xD

  15. #15
    Account Upgraded | Title Enabled! ELSD is offline
    MemberRank
    Sep 2011 Join Date
    Chi-TownLocation
    1,213Posts

    Re: Recoloured Red TV's! [CODED]

    Dayummmmmmmmmmmmmmmmmmmmmmmmm niceeeee



Page 1 of 2 12 LastLast

Advertisement