Code:
REPLACE INTO `books` (`name`, `txtfile`) VALUES ('TSTSSBroddersLostV2', 'Finally I have three bushels of beans to work with. I sorted them by color.``I have painted beans, black beans and red beans. I toasted them and steeped them. GAH that\'s disgusting! No amount of kick would fix that. ``Even Cornflunk started licking the wrong end of a skunk to `get rid of the taste. I\'ll have to wait a few days before I can convince him that he\'s once again won the Ogre Taste Taster award again and gets to try out a few more drinks as his prize. ``(Note to self, get Cornflunk a new hat. With a big feather this time.)``.Okay, that isn\'t going to work. Caught Catbik cooking a batch of`beans and noticed he was using spices and other ales to flavor the beans as I would have if I were brewing. He told me everyone knows how to make beans. ``Well apparently the gnomes really gnome their [. . . ] ``err know their beans. I saved a few cups of each type of his pots of beans. I took a heavy dark malted` ale, in this case Double Brewed Double Stout Dwarven Ale and combined it two-to-one by measure with the left over beans and added a shot of sugar syrup and yeast to each and put it into a keg in a nice cool spot to age. When the corks blew off the kegs I knew something had happened. Well if you like a muddy textured fizzy brew that will make you burp from both ends, this is your winner. Worked on refining it when I realized I\'m making this for ogres. Instead I thought of what else I might add that they\'d like. ````````````Bought a roll of smoked spiced blood sausage and chopped it up into Halfling and Gnomish finger and toe sizes. ``Well the spiced sausage bits actually add to the brew\'s taste and well give you nice chew between the sliding sips. I doubled the ale again to make it less muddy. This was tolerated by non-ogres a bit more.``(WILL SOMEONE TELL CORNFLUNK I\'M NOT HIS BEST FRIEND? ````````AND KEEP HIM AWAY FROM THE COOKING FIRES?! It\'s not as funny as he thinks!!! Hey, you! Scribe, you don\'t have to write down everything I say now...scribe...scribe...see this big hammer? Guess what happens if I should swing [. . .])``(New ink color and different handwriting again) ``I called this Light Bean Ale and the muddier Heavy Bean Ale. A foamy soup of beans and yeasts and what was once good ale,```````` but a promise is a promise.``Heavy Bean Ale or Bean Beer and Bits as I decided to label it for the ogres, is made with one pot of beans any flavor, 2 jugs of DBDSDA\'s or 2 Minotaur Hero brews, 2 measures of yeast, and a flask of sugar syrup. ``And Two Chopped portions of Spiced blood sausage. This produces anywhere from two to four small bottles of M&B. (Heavy bean ale). ````````Light Bean ale you need to take 4 bottles of heavy bean ale and add same amount of jugs of a lighter ale. ``Compared to the Foaming mud in the other bottles I figured that only Othmir Algae Ale would do. ``This brew is aged again in a cask and then decanted. ``You get 8 bottles of light bean ale and 2 bowls of something that isn\'t all that appealing until it\'s baked. ``````These solids are the remains of the beans, yeasts, beer heavies and sausages. ``(Muck, that\'s all I can call the raw Vegemite we get in this process- luckily it stays in the cask instead of clogging the still.) ``Give a cask of muck to a friendly baker and tell him to roll it out and then use cookie cutters to shape them and if he slow bakes them they stay chewie and well we called them chewie chewies. ````````Even trolls thought they were grate. ``Between the "WHUTS DES MEAT" and the farting and belching contest with Conflunk and his cousins. ``Catbik\'s nose clips finally paid for their development costs. ``Glad I held the taste test away from any sources of flames too. ');
REPLACE INTO `items` (`id`, `minstatus`, `Name`, `aagi`, `ac`, `accuracy`, `acha`, `adex`, `aint`, `artifactflag`, `asta`, `astr`, `attack`, `augrestrict`, `augslot1type`, `augslot1visible`, `augslot2type`, `augslot2visible`, `augslot3type`, `augslot3visible`, `augslot4type`, `augslot4visible`, `augslot5type`, `augslot5visible`, `augtype`, `avoidance`, `awis`, `bagsize`, `bagslots`, `bagtype`, `bagwr`, `banedmgamt`, `banedmgraceamt`, `banedmgbody`, `banedmgrace`, `bardtype`, `bardvalue`, `book`, `casttime`, `casttime_`, `charmfile`, `charmfileid`, `classes`, `color`, `combateffects`, `extradmgskill`, `extradmgamt`, `price`, `cr`, `damage`, `damageshield`, `deity`, `delay`, `augdistiller`, `dotshielding`, `dr`, `clicktype`, `clicklevel2`, `elemdmgtype`, `elemdmgamt`, `endur`, `factionamt1`, `factionamt2`, `factionamt3`, `factionamt4`, `factionmod1`, `factionmod2`, `factionmod3`, `factionmod4`, `filename`, `focuseffect`, `fr`, `fvnodrop`, `haste`, `clicklevel`, `hp`, `regen`, `icon`, `idfile`, `itemclass`, `itemtype`, `ldonprice`, `ldontheme`, `ldonsold`, `light`, `lore`, `loregroup`, `magic`, `mana`, `manaregen`, `enduranceregen`, `material`, `maxcharges`, `mr`, `nodrop`, `norent`, `pendingloreflag`, `pr`, `procrate`, `races`, `range`, `reclevel`, `recskill`, `reqlevel`, `sellrate`, `shielding`, `size`, `skillmodtype`, `skillmodvalue`, `slots`, `clickeffect`, `spellshield`, `strikethrough`, `stunresist`, `summonedflag`, `tradeskills`, `favor`, `weight`, `UNK012`, `UNK013`, `benefitflag`, `UNK054`, `UNK059`, `booktype`, `recastdelay`, `recasttype`, `guildfavor`, `UNK123`, `UNK124`, `attuneable`, `nopet`, `updated`, `comment`, `UNK127`, `pointtype`, `potionbelt`, `potionbeltslots`, `stacksize`, `notransfer`, `stackable`, `UNK134`, `UNK137`, `proceffect`, `proctype`, `proclevel2`, `proclevel`, `UNK142`, `worneffect`, `worntype`, `wornlevel2`, `wornlevel`, `UNK147`, `focustype`, `focuslevel2`, `focuslevel`, `UNK152`, `scrolleffect`, `scrolltype`, `scrolllevel2`, `scrolllevel`, `UNK157`, `serialized`, `verified`, `serialization`, `source`, `UNK033`, `lorefile`, `UNK014`, `svcorruption`, `UNK038`, `UNK060`, `augslot1unk2`, `augslot2unk2`, `augslot3unk2`, `augslot4unk2`, `augslot5unk2`, `UNK120`, `UNK121`, `questitemflag`, `UNK132`, `clickunk5`, `clickunk6`, `clickunk7`, `procunk1`, `procunk2`, `procunk3`, `procunk4`, `procunk6`, `procunk7`, `wornunk1`, `wornunk2`, `wornunk3`, `wornunk4`, `wornunk5`, `wornunk6`, `wornunk7`, `focusunk1`, `focusunk2`, `focusunk3`, `focusunk4`, `focusunk5`, `focusunk6`, `focusunk7`, `scrollunk1`, `scrollunk2`, `scrollunk3`, `scrollunk4`, `scrollunk5`, `scrollunk6`, `scrollunk7`, `UNK193`, `purity`, `evolvinglevel`, `clickname`, `procname`, `wornname`, `focusname`, `scrollname`, `dsmitigation`, `heroic_str`, `heroic_int`, `heroic_wis`, `heroic_agi`, `heroic_dex`, `heroic_sta`, `heroic_cha`, `heroic_pr`, `heroic_dr`, `heroic_fr`, `heroic_cr`, `heroic_mr`, `heroic_svcorrup`, `healamt`, `spelldmg`, `clairvoyance`, `backstabdmg`, `created`, `elitematerial`, `ldonsellbackrate`, `scriptfileid`, `expendablearrow`, `powersourcecapacity`, `bardeffect`, `bardeffecttype`, `bardlevel2`, `bardlevel`, `bardunk1`, `bardunk2`, `bardunk3`, `bardunk4`, `bardunk5`, `bardname`, `bardunk7`, `UNK214`, `UNK219`, `UNK220`, `UNK221`, `UNK222`, `UNK223`, `UNK224`, `UNK225`, `UNK226`, `UNK227`, `UNK228`, `UNK229`, `UNK230`, `UNK231`, `UNK232`, `UNK233`, `UNK234`, `UNK235`, `UNK236`, `UNK237`, `UNK238`, `UNK239`, `UNK240`, `UNK241`, `UNK242`) VALUES (98466, 0, 'Brodder\'s Lost Diaries Volume 2', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, '', '0', 65535, 4278190080, '0', 0, 0, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'TSTSSBroddersLostV2', -1, 0, 0, 0, 0, 0, 0, 778, 'IT63', 2, 31, 0, 0, 0, 0, 'Diaries of a dwarf', 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 65535, 0, 0, 0, 0, 1, 0, 2, -1, 0, 0, -1, 0, 0, 0, 0, 0, 1, 30, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, '2011-10-03 10:50:52', '', 0, 0, 0, 0, 1, 0, 0, '', 0, -1, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, NULL, '2009-03-30 00:19:38', NULL, '13THFLOOR', 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, '0000000000000000000', 0, '', -1, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2006-09-26 01:04:54', 0, 70, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, '', -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);