Mood Swings Icon Set + Query Install

[Nexus]

I figured I might as well give you all a useful tutorial which I made the members of our forum host. It will save you some time and make your forum a little more interesting. This is for those who wish to have the Mood Swings Modification installed. Once you get the mod installed follow these instructions:

This is those who have FTP Access. Be sure to backup all your files before making any modifications.​

My favorite Mood Swings Icon Set (The SQL query below works with this set only - if you have another mood swings icon set, then you'll have to play around with the query by modifying the file names to match your set):
Source page

Also, once you save those images to the correct directory (described in the Mood Swings phpbb Modification), use the following SQL to automate their insertion:

INSERT INTO phpbb_moods VALUES (7,'Aggressive','Aggressive')
INSERT INTO phpbb_moods VALUES (8,'Alienated,'Alienated')
INSERT INTO phpbb_moods VALUES (9'Amazed,'Amazed')
INSERT INTO phpbb_moods VALUES (10,'Amused,'Amused')
INSERT INTO phpbb_moods VALUES (11,'Angelic,'Angelic')
INSERT INTO phpbb_moods VALUES (12,'Angry,'Angry')
INSERT INTO phpbb_moods VALUES (13,'Apelike,'Apelike')
INSERT INTO phpbb_moods VALUES (14,'Artistic,'Artistic')
INSERT INTO phpbb_moods VALUES (15,'Asleep,'Asleep')
INSERT INTO phpbb_moods VALUES (16,'Balanced,'Balanced')
INSERT INTO phpbb_moods VALUES (17,'Banhappy,'Banhappy')
INSERT INTO phpbb_moods VALUES (18,'Bashful,'Bashful')
INSERT INTO phpbb_moods VALUES (19,'Bitching,'Bitching')
INSERT INTO phpbb_moods VALUES (20,'Blah,'Blah')
INSERT INTO phpbb_moods VALUES (21,'Bookworm,'Bookworm')
INSERT INTO phpbb_moods VALUES (22,'Bored,'Bored')
INSERT INTO phpbb_moods VALUES (23,'Breezy,'Breezy')
INSERT INTO phpbb_moods VALUES (24,'Brooding,'Brooding')
INSERT INTO phpbb_moods VALUES (25,'Busy,'Busy')
INSERT INTO phpbb_moods VALUES (26,'Buzzed,'Buzzed')
INSERT INTO phpbb_moods VALUES (27,'Chatty,'Chatty')
INSERT INTO phpbb_moods VALUES (28,'Cheeky,'Cheeky')
INSERT INTO phpbb_moods VALUES (29,'Cheerful,'Cheerful')
INSERT INTO phpbb_moods VALUES (30,'Cloud_9,'Cloud_9')
INSERT INTO phpbb_moods VALUES (31,'Cold,'Cold')
INSERT INTO phpbb_moods VALUES (32,'Coldturkey,'Coldturkey')
INSERT INTO phpbb_moods VALUES (33,'Confused,'Confused')
INSERT INTO phpbb_moods VALUES (34,'Cool,'Cool')
INSERT INTO phpbb_moods VALUES (35,'Crappy,'Crappy')
INSERT INTO phpbb_moods VALUES (36,'Creative,'Creative')
INSERT INTO phpbb_moods VALUES (37,'Curious,'Curious')
INSERT INTO phpbb_moods VALUES (38,'Cynical,'Cynical')
INSERT INTO phpbb_moods VALUES (39,'Daring,'Daring')
INSERT INTO phpbb_moods VALUES (40,'Dead,'Dead')
INSERT INTO phpbb_moods VALUES (41,'Depressed,'Depressed')
INSERT INTO phpbb_moods VALUES (42,'Devilish,'Devilish')
INSERT INTO phpbb_moods VALUES (43,'Disagree,'Disagree')
INSERT INTO phpbb_moods VALUES (44,'Doh,'Doh')
INSERT INTO phpbb_moods VALUES (45,'Doubtful,'Doubtful')
INSERT INTO phpbb_moods VALUES (46,'Dramaqueen,'Dramaqueen')
INSERT INTO phpbb_moods VALUES (47,'Dreaming,'Dreaming')
INSERT INTO phpbb_moods VALUES (48,'Drunk,'Drunk')
INSERT INTO phpbb_moods VALUES (49,'Elated,'Elated')
INSERT INTO phpbb_moods VALUES (50,'Energetic,'Energetic')
INSERT INTO phpbb_moods VALUES (51,'Fiendish,'Fiendish')
INSERT INTO phpbb_moods VALUES (52,'Fine,'Fine')
INSERT INTO phpbb_moods VALUES (53,'Flirty,'Flirty')
INSERT INTO phpbb_moods VALUES (54,'Gloomy,'Gloomy')
INSERT INTO phpbb_moods VALUES (55,'Goofy,'Goofy')
INSERT INTO phpbb_moods VALUES (56,'Grumpy,'Grumpy')
INSERT INTO phpbb_moods VALUES (57,'Happy,'Happy')
INSERT INTO phpbb_moods VALUES (58,'Horny,'Horny')
INSERT INTO phpbb_moods VALUES (59,'Hot,'Hot')
INSERT INTO phpbb_moods VALUES (60,'Hungover,'Hungover')
INSERT INTO phpbb_moods VALUES (61,'In-Love,'In-Love')
INSERT INTO phpbb_moods VALUES (62,'Innocent,'Innocent')
INSERT INTO phpbb_moods VALUES (63,'Inpain,'Inpain')
INSERT INTO phpbb_moods VALUES (64,'Insomnious,'Insomnious')
INSERT INTO phpbb_moods VALUES (65,'Inspired,'Inspired')
INSERT INTO phpbb_moods VALUES (66,'Lonely,'Lonely')
INSERT INTO phpbb_moods VALUES (67,'Lucky,'Lucky')
INSERT INTO phpbb_moods VALUES (68,'Lurking,'Lurking')
INSERT INTO phpbb_moods VALUES (69,'Mellow,'Mellow')
INSERT INTO phpbb_moods VALUES (70,'Mischievious,'Mischievious')
INSERT INTO phpbb_moods VALUES (71,'Mondayblues,'Mondayblues')
INSERT INTO phpbb_moods VALUES (72,'Musical,'Musical')
INSERT INTO phpbb_moods VALUES (73,'Nerdy,'Nerdy')
INSERT INTO phpbb_moods VALUES (74,'Notamused,'Notamused')
INSERT INTO phpbb_moods VALUES (75,'Notworthy,'Notworthy')
INSERT INTO phpbb_moods VALUES (76,'Paranoid,'Paranoid')
INSERT INTO phpbb_moods VALUES (77,'Pensive,'Pensive')
INSERT INTO phpbb_moods VALUES (78,'Predatory,'Predatory')
INSERT INTO phpbb_moods VALUES (79,'Procrastinating,'Procrastinating')
INSERT INTO phpbb_moods VALUES (80,'Psychedelic,'Psychedelic')
INSERT INTO phpbb_moods VALUES (81,'Question,'Question')
INSERT INTO phpbb_moods VALUES (82,'Relaxed,'Relaxed')
INSERT INTO phpbb_moods VALUES (83,'Roflmao,'Roflmao')
INSERT INTO phpbb_moods VALUES (84,'Sad,'Sad')
INSERT INTO phpbb_moods VALUES (85,'Scared,'Scared')
INSERT INTO phpbb_moods VALUES (86,'Scurvy,'Scurvy')
INSERT INTO phpbb_moods VALUES (87,'Shocked,'Shocked')
INSERT INTO phpbb_moods VALUES (88,'Sick,'Sick')
INSERT INTO phpbb_moods VALUES (89,'Sleepy,'Sleepy')
INSERT INTO phpbb_moods VALUES (90,'Sluggish,'Sluggish')
INSERT INTO phpbb_moods VALUES (91,'Sneaky,'Sneaky')
INSERT INTO phpbb_moods VALUES (92,'Snobbish,'Snobbish')
INSERT INTO phpbb_moods VALUES (93,'Spaced,'Spaced')
INSERT INTO phpbb_moods VALUES (94,'Spooky,'Spooky')
INSERT INTO phpbb_moods VALUES (95,'Sporty,'Sporty')
INSERT INTO phpbb_moods VALUES (96,'Starving,'Starving')
INSERT INTO phpbb_moods VALUES (97,'Stressed,'Stressed')
INSERT INTO phpbb_moods VALUES (98,'Sunshine,'Sunshine')
INSERT INTO phpbb_moods VALUES (99,'Sweettooth,'Sweettooth')
INSERT INTO phpbb_moods VALUES (100,'Thinking,'Thinking')
INSERT INTO phpbb_moods VALUES (101,'Tired,'Tired')
INSERT INTO phpbb_moods VALUES (102,'Torn,'Torn')
INSERT INTO phpbb_moods VALUES (103,'Twisted,'Twisted')
INSERT INTO phpbb_moods VALUES (104,'Veggedout,'Veggedout')
INSERT INTO phpbb_moods VALUES (105,'Volatile,'Volatile')
INSERT INTO phpbb_moods VALUES (106,'Woot,'Woot')
INSERT INTO phpbb_moods VALUES (107,'Worried,'Worried')
INSERT INTO phpbb_moods VALUES (108,'Yeehaw,'Yeehaw')

-Rich

 

[Deleted member 4320]

Nice tutorial however this is useless as I already have it installed, good though :great: