Updated Solo Server Package - Page 3

djeryv · #1 08-29-2018, 05:50 AM

As said previously, make sure you get a server up and running first. Don't worry about my solo server package until that point. Once you have a functioning server, follow the directions in the README. You simply copy some files to a specific folder, and then load up my database changes into your everquest database (usually called PEQ). Start the server and you are off and running.

Having a server for you and a friend is a perfect use for this. It lets you play alone and lets you play one character at that. I appreciate the bot system and think it is far more useful than the mercenary system...but I feel that bots can kinda ruin the experience of playing a character to its strength.

As an example, if you use bots...you may create a cookie-cutter group. So you make a cleric character and then you make a fighter and wizard bot to go with you. Then you decide to make a wizard character and then you make a fighter and cleric bot. I found that when I played this way...I played each character pretty much the same and approached it like a a group as if I was playing Baldur's Gate.

I would prefer having the monsters adjusted and then approach areas and problems differently based on the character I made. It just lets you explore the character better when all you have with you is your skills and spells. I also think bots can kinda spoil the nicety of the pet-having classes like mages and necromancers. I make a necromancer because I want to have that skeleton following me around. It is one of the things that make that class fun to play.

Angelicus6 · #2 08-29-2018, 09:40 AM

Are all mobs soloable? So epic quests can be done solo?

djeryv · #3 08-29-2018, 11:40 AM

Quote:

Originally Posted by Angelicus6

Are all mobs soloable? So epic quests can be done solo?

There is no way to tell since the world is so massive that I would have to test this by killing everything with every character type.

My only testing was my friends and I playing it over the years, and we never ran into anything we couldn't beat. If it was yellow...it was hard. If it was white...we would probably win. If it were blue...we were pretty much sure to win. That is really all we wanted to achieve. We have characters that reached level 55-60 playing this way.

krv62 · #4 08-30-2018, 01:54 PM

Sorry if this was already brought up, I didn't read through all the posts.

The player.pl file included in this package causes ALL Doors (jail cell and Fort) to act as portals to your Home City.

The code in player.pl that is to blame:

sub EVENT_CLICKDOOR {
my $dbh = plugin::LoadMysql();

$nth = $dbh->prepare("SELECT class, race, deity FROM character_data WHERE name='$name'");
$nth->execute();
@row = $nth->fetchrow_array();
my $n_class = $row[0];
my $n_race = $row[1];
my $n_deity = $row[2];

$sth = $dbh->prepare("SELECT zone_id, x, y, z, heading FROM start_zones WHERE player_class=$n_class AND player_deity=$n_deity AND player_race=$n_race");
$sth->execute();
@row = $sth->fetchrow_array();
my $zn_id = $row[0];
my $zn_x = $row[1];
my $zn_y = $row[2];
my $zn_z = $row[3];
my $zn_head = $row[4];

$dbh->disconnect();
quest::movepc($zn_id, $zn_x, $zn_y, $zn_z, $zn_head);
}

I don't have a code fix for it, I just reverted back to my original player.pl file and all is good.

djeryv · #5 08-30-2018, 02:17 PM

This should be fixed now as I simply told the PL script to use doorid 11 to run that section (which is the cave). The main upload has been updated as well.

Anyone who already got this package, just replace your player.pl file (in the tutorialb folder) with this:

Code:

sub EVENT_ENTERZONE 
{

	quest::movepc(189,18, -147, 19.6, 0);

	if(!defined $qglobals{tutbind} && $ulevel == 1) 
	{
		quest::selfcast(2049);
		quest::setglobal("tutbind",1,1,"D30");
	}
	
	if(!defined $qglobals{tutpop}) 
	{
		quest::popup("Join the revolution!", "Welcome to the Revolt! You have been given two new quests:
			<br><br><c \"#FFFF00\">Rally with Rahtiz:</c><br>If you are ready to begin fighting for the revolt, 
			hail Guard Rahtiz and see where you are needed.<br><br><c \"#FFFF00\">Basic Training:</c><br>If you 
			would like more training on the finer points of Everquest, speak with Arias and he will direct you to other knowledgeable 
			members of the slave revolt.<br><br><c \"#F07F00\">Click 'OK' to continue.</c>");
			quest::assigntask(22);
			quest::assigntask(23);
			quest::setglobal("tutpop",1,1,"D30");
	}
	
	if($ulevel > 15 && $status < 80)
	{
		$client->Message(15,"You are too high in level to be in this zone.");

		my $dbh = plugin::LoadMysql();
	
		$nth = $dbh->prepare("SELECT class, race, deity FROM character_data WHERE name='$name'");
		$nth->execute();
		@row = $nth->fetchrow_array();
		my $n_class = $row[0];
		my $n_race = $row[1];
		my $n_deity = $row[2];
	
		$sth = $dbh->prepare("SELECT zone_id, x, y, z, heading FROM start_zones WHERE player_class=$n_class AND player_deity=$n_deity AND player_race=$n_race");
		$sth->execute();
		@row = $sth->fetchrow_array();
		my $zn_id = $row[0];
		my $zn_x = $row[1];
		my $zn_y = $row[2];
		my $zn_z = $row[3];
		my $zn_head = $row[4];
	
		$dbh->disconnect();
		quest::movepc($zn_id, $zn_x, $zn_y, $zn_z, $zn_head);
	}  
}

sub EVENT_TASK_STAGE_COMPLETE 
{
	if ($task_id == 34)
	{
		quest::ze(15, "A cheer arises from the slaves as the last of the Kobold overseers fall.");
	}
  if ($task_id == 28 && $activity_id == 1) {
    $client->Message(0,"Vahlara bows as you return. 'Just in time. Many are wounded and more arrive by the hour. If you can find any Gloomingdeep silk, bring it to me and I can reward you with more burlap clothing. It's not much, but it's nicer than the rags these kobolds left us with.'");
  }
} 

sub EVENT_CLICKDOOR {

	if( $doorid == 11 )
	{
		my $dbh = plugin::LoadMysql();
		
		$nth = $dbh->prepare("SELECT class, race, deity FROM character_data WHERE name='$name'");
		$nth->execute();
		@row = $nth->fetchrow_array();
		my $n_class = $row[0];
		my $n_race = $row[1];
		my $n_deity = $row[2];
		
		$sth = $dbh->prepare("SELECT zone_id, x, y, z, heading FROM start_zones WHERE player_class=$n_class AND player_deity=$n_deity AND player_race=$n_race");
		$sth->execute();
		@row = $sth->fetchrow_array();
		my $zn_id = $row[0];
		my $zn_x = $row[1];
		my $zn_y = $row[2];
		my $zn_z = $row[3];
		my $zn_head = $row[4];
		
		$dbh->disconnect();
		quest::movepc($zn_id, $zn_x, $zn_y, $zn_z, $zn_head);
	}
}

Element D · #6 09-03-2018, 10:05 PM

My wife and I are really enjoying the Solo Package so far and have made liberal use of the SOW Barbarian in POK. We're looking for certain items from the Prophetess, but neither of us have been able to get her to recognize our quires.

We hail her and click the item link where the explanation says to use 'M:something'. Do you need to use the /say to get it to function? Do we need to actually type it out as a question? I've tried clicking item, then /say M:*Tunic.
It just shows me saying it in the dialog window with no response.

djeryv · #7 09-04-2018, 06:57 AM

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

Element D · #8 09-04-2018, 12:21 PM

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)

Element D · #9 09-04-2018, 12:30 PM

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

djeryv · #10 09-04-2018, 01:06 PM

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?

Element D · #11 09-04-2018, 03:07 PM

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.

djeryv · #12 09-04-2018, 03:21 PM

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

Element D · #13 09-04-2018, 04:09 PM

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 · #14 09-08-2018, 10:25 PM

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 · #15 09-09-2018, 07:40 AM

Quote:

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.