Christmas Poster Early Release

Hello i made a Canvas/poster with a christmas picture on it.
Habmoon gave me some advice what i should use for the custom
for example the picture... :)

Screenie: Attachment 117735

Feel free to code it but keep some credit to me if u want to code it.

also i ripped a litle bit from habmoon's thread: http://forum.ragezone.com/f556/paul-...wf-sql-891340/



Regards-Coca Cola

Yeahh :D looks much better now.
The bear need to be re-pixeled though (atleast the outline) cause it's all blurry now. But it's good. :D
Nice work.

i will work on that thanks for the tip :)

Looks pretty better now, thanks for this :]

SWF: http://www.mediafire.com/?hr4ijkdwx49jjd6

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`, `is_arrow`) VALUES
(181820, 'cokeposter', 'cokeposter', 'i', 0, 0, 1, '1', '0', '0', 181820, '1', '1', '1', '1', '1', 'Default', 1, '0', '0');


INSERT INTO `catalog_items` (`id`, `page_id`, `item_ids`, `catalog_name`, `cost_credits`, `cost_pixels`, `cost_snow`, `amount`) VALUES
(181820, '41', '181820', 'Coca Cola Poster', '15', '0', '0', '1');


["i","181820","cokeposter","34082","","","","","Coca Cola Poster","Get in the festive spirit with Coca Cola™","","139281","4038"],

---

I edited the outline a bit on the polar bear, hope you don't mind btw :p

FIXED AND WORKING BY THE WAY.

Attachment 117793

Not sure if this is fully functional or whatever but,

PHP Code:

---

INSERT INTO `catalog_items` VALUES ('93756', '91', '93756', 'Christmas Poster', '100', '0', '0', '1', '0', '0'); 


---

PHP Code:

---

INSERT INTO `furniture` VALUES ('93756', 'Christmas Poster', 'cocacolaxmasposter', 's', '1', '1', '1', '0', '0', '0', '82689', '0', '1', '1', '1', '1', 'default', '1', '0', '0', '0', '0'); 


---

PHP Code:

---

["s","82689","cocacolaxmasposter","custom","0","1","1","0,0,0","Christmas Poster","Are you ready for christmas?","","-1","-1","","1"], 


---

Attachment 117790

EDIT: Appologies to Jess for the SQL's 2 minutes before me, hers are probably better but any errors feel free to use mine.

Quote:

---

Originally Posted by NathStanley

Appologies to Jess for the SQL's 2 minutes before me, hers are probably better but any errors feel free to use mine.

---

By the waaaaay, your SQLs won't work anymore with my SWF, as I've changed the name. Also your furnidata and furniture have 's' in it, when it should be 'i' for a wall item, maybe that's why it wouldn't work properly for you :3

Mine should work fine now, just added it to my hotel and it's looking good :) Good design, Coca Cola.

Many thanks for all the positive feedback and coding :)