EQEmulator Forums - Updated Solo Server Package

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- General::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=601)

- - Updated Solo Server Package (https://www.eqemulator.org/forums/showthread.php?t=42039)

Not sure what your issue may be. I attached a screenshot of me asking about a cloth cap. I never use the /say commands I just hit ENTER to either go into the chat box or click there with my mouse. Make sure you have the two extra tables added to your database as well.

LINK TO IMAGE

Hmm, I don't see an attachment picture on your post. Not sure what two extra tables you mean. I've copied the .pl files including the prophetess one the the global folder, then sourced the Solo_Server.sql with the two POK book locations removed. I did not use the craft_merchant.sql though. Is that what i'm missing?

I didn't use it because it has no data in the file for me to copy and paste the same way I did the other sql file. File size is 8bytes but notepad and Ultra Edit show nothing. (although Ultra edit does show 5 blank lines)

I do see the image now. Switched to a laptop, Phone browser didn't show it for some reason.

I updated the package to get rid of that empty file.

In your database, do you have these two tables...

_craft_merchant
_item_search

...or maybe you figured it out?

That last post was just an acknowledgment that i did see the image. That was exactly what i was doing when i tried the item search too. Something is still amiss.

I do have both of those entries in my database. They're at the bottom of the 'peq'. _item_search is 6.5MiB, and _craft_mechant is 112 KiB.

The latter seems to have only three entries. Item, name, and cost.

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);

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.

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

Quote:

Originally Posted by Inchronoth (Post 260080)

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.

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.

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

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.

Quote:

Originally Posted by GlassDeviant (Post 260316)

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.

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.

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.

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,

Aaaand...everything is completely screwed up now.

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.

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

Quote:

Originally Posted by djeryv (Post 259809)

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?

If a query cannot run super-quick, then players will notice when the server stops responding. So your idea would cause that temporary freeze as tables are dropped and rebuilt. My final solution works fine on my system so I will leave it as is.

You should have your server off before adding this package.

Ok, I wasn't sure whether that was something that could be spun off to a thread or not. These tables would only need to be dropped and rebuilt once each time a new merchant (or several) was added though, right? So just once after restarting the server post-add, it wouldn't even need an interactive command. That part was just my overactive imagination at odd, early morning hours after little sleep. :)

Edit: OK, when I go to back up my PEQ server before messing with it (i.e.: installing your solo server files, or just messing with things on my own), I am using HeidiSQL and doing "Export to SQL". Should I tick the Drop (and Create) boxes for databases and tables, so that if I need to restore after I inevitably mess up, it will drop all the tables (and the bad data) and restore it to completely pristine condition, or just the Create boxes?

To slightly digress, I backup my server every time I shut it down. I run a local VM and play single player so I only fire up the VM Linux server when I want to play and then my shutdown routine backs up the database first. So you should always make constant backups of your database.

Now, onto your question. Yes! Backup your stuff first because my queries will change things in your existing tables so you only want to run this entire package once. After you back it up, IMPORT my queries and then fire up your server. Then if you see a witch outside of the town you are in, then it loaded fine. To be more precise, see if they offer quests because that means the database was truly loaded.

Now, the queries that create the extra tables can be ran more than once because the query drops the current one and recreates them. So if you add vendors and items, you can rerun the query and get an updated list of sale items. This normally isn't an issue because most people run a server straight out of the box...meaning they aren't adding things to it because it is quite difficult and the "out of the box" setup has everything you need to play. People generally want their servers to be unique so they add custom content and such. Casual server admins don't really do this.

Now, my queries add extra vendors in the Bazaar...so you could argue that I add custom stuff. But I was quite thorough of combing the database for items before putting them on Bazaar merchants of having them be Witch rewards. It was alot of work. Trust me. I tried to avoid touching items that you can get by killing monsters, as I think those should remain exactly that...items you get from monsters.

I'm totally casual as a server admin.

Right up until I see how I could do something ... interesting.

I'll probably scan through your code a few times before I invoke it, for instance I definitely want to reinstate the PoK books as I want to recreate the feeling of being a wholly new EQ player in the time of RoF, not my experience of having to learn a game in its unfinished state (I played in beta, some time around late 97 or early 98 but that was 20 years ago) with zero documentation.

Do you know of any way to get Sunrise Hills up and running? I can't get to it on my default server.

A follow up from the problem user "Element D" had with the solo server not responding to queries. I am having a similar problem but have traced it to a failure in line "my $connect = plugin::LoadMysql();".

For whatever reason, any of the solo server scripts quietly fail (no logged errors) when it hits this line. Surrounding it with try/catch wasn't able to catch an error either. I can say, though, no lines are executed after this LoadMysql() command is hit (added debug output to validate). This affects not just searching but also "leaving" the tutorial (you get prompted that it will send you to your location and then nothing happens).

I wish I could say that I resolved this issue but I have not. I did find, perhaps, an oddity - using Akkadius "Windows server" script I found a plugins directory in both /quests/ as well as in the main server directory containing what looks like exactly the same files. I removed the plugins from /quests/ per http://wiki.eqemulator.org/p?Perl_Pl...ster_Reference line "Perl plugins are ALWAYS installed to ServerDirectory\plugins\ NOT ServerDirectory\quests\plugins\ and restarted the server but no change in behavior.

Anytime any of the new solo perl scripts its the request for the mysql connection it quietly fails and does not go past this. My setup is a new installation using Akaddius's script. Any ideas folks?

Is perl actually getting installed?

I forgot to run Akkadius' windows install script as admin, which prevented perl from installing at all, thus breaking every perl script. The second time I did it right and everything went smoothly.

The script is being ran up to the point it hits that MySQL call. You hail them, it responds, it binds, just quietly fails at that point.

Since the script is perl I would assume this means perl is running it.

I run mine on Linux. Not sure it is an issue. Just mentioning it.

Also, you can have perl installed all day long...but if you don't have the MySQL plugin installed for Perl, you won't be able to run queries. The reason you can't leave the tutorial is because it does a MySQL query to see where to put you based on your character. It is getting stuck like the other scripts in my package. I never mention this in my readme because I thought it comes default with the package...but maybe I am wrong.

So make sure the DBD::mysql - MySQL driver is installed.

Not sure if I should have created a new thread for this, but is there anything in this package that caps leveling at 70? I can command level (#level) past 70, and still gain xp, but no further leveling naturally. AA leveling is normal.

By "still gain xp" i mean it shows the xp bar increase, but when its full it just resets with no level gained.

Solo Server Package - Review

I have been playing this solo server for a while. First, I set it up on a windows 10 pc, and run it using the local login server. The setup was extremely easy. Akka really made it simple, compared to the old way, which used to take a full day to set up... copying the files from the solo_server zip file was no problem, and the sql script itself ran flawlessly. Anyway, on to the game itself...

The GOOD:
The added NPCs work nicely and are a nice addition. The additional quests are definitely welcome, as something new to work on! In zones that used to be train "traps" like blackburrow, befallen, crushbone, you can single pull and fight much easier than before. In all my hours, I have not had a single train. A few adds, yes, but no trains. The gear that you get from the new quests is pretty good for the level, compared to what you used back in the day, the first time through. All in all, this looks promising and will likely provide a bunch of hours of enjoyment.

The Bazaar merchants are a really, really nice addition, btw!

Things I question:

1. I am finding the npc's regen faster than they used to. For instance in blackburrow, they will be back up to around 70% in 12-18 seconds! Not sure if this was intentional, to me that makes it less solo useful...

2. I find the respawn delay to be more of a hindrance than a benefit. EverQuest is a grind. NPCs do not drop what you want every time. Because of this additional delay, it makes quests in the game that depend on rare drops, even more of a pain to do.

3. The shaman in pok would be much more useful if he was more "prolific", as in found in more than PoK. SoW is one of the key spells in Norrath, and with the shaman in 1 place, that puts people dependent on PoK... EDIT: just found the SoW pots in the Bazaar... Oops... ;-)

4. If you set the character to a GM, you will see that the "character_aura" table is missing, and this is with the latest Akka windows install.

Thank you for offering this solo server package! It is a welcome diversion!

1. Maybe compared to live "real" EQ, but the npc regen seems to me pretty accurate for the RoF2 expansion, which is the max client level which will work with EQEmu.

2. Respawns are pretty close to what I remember, having played since 1998 (beta) through VoA.

3. Yeah, with all the potions available the shaman is not really necessary. All of my characters run with at least a stack of every useful one (sow, mana regen, hp regen, haste, etc. as appropriate to their classes).

4. It's possible that your install hit a snag, all of the tables are fine on my solo server but I had to run the install twice to get it completely installed properly. Try running some aura buffs from the console and see if they show up in the auras window and actually work. If they don't you may need to reinstall over top of your existing server.

When you started playing EQ is irrelevant. The conversation here is specifically about this solo server mod with the current PEQ source, used in AKKA's great install scripts. The respawn rates were one of the very specific things this solo pack changed! The respawn rates are very different, especially for zones that used to be common for trains. Some of these very zones btw, are ones with rare spawns that are already a pain. This makes those even take longer with the longer respawn rates. These respawn rates are also very different than the default PEQ database.

Regarding the character_aura table, I found where that table was added back in June this year, so copied the sql and added that table. character_aura is definitely missing from the current peq source. Regarding install problems, nothing was in the log files after the install, and I installed this TWICE, once on a Debian Linux box and again on a windows 10 box. BOTH setups showed these SQL messages after the account.status was set to 250.

There is also another SQL error that shows up when you search in the bazaar. Apparently this year sometime a change was made to items.spellid was changed to items.clickeffect. There appears to be SQL still dependent on that spellid column, specifically when you perform a search in the bazaar.

You could reload all of the database tables from source (excluding character ones), and then take out any respawn change queries I have in my solo server package. Then load my solo server package and you will have the original respawn times but all of my other stuff.

That is exactly what I was looking into. I'm only about half way through the code so far, but I'll find the stuff to comment out soon, I hope... ;-)

Get rid of this part and you will be all set

Code:

-- This increases spawn rates for the quick spawning monsters

-- It allows you to clear dungeons easier



UPDATE spawn2 SET respawntime=1800 WHERE respawntime<1800;

...or reduce the time.

My server is no longer on the list after after I source the SQL

I ran the eqemu installer from akkadius and only running a local server. I can join and play the server from a fresh install but as soon as I modify the database with the solo-server.sql I can no longer see the server running in game. I followed the steps in the read me and from other post in this thread. It does appear to be up and running from what I can see on the cmd windows running. Anyone have any advice?

First I want to thank you for the scripts as this has made a fairly entertaining solo server for me and my friends so far. Curious if you developed any approaches to scaling down NPC spells? These updates work pretty well for most content but I found a few issues one you start getting into higher levels.

NPC pets were not scaled. The best approach I came up with to solve this one was to identify pets which were NPC only and a scale those. Not sure how well that will work in the long run if there are lots of NPCs using pets which are also use for PCs.

NPC spells are still full strength. Have to be real careful dealing with casters. Raid targets fall into this category as well. Any spells or procs they have do full damage still. I am not sure how best to approach this one other than going through one by one :shock:.

I also had to edit the Perl script for the Sister in PoK, who could sent you to zoned not yet done where NPC’s hit for millions...I just removed those from her list.

Having trouble finding PEQ .sql file

Hey there,

First of all, thank you so much for putting together this for everyone! I was wondering if someone could give me a hand with an issue I am experiencing.

After installing the Akka's repack, I downloaded your server files. I placed all of the .pl files in the correct location, but am having trouble figuring out where to put the main .SQL file. I placed it in the mariadb folder with the other .sql files, but this proved to do nothing.

I have tried to look on various forums and guides and haven't discovered anything in regards to overwriting sql files. Can anyone help me with this?

After doing some digging, I realized that the sql file is on a server...

However, I am still having trouble understanding how to tell my existing server to source the new sql file given by this forum. Any help?

The SQL file in this package are the statements that have to be executed once in order to update the database. You CTRL-C copy the entire file and then paste it into the Query tab in HeidiSQL and run them from there. There are a lot of details on how to do that on page 2 of this thread if you aren't familiar with Heidi. Good luck and let us know if you still have trouble.