Empty Vendors, Empty Loot, No Quests

[suprphrk]

Theeper-

Thanks for the point in the right direction. I saw it say that it loaded items from db 62256, but I didn't pay attention to what was right after it:

[Status] Loading items from database: count=62256
[Error] Starting Log: logs/eqemu_error_world_5128.log
[Error] DBLoadItems query 'select source,itemclass,name,lore,idfile,id,weight,no
rent,nodrop,size,slots,price,icon,UNK012,UNK013,benefitflag,tradeskills,cr,dr,pr
,mr,fr,astr,asta,aagi,adex,acha,aint,awis,hp,mana,ac,deity,skillmodvalue,UNK033,
skillmodtype,banedmgrace,banedmgamt,banedmgbody,magic,casttime_,reqlevel,bardtyp
e,bardvalue,light,delay,reclevel,recskill,elemdmgtype,elemdmgamt,range,damage,co
lor,classes,races,UNK054,maxcharges,itemtype,material,sellrate,UNK059,casttime,U
NK061,procrate,combateffects,shielding,stunresist,strikethrough,extradmgskill,ex
tradmgamt,spellshield,avoidance,accuracy,charmfileid,factionmod1,factionmod2,fac
tionmod3,factionmod4,factionamt1,factionamt2,factionamt3,factionamt4,charmfile,a
ugtype,augslot1type,augslot1unk,augslot2type,augslot2unk,augslot3type,augslot3un
k,augslot4type,augslot4unk,augslot5type,augslot5unk,ldontheme,ldonprice,ldonsold
,bagtype,bagslots,bagsize,bagwr,book,booktype,filename,banedmgraceamt,augrestric
t,loregroup,pendingloreflag,artifactflag,summonedflag,favor,fvnodrop,endur,dotsh
ielding,attack,regen,manaregen,enduranceregen,haste,damageshield,recastdelay,rec
asttype,guildfavor,augdistiller,UNK123,UNK124,attuneable,nopet,UNK127,pointtype,
potionbelt,potionbeltslots,stacksize,notransfer,stackable,UNK134,clickeffect,cli
cktype,clicklevel,clicklevel2,proceffect,proctype,proclevel,proclevel2,worneffec
t,worntype,wornlevel,wornlevel2,focuseffect,focustype,focuslevel,focuslevel2,scr
olleffect,scrolltype,scrolllevel,scrolllevel2,updated from items order by id', #
1064: You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use near 'range,damage,color,
classes,races,UNK054,maxcharges,itemtype,material,sellrate,UN' at line 1
[Error] If you got boat loads of errors, make sure you sourced: utils/items-0.6.
0-DR2-0.6.1-DR1-convert.sql

I don't have utils/items-06.0-DR2-0.6.1-DR1-convert.sql. I haven't searched the net for it yet, but further searching for the problem that it mentions in the error shows that "range" is a reserved word in SQL 5.1+. Will running this .sql script fix my problem if I find it? Or am I barking up the wrong tree with it?

[cavedude]

Try using MySQL 5.0. I'm not sure if 5.1 works with EQEmu or not. utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql is very old, and no longer needed.

[suprphrk]

That worked, but I'm seeing the soulbinder not binding me, and my paladin guild master just ate my note

That's stuff I can deal with if nobody has a quick fix for me. But I'm good to go now on the items!

Thanks for all of your help.

[Andrew80k]

Originally Posted by cavedude

Try using MySQL 5.0. I'm not sure if 5.1 works with EQEmu or not. utils/items-0.6.0-DR2-0.6.1-DR1-convert.sql is very old, and no longer needed.

Just FYI, CD, I use 5.1 on XP without issue.

[suprphrk]

Are you using PEQ as your db?

[trevius]

Make sure you copied the PEQ quests into your eqemu/quests folder or they won't work.

[suprphrk]

I'm banging my head on the wall with this one. I now need help with the quests. Let's use this for instance. I made a new WE Ranger, and want to talk to Maesyn Trueshot to start out his career. I hailed Maesyn Trueshot and nothing happened. He didn't say anything. After looking in the Perl script, I even said (in the exact case listed in the .pl file) "What trueshot longbows".

I look in my C:\EQEmu\quests\gfaydark folder, in the file Maesyn_Trueshot.pl, and see that it starts with this:

sub EVENT_SAY { 
 if($text=~/Hail/i){
	quest::say("Welcome to Kelethin. $name!  I am Maesyn Trueshot. commander of Faydark's Champions.  We are the finest marksmen in all of Norrath.  With our trusty [Trueshot longbows] we can miss no target regardless of the distance or the conditions.");
 }
 if($text=~/What trueshot longbows/i){
	quest::say("The Trueshot Longbow was created by my famed father. Eldin Trueshot. It is quite accurate and takes a ranger's skill to wield. We use our new recruits to [gather materials] needed by my father.  We shall soon begin to release the formula to good elves so all may fletch such a bow.");
 }
 if($text=~/I will gather materials/i && $class eq "Ranger"){
	quest::say('Take this pack. Go to Kaladim, find Trantor Everhot and ask for dwarven wire. Then go to Freeport to meet Jyle Windshot. Search the inns for him and ask him for treant wood. Then, collect some spiderling silk from spiderlings and finally, in Steamfont, we have the permission of the gnomes to use any micro servos we find while destroying rogue spiders. Combine them all and return the pack to me.');
	quest::summonitem(17367);
  } else {
	quest::say("Faydark's Champions cannot call you foe. but you have yet to earn our trust.");
  }
 if($text =~ /correct components/i) {
	quest::say('Now that I have crafted the Treant Bow Staff, you shall need one Planing Tool, one Treant Bow Staff, one Micro Servo and one spool of Dwarven Wire. These items will be used with your Fletching Kit as all other bows. Be forewarned, only a Master Fletcher can create such a bow and even a master fails from time to time. Good Luck.');
 }
 if($text =~ /next incarnation/i) {
	quest::say("The Trueshot Longbow was once enchanted by the Koada'Dal enchanters.  Once it was enchanted now it is no more.  I am sure if you were ask the Koada'Dal [where the enchanted bows] are you will get an answer.");
 }
}

So I know the Perl script is in the right place, I know Perl's installed on my machine correctly, and the Perl script appears to have no errors. When I execute the .pl file, it runs. It doesn't do anything because there's no main procedure in the file, but there's no error. My PATH includes C:\Perl\site\bin and C:\Perl\bin.

Again, searching for this was difficult; all I found were articles that proved to be too old or unrelated. Does anyone out there have any insight as to what I may be missing?

[suprphrk]

Looking through my logs, it doesn't have anything about quests or perl in the server startup. Should it?

I don't know how this works. I thought that during any SAY command, it would look in the folder for the name of the mob being hailed and execute the perl script with what was said. So as long as my script is in the right folder, everything should work.

Everything is being executed as Administrator, so I don't think that permissions are the problem either. I'm at a loss, been working with this for two days now, installing/uninstalling, etc.