Code: Selecteer alles
# Host: localhost Database: xxxxx
# ------------------------------------------------------
# Server version 4.0.21-nt-max
#
# Table structure for table phpbb_smilies
#
DROP TABLE IF EXISTS `phpbb_smilies`;
CREATE TABLE `phpbb_smilies` (
`smilies_id` smallint(5) unsigned NOT NULL auto_increment,
`code` varchar(50) default NULL,
`smile_url` varchar(100) default NULL,
`emoticon` varchar(75) default NULL,
PRIMARY KEY (`smilies_id`)
) TYPE=MyISAM;
#
# Dumping data for table phpbb_smilies
#
INSERT INTO `phpbb_smilies` VALUES (1,':D','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (2,':-D','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (3,':grin:','icon_biggrin.gif','Very Happy');
INSERT INTO `phpbb_smilies` VALUES (4,':)','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (5,':-)','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (6,':smile:','icon_smile.gif','Smile');
INSERT INTO `phpbb_smilies` VALUES (7,':(','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (8,':-(','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (9,':sad:','icon_sad.gif','Sad');
INSERT INTO `phpbb_smilies` VALUES (10,':o','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (11,':-o','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (12,':eek:','icon_surprised.gif','Surprised');
INSERT INTO `phpbb_smilies` VALUES (13,':shock:','icon_eek.gif','Shocked');
INSERT INTO `phpbb_smilies` VALUES (14,':?','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (15,':-?','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (16,':???:','icon_confused.gif','Confused');
INSERT INTO `phpbb_smilies` VALUES (17,'8)','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (18,'8-)','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (19,':cool:','icon_cool.gif','Cool');
INSERT INTO `phpbb_smilies` VALUES (20,':lol:','icon_lol.gif','Laughing');
INSERT INTO `phpbb_smilies` VALUES (21,':x','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (22,':-x','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (23,':mad:','icon_mad.gif','Mad');
INSERT INTO `phpbb_smilies` VALUES (24,':P','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (25,':-P','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (26,':razz:','icon_razz.gif','Razz');
INSERT INTO `phpbb_smilies` VALUES (27,':oops:','icon_redface.gif','Embarassed');
INSERT INTO `phpbb_smilies` VALUES (28,':cry:','icon_cry.gif','Crying or Very sad');
INSERT INTO `phpbb_smilies` VALUES (29,':evil:','icon_evil.gif','Evil or Very Mad');
INSERT INTO `phpbb_smilies` VALUES (30,':twisted:','icon_twisted.gif','Twisted Evil');
INSERT INTO `phpbb_smilies` VALUES (31,':roll:','icon_rolleyes.gif','Rolling Eyes');
INSERT INTO `phpbb_smilies` VALUES (32,':wink:','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (33,';)','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (34,';-)','icon_wink.gif','Wink');
INSERT INTO `phpbb_smilies` VALUES (35,':!:','icon_exclaim.gif','Exclamation');
INSERT INTO `phpbb_smilies` VALUES (36,':?:','icon_question.gif','Question');
INSERT INTO `phpbb_smilies` VALUES (37,':idea:','icon_idea.gif','Idea');
INSERT INTO `phpbb_smilies` VALUES (38,':arrow:','icon_arrow.gif','Arrow');
INSERT INTO `phpbb_smilies` VALUES (39,':|','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (40,':-|','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (41,':neutral:','icon_neutral.gif','Neutral');
INSERT INTO `phpbb_smilies` VALUES (42,':mrgreen:','icon_mrgreen.gif','Mr. Green');