-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:42 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `bmcforu_transfer`
--

-- --------------------------------------------------------

--
-- Table structure for table `smilie`
--

CREATE TABLE IF NOT EXISTS `smilie` (
  `smilieid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `smilietext` char(20) NOT NULL DEFAULT '',
  `smiliepath` char(100) NOT NULL DEFAULT '',
  `imagecategoryid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `displayorder` smallint(5) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=467 ;

--
-- Dumping data for table `smilie`
--

INSERT INTO `smilie` (`smilieid`, `title`, `smilietext`, `smiliepath`, `imagecategoryid`, `displayorder`) VALUES
(450, 'Track', ':Track:', 'images/smilies/Track.gif', 4, 3),
(449, 'Tongue2', ':tongue2:', 'images/smilies/tongue2.gif', 4, 2),
(448, 'Tmi', ':tmi:', 'images/smilies/tmi.gif', 4, 3),
(447, 'Taxi', ':taxi:', 'images/smilies/taxi.gif', 4, 4),
(446, 'Surrender', ':surrender:', 'images/smilies/surrender.gif', 4, 2),
(445, 'Superman', ':superman:', 'images/smilies/superman.gif', 4, 4),
(444, 'Streamer', ':streamer:', 'images/smilies/streamer.gif', 4, 2),
(443, 'Stan', ':stan:', 'images/smilies/stan.gif', 4, 2),
(442, 'Splat', ':splat:', 'images/smilies/splat.gif', 4, 2),
(441, 'Spiderman', ':spiderman:', 'images/smilies/spiderman.gif', 4, 4),
(440, 'Specialfred', ':specialfred:', 'images/smilies/specialfred.gif', 4, 2),
(439, 'Spam', ':spam:', 'images/smilies/spam.gif', 4, 4),
(438, 'Sorry', ':sorry:', 'images/smilies/sorry.gif', 4, 3),
(437, 'Soapbox', ':soapbox:', 'images/smilies/soapbox.gif', 4, 3),
(436, 'Snowball', ':snowball:', 'images/smilies/snowball.gif', 4, 2),
(435, 'Snore', ':snore:', 'images/smilies/snore.gif', 4, 2),
(434, 'Snoopy', ':snoopy:', 'images/smilies/snoopy.gif', 4, 2),
(239, 'Chewpopcorn', ':chewpopcorn:', 'images/smilies/chewpopcorn.gif', 4, 2),
(433, 'Skull', ':skull:', 'images/smilies/skull.gif', 4, 2),
(432, 'Singer', ':singer:', 'images/smilies/singer.gif', 4, 2),
(288, 'Apple', ':apple:', 'images/smilies/apple.gif', 4, 4),
(431, 'Sick', ':sick:', 'images/smilies/sick.gif', 4, 2),
(249, 'Frown', ':(', 'images/smilies/frown.gif', 4, 1),
(430, 'Shithappens', ':shithappens:', 'images/smilies/shithappens.gif', 4, 2),
(429, 'Scratch', ':scratch:', 'images/smilies/scratch.gif', 4, 2),
(428, 'Saywha', ':saywha:', 'images/smilies/saywha.gif', 4, 3),
(427, 'Salute', ':salute:', 'images/smilies/salute.gif', 4, 2),
(426, 'Rulez', ':rulez:', 'images/smilies/rulez.gif', 4, 3),
(234, 'Bump', ':bump:', 'images/smilies/bump.gif', 4, 2),
(425, 'Rudolph', ':rudolph:', 'images/smilies/rudolph.gif', 4, 2),
(424, 'Ruddi', ':ruddi:', 'images/smilies/ruddi.gif', 4, 2),
(423, 'Ripped', ':ripped:', 'images/smilies/ripped.gif', 4, 3),
(422, 'Ridinghorse', ':ridinghorse:', 'images/smilies/ridinghorse.gif', 4, 2),
(421, 'Redx', ':redx:', 'images/smilies/redx.gif', 4, 2),
(420, 'Reaper', ':reaper:', 'images/smilies/reaper.gif', 4, 2),
(248, 'Eek', ':eek:', 'images/smilies/eek.gif', 4, 1),
(419, 'Ranton', ':ranton:', 'images/smilies/ranton.gif', 4, 2),
(247, 'Dunce', ':dunce:', 'images/smilies/dunce.gif', 4, 2),
(418, 'Pow', ':pow:', 'images/smilies/pow.gif', 4, 2),
(417, 'Postwhore2', ':postwhore2:', 'images/smilies/postwhore2.gif', 4, 3),
(416, 'Postwhore', ':postwhore:', 'images/smilies/postwhore.gif', 4, 2),
(415, 'PirateDance', ':PirateDance:', 'images/smilies/PirateDance.gif', 4, 2),
(414, 'Pirate', ':pirate:', 'images/smilies/pirate.gif', 4, 2),
(413, 'Pics', ':pics:', 'images/smilies/pics.gif', 4, 3),
(412, 'Phone', ':phone:', 'images/smilies/phone.gif', 4, 2),
(411, 'Party2', ':party2:', 'images/smilies/party2.gif', 4, 2),
(410, 'Ozzy', ':ozzy:', 'images/smilies/ozzy.gif', 4, 2),
(409, 'Owned', ':owned:', 'images/smilies/owned.gif', 4, 2),
(408, 'Ohsnap2', ':ohsnap2:', 'images/smilies/ohsnap2.gif', 4, 3),
(246, 'Curses', ':curses:', 'images/smilies/curses.gif', 4, 2),
(287, 'AnimatedCrap', ':animatedCrap:', 'images/smilies/animatedCrap.gif', 4, 3),
(286, 'Angel2', ':angel2:', 'images/smilies/angel2.gif', 4, 2),
(236, 'Censored', ':censored:', 'images/smilies/censored.gif', 4, 2),
(235, 'Bye', ':bye:', 'images/smilies/bye.gif', 4, 2),
(233, 'Brb', ':brb:', 'images/smilies/brb.gif', 4, 2),
(231, 'Biggrin', ':D', 'images/smilies/biggrin.gif', 4, 1),
(232, 'Bling', ':bling:', 'images/smilies/bling.gif', 4, 3),
(230, 'Battingeyelashes', ':battingeyelashes:', 'images/smilies/battingeyelashes.gif', 4, 2),
(229, '2cents', ':2cents:', 'images/smilies/2cents.gif', 4, 2),
(407, 'Ohsnap', ':ohsnap:', 'images/smilies/ohsnap.gif', 4, 3),
(452, 'Turbo', ':turbo:', 'images/smilies/turbo.gif', 4, 2),
(406, 'Offtopic', ':offtopic:', 'images/smilies/offtopic.gif', 4, 3),
(405, 'Nxsmile', ':nxsmile:', 'images/smilies/nxsmile.gif', 4, 3),
(404, 'Number1', ':number1:', 'images/smilies/number1.gif', 4, 2),
(403, 'Notwork', ':notwork:', 'images/smilies/notwork.gif', 4, 3),
(402, 'Notsigned', ':notsigned:', 'images/smilies/notsigned.gif', 4, 3),
(401, 'Ninjabattle', ':ninjabattle:', 'images/smilies/ninjabattle.gif', 4, 2),
(400, 'Nascar', ':nascar:', 'images/smilies/nascar.gif', 4, 4),
(399, 'Myeyes', ':myeyes:', 'images/smilies/myeyes.gif', 4, 1),
(398, 'Mouth', ':mouth:', 'images/smilies/mouth.gif', 4, 2),
(397, 'Moped', ':moped:', 'images/smilies/moped.gif', 4, 2),
(396, 'Mob', ':mob:', 'images/smilies/mob.gif', 4, 2),
(395, 'Metalhead', ':metalhead:', 'images/smilies/metalhead.gif', 4, 2),
(285, 'Angel', ':angel:', 'images/smilies/angel.gif', 4, 2),
(394, 'Mechanic2', ':mechanic2:', 'images/smilies/mechanic2.gif', 4, 4),
(284, 'Angel (2)', ':angel (2):', 'images/smilies/angel (2).gif', 4, 1),
(283, 'Afro', ':afro:', 'images/smilies/afro.gif', 4, 2),
(282, '911', ':911:', 'images/smilies/911.gif', 4, 4),
(281, 'Poke', ':poke:', 'images/smilies/poke.gif', 4, 2),
(280, 'Coffee', ':coffee:', 'images/smilies/coffee.gif', 4, 2),
(279, 'You Rock', ':You_Rock:', 'images/smilies/You_Rock.gif', 4, 3),
(278, 'Wtg', ':wtg:', 'images/smilies/wtg.gif', 4, 1),
(277, 'Wink', ';)', 'images/smilies/wink.gif', 4, 1),
(276, 'Welcomebmc', ':welcomebmc:', 'images/smilies/welcomebmc.gif', 4, 3),
(275, 'Welcome', ':welcome:', 'images/smilies/welcome.gif', 4, 3),
(274, 'Sup', ':sup:', 'images/smilies/sup.gif', 4, 4),
(273, 'Kiss', ':kiss:', 'images/smilies/kiss.gif', 4, 4),
(272, 'Goodevil', ':goodevil:', 'images/smilies/goodevil.gif', 4, 4),
(271, 'Weeeeeeeeeeeeee', ':weeeeeeeeeeeeee:', 'images/smilies/weeeeeeeeeeeeee.gif', 4, 2),
(270, 'Wave2', ':wave2:', 'images/smilies/wave2.gif', 4, 1),
(269, 'W00t', ':w00t:', 'images/smilies/w00t.gif', 4, 1),
(393, 'Mechanic', ':mechanic:', 'images/smilies/mechanic.gif', 4, 4),
(392, 'Mag', ':mag:', 'images/smilies/mag.gif', 4, 2),
(391, 'Love', ':love:', 'images/smilies/love.gif', 4, 1),
(390, 'Loser', ':loser:', 'images/smilies/loser.gif', 4, 2),
(389, 'Lol3', ':lol3:', 'images/smilies/lol3.gif', 4, 3),
(388, 'Lol2', ':lol2:', 'images/smilies/lol2.gif', 4, 3),
(387, 'Lockdance', ':lockdance:', 'images/smilies/lockdance.gif', 4, 4),
(386, 'Lisa', ':lisa:', 'images/smilies/lisa.gif', 4, 4),
(245, 'Cowboy', ':cowboy:', 'images/smilies/cowboy.gif', 4, 2),
(451, 'Ttiwwp', ':ttiwwp:', 'images/smilies/ttiwwp.gif', 4, 3),
(244, 'Cop', ':cop:', 'images/smilies/cop.gif', 4, 2),
(385, 'Lick', ':lick:', 'images/smilies/lick.gif', 4, 2),
(384, 'Liar', ':liar:', 'images/smilies/liar.gif', 4, 2),
(383, 'Kyle', ':kyle:', 'images/smilies/kyle.gif', 4, 2),
(382, 'Kungfu', ':kungfu:', 'images/smilies/kungfu.gif', 4, 2),
(381, 'Kneelsuckers', ':kneelsuckers:', 'images/smilies/kneelsuckers.gif', 4, 3),
(380, 'Kisses', ':kisses:', 'images/smilies/kisses.gif', 4, 2),
(379, 'Kewl', ':kewl:', 'images/smilies/kewl.gif', 4, 3),
(378, 'Joker', ':joker:', 'images/smilies/joker.gif', 4, 2),
(268, 'Tongue', ':tongue:', 'images/smilies/tongue.gif', 4, 1),
(377, 'Jerry', ':jerry:', 'images/smilies/jerry.gif', 4, 3),
(454, 'Typo', ':typo:', 'images/smilies/typo.gif', 4, 2),
(376, 'Itchy Scratchy', ':itchy-scratchy:', 'images/smilies/itchy-scratchy.gif', 4, 4),
(375, 'Irule', ':irule:', 'images/smilies/irule.gif', 4, 2),
(243, 'Cool', ':cool:', 'images/smilies/cool.gif', 4, 1),
(374, 'Imnew', ':imnew:', 'images/smilies/imnew.gif', 4, 3),
(373, 'Igiveup', ':igiveup:', 'images/smilies/igiveup.gif', 4, 2),
(372, 'Idea2', ':idea2:', 'images/smilies/idea2.gif', 4, 2),
(371, 'Idea', ':idea:', 'images/smilies/idea.gif', 4, 2),
(370, 'Iagree', ':iagree:', 'images/smilies/iagree.gif', 4, 3),
(369, 'Hmm', ':hmm:', 'images/smilies/hmm.gif', 4, 3),
(368, 'Hittingthefan', ':hittingthefan:', 'images/smilies/hittingthefan.gif', 4, 2),
(238, 'Cheerleader', ':cheerleader:', 'images/smilies/cheerleader.gif', 4, 2),
(237, 'Cheer', ':cheer:', 'images/smilies/cheer.gif', 4, 2),
(367, 'Hijacked', ':hijacked:', 'images/smilies/hijacked.gif', 4, 3),
(242, 'Confused', ':confused:', 'images/smilies/confused.gif', 4, 1),
(366, 'Hide', ':hide:', 'images/smilies/hide.gif', 4, 2),
(365, 'Hatoff', ':hatoff:', 'images/smilies/hatoff.gif', 4, 2),
(364, 'Hashy', ':hashy:', 'images/smilies/hashy.gif', 4, 2),
(363, 'Happybday2', ':happybday2:', 'images/smilies/happybday2.gif', 4, 3),
(241, 'Computersmash', ':computersmash:', 'images/smilies/computersmash.gif', 4, 2),
(362, 'Handclap', ':handclap:', 'images/smilies/handclap.gif', 4, 2),
(361, 'Hammer', ':hammer:', 'images/smilies/hammer.gif', 4, 2),
(360, 'Hahaha', ':hahaha:', 'images/smilies/hahaha.gif', 4, 2),
(359, 'Guitar', ':guitar:', 'images/smilies/guitar.gif', 4, 2),
(358, 'GrowUp', ':GrowUp:', 'images/smilies/GrowUp.gif', 4, 3),
(453, 'Turtleride', ':turtleride:', 'images/smilies/turtleride.gif', 4, 2),
(267, 'Tomato', ':tomato:', 'images/smilies/tomato.gif', 4, 2),
(266, 'Thumbsup', ':thumbsup:', 'images/smilies/thumbsup.gif', 4, 2),
(357, 'Grouphug', ':grouphug:', 'images/smilies/grouphug.gif', 4, 2),
(265, 'Thankyousign', ':ty:', 'images/smilies/thankyousign.gif', 4, 3),
(356, 'Grinking', ':grinking:', 'images/smilies/grinking.gif', 4, 1),
(355, 'Google', ':google:', 'images/smilies/google.gif', 4, 3),
(354, 'Godbless', ':godbless:', 'images/smilies/godbless.gif', 4, 4),
(353, 'Glowing Star', ':glowing_star:', 'images/smilies/glowing_star.gif', 4, 2),
(264, 'Smile', ':)', 'images/smilies/smile.gif', 4, 1),
(263, 'Shrug', ':shrug:', 'images/smilies/shrug.gif', 4, 2),
(352, 'Geisha', ':geisha:', 'images/smilies/geisha.gif', 4, 2),
(351, 'Gayfight', ':gayfight:', 'images/smilies/gayfight.gif', 4, 2),
(262, 'Roses', ':roses:', 'images/smilies/roses.gif', 4, 2),
(261, 'Rolleyes', ':rolleyes:', 'images/smilies/rolleyes.gif', 4, 1),
(350, 'Fullmoon', ':fullmoon:', 'images/smilies/fullmoon.gif', 4, 2),
(260, 'Redface', ':redface:', 'images/smilies/redface.gif', 4, 1),
(349, 'Fryingpan', ':fryingpan:', 'images/smilies/fryingpan.gif', 4, 2),
(348, 'Flirty', ':flirty:', 'images/smilies/flirty.gif', 4, 2),
(347, 'Flame', ':flame:', 'images/smilies/flame.gif', 4, 4),
(259, 'Queen', ':queen:', 'images/smilies/queen.gif', 4, 2),
(258, 'Puke', ':puke:', 'images/smilies/puke.gif', 4, 2),
(346, 'Flag1', ':flag1:', 'images/smilies/flag1.gif', 4, 4),
(345, 'Fish', ':fish:', 'images/smilies/fish.gif', 4, 4),
(344, 'Fireman', ':fireman:', 'images/smilies/fireman.gif', 4, 2),
(343, 'Fired', ':fired:', 'images/smilies/fired.gif', 4, 4),
(342, 'Fightingcomputer', ':fightingcomputer:', 'images/smilies/fightingcomputer.gif', 4, 2),
(341, 'Fighting', ':fighting:', 'images/smilies/fighting.gif', 4, 2),
(340, 'Female', ':female:', 'images/smilies/female.gif', 4, 2),
(339, 'Eplus2', ':eplus2:', 'images/smilies/eplus2.gif', 4, 2),
(338, 'Electric', ':electric:', 'images/smilies/electric.gif', 4, 2),
(240, 'Chillpill', ':chillpill:', 'images/smilies/chillpill.gif', 4, 2),
(337, 'Eeknew', ':eeknew:', 'images/smilies/eeknew.gif', 4, 1),
(336, 'Eek3', ':eek3:', 'images/smilies/eek3.gif', 4, 2),
(335, 'Eek2', ':eek2:', 'images/smilies/eek2.gif', 4, 4),
(334, 'Eager', ':eager:', 'images/smilies/eager.gif', 4, 1),
(333, 'Dump', ':dump:', 'images/smilies/dump.gif', 4, 4),
(332, 'Drums', ':drums:', 'images/smilies/drums.gif', 4, 2),
(331, 'Drool', ':drool:', 'images/smilies/drool.gif', 4, 2),
(330, 'Driver', ':driver:', 'images/smilies/driver.gif', 4, 2),
(329, 'Drag', ':drag:', 'images/smilies/drag.gif', 4, 4),
(328, 'Devilhorns', ':devilhorns:', 'images/smilies/devilhorns.gif', 4, 2),
(327, 'Deviation', ':deviation:', 'images/smilies/deviation.gif', 4, 2),
(326, 'Darkside', ':darkside:', 'images/smilies/darkside.gif', 4, 3),
(325, 'Cry2', ':cry2:', 'images/smilies/cry2.gif', 4, 1),
(324, 'Cool2', ':cool2:', 'images/smilies/cool2.gif', 4, 1),
(323, 'Cloud9', ':cloud9:', 'images/smilies/cloud9.gif', 4, 2),
(322, 'Closed', ':closed:', 'images/smilies/closed.gif', 4, 3),
(321, 'Clap', ':clap:', 'images/smilies/clap.gif', 4, 2),
(320, 'Chirp', ':chirp:', 'images/smilies/chirp.gif', 4, 2),
(319, 'Chairshot', ':chairshot:', 'images/smilies/chairshot.gif', 4, 2),
(318, 'Catroar', ':catroar:', 'images/smilies/catroar.gif', 4, 2),
(317, 'Cartman', ':cartman:', 'images/smilies/cartman.gif', 4, 2),
(316, 'Buttkick', ':buttkick:', 'images/smilies/buttkick.gif', 4, 2),
(315, 'Burnout', ':burnout:', 'images/smilies/burnout.gif', 4, 2),
(314, 'Bulb', ':bulb:', 'images/smilies/bulb.gif', 4, 2),
(313, 'Bucs', ':bucs:', 'images/smilies/bucs.gif', 4, 3),
(312, 'Btchfight', ':btchfight:', 'images/smilies/btchfight.gif', 4, 2),
(311, 'Bs', ':bs:', 'images/smilies/bs.gif', 4, 3),
(310, 'Boxing', ':boxing:', 'images/smilies/boxing.gif', 4, 2),
(257, 'Newbie', ':newbie:', 'images/smilies/newbie.gif', 4, 2),
(309, 'Bow2', ':bow2:', 'images/smilies/bow2.gif', 4, 2),
(308, 'Bow', ':bow:', 'images/smilies/bow.gif', 4, 1),
(307, 'Boohoo', ':boohoo:', 'images/smilies/boohoo.gif', 4, 2),
(306, 'Booboo', ':booboo:', 'images/smilies/booboo.gif', 4, 3),
(305, 'Blingbling', ':blingbling:', 'images/smilies/blingbling.gif', 4, 2),
(304, 'Blah', ':blah:', 'images/smilies/blah.gif', 4, 2),
(303, 'Birthday', ':birthday:', 'images/smilies/birthday.gif', 4, 3),
(302, 'Biggrinnew', ':biggrinnew:', 'images/smilies/biggrinnew.gif', 4, 22),
(301, 'Beer', ':beer:', 'images/smilies/beer.gif', 4, 2),
(300, 'Beach', ':beach:', 'images/smilies/beach.gif', 4, 4),
(256, 'Mickey', ':mickey:', 'images/smilies/mickey.gif', 4, 2),
(299, 'Batman', ':batman:', 'images/smilies/batman.gif', 4, 4),
(298, 'Bat', ':bat:', 'images/smilies/bat.gif', 4, 2),
(255, 'Mad', ':mad:', 'images/smilies/mad.gif', 4, 1),
(254, 'Luv', ':luv:', 'images/smilies/luv.gif', 4, 2),
(297, 'Bart', ':bart:', 'images/smilies/bart.gif', 4, 2),
(296, 'Banned', ':banned:', 'images/smilies/banned.gif', 4, 4),
(295, 'Banhim', ':banhim:', 'images/smilies/banhim.gif', 4, 3),
(253, 'Hug', ':hug:', 'images/smilies/hug.gif', 4, 1),
(252, 'Highfive', ':highfive:', 'images/smilies/highfive.gif', 4, 1),
(251, 'Headbang', ':headbang:', 'images/smilies/headbang.gif', 4, 1),
(250, 'Happybday', ':happybday:', 'images/smilies/happybday.gif', 4, 3),
(294, 'Banghead', ':banghead:', 'images/smilies/banghead.gif', 4, 2),
(293, 'Banana', ':banana:', 'images/smilies/banana.gif', 4, 2),
(292, 'Balloon', ':balloon:', 'images/smilies/balloon.gif', 4, 2),
(291, 'Badmood', ':badmood:', 'images/smilies/badmood.gif', 4, 1),
(290, 'Badair', ':badair:', 'images/smilies/badair.gif', 4, 2),
(289, 'Baby', ':baby:', 'images/smilies/baby.gif', 4, 2),
(455, 'User', ':user:', 'images/smilies/user.gif', 4, 2),
(456, 'Vader', ':vader:', 'images/smilies/vader.gif', 4, 2),
(457, 'Viking', ':viking:', 'images/smilies/viking.gif', 4, 2),
(458, 'Wax', ':wax:', 'images/smilies/wax.gif', 4, 2),
(459, 'Werd', ':werd:', 'images/smilies/werd.gif', 4, 3),
(460, 'Whisper', ':whisper:', 'images/smilies/whisper.gif', 4, 2),
(461, 'Woot', ':woot:', 'images/smilies/woot.gif', 4, 3),
(462, 'Woot2', ':woot2:', 'images/smilies/woot2.gif', 4, 1),
(463, 'Wrongforum', ':wrongforum:', 'images/smilies/wrongforum.gif', 4, 3),
(464, 'Ww', ':ww:', 'images/smilies/ww.gif', 4, 4),
(465, 'domo', ':domo:', 'images/smilies/domo.gif', 4, 2),
(466, 'Thumbs Up', ':t)', 'images/smilies/thumbs1.gif', 4, 1);