-- -- Table structure for table `cmsdam_guestbook_main` -- CREATE TABLE cmsdam_guestbook_main ( id int(5) NOT NULL auto_increment, name varchar(25) NOT NULL default '', email varchar(35) NOT NULL default '', icq int(11) NOT NULL default '0', http varchar(50) NOT NULL default '', message mediumtext NOT NULL, timestamp int(11) NOT NULL default '0', ip varchar(15) NOT NULL default '', location varchar(35) NOT NULL default '', browser varchar(50) NOT NULL default '', comment mediumtext NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Table structure for table `cmsdam_guestbook_badwords` -- CREATE TABLE cmsdam_guestbook_badwords ( badword varchar(25) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `cmsdam_guestbook_badwords` -- INSERT INTO cmsdam_guestbook_badwords VALUES ('fuck'); INSERT INTO cmsdam_guestbook_badwords VALUES ('schweinehund'); INSERT INTO cmsdam_guestbook_badwords VALUES ('fucking'); INSERT INTO cmsdam_guestbook_badwords VALUES ('shit'); INSERT INTO cmsdam_guestbook_badwords VALUES ('piss'); INSERT INTO cmsdam_guestbook_badwords VALUES ('stronzo'); INSERT INTO cmsdam_guestbook_badwords VALUES ('stronzi'); INSERT INTO cmsdam_guestbook_badwords VALUES ('vaffanculo'); INSERT INTO cmsdam_guestbook_badwords VALUES ('merda'); INSERT INTO cmsdam_guestbook_badwords VALUES ('merde'); INSERT INTO cmsdam_guestbook_badwords VALUES ('bastardi'); INSERT INTO cmsdam_guestbook_badwords VALUES ('bastardo'); INSERT INTO cmsdam_guestbook_badwords VALUES ('cazzo'); INSERT INTO cmsdam_guestbook_badwords VALUES ('cazzi'); INSERT INTO cmsdam_guestbook_badwords VALUES ('fregna'); INSERT INTO cmsdam_guestbook_badwords VALUES ('fregne'); INSERT INTO cmsdam_guestbook_badwords VALUES ('mignotta'); INSERT INTO cmsdam_guestbook_badwords VALUES ('mignotte'); INSERT INTO cmsdam_guestbook_badwords VALUES ('puttane'); INSERT INTO cmsdam_guestbook_badwords VALUES ('puttana'); INSERT INTO cmsdam_guestbook_badwords VALUES ('bocchignottola'); INSERT INTO cmsdam_guestbook_badwords VALUES ('puttanona'); INSERT INTO cmsdam_guestbook_badwords VALUES ('puttanone'); INSERT INTO cmsdam_guestbook_badwords VALUES ('puttanoni'); INSERT INTO cmsdam_guestbook_badwords VALUES ('zoccolona'); -- -- Table structure for table `cmsdam_guestbook_bannedips` -- CREATE TABLE cmsdam_guestbook_bannedips ( banned_ip varchar(15) NOT NULL default '', PRIMARY KEY (banned_ip) ) TYPE=MyISAM; -- -- Table structure for table `cmsdam_guestbook_smilies` -- CREATE TABLE cmsdam_guestbook_smilies ( code char(3) NOT NULL default '', file varchar(15) NOT NULL default '', name varchar(25) NOT NULL default '' ) TYPE=MyISAM; -- -- Dumping data for table `cmsdam_guestbook_smilies` -- INSERT INTO cmsdam_guestbook_smilies VALUES (':)','smile.gif','Smile'); INSERT INTO cmsdam_guestbook_smilies VALUES (':-)','smile.gif','Smile'); INSERT INTO cmsdam_guestbook_smilies VALUES (':))','lol.gif','LOL'); INSERT INTO cmsdam_guestbook_smilies VALUES (';)','wink.gif','Winkywinky'); INSERT INTO cmsdam_guestbook_smilies VALUES (';-)','wink.gif','Winkywinky'); INSERT INTO cmsdam_guestbook_smilies VALUES (':(','frown.gif','Frown'); INSERT INTO cmsdam_guestbook_smilies VALUES (':-(','frown.gif','Frown'); INSERT INTO cmsdam_guestbook_smilies VALUES (':[','mad.gif','Mad'); INSERT INTO cmsdam_guestbook_smilies VALUES (':z)','grazy.gif','Grazy'); INSERT INTO cmsdam_guestbook_smilies VALUES (':y)','crying.gif','Crying'); INSERT INTO cmsdam_guestbook_smilies VALUES (':o)','sleepy.gif','Sleepy'); INSERT INTO cmsdam_guestbook_smilies VALUES (':a)','alien.gif','Alien'); INSERT INTO cmsdam_guestbook_smilies VALUES (':s)','smokie.gif','Smokie'); INSERT INTO cmsdam_guestbook_smilies VALUES (':l)','love.gif','Loooove'); INSERT INTO cmsdam_guestbook_smilies VALUES (':L)','love2.gif','Loooooooooove'); INSERT INTO cmsdam_guestbook_smilies VALUES (':]','biggrin.gif','Big Smile'); INSERT INTO cmsdam_guestbook_smilies VALUES (':-/','bounce.gif','Bounce'); INSERT INTO cmsdam_guestbook_smilies VALUES (':b)','burnout.gif','Burnout'); INSERT INTO cmsdam_guestbook_smilies VALUES (':&)','clown.gif','Clown'); INSERT INTO cmsdam_guestbook_smilies VALUES (':?)','confused.gif','Confused'); INSERT INTO cmsdam_guestbook_smilies VALUES (':c)','cool.gif','Cooooooool'); INSERT INTO cmsdam_guestbook_smilies VALUES (':e)','eek.gif','Eeeeeeek'); INSERT INTO cmsdam_guestbook_smilies VALUES (':f)','flash.gif','Flash'); INSERT INTO cmsdam_guestbook_smilies VALUES (':g)','girl.gif','Girl'); INSERT INTO cmsdam_guestbook_smilies VALUES (':i)','idee.gif','Idea'); INSERT INTO cmsdam_guestbook_smilies VALUES (':r)','redface.gif','Redface'); INSERT INTO cmsdam_guestbook_smilies VALUES (':8)','rolleyes.gif','RollEyes'); INSERT INTO cmsdam_guestbook_smilies VALUES (':}','tongue.gif','Tongue'); INSERT INTO cmsdam_guestbook_smilies VALUES (':t)','tasty.gif','Tasty'); INSERT INTO cmsdam_guestbook_smilies VALUES (':1)','alien2.gif','invader'); INSERT INTO cmsdam_guestbook_smilies VALUES (':2)','kitty.gif','Bastard Kitty'); INSERT INTO cmsdam_guestbook_smilies VALUES (':3)','heart.gif','Heart1'); INSERT INTO cmsdam_guestbook_smilies VALUES (':4)','rainbow.gif','tie died'); INSERT INTO cmsdam_guestbook_smilies VALUES (':5)','el.gif','Embarrassed'); INSERT INTO cmsdam_guestbook_smilies VALUES (':6)','pumpkin2.gif','Helloween'); INSERT INTO cmsdam_guestbook_smilies VALUES (':7)','private.gif','Secret'); INSERT INTO cmsdam_guestbook_smilies VALUES (':x)','xmas.gif','Christmas'); INSERT INTO cmsdam_guestbook_smilies VALUES (':9)','kiss.gif','Kiss, Kiss'); INSERT INTO cmsdam_guestbook_smilies VALUES (':1]','karate.gif','Karate'); INSERT INTO cmsdam_guestbook_smilies VALUES (':2]','cold.gif','Cold'); INSERT INTO cmsdam_guestbook_smilies VALUES (':3]','devil.gif','Devil'); INSERT INTO cmsdam_guestbook_smilies VALUES (':4]','tongue2.gif','So Nyah!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':5]','redhot.gif','Red Hot'); INSERT INTO cmsdam_guestbook_smilies VALUES (':6]','smash.gif','Smash!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':7]','frosty.gif','Frosty'); INSERT INTO cmsdam_guestbook_smilies VALUES (':8]','confused2.gif','Confused again'); INSERT INTO cmsdam_guestbook_smilies VALUES (':9]','kaioken.gif','KAI'); INSERT INTO cmsdam_guestbook_smilies VALUES (':1}','vampire.gif','Vampire'); INSERT INTO cmsdam_guestbook_smilies VALUES (':2}','splat.gif','Splat'); INSERT INTO cmsdam_guestbook_smilies VALUES (':3}','rwb.gif','Flag Smiley'); INSERT INTO cmsdam_guestbook_smilies VALUES (':4}','FRlol.gif','LOL2'); INSERT INTO cmsdam_guestbook_smilies VALUES (':5}','goodbad.gif','Good / Bad'); INSERT INTO cmsdam_guestbook_smilies VALUES (':6}','eek2.gif','EEEEK'); INSERT INTO cmsdam_guestbook_smilies VALUES (':7}','dodgy.gif','Dodgy'); INSERT INTO cmsdam_guestbook_smilies VALUES (':8}','bawling.gif','Bawling'); INSERT INTO cmsdam_guestbook_smilies VALUES (':9}','party.gif','Party on, Garth!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ni','nighty.gif','Nightey, Night!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':wa','wavey.gif','Wave!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':pa','patty.gif','Patty'); INSERT INTO cmsdam_guestbook_smilies VALUES (':al','alarm.gif','Alarm'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ba','barf.gif','Barf!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':bd','birthday.gif','Birthday'); INSERT INTO cmsdam_guestbook_smilies VALUES (':bu','bubble.gif','bubble'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ca','cat.gif','Kitty'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ce','censored.gif','Censor'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ch','cheers.gif','Cheers'); INSERT INTO cmsdam_guestbook_smilies VALUES (':co','cowboy.gif','Cowboy'); INSERT INTO cmsdam_guestbook_smilies VALUES (':da','dance.gif','Dancing'); INSERT INTO cmsdam_guestbook_smilies VALUES (':gr','dance1.gif','Dancing Stick'); INSERT INTO cmsdam_guestbook_smilies VALUES (':du','dunce.gif','Dunce'); INSERT INTO cmsdam_guestbook_smilies VALUES (':fi','finger.gif','Bird'); INSERT INTO cmsdam_guestbook_smilies VALUES (':fe','flame.gif','Flame'); INSERT INTO cmsdam_guestbook_smilies VALUES (':fg','flaming.gif','Flaming'); INSERT INTO cmsdam_guestbook_smilies VALUES (':fl','flower2.gif','Flower2'); INSERT INTO cmsdam_guestbook_smilies VALUES (':hi','hippie.gif','Hippie'); INSERT INTO cmsdam_guestbook_smilies VALUES (':jo','joker.gif','Jester'); INSERT INTO cmsdam_guestbook_smilies VALUES (':kn','knight.gif','Knight'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ko','koolaid.gif','KoolAid'); INSERT INTO cmsdam_guestbook_smilies VALUES (':lo','looney.gif','Looney'); INSERT INTO cmsdam_guestbook_smilies VALUES (':pi','pimp.gif','Pimp'); INSERT INTO cmsdam_guestbook_smilies VALUES (':fy','mfinger.gif','Monkey Bird'); INSERT INTO cmsdam_guestbook_smilies VALUES (':pu','pukeface.gif','Puke'); INSERT INTO cmsdam_guestbook_smilies VALUES (':no','no.gif','NO!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ro','rosie.gif','Rosy Cheeks'); INSERT INTO cmsdam_guestbook_smilies VALUES (':sh','shudder.gif','Shudder'); INSERT INTO cmsdam_guestbook_smilies VALUES (':si','sick.gif','Sick'); INSERT INTO cmsdam_guestbook_smilies VALUES (':sm','smoker.gif','Smokin'); INSERT INTO cmsdam_guestbook_smilies VALUES (':se','sperm.gif','Sperm'); INSERT INTO cmsdam_guestbook_smilies VALUES (':to','tomato.gif','tomato'); INSERT INTO cmsdam_guestbook_smilies VALUES (':tu','tut.gif','King Tut'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ty','type.gif','Typing'); INSERT INTO cmsdam_guestbook_smilies VALUES (':wh','whip.gif','Whip It!'); INSERT INTO cmsdam_guestbook_smilies VALUES (':ja','whoa.gif','Jaw Dropping');