this is the sql I think the item already exists but the book file it pointed to didnt
Code:
REPLACE INTO `books` (`name`, `txtfile`) VALUES ('TSTSSBroddersLostV1', 'Where wus I, oh yeah sometime after I got away from that Ogre who had captured me (so he thought,but I had really tricked him into taking me safely into his town so I could learn what they knew about brewing) ``I remembered their comments on Boot ale and Skunk Breath Ale [. . .] ``There was this one fat ogre there trying to convince a young cleric that his town wus safe. ``I noticed the amounts of foodstuffs they had collected and a huge list the lass had unrolled (and covered yards and yards of ground. I think my friend Catbik got lost somewhere in that list when he saw a gadjet on the ground nearby. ``I was too busy hauling my notes and samples on not too steady feet away from where the ogre guards patrolled when I noticed the ogre squeezing his beans into a bottle and the thought did occur to me, mayhap I can return the favor to the Ogres and learn to make a good brew from beans. ``They do have a potent after effect, but I\'d normally only consider them for flavorings normally. ``But ogres know what they like, and if it\'s something that keeps me and my kin off the menu, then I\'m all for it. ``By Brell I realized I had talked myself into a working on a new recipe, when was I going to find the time? `` (ink color changes) I found these notes when I discovered a box of my submissions to the Gnomish publishers. ````````How dare they not return all my brewing notes! How dare I not remember! How did I forget? ``Guess I\'ll have to blame you know who, yeah that one, Brell\'s side kick. ``Didn\'t get smited and my shoes are still on the right feet and my beard hasn\'t changed. ``Yep no changes. ``That him. ````Anyway I hied myself off to the druids of Faydwer to see about collecting all sorts of legumes for my work. ``I found steeping the coffee beans with gnomish spirits and honey made a nice elixir that made things move slower around you and talking to excited gnomes a very easy task. ``Have to sell this stuff to the ambassadors dealing with the gnomes. ````````Put them in the right mindset now won\'t it? ``Two handful of beans ground and then steeped in hot water. ``Added to Gnomish spirits and honey or a good sugary syrup of equal measure. ``2 cups of sugar per flask of water in a pot will make a decent sweet syrup. ``````Mix and strain out the grounds and store in a dark bottle. ``Catbik says it\'s good with milk and an extra shot of gnomish spirits. ``When he stops bouncing around like a well overexcited gnome I\'ll ask how it tastes.');
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 (98465, 0, 'Brodder\'s Lost Diaries Volume 1', 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, 'TSTSSBroddersLostV1', -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);