Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Q&A
Not working SQL's
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Blues" data-source="post: 107893" data-attributes="member: 17593"><p>[CODE]Catalog_items :</p><p> </p><p>INSERT INTO `DBNAME`.`catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES</p><p>('891030', 'PAGEID', '891030', 'CF_100000_purba', '100000', '0', '0', '1'),</p><p>('891031', 'PAGEID', '891031', 'CF_250000_purba', '250000', '0', '0', '1'),</p><p>('891032', 'PAGEID', '891032', 'CF_500000_purba', '500000', '0', '0', '1'),</p><p>('891033', 'PAGEID', '891033', 'CF_750000_purba', '750000', '0', '0', '1'),</p><p>('891034', 'PAGEID', '891034', 'CF_1000000_purb', '1000000', '0', '0', '1'),</p><p> </p><p>Furniture :</p><p> </p><p>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</p><p>('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'),</p><p>('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'),</p><p>('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'),</p><p>('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'),</p><p>('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');</p><p> </p><p>Furnidata :</p><p> </p><p>["s","891030","CF_100000_purba","891030","0","1","1","0,0,0","Pink 100k Diamond","100k","","-1","-1"],</p><p>["s","891031","CF_250000_purba","891031","0","1","1","0,0,0","Green 250k Diamond","250k","","-1","-1"],</p><p>["s","891032","CF_500000_purba","891032","0","1","1","0,0,0","Red 500k Diamond","500k","","-1","-1"],</p><p>["s","891033","CF_750000_purba","891033","0","1","1","0,0,0","Orange 750k Diamond","750k","","-1","-1"],</p><p>["s","891034","CF_1000000_purb","891034","0","1","1","0,0,0","Blue 1M Diamond","1M","","-1","-1"],</p><p>[/CODE]</p><p>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?</p><p> </p><ol> <li data-xf-list-type="ol"><span style="font-size: 18px"><strong>[Syn] Diamond Exchange [100k/250k/500k/750k/1M]</strong></span><br /> <br /> <p style="margin-left: 20px"><p style="text-align: center">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.<br /> <br /> <img src="http://img39.imageshack.us/img39/2294/diamondsa.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /><br /> Download: <a href="http://www.mediafire.com/?5g5ge85gc1f2dpb" target="_blank">Diamond Exchange.rar</a><br /> <br /> [SQL IN DOWNLOAD]<br /> <br /> ~Values~<br /> Pink: 100k<br /> Green: 250k<br /> Red: 500k<br /> Orange: 750K<br /> Blue: 1M<br /> <br /> ** 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.</p> </p> <p style="margin-left: 20px"><p style="text-align: center"> </p> </p> <p style="margin-left: 20px"><p style="text-align: center"> </p> </p> <p style="margin-left: 20px"><p style="text-align: center"> </p> </p> <p style="margin-left: 20px"><p style="text-align: center">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</p> </p> </li> </ol></blockquote><p></p>
[QUOTE="Blues, post: 107893, member: 17593"] [CODE]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"], [/CODE] 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? [LIST=1] [*][SIZE=5][B][Syn] Diamond Exchange [100k/250k/500k/750k/1M][/B][/SIZE] [INDENT=1][CENTER]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. [IMG]http://img39.imageshack.us/img39/2294/diamondsa.png[/IMG] Download: [URL='http://www.mediafire.com/?5g5ge85gc1f2dpb']Diamond Exchange.rar[/URL] [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.[/CENTER][/INDENT] [INDENT=1][CENTER] [/CENTER][/INDENT] [INDENT=1][CENTER] [/CENTER][/INDENT] [INDENT=1][CENTER] [/CENTER][/INDENT] [INDENT=1][CENTER]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[/CENTER][/INDENT] [/LIST] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Q&A
Not working SQL's
Top