Updated Solo Server Package

[djeryv]

Maybe try sourcing the below again? This will drop those 2 tables and recreate them.

DROP TABLE IF EXISTS _craft_merchant;
CREATE TABLE _craft_merchant (item INT(20) NOT NULL PRIMARY KEY);
INSERT INTO _craft_merchant VALUES 
('1057'),('1210'),('1329'),('1451'),('1452'),('1453'),('1561'),('1562'),('1596'),('1830'),('1831'),('1832'),('1833'),('1849'),('1850'),('1851'),('1852'),('1854'),('1855'),('1856'),('1857'),('1859'),('1860'),('1886'),('1893'),('1894'),('1895'),('1896'),('2040'),('2046'),('2048'),('2054'),('2066'),('2067'),('2068'),('2069'),('2070'),('2071'),('2072'),('2073'),('2074'),('2075'),('2076'),('2077'),('2078'),('2079'),('2080'),('2081'),('2082'),('2083'),('2084'),('2085'),('2086'),('2087'),('2089'),('2125'),('2126'),('2127'),('2128'),('2129'),('2130'),('2131'),('2132'),('2133'),('2134'),('2135'),('2136'),('2428'),('2448'),('2750'),('2751'),('2752'),('2753'),('2754'),('2755'),('2756'),('2757'),('2758'),('2759'),('2760'),('2761'),('2791'),('2792'),('2793'),('2794'),('3444'),('3450'),('3467'),('3468'),('3471'),('3472'),('3473'),('3474'),('3477'),('3495'),('3497'),('3498'),('3614'),('3619'),('3631'),('3632'),('3636'),('3638'),('3639'),('3641'),('3646'),('3649'),('3651'),('3652'),('3653'),('3658'),('3663'),('3664'),('3667'),('3890'),('3894'),('3913'),('3914'),('3915'),('3916'),('3923'),('5128'),('5533'),('5537'),('5538'),('5539'),('5551'),('5555'),('5570'),('5572'),('5956'),('5957'),('6094'),('6095'),('6096'),('6097'),('6164'),('6165'),('6180'),('6273'),('6700'),('6701'),('6702'),('6703'),('6704'),('6705'),('6706'),('6707'),('6800'),('6822'),('6974'),('7096'),('7134'),('7139'),('7271'),('7272'),('7274'),('7773'),('7884'),('7887'),('7984'),('8091'),('8107'),('8174'),('8175'),('8176'),('8237'),('8238'),('8239'),('8240'),('8284'),('8764'),('8792'),('8798'),('8804'),('8806'),('8808'),('8810'),('8813'),('8816'),('8820'),('8821'),('8826'),('8827'),('8832'),('8833'),('8839'),('8840'),('8848'),('8849'),('8850'),('8857'),('8858'),('8859'),('8863'),('8868'),('8878'),('8881'),('8890'),('8891'),('8892'),('8893'),('8894'),('8997'),('9033'),('9035'),('9037'),('9039'),('9041'),('9043'),('9055'),('9056'),('9062'),('9138'),('9139'),('9140'),('9141'),('9142'),('9143'),('9144'),('9145'),('9146'),('9147'),('9148'),('9149'),('9150'),('9151'),('9152'),('9153'),('9154'),('9155'),('9156'),('9157'),('9158'),('9159'),('9160'),('9161'),('9162'),('9163'),('9164'),('9165'),('9166'),('9167'),('9168'),('9169'),('9170'),('9171'),('9172'),('9175'),('9176'),('9177'),('9182'),('9183'),('9196'),('9197'),('9437'),('9471'),('9578'),('9644'),('9645'),('9647'),('9648'),('9649'),('9650'),('9651'),('9652'),('9653'),('9654'),('9655'),('9656'),('9657'),('9658'),('9659'),('9660'),('9661'),('9662'),('9664'),('9665'),('9666'),('9667'),('9668'),('9669'),('9670'),('9671'),('9672'),('9675'),('9676'),('9677'),('9678'),('9679'),('9680'),('9681'),('9682'),('9683'),('9684'),('9685'),('9686'),('9690'),('9691'),('9692'),('9693'),('9695'),('9696'),('9697'),('9698'),('9699'),('9700'),('9701'),('9703'),('9704'),('9705'),('9720'),('9723'),('9724'),('9725'),('9726'),('9727'),('9734'),('9735'),('9736'),('9740'),('9741'),('9742'),('9743'),('9744'),('9745'),('9746'),('9747'),('9748'),('9749'),('9750'),('9751'),('9753'),('9755'),('9756'),('9757'),('9759'),('9761'),('9762'),('9763'),('9765'),('9767'),('9768'),('9769'),('9770'),('9772'),('9773'),('9775'),('9776'),('9777'),('9779'),('9781'),('9782'),('9795'),('9803'),('9804'),('9825'),('10013'),('10064'),('10160'),('10191'),('10226'),('10227'),('10250'),('10251'),('10252'),('10253'),('10254'),('10268'),('10269'),('10270'),('10271'),('10272'),('10273'),('10274'),('10275'),('10276'),('10277'),('10279'),('10280'),('10281'),('10282'),('10283'),('10284'),('10285'),('10286'),('10287'),('10288'),('10289'),('10367'),('10398'),('10409'),('10410'),('10426'),('10427'),('10428'),('10430'),('10431'),('10432'),('10433'),('10434'),('10436'),('10437'),('10438'),('10439'),('10440'),('10441'),('10442'),('10443'),('10444'),('10446'),('10447'),('10449'),('10451'),('10452'),('10453'),('10455'),('10457'),('10461'),('10463'),('10470'),('10471'),('10472'),('10473'),('10481'),('10482'),('10490'),('10491'),('10492'),('10493'),('10495'),('10497'),('10499'),('10608'),('10609'),('10610'),('10611'),('10612'),('10613'),('10615'),('10616'),('10617'),('10618'),('10619'),('10620'),('10621'),('10756'),('10757'),('10758'),('10759'),('10789'),('10930'),('10958'),('10968'),('10969'),('10972'),('10976'),('11395'),('11398'),('11406'),('11430'),('11548'),('11590'),('11591'),('11593'),('11595'),('11659'),('11660'),('11700'),('11709'),('12011'),('12072'),('12073'),('12075'),('12081'),('12111'),('12114'),('12145'),('12239'),('12282'),('12298'),('12299'),('12300'),('12301'),('12302'),('12303'),('12304'),('12305'),('12314'),('12315'),('12363'),('12398'),('12402'),('12404'),('12410'),('12442'),('12444'),('12445'),('12449'),('12464'),('12468'),('12475'),('12476'),('12477'),('12478'),('12483'),('12487'),('12560'),('12561'),('12564'),('12573'),('12574'),('12607'),('12632'),('12634'),('12635'),('12657'),('12687'),('12689'),('12714'),('12728'),('12759'),('12760'),('12765'),('12767'),('12770'),('12771'),('12776'),('12778'),('12781'),('12782'),('12783'),('12784'),('12785'),('12794'),('12832'),('12889'),('12901'),('12902'),('12903'),('12904'),('12934'),('12935'),('12936'),('12937'),('12939'),('12946'),('13044'),('13046'),('13048'),('13079'),('13090'),('13094'),('13118'),('13247'),('13248'),('13249'),('13419'),('13430'),('13431'),('13432'),('13433'),('13434'),('13435'),('13436'),('13437'),('13438'),('13439'),('13440'),('13455'),('13493'),('13639'),('13667'),('13760'),('13795'),('13822'),('13836'),('13878'),('13910'),('13952'),('14090'),('14091'),('14092'),('14093'),('14095'),('14096'),('14097'),('14098'),('14099'),('14320'),('14344'),('14350'),('14351'),('14352'),('14353'),('14354'),('14355'),('14356'),('14357'),('14358'),('14359'),('14403'),('14404'),('14405'),('14406'),('14407'),('14408'),('14409'),('14410'),('14411'),('14412'),('14413'),('14414'),('14415'),('14416'),('14417'),('14418'),('14419'),('14420'),('14421'),('14422'),('14423'),('14425'),('14426'),('14427'),('14428'),('14429'),('14430'),('14431'),('14432'),('14433'),('14434'),('14435'),('14436'),('14437'),('14438'),('14439'),('14440'),('14441'),('14442'),('14443'),('14444'),('14445'),('14446'),('14447'),('14448'),('14449'),('14450'),('14451'),('14452'),('14453'),('14454'),('14455'),('14456'),('14577'),('14578'),('14579'),('14796'),('14798'),('14888'),('14889'),('14890'),('14891'),('14892'),('14904'),('14905'),('14909'),('14910'),('14913'),('14915'),('14916'),('14917'),('14919'),('14922'),('14925'),('14930'),('14933'),('14934'),('14936'),('14937'),('14938'),('14939'),('14940'),('14947'),('14950'),('14951'),('14954'),('14968'),('14972'),('14973'),('14974'),('14975'),('14976'),('14977'),('14978'),('14980'),('14981'),('14982'),('14983'),('14984'),('14985'),('14986'),('14987'),('14988'),('14989'),('14990'),('14991'),('14992'),('14993'),('14994'),('14995'),('14996'),('15570'),('15571'),('15572'),('15622'),('15624'),('15757'),('15760'),('15835'),('15900'),('15901'),('15902'),('15903'),('15904'),('15905'),('15906'),('15907'),('15908'),('15909'),('15910'),('15911'),('15982'),('15984'),('15987'),('15988'),('15989'),('15990'),('15992'),('15994'),('15998'),('15999'),('16190'),('16193'),('16243'),('16244'),('16249'),('16250'),('16251'),('16252'),('16254'),('16267'),('16268'),('16269'),('16270'),('16271'),('16272'),('16273'),('16274'),('16275'),('16276'),('16277'),('16278'),('16279'),('16280'),('16281'),('16283'),('16284'),('16286'),('16287'),('16288'),('16289'),('16453'),('16454'),('16455'),('16456'),('16457'),('16458'),('16460'),('16461'),('16462'),('16463'),('16464'),('16465'),('16466'),('16467'),('16468'),('16469'),('16470'),('16471'),('16472'),('16475'),('16476'),('16477'),('16478'),('16483'),('16486'),('16488'),('16489'),('16490'),('16491'),('16493'),('16495'),('16496'),('16497'),('16498'),('16504'),('16505'),('16506'),('16507'),('16549'),('16553'),('16558'),('16560'),('16561'),('16562'),('16566'),('16570'),('16578'),('16581'),('16585'),('16589'),('16799'),('16821'),('16824'),('16837'),('16863'),('16865'),('16867'),('16871'),('16873'),('16877'),('16881'),('16883'),('16885'),('16886'),('16887'),('16896'),('16897'),('16905'),('16913'),('16914'),('16915'),('16916'),('16917'),('16918'),('16919'),('16923'),('16925'),('16926'),('16927'),('16928'),('16929'),('16930'),('16932'),('16933'),('16946'),('16947'),('16948'),('18008'),('18229'),('18320'),('18499'),('18960'),('19100'),('19113'),('19120'),('19121'),('19122'),('19123'),('19124'),('19125'),('19126'),('19138'),('19139'),('19140'),('19142'),('19179'),('19180'),('19181'),('19184'),('19192'),('19193'),('19555'),('19556'),('19557'),('19558'),('19559'),('19560'),('19561'),('19572'),('19624'),('19625'),('19626'),('19631'),('19632'),('19633'),('19634'),('19635'),('19636'),('19637'),('19638'),('19639'),('19640'),('19641'),('19642'),('19643'),('19644'),('19685'),('19690'),('19691'),('19692'),('19693'),('19694'),('19695'),('19696'),('19920'),('19921'),('19922'),('19923'),('19950'),('19972'),('19973'),('19985'),('20110'),('20176'),('20187'),('20198'),('20200'),('20202'),('20258'),('20294'),('20295'),('20297'),('20386'),('20393'),('20394'),('20403'),('20414'),('20455'),('20456'),('20464'),('20465'),('20466'),('20467'),('20521'),('20522'),('20523'),('20667'),('20671'),('20672'),('21001'),('21004'),('21008'),('21009'),('21010'),('21011'),('21012'),('21013'),('21016'),('21020'),('21021'),('21022'),('21023'),('21024'),('21025'),('21028'),('21032'),('21033'),('21034'),('21035'),('21036'),('21347'),('21348'),('21610'),('21611'),('21612'),('21613'),('21614'),('21615'),('21616'),('21617'),('21618'),('21619'),('21620'),('21621'),('21622'),('21623'),('21624'),('21683'),('22092'),('22095'),('22096'),('22099'),('22102'),('22103'),('22104'),('22105'),('22106'),('22107'),('22108'),('22109'),('22110'),('22111'),('22112'),('22113'),('22114'),('22115'),('22116'),('22117'),('22118'),('22119'),('22226'),('22227'),('22229'),('22230'),('22500'),('22501'),('22502'),('22506'),('22507'),('22508'),('22509'),('22510'),('22511'),('22512'),('22513'),('22525'),('22531'),('22540'),('22541'),('22543'),('22545'),('22546'),('22548'),('22549'),('22550'),('22551'),('22552'),('22553'),('22554'),('22555'),('22556'),('22559'),('22560'),('22565'),('22567'),('22568'),('22571'),('22573'),('22574'),('22575'),('22576'),('22577'),('22578'),('22579'),('22583'),('22584'),('22585'),('22586'),('22587'),('22588'),('22589'),('22602'),('22610'),('22611'),('22612'),('22613'),('22614'),('22615'),('22616'),('22621'),('22622'),('22623'),('22624'),('22625'),('22626'),('22627'),('22628'),('22629'),('22630'),('22631'),('22632'),('22633'),('22634'),('22648'),('22649'),('22650'),('22651'),('22652'),('22653'),('22661'),('22662'),('22663'),('22664'),('22665'),('22666'),('22667'),('22671'),('22672'),('22673'),('22674'),('22675'),('22676'),('22677'),('22678'),('22679'),('22680'),('22681'),('22682'),('22683'),('22684'),('22745'),('22746'),('22747'),('22748'),('22749'),('22750'),('22751'),('22752'),('22753'),('22754'),('22756'),('22757'),('22758'),('22759'),('22760'),('22761'),('22762'),('22763'),('22764'),('22765'),('22766'),('22767'),('22768'),('22769'),('22770'),('22771'),('22772'),('22773'),('22774'),('22775'),('22831'),('22832'),('22833'),('22846'),('22849'),('22892'),('22900'),('22902'),('22933'),('22934'),('22935'),('22936'),('22937'),('22938'),('22939'),('23026'),('23188'),('23208'),('23327'),('23532'),('23533'),('23534'),('23535'),('23538'),('23539'),('23540'),('23541'),('23542'),('23577'),('23580'),('23582'),('23583'),('23584'),('23585'),('23586'),('23587'),('23588'),('23589'),('23604'),('23605'),('23606'),('23607'),('23608'),('23609'),('23611'),('23612'),('23613'),('23626'),('23639'),('23677'),('23678'),('23679'),('23717'),('23754'),('23791'),('23816'),('23853'),('23950'),('23963'),('23964'),('23977'),('23978'),('24071'),('24074'),('24076'),('24077'),('24078'),('24079'),('24081'),('24095'),('24096'),('24097'),('24098'),('24271'),('24272'),('24321'),('24370'),('24383'),('24409'),('24422'),('24423'),('24424'),('24425'),('24426'),('24427'),('24428'),('24429'),('24430'),('24431'),('24432'),('24434'),('24447'),('24448'),('24449'),('24450'),('24451'),('24452'),('24453'),('24454'),('24455'),('24456'),('24457'),('24458'),('24459'),('24465'),('24467'),('24472'),('24473'),('24474'),('24475'),('24476'),('24477'),('24483'),('24484'),('24485'),('24489'),('24490'),('24494'),('24496'),('24497'),('24498'),('24650'),('24651'),('24652'),('24653'),('24654'),('24655'),('24656'),('24657'),('24658'),('24659'),('24660'),('24661'),('24662'),('24663'),('24664'),('24665'),('24666'),('24667'),('24668'),('24669'),('24670'),('24671'),('24672'),('24673'),('24674'),('24675'),('24676'),('24677'),('24678'),('24679'),('24680'),('24681'),('24682'),('24683'),('24684'),('24685'),('24686'),('24687'),('24688'),('24689'),('24690'),('24691'),('24768'),('24769'),('24864'),('24865'),('24866'),('24868'),('24869'),('24997'),('25663'),('25664'),('25759'),('25770'),('26896'),('27432'),('27433'),('27434'),('27435'),('27436'),('27437'),('27438'),('27439'),('27440'),('27441'),('27442'),('27443'),('27444'),('27445'),('27446'),('27447'),('27448'),('27449'),('27450'),('27451'),('27452'),('27453'),('27454'),('27455'),('27456'),('27457'),('27458'),('27459'),('27460'),('27461'),('27462'),('27463'),('27464'),('27465'),('27466'),('27467'),('27468'),('27469'),('27470'),('27471'),('27472'),('27473'),('27474'),('27475'),('27476'),('27477'),('27478'),('27479'),('27480'),('27481'),('27482'),('27483'),('27484'),('27485'),('27486'),('27487'),('27541'),('27542'),('27543'),('27544'),('27545'),('27546'),('27547'),('27548'),('27549'),('27550'),('27551'),('27552'),('27553'),('27554'),('27555'),('27556'),('27557'),('27558'),('27559'),('27560'),('27561'),('27562'),('27563'),('27564'),('27565'),('27566'),('27567'),('27568'),('27664'),('27669'),('27670'),('27671'),('27672'),('27673'),('27674'),('27675'),('27676'),('27677'),('27678'),('27679'),('27680'),('27681'),('27682'),('27683'),('27684'),('27685'),('27686'),('27687'),('27688'),('27689'),('27690'),('27691'),('27692'),('27693'),('27694'),('27695'),('27696'),('27756'),('27758'),('27759'),('27760'),('27761'),('27763'),('28059'),('28182'),('28183'),('28184'),('28185'),('28186'),('28187'),('28229'),('28230'),('28231'),('28232'),('28233'),('28234'),('28244'),('28245'),('28247'),('28248'),('28249'),('28284'),('28290'),('28546'),('28574'),('28576'),('28577'),('28578'),('28579'),('28590'),('28591'),('28592'),('28593'),('28799'),('29146'),('29147'),('29163'),('29164'),('29166'),('29173'),('29194'),('29195'),('29196'),('29417'),('29418'),('29488'),('29489'),('29494'),('29502'),('29506'),('29507'),('29508'),('29509'),('29510'),('29511'),('29512'),('29515'),('29516'),('29517'),('29518'),('29519'),('29520'),('29528'),('29529'),('29530'),('29531'),('29532'),('29533'),('29540'),('29541'),('29542'),('29543'),('29544'),('29545'),('29547'),('29548'),('29549'),('29573'),('29574'),('29575'),('29576'),('29577'),('29578'),('29579'),('29580'),('29581'),('29582'),('29583'),('29584'),('29585'),('29587'),('29588'),('29589'),('29590'),('29591'),('29592'),('29593'),('29594'),('29595'),('29652'),('29653'),('29654'),('29655'),('29656'),('29657'),('29658'),('29661'),('29742'),('29745'),('29747'),('29748'),('29753'),('29754'),('29755'),('29760'),('29762'),('29764'),('29765'),('29766'),('29775'),('29776'),('29778'),('29779'),('29781'),('29783'),('29784'),('29785'),('29786'),('29787'),('29788'),('29791'),('29792'),('29793'),('29794'),('29804'),('29807'),('29810'),('29813'),('29816'),('29818'),('29823'),('29859'),('29873'),('29874'),('29875'),('29970'),('29986'),('29987'),('29988'),('29989'),('29990'),('29991'),('29995'),('29996'),('29997'),('29998'),('29999'),('30045'),('30062'),('30118'),('30140'),('30197'),('30480'),('30481'),('30482'),('30483'),('30484'),('30485'),('30486'),('30487'),('30489'),('30494'),('30495'),('30496'),('30497'),('30500'),('30619'),('30664'),('30886'),('30887'),('30889'),('30890'),('30891'),('31598'),('31729'),('31760'),('31761'),('31762'),('31765'),('31767'),('31768'),('31770'),('31771'),('31777'),('32000'),('32075'),('32218'),('32219'),('32220'),('32221'),('32222'),('32223'),('32224'),('32225'),('32226'),('32227'),('32228'),('32229'),('32230'),('32231'),('32232'),('32233'),('32234'),('32235'),('32236'),('32237'),('32238'),('32243'),('32545'),('32552'),('32554'),('32800'),('36424'),('36430'),('37537'),('38402'),('38412'),('38417'),('38422'),('38427'),('38432'),('38437'),('38457'),('38467'),('38739'),('38740'),('38741'),('38742'),('38743'),('38744'),('38745'),('38802'),('38803'),('38804'),('38805'),('38806'),('38807'),('38808'),('38830'),('38831'),('38832'),('38833'),('38834'),('38835'),('38836'),('38907'),('38908'),('38909'),('38910'),('38911'),('38912'),('38913'),('38928'),('38929'),('38930'),('38931'),('38932'),('38933'),('38934'),('38939'),('45200'),('45201'),('45202'),('45209'),('45210'),('45211'),('45212'),('45214'),('45215'),('45220'),('45221'),('45225'),('45226'),('45227'),('45228'),('45229'),('45230'),('45231'),('45232'),('45235'),('45236'),('45237'),('45247'),('45250'),('45377'),('45378'),('45571'),('45572'),('45573'),('45574'),('45581'),('45582'),('45583'),('45590'),('45617'),('45619'),('45891'),('45892'),('46002'),('48001'),('48003'),('48004'),('48005'),('48006'),('48009'),('48010'),('48040'),('51007'),('51009'),('51014'),('51017'),('51019'),('51041'),('51042'),('51043'),('51044'),('51045'),('51046'),('51047'),('51048'),('51049'),('51050'),('51051'),('51052'),('51053'),('51054'),('51055'),('51056'),('51057'),('51058'),('51059'),('51060'),('51061'),('51062'),('51063'),('51064'),('51065'),('51066'),('51067'),('51068'),('51102'),('51103'),('51110'),('51135'),('51138'),('51141'),('51144'),('51147'),('51149'),('51153'),('51155'),('51159'),('51161'),('51163'),('51176'),('51177'),('51178'),('51179'),('51180'),('51181'),('51182'),('51183'),('51184'),('51185'),('51186'),('51187'),('51188'),('51189'),('51190'),('51191'),('51192'),('51193'),('51194'),('51195'),('51196'),('51197'),('51198'),('51199'),('51200'),('51201'),('51202'),('51203'),('51204'),('51205'),('51206'),('51207'),('51208'),('51209'),('51210'),('51211'),('51212'),('51213'),('51214'),('51215'),('51216'),('51217'),('51218'),('51219'),('51220'),('51321'),('51323'),('51324'),('51325'),('51326'),('51327'),('51328'),('51329'),('51330'),('51331'),('51332'),('51333'),('51334'),('51335'),('51336'),('51337'),('51338'),('51339'),('51340'),('51341'),('51342'),('51343'),('51344'),('51345'),('51346'),('51347'),('51348'),('51349'),('51351'),('51352'),('51353'),('51354'),('51355'),('51356'),('51357'),('51358'),('51359'),('51360'),('51361'),('51362'),('51363'),('51364'),('51365'),('51366'),('51367'),('51368'),('51369'),('51370'),('51371'),('51372'),('51373'),('51374'),('51375'),('51376'),('51381'),('51382'),('51383'),('51384'),('51385'),('51386'),('51387'),('51388'),('51389'),('51390'),('51391'),('51392'),('51393'),('51394'),('51395'),('51401'),('51429'),('51432'),('52126'),('52920'),('52929'),('52931'),('52932'),('52942'),('52943'),('54004'),('54015'),('54093'),('54094'),('54095'),('54096'),('54101'),('54102'),('54103'),('54104'),('54105'),('54106'),('54107'),('54108'),('54109'),('54110'),('54111'),('54298'),('55018'),('55019'),('55020'),('55021'),('55022'),('55023'),('55024'),('55104'),('55105'),('55106'),('55107'),('55108'),('55109'),('55110'),('55111'),('55112'),('55113'),('55114'),('55115'),('55116'),('55117'),('55127'),('55128'),('55129'),('55130'),('55131'),('55132'),('55133'),('55134'),('55135'),('55136'),('55137'),('55138'),('55139'),('55140'),('55149'),('55150'),('55151'),('55152'),('55153'),('55154'),('55155'),('55156'),('55157'),('55158'),('55159'),('55160'),('55161'),('55162'),('55172'),('55173'),('55174'),('55175'),('55176'),('55177'),('55178'),('55179'),('55180'),('55181'),('55182'),('55183'),('55184'),('55185'),('55275'),('55276'),('55278'),('55279'),('55280'),('55281'),('55282'),('55283'),('55284'),('55285'),('55286'),('55287'),('55288'),('55293'),('55308'),('55337'),('55338'),('55339'),('55340'),('55341'),('55342'),('55343'),('55344'),('55345'),('55346'),('55347'),('55348'),('55349'),('55350'),('55361'),('55362'),('55363'),('55364'),('55365'),('55366'),('55367'),('55368'),('55369'),('55370'),('55371'),('55372'),('55373'),('55374'),('55384'),('55385'),('55386'),('55387'),('55388'),('55389'),('55390'),('55391'),('55392'),('55393'),('55394'),('55395'),('55396'),('55397'),('55408'),('55409'),('55410'),('55411'),('55412'),('55413'),('55414'),('55415'),('55416'),('55417'),('55418'),('55419'),('55420'),('55421'),('55478'),('55479'),('55480'),('55481'),('55482'),('55483'),('55484'),('55485'),('55486'),('55487'),('55488'),('55489'),('55490'),('55491'),('55577'),('55578'),('55623'),('55780'),('55790'),('55791'),('57005'),('57006'),('57056'),('57600'),('57998'),('57999'),('58008'),('58019'),('58020'),('58021'),('58023'),('58024'),('58025'),('58026'),('58028'),('58029'),('58031'),('58032'),('58033'),('58034'),('58035'),('58036'),('58038'),('58039'),('58040'),('58042'),('58043'),('58044'),('58045'),('58046'),('58053'),('58055'),('58056'),('58057'),('58058'),('58060'),('58061'),('58062'),('58063'),('58064'),('58065'),('58066'),('58068'),('58069'),('58070'),('58072'),('58077'),('58078'),('58079'),('58080'),('58081'),('58088'),('58091'),('58096'),('58102'),('58103'),('58105'),('58113'),('58116'),('58119'),('58123'),('58128'),('58129'),('58133'),('58134'),('58135'),('58136'),('58138'),('58139'),('58140'),('58141'),('58142'),('58145'),('58146'),('58147'),('58148'),('58149'),('58151'),('58152'),('58158'),('58160'),('58161'),('58162'),('58163'),('58164'),('58167'),('58168'),('58169'),('58172'),('58173'),('58178'),('58179'),('58184'),('58185'),('58186'),('58191'),('58195'),('58199'),('58202'),('58204'),('58207'),('58211'),('58214'),('58218'),('58222'),('58223'),('58224'),('58226'),('58227'),('58228'),('58242'),('58244'),('58262'),('58265'),('58266'),('58267'),('58268'),('58269'),('58270'),('58271'),('58272'),('58273'),('58274'),('58275'),('58276'),('58277'),('58280'),('58284'),('58286'),('58288'),('58290'),('58291'),('58292'),('58293'),('58294'),('58295'),('58296'),('58297'),('58298'),('58304'),('58380'),('58382'),('58383'),('58384'),('58385'),('58386'),('58387'),('58388'),('58389'),('58390'),('58396'),('58472'),('58474'),('58475'),('58476'),('58477'),('58478'),('58479'),('58480'),('58481'),('58482'),('58555'),('58557'),('58558'),('58559'),('58560'),('58561'),('58562'),('58563'),('58564'),('58565'),('58639'),('58645'),('58646'),('58683'),('58684'),('58685'),('58686'),('58783'),('58785'),('58789'),('58827'),('58828'),('58830'),('58831'),('58847'),('58869'),('58870'),('58884'),('58885'),('58886'),('58887'),('58888'),('58889'),('58899'),('58900'),('58901'),('58903'),('58905'),('58906'),('58907'),('58909'),('58927'),('58928'),('58930'),('58931'),('58943'),('58944'),('58946'),('58947'),('58963'),('59048'),('60162'),('60178'),('60187'),('60188'),('60215'),('60216'),('60217'),('60218'),('60241'),('60250'),('61102'),('61103'),('61104'),('61105'),('61106'),('61107'),('61108'),('61109'),('61110'),('61111'),('61112'),('61113'),('61114'),('61115'),('61116'),('61117'),('61118'),('61119'),('61120'),('61121'),('61122'),('61123'),('61124'),('61125'),('61126'),('61127'),('61128'),('61129'),('61130'),('61131'),('61132'),('61133'),('61134'),('61135'),('61136'),('62490'),('62491'),('62492'),('62500'),('62607'),('62608'),('62609'),('62610'),('62650'),('62651'),('62652'),('62820'),('62823'),('62830'),('62832'),('62834'),('62858'),('62859'),('62860'),('63055'),('63056'),('63057'),('63058'),('63059'),('63060'),('63061'),('63062'),('63064'),('63065'),('63066'),('63067'),('63068'),('63069'),('63070'),('63071'),('63072'),('63073'),('63074'),('63075'),('63076'),('63080'),('63081'),('63082'),('63083'),('63084'),('63085'),('63086'),('63171'),('63172'),('63173'),('63175'),('63176'),('63186'),('63187'),('63192'),('63193'),('63194'),('63196'),('63214'),('63216'),('63246'),('63247'),('63248'),('63249'),('63250'),('63251'),('63252'),('63253'),('63254'),('63255'),('63256'),('63257'),('63258'),('63259'),('63260'),('63261'),('63262'),('63263'),('63264'),('63265'),('63266'),('63267'),('63268'),('63269'),('63270'),('63271'),('63272'),('63273'),('63274'),('63275'),('63277'),('63278'),('63279'),('63281'),('63282'),('63283'),('63284'),('63285'),('63287'),('63288'),('63289'),('63290'),('63291'),('63292'),('63293'),('63294'),('63295'),('63297'),('63298'),('63299'),('63300'),('63302'),('63303'),('63304'),('63305'),('63306'),('63307'),('63308'),('63309'),('63310'),('63311'),('63312'),('63313'),('63314'),('63317'),('63327'),('63328'),('63329'),('63331'),('63332'),('63342'),('63348'),('63387'),('63390'),('63400'),('63404'),('63406'),('63432'),('63443'),('63444'),('63445'),('63446'),('63447'),('63448'),('63464'),('63503'),('63506'),('63516'),('63517'),('63520'),('63522'),('63523'),('63526'),('63548'),('63560'),('63561'),('63563'),('63564'),('63619'),('63622'),('63636'),('63642'),('63676'),('63677'),('63679'),('63680'),('63690'),('63735'),('63736'),('63738'),('63833'),('63834'),('63835'),('63836'),('63840'),('63841'),('63842'),('63843'),('63844'),('63859'),('63860'),('63861'),('63862'),('65000'),('65001'),('65002'),('65003'),('65004'),('65005'),('65006'),('65007'),('65008'),('65009'),('65010'),('65011'),('65012'),('65013'),('65014'),('65015'),('65016'),('65017'),('65018'),('65019'),('65020'),('65021'),('65022'),('65023'),('65072'),('65073'),('65074'),('65075'),('65076'),('65077'),('65078'),('65079'),('65080'),('65081'),('65082'),('65083'),('65084'),('65085'),('65114'),('65115'),('65138'),('65144'),('65145'),('65147'),('65148'),('65155'),('65156'),('65157'),('65158'),('65159'),('65160'),('65161'),('65162'),('65163'),('65164'),('65165'),('65166'),('65167'),('65168'),('65169'),('65170'),('65177'),('65178'),('65179'),('65180'),('65181'),('65182'),('65183'),('65184'),('65185'),('65186'),('65187'),('65188'),('65189'),('65190'),('65191'),('65192'),('65199'),('65200'),('65201'),('65202'),('65203'),('65204'),('65205'),('65206'),('65207'),('65208'),('65209'),('65210'),('65211'),('65212'),('65213'),('65214'),('65221'),('65222'),('65223'),('65224'),('65225'),('65226'),('65227'),('65228'),('65229'),('65230'),('65231'),('65232'),('65233'),('65234'),('65235'),('65236'),('65243'),('65244'),('65245'),('65246'),('65247'),('65248'),('65249'),('65250'),('65251'),('65252'),('65253'),('65254'),('65255'),('65256'),('65257'),('65258'),('65259'),('65260'),('65355'),('65357'),('65358'),('65417'),('65418'),('65421'),('65428'),('65429'),('65430'),('65432'),('65433'),('65434'),('65435'),('65436'),('65437'),('65438'),('65439'),('65440'),('65441'),('65442'),('65443'),('65444'),('65445'),('65460'),('65465'),('65467'),('65471'),('65472'),('65473'),('65474'),('65475'),('65478'),('65479'),('65480'),('65483'),('65484'),('65485'),('65489'),('65499'),('65579'),('65580'),('65583'),('65587'),('65591'),('65593'),('65595'),('65596'),('65598'),('65599'),('65600'),('65601'),('65633'),('65634'),('65635'),('65636'),('65637'),('66120'),('66121'),('66122'),('66123'),('66124'),('66125'),('66153'),('66155'),('66156'),('66157'),('66158'),('66160'),('66161'),('66162'),('66164'),('66165'),('66170'),('66171'),('66172'),('66173'),('67448'),('67491'),('67741'),('69309'),('69325'),('69326'),('69327'),('69328'),('69329'),('69330'),('69331'),('69332'),('72008'),('72013'),('72014'),('72016'),('72021'),('72022'),('72024'),('72025'),('72027'),('72028'),('72029'),('72030'),('72031'),('72032'),('72033'),('72035'),('72036'),('72046'),('72047'),('72049'),('72053'),('72055'),('72058'),('72059'),('72060'),('72064'),('72066'),('72075'),('72076'),('72079'),('72082'),('72095'),('72100'),('72102'),('72106'),('72108'),('72110'),('72112'),('72114'),('72120'),('72122'),('72126'),('72128'),('72130'),('72132'),('72134'),('72136'),('72138'),('72156'),('72158'),('72159'),('72312'),('72314'),('72330'),('72332'),('72336'),('72500'),('72656'),('72698'),('75006'),('75007'),('75008'),('75009'),('75018'),('75020'),('75341'),('75669'),('75670'),('75671'),('75672'),('75703'),('75705'),('75709'),('75710'),('75716'),('75717'),('75718'),('75731'),('75732'),('75781'),('75782'),('75805'),('75807'),('75808'),('75809'),('75817'),('75818'),('75819'),('75822'),('75837'),('75838'),('84082'),('84083'),('84084'),('84085'),('84086'),('84087'),('84088'),('84089'),('84090'),('94000'),('96381'),('96467'),('96933'),('97173');
ALTER TABLE _craft_merchant ADD (name VARCHAR(100) NOT NULL DEFAULT '', cost INT(11) NOT NULL DEFAULT '0');
UPDATE _craft_merchant, items SET _craft_merchant.name=items.Name, _craft_merchant.cost=items.price WHERE _craft_merchant.item=items.id;
UPDATE _craft_merchant SET cost=cost+((FLOOR(RAND() * 401) + 100));
UPDATE _craft_merchant SET cost=cost*2;

DROP TABLE IF EXISTS _item_search;
CREATE TABLE _item_search AS 
	SELECT DISTINCT 
	items.id AS search_item, 
	items.name AS search_name,
 	spells_new.name AS spell_name, 
	npc_types.name AS search_merchant, 
	zone.long_name AS search_location, 
	spells_new.classes1 AS class_warrior, 
	spells_new.classes2 AS class_cleric, 
	spells_new.classes3 AS class_paladin, 
	spells_new.classes4 AS class_ranger, 
	spells_new.classes5 AS class_shadow, 
	spells_new.classes6 AS class_druid, 
	spells_new.classes7 AS class_monk, 
	spells_new.classes8 AS class_bard, 
	spells_new.classes9 AS class_rogue, 
	spells_new.classes10 AS class_shaman, 
	spells_new.classes11 AS class_necro, 
	spells_new.classes12 AS class_wizard, 
	spells_new.classes13 AS class_mage, 
	spells_new.classes14 AS class_enchant, 
	spells_new.classes15 AS class_beast, 
	spells_new.classes16 AS class_berserk
	FROM merchantlist, npc_types, spawnentry, spawn2, zone, items LEFT JOIN spells_new ON items.scrolleffect=spells_new.id 
	WHERE items.id=merchantlist.item AND merchantlist.merchantid=npc_types.id AND npc_types.id=spawnentry.npcID AND spawnentry.spawngroupID=spawn2.spawngroupID AND spawn2.zone=zone.short_name  
	ORDER BY items.name;

ALTER TABLE _item_search ADD (search_index INT(20) AUTO_INCREMENT PRIMARY KEY);

[Element D]

Sourced that in and it went with no errors. Still no search results. (not sure how you attach pictures or i'd show what i'm seeing)

Not sure what is different if that's all there is to it. Would have been nice, but i guess we can live without it. Thanks for your help nonetheless.

[Inchronoth]

Hello,

Just want to say thanks to you for making this possible.
I'm going on a new quest with my necromacer!

I have 2 all acces accounts but I rather prefer to play this one!!!!

Thank you

[djeryv]

Originally Posted by Inchronoth

Hello,

Just want to say thanks to you for making this possible.
I'm going on a new quest with my necromacer!

I have 2 all acces accounts but I rather prefer to play this one!!!!

Thank you

Are you doing the quests from the witches? I am really happy on how those turned out. It took alot of various database queries to determine the items that dropped in zones nearby...but it took the longest to write all of the flavor text for each quest.

I can appreciate the old school quests from EQ, but they just seemed skewed to the point of "why do them". I still remember having a quest to deliver mail from Faydark to Qeynos and I was maybe level 3 or 4. I found a barbarian to SOW me and ran all of the way...the whole time wondering if something would one-hit kill me. I get to Qeynos...deliver the mail...and get a small amount of copper and a little bit of fame. It just felt like a big waste of time.

[dagulus2]

Just a follow up to say I have been testing the item search NPc for some time now. I have had no problems and I think its really useful. Thumbs up.

[loglos]

Hi. I'm using your solo package too. I started working on my own scripts and then saw a post from you. You did about 90% of what I was thinking of and some I hadn't thought of. The extra quests are great. Thanks for that. I know it's a lot of work.

I tweaked a few things of my own just for my preference in playing. But to your comment about the existing quests, I agree. So I have edited many of those to increase the rewards (plat, exp or item, depending on the quest). I am also working on some code to offer XP for everyday actions. Tailored up a glove, little bit of xp. Caught a fish, little bit of xp. Made some batwing crunchies, little bit of xp. etc. Most of that is still under construction (a lot of work and even some source changes) but I think in the long run worth it. At the end, I want someone to be able to level up doing nothing but quests and tradeskills.

Thanks for sharing your solo code. It's really good stuff.

Loglos

[GlassDeviant]

Can someone direct me to some quick instructions on how to get up to speed on this emulator, like an "EQ Emulator for Dummies", preferably using this soloing configuration?

I'd like to get a local server set up fairly quickly to muck around on before I start doing anything fancy/complicated.

[loglos]

Originally Posted by GlassDeviant

Can someone direct me to some quick instructions on how to get up to speed on this emulator, like an "EQ Emulator for Dummies", preferably using this soloing configuration?

I'd like to get a local server set up fairly quickly to muck around on before I start doing anything fancy/complicated.

https://github.com/EQEmu/Server#-windows is your starting place. That's for a windows server and right below that is linux. It is a super easy process to get up and running.

[GlassDeviant]

Thanks. Is there a particular distro the Linux version is best used with? I have a machine ready to go but it's bare metal right now so I can go with anything.

[loglos]

I'd say best is whatever you are most familiar with. I went with Ubuntu for no really good reason. I can't imagine any reason pretty much any distro wouldn't work as well as any other.

I actually put mine in a virtualbox so I can move it around as needed.

[GlassDeviant]

That makes sense, though I have this dedicated physical box that I variously use for minecraft, Empyrion and other game servers. It's only bare metal now because I upgraded my gaming rig so I had some spare parts to move to it, including much bigger HDDs. Perhaps it's the perfect time for me to go virtual on it.

Cheers,

[GlassDeviant]

Aaaand...everything is completely screwed up now.

[djeryv]

You should probably move your posts to a support part of the forum as this is just a thread about a custom set of scripts that allow someone to change the normal EQ install into something that can be played with low population and/or solo servers.

[GlassDeviant]

Yeah I was a bit tired at the time. Going to post there once I figure out where the install log is.

[GlassDeviant]

Originally Posted by djeryv

Well, I did have to make tables instead of views because views cannot have primary keys set. When I moved to the table format, and set primary keys, the queries she ran were really quick.

So the SQL would need to be ran each time you add to merchants, but there is a command to drop the table if it exists and recreate it so it is a quick matter...but you would need to remember to run it.

Here's a thought. Would it be possible to add the ability to say to her something like, "have you met any new merchants?", and have her do a live table drop and rebuild while in the server playing? With some sort of limit on how often the drop/rebuild could happen, like...no more than once per hour or only once per server restart.

Also, when I want to use HeidiSQL to access the EQ tables to mess with stuff, or add the stuff from your EQEmuSoloSettings.zip archive, do I start the EQ server first? And should I start it without the login server via t_start_server.bat, as opposed to t_start_server_with_login_server.bat?