Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #46  
Old 09-04-2018, 03:21 PM
djeryv
Hill Giant
 
Join Date: Apr 2008
Posts: 172
Default

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

Code:
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);
Reply With Quote
  #47  
Old 09-04-2018, 04:09 PM
Element D
Fire Beetle
 
Join Date: Aug 2018
Location: Canada
Posts: 12
Default

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.
Reply With Quote
  #48  
Old 09-08-2018, 10:25 PM
Inchronoth
Fire Beetle
 
Join Date: Aug 2018
Posts: 3
Default

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
Reply With Quote
  #49  
Old 09-09-2018, 07:40 AM
djeryv
Hill Giant
 
Join Date: Apr 2008
Posts: 172
Default

Quote:
Originally Posted by Inchronoth View Post
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.
Reply With Quote
  #50  
Old 10-04-2018, 05:52 AM
dagulus2
Hill Giant
 
Join Date: Feb 2013
Posts: 211
Default

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.
Reply With Quote
  #51  
Old 10-04-2018, 08:37 AM
loglos
Sarnak
 
Join Date: Feb 2008
Posts: 51
Default

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
Reply With Quote
  #52  
Old 10-04-2018, 12:34 PM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

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.
__________________
-GD
Reply With Quote
  #53  
Old 10-04-2018, 01:00 PM
loglos
Sarnak
 
Join Date: Feb 2008
Posts: 51
Default

Quote:
Originally Posted by GlassDeviant View Post
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.
Reply With Quote
  #54  
Old 10-05-2018, 02:32 PM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

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.
__________________
-GD
Reply With Quote
  #55  
Old 10-05-2018, 03:43 PM
loglos
Sarnak
 
Join Date: Feb 2008
Posts: 51
Default

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.
Reply With Quote
  #56  
Old 10-05-2018, 09:44 PM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

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,
__________________
-GD
Reply With Quote
  #57  
Old 10-06-2018, 05:47 PM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

Aaaand...everything is completely screwed up now.
__________________
-GD
Reply With Quote
  #58  
Old 10-06-2018, 06:45 PM
djeryv
Hill Giant
 
Join Date: Apr 2008
Posts: 172
Default

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.
Reply With Quote
  #59  
Old 10-07-2018, 09:56 AM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

Yeah I was a bit tired at the time. Going to post there once I figure out where the install log is.
__________________
-GD
Reply With Quote
  #60  
Old 10-11-2018, 02:00 AM
GlassDeviant's Avatar
GlassDeviant
Fire Beetle
 
Join Date: Oct 2018
Location: Third rock from Sol
Posts: 26
Default

Quote:
Originally Posted by djeryv View Post
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?
__________________
-GD
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:22 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3