Not working SQL's

[Blues]

Catalog_items :
 
INSERT INTO `DBNAME`.`catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
('891030', 'PAGEID', '891030', 'CF_100000_purba', '100000', '0', '0', '1'),
('891031', 'PAGEID', '891031', 'CF_250000_purba', '250000', '0', '0', '1'),
('891032', 'PAGEID', '891032', 'CF_500000_purba', '500000', '0', '0', '1'),
('891033', 'PAGEID', '891033', 'CF_750000_purba', '750000', '0', '0', '1'),
('891034', 'PAGEID', '891034', 'CF_1000000_purb', '1000000', '0', '0', '1'),
 
Furniture :
 
INSERT INTO `DBNAME`.`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`, `is_arrow`) VALUES
('891030', 'CF_100000_purba', 'CF_100000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891030', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891031', 'CF_250000_purba', 'CF_250000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891031', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891032', 'CF_500000_purba', 'CF_500000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891032', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891033', 'CF_750000_purba', 'CF_750000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891033', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891034', 'CF_1000000_purb', 'CF_100000_purb', 's', '1', '1', '0.4', '1', '0', '0', '891034', '0', '1', '0', '1', '1', 'default', '1', '0', '0');
 
Furnidata :
 
["s","891030","CF_100000_purba","891030","0","1","1","0,0,0","Pink 100k Diamond","100k","","-1","-1"],
["s","891031","CF_250000_purba","891031","0","1","1","0,0,0","Green 250k Diamond","250k","","-1","-1"],
["s","891032","CF_500000_purba","891032","0","1","1","0,0,0","Red 500k Diamond","500k","","-1","-1"],
["s","891033","CF_750000_purba","891033","0","1","1","0,0,0","Orange 750k Diamond","750k","","-1","-1"],
["s","891034","CF_1000000_purb","891034","0","1","1","0,0,0","Blue 1M Diamond","1M","","-1","-1"],

But this is an amazing custom for exchange and i have a great use for it but thats not important can someone tell me why the SQL's on this arent working?

1. [Syn] Diamond Exchange [100k/250k/500k/750k/1M]
   
   
   Hey guys, Ive had this for ages but gave to a former friend and said I would wouldn't realese it, About a month ago "So called friend" Decided to uberly f*ck with me, So in regards, I have no respect for this low life, And here I bring you my Diamon Exchange. It was created about 3-4 months ago but it has been strictly with me and said person above. Unless someone did indeed rip it for themselfs, This is new.
   
   

   

   
   Download:

   You must be registered for see links

   
   
   [SQL IN DOWNLOAD]
   
   ~Values~
   Pink: 100k
   Green: 250k
   Red: 500k
   Orange: 750K
   Blue: 1M
   
   ** When exchanging, itll say "Exchange for 1c-100c" BUT when you exchange you will get the acual item ammount [Ex: Exchange a blue diamond, the prompt will say exchange for 1c? Click yes and you will get the full 1M coins] this is due to the fact you cant edit the prompts value to the correct number and have the swf work.​
   ​
   ​
   ​
   If someone will fic this? i will give you credits when i am done and have released the Catalogue i am trying to make Phoenix compatible and using RevCMS once we get RevEmu i will try and make it compatible with that of course​

 

[Nadeem1107]

post a new link plz cauz the current link is not working

 

[Spoderman]

I saw the DBNAME problem in the code, try this code.
Remember to replace PAGEID with the page id you want the furniture in.

Try this

INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
('891030', 'PAGEID', '891030', 'CF_100000_purba', '100000', '0', '0', '1'),
('891031', 'PAGEID', '891031', 'CF_250000_purba', '250000', '0', '0', '1'),
('891032', 'PAGEID', '891032', 'CF_500000_purba', '500000', '0', '0', '1'),
('891033', 'PAGEID', '891033', 'CF_750000_purba', '750000', '0', '0', '1'),
('891034', 'PAGEID', '891034', 'CF_1000000_purb', '1000000', '0', '0', '1'),
 
Furniture :
 
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`, `is_arrow`) VALUES
('891030', 'CF_100000_purba', 'CF_100000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891030', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891031', 'CF_250000_purba', 'CF_250000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891031', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891032', 'CF_500000_purba', 'CF_500000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891032', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891033', 'CF_750000_purba', 'CF_750000_purba', 's', '1', '1', '0.4', '1', '0', '0', '891033', '0', '1', '0', '1', '1', 'default', '1', '0', '0'),
('891034', 'CF_1000000_purb', 'CF_100000_purb', 's', '1', '1', '0.4', '1', '0', '0', '891034', '0', '1', '0', '1', '1', 'default', '1', '0', '0');

 

[Brought]

Problem was solved by the post above. It works now, I've tested it on my hotel.

 

[FunkyBohh]

The Sqls worked but in the catalouge it comes up as a box not the ctuall diamond Help Anyone?

 

[Spoderman]

The Sqls worked but in the catalouge it comes up as a box not the ctuall diamond Help Anyone?

Have you got the SWF for it in hof_furni?
Have you cleared your cache then tried?

 

[bingxuan2009]

Problem was solved by the post above. It works now, I've tested it on my hotel.

Mind sharing by uploading to a new link?

 

[subzerogamerz]

Hi there, can you by any chance upload the file again and share the link? This one appears to be broken.